SUMMARY

• Over 10 years of professional work experience in various modules of Oracle E - Business Suite 11i & R12.
• Experience in implementing, testing, training and production support on various Oracle ERP modules - GL, AP, CM, FA, AR, INV, PO and Project Accounting Modules.
• Experience in Implementation, Upgrade, Integration and Customization in Oracle Applications (versions 11i & R12).
• Specialized in Oracle Financials (GL, AP, CM, AR, FA, OM, and INV) and Project Accounting modules including Costing, Billing and Project Management.
• 3 Full Lifecycle R12 Upgrade Projects including GL, AP, CM, AR, INV, PO, FA and Project Accounting Modules.
• Experience in 3 Full Lifecycle Implementations including Requirement Gathering, Business Process Analysis, GAP Analysis, Creating Functional Specifications, Defining Solutions, Recommending Best Business Practices, Conducting User Acceptance Testing (UAT) and Completing System Set-up.
• Exceptional documentation skills in creating project artifacts like Business Requirements Document (BRD), Functional Requirement Document (FRD), Requirements Traceability Matrix (RTM), System Requirements Specification (SRS), Data Mapping Document, User Acceptance Test Plan, Use Case Specifications and Test Scripts.
• Expert in SYSADMIN activities like managing concurrent managers, application user setup, defining responsibilities, request sets, values sets, flex fields, registering menus, forms, reports and concurrent programs.
• Sound experience in Data Conversions, Data Migration, Inbound/Outbound Interfaces Design, Reports Development, Workflow Customizations, Database Triggers, Procedures, Functions and Packages using SQL & PL/SQL.
• Hands on experience in Data Modelling, Data Visualization, Data Management, Data Quality Assurance and Control, Data Governance and Master Data Management
• Good Knowledge of Oracle RDBMS Concepts, Change Management Process and SDLC Methodologies.
• Experience in Data Migration from the legacy system to oracle Application and Production Support.
• Closely worked with Technical Team for Customizations of Reports, Interfaces, Oracle forms and Java pages etc.
• Experience in Waterfall and Agile methodologies.
• Good working knowledge and strong experience on all the aspects and customization of AR, AP, CM, OM, INV, GL, FA and Project Accounting modules.
• Performing well under intense pressure, multitask and manage multiple projects simultaneously.
• Exceptional communicator - can effectively present ideas and concepts to upper management in a clear and concise manner.
• Proficient in generation and automation of reports (operational and ad-hoc) based on internal/ external needs by using Discoverer, OBIEE and SQL/PLSQL.
• Solid understanding of Procure to Pay (P2P) and Order to Cash (O2C) lifecycles.

PROFESSIONAL EXPERIENCE

ERP: Oracle Applications R12, 11i/ 11.5.10/11.5.9/11.03 (GL, AR, AP, FA, CM, INV, PA, PO, I Expenses and System Administration)

Languages: Experience in SQL, PL/SQL, SQL*Plus, Pro*C, C/C++, C#, Java, HTML and XML.

Tools: SQL*Loader, TOAD, MS OFFICE, Data Loader, Oracle Discoverer, OBIEE, Concur Travel and Expense, Revpro and Mark View

Operating Systems: Windows NT, HP UNIX, Sun Solaris UNIX, Linux

Data Base: MS Access 2000, Oracle 9i, 10g, 11g

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Project Accounting/Financials Consultant

Environment: Oracle Applications 12.2.5, Oracle Financials Fusion, RevPro 3.0, FAH, OBIEE and SQL/ PLSQL.

Responsibilities:

