Description : CDI shall consolidate Customer and Account information across USA to maintain customer demographic information and account associations. CDI has multiple source systems which are then validated on standard basis like record count validation, header and trailer validations. Further this customers are classified as Wealth, business or Local customers according to the business rules. These customers are associated with the accounts and relationship between accounts and customers are maintained.

Responsibilities:

• Understanding the requirement and developing it accordingly.
• Developing the Applications using Ab Initio and availing re-usability techniques for cost reduction.
• Get involved in various phases of testing and providing KT, resolving the issues faced by testing team. Involvement in deployment phase and ensuring its quality.
• Creating Technical Design documents for maintaining history of changes.
• Fixing bugs or doing enhancements in existing Applications according to need of requirement.
• Responsible for overseeing the Quality procedures related to the project.

Environment: Ab-Initio GDE 3.1 and Co-op 3.1, Shell scripting, Oracle, UNIX, Windows XP, TWS (Tivoli)

Description : This AML BI reporting project is designed to create data mart for reporting purposes. Currently BO reports are generated for suspicious transaction activities happening across different regions and countries. This entire customer's their associated accounts and transactional data resides in multiple subject areas such as CITI CMT,MANTAS,QA-Hybrid and Zeus in different regions which are APAC,EMEA,NAM/LATAM.

Main purpose of this project is to consolidate these reports (only the required ones) and load this data into newly designed data mart so eventually Micro Strategy reporting engine will generate the precise and consolidated information (Report) out of this Data Mart.

Responsibilities:

· Understanding the requirements and involving in development of different continuous and batch graphs.

· Attending daily review calls with team on the issues and code review.

· Working in Agile methodology for this project and attending scrum calls with status updates and requirements gathering.

· Extensively involved in Data Extraction Transformation and Loading (ETL Process) from Source to target systems using Ab Initio and UNIX.

· Identification of problems in the graphs and modules, arriving at solutions.

· Generic graph development to load all regions using the same.

· Identification of problems in the graphs and modules, arriving at solutions.

· Inbound & Outbound Batch graphs development.

Environment: Ab-Initio GDE 3.1 and Co-op 3.1, Shell scripting, Oracle, UNIX, Windows XP, Autosys

Description : Information Management is a centralized data warehouse which holds the data from different data marts includes transactional and non-transactional data.

This warehouse is having the data which is created by using Change Data Capture (SCD2) logic. This data holds the daily transactions of different customers and their profile details like branch and card types etc. Data in this warehouse will be used by the Business users for creation of different reports.

Responsibilities:

· Preparing Technical Design Documentation.

· Understanding the requirements and involving in the development of different graphs.

· Extensively involved in Data Extraction Transformation and Loading (ETL Process) from Source to target systems using Ab-Initio and UNIX.

· Mainly worked on different Ab-Initio concepts like parallelism using multi-file systems.

· Test support for SIT & UAT.

· Supporting the production team in case of any critical issues.

Environment: Ab-Initio, Shell scripting, Teradata, UNIX, Windows XP, TWS (Tivoli)

Description : Archimedes is a service which serves Barclaycard’s analytics platform and will provide the business with a scalable Data Warehouse and Analytics platform that will meet both the current and future business objectives. Archimedes processes the data from GDAP platform and loads into oracle. As per the business requirement it process all the Barclaycard data which includes Credit cards, Debit cards and all other gift card transactions of that particular day and month.

Responsibilities:

· Analysis of the technical specifications and preparing the IA (Impact Analysis) document.

· Understanding the requirements and involving in development of different graphs.

· Extensively involved in Data Extraction Transformation and Loading (ETL Process) from Source to target systems using Ab-Initio and UNIX.

· Identification of problems in the graphs and modules, arriving at solutions.

· Production batch Monitoring and recovery of failures.

· Code fixing to run BAU without any failures.

· Involved in changing the schedule definition to complete the BAU within SLA.

Environment: Ab-Initio, Shell scripting, Teradata, UNIX, Windows XP, TWS (Tivoli)