Resume

Sign in

Project Data

Location:
Delhi, India
Posted:
January 11, 2017

Contact this candidate

J-***, *nd Floor Saket

New Delhi-******

Mob.No.: 07503167738 acx722@r.postjobfree.com

Vishal Goel

OBJECTIVE: To obtain a challenging position in the field of Information Technology and to self actualizes my potential, skills and capabilities in all roles and at all times.

Total Work Experience : ( 13 years)

Informatica Experience: (7 years)

Data Modeling Experience: (4 years)

Datastage Experience: (2 years)

RBS (Royal Bank of Scotland) (Feb’2014 –Till Date)

IBM India Pvt. Ltd (Aug’10 – Feb’2014)

Syntel Ltd (From Sep’07 – July’10)

BOBCARDS Ltd. (subsidiary of Bank of Baroda) (From Nov ‘03- Sep’07)

B.E.DETAILS: B. Tech- Information Technology

COLLEGE: Meerut Institute of Engineering & Technology

Aggregate %age marks obtained: 68 %

COMPUTER SKILLS:

Informatica 9x/8x/7x/6x

Datastage 8.1/7.5

SQL,PL/SQL

Oracle, Teradata

Data Modelling and ETL solution Design

Erwin

ETL Concepts

Involved in all phases of ETL lifecycle from scope analysis, design, and build through production support.

Good working experience with ETL Tools, Informatica, Datastage.

Data modeling and ETL solution design.

Data modeling of various subject areas for datawarehouse.

Reference data management

Analyze the requirement and design document for understanding the functionality of both source and target systems.

Responsible for creating mapping design documents

Resource forecast planning

Responsible for performance tuning and error handling in Informatica Mappings.

Having good knowledge in data warehouse concepts like snowflake, star schema’s

Worked on engagements that span through domains of Finance, Banking, Telecommunications and Automotive.

WORK EXPERIENCE AND PROJECT DETAILS:

Program Name : FiRST Data Solutions Program (Finance Risk and Treasury)

Client

Royal Bank Of Scotland

Designation

Technical Lead Consultant

Organization

Royal Bank Of Scotland

Duration

Feb’2014- Till date

Team Size

Project : 7

Environment

(with skill versions)

Software

Languages : SQL

Database : Oracle,Teradata

Model: OFSAA (Oracle Financial Services Analytical Applications)

Tools : Informatica 9.1, Metadata Manager, Erwin

O/s : Unix

Program Description

FiRST Data solutions program aims to deliver business intelligence system to automate the process of manual adjustments that are required for generating MI reports for Finance, Risk and Treasury business teams and also to provide a golden source of data for various businesses.

Contribution

As a Technical Lead Consultant, is responsible for setting up FiRST data solutions COE in India

Key activities performed while working on projects under FiRST Data solutions were as mentioned below:

Responsible for requirements gathering from business.

Managing Data modeling and ETL team responsible for DWH customization for various business teams.

Customization of Oracle OFSAA data model based on project requirements.

Mapping OFSAA LDM to Teradata FSLDM (Financial Services Logical Data Model) to maintain RBS wide Logical Data Model.

Technical design/review of ETL components for Migration’s and On-boarding Projects

Responsible for Data Profiling and Cleansing of Upstream/Downstream data

Taking Ownership of supporting Unix shell scripts (re-formatters/pre-processor) logic into ETL

Interaction with backend database structure and different Data formats(Set Static, Transaction data, KB files format) for building ETL workflows

Responsible for Upgrade and migration of different ETL components periodically

Handling of Level 3 issue investigation, resolution and ownership of all Severity 1 and 2 Prod ETL related issues

Role

Technical Lead

Organization

IBM ( Gurgaon)

Client

TIAA-CREF

Project Name

RMW

Duration

Jan’13- Feb’14

Domain

Insurance

Team Size

Project : 9

Module : 3

Environment

(with skill versions)

Software

Database : Teradata, Oracle

ETL Tools : Datastage8.1,Informatica 8.6.1

Tools: Metadata Manager, Erwin

Scheduling Tools:Autosys,CA7

Project Description :

The project is developed to give the broad perspective details of teachers association retirement plans, after-tax annuities, IRAs, Education Savings, Mutual Funds, Banking and Brokerage services.

Roles and Responsibilities:

As a Technical Lead, was responsible for modeling data for Teradata EDW and managing projects under Retail Data Transformation programme

Requirements gathering from business.

Creation of functional specifications for the project and agreeing them with business.

FSLDM modeling to produce required LDM.

Dimensional modeling of the MI system to provide required reporting capabilities.

Producing data contracts for various subject areas.

ETL solution design, Reference Data management, Metadata management

Mapping Document and Batch design.

Co-ordinating development and testing activities and project implementation

Code review and performance tuning.

Role

Team Lead

Organization

IBM ( Gurgaon)

Client

Bharti Airtel

Project Name

