Summary:

• SAS Developer with over 7+ years of experience with SAS system. 7+ years of programming/analysis experience in SAS on the UNIX, MAINFRAMES and Windows platforms.
• Created Financial and Retail Modeling Datasets. Used the procedures SQL, TABULATE, FREQ, FORMAT, and GRAPH to generate modeling reports.
• Experience in building Fraud rules, Underwriting rules, Verification Rules, Knockout rules.
• Experience with 3rd party data extraction which is used to build Credit and Fraud models.
• Created and Automated Daily, weekly, monthly, Early Warning service reports, Profitability analysis reports for Products like Pay day loans, Installment loans, Mobiloans.
• Analyzed the data for Direct mail Campaign’s, Former customers, new customers, ITA (Invitation to Approval).
• Worked with modelers in building Risk score models for controlling Fraud and increase the customer traffic.
• 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.
• Management of marketing campaigns for customer acquisitions that involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics.
• Experience in Migration of SAS to Abinitio.
• Experience in Preparing Graphs and also Knowledge in Developing Code in Abinitio.
• Generated daily, weekly and monthly reports using Proc Report and SQL.
• Strong SAS programming background for maintaining existing code, ad hoc reporting and supporting the reporting functions.
• Proficient in the following reporting, statistical procedures: REPORT, TABULATE, FREQ, MEANS, UNIVARIATE, TTEST, CORR, REG, GLM, ANOVA, LIFETEST, TRANSPOSE, COMPARE, EXPORT, COPY, CONTENTS.
• Experience in requirement gathering, analysis, planning, designing, coding and unit testing in Windows, UNIX and Mainframe environments and Business objects.
• Experience in SAS intelligence to extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and access tables
• Strong SAS Data warehouse Programming, Mainframe and UNIX experience in Banking, Financial Pharmaceutical industries.
• Additional experience includes using Base Procedures, Graph, Macros, Data Step, SQL, and Data Mining, extracting internal/external data including cleaning and validation, use of formats and in formats.
• Experienced in producing HTML, RTF, CSV and PDF formatted files using SAS/ODS.
• Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS Information Map Studio, SAS Web Report Studio, SAS/ENTERPRISE GUIDE, SAS/ENTERPRISE MINER
• Involved extensively in Data Extraction, Transformation, Loading, Analysis, and MIS Reports for Banking.
• Experience in Creating Process Flow Diagrams and Technical Specification Document Diagrams using Microsoft Visio2007
• Experience in developing complex SAS Programs, Macros for data updates, data cleansing, and reporting.
• Worked extensively on Teradata, Oracle, SQL Server, MS Access Database &Creating Korn shell scripts.

Technical Skills:

SAS Skills: SAS/BASE, SAS/GRAPH, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/INTRNET
Database: Oracle7x/8x, MS SQL Server, MS-Access, DB2, SQL, PL-SQL.
Languages: C, C++, and Oracle
GUI: SAS Enterprise Guide, Enterprise Miner
Operating: Windows (NT/95/ 98/ 00/ ME/XP), UNIX, Linux System Tools: Business Objects Reporting, Data Integrator & Set Analysis
Others: Abinitio, MS Office, MS Project, Power Point, Excel, Outlook, MS-Visio and Access.

Roles:

• SAS DEVELOPER
• Programmer Analyst
• Risk Analyst

Industry Applications:

• Financial
• Pharmaceutical
• Telecommunications

Education: Bachelor’s degree

EXPERIENCE SUMMARY:

INDUSTRY: Financial
CLIENT: Confidential
DURATION: AUG2011 - Present
ROLE: Risk Analyst/Programmer
LOCATION: Fort Worth, Texas.

DESCRIPTION: Think Finance develops next generation financial solutions to meet the unique needs of under banked consumers. Think Finance encompasses brands like Elastic, Think Cash, Payday One, Mobiloans, Presta and Spendables. It has wide range of Pay day loans, Installment loans. I was involved in Fraud Analysis, Risk Analysis, Verifications, Underwriting, and Profitability analysis. Management of marketing campaigns for customer acquisitions that involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics.

