Amit Gadhavi

ac29ec@r.postjobfree.com

832-***-****

SAS and R Programmer/Data Analyst/Business Analyst with SQL, ETL, R, Hadoop and SAS Development experience.

Areas of Expertise

Industry Expertise

Banking and Finance

Investment Banking

Retail Banking

Commercial Credit Cards

HealthCare and Pharma

Retail and Supply Chain

Functional Expertise

Data Analysis

SAS Development

Retail Banking and Cards business.

SAS Visual Analytics – Designing and Exploration

Risk Management

Cross-Functional Collaboration

Team Leadership & Management

Coaching, Training & Mentoring

Predictive Modeling

Strategic Planning / Tactical Execution

Continuous Process Improvement

Education

Executive MBA – Marketing and HR, IIT Bombay

PG, Banking and Finance, Narsee Monjee, India.

PG, Retail Management, Welingkars, India.

Masters, MSU, MI, USA.

Bachelors in Engineering,

MIT, Pune, India.

Diploma in Engineering,

SBMP, Mumbai, India.

Certifications

SAS Certified Base Professional (A00-211 9.3)

SAS Certified Predictive Modeler (Enterprise Miner 13)

Certified Scrum Master

Oracle Certified SQL Expert professional(1Z0-047)

ISTQB Certification

Tools

SAS 9.3/9.4 Windows

SAS Enterprise Guide 13

SAS Enterprise Miner

SAS Visual Analytics 7.3

SAS Visual Analytics LASR Server

SAS Management Console

SAS Credit Scoring Data Store

SAS Risk Dimensions

Oracle 11g

SQL Server

Teradata

SAS Data Integration Studio

Toad for Hadoop

HUE for Hadoop

SQL Plus

SQL Developer

MS Excel

MS Visio

Jira

ALM

Java Eclipse

R Software

R Studio

Revolutions R

Informatica Power Center

Selenium WebDriver

SAS Access

APPIUM

Tableau.

Languages

SAS

SQL

PLSQL

R

HIVE

IMPALA

JAVA

Operating System

Unix

Linux

Windows

Work Status

H1B

Executive Summary

SAS Certified Professional with 8.5 years of experience working as a Sr. Data/Business Analyst extensively involved with SQL, R, Hadoop and SAS Development.

SAS and SQL Certified. Cleared Global Certifications in Base SAS 9.3, Predictive Modeling using Enterprise Miner 13 as well as Oracle SQL Expert (1Z0-047).

Involved in a SAS-HADOOP integration project at AbbVie that resulted in cost savings of over 200 thousand dollars.

Awarded thrice by Mphasis for excellent work while on a project at JP Morgan Chase Bank.

Knowledgeable with Anti Money Laundering(AML) and Banking concepts. Worked with Retail Banking project dealing with Cards and Credit Risk. Used Base and Advanced SAS programming and performed several ad hoc analyses and created trend reports requested by finance and marketing teams to understand customer/transaction patterns.

Interacted with key stakeholders and business partners to identify gaps with business and provide solutions to drive efficiency. Conducted daily status report calls, communicated progress to business team and coordinated efforts with offshore team.

Extensively used SAS and SQL for analyzing data and understanding customer behavior which helped in customer profiling, market segmentation and performing trend analysis.

Experienced with SAS Visual Analytics Data Builder, SAS Visual Analytics Explorer, SAS Visual Analytics Reports Designer modules. Used SAS Visual Analytics and Tableau for preparing, exploring, analyzing, and interpreting data, creating dashboards and generating customized reports.

Worked with SAS Predictive Modeling for preparing data, building predictive models, assessing models, performing Linear and Logistics regression, scoring new data sets, implementing models, customer segmentation etc.

Experienced in writing/updating Business Requirement Documents (BRD’s) and Functional Requirement Documents (FRD’s).

