Sr Data Analyst Resume
SUMMARY
- Over 7 years of IT experience in the Analysis, Design, Development, Testing and Implementation of various statistical analysis projects in different domains such as, CMS (Centers for Medicare and Medicaid Services) and healthcare industries.
- Worked in generating statistical reports, tables, graphs using insurance claims and CMS Medicare and Medicaid healthcare data.
- Extensive experience using SAS in various platforms such as PC/Unix.
- Worked in all aspects project management life - Cycle Development.
- Wrote complex SQL queries using complex joins grouping, aggregation, nested subqueries and cursors.
- Worked in creating and maintaining project documentations such as detailed design documents, test procedures, implementation documents.
- Performed statistical analysis and presented results using SAS, SQL, MS Access, Excel.
- Manipulated files and their associated data for rapid delivery to clients or loading onto internal databases.
- Collaborated with project managers and other team members to gather data from different data sources to complete projects.
- Generate descriptive Statistics, Graphical Data Presentation, Gathering and Implementing User Requirements.
- Good Communication and Interpersonal skills.
- Effective Team Player, fast learner, dependable and consistent performer.
TECHNICAL SKILLS
SAS Tools: PC SAS 9.2, PC SAS 9.4, SAS EG 4.3, SAS EG 6.1, SAS EG 7.1SAS EG 8.1, SAS/GRAPH, SAS/MACROS, SAS/SQL, Macro Facility, SQL Management Studio
Other Applications: Word, Excel, Power Point, and Access database, Tableau, Visual
Databases: MS Access, Microsoft office Suite (Excel, Word, PowerPointOutlook), SQL Server, DB2, Oracle Database
Operating Systems: WINDOWS, UNIX, LINUX
SAS Procedures Used: PROC SORT, PROC TRANSPOSE, PROC FORMAT, PROC COMPARE, PROC REPORT, PROC TABULATE, PROC CONTENTS, PROC COPY, PROC MEANS, PROC FREQ, PROC SQL, PROC GPLOT, PROC PRINT & PROC UNIVARIATE, PROC RANK
PROFESSIONAL EXPERIENCE
Confidential
Sr Data Analyst
Responsibilities:
- Data cleaning and integrations
- Data manipulations and variable transformation projects
- Descriptive analysis to accomplish data trending and basic
- Descriptive statistics for business communications purposes
- Use SAS to prepare statistical report for Medicare/Medicaid claims data
- Review statistical reports prepared by statisticians
- Prepare Medicare/Medicaid claims data requested by law enforcement
- Work with request initiators to provide billing information for specific providers
- Use various statistical technique to produce Medicare/Medicaid reports for providers
- Create customize scripts to produce summary and claims data for specific providers
- Use SAS macros to create claim reports in excel and access databases
- Use ICD9 and ICD10 codes to analyze Medicare and Medicaid claims data
Confidential
Informatics Specialist
Responsibilities:
- Provide daily claims inventory for investigation and statistical analysis
- Use SAS to prepare statistical report for claims data
- Review statistical reports prepared by other statisticians
- Work with request initiators to provide billing information for specific providers
- Use various statistical technique to produce reports for providers
- Create customize scripts to produce summary and claims data for specific providers
- Use SAS macros to create claim reports in excel and access databases
- Used ICD9 and ICD10 codes to analyze medical claims data
- Development of programs and projects through SAS
- Conducting validation and other checks of data
- Reviewing historical codes and modernizing it within the context of the task
- Conferring with client on as-needed basis
- Data cleaning and integrations projects
- Data manipulations and variable transformation
- Descriptive analysis to accomplish data trending
- Using macros to create HTLM publication tables
- Use SAS ODS to create various tables