Milan Rahman - EBS Upgrades and Implementations DBA

 


Profile --

23 years of information technology experience
17 years of Oracle experience focused around Oracle E-Business Suite (EBS) from release 9.4 to R12  Oracle Applications and Oracle  Financial)
14 years experience as a successful consultant Oracle Applications Database Administrator (version 6 to 11g), Architect and Developer
Proven track record in successfully leading and delivering complex EBS implementations, upgrades, and migration projects and building effective relationships at all levels of the organization
High Availability configuration for EBS using Veritas Cluster Server
Oracle DataGuard implementation for EBS
Performance tuning and query optimization for Data Warehouse implementation including ETL using Informatica and reporting using Brio
Certified FileNet, an IBM company, P8 suite  Application Engine (AE), Process Engine (PE), and Content Engine (CE) 2.0, 3.0, 3.5 and 4.0 installer and administrator
Oracle ContentDB and Oracle RecordsDB installation and configuration
Oracle Application Express (APEX) installation and configuration with integration to BI Publisher and Oracle EBS
Oracle Business Intelligence Enterprise Edition (OBIEE) support with Seibel Analytics, and Cognos reporting tool
Database support for Quorum Energy Software Suite and Flow-Cal
Database support for FileNet P8 Content Engine and Process Engine, Open-Text, Oracle UCM, etc.
170 System's MarkView for Accounts Payable and General Ledger
Oracle WebDB, iAS (9iAS), 10gAS, WebLogic and WebSphere installation and configuration

Skills --

E-Business Suite
Oracle E-Business Suite commercial and federal (public sector/government) 9.x, 10.x, 11.x, 11i (from 11.5.1 to 11.5.10.2), and R12 performing DBA and Developer duties involving Financials, HRMS, Payroll, CRM, Distribution, Manufacturing, Order Management, Inventory, Business Intelligence and Self-Service implementations and upgrades
Database and application performance tuning
Global (multi-country) and multi-language (NLS), and multiple reporting currency (MRC)
Cloning, patching, troubleshooting, capacity planning, performance management, SLA objectives

Databases
Oracle Database (RDBMS) 6, 7, 8, 8i, 9i,10g, and 11g

Operation Systems
Solaris, AIX, Linux (RHEL,  SuSE, and OEL), HP-UX, Compaq Tru-64, Windows  (2000, 2003, Vista Business Server)

Tools and Technologies
Oracle SQL and PL/SQL	 		
Oracle Recovery Manager (RMAN)
Oracle Discoverer 4i and 10g			
Oracle Developer (2000 and 10g)
Oracle Designer 2000				
Oracle WorkFlow (standalone and embedded)
Oracle Enterprise Manager (OEM)		
Oracle Applications Manager (OAM)
Oracle Learning Management System (LMS)	
Oracle ContentDB and RecordsDB
Noetix Views					
EBS Business Intelligence views
Lawson DBA					
Kofax Ascent, AnyDoc, BancTec eFirst Capture
High Availability solutions including Veritas Cluster Server (VCS) and TruClusters on Tru-64
Oracle Universal Content Management (UCM) (formerly Stellent)
Vertex (Quantum) and TaxWare (AVP) integration with EBS for Payroll, Sales Tax and Receivables
Certified FileNet, an IBM Company, P8 3.0, 3.5, and 4.0 installation and administration
Knowledge of Hyland's On-Base installation and integration with Oracle EBS

Professional Experience --

Executive Management
Principal Consultant, Information Associates, Inc. -- October, 2007 to present
Technical (Team) Manager, CM Mitchell Consulting Corporation, July, 2002 to October, 2007
Independent Consultant working as a technical leader, mentor, lead architect, January, 1996 to  June, 2002
Team member, Technical Lead, and Development Manager, CareerTrack, Inc., 1988 to 1996

Oracle E-Business Suite (EBS) Database Administration -- 
Oracle EBS Database Administrator responsible for numerous implementations and upgrades
Wrote and presented one of the most downloaded paper on upgrades from OAUG Spring 2001 Conference
Experienced in large scale global implementations with multiple currencies, languages and legislations
Completed six upgrades and three new implementations
Experienced in troubleshooting any Oracle EBS issues including performance, WorkFlow, forms, reports and concurrent programs and processes
Delivered the first successful upgrade from release 10.7 to 11i (11.5.2) with HRMS and Payroll
Deep knowledge of Oracle Advanced Queue (AQ) architecture and its interaction with Oracle WorkFlow
Performed 11i cloning to support projects in very early releases of when no documented method existed
Implemented 11i on an active/passive Veritas Cluster Server (VCS) when 11i was not cluster-aware
Implemented 11i on TruCluster on HP Tru-64
Multiple successful 11i platform migrations including HP-UX to Oracle Enterprise Linux (OEL 4)
Mentored numerous development teams on best practices for Oracle EBS development methodologies
Mentored many Database Administrators (DBA) to support Oracle EBS upon project completions
Provide on-call, emergency, and front-line DBA support to solve immediate crises and work towards stability, self-sufficiency through knowledge transfer
Work with clients to meet and exceed all agreed to Service Level Agreements (SLA) for the organization
Experienced in Vertex (Quantum) and AVP Tax (Taxware) integration in Payroll and Receivables
Research, plan and intelligently perform patch and clone activities to reduce service window
Perform Sarbanes-Oxley (SOX) audits around EBS and supporting infrastructure
Design/deploy technical architecture to securely (DMZ) support EBS products (iExpense, iSupplier, etc.)
Work with clients to implement EBS security that leverages technical options and customer demands
Support and troubleshoot Maximo integration with EBS
Support and troubleshoot application tier  issues  with 9iAS, 10gAS, WebLogic, WebSphere, http/https, etc.
Support and troubleshoot concurrent manager issues