Experienced with Data analysis, Data warehousing, ETL testing, OLAP, OLTP, SCD – Type 1 and 2, Data mapping and Dimensional modelling experience in decision support systems (Data marts) using Star and Snowflake Schema.

Developed and modified existing SAS programs as well as imported data using SQL Pass Through and Libname engine methods to create tables and extract data from Teradata, SQL Server and Oracle DB.

Extensive experience writing complex SQL and PLSQL queries including Joins, Aggregations, Grouping, Views etc. along with knowledge on Unix and Linux and scheduling Unix jobs.

Strong experience with Excel using VLOOKUP’s, Pivot table’s, Charts, Arrays, Sparkline’s, Outlining, Customized reports.

Successfully integrated SAS with Hadoop and R with Cloudera Hadoop.

Functional Experience

Team Leadership and Management: Was part of the Data Analytics and SAS Development team. Lead the Team meetings and daily status calls and was responsible for updating team members during daily standup meetings on the progress of the work.

Data Integration and ETL Experience: Involved in ETL and Data Migration activities including the HADOOP-SAS integration along with linking databases with Teradata, Oracle and SQL Server. Performed QA validation of data which includes data validation and verification of data on both Source and Target DB’s using SQL and SAS. ETL testing includes knowledge of Type 1 and Type 2 Slowly Changing Dimensions(SCD’s).

Requirements Gathering: Involved in Requirements Gathering and preparing Business Requirements document as well as Technical Specifications. Responsible for writing Functional Requirement Specifications (FRS). Conducted the FRS reviews and walkthroughs with designers, developers and stakeholders.; developed activity and UML diagrams using Visio; presented approach to internal stakeholders.

Training and Mentoring: Mentored analysts on SAS tool and oversaw the SAS development activity. Trained new joiners on the various business and test scenarios.

ABBVIE INC, Vernon Hills, IL May 2017– Present

SAS/R Programmer with Hadoop integration

Working as a SAS and R Programmer in the Data warehousing and Business Intelligence team. Involved with SAS-Hadoop, SAS-Teradata, SAS-Oracle and R-Hadoop integration, working on AD-HOC reports and in the verification and validation of data.

Involved in a SAS-HADOOP integration project at AbbVie that resulted in cost savings of over 200 thousand dollars.

Working on AD-HOC SAS and R reports for various Sales and Marketing teams to be used in various targeted campaigns.

Using SAS Access to Teradata and Oracle to connect with the Teradata and Oracle tables using libname, Filename and SQL Pass Through methods and validated results against results generated from Teradata SQL Assistant. Performed complex SQL joins, SAS sorting, de-duping and merges along with using SAS Macros for repetitive tasks including shrinking data, exporting log results etc.

Engaged with the business team to get the requirements and design/create SAS programs as per the requirements.

Integrating SAS 9.4 with Cloudera Hadoop 5.9 version using SAS Access Interface to ODBC by using libname and SQL Pass through methods to connect with Hadoop and generating AD-HOC reports.

Using Sparklyr and Imlyr packages to integrate R with Hadoop along with establishing ODBC connection in order to write queries in R to meet customer specific requests for tables present in Hadoop’s HDFS and HIVE Layers.

Using Unix and Linux codes to transfer data from local Landing directory to Hadoop using Hadoop fs commands. Used HUE Interface for Hadoop to verify the tables on the front end.

Rang Technologies, Piscataway, NJ Feb 2017 – April 2017

SAS/R Developer

Worked as a SAS and R Programmer and as a SAS Visual Analytics Developer.

Worked as a SAS VA developer and extracted data from Hadoop into SAS and then migrated datasets on SAS LASR Analytics server using hdat and sasiola to use this data for Visual Analytics Designing and Exploration.

Used SAS Enterprise Guide to write queries in SAS and create tables using proc sql and SAS queries and then finally transfer the tables to the Designer section using SAS LASR Analytics Server and create Visual Analytic reports in SAS VA which are then used for visual analytics exploration.

