SUMMARY:

• Hands - on working experience in Financial companies (Credit card and Banking) in the area of, Risk Analysis, credit scoring and Collections, Fraud Analysis, Fraud Strategies and Mortgage analysis and Statistical Modeling.
• Hands-on experience Healthcare industries (PBM and Retail) and Pharmacy industries (Clinical analysis and Statistical Modeling ).
• Used ETL tools to build operational reports financial, health care reports (tables, lists and Graphs).
• Designed, developed, analyzed, and documented business requirements in using SAS, SQL, TERADATA and Unix.
• Extensively worked in SAS programming (Advance and Base) for reporting and automations of SAS jobs.
• Work experience in analyzing customer data (Data mining, Data integration, Data cleaning, Data modeling, Data migration, extracting internal/external data).
• Working knowledge of SQL, large relational database databases and querying (SQL Oracle, SQL Server and Teradata) and Data ware housing and Business intelligence department.
• Handled applications independently in development and production environment and Debugging and fixing code errors and participated test execution cycles. Worked with Excel and Power point.
• Interact with teams independently and mentoring. handled projects and demonstrated project management skills, including ability to prioritize, meet deadlines and follow through on completion of high-profile projects.
• Supported multiple projects, highly adaptable in quickly changing technical environments with very strong organizational and analytical skills. Work experience Implementing software development lifecycle policies and procedures.
• Working Knowledge of R programming and SAS Administration tasks. Knowledge of visualization tool - Tableau
• Strong communication (oral and written)interpersonal, presentation and organization skills with Positive attitude with work.

TECHNICAL SKILLS:

S TAT Tools: SAS EG, SAS 9.2,9.3/9.4, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/FM, SAS/GRAPH, SAS/ACCESS, SAS/REPORT, SAS/SQL, SAS/CONNECT, SAS/ODS, SAS / ETS, SAS/DI,SAS Grid Manager, R, Python

Languages: VBA, SQL, PL/SQL, JAVA Script, VB Script, HTML and XML

BI Tools: Tableau

Design Tools: MS -VISIO, MS Power point

Database: Oracle, SQL, Teradata,DB2 and Hadoop

Operating System: Windows (/NT, Windows 7), UNIX (Sun Solaris, AIX, HP-UX), SAS in Linux.

Software: Microsoft Office (Excel, Pivot Tables, Access, Word, Power Point), Version control, Autosys and Clear Case

PROFESSIONAL EXPERIENCE:

Confidential,Riverwood,IL

Proj. Manager

• Wrote complex Teradata, SQL queries to extract data from TERADATA/SQL Assistant for analytical reporting, automation and scheduling the jobs for fraud analysis and strategy.
• Used advanced techniques to develop SAS programs to run efficiently without production time loss and to increases organizational efficiencies.
• Developed SAS programs to run automated jobs to generate collections summary reports (Excel spread sheets) for pay incentives to agents for Compliance collections data. Used SAS procedures like proc Rank, proc summary and proc report for data analysis.
• Developed BTEQ scripts to run automated jobs to generate collections summary reports (Excel spread sheets) for pay incentives to agents, fraud calls and fraud accounts,. Used SAS procedures like proc Rank, proc summary and proc report for data analysis. Moved data from Teradata to Oracle using SAS coding.
• Invoked Teradata SQL queries into SAS files to generate automated processed reports. Validated Teradata analysis datasets. Produced Excel outputs. Developed SQL queries to validate data and identify for new outliers.

Environment: SAS EG 5.1, SAS/STAT, SAS/FM/AIX UNIX, Windows 7.0, Microsoft Excel, SAS 9.4, Oracle, SAS Grid, Teradata and SQL assistance.

Confidential,Northbrook, IL

Sr. SAS/Teradata Programmer

• Responsible for designing programs in SAS and SQL for Medicare Part D EMTM model.
• Wrote complex SQL queries using TERADATA/SQL for Analysis of databases Health care claims, insurance claims, pharmacy claims data and PBM data.
• Wrote Teradata SQL Queries to create, update and modify the analytical data sets.
• Responsible for project design, specifications and implementation of the project and business rules.
• Responsible for Creation of Teradata tables, Data lode, Data cleaning and Data modeling
• Responsible for Enrolment and Encounter data weekly and quarterly production submissions to CMS.
• Involved day to day business meetings and weekly performance meetings.

Environment: SAS EG 5.1, AIX UNIX, Teradata (PBM), R, R Studio, Tableau and SQL assistance.

Confidential,Deerfield, IL

Sr. SAS Specialist

• Worked as a Production support lead analyst in Confidential Specialty RXs sales and operation’s team to generate Monthly, Weekly and Quarterly reports timely.
• Generated Retail central files reports (RCFs), Monthly Performance and BI dash boards.
• Developed programs using SAS, SQL, BASE SAS and SAS Macros and debug/enhance existing programs. Good understanding of data Models and ETL processes.
• Wrote complex SQL queries using SAS SQL and Analysis Databases Health care claims, insurance claims, pharmacy claims and PBM data. Testing- EDW database and BI reports for user acceptance test (UAT).
• Worked in Data Profiling, mapping and Validate data using data using SAS and EXCEL.
• Lead, Guide and Maintained offshore team and assigned tasks as per business requirements. and make sure to submit participated business meetings and performed as SAS administration tasks.
• Presented the results and statistical reports in PowerPoint for marketing staff.

