Joseph L. Petrelli

ad3gh5@r.postjobfree.com • https://www.linkedin.com/in/jpetrelli

Columbus, OH • 614-***-****

DIRECTOR OF DATA & ANALYTICS

Proven data analytics leader with 10+ years of experience developing and executing enterprise data strategies and solutions. Skilled at managing cross-functional teams to derive actionable insights from complex datasets, driving results for data-oriented initiatives across architecture, modeling, engineering, visualization, data quality, and governance. Proven ability to deliver solutions, drive innovation, optimize processes, and align data initiatives with business goals. Strong communication skills for effectively conveying insights to both technical and non-technical stakeholders. AREAS OF EXPERTISE

Data Governance

Data Architecture

Data Modeling

Data Engineering

Data Warehousing

Enterprise Data Analytics

Data Strategy

Business Intelligence and

Reporting Solutions

Data Quality Management

IT/Business Transformation

Business and Data Analysis

Program and Project

Management

Supply Chain Management

TECHNICAL PROFICIENCIES

Azure

AWS

Snowflake

Databricks

dbt

Microsoft Power BI

Tableau

Tableau Prep

Salesforce

SQL

SQL Server

M (Power Query)

DAX

ACCOMPLISHMENTS

Successfully transformed the Supply Chain data governance and analytics capabilities at Chick-fil- A, a global QSR with $19B in annual sales, leading a team of 20+ consultants to completely rebuild analytical capabilities from the ground up, incorporating best practices and modern technology capabilities across all components of platforming, architecture, modeling, data quality and governance process.

Successfully mitigated over $30M in Fair Workweek and minor law penalties for Chipotle Mexican Grill a global QSR with almost 100k employees and 3,000 restaurants by developing a robust Azure and Microsoft Power BI analytics solution which provided Payroll and Human Resources comprehensive labor and compliance visibility across the company’s nationwide staffing footprint.

Analyzed business processes, workflows, and legacy system capabilities responsible for supporting registration, permitting, monitoring, modeling, and forecasting for a state department’s water supply management. Established go-forward architecture and data conversion mapping for migration to new internally hosted solution.

Led a comprehensive assessment of systems and interfaces encompassing Salesforce, Marketing Cloud, Drupal, point-to-point integrations, and proprietary systems for LifeScan, a distinguished

$1.5B medical device manufacturer. Introduced the definition of Data Governance and Master Data Management (MDM) for implementing a Services Driven Architecture to counter data quality issues and amplify integration capabilities.

Generated $1.5M in new annual premiums by leveraging customer data to nurture lead interaction by enhancing cross-channel communication, delivering the right conversation, to the right customer, at the right time, through the right touchpoint. Joseph L. Petrelli

ad3gh5@r.postjobfree.com • https://www.linkedin.com/in/jpetrelli Columbus, OH • 614-***-****

CAREER EXPERIENCE

Senior Manager, Data and Analytics, CapTech Consulting, Columbus, OH 2021 to Present Conduct consultation with specialization in all facets of data solutions delivering, including Architecture, modeling, reporting and analysis, engineering and Governance. Partner with stakeholders across the company to expand offerings and go-to-market strategies, to harness new opportunities and sales solutioning.

Oversee Practice Area delivery excellence, business development, people management, and operations. Support recruitment and onboarding of new employees and leadership mentorship. Provide Service Offering leadership for Data Visualization and Data Governance delivery capabilities.

Office Practice Area Lead, direct team, initiatives, and resources.

Founder and coordinator of Microsoft Power BI community of Practice. Senior Consultant, AXIA Consulting, Columbus, OH 2014 – 2021 Delivered data intelligence and analytics consultation, along with offering business analysis, product management support, as well as program and project management guidance to diverse industries and clients.

Led comprehensive assessment and prioritization of critical business needs, orchestrating solution design, seamless deployment, and steering of long-term technological and managed services trajectory which resulted into a remarkable enhancement in work order coordination, along with elevated records retention to ensure asset capitalization compliance. These achievements were instrumental in optimizing operations and compliance within a substantial $1.4B per year capital improvement program.

