PROFESSIONAL SUMMARY

skills.

• More than 10 years total experience in the fields of IT Oracle Apps and Finance
• Led Global multiple implementation of AP, PO, iProcurement, iSupplier, OSN Oracle Supplier Network and iExpenses including design, configuration, testing and training United States, United Kingdom, France, Portugal, Belgium, Portugal and Netherlands
• Worked as Oracle Financial Functional Lead Consultant in Analysis, Design and configuring of Finance Modules General Ledger GL , Account Payables AP , Account Receivables AR , Purchasing PO , iProcurement, iExpenses, iSupplier, OSN Oracle Supplier Network Fixed Asset FA
• Knowledgeable in R12 Oracle new functionality, architecture and integration
• Completed hands on training and a warded Certification on Preparing for an Oracle R12 Upgrade and new features
• Provided analysis and presentation on R12 Reimplementation Vs Upgrade
• Prepared R12 upgrade Analysis for Financial Modules GL, AP, AR, PO, FA and Sub ledger Accounting, Ledger, Secondary Ledger and AGIS features
• Led Oracle R12 upgrade implementation
• Developed R12.1.3 upgrade project Plan and Led implementation
• Provided a workshop on R12 Cost Management and Cost Accounting functionality
• Developed R12 Cutover plan and led the same
• Received Oracle Landed Cost Management and Financial Visibility Functionality on Supply Chain Costs
• Configured custom payment system using Gateway processing Model for PPS Princeton Payment Solutions
• Developed R12 Business Cutover plan and led the effort
• Prepared MOAC Mulit-Orag Access Control Analysis/Strategy and implement the same
• Provided best practice advice on global implementation of Oracle E-business Suite and implemented GL, AP, PO, iSupplier, OSN, iProcurement, iExpenses, and third party interfaces
• Implemented Global Accounting Engine AX Schema for France and Portugal Entities to meet statutory requirements
• Implemented Advanced Global Intercompany System AGIS
• Led Exadata and 11g upgrade/migration project
• Knowledgeable of Process of Oracle Logistic Modules i.e. OM and Inventory
• Integrated Project Accounting module with AP, PO, iProcurement and iExpenses
• Implemented Specialized Knowledge in AP Account Payables , PO Purchasing , iProcurement, iExpenses and FA Fixed Asset configurations of Oracle 11i E Business Suite
• Configured iSupplier and OSN Oracle Supplier Network modules and customize the PO Layout to meet specific business needs
• Provided analysis, design, localization installation, and rollout of Oracle General Ledger, Accounts Payable, Fixed Assets, iExpenses and purchasing modules for ASIA China entities.
• Developed a Project Plan for ASIA Roll out and executed.
• Setups FSG Reports for China localization requirement.
• Prepared analysis of Re-designing Chart of Accounting COA and mapping
• Setup new local Chart of Account and mapped to the Global Chart of Account
• Worked on Customization and Development of Forms and Reports under Oracle Apps
• Created different public report folder for the user using Noetix view
• Specialized in Identifying and Improving Process of Finance Control Systems
• Developed and delivered a customer-focused end-user training course for the Purchasing, iProcurement, iSupplier and AP modules
• Expertise Knowledge in Preparation of Process Documentations, Training Materials User Trainings
• Worked on document deliverables: Business requirement definition, mapping business requirement BR.30 , Application Setup document BR.100 , Functional design for custom functionality MD.50 , and Business system testing and so on
• Oracle Apps User Management
• Excellent Analytical and Communication Skills

TECHNICAL SKILLS

• Oracle Applications Versions: 11i, 11.5.10, R12.1.2, R12.1.3
• Oracle Applications Modules: GL, AP, AR, FA, CM, PO, iExpense, iProcurement, OSN, iSupplier, INV OM
• Oracle Tools: Forms 6i, Report 6i, SERENA Data Change Request
• Data Access Tools: SQL Loader, SQL Plus, TOAD
• Reporting Tools: Discoverer 4i, Noetix, FSG, Web ADI ADI
• Software: Microsoft Office MS Access, MS Excel, MS Project , Visio, Rational Rose
• Methodology: Application Implementation Methodology AIM 3.0
• Document Library: Microsoft SharePoint, PVC's, SERENA Data Change Request DCR

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Financial Functional Lead

