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.