We provide IT Staff Augmentation Services!

Oracle Ebs & Bi Business Analyst Resume

2.00/5 (Submit Your Rating)

Ukiah, CA

OBJECTIVE:

Seeking a Senior Business Analyst position to implement Business Intelligence, Oracle Financials, Manufacturing applications, CRM, Big Data, Web Applications & Mobile Apps in a dynamic business environment.

SUMMARY:

  • At Confidential worked as Oracle BI Apps Supply Chain lead for BI Apps implementation involving OBIEE, OBIA, Hyperion and DPA ETL Tool.
  • Implemented ASP Aggregator Data Warehouse using Business Objects & Informatica at Confidential .
  • Expertise in implementing Oracle Financials, Manufacturing and CRM in 10.6 - character mode, R10.7 SC, R11.0, R11i and R12.
  • Responsible for delivery of “Upload Manager” BRD - for opening up the tool to Cisco Partners’ involving in gathering requirements, defining business rules and logic and coordinating with IT team for Product development, BAT, UAT, go live and post go live support.
  • Responsible for delivery of Nexgen Services BRD at Cisco’s CPAI Data Warehouse group.
  • Responsible for numerous BAT cycles for Cisco’s SMS3, CSCC and CSPP and participated in war-room support.
  • Responsible for SMS 3. BAT for on boarding new software subscriptions (SAAS) feature to 2-tier tool.
  • Expert on software subscription SAAS business model from Quote to Cash, Service Contracts and Install Base at Cisco.
  • Business Analyst & Project Manager responsible for delivery of 100 Android and IOS Apps.
  • SOX Business Analyst, worked with the following clients, Confidential, UBSN Limited, Keynote Systems, Cypress Semiconductor, IPIX, Ciphergen Biosystems, Looksmart, Epiphany on various SOX projects, refining business processes for SOX, implementing Controls & ERP projects.
  • Strong Functional expertise in Oracle Service Contracts, Install Base, Quote to Contract Conversion (1-Tier & 2 Tier), Contract Management, Contracts Renewals & Contracts Opportunity Management Life Cycle in R12 and R11i.
  • Successfully loaded 100 million records of install based Contract and Contract details at Cisco.
  • More than four years of Oracle Service Contracts & Install Base expertise at Cisco in R12, R11i, 1-Tier Service Contract Quoting, 2-Tier Service Contract Quoting, Contracts Management, Install Base, Oracle Service Contracts.
  • 15 plus years of experience in Oracle Applications implementations and involved as a Functional, Techno-functional and as a Team Lead roles for various client assignments.
  • Implemented full life cycle Oracle Financials at Confidential, Ukiah, CA.
  • Lead Teams in Oracle Apps Reports, Oracle Apps Conversions and project management and release management.
  • Oracle Manufacturing conversion lead for Confidential and Confidential ’s Project Independence at Confidential, Confidential . Project cost for Confidential ’s Project Independence was estimated to be around $300 million.
  • Managed a team of ten developers at Confidential, Confidential for Confidential Consulting.
  • Coordinated with Indian Offshore companies for meeting fast track deadline schedules.
  • Oracle OSFM Product Manager / Release Manager for 10.7 and 11.0 at Oracle Consulting.
  • Managed twenty onshore - offshore consultants at Confidential for Oracle ERP implementation.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, Unix, HP-UX and Windows 2000/XP/NT

Databases: Oracle 7x, 8i, 9i, MS SQL Server, MS Access

Oracle Applications: Oracle Applications Ver.12. 0, 11i (11.0.3, 11.5.4, 11.5.8), 10.7, 10.6 - Manufacturing, Financials and Supply Chain modules

Modules: Order Management, OSFM, Accounts Payable, Accounts Receivables, Order EntryInventory, Purchasing, Fixed Assets, Cost Management, WIP, MRP, GL, BOM and Service Contracts, Install Base, Pricing & Oracle OIM.

Oracle Tools: Developer 6i/2000 (Forms 6i, 4.6, 2.3), Reports 2.0, 2.3, 2.5, 6i, Discoverer, SQL LoaderPL/SQL, SQL Plus, OBIEE and BI Analytics

Other Tools: Informatica Power mart 4.6, Business Objects. And SAP R/3, Kintana, Cisco s CSCC, Cisco s SMS 3.0, Cisco s Contract Management, Quality Center etc.

PROFESSIONAL EXPERIENCE:

Confidential, Ukiah, CA

Oracle EBS & BI Business Analyst

