SUMMARY:

• Over 8 years of experience in analysis, designing, developing, testing and implementing SAS applications for financial and insurance sectors.
• Experienced in SAS/Base, SAS/Macro, SAS/ODS, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Access, SAS/web report studio, SAS/Enterprise Guide, SAS/Connect and SAS/Enterprise Miner in Unix and Windows environments.
• Ability to analyze & process data and produce customized reports and external files using various SAS procedures like Proc Report, Proc Tabulate, Proc Transpose, Proc Format, Proc Freq, Proc Summary, Proc Means etc.
• Experience in developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Exposure on every step of entire software development life cycle (SDLC) including data collection, query, modifying and analysis, coding statistical models, summarizing the findings, and presenting the results
• Experienced in analyzing data mining, statistical analysis, statistical test, regression and report generation.
• Experience in SAS Reporting and Macro language.
• Experience in data manipulation procedures such as formats/ informats, merge, proc data sets, proc sort and proc transpose.
• Experienced in using Unix Shell scripts, Data Flux, Oracle SQL to perform ETL, data processing and automation tasks. Set up customized ETL programs for efficient and automated list processing routines with exception handling capability.
• Experience with retail data and banking data.
• Command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export.
• Experience in databases like Oracle, SQL server and Teradata.
• Experience in using ETL to load data to oracle data warehouse.
• Experience in SAS/ACCESS interface to Teradata, SAS Scoring accelerator for Teradata.
• Teradata data warehousing with focus on implementation of Teradata development environment and single - subject data warehouse in support of SAS analytics.
• Excellent interpersonal and communication skills, highly dedicated, quick starter, solution driven pattern programmer, Design and excellent at solving complex problems under strict deadlines.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/NT, XP/Vista, UNIX.

Language: SAS, SQL, C, C++.

SAS Tools: SAS/BASE, SAS/MACROS, SAS/SQL, SAS DI STUDIO SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/STAT, SAS/ODS.

SAS BI Tools: SAS Enterprise Guide, SAS Add-In to MS Office, SAS Enterprise Miner, SAS Information map studio and SAS Web Report Studio.

ETL: Teradata

Databases: MySQL, Oracle, SQL Server, MS-Access, Oracle 10g/9i/8i, Teradata.

Scripts: SAS Scripts, PL/SQL, UNIX Shell Script.

Other Technologies: Microsoft Office (Word, Excel, PowerPoint, FrontPage, Outlook)

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

SAS Programmer/Data Analyst

Responsibilities:

• Converting the codes which were written in PL/SQL, used to generate summary tables to SAS code.
• Generate reports using SAS proc report from the summary table to measure the contractual cycle time of the repair vendors, improve inventory handling/accuracy, mitigate risks associated with inventory on hand from an operational and financial perspective, to ensure that the parts are picked by warehouse personnel in a timely manner for new station setups, transfers, projects and bench stock requests, to reduce the expense of aircraft part repairs, to ensure repair vendors are complying with contractual cost commitments.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad-hoc jobs.
• Involved in scheduling the existing reports using Unix and SAS DI Studio.
• 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.
• Extensively used proc sol, proc summary, proc Contents, proc report and proc compare.
• Extensively used SAS output delivery system (ODS) to format reports, analysis and loading the data into the database.
• SAS Data Integration studio for ETL and generation of master datasets from various databases, as well as loading into different complex databases like Oracle, Teradata.
• Used SAS macros and SAS/SQL to improve the efficiency of the code.

Environment: SAS Enterprise Guide 5.1, SAS DI Studio, Oracle, PL/SQL, SAS/Base, MS Excel.

Confidential, Wilmington, DE

SAS Programmer / Data Analyst

Responsibilities:

