GOPESH KUMAR GUPTA
Contact Details: +91-7043137799
Branch: TCS – Pune
[email protected]
_______________________________________________________________________________________

Career Objective
6+ years of IT experience with Leadership quality, exceptional communication, Interpersonal, and team building skills.
Sound Knowledge in providing quality solutions for the data analysis and business intelligence functions of a data driven firm and contribute effectively with my refined skills in ETL, Informatica and SQL under Dataware housing projects.
I always desire to learn new ideas and concepts quickly, ability to perform under pressure. I always use to be disciplined with strong work ethic.
AREAS OF EXPERTISE

Informatica PC| Informatica cloud(intermediate)|Teradata | Unix basics|SQL | Data Warehousing |CIS Studio|Cronacle|Control M

WORK EXPERIENCE

Key Functions and Contributions:

Project Offshore track Lead in providing systematic and timely deliveries of complex data manipulations.
Manage Account Level activities and responsible for auditing software compliance and adherence.
Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.1 and 9.5 ETL tool.
Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
Expertise in scheduling Informatica jobs using Informatica, Control M and Cronacle Job scheduler.
Expertise in CIS studio to create the views as per business requirement on different layers.
Experience in documenting High Level Design, Impact Analysis, Unit test plan, Unit test cases and Deployment documents.
Manage timely flow of business intelligence information to users.
Internal TCS ITIL and Agile certified.
Basic knowledge of Unix
Having baisc understanding of informatica cloud

Achievements & Awards

Award Name
Award Date
Award Category
Award Subcategory

Service & Commitment Award
24-Jan-2016
Service Awards
Service Award

Special Initiative
20-Jan-2016
Beyond Performance Awards
Initiatives

On the spot award
May-2018
Beyond Performance Awards
Initiatives

Best Team award
April 2019
Beyond performance awards
Service Award

Education & Learning

Qualification
Subject
Percentage/Grade

STANDARD XII / H.S.C.
Science & Math
82.76

BACHELOR OF TECHNOLOGY
Electronics & Communication
70.22

Undergraduate
Others
88.76

SSC
Others
83.5

TCS Experience

Project Name
Aurizon

Duration
11 months

Period
01-June-2017 To currently working

Roles
Tech Lead

Start Date
01/06/17

End Date
Currently working

Work Location
Brisbane(Australia),Gandhinagar

Responsibility
Developer, Team Lead

Technical Skills
Informatica, Control M,BRIO,SQL

Description
Project Aurizon Non Sap
Description: The project is majorly support on movements of trains. It keeps track of speed restriction on track and track set and incident.
It manages the window period, geography of related train service. Also have information related to service for each sequence of train movements.
It keeps the track of loading and unloading of train goods.
In case of any wrong signal, derailment incident is raised at vizirail front end and that data flow in database. User take decision on basis of data placed in datawarehouse.

BRIO is reporting tool to provide the reports as per requirement.

Responsibility:

Handling incidents and issues raised by the business
Small changes and Enhancements
System Health Checks and Monitoring
Provide business solutions
Testing and Implementation
Development for new requirement

Project Name
Healthcare account

Duration
25.63Months

Period
23-Mar-2015 To 31-May-2017

Roles
Developer

Start Date
23-Mar-2015

End Date
30-Apr-2017

Work Location
Gandhinagar

Responsibility
Developer and support the project

Technical Skills
Informatica, Bteq, Cronacle ,Teradata ,CIS Studio

Description
The project aimed at reporting the purchase details and help analyzing the best possible way to increase profit of sales without compromising on the quality. This involved extracting data from various source systems like SAP, oracle, Pega etc. And integrating these details to provide a common platform for reporting. The details included purchase and invoice details, inflation/deflation, vendor details, profit gained, etc. OBIEE is used to query on the presentation layer for user viewing.

Responsibility:

Performing cleansing, standardization of commonly used data at ODS level.
Customize and streamline the data into an Oracle DB according to client requirements.
Provide vendor comparative analysis to the client and support best vendor decisions on various parameters.
Conduct or coordinate unit, system and regression tests to ensure that intelligence are consistent with defined needs.
Understanding the architecture of the source system.
Performed data manipulation using CIS Studio. Created view on different layers as per business need.
Performed data manipulation using basic functions and Informatica transformations.
Developed mappings using transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Rank, and Sequence Generator.
Used Informatica Workflow Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
Data load into Data ware house and data Mart by using control M scheduler and ETL process.
Validation of dataflow, staging tables, dimension and fact tables.
Defect tracking using HP Quality Center.
Developed process related documents like SDS, SRS, URS, Impact Analysis, Traceability Matrix and Test Plan and Summary report.

Project Name
AXA UK plc

Duration
15.30Months

Period
11-Nov-2013 To 13-Feb-2015

Roles
Developer

Start Date
11-Nov-2013

End Date
13-Feb-2015

Work Location
Chennai

Responsibility
Worked as Team Member

Technical Skills
Informatica,Process360

Description
Project: Workflow and Desktop Support(Process360)
Description: The project is to majorly support the Workflow System (built on a BPM product – Process 360) and the infrastructure built for the workflow such as scanners, faxes, web servers, database servers, repository storage (Centera).

Responsibility:

Handling incidents and issues raised by the business
Small changes and Enhancements
System Health Checks and Monitoring
Workflow Infrastructure Support
Insite DocuStore support
Testing and Implementation
–Informatica upgrade project:
Upgrade from Informatica 8.5 to Informatica 9.1
Responsibility:
Testing for migration of workflows for more than 1500

PERSONAL DETAILS

Date of Birth : 15/07/1991
Sex : Male
Nationality : Indian
Current Location : Ahmadabad
Marital Status : Married
Language Known : English and Hindi

I hereby declare that all the information furnished above is true to the best of my knowledge and belief.

Gopesh Gupta