Environment: SAS EG 5.1, SAS/STAT,AIX,UNIX SAS DI, Windows 7.0, Microsoft Excel, Power point, SAS 9.4, Oracle, IMS Health, Teradata (PBM), SCM, and SQL assistance.

Confidential, IL

Sr. SAS/Unix Programmer(Global Risk Management and Analytical System)

• Developed data model programs for retail business scoring model system to run monthly reports and CA reports using SAS and Unix programming and Portfolio Reporting and Analysis.
• Developed projects in UNIX (AIX) and Shell Scripting, Base SAS and SQL for SMMS. Experience in creating, editing Macro, and stats procedures (e.g., Proc summary, proc mean and Proc freq).
• Responsible to develop SAS programs to run Analysis reports on lending data, using SAS Regression Modeling procedures proc logistic regression and proc reg. Coded programs for data analysis for descriptive and predictive analysis.
• Developed Data Analytics reports, specifically for fair Lending data for identifying significant new outliers and for Risk factors in the data. Generated graphs for different focal points (Actual vs calculated approval rate).
• Understand the Data and identified potential outliers within the regression models that pertain directly to fair lending principles.
• Identified and escalated compliance and fair lending risk within the organization to achieve strong compliance results and ratings.
• Generated summarized and metrics datasets and text files to load data into ORACLE for the backend data of the(SMMS) scoring management system.
• Developed SAS programs for delivery of process improvements and performance.SAS Array processing, risk dimensions.
• Collaborated with the internal and external business partners to provide standard and ad-hoc reporting and data extract support.
• Created summary data by using Proc summary, proc report and Proc SQL procedures for scoring system. Expertise in relational data base concepts. Customer segmentation, productive modeling and customer analytics.
• Created several flat files with good and bad separation with summarized counts and with derived flag variables for Observational and Monthly performance reports.
• Monitored jobs scheduling tolls and fixed monthly production issues. Validated master datasets by using proc compare procedure.
• Used system macros and customized macros variables to pass the values (Ex. dates) to run the jobs (Business models) monthly and weekly basis.

Environment: AIX 6.1(AIX 64), SAS/STAT 12.1, SAS/ETS 12.1, SAS/OR 12.2, SAS/QC 12.1, PL/SQL, SAS EG, ORACLE Windows NT, Java, Autosys. And Clearcase, SAS/QC, SAS EG, Excel, SAS/GRAPH

Confidential,Round Lake, IL

SAS Programmer Analyst (Statistical development and Operations)

• Responsible for developing SAS Programs to generate business and statistical reports like tables, lists and graphs using Health care data, pharmacy data, prescriber data.
• Transferring and migrating data from one platform to another to be used for further clinical analysis using SQL Pass through facility
• Designing, coding and testing SAS Macro libraries to be used for development standardization.
• Used several base and advanced sas procedures like Proc SQL, Tabulate, Format, Proc logistic, Proc Reg, Proc mixed, Proc glm and Graph etc.
• Development SAS edit checks for data cleaning. Model builder and written SQL Queries.
• Involved in discussions with statistician participated in Project meetings and Managed relationship with business partners.

Environment: ORACLE(Clinical) SAS EG, SAS BI, SQL, Excel, SAS 9.2 SAS/BASE, SAS/ACCESS, SAS/MACROS, SAS/STAT, SAS/GRAPH, WINDOWS.

Confidential,Morrisville,NC

Statistical Programmer

• Worked on Pfizer CDARS system for creation of tables, listings and figures of for phase I-III submissions of therapeutic areas like Oncology and Alzheimer’s disease clinical studies for regulatory submissions.
• Responsible for Ad-hoc report requests. Expertise in using SAS macros for and SQL and advanced SAS procedures for developing reports in PDF and RTF outputs.
• Worked with Advanced Statistical Model SAS Procedures for data reporting, and performed statistical operations like Proc GLM and Proc T-test. and SAS macros and SAS SQL
• Created SAS data sets by extracting data from Oracle database and flat files using Proc SQL,
• Developing programming documentation including specifications, as appropriate.
• Performed data extractions from OC views in to SAS datasets in the production environment.
• Worked in integration of study protocols SCE and SCS and pooling of data.

Environment: SAS 9.1/9.2,SAS EG, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH,Pc SAS.ORACLE (Clinical)

Confidential,Kalamazoo,MI

SAS Programmer/Analyst

• Responsible for providing clinical SAS programming and analysis support for Oncology clinical studies across multiple protocols and phases in the Pfizer CDARS system.
• Responsible for Data extraction, reporting and complex analytical support for customer needs using SAS datasets, flat files and Access databases. Redesign processes to make them more streamlined and efficient utilizing technologies such as SAS, VBA and .Net
• Extensive use of Proc SQL to perform queries, join tables. Provide data support for business decisions Data Analysis. Debugging, and validating the project-specific SAS program

Environment: SAS 9.1/8.0, Windows NT, AIX UNIX, Excel, Access and Oracle(clinical)