Dennis Webb Email & Phone Number

Topeka, Kansas

Harrisburg, Pennsylvania Area

Member of four person DBA team whose primary responsibility is to provide 24/7/365 support in a large Oracle production environment, which includes Oracle versions 8.1.7 to 11g and Oracle Applications 11i. Secondary responsibility of the team is to clone production instances and maintain the development, testing and QC environments.Responsible for designing, installing, tuning, documenting, testing, and valuation of databases for new applicationsUpgraded and patched Oracle instancesDeveloped procedures and managed backup and recovery of Oracle instancesDesigned, installed and maintained Oracle Application Servers, versions 10.1.2.0.2 - 10.1.3.4, for J2EE applications and Oracle Internet Directory (OID)Monitored database and server health by utilizing Oracle Enterprise Manager (OEM) and Unix shell scriptsProvided technical support to large development team on SQL tuning, schema design and security, indexing and partitioningResponsible for investigating, testing and implementing new database technologiesInstalled and maintained MS SQL Server databasesAccomplishments Wrote and maintained scripts to automate cloning of 2 key databases and Oracle Applications.Provided support for Oracle Business Intelligence (OBI).Instituted documentation procedures used by the DBA team.Developed excellent working relationship with Development Team Managers and team members to provide better customer service.

Managed all purchasing and inventory control operationsResearched and qualified new vendors to reduce materials costsUtilized materials requirements planning (MRP) software to determine raw material needsMaintained Bills of Materials (BOM), item master and product costingInitialized and maintained work ordersCoordinated transfer of all materials between San Antonio and Philadelphia facilitiesAccomplishmentsEducated production supervisors on importance of accurately reporting production and scrap usage, which resulted in reducing total dollar variance from over $25,000 to under $6,000 on an inventory valuation of $2,210,000.Reduced raw materials storage area by over 50%.Developed and implemented a record keeping system on raw material specifications and purchase history.Mail-Well Envelope

Managed all purchasing and administrative operationsPurchased raw materials to meet a flexible production scheduleResponsible for accuracy of reported inventory levels by managing cycle counts and performing physical inventoriesNegotiated special pricing of raw materials with vendorsMaintained Bills of Materials (BOM), item master and product costingManaged three person order entry and billing staffAssisted Division Controller with end of month processingWrote and modified custom queries using SQLProvided hardware and software support for PC's in San Antonio and DallasMaintained AS400 WAN in San Antonio and Dallas, coordinated with IS Department in Chicago to resolve system problemsAccomplishmentsReduced raw material inventory total value by over 50% while production levels increased by over 30%.Improved office work flow by introducing and training the office staff to MS Word and Excel.

Bba, Industrial Management

Education record