SUMMARY

• Having 10+ years of strong ERP experience as a Oracle EBS R12 Techno Functional Consultant in multiple Implementations, Upgradations and Post Production Support in Oracle E - Business Suite R12/11i versions.
• Excellent Functional expertise and a good understanding of Oracle General Ledger, Account Payables, Fixed Assets, Account Receivables, SLA, E-B Tax, TCA, Cash Management, Purchasing, Order Management, Inventory, System Admin & Application Developer.
• Strong programming experience in creating PL/SQL Stored Procedures, Functions, Stored Packages, Database Triggers, SQL* Loader scripts, Shell scripting, Forms (6i/10g), Reports (6i/10g).
• Extensive experience in design and implementation of Oracle Forms & Alerts and customizing Oracle Workflows.
• Extensive experience in developing and designing custom reports using XML/BI Publisher Reports.
• Experience in personalization, custom page design and extending Oracle Self-Service applications using OAF, JDeveloper10g.
• Good exposure to AIM & OUM Methodologies.
• Experience in using and maintaining documentation of Application Implementations Methodology (AIM), which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing (BR100, BP 80, BR30, BR 150, MD 50, CV 40 &TE 40).
• Possess working knowledge and also have Solid experience in defining processes relative to Procure to Pay, Order to Cash, Record to Report and Close Processing.
• Designed new Budget Structure in GL based on State allocated Appropriations and Segregations.
• Modified Entire Rollup Structure for Chart of Accounts and definition of new Summary Templates.
• Thoroughly studying ‘AS-IS’ processes and providing ‘T0-BE’ processes with the Gap Analysis.
• Provided support for CRP, SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion, Inbound / Outbound interfaces, Reports, Form Personalization's, SQL, PL/SQL and Workflow Customizations.
• Experience in using Oracle tools like SQL*Loader, FND LOAD, Data Loader, SQL Developer and TOAD.
• Conduct multiple meetings with business, coordinate with Offshore team and create functional Impact Analysis documentation as part of Change Management Process.

TECHNICAL SKILLS

Oracle EBS R12 Modules: AP, GL, FA, AR, CM, SLA, PA, TCA, PO, OM, System Admin, AOL

Business Flows: Order to Cash (O2C), Procure to Pay (P2P)

Database: Oracle 10/11g, TOAD, SQL Developer, SQL, PL/SQL

Operating Systems: Windows 98, NT 2000, Vista and Windows 7, UNIX

Tools: Form 9i/10g, Reports 9i/10g, Workflow, JDeveloper 11g, web ADI

PROFESSIONAL EXPERIENCE

Confidential, Detroit

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

• System setup audit has been done to ensure the system setups in R12.2.5 to meet the requirements in GL, TCA, AR, FA, CM, SLA, PA, PO & AP modules.
• Implemented functionalities like Sub Ledger Accounting (SLA) and functionality changes in various modules are reviewed with Super users and Users of various Business areas.
• Worked extensively on TCA Customer Conversion in loading the new Customer details from Legacy System to Oracle AR Tables.
• Interfaced legacy system GL data using Journal Import. Ran Journal Import to load data into GL base tables.
• Provided the functional and technical level support to resolve AR, AP, FA and PO related issues.
• Wrote custom program to import data from temporary table directly into vendor base tables (AP). Uploaded data into the staging tables using Direct Path SQ Loader.
• Performed System Administrator functions like registering of new reports, forms, functions, validation sets, request sets and concurrent programs.
• Prepared test cases for major impacted components.
• Support provided for UAT and posts Go- live issues.
• Developed UNIX shell scripts for archiving of the files for inbound/outbound folders and also developed program to handle the files from inbound.
• Worked on Customizations of OAF Pages.
• Worked on Personalization’s of OA Pages.
• Experienced with creation of BC4J components like AM, VO and EO.
• Designing MD070, MD120 and TE020 documents as per AIM Methodology.
• Involved in client discussions for resolving the issues.
• Worked on Extensively PL/SQL Subprograms (Packages, Triggers, Procedures, Collections.)
• Customized reports in AR such as: Customers Profile Report, Aging Report.
• Designed, developed and documented for Conversion of Purchase Requisitions,
• Purchase Orders, Suppliers, Supplier Sites, and Items.
• Prepared & tested CRP, SIT & UAT, PROD’ Test scripts to get client's approval.
• Worked on Customizing Oracle Reports in Order to Cash Cycle touching various modules such asGL, AP, PO, CM, AR, INV, OM.
• Defined MOAC setups and assigned Ledgers, Operating Units and Legal Entities to profile Options.
• Prepared all custom components and migrated in to the respective new Operating Unit.
• Loading Budgets Journals and Balance Sheet Trial Balance through ADI.

