Oracle Business Systems Analyst Resume
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