Oracle Pl/sql Developer

Sreeja Kotha

Nashville, Tennessee

Phone: 945-***-****

Email:************@*****.***

Professional Summary

• Over 6.3 years of programming experience as an Oracle Plsql developer in Analysis, Design and implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical Functions, Materialized Views and query Rewrite.

• Experience with Python scripting for data manipulation and processing.

• Expertise with Very large OLTP, Data Warehousing, and high-volume batch processing systems.

• Developed Python Scripts to cleanse,validate and process the data files to Oracle database.

• Developed Reconciliation Scripts to ensure data accuracy between source and target systems and used Gitlab for source code management.

• Developed Materialized Views for replication data in distributed Environments.

• Excellent technical and Analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

• Used PlSql tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.

• Loaded data into Oracle tables using SQL Loader, Python Scripts, Stored Procedures.

• Experience with Oracle supplied packages such as DBMS_SQL,DBMS_

JOB,UTL_HTTP, UTL_SMTP and UTL_FILE

• Experience with Performance tuning for Oracle RDBMS using Performance and Hints.

• Experience in ETL tools in Analysis and Reporting using Informatica Powercenter.

• Created and automated shell scripts for data transfer and process automation using Control-M and crontab.

• Worked in Telecom and Banking domain projects using Agile Methodology.

• Experience with AWS cloud-based and on-prem databases.

• Proficient at working as a team player with the aim of contributing towards the team’s success.

Technical Skills:

Database Systems : Oracle 10G,11G,12C, POSTGRESQL

Tools : SQL Developer, JIRA, Putty, PG Admin, Confluence, Control-M

Operating System : Windows, Unix

ETL Tools : Informatica Power Center 9

Programming Languages : PLSQL, Unix Shell Scripting, Python (Data Processing)

Professional Experience:

Capgemini, Hyderabad June 2021 – March 2023

Client - HSBC, Role - Pl/Sql Developer

Project - Strategic Audit Management System (SAMS), has been accessed across 40+ countries for various audit related activities like maintaining audit records of various other systems used in banks. Record issues and actions against Audit result.

Responsibilities:

• Developed audit management features using Packages, Procedures, Triggers, Views, functions as per requirement.

• Engaged in regular client communication to enhance and troubleshoot live environment issues.

• Developed Python Scripts to cleanse,validate and process the received data from different source systems into SAMS.

• Automated Scripts to process the received data from different systems into SAMS.

• Developed Scripts to send data from SAMS to other systems and scheduled the jobs to share the files using control-M.

• Automated processes to improve system performance and ensure smooth operation.

• Experienced in importing data from Flat Files from Legacy Applications to Oracle DB using Python Scripts.

• Unit test to assure/meet requirements.

Tata Consultancy Services (TCS), Hyderabad Feb 2017 – June 2021

Client - Verizon, Role - Pl/Sql Developer March 2019 – June 2021

Project - Real Time Customer Insights (RTCI), is a Telecom domain application which interacts with many external systems. Real Time Customer insights is a unified platform to provide better service for the customers by identifying the caller’s service issues proactively and taking them to necessary self-serve paths that helps reduce calls reaching the call center which saves revenue.

• Developed and automated PL/SQL Packages, Procedures, Triggers and Views to process customer real time data and display key metrics in dashboards.

• Developed and automated the scripts to alert via emails whenever there is discrepancy in the dashboard and metric data.

• Created scripts for real-time monitoring and alert systems to track discrepancies.

• Developed Python scripts to handle data processing and reporting tasks.

• Collaborated with business teams for requirement gathering and continuous system improvements.

• Extensively used Bulk collection in pl/sql objects for improving the Performance.

• Debugging, fixing bugs reported and working on continuous enhancements.

• Improved the customer experience by optimizing service issue tracking.

Client - Bharat Sanchar Nigam Limited (BSNL) Feb 2017 – March 2019

Role - Pl/Sql Developer

Project - Centralized Web service Portal(CWSC) is a Web based application designed for providing a centralized(for all the zones – North, West, East, South) access to the BSNL web Self-care portal to facilitate customers to change his/her Landline/Broadband plans, view bills, register complaints etc.,

• Analyzed existing WSC system to design a new schema for project database.

• Collaborated with coordinators at BSNL Data Centers across all 4-Zones, to finalize on migration data text formats.

• Designed a new database schema and led the migration of over 1 million BSNL customer records across four zones.

• Developed shell scripts for data validation and Automated data processing system at CWSC by deploying scripts, which runs midnight daily.

• Designed and Developed shell Scripts to identify issues, eliminating data issues through iterative drills.

• Developed Reconciliation Scripts to check for data discrepancies between source systems and CWSC database to ensure data accuracy.

• Developed Jobs to monitor the daily processed data results of all zones via mails and automated them.

• Created PL/SQL Scripts to extract data from operational databases into simple flat text files using UTL_File package.

• Cleansing and validating the error data, reprocessing failed records to ensure data accuracy.

Education :

• Master’s in Embedded Systems, Sridevi Engineering College - Hyderabad, India

• Bachelor’s in Electronics and Communication Engineering, Lords Institute of Engineering and Technology - Hyderabad, India

Contact this candidate