Sr. DATA WAREHOUSE ANALYST / MFG DATA ANALYST
Used Excel 2013, T-SQL, and MS SSMS to analyze disparate data from contract manufacturer, automated test data (ATS), and Dynamics GP (Great Plains). This analysis resulted in KPI awareness, process improvement, engineering and manufacturing changes.
- Created graphic analysis for manufacturing KPI's including: production, ship to commit, process yields, defects and design issues.
- Developed visual Pareto analysis to identify reoccurring radio design problems. From this analysis there were engineering changes and quality improvements.
- Mastered an RMA data repository in MS SQL with an Excel visuals, using three disparate data sources.
- Data Warehouse Analyst monitoring large data store of manufacturing product genealogy, QA testing results, and in the field product usage reliability.
- SME support of in-house developed Product License Tracking application.