CHANDRA HULIMAVU

adcskw@r.postjobfree.com Phone : 949-***-****

Summary

Over 15+ years of extensive experience as a Sr. Oracle Applications Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications, including 3 years of OBIEE Development and support experience.

Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), Application Object Library (AOL).

Extensive technical and business experience in Procure-to-pay, Order-to-cash and Quote to Cash process.

Proficient in Oracle Applications implementation with PL/SQL, SQL*PLUS, TOAD, SQL Loader, Data Loader, Database Triggers, Procedures, Functions, Oracle Reports 10g/6i Oracle Forms 10g/6i, Discoverer4i/9i/10g, XML/BI Publisher.

Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.

Experience working on SQL*Loader, SQL* Plus, Oracle Import/Export utilities and SQL* Navigator.

Created Data Conversions through Interfaces and APIs and Custom Development using Oracle Applications Coding and GUI Design Standards, Concurrent Manager, Flex Field’s Setup, Integration Testing, Documentation (AIM) etc.

Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)

Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).

Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.

Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Standard Snow Flake schemas (OBIEE).

Experienced in designing interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.

Excellent in team collaboration, adaptation and problem solving with good communication skills.

Provided on-call and day-to-day support as a part of team in 24x7 production environment.

Interaction with the offshore development team for development of reports and changes needed in the requirements.

TECHNICAL SKILLS

Oracle Applications:

Oracle Applications 11i (11.5.9/11.5.10), 11.0.3, 12.1.3

Oracle Application Modules:

Order Management (OM/OE), Oracle Inventory (INV), Oracle Purchasing (PO), Oracle General Ledger (GL), Oracle Payables (AP), Oracle Receivables (AR), Fixed Assets (FA), Oracle Time and Labor (OTL), Project Accounting (PA)

Business Intelligence Tools

OBIEE 11.x, 12.x

ETL Tools

Informatica Power Center 9.x

Data Visualization

Oracle Data Visualization Desktop 12.2.5 (DVD)

Operating Systems:

UNIX, Linux, Windows – 98/NT/2000/XP/7/10

Languages:

SQL, PL/SQL, C, C++, HTML, PHP, FORTRAN, Pascal, SQLJ, Java, JSP, XML Publisher

RDBMS:

Oracle 11g, 10g, 9i, 8i, 8.0, MySQL, SQL Server, MS Access

Oracle Tools:

SQL*Plus, SQL*Loader Utility, Developer (Forms 6i/4.5, Reports 6i/2.5), Workflow Builder 2.6, Oracle Query Builder, Toad, SQL Developer, PL/SQL Developer, SQL Navigator, Discoverer 4i, Import/Export Utility,

Microsoft SQL Server Reporting Services (SSRS)

Methodologies

Software Development Life Cycle (SDLC), Agile methodologies

Version Control Tools:

PVCS, Visual Source Safe (VSS)

WORK EXPERIENCE

Panasonic Avionics Corporation, Lake Forest, CA Oct 2007 – Till Date

Sr. Oracle Applications Developer

Panasonic Avionics Corporation designs, engineers, manufactures, sells and installs customized in-flight entertainment and communications solutions to airlines worldwide including in-flight shopping, phone service, email, video games and GPS flight location display. Panasonic Avionics Corporation is an approved supplier to both Boeing and Airbus. It is a subsidiary of Panasonic Corporation of North America, the principal North American subsidiary of Panasonic Corporation.

Responsibilities:

Created Supplier Sync Interface between Workday and Oracle Payables (AP) using API’s to Create/Update Suppliers (Employees), Supplier Sites and their Bank Accounts.

Created Item Master Interface to import Items and its attributes to multiple Organizations using Item Master API’s and assign Item Categories from DMS (Legacy System) to Oracle.

Created AP Invoices Interface to Import Invoices from Concur System to Oracle Payables (AP). These invoices consist of Employee Travel related expenses - Credit Cards, Cash transactions. (Built a shell script and a control file to get the extract from Concur ftp server to Oracle Server and then load the data into Oracle Staging table. Developed PL/SQL Procedure to validate data in the staging table and import them into Payables Open Interface tables and then to AP tables).

Created an interface using PL/SQL to send out Payments from Oracle Payables back to Concur.

Created Price Lists Interface to create Customer Pricelists and add Item Prices in Pricing module tables using Pricing API’s.