Used SAS Visual Analytics Designer module for creating reports – inserting objects into reports, using different tables and graphs to display results, used different container objects like vertical, horizontal, prompt containers in reports, used calculated and aggregated items, created new hierarchy, inserted images, used stored process, used gauges to display status of variables, used customer graphs to display results, worked with interactions, parameters report links and ranked values in reports.

Explored Marketing data using R programming's statistical analyses methods quantifying and identifying the most effective Sales periods.

JP Morgan Chase Bank, Jersey City, NJ JAN 2014– FEB 2017

Module Lead/Technical Data Analyst

Supported data integration, data migration and data validation and verification for JP Morgan Chase Bank’s Business Intelligence team.

My responsibilities involved Data Integration and Data Migration using Base SAS 9.3 with Oracle, SQL Server and Teradata engines and using SQL Pass through and Libname methods to integrate and import data from these databases, involved with writing SAS Macros and data transformation and creating datasets and then transferred data to SAS LASR Analytic Server for Data Visualization using SAS Visual Analytics Designer module. Assisted with UAT testing efforts like planning UAT test scenarios and test cases and sending daily Status reports and engaged in Daily Status calls with client and developers. Worked with End-Users of reports/BI tools to understand their issues and solve them for each release.

Used SAS Credit Scoring Detailed Data Store and segmented customers based on their consumer patterns which include frequent shoppers, occasional shoppers and dormant customers, etc. and performed trend analysis on customer behavior and patterns. Analyzed customer data which included Behavioral models, Customer Profiling, Segmentation, Trend Analysis, Predictive Modeling, Lift modeling and Validation using SAS and SQL.

Developed and modified existing SAS programs as well as imported data using SQL Pass Through and Libname engine methods to extract data from the Teradata, SQL Server and Oracle DB as well as create tables in Teradata, SQL Server and Oracle.

Developed architecture, business logic and database structure of the project as per business requirements.

Worked on several business AD-HOC report requests and used SAS and R programming to deliver the results.

Imported data from Hadoop into SAS and performed data transformation using SQL queries to generate customized results and save results into respective data sets. Also, imported data from various datasets including flat files, excel, csv etc. and generated output files in the form of listing, HTML, RTF and PDF formats using SAS ODS. Created dashboards and customized reports using Tableau.

Developed/assisted in creating customer models, forecasting models, customer segmentation analysis, exclusively used SAS Enterprise Guide to gather data (ETL), data modeling, validate models and prepare reports.

Build and execute SQL queries for data mining, data quality, data profiling and data trend and data structure analysis.

Created joins, joins with custom SQL & blended data from different data sources using Tableau Desktop and created dashboards and reports using Visual Analytics and Tableau.

Verified data on Source and Target side of ETL, verified data completeness and transformation rules, tested referential relation and integrity of data as per requirement specification documentation, checked for duplication of records and/or data errors.

Extensively used Excel for VLOOKUP’s and Pivot tables to generate customized reports for client and help with immediate firsthand identification of problems.

Skynet Solutions JAN 2013 – SEP 2013

Data Analyst/Developer

Worked as a Data Analyst using SAS and SQL, involved with database migration and data warehousing project. Created SAS Data sets as per requirements and validated data using SAS and SQL.

Worked on ensuring Data Completeness, Data Transformation, Data profiling & Data Quality for various data feeds coming from source.

Created workflow and process flow Visio diagrams reflecting current and proposed business processes and site functionality.

Wrote requirement specification, user stories, acceptance criteria, test cases and used Jira as ticket management tool and confluence for documentation

Used SQL queries/joins to query SQL Server databases for data analysis and documentation of data flow and data processes for ETL Migration.

Created Data Mapping Documents and Source to Target Transformation document for ETL / Data Warehouse.

Planned and conducted requirements, elicitation meetings with the business to collect functional and non-functional requirements relating to client's enhancement initiatives.