Responsibilities:

  • Responsible for Oracle Business Intelligence prototype - Financials and Distribution. OBIEE and BI Analytics
  • Oracle Financials Production Support and development delivery lead for the GL, AP, AR, PO, OM and INV modules
  • Responsible for successful delivery, on-going maintenance and release management.
  • Currently managing on-going functional support, build, development, testing backups and IT Support.
  • Oracle manufacturing modules prototyped INV, CST, BOM and OPM.
  • Managed a team of 10 senior consultants.
  • Managed full life cycle implementation of SOX 404 project for Confidential and its subsidiaries in New York and UK.
  • Responsible for business process updates, Risk Control Matrix and testing of Order to Cash, Procure to Pay, Fixed Assets, Production, Payroll, IT GC and Entity level assessments for SOX 404 compliance.
  • Responsible for Oracle Business Intelligence prototype - Financials and Distribution. OBIEE and BI Analytics
  • Responsible for financials prototype in R12.

Environment: Oracle Apps 11.5.10.2, GL, AP, AR, INV, PO, OM, OBIEE and BI Apps

Confidential, Milpitas, CA

Senior Supply Chain BI Business Analyst - Oracle BI Apps

Responsibilities:

  • Supply Chain Functional BI lead for Supply Chain modules
  • Responsible for delivery for more than 40 BI Supply Chain Analytics Reports involving requirements gathering, solution design, tech design review, coordinating with third party delivery team, testing and business sign-off
  • Responsible for delivery for complex supply chain Analytics such as Days of Supply, LCM, E&O, Material Transaction, Account Transactions etc.
  • Worked on RevPro, Revenue Recogntion Dashboard covering multiple Revenue recognition reporting.

Environment: Oracle 11i, Oracle R12(OM, INV, GL, AR, PO, MRP, MDS), OBIA 7.9.6.4, OBIEE - 11.1.1.7, Hyperion - 11.1.2.2

Confidential, San Jose, CA

Service Contracts Business Analyst

Responsibilities:

  • Authored Service Contracts AutoQuote - Contract Consolidation BRD for CPAI.
  • Worked on Service Contracts Consolidation Prototype
  • Authored AQS-API White Paper for CPAI
  • Expertise on Service Contracts & IB Data Foundation, Hadoop Infrastructure and Business Intelligence.
  • Reviewed and Authored Service Contracts CSCC Quoting & Ordering BRD’s.
  • Strong expertise on Service Contracts, Install Base, Service Contracts Renewals, Quote to Contract Conversion, Opportunity Management Life Cycle.
  • Added features to Partner Opportunity Management Data Warehouse.
  • Responsible for designing and delivery of Solution& Governance Defect Aging Report.
  • Worked on reducing 10% BSOS cases due to Quote Conversion Failures.
  • Expert on 2- Tier web based Service Contracts Quoting and Ordering Tool for Services.
  • Expert on 1 - Tier web based Service Contracts Quoting and Ordering Tool for Services.
  • Expert on Country Enablement, business models suited for Services and on-boarding Countries.
  • Strong expertise on Cisco’s Cisco Services Partner Program, Cisco Services Contract Center, Services Contract Management& MMAT & Upload Manager for Externals and B2B.

Environment: Oracle Service Contracts, Oracle Apps 12i, OM, AR, GL, OCM, CSCC (1-Tier Q&O and Contracts Management tool), SMS3 (2 -Tier Tool), Contracts Management, Oracle Apps 11i, MMAT, Cisco Services Partner Program (CSPP), Partner / Service Opportunity Management and Install Base etc, B2B.

Confidential, Ukiah, CA

Oracle BI Analyst & Oracle EBS Business Analyst

Responsibilities:

  • Responsible for Oracle Business Intelligence prototype - Financials and Distribution. OBIEE and BI Analytics
  • Managed Oracle Financials full cycle implementation. GL, AP, AR, PO, OM and INV were implemented.
  • Responsible for successful delivery, on-going maintenance and release management.
  • Currently managing on-going functional support, build, development, testing backups and IT Support.
  • Oracle manufacturing modules prototyped INV, CST, BOM and OPM.
  • Managed a team of 10 senior consultants.
  • Managed full life cycle implementation of SOX 404 project for Confidential and its subsidiaries in New York and UK.
  • Responsible for business process documentation, Risk Control Matrix and testing of Order to Cash, Procure to Pay, Fixed Assets, Production, Payroll, IT GC and Entity level assessments for SOX 404 compliance.
  • Responsible for Oracle Business Intelligence prototype - Financials and Distribution. OBIEE and BI Analytics
  • Responsible for financials prototype in R12.

Environment: Oracle Apps 11.5.10.2, GL, AP, AR, INV, PO and OM, OBIEE and BI Apps

Confidential, San Jose, CA

Senior Business Analyst / Business Analyst / Project Manager

