Aparna Rallabhandi

Aparna Rallabhandi
About Me

  631-704-9370(m) • rallabhandi.12@gmail.com


Seeking an opportunity to work in a dynamic environment in the field of Oracle Applications
¨       Professional IT Experience of 4 years in Supply Chain Management Industry
¨       Permanent Resident of United States (Green Card Holder)
¨       Well qualified with Oracle Apps Modules (ver. 11i and R12) – Inventory, Purchasing, Order Management , i-Procurement
¨       Proficient with Mercury Interactive Testing Tools (Quality Center, QTP, Test Director)
¨       Clear understanding of SDLC life cycle and enterprise development models
¨       Comprehensive experience in Oracle Applications as a supply chain functional consultant with good functional and technical skills
MS Office Tools:                 Excel, PowerPoint, Word, MS Access
Languages:                           C, JAVA, PLSQL,SQL, HTML, VBScript
Testing Tools:                      Quality Center, QTP
Oracle Apps Modules:      R12 Inventory, Purchasing, Order Management, i-Procurement, Account Receivables and Account Payables
 Tools:                                   Enterprise Architect, SQL* Loader, TOAD, SQL Navigator
Databases:                           Oracle 11g, Oracle 10g, Oracle 9i
Apr 2010 – Apr 2011, Stamford,CT
Role: Functional Consultant (INV, Purchasing, OM, i-Procurement)
Ø      Gathered requirements from the user and conducted workshops for mapping the requirements to the Oracle Applications systems.
Ø      Planning and estimating the implementation and customizations, interfaces and conversions.
Ø      Prepared Gap analysis document based on the study and preparation of the set up documents ( BR 100) .
Ø      Documented “As Is” current business process ( BP.040) and designed “ TO BE” process ( BP .080)
Ø      Defined chart of accounts, mass allocation, recurring journals, cross validation rules, security rules, calendar, key flex fields, descriptive flex fields,
Ø      Created standard, blanket, contract, plan purchase orders. Approved, automated process in AP in order to move automatically from transaction work bench to payment workbench.
Ø      Defined banks, payment method (check or wire transfers, worked on various invoices , transactions and matching concepts.
Ø      Setup of System Parameters, cleared and unclear transactions in Cash Management.
Ø      Setup Customers, Relationship Terms, Profile Classes and Bank accounts in Account Receivables.
Ø      Setup Auto Accounting, Transaction Schedules, Billing Rules, Quick Cash & Misc, Auto Cash Rules
Ø       Setup PO, Requisitions, Invoice and Expenses Report approvals and notifications
Symantec Corporation
Aug 2008-Jan 2010, Cupertino, CA 
Role: Functional Consultant (INV, Purchasing, OM, i-Procurement)
Ø      Documented As Is and To Be flow design of the R12 Inventory, Purchasing & i-Procurement Modules considering the requirements of the project
Ø      Handled the master data management of items, categories, suppliers, customers
Ø      Mapped the client requirements to Oracle functionalities and configured the applications
Ø      Interacted with the technical team for carrying out the development of Reports and interfaces
Ø      Worked and implemented the required changes for Ordering, Shipping, Receiving and Advanced Pricing business processes
Ø      Created business documents like BR100 for Inventory, PO and OM
Ø      Initiated a documented approach to Project Implementation including:
o        Test Scripts, Standard Operating Procedures and Setup Documents
o        Business Process flow documents
Ø      Resolved Post Implementation issues related to Oracle Inventory, Oracle Purchasing, i-Procurement, and Oracle Order Management Modules
Ø      Improved productivity of the team by creating automated procedures for repetitive tasks on Oracle Purchasing module
Ø      Gap Analysis for automated scenarios
Ø      Communicated effectively to resolve issues during production, development and enhancement phases
Ø      Implemented the approval process within Purchasing according to the management hierarchy
Ø      Developed Test Cases & Test Plans for the Automation scenarios
DB Schenker, Inc., Freeport, NY
Feb 2007 – Feb 2008                                                                                               
DB Schenker, Inc. is a Freight Forwarding company. Involved in the implementation of a Global X-Docking Cargo On-hand System (COS) which is a robust application, providing several solutions for the customers to make the transactions simpler and global. Quality Assurance consulting for the IT team, testing the entire system.
Ø      Conducted User Acceptance Testing, Black Box Testing and System Testing
Ø      Conducted extensive Database testing using SQL navigator and Oracle Database 11g
Ø      Strong understanding of SQL commands and incorporating into QA for validation testing
Ø      Conducted rigorous functional and backend testing on Web Services related application
Ø      Performed validation testing in different environments  understanding the business very well
Ø      Displayed Project Management capability in the process of resolution of defects and coordination with the project members sitting in Germany utilizing HP Quality Center 10.0
Ø      Created Test Cases, Test Logs, Test Reports, Defect graphs and documented the whole system with regards to the COS system
Ø      Created several scenarios using the business knowledge which lead to enhancements in the application

Oracle Projects



Oracle Applications Fusion Cloud - Inventory

Oracle Cloud/Fusion Procurement training will help you develop the fundamental skills required to set up and use the Procurement module. This training covers all the tasks, setups, forms and reports used in Procurement and related modules