Timothy C. Goldstein

Littleton, CO *****

ac3qy7@r.postjobfree.com

720-***-****

EXPERIENCE OVERVIEW

If you value communication ability as well as technical skills, you have finally found that rare combination of technical excellence combine with unique neurodiverse communication skills. Skilled problem solver that has architected, developed, refactored, and maintained various MS SQL OLTP and BI back-ends for clients including Chase Bank, Macys, Citizens Bank, Cigna, Vail Resorts, Physicians Health Partners, HeathGrades, Pearson, Harris Broadcast, Jeffco Schools, and Experian Interactive. Experienced the entire SDLC in multiple order processing, customer service, and billing applications. Worked on various sized teams building BI data warehouses including architecture of the star schema and cube. Extensive Extract Transform Load ( ETL ) experience using DTS, SSIS, Talend, T-SQL and Batch script for manual and automated processes. Extensive experience creating T-SQL and CLR stored procedures and user defined function in C# and VB.NET. Agile environments using Scrum, Kanban, and hybrid methodologies since 2007. Worked with NoSQL and alternate technologies including MongoDB, Apache Solr. AWS Redshift. Certified High Performance Coach, trained Master Presenter. I have spoken to groups like Microsoft Denver Dev Day, taught a class for Cornell University, peer discussions and presentations to senior executives.

SKILL SPECIALTIES

Microsoft SQL Server Architecture, Development, refactoring for OLTP and BI/Data Warehouse solutions, Power BI.

Architecture & Development with SQL Server Integration Services SSIS, SSAS, SSRS, SSMS, Visual Studio, TFS.

SQL Server Data Modeling, Star and Relational Schema, T-SQL, Complex Stored Procedures, CLR Functions and Procedures.

Extract Transform Load (ETL) with various commercial, open source, and scripting approaches.

Microsoft Access, Excel, Power BI power user including VB applications, VBA automation, Power BI Reports, Dashboards

Non-technology specialties include speaking, communication training tech to non-tech, mentoring, creative solutions that satisfy all stake holders, visionary big picture perspective with the ability to engage in the details.

RECENT PROJECTS

Sr BI Architect

AST (Contract) August 2017– October 2017

Architect for a unified data warehouse to allow improve tracking, analysis, and reporting on the combined data from the Campus enrollment system of all the Wyoming Community Colleges. The design was Kimball approach. I created the proof of concept design tests by reverse engineering out of Business Objects using Microsoft SQL server, T-SQL, SSIS, and SSAS.

Sr ETL Consultant

HPSJ (Contract) August 2016 – March 2017

Reverse engineer legacy ETL and business logic for a health care plan report generation system. Architected and developed new SSIS, SQL Server Integration Service, packages to replicate the legacy system output from the input of the new core system. Began as an individual contributor and became the project lead when the previous person resigned.

Sr BI Consultant

Jeffco Schools (Contract) April 2016 – June 2016

Reverse engineer prior effort to allow enterprise style access to multiple assessment centric data marts. Created POC SSAS architecture design creating a higher grain fact table to integrate the individual assessments. Developed complex SSRS reports using a cube data source instead of direct SQL queries. Architected Factless fact bridge table to allow crosstab reporting from the cube.

Sr BI Consultant

EMC (Contract) January 2016 – March 2016

Assigned to a data warehouse project for the Public Health Dept of Denver Health. Created and updated SSIS, SQL stored procedures and views, dynamic SQL, and ELT using Denver Health’s custom ETL engine.

Sr BI Consultant

SSB Consulting (Contract) August 2015 – September 2015

Learned techniques and approaches to utilizing Amazon AWS Data Pipeline to stage data warehouse data in AWS Redshift. Develop shellCommand Activities to iterate s3 file structure and copy files to a central stage directory. Designed and developed a POC utilizing AWS Data Pipeline copy to Redshift as well as the Redshift copy command to ingest a file.

Sr BI/SQL Consultant (FTE)

