PROFESSIONAL SUMMARY:

• 14+ years of Hands - on Functional Experience including over 5+ years of Leadership and Management Experience in Oracle Apps 11i & R12
• 4+ years of Audit Domain Experience on Tax Audit, Statutory Audit & Internal Audit
• Implementation and Support of various financial modules including General Ledger, Payables, Receivables, Cash Management, Fixed Assets, E-Business Tax, Purchasing, Inventory, TCA, iSupplier and iExpense
• Comprehensive knowledge of SDLC (System Development Life Cycle), Agile Programming practices and Implementation Road Maps
• Excellent configuration experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi-Org.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing,, Cut off, Go-live and Post-Implementation Support.
• Conducted requirements gathering workshops, prepared AS-IS(BP-040),TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP,SIT, UAT sessions and user sessions.
• Trained the client’s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.
• Proficient working with Oracle Support, creating and following up on SRs. Coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports
• Experience testing Conversions, Interfaces, Data Migration, RICE customizations.
• Good Team player and leading key business scenarios meetings with coordinating and getting signoff from business for the proposed business scenarios.
• Worked in Onsite and Offshore model projects, coordinating and leading offshore team
• Prepared Test cases TE-020,030,040 for various Financials modules.
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.
• Good working knowledge of SOA (Service Oriented Architecture)
• Experience interacting and driving internal product teams, the user community, IT Operations and Executives; Experience with Functional Teams with a Strong focus on Group dynamics
• Experience with round-trip business methods using Function-point and Use Case estimation methods using well-defined workflow (Project and Initiatives proposal presentation techniques)

AREAS OF EXPERTISE:

• Oracle EBS 11i & R12 Functional on AP, AR, GL, CM, OM, AR & FA, iExpenses & iProcurement, Oracle Configurator and Install Base and Service Contracts
• Oracle EBS Testing on Regression, Integration & System & UAT Testing
• Oracle iSetup
• Project Management / Team Lead
• Client Management
• Business Process Design / Re-design
• Project Budgeting and Planning
• Project Risk and Scope
• End User
• Management of Offshore & Onsite Resources

PROFESSIONAL EXPERIENCE:

Confidential, Anchorage, Alaska

Senior Oracle Solutions Architect

Responsibilities:

• End to end Implementation of Oracle Payables, Payments, and Receivables, Order Management, Advanced Pricing and Ecommerce gateway.
• Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP’s related to the split scenario and post production data cleansing.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Prepared BR100 Application setup for Payables, Receivables, Order Management, Payments and Ecommerce Gateway.
• Created accounting flex field segment values, creating new / updating the existing cross validation rules and security rule
• Involved in requirement gathering and authored MD 50 documents for the various reports and Interfaces which includes AR Invoice and AP invoice Interface.
• Designed, documented and implemented Interface programs to import ITEMS from a legacy system into Oracle Inventory.
• Documented current state, designed future state to automate treasury functions including cash position, daily investing, cash forecasting, cash general ledger entries and debt facility accruals.
• Configured the Cash management module for GL Accounts Mapping, setting up transaction codes, BAI2 file upload, Customization of out file as per Bank of America requirements, automatic transmission and import of bank files.
• Configured banks, bank accounts and documents for different needs like AP processing.
• Designed and authored functional specifications for many OM reports like Pick Slip, Packing Slip, and Mailing Label for Shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports.
• Coordinating with Offshore development and Functional Team to resolve Issues.
• Worked on AP/AR Netting, ERS Transactions Setups and related Issues.
• Designed and implemented Back to Back Sales Order Process, integrating with Purchasing and customizing various forms and interface process as per business requirement.
• Designed and configured Custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once the PO is created for a Back to Back process.
• Configured Pricelists, Modifiers and Qualifiers in Advanced Pricing for complex pricing system of the client.
• Involved in configuration of CRP2, SIT1, SIT2 and test instance.
• Prepared TE040 Documents, which are used to test various aspects of application functionality.
• Involved in defect fixing of custom workflows like OM export compliance, Return Merchandise notification and credit management.

Confidential, San Diego, California

Sr. Oracle Business Analyst

Responsibilities:

• Involved in the Up-gradation of the Application for all financial modules like GL, AP, AR, FA, CM, Purchasing and the Self-Service Modules Like iExpenses, iSupplier.
• Prepared and updated CV40, BR100 documents and created MD 50 Functional Design documents according to AIM.
• Designed and created new CHART OF ACCOUNTS and set of books.
• Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Implemented EB-tax integration for Procure to Pay and Order to Cash cycles with One-Source Indirect Tax product line.
• Extensively worked on Oracle Sub Ledger accounting to analyze and gather information from Payables into GL and reverting back from GL Journal Entries to grab Payables Invoice and Payment Details through XLA.
• Designed various Quarter and Year end reports for Higher Management review in like Top Ten vendor payments, Overall Payments history, Employee and Tax Payments etc.,
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Created users and modified the privileges for users, rollup group and summary accounts.
• Created suspense accounts for automatic balancing journal entries from particular sources and categories.
• Set-up supplier and supplier sites for suppliers in payables.
• Set up banks, receipts, transactions, plus for invoicing, receipts, adjustments, and period close.
• Involved in setting up Project resources and roles to the project, Jobs and organizations for project Organizations, creating and maintaining Project budgets and worked on PA costing Import Process as part of project costing and billing.
• Conducted orientation, CRP, UAT and Rollouts strategies for System up gradation.
• Provided production support for day to day business issues and worked on SRs with Oracle.

