Data Analyst Contractor Resume
Santa Clara, CA
SUMMARY
HIGHLY ANALYTICAL AND SOLUTIONS - DRIVEN ANALYST with experience in designing and implementing data systems to enhance operational effectiveness and ensure the accuracy of all critical operational data elements. A strategist with the business savvy to improve operating efficiencies through technical improvements. Proficient in establishing win-win relationships and addressing diverse customer needs by providing innovative solutions, while ensuring submerged needs are surface and met. Proven experience in formulating and implementing IT and business strategies to effectively execute key project deliverables and bolster business development.
AREAS OF EXPERTISE
- Data Auditing and Automation
- Extract, Transform, Load (ETL)
- SQL Scripting & Refinement
- SQL Server Database, SSIS, SSMS
- SAP Implementation
- Data Modeling, Normalizing & Visualization
- Analytics Development
- Statistical Computing Methods
- Data Science Research Methods
- Business Systems & Software Knowledge
TECHNICAL SKILLS
- SQL
- ETL
- Tableau
- MS SQL Server
- SSAS
- SSIS
- Windows 10 & 7
- Windows Server
- SAP
- Qlikview
- Big Data & Semi structured Data
- Excel
- Macros
- Installations
- Configuration & Testing of Hardware
PROFESSIONAL EXPERIENCE
Confidential
Data Analyst Contractor
Responsibilities:
- Successfully created and maintained SQL and PowerShell scripts for Azure cloud and local databases.
- Created a data audit system to identify and correct data integrity issues increasing data quality from 82% to 99% for key metrics.
- Developed creative dashboards in Tableau.
- Developed key metrics for the new data integrity system with the business groups.
- Solicited to create and maintain a SQL Server data warehouse tracking data integrity.
- Developed and maintained automation of Azure SQL Server databases.
- Managed the data set extraction from the Sales database to a SQL Server data scrubbing environment to the Production environment.
Confidential
Business and Data Analyst Contractor
Responsibilities:
- Leveraged experience and comprehensive knowledge in designing SQL scripts for partner compensation simulation and analytics.
- Created a data warehouse and data auditing tools for European partner compensation. Increasing data quality from 89% to 98% on key metrics.
- Worked with European stakeholders to develop realistic metrics and KPIs for partner simulation.
- Successful development and automation of SAP BOE reporting.
- Architected and built exceptional data mining algorithms for shipment vs sales from large data sources.
- Managed semi-structured and unstructured data improving order options visibility from 65% to 100%.
- Developed Qlikview dashboards and complex Excel pivot tables for the Sales NA compensation model.
Confidential, SANTA CLARA, CA
Methods Engineer / Data Analyst
Responsibilities:
- Successfully created and maintained SQL scripts for ERP/MES integration.
- Leveraged existing resources for MS SQL Server automation for improved manufacturing operations.
- Provided audit and documentation support for ISO and vendor audits.
- Engaged in the design and maintenance of SAP data interfaces and the local SFTP server.
Senior Industrial Engineer II
Responsibilities:
- Pioneered budget reporting automation and integration with other departments.
- Implemented the Learning Management Server project with web-based testing.
- Impact driving force behind the utilization of SAP key user for Production and Maintenance departments.
- Earned the privilege of taking on the role of SQL Server system admin.
- Handpicked to provide MS Access app development and integration functions.
- Professionally liaised between Production/Maintenance and IT.
Confidential, SANTA CLARA, CA
Industrial Engineer
ConfidentialEngineering Associate
