Oracle Ebs R12.3 Otc Functional/qa Consultant Resume
Seattle, WA
SUMMARY
- 9+ Years of total IT experience in Analysis of Business Process, system study, and design of new process. Testing of business application process, Development, Training and Enhancement of functionality.
- 7+ Years of experience in various application modules of Oracle Apps eBusiness Suite such as Order Management, Accounts Receivable, Shipping, Pricing, Inventory, General Ledger, Purchasing.
- Good knowledge of AIM methodology and experienced in various documentations including Requirements Analysis, BR.100, MD.50, MD.70 review, BP80, TE 10 etc.
- Hands - on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work around, interfaces, user training.
- Good conceptual understanding of Multi Org in both R12 and 11i environments
- Overall knowledge in implementation and documentation of Order-to-Cash and Procure-to-Pay Business Process flows
- Dealt with Key Interfaces inbound/outbound on General Ledger, Order to Cash and Procure to Pay side
- Usage of different Test tools/Defect Management systems including Test link, HP Quality
TECHNICAL SKILLS
ERP: Oracle Applications 11i/R12M PL/SQL, Toad, Basic understanding of Oracle Objects, Reports, Forms
E-Business suite Modules: Order Management, Inventory, Pricing, Bills of Material, Purchasing, General Ledger, Oracle Payables, Oracle Receivables.
Analytics: OBIEE
PROFESSIONAL EXPERIENCE
Confidential, Seattle WA
Oracle EBS R12.3 OTC Functional/QA Consultant
Responsibilities:
- Handled the complete Order to Cash cycle involving Order Management systems with integration into Oracle Receivables, General Ledger and Cash Management systems
- Work closely with the related teams in the Confidential for End to End Technology stack comprising Confidential IODS for order entry, WEBADI application for AR Transaction that includes standard, Invoice with Invoice rule and schedule billing, Media Solution Revenue Recognition, Auto reconciliation using bank statement in XML, Invoice print, customer statement and other respective reports like, Forecast Revenue Report, Aging Report with Multi currencies etc.
- Coordinate Design, documentation and Testing process involving Offshore testers for various test cycles including Unit, Regression and User Acceptance testing
- Worked closely with Automation analysts to provide functional inputs to help with test automation
- Recognized as group expert for OTC processes and share expertise with others. Detect underlying problems and work out solutions.
- Maintained a high quality in a complex and constantly evolving environment
- Worked with various peer Analysts, Dev and Test teams to review functional and technical specifications to promote quality in the early stages of the project
- Created & Executed test cases, Reports & Track Test execution and Defect metrics for projects and enhancements using sophisticated test (Testlink)and Defect management tools (Jira)
- Managed various documentation on business flow of Hotel Collect and Confidential Media Solution and created test scripts on OTC RICE objects.
- Co-ordinate solution meetings with various end users to iterate the OTC processes until it meets the business requirements criteria
Confidential, CA
Sr. Functional Consultant
Responsibilities:
- Defining the functionality in Distribution modules (Order to Cash).
- Defining Setups in Inventory, Order management, shipping execution, purchasing.
- Processing of orders Mixed orders and Returns, Drop shipment. Planning of Holds and Credit management for the customers
- Setting up shipping related setups for proper scheduling and deliveries of the booked orders
- Respond and Resolve user Queries related to Field Service, Install Base, Service contracts, Teleservices.
- Involved in development and support of the solution development architecture, technical architecture and operations architecture.
- Analyzing the issue, and confirm setup environment based on the requirement.
- Functionality testing of the Tool/Application to meet the requirements.
- Defining Setups in the modules.
- Following quality methods while delivering the solution in various activities related to functional issues, setups and some part of Technical related issues.
- Understanding the requirement or issue to provide better solution relatively
- Understanding the work flows and suggest the proper set up for the transactions.
- Development of functional specifications through interacting with client.
- Coordinating with the technical team in development in getting best resolution for task.
- Development of test plans and prepare test scenarios/Test scripts using OATS. Test cycles included Order Entry, Shipping, Autoinvoice process, AR Transactions, Receipts, Amortizations (waterfall), Create Accounting, GL postings, GL JE reviews
- Involved in User Acceptance Testing, Quality Assurance and patch testing.
- Perform gap analysis between application and customer requirements, analyze requirements and create detailed design documentation to meet customer requirements.
- Coordinated activities with users team correcting bugs and re-testing while meeting project deadlines. Facilitated discussions with end-users / managers to gather functional requirements.
- Understanding the integration between other legacy system applications and Oracle applications to provide correct solution for fixing the issue
Confidential
Oracle Apps Functional Consultant
Responsibilities:
- Understanding the Business process workflow based on the client’s requirement specification
- Involved in End to End SCM implementation from Business requirement gatherings till Post Go-Live support
- Design and Implementation of SCM India Localization based on DC Business requirements
- Configuring Business objects, which are required for the workflow of clients business
- Configuring every module and testing each and every module of SCM based on the client’s business
- Analysis of the specifications provided by the clients and turning into Business Deliverables
- Designing of new Reports and packages related to the reports.
- Unit testing/System Integration testing involved loading test scripts into Test link and logging defects in Mantis for OM, AR, PO, AP and GL cycles for various test scenarios/scripts.
- Involved India localization setups and other standard configurations
- Solving critical issues related to reports.
- Involved in Post go live support and resolved critical issues
Confidential
Oracle Apps SCM Functional Consultant
Responsibilities:
- Oracle Order to cash including AR and GL transfers
- Documented business requirements and functional design
- Effectively participated in AS IS and TO BE process
- Mapped business requirements and application offerings
- Worked in FIT GAP Analysis effectively
Confidential
Environment: Oracle Applications 11i and R12 instance in modules Order Management, Inventory, Financial, HRMS, Purchasing
Responsibilities:
- Involved in End to end Implementation i.e. Requirement Gathering, Feasibility Study, Gap Analysis, System Implementation, Unit Testing, System Integration Testing, Market go live and Post Implementation Support.
- Study of client existing business process model, capturing the client all requirements and modeling Future Process Model.
- Preparation of all required documents like MD050, RD020, BR100, TE040 (Test Scripts) and End User Training Manuals.
- Interacting and training end users.
- Active participation in enhancements of previous implemented sites of other divisions.
- Involved in Functional Analysis of user requirements and Interface design.
- Involved in CRP and Support Training sessions.
- Working with Oracle Support for resolving Critical and Transactional Issues through SR’s
- Extensive coordination with Finance Support team in solving their queries and helping them understand the customization done during Post Implementation Support.
- Active member of initiative team, involved in root cause analysis and fixing the recurring issues
- Preparing Functional design and Test Scripts for Interfaces and Reports
- Taking Interactive Knowledge sessions with various Teams for transitions.
Confidential
Functional Consultant
Responsibilities:
- Understanding the current business processes and find the gaps and providing feasible, simple workarounds while meeting the business needs.
- Closely coordinated with business users and technical team.
- Thorough quality testing in various business perspectives.
- Thoroughly monitor the tickets raised & applied problem management.
- Thoroughly monitor the tickets raised by the user group.
- Plan and distribute issue tickets to concerned technical or functional consultants.
- Close follow up for early and permanent resolution of the issues raised
- Discuss and understand the root cause of the issue and avoid repetition.
- Generate and manage periodical reports on the performance of the team and status of the issues raised.
- Actively participate in the steering committee meeting for improved time lines.
- Conduct meeting with Oracle on Weekly basis regarding Service Request’s.
- Effective coordination with onsite/off-shore technical team
- Supported the Program Manager in managing project related issues like weekly/monthly project status reports, timely submission of quality deliverables, better integration in the processes, attending steering committee meetings, pending issue resolution etc.
Confidential
Environment: Oracle Apps Ver.R12
Functional Consultant
Responsibilities:
- Migration of data from existing legacy system to ERP.
- Preparing a feasibility study of the system and interacted with the client for improvements on the existing system of reporting.
- Performed analysis and study of clients’ organization structure, existing business processes and new business needs to gather functional requirements for the trial implementation of oracle financials modules. And set up of Multi-Org Structure
- GAP Analysis and mapping of existing processes & systems
- Preparing the Document
- Creation / updating of SOP documents
- Guiding the users in PROD/UAT instance.
- Preparing the Data and loading and reconciling to legacy System entries.
- Trained the client’s employees on ERP system
Confidential
Functional Consultant
Responsibilities:
- Involved in Analysis, Designing, Development and Reviewing the Tasks assigned to the Team.
- Actively involved in work allocation to the team and tracking it till its closure.
- Conducted meetings with QA Team to provide the updates on the development we did for the assigned tasks.
- Involved in Client Meetings on providing the progress details of the tasks assigned to us.
- Involved in providing the application related training to the team.
- Actively involved in coordination & communication with the Client to get the requirement details.
Confidential
Functional Consultant
Responsibilities:
- Implemented Oracle Purchasing module.
- Setup the purchasing hierarchies for all the units.
- Developed along with technical team custom reports like PO printing.
- Developed & tested a number of personalization’s on the PO forms in order to meet the business requirements.