Robert Mackinnon Email & Phone Number

Parker, Colorado, United States

Contract opportunity working in healthcare space.Create and modify Views and Stored Procedures (T-SQL) used in Reporting Environment.Build and maintain SSRS Reports according to user requirements.Develop Custom Queries, Views and Stored Procedures to support data modeling for Tableau Reports.Convert existing SSRS reports to Tableau.Develop Custom Queries for Snowflake EDW and build Tableau Reports from queries.

Lone Tree, Colorado

Nationwide staffing firm – Brands include Fahrenheit ITDevelop complex new ad-hoc reports for Staffsuite application using Oracle PL-SQL, Reporting Views and Crystal ReportsCreate and develop new processes using Microsoft T-SQL and SSRS including developing SSIS packages to support the processes.Develop stored procedures across multiple platforms using Microsoft OpenquerySuccessfully improved performance of existing processes - e.g. reduced execution time from 45 minutes to 45 seconds

Denver, Colorado

Maintain and develop software solutions with legacy system, including stored procedures using complex SQLBusiness Intelligence -modify existing code to meet changing requirements with legacy SQL Server Reporting Services (SSRS) packagesDevelop Dimension and Fact Tables (star schema) for company Data Warehouse.Training in Power BI

Englewood, Colorado

Contract role working with drug pricing datamartCreate and fulfill audit requests from customer/userDevelop, test and maintain SQL Server Queries, Views, Stored Procedures, Functions and Triggers as needed in support of business needsMaintain/Develop SSIS packages in TFS as needed

Broomfield, Colorado

Design, develop, test and maintain Queries, Views, Stored Procedures, Functions, and Triggers in support of business requirements.Complex SQL – tables, views, temp tables, table variables, aggregation, pivots, case statements, dynamic SQL, CTEs, multiple joins.Strong data analysis and trouble shooting skills.Provide timely and reliable enterprise-wide reports using Crystal Reports with SQL Server data source.Work collaboratively with business units to develop precise business requirementsDesign and build Reporting platform structure.Extract, Transform, and Load (ETL) data as needed from diverse data sources to develop company data warehouse Assist business units in identifying business trends using complex logical formulas and presenting that aggregate information in user-friendly formats.Develop Dimension and Fact Tables (star schema) for company Data Warehouse.