Milan Rahman - 11i Upgrades and Implementations DBA

 


MILAN RAHMAN
E-Mail: milan.rahman@gmail.com
								(303) 916-6501 (cell)
Objective
·	Provide Oracle Financial Applications 11i support for implementation and upgrade
·	Administer Oracle Applications
·	Performance tuning Oracle Applications
·	Provide Oracle Database Administration support
·	Provide Oracle Database Administration skills for Data Warehousing implementation
·    Provide Oracle ContentDB and RecordsDB installation and administration
·    Provide FileNet P8 2.x, 3.x and 4.x installation and upgrade support 

Essential Oracle Applications DBA Skills
·	Oracle Applications DBA from versions 9.x to 11i including 10.x (10.5, 10.6, 10.7 SC, NCA, and Character), 11.0.x, 11i (11.5.1, 11.5.2, 11.5.3, 11.5.4, 11.5.5, 11.5.6 and 11.5.7, 11.5.8, 11.5.9, 11.5.10)
·	Experienced in Commercial and Federal Financials (Public Sector/Government)
·	Four completed upgrades from 10.7 or 11.0 to 11i
·	Two additional upgrades mapped out or in progress
·	Three new implementation of 11i
·	Wrote and presented one of the most downloaded paper on upgrades from OAUG Spring 2001 Conference
·	Global 11i implementation with multiple-languages
·	11i multiple reporting currency (MRC) and multi-org (MO) implementations
·	WorkFlow support and troubleshooting
·	Troubleshooting expertise for all tiers (client, middle-tier, database)
·	Forms upgrades
·	Vertex (Quantum) and AVP Tax (Taxware) Software integration in Payroll and Receivables
·	Cluster installation of Oracle Applications on Veritas Cluster Server (VCS) and Compaq (HP) Tru-64 Clusters
·	Discoverer 3i and 4i installation and configuration with Oracle Applications Business Views and Noetix Views
·	Modules implemented or supported: Core Technology, Customer Relationship Management (CRM), Financials, Human Resources/Payroll, Manufacturing, Distribution/Supply Chain, Projects, Public Sector, and Business Intelligence
·	Hardware: SUN Solaris, HP-UX, Compaq Tru-64, IBM AIX, Sequent, and Windows 2000/NT
·	Application Desktop Integrator (ADI) and WebADI installation
·	Oracle Applications InterConnect (OAI) installation and configuration
·	Oracle Financial Analyzer (OFA) installation
·	Oracle Applications technical architecture design and sizing for 11i
·	Oracle Portal 3.0 with Oracle Applications 11i installation and Single-Sign-On (SSO) configuration
·	Web Oracle Application Management (WebOAM), OEM installation and configuration
·	Citrix MetaFrame deployment of 11i experience
·	Oracle versions 6, 7, 8, 8i, and 9i
·	Oracle iAS implementation and support
·	Lawson Financials/HR Oracle DBA support
·	MIMS3 (Materials and Management Systems) Oracle DBA support
·	Designer/2000, Discoverer/2000, Developer/2000 DBA support
·	Data modeling and database design using Oracle CASE Methodology
·	ER/Win modeling tool
·	Oracle symmetric replication
·    FileNet P8 installation and upgrades
·    Kofax, BancTec and AnyDOC Capture understanding
·    Knowledge of OCR technologies
·    Knowledge of Enterprise Content Management software implementation 
·    Oracle ContentDB, Oracle RecordsDB API knowledge 
·	Excellent communication skills for technical and non-technical people to get the job done effectively and efficiently
·	Consistently provide high quality customer service to all

Papers and Presentation
·	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 titled: �11i Upgrade � Technical from Inside Out�
·	Oracle Applications Users Group (OAUG) Spring 2001 Conference titled: �Upgrade 10.7 to 11i � A Rough Guide�
·	Rocky Mountain Oracle Users Group (RMOUG) Training Days 2001 titled: �Upgrading from 10.7 to 11I � An Applications DBA Guide�
·	Rocky Mountain Oracle Users Group (RMOUG) Training Days, 1998 titled: �Integrating AutoSys with Concurrent Managers -- A Case Study�
·	OAUG Insight, April 2000 titled �Want Long Running Concurrent Programs to Finish Quickly?  �  Try Parallelizing�
·	Softec Times, Fall 1999: �Running Update Project Summary Amounts in Load Balanced Batches�
·	Published code in Oracle Applications Tips page: http://www.geocities.com/SiliconValley/Network/9828/
 
Career Overview and Related Achievements

