SUMMARY

• Over 10 years of experience as SAS programmer with good knowledge of advanced statistical methodologies applied in Pharmaceutical, Health Insurance and Financial industry. Along with Three years of experience in administrating Qlikivew application.
• Experience in Data manipulation and producing reports employing various SAS procedures like PROC SQL, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC SUMMARY, and PROC CONTENTS.
• Proficient with Statistical Analysis and reporting applications using SAS Software.
• Proficient with SAS/Base, SAS/Stat, SAS/Macros, SQL SAS/Graph, SAS/Access
• Proficient with SAS BI tools SAS DI Studio, SAS OLAP Cube Studio, SAS Information map Studio, SAS Web report Studio.
• Experience in supporting DATASTAGE (ETL) for 4 years.
• Proficient with wide range of SAS programming in PC, Mainframe and UNIX platforms.
• Experienced in using various SAS procedures such as tabulate, univariate, SQL, Freq, mean, summary, contents, sort, cluster and report.
• Proficient with Mainframe applications of SAS including JCLs and PROCs.
• Experience working with DATASTAGE applications and exposure to Cognos, Business Objects reporting tools.
• Expertise in inferential statistical analysis like t - tests, analysis of variance, chi-square tests and correlation.
• Experienced with development, installation and upgrading Qlikview Software.
• Knowledge in Hadoop technology and tools (HDFS,Map Reduce,Hive,PIG,Sqoop)
• Efficient in maintaining working relationships with clients and internal project members, including data managers and other statistical programmers.
• Experience in developing and maintaining statistical documentation, including description of statistical methods, SAS programs, results and discussion.
• Documented, summarized and recorded data as per standard operating procedures (SOPs) and FDA regulations.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Experience coordinating and managing offshore/onshore team.
• Effective team player with strong communication & interpersonal skills.

TECHNICAL SKILLS

Statistical Software: SAS 8, SPSS, SAS/BASE, SAS/SQL, SAS/MACRO, SAS/GRAPHSAS/STAT, SAS/ASSIST, SAS/EG, SAS Enterprise Miner, R/S-Plus and Minitab

Operating Systems: Windows 2000, Windows XP, Linux and UNIX, VMS

Software: C, C++, Fortran77

MS Office: Word, Excel, PowerPoint, Access and Outlook

Database: SQL Server, Oracle, DB2, Teradata, Mainframes and MS-Access

Packages: DATASTAGE7.5.3, Cognos Report Studio, Cognos Query StudioArena, MS-Visio, Pro-E, Qlikiview9.0/10

PROFESSIONAL EXPERIENCE

Sr. Stat Programmer

Confidential, Austin

Responsibilities:

• Created new SAS programs and worked on enhancement for Prospective Predictive modeling team to identify provider fraud.
• Worked on programs provided by Statisticians/Molders/Business groups to improvise performance of the code in production
• Converted Predictive Models from JAVA to SAS which includes complex logic to identify fraud.
• Designed programs and Architecture to run the SAS programs efficiently
• Participated in design of new systems/processes as part of Advanced Analytics teams.
• Used procedures PROC REPORT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC CONTENTS and PROC DATASETS to generate different reports as well as generated metrics on different data sets.
• Leading offshore team, provided time lines and assigned resources on the projects
• Provided ad-hoc data queries and analysis as requested for internal and external customers.

Environment: SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/DI, SAS/OLAP, SAS/WRS, DB2, Oracle, Teradata SQL, SAS/Eminer.

SAS Programmer, AVP

Confidential, OH

Responsibilities:

• Supported Deposit review Reporting Process which is part of consumer risk reporting.
• Extracted data from SQL Servers, DB2, Oracle databases using Proc SQL pass through facility.
• Created Reports using Proc Report and Proc Gchart, Proc Means and Proc Transport procedures.
• Supported FUTRIX cubes reporting application, for consumer risk reporting.
• Moved FUTRIX cubes data into SAS EBI application such as SAS Web Report Studio, SAS Information Map Studio and SAS OLAP cubes
• Scheduled SAS programs using CronTab.
• Worked with SAS BI including OLAP Cube Studio, Web Report Studio, SAS AddIn for MS Office, stored processes.

Environment: SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/CONNECT, DB2, Oracle, Teradata SQL, SAS/WRS, SAS/OLAP, SAS/IDP.

Business Intelligence Developer

Confidential, MN

Responsibilities:

