Nick Koch Email & Phone Number

Franklin, Tennessee, United States

--Successfully worked with a cross-functional team to implement and test a new data warehouse solution, Snowflake with AWS, resulting in improved data accessibility and reporting capabilities.--Managed a cross-functional Data Assets team of architects and data professionals.----This team is responsible for datasets that focus on data efficiency to support.

Franklin, Tennessee, United States

-Implemented Snowflake Data Warehouse with AWS—Involved from POC to the Production environment. —Designed and implemented the Data Warehouse security and integration with OKTA. —Setup databases, columns, tables, schema, and role naming standards. —Designed S3 bucket and user policy for Snowflake SnowPipes.—Setup SnowPipes to pull from the AWS S3 Stage and.

Franklin, Tennessee

- Migrated all SQL Servers and web servers from vendor data center to private cloud. — Saving the company about one million dollars per year in vendor fees. — Reduced the number of cores per server to allow SQL Server license dollars to be used in other parts of the department. — Converted majority of the databases to 2019.— Converted all intranet and.

Franklin, Tennessee

Helped relocate onsite data center to an off site data center hosted by IBM. - Had to move every website, application, ssis, ssrs, database, and reconfigured each connection string.

Nashville, Tennessee

• Report directly to the CIO.
• One direct report on site and the communication channel to outside IT Vendors.
• Responsible for application development and database structure.
• Oversaw a document scanning application from initial research to company-wide rollout. This project eliminated the cost of shipping from 52 shipments a year to 12 per restaurant.
• Helped create a documentation manual for a 3rd party tool for other departments that allows the users to quickly find previous issues and solutions.
• Oversee code reviews and organize SDLC documentation for yearly reviews.

Greater Nashville Area

• Using.Net in Visual Studio 2010, 2012, 2013, 2015, & 2017 and SQL Server 2008, 2012, 2014 & 2016. Using MVC 5, Twitter Bootstrap, Razor, Entity Framework 6, WPF(XAML), ADO.Net, ASP.Net, LINQ, Reporting Services (SSRS).
• Stood up a SharePoint 2013 site to test to see if SharePoint is the right direction for the company. Created multiple team pages using a handful of the out of the box web parts.
• Created a dashboard site that displays today's sales compared to last year using Google's Chart API used by the executive team members.
• Updated Logan's intranet from.Net 2.0 to 4.5, using Twitter Bootstrap to create a more responsive modern site. Eliminating unused pages that may have been distracting for users and kept them from their everyday duties.
• Built a responsive and adaptive intranet site using MVC 5 and Entity Framework that will allow our Restaurant Marketing team to work more efficiently with better functionality. Cutting down the workload of the users by.
• Work with Regional Managers to provide stores with an accurate PMIX data or food numbers so they can eliminate the chance of unused raw materials and be prepared for each business day.

Greater Nashville Area

• Use Google Analytics and Google Adwords data to find how the market is viewing the company's posts and to help strategize future postings.
• Optimize the Synergy website and job postings for improved search traffic (SEO).
• Update company's website with new logos, team pages, and Social media links; Twitter, Facebook, and LinkedIn.
• Create and update social media sites and Google Places to improve brand awareness.
• Lead meetings to teach other recruiters about keywords for jobs and to explain programming languages.
• Relay recruiting ideas to the rest of the team that will help the company grow.

Springfield, IL

• Create, design, develop, and test reports, using MSSQL Server, which will be run regularly by the users.
• Use.Net and Microsoft SQL Server to develop configurable processes, based on user requirements, that handle everyday business functions.
• Use Object Oriented Programming Design Patterns like Inheritance, Polymorphism, and Encapsulation.
• Work with the client to develop a system that will improve productivity and bring in more assets for the state of Illinois.
• Write T-SQL queries to perform system tests and edits to insure clean data is available.
• Design document layouts using 3rd party software and SQL which will automate the user’s work and eliminates user error.

Martin, TN