Environnent: Oracle Applications R12.1.3

Modules: AP, GL, FA, Cost Management, AR, CM, iExpense,iProcurement, INV, PO and Oracle Payments

Responsibilities:

• Directly responsible for the Configuration of Finance Modules- General Ledger , Account Receivable, Account Payables AP , Purchasing, iProcurement, iExpense modules setup in Multi-Org environment
• Responsible for Project implementation update and Communication of the weekly highlight reports this week accomplishments, open issues, upcoming activities and so on to the Global Project Manager and Senior Directors including CFO
• Acted as a liaison with the Offshore Development team and Oracle On-demand in relation to development, patches and new instance configuration.
• Implemented payment module, Account payables and R12 XML based Check printing process
• Integrated Receivables, Order Management, Purchasing and Cost Management modules effectively with General Ledger
• Designed custom Check printing layout as per JP Morgan Chase Bank and Wells Fargo Bank specification using XML Temple/BI Publisher
• Designed custom ACH payment as per PNC Fargo Bank specification using XML Temple/BI Publisher
• Implemented Automated transmission between K12 and PNC Bank
• Configured Custom Positive Pay layout as per PNC Bank Specifications
• Used Cost Accounting functions and integrated Cost Management, Order Management and Receivable Modules to accurately recognize COGS.
• Setting up of auto Bank Reconciliation process via CM Cash Management and the ability to clear payments and receipts before Reconciliation with PNC Bank and Bank of America
• Provided iSupplier functionality training for the new Sister company users
• Setup iSupplier for the new Sister company Operating units
• Building up Vendor and Invoices Interfaces from non-Oracle systems
• Functional design and Build up automated tool for vendor and vendor bank data upload. The purpose of this tool is to import Vendor and Vendor Bank file online the user will import new suppliers through this tool
• Created end user training manuals and perform end user training
• Configured complete CM Cash Management module
• Worked on Reports for customization as well as well development of new reports
• Building up Bank Interfaces and EFT ACH Payment Processing
• Design and Delivery of User requirements workshops covering General Ledger, Receivables, Payables, Order Management, Cash Management and Receivables
• Implemented custom iExpense and iProcurement workflow solution
• Aware of Supply Chain Concepts and its effective utilizations to Improve Business Process
• Setup iprocurement and iExpense modules for new Sister company and integrated with the financial module
• System Integration tests: Preparing System Testing Environments Preparing system test procedures, Extracting Data for Testing, Loading Data into Test Environment
• Worked on document deliverables: Business requirement definition, mapping business requirement BR.30 , Application Setup document BR.100 , Functional design for custom functionality MD.50 , and Business system testing
• Interacted with top management and users to understand functional specifications
• Reviewed Business Processes, Initiated Setups, Developed and Executed Test Scripts, and Delivered Training
• Resolved lingering R12 Finance issues

Confidential

Senior Oracle Financial Functional Lead

Environnent: Oracle Applications R12.1.3

Modules: AP, GL, FA, PO, iProcurement, iExpense, Subledger, iSupplier and Oracle Payments

Responsibilities:

• Implemented Blanket Purchase order processes for Service related expenses
• Resolved lingering R12 Upgrade issues iProcurement, Payables and Payments issues
• Configured iProcurement and Purchasing modules and manage them as per changing business needs and provide functional and technical support and act as a liaison between business users and technical experts
• Provided production support and work with Technical team to address production support issues
• Setup new payment Check payment process for multiple Operating units
• Reviewed Sister company Purchasing and iProcurement Setup and Provided best practice solutions
• Prepared test Scripts for resolved issues
• Provided iSupplier functionality training and best practice
• Setup new Wire payment process for the new operating units
• Configured or Added new iExpense rules
• Ensured configuration setup is in line with the approved BR100 document
• Review and Setup ACH payment process
• Configured New functionalities in Account payable, payment, Purchasing, General

