SUMMARY

• SAS Certified Base SAS Professional with 7 years of experience in data analysis and statistical modeling including data extraction, manipulation and validation techniques, writing macros and reporting on various projects for financial industry using SAS and its tools.
• SAS professional in developing statistical methods routinely used in Financial/Mortgage/Education/Telecom/Sales and Marketing data analysis.
• Data preparation for various statistical modeling which includes data cleaning, descriptive analysis, missing data analysis, data validations, data triangulations and preliminary data reporting.
• Proficiency in writing maintainable, flexible and well - documented SAS codes using DATA step and PROC step.
• Understanding and proficient use of various procedures like proc SQL, proc report, proc freq, proc means, proc contents, proc dataset, proc append, proc import, proc export, proc print, proc sort.
• Experience in SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/SQL.
• Skilled in SAS programming, merging SAS datasets, SAS formats and Managing data.
• Experience in using report generating procedures like PROC CONTENTS, PROC PRINT, PROC UNIVARIATE, PROC SUMMARY and PROC TRANSPOSE.
• Experience in dynamic programming and list processing using SAS/MACRO.
• Experience in using SAS/GRAPH procedures like PROC GPLOT, PROC GCHART and PROC BOXPLOT.
• Experience in using the ODS facility to create HTML, RTF, XML and PDF files.
• Experience on validation of reports and SAS programs Professional debugging
• Have strong knowledge about drop, keep, retain, and date manipulations, formats, in formats.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Hard working, ethical and highly result oriented. Ability to quickly grasp and apply new concepts and technologies.
• Strong leadership, interpersonal and oral/written communication skills.
• Ability to work independently as well as collectively.

TECHNICAL SKILLS

SAS Tools: SAS 9.1.3 / 9.2 /9.3, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS Enterprise Guide

Languages: Minitab, SPSS, C, C++, Java, SQL

Databases: Access, SQL-Server

Package: MS office 97/2000/2003/ 2010, Word, Excel and PowerPoint

Operating System: Windows 98/95/2000/XP/Windows 7/ Windows 8

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. SAS Programmer

Responsibilities:

• Create complex SAS algorithms to identify opportunity for various research projects.
• Provide analytical and technical support for professors and projects in their research.
• Develop end-to-end reporting based on business requirements using SAS views from database tables usingSAS/ACCESSand writing SAS programs usingBASE SAS and SAS MACROS to create SAS reports.
• UtilizedSAS PROC SQLPass through facility for data extraction, location and retrieval from the database.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs forData Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• UsedSAS procedures (FREQ, SUMMARY), SAS functionsand user defined macros to test the accuracy and validity of data.
• Solve complex issues and implement solutions to enhance productivity, improve quality and customer satisfaction.
• Generated output files in text format,CSV, HTML & PDF format using SAS ODS.
• Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action plan.
• Work with research scholars to help in their projects and other research projects.
• Conduct code review and testing of final results to ensure the work delivered by the team is of high quality standards.
• Performed Data validation, data integrity and data profiling on the data
• Work with the Business Analyst in process improvement initiatives as directed by the business.

Environment: SAS/BASE 9.3, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/EG, SAS/ODS, SAS/ACCESS and MS Access Database.

Confidential, Chicago, IL

SAS Analyst

Responsibilities:

• Investigated missing data and the data anomalies by creating edit checks for SAS data sets imported from databases and other servers.
• Worked with business to gather requirements to create business requirement specifications for tables, reports, listings, and graphs.
• Extracted raw data from various data sources and to create datasets for all programmers in standard locations.
• Created data for dashboard, reports, analysis datasets, and graphs using SAS.
• Extensively usedDATA NULL, TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL and GPLOT procedures.
• Provided programming support to compress data from a multiple sources for each subject into a single table usingArraysandDo Loops.
• Manipulated large data sets. Increase programs efficiency. Responsible for data entry and conversions, data validation and corrections.
• Perform analysis of data for use in Cross-selling, created graphs usingPROC GPLOT, GCHART. Created and updated permanent SAS formats for future analysis and reports.
• Created derived and analysis datasets which are one proc way for any statistical procedures to create listings or reports. Hundreds of new variables are derived using various functions and other techniques in SAS.
• Used variousPROC SQLtechniques to update datasets, combine, and join various datasets.
• Created newmacrosand updated existing macros in the current macro library to improve efficiency of old SAS programs.

Environment: SAS9.2, SAS/ODS, SAS/EG 4.2, SAS/Macros, SAS/Graph, SAS/Access, MS Excel, MS Access, Windows.

Confidential, Fort Worth, TX

SAS Developer

Responsibilities:

