Power Bi Business Intelligence
Resume:
ANDREW MERLUZZI
***************@*****.*** Pekin, Il 61554
CAREER SUMMARY
Results driven, analytically minded and team oriented professional with six years of experience in a manufacturing environment. Experienced in data automation and business intelligence, specializing in manufacturing data. Looking to contribute extensive manufacturing knowledge and strong IT skillset and experience with data feeds, automated data reporting, and Power BI to a growth-oriented organization. CORE COMPETENCIES
Power BI Data Analysis Data Modeling SSMS Microsoft office Root Cause Analysis Project Management SQL Agile Scrum Azure Dev Ops Oracle Data Warehousing ETL Automation Report Building Dax Coding Business Intelligence WORK EXPERIENCE
Power BI Analyst Nov 2021 – May 2023
International Vitamin Corporation Remote
• Eliminated manual data capture requirements by integrating new data sources into data warehouse and Power BI dashboards.
• Nominated as keynote speaker for IT Winter Summit to present detailed overview and walkthrough of Power BI.
• Designed dashboard pages to compare plant-to-plant metrics to facilitate strategic, business intelligence-based decision-making.
• Interfaced with business users to gather new report requirements, collaborated on data analyses and troubleshooting, and created new diagnostic tools.
• Overhauled Power BI dashboards to dramatically improve “drill-through” capabilities, readability, and functionality.
• Independently audited manufacturing plant data: identifying aggregation errors, incorrect processing methods for hourly data feeds, and common-sense improvements for user interfaces.
• Implemented bug fixes, revised coding scripts, and made UI improvements to Power BI Dashboards. Process Engineer May 2018 – Nov 2021
International Vitamin Corporation Philadelphia, PA
• Expanded continuous manufacturing capabilities to compress and coat tablets from powdered raw materials
• Facilitated the integration of 1.3 billion tablets worth of new business (~25% increase).
• Increased continuous granulation and continuous blending throughput by 30% using six sigma statistical analysis.
• Performed data analysis of 2019 and 2020 production data to identify key areas of improvement and cost savings.
• Reduced packaging changeover time by implementing 5S and Kanban methodology.
• Directed plant wide effort to deploy process reliability metric, action follow up accountability boards, and departmental goals.
Process Engineer July 2017 – April 2018
Delavau L.L.C (acquired by International Vitamin Corporation) Philadelphia, PA
• Independently authored and executed the process and cleaning validation documents for two new products.
• Implemented SMED principles to optimize film coating changeover and minimize production downtime.
• Successfully qualified and validated remote operations control room.
• Supported QA by performing deviations, investigations, CAPAs, APRs and IQ/OQ/ PQs.
• Created statistical analysis template for QC data to establish EM specifications. EDUCATION
Villanova University
Bachelor of Science in Chemical Engineering
Villanova, PA
Contact this candidate