Oracle Manager

AFRUL GAFURKHAN

*** *** ****** **** • East Brunswick • NJ 08816 • 732-***-**** • **********@*****.*** • US Citizen

SUMMARY

• Over 19 years in the IT field with primary focus on Oracle Products (E-Business Applications & Core Technology) supporting Financial Services, Pharmaceutical & Consumer Electronics Industries.

• Lead Oracle DBA in several Oracle ERP (E-Business) / Core Oracle Implementation & Upgrade projects.

• Have installed/upgraded Oracle Applications (E-Business) versions up to 11i (11.5.10.2 CU2).

• Have installed/upgraded Databases ranging from 8.x, 8i, 9i, 10gR2 and up to 11gR2 (11.2.0.2).

• Well versed and have hands on experience on all the facets of Oracle Applications DBA tasks.

• Experienced in Core Oracle technologies like Data Guard, RMAN and RAC with ASM.

• Experienced in developing and implementing disaster recovery, backup and recovery strategies, performance tuning of large database systems.

• Strong knowledge of Unix Operating Systems and Shell scripting.

• An Oracle Certified Financials Applications Consultant.

• Provided Technical Architecture and Design recommendations for new installations and upgrades.

• Strong Analytic skills, Problem-Solving, Adaptability, Customer focus, Team playing, excellent interpersonal skills and effective communication are my key strengths.

• Valued contributor who performs confidently and effectively under pressure and thrives on challenge.

• Enthusiastic learner who can quickly grasp concepts and technical skills

TECHNICAL PROFILE

ERP Applications: Oracle Applications 11i up to 11.5.10.2, 11.0.3, 10.7 (Financials, iProcurement, Manufacturing, Self-Service Web Applications), SAP R/3 V3.1H (PP, MM, SD)

Operating Systems: RHEL 4/5, IBM RS/6000 AIX 4.33/5.3, Sun Solaris 5.8,2.6/2.5.1, HP-UX; DG/UNIX 5.4.x, Digital UNIX 2.0, Windows NT/2000, Linux Intel, Compaq TRU64

RDBMS/Software: Oracle 9i,10g & 11g, Forms 6.0/4.5, Reports 6/2.5, Designer 2000, Oracle Discoverer 3.1/4i, ADI 7.X/Web ADI, Oracle Workflow 2.X, Oracle Enterprise Manager for Windows NT, RMAN, Oracle 9iAS/10gAS, SQL*Loader, SQL*Net8, Oracle Names, SAP ABAP/4 (Reports, Module Pool, SAP Script, BDC), Taviz 2.0 Integration, Exadata, Legato, Netbackup, Precise, Foglight, Maximo, Noetix Views

Languages & Utilities: C, Pro*C, PL/SQL, COBOL, Foxpro 2.6, HTML, Unix Shell Programming, sed, awk, Optio Design Studio 1.1.14, PVCS, Toad 11, OEM

Case Tools: (ADW) Application Development Workbench; ERWin

PROFESSIONAL EXPERIENCE

Bank of America Corporation, Hopewell, NJ Aug 2004 – Jun 2012

Vice President, Database Admin

Financial e-Business Applications DBA support Activities:

Bank of America is one of the world's leading financial management and advisory companies providing financial advice and investment banking services. Bank of America consolidated its worldwide Financial Applications into a single Global ERP by implementing FGI (Financials Global Initiative) project on IBM AIX servers. My role and responsibilities in this prestigious project included the following key tasks.

• Installed and configured Oracle E-Business Suite of 11.5.9 on IBM AIX Servers and performed upgrades up to 11.5.10.2 for Financial Global Initiative implementation.

• Installed and configured Oracle E-Business Suite 11.5.10.2 with CU2 on RHEL 5 & RHEL 4 with split configuration of database on 64bit node and application tiers on 32bit node as needed for China Bank POC project. This was installed with Chinese NLS Languages ZHS & ZHT (Simplified & Traditional).

• Upgraded Oracle E-Business Suite Databases from 9i to 10gR2 (up to 10.2.0.4).

• Install / Upgrade of Oracle Application Servers (up to 10.1.2.3).