Oracle Database Administration --
Perform installation and configuration of Oracle databases from release 6 through 11g in different platforms
Perform all database administrative tasks for EBS, custom, and other packaged applications
Perform database architecture design and deployments to support large document management and data warehousing applications with high-availability requirements
Troubleshoot database performance and failures
Perform cloning activities to build development and test databases using various techniques

Developer --
Various interface developer for Oracle EBS
WorkFlow development and customizations
Developed document management integration between Oracle EBS and FileNet P8
Discoverer reports for Oracle EBS and non EBS applications
Oracle Reports developer for Oracle EBS and non EBS applications
Develop XML parsing and XML generation for Oracle EBS interfaces
Utilities for other developers to uniformly generate logs and outputs from PL/SQL programs
Automated process to handle data warehouse loads from Informatica
Develop loose integration between systems using Standards Oriented Architecture (SOA) concepts

Document Management Architect --
Certified FileNet P8 3.0, 3.5 and 4.0 installer and administrator
Team Lead for first successful implementation of FileNet P8 2.0
Technical Lead for project team which earned 2004 FileNet Innovation Award
Install and configure Oracle and SQLServer databases  to support FileNet in high availability architecture 
Install , configure and optimize WebLogic to support FileNet and other custom web applications
Define high availability architecture for BanTec eFirst capture
Deploy MicroSoft Network Load Balancer (NLB), MicroSoft Cluster Service (MCS), VCS and Cisco solutions
Define architecture for BancTec PayCourier automated check-processing solution
Develop integration between document management and any line of business (LOB) application
Familiar with the capabilities of other capture solutions like Kofax Ascent, AnyDoc, and Captiva
Oracle Universal Content Management (UCM), formerly Stellent, installation and configuration
Familiarity with ECM products and OCR technologies for capture automation
170 System MarkView Accounts Payable and General Ledger for EBS
Developed MarkView cloning procedure for EBS

Other skills --
Application Express (APEX), formerly HTMLDB, installation and configuration
BI Publisher integration with APEX
APEX integration with EBS

Publications and Presentations --
Colorado Oracle Application User Group November, 2002 presentation titled 11i WorkFlow -- A Technology Perspective
Colorado Oracle Application User Group October 2001 presentation titled:  Upgrading from 10.7 to 11i -- An Applications DBA Guide encore
Colorado Oracle Application User Group June 2001 presentation: 11i Upgrade -- Technical from Inside Out
Oracle Applications Users Group (OAUG) Spring 2001 Conference: Upgrade 10.7 to 11i -- A Rough Guide
Rocky Mountain Oracle Users Group (RMOUG) Training Days 2001: Upgrading from 10.7 to 11i -- An Applications DBA Guide
Rocky Mountain Oracle Users Group (RMOUG) Training Days, 1998: Integrating AutoSys with Concurrent Managers -- A Case Study
OAUG Insight, April 2000: Want Long Running Concurrent Programs to Finish Quickly?  Try Parallelizing
Softec Times, Fall 1999 Running Update Project Summary Amounts in Load Balanced Batches

Experience -- 

Information Associates 10/2007 -- present
Clients:
MarkWest Energy Partners, L.P.
National Renewable Energy Laboratory
First Data Corporation

CM Mitchell Consulting Corporation 7/2002 -- 10/2007
Clients:
Centrix Financial, L.L.C.
Oppenheimer Funds
Emergency Medical Services Corporation (EMSC)/ American Medical Response (AMR)
Tri-Zetto Group, Inc.
Visa, USA
TeleTech Holdings, Inc.
Flatiron Financial Services, Inc.
Republic Financial Corporation

TEK Systems 2/2002 -- 6/2002
Client:
Compaq, Inc. for Marconi P.L.C.

Independent consulting 10/2001 -- 2/2002
Clients:
Aurora Public Schools
Core Laboratories, Inc.

Dimension Data, Inc. 9/2001 -- 10/2001
Client:
Graebel Companies

Idea Integration, Inc. 7/2001 -- 9/2001
Client:
Managed Storage Inc.

Independent consulting 4/2001 -- 7/2001
Clients:
Kirby Marine Transportation Corporation
Loomis Fargo and Company
State of Colorado, Bureau of Investigation

SageLogix, Inc. 4/2000 -- 3/2001
Clients:
Exabyte, Inc.
Gulf States Toyota

SofTec Solutions, Inc. 2/1998 -- 4/2000
Client:
National Renewable Energy Laboratory

Analyst International Corporation 1996 -- 1/1998
Clients:
Cyprus-Amax Mining Company

CareerTrack, Inc. 1988 -- 1996

State of Montana, Department of Administration 1986 -- 1988


Member number:6823
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2001 Milan Rahman and Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257