Oracle Applications DBA

Morrison Satvedi

Aurora, IL Cell 630-***-**** ********@*****.***

Professional Profile:

Morrison Satvedi has 12+ years of experience as an Oracle DBA, Oracle Applications DBA, Programmer, Developer and Techno-Functional Consultant. His experience includes Database administration, architecture, tuning, backup and recovery, Application design, development and Application performance tuning, and complete SDLC. Experienced in analysis, recommendations, and implementations of complex, global Oracle ERP systems. Excellent communication skills, great team player, and ability to translate business requirements to technology solutions.

Professional Overview:

• Oracle Application installs R12, 11i, 11.0.3; upgrades from 11 to 11i, 11.5.7 to 11.5.10.2, 11.5.8 to 11.5.9,11.5.3 to 11.5.8; Cloning, Patching, SSL, DMZ configuration

• Oracle Database Server 10g, 9i, 8i, 8, 7.x Installs, Upgrades 9i to 10g, 8i to 9i; platform migrations, Tuning using AWR 10g, Statspack 9i, Backup and Recovery, DR, HA environments, SQL Tuning

• Experienced Production Support DBA, Application Support DBA, complete SDLC support

• Techno-Functional in Oracle GL, AP, AR, CM, XLA, HR, Payroll, OAB, PO, INV, OM modules

• Conversions, Interfaces, Batch Jobs, Scheduling, Data Encryption/Decryption, SQL Tuning and Optimization

• Oracle Applications System Administration R12, 11i, 11; Personalization, Customization, Custom Top, Responsibilities, Menus, Request Sets, Requests, KFF, DFF, Value Sets

• Experienced in leading technical teams, and performing project manager duties

• Presentations at NCOAUG, Fall ’04, Spring ‘05

• Experienced in Logical and Physical database designs, object layout and sizing

• Experienced in Oracle Database object development such as packages, procedures, functions, triggers, tables, indexes, views, materialized views, temporary tables using SQL and PLSQL

• 3 years of experience as Unix Administrator on Sun Solaris 8 and 10, install Solaris, patches, configure SAN, Disk Arrays, boot from SAN, disk partitions, disk to disk, disk to tape backups, Shell scripts, Cron jobs

Skills:

Software:

Oracle Applications R12,11i,11 Oracle Database 10g, 9i,8i,8,7 Oracle SQL, PL/SQL

Oracle Application Server 9iAS, 10AS 10g Grid Control, OEM 9i(Oracle Enterprise Manager) OAM (Oracle Applications Manager)

Oracle RMAN 8i, 9i, 10g Oracle RAC 9i Rapidclone, AutoConfig

Oracle Workflow Builder Oracle Export/Import Utilities Oracle SQL*Loader, SQL*Net

TOAD (development tool) X Windows, Secure CRT,SSH SQL Developer

Veritas Volume Manager, FileSystem, NetBackup Shell Scripts (Bourne, Korn, Awk) Solstice Disk Suite

Commvault Galaxy Autosys, OmnibackII MS Projects, Excell, Access, Word PP

Hardware:

SunFire T1000, T2000, V880, 420R, 220 servers, SUN Disk Arrays A1000, D1000, Hitachi Disk Array SAN, EMC Clarion array

Methodologies:

Oracle AIM (Application Implementation Method), R2i (Rapid Return on Investment, KPMG)

Operating Systems:

Solaris 10, 8, Linux Redhat, HP/UX , MS Windows XP, 2000, NT, 98, 95, DOS

Certification/ Training:

Oracle Real Application Clusters 9i Oracle Applications System Administration

Oracle8i Database Administration and Architecture Installing and Maintaining Oracle Applications 11 & 11i

Oracle8i Backup and Recovery Oracle Financials Functional and Technical Foundation

Oracle8i Performance Tuning CRM Service Functional

Oracle8i Network Administration Unix System Administration

Education:

MS Mechanical Engineering, Wichita State University, Wichita, KS, 1995

BS Physics, Bridgewater College, Bridgewater, VA, 1992

Work Experience:

The Revere Group June 2005 – March 2009

Senior Technical Specialist

Client – Suntimes: Oracle Applications DBA, Techno-Functional GL, AP, CM. Technical Team Lead

Project is a reimplementation of Oracle Applications R12 from 11.0.3.

