Sql Server Developer

Jacob Milter

**** ******** **** **.

Dunwoody, Georgia 30338

(c): 404-***-****

E-mail: ********@*****.***

LinkedIn: www.linkedin.com/in/jacob-milter-351774165/

TECHNICAL SKILLS:

Databases: MS SQL Server, MS Access, Teradata, Oracle

DBA Tools: SSMS, SSIS, SQL Profiler, Perfmon, Erwin, TOAD, PL/SQL, T-SQL, Idera AdminTool Set, BI xPress

GitLab, Alteryx, Red-Gate Tool Belt and Source Control

PROFESSIONAL EXPERIENCE:

T-Mobile, Atlanta, Georgia

SQL Server Database Developer-Data Analyst July 2020 – April 2023

●Worked as a Data Architect\SQL Developer\Performance DBA on numerous ETL and code optimization processes. Most of optimized processes started running faster between 3 and 100 times

●Worked as an SQL Developer\DBA creating Server health data and reports for internal use and the SCOPSBI Dashboard

●Worked as a DBA\SQL Developer during Server Migration creating an SSIS process that validates cross server table accuracy and server security configuration

●Developed several SSIS packages for quick data loads from different data sources (Teradata, JSON, FTP, SQL Server, Oracle)

●Worked as a DEV. Lead on a T-SQL based development and implementation project to deploy Production Server objects to GitLab (CI\CD).

●Worked on numerous SQL Server to Cloud migration processes (used Azure and Snowflake using Linked Server. Created SQL Server stored procedures, views, indexing etc. for data pipes). Worked on re-designing SQL Server data model to be more suitable for Cloud

●Worked as a Data QA on numerous projects and processes

●Mentored other SQL Developers on T-SQL best practices / tuning for existing queries, as well as on Database Modeling and Architecture (NF1, NF2, NF3)

●Created several generic automated processes for quick data validation

NCF, Alpharetta, Georgia

SQL-ETL Process Designer-Developer-Data Architect August 2019 – July 2020

●Data\ETL Process reverse engineering, profiling, architecture, and modeling. Completed 3 months originally planned project in 2 weeks

●Database Management and Administration

●Address Matching Processing (Alteryx, SSIS)

●Data migration, data cleansing, conversion, mapping and DWH reload ETL process design and development

●Data Validation and QA. Designed automated ‘while you run’ QA processes

●Gathered requirements from stakeholders and worked on content design methodology

●Data Dictionary – Design, creation, and implementation (SQL Server, Doc xPress)

●QuickBooks Data Migration to SQL Server (SQL Server\ETL\SSIS, Alteryx)

Applied Systems Inc., Atlanta, Georgia

Data Engineer-SQL Developer August 2018 – July 2019

System Production & Architecture

●Business\Data analysis of company data and processes

●Database and Application processes tuning and load support

●Data conversion, mapping and ETL process design

●Worked closely with .net developers optimizing SQL queries and making changes to UI

●Design, creation and support of Customers Server\Data monitoring database and processing

●Database Monitoring Reporting (SQL Server, Excel VBA, Power BI)

United Parcel Service of America, Atlanta, Georgia

Database Manager-SQL Developer July 1994 – August 2018

Business Information and Analysis

●Data Modeling, Design, implementation and support of major BIA Application Databases and Processes (SQL Server ETL, SSIS)

●BI development and data\business analysis

●Extensive support of Relational Database Management systems.

●Design, development and maintenance of data warehouse ETL processes (SQL Server, Oracle, Intelligent Warehouse).

●Strong experience analyzing, evaluating, and interpreting data

●Data Cleansing and validation

●Create documentation outlining ETL processes

●Heavy SQL Server and T- SQL development (DDL, DML and etc.)

●Process design, optimization, and automation. Analyze and implement automation of manual data extracts and other manual activities

●Day-to-Day Server space utilization monitoring and process\query performance tuning

●WEB Application development support (Database, ETL, SSIS, Ad-hoc reports and reports involving complex datasets and query for Business Intelligence.

●Extensively worked on Creating, Populating and maintaining Data Marts (SSIS, ETL).

●Mentored SQL Developers and Data Analysts on Data modeling, Design, SQL\SSIS coding and data mining

●Daily Database administration (DBA)

●Co-Designer of BI xPress (currently by Sentry One)

Main Projects

●UPS Warehouse

●UPS BIA Datamart

●Multidimensional Analysis Tool Project (OLAP)

●Trillium evaluation and testing. Service tool design, coding and implementation

●Cognos Implementation

●OLAP tools analysis, evaluation, and implementation (Impromptu, PowerPlay)

TAD Data Technical Services Atlanta, Georgia January 1994 – July 1994

Programmer-Consultant

●Database analysis and design, application development for United Parcel Service.

Quantum Consulting Atlanta, Georgia September 1993 – November 1994

Programmer-Consultant

●Database analysis, design, and application development for GTE.

EDUCATION:

Kaunas Technical University Kaunas, Lithuania September 1980 – December 1985

Master’s Degree in Information Systems

Contact this candidate