Senior Oracle PL/SQL Developer

BHAGYASRI GANJI

Senior Oracle PL/SQL Developer

Austin, TX +1-407-***-**** *********.*****@*****.*** PROFESSIONAL SUMMARY:

Overall 12+ Years IT proficiency in all phases of software development life cycle (SDLC) including requirement study and analysis, development, integration, maintenance, implementation, testing and delivery of various business applications.

Over 10+ years of development experience in Oracle PL/SQL - stored procedures, functions, triggers, cursors, packages, collections, Pivot, Analytical functions, Complex SQL queries, Dynamic SQL, Data extraction, Oracle Data Pump, SQL Loader, Optimization, Explain plan, performance tuning and exception handling in OLTP and Data Warehouse environments and 2 years in Informatica ETL tool, Cransoft and BODS tools.

Utilized Python to fetch and process data from external sources via REST APIs, automating data integration workflows between upstream systems and Oracle databases.

Hands on proficiency in several business domains including Supply Chain Management, Telecom, Health Insurance and Oil & gas.

Proficiency in writing UNIX Shell scripts for file handling, process control, and SQLPlus execution to automate database tasks and batch operations.

Informatica client tools - Source Analyzer, Mapping designer, Transformations, Informatica Repository Manager, Workflow Manager, Workflow Monitor.

Exposure to various testing methodologies and have good concept of SDLC and Agile methodology for software development.

Excellent analytical and problem-solving skills.

Excellent communication and interpersonal skills with the ability to orchestrate in a team as well as individually.

Educational Details:

Bachelor of Engineering in Electrical & Electronics Engineering from Osmania University, India. Technical Skills:

Operating Systems: UNIX, Linux, Windows.

Version Control: SVN, GIT

Databases: Oracle 9i/10gR2/11g/19c, MS SQL Server 2009/2012,

Languages: SQL, PL/SQL, Python, UNIX Shell Scripts

Batch Scheduling: Autosys workload Automation

Tools: SQL Developer (Oracle 19C), Toad, MS SQL Server 2009/2012, Cransoft (Back office Associates Tool), Crystal Report, HP Quality Center, Data Services, BAAN, Jira, Informatica Power center, SSIS and ODI.

Batch Tools: Unix Shell Scripting and SQL Loader Professional Experience:

Senior PL/SQL Developer Apple Inc, India Jul 2021 – Mar 2025 Project: Commodity Ninja

Type: Development and Enhancement

Description: Internal forecasting platform for Apple accessories, supporting business-critical demand planning. The platform ingests top-level market demand and product master data to generate rolling 8- year forecasts across all Lines of Business.

Responsibilities:

Designed and optimized Oracle 19c/12c database schemas — tables, views, indexes, partitions, and constraints — supporting Apple's business-critical demand planning platform for accessories.

Engineered high-performance PL/SQL packages, stored procedures, functions, and triggers; applied BULK COLLECT, MERGE, WITH clause, Analytical Functions, Dynamic SQL and optimizer hints to deliver significant query performance improvements.

Established a structured SQL code review and unit testing process with line-level traceability of all modified database objects, reducing post-deployment defects and improving team-wide maintainability.

Automated application deployment,

maintenance, and batch operations using Bash/Korn shell scripts, eliminating manual effort on recurring operational tasks.

Implemented secure SOA service communication — authentication, authorization, and message validation — using Python.

Worked within an AutoSys-scheduled batch environment; coordinated with scheduling teams to monitor job dependencies, track execution status, and ensure timely completion of PL/SQL-driven batch workflows.

Managed all database script versioning via GIT; ensured rapid defect-fix turnaround to QA within tight Agile release cycles.

Leveraged Oracle Data Pump and SQL Loader for large-scale data extraction and loading across environments.

Involved with business for effective implementation of the tool. Environment: SQL, PL/SQL, Unix, Python

Senior Consultant British Telecom, India May 2017 – Jul 2020 Project #1: My Service Delivery (MySD)

Type: Development and Enhancement

Description: MySD comprises several linked functionalities; Dashboards, Heat maps, OVQ, Summary view, Notification Centre on its landing page, which will help user to report about order status as well as pre order tracking capability for SQE quotes for Standard offers or Bids handled by the Win Business or Manage Complex Service request processes.

Responsibilities:

Developed and maintained Oracle 12c/19c PL/SQL packages, stored procedures, functions, and triggers for a multi-module telecom order management and pre-order tracking platform serving BT's enterprise customers.

Resolved critical production performance issues through indexing, partitioning, BULK COLLECT, MERGE, and Analytical Functions, significantly improving query throughput on large datasets.

Documented UI module-to-database object mappings, streamlining cross-team debugging and accelerating new developer onboarding.

Handled client ad-hoc data requests and live production debugging independently, identifying root causes in PL/SQL code under tight time constraints.

Prioritized which modules to be developed first based on the user requirements.

Writing data development, SQL code review, preparation of unit test cases, unit test repor*

Leveraged Oracle Data Pump and SQL Loader for large-scale data extraction and loading across environments.

