SUMMARY:

• Over 18+ years of diversified IT experience including 13+ 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
• 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.
• 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,, Data Migration and Production.
• Provided Delta 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 dat 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:

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

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

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Fusion Financial/ P2P Cloud Consultant

Responsibilities:

• 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.
• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds
• Financials track for Cloud Financials Implementation
• 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
• 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, 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

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 TPR Holdings 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 TPR Holdings auditors to comply reporting with GAAP accounting standards
• Modules - AP/AR/CM/FA/GL/AGIS/Subcontracting Module/ BOM/WIP/NVOM, 3PL interfaces

Confidential

Oracle Applications Functional/ Business Analyst (GRC)

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 (KPMG) 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

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 WELLS FARGO 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.