Data Warehouse Architect Resume Samples

A Data Warehouse Architect is accountable for designing data warehouse solutions and also for working with conventional data warehouse technology. A well-written Data Warehouse Architect Resume describes the following duties and tasks – developing specific architecture as per the needs of the client; defining and implementing solutions; maintaining systems for keeping metadata, raw data and other data assets accessible and secure; undertaking data mining tasks, and determining best practices and delivering solutions to keep data versatile.

Employers prefer those possessing the following skills and abilities – familiarity with common technologies for data warehousing and ETL methodologies; experience in using Oracle and other similar resources; familiarity with J2EE, Cognos, and other programming languages such as Java and hands-on knowledge of specific tools. It is common to see on the resumes a degree or higher in the field of Computer Science or IT.

Data Warehouse Architect Resume example

Data Warehouse Architect Resume

Summary : Data modeling and data warehousing specialist with over 15 years of successful experience re-engineering enterprise business applications and databases. Good experience in Relational Database concepts, Entity relation diagrams. Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.

Skills : SQL, Analytics, Database Management, Project Management, Data Warehousing.

Description :

    1. Worked with the external vendor on the new architecture of the tables and screens and approved the design.
    2. Created the dimensional data warehouse model design, developed the ETL jobs loading the disposition codes tables from Pivotal into the Data Warehouse.
    3. Worked on the migration of the previous history into the new disposition codes tables for enabling full historical analysis.
    4. Gathered BI reporting requirements from the sales team, and worked with the BO designer to create the Business Objects universe.
    5. Ensured schedule compliance, generation and traceability for requirements, functional specs/tech design and code reviews, and test readiness.
    6. Used agile development, having a product backlog list and a scrum and prioritization process performed closely with the users.
    7. Worked with Clinical teams for assessment forms needed for Meaningful Use Stage 2 Working with clinical teams on Clinical Quality Measures (CQMs) .
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Master's In Computer


Data Warehouse Architect III Resume

Objective : A successful entrepreneur with a Masters in IT and experience in various technologies. Seeking a challenging position that can benefit from business savvy and strong technical background.

Skills : Oracle, Data Warehouse And Data Modeling, BI Reporting, ETL.

Description :

    1. Supported the Credit Risk project for the Enterprise Information Management (EIM).
    2. Performed the Data Modeling of the Credit Risk Staging tables to support Credit Risk Enhancements.
    3. Sourced over 30 application systems Designed and created over 600 staging tables.
    4. Designed and created the supporting ETL design documents.
    5. Streamlined and automated the EDW Stage 1 Build Procedures using Microsoft Excel, Access and Visual Basic methods.
    6. Wrote comprehensive documentation outlining and describing the Staging build methods and procedures.
    7. Created logical and physical data models for data warehouse and data mart implementation.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Master Of Business Administration


Data Warehouse Architect II Resume

Summary : Over 13 years of experience in Data Engineering and BI Systems Architecture and development, Data Analysis, Data Modeling and Technical Project Management. Extensive experience in translating business requirements and business needs into detailed project requirements, data models and system architecture integrating various data sources.

Skills : Information Technology, Informatica, Oracle, MS SQL Server, UNIX, Autosys, Control-M, ETL, Data Analysis, Databases, Data Mining, Data Warehousing.

Description :

    1. Integrated speciality loan servicing company consisting of experienced, skilled professionals using leading technology.
    2. Seterus is committed to partnering and supporting the government's efforts to stabilize the housing market like the Making Home Affordable (MHA) program which offers possible help to struggling borrowers to pay their mortgages.
    3. Definined future state architecture with ODS and EDW in scope.
    4. Participated in translation of the business requirements to define the structures of solutions and architectures and can include systems, applications, and process components.
    5. Authored comprehensive documentation and metadata supporting the data warehouse.
    6. Performed business analysis, data profiling and research to develop and validate the data warehouse model.
    7. Identificated and troubleshoot of data, ETL and design anomalies.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
M.S In Computer Science

Assistant Data Warehouse Architect Resume

Objective : Experienced ERP, Data Management, Data Warehouse, Data Mining and ETL Specialist with over 12 years of experience in high volume multiple database development, database design, modeling and management. Mr. Khan is an Expert Microstrategy Architect. Able to take out of the box Microstrategy and implement total BI Solution.

