Sai Lakshmi Yamini Garuda

Project Description:

Title : Standard Life Aberdeen Investment Banking - ASI TEM

Client : Standard Life Aberdeen Investment Banking

Technical Skills : Ab Initio, UNIX, MS SQL

Role : Support Analyst

Tools :

ETL Tool : Ab Initio(GDE v3.5.3)

Database : MS SQL Server Management Studio 17

Scheduling Tool : Autosys

Other tools : Putty, Control Center,Service Now, IBM MQ Message Broker

Responsibilities:

1. Monitoring the batches in Autosys

2. Checking the error logs and batch status using Control Center and recovering the batches using putty

3.Handling the flow of incidents using Service Now

4.Working on tag migration and tag localisation requests.

5. Documentation of PDG

6. Handling of Change Approvals

Project Description:

Title : FedEx Sales IT Integration - TNT

Client : FedEx

Technical Skills : Ab Initio, Oracle,UNIX, Teradata, One Automation

Role : Developer

Tools:

ETL Tool : Ab Initio (GDE v3.5.1.6)

Database : Oracle SQL, Teradata

Scheduling Tool : One Automation (1A)

Project Methodology : Agile

Project Summary : The project involves Segmenting the source on country and facility, which are then divided based on the region. The segmented EAN (Enterprise Account Number) are aligned on BBM (Building Block Methodology) to create the Territory Id. The Territory Id’s are provided to client so that the fix the Incentives and Targets based on it.

Responsibilities:

1.Understanding Business Requirement and Created High Level Design Document.

2.Developed Ab Initio graph based on the business requirement using various Components.

3.Prepared Graphs to validate the file and load them into the tables based on the condition.

4.Writing Test Cases to check the functionality meets the requirement or not.

5.Writing Unix Shell scripting to Automate process.

6.Monitoring Jobs in One Automation and fixing the error when it fails. 7.Participated in UAT and System Integration Testing.

8.Migrating jobs and workflows to another environment through One Automation.