Oracle Apps Techno Functional
Resume:
Karthika Reddy Dubba
*************.*****@*****.***
ROFESSIONAL SUMMARY
P
* ***** ** ********** ** Oracle Applications E Business Suite Consultant and Technical Developer in
Design, Development and Implementation of Oracle Applications R12/11.5.10.2/11.5.8.
Experience in writing/debugging Oracle SQL PL/SQL code i.e. Packages, Stored Procedures,
Functions, Triggers, Cursors, Constraints, Indexes, Views, Materialized Views, Database Links, and
Sequences.
Good knowledge and experience in analysis, design, development, enhancements, customizations,
interfacing and conversions of various modules that includes INV, OM, BOM, PO, AR, AP, GL, WIP,
AOL and CRM Modules.
Experienced in design, developing Data conversion Programs, customizing forms and reports using
PL/SQL, Oracle Internet Development Suite (Forms & Reports 10G/9i/6i), and Oracle Discoverer,
TOAD, XML Publisher.
Strong Technical and Functional knowledge in Customer Relationship Management (CRM)
modules like Field Service, Service Contracts, Service Requests, Depot Repair and Install Base.
Good knowledge and experience in Business flows like Order to cash and procure to pay.
Extensive experience in registering Concurrent Programs, Form Functions, Reports, Applications,
Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration.
Expertise in developing and customizing Forms using Oracle Forms Builder (10g/9i/6i) in Oracle
Applications.
Experience in development of Workflows using Oracle Workflow Builder.
Good understanding and experience in TCA architecture and Sub ledger Accounting (SLA).
Experience in entire phases of Software Development Life Cycle [SDLC] such as Analysis, Process
Engineering, Design, Development, Deployment, Testing, and Support .
Technically proficient in RICE (Reports, Interfaces, Conversions, Enhancements) methodologies.
Experienced in Implementation, version upgrade, support & maintenance projects.
Good knowledge of dependencies and relationships between various application modules with knowledge
of interfaces and API’s.
Involved in Financial conversions, which included data gathering from the client, validation and upload into
Oracle. Standard and Custom Oracle API's were used.
Extensive experience in back end database development using tools SQL*PLUS, TOAD, SQL Navigator.
Has good experience in customizing existing OAF Screens.
Designed functional and technical documents using AIM methodologies (MD50, MD70, CV40, CV70)
Area Expertise
ERP Skills Oracle Applications R12 / 11i [Inventory (INV), Order Management (OM), Bill of
Material (BOM), Purchasing (PO), Accounts Receivables (AR), Accounts
Payables (AP), General Ledger (GL), Work In Process (WIP), Application Object
Library (AOL) and Customer Relationship (CRM) Modules.
Programming Languages C, C++, Java, SQL, PL SQL, JavaScript, Unix Shell Scripting
Web Technologies HTML, XML, JSP, OAF
Data Loading Tools Data Loader
GUI/Tools SQL*LOADER, SQL Developer, PL/SQL Developer, Oracle Workflow Builder,
JDeveloper, Oracle Forms, Oracle Reports, Toad, Discoverer, XML Publisher,
SQL Plus.
RDBMS / DBMS SQL, PL/SQL, Oracle 8i / 9i /10g, SQL Server 2000
Operating Systems Unix, Linux, Windows Vista/XP/NT/2000
Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast paced and team
oriented environment with excellent communication and interpersonal skills.
Worked extensively with oracle support to resolve the issues by creating the SR’s.
Experienced in Implementation, version upgrade, support & maintenance projects.
Ability to learn and adapt to new technologies, good team player in dynamic group work environments and
also self motivated to work independently.
Excellent communication skills, experience in communicating with business users to gather and
understand business requirements.
Skills/Tools Summary
Professional Experience:
Client: Hologic Inc., Bedford, MA Nov 2012 to Aug 2014
Techno Functional Consultant
ole:
R
Hologic Inc. is a leading developer, manufacturer and supplier of premium diagnostic products, medical imaging
systems, and surgical products, with an emphasis on serving the healthcare needs of women throughout the
world. It is a women’s health care company, which is a premier provider of cutting edge technologies enabling
researchers in the life sciences industry to create life saving instruments. Hologic Inc. is operating across various
Operating units such as Bedford, Danbury, Belgium etc. Hologic Inc. mission is to help women everywhere lead
longer, healthier lives. It is their reason for being and the single focus of every breakthrough we pursue, every
solution we design, every investment they make.
Responsibilities:
Worked on the entire lifecycle of the project including Analysis, Design, and Development, Unit Testing,
QA Testing support, transition and post production go live support.
Worked on various conversions to import data (Sales Orders, Invoices, Customers, Inventory, and
Supplier) from the legacy system into Oracle Applications.
Worked on the complete Customer Relationship Management (CRM) modules.
Created MD070 Technical Design Documents for various RICE objects as per RICE components design
and build standards of AIM methodology.
Service Contracts:
• Primarily responsible for Handling tickets/tasks and application support to the end user.
• Worked on Customizing Forms and Reports as per client requirements.
Order Management:
• Developed the interface program to interface sales order data from legacy system to Oracle
Order Management.
• Developed a custom program to cancel the sales orders using OE_ORDER_PUB API.
• Customized Sales Order Acknowledgement Report as per client requirement.
Accounts Payables:
• Involved in setup and customization of ORACLE Payables and developed a code
to interface invoices.
• Developed a custom code for conversion of Vendor and Invoice information from the legacy
system to Oracle Application AP module.
• Configured AP: Setup like Payment Terms, Hold and Release Names, Period Types, Periods, AP
Accounting periods, Financial, and Payable Options, Banks etc.
Worked on Supplier conversion interface, to process the Supplier information from
•
a legacy source to Oracle Applications.
Inventory:
• Worked on the Item import conversion to import Inventory items from the legacy
system into Oracle Applications.
Accounts Receivable:
Worked on Customer Conversion to import Customer data from the legacy
system into Oracle Applications.
Customized AR reports (Print invoice report, invoice aging report).
Converted customer invoice data from legacy system into Oracle Account
Receivables
Developed a custom program to create and apply the receipts against the
open invoices using receipt API.
Oracle Purchasing:
Converted Purchase Orders from existing PO systems into the Oracle Purchasing
•
module
Customized PO Requisition Approval and PO Approval workflows
•
Worked on PO cancelled report for Oracle cancelled POs
•
Customized reports like Printed Purchase Order Report and Printed Requisitions
•
Report using XML Publisher.
Oracle General Ledger:
Developed a custom program to import journals from legacy system into Oracle
•
General Ledger.
Oracle Workflow:
• Customized the RMA workflow to add additional functionality to validate the RMA items before
receiving into warehouse.
• Customized the order line workflow to apply custom holds before the order is booked using Holds
Pub API
Oracle Reports:
• Designed and developed the following custom reports in OM and INV modules as per the client
requirement
• Monthly Sales Report
• Pre Pick List Report
• Orders on Hold Report
• Sales Order Report
Oracle Forms:
• Personalized the Shipping transactions form to disable serial number changes.
Involved in ad hoc querying and reporting using Discoverer.
Experience in customizing applications using OAF.
Preparation of installation document MD120 and technical process/data flow chart.
Worked as a member of Production Support Team to solve the Daily Tickets opened by the
Business Users.
Environment: Oracle 10g, Oracle Applications R12.1.3 (OM, AR, AP, PO, GL, CRM modules,
Inventory), Discoverer 10g, Oracle Workflow Builder 2.6, PL/SQL, SQL, Oracle Reports 10g,
Oracle Forms 10g, SQL*PLUS, UNIX, Windows XP, TOAD.
Client: State Compensation Insurance Fund, SFO, CA Sep 2011 – Nov 2012
Techno Functional Consultant
Role:
State Compensation Insurance Fund is California’s largest provider of workers’ compensation
insurance company. It supports California’s entrepreneurial spirit and plays a stabilizing role in
California’s economy by maintaining an open door policy ensuring all employers have a strong
and stable option for their workers’ compensation needs. This company has been using Oracle
E Business Suite for past few years to operate it's business effectively, and it is currently using
Oracle EBS 12.0.6 version with Financial and HR modules.
Responsibilities:
Developed a custom program for AR interface to validate the invoice data and import it using auto
invoice import program.
Developed a custom program for AP interface to validate the vendor invoice data and import it using
payables open interface import program.
Worked on TCA API’s and developed a custom program to validate and import the customer addresses
from third party system.
Developed a custom program to import budget data into GL using GL Interface program.
Customized the Invoice Print New Invoice report, Print statement report in AR to display the output in PDF
format using BI Publisher.
Customized the Check Print Report Template for R12 as per client requirement.
Developed the following reports of Purchasing module using Discoverer
• PO Requisition Details Report
• Open PO report by buyer
Customized the Printed purchase order report in PO to display the output in PDF format using Bi
publisher as per client requirement.
Strong experience in customizing applications using OAF.
Involved in design, coding, development, documentation and postproduction support.
Worked as a Member of the Production support system to address day to day issues.
•
Involved in preparing technical and functional documentation ( MD70) for Packages, Procedures and
Reports etc.
Worked extensively with oracle support to resolve the issues by creating the SR’s.
Environment: Oracle 10g, Oracle Applications R12 (AR, AP, PO, GL, HR, Inventory), Discoverer 10g, Oracle
Workflow Builder 2.6, PL/SQL, SQL, Oracle Reports 10g, Oracle Forms 10g, SQL*PLUS, UNIX, Windows XP,
TOAD.
Techno
Client: iRobot, Bedford, MA. July 2010 – Sep 2011
Role:
Functional Consultant
iRobot designs and builds some of the world’s most important robots. iRobot’s home robots are revolutionizing the
way people clean. More than 10 million home robots have been sold worldwide, with the award winning iRobot
Roomba floor vacuuming robot leading the charge. iRobot’s combat proven defense and public safety robots
perform multiple missions on the land and in the water. The goal of the project was to upgrade Oracle EBS
11.5.10.2 to R12.
Responsibilities:
Involved in requirements gathering, analysis and development.
The Initial phase was to upgrade the Purchasing, Order Management, Receivables and Account Payable.
Involved in the modification of custom forms for R12 upgrade for MOAC feature of R12.
Designed and developed custom Interface program for Conversion of inventory Items into Oracle
Applications after doing required validations to meet the Business Requirement.
Created Item Templates to be used for defaulting certain attributes while loading Inventory Items.
Developed a Custom All Inventory Value Report using Reports 10g in the Inventory Module.
Customized the AR Module Sales Journal by GL Account Report from Report Version in 11i to XML
Publisher in R12.
Involved in Item categories setup in Oracle application Inventory Module.
Designed and developed a custom code to load AP Invoices from legacy system to Oracle system.
Customized standard oracle Invoice entry Form in AP using Custom.pll as per the Client’s
•
Requirement.
Worked on the conversions for the Service Contracts.
Involved in Unit Testing, integration and System Testing. Worked on bug fixing and enhancements.
Developed a Package to distribute sales quota among the salesreps assigned to specific locations.
Developed a Package to extract the commission payments of a salesreps to be sent to the third party
payroll system.
Used PL/SQL features like PL/SQL tables, Programs for error handling, implicit and explicit cursors for
data processing.
Developed many custom interfaces for sending Email Alerts and Notifications to the email groups using
Custom Packages, Triggers or Oracle Alerts.
Created many views for the Discoverer and also common functions, procedures according to the business
requirements.
Preparation of technical design document MD070, installations document MD120 and technical
process/data flow chart.
Environment: Oracle 10g, Oracle Applications 12.0.0 (OM, AR, AP, PO, GL, Inventory), Discoverer 10g, Oracle
Workflow Builder 2.6, PL/SQL, SQL, Oracle Reports 10g, Oracle Forms 10g, SQL*PLUS, UNIX, Windows XP,
TOAD
Client: Charles River Associates, Boston, MA Aug 2009 July 2010
Role: Techno Functional Consultant
Charles River Associates is a leading global consulting firm that offers economic, financial, and business
management expertise to major law firms, corporations, accounting firms, and governments around the world.
They offer litigation and regulatory support, business strategy and planning, market and demand forecasting,
policy analysis, and risk management consulting.
Responsibilities :
Involved in various activities like preparation of technical documents, discussions with the client regarding
the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user
acceptance testing.
Involved in setup and customization of ORACLE Payables and data conversion from legacy system into
ORACLE Payables.
Importing Vendor and Invoice information into ORACLE Payables using stored procedures and
SQL*Loader.
Involved in Accounts Receivable Invoice Conversion and loading Receipts information from POS system
using Auto Lockbox Transmission.
Designed, developed, registered customized forms, tables and reports using AOL.
Developed customized Reports like aging analysis, Outstanding Invoices, and Customer wise report for
amount that is considered bad debt.
Defined custom shipments document sets and pick release document sets and registered them in AOL.
Create Users and assigning Responsibilities for Security.
Defining New Descriptive flex fields.
Created Value sets and value set values.
Manage Concurrent Processing and Concurrent Manager.
Environment: Oracle Apps 11i (GL, AP, AR, FA, OE, INV, AOL), Oracle Forms 10g, SQL*Loader, Unix.
Client: Siemens, Alpharetta, GA Jun 2008 – Aug 2009
Role:
Techno Functional Consultant
Siemens Water Technologies is a leading global provider of equipment and services. They
provide the most comprehensive, cost effective and reliable treatment systems and services.
They offer everything from emergency water supply and conventional water treatment processes
to wastewater reuse systems, membrane bioreactors, UV disinfection systems and RO cleaning
contracts. These products and services are designed to help keep the city safe.
Responsibilities:
Converted receipts from the legacy system and imported into Oracle applications using the Receiving
Transactions Open Interface.
Customized following reports as per the client’s requirements in Purchasing.
• Printed Purchase Order Report
• Printed Requisitions Report
Customized purchase Order Form as per to customer requirements using custom.pll.
Customized Aging 4 Bucket Report in AR as per the Business needs.
Customized standard Journal Reports in GL as per the client requirement.
Created and designed invoicing for the customers using XML Publisher.
Customized following reports using XML Publisher
• Account Analysis Report
• Consolidation Exception Report for Subsidiary accounts
• Invoice Register Report
• Open Purchase Orders (by Buyer)
• Open Purchase orders by cost center
Open & manage Oracle TARs to resolve implementation issues.
Coordination with the users for their Business, Training and Documentation.
Responsible for providing Post Production support by solving user queries and coordinating the
development of any enhancements as required.
Involved in user training.
Environment: Oracle Applications 11.5.10.2 (OM, AR, AP, PO, GL, Inventory, BOM, WIP), Discoverer 10g, Oracle
Workflow Builder 2.6, PL/SQL, SQL, Oracle Reports 10g, Oracle Forms 10g, SQL*PLUS, UNIX, Windows XP,
TOAD.
Client: ACME Packet, AP, India Mar 2007 – June 2008
Role:
Techno
Functional Consultant
Acme Packet is a Product Development and Applications Services Provider with strong onsite and offshore
capabilities.
Responsibilities:
The Goal of this project is to build a mini ERP that consists of 4 modules (Order to Cash, Procure to Pay,
Demand to Bill, Hire to Retire) in oracle applications.
Involved in writing PL/SQL Triggers, Procedures, Functions, Packages and performance tuning.
Worked as a Developer in building the Order to Cash cycle. Understanding the code and develop the
code accordingly.
Worked as a member of Production Support Team to solve the Daily Tickets opened by the Business
Users.
Generated the extract report for the Price List changes using Reports 6i.
Creation of database links to connect to the other server and Access the required info.
Created database triggers to validate complex integrity.
Created SQL Queries using Toad and scheduling some of the custom Reports.
Import and export of data for development and unit testing of applications.
Developed and enhanced various Business and ad hoc Reports.
•
Environment: Oracle Applications 11.5.8 (OM, AR, AP, PO, GL, Inventory), Discoverer 10g, Oracle Workflow
Builder 2.6, PL/SQL, SQL, Oracle Reports 10g, Oracle Forms 10g, SQL*PLUS, UNIX.
Client: Taconic, AP, India Jun 2006– Mar 2007
Role: Oracle Application Developer
Responsibilities:
Developed programs using PL/SQL and many packages to do the validations as per
requirements.
Extensive usage of PL SQL Collection Types to resolve many performance related issues.
Troubleshooting and fixing the issues while monitoring the batch jobs.
Developed Database Triggers to enforce security.
Run SQL queries and return the results to the requestor.
Prepared design document test scripts for the applications.
Prepared Technical documents for new Enhancements.
Environment: Oracle Database 9i, SQL, PL/SQL, SQL*PLUS
•
EDUCATION
Bachelor of Engineering, Information Technology, Aurora Engineering College INDIA.
MISCELLANEOUS
:
Effective team worker, fast learner and career oriented.
Available immediately.
Contact this candidate