Tim Southern

480-***-****

ad21tk@r.postjobfree.com

PROFESSIONAL SUMMARY

Highly skilled IT professional with over 20 years of experience in the Information Technology industry, specializing in Data Engineering, Data Warehousing, Business Intelligence, Analytics, and Data Architecture / Data Modeling. Proficient in development of the full life cycle from Analysis, Architecture / Engineering / Modeling, Data Integration / ETL, Reporting, and Visualization.

KEY TECHNOLOGIES

Development Tools:

.NET (VB, C#, Team Foundation Server, Visual Studio), AirFlow, ASP, Cold Fusion, HTML, Javascript, PL/SQL, Python, PySpark, Spark, T-SQL, XML/XSL

Data Warehouse / Business Intelligence Tools:

InfoSphere DataStage, ER/Studio, ERWin, MicroStrategy (Web, Mobile, Server, Architect, SDK, Dossier), MicroStrategy Enterprise and Cloud Platforms, MySQL Workbench, Informatica PowerCenter, Oracle SQL Developer, Python, SQL Server SSIS / SSAS / SSRS, Talend Open Studio, Toad, Visio Enterprise Modeling

Database Technologies:

Cloudant NoSQL, Oracle, Microsoft SQL Server, MySql, Snowflake, Teradata

Methodologies:

Atlassian tools, Business Intelligence Architecture, Data Architecture, Data Migration, Data Modeling, Data Warehousing, ETL, OLTP, OLAP, ROLAP

Cloud Technologies:

AWS (Aurora, RDS, Redshift DynamoDB, DMS), Azure (SQL Database, DMS)

PROFESSIONAL EXPERIENCE

The Walt Disney Company May, 2021 – Present

Lead Data Engineer

Created a cloud based enterprise data architecture environment, seamlessly integrating multiple on-prem platforms into a consolidated data ecosystem.

Conducted in-depth analysis of existing architectures, data models, data quality, spanning various systems from multiple business areas.

Designed and implemented robust dimensional and relational data models for Data Lakes, Data Warehouses, and analytics, enhancing data accessibility and analysis.

Conducted comprehensive data profiling, pinpointing data quality issues, and executing data cleansing strategies to ensure data integrity and reliability.

Development of ETL processes, Kafka topics, and data pipelines, facilitating data movement and transformation.

Established data governance practices, encompassing data standards, naming conventions, and data dictionaries, ensuring uniformity and compliance.

Analyzed and implemented performance tuning to optimize database performance, guaranteeing efficient data loading and retrieval.

Collaborated closely with business stakeholders to discern technology requirements, prioritize initiatives, and deliver solutions tailored to data visualization and analysis needs.

Actively engaged in Agile development methodologies, leading sprint planning, backlog grooming, and daily stand-ups, ensuring the timely delivery of projects.

Key Technologies: AirFlow, Azure, DataStage, Oracle, Python, Snowflake, SQL Server, PL/SQL, T/SQL, Teradata

Albertson’s Companies June 2019 – May, 2021

Data Engineer/BI

Provided data engineering and BI expertise for consolidating systems into an Azure/Snowflake cloud.

Data architecture/modeling to create consolidated EDM data model and dimensional reporting models

Data analysis and mapping of new data structures to existing data models and source systems.

DataStage, Talend and Snowflake stored procedures were used to create ETL processes to extract data from Oracle Financials and other operational data sources to transform and load that data into the snowflake based EDM.

DataStage, Talend, Snowflake ETL development

Python script development for data movement.

Reverse engineering of BTEQ stored procedures to replicate procedures and functions of the retiring platform into Snowflake stored procedures.

Reverse engineering of Talent and SSIS ETL processes into DataStage scripts and Snowflake procedures.

Subject matter expertise for Microstrategy for replatforming BI reporting to PowerBI.

Key Technologies: Azure, BTEQ, DataStage, Oracle, Snowflake, SQL Server, PL/SQL, T/SQL, Talend, Teradata 15

Cincinnati Children’s Hospital February, 2019 – June, 2019

Data/BI Consultant

Provided data modeling and ETL development for migrating BI platform from Oracle to Teradata.

Data architecture/modeling to reverse engineer from existing Oracle VLDB model into Teradata.

Implemented best practices for Teradata partitioning, Group-AMP operations and indexing.

Informatica ETL development to migrate functionality of the existing Oracle PL/SQL based ETL.

Replicated Oracle PL/SQL reporting scripts to Teradata BTEQ scripts.

Key Technologies: Clarity, Oracle, PL/SQL, Teradata 15, Informatica 10

AT&T July, 2016 – February, 2019

Lead Information Technology Specialist

Created data architecture and models to consolidate, aggregate and organize multiple data sources into a single data repository.

Created multiple data stores, data marts and multi-dimensional databases to fulfill reporting needs based on the consolidate data repository.

Created a large array of ETL procedures in Oracle PL/SQL and Talent Open Studio designed to extract and populate a wide variety of data models (ODS, EDM and Data Lake).

Created MicroStrategy Architecture and objects.

Created MicroStrategy Reporting objects.

Performed MicroStrategy administration tasks and automated many of these processes.

Reversed engineered an existing extensive Cold Fusion implementation that provided reporting services into MicroStrategy reporting.

Established best practices policies and procedures for extension, enhancement and continuing the enterprise Technology Delivery Platform.

Key Technologies: AWS, DataStage, MicroStrategy 10.x, Oracle, Oracle PL/SQL, IBM Rational Suite, Talend ESB

PF Chang’s January, 2016 – May, 2016

Business Intelligence Consultant

Data architecture and modeling of data warehouse and data marts

Developed ETL processes (SSIS and script based)

MicroStrategy Architecture, reporting and administration development

Liberty Mutual Insurance May, 2015 – December, 2015

Business Intelligence Consultant

Implemented a paradigm shifting data architecture and ETL process moving Liberty Mutual to a NoSQL database architecture and an RESTful API Endpoint based source system ETL process for near real time data collection.

Developed Talend ETL jobs for RESTful Endpoint API data collection routines processing JSON documents into a Cloudant NoSQL Cloud Database.

Developed Talend ETL to generate data marts for use by MicroStrategy reporting

Develop custom MapReduction queries and indexes for Cloudant.

Developed MicroStrategy technical architecture and created the metadata (schema) objects layer.

MicroStrategy reporting objects development.

Created dashboard documents and associated reporting objects and components.

Key Technologies: MySQL, Cloudant / CouchDB NoSQL Bigdata, MicroStrategy 9.4, Talend ESB

Express, Inc. November, 2014 – May, 2015

MicroStrategy Architect

Contributed to the data architecture and data modeling designs of the EDW providing subject matter expertise in Kimball dimensional modeling techniques and MicroStrategy specific data modeling best practices.

Developed MicroStrategy technical architecture and created the metadata (schema) objects layer.

MicroStrategy schema objects development.

MicroStrategy reporting objects development.

Created dozens of dashboard documents and hundreds of grid based reports and their associated reporting objects.

Created MicroStrategy mobile dashboards for use by corporate executives and store management.

Key Technologies: Teradata 14, MicroStrategy 9.4, Informatica 9.x, Microsoft SSIS

Bank of America May, 2013 – October 2014

Business Intelligence Lead Consultant

Contributed to the data architecture and data modeling designs of the EDW providing subject matter expertise in Kimball dimensional modeling techniques and MicroStrategy specific data modeling best practices.

Developed MicroStrategy technical architecture and created the metadata (schema) objects layer.

MicroStrategy schema objects development.

MicroStrategy reporting objects development.

Created dozens of dashboard documents and hundreds of grid based reports and their associated reporting objects.

Created mobile reports and associated reporting objects to provide executive level ‘state of the business’ dashboards.

Key Technologies: Oracle 11.2, MicroStrategy 9.3, Informatica PowerCenter

Farm Credit Bank of Texas June, 2012 – December, 2013

Business Intelligence Consultant

Assisted in the data architecture and data modeling of the EDW providing subject matter expertise in Kimball dimensional modeling techniques and MicroStrategy specific data modeling.

Developed SSIS packages to source and transform data from production systems into the vault, stage and warehouse data models.

Developed MicroStrategy technical architecture and created the metadata (schema) objects layer including installation and configuration of multiple iServers (in an iServer clustered environment)/Web Universal environments.

MicroStrategy schema objects development.

MicroStrategy reporting objects development.

Created dozens of grid based reports and associated reporting objects to replace existing source systems reporting.

Created a series of dashboards to visually present Credit/Loans data.

Created mobile reports and associated reporting objects for Credit/Loans data including a 'sandbox' environment for loan officers to produce 'what if' scenarios.

Key Technologies: SQL Server 2010/2012, MicroStrategy 9.2, Microsoft SSIS

eBay June, 2011 – July, 2012

Business Intelligence Consultant

Conducted detailed requirements gathering with eBay's stakeholders and SME's.

Assisted eBay leadership in crafting their standardized KPI metrics.

Developed technical architecture for MicroStrategy metadata layer.

Designed and developed the logical and physical OLAP data models.

Developed a hybrid Teradata/Ab Initio ETL processes to collect data from several data sources, scrub the raw data, handle data restatement/errors/duplication, and transform the data into a dimensional data model.

MicroStrategy schema objects development.

MicroStrategy reporting objects development.

Created a series of MicroStrategy dashboards and associated reporting objects.

Key Technologies: Teradata 13, MicroStrategy 9.2, Ab Initio, Microsoft SSIS

CableOne October, 2010 – June, 2011

Business Intelligence Consultant

Conducted detailed requirements gathering with stakeholders and SME's.

Developed technical architecture for Microsoft hardware and software platforms.

Designed and developed the logical and physical data model.

Developed an SSIS ETL processes to collect data from several data sources, sanitized and scrubed the raw data, transform the data into a dimensional data model.

Microsoft Reporting Services (SSRS) report development.

Created Microsoft Analysis Services (SSAS) cube design.

Deployed the solution in two paradigms; an SSRS crosstab solution for field personnel and an SSAS based SharePoint PerformancePoint solution for management dashboard reporting.

Key Technologies: Oracle 10g, SQL Server 2008, Microsoft SSIS, SSAS, SSRS, SharePoint 2010 PerformancePoint

Medicis Pharmaceuticals June, 2009 – October, 2010

Business Intelligence Consultant

Conducted detailed requirements gathering with Medicis’ stakeholders, SME's and external vendors.

Created an SOW, requirements document and system design document.

Developed technical architecture for Microsoft hardware and software platforms.

Designed and developed the logical and physical data model.

Developed an SSIS ETL processes to collect data from multiple internal and external data sources, sanitized and scrubbed the raw data and loaded it into a dimensional data model.

Developed a custom .net application that allows direct manipulation of the data warehouse data in order to make manual corrections to physician allocation data.

Developed a custom .net reporting template system designed to allow Medicis personnel to design reports tailored to the data reporting requirements for each States regulatory agency.

Key Technologies: SQL Server 2005/2008, Microsoft SSIS, SSAS, SSRS, .net C#

American Express September, 2007 – May, 2009

Business Intelligence Consultant

Primary role involves reengineering AMEX's PPM BI system to utilize Clarity's data structure and to convert their BI platform from MicroStrategy to Microsoft.

Conducted detailed requirements gathering with AMEX stakeholders and SME's.

Developed technical architecture for Microsoft hardware and software platforms

Designed the data architecture and developed the data model (logical/physical) for an enterprise wide data warehouse.

Designed several Microsoft Analytical Services data cubes sourced against the new data model.

Developed SSIS ETL processes to both migrate existing data warehouse data to the new data model design as well as the process to update the data model from the new Clarity data source.

Microsoft Reporting Services report development.

Developed a custom .NET front end that provided filter prompting and selection of attributes and metrics using a technique to generate custom MDX queries on-the-fly.

Key Technologies: SQL Server 2005, MicroStrategy 8, Microsoft SSIS, SSAS, SSRS, .net C#

Prudential Financial May, 2005 – September, 2007

Data Architect (Consultant)

Architected comprehensive enterprise OLTP data models in support of company-wide initiatives to replace all legacy applications and data repositories.

Architected an enterprise OLAP data warehouse for operational and financial data warehousing.

Created logical and physical models for all databases used at the enterprise level.

Developed functional specifications for data extraction, transformation and loading processes from source legacy systems into new data structures.

Developed ETL processes and procedures used to migrate legacy data into new data architecture and enterprise data warehouse.

Developed ETL process utilized to populate an enterprise-wide data warehouse.

MicroStrategy project architecture.

MicroStrategy metadata development and management.

MicroStrategy report development.

Responsible for creating, and ensued compliance with, data standards and best practices in connection with any database development efforts.

Key Technologies: Oracle 10i, SQL Server 2005, Microsoft CRM, MicroStrategy 8, Microsoft SSIS, SSAS, SSRS, Informatica

<< Professional experiences edited for brevity. Additional details available upon request >>

EDUCATION

Bachelor’s Degree, Information Systems/Computer Science, University of Maryland

CERTIFICATIONS

MicroStrategy Platinum Level DSE

MicroStrategy Certified Engineering Principal (MCEP)

Microsoft Certified Solutions Expert (MPSE) (SQL Server)

Kimball University

AWS Solutions Architect

Contact this candidate