Data Warehouse Consultant Resume Sample
Annamarie Smith
78329 Christiansen Hill,
Houston,
TX
+1 (555) 444 8059
Work Experience
Data Warehouse Consultant
05/2017
-
PRESENT
Phoenix, AZ
- Demonstrates excellent customer service to users and partners
- Develop user communications for analytic platforms data warehouses, applications and systems
- Provides business knowledge regarding the appropriate use of data elements and cooperates with existing business processes
- Performs strategic data analysis (data mining) and research as appropriate to support business needs (e.g., revenue management, claim processes/reporting, member and program eligibility, etc.)
- Support and monitor ETL jobs
- Is able to work with business data owners to understand and coach them on their data quality needs and translate them into Data Quality Rules to ingest into the Data Quality HUB
- Has a strong understanding of enterprise data management frameworks to be able to find the root cause of the data issue
- Has Experience to strongly influence upstream source system(s) to correct data issues where he root cause of the data issue exists
- Knows how to acquire, profile and blend data from multiple systems for exploration and analysis
BI Data Warehouse Consultant
04/2012
-
12/2016
Chicago, IL
- Knows how to perform data quality rule checks to identify quality gaps in applicable dimensions based on intended use
- Has a good understanding of how to automate proper system checks and balances (i.e. balance/controls, threshold checks, and upstream business rule changes)
- Experience with data quality dashboards, perform iterative reviews with customers to drill into root causes of data errors upstream and solve them
- Integrate new data sources in collaboration with study team members, other analysts, IT and external data suppliers
- Has the ability to communicate synthesized data quality findings to business and technical team members, senior leaders and external stakeholders
- Research and recommend new innovative methods and systems to manage data for business improvement
- Related experience; or any combination of education and experience, which would provide an equivalent background
- Strong co-ordination and business communication skills to handle complex business situations
Education
University of Georgia
2007 - 2012
Bachelor's Degree in Data Analytics
Professional Skills
- Excellent analytical, problem-solving and PC skills required
- Strong Communication, analytical and interpersonal skills at all levels
- Demonstrated experience developing measurement, business intelligence, and data warehousing solutions
- Strong modeling experience required (data vault integration layer)
- Hands-on programming and database design skills (primarily SQL and stored procedures)
- Teradata experience strongly desired
- Unix experience strongly desired
How to write Data Warehouse Consultant Resume
Data Warehouse Consultant role is responsible for database, design, software, integration, security, java, architecture, reporting, research, modeling.
To write great resume for data warehouse consultant job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Data Warehouse Consultant Resume
The section contact information is important in your data warehouse consultant resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Data Warehouse Consultant Resume
The section work experience is an essential part of your data warehouse consultant resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous data warehouse consultant responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular data warehouse consultant position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Data Warehouse Consultant resume experience can include:
- Creates objects in Relational Database and proficient in building moderate/complex SQL for data validation, manipulation and reporting
- Good SQL knowledge allowing to independently develop and optimize SQL code for data warehousing applications
- Expert Database programming and performance tuning experience required
- Experience using ERWin for data modeling
- Experience in re-architecting existing systems to an enterprise ready solutions
- Strong understanding of data warehouse concepts and architecture
Education on a Data Warehouse Consultant Resume
Make sure to make education a priority on your data warehouse consultant resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your data warehouse consultant experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Data Warehouse Consultant Resume
When listing skills on your data warehouse consultant resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical data warehouse consultant skills:
- Strong Strong technical writing skills
- Uses excellent communication and interpersonal skills to build lasting working relationships
- Healthcare experience strongly desired
- Strong Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities
- Working Experience in ETL Tools like DataStage, Informatica and procedures including PL/SQL
- Extensive hands-on experience in architecting, configuring and implementing Data Warehouse solutions for a large group or organization
List of Typical Experience For a Data Warehouse Consultant Resume
1
Experience For Data Warehouse Consultant ETL Islamabad Resume
- Experience in the healthcare services industry
- Minimal 2 years of experience in DWH projects
- Experience with healthcare administration platforms and EMR systems (Facets, NextGen, Cerner, etc.)
- System build and maintenance experience required
- Demonstrated Leadership – can help to mentor and lead a group of DW professionals
- Pharmacy data experience nice to have
- WhereScape experience a nice to have
2
Experience For R&D Data Warehouse Consultant Resume
- DataVault experience a nice to have
- Lift / carry by hand freight weighing up to 50 pounds several times a week
- Able to push/pull up to 75 lbs using mechanical aids, such as hand trucks, barrel dollies, hydraulic lifts, etc
- Exposure to various operating systems – UNIX, Linux, Windows
- Works closely with IBM Tivoli Work Load Scheduler (TWS) team to automate/schedule various jobs taking in account complex systems interdependencies
- Documents ETL processes & solutions by following the company standards for Support and Production Release
3
Experience For BI Data Warehouse Consultant Resume
- Working with end users/customers to understand and develop requirements for technical solutions to meet business needs
- Working with technical developers to strategize solutions to align with business requirements
- Administering SAS in a Unix/Linux environment
- Working knowledge of relational databases/database structures
- Developing test data and test scenarios
- Knowledge of commonly-used concepts, practices, and procedures within data architecture, reporting, analytics and visualization
- Checks, verifies and pulls freight for customer needs,
- Perform daily inspections of appropriate motorized and manual equipment, including but not limited to: liftgate, pallet jack and hand truck, radio frequency scanners and printers
- Operate warehouse machinery in accordance with established safety procedures as needed to maintain the warehouse stock
4
Experience For Data Warehouse Consultant Resume
- Comply with hazardous material regulations and procedures
- Assist in maintaining a clean, organized warehouse environment at all times Comply with all applicable laws / regulations, as well as company policies / procedures
- Utilizes a hypothesis-driven problem-solving approach to design, construct, and rapidly test/iterate exploratory data-mining analyses to reveal insight across the Client portfolio
- Compiles data from various sources into a single, consumable, data set, including design and implementation of data cubes
- Proficiency with sophisticated analytics tools and programming languages (e.g., R, Python, SQL, HiveQL) and visualization platforms (Webfocus, Tableau etc)
5
Experience For Data Warehouse Consultant ETL Islamabad Resume
- Interprets and communicates insights to product, service and business management
- Work with large, complex data sets across multiple platforms and design efficient processes to provide accurate and timely information
- Conducts / participates in the design to architect, administer and support mission in highly challenged healthcare IT environment
- Participate and/or take lead on all architecture, development and deployment in different Data warehouse implementations
- Knowledge of Relational Database Management System (RDMS) principles
- Assess organizational needs and work with others in a team-oriented culture
- Writes and revises system and program design procedures, test procedures and quality standards
6
Experience For R&D Data Warehouse Consultant Resume
- Uses Scrum Agile methodology and Scaled Agile Framework (SAFe) to maximize the productivity and ensure quality
- Works in all phases of Software Development Life Cycle (SDLC) such as Requirements Gathering, Design, Development, All Testing (Unit, Integration, Regression, and User Acceptance), Production Deployment, and Support
- Collaborates closely with stakeholders and groups (Billing, Product, Settlement, Customer, Accounting, Finance, File Transfer, and Support) to understand, refine and translate the business requirements into technical specifications
- Builds Extract-Transform-Load (ETL) solutions for Data Integration and Data Warehousing (DW) using IBM InfoSphere DataStage (Designer, Director and Administrator) for wide variety of source and target formats (Mainframe, DB2, Oracle, Exadata, MS SQL Server, SalesForce Web API, XML, MQ, Hadoop)
- Technical business analyst experience in a data warehouse project environment
- Recent Teradata experience
- Experience with Requirements Traceability
7
Experience For BI Data Warehouse Consultant Resume
- Assists Solution Architects in designing and estimating solutions as necessary
- Deeply understands and adequately applies DW Dimensional Modelling techniques such as Star, Snow-Flake and Data Vault
- Serves as mentor to other team members of development team
- Assists Production Support in triaging various problems by doing root cause analysis and resolving the issue in timely manner to minimize impact to systems/environment
- Uses change requests (CRs) to release the code to production without negatively impacting or disrupting workflow, systems, and end users
- Self-starter that can carry out a given project / task with little or no assistance
- Complete inventory of all Agency data sources and business processes from an IT perspective
- Review the data warehouse infrastructure design and offer solutions
8
Experience For Data Warehouse Consultant Resume
- Review the MMIS infrastructure design and offer suggestions and insight to vendor
- Review the infrastructure designs of MES components and analyze the impact of each on the data warehouse solution
- Assist with the review of all technical specifications and design documents associated the data warehouse solution
- Review and test the integration of data in the data warehouse/data marts and Business Intelligence solutions
- Communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector
9
Experience For Data Warehouse Consultant ETL Islamabad Resume
- Experience with Medicaid, Medicare or other health systems
- Prepare and document Functional and Technical Specifications for reporting and data mart work. Assist with business data mart/intelligence support and enhancements
- Assist in deployment and management of end-user reporting tools and platforms. Work with IT and business project teams to understand reporting and data mart requirements and propose solutions. Document and provide knowledge transfer to the rest of the Enterprise Data Management Team for all solutions
- Familiar with relational database concepts, and client-server concepts. Relies on experience and judgment to plan and accomplish goals
- Experience with RDBMS platforms (Oracle, MS SQL Server, DB2) Required 10 Years
- Instructs, directs, and reviews work of the development team and less experienced analysts
- Familiar with Agile/Scrum Development Life Cycle
10
Experience For R&D Data Warehouse Consultant Resume
- Ensures that data definitions are clear and current, and communicates changes to data definitions to all users
- Analyze complex business user needs
- Documents information requirements (data flow diagrams, functional requirements, etc.)
- Experience in data analysis, data modeling, and working with automated data warehouse systems, or any combination of education and experience, which would provide an equivalent background
- Medical and Specialty Claims
- Experience with database systems such as Teradata, Oracle or MSSQL in similar position (ETL development, stored procedures development, DDL scripts, DML scripts)
- Good knowledge of SQL (use of store procedures, use of functions and operators)
- Basic knowledge of data warehouse and analytical solutions
List of Typical Skills For a Data Warehouse Consultant Resume
1
Skills For Data Warehouse Consultant ETL Islamabad Resume
- Working experience with Relational Databases (mainly : Oracle, MS SQL, Teradata)
- Experience using ERWin for data modeling Highly desired
- Sufficient experience with UNIX, working with OS, developing shell scripts
- Experience using Teradata Utilities Highly desired
- Experience with implementing SAS/Teradata interfaces Highly desired
- Evaluate complex situations using multiple sources of information: filter, validate and interpret dynamic material
- Expert SQL coding experience required
- Experience with advanced reporting and analytics
- Experience working with IT and business customers
2
Skills For R&D Data Warehouse Consultant Resume
- Hands-on experience in designing solutions with end user self-service as the primary focus
- Excellent spoken, listening and written communication at various levels of the business
- Experience with Medicaid, Medicare or other health systems Required 5 Years
- Years technical business analyst experience in a data warehouse project environment Required 5 Years
- Recent Teradata experience Required 5 Years
3
Skills For BI Data Warehouse Consultant Resume
- Business Analyst experience in a state government environment Highly desired
- Experience with Teradata SQL Assistant Highly desired
- Open Text BI Query experience Highly desired
- Experience in data analysis
- Experience with quality assurance and testing in a relational database environment
- Experience designing data management processes and standards for metadata management, data architecture, data quality, and data security
4
Skills For Data Warehouse Consultant Resume
- Experience with ETL and ELT
- Experience in the implementation of end user analytical toolsets
- Strong data warehouse modeling expertise (i.e. integrated model, and star/snowflake schema data model)
- Experience using Teradata Utilities
- Experience with implementing SAS/Teradata interfaces
- Experience with data warehousing design/development (ties to HCM/Financial desired)
- Experience with database programming (TSQL, PL/SQL, BTEQ)
- Strong understanding of SQL Server database architecture
- Full life cycle experience in all aspects of Business Intelligence and Data Warehousing
5
Skills For Data Warehouse Consultant ETL Islamabad Resume
- Experience working with SQL Server 2008R2/2012/2014/2016, T-SQL scripts and stored procedures
- Extensive experience with complex joins, sub-queries, building temp tables, cursors, set-based operations, and data manipulation
- Experience with Oracle relational Databases, Data Warehouses, Data Modeling, and Star Schema design
- Experience with BI reporting tools
- Experience with SAS In-Database processing with Teradata
- Five (5) years of demonstrated success in multidisciplinary roles in complex data warehouse, business intelligence or measurement projects
- Five (5) years of demonstrated knowledge of Agile DW/BI development practices
6
Skills For R&D Data Warehouse Consultant Resume
- Experience with multi-database environment development
- Experience with ANSI standard database environment development (DB2/Oracle/Teradata)
- Experience with metadata solution development
- Understanding of data modeling and design including partition, indexing, constraints and optimizer statistics
- Facilitating customer requirements gathering meetings/sessions/JAD Sessions Required 5 Years
- Working with end users/customers to understand and develop requirements for technical solutions to meet business needs Required 5 Years
- Administering SAS in a Unix/Linux environment Required 5 Years
- Working knowledge of relational databases/database structures Required 5 Years
- Developing test data and test scenarios Required 5 Years
7
Skills For BI Data Warehouse Consultant Resume
- Partnering with internal and external business clients and IT to fulfill information needs and support business decisions
- Understanding concept of 3rd Normal Form
- Utilizing Agile methodologies for DW/BI solutions
- Understanding of star/snowflake schema design; dimension and fact tables
- Works on programming using UNIX shell scripting to enhance ETL solutions
- Years analyzing project requirements and developing detailed technical specifications Required 5 Years
- Design applications taking into consideration data reconciliation, query/reporting performance, and analytical business value. Highly desired
8
Skills For Data Warehouse Consultant Resume
- Proficient in technical English (creating and working with English documentation)
- Design applications taking into consideration data reconciliation, query/reporting performance, and analytical business value
- Develops in-depth understanding of underlying data, data structures, and business uses of data
- Ensure solutions support existing technologies encompassing the enterprise infrastructure systems reliability, availability and serviceability
- Analyzing project requirements and developing detailed technical specifications
9
Skills For Data Warehouse Consultant ETL Islamabad Resume
- Facilitating customer requirements gathering meetings/sessions/JAD Sessions
- Years working with technical developers to strategize solutions to align with business requirements Required 5 Years
- BI reporting tools Required 5 Years
- SAS In-Database processing with Teradata Required 5 Years
- Apply in-depth disciplinary knowledge within own specialty area with basic understanding of related disciplines and industry practices
- Build new state of the art data warehouse, fully automated NRT ETL, reporting and analytics
- Support integration with various upstream systems and reporting
10
Skills For R&D Data Warehouse Consultant Resume
- Develop and document ETL processes to extract data from existing systems into the data warehouse
- Knowledge of data warehouse data structure design, definitions, capabilities, programming languages, and data integrity issues
- Knowledge of MMIS architecture Highly desired
- Responsibly plan for and undertake professional development pursuing Teradata and external certification in field of expertise. Assist in recruiting and interviewing candidates and train/teach others
- Demonstrate professional behavior at client sites. Build relationships with clients, both business and IT, by understanding and responding to the client's business environment and business challenges
- Apply professional judgment based on the analysis of relevant input; Design and implement available consulting services products, solutions, tools and processes without direction
- Good understanding of ETL concepts and DWH architecture
List of Typical Responsibilities For a Data Warehouse Consultant Resume
1
Responsibilities For Data Warehouse Consultant ETL Islamabad Resume
- Business Analyst experience in a state government environment
- Experience with Teradata SQL Assistant
- Open Text BI Query experience
- Subject Matter Expert (SME) in Business Intelligence/Data Warehouse (BIDW) data modelling best practices
- Expertise in requirement gathering, customer engagement and project management
- Abgeschlossenes Hochschul- oder Fachhochschulstudium (Informatik, Wi.-Inf., Wi.-Ing.)
2
Responsibilities For R&D Data Warehouse Consultant Resume
- 2-3 Jahre Praxis-/Projekterfahrung in folgenden Gebieten
- Datenbanken (z.B. Teradata, Oracle, DB2, SQL Server)
- Modellierungstechniken (3NF, STAR, Snowflake)
- Softwareentwicklung mit SQL, C/C++ oder Perl, Java
- ETL Tools (z. B. Informatica, Oracle Data Integrator, Talend, etc.)
- BI Tools (z.B. MicroStrategy, Cognos, BusinessObjects, SAS, Microsoft, QlikView etc.)
- Kunden- und teamorientiertes Denken und Arbeiten
- Sehr gute Deutsch- und Englischkenntnisse (präsentationssicher), Französisch von Vorteil
- Hohe Motivation für die persönliche Entwicklung
3
Responsibilities For BI Data Warehouse Consultant Resume
- Überzeugungskraft und souveränes Auftreten
- Hohe Einsatz- und Reisebereitschaft
- SSIS (or other data integration tools)
- Abgeschlossenes Hochschul- oder Fachhochschulstudium (Informatik, Wi.-Inf., Wi.-Ing.) mit einer hohen Affinität zu DWH Funktionen, Methoden und Architektur
- Mindestens 3 Jahre Projekterfahrung folgenden Gebieten
4
Responsibilities For Data Warehouse Consultant Resume
- Select and apply highly technical and specialized toolsets and quickly to adapt to changes and advances in technology for Data Warehousing (RDBMS, ETL, etc.), OLAP and BI systems
- Design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes
- Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle
- Experience with Informatica product suite in the Informatica cloud
- Knowledge of MMIS architecture
- Terms and Conditions: If selected, the vendor shall be required to sign and adhere to the client Additional T&Cs. The contractor shall be required to sign several security documents and also adhere to client Additional T&Cs
- Experience with DB2 data warehouse (10.1v or higher) development
5
Responsibilities For Data Warehouse Consultant ETL Islamabad Resume
- Hands-on experience with near/real-time data integration design
- Extensive experience with complex application and data security requirements
- Extensive experience with Informatica Power Center either with Oracle and/or Teradata
- Code Oracle SQL/PL-SQL queries/scripts for ETL and validation of ETL and to build custom queries, views, materialized views, new tables/indexes, etc
- Background Check: Proof/Receipt that a background check has been performed and passed
- Picture ID (Government): Copy of a state Driver''s License/ID Card or US Government photo id
- Advanced ETL tool or solution development
6
Responsibilities For R&D Data Warehouse Consultant Resume
- Experience with data warehouse architecture standards, process, and methodology, with good knowledge of data integration, data quality, multi-dimensional design and ETL tools
- Enhance the data warehouse infrastructure to support current systems
- Develop fully automated DR and failover
- Create Tidal jobs to support needed tasks
- Design, develop, and test ETL processes for the data warehouse
- Document the “as-is” schemas currently in use at client
7
Responsibilities For BI Data Warehouse Consultant Resume
- Perform other analysis and documentation tasks as required to facilitate and support client Enterprise Data Warehouse Project
- Use all ODI tools - Topology, Security Manager, Designer and Operator to create/modify/manage ODI configurations and mappings
- Self-driven, detail oriented
- Linux, Windows Grundlagen
Related to Data Warehouse Consultant Resume Samples
Data Warehouse Architect Resume Sample
Work Experience
• Knowledge of multiple, diverse technologies and processing environments required
• Supports new data warehouse development, ensuring consistency and integration with existing data warehouse structure
• Translates business requirements into technical architecture vision and im...
Professional Skills
• Strong SQL querying skills including store...
• Strong BI architecture database skills fro...
• Proven BI skills with ETL (SSIS) developme...
Data Warehouse Developer Resume Sample
Work Experience
• Leads or acts as chief technical contributor to translation of business requirements to technical specifications
• Leads or acts as the chief technical contributor in the design of new applications or enhancements including integration of purchased solutions in accordance with Enterprise wide strat...
Professional Skills
• Strong systems/process orientation with de...
• A positive self-starter with a solid work ...
• Excellent written and verbal communication...
Shipping / Warehouse Resume Sample
Work Experience
• Related experience and/or training or equivalent combination of education and experience
• Computer Skills: Knowledge of basic office (spreadsheet, word processing, e-mail) as well as inventory and warehouse management software
• Knowledge of AS400 and PKMS is essential
...
Professional Skills
• Strong leadership and team building skills...
• Food processing, liquid filling/bottling, ...
• General office or shipping/receiving exper...
Inventory / Material Resume Sample
Work Experience
• Receives, stores and issues materials, supplies and merchandise. Compiles and verifies stock records against source documents. Ships end products. Loads, unloads and moves materials within and outside the plant. Performs tasks with minimal supervision
• Unloading/handling, opening/sorting packages,...
Professional Skills
• To support, execute and assist in the deve...
• To implement and execute Standardized Proc...
• Experience in Inventory analysis, systems ...
Inventory Logistics Resume Sample
Work Experience
• Using Bard’s ERP system(s) and other service management systems, manages the S&R repair parts, component, and accessories inventory for U.S. service operation
• Maintain awareness and comply with Bard’s Quality Management System, specific Quality policies, and any applicable laws and regulation...
Professional Skills
• Responsible, hardworking and motivated wit...
• Work independently and with strong initiat...
• Able to work in a fast paced environment a...
Sales / Warehouse Resume Sample
Work Experience
• Assist in TWW’s banking including deposits, reconcile to EOD report, confirm check and cash balances, process of credit cards and other
• Sells industrial, medical and specialty gases, welding supplies and related equipment to customers
• Advises customer on equipment and mat...
Professional Skills
• Strong interpersonal skills including sale...
• Proven success in sales and providing exce...
• Capable of working in a fast paced environ...