Responsibilities:

  • Expert on 2- Tier web based Quoting and Ordering Tool for Services.
  • Expert on 1 - Tier web based Quoting and Ordering Tool for Services.
  • Expert on Country Enablement, business models suited for Services and on-boarding Countries.
  • Strong expertise on 2 Tier SMS 3. - Cisco’s web based quoting and ordering services tool
  • Strong expertise on Cisco’s CSPP and CSCC
  • Responsible for delivery of “Upload Manager” BRD - for opening up the tool to Cisco Partners’. The BRD was delivered in a record time in spite of huge challenges.
  • Responsible for delivery of Nexgen Services BRD.
  • Responsible for numerous BAT cycles for SMS3, CSCC and CSPP and participated in war-room support.
  • Responsible for SMS 3. BAT for on boarding new software subscriptions feature to 2-tier tool.
  • Role & Access Engineering Sign off - due diligence spreadsheet for External’s Upload Manager.

Environment: CSCC, SMS3, Contracts Management, Oracle Apps 11i, MMAT, CSPP and Install Base etc

Confidential, Ukiah, CA

Oracle ERP Project Manager, SOX Project Manager & Oracle EBS Business Analyst

Responsibilities:

  • Managed Oracle Financials full cycle implementation. GL, AP, AR, PO, OM and INV were implemented.
  • Responsible for successful delivery, on-going maintenance and release management.
  • Currently managing on-going functional support, build, development, testing backups and IT Support.
  • Oracle manufacturing modules prototyped INV, CST, BOM, OSFM and OPM.
  • Managed a team of 10 senior consultants.
  • Managed full life cycle implementation of SOX 404 project for Confidential and its subsidiaries in New York and UK.
  • Responsible for business process documentation, Risk Control Matrix and testing of Order to Cash, Procure to Pay, Fixed Assets, Production, Payroll, IT GC and Entity level assessments for SOX 404 compliance.
  • Responsible for Oracle Business Intelligence prototype - Financials and Distribution. OBIEE and BI Analytics
  • Responsible for financials prototype in R12.

Environment: Oracle Apps 11.5.10.2, GL, AP, AR, INV, PO and OM, OBIEE and BI Apps

Confidential, Sunnyvale, CA

Program Management & SOX Business Analyst

Responsibilities:

  • Worked with the following clients, Confidential, UBSN Limited, Keynote Systems, Cypress Semiconductor, IPIX, Ciphergen Biosystems, Looksmart, Epiphany on various SOX projects, implementing Controls, ERP projects and refining business processes for SOX.
  • Extensive domain knowledge Single - Sign due to SOX projects IT compliance, done detailed Access Management project at Cypress Semiconductor for Confidential and for all above mentioned SOX projects.
  • Managed 60 people onshore-offshore company.
  • Responsible for IT automation Build, test and Release Management related to SOX Governance.
  • Working knowledge of SAP R/3 (Academic teaching experience), co-coordinated training SAP Consultants in FICO, MM, HR and Projects.

Environment: SAP R/3 and Oracle Apps 11.5.10.2 & Oracle OIM

Confidential, Phoenix, AZ

Manager & Functional Analyst

Responsibilities:

  • Participated in Sales cycle process
  • Responsible for Technical delivery for the Onward Project
  • Scoping, project plans, task scheduling, managing expectations and managed deliverables
  • Responsible for validation of Technical Architecture, Conversion and Interfaces.
  • Presently managing a twenty-member team, onsite-offshore model.
  • Environment Oracle 11.5.8
  • Established methodology, processes and controls, co-coordinated with PMO office and Release management.
  • Employee selection, ongoing performance management and consolidation of feedback from project leads, compensation administration, education and development, coaching, goal setting, and team-building activities
  • Integrated Oracle OSFM with Promis, Genesis and Exman
  • Wrote the functional specs for OSFM integration with MES systems.
  • Designed Network Routings for OSFM for different lot Sectors.
  • Responsible for all functional and technical validation for twenty supply chain conversions.
  • Responsible for functional and technical design validation for seventy interfaces.
  • Expert in fixed bid projects with onshore-offshore combination.
  • Inventory, OM, Costing, BOM, WIP, OSFM and AR

Confidential, Confidential, CA

Manufacturing Conversion Lead - Functional / Technical

Responsibilities:

  • Conducted client interviews to understand as-is system, internal and external and freeze on the requirements from the available 500 systems.
  • Coordinated with groups across the globe in USA, Europe and Asia Pacific.
  • Coordinated with Third Party Vendors for data extraction of various business elements, designed the logistics and made sure the all the data elements are transferred to Oracle.
  • Managed freezing of all the requirements for different business requirements of conversions.
  • Responsible for delivery of all CV 60’S and release management.
  • Managed the conversion design process and delivered all CV 60’s, code development of all manufacturing conversions - Build, Test and Release Management
  • Tracked issues and resolved the bugs and successfully implemented all manufacturing conversions.
  • Managed a Team of ten developers.
  • Coordinated with Indian Offshore companies for meeting fast track deadline schedules.
  • Provided costing solution for the buy side of Confidential ’s business.

