Skills

• Technical Skills
• Experience
• Last Used
• Expertise

Relational database experience as an architect (e.g. Oracle or MySQL)

• 8+ Years
• 2013
• 3 - Expert

Experience processing large health care data files

• 4+ Years
• 2011
• 3 - Expert

Unix or Windows server experience

• 8+ Years
• 2013
• 3 - Expert

Experience in SAS applications programming

• 4+ Years
• 2013
• 3 - Expert

Employment History:
Confidential, Farmington Hills, MI
SAS Programmer
Confidential is a competitive U.S. auto financing company focused on wholesale finance plans of many kinds: dealer finance plans, dealer services, retail consumer finance plans, lease programs, and auto-insurance.TD Auto Finance is part of Confidential, ranked as one of the safest banks in North America by Global Finance Magazine. Currently I am working as a Risk Analyst in Risk Management department; my job is to design, develop, validate and implement SAS code, SAS macros, models, Score cards, statistical analyses and reports, and presenter distribute the same analysis to various groups and Departments within the company. My roles and responsibilities are listed below.

Responsibilities:

• Design, Develop and create SAS Macros using SAS 9.2 version to identify risk based customers.
• Develop and Implement customer based score cards to identify Low risk, Medium risk and High risk customers based upon the historical data.
• Design, develop and implement algorithms, concepts and models based on the user requirements.
• Experience working with SAS application programming in migrating SAS datasets to SQL and Oracle tables, SAS statements to SQL statements using SAS/SQL.
• Worked on extracting data from Strata 4.1.5 versions into SAS 9.2 version.
• Experience in Policy research to identify thresholds on cures, return check, charge-off and redemption accounts and implement the same threshold values in the SAS code.
• Involved in developing forecast and regression model to identify the customer behavior from the historical data.
• Designed, developed and implemented champion challenger project in SAS to identify potential customers for collection department. This project identifies Low risk, Medium risk and High risk customers and generates a report to collection department.
• Designed and developed dealers monitoring macro which will generate six metrics related to the performance of the dealers from past 6 months and generate Bottom 50 dealers list, this list will documented and presented in monthly Dealers monitoring meeting.
• Generate weekly and monthly reports which will Includes percentage of cures under low risk, medium risk and high risk categories.
• Developed SAS programs which will extract the data from Teradata and manipulate the same data for statistical analysis.
• Have experience with trouble shooting/Administration of configuration / connectivity between SAS Enterprise Guide, SAS Add-In for Microsoft Office and SAS BI Enterprise server.
• Responsible for proper coding, documentation and validation of SAS programs/macros/procedures to produce the standardized data display.
• Involved in validating regression and forecast model outcomes.
• Involved in validating new score card models which was developed by our Toronto team and participated on site meetings to discuss the suggestions and issues from the model outcome.
• Involved in behavioral and credit scoring projects.
• Developed resource allocation project and generated reports to collection department.
• Experience in loading Teradata with the daily transactions and summarize the daily load report.
• Developed SAS macro which will read txt files and load them into various tables in Teradata.
• Experience in creating, modifying and enhancing strategies in Strata 4.1.5 version based on the monthly strategy collection meetings.
• Experience in preparing power point slides to present dealer monitoring report results.

Environment: SAS 9.2, SAS/Macro, SAS/SQL, SAS/Regression, SAS/Standard Deviation , SAS/GRAPH, Enterprise Guide, Teradata,DB2 ,Strata 4.1.5, Excel, Unix, Windows 8, Ms office 2010.

Confidential, Nashville, TN
Statistician / SAS Administrator

Confidential is a leading provider of information technology (IT), engineering, logistics, and professional services and solutions to U.S. Federal Government agencies. As Statistician my job is to analyze Medicaid claims data and report Medicaid Overpayments, Fraud and abuse by using most sophisticated methodologies.

Responsibilities:

