SUMMARY:

• Over 20+ years of diversified IT experience including 16+ years of strong hands on experience with Oracle Applications Implementation, upgrade, Rollout and Production support in Procure to Pay (i - Procurement, PO/AP/INV/ EB-tax), Order to Cash (OM/INV/AR), Financials (AP/AR/GL/CM/FA), i-Expense and Project Accounting modules
• Oracle BI Publisher Reports/ OTBI/ FR Studio/ Account Monitor, Account Inspector, Smartsheet View.
• Recently done upgrade of Markview 7.0 to 8.0 along with Oracle EBS upgrade R11i to R12 in i-Expense and Accounts Payable modules
• Kofax-Markview integration with AP and i-expense to receipts/ documents by email, scanning and FAX.
• Conduct CRP, UAT, Requirement Analysis, Gap Analysis, Reengineer, configure, implement, support, Audit for compliance.
• Extensive familiarity with Application Implementation Methodology (AIM- BP040, BP080, BR010, TA010, BR100, RD20, MD50, TE20, TE40, CV10, CV40 etc. ) in different phases i.e. Requirement gathering, Operation analysis, Solution Design, Build, Test, Training, Data Migration and Production.
• Provided Delta training in Oracle Applications
• Excellent knowledge in Oracle Business Flows (Procure to Pay, Order to Cash) solution design and Business Process Mapping.
• Extensive knowledge of bank interfaces and bank statement loaders like HSBC, BOA, Standard Charted Bank.
• Designed reports with FSG, OBIEE, XML Publisher and Discoverer.
• Implement controls in Oracle Applications that conforms to SOX and JSOX.
• Worked on functional design documents for Oracle interfaces like Purchasing/ Requisitions interface, API, EDI Orders, Order Import, BOM Interfaces, Purchasing and Fixed asset workflows, Auto Invoice, Customer interface, Lockbox, Supplier Interface, Payable Import, Journal Import, Project interfaces, project extensions, Employee load data.
• Worked onsite co-ordinator for onsite/ offshore business model.
• Helped customer to define Helpdesk support model and define customised project methodology using AIM processes.
• Designed conversion methodology, business solution architecture and mapped AIM processes with client’s specific project management methodology.
• Excellent analytical, problem Solving, Communication and Interpersonal skills to interact with individuals at all levels.
• Manages the day-to-day support/maintenance issues / requests and coordinates with appropriate service providers as needed
• Responsible for working with business users for understanding, troubleshooting and resolving production support tickets.
• Work with Oracle Support by raising SR to resolve Oracle EBS issues with Oracle seeded functionality.
• Support all Oracle Applications patching, upgrades and maintenance activities by testing and troubleshooting functional issues.

TECHNICAL SKILLS:

Consulting Skills: Worked in business process flows Procure to Pay (i-Procurement, AP/PO/INV), Subcontracting manufacturing, Order to Cash (OM/INV/Advance Pricing/AR) and Financials (AP/AR/GL/CM/FA/i-Expense/ FAH) and project accounting modules. Responsible for delivering the assignments on time as per SLA, Onsite Implementation of ERP applications, multi-level client co-ordination, balancing on-site and off-site team activities, act as an Engagement liaison for the project handed over, well versed to bring onsite projects/processes to off-shore.

Functional Skills: He has good knowledge of AIM documents like BP80, RD 20, RD50, MD50, MD70, CV10, BR100, etc. He has documented the Set-up steps for Procure to pay and order to cash, Manufacturing, financials and project billing & costing modules. Know conversion strategies and methodologies. He knows ADI, Web ADI, discoverer and GL wand reporting tools. He has been involved in fit gap analysis. He has involved in implementation of Oracle GL, AP, AR, FA and PO across 8 countries namely Singapore, Taiwan, China, Malaysia, Australia, New Zealand, Thailand and Philippines. He has knowledge of Global Remedy tools to log in support cases. Efficiently worked with Metalink Support and raised SR (TAR) to find application solutions for bugs/ issues. He has knowledge of SOX accounting compliance.

Development Tools: TOAD/ BI Publisher, Discoverer/Workflow/ AME/ OBIEE/PL-SQL/ UNIX Shell Scripting

PM Tools: MS-Project, MS-Visio, MS-Office Suite, and PM Templates

AREAS OF EXPERTISE:

• ERP Oracle Applications mainly Oracle Fusion Financial/ P2P Cloud (R11/R12) and EBS R11/11i/R12.2.3
• Oracle Fusion Cloud Processes - Invoice Imaging process, Smartsheet Invoicing process, General Ledger, Cash Management, Assets and Accounts Receivables, Functional Setup manager, Identity Manager
• Expert in SOA integration (BPEL, SOA, OSB) to interface data to Oracle Fusion cloud.
• Developed Integration strategy to integrate different system data to Oracle Cloud.
• Used Agile Sprints project methodology to implement Oracle Fusion Cloud Financials/ P2P. JIRA is used to handle issues and user stories to track project work.
• OUM Methodology - AN100, MC050 and DS-140
• Expert in PAAS/ SAAS environments.
• Oracle BI Publisher Reports/ OTBI/ FR Studio/ Account Monitor, Account Inspector, Smartsheet View.
• SOA Integration strategy for interfaces to Oracle Fusion cloud.
• Oracle Procure to Pay (P2P): i-Procurement, i-Supplier Portal, i-Expense, Markview 170, AP, PO, INV, Advance Pricing
• Integration with Legacy System and Reporting
• Kofax Markview170 Upgrade from 7.0 to 8.0, Kofax Email server, Kofax Server, Kofax bar Code Server
• Integration of Kofax Markview 170 with i-Expense and Accounts Payables modules
• GAAP, IFRS accounting standards
• Oracle Order to Cash (O2C): OM, Shipping, AR, Advance Pricing(Modifiers, Qualifiers, Discounts, Promotions, Pricing events), INV, EB-tax, AGIS
• Oracle Financials: GL, AP, AR, AX/SLA, FA, GL-ADI, i-Expense,
• Financial Accounting Hub and Fusion FAH (ADR, AAD, SLAM, Mapping sets, Ledgers, Event Model, Accounting Events - Journal Pass through and event creation API - XLA EVENTS PUB PKG.create event)
• CRM - Service Contracts, Mobile Field Services
• Worked for EMEA, APAC and NA regions
• Brazil, Mexico, Chinese and Japanese Localizations and Languages
• Oracle GRC - Application Access Control Governor (AACG), Transaction Control Governor (TCG), Configuration Control Governor (CCG), Preventive Control Governor (PCG)
• Oracle Projects: PA Costing and PA Billing
• AR Deferred revenue and receipts conversions, Event Based Revenue Management & Revenue Contingencies
• Oracle Logistics SCM: OM, PO, INV, WIP, Configurator, BOM
• Oracle Customers CRM: AR, OM, Advanced Pricing
• Oracle Foundation: FND, AK, API, Auto Accounting
• Noetix Views to create discoverer reports, Managed onsite, Offsite and offshore teams
• Worked for P2P, O2C tracks extensively along with P2I, R2R
• EDI (850, 855, 810,856)
• GL wand to create Oracle financials statements
• WEB ADI, ADI, FSG, OBIEE, SQL,PL/SQL, TOAD, Oracle Alerts, and Discoverer Reporting
• Managed onsite, Offsite and offshore teams
• Workflow/AME rules - Business events, PO Account Generator, FA account generator, Order Header/ Lines Workflow, PO Approval workflow

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Oracle Fusion Financial/ P2P Cloud Consultant

Responsibilities:

• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds
• Financials track for Cloud Financials Implementation
• Journal Import to Oracle Cloud GL with BPEL and SOA Design.
• Payable import to Oracle Cloud AP with BPEL and SOA Design.
• Ledger Design for Corporate, Statutory and Tax reporting with reporting currency and secondary adjustment only ledgers.
• Configuration of complex Allocation Rules for Facilities, Benefits and IT Cost allocations
• Implemented AMEX Corporate Card Integration with expenses
• Configuration of Approval Management Extension (AMX) Rules for Journal Approvals
• Configured Sub-Ledger accounting rules for Fixed Assets and Accounts Payables
• Design and Configurations of Journal Approval Rules to prevent entry to specific Chart of account Segment Values
• Design of Volume Accounting Solution for Revaluation process via development of custom BIP extract.
• Responsible for requirements gathering, design, configuration, conducting various test events, issue resolutions and offshore - onsite coordination.
• Conduct Gap fit analysis and conference room pilots
• FBDi templates to upload data to Oracle Fusion Financials cloud.
• Design of Volume Accounting Solution for Revaluation process via development of custom BIP extract.
• Configuration of Allocations rules via Allocation Manager
• Co-coordinated and guided offshore team in development of FR Studio Reports, Smart view Analysis for Financial Reporting
• Design data migration strategy for GL balance, AP Open invoices and Fixed Assets conversion.
• ADFDI to upload value sets, invoices and other data
• OTBI for real time reporting, BI Publisher reports (PO Printing, Check Printing etc.).Approx. 20 reports created to support business needs.
• Used BI Publisher to produce EFT and positive pay files.
• Chart of account (COA) instance and enterprise structure
• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds
• Upgrade Kofax Markview 7.0 to 8.0 along with Kofax support team
• Fusion Accounting Hub - SLA module to configure JED, JLT,ADR, Mapping Set, AAD, SLAM, Event Class Code, Event Type, Event Class, Process Category, User Transaction Identifier, Reference Objects etc.…
• Journal Pass through and event creation API - XLA EVENTS PUB PKG.create event
• Kofax-Markview integration with AP and i-expense to receipts/ documents by email, scanning and FAX.
• Setup BR100 for i-Expense (Bar code integration) integration with Markview
• Setup rules in Markview for Accounts payables and integration of Bar Code with Markview
• Providing support for day to day business issues in Markview and i-expenses
• Working with Kofax and Oracle Support to handle product related issues
• Standardized AME rules and vacation rules for i-expenses across Confidential
• Configure AME rules for i-expenses
• Modify i-expense workflow and manager approves employee expense through Emails
• Setup for EB Tax rules 0% and 7%
• Setup i-expenses and AME rules for employee supervisor
• Setup Fixed asset / cash management modules
• Setup AP/AR/ GL/ AGIS modules
• Conduct Gap fit analysis and conference room pilots
• Convert open transaction (CV10, CV40) for AP/AR/PO and asset balances for FA
• Load trail balances and asset balances through WEB ADI
• Automatic bank reconciliation in cash management
• MD50 for Chase bank printing, Positive Pay file
• MD50 for PO print program, Customer Invoice Print
• Conversion for suppliers, customers, Items, BOM

Confidential, NYC

Oracle Applications Functional Consultant

Responsibilities:

• Discovery sessions with finance team to know their finance functions- mainly in GL/FA/CM/AR/AP/i-Expense
• Distribute Gap fit analysis with workarounds to fill the gaps
• Develop standard operating procedure for month end closing to make month end efficient and close on time to produce bottom line reports
• Well versed with AIMS methodology and PM standards to meet project deliverables
• Extensive knowledge of upstream and downstream systems to reconcile and synching of systems
• Conduct CRP sessions with finance business stakeholders and users to map their business processes in Oracle
• Discuss conversion strategy with finance team and laid out a conversion strategy document
• Design Chart of account segments after discussing their business functions and reporting needs
• Setup AME rules for i-Expense approvals based on supervisor hierarchy of TPR organization
• Setup AR/FA/GL modules
• Define cross validations and security rules for users to enter correct code combination rules
• Analyse and design Convert open balances (CV10, CV40) for GL/AP/AR and asset balances for FA
• Load trail balances and asset balances through WEB ADI
• Functional design for ACH/EFT and Positive Pay file
• Functional design for legacy supplier invoices to port to Oracle AP
• Functional design for journal history transactions to port to Oracle GL
• Functional design for BI Publishers reports for customer invoice Print and Customer aging reports
• Conversion for suppliers, customers, Banks, Items, BOM
• WEB ADI to load trial balance and asset balances
• FSG reports for P&L, Balance Sheet and consolidation
• Define contract manufacturer and its related setups like Inventory org, organization parameters and receiving organization
• Conduct UAT and SIT testing cycle to ensure business processes are working as per the business requirements.
• Produce production migration methodology to migrate code from UAT to PROD environments
• Define cost rollups
• Worked with Confidential auditors to comply reporting with GAAP accounting standards
• Modules - AP/AR/CM/FA/GL/AGIS/Subcontracting Module/ BOM/WIP/NVOM, 3PL interfaces
• SLA - Define ADR, Journal Line definition, Define AAD, Sub-ledger accounting method
• Define new ADR rules, Journal; definitions, AAD and SLAM to derive accounting entries from asset category
• Worked with Confidential auditors to comply reporting with GAAP accounting standards
• Modules - AP/AR/CM/FA/GL/AGIS/Subcontracting Module/ BOM/WIP/NVOM, 3PL interfaces

Confidential, NJ

