Satya Sampath Veerubhotla

Project Client : Fidelity International Pvt. Ltd.

Employer : IBM India Private Limited

Designation : Advisory System Analyst

Duration : 10/10/2022 - till date

Role : PLSQL Consultant

Role and Responsibilities:

· Worked on developing PLSQL codes for archiving data into backup tables, creating Unix scripts and control M.

· Worked on simplifying complex file transfer system by coordinating with respective teams and delivering it on time.

· Worked on creating multiple control M jobs and managing them as per requirement.

· Worked on basic Sybase and BOXI reports to generate report as specified in confluence.

· Fixing issues related to Control M, Unix Shell Scripts and SQL codes (oracle and basic Sybase)

Project Client : Australia and New Zealand Bank (ANZ), Australia

Company Name : IBM India Private Limited

Designation : System Engineer

Duration : 09/08/2021 to 30/09/2022

Role : Senior PLSQL Developer

Role and Responsibilities:

· Solving and delivering the issues raised for new code development or existing codes in JIRA.

· Worked on developing PLSQL codes for existing/new source system as provided in Confluence and applying the logics as per mapping rule provided in confluence.

· Creating packages by using the developed codes/scripts which are developed by means of Source Tree.

· Coordinating with environment team for migrating codes to various regions which are committed using source tree.

· Developing new shell scripts to monitor data which is populated in various standard tables.

· Scheduling scripts / SQL scripts developed on server by means of Control-M.

Project Client : National Commercial Bank, Jeddah (NCB)

Employer : Tata Consultancy Services Private Limited

Designation : System Engineer

Duration : 31/12/2020 to 06/08/2021

Role : PLSQL Developer

Role and Responsibilities:

· Providing solutions and suggestions for implementation of new functionalities in CIF, DEPOSITS and GENERAL LEDGER in core banking.

· Developing codes based on client requirement.

· Providing code by interacting with frontend and backend team and provide change as per the client requirement.

· Provided PLSQL code for one time data fix on a table.

Project Client : State Bank of India (SBI)

Employer : Tata Consultancy Services Ltd.

Designation : System Engineer

Duration : 19/08/2016 to 04/11/2020

Role : Developer (Performance Tuning)

Role and Responsibilities:

● Providing performance improvement solutions by interacting with customer

● Proactive identification of production issues and providing quick and efficient fixes

● Support to production issues

● Interacting with customers for providing performance improvement solutions

● Shell scripting for monitoring purpose and to run COBOL jobs on UNIX platform.

● Converting database-intensive jobs to PLSQL for performance improvement.

● Archival of large tables and writing PLSQL scripts for archival automation process

● Multi app conversion of Report jobs to utilize the RAC environment in Report generation.

● Utilizing the system resources by making the jobs multi-threaded.

● Measuring the application and database server utilization using tools like glance, top during the End of Day jobs to identify the performance.

● Identifying the jobs, queries which uses more CPU, DB, IO resources by using dictionary views and handling them by making the required changes.

● Debugging to identify potential performance bottlenecks and troubleshooting.

● Troubleshooter for production issues.

• Analyzed existing SQL queries to identify opportunities for improvements.
• Created optimal technical solutions to user needs with in-depth system analysis.