Catherine Hintze
Lexington Park
Summary
Senior Software Engineer with a strong background in application migrations and compliance implementation, achieving a three-year Authority to Operate. Expertise in PL/SQL development and Oracle performance tuning enhances application efficiency and optimizes data architecture.
Overview
42
42
years of professional experience
Work History
Senior Software Engineer supporting DTMO/DHRA
Kaimetrix
06.2020 - Current
- Led team of developers in converting cold fusion applications to Oracle APEX, enhancing system performance and user experience.
- Contributed to migration of Oracle database and APEX applications to Oracle cloud, facilitating improved scalability and reliability.
- Identified bottlenecks and resolved performance issues as developer lead, optimizing application efficiency and response times.
- Lead the team in implementation of Stig requirements to obtain a three year Authority to Operate
- Worked with ArcSight to implement offsite storage of all transactions
- Automatic workload repository(AWR) is used to assist with optimization.
- Efficiency percentages, top sql statements and wait events to identify performance issues.
- Additional statistics and recommendations to optimize the Oracle environment.
- Explain plan is used to assist in sql statement tuning.
Team lead supporting NAWCAD Comptroller
GDIT
07.2015 - Current
- Managed interface between Comptroller systems and NavyERP system of record to ensure data integrity.
- Executed interfaces using sqlldr and stored procedures to streamline data processing.
- Wrote Comptroller applications using Oracle Forms 11g and APEX 5.0.
- Utilized Oracle 11.2.4 for the backend database.
- Supported Fuel Farm operations and facilitated interface between fuel tracking software and Comptroller systems.
Oracle developer
Aurotech Inc
07.2012 - 07.2015
- Designed and optimized Oracle database structures for improved performance.
- Utilized Oracle 11g for backend data repository and AtTask for user interface, supporting seamless project management operations.
- Developed complex SQL queries for data extraction and reporting.
- Developed solutions for FDA data integration between legacy systems and collaborative project management tool for CDER, enhancing data accessibility and workflow efficiency.
- Collaborated with cross-functional teams to define project requirements.
Oracle Analyst
Infojini
08.2011 - 03.2012
- As an Oracle Analyst for Infojini I supported the Maryland State Highway Administration(SHA).
- Sole resource for data conversion and integration into SHA centralized database for asset inventory and management.
- I used ARCGIS to re-project the x and y coordinate system received to the standard coordinate system used by SHA.
- Maintained data structures and managed user access for the asset database.
- Documented and organized PL/SQL scripts to streamline data import processes.
Operations Analyst
Tsymmetry Inc.
01.2010 - 03.2010
- Assisted Department of Homeland Security's Smart Border Alliance (SBA) team in operations analysis.
- Maintained production environment for air, land, and sea entry points into the United States, ensuring seamless operations.
- Processed data in various formats, including comma-delimited files, spreadsheets, and databases like MS Access and SQL Server.
- Received files through FTP sites, database links, and various forms of electronic media.
- Developed PL/SQL scripts for data cleanup from our various customers.
- Also developed PL/SQL scripts for batch processing from consulates around the world.
Sr Database Analyst
Booz Allan Hamilton
04.2009 - 06.2009
- Handled enhancements and maintenance of existing functionality, performance tuning of SQL statements, and made recommendations to the DBA staff for structural changes to improve end-user performance.
- Led maintenance efforts on Logistics system for SCR, ensuring system reliability and performance.
- The application was developed using Oracle Forms which contain triggers written in PL/SQL and various stored procedures written in PL/SQL.
- The system used Oracle 10g in a UNIX environment for the backend.
- Prepared documentation for migration to 11i and coordinated with team members.
- 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.
Sr Analyst
Indus Corporation
10.2008 - 02.2009
- Maintained financial system for Department of Transportation, ensuring accurate tracking and monitoring of funds allocated for road and bridge maintenance.
- Developed Oracle Forms with triggers written in PL/SQL for the front end and utilized Oracle Reports to meet reporting requirements.
- Utilized Oracle 9i and 10g for backend operations in UNIX environment, supporting system functionality.
- Analyzed discrepancies in reports during conversion from SQR to Oracle Reports, enhancing data accuracy.
Developer
Sabre Systems
04.2008 - 07.2008
- Developed application using Oracle Forms and Reports for front end, 10g for backend in UNIX environment.
- Implemented triggers in PL/SQL for both forms and reports to streamline data processing.
- Enhanced financial tracking system for Navy, improving accuracy in funding and maintenance tracking for fleet operations.
- Toad was used as the analysis tool of preference.
Analyst
Synergy Software Design
11.2007 - 02.2008
- Developed web application for Navy Facilities Engineering to capture information for mission dependency index, influencing budget funding distribution.
- 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.
- Analyzed source data to normalize it and enhanced storage scheme to maintain data integrity, eliminate redundancy, and support efficient relational model.
Consultant
Tek Systems
10.2006 - 02.2007
- Consulted for Calvert Cliffs Nuclear Power Plant (CCNPP) by maintaining applications using Oracle Forms and Reports 9i with Oracle 9i backend, ensuring operational continuity.
- Recreated a Windows 95 server using Visual Basic 4.0 to interface CCNPP applications with a remote work management application, addressing critical system vulnerabilities.
- Addressed a vulnerable situation with no backup server and absence of original developers, enhancing system reliability and security.
- Forms and reports contained many triggers as well PL/SQL libraries and stored procedures which were all written in PL/SQL.
- Tasking was completed prior to my departure in February 2007.
- ERWIN was the entity diagramming tool used.
Senior Software Engineer
BAE Systems
11.2004 - 12.2005
- 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.
- Executed backend development utilizing SQL, PLSQL, and UNIX scripting to create new scripts and enhance existing ones.
- Managed data storage in Oracle 9i, optimizing database performance while reengineering poorly designed tables.
- 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.
- Collaborated with a team on a critical project under tight deadlines, applying HTML, ColdFusion, SQL, and SQLPlus skills to ensure timely delivery.
Senior Software Engineer
Information Spectrum Incorporated
03.2000 - 10.2004
- 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.
- Designed, developed, tested, and implemented the NAVAIR Applications Repository (NAR 2.0) as the front end for the database.
- Utilized ORACLE 9i for database management, Designer 4.4 for design, and developed application with JAVA, HTML, Cold Fusion, Oracle Forms/Reports 6i, PL/SQL, and SQL.
- Mapped data from legacy databases to Oracle 9i Data Warehouse, ensuring accuracy and accessibility of information.
- 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.
- Executed database queries to support local authorities in retrieving critical information efficiently.
- 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 received an 'Excellence in Customer Service' award for my efforts on that project.
- All applications were housed on Sun Solaris running UNIX.
Software Manager
BAE Systems Inc
05.1997 - 03.2000
- 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 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.
Consultant
St. Mary's College
04.1995 - 05.1997
- I assisted in the development of a database support system that managed the housing on campus.
- The system ran on an Ingress database.
- Contributed to a team that analyzed current automated systems to determine their 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.
Software Manager
Retired Persons Services
02.1992 - 03.1995
- Provided 24x7 production support for AARP mail order pharmacy call center environment running UNIX and Oracle.
- Collaborated with team to conduct business process re-engineering (BPR) for mail order pharmacy operations, enhancing efficiency and service delivery.
- 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.
- Led technical team in consolidating 7 VAX systems running VMS into two Alpha/8400 systems, streamlining system management and support.
- Centralized data collection as initial step towards migration to UNIX on ALPHA cluster with Oracle 7.2 database, improving data accessibility and integrity.
- Oracle Forms 4.5 and Reports 2.5 were used to create the interface that ran on the Client machines.
Senior Systems Analyst
Coyne Kalajian Inc.
08.1984 - 02.1992
- Progressed from junior programmer to Senior Systems Analyst, gaining comprehensive experience in system development and analysis.
- Automated Citibank's credit card chargeback system, streamlining processing and improving turnaround times.
- Developed system in COBOL, leveraging Host Language Interfaces (HLI) to seamlessly integrate multiple technologies.
Skills
- PL/SQL Development
- PL/SQL Tuning
- Oracle Performance Tuning
- Oracle Data Architecture
- SQL Server
- API Integration
- Database Management
- Automation Scripting
- Shell Scripting
- Cloud Computing
- DevOps Practices
- Agile Methodologies
- Security Best Practices
- Accessibility Standards
- Collaboration Tools
- Project
- Excel
- Word
Timeline
Senior Software Engineer supporting DTMO/DHRA
Kaimetrix
06.2020 - Current
Team lead supporting NAWCAD Comptroller
GDIT
07.2015 - Current
Oracle developer
Aurotech Inc
07.2012 - 07.2015
Oracle Analyst
Infojini
08.2011 - 03.2012
Operations Analyst
Tsymmetry Inc.
01.2010 - 03.2010
Sr Database Analyst
Booz Allan Hamilton
04.2009 - 06.2009
Sr Analyst
Indus Corporation
10.2008 - 02.2009
Developer
Sabre Systems
04.2008 - 07.2008
Analyst
Synergy Software Design
11.2007 - 02.2008
Consultant
Tek Systems
10.2006 - 02.2007
Senior Software Engineer
BAE Systems
11.2004 - 12.2005
Senior Software Engineer
Information Spectrum Incorporated
03.2000 - 10.2004
Software Manager
BAE Systems Inc
05.1997 - 03.2000
Consultant
St. Mary's College
04.1995 - 05.1997
Software Manager
Retired Persons Services
02.1992 - 03.1995
Senior Systems Analyst
Coyne Kalajian Inc.
08.1984 - 02.1992