Data Architect / Data Governance / Data Modeler
I am looking preferably for Data Architect / Modeler position or IT Director / Manager
Knowledge and Experience
20+ years experience in architecting data warehousing, data marts, and relational databases.
9+ years experience in data modeling conceptual, logical and physical using ES Studio (similar to ERWIN), Power Designer, MySQL Enterprise, Visio, Manta View lineage.
5+ years experience with very large data warehouse environments and tables in multi-terabytes.
20+ years experience in ODS, dimensional, fact, usage of 3rd normal form, real time, batch, mission critical.
20+ years of SQL (ETL, ELT) – Teradata, SQL Server, ORACLE, Tandem / HP Non-Stop (MP / XP), Neoview (Greenplum like architecture) using 256 – 512 cpus; MPP architectures and usage in data structures.
10+ years experience in project management and leadership including agile, and waterfall .
Knowledge of Windows and some Unix.
2+ years of Teradata using Golden Gate, Control-M, DMX, UNIX
Specialties and Experience
• Data Architect
• Solutions Architecture
• Dashboard Architecture
• Enterprise Data Warehouse
• Project Management
• Onsite & Offshore Management
• Data Modeler (CDM,LDM,PDM)
• Program Management
• Strategic Planning
• Data Governance
• Team Development
• Cost/Benefit Analysis
• Data Management
• Cross-functional Leadership
• Disaster Recovery
• Data Warehousing (DWH)
• Data Cleansing
• IT Operations Management
Soft Skills
Extensive experience interfacing and translating Business Intelligence to requirements.
Experience with interpreting user asks into needs and requirements – including prioritization.
Experience with transferring user / technical specifications to stories.
Experience with understanding of technical problems and solutions as they relate to the current and future business environment.
Experience with standard and matrix resource environments and special task teams.
Experience with leading and managing teams including onshore and offshore resources.
Exposure to data needs of MicroStrategy, Tableau, Excel Power Pivot (dashboard), Power BI.
Experience creating easy to understand documentation
Subject Areas / Domain Knowledge
Healthcare – Humana, GE (IDX), Medical Office, TMHP (Medicare/Medicaid claim processing)
Retail – Walmart, ROSS, May Department Stores, Sainsbury UK, Target, Overstock.com, HP
Banking / Credit Card – Scotia Bank, Royal Bank, JPM, Raymond James, Credit Unions
Brokerage – Royal Bank, Edward Jones, HP, Compaq
Casino – Pinnacle Entertainment
Manufacturing – DELL, Chrysler, Pilkington Glass
Telemarketing/Campaign management – Ameritech (AT&T), Target, Overstock.com
PINNACLE Entertainment Inc, Las Vegas, NV 4/2017 – current
Casino Management
ETL Architect
SQL Server SSIS – including Stored Procedures.
Build / Modify Solutions / Packages. Job and Step creation and monitoring.
Use TFS for code control
OVERSTOCK.COM, Salt Lake City, UT 11/2014 – 01/2017
DotCom Retailer
EDW Architect / Data Modeler
Data Modeling, Metadata Architecture, Knowledge based dictionary, standard naming
Process Improvement and Cross team relations development
Introduced Manta Lineage tool into company
Create education materials for ER Team Server, and “How To” documents for ER Architect
Create education materials for BI Report developers to enhance manpower efficiency, and knowledge of EDW.
Usage: Teradata SQL, ER Studio, Manta View, Control-M, Confluence, Golden Gate.
On call rotation for Teradata ETL (included DMX, UNIX)
HUMANA, Louisville, KY 10/2011 – 11/2014
Healthcare Plan Management.
Appl. Architect / Data Governance / Data Modeler
Data Governance, Data Modeling, Metadata Architecture, Knowledge based dictionary
Data Access Control, Data related Process Improvement
Usage: SQL Server 2008, 2012, Oracle, ERWIN, SharePoint
Conduct DB SQL Server performance and tuning enhancements.
Architect approach for faster processing, enhanced transactions from 30 to over 200 per second.
Was the key proponent for MS PDW so as to enable advanced application processing performance.
Syntel – Architecture, Data Governance, Data Modeling
Create Data Models (LDM / PDM) large SQL Server 2012 DW
Apply Data Governance, and approve changes for all databases / tables with Clinical team.
Initiated and Implemented new Software Documentation Standards in less than 1 year.
Application Architect for multiple applications.
Technical Leader for multiple simultaneous Projects.
ING, FL 5/2011 – 7/2011
Risk management – dashboard architecture and guidance.
BI Dashboard Architect Consultant
Provide general guidance and architecture for the Risk Management Dashboard, and database structure.
Evaluate and recommend presentation alternatives, establish prototype guidelines, and determine query needs.
Provide dashboard presentation knowhow.
Create Requirements Document and design for the Risk Management Dashboard using Archer.
Guide data architecture foundation / model for solution.
Prepare road map for current phases and future guidance for growth.
Work directly with Director, Project Manager, and closely with other peer management members.
JP MORGAN CHASE, Tampa, FL 11/2010 – 4/2011
Banking – cash card and State EBT processing.
Data Warehousing Architect / Modeler
Combine two large relational applications into a single very large data warehouse MPP platform.
Provided logical and physical modeling for VLDW from relational to SQL. This effort combines two very large applications and VLDB/VLDW into a single VLDW. Using MySQL for the model.
Championed SOA approach for the OneCard project – main concentration on Data Layers.
Create a single standard script to streamline file transfers to internal and external entities for use with FTP, SFTP, NDM, and NDMS.
HEWLETT PACKARD, Bentonville, AR 11/2008 – 08/2010
The team provided support and services mainly to Walmart 10+TB data warehouse on the HP MPP Neoview blade environment. Also supports Sainsbury, UK, and other clients as required.
Senior Database Support Analyst
Provided support for all aspects of the HP Neoview environment, including rotational 24/7 on-call
Created level-2 guide for navigation, troubleshooting, and orientation for supported clients.
Provided level-2 support for all software, including some customer supported items.
Created help desk service guide of access, troubleshooting, and “how to” for familiar issues.
Established remote customer support services
Created SOW. Interfaced and moderated with various internal and external organizations to resolve organizational and process issues.
Devised communication protocol between Customer and Help Desk with SLAs.
Reduced initial callback from 45 minutes minimum to 5 minutes average.
Point Person for complex issues, requiring multitasking, troubleshooting, risk management, resolution, and post-mortems. Normally involved up to 10 people externally and internally simultaneously in various world regions with diverse technical skills levels.
Investigated long running queries and platform overall performance
Developed professional PowerPoint training materials and conducted customer education.
Created platform “load execution resource histogram” guide to educate people on workloads.
Identified ‘bad query’ patterns for quick recognition, and set procedures to expeditiously communicate issue and resolution back to customer.
Provided sales support to enhance customer satisfaction
Created professional status presentation for machine usage histograms, tasks, resource assignment, target date, risks, impacts and historical performance enhancements list.
Enhance client relations through attention to details, assiduous meeting and impromptus clarification discussions with customer staff.
RAYMOND JAMES, St. Petersburg, FL 08/2008 – 11/2008
Development project to enhance business by providing client aggregated position within bank and financial services.
IT Consultant – Project Lead
Managed project in matrix environment. Coordinated with program manager and other projects, database architects and resource manager
Provided estimates, participated in peer reviews, managed ~10 people.
Reviewed database architecture, and audited database design and data.
Created common enhancement approach to shorten development time and minimize risks.
Directed performance research and testing for improved OLTP and batch response time.
Directed implementation project development.
Mentored junior staff.
TMHP, Austin, TX 01/2006 – 08/2008
Very Large Data Warehouse (VLDW) – processing Texas Medicare claims for whole state.
IT Consultant - Data Warehouse Support Architect
Provided support for all aspects of Production DW environment, including rotational 24/7 on-call
Created automation scripts for faster issue troubleshooting.
Provided level-2 support for troubleshooting, resolution, and level-3 for recovery of SQL DW.
Conducted job performance monitoring and tuning, and bad query analysis
Automated monitoring processes. Created elapsed time histograms and deviation charts.
Created education materials for BI support for use by level 1 in Bad Query maintenance.
Monitored data Warehouse staging and test environments availability
Created searchable Visio website documenting job flow and table usage.
Instituted operating procedures to control environment changes.
Enhanced Job coding standards and peer reviews troubleshooting
Reduced environment failures from daily to less than 2 per month.
GE HEALTHCARE (IDX), Boston, MA 07/2003 – 04/2006
Development of OLTP Centricity / Carecast software suite for Hospital patient control and claim processing.
Principal Database Architect / Solutions Architect - CARECAST
Architected migration of flat file relational database (ENSCRIBE) to NonStop SQL
Provided logical and physical data models using PowerDesigner. Optimized SQL statements for inclusion into Object Oriented services for the data-layer access.
Maintained data governance.
Mentored and coordinated offshore resources.
Mentored ‘C’ knowledgeable staff in transition to COBOL85 and HP NonStop MPP.
PRIOR JOB DETAILS, Available on request – COMPAQ, DELL, May, Scotia Bank, RBC, Ross, Ameritech…
EDUCATION
University of Phoenix, Phoenix A.A. Information Technology – Databases
Western Governors University, Salt Lake City B.S. Information Technology – Databases (ongoing)