SUMMARY:

• Overall eight years of experience in Oracle E-Business Suite/Oracle Applications 11i with core expertise on GAP Analysis, Process Mapping, Defining Business Requirements, Implementation and Configuration of Oracle Financial Module including GL, AP, AR, OM, FA, OPM, Service Contract, Incentive Compensation and CE.
• Expert in the functional and technical aspects of Oracle E-Business Suite/ Applications 9i, 10g and 11i deployment Requirements, Coding/Development, Customizations, Testing, and Functional User Training.
• Strong knowledge of development methodology including Structured Systems Analysis and Design.
• Proficient in RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion
• Played team role in application set-ups, implementation, conversions, interface development, testing and end-user training.
• Extensive technical and business experience in Procure-to-pay, Order-to-cash, Quote to Cash and Assets to GL Record to Report.
• Exposure in R12 Financial Modules and SLA, MOAC, TCA, E-BUSINESS TAX.
• Expertise in development tools such as Oracle Forms, Oracle Reports, PL/SQL, SQL*PLUS, UNIX Shell Scripts.
• Experience of setup and configuration of I Expense module.
• Experienced on Project go-live and post-implementation support.
• Proficient in corporate finance/ resource planning, financial systems evaluation, design and implementation.
• Prepared Test cases TE-020,030,040 for Financials modules (AP, AR, and GL).
• Interacted with Business users and the client for providing testing and Production Support as Techno Functional Consultant after GO Live.
• Conducted CRP Presentations for User Community
• Troubleshoot data related issues, Fixing bugs and issues with concurrent programs.
• Developed Technical design documents (MD-120, MD-070 and CV-060) based on functional design document (MD-050, BR-100, CV-40) using Application Implementation Methodology (AIM V.3.0).
• Worked extensively with development team members in resolving issues by creating
• TAR(s) and obtaining one of the solutions using METALINK

Technical Skills:

ERP: Oracle Receivable, General Ledger, Accounts Payables, Oracle Quote to Cash, Oracle iReceivables, OPM, Oracle Order Management, Assets, Application Object Library, Order Management, I Expense.
RDMS/Databases: Oracle 10g, 9i, 8i, 6x, MS Access
Operating System: Windows 2000/NT-4.0/98/95/3.x, NOS 4.1, NOS 2.1, UNIX 3.2, HP UNIX
Tools/Utilities: FSG, Web ADI, SQL * Loader, SQL * Plus, Forms 6i, Reports 6i, Oracle Work flow
Office Tools: MS Word, Excel, Power Point, Visio.
Languages: SQL, PL/SQL, XML, Unix Shell scripting
Packages: E-Business Suite Oracle Applications R12.0.6, 11i (9i, 10g, 11.5.5 - 11.5.10.2)
Application Stacks: Oracle AOL & Sys Admin, Metal ink, Order Management, Oracle Shipping, Advance pricing, Oracle Inventory, Oracle Work in Process, Oracle BOM

Education:

B.S in Computer Science
Diploma in Database Administration and Network Technologies

Certification:
Oracle Certified Developer, 6i, PL/SQL

Experience Summary

Oracle Financial R12 E Business Suite Implementation Oct 2008 Present
Oracle EBS Functional Consultant,Confidential,MN

Best Buy Inc is a specialty retailer of consumer electronics in the United States accounting for 19% of the market. It also operates in Canada, Mexico, and China. The company\'s subsidiaries include Geek Squad, Magnolia Audio Video, Pacific Sales, and, in Canada operates under both the Best Buy and Future Shop label. Together these operate more than 1,150 stores in the United States, Puerto Rico, Canada, China, Mexico and Turkey.

Responsibilities:

• Involved in planning and delivering GL, and Phase I Reporting module which includes defining calendar, defining security rules, account aliases , roll-up group, journal sources, journal categories and used ADI (general ledger desktop integrator) to integrate the GL module to the excel sheet, designing and developing FSG reports such as Balance Sheet, P& L Accounts and other management reports.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Created MD050 (Functional design documents) specification for Reports.
• Created MD070 (Technical design document) for all enhancement requirements.
• Prepared Test cases TE-020,030,040 for Financials modules (AP, AR, OM, and GL).
• Worked extensively with the Development and Business team to help upgrade 9i, 10g and 11i application and setting up of Service contracts, integrating service billing with Oracle GL, providing post production support, maintain service contract workflow, setting up billing schedule and billing profile management
• Planning and Managing Service life cycle that mainly includes 1) Creating Contracts 2) Approving Contracts 3) Extending and Renewing Contracts 4) Terminating Contracts
• Setting up multiple payment service based processing in Service contracts
• Defined Profile Class, Dunning letters, Collectors, Customers, Auto Accounting, Transaction Types, Transaction Sources, Payment methods, Receipt classes, Receipt sources, Payment Terms, Receivable Activities in Receivables.
• Defined Payment Options, Payment terms, Distribution Set, Payment Format, Internal Banks, Recurring Invoices, Prepayments, Expense Report Templates, Interest on Invoice report, Matching options, Adjustment of Prepayments in Payables.
• Configured the setup for raising Batch invoices and Batch payments.
• Configured the setup for multi currency invoices and payments in Payables.
• Configured the setups for prepayments and adjustment to payment to suppliers
• Configured the setups for prepayment to employees and defined employee expense report.
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
• Worked on Payment Format Template which is part of the BOLTON to capture various kinds of template to be used for payments. It also includes XML report to generate the generic payment files to support various banking formats and rtf for various banks in their formats to make payments.
• Worked on Form Personalization to meet customer requirements in modules covering Payables.
• Involved in providing techno-functional Procure-to-Pay (P2P) life cycle support.
• Did the setup for Accrual options in Purchasing, and helped end-users to understand and run reports like Un-invoiced Receipt Report (URR), Accrual and Accrual ‘Rebuild’ Reconciliation Reports and use of write-off transactions option.
• Performed routine fixes for P2P issues in setup of users, responsibilities, suppliers, requisitioning, purchase orders, receiving, invoicing, payments etc.
• Primary resource in multi-org iExpense implementation which included setup of iExpense template, financial options, payables option, signing limits for employees, expense policies, profile options, excel template for each organisation.
• During the post-implementation phase, resolved many issues in Fixed Assets like correcting depreciation amount for assets by running unplanned depreciation, Transferring asset location, changing depreciation methods, adjusting assets units for particular invoice etc
• Understanding of process flow of integration points between PO-AP-FA-GL-OM
• Worked on errors faced in GL cross validation rules used in requisition account generator validation process
• Converted existing Oracle Reports to XML/BI Publisher Report through Oracle’s desktop XML Publisher tool
• Used XML Publisher to create XSL-FO (Formatting Object) and XSL-T (Transformations)
• Experience in creating Concurrent Programs, Request sets, Flex fields, lookups, Profiles, Value sets, Triggers, Packages, Procedures, Functions, Cursors and Exception Handlers, Record Groups, LOV’s.
• In-depth understanding of the steps in Oracle Reports 6i creation, deployment and registration process through AOL and system administration.
• Planned and developed the data conversion methodology for Purchasing Order data interfaced to PO module.
• Analysed and designed staging tables, wrote inbound interface programs in PO Module.
• Involved in handling all issues on Purchase Order Interface.
• Created AIM based documents like BRD100, MD050, and MD070 etc for various customization

Environment:
Oracle e-Business Application R12 (GL, AP,AR, FA,CE,OM, Service Contract, 9i, 10g, 11i and R12), Test Director, Windows NT and UNIX, Auto Lock box.

Confidential,Augusta, ME Jan 2008 Sept 2008
Oracle Functional Consultant

The Project is a full implementation and customization of application from legacy system 9i, 10g to 11.5.10 involving various modules such as AP, AR, PO, OM, GL, FA, Oracle Service and PA

Responsibilities:

• Functional design and design review of Oracle Applications data conversions, interfaces, custom reports and custom applications.
• Provided production support on Oracle on various modules
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Customized application according to Account Receivables Business process.
• Helped Implementation team to test and approve CRP deliverables and facilitate migration path to Production environment
• Conducted interviews with current super users for each module to determine current functionality and process
• Determined additional functionality required to improve and enhance current processes Compared current set up to original Implementation Document and noted any changes.
• Involved in pre-post upgrade Production validation testing during 11.5.10 upgrade for modules AR, OD, Inventive compensation and service contract.
• Setup the system to meet the desired business process and requirements based on knowledge about the Oracle Financials applications functionality and oracle Application Implementation methodologies
• Designed organization structure, transaction flex field structure (descriptive flex field) and remit to territories and locations. Defined transaction types and sources, quick codes, defined grouping and Line ordering rules for Auto invoice, Auto accounting rules, Receipt classes and Source, customer profiles, Payment terms, Internal banks, lockbox, Transmission Formats, Set the system options and defined Tax Codes and set the Profile Options.
• Involved in developing Interface for Bank Statement Open Interface to load Bank statement information into Cash Management before reconciliation.
• Performed multiple bank reconciliation.
• Worked on data conversion in AR, which includes mapping the data from legacy system to Oracle using the Loader and interface programs. Inbound and Outbound Interfaces like Customer.
• Master Conversion and Conversion of Open AR Invoice program to load data into Oracle.
• Tested the functionality of auto-invoicing, auto lockbox and Credit Card processing.
• Post go-live production support was provided to resolve the issues
• Created custom responsibilities to which were attached specific menus, forms and reports for related security access.
• Prepared and provided the functional specs like BR-100, MD-50, MD-70 and TE-40.
• Involved with Unit testing ,Integration testing for different AP/AR /PO process

Environment: Oracle Financial 11.5.10, Oracle Loans, Oracle 8i, PL/SQL, SQL, SQL Plus, Toad, Windows NT/2000, Rational Test Manager, Clear Quest, Oracle Reports/Forms 6i, Tracking System, Power Point.

Confidential,Westminster, CO Mar 07 Jan 2008
Oracle Technical Functional Consultant
.
Requisite Software is a leading provider of ecommerce and channel Management solution. This Project was full implementation and customization of application from 11.5.4 to 11.5.10 involving various modules such as AP, AR, PO, GL and OM.

