Jiten - Consultant DATASTAGE

Sep’12 – Till Now
Project: Motorola Data Quality
Client Motorola
Employer iGate
Environment: Analysis, Oracle SQL, Talend DQ 5.1, Talend Data Integration
Role: Technical Lead
Brief description of the project:
Data Profiling for various source system for MDM purposes

Responsible for:
• Involved in System study, requirement analysis, impact analysis.
• Creation of Client Proposals, SOW, POC
• Analysis of disparate systems in quality perspective
• Development of KPI reports on the basis of the health of data of disparate source systems and cleansing strategies.

Dec’11 – Sep’12
Project: Prudential Data Migration of Financial System
Client Prudential
Employer iGate
Environment: C++, J2EE, Sybase, SQL Server 2008, Perl, Datastage 8.0, TSQL
Role: Technical Lead, Designing, Development, Migration

Brief description of the project:
Migration of Legacy system in C++, J2EE, Perl Sybase to DataStage 8.0, SQL Server 2008

Responsible for:
• Involved in System study, requirement analysis, impact analysis.
• Understand and analysis all source business systems. Understand current technical system and its flow to create knowledge base for to promote execution QA UAT activities.
• Project communications and meeting with stakeholders
• Participation in all technical discussion with client project team
• Coordinate with onsite/offshore team to prepare system design specification document
• Development and enhancement ETL processes, stored procedures, scripts, etc.
• Design strategies for Unit Testing, Integration Testing and QA testing.
• Support smooth migration from each phase (DEV,QA,UAT and Prod)
• Mentoring and grooming team.
• Technical review, Peer to Peer and Peer review.
• Creation of WBS for work allocation and charting progress.
• Gap Analysis of difference in technologies and finding workarounds to resolve them.
• Ensuring smooth transition from Dev to QA to UAT to Prod
• Identifying risks, blocking issues and develop mitigation strategies
• Giving KT to Onsite & Offshore teams on the application

Oct’11 – Nov’11
Project: Arval Batch Processing
Client Arval
Employer iGate
Environment: DataStage 7.5, Unix
Role: Technical Leading, Development, Integration

Brief description of the project:
Create a receiver system for all the files coming from external application. Integrate all the different child applications related to various data marts.

Responsible for:
• Involved in System study, requirement analysis
• Understand and analysis all source business systems and the target applications
• Project communications and meeting with stakeholders
• Participation in all technical discussion with client project team
• Coordinate with onsite/offshore team to prepare system design specification document
• Peer review
• Development of all ETL processes
• Integration of all ETL processes
• Perform Unit and integration testing
• Co-ordinate with different application stakeholders to create an integration strategies and solution

Jul’11 – Oct’11
Project: Saint Jude Medical USD Data mart
Client Saint Jude Medical
Employer iGate
Environment: Datastage 8.2
Role: Team Leading

Brief description of the project:
Various DataStage applications already in place require day to day support as well as time to time enhancement.

Responsible for:
• Involved in System study, requirement analysis
• Understand and analysis all source business systems
• Project communications and meeting with Clients
• Grooming/Helping resources in technical aspects.

Jun’09 – Jul’11
Project: Obelix , ATX, Capri Revenue Assurance, Means of Payment
Client SFR
Employer AtoS
Environment: DataStage 7.5.2x , UNIX shell scripting, Java, JBoss, EJB, C++, MQ Service and PL/SQL
Role: Team Leading, Development, Maintenance

Brief description of the project:
Obelix is an integration system built in DataStage that synchronizes data from Mainframe system to various new application systems. ATX is an audit system built in Datastage that checks data synchronized by Obelix. Capri is a revenue assurance system for prepaid calls that loads various rated CDRs to the target datamarts for generation of various inconsistency reports. Means of Payment is a payment gateway developed in J2EE and C++ for prepaid calls.

