SUMMARY

• SAS Advance and Base certified with Over 7 years of robust professional work experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and Reporting with SAS
• Understanding of the client’s vision, goals, limitations, data sources and time lines
• Firm grasp over understanding of business needs and strategies to develop reliable and effective solutions
• Firm understanding of Proc Olap and Proc Infomap to deliver solutions meeting complex business needs
• Extensive experience transferring data across platforms (Mainframe, Unix, PC) based on the business and reporting needs
• Vast experience in presentation using SAS, Excel, Pivot Tables, DDE for presenting the end results
• Proven skills in SAS Base (data step and proc) and SAS Macro fulfilling on demand business needs
• Advanced SQL skills with ability to code complex queries to load, clean, format & store data
• Clear understanding of data modeling principles like star and snow - flake schema, dimensional data model, 3nf etc
• Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data
• Ability to code complex MDX code for OLAP cubes to have a tradeoff between storage space and performance
• Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, Clustering etc to gain insight into the data
• Skilled in analytical and business reporting using SAS, MS Office, VBA and RDBMS technologies
• Conceptual knowledge of marketing mix, segmentation and association rules, market basket analysis, test and control groups, sample size criteria, hypothesis testing etc in marketing domain
• Experience in loading SAS Metadata Server with metadata from external packages for ETL development
• 3 years of experience in job scheduling and load balancing using SAS Grid and LSF
• Involved in preparing and reviewing BRD, FRD documents to serve development and reporting
• Experience in coding mathematical expressions in SAS as per the requirement using legacy and new functions
• Extensive experience in Teradata tools & utilities like SQL Assistant, BTEQ, FastExport & TPump for business analytics and reporting on massive Enterprise Data Warehouse
• Strong skills in requirements gathering, analysis and ETL design, coding, debugging
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc
• Completed several projects with accountability for design, development, and implementation of enhancements which involved secure data transfers to external vendors
• Involved in projects having to deal with cross functional teams and multiple stakeholders
• Minimum time to self sufficiency in any environment
• Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience

TECHNICAL SKILLS

SAS Tools: SAS 9.3, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS SAS/CONNECT, SAS/GRAPH, SAS/ENTERPRISE GUIDE, SAS OLAP CUBE STUDIO, SAS/ENTERPRISE MINER, SAS/INFORMATION DELIVERY PORTAL

Databases: Oracle 9X/8.x, MS SQL Server 2000/2005, Teradata 11/12, DB2, MS Access, Informix

GUI Tools: MS Office, MS Project, MS Visio

Commercial Tools: Informatica, Expediter, FileAid, Rapid SQL, Crystal Reports, Hyperion, ERWin, Roscoe, RCS

Operating System: WINDOWS XP/NT/Vista, UNIX(AIX), MVS, z/OS

Programming Languages: C, C++, SQL, VBA, VB 6.0, Java, HTML, XML, Bourne Shell

Reporting tools: Crystal Report, Hyperion, MS SQL Server Reporting Services

PROFESSIONAL EXPERIENCE

Confidential, Bridgeport, CT

SAS Developer

Responsibilities:

• Directly involved in gathering complex business requirements pertaining to recent or old pattern of abnormal behavior or activity on different channels that would affect the end customer of the bank
• Convert business requirements into technical specifications using available tools and technologies
• Design the needed aggregations, transformations and mapping of the data entities to suite the build and execution phases of the applications
• Use SAS, SQL, XML, PL/SQL and Windows batch programming techniques to code the technical specifications apply business logic and produce automated reporting solutions
• Create detailed business and technical documentation for individual projects
• Maintain and contribute to the modulated software development environment for loss prevention
• Work individually and as part of a team to put forth ideas pertaining to technical and analytical solutions
• Use Agile methodology to build, test and deploy models and applications
• Involved in mapping and transfer and summarization of transactional, operational, actuarial, econometric and demographic data for EWARS(Early Warning And Reporting System) applications
• Extensively use Proc Olap and Proc Infomaps to build data sources for the reporting applications using SAS, AMO and Web Reports
• Routinely deal in with large internal and vendor data and perform performance tuning, query optimizations and production support for SAS, Oracle 11g
• Responsible for troubleshooting and delivering outputs using PROD/DEV/QA environments
• Develop test cases/plan for individual project assignments of Loss Prevention reporting using ID Portal
• Involved in preparing Data Quality Review Plan (DQRP) to adhere to the internal specifications
• Provide production support and retrospective version control on the application on ad hoc basis
• Implement the needed fuzzy logic in pattern mapping and segregation of the customer profiles using SAS programming techniques