• Fresh install of Oracle Apps R12 multiple instances, cloning, patching, tuning, instance management, disk space management, logical physical mount point, Raid configuration

• Data conversion for Invoice Payments, Checks, Journals and Bank Statements; sql tuning on conversion programs

• Interfaces for inbound Bank Statements, outbound positive pay file, active users report, sql reports

• Platform Sun T2000 servers, Oracle Applications R12 (12.0.4) Database 10gR2 (10.2.0.3), AIM documentation

• Functional on Supplier, Site, Invoice, Payments, Create Accounting, Transfer to GL, Bank Statements, Reconciliation, Ledgers, Accounting Flex Field Structure, Banks, Bank Accounts

Client – Mesto Power: Techno-Functional AR, AP. Client is on Oracle On Demand; user Interwise connectivity.

• Created reports to identify discrepancies between invoices and receipts, outstanding invoices etc.

Client – Revere Group: Install and configured Oracle Demantra.

• Installed Oracle Database 10.2.0.1, upgraded to 10.2.0.3, Oracle Application Server 10AS 10.2.0.2, Oracle Demantra and configured. Setup war file for configuration between Demantra server and Application server.

• Oracle Demantra server Windows 2003 server, Oracle Database and Application server Redhat Linux 4.0

Client – Central Grocers: Vendor Selection. Technical Specialist

• Reviewed and documented client’s existing architecture and application requirements

• Participated in multiple vendor presentations, representing the client in the vendor selection process. Reviewed and analyzed packaged ERP products, JD Edwards, SAP, Lawson, and Infor.

Client – PSAV: Oracle Applications Upgrade to 11.5.10.2, Db 10.2.0.3 Oracle Applications DBA, Project Manager.

• Project planning, managing resources, allocating tasks, client status updates

• Migrated Applications to offsite location on to new hardware, Sun T1000 servers, installed Solaris 10, configured to SAN, disk management, partitions, boot from SAN, implemented new backup solution

• Upgrade from Oracle Applications 11.5.7, db 8.1.7 to Applications 11.5.10.2, db 10.2.0.3

• Research and planned implementation of 10g RAC, hardware, software, interconnects, Veritas volume manager

Client – Revere Group: Setup offshore delivery team in India

• Spent 2 months in India to setup an Oracle Applications offshore delivery team. Involved reviewing resumes, interviewing, hiring, technical and functional training.

• Working as project delivery manager to coordinate tasks, work, time frames between client and offshore team.

Client – AJ Gallagher: Techno-Functional on Oracle HR, Payroll and OAB implementation. Technical Team Lead

• Design, developed conversion for Organization, Location, Job, Employee, Employee History, Assignment, Salary, Benefits data from legacy Ceridian SQL Server db. Used api’s as provided for conversion

• Functional on configuration of OAB, Programs, Plans, Options, Life Events, Employee, Assignment, Salary

• Interfaces for ESPP, 401K, Medical/Dental, Life Insurance, reports for conversion verification

• Worked with HR/Payroll and OAB functional personnel in configuring and setup of Oracle, such as Vertex software for taxes, Elements, Fast Formulas, Life Events in OAB, setup of program, plan, and options for Benefits.

• Assisted with reviewing patches, and patch prerequisites, cloning issues, check printing etc., instance management

• Loading of balances for earning, taxes, deductions etc

• Platform Sun Solaris 5.8 on Sun enterprise servers with attached SAN, Oracle 11.5.10.2, db 9.2.0.5

ORA-APPS DBA, Inc. Feb 2004 – May 2005

Senior Oracle Database Administrator/ Oracle Applications DBA

Client – Recycled Paper Greetings (Jan 05 – May 05)

• Supporting daily production issues, development during SDLC, monitoring production alert log, patches, providing direction for data warehouse tuning efforts, and coordinating tasks for dba team

• Implementation of RMAN for backups, installed catalog, register target db, scripts to perform full and incremental backups, scripts for archive log backup, catalog db backup

• Install and configuration of Oracle 10g Grid Control to monitor targets such as servers, database, and web applications. Configured to send email notifications where thresholds exceeds, or errors in alert logs

• Data purging strategy project lead, data to purge, standard purge programs, data dependency, table and index reorg

Client – Rockwell First Point Contact (Feb 04 – Dec 04)