RBA Consulting February 2015 – July 2015

Projects included implementing dynamic role based filtering in an SSAS cube for a major construction company and initial requirement gathering and high-level planning for a major mobile payment platform. Provided pre-sales tech support for client meeting regarding BI needs. Researched & learned Power BI to create sales demos, development and implementation approaches, and recommended sales talking points.

Sr BI/SQL Consultant Engineer

Janus Financial (Contract) January 2015 – February 2015

This was a 3-week contract to Perform a health check analysis on the primary fixed income trading analysis system along with collecting and validating user requirements and needs for this database system. Core system evaluated was a MS SQL server environment with a Crystal Reports report system. Client deliverable was a report Detailing remediation needs as well as resources for further understanding and rough level of effort estimates to allow them to build a long-term roadmap for this system.

Sr ETL Developer & Architect

AIM Consulting (Contract) July 2014 – December 2014

Architect, develop, refactor Informix/AIX Unix shell scripts to run in a Windows environment using SQL and SSIS 2012. Assist other developers in understanding the new process. Created an automation utility in LiveCode and utilized TFS with Visual Studio 2012 for source control as well as SSMS with Red Gate tools for T-SQL code development.

Sr Database Engineer

Experian Interactive (Contract) October 2013 – June 2014

Architect refactor/develop automated SSIS import and return reconciliation file in a manner suitable for future use in a service based architecture. Mentored other developers in SSIS, advanced SQL queries, as well as general business principles. Utilized Embarcadero ER Studio for data modeling the logical & physical schema design and Serena Dimensions for source control.

Sr Data Architect OSI OLTP & BI

Harris Broadcast (FTE) August 2013 – September 2013

Provided Sr level architectural review and recommendations for both the OLTP and OLAP databases supporting the OSI Traffic and Billing Software product. Research and prototyped various performance tuning options including usage of data compression for reduced IO activity as well as various other techniques available on SQL 2008 R2. Mentored other employees on Data Warehouse and transactional SQL queries. Coordinated work with offshore team.

SSAS, SSIS, SSRS, MS SQL Developer

Jeffco Schools (Contract) April 2013 – June 2013

Architect and develop SQL star schema, SQL Server Integration Services, ETL, SQL Server Analysis Services cube, and SQL Server Report Services reports for childhood assessment test data using MS SQL Server 2012. Worked on various ad-hoc projects in SQL, SSIS, and SSAS. Mentored permanent staff on SSIS and SSAS techniques and approaches. Used TFS for source control.

Sr. SQL Developer

HealthGrades (Contract) November 2012 – March 2013

Development of SQL schema, stored procedures, views, and dynamic SQL for creation of a data loader application. Provided staff augmentation where I handled quick turn and break/fix SQL and data research & remediation. Optimized and tuned SSIS packages and created report feeds for SSRS reports. Learned and added rules, exceptions and hierarchies to their proprietary SQL based rules engine. Utilized Erwin for Data Modeling and TFS for source control. Mentored permanent employees on advanced SQL and SSIS methods.

Sr. SSIS/SSAS Developer

Physicians Health Partners (Contract) July 2012 – Oct 2012

Architect and development the initial POC of a SQL 2012 data warehouse of health care data. This involved the architecting and implementation of star schemas for SSAS cubes, SSIS packages to load the data, stored procedures and views encapsulating business logic and use of SQL Master Data Services and Data Quality Service. This was done using the Kimball Methodology. Mentored permanent employees on SSIS and BI concepts and techniques.

Sr. Development DBA

Pearson ECollege (Contract) June 2011 – June 2012

Development of SQL schema, stored procedures, and SSRS reports on a massive OLTP SQL 2008R2 education platform database. This involved extensive performance tuning to mitigate contention when the database was under loads of over 10,000 simultaneous connections. Due to high SLA’s all changes required extensive understanding and working with the deployment team to implement no downtime releases. Assisted the BI department by reviewing steps and procedures for change implementation to the SSIS and SSAS data warehouse elements. Created SSIS packages as proof of concept for extracting non-structured MongoDB data as well as mentoring permanent employees on advanced SQL and SSIS techniques. Utilized Embarcadero for updates and maintenance to data modeling designs.

