Developer Oracle

RESUME OF MANJULA ANANDULA

Cell: 713-***-****

Summary

Over Eighteen (18) years of IT experience in analysis, design, development, upgrade and implementation phases using Oracle Application Tools in multi-user, client-server, open systems, operational and development environment.

Technical Expertise in Interfaces, Conversions, Oracle v7.x/8i/9i, SQL*Loader, PL/SQL, Developer 6i (Forms 6i and Reports 6i), Developer 2000 (Oracle Forms v4.x and Reports v2.x), Discoverer 3i.Involved in customization, implementation and writing interfaces using PL/SQL Packages and procedures

Experience in R12 and 10.5.9.

Fifteen (15) yrs. of experience in PL/SQL,TSQL, Forms and Reports.

Experienced in Oracle customizations software including Nucleus, CorisPlus, Oracle Energy, VMDB and OEIS.

Worked with major clients including Oracle Corporation, NASA, EOTT Energy, Airliquide America Corporation, Dynegy, Unocal, Huntsman Corporation and Universal Weather and Aviation on wide range of Application projects.

Strong technical and communication skills.

Skillset

Hardware: IBM PC/XT/AT and Sun.

O/S: UNIX, MS-Windows, MS-Windows NT, MS-DOS, VMS.

Databases: Oracle v9i, Oracle v8i, Oracle 7.x, Oracle 10G

Tools: Oracle Developer 6i, Developer 2000 (Oracle Forms v 6i/4.5 and Oracle Reports v 6i/2.5/2.0),Oracle Forms and Reports9i, Oracle Forms v4.0, Oracle Reports v2.0, Oracle Discoverer 2000, Integrated GEMMS v3.21.09, Oracle Reports v2.0/2.5, SQL*Forms 3.0, SQL*Plus 3.1, PL/SQL v2.0, SQL Report Writer v1.1, Oracle Graphics, Oracle SOA, Oracle R12 and Oracle Applications 10.5.9, BI publisher reports, XML Gateway

Languages: C, C++,JAVA, ASP .NET, VB.NET

Software: Microsoft Office, Windows 2000.

Professional Experience

Liberty Mutual Jan 2019 – Present

Senior Oracle PL/SQL Developer

Worked on creating PL/SQL packages and procedures for Oracle HRMS/ Payroll.

Built BI Publisher reports and SQL tuned queries.

Worked on Bulk collections extensively.

Boardwalk Pipeline, Houston, TX Jan 2016 – Jun 2018

Senior Oracle PL/SQL Developer

Worked on analyzing the data and creating procedures, triggers and packages and Bulk Collections.

Involved in analyses of existing system written in PL SQL using complex Index structure.

Extensively worked on Performance improvement in SQL, PL SQL code using Explain Plan analysis,Indexes, Hints, DBMS_profiler, SQL_TRACE, and TKPROF.

Highly Organized and personally motivated in building state –of the art softwares.

Worked extensively on Oracle Forms, Reports and PL/SQL

NRG Energy, Houston, TX Jan 2015 – December 2015

Senior Oracle PL/SQL Developer

Good data modelling and Unix experience.

Successfully delivered Design of Schema requirement in database, size, table structures, Processflow through packages, procedures and triggers.

• Extensively involved in preparing Detailed Technical & Functional Documents from the existing code in company standard document guidelines.• Analyzed the data and mapped it with the old system.

Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions

Object oriented programming with PL/SQL - oracle object types.

extensively Unit tested the code and worked with users in their testing and user signoff

Heavy PL/SQL debugging

Centerpoint Energy, Houston, TX Dec 2012 – Jun 2014

Oracle PL/SQL Developer

Worked on analyzing the data and creating procedures, triggers and packages and Bulk Collections.

Involved in analyses of existing system written in PL SQL using complex Index structure.• Extensively worked on Performance improvement in SQL, PL SQL code using Explain Plan analysis,Indexes, Hints, DBMS_profiler, SQL_TRACE, and TKPROF.

Involved in meeting with business people to find out existing business process and its logic tointerpret the code.

Successfully delivered Design of Schema requirement in database, size, table structures, Processflow through packages, procedures and triggers.

• Extensively involved in preparing Detailed Technical & Functional Documents from the existing codein company standard document guidelines.• Analyzed the data and mapped it with the old system.

