Oracle Project
Resume:
Employer Login
User Name
Create an Account!
Mohammed Ahmed
Jersey City, US-NJ
************@*****.***
POSITION DESIRED: Sap Technical Consultant
TYPE OF EMPLOYMENT: Either W2 or 1099
PAY/SALARY LOOKING FOR: $Open
IT EXPERIENCE: 0.5 yrs
TOP 3 TECH SKILLS:
1. Oracle Apps/DBA
2. Sap Basis/BW
3.
CERTIFICATIONS: OCP and Sap Technical Consultant
DATE AVAILABLE: 2 weeksRELOCATION POSSIBLE: y
US CITIZEN OR GREENCARD HOLDER: y
MORE ABOUT ME:
Hameed Ahmed
804 Broadway fl# 3
Bayonne, NJ 07002
U.S.A
E-mail: ********@*******.***
Contact Hameed @ (201) 925- 2283
SKILLS SUMMARY:
* Thirteen years of experience specializing in Oracle Technologies/ERP and software
development. Extensive experience in Oracle database administration, database design,
performance and Oracle financials Implementation.
* Proficiency in Oracle Database Administration, Implementation/Maintenance of Oracle
Financials, Server Installation and Performance Tuning, Security Management, Backup &
Recovery, Data & Code Migration, Oracle Designer Repository Management and Administration.
* Extensive experience setting up and supporting critical, high-availability production
environments.
* Ability to work under extremely tight deadlines and maintains focus of objectives and
processes and superior troubleshooting, implementation and development skills. Good
experience of the whole development cycle, from writing and reviewing specs, through
design, development, debugging and deployment.
* Proven ability to successfully interact on an interpersonal level and function in team
environments.
* Oracle Certified Professional in Oracle 9i, Oracle 8i and 8.
EDUCATION:
* MS. Computer Science, Texas A&M University, TX U.SA.
* BS. Engineering, Osmania University, India.
Core competence:
Please describe here your core competence in 1-2 sentences
Oracle Financials / SAP Basis, BW.
( Qualification:
Education:
Please list here your educational history and for a better understanding translate your
graduations and academic degrees into the international equivalents
M.S (Master of Computer Science) From Texas A&M University.
Certifications/Memberships:
OCP, SAP Technical Consultant
( Project Summary: (please start with current project)
Time/Duration:
Industry/Company/Country:
Project title:
Description:
2002 to current
Consulting/CAP GEMINI ERNST & YOUNGE /
NEW YORK NY
Sr. Oracle/SAP Consultant
(Installed and configured Oracle 10g/9i Real Application Clusters in two-node cluster
servers. Integrated the cluster 9i database with Oracle E-Business Suite 11.5.9.
Implementation involved Oracle Human Resources, Oracle Standard Benefits, Oracle Payroll,
Oracle FI & Oracle Time & Expense modules.
(Configured Oracle 9i database in 2-node Real Application Clusters (RAC) mode.
(Administered and managed multiple instances like Production, Development, CRP, and
Sandbox.
(Performed numerous cloning of 2-tier production to 2-tier test environment.
(Applied and documented patches that included mini-patch sets, standalone patches, and
upgrade patchsets.
(Upgraded HRMS Suite from Family Pack E to F.
(Used Statspack to monitor and tune database performance.
(Administered security (create users and responsibilities) and provided end-user support.
(Provided support to development and implementation groups for all application instances.
(Backed up the databases and Oracle Applications through cold backup, hot backup and also
included RMAN backup strategies setup for some of the databases.
(Implement user requested enhancements to Oracle Applications Types of enhancements,
(Monitor/Identify any performance related issues of Oracle Apps11i
(Move all custom programs and reports to production. This involves enforcing naming
standards, maintaining the custom application top, and setting up concurrent requests.
(Monitor all the changes going to production environment and do an Impact analysis of
those changes into production.
(Assign/setup Responsibilities, Monitor concurrent managers, manage users, add printers
and change profile options.
(Schedule batch jobs and purge concurrent tables data weekly.
(Support and maintain 6 Oracle Applications 11.5.4 instances including production.
(Responsible for Upgrade of Oracle Applications from 11.5.4 to 11.5.9.
(Performed applications Cloning using Autoconfig and RapidClone.
(Configure Oracle Applications Manager and set up AutoConfig.
SAP R/3 System Skills
(Installed and upgraded SAP systems (Central Instances, Application Servers and SAPGUI
distribution servers) from version 2.0 FCS through 4.6C / 4.6D. SAP R/3, BW and CRM,
including several Industry Solutions.
(Instance design and optimization, performance tuning and load balancing.
(Installed SAP WAS Server 6.10 & 6.20 on UNIX and LINUX
(BW 3.0B day to day support
(HR implementation and upgrade experience
(Setup and refined CCMS thresholds and parameters for system performance and resources.
(Prepared comprehensive client-specific documentation regarding system maintenance and
installation configuration.
(Planned and executed client exports and imports as well as copies.
Applied SAP Hot/Support Packages and OSS Messages when available from SAP for relevant
release and assisted implementation team with testing.
(Implemented and used extensively SAP Note Assistant SNOTE.
(Executed standard system and SAP housekeeping jobs as part of support to implementation
team.
(Installed and upgraded UNIX systems, customized to client & application specific needs.
(Management of Users, Authorizations, and Profiles.
Time/Duration:
Industry/Company/Country:
Project title:
Description:
2000-11
to
2002- 05Bank / Maryland Bank of North America / Newark DE
Project title Sr. Oracle/SAP Consultant
Project description
(Involved in the requirement study, planning, analysis, design, development, testing and
implementations of Oracle Applications 11.5.3(US, UK, CANADA), Oracle Systems.
(Responsible for upgrading Oracle Applications from 10.7SC to 11.5.3 (GL, AP, FA, IP,
PO).
(Played a key role in the successful implementation of Oracle Applications in both
Functional and Technical areas.
(Responsible for Data Migration from the existing legacy system to Oracle Applications.
(Defined system security and standards for application design & development.
(Installed and configured Oracle 9iAS.
(Provided database sizing, tablespace management and rollback segment management.
(Configured Recovery Manager (RMAN) to implement backup methodology.
(Refreshed Production over the development instances and kept the test instance in sync
with other instances and tested new database and application patches.
(Created and maintained custom responsibilities and menus.
(Developed Extensions to Oracle Applications viz. building new forms, reports and queries
in Developer 6i/2000, setting up the application structure, registering the application
and its objects, generating/customizing forms, queries and reports.
(Installation of Oracle RDBMS, Oracle Application Server and patches for RDBMS and
Application Server.
(Responsible for Oracle Applications System Administration which involved creating and
managing users & their access to Oracle Applications, defining their application
privileges, defining data groups & request groups, creating document sequences and
assigning them to documents, managing concurrent programs and managing printers.
(Managed Applications instances with Kintana Accelerator for Oracle E-Business Suite.
SAP R/3 Consulting Skills
(Oracle (6x -> 9x) and MS SQL Server 7 & 2000 experience.
(SQL Traces to find performance problems and add additional table indexes.
(Defined and tested recovery scenarios.
(Monitored database usage, effect sizing and parameter changes in conjunction
with/without EarlyWatch.
(Planned and executed database exports / imports and database copies to create new
instances.
(Database design based on table access and/or table size, down to the controller and disk
layout.
(Data migration and advanced system tuning for the data load.
(Basis team leader in SAP, UNIX, Oracle and Informix administration & implementation
tasks
(Including upgrade and installation strategies and system change management.
(Developed a daily, weekly and monthly checklist for end users in the SAP-, Database- and
Unix-System in conjunction with the housekeeping jobs.
(Provided capacity planning for SAP instances, networks, Unix machines and PCs, including
organization and maintenance of software and hardware support contracts.
(Trained system administrators from beginning levels to advanced admini
stration topics (on site).
Time/Duration:
Industry/Company/Country:
Project title:
Description:
1999-01 to 2000- 11Telecom / Communications Test Design / Philadelphia PA
Project title Sr. Oracle Apps Consultant
Project Description
(Monitor & Tune System Resources for Oracle Financials Database i.e. CPU Utilization,
Memory (optimize Data Block Buffers, measure and tune the performance of Library &
Dictionary Cache), I/O to avoid disk contention.
(Upgraded 8.0.5 database to 8.1.7 and implemented sever partitioning with 8.0.6 to enable
Oracle Applications 11.0.3 to work with 8.1.7.
(Responsible for planning and implementation of Oracle Financials (ver 11.0.3) on HP-UX.
(Create test web servers, web listeners, form servers, concurrent managers, and databases
from the production environment for 11.0.3.
(Tuned Concurrent Managers and defined work shifts, specialization rules &
incompatibilities.
(Troubleshoot problems with web server, web listener, forms server, concurrent managers,
and database on 11.0.3
(Responsible for configuring OEM to monitor Oracle Applications and Concurrent Manager.
(Applied and documented patches that included mini-patch sets, standalone patches, and
upgrade patchsets.
(Used AD administration utilities (adpatch, adadmin, adctrl, adaimgr).
(Data Conversion and Data Migration using SQL*Loader, Export & Import Utilities, PL*SQL
Built-ins (UTL_File) and scripts.
(Design & Setup the production database, Create & Manage users & database objects.
(Replicated databases from production to test and development environments and ensured
consistency between the databases.
(Monitor & Tune different database performance space utilization and table space
fragmentation, Rollback Segments, Indexes, Trace SQL, Estimate efficiency of application
code, Pin application code, Detect & Minimize Row Chaining/Migration (Analyze, V$SYSSTAT),
Generate Optimizer/performance Statistics (Analyze, Explain/Show, DBMS_UTILITY, DBMS_STAT,
Dynamic Performance Views).
(Implemented backup and recovery strategy integration with EMC Business Continuance
Volumes (BCVs).
(Unix shell scripting for automating startup/shutdown of databases.
(Provided production support for 24 x 7 Oracle Applications environment.
SAP R/3 Consulting Skills
(Created and designed the Authorization concept for more than 300 users belonging to
various modules.
(Configured the Transport system using Transport Management System (TMS), we have a 3
tier system which includes Development system, Quality Assurance system and Production
system. TMS has been configured in such a way that all transport request released will go
from Development to Q.A system and only after the checks have been done that it then gets
transported to Production system.
(Installed the latest version of the Sapgui with the patches provided by SAP at different
location with the end users having only Saplogpad on their desktop. I have also done local
client copy and also Remote client copy from our Production system to Q.A system on a
different client so we have the exact replica of the Production system using profile
SAP_APPL which was done successful.
Time/Duration:
Industry/Company/Country:
Project title:
Description:
1997-12 to 1998- 12Oil & Gas / British Petroleum Amoco (BP Amoco) / Chicago IL
Project title Sr. Oracle Apps Consultant
Project Description
(Upgraded Oracle Applications from 10.7 to 11.0.3
(Upgraded and administered database instances to 8.0.5.
(Managed development and conversion instances for Unit Testing.
(Patch Management and application for various Apps instances.
(Moved all custom programs and reports to production. This involved enforcing naming
standards, maintaining the CUSTOM_TOP, and setting up concurrent requests.
(Administered security (users and responsibilities) and provided end-user support.
(Create and maintain custom responsibilities and menus.
(Tuned production database at customer site for improved performance.
(Provided support to development and implementation groups for all applications that
access Oracle databases.
(Administered Forms server, Concurrent Managers, and Report server.
(Created EUL and administered security and user access for Discoverer
(Installation of Web applications server, Oracle Applications server and Oracle Forms
server. Configuration of DAD, WAS cartridges.
(Planned, installed, configured, and perform upgrades of Oracle/SQL SERVER DBMS software
in a UNIX/NT environment
(Designed and implemented database backup and recovery procedures.
(Maintain and improve high availability and disaster recovery.
(Monitor and tune database performance of Oracle/SQL Server including SQL tuning.
(Implement effective database security practices and procedures.
(Developed and scheduled batch jobs using UNIX shell script.
SAP R/3 Skills
(Represented SAP Chicago's ASAP Project.
(SAP R/3 Basis module leader in the pre and post implementation Phase.
(SAP R/3 version 3.1H / Oracle / HP 9000 Systems / EMC Data Frame
(High Availability Cluster via Service Guard
(Installation SAP R/3 3.1H
(Oracle Upgrade from 7.3.3 to 7.3.4 and 8.0.4
(SAP Kernel patches and SAP Hotpackages
(Client strategy extended CTS support, including CTS training, CTS procedure rules and
documentation.
(Production Database design based on Oracle, including tablespace, file and table layout
down to the controller and disk layout on the EMC frame.
(Extended System tuning, (SAP CCMS and Oracle).
(Trained users, and additional Basis Consultants on the SAP R/3 product,
System management and Database maintenance.
Time/Duration:
Industry/Company/Country:
Project title:
Description:
1997- 06 to 1997- 07
Bank / Citibank of North America / Chicago IL
Project title Sr. Oracle Consultant
Project description
(Provided Functional and Technical Support for Oracle Financials 10.7 SC Environment.
(Planned, installed and configured Oracle software in a UNIX/NT environment.
(Tested new database and application patches followed by successful application.
(Solved all technical issues involving system design, architecture, and security.
(Created custom concurrent requests to perform database maintenance.
(Assist with configuration and usability issues reported by the users to include the
design/redesign of new business process that optimize the standard functionality provided
by the applications.
(Provided support for functional configuration, enhancements and production activities
for Oracle application environment.
(Customized Order Entry Forms and Reports for the end Users according to their Business
requirements.
(Developed and modified standard reports in Oracle Purchasing, Oracle Payables and Oracle
Assets.
(Converted reports from Sql Reports V1.1 to Oracle Reports V2.0.
(Involved in Performance and tuning for all the customized and developed Reports.
(Created Logical and Physical database design using ERWIN.
(Refreshed the development and test databases from production databases on a periodic
basis.
Time/Duration:
Industry/Company/Country:
Project title:
Description:
1995- 11 to 1997- 06
Consulting / Atlantic Duncan / Dallas TX
Project title Sr. Oracle Consultant
Project description
(Oracle Applications DBA. - Installs Versions 10.7 SC.
(Performed full range of DBA duties including installation and configuration of Oracle
software, logical/physical design, implementation of databases, performance analysis and
tuning, application design and implementation of vendor software.
(Managing the database through the various stages of the development life cycle.
(Implementing and maintaining database security (create and maintain users, roles and
assign privileges)
(Configured Multithreaded Server (MTS) to handle increased users.
(Provided production, test and development environment support.
(Created test plans and scripts and supervised the application testing.
(Provided problem resolution and troubleshooting.
Time/Duration:
Industry/Company/Country:
Project title:
Description:
1994- 04 to 1995- 07
Consulting / Software Consultancy / Dallas TX
Project title Sr. Oracle Consultant
Project description
(Database tuning, Application Tuning, Indexes, & performance monitoring. Changing
Initialization parameters, I/O, Memory and Operating System.
(Participated in all phases of the application development life cycle.
(Transformed business requirements into logical and physical designs using CASE tool,
Erwin.
(Setup client/server environment using native drivers and ODBC
(Created stored procedures, triggers, functions and packages.
(Developed day to day-reporting system using the VB Crystal report feature.
Time/Duration:
Industry/Company/Country:
Project title:
Description:
1992- 04 to 1995- 06
Consulting / Wipro / East Ind
Project title Oracle Consultant
Project description
(Database Installation/Administration.
(Managed Distributed database and applications.
(Database Sizing, Tablespace Management and Rollback Tablespace.
(Removed row chaining for better performance.
(Wrote scripts for backup and recovery, import and export procedure.
(PL/SQL and stored procedure coding.
( SKILLs:
IT-Skills:
GUI
Oracle Developer 6i/2000, VISUAL BASIC 6.x, Crystal Reports 10x
Operating Systems:
AIX/6000, HP UX 11/11i, SUN OS, Win 2K Advanced Server, Win, XP
ERP Application
Oracle Applications 11.5.10/11.5.9/11.5.4/11.5.3/11.0.3 / 10.7SC (GL, AP, FA, IP (11i),
PO, PA, INV, PAY, Time & Expense), OFA, Oracle 9iAS, BEA Web Logic, OAM 2.2, SAP4.6 D
(Basis) SAPDBA, 10g application server, Peoplesoft (HRMS, Payroll, Benefits)
SAP Releases
2.0FCS -> 4.6C/D -> WAS 6.20, ITS 4.0B - 6.10
Module Skills
Basis Administration, Analyzing, Tuning, CTS, ITS, R/3 and Database upgrades (incl. HR,
IS-Retail, and BW)
Database:
ORACLE 7.X/8.X/9i/10g, SQL SERVER, MS ACCESS, SYBASE 10
Oracle Tools:
Autoconfig RapidClone Opatch Oracle Enterprise Manager (OEM) DBA Studio RMAN
Net 8 Assistant SQL Loader Export/Import Discoverer 3i/4i Oracle Applications
Manager (OAM) AD Utilities
3rd party Tools:
ERWIN, S-Designer v5.x, OEM, SQL Navigator, BMC PATROL KM, TOAD, Precise, Quest Central,
RMAN, Legato, SQL-Backtrack, DB Artisan, Exceed, PVCS, Java Workshop, Remedy, Citrix, MS
Project, Visio, Unix Shell Scripting, NT Scripting, OEM Change Management pack, HP Open
Training
Oracle 9i: New Features for Administrators
Oracle 8i: New Features for Administrators
Oracle Financials System Administration 11i
Oracle 8i Database Administration
Oracle Financials 11i Upgrade
Oracle 8i Backup and Recovery
Oracle Financials Installation
Oracle 8i Performance Tuning
Oracle 9iAS Server
SAP Basis Administration (ADM 100/ADM 325)
HP-UX Administration I
People Tools I/II
Oracle Financial Analyzer
Peoplesoft Server Administration
Object Oriented analysis and design
IIS Server, BEA Web Logic, Dream Weaver 3.0
Terms and conditions - c2003 TalentedTechies.com all rights reserved
Contact this candidate