I have over 20 years of experience with Access and Excel design, SQL, data integration, business process automation, repair and implementation. Skilled in Power BI, Microsoft Fabric and Azure Resources. Creating user friendly dashboards and report design as well as advanced features to increase efficiency, productivity and accuracy.
Data mapping, import/export, conversion and of course integrity are some of the many skills that I offer.
Experienced in working with a wide variety of business segments. Including insurance, medical, manufacturing, and educational institutions.
Build complex dimensional data models and reports
Develop and deploy ETL scripts to extract data from source systems and populate data marts according to predefined specifications via efficient and stable pipelines, based on best practices
Develop and maintain enterprise-grade interactive Power BI applications and dashboards to provide actionable insights
MS Access and Excel dashboards, VBA
Columbus, United States
7月, 2016 - 現在
•
8 , 6
Data Quality Analyst
8月, 2021 - 4月, 2023
•
1 , 7
Ohio Department of Liquor Control
8月, 2021 - 4月, 2023
•
1 , 7
• Developed a quality control program, resulting in a 92% decrease in invalid data being entered
• Created quality test plans for large datasets to support migration to a cloud-based platform
• Evaluated large datasets for quality and accuracy using SQL queries and determining business impact level of all found issues as well as performing root cause analysis.
• Created Data Dictionary, data mapping and technical documentation.
Columbus, United States
8月, 2021 - 4月, 2023
•
1 , 7
Data Engineer
9月, 2019 - 3月, 2020
•
6 , 1
UPS
9月, 2019 - 3月, 2020
•
6 , 1
• Analyzed, verified, and corrected payroll information for over 500,000 employees
• Created ad hoc reports and dashboards for automated reporting
• Utilized Power BI, MS Access, and QlikView to create dashboards and automated reporting
• Analyze and evaluate current reports, consolidating SSRS and Power BI efforts