Project Data
Resume:
New Delhi-******
Mob.No.: 075******** 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