CSUMMARY:

• Confidential has over ten years of extensive experience helping to deliver organizational transformation with Oracle solutions such as Oracle Cloud, Oracle R12 and Oracle GRC.
• Confidential has experience in requirement definition, evaluation, selection and implementation of financial system solutions, business process reengineering, functional specification on RICEFW elements, procedure documentation, testing, training and support of enterprise financial and system administration modules, Confidential has completed more than six full - life cycle implementing Oracle solutions across different industries.
• Confidential has substantial experience leading teams, managing budgets, increasing revenue, identifying new opportunities and managing resources.
• He has delivered several of his engagements in a leading role managing onsite and offshore resources with on time delivery, as well as project and status reporting.
• Confidential has strong experience implementing Oracle Cloud and R12 versions of Oracle application, documenting, gathering business requirements, designing and reviewing business processes and process flows, testing, training and identifying gaps in the Oracle application.
• Confidential has in-depth knowledge of Oracle core financial, procurement and supply chain management modules for public and private sectors as well as global leading industries.
• He has also delivered Oracle cloud security, several SOX and IT data control assurance.

ERP SKILLS:

• Oracle Financial Cloud, Oracle Identity Manager (Admin), Oracle GRC, Oracle EBS Financials Suite: R12 / 11i, SAP FICO, IBM Maximo Asset Management - 7.5, and SABRIX
• Procure to Pay, Record to Report, Acquire to Retire, and Invoice to Cash

TECHNICAL SKILLS:

Oracle Modules: General Ledger (GL), Oracle Fixed Assets (FA), Account Payables (AP), Purchasing (PO), Account Receivables (AR), Cash Management (CM), Subledger Accounting, Oracle GRC, Oracle IDM, XML Publisher, Functional Administration, and System Administration.

Software & Tools: Oracle Unified Method (OUM), DataLoad, SQL*PLUS, SQL LOADER, Application Desktop Integrator (ADI), Financial Statement Generator (FSG), MS Word, Visio, PowerPoint, Excel, Project and Publisher.

Languages: PL/SQL, HTML, DHTML, ASP, Power Builder, Visual Basic and JavaScript.

Relational Database: Oracle RDBMS V8 and V9, MS SQL Server and MS Access.

Operating Systems: UNIX, LINUX, Windows NT, Windows Enterprise.

CORPORATE EXPERIENCE:

Confidential

Responsibilities:

