Customer, Product, and Business Analytics
Experience turning stakeholder needs into metrics, dashboards, reporting infrastructure, and decision narratives.
Resume
Mark de la Cruz
Senior analytics professional with 7 years of experience turning complex utility, litigation, and operational datasets into trusted data pipelines, self-service dashboards, statistical analysis, and leadership-ready decision support.
Data science context
A career built on practical data science in real operating environments.
Mark's resume shows the profile many senior analytics teams look for: strong SQL and Python-based data transformation, dashboard ownership, data quality judgment, and the ability to translate ambiguous business questions into measurable reporting products.
He has built ETL and data processing workflows since his first analyst role at Resolution Economics, where Python and SQL pipelines supported high-stakes economic consulting and litigation modeling. At Southern California Edison, that foundation evolved into utility risk analytics across SAP, Citrix, Dataverse, Power BI, and Power Apps.
A throughline across the resume is translating technical work into non-technical environments: field operations, contractors, executives, regulatory compliance, legal teams, and business stakeholders who need clear answers from messy data rather than just another report.
Target alignment
Relevant to the roles I am pursuing
Research and Measurement
Regression, summary statistics, observational studies, quantitative evidence, and executive-facing interpretation.
Analytics Engineering
SQL/Python transformations, ETL, data quality checks, data modeling, documentation, and automated reporting workflows.
Operational Data Science
Applied analytics in environments where source systems, field processes, compliance requirements, and users are messy.
Evidence
Data science strengths
Pipeline and ETL foundation
Engineered ETL pipelines using Python and SQL at Resolution Economics, maintaining data integrity for enterprise-scale relational datasets and analytical model builds.
Operational data products
Designed Power App, Dataverse, and Power BI systems that processed over 1,000 contractor scorecards and 18,000 field evaluation inputs for infrastructure work.
Risk analytics and prioritization
Built SQL, Python, DAX, and dashboard workflows to analyze equipment failures, exception concentrations, repair delays, and wildfire mitigation priorities.
Non-technical translation
Communicated analytical outputs and risk metrics through plain-language presentations for Vice President-level reviews, regulatory compliance, field teams, and managers.
Experience
Professional timeline
Senior Data Analyst, Substation Project Management
Southern California Edison - Program Management, T&D
- Designed and deployed a Power App and Dataverse database for contractor performance scorecards and field evaluation data.
- Built scalable Power BI dashboards with DAX and data modeling to improve reporting quality, stakeholder self-service, and metric consistency.
- Governed enterprise tracking tools for substation infrastructure upgrades, cost analytics, risk analytics, data quality, and CPUC compliance reporting.
Senior Data Analyst, Data Management Oversight
Southern California Edison - Compliance & Remediations, T&D
- Developed SQL and Python scripts to extract, clean, transform, and analyze equipment failure data and repair-delay exceptions across SAP and Citrix.
- Built automated Power BI dashboards that helped raise a core utility compliance rate from 92% to 98%.
- Created KPI tools aligned with wildfire mitigation priorities and translated results into VP-level performance narratives for non-technical leaders.
Analyst, Valencia DCH
Southern California Edison - Technical Planning, T&D
- Analyzed substation, transformer, and distribution circuit datasets for recurring asset health and risk reports.
- Extracted and compiled Citrix and Power BI datasets for ad-hoc operational reports, business questions, and tactical planning schedules.
- Implemented an online purchase-order database that streamlined processing workflows for field contractor material delivery.
Analyst, Wage & Hour Litigation Consulting
Resolution Economics, LLC
- Engineered ETL pipelines using Python and SQL for high-stakes quantitative economic consulting projects.
- Applied regression analysis and summary statistics to client data trends for federal and state court proceedings.
- Led 20+ data interns on cleaning, structuring, and transformation protocols for analytical model builds.
Toolkit
Skills and domains
Risk and Assets
Infrastructure asset risk, wildfire mitigation context, substations, distribution systems, equipment failures.
Programming
SQL, Python, SAS, DAX, Java, C++, VBA, automation, data processing.
Platforms
Power BI, Power Apps, Dataverse, SAP, Citrix, Snowflake, BigQuery, Tableau, Looker, Palantir Foundry exposure.
Modeling
Linear regression, decision trees, time series, hypothesis framing, summary statistics, executive analytics storytelling.
Education
University of Southern California
Bachelor of Arts, Economics. Graduated 2018. Los Angeles, CA.