Project title : CMR Project
Client : Aimia
Role : Senior ETL Consulatant
Environnent : IBM InfoSphère DataStage 11.3, Oracle

Project Description:

AIMIA, formerly Groupe Aeroplan, is a data-driven marketing and loyalty analytics company based in Montreal, Canada, has close to 4,000 employees in 20 countries, and is publicly listed on the Toronto Stock Exchange, which manages various loyalty programs including Aeroplan in Canada, Nectar (Italy and the UK) and provides loyalty strategy, program development and management services to clients underpinned by product and technology platforms such as the AIMIA Loyalty Platform and Smart Button, and through their analytics and insights business, including Intelligent Shopper Solutions. Merchant rewards is a loyalty program where the respective cardholders of AIMIA’s customer have a dizzying array of points, miles and cash-back rewards programs to choose from. Respective customers of AIMIA can exchange their points earned by purchasing any product of their choice available in AIMIA’s Merchant provide source. They can also opt for exchanging their points for miles by booking any rental cars and redeem their points.

Roles & Responsibility:

Worked on enhancements to update existing datastage jobs.
Developed and modified the Data stage parallel jobs using transformer, Join, Lookup, Filter to load the data into the warehouse tables.
Prepared the Unit test cases, executed the Unit test cases and capturing the result.
Integrating the individual data stage PX jobs into Data stage sequence based on the dependency.
Schedule the data stage jobs using Control M scheduler based on the requirement.
Prepared the Control M scripts for DS jobs and ran the scripts to load the data into the tables.
Prepared the delivery checklist and required code to be migrated for higher environments.
Participated in code migration acitivities and Verified the code after code migration.

AIMIA, formerly Groupe Aeroplan, is a data-driven marketing and loyalty analytics company based in Montreal, Canada, has close to 4,000 employees in 20 countries, and is publicly listed on the Toronto Stock Exchange, which manages various loyalty programs including Aeroplan in Canada, Nectar (Italy and the UK) and provides loyalty strategy, program development and management services to clients underpinned by product and technology platforms such as the AIMIA Loyalty Platform and Smart Button, and through their analytics and insights business, including Intelligent Shopper Solutions. Merchant rewards is a loyalty program where the respective cardholders of AIMIAs customer have a dizzying array of points, miles and cash-back rewards programs to choose from. Respective customers of AIMIA can exchange their points earned by purchasing any product of their choice available in AIMIAs Merchant provide source. They can also opt for exchanging their points for miles by booking any rental cars and redeem their points.

Project title : UK Business Intelligence
Client : HSBC
Role : ETL Consultant
Environnent : IBM InfoSphère DataStage 11.3, Teradata

Project Description:

HSBC is one of the largest banks in the world. HSBC is one of the growing multinational financial services company. The main aim of the project is to maintain the existing data warehouse and also enhance/create new flows to enhance the data warehouse according to the requests received from UK Business. The project uses Data Stage 11.3 as the ETL tool and the Cognos for its reporting and analysis requirements. The major applications involved in warehouse for UK business intelligence as part of the (UCD) mart, SPM, CARDs, Complaints, CTA and UK Warehouse Applications.

Roles & Responsibility:

Develop the Data stage parallel jobs using transformer, Join, Lookup, Filter to load the data into the warehouse tables.
Prepared the Unit test cases, executed the Unit test cases and capturing the result.
Integrating the individual data stage PX jobs into Data stage sequence based on the dependency.
Schedule the data stage jobs using data stage scheduler based on the requirement.
Run the jobs from the director to load the data into the tables.
Prepared the System test cases for system testing.

HSBC is one of the largest banks in the world. HSBC is one of the growing multinational financial services company. The main aim of the project is to maintain the existing data warehouse and also enhance/create new flows to enhance the data warehouse according to the requests received from UK Business. The project uses Data Stage 11.3 as the ETL tool and the Cognos for its reporting and analysis requirements. The major applications involved in warehouse for UK business intelligence as part of the (UCD) mart, SPM, CARDs, Complaints, CTA and UK Warehouse Applications.

Project title : Investment ODS
Client : Prudential Financial
Role : ETL Consultant
Environnent : IBM InfoSphère DataStage 11.5, DB2, SQL Server

Project Description:

Prudential Financial has helped individual and institutional customers grow and protect their wealth. We are known for delivering on our promises to our customers, and are recognized as a trusted brand and one of the world’s most admired companies. We strive to create long-term value for our stakeholders through strong business fundamentals, consistent with our mission guided by our vision and directed by our company's core values.