Environment: SAS ENTERPRISE GUIDE, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, SybaseIQ, SQL Server, RCS, UNIX, RCS, UltraEdit, IBM Tivoli

Confidential, Richmond, VA

SAS Developer

Responsibilities:

• Extensively used SAS on UNIX platform to develop custom business solutions
• Collaborate with business area to understand business needs, capture supporting requirements and resolve issues
• Developed and supported infrastructure to implement Statistical and Economic models
• Conduct walkthroughs of requirement artifacts and communicate effectively with business, development and testing teams during construction phase to ensure clear understanding of requirements
• Effectively used version control to coordinate the development across the various phases
• Used SAS to develop custom desktop solutions for the Stress Testing of the Commercial Loan portfolio of the bank
• Extensively used SAS macros, loops and other techniques to perform program and application automation
• Responsible for Phase I/II and III model validations for Commercial lending portfolio of the bank in Energy, Muni, Construction, C&I(Consumer and Industrial) to derive PD(Probability of Default), LGD(Loss Given Default) and EAD(Exposure at Default)
• Responsible for implementation of the various quantitative models in retail domain targeting delinquency, charge-offs
• Participated in datamart design and build using Oracle 11g, Toad, SQL Plus for the consolidation of the very large vendor data into the enterprise systems
• Supported in house oracle datamart administration using configured environment variables, parameters, stored procedures, group profiles
• Extensively used SAS Grid architecture on UNIX/Linux to perform job and workflow scheduling
• Used SAS and system options to improve the performance of the existing sas programs
• Participated in the process of streamlining the data process underlining the program automation
• Used SAS program techniques to develop custom and enhances reports for customers using AMO, Olap Cubes, OBI
• Used parallel processing in SAS to aggregate programs to significantly reduce the execution time of the applications that fetch aggregated and partitioned data
• Performed rigorous query tuning and performance optimization for the applications that process the large transactional data

Environment: SAS ENTERPRISE GUIDE, SAS OLAP Cube Studio, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, Teradata, RCS, UNIX, RCS

Confidential, Port Washington, NY

SAS BI Developer

Responsibilities:

• Extensively used Proc OLAP to generate cubes for DQ and custom reporting
• Adeptly performed Data Management for the Business Unit: data profiling and cleansing of business unit's assets data using SAS.
• Developed SQL queries to fetch data from schema of terabyte range
• Developed Cubes using formats replacing aplha to conserve disk space for input tables
• Used Excel and call execute routine in SAS to generate Proc Olap code having ease of maintenance
• Served as a direct point of contact with the end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy
• Produced reports in excel using SAS add-in, Proc Report and ODS Tagsets
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
• Developed SAS stored procedures and views to provide BI analysis and insights
• Involved in developing and maintaining documentation of operational processes and data mappings
• Used Proc Metalib as well as SAS SMC to configure/alter information of datasets/views/tables etc
• Developed several reports using SAS Information Map studio to be presented in Excel as well as Web reports
• Extensively used Proc SQL and SAS Macros for application automation
• Extensively used SAS Dictionary tables and Proc Metadata to get real time information for SAS datasets
• Used Excel templates and VBA to generate custom reports from data in SAS tables
• Extensively involved in mainframe SAS for analyzing very large datasets (several hundred rows)
• Involved in fine tuning the code to reduce the churn time and improve the efficiency
• Coded extremely complex SAS Data step and procs including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs
• Extensively used proc tabulate, proc rank, proc transpose in developing custom reports
• Involved in aggregating data residing on the vast network of distributed servers with all forms of data storage
• Exported large SAS data sets (more than 300 variables) to MVS external files to be sent to external vendors using SAS and SAS/Macro
• Hands on experience in moving SAS data sets from Unix to PC environments using FTP
• Used Meta Engine as well as SQL Passthru method to load the manipulated data from external tables into SAS data sets