• Independently design, develop, apply and/or review statistical methods to evaluate and analyze numerical data using computer software, including SAS, Oracle, SQL, ODM ,MS Access, MS Excel and/or other applications, in accordance with clients’ requirements, costs and time constraints, for assigned projects.
• Experience working with SAS application programming in migrating SAS datasets to SQL and Oracle tables, SAS statements to SQL statements using SAS/SQL.
• Developed Multi-Sate IP (Inpatient) Project which identifies trends for Inpatient expenditures between states and over time as aberrational patterns which warrant further investigation and analysis.
• Developed Multi-Sate RX (Pharmacy) Project which identifies pharmacy claims that violate 8 state’s early refill policy for those claims that are billed for the same medication and for the same recipient with same quantity.
• Review algorithms, models and projects to ensure accuracy and quality of work and make revisions and/or recommendations, when required.
• Review the design, development, implementation of innovative analytical approaches and predictive modeling techniques for reactive or proactive data analysis, statistical modeling, data mining, sampling, study design, and quality assurance and/or control to ensure accuracy.
• Developed predictive model project for Illinois Medicaid claims which will identify the Emergency Room-up coding claims with the list of top Servicing Providers Information.
• Experience in debugging, reviewing and resolving issues within the existing code and/or methodology and propose work around methodologies to increase analytical efficiency.
• Experience in reviewing data collection methods and determining sample size requirements to verify accuracy and proper allocation of methodology logic.
• Develop macros to generate pre analysis reports from Oracle MIG Data Engine and present them in the meetings.
• Responsible for day to day external database support for all the internal SAS Programmers/Developers as a SAS Administrator.
• Participated in designing, coding, testing, debugging and documenting SAS Stored Procedures, Programs and Macros.
• Implement the methodologies suggested by the CMS and generate the reports using SAS.
• Experience working as a backup Quality Analyst for the algorithms developed by other teams.
• Experience in state policy research, policies and other relevant information to ensure that the most appropriate statistical techniques and/or methods are utilized.
• Experience in researching key areas relevant to the various algorithms, models and projects to ensure appropriateness, accuracy, and completeness for the various software platforms used.
• Communicate effectively with management, investigators, other Statisticians, as well as internal and external clients.

Environment: SAS 9.2, SAS/BASE, SAS/Macro, SAS/SQL, SAS/Regression, SAS/ Standard Deviation , SAS/GRAPH, SAS Enterprise Miner, Enterprise Guide, SAS/ACCESS, Excel, Oracle, ODM, DB2 , UNIX, and Mainframes, Windows XP.

Confidential, Nashville, TN
SAS Data Analyst/ Administrator

Confidential is an affiliate of Computer Sciences Corporation (CSC) specializing in helping healthcare organizations to evaluate and assess the integrity of their health and pharmacy benefit programs. Advance Med provide services to the clients that exceed their expectations and contribute to improved healthcare delivery by identifying and eliminating fraud, waste, and abuse. I worked as Data Analyst for a Federal Government Project, Task Order Four which is a direct contract from CMS (Center for Medicaid and Medicare Services) .As a Data Analyst my job is to analyze the data and report Medicaid Overpayments, Fraud and abuse from different states in USA by using most sophisticated methodologies.

Responsibilities

• Develop macros to generate pre analysis reports from Oracle MIG Data Engine and present them in the meetings.
• Experience working with SAS application programming in migrating SAS datasets to SQL and Oracle tables, SAS statements to SQL statements using SAS/SQL.
• Implement the methodologies suggested by the CMS and generate the reports using SAS.
• Design, Develop, Test and Implement new algorithms for different states.
• Proposed proactive algorithms to CMS and received approvals for the submitted proactive algorithms and implemented the same proposed algorithms to find out Overpayment, fraud and abuse claims for several other states.
• Experience working as a backup Quality Analyst for the algorithms developed by other teams.
• Developed macros which will validate the SAS final code, reports and logs to make sure proper parameters are used before delivering to the CMS.
• Processed large amounts of healthcare data files through a complex grouping and data manipulation process.
• Working Experience to find out the overpayments for Out Patient Services( same day services, billing errors , service code errors, overlapping , duplicates, services after death etc)
• Experience in Policy research for each state and implement them in the SAS code and modify the algorithm according to the state policy.
• Developed predictive model project for Indiana Medicaid claims which will identify the Evaluation and Management up coding claims with the list of top Provider Billing Information.
• Generate separate sample reports for each individual state to validate and update the Final findings with state sampling response.
• Developed different metrics models using regression and standard deviation.
• Responsible for proper coding, documentation and validation of SAS programs/macros/procedures to produce the standardized data display.
• Experience in extracting large oracle tables and convert them in to SAS datasets.
• Experience in creating Oracle database to SAS library and access the Oracle tables in SAS.
• Responsible for day to day external database support for all the internal SAS Programmers/Developers as a SAS Administrator
• Able to generate reports in Oracle.

