SUMMARY:

• Directed, Managed, Implemented, Resolved, Trained and Supported Oracle Business Applications for multi - billion and multi-national corporations over twenty (20) years from Oracle 10.5 to Oracle 11 (series) and Oracle Business Suite 12.2.4. General Ledger (GL), Payments and Payables (AP), Receivables (AR),Fixed Asset (FA), Order Management (OM), Inventory (INV), iProcurement, Purchasing (PO), Cash Management, EBTAX and Vertex, Sub Ledger Accounting (SLA), Oracle Procure to Pay (P2P), and Projects.
• Oracle Supply Chain Management (SCM), Acquire to Retire, Procure to Pay, FRED, AGIS, GRC, Web ADI and Financials in the Manufacturing Industry.
• Over Twenty (20) years of consulting experience in Information Technology, business and financial analysis.
• Over Twenty five (25) years’ experience in accounting and business with multiple set of books and financial management.
• Industries: Information Technology, Manufacturing, Financial Services, Healthcare, Communication, Pharmaceutical, Automobile, and Retail, with International business operations.
• IT focused, hardworking, resourceful, highly analytical, friendly, achiever, goals and result driven
• Good communication and presentation skills. Work well with others.

TECHNICAL SKILLS:

BUSINESS APPLICATIONS: Oracle (10.5-12.2.4 ) GL, SLA, FA, A/P, A/R, PO, OE, Inv, iProcurement, WebCenter.

PROGRAMMING: Toad, html, Oracle SQL

DATABASES: Oracle 7/8 and 8i, Access

ORACLE BUSINESS PROCESSES: Procure to Pay, Acquire to Retire, MDM, Business Intelligence and GRC

SPREADSHEETS: MS Excel, QuattroWORDPROCESSORS: MS Word, WordPerfectPRESENTATIONS: MS PowerPoint, Freelance, Harvard Graphics

OTHERS: MS Project, Visio, Internet, Email

PROFESSIONAL EXPERIENCE:

Confidential

Lead Oracle Quality Analyst & Business Analyst

• Reviewed the requirements gathering and analysis by PWC team, and advised on best business practices or business process re-engineering.
• Providing assistance and reviewing the process of changing setup configuration to a multi-org structure with Advance Global Intercompany System AGIS and Master Data Management (MDM).
• Helping and assisting management team to prepare test cases and business scenarios for testing
• Executingand providing support for the execution of various tests and scenarios for CRP’s and UAT.
• Identifying and Reporting defects to appropriate persons or team and and updating HP ALM Quality Center.
• Monitoring and tracking defects with the developers and technical team (PWC) and updating test status
• Assist with the Setup, configuration and integration of Supply Chain Management (SCM)
• Assist with the Setup, configuration and integration of Procure to Pay (P2P) System
• Assist with the Setup, configuration and integration of Acquire to Retire (A2R) System
• Integration and customization of third party applications such as AOL, Image Now, Vertex (now an Oracle application)
• CRP and UAT Testing.

Confidential, Peachtree City, GA

Oracle Application Functional Team Lead

• Payable setup and upgrade for different set of books: payment terms, Purchase Order / Invoice matching (2, 3, or 4 way), payment options, and Invoice Distribution.
• Define payment terms, purchase order matching tolerance, tax names, distribution sets, quick codes, financials and payable options and programs
• Payment Processing such as Invoice Validation, Payment Process Requests, AP Trial Balance, Aging Report and interface issues
• Support Payable and resolve complex issues related to Invoice and Batch processing.
• Support and track Payable transactions from across different ledgers / modules and interfaces
• Track transactions or data flow from different modules (Asset, Inventory, Account Payable and Account Receivable) to the Sub Ledger Accounting (SLA) and into the General Ledger.
• Upgrade of Oracle Business Suite (EBS) 12.0.2 to 12.1.2
• Documented business procedure and gather business requirements for the upgrade.
• Identified reporting and information access requirements.
• Analyzed, prepared and mapped business requirements with data.
• Defined application setup and security profiles.
• Prepared and reviewed functional and technical designs.
• Defined and prepared data conversion.
• Defined documentation requirements and strategy
• Defined testing requirements and strategy.
• Defined, prepared and conduct performance testing.
• Conducted on-line or video training.
• Setup applications
• Organized and worked with team of people worldwide to setup EBTAX for different Operating Units across Multi-Org Structure.
• Provide cross functional knowledge and information and compare Oracle EBTAX and Vertex and help both IT and User and executives make decision between the two systems.
• Document the production processes, procedures, and interfaces, which enabled the development of a series of recommendations to stabilize and/or improve the monthly closing process.
• Open or filed Service Requests with Oracle to resolve problems with bugs, patches or datafix; and worked with Oracle Analysts or/ and Development to resolve complex problems with the Oracle Applications (E-Business Suite).
• Download, review, test and apply patches or data-fix supplied by Oracle in different instances before applying them to Production.
• Run and test scripts on the backend to resolve some processing or functional issues.
• Resolve problems or resolve corrupted data and clean all the interfaces to improve performance.

