CAREER SUMMARY:

• I am a self - motivated Senior Oracle ERP Consultant with 13+ years of in depth experience in implementation, Upgradation, Enhancements of Supply chain and Finance Applications in Telecom, Networking & Manufacturing domains.
• My professional expertise includes strong Analytical and Problem-solving skills coupled with outstanding Communication, Presentation and Leadership abilities.
• Excellent Customer Requirements Analysis, Impact & Gap Analysis, Test Management, Defect Management, Production Support
• Oracle Certified Implementation Specialist-Accounts Receivables
• Oracle certified Associate
• Change Management and Release Management Consultant
• Extensive exposure in ERP implementation and upgradation of Oracle Applications R12 in HCM, ASCP, Demantra, Order Management, Advance Scheduler, Purchasing, Inventory, Accounts Receivables, General Ledger, Accounts Payables. Basic Pricing Shipping Execution & Tax Configuration.

SKILL:

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, Salem, OR

Senior Oracle Business System Analyst

Responsibilities:

• Analyzing the Business Systems in Worker’s Compensation Division and Oracle Databases.
• Functional configurations and Technical components ownership
• Creating and reviewing Business analysis documents and suggesting process improvement
• Reverse engineering of existing databases to create Entity Relationship Diagrams (ERD) and logical data models and data dictionaries
• Conducting highly technical complex strategy, planning, and problem-solving discussions.
• Distill highly complex and technical concepts to non-technical stakeholders and high-level Decision makers & Oregon’s State Chief Information Officer (CIO)’s office
• Analyze/Create Business Requirements and functional specifications document deliverables

Confidential, Lincolnshire, IL

Oracle Functional Lead

Responsibilities:

• 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

Oracle Apps Techno Functional Consultant Lead

Responsibilities:

• Implemented the End to End solution for merging two warehouses aimed at day to day Operational Efficiency & Cost Optimization.
• Upgraded Oracle version 12.1.2 to 12.1.3
• Technical and Functional analysis for multiple functionalities and customizations in Oracle AR and OM, Manufacturing and Shipping and Third party Logistics.
• Delivered customizations Sales order Mass updates, Sales order Attachment Conversions, Item Conversion, On hand quantity conversion, Master Labels, Related Items conversion, Pick slip reports, Master Labels, OAF customizations, XMLP Reports, Invoice creation, Customer Master Specific customizations.
• Post Production support, writing and executing sqls to provide Data for Business users for validation and reconciliation.

Confidential, Schaumburg, IL

Techno functional Consultant Lead and Backup PM

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, IR/ISO, Accounts Receivables, Intercompany AP/AR, Demantra, TMS

Confidential, Sunnyvale, CA

IT Business Systems 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 - HCM, Oracle Order to Cash, CPQ, 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

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 HCM, Invoice Conversion, Auto Lockbox, 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 and 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.
• Configuration, Integration of Demantra
• 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

Business Systems Analyst - Onsite Techno functional Consultant

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

Techno Functional Consultant

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 including TIBCO EMS/BW
• 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, obtaining Technical Design sign off, IT Testing Customer Acceptance Testing support and Production Deployment.

Confidential

Sr.BSA & Test Lead

Responsibilities:

• Analyzed 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:

• 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.

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.