• Gathering the input & output flow, codes that are used, vintage datasets(for reference)
• Understanding the purpose of the individual modules like Delinquency allocation, Mature outstanding, Revenue allocations etc.
• Creating a matrix that contains the entire global as well as local macro variable so that these macro variables are embedded in a launcher that produces the required results.
• Making a centralized version controls, file directories so that users from different groups can use them.
• Used SAS Macros extensively in embedding the modules which are dependent on one another and also to integrate the modules.
• SAS Data Integration studio for ETL and generation of master datasets from various databases, as well as loading into different complex databases like Oracle, Teradata.
• Using Proc SQL to create tables that contains the calculations and automating these calculations by embedding these SQL procedures in Macros.
• Adjusting the individual module codes by using DATA steps, Formats, Informats, Date Formats etc.
• Used LAG function whenever needed in calculations.
• Embedding the Proc Export for having the Excel out puts in the centralized locations.
• Debugging the code, making some test runs verifying the system resources using Fullstimer option.
• Worked on building a Scoring Engine that produces scores by integrating different modules involved in scoring.
• Bi-secting the modules in accordance with the transition matrix based on the transition states in the matrix.
• Building the modules like Import Models, making Formula, make transformation etc., that is to be embedded in the scoring Engine.
• Performing the QA at each stage in building the engine to ensure the quality of each module.
• Worked in automating the modules by carefully following the naming conventions (related to variables, transformations) and assigning suitable version controls.
• Worked in integrating the different modules by building a scoring driver so that it triggers individual modules and produce the score.
• Running the Scoring Engine corresponding to different products (cards) like Rewards, Non rewards, T&E etc., under different federal scenarios.
• Cross checking the results produced by the scoring engine by running Proc Summary and updating the remarks, if any.
• Plotting the charts across federal scenarios for different products and updating the remarks.

Environment: SAS/Base 9.2, SAS/GRAPH, SAS/MACRO, SAS/STAT, SAS server, Winscp, and MS Excel, Windows, ReflectionX, Unix.

Confidential, Columbus, OH

Sr. SAS Programmer / Analyst

Responsibilities:

• Provided programming support of ad-hoc requests and special projects as assigned.
• Automated and validated the codes for accuracy and efficiency.
• Created graph/table using proc gplot and proc report respectively for different products National HPI, Home Lending NCI and Home Lending CI as per the requirement as monitoring of independent variable in different dimension (time, scenario). HPI, NCI and CI are input variables to CCAR.
• Created overlay graphs using proc gplot to display account information from model results by developing an automated code.
• Executed the pre-developed summary code for MFM model across various scenarios like CCAR Base, CCAR Severe and ICCAP Adverse and stress scenarios to get the summary model results and then generated intended read-able reports using proc report.
• Used SAS Integration Studio to extract the data from different sources by applying filters, transformations and load data into data marts/Data warehouse.
• Monitored the loan balances of the model results for five scenarios (CCAR Base, CCAR Adverse, CCAR Severe, JPM Adverse and JPM Severe) by developing code to generate the datasets and then exporting the datasets to excel using SAS ODS.
• Wrote a code in SAS to create multiple reporting excel tabs using Excelxp tagsets.
• Manipulated data including the usage of basic standard SAS procedures and use of SAS Macros.

Environment: SAS EG 4.3, SAS/Base 9.2, SAS/GRAPH, SAS/MACRO, SAS/STAT, SAS/CONNECT, SAS/ACCESS, SAS server, Winscp, and MS Excel, Windows, Unix.

Confidential, Memphis, TN

SAS Programmer/Analyst

Responsibilities:

• Extracted raw data from the warehouse and created SAS data sets that are required for the project analysis using SAS/Access and SAS/Connect.
• Extensively used PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC CONTENTS, PROC REPORT, PROC COMPARE and PROC UNIVARIATE.
• Extensively used Teradata tables for SAS datasets.
• Wrote various SQL queries, PROC TRANSPOSE and PROC COMPARE procedures.
• Developed and improved the efficiency of programs through the use of SAS macros and SAS/SQL.
• Listings, derived datasets, and control checks. Program the integration of databases from multiple studies or sources.
• Writing Procedural Language SQL (PL/SQL) query for data manipulation and data analysis.
• Created new and modified existing SAS programs to load data from the source and create specific datasets, which are used as source datasets for report generating programs.
• Modified standard programs to generate data sets for statistical data analysis, generate listings, summaries.
• Wrote wrapper Unix Shell scripts for execution of SQL / PLSQL and SAS scripts from Unix.
• Slicing and dicing the data from unorganized data files.
• Extensively using PROC GPLOT and PROC GCHART for generating graphs and plots.
• Formatted HTML, RTF and PDF reports, using SAS Output Delivery System (ODS).
• Worked on Ad-hoc, monthly reports on a regular basis using SAS EG 4.3.
• Wrote code using SAS/Base and SAS/Macros to extract clean and validate data from flat file, Excel file.