Regarding IODS project, previously the business asked us to provide all of the data to Markit Digital and they would work with MD on the business rules, As the complexities of the business rules become more apparent, there is growing concern in the Technology team about information consistency and risk of multiple interpretations of business rules, Here the concern has been voiced that we should not leave the interpretation of business rules up to any of our consumers including Markit Digital. IODS Main responsibilities are information acquisition, refinement, mastering and publication. Here refining and mastering process are where the business rules implemented and provided the data for publication.

Roles & Responsibility:

Extracted the data from different source systems and loaded data into target warehouse.
Designed the Data stage parallel jobs using transformer, Join, Lookup, Filter to load the data into the warehouse tables.
Prepared the Unit test cases, executed the Unit test cases and capturing the result.
Involved in Performance Tuning and resolve performance issues.
Integrating the individual data stage PX jobs into Data stage sequence based on the dependency.
Provided the updates to mapping team queries and issues in timely manner.
Worked in shifts to give continuous support to the on-shore team.
Providing technical and investigative support for defects, change requests, debugging issues for the reported issues.
Maintained high quality of documentation - In the form of Application Design documents and Test cases.
Prepared the DataStage sequencers as per client requirement’s.

Prudential Financial has helped individual and institutional customers grow and protect their wealth. We are known for delivering on our promises to our customers, and are recognized as a trusted brand and one of the worlds most admired companies. We strive to create long-term value for our stakeholders through strong business fundamentals, consistent with our mission guided by our vision and directed by our companys core values. Regarding IODS project, previously the business asked us to provide all of the data to Markit Digital and they would work with MD on the business rules, As the complexities of the business rules become more apparent, there is growing concern in the Technology team about information consistency and risk of multiple interpretations of business rules, Here the concern has been voiced that we should not leave the interpretation of business rules up to any of our consumers including Markit Digital. IODS Main responsibilities are information acquisition, refinement, mastering and publication. Here refining and mastering process are where the business rules implemented and provided the data for publication.

Project title : Relational Management Warehouse
Client : TIAA - CREF
Role : DataStage- ETL Developer
Environnent : IBM InfoSphere DataStage 11.3, Oracle, Teradata, Unix/Linux.

Project Description:

TIAA-CREF (Teachers Insurance and Annuity Association – College Retirements and Equities fund) has established a centralized Data Warehouse Environment to support its various reporting initiatives, leveraging common, consistent information. The EDW system is developed using IBM’s Business Intelligence Methodology and Banking Data Warehouse Model and is mainly used for building and publishing the Quarterly Statements and reports for affiliated institutions.

Roles & Responsibility:

Develop the Data stage parallel jobs using transformer, Join, Lookup, Filter to load the data into the warehouse tables.
Prepared the Unit test cases, executed the Unit test cases and capturing the result.
Loaded the data manually using the DB2 Load scripts.
Integrating the individual data stage PX jobs into Data stage sequence based on the dependency.
Given the knowledge transfer sessions for AMS Team.
Schedule the data stage jobs using data stage scheduler based on the requirement.
Help the team members in solving the issues.
Run the stored procedure to load the data into the tables.
Run the jobs from the director to load the data into the tables.
Prepared the System test cases for system testing.

TIAA-CREF (Teachers Insurance and Annuity Association – College Retirements and Equities fund) has established a centralized Data Warehouse Environment to support its various reporting initiatives, leveraging common, consistent information. The EDW system is developed using IBMs Business Intelligence Methodology and Banking Data Warehouse Model and is mainly used for building and publishing the Quarterly Statements and reports for affiliated institutions.

Project title : Analytic Data System
Client : Western Digital
Role : Team Member
Environnent : IBM InfoSphère Data stage 11.3, SQL Server, Unix/Linux.

Project Description:

Western Digital Corporation is one of the largest computer hard disk drive manufacturers in the world. Western Digital Corporation has a long history in the electronics industry as an integrated circuit maker and a storage products company. The Western Digital Corporation (WD) Analytic Data System (ADS) system is based is a data warehouse application designed to manage ADS data for enterprise reporting and analytics of MMO and MHO manufacturing data. It provides a single access point for WD manufacturing data identified as valuable sources of operational and analytical data.

Roles & Responsibility:

Used the DataStage Designer to develop jobs for extract, cleanse, transform and load the data into Netezza Data warehouse.
Involved to compiling, validating, running, Monitoring and scheduling the jobs using the Data Stage Director.
Understanding the business model and customer requirements and giving solutions to the customer based on the requirements.
Used Data Stage Director for running and monitoring the jobs.
Created Data Stage sequences to run multiple instances using loop stages.
Created unit testing template for this project and participated in the unit testing.
Involved in Performance Tuning and resolve performance issues.

