Developer
Total years of experience :11 years, 3 Months
Project Description:
Genesis is poised to develop an enterprise level Data Warehouse to house all data related to Contracts, Positions and Balances, reconciled with the source which will ensure consistency and integration of information in order to improve reporting and analytics
•Environment : Datastage 8.1, Tivoli (TWS), Teradata and UNIX
•Roles Performed :
The project aims to migrate the data from CIS (Legacy System) to SAP ISU for the UK’s largest water utilities client. There are different subject areas like Business Master data, Technical master data, Finance and Billing. Target wants to Migrate the data according to MOSL of OFWAT Rule. In target, they want to migrate the data from Legacy System incorporating with Business logic to SAP ISU, SAP C4C system later.
•Environment : Datastage (v11.3), DB2 and UNIX.
• Roles Performed : Onsite Datastage Developer and L3
•Responsibilities :
•Worked with IBM WebSphere Data Stage Designer to develop jobs for Extracting, Transforming and Loading the data into Target database.
•Been at client location in UK for understanding the functionality and the data for migrating customers.
•Involved in the Creating, Designing and Documentation of the mapping sheet and Functional Specs.
•Worked with various stages like Sequential File, Datasets, Filter, Aggregator, ODBC, Transformer and other stages as well.
•Developed ETL Transformation Rules based on Functional Documents.
•Supported different released and worked as L3 support for few Applications.
•Create Unix Shell Scripts for few Validations.
•Managed a team of new resources for the project execution
CITI-GCI-GENESIS1-201
Real Estate Data Management for CITI client. This project aims to manage the Real Estate customer through the Abinitio tool into Oracle database. We used to take the flat file as the source and we use to apply the transformation and load into oracle database.
•Environment : Abintio, UNIX, Oracle
• Roles Performed :