Used SQL queries to extract data from different databases including testing and production for data validation and data analysis.

Regularly worked on data issues from the client perspective and converting them into data mapping and data validations.

Designed and developed Use Cases, Use Case Diagrams, Workflow diagrams and Activity Diagrams by using UML and Visio.

Validated and verified data using various SQL queries including Joins, Aggregate functions, Group by etc.

JP Morgan Chase Bank MAY 2011-DEC 2012

Data/Business Analyst

Was part of the Data Analytics and Market Analysts team responsible for working in line with the retail banking team to mine and analyze data to understand channel dynamics and customer behavior, improve online marketing efforts, and optimize merchandising strategy for key online retailers. Was also part of the Data Migrations and Data Integration team using SAS and SQL.

Developed and automate daily, weekly, monthly, and seasonal reporting/scorecards to monitor the health of the online business as well as share business insights with marketing, product development, sales, and finance stakeholders using SAS and SQL and generated customized reports for client.

Ensured data integrity and testing processes are followed for reporting and research tools. Worked with internal and vendor support teams to report and resolve data discrepancies.

Supported data and analytics requests throughout the development cycle including gathering data requirements, sourcing and validating data, analyzing data, building models, synthesizing insights, and presenting results.

Analyzed performance and impact of digital marketing and merchandising investments with key e-retailer accounts to determine customer impact and return on investment (ROI) (for both online and in-store purchases).

Applied multivariate statistical tools to help build predictive models, improve customer segmentation, optimize approach to online pricing, and improve elements of the digital marketing mix.

Worked on Legacy and Payment Net 3 "Migrations" project focused on transferring important customer information from one database system to another due to recent up-gradations. Worked on Payment Net database network and conducting back-end validation with Oracle and MS SQL Server and ensured that all data is correctly migrated from SQL Server and Oracle databases to SAS Data warehouse. Validating results by writing SQL queries and then comparing with original data using tools like Beyond Compare.

Designed and implemented SQL queries for QA testing and report / data validation.

Validated and verified stored in DB2 database using SQL queries prepared status summary reports with details of executed, passed and failed test cases.

Validating fields in UI with those in Database along with testing various scenarios in Database by writing complex queries. Also worked towards improvement of SQL queries. Performed Regression testing during the Testing phase to ensure a new improvement has not affected/modified the existing functionality.

Involved in Database ETL migration project from SQL Server to Oracle database and which involved extensive usage of SQL queries to validate and verify the proper and complete migration. Logged defects in ALM to reports issues with migration. Tracked the Slowly changing dimensions that change over time to help with understanding of current and historic data.

Was part of the Legacy Migrations team along with handling the PNET3/P4 Migrations. Extensively used UNIX to run batch jobs and perform backend validation.

Writing complex SQL queries and modifying the queries in Oracle and SQL Server and validating the results against existing data using a tool called Beyond Compare.

Developed and automate daily, weekly, monthly, and seasonal reporting/scorecards to monitor the health of the online business as well as share business insights with marketing, product development, sales, and finance stakeholders.

Using SAS Predictive Modeling created data sources in Enterprise Miner, explored and assessed data sources, build predictive models using regression analysis (linear and logistics), decision trees and neural networks, used fit statistic for different predictions, used decision processing for adjusting over sampling, used profit/loss information for assessing model performance and for comparison of models and forecasting.

CANVAS INFOTECH NOV 2010-APRIL 2011.

Data/Business Systems Analyst.

Involved in data verification, data manipulation and coding activities including the usage of basic and standard SAS procedures, SQL queries and Macro coding. Involved with Data migration upgradation project which included migration of data from SQL Server to Oracle and then into SAS.

Imported data from various sources into SAS and was involved with data migration project and upgradation project using SAS. Migrated from SAS version 8.0 to 9.0.

