Savita Yadav

Savita Yadav

Data Analyst
United States of America

About Me

Highly skilled Data Analyst with 2.7 years of experience using data-driven tools to derive meaningful insight and increase analytic efficiency. Experienced Software developer with 5+ years of experience, skilled at coord…

Experience

Data Reporting Analyst

OPTUM / Excel MSO
May 2022 - Present · 4 years 1 month

I have 2.7 years of experience as a Data Analyst. In my former job, I worked with several departments to create reports for teams, physicians, and practitioners. I have analyzed data to assist in delivering optimal healthcare management and decision-making. I Developed SQL queries using joins, stored procedures, common table expressions (CTEs), and temporary tables to support Power BI and SSRS reports. I created complex calculated measures using Power BI data analysis expression language (DAX).

Data and Reporting Analyst

Excel MSO / OPTUM (Client - KOVA, PMGSJ), San Jose, CA
Jun 2022 - Jul 2023 · 1 year 1 month

Developed SQL queries using joins, stored procedures, common table expressions (CTEs), and temporary tables to support Power BI and SSRS reports.
Developed complex calculated measures using data analysis expression language (DAX) in Power BI.
Performed extraction, transformation, and loading (ETL) processes by pulling large volumes of data from various sources using SSIS.
Designed, created, and maintained reports in SSRS.
Generated drill down, ad-hoc, parameterized, and matrix reports using SSRS.
Created reports using MS Excel (Vlookup, Hlookups, Pivot table, Macro, Data points).
Automated weekly and monthly reports to be posted in shared or SFTP locations through Active batch jobs.
Involved in testing, bug fixing, and documenting the project's work at every phase.

Data Analyst, Graduate Research Assistant

Cal State University, Los Angeles, CA
Jan 2021 - May 2022 · 1 year 4 months

Worked under Prof. Jongwook Woo as a graduate research assistant.
Researched scalable big data predictive analysis for Airbnb price and rating prediction using Azure ML, Spark cluster using PySpark, Spark ML on Databricks Enterprise Edition.

Software Associate

Vara United (Client - ICICI Bank), Mumbai, India
Aug 2016 - Sep 2017 · 1 year 1 month

Used expertise in Software Development Life Cycle (SDLC) and Java technologies to create web applications that meet client requirements.

Software Associate

3I Infotech (Client - ICICI Bank), Mumbai, India
Apr 2016 - Aug 2016 · 4 months

Designed and coded application components in an Agile/TDD environment utilizing test-driven development and pair-programming.

Jr. Programmer

Base Information Pvt. Ltd., Mumbai, India
Sep 2014 - Mar 2016 · 1 year 6 months

Effectively coded software changes and alterations based on specific design specifications.

Skills

SQL Database Business Communication Coding Staff Development Meetings Management Presentations SQL Server Reporting Services (SSRS) Power BI Tableau MS SQL Server 2012 SSIS Excel IBM SPSS T-SQL Python Hadoop MapReduce Hive Spark HDFS Pig MS Access MS Excel SSRS R Studio Databricks Azure Machine Learning Studio ArcGIS Desktop Eclipse DAX SQL Stored Procedures CTEs Temporary Tables Vlookup Hlookup Pivot Table Macros SDLC Java Agile TDD PySpark Spark ML
Report this Profile?