Enterprise Data Ecosystem & Financial BI Leader

David Thorp

Boston · *****.*****@*******.*** · 508-***-**** · https://www.linkedin.com/in/david-thorp-98863357 AREAS OF EXPERTISE

Functional: Retail & Supply Chain Demand Planning Promotion & Launch Benchmarking

Master Data Harmonization P&L Validation Omni-channel analytics Technical: SQL Server / SSMS Microsoft Fabric Azure Data Factory Power BI e2e

ETL / ELT Pipelines Data Modeling Power Automate DAX measures

Data Governance Data lakes REST API

Leadership: Stakeholder Management Program delivery Executive Presentations CAREER HIGHLIGHTS

Enterprise Architect: Architected and led development of an end-to-end enterprise data ecosystem spanning ETL pipelines, SQL databases, data models, governance, monitoring, and P&L tie out Project Leader: Architected enterprise financial reporting and costing frameworks integrating P&L, COGS, gross margin, period-close controls, and cross-entity ERP data. Performance Strategy: Designed and implemented a merit-based performance and promotion framework for 600+ field employees, replacing commission-based incentives with a structured annual advancement model integrating customer measures, business enablers, and KPI performance. PROFESSIONAL EXPERIENCE

Business Intelligence Manager, Interparfums, Inc. 2024-2026

Developed SQL-based enterprise financial reporting platform and global source of truth, integrating cross-entity ERP data with standardized KPI calculations, costing methodologies, financial controls, and period-close logic to improve auditability and achieve dollar-level GL-to-subledger reconciliation

Architected complex intercompany cost-attribution SQL logic for cross-entity sales, creating inventory traceability via Business Central subledger data engineering to establish end-to-end cost- flow lineage and deliver accurate COGS, reliable gross margin reporting, and stronger P&L integrity

Technical lead / project leader for enterprise ETL data ecosystem using Azure Data Factory, consolidating 400+ source tables and 9M+ daily records from ERP and REST API sources into a governed SQL data warehouse supporting 30+ countries, 300+ users, and $1B+ in annual sales.

• Led end-to-end delivery of the enterprise BI and analytics platform, managing cross- functional stakeholders, project scope, technical requirements, UAT & deployment

• Engineered and deployed a cloud-native Azure SQL database, including schema design, strategic indexing, data source mapping, and stored procedures, ensuring data integrity and optimized query execution.

• Develop customized a data governance framework (data ownership, validation rules, row- level security), multi-hierarchical user access, FreshService API workflow, Row Level- Security (RLS), accommodating intricate organizational and data privacy requirements;

• Automated workflows & solved complex data challenges across the analytics stack utilizing Power Automate, fabric dataflows, Azure, & Microsoft Fabric components, enabling automated, scalable reporting and data workflows.

• ADF pipeline integrations with graph API, app registrations/service principals, integrated with incremental refresh, for-each loops, data lakes, & REST API source.

• Led full-lifecycle development and deployment of the enterprise Power BI suite within an SDLC framework, supporting 300+ users and improving global data accessibility. Business Intelligence Manager, L’Oreal USA 2018-2023

Acted as a trusted analytics advisor to Brand, Sales, Marketing, and Demand Planning leadership, providing analytical sign-off for promotions, product launches, and omnichannel growth strategies.

Leveraged customer, category, promotion, sales, and performance analytics to assess promotion effectiveness, validate growth projections, refine forecasting assumptions, establish meaningful benchmarks, and deliver actionable recommendations that influenced investment decisions, sales targets, and commercial strategy.

Owned the analytics ecosystem supporting the Field Channel, leading development, deployment, and adoption of enterprise Power BI dashboards, KPI scorecards, and mobile reporting solutions utilized by 600+ territory managers and generating 2,000+ daily users.

Partnered with Sales Leadership and Regional Vice Presidents in establishing monthly KPI targets for a 600+ member national sales force, directly influencing commission compensation, performance expectations, and sales execution.

• Calibrated targets using historical performance, customer opportunity, brand priorities, and regional growth potential to balance revenue objectives with attainable field expectations.

Led the design of a national merit-based performance and incentive framework, partnering with Sales Leadership, Regional Vice Presidents, and HR to redefine how performance was measured and rewarded for a 600+ member sales force:

• Developed KPI methodologies, customer engagement scoring models, and weighted performance pillars by integrating ERP fact sales, Salesforce CRM activity, customer engagement, event participation, and sales performance data into a scalable performance management framework.

• Designed the model to dynamically adjust performance weighting, promotion criteria, and incentive thresholds based on evolving business objectives, adopted as the enterprise standard for performance management and sales force effectiveness. Military Officer, Captain (Retired), U.S. Army / U.S. Marine Corps 2003-2025

Federally Commissioned officer in the U.S. armed forces

20+ Years military service in U.S. Marine Corps & U.S. Army

Service in OIF 2009 (Iraq war veteran) / Secret clearance eligible Customer Insights Analyst, Reckitt Benckiser 2016-2019

Developed & renewed relationships with problem customers; restructured lead times and renegotiated an increase in min. weight per truckload, which improved cost-to-serve metrics; reduction of 14 TLs per month / 3 lanes cut & +9% On-Time performance in 2018

Designed and implemented a SQL-driven Sales Order Management analytics solution that consolidated multiple reporting structures and operational data sources into a unified interface for Customer Service and Sales Operations:

• Consolidated several reporting structures and processes into one single interface via advanced SQL and Power Query solutions (API/400).

• Revitalized daily workflows for over 30 end users in six functional areas.

• Incorporated 3PL & transportation E2E deliverables and allowed for live tracking of by truckload, parcel, and LTL.

Developed performance scorecards and KPIs tracking order fulfillment, performance against targets, and distribution efficiency, enabling leadership to improve operational decision-making.

Performed customer retention, churn, and segmentation analysis to identify growth opportunities

SAP Integration Business Process & Functional Area Expert OTC / sales order management. Supply Chain Business Analyst, Multi-Packaging Solutions 2013-2016

Coordination with cross-functional teams to implement ERP systems through process mapping, change management, and onboarding of human resources / UAT training lead for 50+end users.

Responsible for supporting and training managers and end users in Purchasing, Inventory Control, Shipping, and Receiving departments throughout 11 manufacturing sites.

Project manager for major FDA product launch, encapsulating over 300 individual sales orders spread over 4 manufacturing locations, resulting in over $160K in billing for Pfizer in 2-month span.

Developed intercompany outsource workflow to better meet the needs of the client, which reduced an average of 30 work hours per week and an annual savings of $18,300.

Improved method and timing of order entries which reduced job costing by an average of 10% and improved forecasting efficiency and purchasing prices. EDUCATION

B.A., Organization Management / Ashford University (GPA 3.99) Summa Cum Laude

Leadership Academy / USMC Quantico, VA

US Army Instructor/Trainer-certified

Contact this candidate