Successfully designed and implemented data solution by spearheading development of architecture, modeling, Tableau visualization, road mapping, and governance planning for NiSource/Columbia Gas to deliver key organizational insights on hiring, retention, and development.

Directed configuration, customization, and vendor coordination for firm's Salesforce CRM. Conducted continuous efforts to align feature functionality, capabilities expansion, and boost adoption to match organizational needs.

Business Consultant and Delivery Lead, Centric Consulting, Columbus, OH 2011 – 2014 Assessed and analyzed complex organizational challenges, devising strategic solutions to enhance efficiency and drive growth. Collaborated closely with clients to identify opportunities for process optimization, cost reduction, and revenue enhancement. Developed project plans, provided data-driven insights, and guided successful implementation of recommended strategies. Fostered productive relationships with stakeholders, facilitating effective communication and change management. Orchestrated market analysis and project management to deliver impactful results, ensuring clients' business objectives are met and exceeded.

Drove functional definition and platform requirements for a new permit and licensing solution for the Ohio Division of Liquor Control. Analyzed and documented all business and system activities integral to their licensing and content management platform, which was used to regulate and administer over $38M in statewide alcohol licensing and permitting fees and activities.

Spearheaded end-to-end project implementation, orchestrating seamless delivery of solutions while ensuring alignment with strategic objectives. Collaborated cross-functionally, defined project scopes, and defined achievable goals. Employed effective communication, managed resources, timelines, and budgets, driving successful outcomes. Identified risks and implemented mitigation strategies, maintaining quality and client satisfaction. Joseph L. Petrelli

ad3gh5@r.postjobfree.com • https://www.linkedin.com/in/jpetrelli Columbus, OH • 614-***-****

Delivered impactful business analysis and management support to Nationwide Insurance, the 7th largest home and automobile insurer in the nation, with nearly $15B in Written Premiums.

Collaborated effectively within the Supply, Risk, and Finance departments to establish and synchronize business, technology, and organizational priorities, achieving seamless alignment of objectives and deliveries. Spearheading rapid enhancements to financial processes and reporting capabilities, resulting in an impressive reduction of the close cycle by over 50% and additionally, improving precision of customer segment and market analysis capabilities, optimizing strategic decision-making.

ADDITIONAL EXPERIENCE

Business Analyst, ComResource, Columbus, OH

Operations Director, Demotech, Inc., Columbus, OH

MBA Intern, The Hartford, Hartford, CT

Senior Consultant, Deloitte Consulting, Cincinnati, OH EDUCATION

Master of Business Administration

Duke University, The Fuqua School of Business, Durham, NC Bachelor of Science in Business

Miami University, Oxford, OH

KEY EXPERIENCES, INDUSTRIES, SKILLS AND CAPABILITIES Client and Professional

Duke MBA Big 5 Consulting Fortune 100 and Entrepreneurial Environments Selected Clients

Chick-fil-A, Inc. Chipotle Mexican Grill LifeScan, Inc. Williams-Sonoma IGS Energy NiSource/Columbia Gas TECO Energy Nationwide Insurance Encova (Motorist) Insurance Commonwealth of Virginia Ohio Department of Liquor Controls Industries

Consumer Retail Energy Utilities Quick Service Retail (QSR) Financial Services Title Insurance Property & Casualty Insurance State Government Functional Highlights

Business Analysis Supply Chain Program and Project Management Process Optimization Business, Functional & Technical Requirements Financial Analysis & Risk Mitigation Product Management Agile Development Software Development Life Cycle (SDLC) Delivery and Technical Highlights

Data Engineering Data Architecture Enterprise Data Modeling Business Intelligence Data Governance Master Data Management Data Analysis, Modelling and Visualizations Tableau & Tableau Prep Microsoft Power BI Data Warehouse Azure Databricks dbt SQL and SQL Server AWS Snowflake Salesforce Enterprise Content Management (ECM)

Contact this candidate