Oracle PL/SQL Developer

HARISHWAR VEMPATI

Oracle PL/SQL Developer

************@*****.*** 856-***-**** https://www.linkedin.com/in/harishwar-v-b6ab35130/

PROFILE SUMMARY

With 6+ years of dedicated experience as Oracle PL/SQL Developer, I bring a strong command of Relational Databases, PL/SQL, Python, Oracle Forms/Reports, and expertise in Performance Tuning. I have consistently demonstrated a strong aptitude for designing, developing, and optimizing data analytics solutions tailored to the unique needs of various industries, including Healthcare, Logistics, and Insurance. My journey in software development has equipped me with the skills to design and implement robust solutions, making me well-suited for dynamic roles in PL/SQL development.

Proficient in Oracle SQL, PL/SQL, PostgreSQL, MS SQL, and T-SQL.

Skilled in managing Oracle database systems, covering versions 10g, 11g, and 12c.

Involved in different project phases, from initiation to deployment, testing, and debugging client-server applications.

Developed comprehensive models for both transactional and analytical systems, including the creation of different designs for optimizing reporting and query performance.

Skilled in capturing business requirements, translating them into logical and physical data models, and ensuring data integrity and normalization across various domains.

Designed a normalized data model which followed normalization principles to ensure data integrity and efficiency by optimizing performance while minimizing redundancy. The normalized schema effectively handled multiple concurrent users, ensuring the accuracy of results in real-time.

Hands-on experience in SQL, PL/SQL, packages, stored procedures, functions, triggers, and adept at optimizing and troubleshooting the code for performance enhancements.

Proficient in working with PL/SQL collections, leveraging their power to efficiently manage and manipulate data sets of varying sizes.

Designed and deployed multiple Oracle Forms applications to maintain employee records, leave management, and payroll processing.

Created and maintained Oracle Reports in RDF and XML format to support business dashboards, including PDF and Excel output generation.

Utilized Forms Personalization and custom triggers to enhance user experience and reduce manual data entry errors.

Applied built-in PL/SQL functions and procedures within Oracle Forms for dynamic data population and cascading LOVs.

Managed Oracle Forms and Reports deployment on Oracle WebLogic Server in coordination with DBA teams.

Performed secure file transfers between development, testing, and production environments using WinSCP for database scripts, configuration files, and data migration tasks.

Leveraged PuTTY and shell scripting to schedule and monitor database migration processes, ensuring minimal downtime during production deployments.

Developed and implemented robust validation rules, data constraints, and consistency checks, reducing data errors.

Expertise in exception management, date and time functions, aggregate functions, and analytical functions.

Customized and optimized auditing triggers specific data security needs, contributing to a more secure database environment.

Experienced in performance tuning, I have consistently identified bottlenecks in systems and provided recommendations to enhance efficiency and scalability.

Proficient in utilizing tools such as Explain, AWR, ADDM, ASH, and other performance tuning utilities to optimize database performance.

Restructured the PL/SQL codebase, resulting in a 30% reduction in application errors and a significant improvement in performance.

Worked closely with front-end developers to implement asynchronous loading, caching, and resource management strategies, reducing UI load times by up to 30%.

Prepared technical specification documents by thoroughly understanding the business requirements, analyzing them, and marking the areas of changes.

Familiarity with GitHub to ensure security, scalability, and continuous integration/continuous deployment (CI/CD) practices within development environments.

Practiced Agile principles and methodologies such as Scrum to iteratively deliver high-quality software solutions in a collaborative and adaptive environment.

Participated in Agile ceremonies including sprint planning, daily stand-ups, sprint reviews, and retrospectives to prioritize tasks, track progress, and identify areas for improvement.

TECHNICAL SKILLS:

Operating Systems

Windows 11 Enterprise, Windows Server 2016/2019, Unix, Linux

Databases

Oracle (versions 10g, 11g, and 12c), SQL Server 2008/2012, MongoDB

Languages

