- Featured in:
-
More Data Warehouse Consultant Resumes
Use these Data Warehouse Consultant samples as a guideline or visit our extensive library of customizable resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Inventory Management Resume Samples
Data Warehouse Consultant Resume Samples
No results found
0-5 years of experience
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.
10+ years of experience
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.
0-5 years of experience
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
0-5 years of experience
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.
Inventory Management Cover Letter Examples
Rate This Article
[Data Warehouse Consultant]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
