Consultant
Current● Clients have included Healthcare, Life Reinsurance & W/C, Wholesale, Retail & Logistics - Auto Parts, Flooring, Trucking, Airline Reservations, Marketing & Sales, and Container Rental ● SQL Server - Ad-Hoc Queries, Procedures (static & dynamic), Functions, Views, Table & Index Design, Performance, Profiling, CTE & Cursor● VB (VBA & VB6) Complete VB6 IDE for Legacy Applications with LARGE collection of licensed 3rd party controls. Excel, Access & Office Applications VBA ● Change Management - Stakeholders, Requirements Elicitation, Test Case Development, UAT Testing, User Acceptance and Transition ◘ City & Premium Services ◘ XLS Export Functions ◘ XLS Import Functions ◘ User Security Clearance Groups ◘ User Security Assignment ◘ Various User Requested Application Enhancements (~2-3 monthly..) ◘ Report Design, Testing, Validation, Deployment ◘ ETL Process design & creation based on supplier of data, source format and target format & validation. ◘ Working within established guidelines & regulations, design, build and employ both a mobile foodservice soft-serve truck and a "brick-and-mortar" soft-serve restaurant. ◘ Working with POS system export/import capabilities and self-designed costing sheets can update item purchase price which updates a per item sales cost for accurate COGS ● Release Level user documentation and training guide for changes and enhancements - Atlassian Confluence, MS-Word & PDF● ADO Agile practitioner. [:Scrums, Sprints, Sprint Demo, Sprint Retro, Backlog Refinement, Planning & Repeat:] ● Source Control - Git, Sourcetree, Subversion, TFS, SourceSafe● Accounting Systems Interfaces - QuickBooks / Peachtree Quantum/ Sage 300 Accounting System Interface applications programming for various data import processes.● Risk Analysis / Business Continuity / Infrastructure Hardening / Physical Security for various clients