• Oracle Applications upgrade 11.5.8 to 11.5.9, db upgrade 9.2.0.4 to 9.2.0.5

• Implemented OATM model, new Forms Listener Servlets technology, and load balancing of Apache Jserv

• Implemented Commvault and Oracle RMAN for backup strategy

• Wrote Alerts in korn shell and sql to monitor database and listener processes, and application processes on a 24*7 basis, notification by email, and phone for critical alerts, monitor of 3 production db’s

Prairie Packaging, IL Aug 2002 – Feb 2004

Oracle Database Administrator/ Oracle Applications DBA / Unix Administrator

• Production Support DBA 24*7, support, monitoring, maintenance of multiple Oracle productions db’s including Oracle Applcaitions. Oracle Applications upgrade 11.5.3 to 11.5.8, db updagrade 8.1.7 to 9iR2, 9.2.0.4

• Implementation of Oracle RMAN for backups, Catalog db install, scripts to perform backups

• Unix Administrator tasks such as install, configure and setup of Sunfire V880, Sun 420R and 220 servers, install and configuration of Solaris8, Solstice Disk Suite, Veritas Filesystem and Veritas Volume Manager, SUN Remote System Control, SUN Management Console. Applied OS patches. Configured servers as Raid 1, 1+0, and 5

• Supported Oracle Applications modules AR, AP, FA, GL, PO, INV, OM, BOM, WIP, Engineering, Cost Management, Incentive Sales Compensation, and HRMS

• Setup of Physical Standby database on Windows for WMS system

• Evaluation of software such as Live Archiver, Veritas 3.5, Oracle Data Guard, Big Brother, Oracle on Linux, RAC

Oracle Corporation, CA Mar 1998 – Aug 2002

Senior Consultant, Principal Consultant

Projects:

McDonalds Innovate: Innovate project is to implement a single global instance on an Oracle Database to support McDonalds corporation worldwide and implement Oracle Applications, Financials, Manufacturing, Human Capital, and Supply Chain. Filled in as the Infrastructure Delivery lead, as the liaison between the Innovate IT and the various business tracks. Gathered the requirements for the various environments, information to assist architects in completing logical and physical architectures, and point person for all change requests from business. Gathered the versions of the required components of Oracle Application modules for the GIF for CRP, which is 11.5.6, and 11.5.8 for go live, on a single Oracle9i instance. Worked as the Manugistics development team lead, leading 6 developers and managing the project plan and time frame. Used R2i methodology for project implementation. Worked on design, build, unit, integration and user acceptance testing, and implementation phases.

McDonalds ILS: Involved in Application and Database upgrades from 11 to 11i and 8 to 8i respectively. Applying patches, configuration of Applications on 3 tier. Designed and developed for an Oracle Applications 11i implementation of Oracle Inventory, BOM, Engineering, 3rd party software Manugistics and custom software CIM (Centralized Inventory Management) for supply chain management. Responsible for customizing Applications and integrating with Manugistics and custom software. Worked extensively with Oracle Large Organization features for 11.5.4. Technical and functional knowledge of Oracle application modules, and Manugistics. Designed and developed various interfaces, custom workflow and reports. Test Lab resource from development, worked extensively with Oracle Development on Oracle Large Organization functionality. Oracle Applications 11 & 11i, Developer 6i, Workflow 2.5/2.6, Oracle8 & 8i, Oracle 9iAS, Oracle Portal. Used Oracle AIM methodology for project documentation.

Follett Software Corporation: Worked in implementing Oracle Applications 11 modules Receivables, Payables, Order Enter, Purchasing, Inventory, Service, Bill of Materials (BOM), and, Sales and Marketing. Responsible for customizations and extensions of Oracle forms and reports to meet the clients business needs. Worked on the data migration of items, orders and invoices from the legacy system and import into Oracle Applications. Wrote custom interfaces to integrate with downstream legacy systems. Oracle Applications 11, Developer 4.5, Workflow 2.5, Oracle8.

Oracle Corporation: Worked at Oracle Corporation in analyzing and determining the functionality of CRM Oracle Applications 11i. Worked on the gap analysis between the present legacy systems and CRM 11i. Responsible for the modules of Customer Care, Service, Contracts Core and Service Contracts. Worked on the data mapping and the data conversion and interface strategy. Deliverables included AIM documents.

