Gaurav Kapoor
Email: **************@*****.***
*************@*****.***
Plano, TX - 75093
Professional Summary
• Around 7 years of IT experience in analysis, design, development, testing, data modeling, estimation, implementation,integration and maintenance of various Database Applications, operational as well as Datawarehousing applications.
• Started the Career with Satyam Computers Services Ltd, currently leading the Data Integration team within JC Penney, TX.
• Technical expertise in ETL (Extraction Transformation Loading – Informatica 7.x,8.x), Informatica Power Exchange, reporting(Business Objects 5.x,6.5, Business Objects XI R2).
• Well acquainted in the designing of Star, Snowflake models and use of Erwin to design the data model.
• On the database front, expert in Oracle 9i,10g ,Teradata V2 R6, IBM DB2
• An Oracle Certified Associate (OCA), Business Objects Certified Professional (BOCP) , Informatica Certified Designer and well conversant with CMM Level 5 quality procedures while executing the projects.
• Proven expertise in delivering the solutions in onsite / offshore model.
• 3 years of experience in leading the team.
Experience
Organization Designation Duration
Infosys Technologies Ltd Technology Lead (03/2010) – till date
Collabera Inc. Programmer Analyst (12/2008) – (03/2010)
Trinus Corporation Systems Analyst (01/2008) – (12/2008)
Headstrong Services Ltd Senior Associate (4/2007) – (01/2008)
Satyam Computer Services Ltd., Software Engineer (12/2004) – (4/2007)
Projects Profile
1. Project Name : Various phases of datamart
Client JC PENNEY, PLANO, TX
Duration (03/2010) – till date
Team Size - 10
Project : Inventory / Demand / Direct Revenue / Gross Profit datamart Module : ETL and Reporting Solutions
Environment
(with skill versions) Software
Languages : SHELL
Database : IDM DB2
Tools : INFORMATICA 8.6, POWER EXCHANGE ,TOAD, WINSCP, TERADATA SQL CLIENT, PUTTY, HUMMINGBIRD
O/s : WINDOWS XP, UNIX, MAINFRAME.
Contribution
• Lead the team of 9 people to deliver the various phases of datamart.
• Delievered the EDW first phase in Ralph Kimball methodology / EDW 2nd phase in Inmon methodology.
• Requirements gathering / analysis of the requirements.
• Creating the technical design document for various phases of the delivery.
• Designing the ETL Solutions in Informatica / Power Exchange /Shell scripting.
• Work Allocation among the team members, ensuring the development activities to happen as per the design.
• Presenting the technical design among the Client Technical Architect team and receiving the sign off.
• Designing the various technical solutions which were used at organization level like CDC , Reconciliation between the source and primary staging, running the workflows as per the user input.
• Assisting the Consulting Group with the Pre Sales activities such as writing the documents of technical solutions for the prospective customer.
• Creation of datamaps in Power Exchange to read / write to mainframe files.
1. Project Name : WEBTRAX
Client Cingular (AT&T Mobility), Dallas, TX
Duration (12/2008) – (03/2010)
Team Size - 6
Project : MPS Cycle Close Application, EMI Tracker, BMG Tracker, Bill Revenue Tracker Module : ETL and Reporting Solutions
Environment
(with skill versions) Software
Languages : SHELL
Database : ORACLE 10g
Tools : INFORMATICA 8.6,BUSINESS OBJECTS XI R2, ECLIPSE, ANT,TOAD,SQL Navigator,CVS Tortoise
O/s : WINDOWS XP, UNIX
Contribution
• Designing the ETL Solutions from the OLTP tables as the source and storing the data in summary tables for reporting solutions using Informatica.
• Developing the BO Universe.
• Designing the dashboard reports to be called by the JAVA Web application.
• Using the BO SDK Classes and objects to setup a handshake between JAVA Web app and BO.
• Supporting the BO universe and reports in production.
• Designing the ETL solution using JDK framework to load the files in temp Oracle table.
• Gathering database design requirements, database volume calculation prior to project initiation.
• Creating the logical and physical data model using CA-Erwin.
2. Project Name : ETL and Reporting Solutions
Client Belkin International Ltd, Compton, CA
Duration (02/2008) – (12/2008)
Team Size - 6
Project : Belkin International Ltd Module : ETL and Reporting Solutions
Environment
(with skill versions) Software
Languages : SHELL
Database : ORACLE 10g
Tools : BUSINESS OBJECTS XI R2
O/s : WINDOWS XP
Contribution
• Development of universes and reports in BO XI R2 as per the discussion and meeting with the Users.
• Supporting and maintaining the BO reports in production environment and solving the daily production issues.
• Automating the existing manual processes in the reporting environment depending on other application processes such as kicking the various instances of the BO report on the completion of the ETL process.
• Supporting and maintaining the ETL code which includes modifying the existing Oracle packages and procedures.
• Loading the data from OFA files to Oracle 10g Warehouse using SQL Loader.
• Creating an automating Shell scripts to FTP the OFA Files to shared location.
3. Project Name : Business Metrics Initiative
Client Morgan Stanley
Organization Headstrong Services Ltd
Duration (05/2007) – (01/2008)
Team Size - 6
Project : Morgan Stanley Module : Business Metrics Initiative
Environment
(with skill versions) Software
Languages : SHELL
Database : TERADATA
Tools : INFORMATICA 7.1.3, INFORMATICA 8.1, BUSINESS OBJECTS XI R2
O/s : WINDOWS XP
Project Description
Business Metrics project is an initiative to move the data from various legacy systems to datawarehouse so that the integrated data can cater to the needs of the Managers and particularly Financial Advisors who can view the data in the form of report, broadly the project also includes the development of current Brio reports in Business Objects XI R2 as well as developing stored procedures which are called by Webservices.
Contribution
• Leading a team of 6 people and directly reporting EVP of Morgan Stanley for project tasks.
• Development of universes and reports in BO XI R2 with the auto sort and auto indentation implemented at the report level, which will be validating the data loaded by the ETL Code.
• Automating the existing manual processes in ETL code(Informatica) in order to avoid any manual intervention during the production run, which included the development of shell scripts.
• Developing the views, SQL’s and procedures on ad-hoc basis in Teradata on Teradata SQL Assistant , Windows based tool, which are eventually called by Webservices.
• Developing the mappings to load the legacy data(DB2, VSAM files,Sybase) from various sources to Teradata through loaders (MLoad).
• Tuning the Informatica mappings to improve the running time.
• Performance tuning of the Teradata stored procedures by analyzing the explain plan of the queries.
• Used calculations, variables, sorting, drill down, slice and dice for creating Business Objects reports.
• Converting the full client DESKI reports to WEBI reports using Report Conversion tool.
• Creating the various project metrics documents to track the health and compliance of the project.
4. Project Name :HR
Client General Electric – Power Systems
Organization Satyam Computer Services Limited
Duration (04/2006) – (04/2007)
Team Size - 5 Project : GE POWER SYSTEMS Module : HR
Environment
(with skill versions) Software
Languages : SHELL
Database : ORACLE
Tools : INFORMATICA 7.1, BUSINESS OBJECTS 6.1
O/s : WINDOWS XP
Project Description
Development and support of HR datamart ,the main tasks included developing and supporting the mappings which loads the HR tables.
HR datamart contains the information about the millions of employees involved with GE Energy worldwide either directly or indirectly, it also keeps the tracks of various awards being accoladed to the various employees as well as it keeps the tracks of the employees who are supposed to or who have already left the organization.
Contribution
• Leading a team of 4 people, code review before releasing to production.
• Designing data model using Erwin.
• Development of Informatica mappings and the shell scripts which on schedule ftp the files to the various applications team receiving the data and send them an email intimating them about the availability of the files.
• Constantly involved in many Change Requests at the ETL(Informatica) side.
• ETL support during all phases: QA, SIT, UAT, Go Live and post production
• Supervision of all Migration Activities of all database objects from DEV
Environment to Quality Assurance and finally to Production Environment
• Supervision of Testing of all objects in Production once the movement is complete
• Development of BO universes and reports.
• Performance tuning of the Oracle database queries used in the BO reports.
• Supporting the already existing BO reports in production.
• To make sure the already existing security at supervisor level(Row level security) always hold true and report displays the data intended for the user depending upon his unique identifier.
5. Project Name FINERP
Client General Electric – Power Systems
Organization Satyam Computer Services Limited
Duration (01/2006) – 04/2006
Project : GE POWER SYSTEMS Module : FIN ERP
Environment
(with skill versions Software Languages : PERL
Database : ORACLE
Tools : BUSINESS OBJECTS 6, Informatica 7.1
O/S : WINDOWS XP
Project Description
The second project was in the FINERP datamart which was a development project and included the development of the datamart. FINERP was an extension to the CSERP project, since the data to the CSERP datamart was populated through various stages which included many ERP applications acting as a source so as to facilitate the whole process FINERP datamart was developed, which will directly feed the tables in FINERP datamart keeping the old CSERP datamart intact.
Contribution
• Designed the screen door for the ETL which will scan the source files and split it into various files as per the data functionality.
• Developed the universes and complex BO reports fetching the data from 2 universes simultaneously and linking the universes at report end and using the complex output and input contexts to display the data as per the client requirement.
• Development of the Informatica mappings and the workflows to load the various fact and dimension tables
• Performance tuning of the Informatica mappings to improve the load time.
• Automating the existing Informatica ETL processes using parameter files.
6. Project Name : CSERP
Client General Electric – Power Systems
Organization Satyam Computer Services Limited
Duration (12/2004) – 03/2006
Team Size - 2
Project : GE POWER SYSTEMS
Module : CS ERP
Environment
(with skill versions) Software
Languages :
Database : ORACLE
Tools : BUSINESS OBJECTS 6, INFORMATICA 7.1
O/s : WINDOWS XP
Project Description
GE – Power Systems is the leading company involved in the business of production of heavy machinery like Turbines, Generators etc. CSERP is the datamart which contains the financial related data about the transactions of GE-Power Systems with Vendors as well as Customers.
Contribution
As a team member, the job responsibilities included :
• Analysis of the specifications provided by the clients
• Design , Development & Supporting the BO reports in production
• Worked extensively at the BO Reporting and Designer side.
• Single point of contact to the client for Reporting related
activities.
• Handled complex BO reports including cascading prompts ; master detail
reports and other complex features of BO.
• Involved in the designing of Informatica mappings and the shell scripts
which ftp the files to the various applications team and emailing them about the
success of the process.
• Informatica mapping performance tuning.
Education – Bachelors in Technology in Mechanical & Automation from Guru Gobind Singh Indraprastha University in 2004, New Delhi.
Organizational Contribution
• Active participation in all the volunteer activities for the social cause.
• Received Roll Of Honour Certificate (SATYAM) for contributing towards the Organizational Learning by imparting the training on DW technologies and tools like Informatica and Business Objects 6.0
• Runners – Up in the Corporate Basket Ball tournament.
• Received Pat on the Back Award (POB) from Satyam for the contribution to the HR datamart and receiving numerous appreciations from the client for developing and supporting the datamart
• Received the Certification of Appreciation from JC Penney for the contribution towards the successful delivery of EDW Phase -1.
Certifications.
• Oracle Certified Associate (OCA)
• Business Objects Certified Professional. (BOCP)
• Green Belt Certified by Satyam and GE on clearing the Green Belt Training program.
• Data Warehouse concepts certified – an internal certification drive of Satyam.
• Certified by the National Stock Exchange of India (NSE) in Financial Markets Module.
• Informatica Certified Designer.
• Certified by Infosys in Consumer Packaged Goods subject within Retail Business.