Data Engineer Warehouse

BOBBY

WALLACE

Data Engineer

Data Warehouse Specialist

Database Architect/Developer

Business Intelligence Developer

PROFILE

CONTACT

Experienced and knowledgeable database and data warehouse architect and developer, with extensive practice in Microsoft’s BI stack (SSIS, SSAS, SSRS, Power BI) and SQL Server. I am looking to obtain a challenge that allows for the utilization of my Data Modeling, ETL architecture and development, Microsoft T-SQL design and development skills, and critical thinking to produce database software that meets and exceeds the goals and objectives outlined by the requirements.

Bobby Wallace

*****.*******@******************.***

2261 Northpark Drive

Suite 156

Kingwood, Texas 77339

EXPERIENCE

EDUCATION

Wallace Data Architecture

Sr. Principal Consultant

March 2022 – Present

Fluor Corporation

ETL Consultant

Working with the Fluor Corporation, developing ETL Packages to move data from various data centers around the world into their SQL Server based ODS and Enterprise Data Warehouse.

TapeandMedia.com

ETL Consultant

Defined architecture and developed ETL processes in Python for TapeandMedia.com. Architecture was an Object-Oriented approach that utilized Encapsulation, Abstraction, Inheritance, and Polymorphism.

Global Credit Union

Senior Data Engineer

Developed data pipelines utilizing WhereScape to move the WhereScape metadata from SQL Server to Snowflake for the purpose of building dashboards to monitor job progress. The repository was also used to create data dictionaries for comparison of data types defined between source and Snowflake.

Espresso Moon

Data Migration Consultant

Developed Azure data migration strategy to move the databases and data from SQL Server (on-prem) to Azure, documented the tools to be used to perform the migration, and assisted the team with the execution of the migration and the validation of the data after the migration was complete.

Also assisted in the development and implementation of the Azure backup and retention plan.

Independent Consultant

May 2000 – June 2022

Harris County Universal Services

Business Intelligence & Analytics Consultant

Responsible for assisting with their legacy SQL Server databases/SSIS packages as they move towards Snowflake.

Initiated the utilization of the DevOps repository for code storage and build processes and developed the documentation of those processes. Developed a migration path for their date dimension in SQL Server, modifying the dimension to represent accounting’s changes from the previous definition of their fiscal year to their new definition of a fiscal year.

Also developed the same migration path for their date dimension in Snowflake.

CoverMyMeds

Sr. Data Strategy Consultant

Small projects to help with the rollout of their newly developed revenue forecasting and the database support tools to monitor and maintain the dynamic SQL. Part of the project was also to assist in the translation of the data and database structures from CMM's legacy system.

Crane Worldwide Logistics

Sr. Database Architect/Developer

Designed and implemented a new exchange rate process for converting invoice amounts to and from various currencies throughout the world.

Designed and implemented a new inter-company process to handle transactions between the various Crane Worldwide companies.

Implement the Visual Studio Database Project to introduce source code control of their SQL Server database, as well as assist in the deployment of database changes to production.

eQHealth Solutions

Sr. ETL & Database Architect/Developer

As mentor and member of the SSIS development team, designed and built an SSIS framework to capture file logs, process logs (with a tie-back to the SSIS logs for complete details), and error logs. The input file details trapped import counts, and their distribution counts (CRUD) into the production system.

The framework captured metadata for each source input at a field level, with a back-end validation engine to test the inputs for columns being required, numeric, date, etc.

The framework also included an alert notification system; responsible for delivering alerts (email/sms) when inputs are successful/unsuccessful, and detailed information regarding the inputs (i.e. success counts, invalid file data, etc.).

Also introduced a data warehouse dashboard to help evaluate deltas in the daily, weekly, and monthly inputs.

Water Management Systems

Sr. Business Intelligence Architect/Developer

Designed an operational database as well as a data warehouse to manage daily water well and location readings. Geocoding performed through Google API, mapping performed through Esri technology, ETL performed via SSIS, and data visualizations performed with SSRS and Power BI.

Louisiana State University

1983 – 1987

Baton Rouge, Louisiana

Computer Science and Petroleum Engineering

SKILLS

Data Modeling (25+ years)

Microsoft SQL Server (25+ years)

Data Warehouse (20+ years)

Business Intelligence (20+ years)

Microsoft SSIS (15+ years)

Microsoft SSAS (10+ years)

Microsoft TFS/DevOps (12 years)

Agile Process Development (10 years)

INDUSTRIES

Engineering (Construction)

Retail Sales

Banking

Government (County & State)

Healthcare

Logistics, Freight, and Shipping.

Utilities

CRM (Automotive)

Mortgage

Retail (Brick & Mortar, Online, and Catalog)

Education

Airline

Oil & Gas (Upstream, Midstream, Downstream)

Distribution (Food, Retail)

LEADERSHIP

Over 25 years of providing leadership and working with all levels of management to achieve corporate and system development goals; from mentoring to team leadership, project management, to Vice President – growing a small development team to over 100 database, systems, and web developers.

