Archtect InfoSphere Information Server 11.7 Admin, ETL Datastage, Data Integration, Data Governance

Client: HSBC Middle East
Environment :
Ascential Data Stage 7.5 (Parallel), shell scripting
Unix, DB2.Control-M, Trillium, Attunity tool.
Responsibilities:
Developer:
Project Name: GR Front End Project (GSC MI) 29-09-2008 to 30-04-2008
Client: HSBC internal
Environment:
Ascential Data Stage 7.5(Server),
Unix, Oracle, Windows NT.

Global service centers (GSC) are the HSBC centers for HSBC Business in the banking areas, which
enhances global business of HSBC. It has got 13 centers around the globe including INDIA. Business
intelligence is applied to improve the business so that it will help in intelligent decisions based
on the reports generated from the data warehouse of the client. We as an ETL team did the
transformation required and helped them build intelligent reports.
Worked in development, implementation and production support

Client: Capgemini France, Telecom and Media(PARIS)

Environment :
Teradata SQL assistant 6.1, Unix Shell scripts, Data stage 7.5(Parallel)

Project Description:
Basically, SFR is one of the service provider for telecom in France. This project mainly deals with
the validation work carried out in Data warehouse of the client for validating data in accordance
with the business rules. We are supposed to validate data in different environments and develop test
scripts

Responsibilities:

* Validate the date in the Data warehouse.
* Worked extensively validating data in different stage like testing and warehouse.
* Worked as a ETL developer and developed codes related to telecom domain.
* Worked on Slowly Changing Dimensions.
* Support and implementation.
* Involved in Unit Testing and performance Tuning

10.Project: VEGAS (France Telecom)

Description: France Télécom is the main telecommunication company in France and one of the largest
in the world. I was required to work as an onsite coordinator for Bangalore VEGAS team to
co-ordinate in developing and updating functional documents required to understand a TPV device
working, which was set up in the client side as a short time assignment.
Environment : Functional requirement documentation.
Duration : 16/04/2008 - 30/04/2008
Team Size : 15
Organization : Capgemini France , Telecom and Media(PARIS)
Role : Onsite Co-ordinator for B'lore Capgemini Vegas team

11. Project: OWL (Orange Windows Live)

Description:
Orange is the key brand of France Telecom, one of the world's leading telecommunications. Orange and
Microsoft announced their first convergent Instant Messaging offering for PCs and mobile. The new
service, named Orange Messenger by Windows Live, will allow users to benefit from the collaboration
between Orange and Microsoft® Windows Live' Messenger.
By using the Windows Live platform, the new Orange Messenger by Windows Live service will enable the
135 million France Telecom European customers (served by Orange or another brand) to smoothly
interact with 240 million worldwide Windows Live Messenger users. It will provide customers with a
connection to all the Orange portal services. A wide range of consumer mobile devices will provide
customers with access to the most widely used instant messaging service in the world, with a pricing
policy that will be adapted to instant messaging.
Environment : Open source system CVS, UNIX, Shell scripting.
Duration : 01/02/2008 - 15/04/2008
Team Size : 10
Organization : Capgemini France, Telecom and Media(PARIS)
Role : Developer (shell scripts)

Project: OFFICEMAX (Phase 1)
Description:
Project Description: OfficeMax Incorporated (NYSE: OMX) is a leader in both business-to-business
office products solutions and retail office products. OfficeMax provides office supplies and paper,
in-store print and document services through OfficeMax ImPressTM, technology products and solutions,
and furniture to consumers and to large, medium and small businesses. OfficeMax customers are served
by approximately 35,000 associates through direct sales, catalogs, e-commerce and more than 900
stores.
The overall objective of OfficeMax DataStage from the offshore perspective is to develop Interfaces
in DataStage Server followed by unit testing. The design specifications are primarily the
responsibility of the onsite team while coding and various forms of testing performed by the
offshore team. The deliverables generated by the offshore team will undergo a user acceptance test
before deploying them in a live environment. The scope at offshore is to Understand the design
documents, develop interfaces using DataStage Server and Sequence Jobs, unit testing of developed
code and support onsite integration testing and go live by providing bug fixes and changes to the
code.

Team Size : 10
Duration : Jun 2007 to Dec 2007
Role : ETL developer
Organization : Capgemini Consulting India Pvt Ltd(Mumbai)
Environment : Ascential Data Stage 7.5(Server jobs), Oracle 9i,
Windows NT.

Roles and Responsibilities in HCL technologies:

Department: Centre of Excellence(CoE).

1.Delivery support : Data Integration and Data governance using IBM InfoSphere Information Server
11.x

2. Installation and support to multiple client in HCL.

3. Delivery and performance issues support to HCL clients to resolve performance issues and provide
solution from Centre of excellence department.


5. Developed POC's for data governance using IGC tool.

6 . Installed and setup IBM InfoSphere Information Server 11.7

7. Represented HCL for Technology solutions to existing and new customers and contributed to get the
new business project for development by presenting HCL solutions and capabilities.