Ameritech: Worked on implementation of Oracle CRM 3.0 suite Contracts and Services. Was involved in the setup of the application modules to adhere to the new business process. Worked on conversion of the customer, contracts, services and items data from the legacy systems to Oracle, included extensive analysis and mapping of the legacy system data to Oracle. Used api’s where applicable to insert data into base tables, and wrote custom code where not applicable. Involved in custom development of designing and development of forms and reports to meet additional business functionality. Responsible for designing and writing interfaces, which synchronized data between the legacy systems and Oracle. Wrote custom PL/SQL code for workflow. Worked on Oracle Financial application modules of Account Receivables, Inventory, Order Entry, Bill of Materials, Work in Progress and General Ledger. Oracle Applications 11, Workflow 2.5, Oracle8.

Nextel: Worked on designing, creating and implementing a datamart for Nextel. Worked on creating and sizing of staging and destination tables in Oracle 7.3 database. Responsible for mappings between flat files coming from legacy system and staging tables, and staging tables and destination tables in EDMS. Loading of staging tables from flat files using SQL*Loader. Modified package generated from EDMS for transferring and transformation of data from staging tables into destination tables. Worked on automating the loading process using Shell scripting, and verifying loads with number of records, totals of current gross, current taxes for pay period. Used Discovery 3.0 in creating reporting query for the upper management. Involved in unit testing, user acceptance testing, and implementation of the front-end application.

Cirrus Technologies, Des Plaines IL Feb 1997 – Feb 1998

Consultant

Motorola: Worked as an Oracle DBA. Responsibilities included managing and monitoring 11 different Oracle 7.x production and development databases/instances on 4 HP servers. Upgraded database versions, cloning of Production for Test and Development instances. Daily tasks included adding new users, granting of privileges and roles, modifications and addition of database objects, table and index size calculations, creating tablespaces, adding data files, monitoring table and index segments for number of extents. Verification of daily online and offline backups, database exports and imports, SQL*Net listeners, and shutdown and startup of databases. Worked with various tools such as Oracle Server Manager, Eco Tools, Autosys, Omniback II, and Oracle Enterprise Backup Utility for daily monitoring and backups of databases.

CNA/Alexsis: Working as part of a software team in designing and developing an application for a claims reporting center. Involved in the complete life cycle development from High Level Design, Detail Design, Coding, Unit Testing and Integration testing. Worked on the front-end in creating screens, and on the back-end using PRO*C for distributing claims to various state agencies. The application captures information for workers compensation, auto liability, general liability and personal liability claims. The application also uses EDI to transfer claims electronically to the respective state claim offices and agencies. The application was developed using Oracle 7.1, Forms 4.5, Reports 2.5, and Graphics 2.5.

Johnson Controls: Worked with the Johnson Controls Property Management group in designing and creating reports using SQR Report Writer. Reports include generating workorders, calculating estimated and actual labor hours, mean times to respond and repair, pulling delinquent and backlog workorders for areas and regions, and management information. The database is Oracle 7.3.

New Logic Inc., Chicago IL May 1996 - Jan 1997

Consultant

Projects:

Market Tracker: Worked as an Oracle DBA on the design of the ERD and the database. Installation of the Oracle 7.3 database and configuration of parameters. Created tablespaces, rollback segments, roles, granting of privileges and roles to users etc. Wrote the create table, constraint, and index scripts. Porting of data from text files into the Oracle database using SQL*LOADER and control files. Data scrubbing and validation. Created views to join various tables together. Wrote functions and procedures on the server side to calculate totals, percentages, medians and averages, monthly rollovers, quarterly and yearly figures.

Datacron Inc: Installed Oracle7.3, worked in creating an Oracle database from the existing MS Access database. Responsibilities included creation of tablespaces, rollback segments, roles, tables, constraints and index scripts; creation of a development Oracle database for the programmers to switch development from the present Access database. Used Oracle Objects for OLE , the Oracle Data Control, for the connection between the Oracle database and the front end in Visual Basic. Used S-Designor in creation of an ERD. Porting of test data from Access to Oracle. Control scripts to use in SQL*LOADER for porting of present users from Pick systems to Oracle. Data scrubbing and Validation. The database version is Oracle 7.2.

References:

Will be furnished upon request.

US Citizen.

Contact this candidate