Archana Devi Prabhu

669-***-****

actfof@r.postjobfree.com

EXPERIENCE SUMMARY

Around 7+ years of Oracle ERP experience in IT including Implementation, Testing and Customizations of Oracle Applications

Functional experience in configuration, setup, customization, unit and integration testing of Order Management (OM), Oracle Pricing, Oracle Service Contracts, Oracle Approvals management (AME), Accounts Receivables, Purchasing (PO), Inventory (INV), General Ledger (GL), Accounts Payable(AP) and I-Expense

Extensive experience in the functional aspects of Oracle Applications 11i and Release 12.0

Experience in planning, testing for upgrades, preparation of test plans, test scripts, test cases, training the end users in testing, identification of super users for testing

Good knowledge in requirements study, design and development of Oracle applications

Experience in the preparation of standard operating procedures specific to Client’s business process

Experience in System Administration tasks related to Menus/Functions, Responsibilities, Users and also at workflow levels

Working knowledge with General Ledger, Accounts Receivable, Accounts Payable in the integration point of view

Worked on Production Support, troubleshooting the application and resolving bugs.

Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with business users and lead business projects.

Strong management, administrative and leadership skills to work in a team.

EDUCATION SUMMARY

B.E in Electronics and Communication Engineering, India.

PGDTS-Post Graduate Diploma in Telecom Software Development, India.

Certified in Oracle Database 11g: SQL Fundamentals I

TECHNICAL SKILLS

ERP : Oracle Applications 11i, Release 12.0

Databases : Oracle 8i, 9i, 11g

Languages : SQL, PL/SQL

GUI : Reports 6i

Other tools : Discoverer 4i, XML Publisher, TOAD

Web Technologies : HTML, Java Script, JSP

WORK EXPERIENCE

California BPO Systems, India Oct 2010- Aug 2015

Client: Saba Software Inc CA, USA

Environment: Oracle Applications R12(12.1.3), Oracle 11g, PL/SQL

Saba is a premier provider of learning and talent management solutions that is now leading the transformation of work. Saba enables organizations to transform the way they work by providing a people-centric technology platform that focuses on the continuous development of their people

Extensive experience in Oracle advanced pricing by creating pricing contexts, pricing attributes, pricing formulas and price lists

Responsible for creating the lookups and matching the OM line type with the item group

Worked in Oracle Approvals Management (AME) in setting up the approval process for Service contracts

Responsible for Price list loading for the new items and the new prices for the existing items on a quarterly basis in Oracle Pricing

Support the client in troubleshooting technical and functional issues through Helpdesk portal on an ongoing basis.

Responsible for solving the functional issues in Order Management, Service Contracts, Receivables, Purchasing, I-Expense, Purchasing Requisitions

Data massaging and assigning the templates and pricing methods based on the type of the items in the price list file

New account creation for the new items and creation of new Unit of Measures in General Ledger and Inventory respectively

Creation of Counter templates and counter associations for the Usage items in Install Base Agent user

Defined and assigned the new transaction types in Order Management

Worked on the issues related to hold billing the contract lines by changing the contract status, issues related to invoices stuck in the AR interface

Worked on various workflow issues related to I-Expenses and Purchase Requisition approvals

Responsible for setting up the approval hierarchy and approval limits in Purchasing, GL

Worked on creating customized responsibilities based on Business requirements

Created customized booking holds in Order management level

Developed PL/SQL procedures and functions to validate the data.

Iexpense Descriptive flexfield creation in system Administrator

Worked on the user account creation and assigning responsibilities based on their locations and jobs

Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online- Oracle Metalink

Analyzing user needs, conferring with users to improve procedures and identifying and solving problems

Weekly status reports, Issue Log and plan updates to client

Responsible for preparing the Standard Operating Procedures specific to Saba

Key member of the team involved in upgradation project from 11i to 12i

BPO Systems, CA, USA. Jun 2006 – Sep 2010

Client: Kokusai Semiconductor Equipment Corporation, CA, USA

Environment: Oracle Applications R12(12.1.3),Oracle 11g, PL/SQL, Reports 6i, Discoverer 4i

Kokusai Semiconductor Equipment Corporation is a world leader in the design, manufacture, installation, and maintenance of vertical and horizontal Diffusion and Chemical Vapor Deposition (CVD) systems. Kokusai's is a subsidiary of Hitachi Kokusai Electric Inc. that has operations across Pacific Rim, Europe, and North America, and over 1,500 skilled professionals

Designed and created Database view objects required for the AP and Install Base Discoverer reports.

Worked on Bills of material Interface program to load the data from the staging table to the oracle base tables.

Customized various Oracle reports in INV,OM, and GL:Inventory Tags, Sales Order Acknowledgement, Packing slip, Account Analysis Report.

Responsible for fixing the duplication tax code issues during the upgradation project from 11i to R12

Responsible for creation of new tax rate codes, tax jurisdictions in 12i and fixing the issues that existed in the upgraded taxes

Created Descriptive flex fields for the component information in Bills of Material

Key member of a team involved in User Acceptance Testing of client’s business scenarios during the up gradation process from 11.5.9 to 11.5.10.2.

Designed and developed test cases for testing of General Ledger, Accounts Payable and Accounts Receivable, Order Management, Inventory and Purchasing modules.

Raised several TARs with Oracle for the upgrade from 11.5.9 to 11.5.10.2

Developed XML publisher reports for Sales order Acknowledgement, Packing slip report, Invoice report, Purchase order report