Western Digital Corporation is one of the largest computer hard disk drive manufacturers in the world. Western Digital Corporation has a long history in the electronics industry as an integrated circuit maker and a storage products company. The Western Digital Corporation (WD) Analytic Data System (ADS) system is based is a data warehouse application designed to manage ADS data for enterprise reporting and analytics of MMO and MHO manufacturing data. It provides a single access point for WD manufacturing data identified as valuable sources of operational and analytical data.

Otsuka America Pharmaceutical, Inc (OAPI) is part of the Otsuka Group. OAPI was established in the US in 1989 and is responsible for all pharmaceutical and medical device commercial activities in North America. OAPIs corporate objective is to be a strong, highly competitive organization, focused on both our customers and top-line growth, continuing to successfully launch products for better patient outcomes. Some of OAPIs developed and in-licensed products are Abilify, Samsca, IV Busuflex, BreathTek, Sprycel and Pletal. These products are used in the following therapeutic categories are Neuroscience, Cardiovascular, Oncology, Medical Devices. The objective of the Commercial Predictive Analytics Think project is to maximize the Abilify IM Depot Launch via personalized micromarketing, optimized resource allocation, and deployment & delivery of support and education services to maximize uptake. To achieve this objective, the project will identify segments of physicians that are characterized by their predicted behavioral response to outreach by OAPI recommend next best actions and outreach to targeted segments of physicians to optimize their future value.

Project title : OTSUKA Think Analytics
Client : Otsuka Pharmaceutical Company
Role : Team member
Environnent : IBM InfoSphere Data stage 9.1, IBM DB2, Unix/Linux.

Project Description:

Otsuka America Pharmaceutical, Inc (OAPI) is part of the Otsuka Group. OAPI was established in the US in 1989 and is responsible for all pharmaceutical and medical device commercial activities in North America. OAPI's corporate objective is to be a strong, highly competitive organization, focused on both our customers and top-line growth, continuing to successfully launch products for better patient outcomes. Some of OAPI's developed and in-licensed products are Abilify, Samsca, IV Busuflex, BreathTek, Sprycel and Pletal. These products are used in the following therapeutic categories are Neuroscience, Cardiovascular, Oncology, Medical Devices. The objective of the Commercial Predictive Analytics Think project is to maximize the Abilify IM Depot Launch via personalized micromarketing, optimized resource allocation, and deployment & delivery of support and education services to maximize uptake. To achieve this objective, the project will identify segments of physicians that are characterized by their predicted behavioral response to outreach by OAPI recommend next best actions and outreach to targeted segments of physicians to optimize their future value.

Roles & Responsibility:

Developed the Data stage parallel jobs using transformer, Join, Lookup, Filter etc to load the data into the warehouse tables.
Prepared the Unit test cases, executed the Unit test cases and capturing the result.
Loaded the data manually using the DB2 Load scripts.
Integrating the individual data stage PX jobs into Data stage sequence based on the dependency.
Given the knowledge transfer sessions for AMS Team.
Schedule the data stage jobs using data stage scheduler based on the requirement.
Help the team members in solving the issues.
Run the stored procedure to load the data into the tables.
Run the jobs from the director to load the data into the tables.
Prepared the System test cases for system testing.

Project title : PRISM
Client : JP Morgan Chase
Role : Team member
Environnent : IBM DataStage 7.5.2 & 8.0.1, Oracle (9i, 11g), AIX64bit

Project Description:

PRISM Application is used to measure the performance of a client’s portfolio against a benchmark. These benchmarks are built on some industry provided Indexes (e.g. MSCI, FTSE etc). Currently PRISM receives the Index feed from RIMES. It is third party vendor which provides various feeds like Index, Characteristics and Accounting feed. The accounting feed consisting of securities which forms the client portfolio is received from WINS on daily and monthly basis. In business terminology client is called a Business Unit. A business Unit is made up of several Composites which in turn contains the set of accounts. An account is build up on securities.

Roles & Responsibilities:

Migration of jobs from DataStage 7.5 to DataStage 8.1 using DS export.
Identify the problems in the job if failing and debug the jobs.
I modified the scripts and run the UNIX scripts.
Execute the SQL queries check the data in the database.
Testing the jobs and uploading the file in dashboard and check the data is moving to target database.
Prepare the test cases in for testing and updated in HP quality center.
Involved in Performance Tuning and resolved the performance Issues.
Worked on Application Change Requests (ACR).

PRISM Application is used to measure the performance of a clients portfolio against a benchmark. These benchmarks are built on some industry provided Indexes (e.g. MSCI, FTSE etc). Currently PRISM receives the Index feed from RIMES. It is third party vendor which provides various feeds like Index, Characteristics and Accounting feed. The accounting feed consisting of securities which forms the client portfolio is received from WINS on daily and monthly basis. In business terminology client is called a Business Unit. A business Unit is made up of several Composites which in turn contains the set of accounts. An account is build up on securities.