Confidential, Milpitas, CA

Responsibilities:

  • Worked on Oracle Service Contracts conversion.
  • Successfully loaded 100 million records of install based Contract and Contract details.

Confidential, Confidential, CA

Conversion Team Lead

Responsibilities:

  • Conducted client interviews to for converting data from 10.7 UK, 10.7 US and 11.0.3 LA to 11i Global.
  • Responsible for 11i AP CRP
  • Task scheduling, resolving issues, applying patches and delivery
  • Managed support with five-member support team for 11i CRP issues.
  • Managed support for 10.7 financials suite.
  • Provided status to IT management and escalating and fixing issues.

Confidential, Cupertino, CA

Project Manager / BI Architect

Responsibilities:

  • Responsible for Oracle Financials 11i implementation through a third party.
  • The modules implemented were - GL, AP, AR, OM, PO and Cash Management.
  • Managed build, test, deployment and release management of Confidential ’s Business Intelligence for ASP Aggregator model with Informatica for data extraction and business objects.
  • Designed Integration of Business Objects with Portal environment with single sign on and total compatibility with Portal environment.
  • Fully integrated Business Objects Web based solution with Confidential Portal.
  • Implemented single sign on integration to populate the Business Objects security repository when user provisioned through the Confidential Portal and row level security to separate customer data.
  • Designed and implemented CRM support data mart and corporate data warehouse to capture usage-based service information for billing and financial analysis.
  • Implemented corporate data warehouse that has the flexibility to expand the data model when additional data is gathered from the Application Service Providers.
  • Designed and managed development of hundred Clarify BI reports using Business Objects.
  • Enabled customers to use both canned and adhoc reports. Defined and designed Supports and Financials Universe using Business Objects Designer.
  • Enabled company level security using Business Objects Supervisor.

Confidential, Redwood Shores

Senior Functional Consultant

Responsibilities:

  • Responsible for Oracle Shop Floor Management Product 10.7 and Release 11.0 and also responsible for
  • Supporting and fixing bugs.
  • Responsible for Build, Test and Release of OSFM 10.7 and 11.0
  • Oracle Shop Floor Management Product facilitates the semiconductor industry production process.
  • Addition of new product features, functionality, meeting client’s requirements and future direction. Managed and supported twenty OSFM customers.
  • Functional team member involved in internal implementation of Order Management, Advanced Pricing
  • Release 11i for internal demo, support and development purposes.
  • Developed API for Oracle Telesales, a CRM Module that interfaces with Order Management.
  • Worked at multiple clients Confidential, Verifone, Confidential, Hitachi, Confidential & Oracle Internal development etc

Confidential, CA

Functional Analyst

Responsibilities:

  • Conducted client interviews for collecting user requirements, suggest functional solutions.
  • Designed and developed web based self-service reports.
  • Modified AP self service expense workflow as per client’s requirements, Release 10.7 SC

Environment: - Oracle Self Service Apps & Oracle Projects.

Confidential, Seattle

Techno-Functional Consultant

Responsibilities:

  • Confidential ’s Strategic Procurement Solution is the Oracle first implementation of totally web based procurement or iProcurement solution using third party TPN Register
  • Conducted client interviews, designed and developed functional and technical solutions for Release 11 ICA
  • Interface lead for four interfaces Supplier Code, Cash Disbursement, Commercial Banks and Vertex.
  • Designed and developed web based requisitions and reports.

Confidential, San Diego

Techno-Functional Consultant

Responsibilities:

  • Designed and developed Vendor Conversions for Multiple Organizations.
  • Developed Programs for loading Vendors from one operating unit to another operating unit.
  • Worked on Vendor Work bench security based on the user privileges and forms and reports customization.
  • Conducted client interviews for delivering both functional and technical design solutions in Release 10.7 SC

Confidential, EL Segundo

Principal Technical Consultant

Responsibilities:

  • Conducted business interviews to collect requirements for AP, AR, GL reporting needs
  • Designed and delivered technical solutions for reports
  • Managed ten member reports development team
  • Designed and added customizations, extensions to existing oracle applications in Release 10.7 SC

Confidential, San Diego

Oracle Functional Consultant

Responsibilities:

  • Conducted client interviews for extending the reporting functionality of Oracle Financials and Manufacturing.
  • Designed and developed solutions for calculating cross boundary transactions and also written programs to report Net Booking, Cost of Sales and Pricing.
  • Designed and developed extensions to Oracle Apps in 10.6 Character Mode

We'd love your feedback!