Saumya Arora Email and Phone Number
California, United States
Saumya Arora's Location
San Francisco Bay Area, United States, United States
Saumya Arora's Contact Details
Saumya Arora work email
- Valid
- Valid
- Valid
- Valid
- Valid
Saumya Arora personal email
n/a
About Saumya Arora
Efficient data analyst with experience working with large datasets in generating and analyzing data reports for management, developing database procedures for enterprise environment with expertise in ETL of data on multiple platforms. Surpassed monthly progress goals consistently through prioritizing tasks and through efficiency adjustments. Looking for job change in roles such as- Data Analyst, Business Analyst, Business Data Analyst, Business Technology Analyst, Business Operations Analyst, Healthcare Data Analyst, Healthcare Business Analyst, Data Engineer etc.
Saumya Arora's Current Company Details
Saumya Arora Work Experience Details
-
Senior Data AnalystNorth East Medical ServicesCalifornia, United States
-
Senior It Data AnalystBlue Shield Of California Oct 2023 - PresentOakland, California, Us• Implemented data migration strategy to extrapolate Pharmacy Claims data from Netezza to Snowflake cloud platform migration for Pharmacy ClaimsReimagine Initiative, sourced from CVS to Abarca, Navitus, Amazon Home Delivery and Prime Rebates, resulting in 50% reduction in data retrievaltime and improved data accessibility for the organization.• Supported the Enterprise Data Governance Team in implementing data governance best-practices and Data quality checks using Collibra tool, resultingin improved data reliability and integrity.• Monitored backend ETL data pipelines processes using Informatica PowerCenter 2.0 and DBT for data extraction, manipulation and retrieval.• Collaborated with cross-functional teams implementing Data Vault 2.0 methodology in Snowflake data migration and transformation projects.• Optimized SQL queries and applied performance tuning methodologies in Snowflake using SnowSQL and procedures, improving overall queryperformance by 30% and reducing query processing cost by 20% leading to better data analysis. -
Senior Data AnalystNorth East Medical Services May 2022 - Sep 2022San Francisco, Ca, Us• Implemented a robust Power BI dashboard that aggregates encounter intake data across multiple healthcare categories and performs in-depth analysis of healthcare provider performance.• Led the Tuberculosis Infection project in collaboration with external stakeholders, including the University of California San Francisco team and CDC, to provide a comprehensive analysis of TB population data, leading to a profit of $6 million.• Effectively managed the Performance Improvement Plan (PIP) project in collaboration with multiple Health Plans, including HPSM and Stanford Health, ensuring the comprehensive assessment of their performance across diverse California HEDIS Measures that contributed to an overall team profit of approximately $4 million.• Efficiently migrated healthcare dataset sources from SSRS to Power BI, encompassing a wide range of internal and external reports including clinical research trials, clinical outcomes, financial analysis, operational metrics, and population health assessments.• Collaborated with a team of four analysts to address diverse ad-hoc requests pertaining to encounter data analysis and utilized expertise in healthcare systems, including CL&7, LOINC, NPC, CPT, and ICD-10 codes, to extract, manipulate, and analyze data for insightful information and actionable recommendations using MS SQL.• Participated in a data migration project involving the transition of healthcare information from the NextGen system to the EPIC database.
-
Data AnalystCvs Health (Swoon Llc) Sep 2021 - Jan 2022• Worked with 90-day program team, resolving data enrollment issues and improving medical prescription strategies on a daily basis.• Collaborated with analytical project managers to support user acceptance testing and pre-prod release testing of various 90-Day Outreach Programs.• Conduct regular reviews of reporting request volume to identify low/ high volume of script to analyze Script Impact performance.• Create/ Run and maintain inventory of all reports requiring regular updates and coordinate with SMEs to develop plan for ongoing maintenance activities.• Handle data requests/tickets to support the research of end users in answering analytical questions to identify reporting issues.
-
Data AnalystNys Department Of Health (Sso Llc) Jul 2019 - Sep 2021• Working on the Risk adjustment and Analysis project of different PPS and DISRIP Success Calculator for the Fiscal end• Handling the analysis and data visualization of Value-Based Payment Systems – updating the New York State Road Map for Medicaid Payment Reforms by adding the alignment between DSRIP Goals and VBP Development, giving a better comparison of the two programs.•Helped in developing and executing weekly and monthly analytical recurring reports like- Pharmacy, Transportation, Enrollment data, Herkimer’s, Hydroxychloroquine, etc.•Enhanced the process of viewing reports in an effective manner by the creation of real-time dashboard in Tableau to analyze the total Medicaid budget for different provider services resulting in better decision management for the business.•Helped in the building and updating the database for MAS transportation daily files by developing queries in Shell Scripting to ease out the process of cleaning and transferring the raw data files from Excel/Notepad to a systematic one in Master Data Warehouse (MDW).•Conducted testing for multiple aspects of the analytical healthcare system such as SOAP (Simple Object Access Protocol), VBP Dashboards, DAP Analysis, Member_360 pipeline data (using Python and R), and various database elements of the system including Salient Interactive Miner data.•Worked on developing multiple VBP Business Use Cases on various data parts of Value-based payment which includes- member profile data, TCC data, demographics data, and all Categories of Services.•Worked on HL7 (Health Level-7), gathering pertinent data, identifying and evaluating options, HER Systems, CDA (Clinical Document Architecture), and XML (Extensive Markup Language) file-based analysis.
-
Analyst (Graduate Research Assistant)Nys Office Of Mental Health Jan 2018 - Dec 2018•Worked on Statewide Planning & Research Cooperative System (SPARCS) project, a data reporting system between the healthcare industry and government, implementing and testing cross-project SAS programs along with standardizing incoming and pre-existing datasets.•Also worked on the Criminal Records data set for finding patterns and observing the basic mental functionalities of a criminal. The project resulted in a better analysis of feasible documents provided by the Department of Criminal Justice and creating macro functions in SAS for the same.•Developed code as per the design to load the interface data into the department warehouse using SQL database creation and SAS Manipulation functions. This resulted in the maintaining of management level of information for the definition of new strategies and attainment of improvement and getting a better statistical view of it.• Worked on match evaluation, controlling the data quality by checking under-merge and over-merge records for MDM-based HCP data analyzing match quality, performing data quality checks on data from various healthcare sources/networks.• Conducted research by utilizing internal databases and performing web searches to validate the properties of a record and extracted match scores for various attributes (address, name, NPI ID, etc.) using fuzzy matching.• Engaged with stakeholders across the organization to understand processes that generate, transform and distribute data and recommended optimized solutions to resolve issues in data policies, definitions, quality, and metrics.• Monitoring data quality process, identifying quality issue patterns, implementation of data controls, and managing data quality check strategies.• Worked with business users to ensure Data Quality KPIs are in line with the business objective and quality control and used SQL to extract various attributes match scores (name and address match scores).
Saumya Arora Skills
Java
C++
C
Sql
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Html
Cascading Style Sheets
Content Development
Network Security
Javascript
Cyber Security
Data Analysis
Hibernate
Database Administration
Data Structures
Oracle Database
R
Spss
Java Database Connectivity
Python
Jquery
Angularjs
Apache
Tomcat
Hadoop
Bootstrap
Github
Spring Framework
Postgresql
Junit
Eclipse
.net Framework
Tableau
Teradata Sql
Open Database Connectivity
Wireshark
Acunetix
Toad 9.0
Jmeter
Birpsuite
Unix Administration
Leadership
Microsoft Office
Windows
Android Sdk
Social Media Marketing
Marketing
Saumya Arora Education Details
-
University At AlbanyComputer Science -
Indra Prastha UniversityInformation Technology
Frequently Asked Questions about Saumya Arora
What company does Saumya Arora work for?
Saumya Arora works for North East Medical Services
What is Saumya Arora's role at the current company?
Saumya Arora's current role is Senior Data Analyst.
What is Saumya Arora's email address?
Saumya Arora's email address is sa****@****lth.com
What schools did Saumya Arora attend?
Saumya Arora attended University At Albany, Indra Prastha University.
What are some of Saumya Arora's interests?
Saumya Arora has interest in Travelling, Content Writing, Singing ( Trained Classical Singer ), Reading.
What skills is Saumya Arora known for?
Saumya Arora has skills like Java, C++, C, Sql, Microsoft Excel, Microsoft Word, Microsoft Powerpoint, Html, Cascading Style Sheets, Content Development, Network Security, Javascript.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial