Tracy Norris Email and Phone Number

Design, implement and maintain a wide variety of data interfaces between our main ERP system (CMiC) and others such as ProCore, iSqFt, Cosential, HCSS HeavyJob and HeavyBid, Lever, Banking Systems, Cornerstone TMS and many others. Utilize technologies such as a wide variety of APIs, FTP, SFTP, direct file transfer as well as many others. Principal consultant for company-wide data interchanges as well as our Data Lake, ETL and Data Warehouse processes. Currently leading the charge on our Data Science, Data Analytics and Machine Learning trajectories.

Responsible for providing data governance and direction to SpawGlass in all aspects of the company business. Lead a team to design and implement data flows across disparate systems utilizing SOAP, Oracle 11g, SQL Server 2019 and SFTP strategies. Work with and direct outside vendors with regard to implementing various cloud solutions for the business.

Provided direction and guidance to direct reports for enterprise-level data operations involving ETL from existing SQL Server and DB2 databases to the newly developed divisional data marts as well as the corporate data warehouse. Established corporate standards on SSIS and T/SQL ETL processing, reporting, documentation and performance expectations.Coordinating team activities and prioritization with regards to executive and mid-level management reporting, Microsoft PowerBI training and downstream data aggregation. Establishing Lunch-n-Learn sessions for specific aspects of PowerBI, Data Mining and Reporting.Providing guidance and planning of CRM upgrades from Microsoft Dynamics 2011 to Dynamics 2015 which involves server and capacity planning on database, application servers and IIS platforms to support this effort.

Performed Database Administration and performance remediation across multiple SQL Server 2008, 2012 and 2016 instances. Developed SSRS Reports for senior and middle management against Microsoft Dynamics SL and Spitfire databases. Consulted with division heads and managers to discuss data, process and reporting challenges to research, develop and implement solutions that best fit the problem at hand, with an eye for future, downstream utilization. Collaborated with IT management on larger data migration and interchange issues between disparate systems. Brought in to resolve ADP-Active Directory true-ups to ensure proper security remediation between HR and AD systems.

SQL Server 2008 Database Administration / Database Architecture / Tuning for a wide variety of applications relating to the Oil & Natural Gas Industry. Custom application development / ETL operations utilizing SSIS, C#, ASP.NET, ADO.NET and Microsoft Visual Studio 2010. Additional tasks include data extraction and manipulation from P2 BOLO (Unidata) databases.

Setting Up, Administering, migrating, tuning, troubleshooting and maintaining a very large number of Microsoft SQL Server 2000/2005/2008 databases. Additional duties include Database Architecture Reviews / Approvals for new projects and database upgrades to legacy systems. Providing assistance with Sarbanes Oxley compliance for PII when needed. Supporting a wide variety of environments including SQL Server 2008, workstations, Linux and Sun Solaris. Currently undergoing additional training in Oracle 10 & 11. Providing additional assistance with mySQL 3.x to 5.x data migration.

Administered Sybase Adaptive Server Anywhere (ASA), DB2, and some SQL Server 2000

Short-term project-based contract includedSupported database design and provided upgrade support to SQL Server 2000. Provided modifications & additions to existing Delphi 6.0 applications related to Payroll processing. Reporting support developed using Crystal Reports

Assisted in the development and externsion of the Asset Management System.Extensive programming and database design utilizing Delphi 6.0 Enterprise, Sysbase SQL Anywhere and Microsoft SQL Server 2000.Created and administered the Ad-Hoc reporting system for the AMS.Managed data replication across 47 servers world-wide.

Short term contract to provide new development and upgrades to the existing Interactive Voice Response System (IVRS) for clinical trials.Development was in Delphi 5.0 (with visual voice controls) utilizing a Paradox 7 database. Provided after-hours and on-call support with PC Anywhere.

Duties with Coral Energy (formerly Tejas Gas Corporation) includedDatabase design, development and programming of the Risk Management System for the Risck Accounting Division.Utilized Delphi 2.0, 3.0 and Microsoft SQL Server 6.0/6.5 Database. Extensive database modeling and design utilizing ERwin, TSQL, Stored Procedures, ETL and database triggers.Interfaced the Risk Management System with the ABACUS system and later SAP.Designed, Modeled and Implemented the Broker Fee / Tracking System utilizing Visual Basic 6.0, Microsoft Access 98 and SQL Server 7.0 via ODBC connections.Instructed new developers in advance SQL, Client-Server methodologies and object-oriented programming practices.

Short term project-based contract to develop and implenent the Register Usage and Conflict Manager for the Computer Aided Engineering Department.Utilizes Delphi 1.0 and 2.0 as well as Visual Basic 3.0 for the development system. Microsoft SQL Server 6.0 was used as the database back-end over a Banyan Vines network.Designed and developed the application and provided instruction to the users on its operation. Assumed support responsibility for the Compaq Problem/Enhancement Tracking system utilizing Microsoft SQL Server 4.1 and Powersoft Powerbuilder 4.0.

Design, training and support of the Workload Document Management System.Utilized Gupta SQLBase database and developed using Gupta SQLWindows 5.0 with Windows API support