SUMMARY

• Over 7+ years of Professional Experience in Data analysis, Database marketing, Customer profiling, SAS Programming, Statistical Analysis, Market data Analysis, Risk Analysis and modeling, Credit scoring, RFM analysis, Text Mining, Pattern Recognition Web Analytics and Base - SAS Certified programmer/analyst.
• Experience with credit card, debit card, banking, retail data.
• Experience in creating thoughtful analytics to address business issues and independently generated forward-looking solutions.
• Functional knowledge of risk management principles and credit card terms within financial services industry.
• Experience in buildingRisk score modelsfor controlling Fraud and increase the customer traffic.
• Experience in creating and automating daily, weekly, monthly, Profitability analysis reportsfor credit/debit card products.
• Experience in analyzing the data forDirect mail Campaign’s, Former customers, new customers, ITA (Invitation to Approval)
• Expertise in processing large datasets with millions of records for data transformation and data modeling including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Experience in various advance SAS Tools such as Clustering and segmentation, self-organizing maps(SOM) Kohonen, Support Vector Machines (SVMs), Two stage models, component models, customer attrition and churn models via survival analysis, credit scoring models, Customer Lifetime Value (LTV) Analysis, Text Mining and basic SAS tools such as Regression (Linear, Logistic), Decision Trees, Neural Networks, GLM, Gradient Boosting, Memory Based Reasoning (MBR), RFM Analysis, Time Series Analysis, t-test.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macros, SAS/Enterprise Guide, SAS/Enterprise Miner, SAS/Share, SAS Enterprise BI Server, and SAS Management Console.
• Proficient in the following reporting and statistical procedures:REPORT, SQL, APPEND, DATASET,TABULATE, FREQ, MEANS, UNIVARIATE, TTEST, CORR, PRINT, REG, GLM, ANOVA, IMPORT,SUMMARY, LIFETEST, TRANSPOSE, COMPARE, EXPORT, COPY, CONTENTS.
• Experience in using SAS to import/export data to external file formats like flat, Excel, XML files.
• Experience inData Extraction,Transformation,Loading, Analysis,and MIS Reportsfor Banking.
• Created complex and reusable MACROS, extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Experience in the BI Suite in SAS including SAS Enterprise guide, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Data Integration Studio and Information Map Studio.
• Experience with SAS Business Intelligence Platform: SAS add-in for Excel, Web Report studio, Dashboards, JMP
• Experience in utilizing statistical software packages (SAS, R, IBM SPSS Modeler, Tableau, and Rapid Miner) to summarize data, perform analysis, and model building.
• Experience in developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Experience with SQL programming and reporting.
• Exposure on every step of entire software development life cycle (SDLC) including data collection, query, modifying and analysis, coding statistical models, summarizing the findings, and presenting the results.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
• Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Windows and UNIX
• Experience in creating test cases to make sure the data originating from source is making into target properly in the right format.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r 7.1/7.2,7.3 and ER Studio

OLAP Tools: Microsoft Analysis Services, Cognos, Business Objects, and Crystal Reports 9

ETL Tools: Microsoft SSIS and SSRS and Informatica

Programming Languages: SQL, PL/SQL, DDL, DML, Base SAS and SAS/SQL, HTML, XML, VB.NET

Database Tools: Microsoft SQL Server / 2008 R2, Teradata, Oracle 10g/9i, and MS Access

Packages: Microsoft Office Suite, MS Excel, Microsoft Project 2010, SAP and Microsoft Visio, Power BI, Share point Portal Server 2003/2007

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center,Rational Functional Tester

PROFESSIONAL EXPERIENCE

Confidential, Norwalk, CT

Sr. SAS Analyst

Responsibilities:

• Developed PD scorecards using Credit Scoring nodes in Enterprise Miner. Run various interactive grouping nodes and inspected results.
• Preprocessed data for LGD modeling using linear regression and performed predictive modeling using various drivers like debt type, seniority, industry impact, firm impact, economy impact.
• Analyzed Cumulative accuracy profiles (CAP) for PD modeling, Exposure at Default (EAD) modeling for revolving credit.
• Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel.
• Maintained and enhanced existingSASreporting programs for marketing campaigns. Involved in the code review to make sure the output is as we expected and the efficiency is met.
• Performed ETL tasks in extracting the data from databases using SAS procedures like SAS/SQL, SAS/Access and creation of datasets.
• Used proprietary statistics tool to test how the marketing campaigns fared.
• Performing data analysis, data migration, data preparation, graphical presentation, Statistical analysis, reporting, validation and Documentation.
• Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures.
• Actively involved in analyzing the credit cardcampaigndata usingSASEnterprise Guide and used to analyze competitor's data forecasted results for new credit card offers by region.
• Retrieved the original data and convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Maintain and enhance existingSASreporting programs for marketingcampaigns.
• Interactively meeting the teams for getting the required data to generate the reports as per business requirements.
• Created UNIX Korn shell scripts to export environment variables and deleted old files.
• Developing and analyzing key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL
• Developing SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS, etc for statistical analysis and data displays
• Generating reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN, PROC GPLOT and PROC GCHART.
• Cubes are built using the Teradata, Netezza tables and created some intermediate required data sets which will be joined using the Cube Studio.
• Built summary reports after identifying customers, occupancy period and revenue generated using PROC SUMMARY, MEANS and FREQ. Updated Revenue item table on a daily basis.
• Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and PowerPoint as well
• Used the JDBC for data retrieval from the database for various inquiries. Performed purification of the application database entries using Oracle 10g.
• Documented purpose and methods used in each SAS program.

Environment: SAS9.3,UNIX (AIX 5.2), XP, Base SAS v9, VI Editor, SAS Enterprise Guide, SAS/MACRO, SAS/GRAPH, SAS/STAT, MS Excel, Oracle 10g

Confidential, San Jose, CA

Sr. SAS Analyst

Responsibilities:

• Responsible for creating functional specs, ETL design documents, data mapping documents, process flow diagrams, gathering business requirement, using MS Visio.
• Actively involved in production support, process improvements, optimization, developing new ETL processes, and modifying existing SAS and SQL codes to make them more efficient.
• Accountable for advance analysis of corporate databases from different perspective of view through certain SAS procedures like Proc Summary, Proc Print, Proc Means, Proc Freq, Proc Report, Proc Sort, Proc Tabulate, Proc Contents, and Proc Transpose.
• Developed stored processes, information maps and web reports by using SAS Enterprise Guide, SAS Information Map Studio and SAS Web Report Studio
• Used DB visualizer to analyze and query from the ORACLE and SYBASE and developed Stored Processes to distribute reports and in a secure manner
• Involved in detecting, describing and verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system
• Created install scripts for deploying the database to Test, UAT and production environments.
• Also created complex Stored Procedures, SSIS packages, Views and other SQL joins and statements for different applications
• Involved in huge datasets.
• Worked on AD-HOC reporting.
• Work with Marketing to develop targeted campaigns for recruitment to annual events
• Involved in defining Sybase tables under workspace schema and writing load scripts to load Sybase tables in development environment for testing purpose and performing database anomalies like Insert, Delete and Update
• Developed programs and perform unit test using SAS, DB2, SQL and Clear quest.
• Assisted in User Acceptance Testing (UAT), Regression Testing, and Systems Integration Testing.
• Retrieving Millions of Records through DB2 tables.
• Maintained and enhanced existingSASreporting programs for marketingcampaigns.
• Performed Data de-duplication on working with several millions of records and data points.
• Extensively used SQL statement functionalities for analysis of large datasets (Billions records) and for data manipulation and distribution
• Used SAS Data Step logics to Sort, Merge, Stack, Update, Array, Retain and Interleave datasets for producing required analysis of data and used SAS Business Intelligence to produce required Reports
• Modified macros for report generation using SAS Macros as per the requirements and used Excel tagsetxp to create multiple worksheet in XML version of report in MS Excel
• Used various MACRO debug options such as MPRINT, SYMBOLGEN, MLOGIC, MFILE to Debug stored process and SAS codes
• Created different types of output files in different format like PDF, EXCEL, HTML and TEXT DELIMITED FILE
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros
• Worked directly with client to understand their business requirements and create standard and custom reports

Environment: SAS 9.2, SAS/EBI, SAS/EG, SAS/Information Map, SAS/Web Report Studio, SAS/SQL, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/GRAPH, SAS/MACRO, SAS/XML Mapper, Oracle 10g, Sybase, Microsoft Excel, SQL Developer, PL/SQL, Windows XP, UNIX, DB Visualizer, MS Visio.

Confidential

Sr. SAS Analyst

Responsibilities:

