Oracle Manager

Catherine Hintze

***** ***** ****

Mechanicsville MD 20659

301-***-****(cell)

*********.******@*****.***

OBJECTIVE:

To work with a group of Information Technology professionals who take pride in their work, respect the input of all team members and recognize individual strengths to facilitate achieving their goals as a team.

QUALIFICATIONS:

IT experience includes but is not limited to, engineering relational database management systems, data analysis, backend database programming to include

Triggers, functions, procedures, and packages, managing diverse groups of IT professionals simultaneously, participating in business process reengineering for Government and commercial installations, continuously implementing capabilities maturity model(CMM)/software, implementing software configuration management(SCM) processes and actively contributing to the full software development lifecycle (SDLC).

EDUCATION:

1983 -1984 Charles County Community College

1985 Certificate Data Processing, Yorktown Business Institute

1992 Oracle Database Administration 7.3, Oracle Education

1993 Oracle Reports, Oracle Education

1993 Oracle Forms, Oracle Education

1993 Oracle Graphics, Oracle Education

1996 Oracle Reports I, Oracle Education I

1996 Oracle Forms II, Oracle Education

1996 Oracle Graphics II, Oracle Education

1998 Oracle Designer, Oracle Education

1998 Master Developer Certificate, Oracle Corporation

2000 Star Team, Star base

2001 Programming a SQL Server Database, Software Technology

2002 HTML, Software Technology

2002 Cold Fusion, Software Technology

2005 Remedy -Introduction to helpdesk software.

2005 Remedy -Server administrator

2005 Remedy -Developing Applications

EMPLOYMENT:

Aug 2011 – Present Oracle Analyst, Infojini

As an Oracle Analyst for Infojini I support the Maryland State Highway Administration(SHA). I am the sole resource for data conversion and inclusion into the SHA centralized database for asset inventory and management. I use ARCGIS to reproject the x and y coordinate system received to the standard coordinate system used by SHA. I also maintain data structures and user access for the asset database. PL/SQL scripts used to import the reprojected data were created and are maintained by myself.

Jan 1010 - March 2010 Operations Analyst, Tsymmetry Inc.

Operations analyst supporting Department of Homeland Security's Smart Border Alliance(SBA) team. Responsible for maintaining the production environment that supports the air, land and sea entry points into the United States. Developed PL/SQL scripts for data cleanup from our various customers. Also developed PL/SQL scripts for batch processing from consulates around the world.

Data was received in many formats to include comma delimited files, spreadsheets, and other database repositories to include MSAccess and SQL server. Files were received via FTP sites, database links and various forms of electronic media.

April 2009 - June 2009 Sr Database Analyst, Booz Allan Hamilton

Technical lead performing maintenance on the Logistics system used by SCR. The application was developed using Oracle Forms which contain triggers written in PL/SQL and various stored procedures written in PL/SQL. I was responsible not only for enhancements and maintenance of existing functionality but for performance tuning of the sql statements as well as making recommendations to the DBA staff for structural changes that would increase performance for the end user. The system used Oracle 10g in a UNIX environment for the backend. Working on migration to 11i when I left. Performed adhoc queries to support data calls and provided results via spreadsheet. Toad was used for quick data fixes and for real-time analysis of sql query performance. UNIX scripting was used for scheduled jobs.

October 2008 - February 2009 Sr Analyst, Indus Corporation

Performed maintenance on the financial system used by the Department of Transportation to track and monitor the allocation of funds that are used to maintain roads and bridges. Oracle Forms containing many triggers written in PL/SQL was used for the front end and Oracle Reports was used to satisfy reporting requirements. Used oracle 9i and 10g for the backend running in a UNIX environment. Performed analysis to determine the reason for discrepancies in reports when they were converted from sqr to Oracle reports.

April 2008 - July 2008 - Sabre Systems

Maintained and enhanced a financial tacking system used by the Navy to track funding and maintenance on the Navy's fleet. This application used Oracle Forms and Reports for the front end and 10g for the backend running in a UNIX environment. Both forms and reports contain may triggers which are written in PL/SQL. Toad was used as the analysis tool of preference.

November 2007 – February 2008 Analyst, Synergy Software Design

Developed a web application for Navy Facilities Engineering to capture information used for generating the mission dependency index which directly effects the distribution of budget funding. This application used an Oracle 10g RDBMS for the backend and HTMLDB/Application Express(APEX) for the front end. SQL Navigator was the developer/analysis tool of preference. PL/SQL was used to migrate the data from the existing Access system to the new Oracle system. Many of the shared object and program units were also written in PL/SQL. Data analysis was performed on the source data to normalize the data and the storage scheme enhanced to ensure data integrity was maintained, redundant data was eliminated and storage structures re¬-engineered to support an efficient relational model.

October 2006 - February 2007 Consultant, Tek Systems

As a consultant to Calvert Cliffs Nuclear Power Plant (CCNPP) I maintained existing applications written with Oracle Forms and Reports with an Oracle 9i backend. Forms and report contained may triggers as well PL/SQL libraries and stored procedures which were all written in PL/SQL.

