Professional Profile

Innovative, results-driven Data Strategist and Architect with cloud experience helping organizations maximize their data assets by designing highly extensible, scalable, and robust enterprise systems. My expertise is in architectural design of data management, data governance, data warehousing and reporting systems. I also excel at understanding key business objectives/drivers and turning them into technical requirements.

I have a proven track record and possess experience working with geographically dispersed teams. I am an ambitious, self-starter and a team player with a positive attitude who strives to stay current with new technologies.

Architectural Design and Systems Integration

Built enterprise data models supporting EY’s global Tax operations supporting global Tax operations

Automated and standardized customer file import processes and data intake systems for receiving customer health care data in a 52 TB database

Created an enrollment integrity and data intake system to support healthcare member rosters and eligibility data (200+ SQL Server databases)

Co-created and architected database objects for a manufacturing, supply, and distribution system

Created database processes to obtain data records in 3rd party software system for electric meter connects/disconnects and meter readings

Customized mortgage loan interfaces and processes for JPMorgan Chase and First Horizon clients

Lead database design and consolidation efforts for Enterprise Architecture initiative streamlining order entry, manufacturing, service & repair, and inventory control/requests systems

Co-architected enterprise database objects for ingesting data into Healthways’ HealthIQ systems

Co-architected corporate database and application processing for tug/barge operations

Team/Project Lead and Scrum Master - assisted and guided team members in achieving goals, objectives, and meeting deadlines/deliverables

Education and Certifications

B.A. New Mexico State University; Las Cruces, NM

Microsoft Certified Professional (MCP) - VB.Net

Microsoft Certified Azure Fundamentals

Databricks Lakehouse Fundamentals

Industry Experience

Finance & Accounting

Mortgage Lending

Health Care

Entertainment & Gaming

Manufacturing and Distribution

Transportation

Telecommunications

Utilities (Electrical, Water & Wastewater)

Areas of Expertise

Architectural design of data management, data governance, data warehousing & reporting systems

Object oriented and distributed systems design and development

Design, develop, maintain, implement and support user interfaces and web services

Data/Entity relationship modeling and design

Project conversions, implementations, Interface development, systems integration/migration and project management

Skills and Technologies

Azure & AWS cloud technologies

Erwin, ERStudio & Toad Data Modeling

Azure SQL Server, SQL Server, Oracle, MySql, Postgres Hyperscale (Citus), DB2, DEC Rdb, Hadoop & Vertica

T-SQL, PL/SQL, PostgreSql & NoSQL

ETL Tools: Azure Data Factory (ADF), SQL Server Integration Services (SSIS), Informatica (cloud), Scribe, SQL Server Data Tools (SSDT) & Sql Server Analysis Server (SSAS)

Programming languages: C#, VB.Net (MCP), Visual Basic & VBScript

Visual Studio & .Net Framework

Reporting Tools: Power BI, SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS)

Database Development Tools: TOAD, SQL Navigator, SQL Server Management Studio (SSMS), Red Gate SQL Toolbelt, SQL Farm Combine, PL/SQL Developer & SQL+

ADO.Net, ADO, oData, OLEDB & ODBC

Git, Azure DevOps, Team Foundations Server (TFS), Visual Source Safe (VSS), PVCS, Starteam, Vault, Subversion/TortoiseSVN, Stash

EY - Nashville, TN Mar. 2018 - Present

Position: Product Owner – Lead Data Architect

Environment: Azure SQL Server, Azure Data Factory, Cosmos DB, Postgres Hyperscale, Power BI, Azure Dev Ops

Tools: Erwin, ER Studio & Toad Data Modeler, Redgate, SQL Server Management Studio

Architect and design strategic initiatives for the Data Strategy and Architecture team within the Global Tax Platform (GTP). Coordinate work activities for 21 Data Architects and Data Modelers supporting 23 development/feature teams. GTP is a corporate strategic initiative utilizing a microservices-based architecture in Microsoft’s Azure cloud supporting 6,000+ clients and leveraging 75,000+ databases.

Design and develop enterprise data architecture concepts and standards leveraging the latest technologies and following architectural best practices

Designed and built GTP’s Enterprise data models for Trial Balance (TB), Fixed Asset Register, General Ledger-Journal Entry, Value Added Tax and Chart of Accounts.

Architected and helped build a Master Data Management system to store EY's platform-level data.

Designed and helped build a Tax Enterprise Data Warehouse.

Built Postgres Hyperscale (Citus) POC leveraging data sharding and row level security.