• Migrated Admin, Forms and Web Nodes from AIX to Red Hat Linux Servers.

• Patch Analysis, Patch application and Deployment including Oracle’s Critical Patch Updates (CPU).

• Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production.

• Provide Technical Support to Development and Production Instances.

• Clone Development instances from Production Instances using rapid clone/RMAN restore processes.

• Analyze and apply patches including Family Packs, Patchsets, CPUs and one-off’s using adpatch utility.

• Developing scripts in RMAN to perform cold and hot backups.

• Troubleshooting performance issues by giving suggestions to optimize the queries and configure database parameters for optimum performance.

• Implement GL Tables partitioning to improve reporting performance.

• Implement Localization Products on top of the existing Financial Production System.

• Configure and Administer Noetix Views to enable running custom Discoverer reports pertaining to Financial data.

Corporate Staff DBA support covering Corporate Workplace & Marketing and Enablement Tech Applications:

• Installed/Upgraded Oracle Databases ranging from 10gR2 to 11gR2 (up to 11.2.0.2)

• Configured Dataguard Physical Standby options for production environments.

• Apply periodic security patches and remediate audit related violations to be in compliance with corporate information security policies.

• Troubleshooting performance issues, tune application code for achieving optimum performance levels.

• Perform refreshes from production system to lower environments.

• Performed database migration tasks involving different OS platforms.

• Scripting to automate and schedule various routine maintenance tasks.

• Implementing baselines and best practices, quick turn-around for troubleshooting and support needs, release management and code deployments in all types of database environments.

.

Core Services Corporation, Union, NJ Jun 2000 – Jul 2004

Sr. Oracle Applications DBA

Clientele : AICPA, Genta Corporation, Ulticom Inc, Altec Industries Inc, J M Huber Corporation, Brewer Science Inc, Intelligrated Inc, Senior Aerospace Metal bellows Inc, Loud Technologies Inc, Old Mutual Plc, OSI Pharmaceuticals Inc, Caminus Corporation.

Implemented several Oracle Application installation/upgrade projects on various OS platforms ranging from Sun Solaris 2.6 / 8, IBM AIX 4.33, HP-UX, Windows NT to Linux Intel. My key responsibilities from these projects include,

• Installed/Upgraded Oracle Applications 11i (up to 11.5.9) on oracle databases up to 9.2.0.5

• Installed/Upgraded 9iAS (up to 9.0.2.3), Developer Patchsets, JDK, Techstack ias10222, Autoconfig etc.,

• Performed several application clones using adclone, rapid clone methodologies.

• Have extensive patching experience involving Family Packs, Patchsets and one-off patches.

• Installed and scheduled Statspack reports for performance tuning.

• Configured Workflow Mailer through UNIX mail and OAM (Oracle Application Manager).

• Performed Database recoveries (change, cancel and time-based scenarios).

• Installed and configured Advanced Planning & Scheduling (APS) system for clients using Manufacturing modules.

• Installed/Upgraded ADI (Applications Desktop Integrator) standalone and web based versions.

• Troubleshooting of ADI, Workflow, Self-service Web applications, CRM Foundation, OM Product configurator, JVM/Jserv related issues, iProcurement, Internet Expenses, TCF server & Apache Server.

• Creating and Maintaining Application users/responsibilities.

• Register custom concurrent programs, custom schemas, functions, and menus.

• Scheduling concurrent processes to perform routine housekeeping activities.

• Customizing Oracle Alerts to send out email notifications with reports.

• Customizing standard Oracle Workflow processes to accommodate changes required by the customer for automatic account assignments (Ex. Purchase Requisition Approval).

• Wrote several complex Discoverer reports in the Projects, AR and Service Modules.

• Have performed platform migrations of core oracle based applications hosted on older Solaris versions to newer Linux environments.

Core Services Corporation, Union, NJ Apr 2000 – May 2000

Oracle Applications Techno Functional Consultant

Client: Weightwatchers.com, New York, NY

Weitghwatchers.com, World’s leading weight lose management services company was migrating its financial systems from legacy systems to Oracle Applications Financials Release 11i on Sun Enterprise 3500 servers (Solaris 5.6). My responsibilities from this project include