VOLUNTEER/COMMUNITY

Houston Livestock Show & Rodeo

Lifetime Member – 1995 – Present (28 years)

Committee

Position

Rodeo Ticket Sales

2005 – 2006

Assistant Captain

2007 – 2010

Assistant Vice-Chairman

2011 – 2016

Committee Member

Rodeo Express

2016 – 2017

Committee Member

Transportation

2021 – 2023

Committee Member

Willowbrook Rotary Club

2007 – 2009

Year

Position

2008

Director of Community Services

Star of Texas Fair and Rodeo (Austin)

Lifetime Member – 2012 – Present (12 years)

Committee

Position

Gala Committee

2012 – 2014

Committee Member

Little League International

3rd Base Coach – 2013

Amedisys

Sr. Data Warehouse Architect/Developer

As lead and mentor of the SSIS development team, assisted in the design (re-design) of their next generation Azure data warehouse (Kimball approach). Designed and developed an SSIS framework for the new data warehouse, plus assisted in the subsequent development of 200+ packages with that framework. Developed a data compare tool to assist with the parallel testing of the new vs. old data warehouse. All .NET programming done in C#.

Elead

Sr. Data Warehouse Architect/Developer

As lead of the SSIS development team, produced several SSIS/Stored Procedure packages that perform various tasks surrounding their data warehouse. These tasks included a system to load the data workhouse from production, an automated system to introduce new data sources to the warehouse, and an SSIS Framework to enhance logging capabilities.

Envoy Mortgage

Sr. Data Warehouse/Database Developer

Performed review of an existing Stored Procedure based application. Reviewed Stored Procedures against best practices, performance, naming standards, etc. Produced complete documentation to be used for an upcoming redevelopment project.

TapeandMedia.com

Sr. System Architect

Stood up new Database Server and migrated all databases from SQL Server 2000 to SQL Server 2012. This included all relational databases and the data warehouse, convert all DTS Packages to SSIS Packages, and re-implement SSAS for Sales Orders. There were also a number of Stored Procedures that were upgraded, as well as a number of new Stored Procedures.

Golfsmith International

Sr. Business Intelligence Developer

Brought in as lead of the SQL Server Data Warehouse team to continue development of their ETL processes and mentor others in accepted techniques to handle vast amounts of data from their online and retail outlets.

Responsible for introducing/developing CDC (Change Data Capture) to move production data from Oracle to SQL Server.

Also responsible for installing and implementing TFS (Team Foundation Server) to handle their source code control needs.

Double Line Inc.

Sr. ETL Developer

Initial responsible for the development of XML mapping with Altova MapForce to convert educational data from multiple sources into the EdFi (Michael and Susan Dell foundation’s) XML Standard. Also tasked with mentoring clients in mapping and data movement technology.

In addition, mentoring the internal staff on data warehousing technology on topics such as requirements gathering, understand of facts and their granularity and slowly changing dimensions.

Texas Department of Assistive and Rehabilitative Services

SQL Server/SSIS Architect & Developer

Brought in as lead of the SQL Server development/DBA team to assist with an application and data migration of a web-based tool to support DBS (Division for Blind Services) and DRS (Division for Rehabilitation Services).

Data migration and conversion responsibilities primarily consist of developing functions, stored procedures, and views within SQL Server (2000 & 2005) that are used to migrate data to Informix.

Additional responsibilities include the development and deployment of SSIS Packages that perform the daily, monthly, and yearly data movement requirements to support the ongoing operations. To achieve this, a new SSIS framework was developed that provided extensive error checking and email notifications of warnings and failures.

Defined a new development environment utilizing Visual Studio 2012, SSDT, and TFS. We are also implementing a deployment process to promote both the database definitions and application code simultaneously from Development to QA to Production.

TapeandMedia.com

Sr. Database Architect

Responsible for integrating and performing data integrity checks from multiple heterogeneous data sources and automating several business processes, and pushing data to other heterogeneous databases. Development was with SQL Server (2000, 2005, and 2008) utilizing stored procedures, triggers, DTS, SSIS, and SQL Server Agent to synchronize data between various systems.

Frontline Data Solutions

Sr. Database Developer

Performed enhancements on Frontline’s .NET applications. Primary focus is converting their in-line SQL to stored procedures, as well as modifying their existing stored procedures to address performance issues.

Other responsibilities include developing data migration for client support, database tuning, and advising staff on database architecture and development approaches.

TapeandMedia.com

Data Warehouse Developer

Updated the existing data warehouse previously built (see below) to change the data source from the Sales Order System to the sales order data in the Invoice System. This data has proven to be more accurate due to additional costing fields. This effort included both relational modeling to document and evaluate the source data, and dimensional modeling to modify the layout of the warehouse due to additional dimension. Also modified the ETL process that extracts sales order information and build an additional cube.

SeasonalGifts

System Architect