Oracle SQL, PL/SQL, PostgreSQL, MS SQL, Transact-SQL(T-SQL), MongoDB, PySpark, Core Java, Python, XML, JSON, HTML, CSS, Javascript, Shell scripting.

Tools and Applications

Oracle RDBMS, OCI, SQL developer, Oracle EBS, Erwin, SQL*Plus, SQL Loader, Snowflake, VCL, Delphi IDE, WinSCP, PuTTY, Databricks, Oracle APEX, OTBI, ODI, Microsoft office 365, Visual Studio, GIT, JIRA, Service-Now, SharePoint 2013, SQL Server management studio, SSIS, SSRS, SSAS, Control-M, DBMS_SCHEDULER, Oracle Forms and Reports, Oracle Healthcare Data Warehouse (HDW), Power BI, Dell Boomi, AWS.

PROFESSIONAL EXPERIENCE

Client: The Cigna Group, CT Oct 2024 - Present

Role: Oracle PL/SQL Developer

Project Description: As an Oracle PL/SQL Developer at Cigna, I played a critical role in designing, developing, and optimizing database solutions for claims processing, provider networks, financial reconciliation, and health plan data management. The project focused on integrating large-scale Operational Data Stores (ODS) and Data Hubs to ensure seamless data exchange between multiple systems, including claims management platforms, financial systems, and regulatory reporting frameworks.

Responsibilities:

Designed and optimized complex PL/SQL packages, procedures, functions, and triggers for efficient claims processing and reconciliation.

Led the migration and optimization of SQL Server-based claims processing workflows to Oracle, improving query performance and scalability.

Created partitioned tables, materialized views, and indexing strategies, reducing report generation time by 60%.

Developed and maintained PL/SQL procedures for integrating healthcare data from multiple sources into Cigna’s data warehouse.

Worked closely with health plan executives and finance teams to design automated financial reconciliation processes for claims and payments.

Optimized claims adjudication workflows, reducing processing errors and improving overall accuracy.

Developed custom Oracle Forms for policy administration and claim intake, including dynamic LOVs (List of Values) and record group population using PL/SQL.

Designed Oracle Reports for claims history, payment disbursement, and compliance monitoring with conditional formatting and drill-down sections.

Worked with cross-functional teams to migrate legacy insurance data into new forms-based UI screens that adhere to business validation rules.

Customized Forms triggers like WHEN-VALIDATE-ITEM, WHEN-BUTTON-PRESSED, and PRE-UPDATE to implement business logic in claims and policy data entry modules.

Built Python-based fraud detection models for healthcare claims processing, identifying anomalies using statistical analysis and reducing fraudulent claims by 30%.

Designed Python scripts for ETL workflows, extracting patient claims and financial reconciliation data from multiple sources, ensuring compliance with HIPAA and other regulatory requirements.

Developed PL/SQL logic for handling adjustments, reversals, and duplicate claim detection, reducing claim rejections by 25%.

Built and optimized reporting solutions in Power BI, providing executive dashboards for provider network performance and financial analytics.

Designed audit logging mechanisms to track and report changes in patient claims and provider data.

Collaborated with security teams to enhance data encryption and access control policies, protecting sensitive healthcare information.

Implemented automated JSON validation and error-handling mechanisms to maintain data integrity and consistency.

Integrated JSON data with REST APIs to facilitate real-time data exchange between Oracle and external applications.

Worked directly with business analysts, data scientists, and executive leadership to translate business requirements into optimized database solutions.

Provided mentorship and technical guidance to junior database developers, ensuring adherence to best practices in database design and optimization.

Led knowledge-sharing sessions on SQL performance tuning, ETL best practices, and healthcare data interoperability.

Client: Maxim Healthcare Services, FL May 2023 – Sep 2024

Role: Oracle PL/SQL Developer

Project Description: I played a key role in the development and maintenance of a comprehensive healthcare data management and reporting system aimed at optimizing patient care delivery and operational efficiency within a healthcare organization. The project involved designing, implementing, and enhancing custom PL/SQL solutions with Oracle tools to address various data management and reporting requirements specific to the healthcare domain.

