Robert MacKinnon

720-***-**** adksa8@r.postjobfree.com

Business Intelligence/SQL/ETL/Report Developer. Strong analytical and problem resolution skills. Legal background with strong writing skills. Licensed attorney in Colorado. Mainframe skills include COBOL, JCL, and IBM Assembler (BAL).

OBJECTIVE

Seeking opportunities as a database and business intelligence developer to maintain the integrity of data sources and methods and using best practices to deliver accurate, timely results to decision makers that contribute to the success of the organization.

EDUCATION

Juris Doctor University of Denver, Sturm College of Law, Denver, CO

Bachelor of Science, Management Metropolitan State College, Denver, CO

Associates of Science, Data Processing Community College of Denver, Denver, CO

PROFESSIONAL EXPERIENCE

Database/Business Intelligence Developer

Innovage (Talent Navigation Experts), Greenwood Village, CO 9/1/2020 to 11/30/2020

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.

Database/Business Intelligence Developer

Global Employment Solutions, Lone Tree, CO 8/1/2018 to 3/28/2020

Nationwide staffing firm. Brands include Fahrenheit IT.

Developed complex new ad-hoc reports for Staffsuite application using Oracle PL-SQL, Reporting Views, and Crystal Reports.

Created and developed new processes using Microsoft T-SQL and SSRS including developing SSIS packages to support the processes.

Developed stored procedures across multiple platforms using Microsoft Openquery.

Successfully improved performance of existing processes, e.g., reduced execution time from 45 minutes to 45 seconds.

Database Developer

Nurse Family Partnership, Denver, CO 2016 to 2018

Maintained and developed software solutions with legacy system, including stored procedures using complex SQL.

Business Intelligence. Modified existing code to meet changing requirements with legacy SQL Server Reporting Services (SSRS) packages.

Extract/Transform/Load (ETL). Used Pentaho tools to develop solutions to migrate data from existing SQL Server silos to Amazon Web Services Data Warehouse which used Amazon S3 and Redshift.

Training in Power BI.

SQL/SSIS Developer

Centura Health (Innovar), Englewood, CO 2015 to 2016

Contract position working with drug pricing data mart.

Created and fulfilled audit requests from customer/user using drug pricing data mart.

Developed, tested, and maintained SQL Server Queries, Views, Stored Procedures, Functions, and Triggers as needed to support business needs.

Maintained and developed SSIS packages in TFS as needed.

Database Developer

Nurse Family Partnership, Denver, CO 11/1/2016 to 7/31/202018

Maintained and developed software solutions with legacy system, including stored procedures using complex SQL.

Business Intelligence. Modified existing code to meet changing requirements with legacy SQL Server Reporting Services (SSRS) packages.

Extract/Transform/Load (ETL). Used Pentaho tools to develop solutions to migrate data from existing SQL Server silos to Amazon Web Services Data Warehouse which used Amazon S3 and Redshift.

Agile Scrum environment using Jira, Confluence, and Git tools.

Training in Power BI.

SQL/SSIS Developer

Centura Health (Innovar), Englewood, CO 7/1/2015 to 2/28/2016

Contract position working with drug pricing data mart.

Created and fulfilled audit requests from customer/user using drug pricing data mart.

Developed, tested, and maintained SQL Server Queries, Views, Stored Procedures, Functions, and Triggers as needed to support business needs.

Maintained and developed SSIS packages in TFS as needed.

Database Developer

National Entertainment Networks, Broomfield, CO 3/1/2011 to 7/31/2015

Designed, developed, tested, and maintained Queries, Views, Stored Procedures, Functions, and Triggers to support 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.

Provided timely and reliable enterprise-wide reports using Crystal Reports with SQL Server data source.

Collaborated with business units to develop precise business requirements.

Designed and built Reporting platform structure.

Extracted, Transformed, and Loaded (ETL) data as needed from diverse data sources to develop company data warehouse.

Assisted business units to identify business trends using complex logical formulas and presented that aggregate information in user-friendly formats.

Developed Dimension and Fact Tables (star schema) for company data warehouse.

Crystal Reports / Database Developer

Jones International, Centennial, CO 2009 to 2011

Designed, developed, and maintained enterprise-wide reports for diverse organizational units within a Crystal Reports environment using SQL Server, Oracle, and MySQL data sources.

Maintained 400 Crystal Enterprise reports on web-based portal. Scheduled subscriptions as needed.

Designed, developed, and maintained custom Queries, Views, Stored Procedures, and Functions in SQL Server T-SQL and Oracle PL-SQL to support report requirements.

Developed and maintained custom reports using Crystal Reports embedded in CampusVue.

Software Developer II

Frontier Airlines-Denver, CO 2002 to 2008

Designed, developed, and maintained databases in Microsoft SQL Server and Oracle (using Toad).

Developed queries, views, and stored procedures according to requirements.

Developed and maintained ETL DTS packages for SQL Server 2000.

Developed and maintained reports using SQL Server 2005 Reporting Services (SSRS).

Developed reports and other functionality utilizing SABRE QIK, a proprietary language.

Maintained existing reports and developed new reports using Crystal Reports, both on the desktop and using Crystal Enterprise, where reports were available on company WAN 24x7.

Crystal Enterprise Administrator for 400+ reports for various business units.

Proficient in troubleshooting and problem resolution of complex technical problems.

Analyzed and improved performance of existing reports.

TECHNICAL TRAINING

Frontier Airlines: Sabre QIK (proprietary language)

United Airlines: REXX (mainframe systems programmer language)

Nurse Family Partnership: Power BI (online course)

Self Taught: Data Modeling and Visualization (Power BI, Tableau), .NET, Visual C#

Contact this candidate