Oracle Applications Functional/ Business Analyst

Responsibilities:

• Define security controls in Oracle EBS for Ansell and segregation of duties
• Custom.pll modified to create inquiry responsibilities W/o changing the form function
• Run AACG reports to verify the Oracle EBS security controls
• Define global conditions to filter false positive roles in AACG
• Define AACG policies down to level 9 functions
• Define entitlements, Remediate user conflicts
• BR100 for trade management, Set price list, promotions
• Define data source names and perform data synchronization
• Worked with Internal and external auditors for security compliance.
• Developed solutions to leverage Oracle GRC applications functionality for the E-Business Suite and suggest improvements.
• Developed solutions surrounding system administrator functions such as evaluating user access, segregation of duties analysis, profile option management, responsibility design, user function and menu design.
• Assist DBAs in managing/designing all configuration monitoring, background job monitoring, and connection maintenance for production and non-production environments to GRC Tools.
• Define segregation of duties, AACG policies, CCG Snapshot and change trackers
• Implement preventive and transaction control processes
• External/Internal Audit ( Confidential ) or Financial/IT Compliance experience
• Risk Management, Audit, and Compliance in ERP environment
• Work collaboratively with multiple stakeholders from business, functional areas, IT and financial personal
• Lead Oracle GRC usage sessions with users
• BR100 for OM/ Advance pricing (Discounts, Modifier and Qualifier)
• MD50 to load sales order data

Confidential, NJ

Oracle Applications Functional/ Business Analyst

Responsibilities:

• Created functional configuration document (BR100) document for i-Supplier Portal
• Setup BR100 for i-Expense integration
• Created AME rules
• Worked with business team to gather business requirement and create functional design document (MD50) for i-Supplier Portal to provide internal/ external views for supplier invoices and payments
• Coordinate with technical team in Toronto to explain the business requirements out of MD50
• Test the technical components as per functional specifications (TE40)
• Demonstrate i-Supplier portal functionality to Marsh business partners like Chubb Group Of Insurance Cos, ACE American Insurance Co etc.
• Updated local check configurations (BR100 ) to print checks for Confidential by Standard register software
• Worked with business to test complete local checks solution
• Support testing with business for FAH process (R11i to R12)
• Tested different business flows in RMB for example import RMB Supplier invoices to Oracle AP, create payments manually by manual/ quick payments and through payment process profile
• Tested Oracle AR data to FAH business flow
• Tested billing account statement, customer invoices, instalment schedules etc.
• Configure RMB data like Customer master account, billing account, policies/ engagements/ bonds, Suppliers, Customers, AP invoices, Customer Payments to
• Tested OB10 business flow with business partner OB10 to send AP invoices data to HP
• Worked with business to build process for remit to bank details with different currencies
• Created functional specifications for Bermuda invoices to show different bank remit to format. Worked with Oracle Consulting and Marsh DRS (Document rendering system) team to support development activities.
• Configure cross validations and security Rules to support testing by business
• Load GL Daily rates based on business needs
• BR100 and MD50 for iSupplier Portal
• Co-ordinate with different business stakeholders for example business group, QA, UAT and production support teams in testing and perform configuration steps.

Confidential, NJ

Oracle Applications Functional Consultant

Confidential, NJ

Oracle Applications Functional Consultant

Confidential, NJ

Oracle Applications Functional Consultant

Confidential, CA

Oracle Applications Functional Analyst

Confidential, Princeton, NJ

Oracle Applications Financial Principal Consultant

Confidential

Oracle Applications Finance Principal Consultant

Confidential

Oracle Apps Finance Principal Consultant

Confidential

Oracle Apps Finance Principal Consultant

Confidential

Oracle Apps SCM and Finance Principal Consultant

Confidential

Oracle Apps SCM and Finance Principal Consultant

Confidential, Houston

Oracle Project Accounting Principal Consultant

Confidential, Atlanta

Oracle Apps SCM and Finance Principal Consultant

Confidential

Oracle Apps Finance Principal Consultant (Team Lead)

Confidential

Oracle Apps Finance Principal Consultant

Confidential

Oracle Apps Finance Principal Consultant

Confidential

Oracle Apps Finance Principal Consultant

Confidential

Senior Software Engineer

Confidential .

Team Member

Confidential .

Team Member

Confidential .

System Analyst

Confidential

Team Member

Confidential

System Engineer

Confidential

Team Member

Confidential

Team Member

Confidential

Team Leader