Now you can Instantly Chat with Raja!
About Me
Over 7+ years expertise in the ETL tool Ab-Initio, worked as an ETL developer and module lead. Developed graphs/jobs/mappings to extract data from source system and then transform the data as per the target system requirements Developed different uti...
Show MoreSkills
Portfolio Projects
Description
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)
Show More Show LessDescription
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
Show More Show LessDescription
A critical part of the American Express Accounts Receivable (A/R) strategy is to simplify and reduce the number of A/R systems in use today. As part of this strategy, G* (Globestar) has been identified as the POA A/R system for the international portfolio. Some of the AS-IS systems interacting with AR will also be changed. As part of the Project Pegasus, changes will be made to the Global Corporate & Mexico markets. Global Corporate changes will be the foundation (Corporate card base functionality) for the international markets and is required prior to any markets going live. Mexico is targeted as the first market for implementation.
Show More Show LessDescription
The scope of the project is to Build and implement a new hierarchy setup which will be used by corporate cards in Amex based on the feeds received from SFDC system and this process implemented for all the markets. Process will setup new hierarchy above Master Control Account with Regional Parent and Global Parent and Master Control Account will be linked with Basic Control Account to setup new card members.
Show More Show LessDescription
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)
Show More Show LessDescription
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)
Show More Show Less