Developer of BI solutions using Star Schema Data Warehouse using SQL and Visual Studio 2019. Developer of Extract solutions for inbound and outbound data including formatted Excel reports, basic test CSVs, XML, and REST API POST transfers. Bank Officer. Department lead on disaster recovery plan. Critical systems first line of support for weekends and holidays. Reporting support for secured internal systems such as Intranet, HR, and finance systems.

Fidelity Bank became part of Ameris Bank. Description above.

• Developed a complete SQL Server star-schema data warehouse solution covering up to 5 modules from the underlying ERP system(s) with no intra-module dependencies. Worked directly with department heads to design business requirements that enhanced the available ERP functionality. Architected the technical design to handle multiple ERP solutions distributed across divisions/companies into a single data warehouse. Created a “quick install” method for customer demos limiting the load of the data warehouse. • Researched and repaired calculation errors and gross inefficiencies in legacy code. Eliminated redundant information in staging process. Replaced multiple function calls per row in queries with staged data tables for reduced overhead. Eliminated unnecessary procedures and reduced function calls. Ensured unique primary keys in all permanent storage tables.• Automated the nightly batch for updating the data warehouse. Reduced runtime of the updates with performance tuning depending on customer size and modules chosen. Improved the efficiency and accuracy of the update and insert statements to maintain perm and fact tables. Implemented a modular design to updates which accommodates future development and onsite customizations. • Upgraded the existing financials package to multi-national enterprise financials, replicated the ERP algorithms for payment-to-invoice matching and currency exchange by date and tier• Developed software verification (pre-build.sql) that checked SQL stored procedures and Wherescape settings for known issues and non-standard coding practices to ensure the checked-in code was ready for final QA. Created many department standards for coding and maintenance of software.

www.csmglobal.com• Full Life Cycle development of several Database/Web applications providing work flow, automation, reporting, and request management applications for most back-office departments including R&D, Pricing, Cost Accounting, Sales, Quality Control, Master Data Management, and CIS.• Invented reporting application that flexibly allowed end users to select over 100 dimensions of sales or production reporting in any combination and then automatically construct the smallest SQL query possible to get only the requested data across the network and into Excel.• Key member of implementation team for new ERP, learning several new technologies and providing training for users and developers alike and also insuring data integrity and programming bridges to maintain functionality for ancillary systems.• Built Data transfer from ERP to SQL Reporting Warehouse, FTP Sites, Excel Templates minimizing overhead while maintaining integrity of the data.• Provided global Tech Support on ERP operations, in-house developed systems as well as Microsoft software and Windows OS consulting with colleagues from Amsterdam to Utah• Provided Process Analysis, Financial Analysis, and Statistical Analysis directly for company executives.• Developed standards and coded templates for MS Excel tools and reports that utilized VB automation to error check criteria, provide smart lists of drop down options, and format results with logos that could be presented to customers and vendors.• Managed Intranet Web Site Content including building small applications designed to show lists of documents so departments could maintain their own web content

Developed Access Database solution for Contact Management

www.cooperlighting.com• Full Life Cycle development of MS Access automation application for customer relation management to fax and email customers and agents and make logical decisions on workflow. Eliminated 70% of human intervention with basic Post Sales Customer Service and Returns to free up workforce for customer interactions.• Designed and implemented warehouse pick ticket system increasing order fill rate by 20%.• Interfaced in-house applications with ERP to automatically process returns, warranty claims, credits and debits within automation tolerances, sales invoice research, and partner contact information.• Subject Matter Expert on implementation team for new ERP, ensuring all my built automations could function on either data set and participated in the creation of test scenarios and performance measures prior to implementation.• Ad-hoc querying, Training, and Tech Support on in-house systems and Microsoft software.

www.ngumc.org/churches/detail/2102Managed website content and design.Coordinated volunteers and content providers.Supported in-office network and PC maintenance

assuranceamerica.comDesigned and coded premium quoting software.Designed and coded analysis system to show plain-English method of calculating premium step by step with related customer profile options that drive figures.Designed and coded research tools to assist in claims history, payment history, multiple policies, cancellation/rewrite, and multiple payment methods for billing.

www.franke.comDesigned and coded custom cycle count inventory program for RF handheld devices.Designed and coded custom analysis reports for data discrepancies.

www.mccamish.comWrote custom financial reporting toolsExtracting data from ERP into Access database for graphing and paginated reportCreated GUI user interfaces for financial transaction applications

www.verizonbusiness.com/medium• Designed and Coded custom call center application with in-house and Internet interfaces to grant premium customers additional information and options.• Wrote financial reports for GP, AP, AR, Purchasing, inventory, payroll • Designed batch processed aggregate reporting tables for efficiency.• Provided nationwide PC tech support

www.success-systems.comDesigned and Coded improved EDI mapping program - Cut processing time from 3 hours to 10 minutes, a 94% reduction in runtime.Developed custom forms for orders and invoices per customer specificationsProvided nation-wide support for software product and UNIX administration