- Featured in:
-
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 Consultant Resume Samples
No results found
Candidate Info
years in workforce
years at this job
Mathematics
Mathematics And Computer Science
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
years in workforce
years at this job
Mechanical Engineering
Physics
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
years in workforce
months at this job
Electronics Engineering
Electronics Engineering
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
years in workforce
months at this job
Electronics And Communications Engineering
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.