Resume

Sign in

Data Sql Server

Location:
Andover, Minnesota, 55304, United States
Posted:
January 24, 2018

Contact this candidate

Resume:

Brian Kusie

Plymouth, MN

Executive Summary

Microsoft SQL Server developer with over 15 years of experience designing transactional databases, data warehouses and data marts; programming ETL packages using SQL Server Integration Services (SSIS) and Distributed Transaction Services (DTS); and developing data reporting systems using SQL Server Reporting Services. Extensive development experience with a broad range of language expertise in the areas of C#, Java, VB.NET, ASP.NET, VB6, Transact-SQL, C++ and VBScript. Performs multiple roles including designer, developer, report writer, security consultant and application support analyst on multiple projects. Well-developed problem interpretation and problem solving skills. Ability to work as an efficient and productive team member.

Skills Inventory

Diverse experience designing, building, and troubleshooting ETL packages in SSIS, most of which require significant data manipulation and error handling as well as robust auditing and status reporting functionality.

Outstanding experience installing and supporting SQL 7, SQL 2000, SQL 2005 and SQL 2008 servers in clustered and non-clustered environments.

Experience in reviewing and adjusting database configurations to optimize security, reliability and efficiency.

Strong communication skills and comfortable interacting with all levels of management.

Strong Microsoft experience including C#.NET, VB.NET, ASP.NET, and Classic ASP.

Excellent design structure, navigation and functionality of websites and their related CSS, master pages and object classes based on layouts defined by Photoshop files.

Exceptional debugging and problem solving skills.

Very fast and adaptable learner.

Successful team leadership experience in both large and small groups.

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

Databases

SQL Server 2000

SQL Server 2005

SQL Server 2008/R2

SQL Server 2016

MS Access

Industry Experience

Financial/Mortgage

Fuel Sales/Distribution

Class Action Member Logistics

Customer Loyalty Programs

Tools & Methods

Visual Studio 2015/2008/2005

Macromedia Studio MX Suite

TFS & Source Safe

Visio for UML Diagrams

SSAS/SSIS/SSRS

TSQL

Dundas BI

Methodologies

Internet Information Server

Education

Bachelor of Science – Computer Science From Metropolitan State University. (1999 – 2003)

Summary of Experience

Senior Database Consultant

Tailwind Informatics, November 2016 to present

Analyze data for critical client

Produce reports to aid client in payment metrics

Maintain and administer daily data processing functions.

Database Manager

ABRA Autobody, August 2015 to September 2016

Managed 3 direct-report developers/DBAs

Set up multiple SQL 2016 High-Availability clusters

Reverse-engineered legacy reports, ETL processes, and functions for migration to new system

Configured various third-party software for utilization by team

Senior Consultant

ITR, March 2014 to August 2015

Allianz

Reverse engineer and document ongoing database conversion and update projects.

Senior BI Consultant

Tail Wind Informatics, July 2013 to March 2014

Bluestem Brands

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.

Senior Consultant

Solution Design Group, July 2011 to June 2013

Polaris Industries

Converted SQL2000 DTS packages 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)

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

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.

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.

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.

Database Engineer

Lacek Group, OMG May 2009 – July 2011

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 for processing daily data feeds which has been in use for last 3 years.

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.

Senior Systems Administrator, Contractor

Rosemount, Inc. September 2008 – April 2009

Audited security, reliability, and efficiency of SQL 2000 and SQL 2005 servers and made improvements where necessary.

Transitioned Team Foundation Server from single server to dual server deployment.

Configured and administered SharePoint services.

Configured and administered servers for development and engineering team.

Migrated data and permissions between Windows servers.

Developed code for projects in both C# and T-SQL.

Database Analyst, Contractor

Lacek Group, OMG February 2008 – September 2008

Reconfigured base functionality and structure of existing system to remove data inconsistency and improve reliability, efficiency, and flexibility as well as creating core functionality for daily ETL data conversions and auditing.

Created and maintained multiple ETL functions for loading, converting, and cleansing data from third-party providers and built ad-hoc reports and functions to alert end-users to inconsistencies in received data. Data was received in multiple, inconsistent formats, and required complex validation and QC checks.

Responsible for enhancement, development, and maintenance of SQL Server (SQL2005) data and applications using SSIS.

Lead Programmer/Analyst

CHS, Inc. October 2006 – February 2008

Audited security, reliability, and efficiency of SQL 2000 and SQL 2005 servers and made improvements where necessary.

Updated, designed, and maintained multiple ETL functions for loading, converting, validating, and cleansing data received in multiple formats from multiple internal company entities. Most ETL functions had complex validation logic to address pre-existing data redundancy/inconsistency within system.

Evaluated and implemented repairs to front end application (Visual Studio 2005) to resolve newly discovered functionality barriers.

Identified and resolved current security risks and implement best practices regarding new development security concerns.

Assessed and resolved Break/Fix issues for multiple client contract management systems.

Evaluated, designed and implemented critical enhancements to current system in T-SQL and C# while maintaining Sarbanes-Oxley compliance.

Built scalable company data structure to address future functionality goals.

Utilized Visual Studio .NET 2005 to implement web-based interactive reporting and customer contract management with SQL2000 and SQL2005 back-end.

Created and configured DTS packages to maintain daily client data and to apply financial aging and business rules to data shared between two separate systems.

Lead Programmer/ DBA

River’s End Trading Company May 2006 – October 2006

Responsible for development and maintenance of SQL Server and .Net web applications.

Built SQL2000 database in preparation for migration of data from prior flat-file based system.

Created front end applications (Visual Studio 2005) to replace obsolete management system.

Built scalable company data structure to address future functionality goals.

Created and configured DTS packages to maintain daily sales data and to synchronize data between two third-party vendors.

Technical Consultant/ Programmer

Rust Consulting May 2005 – May 2006

Manipulated database tables and records with Foxpro 7.0, Access, SQL2000, TSQL and Excel to ensure data integrity and consistency.

Wrote code in ASP, Java, and Visual Basic using Visual Studio.NET with VSS.



Contact this candidate