Responsibilities:

• Developed Credit policies for Underwriting, Verification and Fraud processes based on Customer data analytics. Portfolio Management for financial products including micro credit loans, revolving credit and Rent to Own.
• Created and automated reports for Daily, weekly, monthly, Early Warning service reports, Profitability analysis reports for Products like Pay day loans, Installment loans, Mobiloans using SAS Enterprise guide and MS SQL SERVER.
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.
• Formatted HTML, PDF ,CSV and RTF reports, using SAS - output delivery system ODS
• Used SAS extensively for Match merge, Append data validation, and Data correction and Cleansing.
• Generated listings and reports from SAS programs using MACROS, ODS and PROC REPORT/TABULATE and using Word, Excel and Power Point.
• Extracting data from the database using SAS/Access, SAS/SQL procedures and created SAS data sets.
• Portfolio management, Credit Risk Analytics, Portfolio tracking and reporting, creating and maintaining Credit Policies, Managing Marketing Campaigns, testing out new Champion and Challenger strategies, understanding 3rd party data etc.
• Developed and use metrics and reports to proactively identify issues impacting Fraud Team operations.
• Used data step options like KEEP, DROP, and RENAME as a part of storage efficiencies. Data set options IF, where, missover, truncover etc. were used in reading raw data files.
• Developed and Analyzed Strategies and Reports for usage in the Management of: Underwriting, Line Assignment, Existing Customer Management, Marketing Campaigns, and Collections.
• Extracted data from database using various SAS/Access methods including Libname statements and the SQL Pass Through facility.
• Created new Fraud rules, under writing rules, knockout rules, and Verification rules.
• Worked with Statisticians and Modelers in building new Risk score model, Credit Model and Fraud Model.
• Extensively worked with 3rd party data and analyzed with our production data to increase the revenue and controlling Fraud and charge off’s.
• Created Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.

Environment: Base SAS,SAS/SQL, SAS/ACCESS,SAS/MACROS, SAS/ODS , MS Excel, MS Access, MS Visio Enterprise guide, Knowledge Studio, MSSQL Server.

INDUSTRY: Financial
CLIENT: Confidential
DURATION: Jan2011 – Aug2011
ROLE: Programmer/Analyst
LOCATION: Long Island City, New york .

DESCRIPTION: Citi Group provides a comprehensive range of financial services; personal financial services; commercial banking; corporate, investment banking, Mortgage, private banking and other activities. I was involved in Migration of SAS to Abinitio, Preparing Technical Specification Documents for the Conversion Process for Various Products like Reduced Franchise Risk, CBNA, and BANAMEX and also I was involved in Generating Reports, Data Cleansing, Scripting, and Data Manipulation.

Responsibilities:

• Involved in a project for Technology Implementation and ETL tool Application change.
• Worked directly with Business owners, Business analysts and Data architects, communicating with them and understanding implications of various scenarios.
• Prepared Technical Specification Diagrams and Graphs for SAS and Abinitio using MS-Visio 2007.
• Worked on the documentation to relate it to the BRD to help recreate the entire process with any ETL tool.
• Prepared Technical Specification Documents and Technical Design Documents for SAS to Abinitio Migration.
• Prepared Source to Target Mapping Documents for Field to Field transformation at each level of modification within the SAS scripts and worked with Abinitio Developers to develop the Code.
• Prepared the corresponding Abinitio Process document to remove redundant SAS Steps.
• Designed Graphs for SAS to Abinitio Conversion which explains the Components like Filter-by Expression, Sort/Dedup sort, Gather, Joins, Replicate and Reformat.
• Served as a SME for various SAS processes across different implementation projects.
• Wrote SAS scripts to extract sample data from various CITI databases like DB2, Oracle.
• Modified / debugged existing SAS scripts to have an efficient processing system and get rid of redundant steps using SAS Enterprise guide, BaseSAS and SAS Macros.
• Automated the Process of Data extraction and conversion into CSV, TXT and XLS format by writing Korn Shell scripts and scheduled the Jobs using Autosys.
• Created some scripts in UNIX for File Transfer from one Server to Other using SFTP and Winscp.
• Analyzed existing SAS scripts based of off various platforms such as UNIX, Windows and Mainframe.
• Also worked on analysis of JCL scripts for IBM MVS Mainframes to understand different Procs and Jobs executed.
• Worked with Cross functional teams from Business intelligence management, Technology management and Project management domains.
• Worked in an Onshore-Offshore model working with local client employees as well as global associates.
• Worked on Different Products like Reduced Franchise Risk, Mortgage Risk, BASEL Submissions, FICO SCORING etc., For CITI BANK NORTH AMERICA AND MEXICO OPERATIONS.
• Used the Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access)
• Developed reports as per business requirements and created various reports like Summary reports, Tabular reports etc.
• Involved in working with Access Datasets and VB scripts.
• Extracted data from Oracle views using various SAS/Access methods including Libname statements and the SQL Pass Through facility.
• Used data step options like KEEP, DROP, RENAME, IF, WHERE, COALSECEC, when reading raw data files.

