Candidates About

 

Rishabh Gulati

 

SUMMARY

·         An experienced Information Technology professional with over 15 years of comprehensive experience in Data Warehousing and Business Intelligence initiatives

·         In depth Technical expertise with experience of multiple end to end data warehouse implementations, migration, and testing and support assignments.

·         Excellent mix of Technical and Project Management skills.

·         Strong project management experience with the ability to manage teams located across multiple geographies

·         Experienced working with multiple domains including Aviation, Marketing, Healthcare, Banking, Media and Entertainment

 

Education / Training

Bachelors of Engineering, Computer Science and Engineering, 2002

Work Status

Green Card / Permanent Resident

 

Technical Skills

ETL Tools – Informatica (5.x, 6.x, 7.x, 8.x, 9.x) , IDQ, IDE, SSIS

RDBMS – Oracle 11/10g, SQL, Teradata, PL/SQL, SQL server

Sources – Flat Files, SFDC, AS400

Data Modeling –MS Visio 2007/2010

Operating Systems –Windows NT 4.0, UNIX, Linux

Methodologies: ER/Multidimensional Modeling (Star/Snowflake)

Report Tools – TIBCO Spotfire, Business Objects, Crystal Reports, Flex

Agile – JIRA, R ( Coursera Certified)

 

Awards:

·         GE-NBC Award for Excellence in Project Execution – 2009

·         GE-NBC Award for Successful implementation of Digital Dashboards- Q4 2009

·         GE-NBC Award for Successful migration of traffic systems - Q2 2009

·         GE-NBC Award for reduction in manual intervention – 2008

·         GE-NBC Award for Successful implementation of Data Mart at Beijing Olympics 2008

·         GE-NBC for process improvements and automation resulted in saving ~USD 2 MM

 

PROFESSIONAL EXPERIENCE

 

Employer: Fifth Third Bank                                                                                          Feb 2016 – Till Date

Location:  Cincinnati, OH

 

Role:  Lead Analyst / Architect

I interact with Business users to understand end to end scope of work both from data and reporting standpoint. Translate requirements understandable by various team. Responsible for building the ETL / Reporting architecture and ensuring the requirements are covered

·         Gather technical and functional requirements for the project

·         Architect ETL/reporting solutions.

·         Build reports using Business Objects and Tableau

·         Manage, monitor and review progress of team members spread across geographies

·         Build scalable data model based on best practices and requirements

·         Build and manage project plans

·         Write extensive queries for reporting, data extracts and data profiling

·         Provided End-user support for every release cycle to get the systems stable and familiar to support teams.

·         Improve DB performance using Oracle partitioning and indexing / Netezza

·         Build and implement data models

 

Technology Stack:

Informatica 9.x , Data Stage,  Oracle 11g, DB2, PL/SQL, SQL Developer, Tableau, UNIX Shell Scripting,

 

Client: GE Aviation                                                                                                                         Sep 2013 – Jan 2016

Employer: Tech Mahindra America’s

Location:  Cincinnati, OH

 

Role:  Data Analyst / Lead

·         Gather technical and functional requirements for the project

·         Help in architecting data/reporting solutions.

·         Build reports using spotfire

·         Manage, monitor and review progress of team members spread across geographies

·         Present solutions to clients and senior executives

·         Build and track project plans

·         Build scalable data model based on best practices and requirements

·         Help with the development, test and maintain ETL using both ETL tools and custom PL/SQL

·         Write extensive queries for reporting, data extracts and data profiling

·         Provided End-user support for every release cycle to get the systems stable and familiar to support teams.

·         Improve DB performance using Oracle partitioning and indexing

·         Ensure reports are built in-line with the user requirements.

 

Technology Stack:

Informatica 9.x , Oracle 11g, Teradata, PL/SQL, SQL Developer, TIBCO Spotfire, UNIX Shell Scripting, UNIX/Windows, TIBCO Spotfire

 

Client:                  Targetbase                                                                                                         Apr   2010 – Aug 2013

Employer:           iGATE Corporation