Responsible for:
• Involve in System study, requirement analysis
• Understand and analysis all source business systems
• Project communications and meeting with Clients
• Participation in all technical discussion with client project team
• Coordinate with onsite team to prepare system design specification document
• Peer review and product audits
• Mentoring the team and updating the client about the offshore work
• Project Planning, Estimation and Time management of tasks and team members
• Project reporting
• Development of all ETL processes
• Integration of all ETL processes
• Perform unit and integration testing
• Prepare Unit test cases, Integration test cases and User acceptance test case
• Defect analysis and reports such as DAR and CAR.
• Ensuring smooth transition of project from incumbent clients to company as well as from company to incumbent clients. Giving Knowledge transition to incumbent clients.
• Risk analysis, Gap analysis and creation of mitigation strategies.

Apr’08 – Jun’09
Project: FT Herman
Client France Telecom
Employer AtoS
Environment: DataStage 7.5.2x , UNIX shell scripting, PL/SQL
Role: Team Leading, Development, Maintenance

Brief description of the project:
Migration of all the customizations implemented in the P2P and Finance systems of Oracle Apps R11 to R12.
• Involve in System study, requirement analysis
• Understand and analysis all source business systems
• Coordinate with onsite team to prepare system design specification document
• Development and Unit testing
• ETL design
• Developing test cases, participation in Unit and Integration testing
• Developing robust DataStage jobs and sequences
• Coding of PL\SQL and UNIX shell scripts
• Defect Analysis and Prevention
• Estimation

Jun’07 – Apr’08
Project: Lien System Métiers
Client Renault
Employer AtoS
Environment: Pro*C, UNIX shell scripting, PL/SQL
Role: Development, Maintenance

Brief description of the project:
Lien System Métiers is a central repository of information for Renault’s factory production units, containing all information about its inventory design, car variants, models, etc. This repository gives necessary information to various external applications.

Responsibilities:
• Involve in System study, requirement analysis
• Understand and analysis all source business systems.
• Coordinate with onsite team to prepare system design specification document.
• Development and Unit and Integration testing
• Defect Analysis and Prevention
• Estimation

Jun’06 – Jun’07
Project: TPM
Client Orange NL, Orange Domnicana, Mobistar, Mobily
Employer Capgemini
Environment: Pro*C, UNIX shell scripting, PL/SQL, Talend, BSCS 5, 7,8
Role: Development, Maintenance, Migration

Brief description of the project:
TPM provides Telecom BSS/OSS (BSCS, etc.) solution for group of telecom operators such as Orange NL, Domnicana, Mobistar Mobily.
• Involve in System study, requirement analysis
• Understand and analysis all source business systems
• Coordinate with onsite team to prepare system design specification document.
• Development of real time backend solutions for BSCS
• Understanding Business impacts and generate solutions as per requirements of the business
• Perform Data Integration/Migration activities BSCS 5 – 8 using Talend
• Unit and Integration Testing

Jun’04 – Jun’06
Project: Telecom BSCS 6.0 BSS/OSS
Client Loop Mobile
Employer Loop Mobile
Environment: Pro*C, UNIX shell scripting, PL/SQL, BSCS 6
Role: Development, Maintenance, Migration, Configuration, UAT, Business Analysis

BSCS is telecom business support system for telecom postpaid subscribers. It provides a centralized repository which caters to various other systems. This project involved in automation of various systems along with the configurations involved with rating and billing chains. Generate of various reports for MIS and DSS systems. Handle the VAS, Prepaid, Interconnect system along with processes such as FIH, PRIH, RIH, RLH, FOH,TEH, BCH etc.

• Involve in System study, requirement analysis
• Understand and analysis all source business systems
• Development and Unit testing
• Understanding business from point of view of various departments such as Sales, Customer care, etc, and taking key decisions with respect to technological solutions.
• Perform Data Integration/Migration activities
• UAT, Integration Testing
• Configuration of the BSS/OSS systems
• Work with MIS, DSS, Sales and customer support team to provide them technological solutions.
• Creation of APIs and customization over BSS/OSS layers.
• Risk identification and mitigation

Mar’04 – Jun’04
Project: Student repository
Client Global Education Society
Employer Global Education Society
Environment: Sql Server 2000, VB6
Role: Development, Maintenance, Support
• Development and Unit testing
• Supporting monthly application job run
• Implement new changes to the system