SUMMARY:

• 8 years of robust professional experience as a Data/Reporting Analyst and Developer in SAS
• 7 years of experience in RDBMS and DWH environment in SAS, Teradata, Netezza, Sybase and Oracle for analysis and reporting
• 6 years of experience working with SAS BI Suite (Enterprise Guide, Olap Cube Studio, SAS AMO, Information Map Studio, SAS ID Portal Web Reports & SAS VA) & MDX delivering high performance business reports
• 6 years of extensive experience in DQ & ETL using SAS DI Studio 4.9, DataFlux, SAS MDM
• 6 years of experience using SAS on UNIX, Z/OS and MVS domain
• 6 years of experience in physical and logical data modeling, star and snow - flake schema, dimensional data model, 3nf database design
• Extensive experience building and maintaining reporting data marts in SAS for risk analytics, consumer analytics, business development
• 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 using secure connections
• 5 years of experience with Teradata version 12 (SQL Assistant, BTEQ, FastExport) for ETL, analysis and reporting
• 4 years of experience with OBIEE products (PL/SQL, OWB) for analysis, development and reporting
• Extensive experience in MS Excel, MS Access, Excel VBA, SAS DDE etc for application development, scorecards and dashboards for analytics & reporting
• Excellent communication and presentation skills with ability to effectively communicate to diverse technical and non-technical audience
• Completed several projects with accountability for design, development, and implementation
• Minimum time to self-sufficiency in any environment

TECHNICAL SKILLS:

SAS Tools: SAS 8/9, 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, SAS VISUAL ANALYTICS, SAS AMO, SAS/IntrNe

Databases: Oracle, Netezza, Teradata, DB2, MS Access, Informix, MS SQL Server

ETL Tools: Informatica, Talend, Data Stage, SSIS

Legacy Tools: TSO, Roscoe, CICS

Version Control: SVN, RCS

Commercial Tools: Expediter, FileAid, Rapid SQL, ERWin, Claudera, Autosys, Brio, TOAD, PGAdmin, Aginity, Business Objects, Talend, Priest

Operating System: WINDOWS, UNIX, MVS, z/OS, Linux, RHEL, CentOS, OEL

Programming Languages: C, C++, VB, SQL, Java J2EE, HTML, XML, Bourne Shell, Korn Shell, AIX, Centos, Red Hat, Sed, Awk, Perl, Python, JCL

BI Reporting tools: MicroStrategy, Crystal Report, Cognos, Hyperion, Tableau, QlikView, Spotfire, SSRS

Hadoop: Zookeeper, HBASE, HDFS, Map Reduce, Hive, Oozie, Pig, Flume, Yarn, Spark, Big Data

WORK EXPERIENCE:

Confidential, Chicago, IL

SAS Developer

Responsibilities:

• Implement solutions to meet high end business needs using SAS, Unix, Oracle
• Application development based on the constantly evolving requirements
• Assimilation of complex customer demographic and transactional data
• Automate the data loads from SAS DDS to LASR Server for SAS VA reporting
• Create user access based operational and performance dashboards using SAS VA
• Migrate existing SAS codes to Java based platform for automation
• Execute strategies to prevent deposits and retail fraud in real time
• Perform SNA (social network analysis) using Proc Opnet to identify potential malicious customers
• Rigorously analyze daily electronic transactional data from internal systems and external vendors to predict potential fraudulent customer behavior
• Assimilate the external credit bureau data with the internal systems to seamlessly link the different portfolios of the customers
• Educate end users with the use and enhancements of legacy reports conversion to SAS VA
• Develop and automate business reports using SAS for senior management and other audience
• Perform the analysis on the effectiveness of marketing strategies
• Assist and contribute in design of senior level business reports
• Validate the mappings and attribute level data of the new customers inherited in channel based marketing
• Manage application source codes using Clearcase and RCS

Environment: SAS ENTERPRISE GUIDE, SAS Visual Analytics, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, Oracle, SQL Server, RCS, Clearcase, UNIX

Confidential, Charlotte, NC

SAS DI Studio Developer - ETL

Responsibilities:

• Implement solutions to meet high end business needs using SAS, Unix, Netezza
• Involved in Data Modeling, Data Architecting and ETL architecting in a corporate treasury environment
• Implemented modular and reusable codes to run across 20+ product groups
• Extensively used Dataflux DQ with Oracle to setup data configuration & rules
• Implement custom data visualization solutions for reporting using SAS Visual Analytics
• Performed ETL using SAS DI Studio 4.9 in Netezza environment
• Extensively used SCD-2, SQL, Join, Splitter and User written transformations
• Data accessed from Flat Files, Teradata, Netezza, Oracle
• Configure and design data sources for VA reporting using multi facet hierarchies, charts, graphs
• Using SAS Grid on Platform LSF to schedule and maintain SAS jobs
• Maintained end to end process automation using SAS and Unix
• Extensive focus and direct interaction with the clients/customers, end users to map and implement their requirements and specifications
• Manage source codes across multiple environments using SVN and Clearquest
• Provided data support for SAS/RISK Dimensions to compute portfolio risk measurements with Fincad models using PROC FCMP, PROC COMPILE
• Developed risk and performance based reports using SAS VA
• Used different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts as per the business needs
• Involved in documentation, presentation and knowledge transfer while working on a conversion project
• Extremely agile & multi-phase environment with 2.5-3 week development cycle

