SUMMARY

• Over 7 years of IT experience as SAS Programmer in Financial and Insurance domains.
• Excellent knowledge in SAS Programming application like SAS Enterprise Guide, Base/SAS, SAS/Macros, SAS/Access, SAS/SQL, SAS/STAT, SAS/Graph, SAS/ODS, SAS/Connect in both Windows and UNIX Environment.
• Programming Experience with SAS report generating procedure like PROC REPORT, PROC FREQ, PROC TABULATE, PROC MEANS, PROC UNIVARIATE, PROC TRANSPOSE, PROC SUMMARY, PROC PRINT, and PROC SQL.
• Extensively used different SAS procedures like PROC IMPORT, PROC EXPORT, PROC CONTENTS, DATA NULL, PROC APPEND, PROC SORT, PROC COMPARE, and PROC FORMAT.
• Complete understanding of Statistical parametric analysis methods such as Correlation, Regression, Analysis of Variance and general linear models using SAS/STAT procedure such as PROC ANOVA, PROC CORR, PROC REG, PROC UNIVARIATE.
• Experience in Design and building of SAS programs to analyze and coordinating data for generating Reports, Files, Tables.
• Conversion of SAS Datasets to various file types including HTML, Excel, PDF, RTF format using SAS/ODS.
• Used SAS/SQL and Base/SAS merging procedures to join tables.
• Experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
• Highly motivated and organized team player with excellent oral, written, and communication skills.
• Extremely energetic, detail oriented, organized team player with strong analytical abilities, communication skills, interpersonal skills, and problem solving skills.

TECHNICAL SKILLS

Statistical software: SAS v 9.x, SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS, SAS/Macros, SAS/Connect, SAS/ETL.

Operating System: MS Windows/98/2000/xp/7/vista, UNIX.

Languages: SAS, SQL.

SAS Procs: SQL, REPORT, MEANS, UNIVARIATE, CORR, REG, TABULATE, FREQ, CHART, SORT, SUMMARY, CONTENTS, FORMAT, IMPORT AND EXPORT, APPEND, TRANSPOSE, ANOVA,PRINT.

MS Office: Word, Excel, Power Point, Access and Outlook.

Database: Oracle, Teradata, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

SAS Analyst

Responsibilities:

• Extensively interact with business analysts, IT services team, and Statisticians for developing SAS models for marketing purposes
• Involved in SDLC of the market risk rating application. Documented requirement analysis, version upgrade, and migration across develop, test, and production environment.
• Develop, test, and debug SAS programs to model Attrition rating models for different types of commercial loans.
• Modify models to reflect any changes in business requirements and input data structure
• Extensively used SAS Macros for programming.
• Followed an internal program validation and tracking methodology.
• Generate test data for model validation.
• Modify/develop Korn shell scripts to automate report generation and schedule tasks.
• Program for statistical analysis of data for model calibration.
• Work with business analysts to analyze and debug data issues. Use SAS programs and functions for data validation and cleansing.
• Work extensively in sorting, merging, concatenating, and modifying SAS data sets
• Use ODS to generate results in Excel, PDF, and HTML formats.
• Involved in handling the ad - hoc reporting requirements.
• Extensively use Data NULL to create XML files from SAS datasets.
• Develop SAS datasets from Excel files, XML files, Oracle Server, TD SQL and DB2 database.
• Extract data from the source database using Proc SQL.
• Design, document, implement, and maintain monthly & ad-hoc financial, marketing and operations analyses using SAS.
• Conduct complex ad-hoc programming and analysis including statistical programming and analysis.
• Develop and produce monthly reports summarizing business activity, delinquency & loss.
• Analyze business performance and productivity to identify obvious and subtle causes for improvement and deterioration for credit card services.
• Extract and summarize account and transaction level data for trend analysis and forecasting
• Create application layers for web publishing and dispatching of reports.
• Produce SAS datasets, flat files, and reports.
• Extract data from the source database using Proc SQL.
• Build logistic regression models using SAS EG for risk scoring on new campaigns and prospective customers.
• Develop Model to Predict Customer Response to launch of new products.
• Develop and execute controlled tests to determine the impact of new programs, strategy changes, or procedural changes.
• Dealt with list processing or Dynamic processing techniques
• Work in technical writing in providing documentation of capabilities of existing SAS codes.
• Familiar with system management.

Environment: SAS 9.2/9.3, Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide 3.0, SAS Enterprise Miner, Teradata, Oracle 9i (SQL, PL/SQL), UNIX, UNIX Korn Shell, MS-Windows XP, MS-Office.

