Bobby Wallace Email & Phone Number

Houston, Tx, Us

Irving, Texas, Us

Anchorage, Alaska, Us

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.

Spring, Texas, Us

Developed Azure data migration strategy and documented the tools to be used to perform the migration.

Houston, Us

Responsible for assisting with their legacy SQL Server databases/SSIS packages as they move towards Snowflake.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.Initiated the utilization of the DevOps repository for code storage and build processes, and developed the documentation of those processes.

Columbus, Oh, Us

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

Houston, Texas, Us

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.

Baton Rouge, Louisiana, Us

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 with regard to the inputs (i.e. success counts, invalid file data, etc.).Also introduced a data warehouse dashboard to help evaluate differentials in the daily, weekly, and monthly inputs.

Designed an operational database as well as a data warehouse to manage daily 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.

Baton Rouge, Louisiana, Us

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#.

Austin, Texas, Us

Produced a number of 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.

Houston, Texas, Us

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.

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.

Austin, Tx, Us

Employed 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.

Austin, Texas, Us

Initial responsible for the development of XML mapping with Altova MapForce‎ to convert educational data from multiple sources into the Ed-Fi (Michael and Susan Dell foundation’s) XML Standard. Also tasked with mentoring clients in mapping and data movement technology.In addition, provided mentoring to the internal staff on data warehousing technology on topics such as requirements gathering, understand of facts and their granularity and slowly changing dimensions.

Austin, Us

Brought in to assist with the application and data migration from TWorks to ReHabWorks - a web-based case management application 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 design template was developed that incorporates extensive error checking and email notifications of warnings and failures.Currently working to define a new development environment utilizing Visual Studio 2012 and Team Foundation Server (TFS). In conjunction with migrating the application development group, existing SQL Server databases are being captured with the new SQL Server Data Tools database project. We are also implementing a deployment process to promote both the database definitions and application code simultaneously from Development to QA to Production.

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.

Houston, Tx, Us

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 development staff on database architecture and development approaches.

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.

Chicago, Il, Us

As a team member of the DBA staff, assisted in the data cleansing and data migration from two existing Service Equipment systems (SQL Server 2000 and Oracle 9i) into a single, newly purchased system (SQL Server 2005).

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.Technologies: System Architect, SQL Server 2005, Analysis Server, T-SQL (Stored Procedures), SSIS, XML, IIS, Dreamweaver, Fireworks, Flash, HTML

London, England, Gb

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.

Modeled, designed and developed two 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 was 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.

London, England, Gb

Developed a series of ETL processes to support Shell’s ongoing effort to cleanse their SAP data. Data was extracted from the 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; developed 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 the 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 allow 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 PLM 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 PLM Stoplight tool, the Backstop pricing tool, and PriceTool.

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).

Charlotte, North Carolina, Us

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, E-T-L scripts to populate the Data Mart from the source system, and testing.

Houston, Tx, Us

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. Final scheduled report count exceeded 200 reports encompassing weekly, monthly, quarterly, fiscal monthly, and fiscal quarterly reports.Technologies: Business Objects (Full Client), Broadcast Agent, Visual Basic, Office XP Developer.

London, England, Gb

Re-designed the ETL process of an Activity-Based Costing system. Expanded scope of system to include to handle 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.

Involved in the design and development of the Pipeline Quality Bank system used to process the monthly petroleum movements for major oil companies. Major responsibilities include detailed project planning, process analysis, data analysis, and database design and development utilizing MS SQL Server 7.0.

Supervised for 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 the back-office systems. Also responsible for the rollout and maintenance of all in-house servers.

Harris County, Texas, Us

Supervised the design and development of the Automated Royalty Processing system for computer manufacturing company. Major responsibilities include detailed project planning, directing team assignments, process analysis, data analysis, and production acceptance reviews. Additional responsibilities include facilitating JAD sessions and customer reviews, managing vendor compliance, and mentoring team members in PowerBuilder design and development, SQL and Stored Procedure design and development, source code control and configuration management, and transaction processing design.Involved in the analysis and design of a Serial Number Repository for computer manufacturing company. Responsibilities include mentoring the Project Manager in client management skills, project planning, and project management skills. Additional responsibilities include mentoring project members in data analysis, database design, application design (multi-tiered), and supervising the quality assurance effort including automated integration testing (Rational Robot & TeamTest), user acceptance, and performance testing.

Grand Rapids, Michigan, Us

Assigned as the chief architect for major retail company in the re-design of 30+ PowerBuilder applications under Powersoft's PFC technology. Major responsibility was to teach and mentor developers in Object-Oriented design and development. Additional responsibilities include the design/development of a data access and stored procedure generator to standardize application data access across all of the applications, and the design/development of a data cache component.Supervised the design and development of a Purchase Order application for a major retail company. Responsibilities include the overall project plan, directing team assignments, graphical user interface (GUI) design, application design (multi-tiered), as well as designing and developing the Object-Oriented application framework. Other responsibilities include the facilitation of JAD sessions and customer design reviews, application stress analysis, and performance evaluation and tuning. Also responsible for mentoring project members in Object-Oriented design, PowerBuilder design and development, SQL and Stored Procedure design and development, source code control and configuration management, and quality assurance and automated testing (SQA Robot & TeamTest).Involved in the establishment of an Application Architecture group for a major retail company. Responsibilities include the writing and publishing of standards and procedures to address coding guidelines for PowerBuilder and C/C++, graphical user interface (GUI) design, application design, and source code control and configuration management. Additional responsibilities include the establishment of the application development environment, application design reviews, coding reviews, and the change control procedures.

Computer Science

High School, Some Ap