Confidential, Ann Arbor, MI

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

• Preparation of Setup Documents, User Manuals which can be useful in training sessions.
• Setting up application in the Test, Development and Production environments from offshore through remote servers.
• Reviewing the documents, which are prepared by onsite coordinators and gone through the Documents like BP080, and BR100 to understand about client requirements and implementation of the project.
• Done the Multi-Org setups, have sound knowledge about Multi-Org concepts.
• Worked on Mass Allocation like preparing the formula for mass allocations and generating the Mass Allocations Journals.
• Created several Unix Shell Scripts to post various concurrent programs output files to Europe site servers through secured gateway.
• Export Import process exporting forms data into csv file to the desktop and once modification done by user it is importing those data to different instance.
• Developed new reports in Oracle Reports and XML Publisher.
• Customized Global AR Invoice Report, Sales Order Acknowledgment Report, Invoice Print Reports and GL Journal Reports, Delivery Note Report, PO print report using XML Publisher in different formats.
• Developing new report of Vendor Extract Report, Global Employee detail report in Discoverer 10g.
• Interacting with business users to understand the critical and high priority issues, provide solutions and code fix on a timely manner.
• Worked on Customer Conversion. worked on AP invoices Interface/ Conversion.
• Written SQL Complexity queries, PL/SQL Sub programs.
• Setting up Financial & Payable options, Defining Payment Terms & Distribution Sets. Defining Supplier and internal Bank, Branches, Bank Accounts .Transaction Work Bench Recording Transactions using Standard Invoice, Debit Memo, Credit Memo, Mixed Invoice, Expense Report, Prepayment, interest invoice, PO Default. Recording of Payments to the Supplier.
• Creation of Receipt Classes & Receipt Source.
• Defining Receivable Activities.
• Defining Internal, Supplier Bank Accounts.
• Setting up Asset Category, Asset Location, and Assets Key Flex fields.
• Creation of Fiscal Years, and Depreciation calendars and Prorate Conversions.
• Defining Categories and assigning appropriate Ledgers, Calendars, and Depreciation methods to Categories.
• Worded on the Mass Additions to add assets to Oracle Assets from Payables.

Confidential, Wixom, MI

Oracle EBS Techno Functional Consultant

Responsibilities:

• Designed chart of accounts to meet the client’s business requirements.
• Set up Fixed Assets including defining category, location and asset key flexfields.
• Defined the prorate convention, prorate calendar, depreciation rate and calendar, fiscal calendar, book controls and system controls.
• Designed and configured Location and Fixed Assets Key Flex Fields, Asset Books, Asset Categories, Asset Sub-Categories, Asset Depreciation, Fiscal Calendar, Prorate Calendar, Security by Book.
• Defined Asset TAX Book Performed Quick Additions, CIP Additions, Mass Additions and Capitalized CIP Assets.
• Developed program to create an Intercompany AP Invoice for the journals created through mass allocation.
• Developed a custom Report to show details of period closing status in excel file format using XML publisher.
• Worked on SQL Queries and PL/SQL API's.
• Customization Outstanding Credit Card transaction details report and Credit Card Load program.
• Analyzed and provided the solution when the Expense Report got stuck and user is not able to process the Expense Report.
• Created newer FSG reports depending on the business requirements.
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components.
• Configuration of CRP2, CRP3, and UAT instances .
• Preparing test scripts and performing smoke testing prior to user testing.
• Keeping track of and updating issues with proposing resolution in Bugzilla issue tracker .
• Involved in month-end closings, interfaces maintenance, and change management.
• Providing post production support to the business users.

