Santhosh Kumar V

Involved in the implementation of The AT&T DBaaS Cloud Implementation in Oracle India Pvt. Ltd. India Project: ATT currently manages multiple projects and models within Apptio that caters Costing & Operational Reporting tool for the ATT Technology & Operations called the Donavan Organization. As per the agreement with Oracle all ATT applications are being evaluated for a possible replacement with Oracle solutions where fit and applicable

The Unified Data Architecture is the new data structures and processes that move data from source to presentation layer for all future product development. Project: EODS/EBDW/DM load is a metadata driven process that is driven by architectural components for the loading of data, with additional support components that provide common access to read/write load specific information. This document provides the interfaces to access these support components and information on how to utilize them properly.

• Actively participated in discussion sessions to design the ETL job flow. • Creation of multiple database objects. Testing and Bug Fixing in application’s Functionality • Developing Stored Procedure and packages in DB Manager • Worked on indexes, analyze and rebuilding indexes online and parallel hint. • Made use of collections in procedures to generate high performance queries and PL/SQL code.

• Creating Stored Procedures (SP) from the existing JSP files. • Supporting the creation of universe fields using Information Design Tool (IDT). • Direct discussion with the client regarding the design of reports. • Supporting the team members for the design issues and resolving them. • Complete documentation for the Stored Procedures

• Requirement gathering from the Business Team. • Convert the functional requirements into technical document as per the business standards. • Worked as per the CR Raised from the end user. • Analyze the Existing code and do the impact analysis. • Created Database Objects like tables, Views, sequences, Synonyms, • Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.

• Requirement gathering and worked according to the CR. • Worked under the senior level guidance. • Data validation/Reconciliation report generation. • Code Development as per the client requirements. • Involved in the development backend code, altered tables to add new columns, • Constraints, Sequences and Indexes as per business requirements. • Perform DML, DDL Operations as per the Business requirement. • Creating views and prepares the Business Reports.