SUMMARY

• Over 8+ years of extensive experience in SAS programming on different platforms - Windows and UNIX, also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, and testing and data validation.
• Experience in Data analysis and Reporting in health care, finance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis and risk management of financial, marketing and health care data and in the production of reports and tables.
• Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
• Developed new or modified existing SAS programs to load data from the source and create study specific datasets.
• Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio.
• Strong ability to write SQL queries using PROC SQL.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database.
• Involved in coding and pulling data from various oracle tables using Unions and Joins.
• Customize the variables to user-defined formats using PROC FORMAT in printing reports.
• Experience in working with SAS ENTERPRISE GUIDE for reporting and analytical tasks.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
• Performed data extraction, analysis and published results using SAS ENTERPRISE GUIDE.
• Experience in using SAS to read, write, import and export to another data file formats including delimited files, spreadsheet, Microsoft excel and access tables.
• Good understanding of software development life cycle concepts.
• Ability to adopt new technologies, and able to communicate and provide support to BI issues.

TECHNICAL SKILLS

SAS Tools: SAS 9.1.3 SAS/BASE, SAS/Macros, SAS/STAT, SAS/Graph, SAS/SQL,SAS/ACCESS,SAS/ODS, PROCEDURES ETC.

Databases: SQL SERVER 2008/2005, ORACLE 9i, 10g.

Operating Systems: Windows 95/98/2000, windows XP, UNIX, Mainframes

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior SAS Analyst

Responsibilities:

• Performed data extraction, data analysis and Experienced in extracting the data from Oracle, SQL Server databases, Green Plum and from SPDS efficiently using SAS/Access.
• Produced multi-dimensional reports and tables using procedures PROC/REPORT, PROC/TABULATE, PROC/SQL and DATA NULL .
• Creating text, Excel reports using SAS / ODS, VB scripting and Report automation processes.
• Performed data and Developing SAS Programs, Macros Including Advanced SAS Programming techniques for Data Accessing, Data cleansing, Data management, and reporting.
• Quality checking, validating and verifying accuracy of reports developed.
• Used Procedures such as PROC REGRESION, PROC FREQ, PROC FORMAT, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.
• Developed, tested and maintained daily/monthly/quarterly report packages illustrating progress towards the strategic objectives.
• Good knowledge of using SAS Enterprise Guide, SAS Unix.
• Monitoring and handling the job failures to keep all the reporting processes up and running.
• Involved in Resolving the Critical Report issues for Business/Market/State to meet the stringent deadlines.
• Involved in debugging SAS code, compiling errors, review SAS code.
• Running ad hoc reports to support risk adjustment initiatives and strategies.

Environment: SAS 9.3, SAS Macros, SAS/ODS, SAS/ACCESS, Oracle 10g, Windows 7, MS Office, SAS Enterprise Guide 4.3, UNIX.

Confidential, Camp Hill, PA

Senior SAS Programmer/Analyst

Responsibilities:

• Involved in key risk adjustment activities and related provider auditing and monitoring, Interacted with business users, business analysts and translated business requirements into technical specifications.
• Performed data extraction, data analysis and prepared various production and ad hoc reports to support risk adjustment initiatives and strategies
• Focused on the Medicare Preferred population and support the goal of providing a value based product that is competitively priced and increases the quality of care provided to our members.
• Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Extensive study, design, development and testing were carried out in the Oracle Environment
• Extensively involved in getting data from oracle database using SQL pass- through.
• Involved in writing code using SAS/ Base & SAS/Macros for creation of analysis datasets.
• Performed data cleansing to eliminating duplicate and inaccurate data.
• Extracting and converting data from one platform to another to be used for further analysis. (From Oracle and Excel to SAS) by using SAS SQL procedures and create SAS data sets.
• Created efficient SAS programs using SAS Macros and Validated the same to optimize the resource utilization and faster processing.
• Documented and maintained libraries and catalogues of SAS programs and formats
• Involved in validating other programmers code.
• Produced multi-dimensional reports and tables using procedures PROC/REPORT, PROC/TABULATE, PROC/SQL and DATA NULL .