Involved in verification of programming logic by overseeing the preparation of test data, testing and debugging of programs. Worked with the development of test plans, test scenarios and test strategies to facilitate the process of testing. Also involved in Analysis, Design, and Functional Specifications to identify Test Requirements, Design Test Cases, Test Scripts, and Test Data with expected output.

Involved with Data Migration and ETL testing project using complex SQL queries. Used various SQL queries including Joins, Union, Aggregate functions, Group by, Inline views, transpose etc. for validating data.

Using the data mapping document or the requirements document, created detailed test cases for each phase of the ETL process. The test cases checked for the required columns, old versus new changes, data integrity etc. The test cases included detailed description, expected versus actual results comparison etc.

Used SAS and SQL queries to perform data validation and verification.

GENENTECH INC. MAY 2009- OCT 2010.

QA Engineer/Data Analyst

Worked here as an Analyst and was involved in computer systems validation, in accordance with FDA regulations, particularly CFR 21, Part 11 and GAMP 5. Validated processes and equipment utilized to manufacture active pharmaceutical ingredients in FDA environment and wrote and updated SOP’s for each individual equipment as well as the entire pharmaceutical process. Involved with implementing Scrum and Agile methodologies. Used SQL and Advanced SQL queries to validate data.

Internships:

Internships successfully completed at,

IBM, Research Triangle Park, Raleigh, North Carolina (2007) – Supply Chain and Logistics division

Pliant Corporation, Newport News, Virginia (2007) – Food Packaging division

Precious Plasto Packing Pvt. Ltd., Mumbai, India (2001) – Cosmetics Packaging Division

Abhijeet Dies and Tools Pvt. Ltd., Mumbai, India (2000) – Mold Manufacturing Division

PARC, Reliance, Mumbai, India (2003) – Polymer Characterization and Analysis Division

Awards, Design Contests and Publications:

Involved in a SAS-HADOOP integration project at AbbVie that resulted in cost savings of over 200 thousand dollars.

1ST Prize Winner of the Flexible Packaging Association’s Best Student Intern Award in 2007 for excellent performance while on an internship assignment at Pliant Corporation working in their Research and Development group.

Topper at Welingkar School of Management (Retail Management program) – Top B Schools in India.

Secured a first class 65% at Narsee Monjee (NMIMS), Banking and Finance program in four Sems. - Top B Schools in India.

Receiver of salary hike at JP Morgan Chase Bank for good work performance with a revision of salary and benefits.

Receiver of best performer award from Mphasis thrice for excellent work at JP Morgan Chase Bank.

Receiver of bonus amount from Genentech Inc. in the year 2009.

Won 2nd Prize in the DuPont Design Challenge by creating a package for “Veterinary Disinfectants”.

Was selected for Diageo and Johnson and Johnson(GS1) in-house projects for Michigan State University.

Was awarded a scholarship grant from Michigan State University in 1st year for strong overall performance in academics and extra-curricular activities.

Designed an innovative Condom Package for Amcor Flexibles by participating in its design challenge.

Presented 11 technical papers at both state and national levels and won four prizes while presenting papers on topics like Enteric Coatings and Ionic Liquids at these levels. Won 3rd prize at IIT Roorkee (National Level) for works in Nanomedicine and Enteric coatings and bagged two top awards at State Level for works in Ionic Liquids.

Receiver of JRD Tata Scholarship for securing distinction and for being one of the rank holders in Diploma Engineering at Shri Bhagubhai Mafatlal Polytechnic.

Receiver of University and Government Scholarship grants at Bachelors level during third and final year of studies. Paper published: - Dr. G.M.Joshi, A.Gadhavi, Mrs.G.G.Joshi, “Dye Sensitized Solar Cells”, Chemical Weekly, 203 (Nov.9 2004).

Worked with Dr. S. Radhakrishnan (Scientist F), Deputy Director, National Chemical Laboratory, Pune and successfully completed project on Ternary blends and also had submitted findings from the Bachelors project for publication in the Journal of Applied Polymer Science (JAPS).

Contact this candidate