SUMMARY:

• As Senior Data Architect Consultant, Art provides leadership in developing Enterprise scalable Data Warehouses that are closely aligned to business goals and objectives. Built on extensive experience with information systems and mentor level expertise in software development, Data Architecture, Data Governance, Data Modeling, Database Development, Administration, and Master Data Management.
• Art provides team leadership, excellent communication, and interpersonal skills both written, and verbal.
• Art has built an experienced knowledge base of the major DBMS’s including TD 12 through TD 15.1, Informix, MVS DB2, Oracle, SAP, SAS, SQL, and Sybase.
• This is validated by his successes in designing and implementing multi - Terabyte Enterprise Data Warehouse Projects using Teradata, Cloudera Distribution for Hadoop, and Hortonworks Data Platform for Teradata in accordance with open systems industry standard practices.

KEY SKILLS:

• Expert Data Architecture skills performing business analysis, business process modeling, data analysis, ETL, ELT, data mapping, and MDM for BI design, development, delivery, and reporting.
• Expert Data Modeling skills transforming logical data models into Teradata physical database designs via ERWIN, Power Designer, Embarcadero, Visio etc., system implementation, performance tuning, application developer and application dba support.
• Expert DBA skills in Teradata DBMS Administration, initial Teradata DBMS environment setup, development and application DBA support, use of DataMover, FASTLOAD, MULTILOAD, Macros, Stored Procedures, TPUMP, TPT, TMSM, Teradata SQL, Unity, ViewPoint, and BTEQ Teradata utilities.
• Skilled in UNIX/Linux Shell, Powershell, Perl, and Python scripting languages and standard tools such as VI, Awk, etc.
• Skilled in delivering Business Objects, Tableau, SAS, SSAS, SSRS, MicroStrategy Business Intelligence, Cognos, Informatica data integration, and MS Azure based BI solutions.
• Skilled in Terabyte and higher data loads, change data capture techniques, backup and recovery requirements, SQL, etc.
• Skilled in Mac OS, MS Office, Visio, Business Objects Data Services, Erwin, Teradata ODBC, .Net, and Java client tools.

TECHNICAL ADDENDUM - SKILLS MATRIX:

• Business Process Modeling
• Logical Data Modeling
• SDLC Promotion
• Dimensional Modeling
• Teradata Tools & Utilities
• Physical Database Design
• Unix/Linux/Aix/PowerShell
• Backup & Recovery - Tivoli, NetVault, TARA/NetBackup
• Data Migration - DB2, Informix, Oracle, Sybase, MS Azure, and SQL Server to Teradata
• Teradata DBA
• Teradata Performance Tuning
• Teradata Mixed Workload Design & Optimization
• Teradata to Mainframe ISPF
• Business Objects
• MicroStrategy
• SAS
• SSRS
• SSAS
• Tableau
• Cloudera Distribution for Hadoop
• Hortonworks Data Platform
• Teradata Open Distribution for Hadoop

PROFESSIONAL EXPERIENCE:

Data Architect, Solutions Architect, and Technical Lead

Confidential

Responsibilities:

• Delivered implementations for Anthem, Unilever, Cosmopolitan Resorts and Casino, PGE and Bank of America.
• Led requirements gathering sessions with the end-user community.
• Led efforts to integrate and migrate applications through the SDLC
• Developed semantic layer E/R and Dimensional data models.
• Led efforts for mapping, profiling, and sourcing data from SAP, Oracle, flat file, and legacy systems.
• Established guidelines for the administration of the Dev, SIT, UAT, and Prod systems.

Confidential

Responsibilities:

• Developed standard processes to administer all aspects of Data Warehouse administration for a large user base.
• Conceived, developed, tested and implemented Excel based dashboard to perform aspects of Capacity Planning.
• Developed and delivered documents and standards in support of Reference Architecture, Data Models, SQL code, and data migration within the system development life cycle (SDLC)

Confidential

Sr. Teradata DBA Consultant

Responsibilities:

• Expert DBA skills in Teradata DBMS Administration, initial Teradata DBMS environment setup, development and production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
• Expert knowledge converting logical data models into Teradata physical database designs via ERWIN, system implementation, performance tuning, and support.
• Skilled in UNIX Shell scripting including Bash, Korn, system tuning and troubleshooting for network attached hosts. JCL for channel attached hosts, and Archive/Recovery using Tivoli Storage Manager.
• Skilled in IBM MVS mainframe environment using JCL, TSO, ISPF, IBM utilities, SAS.
• Skilled in large scale multi-terabyte initial data load, data migration, and ongoing update techniques, backup and recovery requirements, SQL, etc.
• Skilled in Windows 7, 2K, and XP environments with Microsoft Office Products, Word, Excel, Outlook, ERWIN, Business Objects, MicroStrategy, and Cognos client reporting tools.

Confidential

Sr. Application DBA Consultant

Responsibilities:

• Expert DBA skills in Teradata DBMS Administration, initial Teradata DBMS environment setup, development and production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
• Expert knowledge converting logical data models into Teradata physical database designs via ERWIN, system implementation, performance tuning, and support.
• Skilled in UNIX Shell scripting including Korn, Bash, system tuning and troubleshooting for network attached hosts. JCL for channel attached hosts, and Archive/Recovery using Tivoli Storage Manager.
• Skilled in IBM MVS mainframe environment using JCL, TSO, ISPF, IBM utilities, SAS.
• Skilled in large scale multi-terabyte initial data load, data migration, and ongoing update techniques, backup and recovery requirements, SQL, etc.

Confidential

Sr. DBA Consultant

Responsibilities:

• Expert DBA skills in Teradata DBMS Administration, initial Teradata DBMS environment setup, development and production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
• Expert knowledge converting logical data models into Teradata physical database designs via ERWIN, system implementation, performance tuning, and support.
• Skilled in UNIX Shell scripting including Korn, Bash, system tuning and troubleshooting for network attached hosts. JCL for channel attached hosts, and Archive/Recovery using Tivoli Storage Manager.
• Skilled in IBM MVS mainframe environment using JCL, TSO, ISPF, IBM utilities, SAS.
• Skilled in large scale multi-terabyte initial data load, data migration, and ongoing update techniques, backup and recovery requirements, SQL, etc.

Confidential

Sr. Consultant

Responsibilities:

• Expert DBA skills in Teradata DBMS Administration, initial Teradata DBMS environment setup, development and production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD, TPUMP, SQL, and TASM for workload management.
• Expert knowledge converting logical data models into Teradata physical database designs via ERWIN, system implementation, performance tuning, and support.
• Skilled in UNIX environments and standard tools such as VI, UNIX commands, utilities, shell scripting, etc.
• Skilled in IBM MVS mainframe environment using JCL, TSO, ISPF, IBM utilities, SAS.
• Skilled in large scale multi-terabyte initial data load, data migration, and ongoing update techniques, backup and recovery requirements, SQL, etc.

IT Ascent

Confidential, Los Angeles, CA

Responsibilities:

• Responsible for developing data warehouse architecture and physical implementation standards
• Designing, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain and enhance database performance using Teradata Manager, Performance Monitor, and TASM.
• Assist developers in tuning SQL and maintains appropriate Priority Scheduler profiles, allocation groups, and workloads.
• Work with ETL leads to formulate ETL approach and appropriate use of Teradata Tools and Utilities including Fastload, Multiload, TPump, and SQL Assistant.
• Provide ongoing support of the environment by developing processes and executing object migrations, security and access privilege definition, and performance monitoring.
• Responsible for runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
• UNIX Shell scripting including Korn, Bash, system tuning and troubleshooting for network attached hosts. JCL for channel attached hosts, and Archive/Recovery using Tivoli Storage Manager.

Confidential, Los Angeles, CA

Senior Technical Architect

Responsibilities:

• Responsible for developing data warehouse architecture and physical implementation standards
• Designing, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain the referential integrity of the database using Teradata Manager and Teradata Administrator.
• Assist developers in tuning SQL and maintains appropriate Priority Scheduler profiles.
• Work with ETL leads to formulate ETL approach and appropriate use of Teradata Tools and Utilities including Fastload, Multiload, TPump, and SQL Assistant.
• Provide ongoing support of the environment by developing processes and executing object migrations, security and access privilege setup, and performance monitoring.
• Drive planning and execution of hardware and software upgrades in support of expansion and implementation efforts.

Confidential, Redlands, CA

Enterprise Systems Design Consultant

Responsibilities:

• Designed, developed, and implemented enterprise storage solutions based on Storage Area Network (SAN), Network Accessible Storage (NAS) and direct-attached storage (DAS) from EMC, LSI Logic, IBM, Sun and HP for City of Burbank, Eastern Municipal Water District and Indiana Department of Environmental Management.
• Evaluated fat client and thin client capacity for LAN and WAN bandwidths as project deliverables in support of Alabama Gas, McLeod USA and Long Beach Water Department.
• Developed business continuity and disaster and recovery plan for Orange County, FL and the Orlando Utilities Commission.
• Analyzed business processes that developed logical data models and physical database designs for deployment using Erwin, Visio Enterprise and other documentation tools.
• Published white papers determining standards for system and network design, processor and memory performance, and storage solutions for direct attached and network accessible data stores.
• Achieved over 75% annual proposal win rate as key contributor on projects ranging from $500,000 to over $10 million.
• Led successful implementation teams of up to 30 people including cross-functional Confidential personnel and vendor and client representatives.

Confidential, El Segundo, CA

Enterprise Data Analyst

Responsibilities:

• Developed standards for the implementation of a data entry system in response to future electronic commerce needs.
• Analyzed user requirements, process models, and data standards to recommend data warehousing solutions.
• Developed a relational database management system workshop based on the Teradata RDBMS.
• Led a customer focus team in assisting a multimillion-dollar corporation in reengineering their manufacturing operation processes.
• Analyzed and implemented a client/server system design within the Oracle/Siebel CRM and Windows NT environment that provided the ability to fully integrate sales, marketing, and customer service functions.