Responsibilities:

Gathered requirements from data analysts and architects, and then analyzed them to find a practical solution.

Developed and maintained complex data models using Erwin to support healthcare applications, ensuring accurate representation of patient records, billing information, and clinical data.

Optimized healthcare data models by normalizing database structures, reducing redundancy, and improving query performance in large-scale healthcare databases.

Designed materialized views to refresh patient records daily, ensuring the latest data was available for reporting and analysis. This involved creating scheduled refresh intervals and optimizing the materialized views for fast data retrieval across database environments.

Streamlined data extraction workflows using PL/SQL, optimizing data availability for healthcare reporting systems and enhancing real-time decision-making processes for patient care.

Developed and customized Oracle Forms for managing patient intake, lab order processing, and appointment scheduling integrated with backend PL/SQL packages.

Created Oracle Reports to generate weekly summaries of patient visits, billing activity, and claims processing using data from multiple tables and views.

Modified existing Oracle Forms to include validation triggers and pre-insert logic to ensure data integrity in EHR systems.

Integrated Oracle Forms with HL7 data sources to display incoming lab results in real-time through custom canvases and blocks.

Leveraged PL/SQL expertise to extract, transform, and analyze ERP data, contributing to the optimization of business processes and performance monitoring.

Applied best practices in ERP performance tuning, including SQL tuning, PL/SQL batch job optimization, and schema modifications to improve execution times across high-volume Oracle EBS environments.

Designed and implemented database indexing strategies and optimized table structures, resulting in up to a 40% reduction in execution time for critical business processes.

Collaborated with front-end developers to integrate PL/SQL backend logic into Oracle Forms, ensuring smooth and efficient application operation.

Developed automated billing reports for healthcare providers, pulling data from Oracle databases to generate invoices and payment summaries in PDF and Excel formats.

Created logical and physical data models to support Oracle BI reporting needs, ensuring data accuracy and consistency.

Created PL/SQL procedures and functions to efficiently parse, manipulate, and update JSON data stored in Oracle.

Optimized stored procedures and views accessing JSON data, reducing query execution time by 30-50% through indexing (JSON_EXISTS, JSON_INDEX).

Additionally, wrote PL/SQL database triggers to implement HIPAA rules and analyzed SQL statements, reorganized database objects, and designed indexes to improve query response.

Integrated Oracle databases with AWS S3 to securely store and retrieve large volumes of our healthcare data.

Taken specific measures to ensure that AWS services and configurations are compliant with healthcare regulations and implement appropriate security measures to protect sensitive healthcare data stored in Oracle databases on while migrating to AWS(RDS).

Automated data backup procedures using Shell scripts, ensuring the regular and systematic backup of critical healthcare data, thus enhancing data security and integrity.

Provided on-call support, resolved user issues, and made necessary changes.

Client: INFOSYS Nov 2020 – Aug 2022

Role: Oracle Developer

Project Description: As an Oracle PL/SQL Developer at Infosys, I contributed to the development and implementation of a comprehensive data management and automation system for CMACGM Logistics Company, a leading global logistics and shipping services provider. The project aimed to streamline data processing, enhance operational efficiency, and improve decision-making capabilities within CMACGM's logistics operations. Leveraging my expertise in PL/SQL development, I played a vital role in designing and implementing robust solutions tailored to CMACGM's unique business requirements.

Responsibilities:

Collected change request requirements with the business team, creating comprehensive design documents.

Implemented Oracle RDBMS solutions to streamline inventory management and shipping processes, improving data consistency and real-time tracking.

Performed data modeling and PL/SQL scripting to manage complex logistics data structures, including hierarchical and network data models, for efficient data handling and reporting.

Developed PL/SQL packages for implementing change requests, creating diverse database objects, including tables, views, sequences, stored procedures, functions, packages, cursors, ref cursors, and triggers.

Collaborated closely with CMACGM's shipping business users to understand their reporting needs, developing custom reports and dashboards using PL/SQL and reporting tools integrated with Oracle EBS, delivering actionable insights into shipping operations performance.