Environment: SAS 9.2, SAS/BASE, SAS/Macro, SAS/SQL, SAS/Regression, SAS/ Standard Deviation, SAS/GRAPH, SAS Enterprise Miner, Enterprise Guide, SAS/ACCESS, Excel, Oracle, ODM, DB2 , UNIX, VI Editor , and Mainframes, Windows XP.

Confidential, Ann Harbor, MI
Clinical SAS Programmer

Confidential is the leading provider of decision support solutions that help organizations across the healthcare industry to improve clinical and business performance. As a SAS Programmer I have worked for a CMS (Center for Medicaid and Medicare Services) Government project, Task Order One to analyze Medicaid claims data and report Overpayments, Fraud, and abuse from different states in USA.
Responsibilities

• Developed Macros to generate Monthly reports of the Service Providers based on the Providers ID.
• Developed Specification Documentation for One day Inpatient services and Inpatient duplicates and developed macro to analyze the potential overpayments and generated reports.
• Experience in working with Mainframe to Oracle migration code.
• Worked with oracle Data engine to run the mainframe code as CMS migrated from Mainframe to Oracle.
• Processed large amounts of healthcare data files through a complex grouping and data manipulation process.
• Developed data steps to find out the abnormal data from different files with various variables.
• Modifying the SAS code to run it on Mainframe environment to meet the mainframe standards.
• Developed models with regression and standard deviation.
• Developed Algorithm and Macro for National Correct Coding Initiative Comprehensive Code Unbundling.
• Developed Algorithm and Macro for Same Day Pharmacy Duplicates, Same provider to identify two or more claims for the same drug billed by the same Pharmacy provider.
• Provided descriptive Statistics on various States data sets.
• Have experience with design , implementation of stored process using Management console, Metadata server and SAS Enterprise Guide
• Have experience with trouble shooting of configuration / connectivity between SAS Enterprise Guide , SAS Add-In for Microsoft Office and SAS BI Enterprise server
• Developed validated and documented programs to create TLG’s (Tables, Listings and Graphs) as per Statistical Analysis Plan (SAP) using SAS reporting procedures.
• Generated Ad-Hoc reports for further analysis using SAS tools.

Environment: SAS/BASE, SAS/Macro, SAS/SQL,SAS/BI, SAS/GRAPH, SAS Enterprise Miner, Enterprise Guide, AS/ACCESS, Excel, Oracle, ODM, DB2 , QTP9.0 , UNIX, VI Editor , and Mainframes, Windows XP.
Confidential , King of Prussia, PA
Clinical SAS Programmer
Confidential in Pharmaceutical companies, provides support for developing new therapies and drugs. I have worked as a SAS programmer in clinical trial Fazes I, II to generate reports.
Responsibilities:

• Validated datasets as required by the client to find the missing data and imported to SAS Environment.
• Extracted data from flat files, MS Excel and Oracle Clinical database and created SAS data sets using different SAS procedures and SAS/SQL “Pass through facility”.
• Worked with SAS Scalable performance Data Server to reduce extraction, transformation and loading times, irrespective of data size.
• Provided flexible data storage options to support business intelligence and analytic application requirements using SAS Intelligence Storage according to the statistician’s requirements to support different Phases in Clinical trials
• Generated laboratory shift tables from Analysis Data Model (ADaM) datasets in clinical trial studies.
• Have experience with trouble shooting of configuration / connectivity between SAS Enterprise Guide , SAS Add-In for Microsoft Office and SAS BI Enterprise server
• Experience in large-scale (multi-terabyte), scalable, highly available and reliable database architectures.
• Developed and used SAS Macros programs to generate reports, tables and listings for clinical and bio-statistical review.
• Distribute results by publishing to multiple channels, including the SAS BI report/content repository, the SAS Stored Process Server, printers, Microsoft Office documents and e-mail.
• Created Analysis of Variance (ANOVA) predictive models t-Test, one-way ANOVA, nonparametric one-way ANOVA, linear models and mixed linear models.
• Testing and validating the code using QTP automation testing tool by using VB Script.

Environment: VB script ,C#.NET, ASP.NET, VB.NET, ADO.NET, SQL SERVER 2000,SAS/BASE, SAS/Macro, SAS/SQL, SAS/BI, SAS/GRAPH, SAS Enterprise Miner, Enterprise Guide, SAS/ACCESS, Excel, Oracle, SQL, PL/SQL , QTP9.0 , UNIX, VI Editor , and Windows XP.

