Anand Gupta

ETL & Data Warehouse Consultant

acrszm@r.postjobfree.com

517-***-****

https://www.linkedin.com/pub/anand-gupta/17/ab3/b09

SUMMARY

Over seven years of experience in software implementation and technology consulting at tier-1 multi-national organizations. An expert in ETL (Extract Transform Load), Data Modeling and EDW(Enterprise Data Warehouse) implementation with ETL and Data Modeling experience of five projects and EDW experience of two projects, winning several awards for project performances. Pursuing, Master of Business and Information Systems (with 3.85 GPA) from New Jersey Institute of Technology University.

SKILLS & TECHNOLOGIES

Team Lead

Technology Consultant

Requirement Analyst

Data Migration

ETL (Extract Transform Load)

Informatica PowerCenter

Informatica Power Exchange

Siebel Sales & Service (Call Center)

CDC (Change Data Capture)

Enterprise Data Warehouse

Siebel CTMS (eClinical)

Siebel EIM (Enterprise Integration Manager)

Customer Relationship Management

MS Office

Clinical Trial Management System

Toad, SQL Developer

Universal Customer Master

SQL (Oracle, Microsoft)Oracle PLSQL

EXPERIENCE (7+ years)

New Jersey Institute of Technology University

Database & Business Intelligence Expert

May 2015 – Jul 2015

Researched and Extracted raw environmental data from internet

Analyzed the data and designed the appropriate data model to store that data

Transformed and Loaded the environmental data into the data model (created in MS SQL database)

Created some analytical queries to address the business requirements

Graphically reported certain trends and patterns from the analytical data

Received 95% satisfaction from Professor

Tools Used: Microsoft Office, Microsoft SQL server

Ernst & Young

Testing consultant and test lead

Oct 2014 – Dec 2014

Provided software testing consultancy to a multinational conglomerate

Devised the test plan and the testing strategy for a CEO level reporting system

Enhanced the entire testing process, saving time & effort by 60% and cost by 50%

Tools Used: Microsoft Office

Data Modeling Consultant

Jul 2014 – Sep 2014

Provided data modeling consultancy to a major bank of Poland

Served as an offshore team lead, coordinated with onsite EY Team and owned the offshore delivery

Assisted onsite team in Conducting workshops for the client to discuss the existing system & future requirements, by providing the material for the workshop

Tools Used: Microsoft Office

Technology Consultant

May 2014 – Jun 2014

Provided consultancy to a European Automobile major for EDW implementation

Assisted manager in creating the business proposal

Presented the business proposal and technical solution to the client

Tools Used: Microsoft Office

Price Waterhouse Coopers

ETL Lead & Technology Consultant

Nov 2012 – Apr 2014

Implemented Enterprise Data Warehouse(EDW) for a major bank of India

Provided consultancy to the client regarding the tools and technology for EDW implementation

Devised the Data Extraction / Migration Strategy on the basis of Business Requirements

Assisted Data Modeling team for the designing the data model for entire EDW

Served as the module lead of ETL team for the biggest EDW implementation program across PWC and delivered the ETL module with near zero defects

Lead the development team consisting of twelve associates

Established and trained the support team for phase I

Won the “Above and Beyond Performer” award for demonstrating exemplary performance and for outstanding contribution, which resulted in business advantage.

Tools Used: Oracle DB, SQL Developer, Informatica Power Centre(8.x), Informatica Power Exchange, Microsoft Office, ERWin

Capgemini

Siebel EIM and ETL developer

Jun 2012 – Oct 2012

Implemented Siebel UCM project for a major cruise lines of USA

Designed & Developed data synchronization and data loading process

(UTS) Unit Test Scripts preparation

Tools Used: SQL Developer, Informatica Power Centre(8.x), Siebel 8.0.x tools, Microsoft Office

Siebel EIM and ETL developer

Jul 2010 – May 2012

Implemented Siebel CTMS (Clinical Trial Management System) for a US Pharmaceutical Major

Served as the Siebel EIM and Informatica ETL lead developer

Conducted peer reviews of design and code

Created comprehensive Unit Test Scripts

Framed the testing strategy for data related testing

Provided Siebel EIM and Informatica ETL training

Won “Best Team” award

Tools Used: Oracle DB, SQL Developer, Informatica Power Centre(8.x), Siebel 8.0.x tools, Microsoft Office

Tata Consultancy Services

Siebel CRM Data Lead

Nov2007 – Jun 2010

Analyzed business processes for major banking group

Served as the data module lead, managing a team of five developers

Devised Proof of Concept, saving over $50,000 in terms of project investment and license costs

Trained the trainers on Customer Relationship Management Software application

Planned and Executed go live process for entire data module in a very strict time window

Won Tata Consultancy Services “GEM” award for best team

Won “Star of the month” award for excellent contribution to the project

Tools Used: Siebel 8.0.x tools, Oracle DB, SQL Developer, Microsoft Office

EDUCATION

New Jersey Institute of Technology University

Jan 2015 – Till Date

Master of Business & Information Systems

GPA 3.85

Hindustan College of Science & Technology

Aug 2003 – July 2007

Bachelor of Technology, Computer Science

GPA 3.02

Contact this candidate