Sr. SSIS/ETL Developer

Cigna (Contract) February 2011 – May 2011

Architected and developed a SQL/SSIS automated process to export Cigna’s client data out of their SAAS vendors system for use as a data warehouse feed. This project was on a very tight timeline due to the first 2 ETL developer’s inabilities to complete the project. Work involved development of staging environment, as the stored procedures, dynamic extraction code and SSIS packages as well as extensive performance testing in a SQL 2008 R2 environment. Assisted off site client team in understanding the data and how it would best fit into a star schema for their data warehouse cubes.

Sr. SQL/SSIS/ETL Developer

Vail Resorts (Contract) August 2010 – Dec 2010

Architected and developed a SSIS ETL automated process to migrate and maintain customer email records in a SAAS customer contact system. This involved multiple SQL 2008 SSIS packages to extract data from existing operational systems and merging that data into the outside vendors system using the custom APIs the vendor supports. This process also moved any updates on the SAAS system back into the core operational system. Processing was handled entirely with SSTS, SQL stored procedures and user defined functions. Completed fill-in work including remedial work on Cognos reports and various SQL and SSIS tasks including mentoring co-workers in advanced techniques.

Sr. SQL/SSIS/ETL Developer

Reed Group (Contract) November 2007 – November 2009

Database architecture and development to create a SAAS leave management system. Re-architected much of this database including implementing business logic through the development of a configurable SQL rules engine implemented with complex stored procedures, user defined function, and views that encapsulated the application's business logic. This system was developed on SQL 2008. This project involved large amounts of mentoring team members on the technology and approach being utilized.

Sr. Developer SSIS/ETL/SQL

QED Scholastic Books (Contract) May 2007 – October 2007

Data integration projects acquiring data from various sources including web scraping data then cleansing, standardizing, matching and de-duping against existing data. Data was then loaded to augment existing records. Primary work environment was SQL 2005 SSIS with additional utilities, stored procedures, and user defined functions developed in T-SQL, C#, and VB.Net. Utilized VSS for source control.

PAST PROJECTS, EMPLOYERS, ANCIENT HISTORY

2002 – 5/15 A2Z Corp as Sr website developer supporting a custom classic ASP ecommerce site

9/06 – 1/07 Arapahoe County as Sr. DBA (contract)

2/98 – 9/06 MLH Services Database / Application / Data Warehouse Developer / IT Manager

7/97 – 4/98 BI/Perigrine Network Administrator / Access DB Admin

3/97 – 7/97 Budget Computer PC Technician / NT Installation & Support

RESPONSIBILITIES

Fulfillment Database & Application for processing of Chase customer rewards

Established specifications for this project through both on site and phone meetings with the client. Sole responsibility for architecting, implementing, and maintaining the database, directing the web application development, and creating all data migration procedures as well as the daily data import/export and reporting. Additional duties included maintenance, backup, security, and tuning of this database. The database was MS SQL 2000 server. Daily import/export was implemented in SQL Server Integration Services from SQL 2005. Initial data migration was handled with a combination of SQL 20005 SSIS and SQL 2000 DTS. Web development was in classic ASP combined with DHTML using Visual Interdev 6.0 with VB Script, Jscript, and HTML. Reporting was a combination of stored procedures and MS Excel using MS Query. Server interaction was handled with SQL 2005 Client Tools.

Ad Hoc 1099 Report Creation for Chase Rewards

A rush project due to the departure of a data analyst. Output was an Excel spreadsheet. Data manipulation and query execution was handled on SQL 2005 specifically to take advantage of Common Table Expressions. Data import was via SQL 2005 SSIS and report extraction was via SQL 2000 DTS.

Marketing Information Report System for Citizens Bank

