Summary
Overview
Work History
Education
Skills
Timeline
Generic

Robert Kebert

Phoenix,AZ

Summary

SQL Developer with expert grasp of SQL code generation and optimization with over eight years of experience to support downstream applications and reporting. Knowledgeable of high-level T-SQL coding instances such as windowed aggregate functions, error handling, mirroring complex business requirements, and generating reusable components.

Overview

8
8
years of professional experience

Work History

Analyst/Developer Systems III

Avnet
05.2016 - Current
  • Implemented ETL process of SAP and MDM data sets to SQL server with automated error handling and job statistic tracking in SSIS for over 100 SAP data tables and 10 MDM data tables originally from flat files and then transitioned to a link server with HVR.
  • Developed core data sets for Inventory, Sales Orders, Purchase Orders, Bill of Materials, Forecasts, Cost, Material Area of Responsibilities, and more to replace or enhance BI queries that did not correctly reflect the business's needs.
  • Optimized poor performing queries to increase the speed the business could access mission critical reports.
  • Improved internal knowledge sharing by developing documentation and templates for SSIS packages, SQL job creates and cleanup procedures of old historical data.
  • Developed back end of Total Forecast Response report in response to every supply chain customer when such customer updated forecasting information. This report includes optionally up to 11 different types of demand and supply in a week by week view to show inventory allocation or shortages. The tool has 19 different options which changes the manner in which the demand and supply is included, excluded, calculated or modified with additional side reports analysts can generate. Although this tool was originally calculated to cost three million dollars taking multiple years for an outside vendor to create, I was key in helping build in house with one front end developer and a manager in seven months saving our company millions and an estimated 9,000 supply chain analysts' man hours per year.

Education

Bachelor of Science - Computer Science

Arizona State University
Tempe, AZ
05.2017

Skills

Microsoft Stack-SQL Server, SSIS, Power Bi

Proficient with raw SAP data tables and elements

UiPath Reframework

Documentation

Timeline

Analyst/Developer Systems III

Avnet
05.2016 - Current

Bachelor of Science - Computer Science

Arizona State University

Similar Profiles

CREATE PROFILE
Robert Kebert