Sr. Oracle Functional Consultant Resume
Baltimore, MD
SUMMARY
- 10+ years of experience in Oracle Financials as Business Analyst, Production Support and Functional consultant. Provided consulting services, delivering comprehensive set of value - added services for developing and implementing Oracle E-Business Applications.
- Lead a team of 6 members for Production Support at Confidential Project - overseeing day to day production support, Configurations through BR100CR Change Requests and QA operations.
- Provide inputs for Deliverables, Team composition, Man hours for various Change Management operations - Confidential Project.
- Proficient in Accounts Payable, Accounts Receivables, Cash Management, and General Ledger.
- Over 15 years of experience in the areas of Finance, Accounting and Audit Operations. Conversant with Business process of Manufacturing, Healthcare and Service Industries
- Responsible for gap analysis between the Financials Suite and client business requirements.
- Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Integration & User Acceptance Testing, and Post-Implementation Support.
- Experience in maintaining documentation and using the Application Implementations Methodology (AIM). Authored various documentation including and not limited to (BR100, BR150, MD 50, MD120, CV 40 &TE 40).
- Conducted CRP’s and provided wide range of functional training to multiple business user groups and coordinated UAT sessions.
- Organized and efficient to prioritize and manage various tasks in stressful environments with stringent deadlines.
- Excellent logical and analytical skills and strong ability to perform as part of a team.
- Excellent verbal &written communication skills, with strong interpersonal and teamwork skills.
TECHNICAL SKILLS
- Module/Product: Version
- General Ledger (GL): 11i & R12
- Accounts Payable (AP): 11i & R12
- Accounts Receivable (AR): 11i & R12
- Cash Management (CE): 11i & R12
- Oracle - ERP
- Fusion Middleware and On Demand
- Microsoft - ERP
- Active Directory
- Exchange
- SharePoint
- Office and Windows
- Messaging
- Forms
- Spreadsheets
- Remedy & Rational Rose
PROFESSIONAL EXPERIENCE
Confidential, Baltimore, MD
Sr. Oracle Functional Consultant
Responsibilities:
- Interact with various stake holders like CMS Management Team, 27 Orgs Business Team members, and internally with various cross functional and technical teams with in Confidential Project. Conversant with Remedy and Rational Tools like ClearCase and ClearQuest for the day to day operations.
- Worked in various teams--BR100 Configurations, QA review Change Requests, Financial Reconciliation team, Production Support in resolution incidents and assisted Testing Team in validating UAT Test Scripts related to R12 Conversions.
- Production Support to CMS Contractors in Financial Reconciliation operations in the areas of AR, AP, Loans & GL Modules-Adjustments, Refunds & Outstanding balances (with various aging Buckets / aging periods), Manual AR Invoices, Bank Reconciliation issues, Journal Entries, GL Control Accounts etc
- Provide inputs for Deliverables, Team composition, Man hours for various Change Management operations - Confidential Project.
- Created BR100 setups for AR,AP,CE,GL, and Loans modules for R12 MAC Conversions-for all 24 Orgs and 69 Workloads into Confidential
- Oversee and monitor at periodic intervals updating of Master BR100 documents in ClearCase.
- Worked in Fin Recon Team - work involved preparation of Weekly / Monthly Fin Recon Reports and resolution of reconciliation related issues
- Provided extensive user support Analysis: Research solutions to problems, answer client questions and provide consulting and training as required. Track software and documentation issues.
- Prepared Impact analysis document for the upgrade of the financial modules from 11.5.10.2 to R12.1.3
- Facilitating end-user training and developing the various users training manuals and conducted the UAT sessions.
- Worked in Production support in resolving Production related incidents.
- Assist Testing Team in validating UAT Test Scripts related to R12 Conversions.
Environment: Oracle Financial Applications R12/11.5.9 (Accounts Receivable, Accounts Payable, Cash Management, System Administration and General Ledger).
Confidential, Sacramento, CA
Lead Functional Consultant
Responsibilities:
- Study and document the As-Is and To-Be process. Provide BRD’s for various initiatives-Design of WebPortal, EFT Collections etc.
- Responsible for Requirements gathering, Functional Specification, and Design.
- Segregation of revenue operators into Distributors, Manufacturers and Annual and designing of Transaction Types, Accounting Codes, Payment Terms and the BRD’s.
- Document BR100, Functional and Report Extensions through MD 050 and MD 070 Documentation
- Setup Dunning through Advanced Collections.
- Design documents for Business Rules for WebPortal (for creation of invoices and EFT receipts)
- Functional spec for Conversion of legacy data into AR and its validation
- Develop Test Scripts, Training Material, Knowledge Transfer and User Training.
- Support issues after GO Live in the areas of Auto Invoice, Receipts and month end closing.
- Creation of Item Masters; Category Sets and Codes
- Pricing through Oracle Pricing Manager
- Support in the month end closing process and resolve issues
Environment: Oracle Financial EBS Applications R12 (AP, AR, Inventory, Advanced Pricing).
Confidential, San Jose, CA
Oracle Functional Consultant
Responsibilities:
- Responsible AR modules implementation. Requirements gathering, Gap analysis, preparation of Business Requirement Documents.
- Coordinate with various business teams in arriving at the right solutions.
- Preparation of BR100, MD 50 and update BR100 for GL.
- Preparation of Menus various responsibilities and setting up responsibilities in AR and GL.
- Invoice interface, Customer, Vendors & Banks conversion
- Setup cross validation Rules.
- Functional Testing in CRP3 before its replication to UAT.
- Conducted CRPs and Training end users. Coordination with various teams across globe.
- Training and Support in month end closing process for AR business team
Environment: Oracle Financial Applications R12 (AOL, AP, INV, PO, AR and GL).
Confidential, Cary, NC
Oracle Lead Functional Consultant
Responsibilities:
- Gathered requirements and provided solutions for integration of systems.
- Designed various BRD’s. Performed gap analysis and undertaken providing BR100 and MD 050 for the extensions.
- Functional resource for the implementation of LE and Operating Units for RHD Corp.
- Functional resource for Account Payables Conversion. Configured AME (Oracle Approvals Management) to implement Invoice approval according to client requirements.
- Design BRD to the implementation teams for integrating Sabrix with AP/Purchasing for automation of Sales Tax/Use Tax calculation.
- Performed Setups in Inventory and involved in creating Item Master.
- Followed AIM methodology for implementation and documentation.
- Implemented according to SOX and Audit compliance.
Environment: Oracle Financial Applications 11.5.10.2 (GL, AP, PO, INV, Sabrix Tax)
Confidential, Atlanta, GA
Oracle Functional Consultant
Responsibilities:
- Create new LE, Company (for Transaction DFF), Pay groups (to be used with new LE entity payments) under Multi-Org structure
- Business Indicators (for Management Entity required in Transaction DFF)
- New AR Transactions, Create New Supplier sites, Customer sites.
- New value sets for Customers and Suppliers Inter-company relationships
- New Tax Codes for VAT and Creating new value sets
- Deployment of Multi-Org structure for the new LE and OU’s.
- Implement New LE in ATL Primary OUTS modification required in line with new LE and Sabrix implementation
- New Bank account for new LE, GECARS needs to be ready for collect the cash separately
- Use same Cash collection process for New LE in N01
- Customer master data maintenance to review tax exempt and SO type defaulting in Primary OU
- Book Sales, Release Holds, Pick Release, and Create Delivery and Move Transactions.
- Reports and Analysis through Excel
- E2E Testing, Knowledge Transfer and User Training & Support
Environment: Oracle Financial Applications 11.5.9 (GL, AR, AP and OM)
Confidential, San Ramon, C.A
Functional Consultant
Responsibilities:
- Addressed operational problems, concerns, and questions posed by users.
- Business Process Study, Business Requirement Analysis and BRDs for the new business initiatives.
- Oracle Receivables and Accounts Payable and GL Support.
- Help business in Period close related issues, identify issues preventing period close with IT co-ordination and resolve them timely.
- Help business in period close supporting
- Testing &Training.
Environment: Oracle Financial Applications 11.5.9, (AR, AP and GL)