Data Warehouse Consultant 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 Consultants transform data into business information through data modeling techniques. Eligible example resumes in the field mention duties such as collecting data, managing data models, enhancing logical models, filtering data, solving code issues, and training staff on data modeling. Qualifications like knowledge of business processes, being able to use data modeling tools, analytical thinking, decision making, and attention to details are often seen on Data Warehouse Consultant resumes. Most successful candidates hold a degree in IT, computer science, of software engineering.

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

1

Database/data Warehouse Consultant

Database design and development for a highly visible project for Microsoft/ Yahoo internet behavior analysis.

  • Design and implementation of Data Warehouse ETL procedures using SSIS to process data from multiple sources for a multi-terabyte database.
  • Created a number of stored procedures and SQL queries to analyze user behavior trends.
  • Tuned SQL, identified and resolved bottlenecks.
  • Trained data analysts on database fundamentals and SQL best practices.
Candidate Info
19
years in
workforce
2
years
at this job
BS
Mathematics
MS
Mathematics And Computer Science
2

Data Warehouse Consultant

Spearheaded projects to design, develop and implement data warehouse tasks for areas such as mortgage consumer lending, auto finance, risk management, retail banking and wealth management systems.

  • Handled analysis and reporting modules using SAS
  • Managed data quality, profiling and governance tasks
  • Hands on as well as sound knowledge of UDB, extensive SQL, PL SQL, DB physical modeling, Data analysis
  • Defined the architecture and the various phases to create the data warehouse.
  • Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation.
  • Created multi-dimensional data model (STAR Schema) and enhanced it to meet growing requirements.
  • Interacted with business users on regular basis to consolidate and analyze the requirements and presented them with design results.
Candidate Info
19
years in
workforce
13
years
at this job
BA
Mechanical Engineering
BS
Physics
3

Data Warehouse Consultant

Involved in executing a POC for Blue Cross Blue Shield of Kansas City to exchange Data between LACIE (Health Information Exchange) and [company name] to receive member Medical Record/Encounter information.

  • Acting as a Blue Cross and Blue Shield data specialist, I interviewed business stakeholders and the Health Information Exchange (HIE) vendor to define the scope and the success criteria of the Clinical Data Integration Proof of Concept
  • Worked with HIE Vendor to define the data transfer protocol (vendor data hosted in AWS) and the data fields which would be exchanged
  • Created interface specifications and the data mapping documents for both incoming and outgoing data feeds to LACIE (HIE)
  • Analyzed the Data Dictionary/Model to identify the data items required for matching with providers' data feeds. Created SQL scripts to extract the data and automate it through DataStage
  • Created DataStage Jobs to parse the HL7 data (ORU Messages) in XML format using the XML and Web Services Pack
  • Profiled incoming lab and vitals data for cardinality and data quality using Information Analyzer
  • Created sequences to automate the DataStage jobs
Candidate Info
13
years in
workforce
6
months
at this job
MS
Electronics Engineering
Electronics Engineering
4

Data Warehouse Consultant

Data warehouse / Data Mart Engineer

  • Joined the team as support team player for Data mart (SQL Server) primarily responsible for creating ETL solutions using Informatica. However, given my broader breadth of domain Knowledge, lead the deliverables related to Data warehouse (Netezza), lead the design and development of BI reports, creating dashboards, KPI driven metrics etc.
  • Directly worked with business teams across Finance Organization in gathering business requirements, writing technical specifications, driving and participating peer reviews, supporting testing cycles to ensure data accuracy and data integrity.
  • Leveraged my previous experience and created POC on Apache Spark and made it a candidate to replace the traditional ETL process for non-relational data sources and also to replace the cold/archive storage needs of Data warehouse.
  • Worked with leadership team in determining project priorities, creating project related artifacts, manage defects, produce deliverables in agile iteration model.
Candidate Info
7
years in
workforce
9
months
at this job
BS
Electronics And Communications Engineering

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!