CAREER SUMMARY:

Self motivated Oracle EBS Consultant who gained in depth knowledge from Project Inception to Close out, over these 13+ years of IT experience. Proven strong Analytical and Problem - solving skills coupled with outstanding Communication, Presentation and Leadership abilities.

SKILL:

• Oracle Applications Professional with over four years of experience in implementation of OM & AR modules of Oracle E-Business Suite.
• Excellent Customer Requirements Analysis, Impact & Gap Analysis, Test Management, Defect Management, Production Support
• Oracle Certified Implementation Specialist-Accounts Receivables
• ISQTB Certified Testing Specialist
• Oracle certified Associate
• Change Management and Release Management Consultant
• Expertise in preparing functional design, BR, FSD,TD (Oracle AIM standards), Test Scripts & Results, Configuration Documents, Master Components List, Release Schedule/Cutover Plan, End User Training and Knowledge Transition to Support team, lessons learnt & best practices, reusable artifacts and How to documents for the future references.
• Ability to work with Cross-functional teams, Multiple vendors and cross track Teams..
• Specialties: Extensive exposure in ERP implementation using Oracle Applications 11i and R12 in
• Oracle Order Management
• Oracle Inventory
• Oracle Purchasing
• Basic Pricing and Shipping Execution
• AIM Documentation

KNOWLEDGE AREA:

Tasks & Deliverables: Requirements, Planning Management

Risk/Mitigation plans: Requirements Elicitation

Requirements Analysis Documentation: Requirements Communication

Solution, Assessment Validation (Testing): Diagramming Techniques

Activity diagram, Use Case Model, Sequence diagram, Flowchart: Oracle ERP

Technical and Functional Competence in versions: R 12.1.3/11.5.5/11.5.9/11.5.10/ 11.0.3/ 10.7

Tools: et: HP ALM, Soap UI, HP Quality Center, IBM Rational Rose, MS Project, MS Professional, Visio 2010, JIRA, Lotus Notes 4.11, PLSQL DeveloperSQL Developer, Toad, Workflow Builder, Forms/Reports BuilderE2Net Staging console, Clearcase, Kintana

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

Database: Oracle DB

Reporting Tools: XMLP, BI, Discoverer

CURRENT EXPERIENCE:

Confidential, Lincolnshire, IL

Oracle Functional Lead

Responsibilities:

• Technical and Functional Consulting and Quality Assurance with 3PL Integrations covering Oracle Order to Cash, Forecast to Pay, Integration with Third party Logistics and Finance Tracks
• Strategizing the Test Cycles, Test Management & Defect Management for Release 1 rollout
• Review customer requirements to map them into Design components and Test Scenarios.
• Reviewing and Manage Defects by hosting Defect Triage Calls with Clients to determine priority fix and work arounds.
• Providing Solution Designs and conducting Stake holder review for sign-offs

Confidential, Grafton, WI

Senior Oracle Consultant

Responsibilities:

• Implemented the End to End solution for merging two warehouses aimed at day to day Operational Efficiency & Cost Optimization
• Technical and Functional analysis in Oracle Order to Cash and Supply chain, Logistics, Accounts Receivables, EDI area for multiple Oracle upgrades, enhancements, migrations
• Delivered Item Conversion, On hand quantity conversion, Sales order updates, Master Labels, Related Items conversion, Sales order Mass updates, Pick slip reports, Master Labels, XMLP Reports, Invoice creation, Customer Master Specific customizations, Sales order Attachment Conversions
• Support for Month End Processing, Pricing issues, periodically monitoring Stuck Invoices, Stuck material transactions and clearing them off apart from suggesting alerts, enhancements for seamless Business operations, Production support and providing User Training as appropriate.

Confidential, Schaumburg, IL

Project Lead - IT Business Systems Analyst

Responsibilities:

• Implemented B2B transactions to enable a new 3PL managed warehouse in EMEA region, from Requirements phase to Post Production support.
• Project IT Lead for 18 member team (Global Delivery - onsite/offshore).
• Responsible for all the Deliverables pertaining to the Oracle Tracks (D2D, Q2O, I2R) in scope.
• Reviewed and maintained EDI specifications for Item Information, Item Maintenance, PO, PO Change/Cancel, Delivery outbound, Delivery/Return Acknowledgment or Shipment Adjustment
• Proved Functional and Technical expertise in R12 Fusion Middleware, Inventory, Purchasing, ASCP, Order Management, Shipping, Accounts Receivables, Intercompany AP/AR apart from Demantra, TMS
• Reviewed and maintained EDI specifications for Item Information & Maintenance, PO,PO Change/Cancel, Delivery outbound, Return Acknowledgment or Shipment Adjustment