• Implemented Oracle Applications (11i) Financial Modules GL, AP, AR, FA and CE using Oracle’s Fast Forward Implementation Methodology as a Functional/Technical Lead.

• Studied the existing Financials System setup and mapped on to the Setup document using AIM. Involved in configuration design and setting up of Core Financial modules.

• Custom Interfaced client’s web transactions into Oracle Applications to generate Auto Invoices and Customer master records.

• Developed several ad-hoc reports related to AR Module in Oracle Discoverer to help users rollout critical statements from out of Oracle Applications.

• Setup Applications Desktop Integrator with the client workstations and trained them on using it for Data Conversion (GL Balances Conversion and Assets Conversion) purposes.

• Created extension utilities utilizing Oracle’s standard APIs especially in the areas of Accounts Receivables (Automatic Receipt Batch Creation, Credit Memo Adjustment transactions etc.,)

Core Services Corporation, Union, NJ Jan 2000 – Mar 2000

Oracle Applications Techno Functional Consultant

Client: CINTRA USA, New York, NY

CINTRA USA, a premiere Oracle systems integration and solutions provider in the region was in the process of migrating their legacy financial systems to Oracle Applications Financials Release 11 on Sun Enterprise 3500 servers (Solaris 5.6). My responsibilities in this project include,

• Implemented Oracle Applications Financials Modules GL, AP, AR, FA, Purchasing and CE using Oracle’s Fast Forward Implementation Methodology as a Functional/Technical Lead.

• Involved in System Study, Requirement gathering, functional and technical gap analysis, configuration design, setup of modules (GL, AP, AR, FA, & CE) in a multi-org environment.

• Conducted requirement gathering, functional and technical gap analysis.

• Setup Applications Desktop Integrator with the client workstations and trained them on using it for Data Conversion (GL Balances Conversion and Assets Conversion) purposes.

• Customized workflow to populate account code combinations automatically in the Purchase Requisition process.

• Provided Production Support and trained the Key Users in the Application.

• Customized Accounts Payables Check printing program to suit to client’s requirement.

• Created Financial Reports (Balance Sheet and Income Statements) in FSG.

Core Services Corporation, Union, NJ Oct 1999 – Dec 1999

Oracle Applications Techno Functional Consultant

Client: Eureka Broadband Corporation, New York, NY

Eureka Broadband Corporation, a major facility based ISP who provides high speed internet/IP based application services to its business customers in the northeast region was migrating its legacy financial systems to Oracle Applications Financials Release 11 on Sun Enterprise 3500 servers (Solaris 5.6). My responsibilities in this project include

• Implemented Oracle Applications Financials Modules GL, AP, AR, FA, Purchasing and CE using Oracle’s Fast Forward Implementation Methodology as a Functional/Technical Lead.

• Involved in System Study, Requirement gathering, functional and technical gap analysis, configuration design, setup of modules (GL, AP, AR & FA).

• Setup Applications Desktop Integrator with the client workstations and trained them on using it for Data Conversion (GL Balances Conversion and Assets Conversion) purposes.

• Customized Oracle Standard AR Invoice printing to suit to client’s requirements.

• Provided Production Support and trained the Key Users in using the Application especially in the areas of Journal entries and Mass addition creation process.

• Setup Mass Allocations in General Ledger so as to calculate the Revenue by the location from the revenue account balance.

• Customized Accounts Payables Check printing program in Reports 2.5 to suit to client’s requirement.

Titan Industries Ltd (TATA Enterprise) Bangalore, India Jan 1998 – Sep 1999

Systems Manager

Titan Industries, World's sixth largest wrist watch manufacturer was then implementing a huge migration project from its legacy systems (oracle based In-house applications) to SAP R/3 ERP applications on Digital Alpha 1200 series servers and with Oracle 7.3 database. Being a core member of this prestigious project my responsibilities and areas include,

• Strategy Analysis where AS-IS processes of the organization were mapped and documented.

• Process Designing where the fit between SAP processes and the actual requirements were studied and TO-BE processes have been formalized. Reporting/Data Transition requirements have also been identified.

