SQL
Zachary Ioli
Cleveland,US
Work Preference
Summary
Results-driven Business Intelligence Data Analyst with a proven track record of enhancing master data accuracy, automating dashboard reports, and developing sophisticated customer matching models. Expertise in trend insights modeling and acquisition integrations complements a strong foundation in strategic analytics. Technical proficiency includes database design, maintenance, development, and comprehensive data flow analysis, facilitating informed decision-making and operational efficiency. Committed to leveraging data-driven insights to drive business growth and optimize performance.
Overview
4
4
years of professional experience
Work History
Senior Business Intelligence Data Analyst
Parker Hannifin Corp.
05.2025 - Current
- Improves master data accuracy across customer, distributor, division, and product domains using Oracle EDQ, SQL, and data profiling; resolved reporting issues, standardized data definitions, and maintained customer matching algorithms, demonstrating strong database design and information storage capabilities.
- Built automated dashboard reports in Power BI to track and report incorrect or missing customer data, administered updates to our master customer/product database, and ensured data flow integrity.
- Created multi-step customer matching model to align current customers to newly submitted customer leads and sales reported opportunities, enhancing data accuracy and utilization. Increasing customers matches by 10%
- Built and modeled trend insights for investor relations reports, highlighting market patterns, emerging market shifts, and major macroeconomic themes
- Participated in acquisition integrations for newly acquired businesses, aligned master data, and developed processes to match and standardize overlapping and new customers from the acquisitions, contributing to seamless information technology integration.
Leadership Development Associate Human Resources and Operations
Parker Hannifin Corp.
06.2023 - 05.2025
- Functioned as both a HRIS Leader and a Value Stream Manager during leadership program, applying technical expertise in systems management.
- Developed a Power BI Key Performance Indicator Dashboard to automate tracking of HR metrics, including retention, tenure, turnover, wage competitiveness, recruitment statistics and other people analytics
- Created a comprehensive financial projection model for the Transition Retention Element Plan and a strategic buyout plan, valued at a $100 million drawdown, demonstrating advanced financial modeling skills.
Human Resources/HRIS Intern
Parker Hannifin Corp.
05.2022 - 05.2023
- Created wage analysis matrix to track up-to-date market information and trends through Power BI, supporting data analysis and business intelligence.
- Navigated several projects such as General Wage Increases and training programs, contributing to operational efficiency.
Education
Bachelor's - Business Administration Economics
Allegheny College
05-2023
Skills
- VBA
- SQL
- Power BI
- Data integrity management
- Financial Modeling
- Data Analysis, Statistics
- Power Apps
- Databricks
- R studio
- DAX
- ETL development
- Advanced Excel
- Data visualization
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Software
R STUDIO
PYTHON
DAX
Timeline
Senior Business Intelligence Data Analyst
Parker Hannifin Corp.
05.2025 - Current
Leadership Development Associate Human Resources and Operations
Parker Hannifin Corp.
06.2023 - 05.2025
Human Resources/HRIS Intern
Parker Hannifin Corp.
05.2022 - 05.2023
Bachelor's - Business Administration Economics
Allegheny College