SUMMARY

• 12 years of experience as a Sr. Programmer Analyst/Consultant in design, developing, enhancing with product development analysis, statistical and Data modeling, Predictive modeling operational risk and reporting using SAS, SQL, Oracle, Teradata and on Unix and Windows environment with good communication and interpersonal skills. Seeking for a lead role in a reputed organization to grow in my carrier.
• 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). Worked with SAS management and SAS Data integrations studio.
• 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 andanalytical skills . Work experience Implementing software development lifecycle policies and procedures.
• Working Knowledge of R, Tableau and also performed SAS Administration tasks.
• Strong communication (oral and written)interpersonal, presentation and organization skills with Positive attitude with work.

TECHNICAL SKILLS

STAT 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 3, Python 3

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

Sr. SAS/Teradata Developer

Responsibilities:

• 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

Responsibilities:

• 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.
• Developed R scripts to perform statistical analysis and 3rd party data validation process.
• Responsible to create pie charts for categorical variables, histograms for quantitative variables, bar charts, line charts and scatter plots using packages.
• 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 3.0, R Studio, Tableau and SQL assistance.

Confidential, Deerfield, IL

Sr. SAS/Teradata Specialist

Responsibilities:

• 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.
• Developed tableau dashboards for data visualization for marketing analysis BI data.
• 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, Tableau, Teradata (PBM), SCM, and SQL assistance.

Confidential, Chicago

Sr. SAS/Unix Programmer

Responsibilities:

• 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.

Confidential, Elk Grove, IL

Sr. SAS/Unix Programmer

Responsibilities:

• 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).
• 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/Oracle Programmer Analyst

Responsibilities:

• 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. Worked with other programmers, researchers, and statisticians.
• 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

Clinical Statistical Programmer

Responsibilities:

• 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.

Confidential, Kalamazoo MI

Clinical SAS Programmer/Analyst

Responsibilities:

• 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 on Oracle(clinical), join tables. Provide data support for business decisions Data Analysis. Debugging, and validating the project-specific SAS program

Confidential, Wilmington, DE

Web/SAS Developer

Responsibilities:

• Developed active server pages for policy and procedure pages.
• Wrote complex SQL queries to extract data from ORACLE for analytical reporting, automation and scheduling the jobs for fraud analysis and strategy.
• Created reports for online and batch applications for various servers.
• SAS scripts on MF are run, and the output datasets are exported into SAS.
• Maintained and enhanced existing SAS reporting programs.
• Moved data set across platforms (from PC and Mainframe to UNIX and Vice Versa).