Oracle PLSQL Developer

Hari Viswanathan

Mobile: +1-732-***-**** E-Mail: ************.*@*****.***

Summary

Highly Proficient with close to 14 years of experience in diversified fields of System Analysis, Application Development, Design, Integration and Testing.

Hands on working experience as Oracle PL/SQL Developer

Experienced in Oracle ERP cycle like, Order to Cash and Procure to Pay and in modules like General Ledger, Account Receivables, Account Payables, Purchase Order, Install Base, Service Agreement and Order Management.

Expert in creating Database objects like Tables, Views, Indexes, Procedures, Packages, Collections, Materialized Views, Partitions, Complex Stored Triggers, and User Defined Functions to facilitate efficient data manipulation and consistent data storage

Experienced in Oracle Forms and Reports

Experience in Query Optimization & Performance Tuning

Experienced in UNIX Shell Scripting.

Experience in loading data from CSV/TXT formats to Oracle through SQL Loader

Debugging and troubleshooting of errors in ETL jobs

Hands on in tools like JIRA, GitHub

Excellent skills in using Client/Server architecture in implementing Oracle based applications

Experience in Waterfall, Agile and Iterative SDLC methodologies

Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing, and Implementation.

An excellent team player with good communication skills and hardworking. Aggressive in acquiring new skills, innovative in programming methodology with excellent debugging skills. Good at client and team interaction and coordination.

Technical Skills

Operating System - Windows, UNIX

Databases - Oracle 11g, SQL and PL/SQL

Oracle ERP - O2C and P2P Cycle

User Interface - Developer Suite 10g (Forms & Reports)

Tools & Utilities - TOAD, SQL Developer, JIRA, GitHub and SVN

Education

Master of Science in Computer Science from Osmania University, India, 2001.

Bachelor of Science in Computer Science from Osmania University, India, 1998.

Professional Experience

Primo Waters North America 12/2022 – till date

Software Engineer, Irving, TX, USA

Primo Water is a leading pure-play water solutions provider in North America and Europe. Primo Water’s revenue model is its industry leading line-up of innovative water dispensers, which are sold through retail locations and online at various price points. Primo Water delivers sustainable hydration solutions and water filtration units across its 21-country footprint direct to customers, whether at home or to businesses. Primo Water is committed to its water stewardship standards and is proud to partner with the International Bottled Water Association (IBWA) in North America as well as with Watercoolers Europe (WE), which ensure strict adherence to safety, quality, sanitation, and regulatory standards for the benefit of consumer protection.

Contributions:

Oracle forms development with PL/SQL coding.

Coding and Development to meet the new business requirements.

Wrote conversion scripts using PLSQL, stored functions, procedures and packages to load data from flat files to oracle tables.

Involved in ETL Development using Oracle SQL*Loader and PLSQL.

Designed and developed ETL processes to extract and load data from multiple sources

Provided troubleshooting support for ETL processes

Partitioned large tables using range partition techniques.

Unit Testing. Supported QA and resolved the defects raised by QA.

Providing Functional and Technical support to Application

Creating new and customizing existing Oracle APIs as per business requirements.

TRACFONE Wireless 06/2020 – 11/2022

Sr. PL/SQL Developer, Hyderabad, India

TracFone Wireless, Inc. (TFWI) is an American prepaid, no-contract mobile phone provider. It operates as a mobile virtual network operator (MVNO), holding agreements with the US largest wireless network operators to provide mobile services. As a part of the FCC (a US government agency) sponsored Affordable Connectivity Program (ACP), Tracfone Wireless now offers a free service plan to customers that qualify for ACP under various Tracfone Brands till the program ends.

Contribution:

Coding and Development to meet the new business requirements.

Used Bulk Collections for easy retrieval of data, by reducing context switch between SQL and PLSQL engine.

Created PLSQL scripts to extract data from tables into flat text, CSV files using UTL_FILE package.

Worked on SQL*Loader to load data into tables

Partitioned tables and created materialized views to enhance the performance

Used Pragma Autonomous transaction to avoid mutating problems in database trigger

Designed monitoring and alerting mechanisms for ETL jobs that reduced critical incidents

Assisted in the standardization of the ETL process which increased repeatability and reduce manual intervention

Unit Testing. Supported QA and resolved the defects raised by QA.

Involved in preparing Quality documents like Defect Status Report and Issue Log etc.

Johnson Controls 02/2012 – 10/2019

Lead PL/SQL Developer, India, USA

Johnson Controls (formerly known as Tyco IS), is a longtime leader in life safety and property protection serving over one million customers across United States and Canada. Delivering industry-leading solutions in buildings and environments where life-safety protection is vital – from schools, universities and hospitals to commercial properties, industrial buildings, and government facilities. Johnson Controls currently has its IT applications running on Oracle Applications Release 12.0.4

Contribution:

Wrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.

Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.

Optimized SQL used in reports to improve performance.

Worked with Business users to gather requirements for developing new Reports or changes in the existing Reports.

Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.

Created Cursors, Collections and DB Triggers.

Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Set up batch and production jobs through Request Sets