• Supported MYUHC application- by running daily, weekly, bi-weekly & monthly loads to process enrollment and claims, it runs on SAS and scheduled crontab.
• Supported PHR application weekly runs. Pro-actively worked on ad hoc requests from the clients when encountered issues seeing their claims on PHR website and the application uses SAS for ETL and Autosys for scheduling.
• Developed and enhanced UHC (United Health Care) pharmacy solutions and PCP project. It is used through out UHG, to find out PCP.
• Developed new programs, tested and performed QA on different datasets.
• Worked on technical changes documentation also version control documentation of the programs.
• Responsible for performing discrepancy analysis on myuhc project which comprises of extracting, validating and reporting.
• Responsible for enhancement, development and productionalize of ad-hoc programs on a weekly, monthly and quarterly basis.
• Trained and Lead offshore SAS development team of four.
• Involved in planning, provided the time lines and assigned resources on the projects.
• Responsible for running predictive model, to predict HRP on different sites.
• Extracted data from DB2/Oracle/Teradata data warehouse/Data marts using proc SQL pass though facility. Used different Joins and merges to create final datasets for reporting purposes.
• Wrote macros to automate the code in order to generate reports on the invocation of the macro which helped to save time and manual intervention.
• Used SRCS version control system to maintain different versions of programs.
• Supported IRAR (Independent Right Access Report) part of fraud and abuse department. Extracted medical claims from Mainframe archives using JCLs and SAS programs for the data not available on data warehouse.
• Created ETL’s for Data Mart using different transformation in Data Integration Studio (ETL).
• Worked with SAS administration in installation and testing of SAS9.X versions.
• Built Cubes in SAS OLAP CUBE STUDIO and Report publishing through SAS Web Report Studio.
• Extracted data from various sources and integrated using SAS DI Studio, then performed data quality checks.
• Created documentation on Data Integration (ETL) jobs.
• Supported QSG’s (Query Solution Group) DATASTAGE projects which includes enhancement, conversion of QSG project into SAS and optimized the performance.
• Designed reports, charts, and graphs and published using Qlikview software.
• Created QVW, QVD using Qlikview software. Maintained and upgraded according to new requirements.
• Scheduled QVW/QVD in QEMC to update on timely basis according to database updates.
• Worked with end users to gather the functional requirements and customize Qlikview dashboards according to their requirements.
• Developed Qlikview Scripts (ETL) to load the relevant Data from different data sources to Qlikview applications.

Environment: SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/DI, SAS/OLAP, SAS/WRS, DB2, Oracle, Teradata SQL, AIX, Mainframe, Datastage, Cognos, Qlikview, Tableau

Confidential, MN

SAS programmer

Responsibilities:

• Created SAS data sets from the flat files by writing the SAS program in BASE/SAS.
• Connected to DB2 and pulled data into SAS data sets using SQL pass through facility.
• Wrote various joins and merges to create reports based upon the requirements.
• Wrote efficient code using PROC SQL, which inturn optimized resources.
• Wrote macros to automate the code, which generates reports on the invocation of the macro which consumed less time and manual intervention.
• Used PROC SORT to sort the data according to the requirement.
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC CONTENTS and PROC DATASETS to generate various reports and run metrics on different data sets.
• Used SAS procedures in preparing daily, monthly, yearly reports.
• Developed UNIX Korn Shell scripts to automate recurring processes. Autosys is used for scheduling.

Environment: Base SAS, SAS/GRAPH, SAS/STAT, SAS/MACRO, SQL, DB2, SQL assistant, UNIX (AIX).

Product development Engineer

Confidential, MD

Responsibilities:

• Performed data collection and statistical analysis for R&D department.
• Prepared statistical reports for R&D department.
• Constructed process diagrams, designed layout for equipment using Microsoft Visio.
• Created material database using Microsoft Access.
• Prepared and Maintained Batch Manufacturing Records (BMR), Oversaw Standard Operating Procedures (SOP) making the necessary updates, using Microsoft word.

Environment: Minitab, MS-Visio, MS-office, Windows-XP

Research Assistant

Confidential, TX

Responsibilities:

• Developed a software tool for “Soil classification” using visual Basic software.
• Performed statistical analysis to validate Soil classification tool.
• Performed requirement analysis and data collection for Simulation studies.
• Conducted statistical analysis and created user interface for simulation model.
• Created analysis data sets from raw data and investigated for anomalies and missing data.