Steven Moccio
Newtown,CT
Summary
Results-driven Business Analyst with expertise in Power BI, SQL, and strategic planning. Proven ability to enhance data accessibility, optimize processes, and improve financial monitoring through innovative dashboard solutions. Strong leader in cross-departmental collaboration, project management, and media planning optimization. Skilled in analyzing data to identify trends, risks, and opportunities, driving informed decision-making and delivering impactful business solutions. Actively seeking opportunities focused on management and finance, to leverage expertise and drive organizational growth.
Overview
9
9
years of professional experience
Work History
Business Analyst
BMG360
02.2022 - Current
- Dashboard Development: Led the creation and maintenance of internal and client-facing dashboards using Power BI and Looker Studio, cutting analysis time by 4 hours weekly per analyst for a team of 20
- Database Management: Managed SQL and Snowflake databases to ensure seamless data integration into dashboards and analyses
- Quarterly Rate Analysis: Identified cost-saving opportunities in QoQ rate analyses, improving margins by 12% and reducing cost per call by 14% year-over-year across major campaigns
- Media Planning: Leveraged Nielsen TV Impression data to deliver actionable media planning insights, optimizing campaign effectiveness
- CPM Projection Tool: Developed a CPM projection feature in Power BI, streamlining campaign planning by providing targeted rate suggestions
- Creative Analysis: Analyzed offline creative performance to optimize strategies for high-spend clients, delivering weekly recommendations on creative adjustments and placements
- Financial Process Improvement: Enhanced financial monitoring systems, saving financial auditors 8 hours per week on consolidation tasks
- Reporting Enhancements: Introduced reporting improvements using Excel and PowerQuery, adding an extra hour of analysis time per analyst daily
- Process Standardization: Standardized processes in media planning and financial management through preset Excel templates and advanced data manipulation in PowerQuery
- Project Leadership: Managed cross-functional projects with tools like Visio and Figma, ensuring efficient completion and organizational efficiency
- Training & Development: Conducted training sessions with PowerPoint, Notion, and Loom, enabling teams to effectively use dashboards and interpret data insights
Information Technology Intern
YMCA Retirement Fund
05.2021 - 08.2021
- Performed query troubleshooting using SQL
- Created database diagrams using Visio and Microsoft Access
- Cleaned data by removing duplicates and incorrect entries
- Utilized Power BI to build useful and interactive visualizations for finance department, speeding up their data analysis by 1+ hour each day.
Delivery Driver
Door Dash
12.2019
Senior Delivery Lead
Franco's Restaurant
10.2018 - 10.2020
- Reconciled daily receipts
- Mapped out lead times for multiple delivery requests
Waiter
Rock Ridge Country Club
09.2015 - 08.2018
Education
Bachelor's of Science in Business Data Analytics -
University of Connecticut
12.2021
Skills
- Communication: Leadership, Project Management, Active Listening, Team Player
- Microsoft Office: Teams, Word, Excel (PowerQuery), Access, PowerPoint, Visio, PowerAutomate
- Data Visualization: PowerBI, Looker Studio, Tableau
- Database Management: SQL, Snowflake
- Other: Slack, Figma, Notion, Loom
Awards
- Named to the School of Business Student Hall of Fame
- Phi Kappa Phi Honors Society
- 2020 New England Scholar
- Accenture Scholarship for Business and Engineering Students 2020-2021
- Named to Dean's List in all semesters
Timeline
Business Analyst
BMG360
02.2022 - Current
Information Technology Intern
YMCA Retirement Fund
05.2021 - 08.2021
Delivery Driver
Door Dash
12.2019
Senior Delivery Lead
Franco's Restaurant
10.2018 - 10.2020
Waiter
Rock Ridge Country Club
09.2015 - 08.2018
Bachelor's of Science in Business Data Analytics -
University of Connecticut
Similar Profiles
Sawyer MooreSawyer Moore
Business Development Manager at BMG360Business Development Manager at BMG360
Patrick MaguirePatrick Maguire
VP of Financial Planning and Analysis at BMG360VP of Financial Planning and Analysis at BMG360
Jesse ManningJesse Manning
Video Production Manager at BMG360Video Production Manager at BMG360
Susan AsettaSusan Asetta
Global Manager, Sales Enablement at IBM CorporationGlobal Manager, Sales Enablement at IBM Corporation
Marc LasorsaMarc Lasorsa
Telecommunications Engineer at UNDCTelecommunications Engineer at UNDC