Ledger and Receivable Module modules

• Worked actively to trouble shoot problem and resolve upgrade and production support issues.
• Prepared required documentations as per the Company policy and Sox requirement- Eg: TE20, MD120 Documentations

Confidential

Senior Oracle Financial Functional Lead

Environnent: Oracle Applications R12.1.3

Modules: AP, GL, FA, AR, OM, CM, iExpense, Subledger and Oracle Payments

Responsibilities:

• Resolved lingering R12 Upgrade issues
• Configured Oracle applications and manage them as per changing business needs and provide functional and technical support and act as a liaison between business users and technical experts
• Provided production support and work with Technical team to address production support issues
• Pro-actively interacted with client to understand their business practices and configure the system accordingly
• Setup new payment Check payment process for multiple Operating units
• Prepared test Scripts for resolved issues
• Setup new Wire payment process for multiple operating units
• Resolved lingering iExpense issues
• Setup new Project related Expense Report and Expense Type
• Configured new iExpense rules All project related iExpense to required receipt attachment regardless of the expense amount
• Ensured configuration setup is in line with the approved BR100 document
• Setup ACH payment process
• Resolved iExpense approval and integration issues
• Configured New functionalities in Account payable, payment, Purchasing, General

Ledger and Receivable Module modules

• Resolved custom report issues
• Worked with Oracle support to resolved a complex issues
• Worked actively to trouble shoot problem and resolve upgrade and production support issues.
• Prepared required documentations as per the Company policy and Sox requirement- Eg: TE20, MD120 Documentations
• Responsible for functional support of Oracle Financial Application System.
• Coordinated with the business users, technical IT teams, management and outsourced DBA partners.

Confidential

Senior Oracle Financial Functional Lead

Environnent: Oracle Applications R12.1.3

Modules: AP, GL, FA, AR, OM, iExpense, CM, Subledger and Oracle Payments

Responsibilities:

• Configured New functionalities in Account payable, payment, Purchasing, General Ledger and Receivable Module modules
• Provided R12 new functionality and process workshop
• Designed custom Check printing layout as per JP Morgan Chase Bank and Wells Fargo Bank specification using XML Temple/BI Publisher
• Designed custom ACH payment as per JP Morgan Chase and Wells Fargo Bank specification using XML Temple/BI Publisher
• Implemented Automated transmission between Tramontina and Bank
• Configured Custom Positive Pay layout as per Bank Specifications
• Implemented custom check printing process in a blanket check stock
• Provided workshop and training on R12 Cost Management and Cost Accounting functionality
• Configured iExpense Module for corporate Operating units
• Implemented Cost Management module and used different Cost Accounting for Sister Manufacturing organization
• Implemented intercompany in consideration with Cost Accounting material transfer from one location to another where house
• Implemented Employee supervisor iExpense approval hierarchy
• Ensured configuration setup is in line with the approved BR100 document
• Implemented 45-30-5 days Cash Forecasting template and new cash forecasting process
• Provide Fixed Asset workshop and potential solutions
• Setup Cash Management module and Auto Reconciliation JP Morgan and Wells Fargo Bank
• Delivered MD.50 Functional Design for custom objects
• Delivered Business requirement definition, mapping business requirement BR.30 , Application Setup document BR.100 , Functional design for custom functionality MD.50 , and Business system testing and so on
• Implemented Intercompany Invoicing for internal requisition and internal sales order
• Customized positive pay using XML Template/XML Publisher as per Bank specification JP Morgan Chase and Wells Fargo Bank
• Defined new tax code and resolved EBusiness tax issues
• Designed Custom AR invoice print Layout using XML Publisher for two different entities
• Customized General Ledger, Payables, Receivables and Cash Management reports
• Provided workshop on how to create Budget Organization, Create and maintain Budgets in Oracle
• Implement and integrate Cash Requirement report with payment template
• Resolved financial reporting issues
• Provided Post GO-LIVE /Upgrade production support
• Provided Finance Module training
• Delivered training documents R12 new processes and custom processes

