EDUCATION

BBA in Management Information Systems

SOFTWARE AND HARDWARE KNOWLEDGE

Software: Oracle versions 7, 8, 9 and 10, SQL, PL/SQL, Oracle Grid/Enterprise Manager, Oracle Data Guard/Replication, RMAN using Veritas and Legato, Embarcadero DBArtisan, Tool for Oracle Application Developers (TOAD), Oracle Reports, Metalink, SQL*Net, UNIX (AIX, Solaris, HPUX, TI), IQ Reporting, GEAC Smartstream Financial Reporting, Crystal Reporting, Lawson H/R, P/R, G/L versions 7, 8 and 9, American Software Supply Chain Management
Hardware: IBM SP/2, SUN Sparc, IBM RS6000, HP9000, IBM 4300, IBM AS/400, IBM S/38, IBM 370, IBM 360

EMPLOYMENT

Confidential,Portland, Maine May 1999 Dec 2008
Oracle DBA
Performed Oracle DBA functions for mission critical production, development and test databases on the IBM AIX (Unix) platform. Production databases were up 24x7 and I was on call 24x7. Achieved no data loss for 10 years by strict adherence to the backup strategy and achieved 100% success rate of every payroll run over 10 years.

• Worked closely with user departments, development teams and 3rd party vendors to define and implement database architecture that meets defined functional, operational and security requirements.
• Monitored databases with Oracle Enterprise Manager and DBArtisan to troubleshoot and performance tune databases.
• Created and sized Oracle databases, tablespaces, datafiles, tables and indexes.
• Imported and exported data to/from the production, test and development databases as required.
• Designed, created and maintained Oracle security for production, development and test databases.
• Performed database backup and recovery using RMAN, Legato and Veritas.
• Developed disaster recovery plans and performed regular disaster recovery trial runs.
• Executed ‘point in time’ recoveries with RMAN to facilitate testing.
• Created standby databases with Oracle Data Guard for use in fail over.
• Installed and upgraded databases from 8 to 8i, 8i to 9i, and 9i to 10g.
• Worked with Unix administrators to analyze load on CPU, disk and memory. Made hardware upgrade recommendations.
• Wrote complex SQL to analyze data for integrity and quality issues. Maintained PL/SQL.
• Designed, created and maintained Oracle triggers for various database integration projects.
• Wrote complex G/L, P/R and H/R financial reports with Oracle Reports and Crystal Reports.
• Designed, created and maintained Unix shell scripts to run Oracle backups and SQL jobs.
• Maintained a custom budget application written with Oracle Forms.
• Tested and validated data loads and extractions for quality and accuracy in production, test and development.
• Created physical database from logical database design for tables and indexes.

Confidential,H/R and G/L System Administrator
Performed system administrator duties for Lawson P/R, H/R and G/L.

• Worked with the functional/user community to design report layouts and map report layouts to Lawson data structures.
• Worked with developers to design new files, indexes, relations, conditions, subtypes, rules and events to support customizations, conversions, interfaces and reports.
• Analyzed change requests from users for their impact and feasibility and implemented approved change requests.
• Maintained complex data dictionaries for G/L, P/R and H/R.
• Recommended and enforced naming standards for Lawson data dictionary and Oracle database objects.
• Created and maintained user security for product lines, forms and data elements.
• Involved with installation of Lawson cyclical releases.
• Prepared databases for unit, system and parallel testing.
• Assisted with the conversion activities for Lawson versions 7.0, 7.2, 8.0.3 and 9.0.4.
• Assisted with the control of the Lawson Servers compile queue, transaction manager, job queue, etc.
• Installed and maintained BSI – Taxfactory.

Confidential,Los Angeles, CA September 1993 May 1999
Project Leader and Oracle DBA
Managed large systems projects for the corporate offices of a Fortune 500 company.

• Implemented and supported an Oracle 7.0 client server Legal Case Management System for the Los Angeles and New York corporate offices on the Sun Solaris platform. Performed manual Oracle 7.0 backups. Wrote financial reports with Oracle Reports. Wrote SQL to create views for reporting. Installed and maintained SQL*Net.
• Managed 30 programmers in the conversion of all Times Mirror payroll systems from Wyatt 401k provider to Fidelity Investments. Project included: 401k savings for 40,000 employees; ½ billion dollars in 401k employee savings accounts; 9 different payroll systems. Project was completed early and on budget.
• Led the implementation of a Cash Management system involving 3.5 billion dollars worth of yearly cash flow. Project included moving all cash operations from the New York corporate offices to the Los Angeles corporate offices. Project was on time and within budget.

Confidential,Los Angeles, CA February 1990 September 1993
Manager of Information Systems
Managed 3 employees to support all corporate computer hardware and software development, implementations, operations, acquisitions and maintenance for a Real Estate Brokerage with 3,000 agents in 25 offices.

• Designed and implemented software modifications in an integrated finance/accounting environment.
• Troubleshot G/L, A/P, A/R, and P/R software for errors in transaction processing and financial reporting.
• Managed intricate relationship between the V.P. of Finance, Controller, contract programmers and hardware vendors including budgeting for hardware and software needs.
• Supported a Unix network with 50 users at three remote locations.
• Managed hardware and software support for 300 IBM PC’s, and 20 Mac’s running MSWord, Lotus 123, and Pagemaker.
• Coordinated all communications involving 50 PC’s and a Unix network communicating with 9 different mainframes.