Environment: SAS EG 4.3, SAS/Base 9.2, SAS/Graph, SAS Script, SAS server Winscp, SAS/ETL, Teradata SQL Assistant, SQL, SAS Macro Coding, Teradata, RDBMS, Toad, MS Access and MS Excel.

Confidential, Cranston, RI

SAS Programmer/Analyst

Responsibilities:

• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Extracted data from Oracle database (warehouse) using SAS/ACCESS.
• Prepared new datasets and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions and created Tables and Listings for the same.
• Also created and maintained SAS datasets that are extracted from an Oracle Database using SAS/Access for Oracle and extensively used Proc SQL to manipulate the data.
• Used Proc SQL (Pass-Through) method and Proc Append methods to write statistical analysis results to the Oracle database.
• Converted Excel tables and flat (text) files into SAS datasets for Ad-Hoc analysis.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Data analysis, reports using SAS procedures and SAS/Macros.
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining.
• Used SAS/STAT to create different statistical reports as required.
• Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes.
• Forecasted monthly, quarterly and annually customers flow and revenue for Direct Mail Marketing and Tele-Marketing campaigns using SAS and Excel.
• Performed market research and segmentation analysis using SAS, SQL and Excel to get the potential target customers and identify the market trend and opportunities
• SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.
• Developing SAS Stored Processes that can be easily used by end users using SAS Add-in for Microsoft Office and other SAS BI clients from SAS Information Delivery Portal.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Stat, SAS/SQL, SAS/ODS, MS-Office, SAS Enterprise Guide, Windows, Unix.

Confidential, Hartford, CT

SAS Programmer

Responsibilities:

• Extraction of data from Oracle, created into datasets.
• Extensively used ETL to load data from oracle, Flat files and XML as sources to Oracle Data warehouse as target.
• Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Transformations using Base SAS Procedures & Functions.
• Responsible for the cleaning, reformatting, analysis and loading the data into the database.
• 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.
• Produced RTF, MS Word and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Worked on creation of reports for business users using SAS web report studio.
• Automated the standard reporting with SAS BI and Microsoft Add-in.
• Developed SAS Macros for reduction of program length and for faster execution.
• Combined and grouped datasets using concatenation and merging.
• Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA NULL for analysis.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/ETL,SAS/Graph, SAS/SQL, SAS/ODS, Oracle 9i, PL/SQL, MS Excel, Unix, Web report studio, SAS Add-in to MS office.

Confidential

SAS programmer

Responsibilities:

• Analyzed the data based on the requirement
• Analyzed large data sets consisting of million records
• Creating a customer statistical mailing list for Direct Mailing and Telemarketing. Worked with large customer response and sales data sets.
• Maintain and enhance existing SAS reporting programs for marketing campaigns.
• Maintain SAS analysis for the products purchased every month.
• Conduct individual account and household level analysis.
• Conduct significance tests and study response rates for different level of Marketing based on the reports.
• Modified existing SAS programs and created new programs using SAS Macro to improve ease and speed of modification as well as consistency of results.
• Extracted data from warehouse using SQL procedure and created SAS data sets.
• Performed Data cleaning, Formatting, Cluster analysis, and regression analysis for normality using SAS.
• Created reports using analysis output and export them to the web to enable the Customers to have access through SAS Integration.
• Extensively used SAS procedures Print, Sort, SQL, Mean, Freq etc.

Environment: SAS/ Base, SAS/Macros, SAS/Stat, SAS/Connect, SAS/Access, SAS/Graph, SAS/ODS, Ms-Excel, Oracle 8i, Unix, Pl/SQL Developer.