Project Description:
Retail Traget Platform (RTP) is for the development of a unified, modern IT process for the
new sectoral bank platform.
Deutsche Bank and Postbank(another German bank), have Private & Business Clients
(PBC)s with the main strategic brands surgically separated into two powerful active distribution
networks.
Modules (I worked on): KUMV Spladder
Scope of KUMV Spladder:
KUMV-Spladder is a connector between payment format of SAP/BCB and payment format of
Deutsche Bank to transform.
K2B process is the ETL transformation of the transactions from ZVKK to BCBPS.
It takes KUMV file on the mainframe of the ZVKK system is the input file and creates mandant
(legal entity) specific XML,TXT and ZIP files as the outputs in a dropbox mounted on unix. Also
a mainframe dataset is created with the transactions which have errors.
B2K process is the ETL transformation of the transactions from BCBPS/SAPDM to ZVKK.
The XML & TXT files from BCBPS/SAPDM act as inputs for B2K process and KUMV output file
and error file are created on the ZVKK system.
EoD process is the end of day process which involves collection of eDATA records from all the
B2K processes run during the day and create the mainframe dataset for eDATA

Key Roles:

• Involved in all phases of SDLC from requirement gathering, design,
  development, testing, production, user training and support for production
  environment.
• Create new mapping designs using various tools in Informatica Designer like
  Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping
  Designer.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 9.1 for data
  loading.
• Performed data manipulations using various Informatica Transformations like
  Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update
  Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow
  designer in Workflow manager and monitored the results using workflow
  monitor.
• Pre and post session assignment variables were used to pass the variable values
  from one session to other.
• Optimizing performance tuning at source, target,mapping and session level.
• Involved in Unit Testing and Resolution of various bottlenecks that came across.

Project Description:
The objective of the project is to process the data from source
files by performing ETL to develop job streams for the interfaces, which will process data from
source files to target files and generate automated reporting capability for its client businesses.
These are met by the Extraction, Transformation, Loading and Reporting using Data stage.

Key Roles:

• Involving in meetings with business team and analysts to gather the
  requirements. Understanding the functionality of the system & understanding
  business rules.
• Used most of the stages like lookup, transformer, copy, joiner, filter, aggregate,
  sequence and modify etc.
• Responsible for creating data stage jobs considering the performance issues.
• All file paths must be parameterized to allow runtime flexibility and ease of
  migration between various server environments.
• Time to time analysis of performance of jobs and making performance tunings as
  and when required.

Project Description:
The target project is Consip’s RGS Data Warehouse (or DW-RGS): the decision support
system developed and maintained since year 2001 by the Italian government to support the
national accounting and balance policies.
The DW-RGS consists of three database functional areas, each identified by at
least one separate database schema: the Staging Area (“STG”), the Enterprise Data Warehouse
(“EDW”) and the Data Marts (“DMA”). The STG structures are loaded partly by directly
importing data from the originating systems by means of database utilities and partly using
source systems flat files processed by ETL jobs, while the EDW loading from STG data and DMA
loading from EDW data are done using ETL jobs.

Key Roles:

• Extraction, Transformation and Loading of data from oracle sources, flat files into oracle database
• Developed Parallel jobs using stages Transformer, Aggregator, Sort, Modify, LookUp, Join, Oracle Enterprise, Peek, Funnel, Remove Duplicates etc
• Consolidation of job designs and Fixing jobs according to informatica jobs
• Involved in preparing issue documents.
• Using Aqua Data Studio to check the data in the Database like Oracle
• Involving in Unit testing
• Involve in taking the backup of whole project for Daily-basis and weekly basis

Project Description:
Axa is a leading insurance company in Germany. Axa has acquired DBV
Winterthur, another leading insurance company in Germany. This acquisition has brought the
need for the merger and hence the challenging W-2-G migration project.

Key Roles:

• Designed DataStage ETL jobs for extracting data from DBV mainframe systems,
  transform and finally load into the AXA mainframe systems.
• Working on DataStage Designer tools for creating Mainframe Jobs.
• Developed Mainframe jobs using stages Link Collector, Lookup, Aggregator,
  Transformer etc.
• Involved in ETL Processes to load data from Complex Flat file, Multiformat Flat file
  into target DB2 Load Ready Flat file applying business logic on transformation
  mapping.
• Generate COBOL,JCL modules that run on the mainframe and perform the actual
  data translation.
• Prepares the jobs/ maps as per the mapping Testing.
• Preparing Test cases for the Jobs.

Project Description:
Consolidated Edison Company of New York (Con Edison), a regulated utility, provides
electric service in New York City (except for a small area of Queens), and most of Westchester
County. The company encourages customers to learn about other electric and natural gas
companies — known as energy services companies (ESCOs) — and to compare the pricing
options and services that they offer. When a customer chooses to buy the energy their home or
business uses through an ESCO, however, Con Edison still continues to deliver the electricity and
gas, and responds if there is a service emergency

Key Roles:

• Analysis and design of ETL processes.
• Have used Transformer, Lookup, Joiner, Remove Duplicates, Merge, Pivot Stages
  and Funnel for data processing. Identify other source systems like Oracle, related
  tables and fields and ensure data suitably for mapping.
• Involved in exporting and importing data stage jobs
• Using Sequential file Sage, to extract data as a source, to target using oraOCI9i
  Stage, Using Transformation Stage, Aggregator Stage, Modify Stage for Data
  preparation to server jobs in DataStage Designer.
• Validating Jobs from DataStage Director
• Have used Peek stage for debugging.
• Have used stages like Row Generator, Aggregator, Sorter also and Surrogate Key
  Generator.

Project Description:
Norwich Union is the world's sixth-largest insurance group and the biggest in the UK. It is
one of the leading providers of life and pensions products in Europe and has substantial
businesses elsewhere around the world. Its main activities are long-term savings, fund
management and general insurance.
The purpose of this Project is to migrate NUI Huon Policy data to Exceed
of the SIP Conversion Project.The scope of this Project covers Policy migration including Policy
Common and three lines of business, i.e. Motor, Travel and Household.This would focus
primarily on Solution Architecture and ETL (Extract Transform Load) Strategy.The challenge
involved in the conversion is to have smooth transition from HUON to Exceed in terms of Data
Quality, Data Integrity, validations & handling complex conversion rules , all this in a parallel
phased big bang approach with smaller migration window.

Key Roles:

• Understanding of Exceed data schemas, business processes and system architecture.
• Designed DataStage ETL jobs for extracting data from Huon, transform and finally
  load into the Exceed.
• Working on DataStage Designer tools for creating Mainframe Jobs.
• Developed Mainframe jobs using stages Link Collector, Lookup, Aggregator,
  Transformer etc.
• Involved in ETL Processes to load data from Complex Flat file, Multiformat Flat file
  into target DB2 Load Ready Flat file applying business logic on transformation
  mapping.
• Developing the Migration Suite for HUON to Exceed
• Generate COBOL,JCL modules that run on the mainframe and perform the actual
  data translation.
• Comparison of extracted HUON and Exceed data elements and structure
• Prepares the jobs/ maps as per the mapping Testing.
• Preparing Test cases for the Jobs.
• Server Manager to Schedule and monitor different sessions and loading.