Environment: SAS ENTERPRISE GUIDE, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Reports Studio, SAS Add In, SAS/SQL, SAS/MACROS, SAS/BASE, SybaseIQ, VBA

Confidential, NYC, NY

Audit Software Professional/SAS Consultant

Responsibilities:

• Strongly served the data requests of varied nature pertaining to operational risk, management risk, policy enforcements, regulatory oversight, Investor portfolio management, P&L reporting to name a few
• Adeptly performed Data Management for the Business Unit: data profiling and cleansing of business unit's assets data using SAS.
• Served as a direct point of contact with the end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy
• Automated the creation of Excel pivot tables from SAS data sets using SAS/Macro and VBA
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
• Developed SAS stored procedures and views to provide BI analysis and insights
• Involved in developing and maintaining documentation of operational processes and data mappings
• Used Excel templates and VBA to generate custom reports from data in SAS tables
• Extensively involved in mainframe SAS for analyzing very large datasets (several hundred rows)
• Created SAS programs using the COBOL copybook layouts
• Involved in creating SAS datasets out of the live VSAM datasets
• Prepared several regulatory reports in standard formats as specified using SAS
• Involved in fine tuning the code to reduce the churn time and improve the efficiency
• Designed and coded ETL processes with varied source systems like Oracle, SQL Server and flat files
• Coded extremely complex SAS Data step and procs including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs
• Involved in creation of flat files out of database tables
• Involved in aggregating data residing on the vast network of distributed servers with all forms of data storage
• Tested JCL and PROCS for Auto Reconciliation jobs for a month and compared reports, flat files and VSAM files from test and production environments
• Extensively used SAS/DDE to generate formatted Excel sheets maintaining data integrity from SAS output data sets
• Exported large SAS data sets (more than 300 variables) to MVS external files to be sent to external vendors using SAS and SAS/Macro
• Hands on experience in moving SAS data sets from Unix to PC environments using FTP
• Used SQL Passthru method to load the manipulated data from DB2 tables into SAS data sets
• Developed an application using Base SAS, SAS/Macro, Proc SQL and Proc Contents to generate concise data profiling reports

Environment: SAS 9, SAS/SQL, SAS/MACROS, SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/ETL, TSO, MVS, VSAM, DB2, Teradata, SAS/ENTERPRISE GUIDE, Easytrieve, ISPF, VBA

Confidential, McLean, VA

SAS Developer

Responsibilities:

• Developed and implemented strategies to integrate data from over 40 loan-servicing organizations into the SAS data warehouse
• Streamlined existing SAS code for table look-ups
• Created an automated monthly forecast report for dollars and number of accounts that rolled from current to delinquent using SAS/Macro, Excel and VBA
• Compiled datasets for building attrition and risk models in SAS
• Developed summary tables of the data in various sources using Base SAS and SAS/Macro
• Analyzed the loan data to generate portfolio statistics report using SAS, summarizing accounts by Fico bucket, market segment and account status
• Invoked SAS programs via VBA code to provide an easy user interface on the windows environment to connect to the Unix system
• Created analytical reports that drills down various performance metrics of existing collection strategies by key collection performance drivers including debt balance, recovery score, payment history and demographics
• Used Excel templates and VBA to generate custom reports from data in SAS tables
• Involved in creating Data Marts and performing data validation for scorecard modeling and customer segmentation using logical/physical DM and Teradata-ETL procedures
• Extracted metrics for Risk Management team from Teradata server using PROC SQL in SAS and modified it using Base SAS and SAS Macros to present in required format
• Facilitated and managed meetingsessions with committee ofSMEs from various business areas includingMortgage Servicing, Loan MonitoringandAsset Management.
• Developed data base objects like tables, views, indexes, stored procedures and user defined functions as per the business needs in SAS
• Queried data and applied constantly changing business rules to build customized user reports used in the process of managing loans, brokers, and sales representatives
• Designed automated data load system employing SAS/BASE and MACRO to control job flow and perform data audit on major intermediate and final data sets
• Used SAS OLAP Cube Studio and Web OLAP viewer to perform quick and insightful analysis of data
• Extensively worked with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS.
• Set up cron jobs on the Unix environment to schedule the run of daily SAS reports