Location:             Dallas, TX                           

Targetbase is one of the leading Direct Marketing agencies. They have been rated as one of the best by Forester wave. Targetbase caters to Tier 1 clients automotive, retail, pharma, healthcare clients, etc and help run email, direct mail campaigns, etc.

 

Role:  Data Analyst / Specilist

Interacted with Business users, Developers, Customer service team and Functional consultants to identify business requirements and data realties. Helped them design several re-usable mappings and components. Also, helped them setup data cleansing using Informatica IDQ and IDE profiling.

·         Gather technical and functional requirements for the project

·         Architect ETL solutions and monitor and review progress of team members

·         Built several re-usable mappings to be used for new clients

·         Build custom validation plans using IDQ

·         Develop, test and maintain ETL using both ETL tools and custom PL/SQL

·         Interacted with Business and Technical teams to implement enhancements and change requests

·         Leveraged the migration  to use parameter files and implement standards

·         Provided several adhoc reports using SQL and ETL outputs

·         Interact with business users and provide user lists on multiple criterias

·         Forecasting trends ( YoY, STLY, QoQ, etc )

·         Filter campaign data based on multiple lists Business Users, Consumers, Prison, Profanity, etc

 

Technology Stack:

Informatica Power Center, Informatica Data Quality, Informatica Data Explorer, OBIEE, Visio Modeling, Oracle 11, Flat Files, UNIX Shell Scripting, UNICA ( no hands on experience )

 

Client:                  GE NBC Universal                                                                                             Mar 2006– Apr 2010

Employer:           iGATE Corporation

Location:             NY,NY

GE - NBC (now acquired by Comcast) is one of the leading Media companies with revenue in excess of USD 16 B. I was responsible for managing Local Media Ad Sales and Research Warehouses. Also, played a key role in implementing DWH reporting (mobile based reports) for senior executives during Olympics and NFL.

Also, managed upgrade for portability between PowerCenter including backward compatibility for workflows/sessions and script change.

 

Role:  ETL Architect / Project Lead

·         Gather technical and functional requirements for the project

·         Architect ETL solutions and monitor and review progress of team members

·         Designed phased approach for PowerCenter migrations to reduce complexity, mitigate implementation risk and to reduce batch processing outage.

·         Migrated mappings, sessions, and workflows from development to Testing and then to Production

·         Awarded several times for implementing automation and best practices

·         Integrated Nielsen Ratings to track ad sales progress of shows

·         Develop, test and maintain ETL procedures using both ETL tools and custom PL/SQL

·         Participated in the development and maintenance of a Date Warehouse / Data Mart Routine Load Schedule.

·         Extensively used PL/SQL to embed complex business logic in SQ Overrides.

·         Configured the mappings to implement Slowly Changing Dimensions (Type-2).

·         Defined Target Load Order Plan and Constraint based loading.

·         Responsible for coordinating development and testing efforts with offshore team members.

 

Technology Stack:

SSIS, Informatica Power Center, SQL Server, Oracle, Teradata, AS400, TOAD, Business Objects, Flex, Flat Files, Nielsen Ratings

 

Client: Ruan Transportation, Iowa                                                                            Sep 2002‐ Feb 2006

Employer:           Infosys Technologies Ltd.

Is one of the leading transportation companies based in Des Moines. The data warehouse was built to track loads performance for loads transported across North America.

 

Systems Analyst:  

This project involves developing and analyzing load monitoring reports. Crystal reports was used to integrate querying, reporting, and analysis of their critical financial reports and customer data.

 

Responsibilities:

·         In-depth understanding of processes involving data modeling and building data marts.

·         Translated the business processes into Informatica mappings.

·         Design and development of CDC process using time-stamping method and row comparison.

·         Developed ETL sessions for initial full loading and incremental loading.

·         Worked with heterogeneous sources including relational sources and flat files

·         Unit and Integration testing of Informatica mappings.

 

Technology Stack:

Informatica PowerCenter, Oracle, Flat files, AS 400, UNIX Shell Scripting, UNIX/Windows.