• Active team member in Implementation and Global Design of Oracle Financials Fusion (GL, AP, FAH, PA) and SLA Modules.
• Attended Oracle Financials Cloud training sessions.
• Participated in Oracle Financials Cloud P2P and C2C Oracle Fusion global design working sessions.
• Created functional specification document for projects conversion as part of Oracle Financials Cloud Global Design.
• Produced artifacts such as analysis specification (AN.100) and design specification (DS.140).
• Configured system prototype to demonstrated proposed solution to client.
• Data uploaded using Oracle Fusion FBDI
• Created JE’s, Performed Period Close Activities, Supplier Maintenance Activities and Payables Invoicing in Oracle fusion cloud environment.
• Defined legal entities, ledgers and balancing segment values for POC.
• Familiar with General Accounting Dashboard, Financial Reporting Center and Functional Setup Manager
• Successfully completed Phase-I and presented Oracle financials cloud implementation global design to client.
• Coordinated and lead the entire phase of the project which included Initial Requirement Gathering, Business Process Re-Evaluation, Testing, Training, Conversions, Customizations and Documentation.
• Prepared Configuration and functional specification documents (MD.050).
• Worked with the client team in understanding the Business Process to prepare the Business Requirement Definition document and Recommending Best Business Practices.
• One of the active team member in implementation of Revpro for WTW as per ASC606 guidelines.
• Assisted the team in automation of revenue recognition as per ASC606 and IFRS15 Standards.
• Techno/Functional support for integrations between Oracle AR, Oracle GL, Oracle Project Billing, FAH and RevPro
• Conducted Knowledge Transfer workshops and closely worked with development team to translate the functional design to technical design.
• Worked closely with different revenue stream leads in identifying and converting the data from ASC605 to ASC606 standards.
• Responsible for design and development of Transformation procedures. Validation procedures, Audit, Control procedures and Error Handling within the staging layer
• Documented business logic to transform the data to be consumed by Revenue Management System (RMS) RevPro and incorporated data quality checks, data profiling validations during the source extraction prior to the data landing into the TL’s staging layer.
• Configured FAH application as per the requirement and specifications to import the revenue journals from RevPro into FAH.
• Prepared mapping documents and designed mapping tables to interface the revenue data between Oracle EBS and Revpro as per technical design requirement.
• Created More4Apps upload templates and Data Loader scripts to update historical Oracle data.
• Revisited PA Auto Accounting Rules, Contract Creation Process, PA Event Creation, Auto Invoicing and made necessary changes to accommodate ASC606 guidelines.
• Designed a custom SQL loader program to load the various revenue streams cutover data into custom revpro tables to calculate revenue as per ASC606 guidelines.
• Designed the process to automate project invoice email notification to project managers for review and approval.
• Created a custom OAF Page to review the project invoice details and to take necessary action.
• Automated the email delivery (with invoice pdf and supporting documents) of project invoices to client once the invoice is approved by project manager.
• Provided ad-hoc data extracts and SQL queries for trouble shooting and reconciliations
• Provided Global support and resolved several O2C & P2P related issues
• Assisted the team in preparing Test Scripts, Test Scenarios and Test Plan.
• Responsible for Identifying and tracking defects to resolution and producing a summary defect report to determine testable defects (defects that have been promoted, fixed or reopened).
• Performed Back End Testing using SQL queries, generating reports to ensure data integrity and to validate the inserted and updated data.
• Actively participated in QA life cycle execution from Test Plan, Test Scripts, and Defect Resolution to User Acceptance Testing (UAT), System Integration Testing (SIT) and End-to-End testing.
• Managed test case, defects and reports in HP Quality Center (ALM).
• Prepared Training manuals for Post Go Live Support.

Confidential, FL

Sr. Oracle Project Accounting Analyst

Environment: Oracle Applications 12.1.3, Concur Travel and Expense Tool, Oracle Forms 12.0.15, Mark View Application 7.0, Discoverer and SQL/PLSQL.

Responsibilities:

• Gathered business requirements for Concur Travel and Expense Implementation and Concur Integration’s with Oracle EBS
• Interacted with business users, Business and IT Leads, Accounting Managers and Controllership Team to understand and to document the business process flows and requirements
• Conducted business workshops to assess business requirements (Process Gaps/RICEFW) in detail and mapped to Oracle EBS
• Prepared Functional Design (MD050), Conversion Design (CV040), Process Flows (BP080) and Configuration Documents (BR100)
• Designed and configured inbound interface program to interface Employee Expense Data from Concur to Oracle Projects to record the Job Costing data in PA
• Designed and configured inbound interface program to integrate Concur with Oracle GL to Record and Post Employee Travel Expense JE’s in Oracle GL as per the requirement and specifications
• Provided Solution to integrate Non Direct Deposit Employee (NDD) Expenses from Concur to Oracle AP and to make disbursement out of Oracle AP
• Key member in design and development of Concur integration with Oracle AP to capture Non Direct Deposit Employee Expense data, Create Supplier and Supplier Site, Pay Employee (Out of Pocket) Expenses via Manual Check out of AP and Create Accounting Entries as per the Business Requirement
• Responsible for Design and Development of Outbound Interfaces to feed Project/Task Information from Oracle PA to Concur and COA (Chart of Account) information from Oracle GL to Concur as per Concur Import File specifications
• Worked with Business Users, Developers and Oracle Support to research, document and resolve Oracle system and functional issues
• Prepared Test Scenarios, Test Scripts for Concur and Oracle EBS and Conducted SIT and UAT test cycles for key business process scenarios and regression testing
• Coordinated and worked closely with offshore development team to review the business requirement, functional design & for solution validation
• Worked closely with cross functional teams to design and define the integrated solution
• Participated in Concur System Configurations and design of Audit rules as per the business requirement
• Developed SQL queries for Analysis, Troubleshooting and created ad-hoc reports as needed
• Provided road map to decommission I-Expense and to move all expense users from I-expense and OTM to Concur.
• Actively participated in assessment of Future State Design for Oracle EBS and prepared the Road Map for IT.
• Captured and Documented Finance Team Pain Points, Future State Business Process Flows and AP Requirement for Future State Design.
• Identified and documented Mark View Customizations, Oracle EBS Customizations in Current State and Proposed Solutions for Future State to Meet the Business Requirement.
• Documented Interface Architect Diagrams for Oracle Financial Modules and incorporated with IT Enterprise Model.
• Presented Kofax KTM Proposal (Mark View) and Kofax Components (Mark View) Architecture to client for future state design.
• Configured EbTax and assisted implementation team for Vertex O2C Tax Link Integration
• Identified the RICEFW list for Oracle AP by performing MAP/GAP analysis with Standard Functionality.
• Assisted Track Leads and Program Managers in Program Management and Status Reports for Senior Leadership.
• Prepared CV040 for AP 1099, AP Paid Invoice History, AP Supplier and Projects Conversion.
• Provided a weekly project report that includes Test Metrics and status reports to stake holders.
• Developed Test Strategy Document and performed Functional System Testing and Regression Testing.
• Participate in requirement and design reviews to ensure test plans are traceable to requirements.
• Reviewed test scenarios and coordinated with business users and QA team for execution of test plans.
• Responsible for importing the test cases from MS-Excel to Quality Center.
• Conducted training sessions to familiarize users with system and Assisted in development of training materials for new technology and process improvements.
• Resolved the user support tickets and Involved in monthly production release.