Environment: SAS 9.3, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle 10g, Windows 7, MS Office, HTML, SAS Enterprise Guide 4.3, SAS/Graph, MS/Access.

Confidential, TX

Senior SAS Programmer/ Data Analyst

Responsibilities:

• Involved in development and testing of Marketing Models.
• Interacting extensively with Model Owners on requirement gathering, analysis and documentation.
• Documented coding methodology, data reports and model results to share with Users and Management.
• Imported data using LIBNAME and PROC SQL facility to reduce processing times.
• Extensively performed Data Cleansing during the ETL’s Process by analyzing the raw data and writing SAS Codes and Complex reusable Macros.
• Carried out Data extraction and Data manipulation techniques using PROC SQL. PROCT SORT, DATA Step by applying project specific conditions.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, and PROC SUMMARY.
• Extensively used SAS procedures such as PRINT, RANK, FREQ, MEANS, and SUMMARY, TABULATE.
• Performed Data Analysis, Statistical Analyis, Generated Reports and Listing using SAS/SQL, SAS/ACCESS and SAS/EXCEL, Pivot Tables and Graphs.
• Effectively prepared and presented various performance reports and presentation.
• Develop, write and execute protocols for the process validation of new processes.Assist in the development of Control Checks for developers.
• Collect and review data and compile reports.
• Performed research for development of technical and quality assurance protocols.
• Analyzed data from validation activities and reported any irregularities.

Environment: SAS/Base, SAS Enterprise Guide, MS Excel, SQL, IBM Cognos, IBM SPSS Modeler, Tableau.

Confidential - Memphis, TN

SAS Programmer

Responsibilities:

• Coordinate with the Client to develop and run daily, monthly and quarterly processes.
• Work with business to implement their reporting needs using Base SAS, SAS SQL, and SAS Macros.
• Working on data QC analysis, metadata development and data profiling.
• Working on complex datasets to extract customized reports using PROC SQL, PROC SORT, PROC REPORT and PROC TABULATE based on the specifications from BRD.
• Use SAS report generating procedures like PROC REPORT, PROC FORMAT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC SUMMARY, PROC IMPORT, PROC UNIVARIATE, and PROC TRANSPOSE.
• Proficiently use SAS procedures to extract data from different relations database management systems like Teradata, Oracle.
• Perform data analysis, statistical analysis, generated reports, listings and graphs using SAS tools.

Environment: SAS v9.3/9.4, Oracle 11g, SAS/BASE, SAS/STAT, SAS/ MACROS, SAS/SQL, SAS/ACCESS, SAS/ODS, Oracle 9i, Windows XP, UNIX.

Confidential

SAS/SQL programmer

Responsibilities:

• Interacted with business users, business analysts and translated business requirements into technical specifications.
• Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Extensive study, design, development and testing were carried out in Oracle environment.
• Extensively involved in getting data from Oracle database using SQL pass through.
• Involved in writing code using SAS/Base and SAS/Macros for creation of analysis datasets.
• Performed data cleaning to eliminate duplicate and inaccurate data.
• Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
• Generated high quality reports and listing HTML, EXCEL and PDF formats using SAS/ODS.
• Quality checking, validating and verifying accuracy of reports developed.
• Producing reports by employing various SAS procedures like Proc Print, Proc Report, Proc Summary, Proc Freq, \Proc Tabulate, Proc Means and Proc SQL.
• Generated highly customized reports using Data, Null, Put statements, Proc Report, Proc Tabulate and Proc print.
• Creating, maintain and running SAS jobs to support specific solicitation and loading of database tables for analysis.

Environment: SAS/Base, SAS/EG, SAS/Macros, SAS/Access, SAS/Connect, SAS/Unix, SAS/ODS, Oracle9i, MS Excel.