We provide IT Staff Augmentation Services!

Oracle Business Systems Analyst Resume

5.00/5 (Submit Your Rating)

Verifone, CA

SUMMARY:

  • 12+ years of IT Experience in Distribution, Manufacturing, Medical care, Health care, Finance and Retail Industries
  • 10+ Years of experience in ERP Oracle E - Business Suite 11i, R12
  • Developed Business solutions by Translate stakeholder requirements into over various tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
  • Analyze & Prioritize client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis and supported deployment planning with risk mitigation process.
  • Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint, Visio) and preparing End-User training documentation using UPK-Universal Productivity Kit Oracle tool.
  • Liaise between business and technical personnel to ensure a mutual understanding of processes and applications by aligning business requirements to functional and technical requirements.
  • Competent in Implementation, Enhancements & Production Support for ERP Packages.
  • Extensive experience on Oracle Upgrade projects, Order-To-Cash, Quote to cash, Back2Back and Procure-To-Pay Process on Oracle EBS. Expertise in Purchasing (PO), Inventory(INV), Order management(OM), Warehouse management (WMS), Quality, Mobile supply chain application(MSCA), ASCP, General Ledger(GL), Payables(AP), Receivables(AR), Install Base(IB), Service Contract(OKS), Sourcing, (SLM),iProcurement,iSourcing,iSupplier,Shipping,E-Commerce Gateway SOA Suite 11g and OBIA 11g.
  • Experience in the Implementation, Development and Support of Oracle Business Intelligence Applications (Informatica, OBIA,OBIEE, DAC,ODI).
  • Experience in PL/SQL Development and expert in SQL queries with any complex joins
  • Experience in developing functional specifications for extensions, integrations, configuration of application modules train application functionality and data migrations
  • Experienced with EDI standards and processing 850-PO, 856-ASN, 810-Invoice and 855-Ack for Distribution client.
  • Experience in Project with SDLC methodologies: Agile, V-model & Waterfall modules process standards
  • Specialist as a Software Quality Assurance in creating Project Estimates, Metrics, preparing Test Strategies, Test Plans, developing & reviewing Test Cases for Black-box, Functional, Regression, End-2-End, Integration, Database, Performance, User Acceptance Testing, Defect Tracking and Reporting.
  • Expert in test management tool HP ALM 11.5 and configuration management tool VSS, SharePoint & JIR
  • Liaise between business and technical personnel to ensure a mutual understanding of processes and applications by aligning business requirements to functional and technical requirements.
  • Competent in multiple Implementations, Enhancements & Production Support for ERP Packages
  • Refer to the Specific Details on ERP & CRM Implementation and Upgrade experience on Page 5

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite 11i/R12, Oracle Fusion Applications, e-Commerce gateway, EDI

Languages: Java, SQL, PL/SQL, C, C++.

Business Intelligence: OBIEE, OBIA (BI Apps), ODI, FSM, DAC, Informatica, XML Publisher, BI Publisher

Middleware: SOA Suite 11g, XML, XPATH,XSLT,BPEL, AIA, B2B, etc

Databases: Oracle 8i/9i/10g/11g, MS Access, SQL Server 2000, MYSQL.

Web Tools: HTML, Java Script, JSP, MS Front page.

Office Applications: MS-Office.

Tools: Oracle Reports 6i/9i/10g, Oracle Forms 6i/10g, Oracle Developer, Oracle Discoverer 9i/10g, OBIEE, DAC,ODI, TOAD, SQL Navigator, and Workflow Builder.

Operating Systems: UNIX, & Linux, Windows98/XP, Windows NT.

PROFESSIONAL EXPERIENCE:

Confidential, Verifone, CA

Oracle Business Systems Analyst

Responsibilities:

  • MD50 Functional Design Document Prep, Flow Diagrams
  • Created BR100 Setup document, Review and Mapping of MD70 to Functional Design Document MD50 for Oracle Supply Chain, Procurement, Manufacturing and Finance areas.
  • Project management, Status Reporting, Communication with Stakeholders on risk and mitigation strategy and aligning Business, Functional, Development and Testing team for project delivery
  • Responsible for coordinating activities of teams, schedules and resources for assigned tasks or project
  • Created test plans, test cases, test scripts and performed functional testing, SIT, UAT.
  • Responsible for Functional design, configuration change, setup, test, implementation and Production support for Oracle Applications.
  • Worked on B2B integrations, EDI mappings, configurations and changes on EDIFACT based transaction sets including 850, 855, 856,846, etc. Designed and Implemented new EDIFACT messages with 1EDISource

Environment: Oracle E-Business Suite R12, PLSQL, 1EDISource, ASCP, EDI, WINDOWS

Confidential, Atlanta, GA

Oracle Business Analyst

Responsibilities:

  • Created BR100 Setup document, Review and Mapping of MD70 to Functional Design Document MD50 for Supply Chain, Procurement & Finance Areas.
  • Created test plans, test cases, test scripts and performed functional testing, SIT, UAT.
  • Assisted developers - internal and external - through provision of functional specifications and technical walk through
  • Implemented Punch-out to supplier-hosted sites set ups as stores to select items, returning to iProcurement for checkout and approval, BPA lines upload, etc.
  • Configured Information templates to capture additional information specific to client business requirements.
  • Responsible for overall Sourcing cycle and complete end to end negotiation process with Contracts Terms & Conditions.
  • Involved in Preparation of Two stage evaluation of RFP/RFQ, and Preparation of Auction/RFI/RFQ’s.
  • Developed Templates for RFI, RFQ and Auctions based Categories and Commodities
  • Configured Contracts Templates in Procurement Contracts
  • Create test plans, test cases, test scripts and performed functional testing, SIT, UAT.

