We provide IT Staff Augmentation Services!

Senior Sas Analyst/medical Economic Analyst Resume

SUMMARY

  • Certified SAS Programmer with 9 years of programming experience with SAS 8.2, 9.0, 9.1.3, 9.2, 9.3 in Mainframe, Windows and UNIX Environments.
  • Extensive programming experience in BASE/SAS, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/EG
  • Experienced in Base SAS procedures such as PROC FREQ, MEANS, SUMMARY, UNIVARIATE, FORMAT, IMPORT, EXPORT, REPORT, TABULATE, TRANSPOSE, DATASETS, COPY, PRINT and SQL.
  • Possess extensive knowledge in SAS BI tools like SAS ENTERPRISE GUIDE, SAS ENTERPRISE MINER, SAS INFORMATION STUDIO.
  • Performed Data management like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step and PROC SQL.
  • Experienced in using SAS to read, write, import and export to other data file formats, including delimited files, Microsoft Excel, Access files.
  • Worked in the domains HealthCare, Pharmaceuticals and Insurance.
  • Worked Primarily for Medicare and Medicaid in HealthCare.
  • Involved in Phase I, Phase II, Phase III of Clinical Trials and has working knowledge of Phase IV.
  • Has great understanding and working knowledge of Good Clinical Practice (GCP), Code of Federal Regulations (21 CFR Part 11), eCTD and FDA regulations.
  • Highly knowledgeable of Clinical Data Interchange Standards Consortium (CDISC) Version 2 and 3, SDTM, ADaM and International Conference of Harmonization (ICH) guidelines
  • Has knowledge of Integrated Summaries of Efficacy (ISE) and Integrated Summaries Safety (ISS)
  • Experienced at preparing reusable components and SAS Macros for automation of the application
  • Has thorough knowledge in Statistical Analysis Linear Regression, Descriptive Statistics, Factorial ANOVA, Regression Analysis, etc.
  • Strong experience in developing Test Plans, use cases, Test cases using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
  • Experience includes establish strategic direction, methodologies and procedures for testing.
  • Experienced in Mainframes Z/OS environment with COBOL, JCL, VSAM, GSAM, Confidential DB/DC, DB2, MQ series.
  • Worked with various Databases like Oracle, DB2, Sybase, Confidential DB, SQL SERVER and Teradata.
  • Extensive knowledge in SQL, PL/SQL.
  • Very knowledgeable with tools like ENDEVOR, XPEDITER, File - Aid, QMF, SPUFI.
  • Has a strong ability to interact with business knowledge experts to understand, and in some cases help define business functional needs
  • Has the ability to work as a team as well as to perform individually
  • Has exceptional problem solving skills for delivering useful and prudent solution. A quick learner with an eye for detail and excellent analytical and quantitative skills.
  • Excellent written and verbal communication skills, self-starter and good team player.

TECHNICAL SKILLS

Operating Systems: MS-DOS, Unix, Windows NT/2000/2003 Server/XP/Vista, OS/390

Languages: COBOL, VS COBOL II, JCL, VB, C, C++, JAVA, SQL, PL/SQL, UNIX SHELL SCRIPTING, HTML SCRIPTING, JAVA SCRPTING.

SAS Tools: Base SAS, MACROS, ACCESS, SQL, GRAPH, ODS, SAS ENTERPRISE GUIDE, SAS ENTERPRISE MINER, SAS INFORMATION STUDIO.

Database: Oracle,Sybase,DB2, Confidential DB, VSAM, GSAM,MS Access

OLTP: CICS, Confidential DC, TELON

Mainframe Tools: File-Aid, Endevor, JCL, QMF, SPUFI, Xpediter

Utilities: TSO, ISPF, IBM Utilities.

Domains: Insurance, Health Care and Pharmaceutical

Other Skills: Team Leading, Reviews, test planning and conducting vertical audits

PROFESSIONAL EXPERIENCE

Confidential

Senior SAS Analyst/Medical Economic Analyst