Confidential, Boston, MA

SAS Programmer/Analyst

Responsibilities:

• Produce SAS datasets, flat files, and reports for various departments,
• Create SAS data sets from Oracle database.
• Extensively program for statistical analysis of data.
• Develop and execute controlled tests to determine the impact of new programs and strategy changes on existing customers.
• Implement advanced statistical approaches to develop predictive models and profiles.
• Data mining to identify significant relationships among customer behaviors and descriptive characteristics.
• Perform complex ad-hoc programming, analysis, and reporting.
• Design, document, implement, and maintain monthly and ad-hoc financial and marketing analysis.
• Develop and produce monthly reports summarizing business activity, delinquency & loss.
• Maintain and enhance loss-forecasting models and delinquency roll rates.
• Modified/developed korn shell scripts to generate periodic reports.
• Used SAS/Macros and Proc SQL for List processing.
• Have experience in technical writing and in analyzing code, providing documents and updates to the client/customer.

Environment: SAS 9.2, Base SAS (MACROS, Proc SQL, ODS), SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS Enterprise Miner, Oracle 9i (SQL, PL/SQL), UNIX, MVS, UNIX Korn Shell, MS-Windows XP, MS-Office

Confidential, Bridgeport, CT

SAS Programmer

Responsibilities:

• Develop, enhance & execute complex programs and reports with proper documentation.
• Comprehend production codes, undertake diagnosis, resolution of complex issues and improve the efficiency of processes and programs.
• Develop business domain expertise, rudimentary project based business knowledge and good theoretical knowledge of tools like SAS, MS office
• Independently delivers end to end on complex projects and assist in developing and testing new information infrastructure.
• Manage end-user expectation in the delivery of projects within agreed timelines and as per agreed quality standards.
• Independently executes standard processes, implements predefined algorithms and corrects identified problems.
• Maintaining large data sets, i.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.
• Documenting the process, i.e. documenting all the possible information about the application like SAS programs, DATA files and source.
• Preparing project plan for the execution.
• Independently interacts with business partners to understand business need and translates to technical specifications.
• Assist in developing and testing new information infrastructure.
• End to end project management and hands on delivery when required.
• Take ownership and actively manage project timelines. Execute standard reports, processes, files, and implements predefined algorithms
• Sets up QA/QC framework and ensures adherence and constant improvement.
• Develops business and technical knowledge of team members and identifies opportunities of improvement.

Environment: SAS 9.2, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESSSAS/ODS, Oracle, Teradata, DB2, UNIX and Windows 2003/XP.

Confidential, Columbus, OH

SAS Data Analyst

Responsibilities:

• Design, document, implement, and maintain monthly & ad-hoc financial, marketing and operations analyses using SAS.
• Conduct complex ad-hoc programming and analysis including statistical programming and analysis.
• Develop and produce monthly reports summarizing business activity, delinquency & loss Analyze business performance and productivity to identify obvious and subtle causes for improvement and deterioration.
• Extract and summarize account and transaction level data for trend analysis and forecasting.
• Create application layers for web publishing and dispatching of reports.
• Produce SAS datasets, flat files, and reports.
• Extract data from the source database using Proc SQL.
• Build logistic regression models using SAS EG for risk scoring on new campaigns and prospective customers.
• Experienced in System management.
• Develop Model to Predict Customer Response to launch of new products.
• Develop and execute controlled tests to determine the impact of new programs, strategy changes, or procedural changes.

Environment: SAS 9.1.3, Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide 3.0, SAS Enterprise Miner, DB2, Oracle 9i (SQL, PL/SQL), UNIX, UNIX Korn Shell, MS-Windows XP, MS-Office.

Confidential

SAS Programmer

Responsibilities:

• Responsible for data collection, management and manipulation of financial database.
• Performed statistical analysis, written SAS programs for data management and reporting, and performed validation, including testing SAS programs.
• Compared consistency of SAS variables, formats, and format codes across multiple studies.
• Accessed external excel files, stored and retrieved SAS data sets by moving data through multi platforms.
• Used PROC SQL (Pass-Through & Libname) methods and PROC APPEND (Bulkcopy) methods to write statistical analysis results to ORACLE database.
• Extensively used report writing procedures such as PROC PRINT, PROC REPORT, and PROC SQL.
• Produced summary of reports using PROC MEANS, PROC SUMMARY AND PROC TABULATE.
• Developed and maintained data retrieval and analysis tools for reporting.

Environment: SAS 9.1.3, SAS/Macro, SAS/Access, Oracle, SAS Procedures, MS Excel, Windows XP.