OBJECTIVE:

Seeking a position as an Oracle ERP professional where my technical, functional, training and communication skills can be utilized in Oracle Financials implementations/support.

SUMMARY:

• Seasoned professional with 19 years of experience in Oracle ERP modules in functional setup, analysis, project management and support of General Ledger, Accounts Receivables, Accounts Payables/iPayables/iExpenses, Fixed Assets, Project Accounting, Purchasing/iProcurement, Advanced Pricing, Oracle Transportation Management, Order Management, Inventory, Workflow, AME( Approvals Management Engine), E - B Tax and Sub ledger Accounting, FAH modules.
• Thorough knowledge of functional/business processes of Oracle applications setup in implementation of most of the Financials modules. Good understanding of accounting cycle in Oracle E-business suite.
• Worked as Lead Consultant in multiple Oracle EBS modules. Excelled as functional consultant in Project accounting, Payables, Purchasing and Inventory modules at multi-national clients in North America for global implementations spanning multiple countries and organizations.

TECHNICAL SKILLS:

Databases: Oracle 10g, Oracle 7.x, Oracle 8.x

Languages: SQL, PL/SQL(2.x, 8)

ERP: Oracle Applications Rel. 12.1.3, 12.1.2, 12.0.4, 12.0.6, v.11.x, 10.7 10SC Webserver, Oracle Applications 11.5.3, 11.5.7, Oracle Wokflow, EDI Gateway, Oracle financial analyzer, Oracle Tutor11i

Methodologies: AIM, UCD

Software: Toad, Sqlplus, Sqlnavigator, Discoverer Desktop 10.1.2, Discoverer Administrator 10.1.2, Oracle Workflow Builder 2.6.3.5

PROFESSIONAL EXPERIENCE:

Business Analyst/Consultant

Confidential, Cleveland, OH

Responsibilities:

• Functional Lead for full cycle of upgrade n from CRP1, CRP2, SIT, UAT to go-live in General Ledger, Payables, Receivables and Purchasing modules. Gathered requirements during CRP1 phase and designed solutions by creating 12 RICEW objects and guided development team.
• Co-ordinated system testing, integration testing, test scripts and end user training.
• Designed conversion of Journals and Payables Invoice interface to Oracle EBS and supplier data to Oracle MDM.
• Completed the General ledger and payables setups and mapping of fields between source systems to Oracle MDM namely Supplier Type, Organizations, Freight Carriers etc.
• Designed 12 custom RICE objects in Receivables, Payables and General Ledger modules like WebADI templates to upload supplier and supplier hierarchy data into MDM and source systems. RICE objects also include multiple reports to report on supplier hub entities like Merge data, duplicate sets etc.
• Customized Receivables invoice interface and Payables Invoice approval AME processes.
• Defined E-b Tax engine ( jurisdictions and rules ) to default on supplier/sites and P2P transactions.

Environment: Oracle EBS 12.2.5

Senior Functional Analyst/Lead

Confidential, Toronto, ON

Responsibilities:

• In first phase completed pain point analysis of 60 pain points ( gaps ) in General Ledger, Purchasing, iProcurement, iExpense and Payables modules and suggested process improvements.
• Prepared detailed design documents MD050 for each individual pain point. Very strong in business analysis. The examples of some of pain points are
• Conducted business workshops and demos to business leads apprising the new R12 features to map them to gaps identified in prior releases ( R11 ).
• Completed proposed alternatives to business processes in these modules namely General Ledger, Purchasing, Payables, iExpense, iProcurement and Receivables modules.
• Worked in R12 upgrade project in second phase to configure, functional testing of all the new R12 functionalities. Created test cases and test scripts. Trained and supported business users during testing phase.
• Led the team in full cycle of upgrade in second phase .
• Configured E-b Tax Engine to streamline calculation of taxes on transactions in various modules. Defined Jurisdictions and tax rules to pick up right tax codes reflecting correct tax rates.

Environment: Oracle EBS 12.1.3

Senior Business Analyst/Lead

Confidential, Toronto, ON

Responsibilities:

• Thoroughly tested full P2P cycle encompassing Purchasing, Payables, Cash Management, Assets, Receivables and General Ledger modules after upgrade. Made the configuration/setup changes to address the defects/bugs along with application of required patches. Interacted with Oracle Metalink support through Service Requests and followed up with them.
• Prepared business analysis documents per AIM methodology, BP90 ( Business Procedure Documentation ), BR100 and MD050 for each business process/scenario in above modules.
• Tested sales tax calculation in these modules per tax rules setup and legal requirements in all the above countries/legal entities/Operating units.
• Setup up of multi-currency and consolidation of 40 ledgers spanning multiple countries in this global implementation.
• Managed project by participating in project meetings with end users, business analysts. Prepared Cutover task planning, Sanity Testing etc.
• Conducted UAT and helped users to complete testing and signoff by supplying inputs and guiding them.
• Designed and guided 40 custom RICEW objects for interfacing to MMC Oracle EBS from WebCAS ( custom web application ) and other applications. Designed multiple custom reports for P2P and Order Management streams. Prepared MD050 and guided off-shore development teams for development and testing.
• Tested all functionalities in the context of new modules for sub-ledger accounting and e-b tax for upgradation of Oracle R11 to R12.
• Prepared test scripts/scenarios/Test Cases for users to run during UAT.

Environment: Oracle EBS 12.1.3

Senior Functional Analyst/Lead

Confidential, Vancouver, BC

Responsibilities:

• Participated in requirement gathering workshops, interviews, design reviews with end-users and business analysts. Reviewed business process documents and prepared BR100 documents.
• Configured Oracle EBS. Designed setups to get the required business functionalities .
• Lead consultant to implement General Ledger, Payables and Receivables modules in 22 countries spanning Australia to USA and Canada. Defined Position Hierarchies and AME rules for Requisition approval. Configured Workflow and automatic creation of releases from iProcurement requisitions.
• Implemented AME for Payables Standard Invoice Approval Workflow and iExpenses workflow.
• Setup Ledgers including consolidation of Ledgers for reporting purposes.
• Fulfilled challenges involved in keeping current of the latest legal requirements and functionalities in Oracle EBS. Mapped client requirements to Oracle EBS and suggested customizations and workarounds to client needs.
• Managed project by participating in project meetings with end users, business analysts. Prepared project plans, timelines, resource estimates and infrastructure planning in different phases of project.
• Troubleshooted glitches and UAT issues. Guided off shore development team by preparing MD050 for every customization and assisted project manager in resource estimation.
• Helped QA team by reviewing test scripts and resolved more than 60 defects they raised in these modules.
• Participated and organized System Integration Testing, Production Cutover Planning.
• Involved in post Go-Live support for the first 4 weeks after live date and helped with first month-end production issues.

Environment: Oracle EBS 12.1.3

Consultant

Confidential

Responsibilities:

• Worked as a business analyst in initial phase of the project to prepare business process diagrams/documents per Oracle’s AIM methodology. Prepared BP010, BP090 and BR10, BR090 documents for business processes.
• Created 24 Functional Design Documents for Off-Shore team to customize Payables and Purchasing modules.
• The FDDs ranged from customizing existing objects ( Reports, interfaces ), custom policies like controlling the expense report and receipts submission schedules, reimbursement currencies in iExpenses to implementing new functionalities like implementing AP invoice approval workflow customizations etc.
• Designed multiple interfaces to Passport application with Accounts payable module.
• Created multiple FDD documents to customize AP invoice and expense report approval workflow processes to satisfy in-depth approval requirements of customer like sending notifications to multiple approvers to approve invoice etc.
• Designed and developed multiple sql reports encompassing Purchasing to Projects, Inventory and Assets modules to reconcile the transactions between Purchasing to Inventory modules.
• Involved in system testing and prepared multiple test scripts to test the accounting impact of every transaction in above modules namely Purchasing, Payables and inventory modules.
• The FDDs ( for RICEW elements ) created encompassed creating custom programs to functional setup changes to streamline US Steel’s business activities.
• Designed multiple FDDs in Project Costing module spanning enhancements to Project Transactions interface to Projects workflow customizations.

Environment: Oracle EBS 12.1.2

Consultant

Confidential, Halifax, NS

Responsibilities:

• Involved in Implementation of Oracle financials modules Purchasing/iProcurement for Emera group of companies. Solved multiple user problems.
• Designed and developed multiple reports using Cognos Impromptu Administrator.
• Implemented Purchasing and Project Costing modules as part of the team for this implementation of new modules along with upgrading the existing Payables and General Ledger modules.
• Fully responsible for Canadian tax standards implementation in financials modules to confirm to Canadian tax legislation.
• Defined tax codes and tax groups for use in creating transactions in Purchasing, Payables and Receivables modules.
• Deployed multiple Cognos impromptu reports and published them to portal.
• Involved in implementation of AP invoice approval workflow. Defined the functional setup needed for using invoice approval workflow and AME rules for selecting appropriate approvers.
• Designed and defined all the functional work needed to create automatic releases for Agreements during Requisition Import from iProcurement and other sources like MAXIMO.
• Implemented Pay on Receipt functionality for some Suppliers/Supplier Sites in Emera Legal Entity
• Involved in 12i upgradation in Projects, Payables, Purchasing/iProcurement modules. Designed and developed interfaces.
• Involved in post rel. 12i technical and user support.

Environment: Oracle EBS 12i ( 12.0.1 )

Consultant

Confidential, Etobicoke, ON

Responsibilities:

• Resolved multiple complex issues users are facing for several months in General Ledger, Inventory and Projects modules
• Solved some of the issues/bugs with Oracle Support through Service Requests/TAR’s.
• Involved in functional user support in above modules.
• Designed and developed multiple discoverer workbooks.
• Designed and implemented p-card functionality in Purchasing/Payables module to streamline procurement process.
• Implemented and customized p-card workflows.

Environment: Oracle Applications 11.5.10.2

Consultant

Confidential, Etobicoke, ON

Responsibilities:

• Gathered and prepared Business Requirements Documentation for Purchasing/iProcurement, Payables modules in this multi-org implementation.
• Involved in fit-gap analysis, gathering and mapping business requirements to Oracle functionalities and implementing solutions.
• Involved in system testing, integration testing. Participated in overall application design process and contributed to project plan and other deliverables.
• Involved in designing and implementation of Purchasing/iProcurement, Payables, Order Management modules
• Designed and setup the functional entities for Purchasing/iProcurement to name few Buyers, Suppliers/Supplier Sites, Purchasing Categories, Approval groups, Approval assignments, Summary Approved Supplier List, Supplier Item Catalog etc.
• Assisted in defining setups for Advanced Pricing, Purchasing and Order Management modules.
• Involved in the Oracle Applications implementation to create course material for training new resources in MDS and specific to its business to train as many as 1,000 users new to Oracle ERP Applications.
• Prepared the detailed instructions to new functionalities never used in the previous package like customizations to PO Approval Workflow to go through full cycle of approval process for change orders even if the changes were not needed to be reapproved in the seeded PO approval workflow etc.

Consultant

Confidential

Responsibilities:

• Designed and developed Oracle Payables workflow for approving AP invoices. Customized seeded AP workflow using Workflow builder to send notifications at batch level and customized payables invoice workflow concurrent program to pickup already pre-approved expense report batches from iExpenses for re-approval by payables managers.
• Designed and defined the functional setups required for implementing AP invoice approval workflow per customer requirements. Involved in full cycle implementation from requirements gathering ( prepared BR100 ) to Module Design ( MD050 ) and migration documents.
• Designed and implemented AME conditions, action types, approval groups and approval rules for AP workflow to send notifications to approvers using seeded attributes.
• Gathered and prepared Business Requirements Documentation for Purchasing/iProcurement, Payables modules in this multi-org implementation.
• Involved in designing and implementation of Purchasing/iProcurement, Payables, iAssets modules
• Designed and setup the functional entities for Purchasing/iProcurement to name few Buyers, Suppliers/Supplier Sites, Purchasing Categories, Approval groups, Approval assignments, Summary Approved Supplier List, Supplier Item Catalog etc.
• Assisted in defining setups for Oracle Payables and Assetsmodules.
• Involved in the Oracle Applications implementation to create course material for training new resources in Government and specific to its business to train as many as 1,000 users new to Oracle ERP Applications.
• Prepared the detailed instructions to new functionalities never used in the previous package like customizations to PO Approval Workflow to go through full cycle of approval process for change orders even if the changes were not needed to be reapproved in the seeded PO approval workflow etc.
• Created new training docs for reclassification of approved PO’s in the closed periods and to make quantity adjustments esp. when the PO’s have receipts and invoices/payments created against them.
• The training material created covered all the procedures followed in day-to-day business together with all the functionalities and definitions in the above modules particularly iProcurement/Purchasing module at this client in above modules and were prepared with clear, detailed instructions with screen prints by keeping in mind novice users as well as advanced business users.
• Involved in fit-gap analysis and system testing to identify gaps and mapping them to Oracle functional functionalities. Suggested workarounds where the Oracle apps standard functionalities are not adequate to Government requirements.
• Created a total of 75 test scripts in iProcurement/Purchasing module alone to cover the customized part of the application apart from standard test scenarios to ensure all the required functionalities are covered.
• Logged bugs and recommended application of patches by following up with Oracle support and correcting setup errors.
• Identified new test scenarios specific to Government business and prepared test scripts for business users to facilitate system testing.
• Involved in system testing and integration testing and training users from legacy systems.
• Developed multiple sql queries in both sql plus and Discoverer Plus tool to report on the reconciliation between Purchasing, Payables and other associated modules ( Projects and Fixed Assets ).

