Post Job Free

Resume

Sign in

Data Modeler / Data Architect

Location:
Round Rock, TX
Salary:
$125,000
Posted:
June 30, 2020

Contact this candidate

Resume:

David Martin

**** ******* ***** ** ***** Rock, TX 78665 (near Austin, TX) 918-***-**** add733@r.postjobfree.com

Data Architect

Data Modeler/Data Architect with extensive experience designing databases for multiple DBMS platforms using industry standard modeling approaches. Data Architect skills include:

Requirements/Business Rules acquisition

Conceptual model discussion/development

Logical model design for: Transactional/Dimensional/Data Vault

Physical model design/scripting for:

MS SQL Server/Oracle/Sybase/DB2/Hive

Expert knowledge of ER/Studio and ERwin Data Modeling tools

MDM analysis and Design.

Data profiling/analysis

SQL script usage/analysis/development

Basic Database Administration in MS SQL Server, Oracle, and HP Vertica.

Instruction in Data Modeling, Normalization, Star Schema/Dimensional Design, Data Vault, and modeling tool usage.

Experience

Christian Care Ministry, Melbourne, FL

Database Engineer/Data Architect

February, 2018–June, 2020

DXC Technology, Austin, TX (Spin-merge out of HPE)

Data Architect

April, 2017– February, 2018

Hewlett Packard / Hewlett Packard Enterprise (HPE), Austin, TX

Data Architect

December, 2010 – April, 2017

Tyson Foods – Springdale, AR

Technical Analyst / Data Modeler

December, 2007 – November, 2010

Worked with Business Customers and Developers to understand requirements, discern business rules, profile data, and craft Conceptual, Logical and Physical data models before delivering a final SQL script to the DBAs and development teams for implementation.

Key projects:

Data Standard Document: Researched and composed the Data Standards Document for CCM.

Master Data: Initiated CCM’s Master Data initiative. Identified and deployed multiple Master Data Objects for CCM (2 years).

Membership & Pricing: Currently doing analysis and design for the go-forward data model at CCM.

MDM: Participated with the establishment and deployment of HP’s Master Data initiative (1 year).

Enterprise Data Architecture: Modeled a number of Business Data Objects for the Enterprise Data Model, serving on the EDA Review team approving new objects for the EDM, company-wide.

Reporting/ETL: Analyzed data from multiple disparate systems, then designed a very complex ETL script to load the Fact table tying the data together for mission-critical Revenue Recognition reporting.

Transactional: Designed and delivered a large data model for HP’s Support Product Auto-Registration.

Transactional: Strategic design and implementation of the data model supporting HP’s Fraud Detection.

Dimensional: Served as modeling consultant to the Data Warehouse team on Tyson’s Cost to Serve project, consisting of over 100 new tables including a large and complex set of star-schemas.

Data Lake: Participated in the development of Modeling standards and the deployment of macro scripts to promote speed, accuracy, and compliance to the HPE’s Enterprise Analytics Platform on Hive.

Data Vault: Designed and implemented a Data Vault model for capturing, deciphering, and delivering USDA data to Tyson’s Deal Manager project.

Instruction: Expanded and taught Tyson’s one-day Data Modeling course for developers and business analysts throughout the company (once per quarter for 2 years).

David Martin – Résumé page 2

add733@r.postjobfree.com

918-***-****

Software - Functional (or better) competence with:

Idera/Embarcadero ER/Studio (Power User)

SQL Server Management Studio, SSIS, SQL Developer, SQL Explorer,

CA ERwin

Microsoft Office Suite:

Word, Excel, Outlook, PowerPoint, Visio

Education & Training

New Horizons Computer Learning Center, Kansas City, KS

Maintaining a Microsoft SQL Server 2008 Database

April, 2010

Genesee Academy, Denver, CO

Certified Data Vault Modeler

July, 2008

Northern Illinois University, Dekalb, IL

Master of Music – Conducting & Composition

May, 1993

Other Work Experience

Calvary Bible Church, Bourbonnais, IL

Worship Pastor/Music Director

September, 2005 - December, 2007

Served on the full-time Pastoral Staff for a congregation of approximately 600. Planned and lead worship services while overseeing all music volunteers and music ministries. Also had oversight of worship support technology (audio/video).

Davisville Church, Southampton, PA

Worship Elder/Music Director

November, 1995 - September, 2005

Served on the full-time Pastoral Staff & on the Elder Council for a congregation which grew from 600-1000 during my tenure. Responsible to plan and oversee all musical and worship-related events as well as volunteer music and worship technology staff.

References

Robert Ross, Manager (HP/HPE/DXC)

Email: add733@r.postjobfree.com – cell: 530-***-****

December, 2010 – February, 2018

Marilyn Jahr, Coworker (HP/HPE)

Email: add733@r.postjobfree.com – cell: 916-***-****

December, 2015 - February, 2018

Don High, Manager (Tyson Foods)

Email: add733@r.postjobfree.com – cell: 479-***-****

December, 2007

Erika Williams, Manager (CCM) September, 2019 – May, 2020

Email: add733@r.postjobfree.com – cell: 321-***-****



Contact this candidate