Deep business and management knowledge and experience and Sr level BI and Database skills and experience in both FTE and contract / consulting roles. Expertise in business to tech communication gap solving and training. 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, and Experian Interactive. Has lead and participated through 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 ETL experience using DTS and SSIS for both manual and automated extractions and loads. Extensive experience creating both T-SQL and CLR stored procedures and user defined function in C# and VB.NET. Worked in Agile environments using Scrum, Kanban, and hybrid methodologies since 2007. Worked with NoSQL technologies including MongoDB and Apache Solr. Extensive business and leadership experience with both start-ups and established companies. Roles have included management in both IT and non-IT business. Have lead development teams as well as managed a 15 person IT department. Specialties: Microsoft SQL SSIS ETL SSAS SSRS Architecture and Development SQL Server Architecture, Star and Relational Schema, T-SQL, Complex Stored Procedures. Non-technology skills include mentoring, creative solutions that satisfy all stake holders, visionary big picture perspective with the ability to engage in the details.

Sr Creator @ Setup back end systems and create content for this Digital Media Company. Materials focus on self help, self training, facilitated training, and trainer training in neurodiversity and dealing with neurotypicals and on assisting business units to better understand the neuro diversity of the IT department and how as a neuro typical to best work with IT for ultimate project success as defined by the business. From September 2015 to Present (4 months) Greater Denver AreaSr Consultant BI/SQL @ 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. Learn to configure and utilize both the Data Pipeline copy to Redshift as well as the Redshift copy command to ingest a file. From August 2015 to September 2015 (2 months) Greater Denver AreaData BI Consultant @ Implemented 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. Extensive study of PowerBI and implementation of sample proof of concept projects. From February 2015 to July 2015 (6 months) Greater Denver AreaSr SQL Database Consultant @ Brought in by Catapult Systems to do a health check and database assessment on a key Janus application database. From January 2015 to January 2015 (1 month) Greater Denver AreaSQL, SSIS, SSRS, Architecture and Development @ Design, develop, refactor insurance data ETL processes from existing Informix/AIX Unix shell script process to a SQL 2012 environment on the Amazon AWE cloud. Processes are being implemented in T-SQL, Stored Procedures, User Functions, and command line batch scripting. From July 2014 to December 2014 (6 months) Greater Denver AreaLead Developer @ On going project supporting and extending the core business system on SQL Server. Filling all SSIS/ETL needs as well as web application development in Classic ASP. From November 2009 to December 2014 (5 years 2 months) Sr SQL Database Engineer @ 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 logical schema design and Serena Dimensions for source control. From September 2013 to June 2014 (10 months) Greater Denver AreaSr Data Architect @ 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. From August 2013 to September 2013 (2 months) Greater Denver AreaSr Data Integration SQL SSIS Developer @ Short term data conversion project from Onyx CRM to SalesForce.com. Used stored procedures, functions and C# CLR functions as well as SSIS to transform the existing data into an object model suitable for loading into their custom SalesForce.com application. From July 2013 to July 2013 (1 month) SQL\SSAS\SSIS\SSRS Developer @ Architected and developed a SSAS cube as well as the related star schema for a new assessment program. Utilized existing dimensions as conformed dimension. Created all required ETL in SSIS as well as reports in SSRS. Coached staff on SSAS and SSIS as well as star schema design. From April 2013 to June 2013 (3 months) Sr SQL / ETL Developer @ Development of SQL schema, stored procedures, views, and dynamic SQL for creation of a data loader application. Additionally provided staff augmentation where I handled quick turn and break/fix SQL and data research and 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 Embarcadero for Data Modeling. Mentored permanent employees on advanced SQL and SSIS methods. From November 2012 to March 2013 (5 months) Greater Denver AreaSr ETL SSIS SSAS SQL Developer @ Design & architect the initial development of a SQL 2012 data warehouse of health care data. This involved the architecture and development of star schemas for SSAS cubes, SSIS packages to load the data, complex 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 as well as SQL, SSIS, Agile & Scrum process. From July 2012 to October 2012 (4 months) Greater Denver AreaDevelopment DBA Contractor @ 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. From June 2011 to June 2012 (1 year 1 month) Consultant Sr SSIS ETL SQL Developer @ 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. From February 2011 to May 2011 (4 months) Contract Sr SQL & SSIS Developer @ 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 SSIS, 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. Utilized Subversion for source control. From August 2010 to December 2010 (5 months) Sr. SQL SSIS ETL Developer , Consultant @ 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. From November 2007 to November 2009 (2 years 1 month) Sr. Developer SSIS ETL SQL @ 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 and CLR stored procedures and functions developed in T-SQL, C#, and VB.Net. From April 2007 to November 2007 (8 months) Greater Denver AreaSr SQL Developer @ Staff augmentation. Worked on extending an EDMS (Electronic Document Management System) with complex stored procedures. Extracted data from Remedy for reporting. Trained on MySQL as prat of an initiative to understand how open source software may fit into their future development. General SQL server maintenance and development. From August 2006 to January 2007 (6 months) Director IT @ Assembled, managed and mentored a 15 person IT staff. Projects included a SQL SSAS data warehouse for Macy's credit marketing, web applications supporting various marketing initiatives for Macy's, Chase Bank, Bank One, Citizens Bank. Extensive ETL using DTS, SSIS, Data Junction. Architected and lead development on multiple SQL databases, Classic ASP web applications, VB.net applications, and extensive reporting using Crystal Reports, Cognos, and SQL stored procedures and TSQL script. From 1999 to 2006 (7 years) Greater Denver Area

Business Administration and Management, General, 4.0 @ Mohawk Valley Community College-Utica Branch From 1977 to 1979 New Hartford High School From 1973 to 1977 Tim Goldstein is skilled in: Agile Methodologies, T-SQL, Microsoft SQL Server, SSIS, Complex Stored Procedures, Stored Procedures, Business Analysis, TFS, Business Intelligence, Software Development, SSRS, SQL, C#, Visio, Quality Assurance