Business Analyst Project Management

Shefalika Upadhyay

Irvine, CA 669-***-**** **********.**@*****.*** www.linkedin.com/in/shefalika-upadhyay SUMMARY

7+ years of experience in data analytics, business strategy, and stakeholder collaboration. Proficient in project management, corporate training and translating complex data into actionable insights for delivery data-driven solutions. WORK EXPERIENCE

Business Data Analyst-FP&A Mar 2024-Present

Netflix, Los Angeles, CA

• Consolidate and restructure 100+ FP&A reports in Google Sheets for data migration to in-house data warehouse infrastructure, analyze and extract business logic from existing reports ensuring accuracy in data representation.

• Validate and compare financial data for precise data reconciliation across old and new reports by implementing audits in Google Sheets and working with partners to fix or resolve data inaccuracies to maintain the highest quality dataset. Sr. Analyst- Data and Strategy Aug 2023-Feb 2024

GEICO, San Diego, CA

• Led the migration of legal compliance and Finance data from external Database Management System to Excel, by extracting survey data with SQL, creating custom Workday reports, and validated data accuracy in Python.

• Analysed reports and dashboards prepared from existing databases and implemented the existing business logic to new database, created interactive Power BI dashboard with improved real-time insights on workforce metrics.

• Developed Data Validation and Governance Handbook for the new database management, implementing data governance rules to ensure integrity and compliance of data collection and reporting across projects. Data Analyst-Graduate Assistant Sep 2022-May 2023

Texas State University (Career Services), San Marcos, TX

• Enhanced user engagement in social media accounts, achieving increase in followers by 85% and user interactions by 28%, by utilizing social listening and analyzing social media insights to create data-driven marketing content.

• Conducted post-graduation outcome surveys using Qualtrics, analyzed survey data with Python and compared it with historical data to identify career trends, refine employers' list, and document industry insights for career guide. Sr. Business Analyst Apr 2021-Nov 2021

Green Global Aggrovation, Vadodara, India

• Accomplished end-to-end product development of automated farming pods and B2C mobile application in 6 months.

• Reduced 25% production cost by improving usability and functionality, based on feedback from farmers and vendors.

• Collaborated with cross-functional teams to identify product requirements, system requirements, and dependencies. Monitored KRAs and KPIs to ensure alignment with product roadmap and presented monthly progress to investors. Co-Founder Jun 2020-Mar 2021

ITSFAQ, Pune, India

• Launched a non-profit online platform dedicated to personal development, health, and lifestyle, achieving 100 weekly visitors, 60+ published articles, and 1.1 million visits in 6 months using AWS, WordPress, and Elementor.

• Improved website engagement, boosting click-through rates by 15% and time spent on the website by 25%, using Google Analytics data and A/B testing to measure the effectiveness of marketing campaigns and optimize content. Business Data Analyst II Mar 2018-May 2020

Entrata Inc, Pune, India

• Managed a portfolio of 40 high-impact trainings per quarter from inception to completion and delivered to over 2500 employees which increased annual employee productivity by 13% & employee retention by 33%.

• Analyzed workforce data across 6 business units to identify training gaps, workload distribution, performance metrics, and evaluate program ROI. Designed and validated Excel and Tableau dashboards to visualize insights and KPIs.

• Increased 15% employee productivity by revamping OJT policy for 2000+ employees, by aligning employee and leadership expectations, automating performance metrics reporting, and streamlining post-survey actions. Data Analyst Jun 2016-Apr 2017

Indian Institute of Management, Ahmedabad, India

• Executed customized workshops for corporate clients to resolve their organizational and leadership challenges by analyzing client data, designing and delivering tailored case studies and interactive training materials.

• Curated course material for graduate courses, facilitated MBA seminars on high-performing teams, talent management, and team dynamics including content delivery, managing logistics, and collecting feedback.

• Created and maintained research database adhering to data collection and integrity regulations, presented reports summarizing research data and findings, and generated reusable R codes for manuscript figures and tables. Junior Analyst Apr 2015-May 2016

IOT Anwesha Engineering and Construction Ltd, Vadodara, India

• Streamlined employee onboarding and offboarding by automating data entry and dashboard creation using Excel Macros, thus reducing onboarding time by 50% and administrative burden by 30%.

• Overhauled appraisal process for 1200+ on-site employees by extracting, transforming, and loading data from multiple project sites to central HRIS database, enforcing data governance and introducing new performance metrics.

• Managed and analysed HRIS data (recruitment, headcount, compensation, and performance) to identify trends, align HR initiatives with business goals, and provide monthly reports with actionable insights and recommendations. PROJECTS

Prediction Model of Energy Consumption for McCoy College of Business May 2022-Aug 2022

• Analysed daily time series data of electricity consumption and ambient temperature, using Python to identify trends in energy consumption and develop predictive models by implementing ARIMA, Neural Networks, and LSTM models.

• Created a data warehouse based on Star Schema layout, using SQL to store raw data and model predictions.

• Developed real-time dashboard on GCP to visualize forecasts, resulting in 60% accurate resource allocation. EDUCATION

Master of Science in Data Analytics and Information Systems Jan 2022-May 2023 Texas State University, San Marcos, TX

Master of Business Administration Aug 2013-Apr 2015 Unitedworld School of Business, Ahmedabad, India

Bachelor of Commerce in Accounting and Financial Management Aug 2010-Apr 2013 Maharaja Sayajirao University, Vadodara, India

SKILLS

• Creative Thinking

• Effective Communication

• Project Management

• Agile Management

• Statistical Analysis

• Data Warehouse

• Data Modeling

• Data Visualization

• Forecasting

• Data Governance

• MS Excel

• Stakeholder Collaboration

• Python, R

• SQL

• Workday

• Power BI

Contact this candidate