Karthika Reddy Dubba

acf67b@r.postjobfree.com

224-***-****

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