CM Mitchell Consulting, Golden, Colorado, July 2002 � Current
Client: Centrix Financial, LLC
·	Implementation of 11.5.7 on Windows 2000 and HP-UX
·	Technical architecture definition
·	Support the implementation team
·	Patch application
·	Multi-Org implementation
·	Troubleshoot issues
·	Provide production support and train on staff DBA
·	Install and configure WebOAM, Oracle Portal, WebADI, Desktop ADI, and Workflow Mailer
·      Upgrade to 11.5.10
·      Technical guidance on all Oracle Interfaces and development activities
·      Implementation of additional modules
·      Implementation of FileNet P8 2.0.1
·      Upgrade of FileNet P8 2.0.1 to 3.0
·      Technical Expert on all FileNet P8 Interfaces

TEK Systems, Colorado Springs, Colorado, February 2002 � June, 2002
Client: Compaq, Inc. and Marconi PLC.
·	Global Implementation of Oracle Applications 11i (11.5.4) on Compaq Tru-64 Cluster
·	Multiple Languages (26 eventually, 7 to start)
·	Multi-Org, Multiple Reporting Currency
·	Senior member of a team of 5 DBAs supporting 26 instances for the project
·	Cloning, patch application, troubleshooting technical issues
·	Prepare documentation as needed
·	Installation of Oracle Applications InterConnect (OAI), also known as Oracle InterConnect
·	Installation of Discoverer 3i on Citrix MetaFrame to work with Oracle Applications 11i
·	�Cluster Aware� installations of Oracle 9i RAC on Tru-64

Independent Consulting, October 2001 -- February 2002
Client: Aurora Public Schools, Aurora, Colorado.
·	Upgrade client from 10.7 to 11i including government financials modules
·	Migrate from one HP hardware to another
·	Defined export/import strategy
·	Plan O/S upgrade from HP-UX 10.2 to HP-UX 11
·	Perform performance tuning and maintenance on the current database
·	Applied additional patches to stabilize the environment
·	Set up the appropriate environments for the development staff to start customizations
·	Set up Vertex software to support Payroll tax
·	Upgraded Workflow 2.5 to 2.6.1
·	Debugged Workflow related issues as appropriate
·	Installed ADI 7.0 for use with 11i

Client: Core Laboratories, Inc., Houston, Texas, November 2001 � December 2001
·	Provided production support for 24 x 7 Oracle Applications 11.0.3 environment configured with HP Service Guard Clustering for fail-over
·	Applied Year-End HR/Payroll and other patches as needed
·	Refreshed/cloned many development databases (Year End, Development, EURO testing, etc) from production as needed
·	Support Optio printing software
·	Installed newer version of Noetix Views and Discoverer EUL
·	Provided application System Administration function as needed
·	Supported on-going development efforts
·	Configured Oracle Enterprise Manager for monitoring
·	Troubleshoot ADI issues related to migration from one HP system to another

Dimension Data, Inc. September 2001 � October 2001
Client: Graebel Companies, Aurora, Colorado
·	Consulted client on assessment for 11i upgrade from 10.7
·	Prepared technology architecture recommendations
·	Proposed options regarding reuse of existing hardware
·	Identified issues with current RDBMS and hardware setup
·	Proposed architecture to support hardware fail-over for both database and application servers
·	Identified problems with memory usage with Network Appliance Filers
·	Recommended upgrade approach and plan to uninstall HR-Payroll modules which are no longer used by the client

Idea Integration, Inc. August, 2001 � September, 2001
Client: Managed Storage Incorporated, Broomfield, Colorado
·	New implementation of 24 x7 global using iSupport and Oracle Service
·	Applied patches as appropriate to stabilize the environment
·	Implemented Veritas Clustering for fail-over for Oracle Applications 11i for database and forms/web servers
·	Resolved all issues related to Veritas Clustering due to issues with logical node-names
·	Trained DBA and other technical staff for on-going maintenance of this implementation
·	Educated Unix staff on 11i architecture and Secure Socket Layer (SSL) issues to ensure proper firewall set up
·	Set up procedures and code required to support backup and recovery for this database
·	Set up cloning procedures using hot backups for on-going development efforts
·	Worked with the implementation team to identify and resolve problems as appropriate
·	Worked with the implementation team to resolve Workflow issues
·	Installed Discoverer 3.0 for 11i

Independent consulting, April, 2001 � August, 2001
Client: Kirby Marine Transportation Corporation, Houston, Texas
·	Upgraded from Oracle Applications 10.7 character to 11i
·	Resolved all issues with DB and Application upgrade
·	Trained internal staff on upgrade issues and resolutions
Client: Loomis Fargo and Company, Houston, Texas
·	Upgraded from Oracle Applications 11.0.3 to 11i
·	Implemented Oracle CRM product suite including Contracts and Service
·	Migrated databases from Sequent to Sun
·	Upgraded RDBMS from 8.1.6.0 to 8.1.6.3 and resolved all related issues
Client: State of Colorado, Bureau of Investigations, Lakewood, Colorado
·	Consulted client on installation of Oracle 8.1.6.0 on Sun
·	Prepare database for KRONOS time-keeping application
·	Resolve connectivity issues as appropriate

