Connecting engineering, field, customers and technology to bring better health experiences to everyone. Focusing on FHIR, Internet of Medical Things (IoMT) and the Microsoft Cloud Platform.

- Generated complex weighted aggregations using custom MDX inside SSAS Multidimensional model - Performance tuned data warehouse, ETL, and SSAS partitions to reduce nightly processes - Trained Report Analysts on building visualizations in Performance Point and Power View- Created Dimensions which include spatial data for mapping client’s assets and areas of impact- Constructed a SQL 2008 R2 to SQL 2014 data warehouse and ETL migration- Planned a relatively real-time data warehouse using SQL 2014 In-Memory technology- Assisted with SharePoint 2013 implementations- Acting Senior Database Architect while client is on leave- Architected SSAS Multidimensional Model on top of DB2 data warehouse- Gather project requirements, produce weekly status reports, and maintain client communication- Established SSAS Tabular and Power Pivot models each with ragged hierarchies using DAX- Designed and implemented data warehouses using Kimball methodology- Explored self-service BI modeling using Power Query, Power Pivot, and Power View in Excel 2013 - Project Lead for multiple clients

- Designed and implemented SQL Server maintenance plans to back-up & re-index databases on instances of SQL Server 2008 R2 and 2012.- Wrote T-SQL scripts and stored procedures for various conversion, maintenance, and reporting tasks; including, database creation, system optimization, and troubleshooting operations.- Developed C# custom scripts within SSIS - Architected databases for hosting data warehouses and conversion systems.- Created SSIS packages for loading metadata into data warehouses for reporting and metadata conversions.- Reverse engineered customer databases on SQL Server, Oracle, DB2, and Non-Stop SQL platforms for conversion to the OnBase Software SQL Server or Oracle platform. - Maintained the team’s five VMWare ESXi environments.- Spoke at Hyland’s annual OTTC Conference on Conversion Project Methodology.

- Oversaw SQL Server 2005 database operations for outsourcing clients by reviewing, documenting, and implementing schema changes, refreshing databases and simulating “go-live” situations.- Problem solved clients’ ETL mapping, reporting, and integrations requests.- Monitored scheduled jobs, report any errors to appropriate teammates and/or clients as needed, troubleshoot and restart system after scheduled job failure or partial completion.- Analyzed clients’ data staging environments for improvements and tune system as needed to insure optimum performance and data quality.- Migrated staging table databases from SQL Server 2005 test instances to SQL Server 2008 production instances.

- Defined and implemented automated performance, maintenance, and backup plans for SQL Server. - Wrote complex queries for a reporting program for Stark Area Regional Transit Authority that tracks customer policy violations.- Established infrastructure and network for orthodontic manufacturer, configuration included: Terminal Services, Thin Clients, Remote Access, and SQL/ QuickBooks integration via 3rd party software. - Identify and recommend hardware and software in order to meet business requirements.- Wrote custom reports and dashboards for customer profitability and cost analysis.- Maintained continuous communication with customers during planning, installation, training, and closing phases of each project.

Rewrote Queries from VQL to UQL for new search system.Tested portals and customer website upgrades