Created Oracle Inter Org Transfer Interface to transfer Inventory from one Org to another using API’s.

Created Custom Tables, Views, Triggers, PL/SQL Packages to support Panasonic home grown Custom Applications like Program Table, PNL Uploader and Parts Pricing applications where the front end is .Net Interface and backend is Oracle.

Created custom PL/SQL API’s to extract and load data from PCube (Legacy) tables to Oracle Custom tables.

Created Bulk Insert and Update scripts to insert/update large volume of data.

Enabled Audit Trial functionality on Order Management and Service Module tables to capture changes that happen on certain Oracle EBS table columns on a day to day basis and created reports to display the changes for business users to review.

Created PO Validation Form to submit PO and generate Sales Orders to meet the business requirements. (PO might be in the form of mail, fax, email etc.)

Worked extensively on Performance Tuning using hints.

Involved in customization of Oracle Sales Online (OSO) Oracle Reports.

Involved in Development and Customization of vast number of SSRS reports based on the requirements from business users.

Worked on FNDLOAD to download and upload concurrent programs, request sets, form functions, request groups etc into a load file in one instance and uploaded them into other instances.

Participated in code reviews, unit test plan reviews, and other quality reviews defined by the system development lifecycle (SDLC). Identified and escalated issues that impacted testing progress.

Environment: Oracle Application 12i, 11.5.9 (OM, INV, PO, AP, AR, GL, Sys Admin, AOL), Oracle 10g, Oracle Forms 6i, Reports 6i, SQL Navigator, TOAD, UNIX, SQL Server Reporting Services (SSRS)

Oracle Business Analytics Developer

Responsibilities:

Conducted Functional Requirements review and walk through with Business users and proposed solutions.

Worked on the whole life cycle of a project from gathering requirements to production deployment.

Created PL/SQL Packages to accommodate complex solutions within the warehouse.

Used Informatica to create mappings to extract, transform and load data from Source tables to Target tables in data warehouse from different sources like Oracle EBS, SQL Server, MySQL etc.

Involved in customizing standard out of the box tables, informatica mappings, RPD repository and dashboards from Oracle as per our business needs.

Involved in troubleshooting data related issues in the warehouse tables.

Modified metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer, created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.

Created BI Publisher reports when live reports were needed as per the business needs.

Created Jobs on Reports and scheduled them on a need by basis to email reports data to users.

Developed test cases and performed Unit Testing and Integration Testing of the dashboards.

Provided guidance and support to end users.

Environment: OBIEE 12.1.3.4, BI Publisher 10.1.3.4, Oracle 11g, SQL Developer, Toad, Informatica 9.x, DAC 11g, Oracle BI Admin Tool 12.2.1.x

Cartus, Danbury, CT Dec 2006 – Sep 2007

Oracle Applications Technical Consultant

Description: The project involved implementation of Financials modules (GL, AP, AR, FA, PA) and Manufacturing modules (OM, PO, INV) using Oracle System Administration and Oracle Application Object Library (AOL).

Responsibilities:

Developed an interface to load historical orders (sales) from legacy system to Oracle OM.

Developed an On-Hand Quantity interface in Oracle Inventory (INV).

Developed AP Invoice interface to import invoices from Legacy system to Oracle AP.

Developed GL Interface to import journal information to Oracle GL from legacy system.

Developed a conversion program to load the data into FA_MASS_ADDITIONS tables and used to prepare and post processes to import data into Oracle Assets.

Developed an Outbound Interface from PA (Project Accounting) to Mainframe to extract Oracle Projects information and send them to Mainframe on a regular basis.

Used PL/SQL packages, procedures and functions for developing the above interfaces.

Created triggers to capture changes in PA tables into a custom table and send them to mainframe.

Developed Bank code mapping form using Forms 6i on a custom table using TEMPLATE.fmb

Used form personalization to change the functionality of standard Oracle Projects form.

Involved in writing UNIX Shell scripts to put and get files to and from Oracle to various other servers by reading the server information through a config file for processing various inbound and outbound interfaces in Oracle Applications.

Perfomance tuning of various SQL queries and PL/SQL Packages.

Used FNDLOAD to download concurrent programs, request sets, form functions, request groups etc into a load file in one instance and uploaded them into another instance.

Several SQL Queries were written to export data from Oracle to other legacy systems.

Used DATA LOAD tool to load lookup data from a spread sheet into Oracle PA lookups.

