Data Analyst Resume
LOG IN OR REGISTER TO CONTACT ME
This button will open the login/register page in a new tab. After logging in, come back to this page and refresh your browser.
Resume:
Professional Profile: Experienced Data/Financial analyst who has worked in manufacturing, medical devices and services organizations. Responsible for inventories in excess of $ 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 and Visual Studio .
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 CRS, 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 .
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 //-//
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
ITSCC Report Writer Region XIII Education Services Center Austin, TX /-/ Created and modified MS Access Databases and reports to run through SQL Server and SQL Server Analysis and Processing Servers using VBA coding via a Web interface.
Skills Used: Visual Basic, SQL Server
Business Operations Analyst Unisys Corporation Austin, TX /-/ Designed customized DTS Packages for Clients to show call activity and help desk performance against Service Level Agreements.
Skills Used: SQL Server , Excel
SQL Database Administrator Zimmer Orthopedics (Through Kelly Services) Austin, TX /-/ Reconfigured Access “Product Complaints Database” allowing validation to FDA Regulations, Rules and Standards. Reduced production downtime from - hours per week to - hour per month. Migrated “Product Complaints Database” to MS SQL 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 Oraclei 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 , Excel. Access, Word
Inventory Analyst* Financial/Operations Analyst* SQL Administrator Dell, Inc Round Rock, TX /-/ Reconciled Logistics Provider Inventory for High Availability Server parts provider. Inventory was $M, became $M 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 -. 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 <$, and was at >$. M years later
Skills used: Microsoft Access, Excel, Power Point, SQL Server , Hyperion, Oracle Financials, Ariba, Changepoint,
Education:
B.A. Biology, Baylor University Waco, Texas
Advanced Access. Visual Basic . Executrain Training
Project Management, Lean Basics & , Risk Management for Lean Basic FlexU (Flextronics)
