Oracle Applications Functional Resume
NyC
SUMMARY:
- Over 18+ years of diversified IT experience including 13+ years of strong hands on experience with Oracle Applications
- Pay (i - Procurement, PO/AP/INV/ EB-tax), Order to Cash (OM/INV/AR), Financials (AP/AR/ Confidential /CM/FA), i-Expense and Project Accounting modules
- 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
- Confidential -Markview integration with AP and i-expense to receipts/ documents by email, scanning and FAX.
- Conduct CRP, UAT, Requirement Analysis, Confidential 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,, D Confidential Migration and Production.
- Provided Delta in Oracle Applications
- 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 d Confidential .
- 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.
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/ Confidential /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 Confidential wand reporting tools. He has been involved in fit Confidential analysis. He has involved in implementation of Oracle Confidential, 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
.PROFESSIONAL EXPERIENCES:
Confidential, NYC
Oracle Applications Functional
Responsibilities:
- Work directly with business stakeholders to capture business requirements and provide Fit Confidential Analysis and workarounds
- Upgrade Confidential Markview 7.0 to 8.0 along with Confidential support team
- Confidential -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 Confidential 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/ Confidential / AGIS modules
- Conduct Confidential 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
- Setup Project billing and costing modules
- WEB ADI to load trial balance and asset balances
- FSG reports for P&L, Balance Sheet and consolidation
- Got a on Oracle Fusion Financial and provided to business users
- Functional setup manager to setup AP/ Confidential
- ADFDI to upload value sets, invoices and other d Confidential
- OTBI for real time reporting
- Smart view and FR to load view reporting d Confidential
- Chart of account (COA) instance and enterprise structure
- Financial reporting studio
Confidential, NYC
Oracle Applications Functional Consultant
Responsibilities:
- Work directly with business stakeholders to capture business requirements and provide Fit Confidential Analysis and workarounds
- Implement Confidential Markview 7.0 to 8.0 along with Confidential support team
- Setup BR100 for i-Expense 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 Confidential and Oracle Support to handle product related issues
- Standardized AME rules and vacation rules for i-expenses across Confidential
- BR100 and MD50 for Confidential Portal
- Modify i-expense workflow and manager approves employee expense through Emails
- Setup AGIS for intercompany transactions
- 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/ Confidential / AGIS modules
- Conduct Confidential 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
- Markview integration with AP and i-expenses
- MD50 for Chase bank printing, Positive Pay file
- MD50 for PO print program, Customer Invoice Print
- Conversion for suppliers, customers, Items, BOM
- WEB ADI to load trial balance and asset balances
- FSG reports for P&L, Balance Sheet and consolidation
- Configure AME rules for i-expenses
- Confidential -Markview integration with AP and i-expense to documents by email, scanning and FAX.
- Define contract manufacturer and its related setups like Inventory org, organization parameters and receiving organization
- Define cost rollups
- 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/ Confidential /AGIS/Subcontracting Module/ BOM/WIP/NVOM, 3PL interfaces
Confidential, NJ
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 d Confidential source names and perform d Confidential synchronization
- Worked with Internal and external auditors for security compliance.
- Developed solutions to leverage Oracle Confidential 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 Confidential 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 Confidential usage sessions with users
- BR100 for OM/ Advance pricing (Discounts, Modifier and Qualifier)
- MD50 to load sales order d Confidential
Confidential, NJ
Business Analyst
Responsibilities:
- 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, Confidential
- 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 Confidential for example import Confidential Supplier invoices to Oracle AP, create payments manually by manual/ quick payments and through payment process profile
- Tested Oracle AR d Confidential to FAH business flow
- Tested billing account statement, customer invoices, instalment schedules etc.
- Configure Confidential d Confidential 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 d Confidential 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 Confidential 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
Responsibilities:
- Worked with procurement team to understood footprint of existing applications and business flows
- Requirement gathering and created requirement traceability Matrix
- Perform Confidential fit analysis and best possible workaround to meet business objectives
- Design business flows for P2P track for example Requisition Process, PO Process, Receiving Process, Supplier Payment process, Month end closing process
- BR100 for OM/ Advance pricing (Discounts, Modifier and Qualifier)
- MD50 to load pricing d Confidential
- BR100 for Configurator for CTO orders.
- Configuration steps (BR100) for i-Procurement
- Internet Procurement C Confidential log Administration - Purchasing Categories, Stores
- Define expense accounts rules, commodities, content zones
- OA Framework Personalization, Define POR profiles
- Worked on configuration document BR100 for PO/AP/INV/ Eb-Tax/ AGIS
- Handle day to day issues with business stakeholders
- Prepared manual, test scripts (TE40) for business group to have full understandings of process flows
- Define month end procedures for business to ease month end closing process
- Create functional specifications (MD50) to send payment d Confidential, positive pay file and remittance advice
- User guide for reconciliation process from AP, PO, INV to Confidential that helps during month end closing
- Modified BI publisher template to meet bank file specifications
- Good understanding of punch out feature
- Worked with Oracle Support team to resolve product defects and high priority issues
Confidential, NJ
Oracle Applications Functional Consultant
Responsibilities:
- CRP Session with Business stakeholder to capture requirements
- Configuration document (BR100) for AR/AP/PO/OM/INV
- MD50 for Order Import, Auto-invoice interface, Bank reconciliation
- MD50 for payment files through BI Publisher
- Reconcile sub ledgers to Confidential
- MD-50 Functional Design solution for Purchasing/ Order Import
- Worked on dunning letters and DSO i.e. days in sales outstanding report
- BR100-Functional Setup for Lockbox to interface customer receipts
- BR100 for EB tax and AGIS
- BR100 - Set ups for AP, AR, CM, FA, PO, i-Supplier Portal, i-Procurement, and INV and Confidential
- Designed and developed Payment outbound file for Standard Chartered Bank, Confidential Bank, Confidential .
- Automatic bank reconciliation for BAI file for New Zealand, Confidential in Singapore and Confidential for Malaysia
- Developed discovered Customer Aging, Chart of Account Reports, Trail Balance Report, Supplier Bank Listing Report.
- Developed XML Publisher Report for Customer Invoice Printing, Journal Voucher Printing.
Confidential, NJ
Oracle Applications Functional Consultant
Responsibilities:
- Conduct requirement gathering sessions for procure to pay cycle
- Create configuration (BR100) document for i-Procurement/ PO/AP/INV/ Service Contract/ Mobile Field Services/ Install base
- Define MD50 to load payable invoices, PO and receiving d Confidential
- Planning for d Confidential conversion strategy
- Production support for service contract and Mobile field services
- Support UAT to guide contract and field service users
- Modified service contract workflow to accommodate the new OCE business logic
- Support and modified discover reporting
- Worked with Metalink support to resolve high priority tasks etc.
- Change management process to support change requests and defects by using ITG, SharePoint
Confidential, CA
Oracle Applications Functional Analyst
Responsibilities:
- Worked with procurement team to understood footprint of existing applications and business flows for APAC, EMEA and AMERICAS
- Requirement gathering and created requirement traceability Matrix
- Setup BR100 for i-Expense integration
- Deferred revenue recognition and contingencies
- Define revenue contingency and policies
- Created AME rules
- Event Based Revenue Management & Revenue Contingencies
- Perform Confidential fit analysis and best possible workaround to meet business objectives
- Design business flows for P2P track for example Requisition Process, PO Process, Receiving Process, Supplier Payment process, Month end closing process
- Develop project roadmap for project upgrade and implementation project
- Customize project extension to add Quest specific business rules
- Define BR100, MD50, MD70 and Unit test scripts documents
- Define recruitment process to recruit resource at onsite and offshore
- Changed i-Procurement interface to Chinese and Japanese languages
- BR100 for EB-Tax and AGIS
- BR100 for OM/ Advance pricing (Discounts, Modifier and Qualifier)
- MD50 to load pricing d Confidential
- Worked with onsite and offshore teams
- Define Confidential controls on transaction and receipts forms
- Develop bank interface technical design for EMEA/ APAC/ Americas regions
- OBIEE Analytics reports
- Module - AP/AR/FA/CM/ Confidential / INV/ OM, i-Procurement, i-Supplier Portal, for P2P, O2C, A2R and R2R process tracks.
- Worked with Metalink Support to handle service request issue
- Used tools like MS Projects, SharePoint, PVCS, Test Director to monitor RICE development progress, manage documents, code changes and testing activities
Confidential, Princeton, NJ
Oracle Applications Financial Principal Consultant
Responsibilities:
- Conduct CRP for AP, AR, PO, i-Procurement, and CM modules
- BR100 for AP, AR, PO and CM functional set-ups
- Converted masters and d Confidential from legacy systems to oracle by using standard interface programs and ADI
- Developing the conversion strategy for uploading the d Confidential from legacy system
- Application Desktop Integrator (ADI) for uploading Fixed Assets and Confidential Journals
- Worked with Metalink to raise SR to fix the product functionality issues
- BR100 to setup the item master
- Prepared User documents for financial modules for the specific user groups
- Worked with technical experts to build custom objects and modified application processes.
- Created MD 50 for d Confidential conversion for supplier invoices, customer d Confidential, supplier d Confidential, auto-invoice and lockbox interfaces.
- Created Unit test scripts documents for AP/AR/CM modules
- Created d Confidential mapping templates for Supplier, Customer, Supplier invoices, Assets d Confidential, Confidential Balances to move legacy d Confidential into Oracle Applications.
- Identifying the Gaps and providing the Oracle fitment
- Preparation of Discoverer reports for AP and AR.
- Customized various reports through Financial Statement Generator (FSG) to meet localization needs.
- Completed various set-ups in Confidential - Module including defining set of books, Currencies, Calendars, Chart of Accounts, Value Sets, Roll up groups, Summary Accounts etc
- Completed various set-ups in FA - Module including defining the Asset Categories, Asset Key and Asset Location flex field.
Confidential
Oracle Applications Finance Principal Consultant
Responsibilities:
- Developing the conversion strategy for uploading the d Confidential from integrated legacy system
- Analysed and mapped business processes before migrating to R12
- Worked with Metalink to raise SR to fix the product functionality issues
- Analyse BR 100 for PA set up
- Analyse MD50 for Project Billing and Project costing modules
- Impact analysis of RICEW components and prepared test scripts to test them
- Worked on AP/FA /PO/AR/ Confidential /INV/ i-Procurement, i-Supplier Portal modules for EMEA/ Netherlands/ APAC, Latin America and South America countries
- D Confidential Migration for AP/FA /PO/AR/OM// Confidential
- Updated FSD (MD50) for project interface and Auto-invoice
- Updated FSD (MD50)/ BR100 for FA/ Confidential for Upgrade Project
- Created a global FA account generator by consolidating all countries business logic into one and upgrade to R12
- Testing D Confidential Conversion for pre-merge and post-merge instances
- Working Globally Across Different Teams in Confidential
Confidential
Oracle Apps Finance Principal Consultant
Responsibilities:
- Application Desktop Integrator (ADI) for uploading Fixed Assets and Confidential Journals
- Conversion Methodology, Reconcile sub ledgers to Confidential
- MD50- Functional Design solution for Purchasing/ Order Import
- Worked on dunning letters and DSO i.e. daily sales outstanding report.
- Functional Setup Lockbox for Lockbox to interface customer receipts
- Set ups for Inventory i-Procurement, AP, AR, CM, FA, PO, INV and Confidential
- Designed PR/PO integration with Oracle PO.
- Designed and developed Payment outbound file for Standard Chartered Bank, Confidential Bank, Confidential .
- Automatic Reconciliation for BAI file for New Zealand, Confidential in Singapore and Confidential for Malaysia
- Developed Discovered Customer Aging, Chart of Account Reports, Trail Balance Report, Supplier Bank Listing Report.
- Developed XML Publisher Report for Customer Invoice Printing, Journal Voucher Printing.
- Revaluation, Translation and Consolidation across APAC region.
- Modules (Financials, and PO) Solution designing of the processes and d Confidential conversions, Map AIM processes with project methodology DEPICT
- Designed customer, supplier, supplier invoices, customer invoices, Bank interface etc.
- Understanding the business process by referring to the business study document.
Confidential
Oracle Apps SCM and Finance Principal Consultant
Responsibilities:
- Production support in Oracle Purchasing, i-Procurement, Oracle Order Management and Inventory modules.
- MD50 for order to cash cycle
- Transitioned two Business Units of Confidential to the Global Support Centre (GSC) for future Support, Maintenance and Testing.
- Working on the functional problems that come up daily, during the month-end and quarter-end closing
- Analysis of all scenarios/paths an order line can go through, and issues that may occur during the full lifecycle of an order.
- Prepared System Test Scripts and documented Test Results
- Performed critical business process testing for business with regard to Disaster Recovery, Quarterly patches, 10g/RAC etc.
- Key member while migrating to the 10g RAC environment.
- Involved in preparation of Functional Specifications and D Confidential Templates for d Confidential migration from clients legacy system to Oracle Applications.
- D Confidential Validation and Functional testing.
- Post Go-Live support that includes activities like critical issue resolution in the production instance.
- Trained key users in Oracle Purchasing, i-Procurement, Inventory and Order Management modules.
- Solved day to day issues with end users
Confidential
Oracle Apps SCM and Finance Principal Consultant
Responsibilities:
- Solution designing of the processes and d Confidential conversions
- Provide full time support Oracle Distribution (Inventory, Purchasing & OM) and Process & Discrete Manufacturing
- Direct Interaction with end-users located globally in the US, UK, Singapore, Hong Kong, Fiji and Australia.
- Interacting with Onsite Functional Consultants and Business domain Leads.
- Understand existing business processes and served as an IT Supply Chain functional subject matter expert (SME)
- Worked with BU management to review and prioritize requests.
- SPOC (Single Point Of Contact) between the end users and the technical team, Oracle DBAs, Oracle Global Product Support, Various Internal Oracle Teams and the Business Operations Experts for problem resolution and system enhancements like patch application etc.
- Work with Business Users on a daily basis, providing functional support as well as technical troubleshooting assistance to ensure the successful flow of Business processes.
- Responsible for testing of customized components and Standard functionality in Order Management, Inventory and Purchasing modules.
- Excellent knowledge in Oracle Business Flows (Procure to Pay, Order To Cash etc,) solution design and Business Process Mapping
- Prepared System Test Scripts, documented Test Results and User Acceptance Test (UAT) for Regression Testing
Confidential, Houston
Oracle Project Accounting Principal Consultant
Responsibilities:
- Created functional design for Project Interface
- MD50- Functional design for transaction import
- Modified and tune Global Supplier Interface
- Automated Invoice interface based on the event.
- MD50- Functional design for Auto Invoice interface
- Project Costing and Billing
- Customised Labour billing extension
- Created functional design ABS: Timecard Approval Report
- Created MD 50 for Chile and Venezuela invoice print report
- Self service Time
- Customised Confidential Interface
- Customised Project billing extension
- Modified Employee d Confidential API in HRMS Interfaces
- SSHR, OTA, OTL, J developer,
- PA Timecard Approval
- Project Supplier Invoice Account Generation
- Project Expense Report Account Generator
- HR Self service Workflow
- Converting FS to TS at onsite