Confidential

Senior Oracle Financial Functional Lead

Environnent: Oracle Applications R12.1.3

Modules: AP, GL, FA, AR, OM, CM, iExpense, Sub ledger and Payments

Responsibilities:

• Configured Account payable, iExpense and payment modules
• Configured Fixed Asset modules
• Configured custom payment system using Gateway processing Model for PPS Princeton Payment Solutions
• Delivered Business requirement definition, mapping business requirement BR.30 , Application Setup document BR.100 , Functional design for custom functionality MD.50 , and Business system testing and so on
• Developed a custom refund process for historical transactions - Auto refund process from OM AR AP
• Worked with the OM, AR, AP, Inventory and Oracle payment on fund capturing , refund and Payment
• Designed custom Check printing layout as per Bank of America and Commerce Bank specification using XML Temple/BI Publisher
• Implemented iExpense for new 6 - sister companies
• Designed custom ACH payment as per Bank of America and Commerce Bank specification using XML Temple/BI Publisher
• Setup and integrated third party credit and debit card fund capturing process using Gateway
• Setup and integrated Oracle R12.1.3 and Princeton Payment Solutions Implemented CardConect payment card gateway PPS Payment System
• Setup Cash Management module and Auto Reconciliation Bank of America and Commerce Bank
• Customized positive pay using XML Template/XML Publisher as per Bank specification Bank of America and Commerce Bank
• Developed Fixed Asset Mapping, used web adi to convert fixed Assets
• Used Submit Offline Transaction SOT to process credit card settlements

Confidential

Senior Oracle Financial Functional Lead / Project Manager

Environnent: Oracle Applications 11.5.10.2 and R12.1.3

Modules: AP, PO, GL, FA, AR, CM, Subledger and Payments

Responsibilities:

• Led Oracle R12.13 upgrade Project - Functional Assessment, Technical Assessment, Application Techstack Assessment , existing system Pain points and R12 upgrade
• Led discussion on R12 new functionality, features, architecture changes and upgrade Analysis
• Developed R12.1.3 upgrade project Plan
• Developed R12 Cutover plan and led the same
• Developed R12 Business Cutover plan and led the effort
• Redesigned several standard reports to serve important business processes very specific to the client. Such reports include Customer, Receipts, Invoice, Aging, Account Analysis reports and adjustment reports.
• Configured AP, AR, GL, PO, INV, CM, Payment and Subledger Accounting modules
• Implemented third party custom Check Printing Submission from R12.1.3
• Redesigned and documented an inbound and outbound AR/GL/AP interfaces.
• Worked actively to trouble shoot problem and resolve upgrade and production issues.
• Implemented Advanced Global Intercompany System as per the client requirement Invoicing not required
• Redesigned FSG's, Aging reports, Invoice reports, Supplier reports, payment reports, posted reports.
• Prepared Re-designing of Chart of Accounts COA analysis
• Developed Mapping and value definition strategies
• Developed/Changed 5 segments Chart of Account structure to 7 Segments structure
• Created Multiple Payment Process Request and automate R12 payment transmission Process
• Designed new Electronic payment templates NACHA using XML Template/ publisher
• Setup R12 Check payment Process
• Customized and configured Separate Remittance Advice using XML Template/Publisher
• Setup AR generates late charge calculation and late charge transaction type/method
• Designed new AR Statement layout using XML Template/Publisher
• Designed new Dunning letter layout using XML Template/ Publisher
• Implemented Subledger Accounting SLA
• Provided R12 new functionality training
• Customized positive pay using XML Template/XML Publisher as per Bank specification Chase and PNC
• Implemented SOD Segregation of Duties in R12 environment
• Implemented new/changed business process
• Implemented eBTAX E-Business Tax
• Redesigned RICEW objects and Created new XML based reports
• Involved in Design, Development and Customization of OAF Framework Pages.
• Setup new Web-ADI GL Journal and Budget Layouts
• Led Exadata and 11g upgrade and migration project