Confidential , INDIA
SAS Programmer
Confidential into clinical trials apart from Health care service in developing new therapies. The collected data from the provider was loaded into the database for further reporting based on report specification. The reports were developed and sent to the Head of the department.
Responsibilities:

• Generated statistical analysis files, summary tables, listings and graphs using SAS/BASE, SAS/MACROS, SAS/GRAPH and SAS/STAT, SAS/IML.
• Created new datasets from existing data-sets by using concatenation, merging, interleaving and using conditional statements.
• Created Study Data Tabulation Model (SDTM) data tabulation data sets that are to be sent to FDA as part of a regulatory submission.
• Using Analysis Dataset Models (ADaM) I have created datasets that are designed for creating statistical summaries and analysis.
• Processed large amounts of healthcare data files through a complex grouping and data manipulation process.
• Experience working with SAS application programming in migrating SAS datasets to SQL and Oracle tables, SAS statements to SQL statements using SAS/SQL.
• Developed and improved the efficiency of programs through the use of SAS macros.
• Moved the datasets and final results between multiple platforms.
• Validation done on all the data sets and developed testing scripts and Flag the scripts according to priority using PI manager Tool.
• Reviewing developed SAS code to eliminate any possible errors and improve functionality.

Environment: C#.NET, ASP.NET, VB.NET, ADO.NET, SQL SERVER 2005,SAS/BASE, SAS/BI, SAS/MACROS, SAS Enterprise Miner, Enterprise Guide, SAS/ODS, Proc TABULATE, Proc ANOVA, Oracle 10g, QTP 9.0 , UNIX , MVS.
Confidential, INDIA
SAS Programmer
Confidential is Service level agreement customer care cockpit to deliver a monthly reporting of the data received from different customers like PFIZER, GE, and UFA.
Responsibilities:

• Techniques used in SAS include file merging, frequency and Report, Transpose, Summary, and Means Procedures, SAS/IML.
• Responsible for day to day external database support for all the internal SAS Programmers/Developers as a SAS Administrator
• Performed Data driven from data warehouse based on the requirement and generated reports using SAS/BI
• Provided the statistical analysis plan and derives sample size estimates for study protocols based on current statistical methodology and ensures the data collection methods are compatible with the analysis plan.
• Involved in Enterprise BI Administration to configure different Datamarts.
• Exported the reports to other applications such as Adobe Acrobat, Microsoft Excel, Microsoft Access or Microsoft Word.
• Used Star Schema using Oracle tables, and elements
• Performed Statistical Analysis using SAS STAT procedures such as Regression and Multivariate Analysis.
• Reviewed and streamlined outdated SAS code to eliminate errors and improve functionality.
• Created macros to create the sample dataset from the conditions specified.

Environment: C#.NET, ASP.NET, VB.NET, ADO.NET, SQL SERVER 2005, SAS/BASE, SAS/MACRO, SAS/AF, SAS/BI, SAS/TESTING, MS Excel, Oracle 9i, UNIX, VI EDITOR and MVS.

Confidential, CT, USA
Software Engineer/SAS Programmer
Confidential is one of the major publicly traded pharmaceutical companies in India. I have worked as a SAS Programmer in this company and my job is to generate reports and establish database connections based on the client requirement.

Responsibilities:

• Responsible for Developing Database Connections.
• Responsible for day to day external database support for all the internal SAS Programmers/Developers as a SAS Administrator
• Worked on phase II of drug development process.
• Generated statistical analysis files, summary tables, listings and graphs using SAS/BASE, SAS/MACROS, SAS/GRAPH and SAS/STAT.
• Clinical dataset reports generation form data warehouse using SAS/BI
• Developed and customized reports using PROC REPORT, PROC FREQ and PROC MEANS and DATA NULL .
• Created new datasets from existing data-sets by using concatenation, merging, interleaving and using conditional statements.
• Generated routine and ad-hoc reports using PROC PRINT, PROC FREQ and PROC REPORT.
• Generated required Charts, Graphs and reports using Proc REPORT, Proc GPLOT and SAS/Graph for graphical analysis.
• Used SAS/STAT for statistical analysis like ANOVA.

Environment: VB script, Java script, C#.NET, ASP.NET, SQL SERVER 2000,SAS/BASE, SAS/GRAPH, SAS/BI, Proc TABULATE, Proc ANOVA, Proc GPLOT, Proc REPORT, HTML, Oracle 9i, UNIX and Windows NT.