• Performed the operations analysis of the business process and requirements, developed models and process flows for each business process.
• Performed mapping and gapping analysis and produced the initial version of documentation using the Oracle and proprietary methodology templates
• Configured All Common Financial setups for enterprise structures and other financials applications, created locations, business units, geographies, data template roles, Oracle Identity Manager(OIM), Sync Processes, user account creation, Reference data sets creation and assignment to the business units
• Oracle Identity Manager (OIM) to manage users and roles assignment
• Configure Fusion Functional Setup Manager and define Applications Configurations
• Managed Oracle Cloud General Ledger configuration - Value sets, COA Structure and Instance, Accounting Hierarchy, Create Account Combination, Define Cross-validation Rules, Calendar, Currencies, Conversion Rates Type, Daily Rates, Ledger, Ledger Options, Legal Entities and Balancing Segments Assignments, Complete the Ledger Configuration, Data Access Set Security, Allocation Rule an Account Group. Business Units Reference Data Sets and Configured Fusion Subledger Accounting.
• Managed Oracle Cloud Accounts Payable Configuration - Supplier Model, Data Role, Create Payment Term, manage invoice options and payment options, Payments Activities, Payment System, Payments and submitting a payment process request.
• Managed Oracle Cloud Accounts Receivable - Receivable Activities, Receivables System Options, Receipts, Customer and Profile Class. Payments for funds Capture Activities, Setting-Up Funds Capture for Receivables
• Prepared reusable templates such as BR100 and MD50 documents.
• Designed and updated business process flows, and end users training documentation
• Managed CRP and SIT cycles, and UAT testing
• Built financial statements such as balance sheet and income statement using financial reporting studio (FRS), extensively worked on Smart View. Setup and installation of ADF desktop Integrator, Smart View and FRS on user's machines
• Implemented Oracle Expense, Oracle Fixed Asset and Oracle Cloud Cash Management, as part of the enterprise financial implementations, enterprise performance manager (EPM)
• Performed loading conversion data using external data integration functionality by populating spreadsheet templates, loaded suppliers, payables invoices, journals, budgets, cash management external transactions, COA values and hierarchy, code combinations etc.
• Provided senior level expertise on decisions and priorities regarding Role Based Access Control (RBAC)
• Worked with members of the application development teams to design and integrate applications with Role-Based Access Control system (RBAC)
• Managed and Implemented Oracle Governance, Risk and Compliance products (AACG, CCG and TCG).
• Reviewed the Segregation of Duties (SOD) controls, and developed operational compliance and security provisioning processes.
• Assisted clients in mitigating SOD conflicts and ensured compliance to the Sarbanes-Oxley Act.
• Developed Risk Control Matrix for Oracle Advance Control
• Configured controls to be SOX compliant and passing both internal and external audit deficiency previously identified.
• Collaborated with audit in designing mitigating control for SOD violations.
• Carried out User Acceptance Training (UAT) of key and non-key Oracle controls and provided major deliverables to clients at the end of key project phases.
• Involved in the requirement gathering process, recommended best practices and participated in the design of various access points.
• Responsible for carrying out the validation process of the AACG Suite.
• Worked on projects as a functional expert in responsibility redesign and Segregation of Duty (SOD) detection and prevention.
• Advised project team on design of various access points while recommending best practices during requirement gathering.
• Supported cross-functional teams in designing SOD rules at the entitlement, model and control levels according to client specific goals objectives.
• Helped clients with the remediation process including but not limited to report generation, incident analysis and clean-ups. Performed end user training and documenting procedures for all related Oracle GRC processes and controls.
• Performed the operations analysis of the business process and requirements, developed models and process flows for each business process.
• Performed mapping and gapping analysis and produced the initial version of documentation using the Oracle and proprietary methodology templates
• Delivered a multifunctional Procure to Pay, Order to Cash, Acquire to Retire shared service system by assigning additional operating units to the payable and receivables responsibilities and book to assets to specify how payables, receivables and asset control access to and processes data.
• Coordinated intercompany integration between supply chain management and Procure to Pay.
• Defined ledgers (COA, calendar, currency and subledger accounting method) for client’s U.S. legal entity and international legal entities using U.S. GAAP and Local GAAP (China, Mexico, Singapore, India legal entities with Release 12 functionalities).
• Used the account setup manager functionality to assign balancing segment values to a ledger, define rules to generate accounting entries from subledger transaction, define and maintain operating unit for primary ledger, define intercompany account to account for transactions across legal entities, define and maintain accounting and reporting sequencing options for ledgers and reporting currencies.
• Defined data access set to restrict access to ledger definitions and assign to a responsibility.
• Design and develop a simple time effective Multiorg Access Control (MOAC) system in a complex business environment.
• Defined business group, legal entity (Legal Entity Manager), operating units, inventory organizations and asset organization.
• Defined multiple accounting representation using Subledger Accounting (SLA)
• Defined event class and event type in addition to Oracle’s already defined event class and types.
• Defined additional journal entry rules for transactions and event of a subledger using accounting methods builder.
• Defined and recommend area of improvement on how the new functionality of Oracle Release 12 will improve efficiency for General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, iExpense and iProcurement
• Performed the operations analysis of the business process and requirements, developed models and process flows for each business process area or workstream.
• Performed mapping and gapping analysis and produced the initial version of documentation using standard and customized methodology templates.
• Created the setup documents using standard and customized templates.
• Created functional specification document for custom requirements.
• Defined Business Group, Legal Entity (Legal Entity Manager), Operating Units, Inventory Organizations and Asset Organization.
• Defined financials options and defaults used for Oracle Financial Applications, defined payables options to set control options and defaults used throughout Payables. Defined payment terms to create multiple scheduled payment lines and multiple levels of discounts.
• Defined banks. Internal banks for receipts and disbursement account, Supplier banks for the client’s suppliers, Clearing Houses to record firms that process electronic versions of the clients receipt information.
• Defined purchase order matching and tax tolerances to allow for variances between invoice, purchase order, receipt, and tax information.
• Coordinated Intercompany transactions between Supply Chain Management and Procure to Pay.
• Defined Asset Book Controls and assigned Ledgers for global usage while ensuring data is segregated by entity and operating units, defined System Controls and designated the oldest date placed in service. Defined locations. All possible combinations of physical locations that are valid for the client were defined. Defined the Calendars (Depreciation and Prorate) for each depreciation book, to break down the fiscal year into accounting periods.
• Developed test scenarios and wrote test scripts.
• Coordinated Conference Room Pilot and User Acceptance testing, including Unit, Integration, Interface and performance.
• Supervised Live Production of the module and provided Post-Production Support.