• Developed and designed analytics reports using SAS 9.2 and Enterprise Guide 4.2
• Developed Analysis, Strategies, and Reports for usage in the Management of Underwriting,Line Assignment, Existing Customer Management, Marketing Campaigns, and Collections.
• Utilized database management, reporting, and analysis software to store, organize, and manipulate data from Reporting and Production databases.
• Involved to relate technical concepts to SAS System applications and Business and Marketing user needs.
• Utilized advanced statistical software to develop Analysis, Strategies, and Reporting Capabilities.
• Worked with Fraud Analytics to develop new and modify existing process documentation and templates in implementation of fraudrisk controls and reporting.
• Developed sophisticatedriskstrategies, and analyze and mitigate fraudriskby identifying the risks associated with online customer originations, authentication and product usage.
• Provided insightful and analytic based recommendations that consider fraud exposure, customer service, and operational impacts.
• Written SAS reports to Excel, the SAS content server, HTML, and PDF
• Generated reports, graphs and presentations with recommendations from post campaign analysis and enhancement of future campaigns
• Involved solving large systems and analysis of massive data
• Analyzed the database schema and extracted the performance data from the MYSQL server.
• Prepared and Delivered Dashboard reports on the basis of analysis of revenue assurance report received from various operations of the company and consolidating the result for management reporting using SAS, Macros, Pivot tables, Charts, Data Validation.
• Marketing Campaign Report analyzing the reasonableness and profit potential of the user’s campaign assumptions. This tool also allows users to analyze more than one marketing campaign to compare among them, the one that would be the most successful for their business.
• Involved with Fraud, Waste and Abuse analysis in the Financial payer space
• Process improvement via project management to include data gathering, analysis of situation or data, scenario creation, ROI evaluation, and reporting on recommendations to management
• Created a demographic analysis of the online customers to describe the population and its characteristics, such as average education level, average age, income level, Email Provider, and other characteristics.

Environment: SAS 9.2 version, SAS/Base, SAS/Stat, SAS Macros, SAS/Graph, SAS/SQL, SAS/Reports, SAS Enterprise Guide 4.3, MySQL, MS Excel.

Confidential, Dallas, TX

Programmer/Analyst

Responsibilities:

• Extensively used procedures likePROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATEandPROC REPORT.
• Creating permanent formatted SAS data sets and developed reports usingPROC REPORT, PROC TABULATE AND DATA NULL for analysis.
• Used theImportandExportfacilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access)
• Developed reports as per business requirements and created various reports likeSummary reports, Tabular reportsetc.
• Created Macros and developed SAS Programs for data cleaning, Validation AnalysisandReport generation using newly created as well as existing macros.
• Performed Statistical Analysis with Statistical procedures and Univariate procedures from Base SAS.
• Used SAS procedures such asReport, Tabulate, Freq, Means, Summaryand Transposefor producing customized reports.
• PerformedSortingandMergingof data and generated CRT's, tables, listings and graphs using SAS/Base, and SAS/Graph, SAS/SQL.
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistency of results.
• Used data step options likeKEEP, DROP, RENAME, IF, WHERE, COALSECEC, when reading raw data files.

Environment: SAS 9.2, Base SAS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/MACROS, SAS/ODS, MS Excel.

Confidential, Baltimore, MD

SAS Programmer

Responsibilities:

• Used programming tools such as SAS/Base, SAS/Macro, PROC SQL, and Microsoft Excel etc.
• Developed validated and maintained SAS programs for validation, manipulation, analysis and reporting of large volume of data as per the business requirements.
• Modified data in several ways using various procedures like Proc transpose to obtain the desired format.
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistency of results.
• Created SAS data sets by extracting data from Oracle tables via an ODBC connection using LIBNAME.
• Verified and validated data accuracy to improve the overall accuracy of customer records, product data and other information.
• Worked on resolving production issues, debugging procedures for existing SAS code.
• Generated highly customized reports using PROC FORMAT, PROC REPORT, PROC TABULATE and ODS HTML

Environment: SAS 9.1.3, SAS/Base, SAS/MACRO, SAS/ODS, SAS/ ACCESS, SAS/SQL, Oracle 9i, SQL Server, MS Excel, DDE Windows XP/2000.

Confidential, Los Angeles, CA

SAS Programmer

Responsibilities:

• Involved In SAS Assessment.
• Responsible For Coordination between Client and Offshore Team from Client Location.
• Responsible for Requirement Gathering, Analysis, Development, Testing and Maintenance of the Report to be written using SAS.
• Responsible for Testing New Marketing Database with the use of Prior Knowledge of Analytix Acquired during Report Development.
• Preparing for the new changes to be implemented in Production.

Environment: SAS 9 version, SAS/Base, SAS/Stat, SAS Macros, SAS/Graph, SAS/SQL, SAS/Reports, PROC SQL, PL SQL.

Confidential

SAS Developer

Responsibilities:

• Involved in functional analysis and gathering the information from client as per the project requisites.
• Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.
• Ability to dig into raw data to find and evaluate actionable insights that will help the organization.
• Analyze and interpret significant results based on data summaries.
• Provide insightful analytics, strategy development and reporting to support Risk analysis Operations.
• Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs.
• Used various procedures such as Proc Tabulate, Proc Means and Proc Report to generate tables, listings, graphs and reports.
• Develop new macros for report generation using SAS/Macros as per the customer’s requirements.
• Used SAS/ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Retrieving Millions of Records Using different Procedures.
• Developed various SAS reports for Survey project and involved in code reviews for all the developed reports

Environment: SAS/BASE, MACRO, SAS/SQL, SAS/ACCESS, Shell-script, MS-Office 2003.

Confidential

Trainee/ SAS Developer

Responsibilities:

• Involved in functional analysis and gathering of the data as per the project requisite.
• Extracting data from SQL Server into SAS data files using SAS SQL
• Developing application for cleaning and scrubbing the data.
• Involved in development and enhancement of SAS programs.
• Generated graphs using SAS/GRAPH.

Environment: SAS/SQL, SAS/MACRO, SAS/BASE, SAS/GRAPH, SQL-Server, MS-Excel, MS-Access.