PROFILE SUMMARY:

• 10+ years of IT experience and working as a Lead Oracle Techno Functional Consultant in Finance, Telecom, Supply Chain modules possessing strong analytical and problem - solving skills coupled with outstanding communication, presentation and leadership abilities.
• Rich Technical and Functional Knowledge on Oracle AR and OM modules
• Excellent Business Communication, Customer Requirements Analysis, Gap Analysis
• Oracle Certified Implementation Specialist-Accounts Receivables
• ISQTB Certified Testing Specialist
• Oracle certified Associate
• Certified in Computer Applications
• Change Management Consultant

SKILLS:

Requirements, Planning Management: Risk/Mitigation plans

Requirements Elicitation: Requirements Analysis Documentation

Requirements Communication: Solution, Assessment Validation

Diagramming Techniques: Activity diagram, Use Case Model, Sequence diagram, Flowchart

Software: EBS: Oracle R12 & 11i, MS Project, Microsoft ProfessionalHP Quality Center, Kintana, Visio 2010, MS Office,Lotus Notes 4.11

Languages: SQL, PLSQL, C++ & C, HTML

Database: Oracle DB

Reporting Tools: XMLP, BI

EXPERIENCE:

Confidential, Schaumburg, IL

Lead Oracle Techno Functional Consultant

Responsibilities:

• Leading the Onsite and Offshore Global Development Teams, and employ SDLC for the purpose of monitoring the project and also prepare Work based Structures for the team.
• Functional analysis for deploying new Org structures, involving configuration for Finance Track
• Set Milestones based on Project timeline, Resource Planning and prepared Cost Budget Allocation based on the Milestones
• Facilitate sessions with Senior Project Management, Business Process owners and other stakeholders to define the Project and timelines
• Gathered business requirements through interviewing internal business users, external partners who were EDI translators and Third party Logistics providers
• Analyze business requirements and segregate them into Use Cases. Created Use case diagrams, activity diagrams using Microsoft Visio, PowerPoint
• Documented the proof of concept, Solution design and reviewed with Business Leads
• Maintain the Oracle and FMW Instance Strategy for the entire Build cycle and prepared Functional Specification Document (FSD) for the Oracle Tracks (D2D, Q2O, I2R) in scope.
• Participated in datamodeling,planning, designing,and implementationof thefinal system. Produced data mapping and data definition documentation.
• Gathered the Business requirements for German VAT Tax calculation and Reverse charges (Germany statutory)and driven the solution.
• Work with multiple Vendor Development teams across the globe involving Oracle PLSQL, Fusion Middleware, Tradesphere, EDI Translation & SAP
• Having exposure to middleware services concepts and support utilities, related database utilities. Demonstrated understanding and experience with PL/SQL Queries.
• Track the Timeline and accelerate the Development cycle based on the risks foreseen and mitigated it through the mitigation plan
• Manage all phases of Testing for assigned components ensuring test plans and test cases are completed and business requirements are met.
• Supporting Project Management activities to drive the Project Schedule
• Create test plan, Walk through, integration approach and strategy document, test cases, scenarios. Managed the Testing team for executing the Test scripts, investigating and Logged Variances/defects and Change Control Requests.
• Support Load Testing by giving them walkthrough of functional flow of application and review testscripts prepared by the team for quality and functionality.
• Followed BMC Change Management process for correcting software bugs and deficiencies based on the testing results and released to the Production environment.
• Driven the Post Go Live warranty support period to monitor and track the transaction, bug fixes enhancement requests and transition to a steady state Support environment

Solution Environment: Oracle Apps R12(12.1.3)

Tools: Microsoft Project Plan, Pl Sql Developer, E2Net Staging console.,MS Office Suite, Toad, Clearcase, Kintana

Confidential, Sunnyvale, CA

Oracle Techno Functional Lead

Responsibilities:

• Studying the entire application management process, procedures, identifying areas for improvements. Defining detailed scope of the engagement and arriving at the Work Breakdown Structure for the project work items
• Functional Analysis on the Order to Cash Cycle and Invoice to Report track,
• Identifying and reviewing new project requirements within Confidential by customer interaction and discussion with the Business users of Confidential
• Prepare project estimation, assigning the functional & technical work to the development teams, coordinate effort estimation & scheduling tasks, arriving at dependencies and pre-requisites and list of deliverables
• Liaising/ Interacting with various onsite & offshore teams, Infrastructure management, SMEs, Holding recurring status and staff meetings on a daily/weekly basis
• Interacting with clients and all stakeholders to determine work priorities
• Followup various teams and escalate issues and risks proactively
• Prepare Project status & metrics using Microsoft Professional and PERT chart expert and reporting to: a. Steering Committee PMO b. Customer Management c. Project stakeholders (IT & Business users)
• Tracking, coordinating, revisiting the plan as required, executing and monitoring the project progress
• Driven the Integration/Functional Testing using HP Quality Center Tool, provide regular status updates and acquire signoff.
• Lead and coordinated end to end support for Performance Test, Load Test and Smoke Test walkthrough of functional flow of application and review testscripts prepared by the team for quality and functionality.
• Followed the Change Management process for correcting software bugs and deficiencies based on the testing results and released to the Production environment.
• Worked on developing the Implementation plan for the entire Enterprise Integration Team supporting multiple enterprise wide applications during Conversion time-period and supported all the Enterprise applications for a smooth transition from the old to the new system.
• Coordinated the process for users, which analyzed their current business practices, user, needs, and then used that information to define functional requirements andRequest for Proposal(RFP) for a new system.
• Managed the Post Production support period until the system is stable and open defects are fixed.
• Present lessons learnt & best practices and handover the work items to Confidential Support teams

Solution Environment: Oracle Apps 11i

Tools: Microsoft Project Plan, Milestone Professional, MS Office Suite, HP Quality Center, Toad Sharepoint, Kintana

Confidential, Schaumburg, IL

Oracle Techno Functional Consultant

Responsibilities:

• Worked as a Oracle Techno Functional Analyst to drive I2R track Business transformation into a Global R12 platform
• Designed the Business requirement collection approach based on the project scope andSDLCMethodology, developed high-level project plan.
• Lead a key position for the Oracle Patch management process and recommended Localizations & Patches for a global implementation.
• Driven the eCommerce Trading Partner setup, Invoice Distribution process including Invoice Printing through XML Publisher and EDI gateways, email etc
• Performed extensive requirement analysis for ANSI 4010 Mapping for EDI 810, Invoice distribution processes
• Support User community to frame Business Requirements and created corresponding Customer requirement Analysis, Development Requirement documents in DOORS modules
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Invoice Creation, Distribution and AR Collection processes
• Identifiedtestdata needs to support test execution; verifyingenvironment readiness forsystemtesting by interacting withrelease engineering.
• Designed and implemented basicSQLqueries for QA testing and report / data validation.
• Developing strategic partnerships with the business unit to develop a solid knowledge base of the businessline, including the business plan, products, and process and revenue streams.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Performed data mining and analysis from different system.
• Provided end to end support for User Acceptance Testing (UAT)
• Full knowledge of most phases of the Systems Development Life Cycle and supported the post Go live warranty period.

Solution Environment: Oracle Apps R12

Tools: Plsql Developer, Microsoft Project Plan, DOORS, MS Office Suite, HP Quality Center, Kintana, Toad

Confidential, Schaumburg, IL

Oracle Techno Functional IT Analyst

Responsibilities:

• Worked as a Oracle Techno Functional IT Analyst and was independently responsible for Delivering Lockbox, Direct Debit, Advanced Collections, Invoice Printing, Automatic Receipt Creation and Statement generation processes.
• Gather Business Requirements and Customer requirement Analysis, created Development Requirement documents in DOORS modules
• Played a key role in analyzing and applying the Oracle Patches recommended through Oracle SRs
• Worked as a Lead IT Analyst for the Confidential Separation activities into two companies
• Created, reviewed and executed the Test scripts based on Business scenarios for System Integration Testing in HP Quality Center and implemented fixes for the defects identified
• Supported the Customer Acceptance Testing across all tracks in the Revenue cycle processing
• Provided the post production support and created reusable artifacts and How to documents for the future references.

Solution Environment: Oracle Apps R12

Tools: Plsql Developer, Microsoft Project Plan, DOORS, MS Office Suite, HP Quality Center, Kintana, Toad

Confidential, Horsham, PA

Oracle Techno Functional Consultant

Responsibilities:

• Worked as a Build Onsite Coordinator for five offshore team members to plan and deploy the deliverables for Order Management and Finance track
• Status reporting to Clients and Team Management.
• Gathered Business Requirements and transformed them in to IT requirements by working with Business Leads and IT SMEs
• Prioritize the release of Enhancements into Production based on Business needs
• Performed IT Testing and driven the Customer Acceptance Testing for signoff and deployed the changes in Production based on the Change Advisory Board recommendations.

Solution Environment: Oracle Apps 11i

Tools: Plsql Developer, MS Office Suite, Kintana, Toad

Confidential

Oracle Techno Functional Lead

Responsibilities:

• Worked as a Project Lead to manage the Resource pool for Delivering the small size projects, enhancements
• Analyzed Business requirements through Production issues and converted them into IT requirements.
• Developed IT design and mentored the team to build and test the changes recommended.
• Status reporting to Clients and Team Management.
• Lead the IT Testing and driven the Customer Acceptance Testing for signoff.
• Deployed the changes in Production based on the Change Advisory Board recommendations.
• Created and Reviewed the solution design with Business Leads and client BSAs for obtaining the Technical Design sign off

Solution Environment: Oracle Apps 11i

Tools: Plsql Developer, MS Office Suite, Kintana, Toad

Confidential

Oracle TechnoFunctional Consulatant & Test Lead

Responsibilities:

• Analysed and developed the PIP integration between Confidential and the 3PLF/3PLT which involved changes in the Confidential hosted systems (ERP’s and such) as well as developing new interfaces for data extraction to the third party logistics
• Conducted workshops with Business Leads and senior leadership team to walkthrough the Testing cycles of the project
• Status reporting to Clients and Team Management.
• Lead for the System Integration Testing cycle for all the end to end Business transactions involved, like PO & PO changes, Sales order and Delivery, ASN, Invoices and RMA
• Driven the Customer Acceptance Testing for signoff and deployed the changes in Production based on the Change Advisory Board recommendations.

Solution Environment: Oracle Apps 11i

Tools: Plsql Developer, MS Office Suite, Kintana, Toad

Confidential

Oracle Techno functional Consultant

Responsibilities:

• Developed interfaces for PO Extraction, ASN import & Receipt Creation, Waybill update customization for Invoice interface to AR, Pay on Receipt Autoinvoice to interface with AP.
• Performed IT Testing and driven the Customer Acceptance Testing for signoff and deployed the changes in Production.

Solution Environment: Oracle Apps 11i

Tools: Plsql Developer, MS Office Suite, Kintana, Toad

Confidential

Test Lead

Responsibilities:

• Worked as a Test Lead for Buy-Sell Consolidation Project.
• Daily, Weekly Status reporting .to the team and client stake holders.
• Developed Test Strategy, Test Plans, Test Cases in IBM Rational Rose tools
• Followed the SOX compliance process and supported IT/SOX audits for quality and Assurance.
• Performed IT Testing, logged defects and suggested fixes for the functional & technical gaps identified.
• Driven the Customer Acceptance Testing for signoff and deployed the changes in Production

Solution Environment: Oracle Apps 11i

Tools: Plsql Developer, MS Office Suite, Kintana, Toad