Confidential, Atlanta, GA.

Oracle Application Consultant - Project Manager

• Responsible for managing the financials track on client engagements
• Interviewed client personnel to determine requirements to create business process models based on the requirements
• Gather business requirements, prepare, review and update functional and technical specifications.
• Worked extensively to implement Oracle applications specifically related to the Procurement and Payables, Accounts Receivable, FA, iExpense, iSupplier modules.
• Worked with a wide variety of clients and industries, from start-ups to multinational Fortune 100 companies
• The engagement included developing business and system requirements for re-engineering the financial consolidation processes to meet the needs of the newly merged entities.
• Identified and helped to gather data for the implementation. Setup concurrent requests for customized programs.
• Set up and tested Oracle GL - Journal Import, AP - Invoice Import, PO Purchase Order Import & CE - Bank Statements. Used TOAD for investigating errors generated from file transfers to Oracle apps, update Apps tables.
• Update PL/SQL procedures and packages to extract, validate and insert data into interface tables
• Documented the production processes, procedures, and interfaces, which enabled the development of a series of recommendations to stabilize and/or improve the monthly reporting process.
• Managed a comprehensive training and education curriculum on Oracle, which covers sales, service, technology product for new hires as well as tenured employees
• Organize the work effort by developing project plans including tasks, deliverables, and due dates.
• Work closely with Marketing, IT, Operations, Risk, and Legal to identify and resolve issues related to introduction of Oracle

Confidential, Atlanta, GA

Project Manager

• Managed the design and implementation of Oracle Fixed Asset for Confidential, CA.
• Setup and implementation of Oracle Fixed Asset.
• Gather business requirements, prepare, review and update functional and technical specifications.
• Organized the work effort by developing project plans including tasks, deliverables, and due dates.
• Reconciled all balances from legacy system with Oracle.
• Documented business process for Self- Service Web Implementation.
• Set up and tested Oracle GL - Journals, Budgets & ADI Journals, AR - Receipts, Transactions, MRC - functionality tested to ensure that it works.
• Designed customized reports using Oracle Developer 6i. Modified and updated Customer Invoices, XML extracts
• Prepared FSG Reports (Trial Balance, Income Statement, Balance Sheet) for reconciliation purposes
• Tracked documents/deliverables for client signoff
• Created Test scripts from functional specifications and assisted users with testing.
• Defect resolution, raise change requests, review and revise test scripts.

Confidential

Senior Consultant

• Conducted business requirement analysis and compared clients’ requirements with the available Oracle functions available with the module (Oracle AP, AR, FA, GL, OM and PO).
• Documented requirement analysis and worked with programmers on technical details.
• Mapped and gapped requirements and specifications; and advised on customization.
• Prepared Chart of Accounts and Set of Books for Single and Multi-organization structures.
• Prepared set-up document and carried out set-ups. Prepared module conversion design specification.
• Prepared module test scripts and participated in CRP testing. Assisted with transfer, conversion and customization of legacy data to Oracle Database.
• Supported Production migration. Carried out integration and performance testing.
• Prepared training manuals and conducted presentations.
• Project leader setup and configuration of Oracle Fixed Asset with MRC set of books for VISA International.
• Assisted with the transfer of Fixed Asset data from different legacy systems into Oracle. Prepared and run test scripts for Fixed Asset module and the integrated systems.
• Worked with DBA's and technical groups to apply patches and help to resolve technical issues with
• Prepared FA documentation and trained Fixed Asset managers and heavy users.
• Held meetings to reconcile Oracle FA balances with different legacy systems.
• Assisted with the implementation of SSP 5.
• Provided support and expert opinion for global implementation of Oracle 11.03 and transfer from 11.03 to 11i.

