Data Architect with 10 years of data warehouse design experience. Summary Of Skills Self-motivated team player with excellent communication and problem solving skills. Strong leader with experience mentoring development teams. Comfortable leading meetings with executive customers to gathering requirements. Experienced in generating specifications and documentation. Data Architecture 10 years of experience in multi-terabyte dimensional warehouse and normal form relational enterprise systems architecture with both ERwin and Embarcadero tools. Involved in all phases of data warehouse development lifecycle, from gathering requirements and modeling architecture to development, testing, implementation, and support. Experienced with the design of data architectures for big data systems and star schema Kimball methodology warehouses. Developed incremental data loads using Change Data Capture. Data Platforms Worked with almost every major ETL tool including IBM Datastage and Informatica. Experience designing objects in Oracle 11g, SQL Server, and the HP Vertica big data platform. Comfortable with database administration and the creation and modification of objects including views, tables, stored procedures, sequences, triggers, indexes, and constraints in the warehouse. Highly advanced query writing skills in PL/SQL and T-SQL. Perl and UNIX Shell Scripting Comfortable in a UNIX environment and experienced in writing shell scripts for BASH and Korn shells on Solaris, AIX, and Linux. I am an advanced Perl developer. Work experience Data Architect Confidential Data Warehouse and Enterprise Data Architect for large corporate restaurant brand. Managed end to end design of data structures for Pizza Hut's multi-terabyte HP Vertica warehouse and SQL server enterprise systems. Gathered business requirements and authored technical specs for the development of star schema, big data, and relational data storage structures. Created data models and documentation for the data warehouse and managed the Embarcadero model repository. Served in the Lead Architect role in the implementation of a Tibco MDM solution for management of customer data. Designed data structures to integrate cleansed and enriched MDM data into the Vertica warehouse for use with Microstrategy and Tableau reporting solutions. Used Facebook data sources to enrich customer data mart records. Participated in Agile Scrum development teams. Provided guidance for the implementation of a metadata management solution. Performed Enterprise Data Architecture and DBA duties in SQL Server environments. Data Architect Confidential Data Warehouse and Enterprise Data Architect for the financial division of General Motors. Responsible for gathering requirements, designing dimensional and normal form relational data architecture. Wrote ETL specifications and technical requirements for Informatica ETL development. Interfaced with high level business users to design data marts for credit scoring, leasing, auto loans, commercial lending, and securitization of assets. Performed troubleshooting of data loading problems in Oracle and Informatica. Designed data models in ERwin and implemented naming and table design standards. Designed and documented XML schemas to meet departmental standards. Created DDL for database objects such as tables, views, and indexes. Completed Data Vault 2.0 training which included data modeling for Data Vault, Agile data warehouse development methodologies, and Integrating Hadoop Big Data/NoSQL solutions into the data warehouse architecture through the use of MapReduce and Hive. Designed Data Vault marts with hashed key architecture compatible with Big Data NoSQL environments that share nothing . Business Intelligence Architect / ETL Developer Confidential Responsible for the architectural design, ETL design, development, and support of many multi-terabyte Oracle EPM data warehouses. Designed star schema fact and dimension tables and implemented custom data marts to deliver a PeopleSoft data reporting solution for multiple remote campuses in the University of Texas System using IBM Infosphere Datastage. Managed data lineage and metadata. Implemented incremental Change Data Capture load designs for UT Arlington data which resulted in a 400 faster nightly data load. Performed code reviews and migrations. Established naming and development standards. Participated in the interview and hiring process. Mentored and trained new developers. ETL Developer Confidential ETL Developer and Application Support Manager for various data warehouse projects at SUNY University at Buffalo using Oracle Warehouse Builder, SSIS, ERwin and other tools. Developed data architecture and ETL maps using Kimball methodology star schema dimensional modeling. Also developed a data in normalized data warehouse. Performed architectural duties including the design of fact and dimension tables. Authored technical requirement and spec documents. Standardized column names and data types. Performed impact analysis of changes to the data warehouse.