Additionally, I was tasked with recreating a windows 95 server that used Visual Basic 4.0 to act as an interface between the CCNPP applications and a work management application running on a remote server. This was a vulnerable situation as there was no backup server and none of the original developers were still employed. Tasking was completed prior to my departure in February 2007. ERWIN was the entity diagramming tool used.

November 2004 - December 2005 Senior Software Engineer, BAE Systems

As a consultant to Lockheed Martin (for BAE Systems) I managed the data loads for real-time flight information to facilitate maintenance of aircraft in a timely and effective manner. This was largely backend work requiring SQL, PLSQL, and UNIX scripting skills to develop new scripts and maintain existing ones. All data was housed in Oracle 9i and I was responsible for tuning the database(s) and reengineering poorly designed tables where necessary.

Additionally, I developed and maintained the National Navy Helpdesk software which provides all Department of Navy employees, military and civilian application users the ability to report application issues and receive timely status updates and rapid resolution to their issues. This required Remedy software skills which I acquired in a classroom setting this year.

I acted as the Software Configuration Manager in the absence of the primary Configuration Manager. This required knowledge of Star team configuration management software which I have been using for about eight years.

Due to under-staffing, I also joined a team for a couple of months to get a "hot" project delivered on time that required use of my HTML, ColdFusion, SQL and SQLPlus skills to help the team meat their deliverable targets.

March 2000-October 2004 Senior Software Engineer, Information Spectrum Incorporated

As a contractor to the Patuxent Naval Air Station, Information Management Department (IMD), I worked with a team to re-engineer the relational database for NAVAIR that holds information regarding all automated processes for the purpose of reducing redundancy, alleviating the budget of unnecessary maintenance costs and providing consistent responses to the various data calls received by NAVAIR. Responsible for the design, development, testing and implementation of the NAVAIR Applications Repository (NAR 2.0) that acts as the front end for the previously mentioned database. This system used ORACLE 9i for the database, Designer 4.4 as the design tool and the application was developed using JAVA, HTML, Cold Fusion, Oracle Forms/Reports 6i, PL/SQL and SQL.

Responsible for the data mapping of all data in the legacy databases to an Oracle 9i Data Warehouse. All mapping was performed with Informatica (a tool similar to datastage). I was a key team member in the creation of the warehouse data dictionary which held all of the metadata definitions.

I was responsible for the maintenance and security of the Base Access System. This system was developed using Oracle forms and reports containing many triggers and procedures written in PL/SQL, supported an automated visitor machine and produced the picture badges necessary to gain access to the base. The system incorporated workflow processing for the purpose of routing visit request to the proper authorities for approval. In many cases this database supported the local authorities through queries that I performed. I received honorary recognition from the Naval Criminal Investigative Services for my support following 9/11/2001 and a "Salute to Excellence" from NAVAIR for going above and beyond the call of duty at a time of national emergency.

I maintained the Training Records and Control System (TRACS) for human resources and receive an "Excellence in Customer Service" award for my efforts on that project.

All applications were housed on Sun Solaris running UNIX.

May 1997- March 2000 Software Manager, BAE Systems Inc

As the technical lead and staff manager I led a 2 year effort supporting the Naval Weapons Command, Aircraft Division (NAWCAD).

Seven Oracle character based applications supported by seven separate databases were combined to reduce maintenance, increase data integrity and reduce required labor to align the business process with the ever decreasing budget. I used PL/SQL to extract data from the old data stores, manipulate the data according to the data integrity rules established, and to load the new data structure. These scripts generated processing statistics as well as error logs for the purpose of ensuring no data was lost and for accurate estimates for the duration of the migration effort. The result of the effort was a single 8i database repository, running in a UNIX environment and a web enabled application that provided the logistics and engineering support to the respective departments that were responsible for building and deploying the Radio Control Systems on our Navy Destroyers.

April 1995 - May 1997 Consultant, St. Mary's College

I assisted in the development of a database support system that managed the housing on campus. The system ran on an Ingress database. I was a member of a team tasked with performing analysis on current automated systems to determine if they would transition to the year 2000 without interruption. The output from the analysis was a recommendation that was implemented to prepare the college applications for the change of the century.

February 1992- March 1995 Software Manager, Retired Persons Services

Provided 24x7 production support for AARP mail order pharmacy call center environment running UNIX and Oracle.

I was part of a team established to perform Business Process Re-engineering (BPR) for the mail order pharmacy business. After extensive work with an outside BPR-consultant it was determined that the best way to enforce our refined processes was to consolidate our systems and maintain one automated system rather than seven flavors of automated systems.

As a lead member of that technical team, I consolidated 7 VAX systems running VMS onto two Alpha/8400 running VMS. This centralization of data collection was the first step in the ultimate migration to UNIX running on the ALPHA cluster with an Oracle 7.2 database. Oracle Forms 4.5 and Reports 2.5 were used to create the interface that ran on the Client machines.

August 1984 - February 1992 Senior Systems Analyst, Coyne Kalajian Inc.

Starting as a junior programmer I assumed various roles here that ultimately lead to the final title of Senior Systems Analyst. The final project experience was the automation of Citibank's credit card charge-back system. This system was written in COBOL and used Host Language Interfaces(HLI) to integrate fax, imaging, expert systems, workflow routing, and relational database technologies to provide the bank with a state-of-the art (at that time) system and a six month return on investment.

Contact this candidate