Kevin Bach Email & Phone Number

Within the test environment:• Created solutions and projects with SQL Server Management Studio• Installed and used SQL Server Data Tools• Created databases• Detached and attached databases• Created and altered tables• Added constraints to tables• Compressed tables• Partitioned tables• Created indexes• Added included columns and filters to indexes• Compressed indexes• Disabled and dropped indexes• Created database diagrams• Used SSIS Designer to create an ETL package that took data from a flat file, reformatted the data, and inserted the reformatted data into a fact table• Added Looping to the above-mentioned ETL package via a Foreach Loop container• Performed backups and restores• Briefly touched on Always On availability• Completed the following online courses from Microsoft:• 47096 - Administering Microsoft SQL Server 2012 Jump Start• 47083 - Querying Microsoft SQL Server 2012 Database Jump Start• 47084 - Implementing a Data Warehouse with SQL Server Jump StartNote: Used the book Microsoft SQL Server 2012 Step by Step and MSDN Tutorials in conjunction with SQL Server 2012 Developer EditionAdditionally, was mentored by a SQL Server DBA at my current place of employment and attended SQL Saturday Minnesota 2015

Greater Minneapolis-St. Paul Area

• Directly oversee the data integrity of the Piper Jaffray employee application entitlement tracking database (i.e., the FITS database) by working closely with Business Consulting, Product Managers, Employee Access and vendors• Reconcile employee application entitlement information in the database. I.e., extract needed user list data and manipulate the data via Excel functions and Visual Basic scripts such that the data can be uploaded to FITS during the reconciliation process• Administrate new application set ups in the database• SOX Auditing• Ad-hoc reporting using the built-in reporting functionality of FITS• Add and update employee application entitlement information in the database as requested• Add, update and maintain relevant user information in the database• Work with the Technology Invoices department to add, update and maintain application pricing information for invoicing needs• Database integrity management, including monthly batching of data and rolling the database into a new month/year

Shoreview, Mn

• Involved in all phases of the project life-cycle for roughly 600 Spares’ projects per year.• Collaborated effectively with personnel across multiple departments to ensure project deliverables remained on track and aligned with business goals and expectations. To illustrate the effectiveness of this collaboration: Spares’ “Jobs On-Time” efficiency went from 28% to 85%. This increase in efficiency coincided with a marked increase in the total number of Spares’ jobs• Assisted Project Managers in maintaining project schedules and work breakdown structures (WBS) • Administered the weekly Spares’ meeting and provided status reports to ensure effective, ongoing communications across all team members• Established metrics that tracked the efficiencies and effectiveness of the Spare Parts Department

Twin Cities, Mn

• Provided administrative support including accounts payable, accounts receivable, and database administration to two key clients• Provided administrative support to an office of fifteen people - managed and administered an association database including accuracy of data, reporting, invoicing, billing, and meeting materials (registration lists, badges, tent cards, rosters, etc.)• Provided extensive job documentation for both clients

Bachelor Of Science (B.S.), Computer Science, 4.0 - Summa Cum Laude

Microsoft Network Administration Technical Certificate, Computer Systems Networking And Telecommunications, 4.0