Senior Data Analyst Resume
2.00/5 (Submit Your Rating)
Piscataway, NJ
SUMMARY
- Process - oriented Data Analyst with 5+ years of experience in business analysis, design, implementation, and testing of data using SAS, SQL databases.
- Experience with data preparation, classification, statistics and machine learning concepts.
- Responsible for generating complex Business Intelligence Reports and dashboards using Tableau and SAS Visual Analytics.
PROFESSIONAL EXPERIENCE
Confidential, Piscataway, NJ
Senior Data Analyst
Responsibilities:
- Created new SAS programs using PROC SQL and data steps to create flat files from the NPM and FACETS databases.
- Modified existing programs to run them on SAS Grid to increase the productivity of batch jobs.
- Worked on Ad hoc intakes to modify the existing queries to align with the current Provider operations business.
- Scheduled the batch processes using Windows scheduler to run for the daily extracts and to create reports.
Confidential, Quincy, MA
Data Analyst (Contractor)
Responsibilities:
- Implemented end-to-end monthly enrollment, dis-enrollment reports for One care based on business requirements and published across Commonwealth Care Alliance (CCA) and Tufts organizations.
- Migrated legacy SQL codes on Oracle to SAS programming codes and increased the team productivity by 30%.
- Managed a team of 7 members for a new Medicaid project while monitoring quality and completion within time lines.
- Worked on extraction, transformation and loading (ETL) of claims data from Data Warehouse for Provider claim match.
- Transformed the original Professional & Institutional claims data and prepared target data sets for data analysis.
- Executed various ad hoc reports for finding the summary of claims with different claims status in the prior billing cycles.
Confidential, Richardson, TX
Reporting Analyst (On Campus)
Responsibilities:
- Created weekly reports of Panda Express sales in UT Dallas Campus and inferred reasons for low sales of dining services.
- Designed dashboards and reports to improve proficiencies which progressed in expanding of dining with three vendors.
- Worked closely with sales team to help agents make better and informed decision on marketing strategies.
Confidential
SAS Data Analyst, Associate
Responsibilities:
- Acted as a Scrum Master for Provider module, one of the largest functional area in Medicaid application and supervised up to a team of 10 members.
- Extracted complex healthcare data of about 80 million observations from the databases such as Oracle, SQL, Teradata using SAS import techniques.
- Analyzed enormous complex data sets and varied business metrics to spot key insights and trends of a data source.
- Provided analytics support in benchmarking and target setting efforts and enterprise A/B Testing.
- Charted dashboards in Tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
- Worked as a Subject Matter Expert and conducted knowledge transition sessions to new members of team on Medicaid.
TECHNICAL SKILLS
Analytic Tools: Base SAS, SAS 9.4 Grid, SAS Enterprise Guide, SAS Enterprise Miner, R, Weka, Advanced MS Excel
Visualization Tools: SAS Visual Analytics, Tableau
Database Management: SQL Server, Toad for Oracle, DB2, Teradata, My SQL, MS Access