Confidential, WA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• Identifying standard functionality, analyze gaps document and design solution for GL & AR depending on Business requirement.
• Coordinated with project Manager, Business team for system updates and deadlines for the implementation.
• Set-up Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies.
• Prepared MD050, MD070 for technical and functional documents.
• Created Oracle alerts for major concurrent program failures and custom specific programs.
• Involved in the business meetings for gathering the requirements for all the objects assigned.
• Developed interface between PO and Marketing system for details exchange like PO and invoice information.
• Customized reports in AR such as Customers Profile Report, Aging Report.
• Designed, developed and documented for Conversion of Purchase Requisitions,
• Purchase Orders, Suppliers, Supplier Sites, and Items.
• Involved in implementing the assets directly using the Additions API via Invoices and cost adjustments to the assets through API's.
• Development & Supporting of PL/SQL, Workflow process, Interface, Forms and Reports.
• Involved in Form personalization.
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
• Prepared Cut- over Plan, listing down all Pre & Post Go- live tasks. Involved in Post-Production support.
• Created/Maintained Business process documents BR-100, MD-50, TE-40, CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology as part of project implementation task.

Confidential, Charlotte, NC

Oracle EBS Business Analyst - Support

Responsibilities:

• Reviewed business processes initiated setups, developed and executed test scripts.
• Supporting day to day production issues, gathering requirements, configuring and testing system to meet the requirements. It includes documentation and user training on new processes.
• Resolved process issues, period end closing and interface issues in GL, AP, AR, FA, CE, PO and E-Business Tax modules.
• Business process had been designed and users were trained to log process issues and documented.
• Business process had been designed for interface issues in cash management and Receivables.
• Issue resolution, update functional impact analysis with proposed changes, if any in to Bugzilla issue tracker.
• Create and followed up SR’s with Oracle Technical Support, coordinate and follow on multiple issues based on priority including identifying bugs and follow-up with Oracle Development.
• Periodical status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting.
• Worked on customized PO distribution from Purchasing to AP.
• Conducted rounds of testing on Funding ID Split from various modules (AP, INV, Payroll) to Projects to Fixed Assets.
• Coordinated with DBA’s and the technical team to customize form as per the requirement of the business users.
• Coordinate with technical team for all timely deliverable of RICE components.
• Defining the Accounting Structure as per the Requirement of the Clint.
• Involved in Defining Chart Of Accounts and Calendar.
• Setting up and providing features like alias, cross validation rules, security rules in Oracle General Ledger.
• Define journal Categories and Source.
• Define Document Sequence and assign to Document Categories.
• Creation & Setting up Payable Options and Financial Options.
• Setting up Banks and Defining Bank Account (Internal & supplier).
• Defining Suppliers and Sites, Expense Report.
• Define Payment terms; Distribution sets Invoice management (Standard, prepayment, credit memo, Debit memo, Expense Report etc.)
• Payment Setups in Accounts Payables module.
• Maintaining the total information of Customer.

Confidential

Oracle EBS Business Analyst

Responsibilities:

• Supporting day to day production issues, gathering requirements, configuring and testing system to meet the requirements. It includes documentation and user training on new processes.
• Provided period end closing process for Payables and General Ledger. Resolved period end closing issues.
• Gathered requirements on budgets and configured the GL system to meet the requirements. Functional process has been developed to upload budget journals and configured setups for Web ADI for batch journals upload process.
• Created YTD, QTD and rolling months actual and budget variance reports through Financial Statement Generator (FSG).
• Analyzed the requirements/process issues and designed a business process to meet the functional requirements for enhancements, Period End closing and production issues.
• Issue resolution, update functional impact analysis with proposed changes, if any into Bugzilla issue tracker.
• Provided production support on GL, AP, AR, FA, PO, and modules and resolved period end closing and interface issues in production. Trained user on process design and enhancements.
• Translating the functional requirements to the technical team for developing various reports and financial statement.
• Managing Finance track Month End Closing.
• As per Oracle AIM methodology review the existing business processes and map them with Oracle standard functionality.
• Performed complete setup for GL, AP and AR as per business requirement
• Gathered business requirement and prepare the As-Is business flows document.
• Performed GAP Analysis and proposed the feasible solutions to fill the identified GAP’s.
• Prepared To-Be (i.e. BP80- Future state model) business flows and Map the business requirement with available standard functionality.
• Prepared Functional Specification for customization to achieve the business requirement
• Designed functional solution, to keep various factors in mind like, performance improvement, easy maintenance and less defect opportunity after regular patching cycle.
• Preparation of shift plans, managing healthy tickets distribution amongst the team.