We provide IT Staff Augmentation Services!

Oracle Functional Consulant Resume

0/5 (Submit Your Rating)

Franklin Lakes, NJ

SUMMARY

  • Over 9 years of experience with Oracle Financials, SCMS(Supply Chain) and HRMS(Human Resource) implementation life cycles - from understanding business requirements, fit-gap analysis, configuration, testing and end-user training to post-implementation support.
  • Implementation & Configration of: General Ledger, Accounts Payable & Receivable, Fixed Assets, Cash Management, Project Cost & Billing
  • Hands on experience in Time & Labor, iExpenses, Treasury Management, Order Management and Inventory, Human Resources modules worked on Procure to Pay, Order to Cash and Record to Report processes
  • Intercompany accounting in GL in Oracle 11i(GIS) and R12 (AGIS)
  • Implementation of multiple development lifecycle systems using AIM framework
  • Interpersonal skills, flair for learning new technologies, client interaction, team participation and delivery
  • Good at end-to-end process from gathering requirements to define scope, gap analysis, configure, develop, test, change management to deploy and post production support functions.
  • Excellent noledge of various Software Development Life Cycle methodologies. Experienced in both Waterfall and Agile methodologies using SCRUM techniques.
  • Proficient in UML with a good understanding of data flow diagrams, use Case diagrams, Sequence diagrams and Activity diagrams.
  • Experienced in working with QA teams and assisting the QA team with identifying test cases and coordinating User Acceptance Testing (UAT) sessions.
  • Proficient in creating data mapping documents for data models to facilitate data transformation and reporting.
  • Implementation/upgrade/rollout/support of Oracle E-Business Suite 11i/R12
  • Worked on gathering, building, designing, testing and go-live phases of Oracle E-Business Suite Financial Modules
  • Financial accounting and business processes, including: financial closing, revenue and expense cash/accrual concepts, adjustments and financial statements
  • Writing SQL queries for extracting database information
  • Worked on Oracle 11i & R12 functional modules and organizational accounting structure

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

Oracle Functional Consulant

Responsibilities:

  • Led Onsite & Offshore teams for Account to Report and Assets to Retire tracks as SME and designed GL architecture with primary ledger and secondary ledgers
  • Designed and implemented currency rates interface from Bloomberg
  • Interpreted accounting requirements for application design & setup
  • Identified technical requirements and legacy system interfaces
  • Implemented FA module
  • Preparation of BRD (Business Requirement Documents & FSD (Functional Specification Document)
  • Implemented the new features and new reports
  • Assisted technical team with the customized reports development
  • Designed GL balances and Assets Conversion using web ADI
  • Documented requirements of each subsidiary for General Ledger and Fixed Assets modules
  • Identified technical, data conversion and legacy interface requirements from the fit gap analysis
  • Ran CRP sessions on General Ledger & Fixed Assets modules to show standard functionality
  • Updated BR100 document with new R12 implementation requirements
  • Trained business users on Oracle functionalities
  • Gatheird user requirements through interviews, surveys, and worked with team to identify gaps and defects.
  • Developed and maintained RTM (Requirement Traceability Matrix) and conducted requirements and design walkthroughs with designers, developers and management staff.
  • Assisted the project manager in documenting meeting agenda and minutes of the meeting.
  • Developed several SQL queries to understand the data and data-relationships.
  • Created use cases and corresponding test cases from requirements using QTP.
  • Conducted requirements workshops with developers and testers.
  • Reviewed the functional specifications & obtained sign-off from Business Lead

Confidential, Mclean VA

Oracle Functional Consulant/Business Analyst

Responsibilities:

  • Oracle Applications Version 11i (11.5.10) Modules: GL, AP, AR, FA, CM and iExpenses
  • Custom Rev Rec and COGS Rec Modules
  • Involved in Requirement gathering
  • Module configuration for GL,AR,AP,FA,CM and iExpenses
  • Performed fit/gap analysis
  • Pre-production business testing CRP me,II, and III Training for Key Users
  • Interface and conversion mapping and related documentation deliverables viz., Common Application Setup, BR100, MD 50
  • Procure to Pay - AP to GL Reconciliation - Bank Reconciliation using Cash Management
  • Order to Cash - AR to GL Reconciliation - Bank Reconciliation using Cash Management Module
  • Resolving various issues relating to data conversion
  • Guiding technical consultants in developing various reports viz check printing from AP Module using XML Publisher
  • Custom Module Built for Software - Subscription/License Services
  • Ironport (which was acquired by Cisco during 2007) is a leading seller of Email, Web Security, Spam Protection, Anti-Virus, other related s/w and Training on the products
  • The business involves selling the hardware, software on a subscription/license basis and also dealing with 3rd party software and hardware for which Royalty related accounting has to be generated
  • Each product and service had its own rules of recognizing revenue, deferring the revenue, and charging appropriate cost against that product or service
  • their was a GAP in the standard oracle functionality to deliver the requirement, so the requirements were gatheird and using the inputs from Standard Oracle AR, OM, Inventory modules custom rules were created and TWO small custom modules were developed on the inputs from the client

Confidential

Business Analyst

Responsibilities:

  • Worked on financials, SCM and HRMS module as a functional consultant.
  • Prepared requirements, specifications, business processes and recommendations.
  • Analyzed customer business and competitive position of industry.
  • Defined test conditions and develop accurate and complete test plans.
  • Identified and document system deficiencies and recommend solutions.
  • Designed flow diagrams using Microsoft Visio for more complex user stories.
  • Used JIRA Server to enter all user stories as Product Backlog items.
  • Worked with the development team in clarifying requirements issues.
  • Conducted sprint planning meeting, various review meetings and client team meeting.
  • Participated in daily stand up meeting with the team.
  • Worked closely with the QA team and assisted them in identifying test cases and test scenarios.
  • Assisted the QA team in testing the system in each sprint.
  • Assisted the QA team in identifying test cases for automation.
  • Participated in defect review meetings at the beginning of each sprint to identify defects carried over from the previous sprint.
  • Conducted testing whenever required.
  • Coordinated with Oracle SR team for resolution of issues
  • Acted as a bridge between technical team and different department for development of reports
  • GAP analysis to identify essential customizations and workarounds.
  • Gatheird and reworking client data for input into the system.
  • Carry out BPR (Business Process Review) to understand the current processes of Client.
  • Creation of CRP (Conference Room Pilot) to demonstrate system to the Client.

Confidential

Business Analyst

Responsibilities:

  • Coordinated with reports development team to transfer requirements wherever required.
  • Performed UAT (User acceptance test) of reports already developed and also for newly
  • Developed reports before formal release to users.
  • Collected queries from different departments and solve accordingly with technical teams.
  • Developed Reports layouts and parameterization as per instructions of ERP head.
  • Supported in all financials and non financials functional responsibilities.
  • Monitored new ERP trends to identify potential benefits and risk analysis.
  • Reviewed of Functional Design Documents and Give training to end users on Documents and changes.
  • Assisted ERP head by providing required data from application to resolve the SR from Oracle.
  • Tested of all modules financials and non-financials modules
  • Used following financial & non-financial modules of Oracle R-12:
  • Oracle Payable
  • Oracle Business Intelligence
  • Oracle Receivables
  • Oracle Cash Management
  • Oracle General Ledger
  • Oracle Assets
  • Order Management
  • Oracle FSG Reports
  • Oracle Purchase Management
  • Oracle Inventory

We'd love your feedback!