Created business areas and developed reports using Discoverer in AP, PO, OM

BPO Client: Pillar Data, CA, USA.

Environment: Oracle Applications R11i (R11.5.10), Oracle 9i, PL/SQL, Reports 6i, Discoverer 4i.

Pillar data Systems is a leader in application aware storage. Its software management suite eliminates data storage complexity and unnecessary cost, providing appropriate levels of performance to the applications and keep data secure.

eTax Bridge: This provides an automated integrated application of ISPI’s database into Oracle Financials. The database contains sales and use tax rates, descriptions, sales and use tax related codes, dates and zip codes. The tax rates throughout the country are tracked to provide the most accurate data.

Responsible for developing and deploying sales tax interface programs

Customized Sales Tax calculation in OM/ AR.

Wrote interface programs to load and update the database.

Wrote PL/SQL procedures and functions to validate the data.

Performed data massaging using SQL queries.

Performed data export from the delimited text file to extract the sales tax data information using sql loader.

Performed Query and Application performance tuning.

Performed Unit and Integration testing.

BPO Client: Actividentity, CA, USA.

Environment: Oracle Applications R11i (R11.5.10), Oracle 9i, PL/SQL, Reports 6i, Discoverer 4i

ActivIdentity™ Corporation (NASDAQ: ACTI) is a global leader in strong authentication and credential management, providing solutions to confidently establish a person's identity when interacting digitally.

Customized/Developed various reports using Reports 6i in INV, OM: Reports to pull the entered status and backordered status sales orders,

Developed a PL/SQL procedure to update the employee expense accounts.

Provided Technical support for the issues on an ongoing basis

Worked on various issues like inventory items stuck on staging sub-inventory, loading the default bin locators, expense account, AP Aging report.

Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer.

Customized the packing slip report for a single line order with multiple deliveries.

Changed the Set of Books Id for every employee in the HRMS module.

Created users and assigned responsibilities for the users.

BPO Client: Andros Inc., CA, USA.

Environment: Oracle Applications R11i (R11.5.9), Oracle 9i, PL/SQL, Reports 6i, Discoverer 4i

Andros is a scientific instrumentation company and worldwide leader in the development of gas analyzers using DIR and NDIR technology. With Oracle implementation methods they have dramatically reduced the manufacturing cycle, decreased inventory, increased quality and drove down the delivery cycle of new products.

Gathered Reporting Business Requirements and coordinated with users for reports validations and testing.

Worked on Move Order API by loading data into staging table using SQL *Loader. Validated data using PL/SQL by loading into interface tables

Designed and created Database view objects required for the PO and AP Reports.

Performed modifications and enhancements to existing reports per client requirements developed in Reports 6i and Discoverer 4i.

Assisted users in processing the purchase orders and sales orders that were stuck in the workflow process

Created Concurrent program and request sets for various responsibilities to schedule Month end procedures.

BPO Client: CamelBak, CA, USA

Environment: Oracle Applications R11i (R11.5.10), Oracle 9i, PL/SQL, Reports 6i, Discoverer 4i.

Developed XML publisher report for Shippers Letter of Instruction, Purchase order report

Created order header descriptive flexfields, delivery detail descriptive flexfields and value sets

Created concurrent programs, data definition and report templates

Prepared documents and tested the report for different scenarios

Developed AR commission invoice discoverer report

Software Programmer

Subra Systems, Coimbatore, India May 2003-Jun 2004

Project: PC Asset Tracking System for System Manager

Environment: SQL, Oracle 8i, Solaris8, JSP, HTML,

The project is to develop a tracking system for all the assets in the system manager development group.

Depending on the requirement, gathered all the specifications for the assets.

Developed and maintained database for all the assets.

Wrote PL/SQL packages, functions to enhance features in Asset tracking system.

Created HTML pages using JSP to get the parameters.

Performed Unit and Integration testing.

Performed Debugging and error handling.

Performed Query and Application performance tuning.

Prepared documents and involved in QA code reviews.

Software Programmer

Subra Systems, Coimbatore, India Nov 2002-Apr 2003

Project: Implementation of Short message peer-to-peer protocol

Environment: UNIX, C++, and Socket Calls

The Short Message Peer to Peer (SMPP) Protocol is an industry standard protocol designed to provide a flexible data communications interface for transfer of short message data between message center such as SMSC and a SMS application system.

Participated in requirement analysis and technical design.

Implemented SMPP interface between SMSC and ESME using Socket calls over a TCP/IP network.

Developed different stages of connection between ESME and SMSC.

Defined and built different messages (PDUs) to be exchanged for communication using Socket calls.

Software Programmer May 2002-Oct 2002

Subra Systems, Coimbatore, India

Project: Implementation of Internet Protocol and MEGACO in gateway for VoIP application

Environment: UNIX, C, and Socket Calls

Description: Internet Protocol supports a single Ethernet interface. It does not support flow control and fragmentation. It uses ARP for address resolution pertaining to the hardware and is qualified to perform as a host. An abstract interface is provided to layers both above and below the IP layer.

MEGACO is responsible for building and sending the MEGACO messages to the MGC as and when the events are reported by the application above it. The Protocol processes MEGACO messages sent by the MGC and generate the events that will be reported to the application.

Gathered requirements and involved in designing the project based on the specifications.

Implemented Internet Protocol in gateway for Call processing in VoIP

Application.

Generated MEGACO messages using PDUs and sent across the network using socket calls.

Providing Error messages for the undelivered packets.

Contact this candidate