Keerthika Muthyala

• Centralized Enterprise Data warehousing solution design is to meet demands of business areas by providing standardized and integrated enterprise wide data that provide one version of the truth for all business areas consistently utilize.
• EDW contains data from source systems that represent the entire product life cycle.
• Application : Enterprise Data Warehouse
• Database : Teradata 10.15.

• Few application logics reside in , and those need to be converted into Oracle code by retaining the functional logic. Analysing the logic in sybase, writing the PL/SQL program for retaining the old logic in sybase and make the code compatable.
• Languages: Oracle 12c,
• Sybase Tools Used: Toad, Toad for SAP solutions,
• Scheduling Tools : Autosys

• The data migration of VLS to MSP performs servicing for home equity, private banking, small business and a portion of auto.
• Analyzing the SAS programs and modifying according to the client requirements. Validating VLS to MSP data by performing SIT, UAT testing and reporting the defects in ALM. Writing & Analyzing SQL queries.
• Languages: Oracle 11g,
• SAS Tools Used: Toad, Teradata, WINSCP

Data Migration will be done using the ETL approach and performing the validation developing PL/SQL Stored Procedures to implement Post data validation concepts.

• Languages: Oracle 11g
• Tools Used: SQL developer, WINSCP

Description: PAS(Participant Accounting System) is a complete record keeping system for client in order to maintain their investment plans that includes the 5500 preparation, tax reporting, Census testing, Voice & Internet access/Response, Clients Repots etc.

• Responsibilities: As PAS system is migrated to DST on 11-21-2015, worked for handling deployments and production support by analyzing PL/SQL Stored Procedures and Unix shell scripts and writing SQL Queries and Unix Shell Scripts based on the requirement.
• Languages: Oracle 10g, Java 1.4, Weblogic, UNIX Shell
• Tools Used: Toad, WINSCP, Putty, ECLIPSE, Unicenter

The project deals with the rating of the object.

Languages: Sybase, UNIX Shell Scripting

• Airline Domain Description : The O&D (Origin & Destination) system is a joint development between British Airways and Qantas for the control of Revenue Management with the purpose of enhancing Qantas ability to maximize the returns on every available flight seat by working on Batch Jobs scheduled on UNIX