Tasks handled

• Implementing Oracle AP, AR, GL modules to meet Business requirements of the client.
• Developed scripts for custom tables, indexes and sequences
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL procedures, reports as concurrent programs.
• Used the System Administrator responsibility to create users responsibilities, Value sets and Request sets.
• Customized payment term listing reports for collections with XML Publisher.
• Used Standard Oracle API’s to submit concurrent requests from PL/SQL.
• Involved in writing INV Net Material Transaction Extract Outbound interface program. Net transaction quantity can be extracted one time only on daily basis without any duplicates from Base Tables (Transactions, Receipts and Adjustments) into Data File using UTL_FILE.
• Involved in AP open invoices conversion from legacy to Oracle Payables.
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Involved in writing Package to extract data from Legacy System, validated and imported into Journal Import Interface tables and submitted a concurrent request to populate base tables.
• Created End User Layer and Business Areas using Discoverer Administrator.
• Created workbooks in Oracle Discoverer for trend analysis and reporting purposes.
• Coordinated Knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.
• Developed Various Reports in PO and AR Modules and customized them using XML Publisher.
• Created and modified reports using Reports 6i which includes creation of new parameters, fields, columns etc and bug fixes, enhancement requests etc.
• Involved in discussion documents and suggesting modifications. Also involved in creating technical documents and testing specifications for every functional specification.

Confidential,TO,Canada Mar 06 May 2007
Oracle Technical Consultant

was to support of various Oracle Financials modules like Oracle Payables, Receivables, Purchasing and Order Management.
Roles and Responsibilities:

• Worked on a Custom Form for supporting the Operating Unit Level Restriction on Payables. A custom.pll was also used to restrict the user access on the Query, modification and creation of the records in standard screen or Payables modules i.e. Payments, Invoices and Internet Bank Account
• Involved in Bank Conversion program to upload bank details using direct insertion approach.
• Worked on payables interface which picks the Data from the Custom screen (OAF screen where user enters the data after the goods are received) and after validating the data is populated in the Interface table and error are displayed in the Log Output File.
• Summary of accrued and earned Interest Report By using XML-Publisher.
• Setup customization of Incentive compensation, compensation policies, compensation structure, sales force management, Modeling Contract Agreements in Oracle
• Developed technical document M D-070 for forms and interfaces.
• Interacted with users and analyzed their requirements to develop custom code, forms and reports as per the need and registered with application.

Environment

• Oracle E-Business 11.5.7 (AP, PO, AR and OM), PL/SQL, Forms 6i & Reports 6i, XML Publisher

Confidential, San Diego, CA Jul 2005 Apr 2006
Techno Functional Consultant

National pen is the direct marketing company specialized in manufacturing of office stationary product. It is one of the largest direct marketing companies in the world in its niche. The company upgraded to Oracle 11i and integrated some of the legacy systems and streamlined all business processes under one umbrella of Oracle.

Roles and Responsibilities:

• Upgrade of Oracle financial modules and re-implementation of Oracle receivables.
• Discussion, negotiation with bank of America to implement lockbox for European operations
• GAP Analysis, process mapping, training of end users and setting up new business processes in Oracle.
• Upgrade of incentive compensation module in Oracle. This mainly included, Sales force, OPM, ,management, sales quota allocation to sales force , Configuring contract agreements, responsibilities, user access policies, tables mapping, rate formula, rate dimensions and compensation policies.
• Worked with developers and DBA team, to translate business needs into technical deliverables.
• Setup of On Demand Invoicing features, Configuration and implementation of fixed assets, XML Gateway transmissions in Oracle AP.

Environment: Oracle E-Business 11.5.10.2, TOAD, SQL Plus, Forms/Reports, HPUX

Confidential,TO,Canada Aug 2002 June 2005
Support Analyst

As part of a process improvement drive, the company initiated their FSRP (Financial Systems Replacement Project), which included Application Development and Support of Oracle Financials applications.

• Evaluated the design and development needs of the client, writing functional specifications, debugging and testing, functional support and issue resolution which adhere to GAAP Accounting Principal.
• Executed best practice business procedures and processes in application analysis and design. Designed custom interfaces, process and reports to meet client’s requirements in General Ledger, OM.
• Report any functional gaps in existing applications and suggest business process improvements.
• Work with the on-site functional lead for functional enhancements & application design documentation
• Global implementation GIS
• Creation of implementation plans for consolidating multiple GL set of books and multiple operating units.
• Conduct a study of the current GE’s applications and GE’s customer specific business rules and practices, user requirements and preparing specifications in the area of integrated General ledger
• Reported any functional gaps in existing applications and suggest business process improvements.
• Setting up depreciation and corporate tax books,
• Set-up different calendars (depreciation)
• Implemented MRC feature
• Intercompany invoicing

Environment: Oracle financials, Purchasing, OPM, Project Accounting. 10.7 S.C, 11 x., Install base, Citrix, Quest tools, Oracle 8i, PL/SQL, SQL, SQL Plus, Toad, F.S.G, SQL Loader, Windows NT/2000.