SUMMARY

• Certified Base SAS programmer for SAS 9 in data analytics and statistical modelling including data extraction, manipulation, and validation techniques, writing macros, and reporting on various projects for financial and healthcare industry using SAS and its tools.
• Broad understanding of healthcare data like claims clinical data quality metrics and health outcomes.
• Strong SQL knowledge for querying the database and proficient in developing tables, joins, data modeling, analysis, verification, cleansing, transformation, integration, mapping, extraction, load process from multiple data sources.
• Extensively used Macro programming in SAS/MACRO for data cleaning, validation analysis and report generation.
• Expertise in data extraction, data cleaning, data wrangling, data analysis, statistical analysis, and reporting with SAS/SQL/R/Python (Pandas Library) /Tableau.
• Build dashboards and supporting SQL database setups for weekly, monthly, and quarterly reports and analyses for clients.
• Experience in Data extraction from several databases including Oracle, SQL Server and other external files using SAS/Access, SAS/SQL pass through facility, Libname statements, and Proc Import procedure and via SAS Data steps.
• Conducts quantitative analyses of raw claims data, Rx claims, and various healthcare data sources.
• Excellent knowledge in Electronic Medical Record (EMR)/Electronic Health Records (EHR) modules.
• Conducts health database management, and audits to determine data quality and accuracy.
• Experience in working on the security for the monitoring of medical outcome quality data reporting for HEDIS related date warehouse.
• Build, implementation and technical support of system integration technology (General knowledge of Cloverleaf, HL7, FTP, SFTP) within the hospital environment.
• Retrieve and update the FHIR resources on the FHIR Server using SQL Schema of FHIR resources.
• Create clean, effective, and actionable presentations for clients and internal teams, collaborate with internal teams to translate business needs into measurement plans and their implementations via website/ad - server tracking setups and data flows.
• Good interpersonal skills, capable of handling multiple tasks and priorities, self-motivated, displays initiative, communication and problem-solving skills and work independently as well as in a team.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.

TECHNICAL SKILLS

Statistical Software: Base SAS, SAS/SQL, SAS/Macros, SAS/ODS, SAS/CONNECT

Programming Languages: Python (NumPy, pandas, matplotlib), R, SAS, SQL, MATLAB

Software Packages: MS Office (Word, Excel/Pivot tables, PowerPoint, Access, Outlook)

Graphic Tools: Adobe Photoshop, Adobe Flash

PROFESSIONAL EXPERIENCE

Confidential, Phoenix

Data Engineer/Analyst

Responsibilities:

• Provided support when facing hurdles during loading data, running processes, and producing reports in HEDIS reporting software.
• Created and published periodic reports from HEDIS product, as well as any necessary HEDIS ad hoc reports.
• Responsible for completing the analysis process to determine best course of action for each inquiry.
• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and grouped data, and refreshed and formatted pivot tables.
• Entered all applicable information into the electronic medical record review tool as required.
• Collaborated with data science team to transform data and integrate algorithms and models into automated processes.
• Created complex and reusable Macros by using Macro programming language, and developed SAS and SQL Programs for data cleaning, validation, analysis, and report generation. Tested and debugged existing macros using different macros debugging options.
• Democratized data and insights through data integration and the use of visualization tools.
• Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to different database such as Oracle, Teradata, DB2.
• Build dashboards and supporting SQL database setups for weekly, monthly, and quarterly reports and analyses for clients.
• Excellent analytical skills and the ability to plainly communicate results to clients and internal teams.

Environment: SAS BASE, SAS/SQL, SAS/MACRO, Excel/Pivot tables, Oracle, Teradata, DB2, HEDIS

Confidential, Philadelphia

Data Analyst

Responsibilities:

• Gathered healthcare data from various sources within the organization to accomplish quality/performance improvement goals.
• Provided data analysis to drive clinical and operational process changes.
• Used Excel Pivot tables to manipulate large amounts of data to perform data analysis using data sources such as Epic, Midas, and Vizient.
• Developed and implemented databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
• Created SAS query along with ETL tools to extract and process data from different database into the SAS environment.
• Extensively used the SAS/Macro facility for automation process and to write weekly and monthly reports.
• Produced RTF, PDF and HTML formatted files using SAS/ODS to produce ADHOC reports for presentation and further analysis.
• Presented information to tailor messaging to the specific audience like physicians, senior management and department directors and managers.

Environment: SAS BASE, SAS/SQL, SAS/MACRO, SAS/ODS, SQL Server, MS Excel Pivot Tables

Confidential, New York

Healthcare Data Analyst

Responsibilities:

• Responsible for daily evaluation of ongoing data feeds, interpretation of nuances within the data and maintaining a pristine healthcare dataset for use in products and offerings.
• Worked with healthcare claims data and wrote SQL queries to organize the data and sorted, summarized, and reported salient changes within the datasets.
• Evaluated and established the validity of incoming claims data and data element combinations to ensure accuracy and completeness of all reporting results.
• Collaborated with data and product staff on various aspects of incoming healthcare claims data.
• Used analytic tools such as Tableau and SAS for healthcare data analysis and visualization.
• Utilized Microsoft Excel to categorize previous reports into a detailed pivot table to develop an improved strategy.
• Extracted healthcare data from the Oracle database using SAS/Base, SAS/Access, and wrote SQL queries using Proc SQL procedures and created SAS datasets.
• Performed data cleaning by analyzing and eliminating duplicate and inaccurate healthcare data using Proc Freq, Proc Comp, Proc Univariate and Macros in SAS.
• Used regression techniques ANOVA, CORR, Proc Means and Proc Freq to analyze the data.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Responsible for preparing, reporting and maintenance of daily, weekly, and monthly productivity and accuracy report using SQL query, MS excel, Word, PowerPoint.
• Performed Data analysis, statistical analysis, generated reports, listings, and graph using SAS tools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Created reports in various style format (RTF, PDF, Excel, and HTML) using ODS statements.

Environment: BASE SAS, SAS/MACRO, SAS/SQL, SAS/ODS CONNECT, SAS/ACCESS, MS Office, Tableau

Confidential, Carbondale

Data Analyst

Responsibilities:

• Maintained all required record, reports, statistics, logs, files, and other documents as required.
• Acquired healthcare data and loaded the data into SAS datasets for further analysis and reporting.
• Interpreted data, analyzed results using statistical techniques and provided ongoing reports.
• Distributed laboratory reports according to current guidelines.
• Extracted, transformed, and loaded ETL datasets with basic modeling variables for each segment type using Proc Import and SQL queries, imported data from Oracle database into SAS files.