Involved in debugging and tuning the PL/SQL code.

Tuned SQL queries using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time, and efficiency.

Canon April 2010 – January 2012

Sr. PL/SQL Developer, Hyderabad, India

Canon is one of the world's leading providers of document management and printing for professionals, high speed digital production printers and wide format printing systems for both technical documentation and color display graphics. Canon is also a foremost supplier of document management outsourcing. Canon currently has its IT applications running on Oracle Applications Release 11.5.8

Contribution:

Designing and preparing technical documents after analyzing functional requirement documents.

Coding and development of packages in packages, procedures, cursors, tables, views and functions as per the business requirements.

Unit Testing.

Supported QA and resolved the defects raised by QA.

Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.

Written complex SQLs using joins, sub queries and correlated sub queries.

Handled errors using system defined exceptions and user defined exceptions.

Creating INDEXES to avoid the need for large-table, full-table scans for fast retrieval of data.

Used Collections for accessing complex data resulted from joining of large number of tables.

CISCO August 2007 – March 2010

Estimate to Quote Conversion, Team Lead/Sr. PL/SQL Developer, Hyderabad, India

The Quoting & Ordering; a CSCC application includes the ability to create, view, validate Quotes and submit it to order. On submission for Order, a Sales Order in generated and booked, the quote is converted to a contract and Invoice is generated successfully.

An estimate is created by the user in SCC 2.0, to get the service price by providing the minimum data what is available with the user. Estimates can be created by internal or external users. This project focuses on converting an estimate to core quote by validating all the data entered by the user.

Contributions:

Wrote Technical Specifications based on business requirements to provide account level financial summary reports to the business customers

Wrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.

Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.

Created Cursors, Collections and DB Triggers.

Involved in debugging and tuning the PL/SQL code.

Unit Testing. Supported QA and resolved the defects raised by QA.

Playing an active role in preparing Quality documents like technical documents, Defect Tracking Form, and Issue Log etc.

Involved in creating INDEXES and performance tuning.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number

of tables.

Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

CISCO February 2007 – July 2007

Nextlinks Product Interface, PL/SQL Developer, Hyderabad, India

CSCC (Cisco Service Contract Centre) Quoting Application uses Nextlink Service to perform an Export Compliance (EC) check on the products of a quote. If a product on the Quote does not exist in Nextlink Database a missing product EC hold is placed on the quote. This increases the Cycle Time of Converting a Quote into Order. To overcome this time latency an extract was developed from C3 to Nextlink to keep the Serviceable Products in sync

Contribution:

Analysis of the specifications provided by the clients

Design and Development.

Created the Table structures.

Coding database manipulations, Stored Procedure changes and creating new stored procedures and functions in Oracle.

Created Cursors, Collections and DB Triggers.

Unit testing. Supported QA and resolved the defects raised by QA.

CISCO September 2006 – January 2007

CIBER B2B 2-Tier web service, PL/SQL Developer, Hyderabad, India

CIBER (Contracts, Installed Base and Entitlement Repository) is an Oracle 11i based application housing all of Cisco’s Service Contracts and installed base. CIBER supports all sales related Service Contract activities including creating, modifying, renewing, and quoting against Service Contracts. It is also the application Cisco uses to manage Cisco’s installed base.

Cisco’s B2B 2-Tier web service (Business to Business) is a service quoting mechanism for its products via a web service. This component is responsible for three processes which include "Creation of a quote", "Renewal of a quote" and "Add uncovered equipment to existing quote" and this web service component can be accessed by CISCO product distributors and resellers by an ERP system or web portal

Contribution:

Wrote Technical Specifications based on business requirements to provide account level financial summary reports to the business customers

Wrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.

Created the Table structures.

Created Cursors, Collections and DB Triggers.

Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching

Unit testing. Supported QA and resolved the defects raised by QA.

Involved in debugging and tuning the PL/SQL code.

CISCO January 2004 – August 2006

QTC-SOM Migration & Support, PL/SQL Developer, Hyderabad, India

Cisco Systems, Inc. is the worldwide Leader in Networking for the Internet. Cisco’s IP networking solutions are the foundation of the Internet and most corporate, education and governments around the world. Cisco provides the broadest line of solutions for transporting data, voice and video within buildings, across campuses or around the world. Cisco has its applications currently running on Oracle Applications Release 11.5.9

The Supply Order Manager (SOM) a part of Order Management (OM). An Interface to Create/Update Sales orders on Manufacturer server for each applicable Customer order created on Customer servers. It Replicate changes from Customer Servers to Manufacturing post order creation, Replication of workflow statuses, Replication of apply/release hold changes from Customer servers to Manufacturing server. Synchronizing holds and shipping information from customer server to manufacturing server and back.

Contribution

Wrote Technical Specifications based on business requirements to provide account level financial summary reports to the business customers

Wrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.

Created Cursors, Collections and DB Triggers.

Involved in debugging and tuning the PL/SQL code.

Unit Testing. Supported QA and resolved the defects raised by QA.

Playing an active role in preparing Quality documents like technical documents, Defect Tracking Form, and Issue Log etc.

Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Contact this candidate