Skills : Oracle, Data Warehouse And Data Modeling, BI Reporting, ETL.

Description :

    1. Developed the entire data warehouse for merchandise application and managed growth.
    2. Consulted with businesses and led project teams in major Data Warehouse and Re-engineering initiative for Department of State.
    3. Worked with business line to gather the needs and translated them into a Data Warehouse solution.
    4. Provided technical expertise to resolve database related issues and design problems.
    5. Coordinated development tools support, implementation and resolution of information flow issues.
    6. Managed Data Warehouse production environment, monitored Data Warehouse processes and identified, researched and coordinated the resolution of data anomalies.
    7. Managed the metadata and trained end users on applications, resolving basic end-user questions and ensuring complete knowledge and understanding.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Arts In Spanish

Associate Data Warehouse Architect Resume

Headline : Extensive experience and knowledge in Data warehousing field. Strong ability to interact with technical, functional and business teams. Knowledge of Data Warehousing and data modeling concepts with strong analytical and diagnostic skills. Strong SQL experience and knowledge of relational databases. Deep knowledge and experience in Data Warehousing concepts and BI designing.

Skills : Data Warehouse Architect, Teradata DBA, Data Architect, Data Modeler.

Description :

    1. Developed Functional Requirements that describe what the system, process, or product/service must do in order to fulfill the business requirement(s).
    2. Developed test scenarios and tested cases for use in system and integration testing.
    3. Analyzed alignment of proposals to business strategies.
    4. Analyzed complex sets of data to identify quality issues and pro actively initiated steps for improvement.
    5. Involved in the design of ETL applications with ETL and BI architects.
    6. Created Tables and fields for customers in MDM data Manager.
    7. Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Arts In Liberal Arts

Assistant Data Warehouse Architect I Resume

Objective : Over 15 years of consecutive Information Technology experience on a wide variety of platforms, hardware, and operating systems across several industries as a senior technical management consultant. Performed master project scheduling, risk management, and Program Management Office (PMO) leader for a large international retail project.

Skills : Project Manager, Data Modeling

Description :

    1. Lead the Datawarehouse team in the methodologies and tools utilized in the deployment of the San Diego county IPTS datawarehouse.
    2. Architected the design of the Datawarehouse including dimensions, cubes, ETL process, job scheduling, and reporting queries.
    3. Designed logical as well as physical schemas for the IPTS OLTP and data warehouse using ERWin.
    4. Performed basic project management tasks including planning, estimating, status reporting and scope management.
    5. Met with vendors and aided the negations as well as 3rd party tool selections as well as licenses for databases and hardware configurations.
    6. Mentored and trained project team members in the implementation and use of latest datawarehouse tools and methodologies including Oracle10g, Oracle Warehouse Builder, and various reporting tools.
    7. Worked with business users to define user requirements and business rules.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
BS In Pre

Associate Data Warehouse Architect I Resume

Summary : Eleven years of IT experience in business analysis, system analysis, ETL/Data architecture and implementing BI Reporting solutions. Possess very strong experience in design, manage and support of complex, massive Data warehouses. Eleven years of experience in Database design, ETL Strategy design and implementing Data warehouses/Data Marts by extracting/transforming data from Oracle/Teradata/DB2/SAP/MQ Series and JMS Messages/Mainframe Legacy Systems using Informatica/SSIS/Teradata Utilities (Mload, Fast load, Tpump BTEQ, TPT) .

Skills : Data Architect, Big Data, SQL SERVER, ORACLE, DB2.

Description :

    1. Interacted with the business users, other stake holders and understanding the functional reporting and analytic needs of the customers.
    2. Designed logical and physical database model using Erwin from high level functional, business, reporting and data mining needs.
    3. Created Semantic, logical and physical database models, creating Metadata, views, indexes, Join Indexes, Aggregate Join Indexes and related database structures using Erwin.
    4. Analyzed the functional needs for BI and Data Analytics, interacting with Source SME's to capture business rules and data transformation roles.
    5. Prepared High level solution and data flow design based on Functional and Reporting requirements.
    6. Captured business logic and Managing Metadata using GORMIT tool to meet Enterprise Metadata data needs.
    7. Successfully analyzed and implemented data analysis that enabled an ever-changing data management environment.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Arts In Political Science

