Data Warehouse Architect Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

Data Warehouse Architects work in large companies and are responsible for tasks such as collaborating with system designers, providing support to end users, analyzing data, designing databases, and modeling and migrating data. Required skills include data analysis expertise, teamwork, communication and presentation abilities, time management, and organizational skills. Eligible resume samples make display of computer proficiency. Based on our collection of example resumes, Data Warehouse Architects should hold a Bachelor's Degree in computer science or information technology.

Find out what is the best resume for you in our Ultimate Resume Format Guide.

1

Team Lead\data Warehouse Architect

Pioneered successful cutting edge technologies, development processes and standards in an environment resistant to change.

  • Streamlined the operational processes to be more efficient and cost effective (i.e. reduced the costs of tape backups by 90%).
  • Regularly advised and consulted with other teams at the University and other Universities.
  • Lead team of twelve people. Duties include hiring new employees, developing employees and evaluating the performance of employees.
  • Designed dimensional models and developed ETL solutions (included data from Student, Finance, HR, Library and Research Systems).
  • Core technologies include: Cognos (Framework, Cube, Report and Data Manager), Microsoft SQL Server (Database, SSIS and SSAS), and SharePoint.
Candidate Info
13
years in
workforce
3
years
at this job
BS
Bachelor of Science
MBA
Business
2

Data Warehouse Architect

As Data warehouse Architect the various Data marts built and worked on enabled easy access to months of customer, product and financial data to the Credit Suisse business users. The Data Warehouse was more than 1 Terabyte in size and features powerful analytical tools, flexible reporting capabilities and leverages the corporation's authoritative sources of information. It accessed the log files generated from the web servers.

  • One of the architects of Credit Suisse's enterprise wide customer profitability Data warehouse. Worked on this project from inception. Conceived, designed, developed and implemented the data warehouse solution from scratch.
  • Managed the complete project with a team size of over 25 persons.
  • Analyzed the existing systems and the business user requirements for tactical and strategic needs.
  • Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing the data.
  • Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation
  • Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results.
Candidate Info
13
years in
workforce
5
years
at this job
3

Data Warehouse Architect

Designed the dimensional star schema for a large-scale warranty data warehouse and implemented the ETL process in SQL Server 2000's DTS technology; implemented (Kimball "type-2") dimensional history to provide audit trail of dimensional changes.

  • Supported Business Objects Universe for data warehouse analytical reporting.
  • Introduced design standards for ETL processes to enhance audit and support capability.
  • Led design sessions with analytical users to streamline previous requirements process.
  • Recommended process improvement for internal design methodology to facilitate Rapid Development.
  • Evaluated SQL Server 2005 and formulated migration plan for ongoing data warehouse development.
Candidate Info
14
years in
workforce
2
years
at this job
Business Information Systems
4

Data Warehouse Architect Team Lead

Architect / Team Lead for a 7 person offshore Informatica ETL data team for EDW data integration.

  • Mapped multiple ETL sets and coordinated all team development into sharable, non-redundant maps.
  • Created Enterprise Data Warehouse architecture and standards, plus trained two architects in dimensional modeling and data quality; created shared Master Data sets and data models for Business Objects in an Oracle Financials ERP BCNF (inventory control) including Requisitions, PO, AP, and GL
  • Mentored DA's on dimensional models, SCD's, MDM, standards - resolved multiple issues
  • Worked with business users to analyze requirements, standards, presentations and documents
  • Environment: Oracle 10g, ER/Studio, TOAD, Informatica 8.6, SQL Developer, Business Objects
Candidate Info
50
years in
workforce
6
months
at this job
BA
English / Psychology
MA
Linguistics
MA
Warehouse And Systems Engineering For 6
5

Data Warehouse Architect

DB2 UDB V8.2, MS SQL Server 2000, MS Window, ERwin Environment

  • Designed and created a data warehouse model using ERwin for sales transaction analysis to identify profitable region, restaurant, location, product, promotion, and minimize expense.
  • Supported production application, troubleshooted DB2 & MS SQL Server stored
  • Created source, target, and process models to load data with DB2 Data warehouse Center
  • Created Cognos reports
Candidate Info
15
years in
workforce
7
months
at this job
BBA
Computer Systems
MS
Computer Methodology
6

Senior Data Warehouse Architect