FUNCTIONAL DIRECTOR DASHBAORD (FDD)

Duration

Oct’12- Dec’13

Domain

Telecommunication

Team Size

Project : 5

Module : 3

Environment

(with skill versions)

Software

Database : DB2 (Advance Query Tool)

Tools : Datastage7.5

Language: SQL

Project Description :

The purpose of this project is to develop the dashboard for the Functional Director of the SCM team. The dashboard will give a broad perspective of the performances of various verticals of the SCM team.

Roles and Responsibilities:

Responsible for timely delivery of all the ETL related activities.

Creation of functional specifications for the project and sharing it with business for their sign off.

Preparation of data models for different subject areas of datawarehouse.

Resource forecast planning.

Creation of parallel jobs in datastage.

Creation of SQL queries in DB2 and testing the output.

Code review and performance tuning.

Creating the High and low level ETL design documents.

Also responsible for the reconciliation of output from the ETL and the corresponding values on the Cognos report on the regular monthly basis

Role

Team Lead

Organization

IBM ( Gurgaon)

Client

Bharti Airtel

Project Name

PARTNER PERFORMANCE SCORECARD

Duration

JAN’12- Sep’12

Domain

Telecommunication

Team Size

Project : 3

Module : 5

Environment

(with skill versions)

Software

Database : DB2 (Advance Query Tool)

Tools : Datastage7.5

Language: SQL

Project Description :

The purpose of this project is to develop the Analytics for the Partner Performance ScoreCard . This Project helps the end user to analyze the performance of their Vendors and further help to analyze the best vendor which had done the maximum business with them

Roles and Responsibilities:

Responsible for timely delivery of all the ETL related activities.

Creation of functional specifications for the project and sharing it with business for their sign off.

Resource forecast planning

Code review and performance tuning.

Co-ordinating project implementation.

Reviewing the High and low level ETL design documents.

Role

Team Lead

Organization

IBM ( Gurgaon)

Client

Bharti Airtel

Project Name

FINANACE ANALYTICS

Duration

JAN’11- Dec’11

Domain

Telecommunication

Team Size

Project : 3

Module : 5

Environment

(with skill versions)

Software

Database : DB2 (Advance Query Tool)

Tools : Datastage7.5

Language: SQL

Project Description :

The scope of this project is to take prepare dashboards for Invoice and Payment tracking for ERP Analytics. The Input data will be taken from Oracle ERP Database and Finance CMT eFinAct Application DB2.

These dashboards will help business to track Invoice and Payments processing efficiently and ensuring timely payments.

Roles and Responsibilities:

Actively Involved in Requirements and Design discussions with Business and Development team.

As a Team Lead, Responsible for timely delivery of all the ETL related activities.

Involved in reviewing and understanding the requirement documents

and comparing the design document with reference to the requirement document

Understanding all the different Applications and Business Rules.

Assigning the tasks to the individual, providing them the inputs helping them in the delivery.

Doing GAP analysis at different levels like Requirement and Design, Design and Code built, code functionality, requirements and testing the code.

Development of Jobs in datastage.

Responsible for Successful Execution of Jobs and Validation of Data according to the functional specifications of the business.

Role

Team Lead

Organization

IBM ( Gurgaon)

Client

Bharti Airtel

Project Name

SIGNET

Duration

Sep’10- Dec’10

Domain

Telecommunication

Team Size

Project : 3

Module : 5

Environment

(with skill versions)

Software

Database : DB2 (Advance Query Tool)

Tools : Datastage7.5,Unix Scripting

Language: SQL

Project Description:

This project SIGNET includes automation of Prepaid Revenue Accounting and its Revenue Reporting using reports from various sources like IN, UTIBA, VL Server and Botree. This will include collection of data from source systems, processing, maintaining audit trail, generating reports, pushing entries to Oracle Financials and performing accounting activities in Oracle Financials.

Roles and Responsibilities:

As a Team Lead, Responsible for timely delivery of all the ETL related activities.

Assigning the tasks to the individual, providing them the inputs helping them in the delivery.

Actively Involved in Requirements and Design discussions with Business and Development team.

Development of Parallel Jobs in datastage.

Responsible for Successful Execution of Jobs and Validation of Data according to the functional specifications of the business.

Also use to work and analyze the Unix scripts used to run the datastage jobs.

Role

Sr. Programmer

Organization

Syntel Ltd.

Client

AMERICAN EXPRESS

Project Name

Amex-GCT

Duration

Sep ’09- July’10

Domain

Banking and finance Services

Team Size

Project : 2

Module : 9

Environment

(with skill versions)

Software

Database : DB2 on Mainframe Systems

Source System: Mainframe Dataset files and DB2 tables on

Mainframe Systems.

Tools : Informatica 8.6,Powerexchange 8.6,Unix

O/s : Windows

Hardware

Pentium IV

Roles and Responsibilities:

Actively Involved in Requirements and Design discussions with Business and Development team.