Responsibilities:

  • Attend the business meetings to understand the requirements specific to a LOB.
  • Review the meetings and do the GAP analysis and finally come up with Requirement Specifications document.
  • Coordination with the Project management to come up with the Project Plan for the Project.
  • Analysis includes identifying eligible providers, eligible claims, applying exclusion specific for LOB and Calculating the ACA pricing for the eligible billing codes.
  • Further Analysis to validate the fields and tables to do the data pull from SYBASE/ORACLE.
  • Libname Oracle/Sybase Engine, SQL Pass through facility to pull the data from the database.
  • Optimizing the Proc SQL to write the efficient queries while pulling large data from the DB to reduce the execution time.
  • Input from and output to external excel files using SAS/ACCESS for PC file formats.
  • Performed data manipulation like Merging, Interleaving, Combining sas datasets and used various sas functions and procedures during transformation of data fields.
  • Used Reporting procedures like PROC REPORT, PROC TABULATE, and DATA NULL to create reports to be sent out to the provider groups.
  • Wrote Macros to automate the Quarterly creation of payment files for some of the LOBs.
  • Prepare the payment file to go in to FACETS system and PDF reports to be mailed to the Providers.
  • Load the payment files in to the FACETS system to implement the enhanced rate payment to the providers.
  • Implement the ACA payment process in Retroactive payment methodology and Ongoing Payment methodology

Environment: SAS 9.2, SAS EG 4.3/5.1, SAS/STAT, SAS/SQL, SAS/MACRO, SYBASE, ORACLE, Windows 7

Confidential

Senior SAS Programmer/SAS Lead

Responsibilities:

  • Participation in the meetings with SMEs to gather high level requirements for the projects.
  • Analyzing the requirements and preparing the high level and low level design documents.
  • Worked on large datasets of pharmaceutical drug data from various pharmacies.
  • Writing SAS programs using PC SAS to do data transformations, validations of the data and to generate sas reports.
  • Create summary reports and graphs to the users.
  • Worked on adhoc requests to change the existing sas code and macros
  • Worked on standardizing and productionising the existing sas jobs using cybermation scheduler in Mainframe environment.
  • Coded and modified the existing COBOL programs.
  • Wrote UNIX shell scripts to call SAS programs.

Environment: SAS 9.2, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, Windows xp, UNIX, OS/390, COBOL, JCL.

Confidential

SAS Programmer

Responsibilities:

  • Responsible for developing SAS programs for the analysis of the data following the information stated in Analysis Plan.
  • Worked with various Medicare claims files like Inpatient, Outpatient, Prescription drug,
  • Physician for CMS (Centers for Medicare and Medicaid Services) which were 5% random samples drawn with out replacement.
  • Created Comparative effectiveness research public use files (CER-PUF) and deliver the Medicare claims files in the de identified form to CMS which will be useful to the public for comparative effectiveness research.
  • Performing Risk Analysis on the PUF datasets combined with the re-identification.
  • Using HIPAA standards set for protecting PHI (Protected Health information) for de-identification of the PUF datasets so that the information available to researchers is not IIHI(individually identifiable health information).
  • Estimating the identification risk, conducting Re-identification analysis by using inside and outside intrusion after safe harbor treatment.
  • Reading data from the external source files such as Comma separated files, mainframe files (EBCDIC) and tab delimited files.
  • Created reports using ODS into formats such as RTF, HTML and ODS TAGSETS to create XLS, XML.
  • Interpreting and summarizing the analytical findings.
  • Identifying the data sources to develop the Voluntary disenrollment measure from CMS’ databases such as Medicare beneficiary Database (MBD), Enrollment Database (EDB) .
  • Worked on the SAS code to develop the measure of voluntary disenrollment for Part C and part D and SAS code to identify the involuntary disenrollment.
  • Extensively worked on UNIX scripting.
  • Worked on part D report Card analyses to produce the star rating values for all the contracts that offer Part D coverage.
  • Working on SAS code to import the CME (Common Medicare Environment) data to SAS from EBCDIC format (extracted from Mainframes) and develop the measures for monitoring the Administrative functions.

Environment: SAS 9.2, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, Windows xp.

Hire Now