SUMMARY

• Over 6 years of SAS Professional with hands on working experience in Banking, Financial and Healthcare industries.
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data other SAS application for data updates, data cleansing, and reporting.
• Working experience in SAS Access, SAS Connect, SAS/AF, SAS/ETL, PROC Reports, SAS ENTERPRISE Guide in Windows and Unix environments.
• Worked closely with Business in gathering requirements and understanding the metrics required for generation of Reports, List out puts for Marketing teams.
• Possess statistical knowledge of descriptive models including various sorts of mixed models and predictive solution models including linear, multiple, polynomial and non - linear regression model.
• Worked on Enterprise Miner for developing Predictive Models.
• Experience in performing ad hoc queries and User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis.
• Well versed with creating HTML Reports for financial data using SAS ODS facility, proc report and sql pass thru facility.
• Created views in Oracle with SQL and using TOAD.
• Wide-range experience in data manipulation and generating customized reports with SAS data steps and procedures.
• Experience in preparation of reports, listings, tables and graphs using various SAS Tools like SAS/Base, SAS/Graph, and Procedures such as Sort, Means, Summary, Freq, Print, Report.
• Experience working withSAS Web Report Studio
• Experience in configuring Data Marts using enterprise BI Administration.
• Hands on experience working with OLTP, OLAP Cube Studio, SAS Enterprise Business Intelligence Server(SAS/EBI)and SAS Information Map Studio
• Extensive experience in RDBMS like Oracle, SQL Server, Db2, MS Access.
• Used ECM tools Remedy,andCVSto trace development, testing, and production (SDLC) phases
• Excellent organizational and communication skills.
• Experience in transforming business requirements to Functional Specs and User Stories for Web pages, Reports, Dashboards and Web Analytics.
• Worked with Data Flux to manage data in data ware houses.
• Extensive preparation of Ad-hoc reports.
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks
• Demonstrated high energy, professionalism, strong problem solving, decision-making and interpersonal skills. Possess leadership skills as well as the ability to work independently and on a team. Strong verbal and written communications skills.
• Possess strong ability to quickly adapt to new applications and platforms
• Ability to work in self-directed environment and Very good team player with excellent analytical and problem solving skills.

TECHNICAL SKILLS

Database: MS Access, Oracle 10G/9i/ 8i, SQL Server 2000/2005/2008, UDB, Teradata.

Languages: C, JAVA, SAS, HTML, SQL, PLSQL

OS: UNIX, Windows 9x/2000, XP, NT

Applications: MS Word, MS Excel, MS PowerPoint, HTML, FrontPage express, Power Point, Futrix, Spotfire.

SAS tools: SAS®8, SAS®9, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/ETL.

SAS Procedures: Tabulate, Report, Print, Contents, Means, Freq., Univariate, Summary, SQL, Sort, Import, Export, Copy, GPlot, Gchart, Format, Sort, Transpose, ANOVA, GLM, Reg, and Compare.

Business Intelligence: SAS DI Studio, SAS OLAP Cube StudioSAS Management Console, SAS Enterprise Guide, SAS Web Report Studio, Add-In to MS Office, SAS Information Map Studio, SAS stored process

Word Processors: MS Word, Open Office, Page Maker.

PROFESSIONAL EXPERIENCE

SAS Programmer/ Statistical Analyst

Confidential, Dallas, TX

Responsibilities:

• Involved in automation of reports in various formats like pdf, html and excel reports.
• Using the EG Stored Processes, updating and developing macro programs code.
• Developed Unix Korn shell scripts to automate recurring processes and routine administration tasks.
• Conducted QA for macros generated by other programmers using Macro options MLOGIC, SYMBOLGEN, MPRINT, MACROGEN etc.
• Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORTetc. and SAS ODS facility.
• Created views in ORACLE using SQL and Tool for Oracle Application Developers(TOAD).
• Created UNIXKorn shell scripts to export environment variables and deleted old files.
• Actively monitored software usage on all platforms, keeping them at optimal level for user querying.
• Conducted statistical modeling for both continuous and categorical data, including linear regression, nonlinear regression, ANOVA, GLM model, repeated measure, nonparametric regression, classification tree etc.
• Performed documentation of the SAS Code for the better understanding of the program

Environment: SAS/Connect, SAS/STAT,SAS/Graph,Oracle11g,Base SAS 9.2,SAS Macros, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel,TOAD, MS Access.

SAS Programmer/Consultant

Confidential, River woods, IL

Responsibilities:

• Perform data migration, data preparation, graphical presentation, statistical analysis, validation, reporting, documentations, extraction, transformation, and loading.
• Converted SAS functions and modeling Macros to equivalent SQL Codes for run time efficiency.
• Automated processes with check and reporting to different locations and reporting systems.
• Supported the forbearance reporting during the transition phase to the new system.
• Extracted and loaded tables to and from Data using Libnames engine.
• Created Test Programs and Validated Datasets for adherence to department guidelines.
• Used SAS/Macros facility to provide reusable programs to create periodic reports with minimal chance of errors.
• Supported offshore teams for any issues regarding report requirements, data sources and report formats.
• Used SAS procedure like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORTS in order to prepare data.
• Developed SAS programs for statistical analysis and data display working with various SAS products, SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS to develop solutions.
• Wright programs in SAS to generate reports, table, and using SAS ODS.
• Implemented credit risk analysis reporting system based on scores and data management principles, such as joining dataset, indexing, data aggregation, record selection, sub-setting, and multiple records per case, creation and modification of views, accessing multiple databases.

Environment: s: Windows, SAS 9.2, SAS 9.13, SAS Enterprise Guide, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/ODS, MS OFFICE, ACCESS, MSOFFICE.

SAS Developer/Analyst

Confidential, Wilmington, DE

Responsibilities:

• Extensively performed data migration and large transactional data base applications by pulling millions of records from data source using Mainframe SAS application and partitioned the data into partitioned data sets(PDS) for lesser runtime
• Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
• Using understanding of direct marketing to provide segmentation, data mining and response analysis for marketing campaigns.
• Involved in market segmentation and customer profiling
• Redesigned Oracle cursor-based stored procedures to Teradata set-based stored procedures. Worked with Business Objects developers to ensure that generated SQL was optimized for Teradata.
• Involved in the creation of user testing documentation Used Data Flux for Data Integration.
• Ensured and adhered to design and security standards.
• Provided programming support to the Solutions(Lending) team and other Creditcard team members (i.e. a total redesign of all the model monitoring report process for Lending which included development of a more efficient data extraction code and conversion from a manual (Excel/Pivot tables) to automated(html based graphs) process of producing the reports).
• Implemented SAS/ETL processes to optimize the code using partitioned datasets.
• Extensively created audit reports which were successfully tested and approved by the production team and also assisted them in UAT sessions to help the users validate the developed queries.
• Effectively integrated the data using SAS DI studio after ETL operation and thus maintained the data on a monthly basis.
• Data Extraction- Extracted data Developed full scale Client/Server SAS/AF systems for international users.
• Supported development of predictive modeling for each marketing campaign product using SAS, Informix and Sybase.
• Wrote queries based on the BRCL and ran the SQL code against the tables in DB2 and effectively utilized joins in PROC SQL including inner joins, left outer joins and right outer joins to optimize the statement.
• Participated in Risk Assessment and Risk Management with regards to the Business requirements for queries with the Business team and also effectively coordinated with the user team to achieve considerable Risk mitigation.
• Prepared datasets for market analysis and model group.
• Installed and configured SAS for Windows on several workstations.
• Enhanced the liquidity of the mortgage market by providing funds from the bank to mortgage bankers and other lenders so that they may lend to home buyers.

Environment: SAS/Connect, SAS/STAT,SAS/Graph,SAS EG 4.2,Oracle10g, UDB, SAS metadata server, SAS Management Console,Base SAS 9.1.3,SAS Macros.

SAS Programmer/ Analyst

Confidential, Nashville, TN

Responsibilities:

• Extracting financial data from the database using SAS/Access, SAS SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, ProcUnivariate, and PROC ANOVA.
• Used of SQL server, SQL access, SQLPLUS, TOAD and PL/SQL to solve complex database problems as well tuning purpose
• Involved in maintaining and tuning existing JCL scripts
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Analyzed the data using SAS/STAT procedures PROC FREQ, PROC MEANS, PROC SUMMARY
• Used Proc Sort, Set, Update and Merge statements for creating, updating and merging various SAS datasets
• Design of ETL process to meet the requirement of data demand.
• Developed and maintained the Crontab Entries for scheduling the daily, weekly, monthly, quarterly as well as yearly jobs
• Worked with SQLPLUS, and PL/SQL extensively to solve database problems to make database effective and efficient tuning purpose. In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Scheduled and managed jobs with AutoSys job management system to ensure job streams flowed smoothly.

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel,TOAD, MS Access