Environment: Base SAS, Abinitio, SAS/SQL, SAS/ACCESS,SAS/MACROS, SAS/ODS , FTP, Korn shell, MS Excel, MS Access, MS Visio Unix, Enterprise guide, WINSCP.

INDUSTRY: Communications
CLIENT: Confidential
DURATION: May10 – Jan2011
ROLE: Programmer/Analyst
LOCATION: DALLAS, TX

DESCRIPTION: Avaya Inc. is a privately held telecommunications company which specializes in enterprise network, telephony, and call center technology. I was involved in Data cleaning, Data manipulation, Requirement gathering, Generating Reports, Statistical analysis, Data analysis, worked on Companies customer details, Profits, Selling, Resellers, Distributors.

Responsibilities:

• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE AND DATA_NULL_ for analysis.
• Used the Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access)
• Developed reports as per business requirements and created various reports like Summary reports, Tabular reports etc.
• Provided Efforts Estimate and coordinated the test schedule using Agile testing methodology in UAT phase.
• Created stored processes and stored them on BI metadata server.
• Created Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.
• Performed Statistical Analysis with Statistical procedures and Univariate procedures from Base SAS and SAS/STAT.
• Used SAS Data Integration Studio to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into Data marts and Data warehouse database.
• Used Data _Null_ and SAS procedures such as Report, Tabulate, Freq, Means, Summary and Transpose for producing customized reports using SAS Web Report Studio.
• Performed Sorting and Merging of data and generated CRT's, tables, listings and graphs using SAS/Base, SAS/Stat and SAS/Graph, SAS/SQL.
• Used Enterprise guide 4 to write the stored procedures, Generate Reports and also performed Data and Statistical analysis.
• Used Enterprise miner for data mining in Marketing and fraud detection.
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistency of results.
• Provided all data analysis, ad-hoc and custom reporting of customer data. This involved extracting data from an Oracle database, XML files, Flat files data used as input for SAS programs to create Excel spreadsheets, Access databases, and hard copy reports.
• Extracted data from Oracle views using various SAS/Access methods including Libname statements and the SQL Pass Through facility.
• Used data step options like KEEP, DROP, RENAME, IF, WHERE, COALSECEC, when reading raw data files.

Environment: Base SAS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/MACROS, SAS/ODS, FTP, MS Excel, UNIX, Main frames, Enterprise Miner, Enterprise guide.

INDUSTRY: Mortgage
CLIENT: Confidential
DURATION: Feb 10 – May10
ROLE: Programmer/Analyst
LOCATION: DALLAS, TX

DESCRIPTION: Fannie Mae being a government-sponsored enterprise (GSE) provides loans to mortgage bankers, brokers and other primary mortgage market partners where I was involved in working on Appraisal reviews, Underwriting reviews and Repurchasing requests and reporting on summary information involving groups of documents and also I was involved in generating Ad hoc reports providing the Loan level details, Daily, Weekly and Monthly activity reports, Lender notification reports and also gathering the requirements