Confidential

Manager of Financial Systems

Responsibilities:

• Led the implementation and phase roll out for Oracle 11i, Formscape, Markview and Sabrix to Confidential managed and owned properties within North America, Canada and the Caribbean.
• Implemented a Change Management strategies for the entire Shared Service Center relating to technology change, SDLC, development and enhancement, fixes etc of all enterprise application including Oracle, Markview and Sabrix
• Manage a team of 16 offshore (India) and onsite functional and technical analysts / consultants including support and development team.
• Designed the Confidential File Transfer System to upload Point of Sales and Property Management (POS and PMS) data to Oracle to create Income Journal and Accounts Receivable transactions.
• Implemented BAI solution (Banking Administration Institute) to load bank statements/transactions into Oracle Cash Management and automated the reconciliation process.
• Implemented an Automatic Receipt and Automatic Remittance process. The process automatically creates receipt and debit properties’ bank account for services rendered at the Shared Services.
• Served as a functional specialist in a project team lead role whose focus is the effective and efficient delivery of financial services using the Oracle Application.
• Researched and benchmark financial practices of other hospitality and financial service organizations.
• Analyzed special departmental procedures and information systems to determine the most feasible and cost effective methods to develop automated business processes, reports and operating processes utilizing Oracle-based ERP and complimenting systems.
• Served as a functional team lead during pre-implementation, implementation, post implementation, interfaces, conversions, Financial Application Extensions, patches, patch testing and system upgrades; sets up new Financial Application business needs, such as but not limited to descriptive flex fields, special information fields, and regulations, for Financial Application user groups involved in the accounting function, and implements advanced functions within the software program within established parameters.
• Identified functional needs of users involved in the accounting function, and subsequently determined the capability of the ERP to meet the needs of the user, keeping in mind increased efficiency, improved decision-making and achievement of the objectives outlined in Confidential ’s organizational scorecard.
• Reviewed current functional procedures, and researches alternative methods of problem solution, and acts as technical advisor in developing functional requirements for new or improved information systems.
• Created and delivered customized reports that affects financial reporting and decision making, participates in a management and employee education programs to explain services available and improvements in operating efficiency possible through use of information systems technology.
• Directly supported Financial Application End Users, managed application errors, bugs and SRs with Oracle MOS and month-end close. Research problems and identifies solution or work around to facilitate business functionality to end users.

Confidential

Oracle Accounts Payable, General Ledger

Responsibilities:

• Performed the operations analysis of the business process and requirements, developed models and process flows for each business process.
• Performed mapping and gapping analysis and produced the initial version of documentation using the Confidential Delivery Methodology (ADM) templates
• Assigned primary Ledger to Payables responsibility for the client to record transactions.
• Used the System Administrator’s responsibility to assign a responsibility to an Operating Unit.
• Delivered a Multi-Functional Payables Shared Service system by assigning additional Operating Units to the Payable responsibility to specify how Payables controls accesses to and processes data.
• Defined financials options and defaults used for Oracle Financial Applications, defined payables options to set control options and defaults used throughout Payables.
• Defined purchase order matching and tax tolerances to allow for variances between invoice, purchase order, receipt, and tax information.
• Defined payment interest rates that Payables uses to calculate and pay interest on overdue invoices.
• Defined some additional payment formats needed to define payment documents in the banks window.
• Supervised Live Production of the Module and provided Post-Production Support.
• Defined and recommend area of improvement on how the new functionality of Oracle Release 12 will improve efficiency for Account Payables, Cash Management and Fixed Assets.
• Defined Ledgers (COA, Calendar, Currency and Subledger Accounting Method) for client's US Legal Entity and International Legal Entities using US GAAP and Local GAAP (China, Mexico, Singapore, India Legal Entities with Release 12 functionalities).
• Defined value sets, key Flexfield segments and roll-up groups with security and cross validation rules
• Used the Account Setup Manager functionality to assign Balancing Segment values to a ledger, define rules to generate accounting entries from subledger transaction, define and maintain operating unit for primary ledger, define intercompany account to account for transactions across legal entities, Define and maintain accounting and reporting sequencing options for ledgers and reporting currencies.
• Defined Data Access Set to restrict access to Ledger definitions and assign to a responsibility.
• Defined Accounting Periods, Automatic Posting, Journal Sources, Journal Categories, Suspense Accounts, and Summary Accounts
• Defined Mass Allocation Formula
• Design and develop a simple time effective Multi-Org Access Control (MOAC) system in a complex business environment.
• Defined Business Group, Legal Entity (Legal Entity Manager), Operating Units, Inventory Organizations and Asset Organization.
• Defined multiple accounting representation using Subledger Accounting (SLA)
• Defined Event Class and Event Type in addition to Oracle’s already defined Event Class and Types
• Defined additional Journal Entry rules for transactions and event of a Subledger using Accounting Methods Builder
• Defined Journal Line Type, Account Derivation Rules, Journal Entry Description, Journal Line Definition, Application Accounting Definition and Subledger Accounting Method.
• Validated the configuration of the application against the setup document.
• Analyzed and mapped the client's requirements into Oracle FA applications.
• Identified and analyzed the gaps by suggesting solutions.
• Carried out the setup of Oracle FA Application.
• Defined Asset Book Controls and assigned Ledgers to US, India, Singapore, Mexico and China Responsibilities
• Defined the System Controls and designated the oldest date placed in service.
• Defined locations. All possible combinations of physical locations that are valid for the client were defined.
• Defined the start and end date of each Fiscal Years since the oldest date placed in service.
• Defined the Calendars (Depreciation and Prorate) for each depreciation book, to break down the fiscal year into accounting periods.
• Mapped the legacy fields into the Mass Additions Table and supervised conversion.
• Wrote the FA Test scripts. Carried out CRP testing, including Unit, Integration, Interface and performance.

Confidential

PeopleSoft 8.4 Accounts Payable, Fixed Asset

Responsibilities:

• Updated and defined additional setup steps in the configuration work book
• Defined Business Unit to assign new Asset.
• Defined Asset Categories, Asset Books, Cost Type, Depreciation Schedule, Depreciation Limit, Depreciation Terms Definition, Asset Profile and Payment Schedule.
• Reviewed and update already set Profile Options for installed PeopleSoft Asset Management application to specify how PeopleSoft controls access to and processes asset data.
• Developed Test Plan and Test Scripts for QA Testing and coordinated all testing activities for General Ledger, Accounts Payable, and Asset Management modules.
• Coordinated UAT Back Office testing activities (Unit Testing and Integrated Testing)
• Prepared FDDs for China and Singapore Asset and Vendor conversion and mapped to corresponding tables.
• Prepared FDDs and input for complex EFT transactions with the client's bank in China, Hong Kong and Singapore.
• Cleansed data to be mapped into Production Instance
• Coordinated Live Production of the Module and Provided Post Production Support
• Mentored and provided leadership to Analysts