PROFESSIONAL SUMMARY:

• Senior SAS Programmer with 8+ years of experience in SAS development and testing in financial, Banking, Insurance & mortgage industries.
• Expertize in working with different SAS environments such as WINDOWS and UNIX.
• Experience in developing SAS Macros from scratch and developed application for automation, data updates and reporting.
• Efficient in data analytics and performed data manipulation and data cleansing using base SAS functions, SAS Data steps and procedures including Data NULL, PROC PRINT, PROC REPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS, PROC DATASETS, PROC FREQ, PROC FORMAT, PROC SQL, PROC TABULATE and PROC ACCESS.
• Adept in using SAS Enterprise Guide for performing day to day programming in SAS.
• Expert hands - on noledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ETS, SAS/ODS, SAS/SQL and SAS/OR.
• Extensive programming experience with SAS datasets and procedures such as PROC FORMAT, PROC TABULATE, PROC REPORT, PROC TRANSPOSE, PROC PRINT, and SAS/STAT procedures such as PROC CORR, PROC REG, PROC GLM, PROC ANOVA, PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• Successfully increased portability of existing SAS programs and created new programs using SAS macro variables to improve efficiency and consistency of result.
• Successfully analyzed business logic and system needs to prepare dataflow diagrams and documentation.
• Particularly adept in identifying technology solutions for business problems and implementing them.
• Result oriented, committed and hard working with a quest to learn new technologies and undertake challenging tasks.
• Enthusiastic to develop new skills in a dynamic environment.
• Followed System Development Life Cycle (SDLC) methodology for teh design, development, implementation, and testing of variousSASmodules.
• Capable of utilizing data management techniques like Merging, concatenating, interleaving ofSASdatasets using MERGE and SET statements in DATA step.
• Performed PROC SQL joins and worked with PROC SQL set operators to combine tables
• Worked withSASon Unix andSASEG (Enterprise Guide) with Oracle / DB2 and Host files using Proc SQL Pass-Through.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Responsible for accessing and managing data and for performing complex queries and analysis.
• Producing data in various output formats including HTML, RTF, PDF, MS-EXCEL using ODS (output Delivery System).
• Worked usingSASMacros andSASprocedures in Banking for credit card report generation and upgradation.
• Working experience in coding using SQL Procedures/Functions.
• RewriteSAScodes to fine-tune and automate variousSASprocesses.
• Good noledge on Hadoop, Pig, Hive.
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Worked on data quality rules and ensured teh proper implementation of data quality during teh creation and modification of data, according to Enterprise Data and Analytics data quality standards, guidelines, metrics and quality-expectations.
• Ensured accuracy, completeness, integrity, consistency, uniqueness, and timeliness of data.
• Executed Enterprise Data and Analytics data quality tests/assessments and data cleansing activities.
• Knowledge of frequency and duplicate analysis, cross dataset dependencies, redundancy analysis, data extraction techniques and applications.
• Knowledge of and some experience applying statistical/mathematical decision making and/or testing methodologies.
• Proven ability to support multiple projects under deadlines often with competing priorities and complexities.

TECHNICAL SKILLS:

Operating System: Windows 98/2000/XP/7, DOS, UNIX AIX

Statistical Tools: SAS 8/9.1/9.2, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ETS, SAS/ODS, SPSS, STATISTICA, SAS Enterprise Guide 4.1/4.2/4.3

Languages: C, C++, Java, SQL, PL/SQL, XML, HTML, DHTML, Java Script, VB Script and Shell Scripting

RDBMS: MS SQL Server 2000/2005, Sybase, Oracle 8i/9i/10g, Teradata V2R5/V2R6, MS Access 2003

MS Office Suite: Word, Excel, PowerPoint, Outlook, and Access

PROFESSIONAL EXPERIENCE:

Confidential -TX

SAS Lead Developer

Responsibilities:

• Interact with management and business analysts to determine system requirements.
• Work with around 40 million consumer records dat resulted from Fidelity implementing 12 years of upgrades.
• Create SAS layouts for mainframe/host files obtained from Fidelity unload database.
• Extract teh Fidelity unload data from Mainframe host files in Netezza using FTP.
• Modify existing code to accommodate teh addition of new data as part of teh core banking upgrade project.
• Project Scheduling & Tracking to ensure dat deadlines are met.
• CreateSASprograms and perform data validation on raw data sets and create data sets for analysis.
• Modify SAS codes, create scripts and prepare them for automation in Control M.
• Creating test scenarios to find errors and confirm programs meet specifications as per Bank Governance Guidelines.
• Participated in teh discussions and worked on tasks assigned from cross-functional teams.
• Responsible for manipulating, transferring, managing and processing financial data in SAS using SAS Enterprise Guide under UNIX Platform.
• Write documentation to describe program development, logic, coding and corrections.
• Generating customized summary reports using SAS Data steps and Procedures.
• Extensively used PROC SQL, SAS ODS and SAS MACRO.

Environment: SAS 9.1.3, SAS 9.2, SAS-EG 4.2, SAS/BASE, SAS/SQL, SAS/MACROS, WINDOWS 7, MS-OUTLOOK, Mainframe and Netezza.

Confidential -MN

Sr.SAS Programmer/Analyst

Responsibilities:

• Extracted teh data from DB2 and Oracle using PROC SQL pass through facility.
• Extracted data from teh Mainframe flat files using SAS, SAS SQL procedures and create SAS data sets.
• Worked with teh Guest browser’s data and sales data dat consists of more than 2 billion records.
• Used Common Table Expressions (CTEs) to improve resources usage and increase performance.
• Converted raw data files into SAS datasets using teh SAS INFILE statement.
• Scheduled SAS jobs using CRON TAB Scheduler.
• Migrated teh SAS code and SAS data sets from teh old environment to new grid environment
• Extensively used PROC SQL, PROC TRANSPOSE, PROC EXPORT and SAS Macros.
• Used PROC RANK, PROC FORMAT, and PROC UNIVARIATE to analyze teh guest spend and to do teh guest segmentation.
• Used SAS/MACRO facility to decrease teh redundancy of extensively used SAS scripts and to increase teh flexibility of teh code.
• Utilized SAS/ODS to create reports in PDF, RTF, HTML formats as per teh user needs.
• Developed SAS code and created ad-hoc reports based on teh given requirements.
• Created dash board reports and ad-hoc reports on weekly and monthly bases.
• Used EXCEL and VBA scripts to develop teh ad-hoc reports.
• Extensively used QUERY ANALYSER to check data in teh Data base (DB2) and run teh SQL queries directly in DB2.

Environment: Mainframe, Windows XP, SAS 9.1.3, SAS 9.2, SAS-EG 4.2, SAS/BASE, SAS/SQL, SAS/OR, SAS/MACROS, SAS/STAT, SAS/ACCESS, MS-OUTLOOK, COBOL,JCL,DB2, and Oracle.

Confidential -Ohio

SAS Developer

Responsibilities:

• Extracted data from different data warehouses, Teradata and SQL using SQL Pass through facility.
• Converted raw data files into SAS Datasets using teh SAS INFILE statement.
• Used SAS/MACRO facility to decrease teh redundancy of extensively used SAS scripts and to increase teh flexibility of teh code.
• Created SAS datasets for modeling environments.
• Responsible for manipulating, transferring and managing data in SAS.
• Handled teh tasks of writing reports and data using UNIX platform.
• Extracted teh data from mainframe environment.
• Extensively used PROC SQL, PROC SORT, PROC FORMAT, and PROC FREQ.
• Stored formats in permanent catalogs to increase teh reuse and portability of teh formats.
• Used select/when statements wherever possible instead of if/tan else statements to increase teh efficiency.
• Used stored macro procedures in building macros to facilitate other users to share macro code.
• Decreased teh run time of teh existing SAS programs by eliminating redundant DATA steps by using WHERE statements instead of IF statements and using PROC FORMAT to format SAS variable values instead of multiple IF statements.
• Produced final reports and charts in excel to send to business users.
• Used Excel Pivot tables to summarize complex data.
• Creation of monthly financial reports.

Environment: Windows XP, SAS 9.1.3, SAS/BASE, SAS/SQL, SAS/MACROS, SAS Enterprise Guide 4.2, Teradata, UNIX, SQL Server.

Confidential -VA

SAS Developer

Responsibilities:

• Extracted teh data using SAS from different input sources and transformed teh data according to teh business requirements and generated teh reports and load ready text files.
• Data was extracted from xml files, external input files into SAS datasets.
• Extracted data from Oracle, DB2 and Sybase databases into SAS using SQL pass-through facility.
• Applied teh business rules to teh SAS datasets using data and PROC steps.
• Created temporary tables in DB2 using LIBNAME statement.
• Generated teh reports using SAS ODS TAGSETS.
• Created many reports to track teh performance of teh servicers related to data issues.
• Ad hoc reports were created using Business Objects.
• Documented every module in teh project.
• Macro code was written extensively to automate teh SAS code.
• Created teh Assessment report daily to track teh performance of teh servicers.
• Contacted teh servicers for data issues.

Environment: Mainframe, Windows XP, SAS 9.1, SAS/BASE, SAS/SQL, SAS/MACROS, Oracle, DB2, Sybase, MS Outlook

Confidential -Blacksburg VA

SAS Programmer/Analyst

Responsibilities:

• Extracted data from Oracle databases and flat files.
• Developed reports using PROC FORMAT, PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Extensively used SAS/STAT to perform analysis of variance, multivariate analysis of variance, and repeated analysis of variance.
• Generated flowcharts using MS Visio. Conducted behavioral analysis with large data on various promotional campaigns to support teh market research department.
• Effectively prepared performance reports and presentations. Successfully published monthly sales and payment trend reports on teh company intranet using SAS ODS.
• Retrieved ORACLE tables with PROC SQL. Run weekly and monthly reports using SAS.
• Extracted Oracle tables from SAS and within Oracle by suing SAS/Access, and SAS/SQL.
• SAS/SQL was used for pre-processing data, SQL queries, data analysis, generation reports, and statistical analyses.
• Effectively worked with users to define business processes and information systems for supporting those processes.
• Developed reports for senior management and other departments using SAS tools and Excel.

Environment: SAS/BASE, SAS/MACROS, SAS/ODS, Oracle 8, UNIX and Windows NT.

Confidential

Statistical Developer

Responsibilities:

• Involved in clinical trials, Data migration/extraction from flat files, excel, CSV, DAT and Oracle database.
• Provided output for teh clinical study report using Output Delivery System (ODS).
• Used SAS/ODS for delivering output in different formats including HTML, PDF and RTF.
• Involved in creating teh data specifications or flow charts to generate analysis datasets and validation macros.
• Worked with CDISC team to map analysis dataset into SDTM model according to FDA specifications.
• Involved in writing SAS program code using SAS/BASE, SAS/MACROS SAS/STAT to produce analysis datasets.
• SAS macros were successfully used to create new programs and modified existing SAS programs to make them portable as well as consistency of results.
• Extensive use of teh SUMMARY, CONTENTS, TRANSPOSE, SORT, PRINT, SQL, GPLOT and GCHART procedures.
• Worked with all teh necessary procedures dat compile to NDA submissions.

Environment: SAS/BASE, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ACESS, SQL, MS Office, ODS, Windows XP