Prashanth Reddy Email & Phone Number

Hyderabad, Telangana, India

Hyderabad Area, India

Developed the new jobs using .Jils script in Autosys Environment.Deployed the new extract jobs using JENKINS and Udeploy tools.Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.Used SQL loader to load the data from the files provided by the interfacing applications.Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.Created partitioned tables and partitioned indexes to improve the performance of the applications.Wrote PL/SQL Database triggers to implement the business rules in the application.Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.

Hyderabad Area, India

• Shell script programming for the new jobs creation.• Created Complex Queries for Views for reporting purposes.• Developed/Debugging PL/SQL Procedures, Functions to satisfy requirement.• Developing and implementing customizations as per requirement of the client.• Involved in Servers maintenance activities.

Hyderabad Area, India

• Involved in development, implementation and support of Sure Product.• Created Complex Queries for Views for reporting purposes.• Developed/Debugging PL/SQL Procedures, Functions to satisfy requirement.• Developed Customized Reports using Crystal Reports as per client requirement.• Developing the test cases as per requirement of the client.• Developing and implementing customizations as per requirement of the client.• Involved in requirement gathering, analysis, documentation.• Involved in daily and weekly meetings with client.• Involved on Project Coordination and Management activities with client and internal teams.