| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSummaryBrian has over 22 years of experience with Microsoft SQL and Azure Databases including both database development and administration work as well as front end development with MS Visual Studio. 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. His experience includes roles as a sole developer, a senior member of a development team, and as a manager of teams of up to 8 direct report employees.Experience SynopsisOver 22 years of experience with SQL Databases, 2 years with Azure.2 years experience working with Snowflake database and Matillion ETL programs in an Azure environmentExtensive database development experience including stored procedure and query development workSQL Database administration experience including configuration and tuningSSRS reporting experienceFront end, API, and web page developmentProfessional ExperiencePerformance Systems Integration February 2023 March 2023Senior Database Consultant/Project ManagerReview 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.Technologies used: MSSQL 2017, PowerBI, MS ExcelTrue Blue August 2022 February 2023Senior Database ConsultantRe-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 developmentDocument structure of existing databaseTechnologies used: MSSQL 2019, MySql, SSISCherry Aerospace February 2022 August 2022Senior Database ConsultantReverse engineer existing 25 year old Progress database and associated functionality.Document structure of existing databaseAnalyze 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.Technologies used: MSSQL 2019, PowerBI, SSIS, Progress, MS TFSDairy Queen March 2021 February 2022Senior Database ConsultantReverse engineer existing stored procedures to ensure correct processing of incoming data integrity.Developed Stored Procedures for data access layer in SQL 2019Supported 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.Technologies used: MSSQL 2019, SSIS, MS TFSEcolab April 2020 August 2020Senior Database ConsultantIdentified 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.Technologies used: MSSQL 2017, PowerBI, MS TFS, SSIS, Azure3M August 2019 August 2020Senior Database ConsultantMaintained 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.Technologies used: MSSQL 2017, PowerBI, MS TFS, SSIS, AzureRobert Half March 2019 August 2019Senior Database ConsultantTransferred 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.Technologies used: MSSQL 2017, PowerBI, MS TFS, SSIS, Azure, Snowflake, MatillionRobert Half December 2018 March 2019Senior Database ConsultantReverse 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.Technologies used: MSSQL 2017, MS TFS, SSISSunrise Banks May 2018 December 2018Database Development ManagerReverse 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 metricsMaintained 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.Technologies used: MSSQL 2017, PowerBI, MS TFS, SSIS, AzureBluestem Brands August 2017 February 2018Senior Database ConsultantAnalyzed 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 metricsMaintained 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.Technologies used: MSSQL 2016, MS TFS, GIT, SSIS, SSRS, HadoopHallmark October 2016 August 2017Senior Database ConsultantAnalyzed 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.Technologies used: MSSQL 2014, MS TFS, SSISABRA Autobody August 2015 September 2016Database ManagerManaged 3 direct-report developers/DBAsData 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.Technologies used: MSSQL 2016, SSRS, SSIS, Dundas BIAllianz March 2014 August 2015Senior ConsultantReverse 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.Technologies used: MSSQL 2012, SSISBluestem Brands July 2013 March 2014Senior BI ConsultantReverse 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.Created and maintained all documentation for financial reporting project.Technologies used: MSSQL 2012, SSRS, SSIS, NetezzaVarious Clients July 2011 June 2013Senior ConsultantClient: Polaris IndustriesConverted 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.Technologies used: MSSQL 2000, MSSQL 2008R2, SSRS, DTS/SSISClient: Patterson DentalPerformed 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.Technologies used: MSSQL 2008R2, SSISClient: Green Tree Financial ServicesResolved 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.Technologies used: MSSQL 2008R2, SSISClient: Bluestem BrandsAnalyzed 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.Technologies used: MSSQL 2008R2, SSISLacek Group, OMG May 2009 July 2011Database EngineerProduced 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.Technologies used: MSSQL 2008R2, SSISEducationJuris Doctorate (in progress) 2021 PresentMitchell Hamline School of LawBachelor of Science Computer Science 1999 2002Metropolitan State University |
