Raja R.

Raja R.

Sr ETL Ab Initio Developer

Hyderabad , India

Experience: 7 Years

Raja

Hyderabad , India

Sr ETL Ab Initio Developer

17142.8 USD / Year

  • Immediate: Available

7 Years

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 utility scripts according to project specifications such as archiving and purging script, incident generation script, sending mails to the support teams in case of any rejections.
  • Involved in ETL processes like extraction and transformation of data, loading of data in target system, & generation of feed files.
  • Created valuable reusable code/graphs for improving the efficiency. Ex : Generic Loader graph
  • Worked extensively in implementing Data Warehouse Applications and Business Intelligent applications.
  • Involved in Specification and Requirement Analysis, Design, Development, and Testing of applications
  • Extensive Knowledge in Banking and Financial Projects.
  • Experience to create vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
  • Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.
  • Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
  • Create new methods to clients to improve the process and reduce the costs
  • Generate weekly change reports to classify the infrastructure and development changes.
  • Involved in all the phases of SDLC (Waterfall and Agile) - Analysis, Design, Development, Implementation and Testing of applications involving the tool Ab-Initio, Teradata, Oracle, DB2, UNIX.
  • Interaction with Client to discuss critical issues and taking the acknowledgement and providing the resolution.
  • Thorough knowledge of UNIX Commands.
  • Energetic self-starter with excellent analytical and organizational skills.
  • Excellent Interpersonal skills, business communication & presentation skills.
  • Ability to satisfy, delight & retain customers by quality & process improvement.

Show More

Portfolio Projects

Customer Data Integration

Company

Customer Data Integration

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 Less

AML BI Reporting

Company

AML BI Reporting

Description

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 Less

Information Management

Company

Information Management

Description

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 Less

Tools

Thimble

Archimedes

Company

Archimedes

Description

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

Tools

Thimble