Data Warehouse Architect/Developer Resume

Summary : Strong fundamental understanding in a variety of software development methodologies (RAD, Agile, Scrum, SDLC - PMI) and their capabilities, quality assurance, object-oriented techniques using various tools and languages. Managed projects, cost-benefit analysis, proposal development, presentation, system demonstration personnel and logistics to meet short and long-range goals utilizing project management tools.

Skills : SSAS, SSRS, SSIS, Microsoft Sql Server, Tableau, QlikView, OBIEE.

Description :

    1. Implemented the processes and procedures in support of data mart/data warehouse performance tuning, optimization, backup, and recovery, operation manuals, checklists, change management, change control, and data governance documentation.
    2. Established, monitored and supported DSS guidelines and best practices that should be used for Data Mart enhancements and projects.
    3. Established and implemented a Meta Data strategy and infrastructure and provide on-going support of the Meta data infrastructure and repository.
    4. Established auditing procedures to ensure data integrity to our daily and monthly load processing, exception reporting, error logging, and data clean up requests, code migrations and look-up table maintenance for various sources and data warehouse.
    5. Responsible for data analysis, design and implementation to build operational data store (ODS), OLAP, EDW, data warehouse and data marts.
    6. Provided the data modeling, analysis, and functional documents.
    7. Developed transformations using Informatica ETL tool for data extraction, cleansing and loading process to maintain the data quality clean, combine, transform, archive, eliminate duplications and refresh the production database.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Computer Science

Data Warehouse Architect/Manager Resume

Headline : Over 16 The epicenter of expertise: Data Warehouse Architecture and Database Administration. System level expertise SAS Administration, Informatica Administration, VMware/Citrix Administration, Windows/Unix Administration. Applications level expertise: Business Intelligence and Data Warehousing. Knowledge transfer expertise: Instructor with excellent communication skills.

Skills : Data Warehouse Architect, Database Administration, Informatica Administration, SAS Administration, Oracle DBA, Sql Server DBA.

Description :

    1. Led a team of developers and also worked as the DW administrator; working closely with our principal, the two of us built the DW architecture.
    2. Met with the team on a weekly basis and discussed progress, risks, and potential pitfalls.
    3. Supervised and performed quality review of junior level DBA's to ensure success of all operations.
    4. Managed all aspects of the technical implementation.
    5. Worked closely with development and support staff, customers, business subject matter experts and business partners to gather requirements and translate them into technical designs.
    6. Assisted in translating business requirements to report specifications.
    7. Took the lead in instilling best practices into our development environment.
    8. Established procedures and guidelines for the design, development, and administration of the warehouse.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Master Of Science

Data Warehouse Architect Resume

Summary : Highly qualified Data Warehouse Architect with experience in the industry. Enjoy creative problem solving and getting exposure on multiple projects, and would excel in the collaborative environment on which your company prides itself.

Skills : Data Warehouse, Stored Procedures, Data Modeling, Requirements Analysis, Data Architecture, ERwin, ER/Studio, Microsoft SQL Server, Oracle, Database Architecture.

Description :

    1. Worked with the Enterprise Data warehouse team as Data warehouse architect Established Data Architecture to create BI, ETL Standards and Procedures to meet Business Unit's needs.
    2. Responsible for Requirements gathering, analysis, Design and Development of Star schema/Data Mart using ER/Studio.
    3. Responsible for creating LOE for the overall project.
    4. Responsible for Data profiling/Data Analysis, Data Governance and Data Cleansing.
    5. Worked on Data Mapping - Source to Target (Multiple Source to Target) Designed/developed ETL data load in to data warehouse from various sources using SQL Server/SSIS and performance tuning of ETL jobs.
    6. Worked on Meta Data Management for the Enterprise Data warehousing project.
    7. Designed and developed Business Objects Universe and reports using Webi reports.
    8. Provide troubleshooting and consulting services to the project team members.
    9. Responsible for Define and enforce common Data warehouse best practices.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Master Of Computer Applications