Confidential, Valparaiso, Indiana

Sr. Oracle Lead

Responsibilities:

• Worked with R12 implementation team, gathering requirements and authoring business requirement documents and functional specifications.
• Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depriciation methods, security profile, asset calender, fiscal year, quick codes and system controls.
• Worked on setting up of accounting method builder (AMB) for Financial accounting hub for various pass through Journal applications.
• Designed and developed multiple FSG reports on Budget and Actual balances, crossing over fiscal periods as per Business requirement.
• Extensively registered various AOL objects such as Value Sets, Value Set values, Custom Responsibilities, Lookup Values, Request Sets, and Request Set Links.
• Designed and Developed customized solution for Oracle Fixed Assets to resolve depreciation issues.
• Supported Procure to pay and FA issues during month end performing additional configurations.
• Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
• Involved in the analysis and design phases of various iProcurement initiatives. Configured external punch outs and OSN.
• Configured iSupplier for supplier centralization and online invoice processing.
• Liasoned between the technical staff and the users (staff and management). Was also responsible for interdepartmental coordination between the various teams involved.
• During the Support phase, Applied various Recommended patch Collections (RPCs), for AP, Suppliers, Workflows and Cash management. Analyzed and applied various GDFs in payables and applied RCA patches to fix the issues permanently.
• Designed, tested and delivered various custom reports as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Allocation of labor, Timeliness of Payments, Rejected Invoices register, etc.,
• Participated in user testing and helped in migration to production for BAU activities.
• Provided extensive production support of Oracle financials, including following up SR’s with Oracle Meta link.

Confidential, Chicago, Illinois

Sr. Oracle Lead

Responsibilities:

• As a Lead and Project Manager leading from Client IT Finance Business Side on implementing the R12 Oracle Financial Modules on GL, FA & AR & AP & Fixed Assets & iExpenses& OM and Oracle Configurator & Install Base
• Guiding the Finance Business Users on their testing in R12 on CRP2 & CRP3 Sessions and SIT2 Conversion Phases
• Gathering new business requirement on Functional & Technical Enhancements
• Incident Management on JIRA Tickets raised on CRP2 & CRP3 Sessions and new enhancements both Major & Minor

Confidential, Chicago, Illinois

Lead and Project Manager

Responsibilities:

• Setting up Application for iExpenses and defining workflow process for the new Orgs
• Setting up Application for Purchasing and Approval, Security and Control and Creating Requisition, Purchase Order and Receiving
• Setting up Application for Accounts Payable with Credit Card Integration
• Interact directly with business users to assess Incident, Break Fix, Enhancements
• Prepare Functional Design document and Estimate Development & Migration time
• Co-ordination with Offshore Technical Team
• Feedback on Incident Review Meetings
• Client Interactions and Meetings on Status Reporting and Enhancement Request
• Offshore Functional Team Management on Incidents, Break Fix & Change Request
• Development and Supporting Offshore Testing Team on development of Test Scripts for Test Execution
• Meeting of business requirements on upgrade to Release 12

Confidential, NJ

Lead for the Oracle E-Business suite Implementation

Responsibilities:

• Preparation of Project Plan and Sign off from Senior Management and Client Management
• Offshore and Onshore Team Handling
• Daily reporting on the deliverables for the Senior Management and Client Management
• Enabled Automated Defaulting of customer and item information on the sales orders, which helped the customer to reduce manual data entry problem and improving productivity during sales order and RMA creation.
• Implemented Firm/ Un-firm feature to prevent sales order delivery lines changes.
• Enabled manual and automatic Delivery creation to group multiple sales order lines onto a single delivery.
• Enabled partial order fulfillment through Split lines feature. This was done by splitting single Delivery into multiple lines, thereby shipping the order partially.
• Provided a solution to Development and support shortage of items on a delivery and complete the Trip, by un-assigning delivery from the Trip.
• Provided a solution to fulfill the customer orders by shipping the items from the supplier directly to the customer, through the Drop Ship Process, eliminating the inventory management costs with no upfront inventory and ensuring positive cash flow.
• Implemented feature based Order Configurator process that enables order processing of CTO (Configure to Order) and ATO (Assemble to Order) type of products including the manufacturing of the configured products.
• Implemented Vendor Managed Inventory (VMI) where the suppliers are responsible for replenishing the stocks by monitoring the stock levels.
• Defined pick slip grouping rules based on varied grouping criteria to allow smooth picking process.
• Defined release sequence rules to specify the release criteria based on order number, outstanding invoice value, scheduled date departure date and shipment priority.
• Enabled automatic or manual attachments of documents on sales orders and returns to capture important information.
• Increased the order fulfillment and revenue using product substitution process Confidential the time of order entry.
• Defined Customer items and cross s to link the customer items with inventory organization.
• Increased the inventory accuracy by implementing Physical Count which resulted in bridging the discrepancies between system and actual quantity periodically. This also helped in reporting and closing the financial statements Confidential the month and year end.
• Provided lot and serial transaction controls for the items during all receiving, manufacturing and shipping transactions.

