Résumé

Name: Guddu Kumar Mehta

Contact # +91-797*******, 829-***-****

E-Mail: adnt4l@r.postjobfree.com

Synopsis of Experience:

●Presently working as IT Analyst at Tata Consultancy Services.

●Total 7.2 years of experience in Information Technology of which focused working on various technologies - Data Warehousing (ETL: Informatica PowerCenter 8.6, 9.1, 9.6.1,10.4), Databases (Oracle 11g, Teradata), Scripting (Shell scripting) and working knowledge on PL/SQL, Teradata Procedure and Utilities.

●Proficiency in ETL Development using DWBI tools following software development processes.

●Proficient in Requirements gathering, analysis & design. Played various roles in order to employing best business practices that improve efficiency, reduce operating costs whilst increasing performance.

●Professional experience in Teradata SQL, Oracle Query building (SQL) and UNIX Shell scripting.

Professional Experience:

Duration

Organization and Designation

Feb’14 – Jan’18

Infosys Ltd as Senior Systems Engineer

Feb’18 – May’18

Exilant Technologies Ltd as Programmer Analyst

Jun’18– Till Date

Tata Consultancy Services as IT Analyst

Education:

Academic Qualifications:

Degree/Certificate [Passing Year]

Percentage Of Marks

University / Institute

B.Tech (in Electronics & Communication) (2013)

CGPA - 7.6/10

B P PODDAR INSTITUTE OF MANAGEMENT & TECHNOLOGY, KOLKATA (under WBUT)

BSEB 12th (2008)

63%

SHRI RADHA KRISHNA GOENKA COLLEGE,SITAMARHI

BSEB 10th (2006)

68%

SHRI MATHURA HIGH SCHOOL,SITAMARHI

Skills Profile:

Technical:

Domain

Finance (Banking), Retail and Insurance

OS

Windows XP, 7, 8, 10 and Macintosh

ETL

Expertise in Informatica Power Center 8.6.1/9.1.1/9.6.1/10.4

Database

Oracle 11g

Database Tool

Toad

Languages

SQL, PL/SQL Programming

Scripting

Unix Shell scripting

Work Experience:

Cigna Corporation – USA [Jun 2018 – Till Date]:

Name

Cigna Corp. – Business Intelligence (DWBI) Team

Client

Cigna Corp.(USA)

Duration

Jun 2018 – Till Date(Cigna Corp., USA)

Role

IT Analyst

Location

Kolkata, India

Description

Worked on projects US Retail.

The objective of these projects is to provide the solution to customer for their insurance details like Coverage details, incentive, risk details. Worked upon Agile Model to full fill the business requirements. This included activities like requirement understanding in rally board, ETL code development, documents preparation like STM, UTP, Design Document, present daily work status to client, Query Building using Oracle, Testing and post-production support, database maintaining. The following includes my roles and responsibilities in the team.

●Providing data warehousing ETL development with tools like Informatica PowerCenter 10.4.

●Query building, DDL creation using Teradata and Oracle.

●Following Agile process for development of new code.

●Worked upon performance tuning.

●Involved in creating UNIX scripts whenever necessary to implement necessary requirements.

●Responsible for Code reusability and Data Quality of code.

●Provide KT to production support team before deployment of the code to Production.

●Monitor and maintenance of jobs for Post-Production support.

●Determining nature of faults and steps required to rectify it.

●Proper documentation of completed projects and sharing best practices on knowledge document uploaded in the portal.

Key Accomplishments

●Have been recognized by the team as a Insta Award for hard-working, efficient team player, good analytics and received appreciation mails from the client base.

●Have shared knowledge artifacts corresponding to project understandings and shared them in the Knowledge portal.

Technologies

ETL (Informatica),SQL (Oracle), Unix Shell Scripting

Apple Inc. – USA [Feb2018 – May2018]:

Name

Apple Inc. – Business Intelligence (DWBI) Team

Client

Apple Inc. (USA)

Duration

Feb 2018 – Till Date(Apple Inc., USA)

Role

Programmer Analyst

Location

Bhubaneswar, India

Description

Worked on projects Retail Expansion.

The objective of these projects is to provide the details of newly set up Retail store to business-centric reports . This included activities like requirement understanding, ETL code development, documents preparation like STM, UTP, Design Document, Query Building using Teradata/Oracle, Testing and post-production support, database maintaining, Reporting using BO . The following includes my roles and responsibilities in the team.

●Providing data warehousing ETL development with tools like Informatica PowerCenter 9.6.1.

●Query building, DDL creation using Teradata and Oracle.

●Generating the report using Reporting tools like SAP BO.

●Following SDLC process for development of new code.

●Involved in creating UNIX scripts whenever necessary to implement necessary requirements.

●Responsible for Code reusability and Data Quality of code.

●Monitor and maintenance of jobs for Post-Production support.

●Determining nature of faults and steps required to rectify it.

●Providing knowledge transfer sessions to the team.

●Proper documentation of completed projects and sharing best practices on knowledge document uploaded in the portal.

Key Accomplishments

●Have been recognized by the team as a hard-working, efficient team player, good analytics and received appreciation mails from the client base.

●Have shared knowledge artifacts corresponding to project understandings and shared them in the Knowledge portal.

●Have quick to learn new technologies like SAP BO, Hive.

Technologies

ETL (Informatica),SQL (Oracle), Teradata, Unix Shell Scripting, SAP BO

MoneyGram International – Dallas, North America [Jul 2014 – Jan 2018]:

Name

MoneyGram International – Business Intelligence (DWBI) Team

Client

MoneyGram International (USA)

Duration

July 2014 – Jan 2018(MoneyGram International, USA)

Role

Senior Systems Engineer

Location

Bhubaneswar, India

Description

Worked on multiple projects like ID Sharing, Getpaid, ERCM, GEM, MFA Reporting etc.

The objective of these projects is to provide the transactions details, fraudulent details, customer details and agent details to deliver business-centric reports. This included activities like requirement gathering, ETL code development, documents preparation like STM, UTP, Design Document, Testing and post-production support, database maintaining. The following includes my roles and responsibilities in the team.

●Providing data warehousing ETL development with tools like Informatica PowerCenter 9.6.1.

●Following Waterfall model for development of new code.

●Preparing knowledge artifacts based on project learning and share them in the portal for broader user base.

●Involved in creating UNIX scripts whenever necessary to implement necessary requirements.

●Involved into tune the ETL code and provide better reusability.

●Responsible for Code reusability and Data Quality of code.

●Monitor and maintenance of jobs for Post-Production support.

●Determining nature of faults and steps required to rectify it.

●Providing knowledge transfer sessions to the team.

●Proper documentation of completed projects and sharing best practices on knowledge document uploaded in the portal.

Key Accomplishments

●Have been recognized by the team as a hard-working, efficient team player, good analytics and received appreciation mails from the client base.

●Also received various internal awards (like INSTA Award) and mail appreciations for project related and other internal initiatives and activities.

●Have shared knowledge artifacts corresponding to project understandings and shared them in the Knowledge portal.

Technologies

ETL (Informatica),PL/SQL (Oracle), Teradata, Unix Shell Scripting, Pentaho Data Integration.

Personal Details:

Date of Birth

April 08th, 1990

Nationality

Indian

Marital Status

Married

Contact this candidate