Sql Developer Management System

Sreeja Kotha

Nashville, Tennessee

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

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

Professional Summary

●Oracle PL/SQL Developer with over 6 years of experience in Analysis, Design and implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

●Designed and optimized advanced SQL logic using analytical functions, table partitioning, materialized views with query rewrite, Collections, Table types, Cursors, CTEs, and parallel execution strategies to handle millions of records with high efficiency.

●Automated end-to-end data ingestion and validation pipelines using Python, shell scripting, SQL Loader, crontab, and Control-M, reducing manual intervention and processing time.

●Developed and implemented data loading mechanisms (SQL Loader, Python scripts, Stored Procedures) to ensure seamless data migration and integration with external systems.

●Developed reconciliation scripts to ensure data consistency across systems and integrated validation flows tightly with source-to-target mappings for error-free reporting.

●Implemented high-throughput batch processing with collections, bulk operations (BULK COLLECT/FORALL), and PL/SQL tables to reduce execution time and improve database performance under heavy loads.

●Managed semi-structured data using JSON in Oracle tables, while leveraging Oracle-supplied packages (UTL_FILE, DBMS_SQL, DBMS_JOB, UTL_HTTP, UTL_SMTP) for external integrations and automation.

●Applied performance tuning techniques and SQL hints in production-critical environments to eliminate bottlenecks and accelerate reporting and processing layers.

●Familiar with Informatica PowerCenter for ETL development and reporting support, collaborated on AWS-hosted and on-prem environments with Agile delivery.

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

●Exposure to Jenkins for automating code integration processes, with an understanding of CI/CD pipeline concepts.

●Versioned and managed code in GitLab to ensure seamless collaboration and code tracking.

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)

SAMS is a global audit platform accessed across 40+ countries, used for maintaining audit records, recording issues, and managing action items across various internal banking systems.

Responsibilities:

●Developed and optimized complex audit management features using Oracle 12c, creating robust Packages, Procedures, Triggers, Views, Types, and Functions to meet intricate business requirements, enhancing system reliability and data integrity.

●Optimized performance using BULK COLLECT, FORALL, collections, and pipelined table functions to reduce context switches and speed up query execution.

●Performed advanced query and procedure tuning, including optimization of JSON data access in Oracle tables, to resolve performance bottlenecks and improve execution times of long-running jobs.

●Streamlined and automated data workflows by integrating structured/unstructured sources into SAMS, leveraging shell scripts and Control-M for scheduling and monitoring, which improved system efficiency and reduced manual effort.

●Designed and implemented advanced Python scripts to cleanse, validate, and integrate data from multiple source systems into the SAMS database.

●Worked with AWS cloud-based database environments, contributing to database management, scalability, and performance optimization.

●Conducted unit testing and implemented robust exception handling to ensure quality, reliability, and fault tolerance in high-volume scenarios.

●Improved overall system performance through process automation, significantly reducing manual intervention and operational overhead.

●Collaborated closely with clients, troubleshooting and resolving live environment issues to maintain system uptime, ensuring smooth operations and swift issue resolution in production.

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.

Responsibilities:

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

●Developed and automated scripts to monitor discrepancies in dashboard and metric data, sending real-time email alerts for timely resolution.

●Developed Python scripts utilizing libraries such as pandas and numpy, to handle data processing and reporting tasks.

●Extract, transform, and load data from various sources, including databases and flat files into Oracle databases.

●Developed and implemented data pipelines and ETL processes using Oracle PL/SQL.

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

●Leveraged DBMS_PROFILER for performance tuning of critical PL/SQL procedures, identifying bottlenecks and implementing optimized solutions.

●Extensively used Collections in PL/SQL, along with pipelined table functions, records, and types to improve performance in large-scale data operations.

●Proficient in implementing robust exception handling using RAISE_APPLICATION_ERROR, and SQL%BULK_EXCEPTIONS etc., to ensure data integrity and efficient error resolution during high-volume operations.

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

Role - Pl/Sql Developer

Project – Centralized Web Service Portal (CWSC), A web-based application providing centralized access to BSNL's Self-care portal across all zones (North, South, East, and West). Enabled customers to manage Landline/Broadband plans, view bills, and register complaints through a unified platform.

●Analyzed legacy systems and designed an optimized Oracle 11g schema to support seamless integration of CWSC features and future scalability.

●Collaborated with BSNL data center teams across four zones to standardize data formats for migrating over 1 million customer records.

●Developed shell scripts for validating data integrity and automating data processing tasks, executing nightly to ensure operational efficiency.

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

●Utilized Toad to write, debug, and optimize PL/SQL queries improving execution efficiency and database performance.

●Designed and deployed reconciliation scripts to identify and resolve data discrepancies between source systems and the CWSC database, ensuring data accuracy.

●Automated monitoring tasks by creating scheduled jobs using Control-M, tracking daily processed data and notifying stakeholders of anomalies.

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

●Cleansing and validating 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