Confidential

Responsibilities:

• Analyzed the business requirements and provided the fit GAP analysis
• Prepared As-Is, To-Be process flows documentation using AIM Methodology.
• Enabled upsell / cross sell and substitute items by defining items relationships in oracle inventory for the increase in revenue through fast order fulfillment.
• Defined payment terms and also Implemented a solution to apply Holds on multiple entities.
• Defined Processing constraints according to business process and prevented certain unwanted changes by validating the changes against the processing constraint enabled.
• Implemented Defaulting rules by defining defaulting condition templates and defaulting rules based on sales order attributes. This reduces the amount of information that must be entered manually on Sales Order form.
• Implemented Retro-Billing Process which helped in changing the amounts on already invoiced orders on customer request.
• Implemented freight cost charging to sales order during shipping process.
• Defined shipment transit times by setting up the relationship between organizations by specifying the Ship Method and other associated parameters for the inter location movement of the goods.
• Enabled partial order fulfillment through split lines feature. This was done by splitting single delivery into multiple lines, thereby shipping the order partially.
• Implemented Shipping Process enabling Auto Create Deliveries and Trips.
• According to Business needs, enabled Surcharges to a particular order type which helped in defaulting surcharge price on to the sales order.
• Implemented pricing modifications based on coupon with help of modifiers on sales orders during order processing.
• Implemented Item upgrade modifiers by defining the relationship between items and Upgraded items in Inventory.
• Implemented multiple BOM’s, component substitution, alternate operations lead time inquiry, and BOM comparison to improve the manufacturing process and to identify the discrepancies.
• Implemented alternate routings, copy routing and common routing for the manufacturing process.
• Automated processes for count points, back flushing, floor stock replenishment, over completions and resource charging.
• Used the common bills concept for the maintenance of the BOMs for the common products across organizations.
• Enhanced the Work in Process productivity through the creation of standard documents and attaching them to the discrete jobs which provided as SOP for shop floor assembly operation resources
• Automated standard discrete job creation process in the organization by auto creating discrete Jobs, based on the sales order scheduling in a CTO environment.
• Implemented Material Work Bench to perform material transactions like mass move, mass issue in order to issue or move the material to the selected location.
• Effectively utilized closed loop system to define outside processing resource requirements, automatically generate requisitions for outside processed assembly items, receive the items back into inventory and update the WIP job.
• Provided a solution for adding and updating material requirements to discrete jobs with the appropriate job statuses.
• Enabled serial number tracking for standard and non-standard discrete jobs. This enabled to assign and associate serial numbers to a job, and track the assembly by serial number as it progresses on the shop floor.
• Prepared MD50 and MD70 documents.
• Conducted CRP, SIT and UAT testing.

Confidential

Responsibilities:

• Define Accounts Receivables related setups. Data migration from the legacy.
• Define Functional specification for custom changes on forms and reports and sign off with cross-functional team.
• Identify and work with development for the modifications as per the Functional Specification.
• Drive Business Process flows for Test Cycles and Pre-Production run.
• Create and Update Project Business Process Flows and Material.
• Drive Business Process flows for Test Cycles and Pre-Production run.
• Extensive 24x 7 Support during GO Live and a year’s support after go-live.

Confidential

Responsibilities:

• Development and Support and Maintenance activity on Oracle Financials Applications in modules like AP, GL, FA, PA, AR and also some part of Oracle Manufacturing modules like OM, PUR for the Global Support of Confidential .
• Majority involved in the end-user support on their problems and issues with Oracle Application System. Also, I have taken part in the Business Continuity Plan.
• And, also involved in the Financial Enhancement activity of Oracle Financials modules like setup, knowledge transfer and cut over to production.

Confidential

Oracle App Functional Consultant

Responsibilities:

• Were prepared for the purpose of regression testing.
• This testing was done for entire assigned applications before migration as well as for post upgrade (11.5.10) of the functions in order to check the impact of the changes in business flow.
• It is majority-building regression testing capability of the client IT Team. Additionally to the above testing, the business functionalities and business rules post-financial standardization (i.e. merger of Telco and wireline).
• Majority involved in Payment.Net, Common Services and Accounts Payable applications on writing the Test cases and Test Scripts and Test Scenarios and executing the same in Oracle and Custom Applications and also involved in executing the assigned Test Scenarios which covered the functionalities in modules like General Ledger, Fixed Assets & Project Accounting.
• And involved in Business Rules validation of Oracle Applications, Where some time leading the team on this activity.