Environment: Oracle Applications 11.5.10.2, Discoverer 10g, iProcurement/Purchasing, General Ledger, Accounts Payables, multi-org

Programmer Analyst

Confidential

Responsibilities:

• Involved in requirements gathering and prepared Requirements Documentation in above modules esp. Purchasing and Order management modules.
• Worked in 11.5.10 upgradation by customizing Item Category interface in Inventory module. The modifications to the program involved inserting one record for updating pre-existing item category combinations. Worked on several interfaces in Manufacturing modules during upgrade to 11.5.10.
• The test scripts created in iProcurement/Purchasing module encompass from Login to iProcurement and Setup/Modify Personal Profile’ to ‘Create Approval Groups and Approval Assignments’.
• The training material created covered all the procedures followed in day-to-day business at this client in above modules and were prepared with clear, detailed instructions with screen prints by keeping in mind novice users as well as advanced business users
• Worked on several complex Discoverer reports that needed extensive custom sql code namely RO19 report, R&O follow-up report ( RO purchase orders with outstanding quantities ), Descriptive Flexfields usage report ( for Change Control Board ), Supplier Scorecard Report, Concurrent programs listing report etc. to give functional inputs needed for developers.
• Involved in functional configuration of new implementation of Order Management and Purchasing/iProcurement modules. Implemented Drop Shipment functionality. Designed setups and implemented client’s requirements through fit-gap analysis.
• Involved in system and integration testing of Order Management module and other associated modules ( Inventory, Receivables, Purchasing etc. ).
• Involved in creating configurations in Oracle Configurator module by using configurations for use in Order Entry. Defined model definitions and rules for configurations.
• Designed and developed Auto Invoice and Lockbox interfaces in Accounts Receivables.
• Solved many user functional/configuration problems in above financial and manufacturing modules.
• Involved in technical and functional support of above manufacturing and CRM suite of modules.

Environment: 11.5.9, 11.5.10.2

Confidential

Responsibilities:

• Involved in design and development of reports and programs to streamline cash splitter process, interfacing bank files into Oracle Accounts Receivables module.
• Involved in requirements definition, functional setups and conversion of new products in to upgradation of Oracle Applications package.
• Prepared training material for users in the project of upgrading from Oracle Applications 11.5.9 to 11.5.10.2 in iProcurement/Purchasing, Payables, General Ledger Modules.
• Created test scripts for customizations to the above modules to facilitate user testing.
• Involved in SOX ( security ) project development and refresh of evidences to comply with mandatory reporting requirements controlling accessibility to various programs, directories, systems in enterprise servers/applications.
• Troubleshooted various problems faced by users in working with Cross-currency receipts while applying receipts in Accounts Receivables.
• Designed and developed a new report in sql showing the interface status of invoice lines being interfaced from Accounts Payables to Fixed Assets that are interfaced through Project Accounting module. Currently there is no report in Oracle 11i to show these statuses, a need raised to develop a new one by studying tables in all these modules to pinpoint where the transactions stuck in the cycle.
• Involved in techno-functional support of Purchasing, Payables, Inventory, Order management and Receivables modules
• Designed and developed another report in Confidential ’s custom cash pre-processor/Accounts Receivables modules to show excluded cheques report to facilitate user in identifying duplicate cheques coming in the feed from banks and other financial institutions.

