Specific Expertise:

• 6 years of extensive experience as a SAS developer in data analysis and application development, in Windows, and UNIX environment.
• Experience in Extraction, Transformation, and Loading ETL of data using SAS.
• Experience in developing SAS Procedures, Macros, Report formatting, and Exporting, and Batch Processing
• Expert in data management such as joining data sets, indexing, data aggregation.
• Excellent programming skills in SQL, and UNIX Shell Scripting.
• Expertise in using Relational DBMS like Oracle, DB2, Sybase, and Teradata.
• Expertise in using Teradata SQL assistant and SQL plus and for writing queries to pull the data from different tables.
• Excellent problem solving skills for delivering useful and compact solutions.
• Goal oriented professional and can work best both in a team and as an individual.
• Experience in communicating with members across different teams in order to gather requirement and specification for the successful completion of the project.

Technical Expertise:

• SAS Tools: SAS 8.2/9x, SAS/ACCESS, SAS/SQL, SAS/Connect, SAS/ACCESS, SAS/GRAPH
• Database: Oracle, DB2, Sybase, Teradata, MS Access
• OS: Sun Solaris 9, UNIX, Linux. Windows Vista, Window XP/2000, Windows NT 4.0
• Languages: SQL, HTML, PL/SQL, C/C , VBA Excel
• Script Languages: UNIX Shell Script Korn Shell .
• Version control: Clear Case and Clear Quest, PVCS
• Other Tools: MS Office 2007, MS Visio, Auto-cad, Mat Lab.

Professional Experiences:

Confidential

SAS Developer

• Extensive use of Base SAS for Data Set creation and generating reports in HTML and PDF.
• Extensive use of SQL for Queries, data set joins and SAS Merge.
• Work on analyzing marketing response flat files. Write SAS program to change these flat files to SAS data set so that they can be uploaded to response database.
• Use Wachovia marketing flat files to generate various reports to target list of a direct mail and telemarketing customers using SAS system.
• Write many SAS programs to create audits and frequency report in order to check the accuracy of the report.

Environment: SAS 9.1, SQL, Windows XP, Excel.

Confidential

SAS Developer/Analyst

• Loss Forecasting Team predicts the loss that Fannie Mae may incur in next five years based on historical data, various interest rates, historical and current home prices. LFM takes the present book, plus estimated acquisitions and simulates the migration of each loan month by month from its present state through stages of current or delinquency to a forecast end state of prepayment, default or still on the book.
• Develop SAS programs with the use of Base SAS and SAS/Macros, SAS/SQL and different procedures like Proc Means, Proc Freq, Proc Tabulate, Proc Sort etc to implement new models.
• Write SAS code to implement research version code into production version.
• Investigate bugs logged by testers and fix it.
• Review and streamline old SAS code to eliminate errors and improve functionality.
• Create custom reports from Oracle database using Base SAS extraction and formatting procedures.
• Involve in making projects SOX compliance.

Environment: SAS 9.1, SAS/STAT, Oracle 10g, SQL, UNIX, Windows XP,

Confidential

SAS Developer/Production Support

• The project involve to build centralized Provider data base for data management department which organize and store data from main frame system and other flat files to provide a single source of integrated data. This date base is used for the purpose of reporting, analysis and decision support and to improve the provider services by preventing errors providing real-time data.
• Transfer data from Sybase to UNIX platform and use SAS to verify duplicate or erroneous records entered by the end users. Merge Excel data or other flat files from various vendors to our Sybase database processed by using SAS system.
• Produce external files and reports employing various SAS procedures, like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Means, Proc Transpose, and Proc SQL
• Write new macros and modify existing macros to incorporate the business specification and to make the code more efficient and dynamic.
• Perform data integrity checks and cleansing using SAS Macros and data steps
• Monitored automated production support.
• Write various production Shell Scripts to automate daily tasks such as monitoring, reporting, and archiving.

Environment: SAS 8.2, Excel, Sybase, UNIX.

Confidential

SAS Analyst/Programmer

• Credit risk project involved extracting retail banking data from warehouse and analyzing those data for credit risk exposure. The team also performed analysis on market campaign data for credit cards.
• Extraction of data from ORACLE and other flats files and Excel into SAS Data Sets using SAS/Access, SAS/Connect, and SAS/SQL. Designed and created the SAS Data Sets from
• Extensive use of Base SAS for Data Set creation and generating reports.
• Extensively used SQL for Queries, JOIN, MERGE, and Concatenation of different tables for data extraction from different databases.
• Worked on analyzing campaign marketing data. Produced various reports for approval rate and credit card enhancement.
• Used marketing database to generate various reports to target list of a direct mail and telemarketing campaign.

Environment: SAS 8.2, SAS/SQL, MS Excel, Oracle 10g.

Confidential

SAS Developer

• Delta Technology developed software that was backbone of the operation of Delta Airlines. Block Time Forecast System BTFS was an application designed for ASA customers. This application used historical schedules to forecast the future schedule.
• Acquire raw data from excel sheet and create SAS datasets. Use PROC SQL, PROC import, PROC export procedures to create SAS datasets.
• Perform data extraction, data transformation, data manipulation, loading and testing.
• Use of SAS Macros, PROC Summary, PROC Means, PROC Report, PROC Transpose to generate various reports.
• Modify SAS/AF codes in order to fit in BTFS application according to the requirement.
• Develop SAS codes to calculate maintenance costs, Hanger costs, Component costs and Material cost for various aircraft using various SAS procedures and SAS macros.

Confidential

Software Test Engineer

• I was involved in writing test plans and setting up environment for test. I extracted useful information from the historical data and created reports based on the clients' requirements.
• Tested various codes developed by the senior team members.
• Developed secured user interface by creating VB forms that provides username password entry to access individual call log and account summary.
• Involved in manual system testing debugging of the application.