Summary Snapshot

Business Domain

Banking/Finance

Commercial Lending, Retail Banking, Collections Charge-Offs, Equities, Derivatives, MBS, CDO, Branch Operations, Loan Origination/Servicing, Exchanges, Broker/Dealers, Orders, Trades, Margin, Settlement, Custodians, Accounting, Stock Records, General Ledger and Sub Ledgers, Regulatory Reporting, Compliance, Fraud/Loss Prevention, CCAR, DFAST, Credit Bureau Attributes Data

Market research

Apparel, Beauty, Footwear, Technology, Auto

Technical

• 7 years of robust professional experience as a Data/Reporting Analyst and Developer in SAS
• 6 years of experience in RDBMS and DWH environment in SAS, Teradata, Sybase and Oracle for analysis and reporting
• 6 years of Experience in MS Excel, MS Access, Excel VBA, SAS DDE etc for application development, scorecards and dashboards for analytics reporting
• 5 years of experience using SAS on UNIX domain
• 5 years of experience with direct customer facing role including requirement gathering, coordinating meeting, seamless communication and participation in business and strategy planning meetings
• 4 years of experience working with SAS BI Suite Enterprise Guide, Olap Cube Studio, SAS Add In, Information Map Studio and Web Reports delivering high performance business reports
• 4 years of experience working in agile scrum development process
• 4 years of experience in physical and logical data modeling and schema design using industry standard tools like Erwin and others
• Extensive experience building and maintaining reporting data marts in SAS for risk analytics, consumer analytics, business development etc
• Extensive experience extracting information form enterprise data sources like Oracle, SQL Server, DB2 UDB, Flat files, text files, Spreadsheets, VSAM from within and outside the firm
• 4 years of experience with Teradata version 12 SQL Assistant, BTEQ, FastExport for ETL, analysis and reporting
• 3 years of experience with OBIEE products Oracle, PL/SQL, OWB etc for analysis, development and reporting
• Excellent communication and presentation skills with ability to effectively communicate to diverse technical and non-technical audience

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
• 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

Work Experience

Confidential

SAS Developer

Project involves developing business applications and analytical tools to detect various types of FRAUD in retail, commercial and Debit Card segments of the bank.

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.
• Involved in mapping and transfer and summarization of transactional, operational, actuarial, econometric and demographic data for EWARS Early Warning And Reporting System applications
• Extensive use of Proc SQL, SAS Macros, Unix and Windows Batch Shell for process automation
• 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

Confidential

SAS Developer

The project was to develop and support the model validation and implementation framework for the bank as per the BASEL2 specification. Developed stress testing tool for CCAR and DFAST. SAS, UNIX, Teradata, Oracle and Mainframe history loads and third party data systems are all to be integrated in a seamless fashion for the monthly and quarterly model runs

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
• 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 partioned 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

SAS BI Developer

• Company Overview: NPD Group, headquartered in Port Washington, NY, is the leading global provider of consumer and retail market research information for a wide range of industries. NPD provides critical consumer behavior and point-of-sale POS information and industry expertise across more industries than any other market research company. Through its consumer panel retail sales tracking services, it helps clients understand and profit from consumer and retail trends by telling them who is buying, what, where and why at the international, national and store levels.
• Involved in developing data-quality DQ system and custom market research MR dashboard reports in SAS domain. DQ system consists of multiple business lines with data loading varying from weekly to monthly time period. For certain business/frequencies, the DQ needs to be performed after 'Load Complete' as well as 'Go Live'. MR reports are developed for clients containing high end, critical and multi-faceted analysis of performance of product/brand/category/segment etc in the varied industry sectors like Apparel, Beauty, Technology, Auto etc.

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 maintainence
• 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

Audit Software Professional/SAS Consultant

Part of the audit team of Global Wealth Management GWM . Involved in auditing various business processes related to securities' trading, application performance, process controls etc as part of internal or regulatory requirement. Understanding the business justification of the audit, getting the requirements from the clients and stakeholders, interacting with the SMEs and the IT team, presenting the findings, improving upon the results and documenting the entire audit process are the main tasks performed. Teradata and SAS are the prime tools used.

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

SAS Devoper

The project was to execute the loan system migration of the bank that had been acquired.

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 meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset 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

Data Analyst - SAS

Company Migration project: The Human Resources Department had been, for some time, converting business logic, applications, and data from DB2 and other MVS data stores on MVS to Oracle for use by PeopleSoft. My role on the team was to create audit methodology that could compare data between the PC and MVS. Client Server SAS was selected as the Software of choice in consort with SAS on MVS to connect the platforms

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

Data Analyst

Worked on the application called Disclosure. The main purpose of this application was to disclose the documents to their lenders and notifying them automatically via emails whenever there are any changes to their documents or whenever they are posted on the web. Also worked on Data mining, reporting, and application development Windows utilizing Microsoft Access, VBA, SQL with emphasis in Fraud Prevention

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 InDatabase 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