Responsibilities:

• Involved in running summary reports concentrating on Quality Control information.
• Worked with NUC managers to obtain and process reporting requirements and to handle Ad hoc reporting requests.
• Used PC SAS to manipulate smaller pools of data as well as UNIX to extract and manipulate data stored in Oracle tables.
• Acted as a resource to team in providing SAS programming support as well as completed any Additional tasks needed to meet project deadlines.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE AND DATA_NULL_ for analysis.
• Built a Data warehouse and Data marts that integrate the extracted data
• Developed reports as per business requirements and created various reports like Summary reports, Tabular reports etc.
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.
• Formatted HTML, PDF ,CSV and RTF reports, using SAS - output delivery system ODS
• Used SAS extensively for Match merge, Append data validation, and Data correction and Cleansing.
• Generated listings and reports from SAS programs using MACROS, ODS and PROC REPORT/TABULATE and using Word, Excel and Power Point.
• Extracting data from the database using SAS/Access, SAS/SQL procedures and created SAS data sets.
• Creating Customized reports and Stored processes in Enterprise Guide for the users
• Used data step options like KEEP, DROP, and RENAME as a part of storage efficiencies. Data set options IF, where, missover, truncover etc. were used in reading raw data files.
• Conducted and generated Daily, Weekly and Monthly statistical reports based on the routine analysis in Dashboard using Business Object.
• Generated Lender Notification reports, Loan level details, Inventory, Repurchase, Rebuttal, and Aging reports.
• Migrated data from Windows to Unix (P2 and P7) environments.

Environment: Base SAS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/MACROS, SAS/ODS, Business Objects, MS Excel, UNIX, Enterprise Miner.

INDUSTRY: Banking
CLIENT: Confidential
DURATION: Jan 09 – Jan10
ROLE: Developer/Analyst
LOCATION: NEWYORK, NY

DESCRIPTION: Morgan Stanley provides a comprehensive range of financial services; personal financial services; commercial banking; corporate, investment banking and markets, private banking and other activities. I was involved in performing complex analysis that maximizes profits and/or asset growth and minimizes operating losses. I was also involved with the update and maintenance of the Data warehouse and generation of various reports. Data is loaded from database into SAS datasets, and Reports were generated. The system maintains the company income and expenditure details and it also generates detailed reports regarding financial transactions, sales details, and purchase details, operating costs.

Responsibilities:

• Used SAS Macros and procedures like Proc SQL, Transpose, Univariate, Means, Freq Performed statistical analysis using One-Way ANOVA
• Developed SAS macros for Data cleaning, Data mining and Reporting and to support routing processing
• Formatted HTML, PDF ,CSV and RTF reports, using SAS - output delivery system ODS
• Extraction of data from Data Ware housing tables and Data marts
• Modifying data using SAS/BASE and Macros.
• Gathered the requirement business team and analyzed the data.
• I used programming tools such as SAS Data Integration Studio (formally known as SAS ETL Studio), SAS BASE V9.1.3 (Windows and UNIX), SAS Enterprise Guide V3, SAS MACRO, SAS ACCESS, SAS Information Map Studio, Enterprise Miner, SAS Web Report Studio, PROC SQL, SAS SQL-Pass Through, Oracle9i, Teradata, Microsoft Excel, Microsoft Word.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools–SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Automated creation of Daily, Monthly and Quarterly UFF files to support My Field-Point Analytics by SAS Macro variables and SAS Macros and Stored Processes.
• Creating Customized reports in Enterprise Guide for the users
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.

Environment: Base SAS, OS Windows, SAS/SQL, SAS/GRAPH, MS Excel, UNIX, Enterprise guide, Enterprise miner.

INDUSTRY: Banking
CLIENT: Confidential
DURATION: Sep 07 - Jan 09
ROLE: Programmer/Analyst
LOCATION: Charlotte, NC