Implemented Oracle EBS Order Management (OM) functionalities tailored to optimize cargo order processes, incorporating advanced cargo tracking strategies to streamline cargo handling and management efficiency.

Leveraged Oracle EBS Warehouse Management System (WMS) features such as cargo tracking, handling verification, and shipment tracking to enhance cargo accuracy, minimize handling errors, and elevate customer satisfaction.

Designed and maintained Oracle Forms for inventory transactions, warehouse management, and shipment tracking that interact with PL/SQL APIs.

Developed Oracle Reports to track goods movement, pending shipments, and stock reconciliation across warehouses.

Enhanced performance of Oracle Forms by optimizing data block queries, using control-level triggers, and leveraging PL/SQL libraries.

Created parameterized reports for delivery status and vendor performance, enabling management to make real-time logistics decisions.

Developed PL/SQL scripts to automate inventory and payment reconciliations, enhancing accuracy in financial reporting.

Conducted data analysis to identify inefficiencies in logistics workflows, implementing PL/SQL solutions that optimized payment processes.

Integrated Oracle EBS modules with CMACGM's shipping data management and automation system, facilitating seamless data exchange between internal systems and external partners to enhance data accuracy, timeliness, and reliability within shipping operations.

Prepared Unit test documents like UTP and UTR as part of the development done in such a way that it captures all the scenarios that can get impacted by the changes done.

Developed Unix scripts to automate the extraction and transformation of large datasets from Oracle databases for logistics analytics. The scripts ensured data consistency and accuracy, reducing processing time by 30%.

Prepared migration-related documents when a developed component is successfully tested and is ready to be deployed in the production environment.

Client: Oriental Insurance Company May 2018 – Nov 2020

Role: PL/SQL Developer

Project Title: Oriental Insurance Database Management and Optimization

Project Description: The Oriental Insurance Database Enhancement project was all about making the company’s general Insurance database system work even better. We handled requests to change the database, created templates for those changes, and used tools like SQL Server, PL/SQL, RDBMS, Visual Studio, and Oracle Forms and Reports to get the job done.

Responsibilities:

Reviewed and analyzed database change requests for the General Insurance division.

After approval, created and updated database change templates using Visual Studio.

Designed and implemented a policy management system using SQL, PL/SQL, and Python, allowing insurance agents to create, modify, and retrieve policy information efficiently.

Implemented authorized changes, including tasks like creating, dropping, renaming, and altering database objects such as tables, indexes, and materialized views.

I was responsible for monitoring database performance and storage where I used tools to identify the size of critical tables like policy and claim data tables, ensuring data was efficiently stored and indexed.

Designed and implemented database schemas that supported complex insurance data relationships, such as policyholder information, claim histories, and premium calculations.

Developed SQL-based risk assessment models to evaluate trading risks associated with investment portfolios, derivatives, and financial instruments.

Developed complex queries and views to extract and transform JSON data stored in Oracle tables, ensuring seamless integration with reporting tools.

Contributed to the development of insurance claim processing systems by creating complex DML statements and stored procedures to handle diverse policy scenarios.

Developed PL/SQL scripts to normalize and clean market data for use in trading analytics and decision-making processes.

Automated claims processing workflows using PL/SQL to reduce turnaround times on payments and enhance customer satisfaction.

I also identified tablespace usage and ensured that large datasets, such as claims history, were optimally distributed across storage devices for faster access.

Designed and implemented ETL pipelines using Informatica to move historical and transactional insurance data between systems, ensuring seamless data flow and synchronization for insurance premium calculations and claims processing.

Assisted with deployment of applications in various environments such as development, test, staging, and production.

Collaborated with cross-functional teams to design and deploy Power BI reports and OTBI dashboards in the Insurance domain, facilitating data-driven insights into policyholder demographics, claim patterns, and underwriting risks.

Documented program development and subsequent revisions with comments for easy comprehension.

Gathered and analyzed functional requirements to convert them into technical requirements.

Contact this candidate