Oracle Database Developer

Hiten R. Vaidya

Green Brook, NJ ***** 908-***-**** **************@*****.***

LinkedIn: www.linkedin.com/in/hiten-vaidya

ORACLE DATABASE DEVELOPER

Accomplished Oracle EBS developer with extensive experience in Oracle database development, including writing custom PL/SQL code for creating extracts and custom concurrent programs. Highly experienced in problem-solving and analysis and providing end-user training and support. TECHNICAL SKILLS

Oracle SQL, PL/SQL, Oracle EBS, Performance Tuning (Tkprof, Database Traces, Execution Plans), SQL*Plus (Scripting), SQL*Loader including Import/Export, Java, MySQL,DBArtisan, SQL Developer, Toad, ERWin, Eclipse, IntelliJ, Jdeveloper, Microsoft Office (Excel, Word, Project, Powerpoint, Visio), PVCS, Jira, SharePoint, PostgreSQL Tutorial, Power BI Training EXPERIENCE

Prudential Financial, Newark, NJ August 1999 - July 2020 Systems Manager April 2006 - July 2020

Responsible for developing code for Oracle EBS financials and Oracle databases using PL/SQL as well as SQL.

● Implemented Oracle EBS software platform for domestic and international businesses into a single global instance.

● Defined, implemented and tested configuration and associated functionality in six languages.

● Supported Oracle database upgrades (including financials applications) from 11.5.9 to 12.2.6 (12c) to 19c to provide minimal impact to business processes & end users.

● Supported hardware upgrades, most recently to Exadata technology; upgraded existing shell scripts and oracle objects to take advantage of the new hardware.

● Performed problem identification and collaborated with multiple teams to implement resolution.

● Wrote queries as needed by end users against Oracle tables for GL/AP/FA/AOL as well as custom tables.

● Used analytical tools such as OEM/execution plans/tkprof to analyze performance issues.

● Created many database objects such as stored procedures, packages, package bodies, functions, triggers, tables, indexes, partitioned tables, views, materialized views.

● Created many custom concurrent programs to integrate with Oracle EBS financials.

● Created programs to monitor long running programs as well as programs that finished in error or warning.

● Wrote programs to automatically schedule concurrent programs monthly with different parameters as needed. This saved time for the ops team since this eliminated manually scheduling many programs regularly.

● Created Java programs using web service to notify employees of actions that are required such as approving invoices or expenses.

● Used SQL*Loader and external tables to load data from flat files obtained from various feeder systems into Oracle tables.

● Created and modified Unix/Linux shell scripts according to changing needs of projects.

● Wrote shell scripts to process files to remove junk data from files, zipping/unzipping files and extracting data needed from those files.

● Participated in continuous enhancements and fixing of production/test instance problems/issues.

● Created tables which used partitioning and subpartitioning functionality for quicker data retrieval.

● Utilized preprocessor feature in Oracle databases. This feature enhances the ability to use different types of input files automatically such as processing zipped files.

● Created PL/SQL procedures/packages using dynamic sql and exception handling.

● Created procedures/scripts to extract data from tables and create flat files off that data using UTL_FILE package.

● Utilized Oracle hints and indexes to enable query optimizer to choose optimum query execution plan.

● Used Gather table stats packages to update statistics on tables for quicker data retrieval.

● Created scripts which used row_number over partition by features and ‘With’ statements for better performance.

● Created VPD rules to secure data from being visible to end users.

● Worked on data warehouse projects where data is received from many disparate databases which is then consolidated and loaded into Oracle database for easier retrieval and common view of the data.

● Used Pivot and Unpivot Oracle functions to present data in a more understandable or summarized manner.

● Knowledgeable with middleware processing where feeds/files (for example for employee loads, bank loads and supplier loads, etc.) are received from remote systems. These feeds contain transactional data which require validation and transformation to be processed into Oracle by kicking off appropriate oracle concurrent programs such as journal import, ap import, etc.

● Utilized SDLC methodology for project management.

● Responsible for managing offshore employees.

● Responsible for off hour production/testing support when issues arose. This resulted in problems/issues getting resolved when they occurred instead of waiting until the following day.

● Worked on ETL projects which consolidated data from many sources into one Oracle database.

● Utilized vlookup, hlookup and many other MS Excel functions for data manipulation

● When given Excel files, have taken that data and created insert sql script for loading data into Oracle tables Senior Systems Developer August 1999 - March 2006

Responsible for supporting SmartStream ledger systems.

● Worked on SmartStream ledger system based on Sybase database to process financial data for GL/AP.

● Created/updated database objects such as tables, views, stored procedures, triggers and functions in Sybase database.

● Created/updated Unix shell scripts for incorporating into the ledger systems. Prior Experience

● Wrote programs for the Sybase database to assist in sampling medical and dental claims.

● Created personalized reports using Sybase tables for clients and their personal needs.

● Wrote programs using Gupta software for medical and dental sampling for many large clients.

● Read tapes and imported data into database tables.

● Created reports using Gupta software for clients for analysis. EDUCATION

Oracle University:RDBMS, PL/SQL programming, E-Business Suite: General Ledger, Financial Functional Foundation, Oracle Business Intelligence, Database Administrator New Jersey Institute of Technology, Newark, NJ:Master of Science in Computer Science New Jersey Institute of Technology, Newark, NJ:Bachelor of Science in Computer Science

Contact this candidate