Research Management Constultants Inc. is a verteran run small business that contracts with the Office of Personnel Management (OPM) to support the data and reporting needs across all government agencies using their USA Jobs and USA staffing websites. • ETL(SSIS) and SQL query development and performance optimization• Supporting and troubleshooting SSIS packages• Power BI procurement, implementation and Development• Data Modeling• DAX formula writing • Training and… Show more Research Management Constultants Inc. is a verteran run small business that contracts with the Office of Personnel Management (OPM) to support the data and reporting needs across all government agencies using their USA Jobs and USA staffing websites. • ETL(SSIS) and SQL query development and performance optimization• Supporting and troubleshooting SSIS packages• Power BI procurement, implementation and Development• Data Modeling• DAX formula writing • Training and supporting coworkers in Power BI• Supervising ETL Development team• Review and approve timesheets• Annual performance reviews• Training and mentoring team members Show less

Custom Truck One Source is a Kansas City company that sells, rents, manufactures, upfits and services commercial heavy equipment.• Database tasks such as Data Architecture and SQL query development and performance optimization• Supporting and troubleshooting SSIS packages• Power BI Development• Training and supporting business users in Power BI• Report Development • Working with and obtaining requirements and objective for reports from business… Show more Custom Truck One Source is a Kansas City company that sells, rents, manufactures, upfits and services commercial heavy equipment.• Database tasks such as Data Architecture and SQL query development and performance optimization• Supporting and troubleshooting SSIS packages• Power BI Development• Training and supporting business users in Power BI• Report Development • Working with and obtaining requirements and objective for reports from business users • Creating reports with Power BI or Views to get desired data in SQL Server• Oversite of Data Warehouse team and a group of consultants tasked with creating, implementing and maintaining a new data warehouse with Kimball Star schema data marts • Includes addressing resource needs and tracking business requests for reports/data access and prioritizing those requests and slotting them into the sprints.• Perform in an Agile environment Show less

IMC is an application and database services provider for Army’s Digital Training Management System (DTMS) for services to manage training records for all army soldiers. Managing SQL Server resources for over 20TB of data and two major websites, using Microsoft SQL Server, ASP.NET and Adobe ColdFusion.• Developed, tuning and revisions of Stored Procedure, User-Defined Function (UDF) and Triggers• Performance tuning reducing many queries down from 30+ seconds to under one second•… Show more IMC is an application and database services provider for Army’s Digital Training Management System (DTMS) for services to manage training records for all army soldiers. Managing SQL Server resources for over 20TB of data and two major websites, using Microsoft SQL Server, ASP.NET and Adobe ColdFusion.• Developed, tuning and revisions of Stored Procedure, User-Defined Function (UDF) and Triggers• Performance tuning reducing many queries down from 30+ seconds to under one second• Created and modified SSIS (ETL) packages for data migration and maintenance of over 1,000 tables• Performed in an Agile environment Show less

End Point is the sole provider of a Google project known as the Liquid Galaxy, a high end display system for Google Earth.Responsibilities included:• SQL Server queries, stored procedures, reports• Pioneering and implementing system testing procedures• Remote IT support for Liquid Galaxy system including after hours on call• Documentation of testing procedures• Content creating and troubleshooting• Product quality assurance include final requirements sign… Show more End Point is the sole provider of a Google project known as the Liquid Galaxy, a high end display system for Google Earth.Responsibilities included:• SQL Server queries, stored procedures, reports• Pioneering and implementing system testing procedures• Remote IT support for Liquid Galaxy system including after hours on call• Documentation of testing procedures• Content creating and troubleshooting• Product quality assurance include final requirements sign off• Building and servicing Liquid Galaxy systems Show less