Have very good proficiency in Oracle in controlling very large databases.

At the time of deployment(s), I used to work closely with the DBA team members and make sure once the deployment is successful after validating the application is launching as expected.

Participated in technical architecture design and solution development for enterprise applications, ensuring scalability, performance, and maintainability. Environment: SQL, PL/SQL, Unix

Project #2: Network Management Database System

Type: Development and Enhancement

Description: NMDB is the master database for the BT customers network and device details. It creates networks and commission devices and virtual devices into the networks. It will update this information to upstream and downstream systems like BFG, NIAB, Ontario and IPUB. Responsibilities:

Involved in Understanding the requirement, Timelines and Development.

Responsible for developing and optimizing of SQL Queries, procedures, collections, functions, packages, pivot, Explain plan and performance Tuning.

Developed and maintained PL/SQL packages, stored procedures, functions, triggers, and cursors to implement complex business logic.

Utilized Python and Shell scripting to automate Oracle database operations, including data loads, health checks, and maintenance tasks.

Designed and optimized database objects including tables, views, indexes, sequences, and constraints in Oracle 12c.

Developed application solutions in accordance with Technical and Architecture Specifications and business requirements.

Created tables, view, indexes, DDL, DML Queries etc.

Created mappings and workflows as per requirement.

Analyzing and fixing defects.

Coding the application logic in SQL, PL/SQL as per requirement. Environment: SQL, PL/SQL, Unix

Consultant Capgemini, India Jan 2012 – Jan 2017 Client #1: SWISS RE

Project: CORSO Information integration

Type: Development and Enhancement

Description: As a part of CORSO (Corporate Solutions) Information integration team, we are responsible for integrating information from various CORSO applications that are used by Swiss re and its clients and provide reporting services on top of that. Swiss Re is into the insurance business and thus has several applications to support this. These applications basically contain information regarding policies, claims and submissions for claims. We are an Informatica team, responsible for bringing data from various Swiss Re applications to a single database on top of which the BOXI reports are developed by the BOXI team. Responsibilities:

Development of complex PL/SQL queries, procedures, Functions, Packages, Joins, views, Pivots.

Created tables, view, indexes, DDL, DML Queries etc.

Developed high-performance SQL queries and optimized PL/SQL code using EXPLAIN PLAN, SQL Trace, TKPROF, and Oracle tuning techniques.

Built high-performance PL/SQL solutions leveraging Oracle 12c features for enterprise applications.

Implemented complex business rules and validation logic within PL/SQL modules to ensure data integrity and regulatory compliance.

Developed and maintained Informatica ETL workflows for extracting data from source systems, applying business transformation rules, and loading into target databases.

Designed and scheduled end to end sessions and workflows using workflow Manager.

Experience in preparing and maintaining Technical and Architecture Specifications for enterprise applications.

Understanding the requirements of the client and acting as a sole functional resource and interacting with the client on various forums to discuss the status of the project, get clarification with queries etc.

Analyzing root cause and fixing defects.

Coding the application logic in SQL, PL/SQL as per requirement.

Requirement analysis and transitioning of Knowledge at offshore. Environment: SQL, PL/SQL, Unix, Informatica

Client #2: GE Oil & Gas

Project: GE CAMERON SAP Project

Type: Migration

Description: Extracts the data from Legacy ERP and by applying the transformations, Conversion rules to make sure that the data is in the required format to load it into SAP target using BackOffice Cransoft tool set (Data Garage, Data Dialysis, DSW, Cranport, and EZMap). Responsibilities:

Utilizing BackOffice Data Staging Warehouse™ (DSW), migrated legacy data from multiple legacy source databases into target tables created in SAP.

Helped to create a Dashboard/Scorecard to provide visibility in current standing of project mapping and development.

Extensive experience in Creating Source tables, Target tables, Source rules, Target rules, Views and usage of SQL functions for data extraction cleansing.

Analyzed business requirements and translated them into detailed technical design and architecture documents.

Have worked on SQL queries, joins, and views.

Created Load queries, preload validation reports before loading data into Sap, post Load queries and Delta load queries as well. Have successfully completed multiple mock loads into the SAP system. Environment: Cransoft (DSW, Cranport, EZMap), SQL, PL/SQL Client #3: AON Hewitt, Insurance Company

Project: Absence Management Systems

Type: Development and Enhancement

Description: Absence management system is fully integrated solutions that help a company employee’s absence issues. Specifically, it provides comprehensive Family Medical Leave (FML), Leave of Absence

(LOA), Short-Term Disability (STD) and Long-Term Disability (LTD) claim and case management. It helps customers to minimize the costs, productivity impact, and liabilities associated with all forms of health- related issues. It assists with the management of both paid and unpaid absence. Responsibilities:

Responsible for developing and optimizing SQL Queries, procedures, collections, functions, packages, analytical functions.

Created tables, view, indexes, DDL, DML Queries etc. Created mappings and workflows as per requirement.

Analyzing and fixing defects. Coding the application logic in SQL, T-SQL as per requirement. Environment: MS SQL Server 2009/2012

Contact this candidate