Created new table structure and new flow of system to achieve resultsCreated complex procedures and packages.

Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions

Object oriented programming with PL/SQL - oracle object types.

used Materialized Views extensively

Unit tested the code and worked with users in their testing and user signoff

Heavy PL/SQL debugging

Expertise in all the phases of System development life Cycle (SDLC)• Writing code for enhancing existing programs or developing new programs.• Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.

Experienced in working with many complex SQL queries with joins, date functions, inline views,cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.

Performance Improvement of PL SQL code and improving memory utilization.

Experience in Back end Testing of the applications by executing complex SQL commands.• Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.

Comfortable in working with a fast-paced, professional development team environment.• Excellent verbal and written communication skills and the ability to interact professionally with adiverse group, including executives, managers, and subject matter experts.

Worked on Complex forms and reports and unit tested them and helped with user acceptance testing and moving to PROD.

Worked on Oracle Quwues, written packages for Enqueue and Dequeue.

Environment:

HP UNIX, PL/SQL, Oracle 10g, Toad

Continental Airlines, Houston, TX Nov 2011 - July 2012

Oracle PL/SQL Developer

Provided full support while batch processing and resolved errors within stipulated time period withoutaffecting business process.

Used TOAD, PL/SQL developer & SQL Developer tools for faster application design anddevelopments.

Designing and Developing Oracle Stored Procedures, Triggers

Worked on Complex forms, reports and PL/SQL packages.

Understanding of and ability to apply Oracle database environment performance tuning principles