Confidential, Sunnyvale, CA

IT Analyst Lead

Responsibilities:

• Implemented a new Trading Legal Entity (Business Structure Realignment)), to support the proposed Juniper Business structure for Tax Benefits and better Reporting purposes
• Delivered the project end to end along by leading a 5 member team .
• Single point of contact for Functional & Technical expertise across tracks - Oracle Order to Cash, Procure to Pay and Invoice to Report.
• Executed and lead the Integration/Functional Testing using HP Quality Center Tool, provide regular status updates and acquired signoff.

Confidential, Schaumburg, IL

Sr.Business Systems Analyst Lead

Responsibilities:

• Implemented Invoice Distribution solution through various modes EDI, Print and Invoice interfaces.
• Represented AR Track for Transformation of MSI Short Cycle Business in SAP Platform & Global Financial process in Oracle 11i into a Global Oracle R12 environment
• Hands on experience on Invoice Conversion, Advance Collections Workbench, Automated Receipts Interface, Customer Master Setups, AGIS, Invoice to Report Track- Revenue Cycle Processes
• Performed extensive analysis for ANSI 4010, 4030 Mapping for EDI 810 and Configured EDI Invoice Outbound Processing through eCommerce Gateway
• Driven the Oracle Patch Management for Localization and R12 Upgrade. Delivered multiple RICEW components pertaining to Accounts Receivable track and received appreciations

Confidential, Schaumburg, IL

IT Business Systems Analyst

Responsibilities:

• Worked as a Oracle Consultant to upgrade Confidential Long cycle Business of EMEA region into Oracle R12- Order Management an d AR Implementation.
• Was independently responsible for Upgrade/Impact analysis for Lockbox, Direct Debit, Advanced Collections, Invoice Printing, Automatic Receipt Creation and Statement generation processes during R12 upgrade
• Played a key role in analyzing and applying the Oracle Patches recommended for the upgrade through Oracle SRs, performed SIT and supported UAT
• Lead IT Analyst Finance Track for the Confidential Separation activities into two companies
• Identified Technical objects and Functional setups containing Company name/logo and lead/develop changes identified
• Analyzed Business requirements & created Development Requirement documents in DOORS modules

Confidential, Horsham, PA

Sr.Business Systems Analyst Onsite Lead

Responsibilities:

• Worked as a Build Onsite Coordinator for five offshore team members to plan and deploy the Production fix deliverables for Order to Cash cycle and Finance track (AP, AR, GL). Customizations in MSI Service Contracts and Depot Repair
• Gathered Business Requirements and transformed them in to IT requirements by working with Business Leads and IT SMEs
• Key resource for Prioritization, IT Testing, UAT support and Release management based on Change Advisory CAB recommendation and Business criticality.
• Followed BMC Change Management process for Production Release

Confidential

Sr.Business Systems Analyst

Responsibilities:

• 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 and Status reporting to Clients and Team Management
• Worked on multiple small projects on Order to Cash cycle and AP, AR, GL module.
• Built and tested RICEW components to load data from Service Contracts and Depot Repair. for Report Generation and allow SAS and TL9000 applications to pull the data off Staging area.
• Responsible for Solution design, Business Review, obtaning Technical Design sign off, IT Testing Customer Acceptance Testing support and Production Deployment .

Confidential

Sr.BSA 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 RM
• Driven the Customer Acceptance Testing for signoff and deployed the changes in Production based on the Change Advisory Board recommendation.
• Performed extensive analysis, reviewed and made changes pertaining to the Rosettanet PIP integrations

Confidential

Business Systems Analyst

Responsibilities:

• The objective of the Project is to provide solutions and implementation of small enhancements and lite effort projects in 11i system for G&PS Business of Confidential and Home & Networks Business of Confidential in 11.0.3 application
• Developed interfaces for PO Extraction, ASN import & Receipt Creation, Waybill update customization for Invoice interface to AR, Pay on Receipt Auto invoice to interface with AP.
• Performed IT Testing and driven the Customer Acceptance Testing for signoff and deployed the changes in Production.

Confidential

Test Lead

Responsibilities:

• Developed Test Strategy, Test Plans, Test Cases in IBM Rational Rose
• 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 Daily, Weekly Status reporting .to the team and client stake holders..
• Driven the Customer Acceptance Testing for signoff and deployed the changes in Production.