• Worked with business users to design and develop several ad-hoc reports and information maps using Proc Report and Proc Tabulate
• The reports created include Monthly summary reports as well as detailed weekly reports
• Connected to the DB2 database and extracted the relevant data (using LIBNAME or Pass-through facility) and then processed the data using business logic to produce reports.
• Made heavy use of Proc SQL, Proc Report and ODS for producing these complex reports
• Developed online claims reporting system to retrieve client records and create SAS Proc tabulate tables, Proc Freq, Proc Means, and Proc Report
• Creating excel pivot table reports using Cycle Time data. These reports consist of Benefit level data, claims level data.
• These reports are very useful to get a greater insight into the further plan design.
• Extensively used SAS Data Steps, Statistical models, and Flowchart Design, Listing, Graphing, Summarizing and Reporting procedures
• Performed variety of tasks including data extraction, manipulation, Analysis using claims data
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining
• Tested and executed marketing campaigns using SAS Marketing Automation
• Used EDW processes for replacing the existing data, updating and appending the data and this data is used for generating reports as per the requirement
• Created various transformation procedures by using SAS ETL and SAS Enterprise guide
• SAS Procedures used are Proc Append, Macros, Import and Export, Proc Transpose, Proc Datasets
• Collected and maintained the customer information through CIS
• Developed and deployed SAS OLAP cubes for browsing of financial data via the SAS Information Delivery Portal
• Proficient in sorting, merging and using different table lookup techniques to get the required information to generate the report
• Handled the tasks of writing reports and manipulating data by using Unix platforms
• Produced reports and complex data analyses using SAS, including SAS/stats, extracted data from MVS and Oracle files using SAS/Views, SAS Proc SQL and SQL
• Debugging SAS programs using data null, Put statements and using datastep debug
• Generated automated graphs for monthly run using Proc Gplot. Exported these graphs to Pdf File using SAS/ODS
• Customizing the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros
• Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data
• Developing the Unix shell scripts in order to run the report as a part of daily schedule
• Exported SAS Reports to the Excel sheet by using ODS/Tagsets/ Excel XP to get output in multisheets
• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting
• Expert in preparing Analysis Datasets, Tables, Listings, and Graphs according to the Business Requirement

Environment: SAS/Enterprise Guide, SAS/Base, SAS/Macros, SAS/SQL, SAS/ETL, SAS/Graph, SAS/ODS, SAS/Stat, SAS Marketing Automation 5.4, Excel, MS Access, Windows, SQL Server, MS office and Unix.

Confidential

Sr. SAS Analyst

Responsibilities:

• Responsible for analyzing commercial customer’s banking data, demographic data, sales and revenue data, mortgage data and credit card transaction data and subset them in a group with associated risks.
• Identified the associated risk by analyzing different analytical data models which includes number of years in business, business locations, profit and loss ratio, annual earnings, assets, investments, shareholders, and dividends percentage
• Created new financial tables and manipulated customer data by using various joins and merges and then appended the data Proc append from the existing source tables containing millions of records.
• Created intricate set of SQL tables to hold user login and user access information with constraints and access errors were logged in to error tables
• Retrieving Millions of Records Using different Procedures.
• Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, PROC CORR, PROC COMP, PROC MANOVA, PROC GLM, PROC PRINT, PROC GPLOT, PROC RANK, and PROC ANOVA.
• Wrote complex SAS, SQL and Korn Shell script to manipulate data as per business rules, upload in to the warehouse tables and create reports.
• Worked extensively in sorting, merging, concatenating and modifying SAS Data sets and read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• Involved in requirements gathering and project documentation and also involved in the data analysis, DB creation, applying database constraints and make ready to load onto database.
• Accountable for developing the UNIX Korn shell scripting for execution of SAS jobs on timely bases as well as for execution of SAS programs according to logical order.
• Loaded data from flat files to Teradata Databases and extracted data from database (Oracle) using SAS ETL through SAS/ACCESS and created SAS datasets.
• Extensively used procedures like TRANSPOSE, TABULATE, SORT, IMPORT, EXPORT, COPY, etc. in Data Transformation and Manipulation processes.
• Created reports in different file formats (RTF, PDF, Excel and HTML) using ODS statements and also created summary tables, listed outputs and generated ad-hoc reports.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS Enterprise Guide, SAS/Graph, SAS/SQL
• Extensive use of SAS/ACCESS, SAS/CONNECT to connect to various databases (TERADATA, DB2, SQL SERVER) such as development and production database (DB2 on UNIX)
• Performed extraction, transformation and loading from large Sybase tables using SAS/ETL in data-warehouse.
• Passed parameters in bat files to read daily and on request jobs to reduce complexity of business process
• Investigated and fixed several issues and suggested new output formats to satisfy the business requirements.

Environment: SAS/BASE, SAS/EBI, SAS/DI Studio, SAS/STAT, SAS/SQL, PL/SQL, SAS/MACROS, SAS/ODS, SAS/ACCESS and SAS/CONNECT, SAS/Enterprise Guide, SAS/Web Report Studio, TERADATA, DB2, SQL Server, Reflection, Putty, WinSQL, WINDOWS, UNIX.