Oracle Ebs & Bi Business Analyst Resume
Ukiah, CA
SUMMARY:
- Implemented full life cycle Oracle Financials at Confidential, Ukiah, CA.
- Expertise in implementing Oracle Financials, Manufacturing and CRM in 10.6 - character mode, R10.7 SC, R11.0, R11i and R12 and Oracle Fusion, worked on Oracle Fusion Financials POC prototype.
- Worked on Oracle Financials upgrade to R12.2 following modules AR, AP, GL, INV, PO & OM etc.
- At JDSU worked as Oracle BI Apps Supply Chain lead for Supply Chain Analytics, plus Financials and Sales Analytics implementation involving OBIEE, OBIA, Hyperion and DPA ETL Tool.
- Implemented Financials and Sales Analytics at Confidential - OBIEE & OBIA.
- 15 plus years of experience in Oracle Applications implementations and involved as a Functional, Techno-functional and as a Team Lead role for various client assignments.
- Lead Teams in Oracle Apps Reports, Oracle Apps Conversions and project management and release management.
- Oracle Manufacturing conversion lead for Confidential ’s Project Independence at Agilent Technologies, Santa Clara. Project cost for Agilent’s Project Independence was estimated to be around $300 million.
- Managed a team of ten developers at Agilent, Santa Clara for Deloitte Consulting.
- 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.
- Implemented ASP Aggregator Data Warehouse using Business Objects & Informatica at Jamcracker.
- Responsible for delivery of “Upload Manager” BRD - for opening up teh 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 teh 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 TEMPthan 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.
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 &Tableau etc.
PROFESSIONAL EXPERIENCE:
Confidential, Ukiah, CA
Oracle EBS & BI Business Analyst
Responsibilities:
- Prototype Oracle Fusion Financials for upcoming upgrade from R12.
- Responsible for Oracle Business Intelligence - Financials and Sales Analytics (OBIEE & BI Apps)
- Worked on customizing AP, AR & OM Analytics.
- Oracle Financials Production Support and development delivery lead for teh GL, AP, AR, PO, FA, CASH, 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.
- 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.
- Worked on Oracle Financials upgrade to R12.2 following modules AR, AP, GL, INV, PO & OM etc.
- Supply Chain Functional BI lead for Supply Chain modules
- Responsible for delivery for more TEMPthan 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 & MDM etc.
- Worked on 10 Financials and Sales Analytics Reports (OE Dashboard, OE Revenue & Margin, AP Invoice Aging, AP Outstanding Checks, Vendor Payment Analysis, AR Invoice Aging & AR Invoice detail)
- Worked on RevPro, Revenue Recognition 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.
- Responsible for Oracle Business Intelligence prototype, go live and support - Financials and Distribution. OBIEE and BI Analytics -All Financials and Sales Analytics reports went live – Off teh shelf solution.
- 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
Environment: Oracle Apps 11.5.10.2, R12, 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 teh tool to Cisco Partners’. Teh 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.
- 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
- Worked with teh 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 noledge Single –Sign due to SOX projects IT compliance, done detailed Access Management project at Cypress Semiconductor for Deloitte 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 noledge 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 teh 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
- 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 teh 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
Manufacturing Conversion Lead – Functional / Technical
Responsibilities:
- Conducted client interviews to understand as-is system, internal and external and freeze on teh requirements from teh available 500 systems.
- Coordinated with groups across teh globe in USA, Europe and Asia Pacific.
- Coordinated with Third Party Vendors for data extraction of various business elements, designed teh logistics and made sure teh all teh data elements are transferred to Oracle.
- Managed freezing of all teh requirements for different business requirements of conversions.
- Responsible for delivery of all CV 60’S and release management.
- Managed teh conversion design process and delivered all CV 60’s, code development of all manufacturing conversions – Build, Test and Release Management
- Tracked issues and resolved teh 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 teh buy side of Agilent’s business.
- Successfully loaded 100 million records of install based Contract and Contract details.
- 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.
- Responsible for Oracle Financials 11i implementation through a third party.
- Teh modules implemented were - GL, AP, AR, OM, PO and Cash Management.
- Managed build, test, deployment and release management of Jamcracker’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 Jamcracker Portal.
- Implemented single sign on integration to populate teh Business Objects security repository when user provisioned through teh Jamcracker 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 dat TEMPhas teh flexibility to expand teh data model when additional data is gatheird from teh 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
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 teh 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 dat interfaces with Order Management.
- Worked at multiple clients Proxima, Verifone, Sony Electronics, Hitachi, Boeing & Oracle Internal development etc
- 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
- Boeing’s Strategic Procurement Solution is teh 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.
- 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 teh user privileges and forms and reports customization.Conducted client interviews for delivering both functional and technical design solutions in Release 10.7 SC
- Conducted business interviews to collect requirements for AP, AR, GL reporting needs
- Designed and delivered technical solutions for reports
- Managed ten member reports development teamDesigned and added customizations, extensions to existing oracle applications in Release 10.7 SC
- Conducted client interviews for extending teh 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