SUMMARY

• Eight Years of Oracle E - Business Suite (11i, R12) experience in configuration enhancements, setups, process design of Distribution and finance modules such as GL, PO, AP, OM, AR, INV, OM & Shipping
• Well versed with AIM Methodology. Created BR100’s, MD050’s & contributed towards MD070 to document configurations Functional and Technical specifications
• Created requirement analysis documents for the Order to Cash and Procure to pay cycles
• Experienced in all aspects of software development life cycle such as performing gap analysis, writing functional specifications, implementing/customizing oracle applications to suit client requirements
• Involved in R12 Purchasing Implementation Projects
• Comprehensive understanding on Order-to-Cash Cycle / Procure-to-Pay Cycle
• Worked with oracle support, using metalink, to resolve issues using knowledge base, SR/TAR
• Worked on PL/SQL in developing the queries and on open interfaces in Inventory
• Worked Effectively on TOAD on 9i and 10g Database
• Worked in Production support and involved in activities like Monitoring, trouble shooting and documentation
• Experienced in Month end closing process for financial periods
• Involved in testing of financial modules functionality as and required during the roll outs
• Worked on adhoc reports to provide the financial data as per business and user needs
• Experienced in designing business processes, documenting standard operating procedures and training business users in these procedures. Also training client users at various levels from clerks through super users.
• Experienced in functional testing, integrated testing, setups, design validation and conducting conference room pilot
• Translate high level business requirements into functional specification documents
• Expertise in development of Oracle Open Interfaces using PL/SQL
• Excellent communication and verbal skills at both User and Management levels
• Lead Offshore team related to testing entire cycle end to end
• Well adverse with SOX compliance process
• Resolve functional issues and/or provide the recommendations where design changes would be the better solution for any issues.
• Technical experience with Design, Development, Implementation, Customization and Production Support of Oracle Applications.
• Expertise in development of Oracle Open Interfaces using PL/SQL, Workflow customizations using 2.6 and Discoverer 10g.

TECHNICAL SKILLS

Testing Tools: Win Runner 7.6, Test Director, Rational Clear CaseRational Clear Quest, Rational Requisite Pro, Rational Test Manager

Other Tools: TOAD, SQL Navigator, Data Load, Oracle Web ADI

ERP Systems: Oracle Applications 11i, R12

Platforms: Windows NT/XP/2000

Languages: C, SQL, PL/SQL

Data Bases: Oracle 8i/9i/10g

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Oracle Order to Cash Functional consultant

Responsibilities:

• Implemented Release 12 Order Management, Shipping, Pricing & Accounts Receivable
• Customized forms to display margins based on base cost in addition to margins based on average cost
• Customized shipping to allow for negative inventory
• Design & lead the conversion for Sales Orders, Customers, Open Invoice and Open Receipts
• Design complex customer structure using TCA hierarchy
• Designed complex pricing rules to derive the price dynamically
• Involved in performing GAP analysis for Order to Cash cycle
• Assisting in BRD (Business requirement documents) for business users
• Responsible for complete test scripts for the end to end solution
• Worked on BR-100 documents for CRP/UAT and PROD for the OM, AR, Shipping & Pricing modules
• Created Pricing Flow, Qualifiers and Qualifiers groups in advanced pricing.
• Conducted CRP and UAT sessions with business users in WAR room
• Lead the cut over activity during CRP, UAT and PROD
• Provided trainings to business users

Confidential, Aurora, IL

Post production support

Responsibilities:

• Provided post production support for financial and supply chain modules (Release 11.5.10) (AP, AR, GL, OM & PO, iExpenses)
• Analyzed existing business process to identify opportunities for enhanced functionality of Oracle
• Streamlined process for inter-company shipments and invoicing
• Implemented credit card integration (AMEX) with Oracle i-Expense module
• Worked on enhancements related to R12 on financial modules and procure to pay cycle.
• Streamlined the purchasing approvals
• Provided support for month end and quarter end closing
• Prepared detailed functional specifications for new/modified extensions, interfaces, reports and conversions.
• Prepared Purchase Invoice Interface Functional Design Specification.
• Analyzed data errors by executing SQL queries using TOAD.
• Worked as Functional Requirements Analyst & Application Tester for Release 12 upgrade project, gathered information from Business Analysts for setting up General Ledger and Payables Modules.
• Coordinated and documented detailed gap analysis between client requirements and Oracle R12 functionality.
• Performed System Administration functionality including end user set up, responsibility definition and menu definition.
• Tracked all client and Oracle Support activity related to Service Request (SR) issues and documented it in the client issue tracking system (Clear Quest) as well as the project implementation logs.
• Documented the complete end-to-end process for all the financial modules
• Incorporated all the business scenarios in CRP demonstration documents for R12.
• Worked as Functional Tester to write test scripts, test cases and test conditions to perform end-to-end testing of the application.
• Worked extensively on production support role, supporting end users and provided solutions to the bugs/enhancements.