Tuned and solved problems in Oracle 10g databases and many SQL statements for a data warehouse project.

  • Supported Discoverant applications and automated conversion and migration operations with Korn shell scripts on Solaris 10.
  • Designed, tested and benchmarked the production database system.
  • Fully documented project database administration and designs for the system.
  • Performed all DBA functions using Toad and SQLPlus for DSS type databases.
Candidate Info
11
years in
workforce
7
months
at this job
BS
Computer Science
PhD
Technical Management
MBA
Project Management
7

Project Leader, Data Warehouse Architect

Project leader - Led project, working with executives, management, and IT staff.

  • Data Warehouse Architecture Consultant - Designed the Enterprise Data Warehouse and dimensional Data Marts.
  • Established Data Management, Governance, and Metadata processes/standards.
  • Established Data Administration function including Data Governance.
  • Created a common objects and data reuse strategy.
  • Mentored client data modeling staff, including teaching data modeling classes.
  • Supply Chain - Analyzed, designed, and modeled mfg. supply chains.
  • Database Consolidation- Consolidated 18 different DMBS platforms into 4.
Candidate Info
13
years in
workforce
3
years
at this job
BA
Business Administration
8

Data Warehouse Architect

Created a flexible data model design that was scalable and reusable, while at the same time emphasizing performance and the enterprise's business needs. Played an active role in the design of ETL process(s) to load data from source to staging, foundation and presentation layers of the DW.

  • Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts.
  • Translated business requirements into design and technical specifications for implementation.
  • Collaborated with business analysts and offshore developers toward the implementation of changes, and worked with Quality Assurance (QA), and change management teams for IT releases to the data warehouse.
  • Engaged in data analysis, technical design, documenting, coding, unit testing, deployment and maintenance of various data load modules.
  • Provided technical design overviews for the DW setup, and participated in technical reviews for IT related implementations.
  • Delivered key support to multiple IT teams and business users, and created and maintained technical and application support documentation.
  • Extracted data from IT systems created 20 years prior and without referential integrity, overcoming issues with extensive source data analysis as well as agreements on data extraction and usage rules with source system teams by having an interface control document in place.
Candidate Info
21
years in
workforce
2
years
at this job
BA
Business And Financial Accounting
9

Data Warehouse Architect

Analyzed, identified and documented data mapping between source, stage and destination repositories.

  • Designed reporting ODS, staging area and data marts for each Line of Business (total of 5) to deliver Enterprise Data Warehouse (EDW)
  • Designed DTS packages between FileNet P8 system and SQL Server 2000 to provide data validation, scrubbing, aggregation and transformation. Coded data cleansing logic utilizing regular expressions.
  • Created enterprise reporting solution utilizing SQL Reporting Services 2000, T-SQL and MDX.
  • Implemented security, scheduling and maintenance plans for the DTS packages and reports.
  • Stress tested designed framework under full processing load, provided documentation and knowledge transfer to a client's BI team.
  • Technologies: SQL Server 2000, Analysis Services 2000, EDW Kimball Method, T-SQL, MDX, FileNet P8 Platform, SSRS 2000 (VS.NET 2003), Visual Basic 6.0, VBA, SSAS 2005, SSIS, SSRS, EDW Kimball Method, MDX, .NET Framework, UML/Visio, TFS, SQL Profiler/Performance Monitor.
Candidate Info
8
years in
workforce
1
year
at this job
MA
Electronics Engineering
10

Data Warehouse Architect

Responsible for a first-generation data warehouse (DW) from 1993 to 1999, including DW modeling, analysis, data quality, user support, ETL development, production support, and user reporting.

  • Converted from Teradata to Informix, with re-write of all DW ETL processes
  • Supported IQ Software report tool and created user semantic layer
  • Headed the DW User Group and managed all user interactions and requirements
  • Managed relationships with multiple business partners: Sales, Marketing, Accounting, Compliance, H/R, and Capital Markets (Fixed Income, Municipals, Equities, Research)
  • Coordinated the orderly application retirement and transfer of functionality to EDW
  • Designed, developed, and supported two applications: Syndicate Index for public offering trade analysis; and Money Market Preferred, a commission accounting application
  • Architected the Sector Market Analysis & Report Tool (SMART) for transmitting, storing, and displaying bond offerings and for providing a pricing database for swap analysis
Candidate Info
17
years in
workforce
6
years
at this job
BS
Mathematics

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!