Environment: SAS 9,SAS/SQLSAS/MACROS,SAS/BASE,.SAS/GRAPH,SAS/STAT, SAS/DDE, UNIX, Oracle, DB2, SAS/ENTERPRISE GUIDE, VBA, Teradata, SAS Enterprise Miner 5.2, MS Office, FileAid, Expediter

Confidential, Whitehouse Station NJ

Data Analyst - SAS

Responsibilities:

• Developed programs using the Libname statement & SAS Views to extract & report error statistics
• Created Automated Turnaround documents for use as re-input to source
• Contributed to several JAD sessions with focus to eliminate bottlenecks form the system
• Used Microsoft Access and Excel to provide output analysis data
• Programmed reports for Management to use to find business logic problems, manual and automated keying problems
• Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information
• Used SAS datasets to create reports using Proc Print and Reports. Also used Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL
• Used arrays along with Proc Means, Proc Summary and Proc Freq. Created drill-down HTML reports for the finance department using data from several sources
• Used SAS/DDE to call Excel VBA macros in reporting applications development
• Used SAS Macros to produce drill down capability for the reports
• Produced tables in Excel using ODS and Proc Tabulate as per the business requirements
• Performed detail analytics while producing financial reports so that the financial data is checked and are accurate
• Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets
• Participated in full life cycle of model development: market research, statistical analysis, model development, and reports/presentations

Environment: SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, Windows NT Server, UNIX, Microsoft Office 2003, SAS/EG, MS SQL Server, Teradata, Java, Python, COBOL, Perl

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Developed programs using the Libname statement & SAS Views to extract & report error statistics
• Created Automated Turnaround documents for use as re-input to source
• Used Microsoft Access and Excel to provide output analysis data
• Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information
• Implemented research forecasting models into production by using Base SAS, SAS Macros, PROC SQL and many other SAS tools
• Assisted architecture team in moving layers of the EDW from Oracle to Teradata for using SAS In Database technology
• Wrote Teradata code / SQL to enable the ETL processes to meet demanding business requirements, including BTEQs, Fast Loads, Multi Loads, and Fast Exports
• Used SAS datasets to create reports using Proc Print and Reports. Also used Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL
• Performed the automated data driven testing using WinRunner
• Performed functional, GUI, and Security testing using different checkpoints with the WinRunner scripts
• Responded to ad hoc data requests from internal auditors and consumers
• Analyzed requests generated data files using SAS and SQLPLUS etc
• Performed back-end testing to verify the flow of data from the database to the front end
• Used SAS Macros to produce drill down capability for the reports
• Performed detail analytics while producing financial reports so that the financial data is checked and are accurate
• Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets

Environment: SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, TOAD, Oracle, Windows NT Server, UNIX, MS SQL Server, SQLPLUS, Java

Confidential

Data Analyst

Responsibilities:

• Provided ad-hoc data analysis and reporting support for Sales and Marketing using Base SAS
• Developed SAS/MACRO to standardize the report and chart generation for re-use with
• PROC TABULATE, PROC REPORT, PROC APPEND PROC GPLOT, and PROC
• GCHART etc
• Wrote Macros in SAS to develop a concise code for data cleaning and reporting
• Developed SAS macros to create tables, graphs and listings
• Created SAS customized files in HTML, PDF, RTF and Flat files using the DATA NULL technique
• Created reports with multiple graphs and chart displays into a single Excel spreadsheet
• Created individual RTF files for summarizing the results and also to document the metadata
• Performed data manipulations on data stored in Oracle using SQL Assistant and PROC
• SQL
• Used SAS/ODS for effectively deliver the outputs in HTML and PDF formats
• Imported SAS data from Excel and Txt files to SAS Datasets

Environment: SAS V6.12 (Base, Macros, SQL), SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/STAT, Excel, Access, Oracle 8i, PL/SQL, UNIX, Windows NT