Environment: SAS ENTERPRISE GUIDE, SAS DI Studio 4.9, SAS Visual Analytics, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, Netezza, SQL Server, SVN, Clearquest, UltraEdit, JIRA

Confidential, Bridgeport, CT

SAS Developer

Responsibilities:

• Involved in the team implementing and customizing the newly purchased SAS AML suite
• Involved in tuning and troubleshooting the SAS AML AGP (Alert Generation Process) for daily, weekly and monthly batch schedule runs in Prod+2 environments with actual and simulated data runs
• Reconciled the SCD-2 data changes and anomalies in the AGP process in the prior historical runs
• Develop case studies based on the alerts generated in different environments based on real and artificial data
• Use SAS, SQL, XML, PL/SQL and Windows batch programming to develop anti-FRAUD models pertaining to Written Checks, ATM withdrawals, Online Transactions and Payments, Butterfly Checks etc
• Worked with and assisted the anti-FRAUD/Loss Prevention team in real time to tune the anti-FRAUD models to mitigate the False-Positives
• Design the needed aggregations, transformations and mapping of the data entities to suite the build and execution phases of the applications
• Routinely involved in code module enhancements to the SAS AML suite to customize it to the company’s operations and data warehouse domains to streamline the end to end lifecycle of the custom modules
• Involved in the agile development process to rapidly and continuously improve upon the predictive capabilities of the models to identify FRAUD
• Work individually and as part of a team to put forth ideas pertaining to technical and analytical solutions
• Extensively use SAS Arrays, SAS Macros and Proc SQL to replicate the business logic in the code development and automation
• Involved in SCM activities using Clearcase & Clearquest
• Worked actively with the Loss Prevention department to perform the scenario analysis on selected anti-FRAUD model and model performance improvement
• Involved in mapping and transfer and summarization of transactional, operational, actuarial, econometric and demographic data for EWARS(Early Warning And Reporting System) applications
• Using available Type-I/II loader transformations as well as custom code to suit the business requirements
• 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

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

Confidential, Des Moines, IA

SAS Data Analyst

Responsibilities:

• Responsible for highly dynamic senior level risk reporting, profiling and summarization of the bank portfolios across multiple business segments
• Segmentation and profiling of customer attributes across 3 credit bureaus.
• Marginalization of the merged portfolios using SAS Programming
• Extensive reporting automation using SAS and Unix shell scripting and MVS history loads using SAS/Connect
• Involved in direct communication with the 3 credit bureaus to assimilate the information regarding 700+ customer profile attributes

Environment: SAS ENTERPRISE GUIDE, MS Excel, Base SAS, SAS/SQL, SAS/MACROS, SAS/BASE, SybaseIQ, SQL Server, RCS, UNIX, UltraEdit, CA7, Control-M, JCL, REXX, EZTRIEVE, FILEAID, ENDEVOR

Confidential, Richmond, VA

SAS Analyst 3

Responsibilities:

• Collaborate with business area to understand business needs, capture supporting requirements and resolve issues
• Developed PC SAS based scorecards for Basel II compliance in the capital market portfolio
• Developed reports and configured libraries to refresh the tables directly into Excel files of the users using AMO
• Conduct walkthroughs of requirement artifacts and communicate effectively with business, development and testing teams to ensure clear understanding of requirements
• 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
• Involved in migrating Unix cron and Control-M jobs on Unix onto SAS Grid on Red hat Linux
• 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
• 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.
• 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, Linux, SAS Grid, AMO

Confidential, Port Washington, NY

SAS EBI Developer

Responsibilities:

• 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
• Solely responsible for entire DQ system of MR reports across different business and product domains
• Extensively used Proc OLAP, Proc Infomap to generate cubes for DQ and custom reporting
• 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
• Used Proc Metalib as well as SAS SMC to configure/alter information of datasets/views/tables etc
• Coded complex MDX codes for OLAP cubes to have a tradeoff between storage space and performance
• Produced reports in excel using SAS add-in, Proc Report and ODS Tagsets
• Developed several reports using SAS Information Map studio to be presented in Excel as well as Web reports
• 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
• 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 SME and end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
• Created SAS programs using the COBOL copybook layouts
• 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
• 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 Programmer-Analyst 2

Responsibilities:

• Developed and implemented strategies to integrate data from over 40 loan-servicing organizations into the SAS data warehouse within standard JAD & SDLC
• Developed Tables, Database links, Synonyms, Stored Procedures, Functions, Packages, Triggers, Cursors, Views, and Indexes in Teradata environment
• Created an automated monthly forecast report for dollars and number of accounts that rolled from current to delinquent using SAS/Macro, Excel
• 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
• Involved in creating Data Marts and performing data validation for scorecard modeling and customer segmentation using logical/physical DM and Teradata-ETL procedures
• Extensively worked with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS.

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, Cron

Confidential, Lafayette, GA

Engineering Intern

Responsibilities:

• Design and Development of free standing induction ranges
• Assist in production ramp lineups and upgrades
• Prepare the spec and test docs
• Involved in competitive analysis using phew matrices, FBD diagrams etc

Environment: Six Sigma, Design, Production