Environment: Oracle 11.5.7, multi-org, Developer 2000, Developer 6i

Confidential

Responsibilities:

• Involved in upgradation ( to Oracle 11i ) and implementation of Oracle Purchasing, Accounts Payables and Receivables modules in Requirements gathering to development /customization and application support.
• Designed and developed several reports in sql namely ‘PO Open Commit’ report to report all POs with open commits in a given period in Purchasing.
• Designed and developed Asset extraction script for any FA book to get assets information for ongoing depreciation in any other set of books, did this as a part of migration of assets from Confidential to E&Y practice in some countries. Designed and developed another script to copy FA categories from one FA book to other book.
• Designed and guided technical developers to build ‘Customer interface’ to upload customer information from Concert’s peoplesoft application to Oracle financials database to synchronize customer information between two systems.
• Involved in production/user support of current Oracle 11 Receivables, Purchasing and Payables modules. Co-ordinated the application issues between oracle Purchasing and associated web applications in solving user functional and technical issues.
• Prepared test scripts and documentation of customized programs per standard requirements. Co-ordinated and guided users in successful completion of system testing and user acceptance testing.
• Gathered requirements from users, analyzed them and implemented solution ranging from workarounds to projects, gave necessary inputs and prepared project plans involving work estimates and timelines.
• Designed and guided technical programmers to build outbound General Ledger/Journal interface to another system ( Titan ) for consolidation and reporting for all 69 Legal Entities.

Environment: Oracle 11.5.7, Oracle 11.0.3, multi-org, Developer 2000, Developer 6i

Contractor

Confidential, Toronto, Ontario

Responsibilities:

• Involved in development and support in phase II ( involving upgradation to 11i and addition of purchasing and receivables modules ) of implementation and its business impact in Fixed Assets, Accounts payables, Project Accounting, Accounts Receivables and Purchasing/ iProcurement modules. Prepared test scripts and ran them, logged bugs and interacted with oracle support for resolution. Coordinated patch application to resolve these bugs.
• Prepared elaborate user procedures for maintenance and transactions in these modules as part of test plans, trained users with Oracle Assets and purchasing procedures, resolved their concerns and implemented solutions as a part of post implementation user support.
• Designed and documented application according to Oracle AIM methodology guidelines at various stages of its lifecycle. Recorded inputs and delivered output at various stages. Prepared technical/project documentation per AIM guidelines.
• Prepared elaborate user procedures for maintenance and transactions in these modules as part of test plans, trained users with training manuals and course schedules, prepared and edited for suitability of user group, prepared all the documentation through Oracle Tutor11i.
• Defined organization’s business processes in Tutor, which are different from standard pre-defined business processes to get customized training manuals, guides and test scripts thereby built organization’s repository to take care of any future changes in business processes, placed them in online help system.
• Designed and developed customization of few reports ( Reports Developer 6i ) and descriptive flexfields to forms ( Forms Developer 6i ). The reports customized were EFT reports in payables and receivables and several reports in General ledger namely, Journals Day Book report, Journals General report and General ledger report etc. Added descriptive flexfields to Accounts payables transaction/Invoices form to display payment indicators at the time of creating invoices.
• Designed and developed Fixed Assets and Account receivables interfaces ( pl/sql procedures ) to validate incoming data from mainframes and to map transactions between two systems for successful integration. The interfaces are invoice, customer and vendor master interfaces and Requisitions interface in Purchasing.
• Defined the transaction/testing process in load runner and tested network load. Guided programmers interface design with mainframes.
• Completed fit-gap analysis and impact analysis of proposed changes to the system and gave better estimates of system load and resource requirements. Studied the current setup and filled the gaps. The gap analysis yielded a better picture of gaps against requirements in the existing system and led to accurate resource estimation to fill those gaps for planning phase II of the project.

Environment: Oracle 11.5.3, Developer 6i, PL/SQL 8.0, Tutor 11i

Contractor

Confidential

Responsibilities:

