Welcome to my GitHub profile! I am a passionate data analyst with over 7 years of experience in transforming complex data into actionable insights. My expertise lies in using various data analysis and visualization tools to help organizations make informed strategic decisions.

With an MS in Business Analytics from UCLA Anderson, ranked globally #1 in this field, I have honed my skills in Tableau, SQL, Python, Power BI, Power Query, SSRS/DAX, and Excel reporting. I specialize in conducting root cause analysis, developing clear visualizations, and thorough analyses to support strategic business decisions.

Data Analyst
ENDEAVOR (WME), Beverly Hills, CA
January 2022 – March 2024

• Led the development of a financial reporting suite, incorporating over 75 reports and dashboards across Power BI, MS Report Builder, and Excel, which reduced redundancy by 65% and significantly enhanced usability and stakeholder satisfaction.
• Utilized SQL for data extraction and transformation, and designed and maintained data warehouses to ensure reliable reporting.
• Successfully migrated over 700,000 data points and conducted SQL-based QA testing, achieving more than 95% accuracy.
• Collaborated with Engineering, Product, and Design teams to enhance the BI data ecosystem through strategic migration phases.
• Simplified the creation of new Power BI reports by designing 20 documentation and BI report management guides.
• Provided technology consulting to define BI reporting requirements with business stakeholders, enhancing decision-making and promoting consistency across departments.
• Enhanced user experience by collaborating with product designers to tailor report designs to specific user needs.
• Established big data workflows that significantly improved data accessibility and user adoption across departments.
• Ensured high data reliability by conducting daily quality assurance and resolving discrepancies.
• Trained over 45 finance and accounting team members on leveraging BI DataMart reports for enhanced data analysis.

Customer Success Analytics MBA Intern
INTUIT, INC., San Diego, California
June 2021 - September 2021

• Developed a Tableau dashboard analyzing 13.6 million data points across 16 Customer Success KPIs, providing critical insights on statistical ranges, variances, and business implications to leadership.
• Spearheaded the creation of a Live Index to Prior Year Tracker, aligning FY 2022 goals with BU performances.
• Standardized definitions, purposes, and calculations for all 16 KPIs in collaboration with stakeholders, ensuring uniformity in performance tracking across 25+ products and 10+ markets, enhancing strategic decision making.

Graduate Student Researcher
UCLA HEALTH, BIODESIGN HUB FOR MEDTECH AND DIGITAL HEALTH, Los Angeles, California
January 2021 - December 2021

• Analyzed over 4 MM data points in SQL and Python to measure the impact of funding received by small businesses on medical innovation and translating them to insights facilitating strategic decisions in medical innovation funding.
• Designed and launched 9 Tableau dashboards at the UCLA Biodesign Hub, visualizing critical data for stakeholders.

Digital Marketing and Strategy Executive
GENERAL TECHNOLOGIES, Mumbai, India
April 2018 - June 2020

• Leveraged analytics tools such as SQL, Google Data Studio, and Google Analytics to identify growth opportunities, designing and implementing campaigns that boosted sales revenue by 22.7%.
• Developed a 2-year digital transformation roadmap, driven by data-backed market demand analysis, to guide service capability expansions, spearheaded digital marketing strategies, increasing new user registrations by 200%.

Assistant Vice President, Digital Products
CHOICE INTERNATIONAL, Mumbai, India
May 2017 - March 2018

• Led the launch of the 'Investica' mutual fund app in the APAC region, achieving over 10,000 downloads through strategic market segmentation, sprint planning, and execution.

Data Architect
FORD MOTOR COMPANY, Chennai, India
July 2014 - May 2015

• Optimized data management for three major databases, enhancing efficiency by 34% through strategic SQL modeling in collaboration with business and project teams.
• Led agile development of data source mappings, interfaces, and analytics, utilizing SAP Power Designer 16.
• Awarded Functional Excellence in Data Architecture and won Ford's national Technology Trends Quiz in 2015.

Master of Science in Business Analytics (MSBA)
UCLA Anderson School of Management, Los Angeles, California
December 2021

• 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.

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

• 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.

Bachelor of Engineering, Electronics and Communication
M S Ramaiah Institute of Technology, Bangalore, India
May 2014

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

• Data Analysis & Visualization: Jupyter, Excel, Tableau, Power BI, SSRS
• Programming & Query Languages: SQL, DAX, PowerQuery, R, Python
• Digital Analytics: Google Analytics, Mixpanel, Adobe Analytics
• Certifications: KPMG Certified Lean Six Sigma Green Belt, Harvard Business School Online Business Analytics

• Tableau Public Profile: Pratiti Soumya Tableau
• LinkedIn Profile: Pratiti Soumya LinkedIn
• YouTube Channel: Analytics About YouTube

Feel free to reach out to me via LinkedIn or check out my work on Tableau Public and YouTube!

Pratiti Soumya