Environment: Oracle E-Business Suite R12(iProcurement,iSupplier,Sourcing,Service procurement,eAM, PO,etc) HP-ALM, PLSQL, Oracle Fusion Applications, CLARITY, MMAT, WINDOWS

Confidential, NC

Oracle Functional Consultant

Responsibilities:

  • SME in Supply Chain modules, Responsible for functional design
  • Configuration change, setup, test and implementation for the Oracle Supply Chain, Ware managements, Business Intelligence, Procurement, etc areas
  • Providing solution to the pain areas of the Business in the form of Enhancements (BUS) tickets to meet Business requirements
  • Reading logs, troubleshooting, finding errors, work with developers to get errors fixed in the customized environment
  • Design Documentation & Test deliverables (Planning, Preparation, Leading Execution and Reporting)

Confidential, MD

Oracle EBS/OBIA Consultant

Responsibilities:

  • Responsible for Functional design, Development, configuration change, setup, customizations, test and implementation for the Oracle Supply Chain and Finance areas
  • Bug fixing/Root cause Analysis of the Production issues, involved in Data Cleanup Objects
  • Design Documentation & Test deliverables (Planning, Preparation, Execution and Reporting)
  • Involved in the OBIA R12 Impact analysis
  • R12 Upgrade remediation, Designing and approach and production support issues handling used available system tools (BI, SQL, Oracle reporting tools) to gather and prepare data for reports and analytical tasks. Enhancing the existing Custom BIAPPS reports.

Environment: Oracle EBS Apps R12, OBIA 11g, OBIEE, ODI, DAC,ORACLE 11g, PL/SQL, Toad 10, SQL*PLUS, UNIX.

Confidential, New York

Oracle Lead Functional Analyst

Responsibilities:

  • Responsible for Functional design, Development, configuration change, conducting CRPs, setup, customizations, test and implementation for the Oracle Applications
  • Project management, Status Reporting, Communication with Stakeholders on risk and mitigation strategy and aligning Business,
  • Functional, Development and Testing team for project delivery,
  • Facilitate the onsite-offshore co-ordination during design and all the phases of project schedule and Identified process improvements work with business partners effectively to implement change including training.
  • Worked on Sales order processing, AR interfaces and other transactions to Xerox systems using Oracle SOA suite 11g (Oracle fusion middleware)
  • Responsible for coordinating activities of teams, schedules and resources for assigned tasks or project

Environment: Oracle EBS Applications R12, SOA Suite 11g, OBIEE, OBIA 11g,Oracle Database 10g, Discoverer9i/ 10g, UNIX, BI Reports and Forms.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

  • Responsible for Design, Development, setup, customizations, conversions, migration, data extractions, test and implementation for the Oracle Applications, Status Reporting.

Environment: E-Business Suite 11i/R12, Release 11.5.10.2 Toad, Shell Scripts, SQL, PL/SQL, Oracle, Oracle Reports 6i, Windows NT/XP.

Confidential, PA

Oracle Techno Functional Consultant/Project Lead

Responsibilities:

  • Responsible for Design, Development, configuration change, setup, customizations, test, Production Support for the Oracle Supply Chain, CRM and Finance areas
  • Responsible for Development, setup, customizations
  • Production support Change Requests, Enhancements, test and implementation for the Oracle Applications
  • Project management, project tracking, resource management, Value adds, Lessons learnt, Process improvements, status reporting, issues/risks management, supporting the month end activities in Oracle for period closure.

Environment: E-Business Suite 11i, Toad, Shell Scripts, SQL, PL/SQL, Oracle, Oracle Reports 6i, Windows NT/XP.

Confidential

Oracle Techno Functional Consultant/Oracle EBS Analyst

Responsibilities:

  • Worked at Client’s place (London) initially and involved in direct interaction with the business and users while resolving few issues and working on few enhancements
  • Responsible for Design, Development, configuration change, setup, customizations, test and implementation for the Oracle Supply Chain and Finance areas, EDI.
  • Requirement gathering and provision of various extracts on customer,etc data for A2B migration/Conversion purposes
  • Raised SRs and coordinated with Oracle support in resolving few issues
  • Involved in resolving the EDI production issues resolving on daily basis and Studied & Updated the existing BR100 documents by doing GAP analysis

Environment: E-Business suite 11i,Inovis,e-Commerce Gateway,Toad, Shell Scripts, SQL, PL/SQL, Oracle, Oracle Reports 6i, Windows NT/XP.

Confidential

Oracle Techno functional Consultant

Responsibilities:

  • Developed Technical Specification documents for RICE objects
  • Development of RICE objects, conversion process and Application Setup documents for the modules implemented Technical Documentation Based on AIM Methodology
  • Involved in the functional testing

Environment: Oracle EBS Suite 11i, ORACLE 9i, PL/SQL, Toad 10, SQL*PLUS, UNIX, WINDOWS

Confidential

Oracle Techno functional Consultant

Responsibilities:

  • Developed Technical Specification documents for RICE objects, Development of RICE objects, conversion process and Application Setup documents for the modules implemented, Technical Documentation Based on AIM Methodology and Raising Metalink TAR’s for the Priority issues with Oracle.

Environment: Oracle EBS Suite 11i, ORACLE 9i, PL/SQL, Toad 10, SQL*PLUS, UNIX, WINDOWS

We'd love your feedback!