SageLogix, Inc. April, 2000 � March, 2001
Client: Exabyte, Inc.
·	Upgraded Oracle Applications 10.7 to 11i for modules including Order Entry (Order Management suite in 11i) and Manufacturing suite
·	Upgraded database from 7.x database to 8i (8.1.6)
·	Planned/executed migration of the databases from Unix raw devices to file system on IBM ESS
·	Preliminary proof of concept implementation of Oracle CRM 3i to work with 10.7
·	Installed Oracle Applications 11i CRM suite
·	Configured WorkFlow for use by Oracle Applications
·	Installed latest Noetix Views for 11i and Discoverer EUL
·	Installed Oracle Tutor
·	Resolved issues with the installation and upgrade process as they appeared
·	Optimized upgrade window so that the process can be completed with minimal downtime
·	Cut back upgrade window from an initial timeline of ten days to four days
·	Provided DBA support for Siebel

Client: Gulf States Toyota, Houston, Texas
·	Upgraded Oracle Applications 10.7 to 11i for GL, AP, AR, FA, HR, PAY modules
·	Migrated from 7.x database to 8i (8.1.6)
·	Applied and troubleshoot patches as necessary 
·	Configured WorkFlow for use by Oracle Applications
·	Installed and configured latest Noetix Views for 11i and Discoverer EUL
·	Installed and configured ADI for 11i
·	Resolved issues with the installation and upgrade process as they appeared
·	Resolved issues with KRONOS integration with 11i Applications
·	Integrated Vertex for Oracle Payroll
·	Optimized upgrade window so that the process can be completed with minimal downtime

SofTec Solutions, Inc. February 1, 1998 � April, 2000
Client: National Renewable Energy Laboratory (NREL) -- Department of Energy 
·	Upgraded Oracle Applications from 9.4 to 10.7
·	Migrated from 7.0.x database to 7.3.3.5 on Sun Solaris 2.6
·	Implemented Production 16.1 Smart Client for GL, AP, AR, and INV
·	Centralized deployment of Oracle Forms on NT middle-tier
·	Advised and implemented Noetix Views and Discoverer tool set for ad-hoc reporting
·	Sized the database appropriately
·	Resolved performance issues proactively as appropriate
·	Implemented Oracle Projects, Human Resources, and Fixed Assets
·	Implemented Oracle 8 Data Warehouse using ER/Win for repository management, MX Power Plug for metadata exchange, Informatica for Extraction, Transformation, and Loading (ETL) and Brio for reporting
·	Implemented Oracle Webserver for Web based time entry system (TMA Web Tea:Time)
·	Implemented Ceridian interface from TMA and Oracle HR
·	Implemented Hyperion interface with Oracle Projects for budgeting
·	Implemented EcoTools for database monitoring
·	Automated warehouse data load management
·	Migrated current database from 7.3.3.5.to 7.3.4 and Server-Partitioned 8.0.5
·	Migrated Data Warehouse to 8.1.6 (8I)

Analyst International Corporation (AIC), 1996 -- January, 1998
Client: Cyprus Amax Mining Company
·	Support the implementation of an $10+ million Oracle Applications (GL, AP, OE, AR, INV) 10.6.1 SC15 across 23 sites worldwide as sub-contractor for Andersen Consulting 
·	Installed, upgraded, created databases as needed for the development effort
·	Provided hardware and database sizing assistance
·	Provided proper implementation methodology guideline throughout the project
·	Provided Operational Architecture components for the project (i.e. automation of Journal Import, Allocations, and Financial Statement Generation) via AutoSys, an scheduling software
·	Named the �MVP� of the project by the project team
·	Supported Designer/2000 for development projects
·	Deployed Noetix Views for use with InfoMaker as an additional and ad-hoc reporting tool
·	Installed Discoverer tool set for ad-hoc reporting
·	Configured Oracle Names Server 
·	Implemented CCC/Harvest, TSReorg, RediView, Hyperion (S-Base), VinNET, DBVision, Oracle Financial Analyzer and Oracle Express, and Vista Plus software as part of the overall implementation

CareerTrack, 1988 -- 1996
Oracle Applications and Database Administration, 1994 -- 1996
·	Provided Oracle 7 database administration and Oracle Applications support for GL, AP, PO, FA, INV, BOM, WIP, OE, AR, and PA
·	Performed installations and upgrades of the database and the Applications
·	Performed maintenance of the databases to minimize downtime
·	Installed and configured Oracle CASE 5.x


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