Resume of Daniel Longmore

In a ten month time period, I breathed new life into the failing Integrated Library Management System, used by the Church History Department of the LDS Church.

Skills: Initiative • Teamwork • Influential Communication • Decision Making • Analysis and Troubleshooting • Programming.

Accomplishments:

• Established a trust with customer through quality in workmanship and integrity of delivering on time
• Eliminated problems with server crashing frequently by correcting application server configuration issues.
• Enhanced the libraries circulation features, allowing a much finer granularity of tracking materials.

Developing of new enhancements and maintaining existing modules within the current Health Care Management Application.

Enhancements included:

• Integration with new Case Work System • Archival of data

Tools used:

• Oracle Designer: to generate ERD, tables, table triggers, packages, and forms • Oracle 10g database • Oracle Reports • Oracle SQL Developer: used to edit and run SQL

As a member of the Store 4.0 team, I was involved with the next generation development project of their existing Self Storage Management Application. I was specifically assigned to develop the business logic associated with the rental transactions. These transactions included: discounts, waives, assessments, reversals and more. These PL/SQL packages were being called by a VB frontend application, and utilized Oracle 10g pipelined table functions to return the results.

Converted and refactored an already existing application code base for Georgia State Health Department. The code baseline originated from an earlier implementation at Utah States Health Department. The scope of the conversion project involved 100+ tables, 50+packages, 50+ complex forms. Tools involved were Oracle Designer used to generate the database, tables, packages as well as the forms. Oracle reports were used to create reports. Conversion process took us 11 months. Continued to maintain and support the production system throughout the next 9 months.

Directed and mentored development team in India. Provide design, development and support for enhancements/fixes to Retailnet Order Management System. Enhancements included (GECS Credit, Customer Pricing, Incentive Compensation, Major rework of tendering codebase).

Created custom extension to Order Entry module of Oracle E-Business Suite.

I developed a reliable and fast "job search and matching" API service. This API was one of key components of the project. The technologies applied were as follows: PL/SQL and "meta-data search terms" were used to dynamically build SQL queries which were then used to populate an Oracle global temp table where final output was returned. In addition to this I also managed the conversion of legacy data during implementation. This included the following: merging of multiple sources of data, scheduling and coordination of long jobs, tuning of scripts. I also provided training and mentoring on SQL,PL/SQL, Forms and Reports.

I designed and developed a custom WIP transaction extension to Oracle Application. This significantly improved the efficiency and accuracy of the process. The previous processes involved navigating to six separate screens in most cases entering redundant data for each transaction. The new process was a single screen which defaulted most data and allowed several transactions to be entered in one batch. Improved forecast data input process including, use of excel spreadsheet for data input, SQL scripts to import the spreadsheet data. Also provided many support and maintenance related fixes to reports and forms in the Oracle E-Business Suite.