Bobby Wallace
Database and Data Warehouse Architect/Developer
Kingwood,Texas
Summary
Dynamic Database and Data Warehouse Architect/Developer with over 20 years of experience in designing and implementing advanced data solutions that enhance operational efficiency. Expertise in Microsoft’s BI stack, complemented by strong competencies in SQL Server, ETL processes, and data modeling, supports a proven track record of successful project delivery. A collaborative approach with cross-functional teams has resulted in the creation of scalable data architectures that improve reporting capabilities and ensure data integrity. Committed to leveraging technical acumen to develop innovative systems that align with strategic business objectives while addressing complex challenges requiring high-level analytical thinking and problem-solving skills.
Overview
26
26
years of professional experience
1
1
Language
Work History
Chief Technology Officer & Product Architect
myHalloweenShop.com
11.2024 - Current
- Defined the architecture for an upcoming online retail store dedicated to Halloween products, establishing a solid foundation for future growth.
- Designed and built interfaces to distributors, facilitating seamless integration for product, inventory, orders, and returns data, which enhanced operational efficiency.
- Utilized SQL Server Integration Services (SSIS) to construct APIs, ensuring smooth data flow; this setup is set to transition to Azure Data Factory (ADF) in the future for improved scalability.
- Planned the necessary pipelines to connect the storefront technology with the API, helping to streamline processes and improve customer experience once the technology is fully implemented.
- Aligned IT strategy with organizational goals, fostering collaboration between technical and non-technical stakeholders.
- Coordinated third-party vendors and client IT teams to seamlessly deliver effective solutions.
- Developed and implemented long-term strategic technological blueprint.
ETL Consultant
Fluor Corporation
06.2024 - 11.2024
- Developed SSIS packages to efficiently transfer data from various global data centers into SQL Server, which streamlined the data integration process and improved overall data accessibility.
- Collaborated with cross-functional teams to ensure data quality and integrity, helping to maintain accurate reporting for business intelligence initiatives.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Interpreted data models for conversion into ETL diagrams and code.
- Identified opportunities for process improvements by conducting thorough assessments of existing systems and workflows.
- Effectively communicated technical information to both technical and non-technical stakeholders throughout project lifecycle.
- Developed polished visualizations to share results of data analyses.
Senior Data Engineer
Global Credit Union
10.2023 - 12.2023
- Developed data pipelines using WhereScape, which streamlined the transfer of metadata from SQL Server to Snowflake, enhancing the efficiency of our workflows.
- Built a comprehensive repository that served as a foundation for data dictionaries, facilitating accurate comparisons of data types between the source and Snowflake, which improved data integrity and usability.
Data Migration Consultant
Espresso Moon
03.2021 - 08.2023
- Developed Azure data migration strategy, ensuring seamless transition of databases from on-prem SQL Server to Azure.
- Documented tools and methodologies used for migration, enhancing team understanding and execution efficiency.
- Assisted in data validation post-migration, ensuring integrity and accuracy of transferred data.
- Collaborated on development and implementation of Azure backup and retention plan, streamlining data preservation processes.
Business Intelligence & Analytics Consultant
Harris County Universal Services
11.2021 - 03.2022
- Assisted with legacy SQL Server databases and SSIS packages during transition to Snowflake.
- Initiated utilization of DevOps repository for code storage and build processes.
- Developed comprehensive documentation for migration processes.
- Created migration paths for date dimensions in both SQL Server and Snowflake, adapting to changes in fiscal year definitions.
Sr. Data Strategy Consultant
CoverMyMeds
05.2021 - 08.2021
- Participated in the roll-out of a new revenue forecasting and database support tools.
- Monitored and maintained Dynamic SQL performance.
- Translated data and database structures from legacy systems.
- Collaborated with cross-functional teams to ensure project alignment.
Sr. Database Architect/Developer
Crane Worldwide Logistics
05.2020 - 07.2020
- Designed and implemented exchange rate processes for global currency conversions.
- Developed inter-company transaction processes for Crane Worldwide companies.
- Executed Visual Studio Database Project for SQL Server source code control.
- Collaborated on deployment of database changes to production environments.
Sr. ETL & Database Architect/Developer
eQHealth Solutions
08.2019 - 01.2020
- Designed and implemented an SSIS framework for comprehensive logging of file, process, and error logs, integrating complete details with SSIS logs.
- Captured and validated input sources using metadata, ensuring data integrity through a back-end validation engine.
- Developed an alert notification system to provide real-time updates via email/SMS for input success and failures, including detailed reporting on counts and data issues.
- Introduced a data warehouse dashboard to analyze daily, weekly, and monthly data deltas, enhancing data visibility.
- Collaborated with cross-functional teams to optimize ETL processes and improve overall system efficiency.
Sr. Business Intelligence Architect/Developer
Water Management Systems
11.2018 - 07.2019
- Designed operational data store and data warehouse for managing daily water well and location readings.
- Executed geocoding using Google API and mapping with Esri technology.
- Implemented ETL processes utilizing SSIS for data transformation.
- Developed data visualizations with SSRS and Power BI for insightful reporting.
Sr. Data Warehouse Architect/Developer
Amedisys
05.2018 - 11.2018
- Led and mentored SSIS development team in designing next-generation data translations to Azure data warehouse.
- Developed comprehensive SSIS framework supporting creation of over 200 data packages.
- Created data comparison tool to facilitate parallel testing between legacy and new data warehouses.
- Implemented best practices for data governance and quality assurance in data warehouse development.
Sr. Data Warehouse Architect/Developer
Elead
05.2017 - 04.2018
- Led SSIS development team to design and implement robust data integration solutions.
- Developed and optimized SSIS Packages and Stored Procedure for efficient data warehouse management.
- Established a streamlined process for loading production data into the warehouse.
- Automated integration of new data sources, enhancing overall data accessibility.
- Created an SSIS Framework to improve logging and monitoring capabilities.
Sr. Data Warehouse/Database Developer
Envoy Mortgage
01.2017 - 05.2017
- Reviewed existing Stored Procedures against industry best practices and performance standards.
- Documented findings to support an upcoming redevelopment project.
- Optimized performance of database applications through detailed analysis.
- Implemented naming conventions to enhance code maintainability.
Sr. System Architect
TapeandMedia.com
12.2015 - 12.2016
- Established new Database Server and executed migration of all databases from SQL Server 2000 to SQL Server 2012.
- Converted all DTS Packages to SSIS Packages to enhance data integration.
- Re-implemented SSAS for Sales Orders to improve analytical processing.
- Upgraded existing Stored Procedures and developed new Stored Procedures to optimize database performance.
- Conducted thorough testing to ensure data integrity and system reliability.
Sr. Business Intelligence Developer
Golfsmith International
05.2015 - 11.2015
- Led SQL Server Data Warehouse team, enhancing ETL processes and mentoring team members in best practices for data management.
- Introduced and developed Change Data Capture (CDC) for efficient production data migration from Oracle to SQL Server.
- Installed and implemented Team Foundation Server (TFS) to streamline source code control.
- Analyzed data processing needs, optimizing performance and scalability of data solutions.
- Collaborated with cross-functional teams to align data architecture with business objectives.
Sr. ETL Developer
Double Line Partners
02.2014 - 02.2015
- Developed XML mappings with Altova MapForce for EdFi XML Standard, ensuring accurate data conversion from diverse educational sources.
- Mentored clients on data mapping and movement technologies, enhancing their understanding and implementation capabilities.
- Trained internal teams on data warehousing principles, focusing on requirements gathering, fact granularity, and managing slowly changing dimensions.
- Implemented best practices for ETL and SSIS Packages, improving data integrity and efficiency.
- Collaborated with cross-functional teams to optimize data workflows and enhance reporting capabilities.
SQL Server/SSIS Architect & Developer
Texas Department of Assistive and Rehabilitative Services
01.2012 - 02.2014
- Led SQL Server development/DBA team for web-based tool migration supporting DBS and DRS.
- Developed functions, stored procedures, and views in SQL Server 2000 & 2005 for data migration to Informix.
- Created and deployed SSIS Packages for daily, monthly, and yearly data movement, enhancing operational efficiency.
- Designed new development environment with Visual Studio 2012, SSDT, and TFS, streamlining deployment processes.
- Implemented extensive error checking and notification system for SSIS framework, improving data integrity.
Sr. Database Architect
TapeandMedia.com
10.2010 - 12.2011
- Integrated and performed data integrity checks across diverse data sources.
- Automated business processes and streamlined workflows.
- Pushed data efficiently to multiple heterogeneous databases.
- Developed solutions using SQL Server (2000, 2005, 2008) with stored procedures, triggers, and DTS.
- Implemented SSIS and SQL Server Agent for effective data synchronization.
Sr. Database Developer
Frontline Data Solutions
03.2010 - 09.2010
- Enhanced Frontline’s .NET applications by converting in-line SQL to stored procedures.
- Modified existing stored procedures to address performance issues effectively.
- Developed data migration strategies for client support, ensuring seamless transitions.
- Tuned databases to optimize performance and efficiency.
- Advised staff on best practices for database architecture and development.
Data Warehouse Developer
TapeandMedia.com
08.2009 - 12.2009
- Updated data warehouse by transitioning data source from Sales Order System to Invoice System for enhanced accuracy.
- Conducted relational modeling to document and evaluate source data integrity.
- Modified dimensional modeling to accommodate new layout and additional dimension.
- Enhanced ETL processes for improved extraction of sales order information.
- Developed an additional SSAS cube to support expanded reporting capabilities.
Database Architect
Continental Airlines
02.2009 - 06.2009
- Collaborated with DBA team to execute data cleansing and migration processes.
- Migrated data from SQL Server 2000 and Oracle 9i to SQL Server 2005.
- Developed data integrity protocols to ensure accuracy during migration.
- Assisted in optimizing database performance post-migration.
- Contributed to documentation of migration processes and systems architecture.
Chief Technology Officer & Product Architect
SeasonalGifts
01.2008 - 02.2009
- Developed and launched www.theRealOutdoorsman.com, featuring nearly 5,000 products.
- Created SQL Server 2005 database to manage complex manufacturer and distributor relationships.
- Analyzed sales trends using a dedicated data warehouse to inform strategic decisions.
- Utilized SSIS for efficient data movement and integration processes.
- Spearheaded technology initiatives to enhance e-commerce capabilities and operational efficiency.
Database Specialist
BP
05.2007 - 08.2007
- Reverse engineered and evaluated three databases to optimize data capture from global processing plants.
- Analyzed data movement processes and methodologies for enhanced data gathering and processing efficiency.
- Conducted secondary database tuning reviews, identifying SQL Server configuration inconsistencies.
- Improved architecture of data access across databases to streamline operations.
- Collaborated with teams to implement best practices in database management.
Sr. Data Warehouse Developer
TapeandMedia.com
03.2007 - 05.2007
- Modeled, designed, and developed two comprehensive data warehouses for Sales Order and Invoice information, incorporating 5 years of historical data.
- Conducted relational and dimensional modeling to document, evaluate source data, and structure the warehouses.
- Developed ETL processes for extracting sales order, invoice, and shipping data from the accounting system into SQL Server.
- Automated shipping procedures by enabling seamless access to shipping data across locations.
Sr. Data Warehouse Developer
Shell Oil Company
03.2005 - 03.2007
- Developed ETL processes to cleanse SAP data, extracting and evaluating data from the Warehouse based on specific criteria.
- Designed a web interface for managing price conditions of Shell Oil Products, including data flow and use case diagrams.
- Converted Access database for backstop pricing into SQL Server, implementing monthly data extraction and DTS packages.
- Created the PLM Stoplight tool for Product Life-Cycle Managers to assess product performance against hurdle rates, utilizing a red/yellow/green indicator.
- Built an invoice data mart summarizing financial and volume data for 24 months, supporting multiple projects including PLM and Backstop pricing.
.NET Developer
CGI
07.2002 - 02.2005
- Developed prototype applications for County Assessor’s office, integrating GIS technologies (Esri).
- Assisted with various governmental application processes for County Clerk.
- Collaborated with cross-functional teams to enhance application functionalities.
- Analyzed user requirements to refine application design and usability.
- Contributed to documentation and training for end-users.
Business Intelligence Specialist
Duke Energy Corporation
05.2002 - 06.2002
- Developed three Business Objects universes for Real Estate Management Division at Duke Energy.
Sr. Business Intelligence Consultant
Sysco
04.2002 - 05.2002
- Designed and developed comprehensive report distribution facility using Business Objects and Broadcast Agent.
- Created Visual Basic code to automate population of date prompts for various reporting cycles.
- Distributed over 200 scheduled reports to printers, email recipients, and structured directories for historical reference.
- Collaborated with stakeholders to identify reporting needs and ensure alignment with business objectives.
- Implemented best practices for data management and report security.
Sr. Data Warehouse Developer
Shell Oil Company
11.2001 - 04.2002
- Re-designed ETL process for Activity-Based Costing system.
- Expanded system to handle the 40+ companies under SOPUS (Shell Oil Products US).
- Removed redundant DTS data sources, rewrote T-SQL stored procedures to enhanced performance.
- Implemented data partitioning to improve database performance, and modified the Analysis Services cube.
- Achieved 80% performance increase while processing over 10 times original data volume.
Sr. Database Developer
Allocation Specialists
05.2000 - 08.2001
- Designed and developed Pipeline Quality Bank system for processing monthly petroleum movements for major oil companies including Shell, Exxon, and BP.
- Conducted detailed project planning, ensuring timely delivery and alignment with client expectations.
- Analyzed processes and data to optimize system performance and accuracy.
- Developed and maintained a robust database using MS SQL Server 7, enhancing data integrity and retrieval efficiency.
- Collaborated with cross-functional teams to gather requirements and implement solutions.
Vice President - Systems & Operations
ThinkTanksWorldWide.com
05.1999 - 04.2000
- Supervised design and development of multi-point video conferencing system.
- Managed budget, project planning, and staffing to optimize resource allocation.
- Selected and coordinated with consulting firms to enhance development processes.
- Implemented roll-out and maintenance of in-house servers, ensuring operational efficiency.
- Expanded development team, resulting in over 100 databases and systems built, generating revenue within 11 months.
Education
Computer Science and Petroleum Engineering
Louisiana State University
Baton Rouge, Louisiana 05.2001 -
Skills
Affiliations
Houston Livestock Show & Rodeo
- Lifetime Member Since 1995
- Rodeo Ticket Sales Committee (2005 - 2016) - Held positions of Assistant Vice-Chairman and Assistant Captain
- Rodeo Express Committee (2016 - 2017)
- Transportation Committee (2021 - Present)
Fort Bend County Fair
- Lifetime Member Since 2006
Rotary International
- Willowbrook Rotary Club (2007 - 2009)
- Director of Community Service (2008)
Rodeo Austin
- Lifetime Member Since 2012
- Gala Committee (2012 - 2014)
Little League Baseball
- 3rd Base Coach ((014
Timeline
Chief Technology Officer & Product Architect
myHalloweenShop.com
11.2024 - Current
ETL Consultant
Fluor Corporation
06.2024 - 11.2024
Senior Data Engineer
Global Credit Union
10.2023 - 12.2023
Business Intelligence & Analytics Consultant
Harris County Universal Services
11.2021 - 03.2022
Sr. Data Strategy Consultant
CoverMyMeds
05.2021 - 08.2021
Data Migration Consultant
Espresso Moon
03.2021 - 08.2023
Sr. Database Architect/Developer
Crane Worldwide Logistics
05.2020 - 07.2020
Sr. ETL & Database Architect/Developer
eQHealth Solutions
08.2019 - 01.2020
Sr. Business Intelligence Architect/Developer
Water Management Systems
11.2018 - 07.2019
Sr. Data Warehouse Architect/Developer
Amedisys
05.2018 - 11.2018
Sr. Data Warehouse Architect/Developer
Elead
05.2017 - 04.2018
Sr. Data Warehouse/Database Developer
Envoy Mortgage
01.2017 - 05.2017
Sr. System Architect
TapeandMedia.com
12.2015 - 12.2016
Sr. Business Intelligence Developer
Golfsmith International
05.2015 - 11.2015
Sr. ETL Developer
Double Line Partners
02.2014 - 02.2015
SQL Server/SSIS Architect & Developer
Texas Department of Assistive and Rehabilitative Services
01.2012 - 02.2014
Sr. Database Architect
TapeandMedia.com
10.2010 - 12.2011
Sr. Database Developer
Frontline Data Solutions
03.2010 - 09.2010
Data Warehouse Developer
TapeandMedia.com
08.2009 - 12.2009
Database Architect
Continental Airlines
02.2009 - 06.2009
Chief Technology Officer & Product Architect
SeasonalGifts
01.2008 - 02.2009
Database Specialist
BP
05.2007 - 08.2007
Sr. Data Warehouse Developer
TapeandMedia.com
03.2007 - 05.2007
Sr. Data Warehouse Developer
Shell Oil Company
03.2005 - 03.2007
.NET Developer
CGI
07.2002 - 02.2005
Business Intelligence Specialist
Duke Energy Corporation
05.2002 - 06.2002
Sr. Business Intelligence Consultant
Sysco
04.2002 - 05.2002
Sr. Data Warehouse Developer
Shell Oil Company
11.2001 - 04.2002
Computer Science and Petroleum Engineering
Louisiana State University
05.2001 -
Sr. Database Developer
Allocation Specialists
05.2000 - 08.2001
Vice President - Systems & Operations
ThinkTanksWorldWide.com
05.1999 - 04.2000
Similar Profiles
Craig PerryCraig Perry
Edgenuity Teacher (Online Facilitator) at Harris County Department of EducationEdgenuity Teacher (Online Facilitator) at Harris County Department of Education
TaQuisha DoveTaQuisha Dove
8th Grade English and Language Arts Teacher at Atascocita Middle School8th Grade English and Language Arts Teacher at Atascocita Middle School
Micah Sky MillerMicah Sky Miller
Summer Nanny at Stephanie ClevelandSummer Nanny at Stephanie Cleveland
Nick ViellieberNick Viellieber
Chief Product and Technology Officer at ALGOO UGChief Product and Technology Officer at ALGOO UG
Assaf AsbagAssaf Asbag
Chief Technology and Product Officer at aiOlaChief Technology and Product Officer at aiOla