Built with datascienceportfol.io

Pratiti Soumya

Data Analyst

Based in Los Angeles

About

I’m a business intelligence and analytics professional with 7+ years of experience turning complex data and business requirements into reporting and analytics solutions that help teams make better decisions. I hold an MS in Business Analytics from UCLA Anderson and an MBA, and have worked across industries including utilities, entertainment, healthcare, technology, and real estate. My experience includes business intelligence, requirements gathering, data validation, reporting automation, dashboard development, and translating business needs into technical solutions. I work primarily with SQL, Power BI, Tableau, Snowflake, Excel, and Python, and enjoy working at the intersection of data, systems, and business teams.

Skills

Projects

Experience

2024-2025

Analyst at Southern California Edison

• Built SQL-driven data integration workflows for vegetation management KPIs, standardizing operational data into Power BI datasets; reduced manual reporting time by 40% • Improved data accuracy to 70% through SQL validation checks, KPI logic, and reconciliation across SSRS, Excel, Power BI • Translated operations and compliance requirements into reporting-layer models, standardized metric definitions, monitored reliability, and resolved source-to-report discrepancies

2022-2024

Data Analyst at Endeavor

• Led financial performance reporting initiatives supporting finance leadership, delivering SQL-driven insights across revenue KPIs • Designed 75+ recurring Power BI/SSRS reports supported by reusable SQL logic, refresh automation, and consistent KPI definitions, reducing reporting cycle time by 65%+ • Standardized financial reporting data across systems, resolving KPI discrepancies and improving reporting consistency

2021-2021

Customer Success Analytics MBA Intern INTUIT, INC., San Diego, California

• Developed a Tableau dashboard analyzing 13.6M data points across 16 KPIs and created a live index with performance tracking. • Standardized KPI definitions for 25+ products and 10+ markets improving alignment across global analytics teams.

2018-2020

Digital Marketing and Strategy Executive GENERAL TECHNOLOGIES, Mumbai, India

Leveraged SQL, Google Data Studio, Google Analytics to implement campaigns increasing new user registrations by 200%. • Designed SQL queries and dashboards to track marketing ROI, CTR, and conversion funnel metrics.

2014-2015

Data Architect FORD MOTOR COMPANY, Chennai, India

Developed and maintained conceptual, logical, and physical data models, enhancing data structure across 3 databases. • Designed enterprise architecture diagrams in SAP Power Designer, aligning data flows with business objectives.

Education

2020-2021

Master of Science in Business Analytics, UCLA Anderson School of Management

Focused on applying analytics in business settings, enhancing decision-making and strategy development. Specialized in Customer Analytics, Competitive Analytics, and Descriptive Predictive and Prescriptive Analytics. Leadership roles: Vice President of Career, MSBA; Vice President of Marketing, Business Analytics Association; Director of Technology, Entrepreneur Association.

2015-2017

Master of Business Administration (MBA) at Narsee Monjee Institute of Management Studies, Mumbai, India

Specialized in Statistical Analysis, Finance, Decision Modelling, Innovation Management, and Econometrics. Leadership roles: Editorial Head, significantly boosted digital subscription by 63% through strategic content and digital marketing.

2010-2014

Bachelor of Engineering, Electronics and Computer Science at MS Ramaiah Institute of Technology

Developed a strong foundation in technical principles, complementing later achievements in data analytics and business strategy.