8. Developed Data lineage and business lineage reports using IGC for Banking customers using IBM
products.


9 . Provided training to freshers and experience resources for datastage 11.5.

10. Delivered support to data integration projects for data stage to multiple clients within
HCL(similar to IBM PMR support role)

Project details in IBM India, System Development Lab

Project name: MAGIC

Role performed: Individual role

DataStage developer, Lead and Administrator.

1. Supported MAGIC application used to support Global sales of IBM.
2. Fixed all data discrepancies.
3. Developed many jobs.
4. Successfully migrated DataStage from 11.5 to 11.5.0.2 version. (Installation, Configuration
and Setup activities) ---Windows 2012 platform


Project details in IBM Malaysia

Project name: Prosieben Sat

ProSieben (IPA: /pʁozibən/, sieben is German for seven) is a commercial television station in Germany
. It is largely distributed by cable and satellite and to a lesser extent digital video broadcasting
* terrestrial. It began operations on 1 January 1989. ProSieben is Germany's second-largest
privately-owned television company. Although ProSieben produces some of its programming itself, it
also airs many American imports. On 3 May 2012, ProSieben launched a payTV channel called ProSieben
Fun. A third channel called ProSieben Maxx started broadcasting on 3 September 2013.
The three different variants of the channel are: ProSieben (for Germany), ProSieben Austria (for
Austria), and ProSieben Schweiz (for Switzerland). The main difference is that they have different
advertisements and news for each target country.
Role: IBM DataStage SME (Subject Matter Expert)

* End to end support for BI solution.
* As a datastage administrator provided complete support for 9.1 ,11.3 and 11.5 versions of IBM
DataStage ETL tool.
* Installed datastage 9.1, 11.3 and 11.5 versions successfully.
* As a SAP BO administrator for reporting issues.
* As a datastage developer and architect for complete support of ETL batch.
* Resolved environmental issues for DB connectivity for Informix DB.
* Successfully migrated datastage projects from 9.1 to 11.3 and then from 11.3 to 11.5 versions
succefully.
* Succesfully deployed major change releases and enhancement projects containing ~5000 jobs.
* Implemented WLM for datastage 11.3 version to avoid stress on the ETL server and in turn resolved
many failures.
* Setup separate file system for datastage usages as a part for tunning.
* Increased connection parameters for Informix connectivity issues.
* Resolved job level issues.
* Created configuration files for the environment.
* Resolved performance issues.
Project details IBM India Pvt Ltd.

1. Project name: TD Bank (Technical Lead)
Description: Source system -Main frame (EBCDIC files and ASCII files)
Database: Netezza
Team size 16+
Tools: IBM DataStage 8.7 and 9.1 and Netezza.

TDCT has purchased MBNA Canada and will be converting the accounts residing on Bank of America's
system to Tsys' TS2 system.
TDCT has decided to adapt a Hybrid approach - fitting somewhere between running as a stand-alone
business and full integration for Product and Operational functions. There will be some interfaces
managed through TDCT/MBNA's iHub/Integration Layer ETL (Data Stage) system while others will be
direct.
Applications and infrastructure will leverage existing TD systems and processes (including in flight
projects) where possible. Given tight execution timelines and budget constraints, the business has
decided to identify and prioritize only the critical few capabilities that are "strategic
imperatives" needed to preserve the value of the MBNA portfolio, distinct from "foundational
capabilities" needed to meet operational requirements to run the business. Foundational capabilities
will utilize existing TDCT or Tsys functionality as much as possible. Strategic imperatives may
leverage existing TDCT or Tsys functionality; use a vendor or build from scratch.

Role: Team Lead

2. Project name: L&T

1. As a developer and Admin and the Team lead for EDW module which is critical for the Cognos
reports used by the business end.
2. My role in this project is basically performance tuning of the existing code which is failing in
production due to the poor coding of the DataStage jobs when it processes large volume of data from
source systems. Currently the ETL batch is stable and automated to restart the ETL batch whenever
the job fails due to memory constraints.
3. Made sure ETL batch completes within timelines as the data is required by the business end.
4. There are no failures after I applied permanent fix in the ETL code for 3 months. (Achievement as
expected).
7. Resolved environmental issues like memory from the ETL server.

3. Project name: National Commercial Bank, KSA
Module: ATM reports

Description:

The National Commercial Bank (NCB) also known as AlAhli Bank is the first Saudi Arabian bank, the
largest bank by asset in the Arab world and one of the pioneers in Islamic Banking and finance in
the world. NCB is primarily a Jeddah based bank with its registered Head Office in Riyadh.
There was a lot of scope for ETL operations in core banking and improve the existing system by
creating new designs and new reports to enhance and upgrade the existing NCB system to.

Module: ATM reports

There was a need of daily reports for the existing monthly ATM reports by creating a new design and
enable it for the daily reporting in ATM reports against the monthly reports. ATM reports does
consist of ticket history details, ATM machine details, active state durations, ATM service details
and ATM active categories.