Confidential, FL

Sr. Oracle Financials & Project Accounting Lead

Environment: Oracle Applications 12.1.3, Oracle Forms 12.0.15, RDBMS:11.2.04.0, Mark View Application 8.0, OBIEE, SQL/PLSQL.

Responsibilities:

• Conducted senior-level business process analyses, needs assessments and preliminary cost/benefits analyses in order to align information technology solutions with business delivery initiatives in the Finance business process domain, focusing on Oracle EBS.
• Served as a liaison between the Finance function and IT to provide technical and business solutions that meet user needs.
• Provided support for Oracle GL, FA, AP, PA, I-Expense and Mark View application.
• Translated high-level business requirements to functional specifications for IT and managed changes to those specifications.
• Negotiated agreements and commitments by facilitating communication between the business unit(s) and IT from initial requirements to final implementation.
• Created business requirements and other documents in support of projects and assisted teams in providing configuration solutions for business requirements.
• Provided ad-hoc reporting and analysis
• Performed other duties as assigned.
• Responsible to lead small and medium projects in Procure to Pay (P2P) stream.
• Implemented and configured AP module for Canada. Includes full module stand up, creation of Canadian Operating Unit, Configuration and Custom Responsibility Creation.
• Gathered requirement and specifications for Externally Printed Confidential Check File Format, ACH File Format, ePayemnt File Format, Internally Printed Check, Externally Printed Check and Positive Pay File Format for internally printed checks.
• Worked with development team to design the XML format templates and configured the steps required to link it with a bank document and process profile that meets the specification of Confidential and requirement of Confidential .
• Created payment process profiles and templates to include Confidential Check Format & File, Confidential ACH Check Format and File, Confidential ePayment Format and File, In-House Printed Check Format and File, In-House Confidential Positive Pay Format and File as per the requirement & specifications.
• Remediated and designed an outbound file transfer program to automatically transmit the Externally Printed Confidential check file, ACH File, ePayment File, Positive Pay for Internally Printed Check to Confidential, following ADT encryption protocol upon confirmation of the payment batch.
• Configured payment process profiles and payment templates to create payment batch based on payment method rather than payment priority.
• Created custom responsibilities to perform the supplier maintenance and to run the oracle seeded reports as per the ADT requirement.
• Coordinated and worked with development team to customize the Non-AME workflow rather than turning on AME workflow and using workflow builder to meet the business requirement.
• Removed signing limits and cost center (department) verification as part of the i-Expense approval workflow.
• Defined expense types and cost center allocation rules.
• Customized the credit card inquiry form to view additional information as per the business requirement which helps credit card administrator for audit purposes.
• Implemented DMZ to expose I-Expenses to External Network (Internet Users)
• Configured AP Invoice Interface program for loading AP Invoices from different legacy systems.
• Supported I-Supplier Implementation team.
• Performed the impact analysis of oracle upgrade on existing business process and identified the GAPS.
• Remediated Auto Accounting Rules, Cost Clearance Engine, Asset Capitalization Process, Custom Reports and all other lookups/setups to accommodate Chart of Account Transformation and Calendar Change.
• Created new responsibilities and redefined the existing responsibilities to allow users to run oracle seeded reports and other capabilities as per the ADT business requirement.
• Enhanced the Project Auto Close Program to close the projects after 4 months instead of 6.
• Made changes to the Projects and Customer interface from external system to improve the error handling exceptions.
• Designed a custom process to purge project and customer information to improve the performance.
• Implemented suspense account logic for Auto Accounting Exceptions which helps for smooth PA period close as part of Month End.
• Responsible to open HP QC Defects and to track the status till the defect is closed.
• Prepared training documents and trained business users and production support team on delta futures.