Spearheaded architectural design and data separation initiatives for Global Tax Platform supporting EY's business divestiture.

CGI - Franklin, TN Apr. 2017 – Mar. 2018

Position: Senior Consultant

Environment: Windows 10, Virtual Machines, Remote Desktop, VPN, MySql, SQL Server and TFS

Tools: Erwin Data Modeler, Toad, SQL Server Management Studio, SoapUI, Informatica, Putty, Git Bash

Evaluated client systems, applications, and databases to formulate optimization proposals and design recommendations for RFP process.

Built and supported Informatica cloud data integrations for a financial accounting accreditation and certification system for National Association of State Boards of Accountancy (NASBA).

Video Gaming Technologies - Franklin, TN Dec. 2013 – Apr. 2017

Position: Systems/Data Architect

Environment: Windows 2000, Virtual Machines, SQL Server, Hadoop & Vertica

Tools: Erwin Data Modeler, Scribe/Jaspersoft, SharePoint, Sparx Enterprise Architect, DB Visualizer, SQL Server Management Studio and Visual Studio

Designed and built Enterprise data models and corporate data warehouse with video gaming statistics for Power BI reporting platform. Created architectural systems design documentation utilizing TOGAF methodologies. Utilized a centralized data repository for building a highly customized MS CRM/xRM (online) application with custom data integrations/migrations.

Streamlined and automated order entry, manufacturing and inventory control processes, service and repair, RMA, and inventory request processes. Additionally, helped design and build a Hadoop Big Data environment utilizing Cloudera, Vertica, and SQL Server data marts with embedded Power BI dashboards.

Zycron Inc. – Nashville, TN Nov. 2010 - Dec. 2013

Client: Nashville Electric Service (NES) – Nashville, TN

Position: Sr. Consultant – Systems Programmer

Environment: Windows XP & 7, Virtual Machines Oracle 11g

Tools: Toad, SQL+, Visual Studio, Telerik controls, BizTalk, SharePoint, VSS, UltraEdit, UltraCompare, and Visio

Built and enhanced entity and dimensional relationship diagrams, database structures and objects. Designed and built custom web/windows applications supporting internal applications and ACH processing for vendor invoices and created data integration processes with a 3rd party server to automate customer meter connects, disconnects and meter readings. Leveraged BizTalk for meter connects/disconnects.

Internal Data Resources – Nashville, TN Aug. 2010 – Nov. 2010

Client: MedSolutions – Cool Springs, TN

Position: Sr. Consultant – Database Architect

Environment: Windows 7, SQL Server 2005

Tools: Visual Studio, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Integration Services, SharePoint, Red Gate SQL Toolbelt, Team Foundation Server, and Visio

Utilized Scrum-Agile project development methodologies to design and build database structures and stored procedures supporting an Authorization Extraction (AE) system for claim approval automations.

Optum 360 (Ingenix, AIM Healthcare) – Franklin, TN Sept. 2009 - Aug. 2010

Position: Sr. Developer – Tech/Project Lead and Scrum Master

Environment: Windows XP, SQL Server 2005/2008, .Net Framework 3.0/3.5

Tools: Visual Studio, C#, Infragistics controls SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Integration Services, SharePoint, SQL Farm Combine, Vault, Subversion/TortoiseSVN

Utilized agile project management with scrum to support and maintain claims analysis/discovery application, claims recovery data processing systems, and SSIS packages. Maintained and supported database scripts and SSIS packages for 200+ SQL Server databases. Also designed and developed an enrollment integrity and data intake system to support healthcare member roster and eligibility data across multiple payers.

Compuware Corporation (Carlisle and Gallagher) – Brentwood, TN Sept. 2006 - Sept. 2009

Client: Healthways – Cool Springs, TN

Position: Sr. Consultant – Data/Solutions Architect

Environment: Windows XP, Oracle 9i/10g, SQL Server 2005, .Net Framework 2.0/3.0

Tools: TOAD, SQL+, Erwin Data Modeler, Visual Studio, C#, IIS, SharePoint, Visio, TFS, StarTeam

Co-architected and re-designed internal auto-approval application (MyHealthIQ), Customer Data Import systems, and associated enterprise database structures. Enhanced and maintained ASP.Net web applications and web services supporting customer data imports.

Coded and maintained Oracle objects (packages, procedures, functions, triggers, constraints, indexes, and partitions) and created Entity Relationship Diagrams for 52 TB database and mentored 9 Compuware consultants.

Contact this candidate