Implemented an online store, www.theRealOutdoorsman.com that sells almost 5,000 products. A SQL Server 2005 database was developed to maintain manufacturer/product relationships, distributor/inventory relationships, as well as a small data warehouse to help analyze sales trends. SSIS was utilized for the majority of the data movement requirements.

A subsequent store, www.myHalloweenShop.com, was implemented to sell Halloween costumes and decorations. A slightly smaller store, but integration and data movement with the distributor for order processing, inventory management, and shipment was done using XML interfaces.

BP

Database Specialist

Reverse engineered and evaluated three databases, along with their processes, designed to capture data points from all worldwide processing plants. End result focused on the data movement process and method of how the data was gathered and processed. Secondary database tuning review identified several inconsistencies in how SQL Server was configured and the architecture of the data access across databases.

TapeandMedia.com

Sr. Data Warehouse Developer

Modeled, designed and developed two data warehouses: one detailing Sales Order information, the other Invoice information, both covering 5 years of historical data of an online internet business. This effort included both relational modeling to document and evaluate the source data, and dimensional modeling to layout the warehouse. There were also ETL processes developed to extract sales order and invoice data from their accounting system and load it into the warehouse source data and re-process the cubes.

In addition, a second ETL process was developed that extracts shipping data from their accounting system and loads it into SQL Server for access from both shipping locations, ultimately automating their shipping procedures.

Shell Oil Company

Sr. Data Warehouse Developer

Developed a series of ETL processes to support Shell’s ongoing effort to cleanse their SAP data. Data was extracted from their Warehouse and systematically evaluated based upon given criteria.

Designed and developed a web-based interface to manage the price conditions for Shell Oil Products. Responsibilities included data flow diagrams, use case diagrams, and data models for analysis purposes; work closely with the DBA group to ensure the physical data model meets or exceeds all standards; perform DBA duties on the staging and production database; develop an ETL process that extracted the SAP price condition records from the Lubes Data Warehouse; and developed an ASP front-end interface. All data access was performed through stored procedures.

Converted an existing Access database application that calculated backstop prices for Shell Lubricants into a SQL Server application. Responsibilities included process and data modeling; developing an ETL process to extract pricing data on a monthly basis; and build DTS packages necessary to perform the processing.

Designed and developed the PLM (Product Lifecycle Management) Stoplight tool. A web-based interface, this tool allows the Product Lifecycle Managers to define hurdle rates for various groupings of products for Shell Lubricants.

The stoplight engine compared the actual performance of products against the hurdle rates. The report allowed the Product Lifecycle Managers to investigate and address performance based on a red/yellow/green (hence stoplight) indicator.

Designed and developed an invoice data mart. The data mart stored a summarized view of financial and volume information for a rolling 24-month period. The data mart supports a number of subsequently developed projects, including the PLM web site, the Product Lifecycle Stoplight tool, the Backstop pricing tool, and their PriceTool.

CGI

.NET Developer

Help with various government applications for the office of the County Assessor’s office and the County Clerk, namely a prototype for a new Assessor’s office application to incorporate GIS (Esri).

Duke Energy Corporation

Business Intelligence Specialist

Developed three Business Objects universes for the Real Estate Management Division of Duke Energy. Responsibilities included the design and development of an Oracle Data Mart, ETL scripts to populate the Data Mart from the source system, and testing.

Sysco

Sr. Business Intelligence Consultant

Designed and developed a report distribution facility. Utilizing Business Objects and Broadcast Agent, Visual Basic code was developed to populate the various date prompts (both Calendar and Fiscal), and subsequently distribute the reports to printers and email recipients, as well as a directory structure designed to store historical references to the reports.

The final scheduled report count exceeded 200 reports encompassing weekly, monthly, quarterly, fiscal monthly, and fiscal quarterly reports.

Shell Oil Company

Sr. Data Warehouse Developer

Re-designed the ETL process of an Activity-Based Costing system. Expanded scope of system to include handling all (40+) companies under SOPUS (Shell Oil Products US). The new design removed redundant DTS data sources, rewrote the T-SQL stored procedures for performance, implemented data partitioning, and modified the cube (Analysis Services). As a result, the new system ingested and processed more than 10 times the original data volume but decreased the total processing time to less than one hour, down from 3 hours.

Allocation Specialists

Sr. Database Developer

Contracted to design and develop the Pipeline Quality Bank system used to process the monthly petroleum movements for major oil companies (Shell, Exxon, BP, etc... Major responsibilities include detailed project planning, process analysis, data analysis, and database design and development utilizing MS SQL Server 7.

ThinkTanksWorldWide.com

Vice President - Systems & Operations

May 1999 - March 2000

Supervised the overall design and development of the Internet-based multi-point video conferencing system. Major responsibilities include budget management, project planning, staff planning, selecting, and managing multiple consulting firms to support the ongoing development efforts including the development of the web site, billing system, database, and back-office systems. Also responsible for the rollout and maintenance of all in-house servers.

Grew a small development team to over 100 database, systems, and web developers, and generated revenue for the company in 11 months.

Contact this candidate