Brian Kusie

Summary

Brian has over ** years of experience with Microsoft SQL and Azure Databases including both database development and administration work. He has extensive experience with developing stored procedures, writing queries, and maintaining data integrations. He also has report development experience with SSRS. Brian is experienced with database administration tasks including database design, configuration and tuning with both on premise and cloud environments. Experience Synopsis

• Over 21 years of experience with SQL Databases, 2 years with Azure.

• 1 year experience working with Snowflake database and Matillion ETL programs in an Azure environment

• Extensive database development experience including stored procedure and query development work

• SQL Database administration experience including configuration and tuning

• SSRS reporting experience

Professional Experience

Performance Systems Integration February 2023 – March 2023 Senior Database Consultant/Project Manager

• Review current needs of client regarding conversion of manually generated spreadsheet reports into an automated BI reporting environment.

• Research options for future system and present all options to development group to attain consensus for system architecture.

• Create roadmap and timeline for project to include deliverables, potential hurdles, and critical decision points.

• Create database architecture documents, create data warehouse/data mart environment, provide guidance for ancillary concerns regarding security, availability, and cost. True Blue August 2022 – February 2023

Senior Database Consultant

• Re-engineer existing SSIS packages to replace existing MSSQL connections with new MySql connections.

• Resolve conflicts which arose from shifting to MySql environment for temporary data storage.

• Identify roadblocks inherent in new ETL environment and establish standards for functionality and development

• Document structure of existing database

Cherry Aerospace February 2022 – August 2022

Senior Database Consultant

• Reverse engineer existing 25 year old Progress database and associated functionality.

• Document structure of existing database

• Analyze existing data and associated functionality to determine source/cause of disappearance of $413,000.

• Engineer process to move data/structure of existing Progress database with 530 tables to new SQL database while retaining structure and functionality so that both databases can run in parallel.

Brian Kusie

Dairy Queen March 2021 – February 2022

Senior Database Consultant

• Reverse engineer existing stored procedures to ensure correct processing of incoming data integrity.

• Developed Stored Procedures for data access layer in SQL 2019

• Supported daily operation of existing client-facing product.

• Reviewed existing Database structure and scheduled ETL functions and recommend solutions for optimization.

• Promoted projects via TFS.

• Optimized existing stored procedures and resolve data inconsistency issues. Ecolab April 2020 – August 2020

Senior Database Consultant

• Identified and resolve data integrity issues in existing Azure databases.

• Optimized existing Azure based system and design for future functionality.

• Developed Stored Procedures for data access layer in SQL 2017.

• Maintained existing reports and data flows, and creating new ones, in PowerBI.

• Performed data forensics to identify integrity issues and develop solutions.

• Maintained solutions in TFS environment.

• Supported daily operation of existing client-facing product. 3M August 2019 – August 2020

Senior Database Consultant

• Maintained existing Azure databases and facilitated move from on-premises SWL databases to new Azure databases.

• Identified and resolved data integrity issues in existing Azure databases.

• Optimized existing Azure based system and design for future functionality.

• Reviewed/analyzed existing ETL packages to determine logic for future replacement development and to identify errors in current process.

• Reconfigured existing reports and generating new dataflows, reports, and schedules in PowerBI for accounting team.

• Supported daily operation of existing client-facing product. Robert Half March 2019 – August 2019

Senior Database Consultant

• Transferred on-premises SQL data to Azure databases and verified data integrity after transfer.

• Designed and developed new ETL/ELT processes for critical daily reporting and data ingestion. Snowflake (database) and Matillion (ELT) were used to develop these.

• Generated / designed stored procedures and TSQL scripts to gather data sets for transformation to data mart.

• Reviewed / analyzed existing ETL packages to determine logic for future replacement development and to identify errors in current process.

• Performed extensive QA on new results to identify anomalies in data and devise better logic to resolve these issues.

• Participated in governance process via daily Scrum/Standup meetings and bi-weekly Sprint reviews/planning.

Brian Kusie

Robert Half December 2018 – March 2019

Senior Database Consultant

• Reverse engineer existing SSIS packages and stored procedures to ensure correct processing of incoming data integrity.

• Reviewed existing Database structure and scheduled ETL functions and recommend solutions for optimization.

• Promoted projects via TFS.

• Developed new project for monitoring commission structure and performance of sales team members. Project included ETL, stored procedures, database architecture, and reporting functionality.

• Optimized existing SSIS packages/stored procedures and resolve data inconsistency issues. One existing package had been running for 6 hours daily, and work on this package resulted in a run time of under 10 minutes with full transfer of all record. Sunrise Banks May 2018 – December 2018

Database Development Manager

• Reverse engineer existing SSIS packages/stored procedures to ensure correct processing of incoming data integrity.

• Reconfigured existing reports and generating new dataflows, reports, and schedules in PowerBI.

• Produced both Ad Hoc and scheduled/recurring reports to aid client in critical financial metrics

• Maintained and administered daily data processing functions to ensure functionality and identify data corruption.

• Designed and created process SSIS packages and stored procedures) to integrate data from new system, map data, schedule data import jobs, and document entire project.

• Reviewed existing Database structure and scheduled ETL functions and recommend solutions for optimization.

• Promoted projects via TFS.

• Managed 2 direct report resources.

• Planned for future team development and added functionality of newly adopted programs. Bluestem Brands August 2017 – February 2018

Senior Database Consultant

• Analyzed data, create error handling logic, and resolve ETL issues. Scheduled SSIS packages then pulled data from Data Marts into relative reports via SSRS for distribution. Snowflake Schema was used.

• Set/control timing of scheduled data load to ensure hierarchical integrity.

• Produced both Ad Hoc and scheduled/recurring reports to aid client in critical financial metrics