• Worked for AT&T’s 11i implementation in development and functional support of Oracle iProcurement/Purchasing, Accounts Payables, Accounts Receivables and Fixed Assets modules.
• Defined Key flexfield segments, item category, system item and all flexfields in HRMS, their values, designed and defined Descriptive flexfields. Designed workflow setup in iprocurement and Accounts payables modules.
• Involved in full Techno-functional Design of conversion of transactions from Legacy system to Oracle Purchasing, Payables and Receivables modules. The design included Data mapping, approach, program logic, dependencies, exception report logic, Data Cleanup etc.
• Worked for OCI team, Oracle financials 11i and PRISM (Compusearch.com) integration package in Purchasing and Payables modules. Involved in fit-gap analysis and user techno-functional post implementation support.
• Tested usecase scenarios and found several bugs and fixed them pertaining to Categories, Vendors, BPA Calls, Requisitions etc. Designed and developed requisitions and purchase orders outbound interfaces to PRISM database through PL/SQL procedures and alerts.
• Customized several reports pertaining to customer profiles and reports for risk management in Accounts Receivables. Designed and implemented descriptive flexfields for Accounts payables forms.
• Designed and developed Vendor and Purchasing interfaces in Purchasing and Mass Additions interface in Fixed Assets from scratch.
• Worked for Fixed Assets and Accounts Receivables team in designing and developing user change requests and further enhancements to Fixed Assets module. Worked on Mass internal transfers program to record corrections to distribution accounts. Completed sql script and sql loader script, automated by placing the entire script execution in a Korn shell script and registered in AOL. Modified sales tax calculation program for further validations.
• Modified Vertex (third party) sales tax calculation calling program, written in pro*C for calculating sales tax on leased and other assets, to improve efficiency in handling a bunch of asset records rather than one-by-one or per call basis for each asset. This improved efficiency of month end sales tax calculation for thousands of AT&T assets. Both speed and error handlings were remarkably improved
• Prepared system test plan documentation, Prepared and tested test cases for all entities like Requisitions, Purchase orders, BPAs, Vendors, Contracts, items etc. and corrected all the data integrity problems related to functional configuration.
• Interacted with users to understand their information requirements and apprised of the Oracle procurement system features and usage to fulfill them. Recorded their specific requirements for customizing the procurement module. Trained users in Purchasing user procedures and day-to-day tasks.

Environment: Oracle applications 11.0.3, 11i, e-commerce, multi-org

Consultant/Lead Analyst

Confidential, Toronto, ON

Responsibilities:

• Involved in development, analysis and supporting Oracle financials application ( Release 11.0 ) in technical and functional areas of the application, for a company involved in pension administration for Hospitals in Ontario ( HOOPP ), day-to-day activities are, user interaction to solve their problems related to functional setup and technical design of concurrent programs in Order Projects, Fixed Assets, Accounts Payables and Oracle General Ledger modules. ADI tool v. 5.0.2 for uploading journals from spreadsheets. Mentored junior staff/programmers and users with financials.
• Involved in impact and fit-gap analysis, prepared project plan and deliverables for successful 11i implementation to support other business areas. Planned 11i migration by studying its new features and apprised users, of their application to organization information requirements. Worked on third party tools integration to financials to solve electronic document solutions to organizational electronic document circulation needs. Technical and functional Project in-charge for this application in support, design and development for upgradation to 11i.
• Worked on interface design and development in Accounts Payables and Accounts Receivables, designed and developed several reports in Accounts Receivables and modified interfaces for more specific error handling/validations of data.
• Configured and implemented Oracle Purchasing, General ledger and Project management modules. Supervised a team of six technical and functional consultants.
• Done full functional design of conversion of transactions from Legacy system to Oracle Purchasing, Payables and Projects modules. The design included Data mapping, approach, program logic, dependencies, exception report logic, Data Cleanup etc.
• Designed workflow diagrams and Workflow setup in Purchasing module. Thoroughly tested all functions together with complete transaction cycle after configuration and before implementation, prepared and executed test plans.
• Designed and defined (functional setup) key flexfields segments and segment values, namely Accounting flexfield, territory and sales tax location flexfields and all the functional setup necessary for usage of above modules.
• Prepared functional setup documents and user training schedules together with training material. Trained users at all levels.
• Gathered user requirements to map to the existing system and for further customization of above financials modules.
• Worked with Oracle support on tars for bugs related to functional features, implemented corresponding application patches to address these bugs like attaching purchasing documents to payables transactions, prepared patchset testing plans like patchset D and patchset E in these modules.

Environment: Oracle financials v. 11.0.3/multi-Org, WindowsNT4.x