Post Job Free

Resume

Sign in

Data Sql Server

Location:
North Las Vegas, NV
Posted:
September 13, 2017

Contact this candidate

Resume:

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)



Contact this candidate