Data Architect
Resume:
Willie M. Jacobs
Richmond, Tx 77406
Email: **********@*****.***
www.linkedin.com/in/willie-jacobs-03a36a8a
Summary of Tools and Technologies:
Database: MS SQL Server, MySQL, Oracle, Teradata, Azure SQL, MongoDB,CosmosDB
Cloud: Azure; AWS
ETL: Informatica, SQL Server Integration Services
iPaaS: MuleSoft
Analytics: Business Objects, Cognos, SQL Server Reporting Services, Power BI, Sisense, Tableau
Enterprise Architecture: TOGAF; Zachman; ArchiMate; BizzDesign
Data Modeling: Erwin, ERStudio, Microsoft Visio, Power Designer
Master Data Management: SQL Server Master Data Services, Profisee
Summary of Qualifications:
Over 20 years IT experience. In my most recent Data Architect positions, I have been responsible for enterprise architecture focusing on Data Management. Expert in most all aspects of Data Management including: Data Governance, Data Architecture, Data Modeling, Database & storage management, Data Security, Master & reference data management, Integration Architecture, Document Management, Data Warehousing & Business Intelligence, Metadata Management and Data Quality.
Professional History:
Oct 2018 - Current LynnCo Supply Chain Solutions Tulsa, OK
Senior Enterprise Data Architect
Enterprise Data Architect with responsibilities primarily in Data Management. Providing architecture and design for Integration, Database, Business Intelligence & Analytics, Master Data Management and Data Warehouse areas of the Lynnco ecosystem as well as lead the Data Governance program.
Responsibilities include:
Lead POC projects for Data Management initiatives
Create Prototypes for Data Management initiatives
Lead efforts to evaluate new Data Management technology.
Lead Data Governance program
Create and maintain technical roadmap for the enterprise.
Model database designs.
Create and maintain enterprise architecture documentation and models
Architect and design integration solutions that provide system abstraction, data as a service and re-usability for the Lynnco ecosystem.
Architect and design a Master Data Management solution based on the Profisee platform.
Architect and design an enterprise operational data store and data warehouse solution for Lynnco to support the enterprise into the future.
Feb 2014 – Oct 2018 Pennwell Media Inc Tulsa, OK
System Architect
Architect with responsibilities in Database, Business Intelligence, Master Data Management, Data Integration and Data Warehouse architecture and design in the enterprise data management area.
Responsibilities include:
Develop and document architecture of enterprise data environment.
Develop data acquisition processes to streamline and reduce data acquisition time.
Create and maintain technical roadmap for enterprise data environment.
Model database designs.
Create and maintain enterprise architecture documentation and models
Design, develop and implement data loads from various sources into data warehouse environment.
Design, develop and implement Master Data Management solutions.
Design, develop and implement data cleansing solutions primarily for customer related data.
Design, develop and implement customer matching solution to condense disparate customer data into a single Master record.
Design Audience Management System to manage unified and individual Audience records.
Design, develop Data Lake environment
Design, develop and implement a data layer used for analysis and reporting. The data layer includes relational database objects, multi-dimensional cubes and in-memory data platforms.
Design, develop and implement ETL processes using SQL Server Integration Services
Design, develop and implement reports and dashboards using SQL Server Reporting Services and PowerBI.
Design, develop and implement multi-dimensional cubes and tabular models using SQL Server Analysis Services.
Design and develop data cleansing routines and processes to clean and normalize data.
Nov 2013 – Feb 2014 Samson Resources Tulsa, OK
Data Architect\Developer Consultant
Duties included database design and development relating to the SAP implementation and its integration with various systems.
Responsibilities include:
Modeling database designs.
Create and modify database stored procedures.
Create ETL processes to migrate data from disparate sources.
Jun 2013 – Nov 2013 Hertz Corporation Tulsa, OK
Enterprise Architect
Enterprise Architecture with responsibilities over enterprise data.
Responsibilities include:
Integrate\migrate data from Dollar Thrifty Automotive Group systems to Hertz systems.
Establish Enterprise Data Modeling tools and standards.
Create and maintain Enterprise Data Architecture documentation.
Create and maintain Data Road Map for the Enterprise.
Oversee design of a Global Data Warehouse on the Teradata platform.
Develop Data Governance methodology.
Mar 2012 – Jun 2013 Dollar Thrifty Automotive Group Tulsa, OK
Data Architect
Responsible for overseeing the design and development of an Enterprise Operational Data Store, an Enterprise Data Warehouse and an Enterprise Master Data Store and Data Architecture for the enterprise.
Responsibilities include:
Design, Develop and implement an Operational Data Store, Data Warehouse and Master Data Store for the enterprise.
Create and maintain Data Modeling standards.
Create and maintain Enterprise Data Architecture documentation.
Design, Develop and implement data loads between disparate systems using various methods including ETL and ESB.
Mentor Business Intelligence developers.
Design, Develop and implement SQL Server Analysis Services solutions.
Design data analysis tools using SQL Server Reporting Services, Power Pivot and Power View.
Mar 2011 – Mar 2012 Williams & Williams Auction Tulsa, OK
Database Architect
Responsible for maintaining, administering and architecting all SQL Server 2005, SQL Server 2008 and SQL 2008 R2 instances and components, Database development, SharePoint 2010 administration and ETL development.
Responsibilities include:
Administer SQL Server 2005, SQL 2008 and SQL 2008R2 installations including, database backups and maintenance, performance tuning, database security and procedure writing.
Perform new SQL Server installations.
SQL Server Integration Services administration and development.
SQL Server Reporting Services administration and development.
SQL Server Analysis Services administration and development.
Performance tuning of databases supporting Microsoft CRM and multiple Website installations.
Architect and develop an enterprise data warehouse on SQL Server. Designing the physical systems, create database layout and ETL load processes.
Develop disaster recovery processes.
Architect new SQL Server infrastructure.
Develop and maintain SQL Server database standards.
Architect, Administer and Develop Sharepoint 2010.
Design, Develop and Support disaster recovery solutions for Microsoft SQL Server components.
Oct 2007 – Mar 2011 ONEOK Inc Tulsa, OK
Senior SQL Server Database Administrator
Responsible for maintaining and administering all SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL 2008 R2 instances and components.
Responsibilities include:
Administer SQL Server 2000, SQL Server 2005 and SQL 2008 installations including, database backups and maintenance, performance tuning, database security and procedure writing.
Perform new SQL Server installations.
SQL Server Integration Services administration and development.
Architect, develop and maintain an enterprise SQL Server Integration Services package store. Created custom procedures for initial creation, change management and securing of SSIS packages.
SQL Server Reporting Services administration and development.
SQL Server Analysis Services administration and development.
Database performance tuning.
Architect and develop an enterprise data warehouse on SQL Server. Designing the physical systems, create database layout and performance tuning.
Develop, maintain and administer disaster recovery processes using Netapp SnapMirror technology
Architect new SQL Server infrastructure.
Develop and maintain SQL Server database standards.
Upgrade SQL Server 2000 and SQL Server 2005 instances.
Dec 2006 – Oct 2007 WorldTelemetry Inc Tulsa, OK
SQL Server Database Developer\Administrator
Responsible for maintaining and administering all SQL Server 2000 and SQL Server 2005 instances and components, as well as database development, data modeling and database performance tuning.
Responsibilities include:
Administering SQL Server 2000 and SQL Server 2005 installations including, database backups and maintenance, performance tuning, database security and procedure writing.
New SQL Server installations.
Database development.
SQL Server Integration Services development.
SQL Server database development.
Maintain and administer disaster recovery processes.
Develop and maintain SQL Server database standards.
Upgrade SQL Server 2000 instances to SQL Server 2005.
Data Modeling.
Administering SQL Server Reporting Services
May 1995 - Nov 2006 Dollar Thrifty Automotive Group Tulsa,OK
Database Support Manager
Responsible for maintaining SQL Server regulatory compliance, researching new technologies and coordinating the efforts of the SQL Server DBA team.
Responsibilities include:
Administering SQL Server 7.0, SQL Server 2000 and SQL Server 2005 installations including, database backups and maintenance, performance tuning, database security and procedure writing.
Coordinate the efforts of all SQL Server administrators.
Train and mentor Junior SQL Server administrators.
Analyze and size SQL Server projects.
Approve and review SQL Server database changes.
Ensure SOX compliance for all SQL Sever database controls.
Develop and maintain SQL Server database standards.
Upgrade SQL Server 7.0 and SQL Server 2000 instances to SQL Server 2005.
Assisted with the re-write of the Dollar and Thrifty websites. This included data modeling the respective databases to support the new application.
Education
Oklahoma State University, Stillwater, OK
Environmental Engineering
Dale Carnegie Course: Effective Communications & Human Relations
Reference:
Available on request
Contact this candidate