DESCRIPTION: Bank of America provides a comprehensive range of financial services; personal financial services; commercial banking; corporate, investment banking and markets, private banking and other activities. I was involved in Performance Reports, Capacity planning and Analysis and generated reports for online and batch applications for various servers. Used SAS system as front end tool to create datasets and used SAS/GRAPH to create charts showing performance. Monitored and Analyzed Bank and Cards application usage. Data Tables and reports results on account/household values and customer profiles are obtained by merging and summarizing data using SAS.

Responsibilities:

• Modified data using SAS/BASE and Macros.
• Employed techniques like sorting and merging on the raw data sets and coded them using Proc SQL and SAS Macro facility to get the required output
• Prepared graphs using the modified data for business analysis.
• Creation of Data Sets on the Remote Server.
• Used shell programming to run weekly and monthly reports
• Used SAS/ACCESS to gather data from RDBMS like TERADATA and DB2
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used time to time and created tables, graphs and listing reports
• Used SAS Data Integration Studio to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into Data marts and Data warehouse database.
• Extracted data sets from server using PROC IMPORT and created datasets in SAS libraries.
• Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.
• SAS scripts on Unix are run, and the output datasets are exported into SAS.
• Created charts showing performance using SAS/GRAPH.
• Monitored and Analyzed Bank and Cards application.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Maintained SAS statistical analysis for the products purchased every month.
• Run reporting programs and download the results into EXCEL and build pivot tables.
• Presented the results and statistical reports in PowerPoint for marketing staff.
• Moved data set across platforms (from PC and Mainframe to UNIX and Vice Versa).

Environment: BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ STAT, SAS/CONNECT and SAS/ACCESS, DB2, Teradata, PL/SQL.

INDUSTRY: Health Care-Pharma
CLIENT: Confidential
DURATION: SEP 06 - AUG07
ROLE: Developer
LOCATION: New Jersey.

DESCRIPTION: BMS is a Biopharmaceutical company developing products designed to improve the safety of the world’s health in Oncology and is conducting Phase III clinical trials. As a SAS Programmer, my role was in analysis of clinical trials data and generating required reports, listings, summaries and graphs for submission to FDA and other regulatory authorities.

Responsibilities:

• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis. Analyzed Phase I, II and III Clinical Trials.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Reading the raw clinical data (weekly and monthly), validating, manipulating, sorting, and merging the data. Generate summary tables, patient listings and develop different types of statistical reports by using different types of procedures. Extracted data from DB2 and Teradata tables
• Data integration of different individual Business units to create appointment date file by using Macros, Data steps, Match Merge and Hash-look up
• Coded SAS programs to manipulate and produced the custom reports. Developing the reports in Business Objects using complex SQL queries & materialized views
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and Debugged existing macros.
• Generated Tables, Graphs and Listings for inclusion in Clinical study reports and regulatory submission; Participated in preparing study results as well as ISS and ISE for FDA submissions using SAS.
• Extracting data from the database using SAS/Access, SAS /SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access.

Environment: Windows 2000, SAS 8.2, SAS/Macro, SAS/STAT, SAS/ACCESS, Enterprise Miner, SAS/CONNECT, SAS/ODS, SAS/SQL.

INDUSTRY: Health Care-Pharma
CLIENT: Confidential
DURATION: SEP04– JAN06
ROLE: SAS Developer
LOCATION: India.

DESCRIPTION : Worked with Non-clinical statistics unit of pharmaceutical company, developing computer programs to do the Statistical analysis of product sales, performance of sales department, regional sales, Monthly, Quarterly and yearly sales reports. The incentive compensation was taken care of in this project and the profit forecast was also done

Responsibilities:

• Extensively involved in Oracle PL/SQL programming to create Triggers, database Packages Procedures/Functions etc. Creation of database objects like Tables, Views, and Synonyms etc.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Transferring and Migrating data from one platform to another to be used for further clinical analysis.
• Extracted data from Oracle using SQL Pass through facility and generated ad-hoc reports.
• Prepared, documented and tested required programs and procedure data displays in an efficient manner for inclusion in integrated Clinical, Statistical summary reports and other reports. Supporting other team members in designing and developing programs.

Environment: SAS V6.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, Oracle7.3 and UNIX.