SUMMARY

• Manager Data Analytics / Certified Base SAS Programmer with over 8 years of professional Analytics and IT experience in the field of SAS Technology.
• Experience in design and code development using SAS to compile and analyze large data sets including data step processing, data mining, data manipulation, macro creation, data transformation, variable construction & optimization.
• Experience in software development, design, analysis, coding, implementation, maintenance and support with profound experience in Banking/Financial, Pharmaceuticals, Utilities, Education, Shipping and Insurance domains
• SAS Version Experience: SAS Version 4.1 and SAS Version 5.3
• Extensive experience in working with SAS/BASE, SAS/MACRO, SAS/CART, SAS/Connect, SAS/SQL, SAS/MODELLING, SAS Enterprise Guide, Storing and Managing Data in SAS Files.
• Thorough hands - on experience in using SAS/ODS to generate different files including XML, RTF, MS Excel, PDF and HTML
• Sound knowledge of MS Access, Power Point, Excel and basic knowledge of Tableau
• Extensive experience in various data mining tasks like Base lining, Segmentation and Profiling
• Expertise in analyzing and coordinating trial data, generating reports, tables, listings and graphs using sas procedure steps such as PROC REPORT, PROC SORT, PROC FREQ, PROC MEANS, PROC SQL, PROC TRANSPOSE, PROC APPEND etc.
• Good at creating, reviewing, retrieving, validating Datasets and to read, write, import and export to another data file formats, concatenate, interleave and merge datasets.
• Experience in Business Object for processing data and generating Self-Serve Reports
• Optimized performance using Data Profiling, Data Validation and Data cleansing using Statistical procedures with SAS PROCS.
• Currently undergoing Big Data analytics training

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/REG, SAS/LOGISTICS SAS/STAT, SAS/ODS

SAS EBI: SAS Enterprise Guide, SAS Management Console, SAS DI Studio

Database: DB2 UDB

Tools: MS Office, Business Objects, Tableau, MS Access, CART

Others: Ultra Edit, SAS Drug Development

Environment: Windows 7/NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati

Manager / Data Analyst / Technical Lead

Responsibilities:

• Cross Sell and upsell Analysis for existing customer base using historical data
• Pricing Analysis for current customers & Suggested Price Increase by different models and statistical techniques
• Overdraft Forecasting by analyzing data thereby finding trends and patterns in historical data
• As a project lead / team member - review the analysis and codes of peers
• Coordinate with Client, LOB, Offshore team and Near shore team
• Generating Business Planning and Analysis Reports, sending them to CFO-Commercial LOB on weekly basis and finding out the most and least profitable customers
• Got an appreciation from Client for generating a Business Objects Report that is installed on to the i-Pads of different Treasury Management Officers that highlights Sales and Revenue collected by Sales People reporting to them and also highlights the % target achieved by them across different regions and affiliates
• Generating the report that shows different view & trend’s e.g. realization achieved, number of accounts, number of relationships, investable balances, earning’s credit etc. using historical data
• Extraction and creation of data tables using SAS/Access, SAS/SQL from large scale databases.
• Developed programs to generate derived datasets from raw data imported from sources; modified existing SAS datasets using Data Step, Set, Modify and Merge statements.
• Leading the team with strength of maximum 5 members.
• Segmentation and Scoring (Applying Weightages, Coefficients as per LOB rules), Score card Generation
• Extensive use of PROC SQL to perform queries, join tables

Confidential, Cincinnati

Lead Assistant Manager / Data Analyst

Responsibilities:

• Requirement Gatherings and Business Understandings revolving around the broker’s part
• Created the Data Dictionary and calculated the summary of each variable.
• Extraction, Data Preparation and Data Cleaning thereby making the Master Dataset by using SAS.
• Variable understanding and finding out the Broker’s list that were not following the Fair Lending Rules.
• Sharing out the analysis performed on the Broker’s part and the statistics by which the broker is differentiating between the protected and non-protected class.
• Presenting the analysis performed by the help of PPT’s and Excels to the Client

Confidential

Senior Programmer Analyst

Responsibilities:

• Data Extraction, Data Preparation and Data Cleaning thereby creating a master dataset
• Analyzed the variables that were majorly contributing for profitability
• Compared the costs and revenues of our client with its competitors
• Analyzed the firmographics variables and their relationship with profitability by running CART and SAS procedures
• Created the PPT’s that included recommendations for the client
• Finally suggestions were given to the client based on the analysis performed and also shared the data that supported our hypothesis

Confidential

Senior Programmer Analyst

Responsibilities:

• Data Preparation and Data Cleaning with Outlier treatments (missing value imputation and capping the values of the variables)
• Grouping and Creation of Indicator Variables
• Finding the correlation and Inter correlation in respect to the dependent variables
• Running CART and finding the important patterns and relationships in the data
• Performing Statistical techniques like multi-colinearatiy and variable transformation thereby removing and introducing new variable into model
• Separating the data into Modeling and Validation and thereby applying Proc Logistic
• Analysing the R square ratio and Concordance
• Finally delivered the implementation code to the client for the attrition model so that client can restore the customers by providing them some additional benefits
• Finally suggestions were given to the client based on the analysis performed and also shared the data that supported our hypothesis

Confidential

Senior Programmer Analyst

Responsibilities:

• Did the analysis of the brokers selling health insurance policies & target right broker to sell the right policy as per his age, region and other demographics etc.
• Data preparation for online campaigns executed by the client using SAS and Excel
• Analysis of online pre and post marketing campaigns that company runs and suggesting areas for improvement on regular basis
• Generating MIS Reports on Brokers using SAS reports

Confidential

Clinical Statistical Analyst

Responsibilities:

• Creation of Tables, Field & Listing Reports (TFL’s).
• Report Generation and Validation l
• Dataset Creation and Support
• Validation/Documentation
• Establish reporting database and analyze clinical trial data using SAS

Confidential

SAS Programmer

Responsibilities:

• Key responsibilities was to work as a SAS Administrator responsible for maintenance of
• SAS ETL environment
• Prepared user written code, frameworks for the SAS ETL job
• Worked as ETL Specialist, Responsible for develop and schedule SAS ETL jobs using SAS DI Studio and SAS Management Console
• Also contributed in HLD, LLD and Data Warehouse Designing
• Was part of Qualification Module and responsible for the Qualification data Architecture and designing data model Using IBM RSA tool for Database and Data Warehouse