Creating the data model for the project

Reference data management

Reviewing the developed code w.r.t Requirement and Design documents, providing the comments (to Development and client) w.r.t Coding standards, performance improvement chances, Best Practices etc., discussing with for the discrepancies found.

Doing GAP analysis at different levels like Requirement and Design

Involved in Discussions of Data Extract & Mapping specifications Documents (TSD).

Developing data maps in Powerexchange 8.6 and exporting it into

Informatica Powercenter 8.6 for extracting Mainframe data.

Developing Mappings, Workflows,Sessions and Tasks using ETL tool

Informatica 8.6

Actively Involved in SIT phase, built the test cases for testing the developed ETL code and raising the defects when found a discrepancy between expected result and the actual result.

Role

Team Member

Organization

Syntel Ltd.

Client

DAIMLER TRUCKS NORTH AMERICA

Project Name

CBFC- DTNA

Duration

Jan ’09- Sep ‘09

Domain

Automotive

Team Size

Project : 4

Module : 4

Environment

(with skill versions)

Software

Database : DB2

Source System: SAP

Tools : Informatica 8.1.6, SAP, Unix

O/s : Windows

Hardware

Pentium IV

Roles and Responsibilities:

Responsible for gathering the business requirements and analysis.

Developing mappings using ETL tool Informatica 8.1.6 and DB2 database.

Extracting the source records from SAP sources and loading it into

dimension and Fact tables located in DB2 database.

Preparing the functional and technical design documents.

Data modeling for different areas of datawarehouse.

Reference data management.

Preparing the unit test cases reports.

Auditing of Load Statistics for balancing target record counts with source record counts

Translating the requirements into source to target mapping document.

Responsible for Performance tuning of loads.

Given support for the application and KT to the new team members.

Role

Team Member

Organization

Syntel Ltd.

Client

Allstate

Project Name

Allstate Insurance Algo Support

Duration

Sept 08- Jan’09

Domain

Insurance

Team Size

Project : 5

Module : 4

Environment

(with skill versions)

Software

Languages : PL/SQL

Database : Oracle 8i

Tools : Informatica 8.1, Unix

O/s : Windows

Hardware

Pentium IV

Roles and Responsibilities:

Responsible for gathering the business requirements and analysis.

ETL and Algo Job Monitoring using TIVOLI.

Submitting the JOB request system through JRS.

Resolving the abends.

Working on defects and enhancements.

Translating the requirements into source to target mapping document

Developing mappings using ETL tool Informatica 8.1 and Oracle database on windows platform

Given support for the application and KT to the new team members.

Role

Team Member

Organization

Syntel Ltd.

Client

American Express

Project Name

AEM(Assignment Exception Mapping)

Duration

9 months

Domain

BNFS

Team Size

Project : 5

Module : 3

Environment

(with skill versions)

Software

Languages : PL/SQL

Database : Oracle 8i

Tools : Informatica 7.1.3

O/s : Windows

Hardware

Pentium IV

Roles and Responsibilities:

During this period I was responsible for gathering the business requirements and analysis of the project.

Translating the requirements into source to target mapping document

Developing mappings using ETL tool Informatica 7.1.3 and Oracle database on windows platform.

Also involve in the data modeling team for creating a data model for datawarehouse.

Given support for the application and KT to the new team members

As a part of the team I was responsible for development of the Informatica Mappings, Sessions, Workflows, Worklets and Tasks

Involved in developing the Mappings for critical interfaces using different transformations in PowerCenter designer.

Also responsible for loading and testing the data in staging tables.

From Nov 2003- Sep07 worked in BOBCARDS Ltd. (a subsidiary of Bank of Baroda).

Project Name

GECS

Role

Team Member

Organization

BOBCARDS Ltd

Team Size

Project: 6

Module : 3

Domain

BNFS

Environment

(with skill versions)

Production Environment

Software

Languages : PL/SQL

Database : Oracle 8i

Tools : Informatica 7.1.2

O/s : Windows

Hardware

Pentium IV

Roles and Responsibilities:

During this period I was responsible for gathering the business requirements.

Developing mappings using ETL tool Informatica 7.1.2 and Oracle database on windows platform.

Also a part of the data modeling team which works on creating a data model for the entire process of the organization.

As a part of the team I was responsible for populating the data into Oracle tables from the CSV files based on the business logic provided to us. Based on this data several reports are generated that helps managers here to make several decisions such as Fraud checks, credit limits etc.

Also responsible for performance tuning of loads.

Also work on enhancement of the existing applications and present ideas on how to prevent the bugs from reoccurring.

Conduct knowledge sessions between the team members.

AWARDS AND ACHIEVEMENTS:

Got several appreciation mails from my managers and Client Manager while working with RBS,IBM and Syntel Ltd.

I consider my wonderful relationship with my colleges and managers as one of my biggest achievements in my professional career.



Contact this candidate