Frank Harper Email & Phone Number

Lehi, Utah, US

Pleasant Grove, Utah, US

Draper, Utah, US

• Became a Subject Matter Expert in Product/Systems Integrations and Functionality
• Developed various ETL scripts to pull from multiple diverse data platforms
• Wrote various reports that were used to direct efforts of multiple departments
• Wrote monitoring scripts for various processes
• Performed statistical analysis of Television and Software behavior
• Discovered multiple hidden and unexpected behaviors for both internal and 3rd party dataproviders

Midvale, UT, US

Investigate, install and develop proof of concept against various Database Platforms including Cassandra, Mongo, and Redis.Design and implement Data models from conceptual to physical modeling for extensibility and scalability. Design and code continuous "real time" ETL streams to integrate various OLTP systems.Architect restful micro-services including.

Midvale, UT, US

My team maintains 99.999% uptime on our production database supporting one of the largest online retail websitesI lead all efforts in tightening database security --Researching Oracle and 3rd party security software --Planning Database security initiatives and roadmaps --Acting as a liaison to the IT security team --Suggesting improvements to database.

Salt Lake City, UT, US

• Administered 50+ Databases most of which were 1+ TB in size. Oracle versions included 10g and 11g
• Lead a small team of Senior Database engineers supporting two global banking systems 24/7.
• Implemented GIT as a documentation and script version control for database team.
• Trained 35+ ICS engineers in SQL Tuning and Explain Plans.
• Presented in an organization wide database security conference.
• Upgraded multiple 10g RAC databases to 11g.

• Facilitated more than $150,000 custom-orders revenue monthly by finding requested parts, estimating landed cost, ordering materials, and communicating delivery information.
• Helped make possible $320,000 annual sales to referred customers by resolving problems with customer’s orders & deliveries to maintain high referral rate and customer retention.
• Added value to customer experience and saved $6,000-$15,000 monthly opportunity cost per salesman by adding weight field to inventory module and by appending invoice-template to calculate line item and total order.
• Saved $2,000 monthly purchasing time by creating purchasing focus queries & reports and by creating/updating po# macros in Excel. Reports include: Cut-Stock, Stock-Check, Warehouse Receiving, Under-Stock, and Min/Max.
• Saved accounting department more than $750 per month by creating custom reports, by advising in Cougar Mountain (ERP) upgrade, and by creating a system of backup up tables to allow data retention when module history.
• Reduced sales errors and GP loss by implementing Bar-Coding process & equipment.