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