Expertise in SQL tuning of large database environments (1+ terabytes

Environment:

HP UNIX, PL/SQL, Oracle 10g, Toad

Geokinetics Inc., Houston, Texas Dec 2010 – Sept 2011

Sr. Oracle Application Developer

Work on reports, Form customizations, ETL Tools including XML Publisher.

Written PL/SQL Stored procedures and packages in R12.

Written complex packages and procedures using pl/sql and toad.

Extensively worked in data warehouse environment architecture and methodology using StarSchema

.Proficient in debugging PL/SQL packages to troubleshoot issues.

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle, Applications R12 (AR, Invoicing, AP, GL ), Oracle v10G, SQL*Plus, PL/SQL Developer, Oracle 9i Forms and Reports, Toad, and XML Publisher.

R12 and experience in GL/AP/AR/PO modules.

MCPS, Woodlands, TX Aug 2010 - Dec 2010

Work on Complex Packages, Procedures and UNIX Scripts.

Designed, Developed and tested Complex Oracle Forms & Reports in Oracle Applications modules

Worked on custom conversions and gl interface.

Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions

Unit tested the code and worked with users in their testing and user signoff

Heavy PL/SQL debugging

Worked on packages forms, Reports.

Experience in Back ends Testing of the applications by executing complex SQL commands.• Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.

Converted SQL Server TSQL statements to Oracle pl/sql procedures and reports.

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle, Applications v 10.2.0.2.0 (AR, Invoicing, AP, GL ), Oracle v10G, SQL*Plus, PL/SQL, R12 and experience in BOM, WIP, INV/GL/AP/AR/PO modules.

National Oilwell Varco, Texas Feb 2008 – June 2010

Sr. Oracle Application Developer

Worked on complex Unix Shell scripting to automate the process.

Write complex PL/SQL Packages and Procedures and tune them in 10g.

Worked on Complex VB.NET Programs..

Worked on customer and AR Interfaces and custom conversions.

Worked with SOA file and ftp adapter.

Unit tested the code and worked with users in their testing and user signoff

Heavy PL/SQL debugging

Experience in Back ends Testing of the applications by executing complex SQL commands.• Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle v10G, SQL*Plus, PL/SQL,MS SQL Server, .VB.NET., XML Gateway,

R12 and experience in BOM, WIP, INV?GL,AP/AR/PO modules.

Universal Weather and Aviation, Clearlake, Texas June 2006 – Jan 2008

Sr. Oracle Developer

Customizations: Implement and Write PL/SQL Packages and Procedures in 10g Environment.

Worked on Complex VB.NET Programs..

Worked on complex Unix Shell scripting to automate the process.

Worked on GL Interface and custom conversions

Work on Complex Packages, Procedures and UNIX Scripts, forms and reports.

Designed, Developed and tested Complex Oracle Forms & Reports in Oracle Applications modules

Worked on custom conversions and gl interface.

Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions

Unit tested the code and worked with users in their testing and user signoff

Heavy PL/SQL debugging

Experience in Back ends Testing of the applications by executing complex SQL commands.• Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus, PL/SQL, VB.NET, Experience in R12 and experience in BOM/WIP/INV/AR/AP/PO/GL and GL modules.

Unocal, Houston, Texas Sept 2005 – June 2006

Sr. Oracle Developer

Customize and Support Oracle Custom Development.

Lead Role in Oracle Customizations.

Have written complex procedures and packages using PL/SQL and tested Complex Oracle Packages.

Work on Complex Packages, Procedures and UNIX Scripts.

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus.

Emergency 911, City of Houston, Texas June 2004 – Aug2005

Sr. Oracle PL/SQL Developer

Designed, Developed and tested Complex Queries and written complex Packages and Procedures. Have Written Reports using MS SQL Server Queries. Maintained SQLServer Database.

Worked on complex Unix Shell scripting to automate the process.

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus, MS SQL Server.

Eagle Global Logistics, Houston, Texas Dec 2003 – May 2004

Sr. Oracle Developer

Customized the standard Mass Adjustments API to allow the option of creating a mass adjustment to a single GL Account code or to the Business Units (BU) and Line of Business (LOB) that exists on the invoice being adjusted.

Customized Oracle Mass Adjustments Form to capture additional invoice selection criteria and reverse adjustments functionality. Updated mass adjustments form to accommodate Globalization.

Mass Adjust Custom Report – Developed the report using Mass Adjust Batch Name field as a selection parameter to allow reporting on all adjustments created within that batch.

Worked on Reports:

Worked on AP Interface ABOB Report, EGL AP Overhead Payables Report, Budget-to-Actual FA Report, and EGL.

Worked on form customizations and few conversions.

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle, Applications v11.5.9 (AR, Invoicing, AP), Oracle v9i (Forms 6i and Reports 6i), SQL*Plus.

Delta Card Services, Houston, Texas June 2003 – Dec 2003

Sr. Oracle Applications Developer

Customize, Support Oracle Custom Development.

Worked on COM objects.

Worked on sql and pl/sql tuning .

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus.

Dynegy Corporation, Houston, Texas Houston, Texas Sept 2001 – May 2003

Oracle Developer/Analyst

Rocket – Back Office Invoicing using Nucleus Software

Developed interfaces for Vertex tax module to AR.

Worked on analyzing the data and creating procedures, triggers and packages and Bulk Collections.

Involved in analyses of existing system written in PL SQL using complex Index structure.• Extensively worked on Performance improvement in SQL, PL SQL code using Explain Plan analysis,Indexes, Hints, DBMS_profiler, SQL_TRACE, and TKPROF.

Involved in meeting with business people to find out existing business process and its logic tointerpret the code.

Successfully delivered Design of Schema requirement in database, size, table structures, Processflow through packages, procedures and triggers.

• Extensively involved in preparing Detailed Technical & Functional Documents from the existing codein company standard document guidelines.• Analyzed the data and mapped it with the old system.

Created new table structure and new flow of system to achieve resultsCreated complex procedures and packages.

Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions

Object oriented programming with PL/SQL - oracle object types.

used Materialized Views extensively

Unit tested the code and worked with users in their testing and user signoff

Heavy PL/SQL debugging

Expertise in all the phases of System development life Cycle (SDLC)• Writing code for enhancing existing programs or developing new programs.• Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.

Experienced in working with many complex SQL queries with joins, date functions, inline views,cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.

Performance Improvement of PL SQL code and improving memory utilization.

Experience in Back end Testing of the applications by executing complex SQL commands.• Successfully collaborated with the Product Management to understand and deliver the right solutionsfor business needs and comfortable working with Offshore team.

Comfortable in working with a fast-paced, professional development team environment.• Excellent verbal and written communication skills and the ability to interact professionally with adiverse group, including executives, managers, and subject matter experts.

Environment:

Windows NT, HP UNIX, PL/SQL, Oracle Financials v11i (AR, AP, Workflow), Oracle v8i, Oracle Developer 6i (Forms 6i and Reports 6i), Oracle Discoverer, Nucleus.

Air Liquide America Corporation, Houston, Texas Sept 1997 – Apr 2000

Programmer/Analyst

Open Interface: Have written open interface procedures and packages to post customized CORISPlus Inventory, Customer and Invoicing data to Oracle Finapps tables in PL/SQL v2.0, Developer 2000 and Oracle Financials v10.7 SC environment.

Inventory: Customized Inventory Interface package to process Back Orders, Direct Billings, and Transfers, Cancel Orders and Billing Adjustments. Involved in implementing Alchem Lot Inventory and posting CorisLite custom orders to Oracle Inventory using PL/SQLv2.3, Developer 2000 and Oracle Financials 10.7 SC.

Invoicing: Made changes to the Invoicing package to assign cost ccid, A/R ccid, revenue ccid and tax ccid to process group invoicing, International sales, specialty gas cylinders, Healthcare and Govt.-Healthcare categories using PL/SQL v2.3.

Involved in adding Descriptive Flexfields to forms, customizing reports and registering Bin Scripts using Developer 2000.

Globalization of CORISplus Reports: The objective of Globalization project was to upgrade CORISplus application to support Air Liquide global operations – Generated new reports or modified existing reports to provide implementation flexibility, provision for multi-currency, multi-taxes, national language Support, multi-language support, international addresses, date formats and multi-org capabilities using Reportsv2.5.

Team member in preparing specifications and documentation for Inventory, Customer, Invoicing and Interface modules.

Provided technical support and trouble shooting for month-end closings for AR and Invoicing modules.

Environment:

Windows NT, Digital Unix, PL/SQL v2.3, Oracle v7.3, Developer 2000 (Forms 4.5 and Reports 2.5), Oracle Discoverer, AOL v7.5.7.

EOTT Energy Corporation, Houston, TX Feb 1997 – Aug 1997

Oracle Energy

Worked on PL/SQL procedures and packages, Interfaces, Oracle Forms, Reports and Discoverer 2000

Environment:

HP-Unix, Windows NT, Developer 2000, Discoverer 2000, Forms 3.0/4.5, Reports 2.0/2.5, Server-K460.

Huntsman Corporation, Houston, TX Oct 1996 – Jan 1997

Oracle Developer

Project: Financials Information & Management System

Involved in the customized development and testing of Oracle Financials Reports by interacting with end using Developer 2000, Discoverer 2000 (Oracle Browser v2.0), Integrated Gemms v3.21.09 and Oracle Financials v10.5.

Environment:

Novell NetWare, HP-UNIX, Developer 2000, Discoverer 2000 (Oracle Browser v2.0), Oracle Financials v10.5, Integrated Gemms v3.21.09.

NASA, Houston, TX June 1996 – Sept 1996

Oracle Developer

Project: Vehicle Master Database (VMDB)

Involved in the development and testing of Vehicle Master Database (VMDB). This system provides tools for the management of ISS (International Space Station engineering data for NASA. The VMDB Architecture consists of Networked Work Stations (Mac, PCs and UNIX) using World Wide Web and X-Windows application to access an Application Server. Was responsible for the development of Complex Database Procedures, Functions and Packages.

Environment:

UNIX, Sun, Oracle v7.1, Oracle Forms v4.0, Oracle Reports v2.0.

ORACLE CORPORATION, Houston, TX Aug 1995 – May 1996

Oracle Developer

Project: Oracle Environmental Information System

Involved in the development and testing of Oracle Environmental Information System (O.E.I.S) project being developed by Oracle Corporation for 13 major clients. These systems keep track of environmental information such as pollution, regulatory criteria, permitting, and health 7 safety and clean up. The system consists of various functional modules like air, water, permit, regulations, remediation, etc.

Responsible of the development of two modules using Forms v4.5. Developed several forms using complex master detail relationships. Used special features like minor items and has written PL/SQL procedures, packages, functions and event triggers. Developed reports using Reports v2.5 to the Client requirements. Also responsible for testing and QA/QC.

Environment:

MS-Windows, NT, Sun, Oracle V7.1, Oracle Forms V4.5, and Oracle Reports V2.5.

Education

B. S. Engineering, 1994

Contact this candidate