The Most Visited Job Board for Women
- Featured in the Wall Street Journal
Status: Logged Off
- Featured in the Wall Street Journal
Status: Logged Off
Search All Resumes | Submit Your Resume | Search Jobs
Karen
US-Texas-Austin
Data Analyst
To continue my career as a Metrics/Reporting Analyst
Professional Profile: Experienced Data/Financial analyst who has worked in manufacturing, medical devices and services organizations. Responsible for inventories in excess of $45 million as well as implementing processes to improve capturing and tracking revenue. Most recent experience in planning, creating, implementing and supporting application solutions for engineers in a manufacturing setting to improve visibility to problem trending, capacity overview/planning, and quality metrics using Lean processes to forecast/prevent errors.
Expert in Microsoft Excel and Access, proficient in Microsoft SQL Server, Visual Basic 2008 and Visual Studio 2008.
Expert in Cisco metrics analysis using CMRC/CPP, ECO, Redline and Process Tables.
Familiar with the use of .agen scripts for web analytics and other needs.
Supported CISCO as partner dealing with all Functional Test areas such as CRS1, MSSBU, GSR and ISBU.
Intermediate to Expert skills (depending on platform) in automation of daily, weekly, monthly and quarterly reports involving ODBC/OLE DB connectivity, excel spreadsheets, Access and SQL Databases, VBA coding, ASP.Net, and Tandem (PDM, Pervasive).
Intermediate experience with Oracle Database, Financial, Accounts Payable as well as PL/SQL querying.
Skilled in Lean Basics, Risk Analysis and Kaizen facilitation. Capable of managing projects long and short term using Lean principles, Visio (flow diagrams) and Project Manager 2003.
Skilled at interaction with user and management level utilizing presentation, persuasion and follow-up to achieve final signoff.
Created all deliverables, including a web-based GUI developed in Visual Studio.
Skilled with SAP Financials (including amortization schedules), SAP Materials and Inventory planning as well as SAP testing and capacity modules.
Experienced with Customer Satisfaction metrics measuring Time to Answer, Time to resolve, First time Fix, Elapsed Time, problem trending and Customer Satisfaction qualitative analysis.
Familiar with PHP and XML coding to construct ASP or Web page portals. Skilled with extracting data from Tandem based programs (Pervasive/PDM)
Lead on team to improve Web Portal reports created from diverse sources. Worked with data owners to simplify, standardize and produce reports which were meaningful and useful for all users. Worked with IT department to facilitate necessary changes to input criteria.
Comfortable in dynamic, fast paced environment creating Ad Hoc reports and queries against deadlines.
Job History:
Data Analyst (Most Recent) Flextronics, International Austin, TX 11/13/2006-08/28/2009
Created and Automated MS Access Databases and Excel reports run on daily, Weekly and Monthly Basis to track various issues. Lead long term Kaizen projects--Created Capacity Analysis Tool (Database and GUI interface) using Excel, MS Access, Visual Basic, Visual Studio and MSSQL Server. To improve data correlation many statistical methods used in trying to identify and mediate issues. Included writing code to replicate calculations previously done using Excel. Reporting created from MS Access and SQL Database with Input Forms for Operational tracking and reporting of known problem states on Servers.
Created, optimized and implemented quote process Prepared various Ad Hoc Reports and Data Mining Requests on the fly, against deadlines.
Skills used: Microsoft Excel, Access, Power Point and Word as well as Web development using Visual Basic, Visual Studio and SQL Server 2000
ITSCC Report Writer Region XIII Education Services Center Austin, TX 6/2006-10/2006 Created and modified MS Access Databases and reports to run through SQL Server 2000 and SQL Server 2005 Analysis and Processing Servers using VBA coding via a Web interface.
Skills Used: Visual Basic, SQL Server 2000
Business Operations Analyst Unisys Corporation Austin, TX 12/2005-6/2006 Designed customized DTS Packages for Clients to show call activity and help desk performance against Service Level Agreements.
Skills Used: SQL Server 2000, Excel
SQL Database Administrator Zimmer Orthopedics (Through Kelly Services) Austin, TX 6/2004-12/2005 Reconfigured Access “Product Complaints Database” allowing validation to FDA Regulations, Rules and Standards. Reduced production downtime from 3-4 hours per week to 0-1 hour per month. Migrated “Product Complaints Database” to MS SQL 2000 creating Project Timelines and documenting Maintenance, Backup/Recovery, Disaster Recovery Plans. Created and implemented Test Database. Created all attendant stored procedures to update tables from MS Access front end as well as protocol to validate database to FDA, Canadian and European Rules, Regulations and Standards for Electronic Records management. Facilitated movement of data to Oracle11i data warehouse at parent company out of state as Austin facility was going out of service. Validated and secured data for future FDA audits.
Skills used: Microsoft Project, Visio, SQL Server 2000, Excel. Access, Word
Inventory Analyst* Financial/Operations Analyst* SQL Administrator Dell, Inc Round Rock, TX 6/1998-10/2003 Reconciled Logistics Provider Inventory for High Availability Server parts provider. Inventory was $10M, became $45M soon after assumed position. Solved numerous system problems at provider to reconcile inventory at supplier to expected shrinkage. Team Lead of Project to refine Metrics process. Developed Access package to track Dell Partner activities and report same to Dell and various Dell Service Partner management. Metrics process shortened to 1-1.5 days, with vastly improved accuracy. Worked with various departments inside and outside of Enterprise Support Operations to streamline Dell Complaint analysis. Application Changepoint used for reporting consulting projects (tech time, expenses, scheduling, etc). Assisted in development of Financial systems for organization with revenue which began at <$100,000 and was at >$1.5 M 3 years later
Skills used: Microsoft Access, Excel, Power Point, SQL Server 2000, Hyperion, Oracle Financials, Ariba, Changepoint,
Education:
B.A. Biology, Baylor University Waco, Texas
Advanced Access. Visual Basic 6.0 Executrain Training
Project Management, Lean Basics 1 & 2, Risk Management for Lean Basic FlexU (Flextronics)
A job posting is required to contact candidates.
Click here to post a job now.
Library Application Specialist
Home Service Tech - Dev - Palos Verdes
Cox Business - Field Service Rep
Administrative Assistant to the Homeowners Association Manager
