HARISHWAR VEMPATI

Oracle PL/SQL Developer

ad3g5z@r.postjobfree.com +1-856-***-**** https://www.linkedin.com/in/harishwar-v-b6ab35130/

PROFILE SUMMARY

With over six years of dedicated experience as a PL/SQL Developer, I bring a wealth of expertise in Oracle PL/SQL programming and SQL databases. Throughout my career, I have consistently demonstrated a strong aptitude for designing, developing, and optimizing database solutions, particularly within Oracle EBS environments. My journey in software development has honed my ability to craft robust solutions tailored to the unique needs of various industries, including Banking, Healthcare, and Insurance. I am well-prepared to take on dynamic roles in PL/SQL development, leveraging my proven track record and diverse skill set to drive success in challenging projects.

Proficient in Oracle SQL, PL/SQL, and Microsoft SQL Server, T-SQL.

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

Hands-on experience in SQL, PL/SQL, stored procedures, packages, functions, triggers, and SQL Loader.

Developed and maintained custom PL/SQL solutions within Oracle E-Business Suite environment to support various business processes and functionalities.

Extensive experience in writing and optimizing PL/SQL code to enhance performance and meet specific business requirements within Oracle EBS modules.

Collaborated with cross-functional teams to gather requirements, analyze business processes, and translate business needs into technical solutions within Oracle EBS environment.

Implemented data migration and integration projects using PL/SQL scripts to ensure seamless data transfer between Oracle EBS and external systems.

Contributed to the development and maintenance of Oracle EBS reports and interfaces, leveraging PL/SQL to extract, transform, and load data for reporting and analytics purposes.

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

Specialized in building applications connecting with Oracle databases using PL/SQL.

Adept in database design, performance tuning, data validation, and data security.

Collaborative approach, working effectively with cross-functional teams.

Ensures data accuracy, integrity, and compliance with data security regulations.

Active involvement in designing database schema, tables, views, and other objects in Oracle.

Collaborated with DBA for CRUD operations and DDL tasks in Oracle, including schema creation, table management, index maintenance, materialized views, and table partitioning.

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

Created intuitive user interfaces using Oracle Forms to facilitate efficient data entry, validation, and retrieval processes, enhancing user productivity.

Utilized Oracle Reports to generate interactive and printable reports, providing stakeholders with actionable insights into business performance.

Proficient in developing SQL queries for reports, analytics, and data extraction.

Optimizes database performance through fine-tuning SQL queries, indexing strategies, and query execution plans.

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

Experienced SQL Server database developer with expertise in Transact-SQL (T-SQL) and designing data structures.

Proficient in logical and physical database design using Toad Data Modeler and skilled in Unix, writing small shell scripts for process automation and system management.

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

Led the deployment of cloud databases, enhancing scalability to efficiently accommodate varying user demands.

Improved SQL query performance by implementing strategic indexing, resulting in up to a 70% reduction in query execution times.

Played a key role in guiding data migration efforts during a company acquisition, ensuring seamless integration of databases within specified project timelines.

TECHNICAL SKILLS:

Operating Systems

Windows XP/2003/7/8/10, Unix, Linux

Databases

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

Languages

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

Tools and Applications

Oracle EBS, SQL developer, SQL*Plus, SQL Loader, Toad data modeler, WinSCP, PuTTY, Microsoft office 365, Visual Studio, Service-Now, SharePoint 2013, SQL Server management studio,

Oracle Forms, Reports.

PROFESSIONAL EXPERIENCE

Client: Maxim Healthcare Services, FL Feb 2023 – Present

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

My responsibilities included analyzing, designing, coding, debugging, and deploying systems. Collaborated with the team to create database objects like tables and procedures using Oracle tools such as PL/SQL and TOAD. Wrote stored procedures using PL/SQL.

In addition, prepared functional and user documents, process flow diagrams, and flow charts. Developed PL/SQL packages, procedures, and functions based on business requirements.

Wrote complex Oracle SQL queries with various components like Inner/Outer joins, Indexes, Sequences, Union All, Intersect, and Minus set operators.

Troubleshooted performance issues and bugs within anonymous blocks, partitioned DBMS output, and explained plans.

Also worked as an Informatica developer, designing, and developing Informatica mapping for the Extraction, Transformation, and Load process.

Created scripts for database objects like tables, views, and indexes.

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.

Documented the design, development, implementation, daily loads, and process flow of Informatica mappings.

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

I managed and set up the Apache Spark clusters using Amazon EMR (Elastic MapReduce) for large-scale data processing.

Integrated with other AWS services and third-party tools for end-to-end data solutions.

Additionally, provided production support for applications, handled configuration management support for release activities, and created and enhanced Java UDF and Map Reduce jobs for processing data in Hadoop clusters.

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

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, CVS, TOAD, UNIX, AWS Glue, EMR, Amazon Kinesis.

Client: INFOSYS, India Nov 2020 – Aug 2022

Role: PL/SQL Developer

Project Description: As a 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 and Oracle E-Business Suite (EBS) integration, 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.

Facilitated user access to front-end tools after obtaining necessary approvals.

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.

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

Implemented thorough error handling procedures for debugging and maintainability.

Collaborated closely with CMACGM's IT team to analyze business requirements and devise technical solutions that leverage Oracle EBS and PL/SQL to address data management challenges and automate manual processes.

Developed and maintained custom PL/SQL scripts, stored procedures, functions, and triggers within the Oracle EBS environment to automate data processing tasks, optimize database performance, and ensure data integrity.

Integrated Oracle EBS modules with the data management and automation system to facilitate seamless data exchange between CMACGM's internal systems and external partners, improving data accuracy, timeliness, and reliability.

Designed and implemented custom data validation and cleansing routines using PL/SQL to identify and rectify data discrepancies and inconsistencies, ensuring high data quality standards across CMACGM's logistics operations.

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

Conducted rigorous testing and debugging of PL/SQL code to identify and resolve issues, ensuring the stability and reliability of the integrated data management and automation system.

Provided comprehensive technical support and training to CMACGM's IT team on PL/SQL development best practices, Oracle EBS functionalities, and system maintenance, empowering them to effectively manage and enhance the integrated system.

Utilized Toad extensively for Oracle PL/SQL package development.

Deployed code across environments to maintain consistency, updating version control in Clear Case.

Generated test cases for the verification and validation of change requests.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, Oracle EBS, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, UNIX, Shell scripting.

Client: Oriental Insurance, India Oct 2017 – Nov 2020

Role: SQL Server 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, MS SQL, Visual Studio, and SSIS 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.

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

Handled recurring database change requests by utilizing existing templates, ensuring efficiency.

Utilized SQL Server Integration Services (SSIS) packages to automate the extraction, transformation, and loading (ETL) processes, consolidating data from multiple sources into production servers.

Directed programming and documentation development team, offering insight into design process and procedures.

Optimized SQL queries by analyzing query plans generated by the database engine.

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

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

Implemented debugging programs to determine vulnerabilities and issues in software.

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

Environment: Oracle 10g, PL/SQL, java, Oracle EBS, Xml, Visio, UNIX Shell scripts, SQL Developer, SQL *Loader, Import Export, Autosys.

EDUCATION

Master’s in science 3.86/4.00 Cgpa

Rowan University, Glassboro NJ. 2022 - 2023

Bachelor of Technology 8.92/10.0 Cgpa

Hindustan University, Chennai, India.

Contact this candidate