Architected, created, implemented, and developed the database as well as led the development of the web based application. The database was on MS SQL 2000. Report development was in Seagate Info/Crystal Reports. Web application was in classic ASP using VB Script. Oversaw data import using SQL 2000 DTS and report creation and was responsible for database maintenance, security, and backup.

Credit Customer Behavior Analysis Data Warehouse for Macys

Responsible for hardware selection, server software installation, database creation, performance tuning, and backup for this 500 gigabyte database. Developed and supervised weekly data loading and monitored server performance. Worked with the consultant team on developing the star schema and OLAP cube and was responsible for the data warehouse through its lifecycle. The OLAP cube was developed in MS OLAP Services (now know as SSAS). Was taught the Kimball Data Warehouse methodology.

E-Commerce Store with Online Business Management for A2Z Corp

Architected, coded, and maintain a cookieless e-commerce store that supports a worldwide customer base. This application also manages inventory and sales accounting. Built in classic ASP with a SQL back end that is now on SQL 2008R2. Data import and conversion from EBay sales is handled through SSIS. Developed and implemented a SSAS cube and the associated star schema and SSIS ETL for the analysis of sales data.

IT/Development Manager for MLH Services

Recruited, managed, and lead the IT and Development teams as well as managing the projects in the IT department. Team included developers in SQL, Data Warehouse, Web interfaces, Report Writers, Help Desk, and Infrastructure.

KEY ACCOMPLISHMENTS

Teaching a class at Cornell University using my proprietary concepts and course materials.

Speaking on “Communicating with the Non-Technical” as Microsoft Denver Dev Day 2017.

Authored the book “Geeks Guide to Interviews: 15 Critical Items for the Technical Type”.

Architected, developed and maintained a cookieless classic ASP with SQL backend e-commerce site. I maintained and upgraded the system in production for over 13 years and ended development of in 2015.

Architected and developed a MS SQL Server Dynamic SQL rules based decision engine that is the central core of a health & FMLA leave management application deployed with Cigna and Hartford Insurance.

Architected and developed multiple rule driven SSIS packages to migrate employee data into the SQL decision engine database from multiple enterprise resources.

Learned tuning and deployment techniques required for an “Always On” SQL database supporting over 10,000 simultaneous connections as well as architectural strategies to utilize No-SQL products to reduce the load on the core SQL DB.

Architected and developed an SSIS process to standardize and merge/augment records into an existing educational data repository.

Architected and developed a OLAP/SSAS solution on SQL 2000 for Macy’s as part of a team mentored by Len Silverston with direct support by Microsoft.

Architected, developed, and implemented numerous web based applications and MS SQL solutions covering all aspects from hardware infrastructure to actual code creation.

Serving as the IT leader, team, project, development leader on multiple software, database, data analysis, data warehouse and architecture designs.

Microsoft® Certified System Engineer + Internet (MCSE+I) and an A+ Certified Technician. Implemented and administered LANS & WANS, connected sites to the Internet, created and implemented Internet domains, web sites and e-mail services.

SKILLS

MS SQL Architecture, Development with SQL versions from 6.5 to current

Sql Server Integration Services SSIS all releases and the prior Data Transformation Service DTS

Microsoft Power BI

VB.Net

Visual Studio including Team Foundation versions from 2005 to current

Visual InterDev 6.0

VBScript

VBA Script

Redshift

JavaScript

Python

Classic ASP

Red Gate SQL Developer tool set

Embarcadero

ER Studio

Erwin

HTML

Internet Information Server MS IIS 4/5/6/7

MS Office

Large range of other applications used over the many years involved in the Information Technology industry.

CERTIFICATION & TRAINING

Microsoft SQL Server Analysis Services (SSAS) End to End training with MVP Brian Knight

Implementing a Database Design on Microsoft® SQL 6.5

Crystal Reports 8.0

V B .Net Introduction

SQL 2005 Introduction for Developers

Certified High Performance Coach

Coveted Master Presenter certification

Contact this candidate