Oracle Pl Sql Developer

HARISHWAR VEMPATI

Oracle Developer

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

PROFILE SUMMARY

With over 6 years of dedicated experience as an Oracle Developer, I bring a strong command of Relational Databases, Oracle SQL, PL/SQL, EBS, Database Migration, and expertise in Performance Tuning. I have consistently demonstrated a strong aptitude for designing, developing, and optimizing 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.

In-depth knowledge and hands-on experience with Oracle E-Business Suite (EBS), particularly specializing in modules such as Warehouse Management System (WMS) and Order Management (OM).

Able to configure, customize, and integrate EBS solutions to meet business requirements effectively.

Skilled in implementing data migration and integration projects using Oracle PL/SQL scripts, ensuring seamless data transfer between Oracle EBS and external systems.

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.

I created materialized views that enabled real-time synchronization of data between different databases.

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.

Enhanced ETL processes by developing scripts to extract, transform, and load data between Oracle and PostgreSQL databases, improving data pipeline efficiency by 20%.

Created intuitive user interfaces using Oracle Forms to streamline data entry, validation, and retrieval processes, enhancing user productivity, and improving overall system usability.

Designed intuitive and responsive user interfaces using Oracle APEX components, improving usability and accessibility across various devices.

Extensive experience in integrating Oracle APEX applications with external systems and databases using RESTful web services and APIs.

Utilized the DBMS_SCHEDULER package to automate job scheduling, ensuring regular execution of PL/SQL jobs for data backup, data migration, and system maintenance.

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

Implemented joins and hierarchical queries to fetch and manipulate data efficiently.

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, 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, VCL, Delphi IDE, WinSCP, PuTTY, 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: Senior Database Developer

Project Description: As a Senior Database 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 PostgreSQL procedures for integrating healthcare data from multiple sources into Cigna’s data warehouse.

Implemented CDC (Change Data Capture) strategies to track real-time updates in financial and claims datasets.

Designed and developed Informatica IDMC ETL pipelines to automate data ingestion from JSON, EDI 837/835, HL7, CSV, and XML sources.

Built data transformation logic to map and standardize health plan data, ensuring compliance with regulatory and financial reporting requirements.

Integrated Snowflake-based analytics solutions, optimizing data aggregation and retrieval processes for financial and operational reporting.

Automated data ingestion workflows using Python and AutoSys, improving batch job execution efficiency by 40%.

Led the design and implementation of Azure Synapse-based data models to enhance real-time claims analytics and risk assessment.

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 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.

Implemented data validation and governance controls to ensure compliance with HIPAA, CMS, and SOC2 regulations.

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.

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 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.

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.

Implemented indexing strategies, partitioning techniques, and query optimizations to handle large volumes of healthcare data efficiently.

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.

Played a role in deployment and post-deployment support, created indexes on tables for faster data retrieval, and loaded data using PL/SQL and SQL*Loader, calling UNIX scripts for file manipulation.

Used SQL*Plus to execute dynamic performance queries, enabling quick troubleshooting of slow-running processes and gathering real-time insights into active sessions, blocking locks, and wait events.

Used PuTTY to establish secure SSH connections to Oracle database servers, ensuring smooth execution of database import/export operations and instance migrations.

Handled cross-instance migrations by transferring large Oracle Data Pump (EXPDP/IMPDP) files using WinSCP, optimizing file transfer speeds and ensuring data integrity.

Employed OEM’s performance tuning advisors, including SQL Tuning Advisor and SQL Access Advisor, to suggest and implement optimization strategies, which significantly improved application response times and database throughput.

Managed and scheduled complex batch jobs for patient data transfers between various systems using Control-M, ensuring compliance with healthcare industry regulations.

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).

Utilized AWS CloudWatch and AWS IAM for monitoring database health and ensuring secure access to cloud resources.

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

Experienced in producing detailed Functional and Technical design documents that outline healthcare system architectures, data models, interoperability requirements, and regulatory compliance measures, facilitating effective implementation and maintenance of healthcare IT solutions.

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.

Crafted complex SQL statements, employed Oracle Hints for optimization, and utilized bulk collection for enhanced performance.

Leveraged PL/SQL tuning techniques such as bulk data processing, efficient cursor usage, and exception handling optimization to minimize runtime and resource consumption in high-transaction ERP environments.

Managed complex shipping development projects from inception to production within tight deadlines, receiving recognition for meticulous handling of critical tasks in cargo management.

Implemented validation rules, constraints, and cargo consistency checks to uphold data accuracy and integrity, ensuring compliance with shipping regulations and standards.

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.

Leveraged PL/SQL functions to analyze shipping data and calculate delivery routes, resulting in a 15% decrease in delivery times.

Designed transaction monitoring dashboards using PL/SQL to track performance metrics related to payments, facilitating real-time decision-making.

Designed and deployed shipment tracking reports for logistics operations, enabling real-time updates on order status, delivery timelines, and carrier performance metrics.

Implemented indexing strategies, database partitioning, and query optimizations to improve response times and reduce resource contention.

Conducted in-depth analysis of AWR reports to identify and address performance issues in logistics systems, optimizing SQL queries and database configurations for optimal throughput.

Experienced in conducting performance benchmarking tests and analyzing results to identify performance bottlenecks, validate tuning efforts, and provide actionable recommendations for improving system performance and scalability.

Managed the day-to-day maintenance of Oracle databases supporting logistics applications, ensuring high availability, performance, and data integrity.

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%.

Supported Oracle database upgrades and migrations by managing the transfer of schema definitions, PL/SQL packages, and data dumps securely using WinSCP.

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 Oct 2017 – 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 Java, 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.

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

Utilized SQL queries to calculate Value-at-Risk (VaR), stress testing scenarios, and portfolio risk measures to monitor trading exposures.

This enabled risk-based premium adjustments directly from the application’s interface, enhancing underwriting accuracy.

Migrated policyholder and claims data from Oracle to cloud-based analytics platform, ensuring accurate mapping and transformation of critical business data.

Developed stored procedures to calculate premium adjustments and claim payouts, integrating seamlessly with Oracle-based systems for real-time operations.

Worked closely with business analysts to gather requirements and translate them into technical specifications for SSIS solutions, ensuring alignment with business needs and objectives.

Integrated SQL databases with market data sources, trading platforms, and financial data feeds to capture real-time market data, pricing information, and trading volumes.

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 SSIS 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.

Resolved migration issues by analyzing logs in PuTTY during real-time database migration activities, ensuring error-free transitions between Oracle instances.

Coordinated multi-instance migrations involving Oracle databases by combining WinSCP for file management and PuTTY for command-line operations, streamlining the overall process.

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.

EDUCATION

Master’s of science 3.86/4.00 Cgpa

Rowan University, Glassboro NJ.

Bachelor of Technology 8.92/10.0 Cgpa

Hindustan University, Chennai, India.

Contact this candidate