Confidential, HIGH POINT, NC

Oracle Application Support Specialist

• Provided System Administration function for different application modules (OE/OM, PO, INV., AP, and AR) in Oracle.
• Assigned and modified responsibilities based on job descriptions and trained users on Oracle navigation.
• Reviewed business processes (especially in Order Entry / Order Management) for improvement and efficient business operations.
• Documented new business requirements and worked with programmers on technical details and customizations.
• Researched processing errors and resolved them; including review of bugs, patches and technical reference manuals to resolve different issues.
• Resolved technical and procedural problems on Oracle applications and when necessary log TAR (Technical Assistance Request) with Confidential .
• Collected patches from Confidential Technical Group to fix bugs in the system.
• Resolved processing and data import errors during processing between modules.
• Worked with DBA on system maintenance issues performance tuning, different application and concurrent managers scheduling for OE/OM.
• Assisted different groups (Sales, Accounting and Management) within the organization with issues such as Order entries, scheduling, pick releases, reservations, and departures on Oracle.

Oracle Financial Consultant

• Reviewed and analyzed accounts of subsidiaries in foreign countries.
• Reconciled foreign subsidiaries account with the consolidated GL balances and multi-currency reconciliation.
• Prepared custom reports on Oracle for different business segments and trained employees to use them for making business decisions.
• Prepared monthly activity reports for different business segment with ADI.
• Compared reports with database information. Front and back end analysis.
• Trained staff on how to use Oracle Financial Analyzer (OFA) to report analyzes and create budget, forecast and run financial models.

Confidential, ATLANTA, GA

Oracle Application Consultant

• Evaluated initial implementation of Oracle 10.7 to resolve reporting problems.
• Assisted with the conversion from single set of book to Multi - org structure.
• Analyzed and reviewed business operations to design new chart of account (GL) to reflect the reporting needs of the organization.
• Converted account balances from one set of book into different set of books.
• Trained Executives, CFO’s, and Controllers on the use of GLDI/ADI for budgeting, journals and creating reports.
• Trained accounting staff on navigation and transactions on Oracle GL, A/P, and F/A, and providing help and assistance as help desk.
• Assisted with the preparation of budget data and upload them to the General Ledger with GLDI/ADI.
• Provided classroom training that includes Presentations, Visual Aids, and Manuals for different Oracle Applications.
• Assisted with end of the month closing and prepared actual and budget reports for printing.

Confidential, Atlanta, GA

Oracle Implementation Consultant.

• Conducted business requirement analysis. Compared clients’ requirements with the available functions available with the module (Oracle AP, AR, FA, GL, OE and PO).
• Prepared Chart of Accounts and Set of Books for Single and Multi-organization structures.
• Mapped and gapped requirements and specifications; and advised on customization.
• Prepared set-up document and carried out set-ups. Prepared module conversion design specification.
• Prepared module test scripts and participated in CRP testing.
• Assisted with transfer, conversion and customization of legacy data to Oracle Database.
• Supported Production migration.
• Carried out integration and performance testing. Prepared training manuals and conducted presentations.

Confidential Atlanta, GA

Business and Financial Analyst

• Collected account and financial information for reconciliation Oracle GL and AR (10.5).
• Coordinated the preparation of operating and capital budget.
• Evaluated internal control procedure and policy compliance.
• Formulated strategies for clients to increase market share and profitability.
• Conducted researches and prepared reports to assist clients.
• Analyzed accounts to determine trend and variances with budget.
• Identified potential markets and opportunities.
• Business planning and operational analysis
• Prepared business and financial reports and make presentations.
• Prepared Corporate and Personal income; Sales and property taxes.
• Saved companies from $500,000 to $10 Million in setup and implementation.
• Increased productivity and profitability in accounting department A/R, A/P.
• Saved over one million dollars through effective currency transfer and hedging strategy.
• Introduced programs and policies that support and promote cooperation during implementations.