SUMMARY

• SAS Developer with 8+ years of programming/analysis experience in SAS on theUNIX, andWindows platforms.
• Created Financial and Retail Modeling Datasets. Used the proceduresSQL,TABULATE,FREQ,FORMAT, andGRAPHto generate modeling reports.
• Created and AutomatedDaily, weekly, monthly, Early Warning service reports, Profitability analysis reportsfor Products like Pay day loans, Installment loans.
• Worked with modelers in buildingRisk score modelsfor controlling Fraud and increase the customer traffic.
• Additional experience includes usingBase 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 producingHTML, RTF, CSVandPDFformatted files usingSAS/ODS.
• Experience inSAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH.
• Experience in developing complexSAS Programs,Macrosfor data updates, data cleansing, and reporting.
• Knowledge in SDTM DOMAINS like AE, DM, CM FA, EX, DS etc and understanding of CDSIC guidelines for FDA submission of clinical trial data.
• Meticulously analyzed and validated data sets and SAS outputs with other programmers’ outputs and mockups in SAP using PROC COMPARE, PROC CONTENTS, and PROC FREQ. Created formats for the coded data and used PROC SQL for data validation.
• Additional experience includes usingBase 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 producingHTML, RTF, CSVandPDFformatted files usingSAS/ODS.
• Involved extensively inData Extraction,Transformation,Loading, Analysis,and MIS Reportsfor Banking.
• Experience inSAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS Information Map Studio, SAS Web Report Studio, SAS/ENTERPRISE GUIDE, SAS/ENTERPRISE MINER
• Experience in Creating Process Flow Diagrams and Technical Specification Document Diagrams usingMicrosoft Visio2007
• Experience in developing complexSAS Programs,Macrosfor data updates, data cleansing, and reporting.
• Proficient in the following reporting, statistical procedures:REPORT, TABULATE, FREQ, MEANS, UNIVARIATE, TTEST, CORR, REG, GLM, ANOVA, LIFETEST, TRANSPOSE, COMPARE, EXPORT, COPY, CONTENTS.
• Worked extensively onTeradata, Oracle, SQL Server, MS Access Database.

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 Languages C, C++, Perl.

Operating: Windows (NT/95/ 98/ 00/ ME/XP), UNIX, Linux System Tools Business Objects Reporting, Data Integrator & Set Analysis

Others: MS Office, MS Project, Power Point, Excel, Outlook, MS Access.

PROFESSIONAL EXPERIENCE

Confidential

Sr SAS Programmer

Responsibilities:

• Extensively used procedures likePROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATEandPROC REPORT.
• SDTM Upversioning from SDTM 3.1.1 to SDTM 3.1.3 and SDTM3.2 format.
• Creating Validation programs using mapping specification documents.
• Writing macros to automate batch execution of SDTM domains for Oncology trials in clinical.
• Extracting data from the database using SAS/SQL proceduresand created SAS data sets.
• Used data step options likeKEEP, DROP, and RENAMEas a part of storage efficiencies. Data set optionsIF, where etc. were used in reading raw data files.
• CreatedMacrosand developed SAS programs forData cleaning, Validation, AnalysisandReportgeneration using newly created as well as existing macros
• FormattedHTML, PDF, CSV and RTF reports, usingSAS - output delivery system ODS
• Used SAS extensively forMatch merge, Append data validation, andData correctionandCleansing.
• Generated listings and reports from SAS programs usingMACROS, ODS and PROC REPORT/TABULATEand usingWord, Excel and Power Point.
• Extracting data from the database usingSAS/Access, SAS/SQL proceduresand created SAS data sets.
• Used data step options likeKEEP, DROP, and RENAMEas a part of storage efficiencies. Data set optionsIF, where, missover, truncoveretc. were used in reading raw data files.
• Developed and use metrics and reports to proactively identify issues impactingFraud Team operations.
• CreatedMacrosand developed SAS programs forData cleaning, Validation, AnalysisandReportgeneration using newly created as well as existing macros.

Environment: Base SAS, SAS/SQL, SAS/MACROS, SAS/ODS, MS Excel, MS Access, MSSQL Server.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Served as a SME for various SAS processes across different implementation projects.
• Wrote SAS scripts to extract sample data from various Confidential databases likeDB2, Oracle.
• Modified / debugged existing SAS scripts to have an efficient processing system and get rid of redundant steps usingSAS Enterprise guide, Base SAS and SAS Macros.
• Worked with Cross functional teams from Business intelligence management, Technology management and Project management domains.
• Involved in working with Access Datasets and VB scripts.
• Created some scripts inUNIXfor File Transfer from one Server to Other usingSFTP and Winscp.
• Extracted data from Oracle views using variousSAS/Accessmethods includingLIBNAME statementsand theSQL Pass Through facility.
• Used data step options likeKEEP, DROP, RENAME, IF, WHERE, COALSECEC, when reading raw data files.
• Worked in an Onshore-Offshore model working with local client employees as well as global associates.
• Worked on Different Products likeReduced Franchise Risk, Mortgage Risk, BASEL Submissions, FICO SCORINGetc., ForCITI BANK NORTH AMERICA.
• Used theImport and Exportfacilities 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.

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