Few custom reports were developed in each of the modules: AR, AP, PO, INV

oInvalid Customers report.

oInvoices hold report.

oVendor Audit report.

oOn-Hand Quantity report.

Created new users, responsibilities, custom menus, request sets, functions, value sets and request groups.

Identify concurrent programs, request sets, request groups, responsibilities that have violated SOX requirements.

Involved in preparing MD70 documents using AIM methodology.

Environment: Oracle Applications 11.5.10(AP, GL, PO, INV, AR, OM,

Sys Admin, AOL), LINUX, Oracle 10g (SQL, PL/SQL), Forms 6i, Reports 6i, DATA LOAD, SQL Developer, SQL*Loader, PL/SQL Developer, PVCS, VSS

SemGroup, Tulsa, OK Aug 2006 – Nov 2006

Oracle Applications Technical Consultant

Description: The project involved implementation and support of Financials modules (GL, AP, AR) and Supply Chain modules (OM, PO, INV) using Oracle System Administration and Oracle Application Object Library (AOL).

Responsibilities:

Designed and developed GL interface to transfer journal information from legacy system to Oracle GL.

Developed Auto Invoice Interface to import invoices from legacy system to Oracle AR.

Mapped COBRA and OMS data to Oracle Payables and Receivables layout.

Developed an Outbound interface to extract AR transactions from COBRA database to Oracle Receivables.

Developed an Outbound interface to extract AP Invoices and AR Transactions from OMS Database to Oracle Payables and Receivables.

Developed an Inbound interface to import vendors from legacy system to Oracle.

Developed an items interface to import items from legacy system to Oracle INV.

PL/SQL Packages, Procedures and Functions were used for developing the above inbound and outbound interfaces.

Worked on Credit and Debit memo adjustments in OMS Receivables.

Designed and developed an error corrections form using Forms 6i for both Oracle Payables and Receivables interfaces using TEMPLATE.fmb

Used Custom.pll to include zoom functionality in some of the Oracle Application forms.

Customized Order Line Workflow in OM to set discount to preferred customers.

Tuned various SQL Queries to improve performance by using Explain Plan utility.

Support of Cobra Interface from Cobra to Oracle Receivables.

Involved in solving Production support issues on various modules such as GL, PO, INV, AR, AP

Developed a few custom reports in PO, INV, OM

Used System Administration responsibility to create new users, responsibilities, functions, custom menus, request sets and request groups.

Prepared MD70 documents using AIM methodology.

Environment: Oracle Applications 11.5.9 (AR, AP, GL, PO, OM, INV,

Sys Admin, AOL), Oracle 9i (SQL, PL/SQL), AIX, Forms 6i, Reports 6i, Workflow Builder 2.6

El Paso Electric Company, El Paso, TX Apr 2006 – Jul 2006

Oracle Applications Technical Consultant

Description: The project involved implementation and support of Financials modules (GL, AP), Human Resource Modules (HR, OTL) and Supply Chain modules (PO) using Oracle System Administration and Oracle Application Object Library (AOL).

Responsibilities:

Developed AP Invoices Interface to transfer Invoices from Legacy system to Oracle Payables.

Developed an Outbound Timecard interface to extract data for Timecard from Oracle Time and Labor (OTL) to Ceridian.

Developed Time Bank Interface to load extract data of Time bank information from Ceridian to OTL.

Support of employee interface from Ceridian to Oracle HR.

Supported several interfaces between Oracle financial systems and Ceridian HR/Payroll system

Several SQL queries/tables/views were created to export the data to Power plant Cost Repository (Oracle) database.

Developed Time Bank form in Oracle Time and Labor (OTL) using Forms 6i to retrieve the employee hours based on the employee information.

Developed GL Revenue Corrections form.

Developed PO Vendor Audit Reports using Reports 6i to retrieve the Vendor Information.

Environment: Oracle Applications 11.5.9 (AP, GL, HR, OTL, PO, Sys Admin, AOL), Oracle 9i (SQL, PL/SQL), AIX, Forms 6i, Reports 6i, PVCS

EDUCATION

Master of Science - Computer Science Jan 2004 - Dec 2005

Texas State University - San Marcos, TX

Bachelor of Engineering – Computer Science Sep 1997 - Dec 2001

B.T.L. Institute of Technology and Management,

Bangalore University, INDIA

References will be provided upon request.

Contact this candidate