IT Governance and Automation in an Oracle E-Business environment

1
IT Governance and Automation in an Oracle
E-Business environment

• Gaja Nagarajan
• Technical Operations Manager
• Enterprise Business Applications
• Marvell Semiconductor Inc.
• Chennapan Padmanaban
• Entegration Software, Sunnyvale, CA

2
About Marvell

• An industry leader in storage, communications,
  and consumer silicon solutions
• Global operations, 5,000 employees
• Headquarters in Santa Clara, California
• Israel
• Europe (Germany, Italy, Switzerland)
• Asia Pacific (Singapore, India, China)
• FY 2007 revenue of 2.24B

3
Marvells Enterprise Business Applications
Business Intelligence (BIS/DBI/Portal/Discoverer)
Advanced Planning
Trade Management
Demand Forecast
Discrete Mfg
Order Mgmt
Inventory
Semi Mfg (OSFM)
Adv Pricing
G/L
A/R
Fixed Assets
B2B
OTL
iProcurement
CWB
Disti Mgmt
A/P
HR
Purchasing
Cash Mgmt
Invoice Matching
Recruiting
Expense Reports
4
Marvells Business Requirements for MIS
Key requirements by Corporate Compliance/Audit
Group

• All Business Applications need to adhere to
  General Computing Controls for SOX Seperation
  of Duties (SOD) management
• No write/update access to MIS/IT Team in
  Production Environments
• Auditable Separation of Duties Control
• Provide documented track history for System
  Changes with adequate approvals

Key requirements by IT Corrections/Promotion
Policy

• Corporate Business Applications is governed by
  MIS Policies Procedures
• All Changes to PROD should be performed by
  Production Control (QA)
• Production Control will use automated tools to
  promote changes
• Every Change should be certified by QA for
  Performance Functionality
• Business User Approvals , Test Cases, Test
  Results are mandatory
• Production Controls activity should be
  documented for easy auditability

5
Key to Success Process Automation

• AUTOMATION, EXECUTION , ENFORCEMENT
• equals
• ACCOUNTABILITY, AUDITABILITY TRACEABILITY

6
Management by Metrics for Measurable Service
Improvement

• If you dont know IT, you cant
• measure IT
• If you dont measure IT, you cant
• manage IT
• If you dont manage IT, you cant
• improve IT

7
MIS Teams, Roles Access privileges
Promotion Path
Instance/ Team PATCH DEVELOPMENT PROJECT STAGING PRODUCTION
Production Control Code Review Change Migration Business Process Testing Promotion Scheduling Change Migration
DBA Team
Business Systems Analysts Prototype Design Integration Testing User Training Conduct UAT GO-Live Clearance Inquiry Access
Technical Team Leads Technical Design Code Certification
Development Team Develop code Unit Testing

• Apply patches
• System Administration DBA Support

8
Process Automation Best Practices few leading
Tool providers

• Automated Setup and enforcement of People
  System workflow
• along with seamless process-to-process
  integration across silos and
• other related enterprise applications
• Leading Tools HP- ITIL, IBM - Remedy, Serena
  - Team Track
• Automated Version Control for Change Management
• Leading Tools HP Version Control
  Opensource VCS Serena PVCS VM
• Automated Business Process Testing
• Leading Tools HP - Functional Test Pro,
  Borland - SilkTest, IBM - Rational
• Automated Performance/Load Regression Testing
• Leading Tools HP - LoadRunner, Borland -
  LoadTest, AdventNet - QEngine
• Automated Code Migration
• Leading Tools HP Kintana, Unitask - OMM,
  Serena Build Mover
• Automated Setup Migration
• Tools Oracle - iSetup, Entegration Setup
  Manager

Blue color indicates the tools Marvell choose
for its Operations
9
Tools that enable IT Governance Automation
Source Bridge
Change Requests
Approved SCRs
Serena TeamTrack
Approval Workflow
Marvell Business Analysts
Management
Specifications
Serena Version Manager
AOL/Code Changes
Functional Setup Changes
UnitaskOMM
Final list of SCRs for Promotion
QA
List of SCRs for UAT
QA
EntegrationFunctional Setup Migration Tool
Serena TeamTrack
Test Results
Promote Functional Setups
Promote AOL/Code
Schedule/ Execute Tests
Promotion Log
Serena TeamTrack
Entegration -Attest Test Management Tool
PRODUCTION
10
Automated Business Process Testing

• Solution includes the following components
• Mercury/HP Quick Test Professional
• Mercury/HP Load Runner for Regression Testing
• Entegration Attest Test console
• End to End testing of Critical Business Processes
  in the following areas
• Q2C, P2P, MFG, OSFM and key INV, BOM Financial
  transactions
• Weekly execution of BPT of over 140 Business
  Functions

11
BPT System Architecture
12
BPT System Data Elements
Test Schedule
13
Attest Test Console
14
Key Benefits for Marvell

• A comprehensive QA process was established.
• All changes are implemented first in a QA
  environment. Unless all tests passed in QA, the
  code was not approved to migrate to production
• A exhaustive test script library of over 145 test
  scripts covering all the major business processes
  was created to support the above process
• The Application Signature functionality allowed
  Marvell to test the applications using the same
  user and responsibility as in production.
• Test Plan functionality allows Marvell to switch
  testing environments with no code change

15
Automated Setup Migration

• Solution includes the following components
• Mercury/HP Quick Test Professional
• Entegration Align Setup Manager
• Automatically migrates the Functional Setups from
  one DB instance to another
• Current coverage of setups in the following
  modules
• AR, AP, GL, INV, BOM, WIP, OSFM, OM, PO, CM

16
Entegration Align Setup Manager

• J2EE based platform for automating the setup
  migration using
• Oracle native SQL
• Mercury Quick Test Professional
• JAVA and XML Technologies
• Resulting in
• Improved consistency and accuracy of setups
• Complete audit trail of what was migrated
• Reports comparing setups across instances

17
Entegration Align Architecture

• Components
• Functions
• Create Encumbrance Types
• Purchasing Options
• Tax Codes
• ..
• Packs
• Comprises of one or more functions
• Workflows
• Pre-determined flow of path
• Extract from PRJ2
• Migrate to STAGE
• Migrate to PROD
• Users
• Responsibilities

18
Entegration Align Architecture
Workflow
Function1
Extract from PRJ2
Function2
Setup Run


Migrate To STAGE
Function3
Migrate To PROD
Function4
19
Key Features

• Security Features
• Restricted Users
• Restricted Responsibilities
• Restricted Workflows

20
Key Features

• Scalability
• Can add custom setup functions
• Can be expanded to include other applications
  like CRM/HRMS

21
Key Features

• Ease of Use
• Can group together related setups
• Can sequence the setups to satisfy dependencies
• Very useful while deploying multiple setups
  related to a project

22
Key Features

• Audit Trail
• Execution steps are recorded and stored
• A snapshot of before and after values is stored
  in DB for easy examination and reporting

23
Align Setup Console
24
Migration Details
25
Setup Functions

• Over 120 setup functions in the following areas
• General Ledger
• Accounts Receivables
• Accounts Payables
• Cash Management
• Purchasing
• Order Management
• Inventory
• Bills of Material
• MRP
• WIP/OSFM

26
Benefits for Marvell

• Setup migration to Production is now automated
  resulting in
• Quick and accurate setups
• Completely Audited Changes
• Before and After Change Report
• Eliminated the need to provide production setup
  access to BSAs

27
Q U E S T I O N S
A N S W E R S
Contact Details Gaja Nagarajan
gajan_at_marvell.com Chennapan Padmanaban
cpadmanaban_at_entegration.com