• Provide project based and ongoing vCTO and Systems Architect support for small businesses and non-profits allowing for highly focused IT spend to maximize limited budgets. • Design, implement, and administer Microsoft 365 platform including Exchange migration, SharePoint, OneDrive, Azure AD, and various Azure cloud compute and storage resources.• Design and implement comprehensive on-premise and cloud solutions customized to the current and future needs of the organization. • Lead planning, design, and implementation efforts of cloud migrations including finance and customer relationship management (CRM) platforms such as Salesforce and Blackbaud Raiser's Edge.

• Technical architect and lead for multiple Agile data and analytics engineering teams focused on a data strategy, modern data architecture, and “modern culture of data” initiative.• Responsible for definition, design, and implementation of modern data stack technical milestones including a cloud data lakehouse architecture, DataOps framework and processes, data engineering best practices, analytics engineering best practices, modern data orchestration, and data governance/observability.• Act as mentor and thought leader to colleagues by participating in solutioning and pursuit activities, developing reusable solution accelerator frameworks, and presenting on deeply technical topics such as data vault modeling, data virtualization, the future of data practitioner teams, and modern data architecture.

• Led multiple data engineering teams in design and development to enable a wide array of sales and marketing analytics. Major initiatives include dimensional data warehouse and investment fund characteristics data app back-end.• Served as enterprise data architect to partner data engineering teams within the organization regarding data strategy, best practices, and integrations.

• Designed and developed advanced ETL and ELT packages using SSIS, T-SQL, C#, and VB.NET to enhance timeliness, accuracy, and completeness of data warehouse offerings to client business stakeholders.• Performed code review of ETL and ELT designs for team members with focus on alignment to best practice architecture principles, code efficiency, and design extensibility.• Solved complex business challenges through extending data warehouse architecture to accommodate incoming data and integration needs.

• Led complete redesign effort of laboratory results product as well as electronic delivery infrastructure to revolutionize accuracy, readability, and timeliness of crucial patient data.• Served as sole team member responsible for data architecture and sustainability by performing code review to developers ensuring T-SQL efficiency, proper indexing, table partitioning, and overall structure.• Interfaced with a variety of business stakeholders to design, produce, and validate complex queries including customer profile reports, CRM data cleanup, laboratory test result client deliverables, executive KPI dashboards, and comprehensive sales commissions reports.

• Acted as senior BI team member to junior analysts and contractors, leading team efforts on small to large projects by coordinating delegation of tasks, serving as subject matter expert for complex data scenarios, supporting team members during times of resource constraint, and ensuring availability of code review for optimal data quality and query performance.

• Served as primary data expert to the organization with regard to data relationships, reporting, data availability, and analysis. Primary contact throughout end-to-end system design planning activities ensuring data integrity, deliverability, and accuracy.• Developed and continually enhanced comprehensive metrics utilizing a variety of data sources to enable informed executive decisions regarding the organization’s marketing, system planning, assistance/broker network planning, and financial activities.• Developed advanced queries to accommodate weekly, quarterly, and annual reporting and audit activities of federal and state regulatory agencies such as Centers for Medicare and Medicaid Services, Government Accountability Office, and Office of Inspector General.

• Served as business intelligence expert for both internal and client stakeholders across many data domains, utilizing IBM Cognos to design complex analytics and operational reporting. Example reporting sources include call center, Medicaid claims processing, financial claim transactions, QMS task management system, long-term data archive statistics, and time allocation and project management systems.• Designed and maintained data model frameworks using Cognos Framework Manager and multi-dimensional cube models for a wide variety of data domains to support operational and analytical requirements.• Served as data infrastructure administrator and support for both internal and external stakeholders on numerous line of business and operational platforms including IBM Cognos, SharePoint, TrackWise, IBM z/OS, IBM DB2, Microsoft SQL Server, Sybase, Oracle.

• Provided tier 2-3 technical support via phone, live chat, e‐mail, and in person for Missouri State faculty, staff, and students in addition to coordination and supervision of Help Desk operations as needed when full‐time staff were unavailable.• Developed detailed IT documentation for the campus community including numerous articles on technical subjects such as data encryption, multi‐boot image deployment environments, wireless network configuration and security, and SmoothWall NAT design and configuration as well as professional communication techniques for first tier student analysts.* Designed and managed various pilot projects including Windows Server Update Services for later deployment to the campus community, communicating detailed progress reports to superiors at monthly and milestone intervals.

* Designed, installed, configured, and maintained operation‐critical server systems running Microsoft Windows Server 2003 and services such as Exchange 2003, IIS, Active Directory, and WSUS * Designed, implemented, and troubleshot the McAfee VirusScan Enterprise server‐side package and SQL database and subsequent deployment of endpoint software to the client network * Implemented and maintained network architectures throughout the facilities utilizing 3COM, CISCO, and SonicWall networking appliances