Oracle Management

**** ****** **. * (***) ***-

****

Heath, Ohio **056 H (740)

***-****

EXPERIENCE:

IT System Analyst: American Electric Power, Columbus, Oh (1999-2010)

. Interviewed users to obtain and clarify needs and requirements for

applications to be developed or enhanced.

. Developed all the system documentation.

. Made recommendations for improving business processes based on

business' needs.

. Wrote and performed system test cases and assisted users with user

acceptance test cases.

. Wrote queries and improved queries based on improvements made to the

new versions of Oracle to assist management track data issues.

. Reconfigured the database code provided by a vendor from MS SQL Server

to Oracle.

. Performed data analysis to discover data gaps.

. Developed procedures to eliminate data gaps.

. Added fields to tables based on the needs and requirements of the

business process.

. Added indexes, constrains, triggers, foreign keys to tables to improve

performance.

. Added new tables to meet new requirements and modifications to the

business process.

. Wrote new Oracle stored procedures and improved existing stored

procedures to gather data from other Oracle databases via dblinks, to

eliminate the need to enter data multiple times.

. Wrote an Oracle Stored Procedure to gather data from a DB2 database to

help engineers automatically monitor the progress of their projects

against the project financial expenditures, to prevent over-spending.

. Wrote new Oracle stored procedures to automate manual processes; the

stored procedure sent e-mails to the users with the results of the

queries contained in the stored procedures.

. Developed Oracle jobs to launch stored procedures that performed data

analysis overnight.

. Advised development team on the structure a database to minimize

development time.

. Advised my team on all Oracle issues such as why a stored procedure

was not working as expected and how to optimize queries to reduce

processing time.

. Maintained and improved programs written in PowerBuilder.

. Took ownership of financial and inventory management systems, and made

improvements to minimize support costs by 25% while improving the

quality of the systems.

. Lead an IT group during the implementation of a project management

system.

. Reviewed programs for compliance with the Sarbanes-Oxley Act.

. Prioritized the duties of programmers.

. Analyzed Regulatory requirements and implemented procedures to ensure

AEP compliance with those regulations.

IT Program Analyst: Nationwide Insurance, Columbus, Oh (1995-1999)

. Made recommendations on the implementation of new development and data

modeling tools to improve the efficiency of the IT department.

. Developed, maintained and improved a system to allow the agents to

view and monitor their sales.

. Developed an Oracle Data Mart to monitor the status of new life

policies so they will be efficiently processed.

SR. Program Analyst: Bank One, Columbus, Oh (1992-1995)

. Interviewed users to obtain and clarify needs and requirements for a

customer contact database and other applications.

. Wrote system designs documents based on requirements

. Developed, documented, maintained, and improved a customer contact

database written in PowerBuilder.

. Performed the role of Data Administrator for an Oracle customer

contact database.

. Made presentations to all levels of management.

. Developed a check processing system that reduced the processing time

of checks from 5 to 2 days.

Implementation Consultant: Concept XXI, Cleveland, Oh (1990-1992)

. Utilized systems development life cycle methodology to develop an

inventory tracking system.

Programmer Analyst: AXA/Equitable Life Insurance, New York, NY (1988-1990)

. Analyzed program used by agents in the selling of life insurances.

Recommended and implemented code modifications to improve the accuracy

and performance of the program based on my analysis.

. Coordinated the efforts of a team of programmers.

EDUCATION:

. Certification in Micro Computers, Columbia University

. Master in Business Administration: Management Information Systems,

Pace University

. Bachelor in Business Administration: Accounting, Bernard M. Baruch

College

SPECIAL SKILLS:

. Advanced knowledge of MS Office and Lotus Notes

. Advanced knowledge of Oracle PL/SQL language and Crystal Reports

. Bilingual in both the English and Spanish languages

. Certification in VB.NET and PowerBuilder

Contact this candidate