• Developed enhancement cum report program for demand re-allocation from a storage location of a plant to the storage location of another plant. Also developed a report for checking the Capacity and Material Availability for a given set of production orders.

• Written several report programs which gives the WIP (Work in progress) status of the Components/Products in the Production area.

• CATT procedures for upload of Work center and BDC programs for upload of standard text key, Class and classification data was also developed.

• Data transition had been a crucial phase in the entire SAP implementation. The legacy data has been uploaded to SAP system through standard BDC programs, CATT procedures and custom BDC programs. I was responsible for Routing, Work Center, Class, Characteristics master data transition as well as for initial Stock upload of various storage locations in the plant and the warehouses.

Titan Industries Ltd (TATA Enterprise) Bangalore, India Dec 1993 - Dec 1997

Systems Executive

Titan Industries was implementing an In-House MRP solution with Oracle Database (6.x/7.2.x) to maintain and support its business. The platforms vary from Norsk Data Systems, Data General AViion 5000/8500 Series to Digital Alpha 1200 series servers. I was part of the Programmer / Developer Team involving system study, design and implementation of the following modules.

MANUFACTURING PERFORMANCE APPRAISAL SYSTEM:

• MIS appraisal system for top management about manufacturing performance.

• Targeted, Actual, Growth rate Information is projected through this system.

• These figures indicate production details at its various production units, dispatches, exports, movement component production and Euro production.

(CAMMS) COMPUTER ASSISTED MAINTENANCE SYSTEM:

• Computerizes Break Down, Preventive and Predictive Maintenance activities of Maintenance Department through a centralized database.

• Facilitates recording of Equipment details and cataloging of Machine spares.

• Lists Machine wise PM (Preventive Maintenance) Schedules due to be performed.

• Records machine history details and helps in spares planning.

TRAINING INFORMATION SYSTEM:

• Comprehensive database covering training details of all employees in the factory.

• Facilitates release of Annual Training Calendar through system.

• Identifies training needs of the people level wise.

• Captures training attended details of the employees.

EXCISE ACCOUNTING SYSTEM:

• Statutory records maintenance and MODVAT (Modified Value Added Tax) Crediting.

• Gate pass Processing cum duty debiting.

• Daily maintenance of funds in RG23A, PLA excise accounts.

JOBCARD SYSTEM:

• Capturing Employees Work Details / Machine utilization on a daily basis.

• Calculation of actual Machine utilization as against standard norms.

• Aids in better planning of M/C utilization and for self-appraisal of the employees.

SUB CONTRACTING SYSTEM:

• Job Work tracking in view point of Excise regulations.

• Preparation of 57F4 document for excise accounting & 57F4 Material reconciliation of Sub-Contract material.

• Facilitates Creation of Sub Contract Orders, Release of Dispatch Vouchers.

WORK ORDER & WIP MANAGEMENT:

• Work Order release based on requirement and Master Planning.

• Preparation of Route card, Job card and Material Requisition for the Work Order.

• On-line data capture of operation complete information.

INVENTORY CONTROL MODULE:

• Perform on-line transactions of issues & receipts of components.

• Allows single or multiple inventory locations per component.

• ABC / Fast- Slow-Non Moving / Consumption reports.

• Aging analysis of components in a particular location.

• Generate kit issue list based on work order.

Titan Industries Ltd (TATA Enterprise) Bangalore, India Feb 1988 – Nov 1993

Sr. Planning Officer

As a part of the Production Planning Control (PPC) Team, my responsibilities included,

• Preparation of Production Program for finished products based on the marketing forecast for wrist watches.

• Planning for Material and Production for the final Watch Assembly and raise procurement requests.

• Coordination with Systems for online computerization of manufacturing modules.

• Coordination with Marketing/Logistics group for follow up and update on sales

EDUCATION / CERTIFICATIONS

• Graduate Degree in Industrial Engineering from Indian Institution of Industrial Engineering, Mumbai

• Oracle Certified Financial Applications Consultant in Procurement Release 11

• Oracle Certified Financial Applications Consultant in Order Fulfillment Release 11

• Unix & C Certified from Software Technology Group International

• Certified Oracle Application Developer from Digital Equipment India

Contact this candidate