About Me
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 exper...
Show MoreSkills
Portfolio Projects
Description
Art provided 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.
Show More Show LessDescription
Art provided 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.
Show More Show LessDescription
Art provided 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.
Show More Show LessDescription
Art was responsible for all aspects of database administration for a Teradata Data Warehouse. Forty percent of duties involved consulting with users of the Data Warehouse.
- 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)
Description
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.
Performance tune SQL and maintain appropriate Priority Scheduler profiles, allocation groups, and workloads.
Show More Show LessDescription
- 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.