• Maintained and administered daily data processing functions to ensure functionality and identify data corruption.

• Designed and created process to integrate data from new system, map data, schedule data import jobs, and document entire project.

• Reverse engineer Hadoop functionality to produce identical functionality in MS SQL-based ETL jobs and Reports.

• Reviewed existing Database structure and scheduled ETL functions and recommend solutions for optimization.

• Promoted projects via GIT and TFS.

• Significantly reduced runtimes for multiple data loads via optimization and restructuring of processes. This typically reduced runtimes from > 1 hour to < 5 minutes. Brian Kusie

Hallmark October 2016 – August 2017

Senior Database Consultant

• Analyzed data, create error handling logic, and resolve ETL (SSIS) issues for critical client. ETL processes/stored procedures were used to pull data from client flat files into Data Warehouse, then separate scheduled jobs pushed data to singular client data mart. Scheduled and ad hoc SSIS packages then pulled data from Data Mart into relative reports via SSRS for distribution.

• Acted as Liaison between company and client data supervisor to identify and resolve discrepancies with incoming data.

• Analyzed data, create error handling logic, and resolve ETL (SSIS) issues for critical client.

• Acted as Liaison between company and client data supervisor to identify and resolve discrepancies with incoming data.

• Designed and created process to integrate data from new client system, map data, schedule data import jobs, and document entire project.

• Identified conflicts with existing and proposed business logic and provide resolution logic.

• Maintained and administered daily data processing functions. Identify and troubleshoot failures and mitigate any data corruption issues.

• Reviewed existing Database structure and scheduled ETL functions and recommend solutions for optimization.

• Performed data cleansing and merging for existing errant/redundant data. ABRA Autobody August 2015 – September 2016

Database Manager

• Managed 3 direct-report developers/DBAs

• Data was pushed to main corporate server Data Warehouse via replication from individual stores. Data was then distributed via scheduled SSIS packages to financial data mart for report distribution via SSRS and dashboards via Dundas BI. Snowflake schema was used, and data was well normalized.

• Set up multiple SQL 2016 High-Availability clusters.

• Reverse-engineered legacy reports, ETL processes/stored procedures, and functions for migration to new system.

• Created, administered, and optimized dashboards (Dundas BI platform) and scheduled reports

(SSRS platform) for financial department end users.

• Implemented documentation standards for ETL processes and database structures. Allianz March 2014 – August 2015

Senior Consultant

• Reverse engineer and document ongoing database conversion and update projects.

• Created functionality for integration of existing data and functionality into new system.

• Identified data processing conflicts and recommend scalable solutions. Brian Kusie

Bluestem Brands July 2013 – March 2014

Senior BI Consultant

• Reverse engineered, restructured, and documented large financial reporting tool.

• Reduced runtime from 3 hours to less than 20 minutes for financial reporting data load.

• Increased reliability of data significantly while moving reporting system from SQL Server databases to Netezza database.

• Created and maintained all documentation for financial reporting project. Various Clients July 2011 – June 2013

Senior Consultant

Client: Polaris Industries

• Converted SQL2000 DTS packages/stored procedures to SQL2008R2 SSIS packages.

• Implemented new software and process for documentation of SSIS/ETL packages.

• Developed multiple SSIS packages for adding new reporting functionality (primarily for Australian market) via SSRS.

• Improved or completed existing SSIS packages that were either incomplete or lacking the full functionality that the end user desired.

Client: Patterson Dental

• Performed backup/restore functions for company databases.

• Managed security profiles for all SQL databases.

• Promoted development projects through database environment tiers (Dev, QA, UAT, and Production).

• Ensured high availability of all database servers. Client: Green Tree Financial Services

• Resolved issues in SSIS with current system which prevented automated functionality in reporting system.

• Identified security and standardization issues with current ticketing system and related escalation procedures and implemented solutions.

• Resolved/processed ad-hoc functionality requests from BI team.

• Provided solutions for documentation and standardization needs. Client: Bluestem Brands

• Analyzed current process structure for online retail business to identify inefficiencies that were preventing high-volume functionality and reliability.

• Identified several coding practice issues and non-ideal environment settings and formulated a resolution plan for client.

• Supervised issue resolution process via in-house development team. Result was full functionality and reliability during highest revenue sales day in company history. Brian Kusie

Lacek Group, OMG May 2009 – July 2011

Database Engineer

• Produced automated auditing processes to allow quality assurance testing by business entity.

• Created and adjusted multiple monthly email campaign data production processes.

• Wrote ETL SSIS package/stored procedures for processing daily data feeds which has been in use for last 3 years. No data warehousing was used, and data was not normalized.

• Designed and configured new system in SQL 2008 R2 to house improved data system. Defined all continuity, maintenance, and optimization facets for this database.

• Migrated database/SSIS packages to SQL 2008 R2.

Education

Juris Doctorate (in progress) 2021 – Present

Mitchell Hamline School of Law

Bachelor of Science – Computer Science 1999 – 2002 Metropolitan State University

Skills

Programming Languages & Technologies: ASP.NET, ASP Classic, ADO Microsoft Visual Studio.Net suite Visual Basic, VB.Net, Visual C++

Visual C#, and Visual J#, Java, JavaScript

Databases: Azure, SQL Server 2000, SQL Server 2005, SQL Server 2008/R2, SQL Server 2016-2019, MS

Access

Industry Experience: Financial/Mortgage, Fuel Sales/Distribution, Class Action Member Logistics, Customer Loyalty

Programs

Tools & Methods: PowerBI, Visual Studio

2019/2017/2015/2012/2008/2005/.NET/6.0/97,

TFS, GIT, & Source Safe, Visio for UML Diagrams,

SSAS/SSIS/SSRS, TSQL, Dundas BI

Contact this candidate