Confidential, Chicago, IL

Functional consultant

Responsibilities:

• Analyze existing business systems for the Order to Cash cycle and document ‘AS-IS’ Business processes
• Analyze future process flows mapping business requirements to the functionality provided by Oracle for the following modules - Oracle Order Management, Shipping, Advanced Pricing & Accounts Receivable
• Identify gaps that cannot be accommodated using standard Oracle and suggest alternatives or work-arounds
• Document high-level & detailed specifications for the customizations identified
• Present CRP sessions to the client for user sign off
• Provide training to the core team users
• Model the customer structure/hierarchy using Trading Community Architecture
• Integration of shipping with custom mobile applications built for hand-held devices.
• Develop specifications for complex pricing formulas to be used in Pricing modifiers & Price Lists
• Coordinate with the technical team for conversion of customers, customer item master cross reference, Open Orders in OM & Open Invoices in AR
• Set up and configure Order Management, Shipping & Accounts Receivable modules
• Wrote and modified functional documents for converting data from Legacy to Staging tables and Staging tables to base tables according to business rules and validation using Oracle AIM Methodology.

Confidential, Atlanta, GA

Functional consultant

Responsibilities:

• Reviewed and analyzed the business requirements and functional specification documents.
• Setups meeting with business analysts and developers to clarify the design, flow and functionality of application.
• Defined and managed the resources that are needed to create and work with General ledger, Accounts Payable, Purchase Order, Accounts Receivables
• Matched purchase orders and receive documents for incoming invoices.
• Wrote and execute SQL Queries to retrieve the data from different tables in Inventory, Order Management, and Service Contracts according to scripts, match the data with expected data and actual data.
• Created and checked the order placement form and checked the functionality of order placement process to different vendors using Oracle 11i.
• Created SQL queries to check the information of Vendors, Customers, and Account payable, Account receivable to different vendors and from different customers using TOAD.
• Created and checked the order submission process from different customers for different items and groups.
• Create Manual test cases and test scripts for Transaction receiving process such as Receipts, Returns, Receiving transactions, corrections in transactions and managed shipments.
• Enhanced test scripts defining various checkpoints, synchronization points, Input value, output value, parameterize test.
• Performed Positive testing, Negative testing and Security testing to ensure that security is maintained throughout the on line application for users.
• Performed Data Driven Testing, write SQL queries to test the Data Integrity and Data Validity using TOAD.
• Execute and run test and test scripts, view and analyze the test result and logged defect.
• After fixing the defects/bugs performed retesting on test scripts.

Confidential, Schaumburg, IL

Oracle applications tester (AP, AR & GL)

Responsibilities:

• Created and executed test cases based on high-level and detailed designs documents for Procure to pay process, Invoice approval process for different customers in AP.
• Designed test flow process for the complete regression test bed, participated in requirement and development walkthroughs and reviews using used cases designed in oracle Apps Order management and account receivable modules.
• Wrote and executed test cases and developed /maintained test scripts for both manual and automated testing for Payments made to different customer after claming the insurance amount in Oracle Account Payables.
• Wrote and executed manual and automated test cases and test scripts for payment Invoices to customer, invoice by customer for claim, Quick invoice process, Invoice overview and withhold amount in oracle receivables and invoicing.
• Created and executed test cases for checking Account receivables such as batches, batch summary, Transaction summary, credit transactions & copy transactions.
• Wrote and executed test cases for view and analyzed all the transaction process such as Payment terms, Transaction type, Transaction rules, Agent persons and groups.
• Tracked defects in Test Director, interacted with developers, business analysts and functional testers in resolving the defects.
• Established test data setup criteria for enhancing tester ability to test all scenarios. Also coordinated with test data preparation group for the purpose.
• Wrote and executed queries to retrieve the data from different tables using TOAD.
• Generated views and analyzed the Oracle forms and reports for Account Payables, Account receivables and order management.
• Generated the business Intelligence report based on data requested from different departments like Sales forecast details report, Commission Check stub report, Commission transaction exclusion report, Inventory report by Product line (Policy) and by region and location.
• Divided various functional areas of the application into various Risk Levels for effective testing of the application, also risk leveled all the test cases accordingly.
• Created user defined functions and used library functions for easier maintenance of script.
• Performed Data base Testing and create SQL queries using TOAD and SQL Navigator.