Oracle Developer

Srividya Kambhampati

Phone: 919-***-****

E-mail: *****.***********@*****.***

Career Summary

●OCA certified having 7 years of IT experience in various capacities.

●Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.

●Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.

●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)

●Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.

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

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

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

●Worked with the business functional areas to research and identify the best technical solution to support business processes.

●Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports.

●Experience in designing, developing, testing, performance tuning and supporting database applications using Developer Tools (Reports 6i/10g, Discoverer 4i, XML/BI Publisher), PL/SQL on Windows platforms.

●Proficient in creating technical documentation (MD070, CM040, IQ) to support RICE component.

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

Education and Certifications

●Oracle Certified Associate (OCA)

●Bachelors of Engineering, Aurora’s Engineering College(JNTU University), Hyderabad, India (2003-2007)

Professional Experience

Infosys Limited (Hyderabad,India) Jun ’17 – Jan ’18

Technology Analyst

●Client - Symantec Corporation, Sunnyvale, California

●Role to develop and support incidents based on Oracle Service Contracts

●Development/modification of XML reports based on the client needs

●Development/modification of Oracle reports based on the client needs

●Developed new concurrent program that sends email to the customer when a service contract is created as a result of creation of new/fulfillment/acknowledgment sales order along with the item details as an attachment.

●Developed new concurrent program that sends email to the customer when a service contract is created/fulfilled/acknowledged along with item details as an attachment.

●There were totally 6 concurrent programs created. 3 for service contracts created by default from order management and 3 from service contracts.

●This involved functional setup such as enabling dff, lov, valuesets,profile options.

●Technically, this process included creation of multiple custom tables having multiple column types with CLOB as the datatype, loading data and html content into these tables, creating html files, creating common utility packages and packages that replaces the tags with the dynamic content and finally sending the email to the relevant user.

●Creating/Updating MD070 for new/existing documents.

●Creating ldt commands to download and upload concurrent programs/ DFF’s across instances.

Technologies: Oracle Applications 12.1.2, Oracle Form and Report Builder (10 G),

BI Publisher, SQL, PL/SQL

Hitachi Consulting, Hyderabad, India

Worked at Hitachi Consulting for a period of six years.

Senior Consultant Jan ’11 – Apr ‘13

●Client - Ferring pharmaceuticals, Switzerland

●Role to design and modify new and existing RICE components

●Handling and delegating new development tasks to the team.

●Development / Customization of Oracle Forms based on the requirements

●Development/modification of Discoverer & XML reports based on the client needs

●Preparing AIM documents (MD070, MD120 and CM040)

●Preparing code bundle in tar format that aids in installing the custom components across instances in a systematic manner.

●Resolving incidents/issues that is both functional and technical in nature.

●Created a read only inventory workbench form in R12 that displays all the relevant item details to its lowest granular form. Records will be queried based on item detail level in a find window. Planners need to consult the items stock on real time several times a day, therefore created a consolidated form/view to display the following fields

1. Multi site access

2.Item number

3.lot status

4.sub inventory

5.locator

6.lot on hand

7.lot reserved qty

8.lot available qty

9.lot expiry date

10.lot manufacturing date

11.intransit qty

12.remaining shelf life, etc

●Created a custom package to print labels from Oracle. Labels are defined as stickers printed from thermal printers with barcodes and text fields. Labels are used to identify each pallet or loading unit inside Supply Chain. Labels are then scanned by Radio Frequency mobile devices to perform transactions inside the warehouse. Labels are then printed on thermal printers with a third party tool.

●Created a custom package to delete the pending lot of a product in a batch, when the lots are updated or deleted in the reservations of the items/ingredients of the same batch, which have the lot numbering DFF value set to ‘Y’ in the ingredient of the formula used to create the batch and also, to disable this lot from lot numbers.

●Developed and configured OM commercial invoice report that gets triggered once the sales order is ship confirmed.

●Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report.

●Modified the custom.pll to restrict the update of certain field items on AP Invoice form.

●Created a custom report similar to the standard oracle Scheduled Payment Selection Report with additional details and cosmetic changes.

Technologies: Oracle Applications 12.1.2, Oracle Form and Report Builder (10 G),

Discoverer version 10.1, BI Publisher, SQL, PL/SQL

Consultant Sep ’10 – Dec ‘10

●Roll out project for Ferring Pharmaceuticals, Israel

●Primary point of contact for all incidents

●Manage a small technical team and assign tasks.

●Discuss the requirements with the clients directly and document and provide estimates and plan of action.

●Document MOM (Minutes of meeting).

●Coordinate and delegate with team for AMS issues.

●Resolving Oracle OM and Discrete Manufacturing related issues.

●Develop PL/SQL packages, procedures, functions based on the requirement

●Review the code and check if it adheres to client standards like (naming convention, custom schema, syntax, etc) and raise defects if any.

●Prepare code bundle and check into VSS (virtual safe source)

Technologies: Oracle Applications 11.5.9, SQL, PL/SQL, Discoverer, Oracle Developer 6i.

HRMS Technical Consultant Jun ’10 – Sep ‘10

●Onsite Assignment for IDA, Singapore.

●Gathering requirements from client for various customizations.

●Developing /customizing oracle reports/discoverer.

●Triggering/Creating/customizing mail alerts.

●Preparation of MD070 and MD120 documents.

Technologies: Oracle Applications 11.5.9, SQL, PL/SQL, Discoverer 4i, Oracle Developer 6i.

Consultant Apr ’10 – May ‘10

●2 month role to develop a complex custom form that yields a product in multiple lots as desired in Production Batches.

●Involved in modification of Custom.pll to automate serial lot generation.

●Preparation of ldt scripts for the deployment of the customizations.

● Documentation such as MD070 and IQ Protocol

Technologies: Oracle Applications 12.1.2, Oracle Form Builder 10g, SQL

Associate Consultant Mar ’08- May ‘08

● Development/Modification of Interface programs to upload necessary data for OPM modules (Item cost interface, Operations Interface, Routing Interface, Recipes Interface and Specifications Interface).

●Developed scripts to upload data for PO modules (Sourcing Rules and assignment sets).

●Enhancement of Discoverer reports to suit new operating unit.

●Developed a complex custom form to achieve move immediate functionality for multiple items at one go (FBTG Move Immediate for Multiple Items).

●Development of IQ (Installation Qualification) Document according to Ferring Standards.

Technologies: Oracle Applications 11.5.8, SQL, PL/SQL, Discoverer 4i, Oracle Developer 6i

Associate/Lead Consultant May ’07 – Dec’10

●Providing estimates for the RICE Components.

●Interaction with the client directly for any clarifications or updates over the development work.

●Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.

●Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program.

●Imported data from legacy system into AR using the Auto Invoice Program to create AR Invoices .

●Modification and development of oracle Forms based on the client’s requirements

●Worked on tasks related to OPM, PO, ONT, GL modules.

●Customization and development of existing discoverer / XML reports based on the client’s needs

●Worked on an Oracle Alerts to perform activities based on the requirement

●Worked on OAF to create a new OA Page for the customization of i-Receivables.

●Developed good number of reports on Discoverer/XML and Oracle Reports in various modules like GL/PO/OM/AP/AR.

●Tuned SQL and PL/SQL programs to improve efficiency and utilization.

●Preparing/Modifying DLD’s and IQ’s for the customizations made.

●Preparing ldt commands to move customization across instances for various AOL components.

●Preparation of weekly and monthly reports for project monitoring and maintenance.

Technologies: Oracle Applications 11.5.8, Oracle Developer 6i, Discoverer 4i, SQL, PL/SQL

Contact this candidate