Data Warehouse Resume Sample
Christa Baumbach
6125 Legros Ramp,
Boston,
MA
+1 (555) 124 3155
Work Experience
Data Warehouse Administrator
12/2016
-
PRESENT
Boston, MA
- Experience in diagnosing and resolving root cause of performance problems
- Monitors performance of major elements on an on-going and historical basis
- Proven experience in maintaining and supporting multiple major or critical applications
- Experience with all the major components in a vendor's solution specifically Oracle and Teradata
- Experience with ITIL framework, vocabulary and best practices
- Experience leading or managing a variety of teams and managing projects/ project teams/project plans; effectively delegating responsibility
- Ensuring the database service complies to regulatory and Barclays’ security requirements
Data Warehouse
08/2009
-
07/2016
Los Angeles, CA
- Previous experience within Financial Accounting / Risk Management; product knowledge of financial instruments is highly desirable
- Previous experience in leading requirements definition workshops
- Willingness to take ownership of deliverables, balanced by sound professional judgement and the confidence to escalate issues appropriately
- Provide expertise on decisions and priorities regarding the enterprise’s overall data warehouse architecture
- Expand the company’s use of data as a strategic enabler of corporate goals and objectives
- Travel required (see note)
- Engage business and technical teams and build relationships
Data Warehouse Intern
08/2003
-
02/2009
Dallas, TX
- Matrix manage 40+ database administrators to deliver the service
- Accountable to ensure project managers and projects deliver to the Database Service agenda
- Tracking and guiding members of other Barclays teams to ensure they deliver to the agenda
- Develop Informatica code according to specification
- Unit test Informatica code
- Assist with data modelling for DWH
- Assist with process modelling for DWH
- Review functional and technical specifications developed for the DWH
- Assist in risk identification and mitigation. Assist in risk identification and mitigation
Education
Westfield State University
1998 - 2003
Bachelor's Degree in Computer Science
Professional Skills
- Excellent communication skills, experience working with external vendors and strong analytical skills
- SQL Server ETL Development experience using SSIS. Strong ETL, data warehouse, T-SQL skills
- Strong analytical skills and experience with implementation and administration of Database Quality Engineer
- Strong communication, facilitation, prioritization, and scope management skills
- Demonstrated record of success with problem-solving skills, creativity, and the ability to manage multiple priorities
- Programming skills (sufficient to write SQL queries to validate test results in a database)
- Strong creative and innovative problem-solving skills
How to write Data Warehouse Resume
Data Warehouse role is responsible for business, sql, modeling, technical, software, analysis, etl, database, development, leadership.
To write great resume for data warehouse job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Data Warehouse Resume
The section contact information is important in your data warehouse 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 Resume
The section work experience is an essential part of your data warehouse 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 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 position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Data Warehouse resume experience can include:
- Strong intrapersonal skills and global acumen necessary to work as a part of a global and divers team
- Top-notch communication, writing, and problem solving skills
- Knowledge Skills, Growth, Mentoring, Training, Knowledge Mgmt
- Extensive experience in managing multiple priorities independently and/or in a team environment to achieve goals
- Strong hands on experience building large scale databases
- Understanding of SQL and some experience in a database environment
Education on a Data Warehouse Resume
Make sure to make education a priority on your data warehouse 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 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 Resume
When listing skills on your data warehouse 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 skills:
- Strong Skills in MPP Database (preferably Teradata) including database design, performance tuning, writing complex DB programs etc
- Excellent Relational SQL database skills using Oracle or Sqlserver in particular
- Problem Solver with good aptitude skills
- Effectively organizes and prioritizes activities to meet established deadlines
- Performing Extracting, Transforming, Loading (ETL) design, development, testing, and deployment activities effectively and efficiently
- Learning and applying BI / DW practices and skills
List of Typical Experience For a Data Warehouse Resume
1
Experience For Data Warehouse Administrator Resume
- Fluency in Dutch and/or French, proficient business English, with solid communication & presentation skills
- Excellent skills in ETL software technologies, such as SAS, or SAP product stack in information management (IBM Datastorage, Ab Initio,…)
- Effectively plan and implement resources to ensure multiple priorities are completed to satisfaction
- Strong development experience in SQL, NoSQL, database programming
- Experience as a data modeler with demonstrated success in relational database design
- Experience of ETL Enterprise Data Warehouse Experience
2
Experience For Data Warehouse ETL Developer Resume
- Nice to have application development skills: C#, HTML5, Angular, Knockout, Webapi, Json, XML, REST, Visual Studio
- Behavioral traits, attitudes, and skills required
- Proven experience with complex script development or complex utility tool configurations
- Sound project management practices and skills are required
- Identifies and implements improvement opportunities inclusive of tools, process, and skills
- A. Four (4) years demonstrated experience with enterprise database management and/or ETL development and design
- Demonstrated experience in/with SQL
- Demonstrated experience in/with business intelligence
3
Experience For Data Warehouse Solution Architect Resume
- Expert systems analysis skills
- Effectively present information in one-on-one and small group situations to business users and tech teams
- Experience developing and using Informatica ETL, SDA/SDI, ODI, and Business Objects Data Services is desired
- Experience using Perl, or other equivalent scripting toolsets
- Knowledge and experience in relational and dimensional database design techniques, creating business rules mapping from source to target systems
- Promote and assert standards through effective communication while fostering successful outcomes
- MS MCSA (SQL Server 2012 or later) or 6+ years of experience adminstering SQL server
- Provides consistent, timely and effective coaching in an individualized manner and completes thorough and fair performance assessments
- Experience in Data Warehousing or with large data bases and data analysis
4
Experience For Data Warehouse Business Analyst Resume
- Basic Microsoft Excel VBA experience and understanding
- Experience working city-wide in economic/Industrial cities
- Experience developing web applications in a Linux/Unix environment. (JDK 1.5/1.6)
- Utilizes understanding of data systems & objects as well as SQL to perform data validations against a variety of data warehouses
- Proven expertise in ETL and ELT tooling such as Pentaho, Integration Services, Informatica, Data Pipeline, Glue
- Experience using Rest APIs, JSON, & XML
- Skilled in Data Analysis and Data Modeling
5
Experience For Oracle Data Warehouse Database Administrator Resume
- Experience with Data Warehousing and Business Intelligence
- Knowledge and hands on working experience in a Data Warehouse development environment
- Hadoop/Big data tool experience using Hive / Hbase databases applications
- Experience in Data warehouse/ETL/Database Testing
- Typically requires 3-5 years of database administration experience working with various database management systems
- Experience in Ab Initio technologies including, but not limited to Ab Initio graph development, EME, Co-Op, BRE, Continuous flow
- Experience working in a matrixed environment on a fast-paced project
- Strong knowledge of BI tools such as Cognos, Business Objects, QlikView, Tableau
6
Experience For Senior Data Warehouse Administrator Resume
- BS Information Systems or 4+ years of experience with Server administration
- Experience in data integration tools (ETL)
- Relevant working experience in technical data analysis and data integration (between 2 – 6 years)
- Hands on experience working with at least one major technologies listed above
- Experience with ETL design and development
- Experience with large scale data warehouse systems
- Experience as Program Manager and/or Project Manager within complex IT projects
- In depth SQL development experience
- Experience in OBIEE
7
Experience For Data Warehouse / Database Developer Resume
- Experience working with Spark and EMR
- Experience programming in Java and/or Scala
- Experience with fast data and real-time data movement
- Works with both internal and external business partners and consultants on the overall user experience design and support the usability and human factors team
- Related experience in product development with a focus on system architecture of medical devices/IT systems
- Experience using Informatica, Oracle and SQL
- Experience using MS SQL Server Analysis Services
- Experience with JMS and Web services (SOAP, REST), XML, JSON, Apache, Tomcat, HTML5, JavaScript
8
Experience For Analyst, Data Warehouse Resume
- Excellent problem solver that manage multiple tasks efficiently
- Some experience with technical documents creation
- 1 – 3 years of experience in application, BI, or analytics development: professional, academic, or personal projects
- Experience in Data Warehouse components such as data dictionary, data architecture, subject areas, metadata repository, and data standards
- Experience with Hadoop is REQUIRED!
- Experience with Business Objects AND Crystal Report development
9
Experience For Enterprise Data Warehouse Resume
- Microsoft PDW/APS experience
- Administer data quality and validation
- An excellent collaborative manager, able to take on aboard wide
- GreenPlum and/or Oracle database experience
- Data analysis experience
- Proven track record in a Technology function
- Experience in a people leadership position
- Three years’ experience in data management, preferably in a health care
10
Experience For Data Warehouse Solutions Architect Resume
- Experience in information technology in the data space
- Development experience with ETL tools (preferably Informatica 9.x or later)
- Experience with Informatica PowerCenter
- Experience with Informatica Test Data Manager
- Total IT & Business experience
- Experience with Business Intelligence tools such as Crystal, Business Objects, Tableau, Microsoft Power BI, Microstrategy, or OBIEE
- Direct experience with BI or DW projects over the entire development lifecycle
- Experience with Dimensional Data Models
- Experience in ETL data warehouse and data integration principles
List of Typical Skills For a Data Warehouse Resume
1
Skills For Data Warehouse Administrator Resume
- Strong experience with Data Mapping, Data Modeling, Data Mining, and Data Warehousing/Mart
- Strong technical experience in designing and implementing data-intensive Data Warehouse solutions
- Data Modeling skills including ERWin/ERStudio
- Proficient analytical, problem-solving, critical-thinking & communication skills
- Support SKF business in delivering their business goals & strategies, advising the SKF Business how to effectively use the BI / DW services
- Strong SQL Server Administration and SQL programming experience
2
Skills For Data Warehouse ETL Developer Resume
- Solid understanding of SQL and good grasp of relational and analytical database management theory and practice
- Good Experience in at least one of the following
- Extensive exposure to Back-end/ETL Testing with high-level of SQL skills is required
- Experience with insurance policy / claims / billing administration systems strongly desired
- Strong experience in setup, installation and configuration of ETL (Informatica) tools using Teradata
- Desired– Event-driven and/or object-oriented programming skills
- Proven experience of coordinating teams (20+ resources)
3
Skills For Data Warehouse Solution Architect Resume
- Data Analysis – Experience consolidating disparate data sets into usable data
- Adaptable and effectively cope with rapidly changing business landscape
- Participating in the testing of applications, such as developing test plans, test conditions, and validation testing
- Experience in designing, developing and implementing an enterprise DW/BI system
- Demonstrates a clear and succinct writing style for the purpose of developing and completing correspondence and project documents
4
Skills For Data Warehouse Business Analyst Resume
- Experience in building enterprise data warehousing with table partitioning, encryption and data compression
- Experience with designing, developing and deploying Data Warehouse and Business Intelligence solutions
- Strong Knowledge of logical and physical data modeling (relational, dimensional data modeling); and
- Six (6) years of IT experience, including 4 years in Business Intelligence having one full life cycle of the project
- Practical experience in developing database ETL environments using SSIS for business intelligence applications
5
Skills For Oracle Data Warehouse Database Administrator Resume
- Experience leading testing teams
- Knowledge of policy, billing, and claims processing or medical liability experience
- 5~6 years of working experience in data warehousing project
- Hands-on experience with all aspects of the Data Warehouse lifecycle including data analysis, data modeling, design and implementation
- Three (3) years experience working on projects or programs requiring the integration of cross-functional technology and/
- Experience in Data Warehousing, Integration, Data Mapping
- In-depth working experience with IBM DB2 and AIX operating system
- Experience developing Data Warehouse data models, Dimensional Data Modeling
6
Skills For Senior Data Warehouse Administrator Resume
- Experience writing and tuning SQL queries
- Data modeling and transformational modeling experience
- Experience in SQL with a clear understanding of SQL tuning
- Experience working with real time messaging systems such as Kafka
- Participates in managing communication, dependencies and priorities across teams engaged in business analysis, engineering and QA, in different time-zones
- Experience building Business Intelligence and Data Warehousing solutions
- Expert skill maintaining accuracy with attention to detail and meeting deadlines
7
Skills For Data Warehouse / Database Developer Resume
- Broad understanding and experience of data modeling, data management, ETL and BI
- Perform data validation with systems of record and existing reporting
- Familiarity and understanding of supply chain management processes and relevant experience in manufacturing companies
- Ensures strong business relationships by responding to all business requests and serving as one of the primary point of contacts from the IT side
- Experience in working with RDBMS mainly SQL Server 2008/2012 and Oracle 11g/12c
- Experience using SQL Server 2008, 2012, Visual Studio, Business
8
Skills For Analyst, Data Warehouse Resume
- Experience using SQL Server Management Studio (SSMS), SQL Job Agent and Integration Services Catalogs
- Database and application development experience using formal software development life cycle
- Experience working with database, data warehouse, and IT systems
- Experience with scripting
- Strong understanding of different software development life cycles (waterfall, iterative) and contemporary software quality assurance processes
- Proven track record of converting Business requirements into functional / technical specs
9
Skills For Enterprise Data Warehouse Resume
- Good understanding of Informatica and Oracle (SQL & PL/SQL) to carry out peer reviews and provide feedback to developers
- Quality Assurance / Testing experience
- Experience with Quality Assurance testing tools
- Experience testing data warehouse systems
- Data Technology experience to include BI tools, methodologies, and/or responsibilities (Extract, Transform and Load (ETL) and/or BI Reporting)
- Software Quality Assurance experience on enterprise level applications which includes some Data Warehouse Testing
- Possess experience in using Informatica suite of tools
10
Skills For Data Warehouse Solutions Architect Resume
- Experience of regulatory security requirements regarding HIPAA and other regulatory security requirements
- 1+ Experience with leading other ETL Developers
- Database modeling experience – design of relational and dimensional data models required
- Strong structured testing background
- Experience in data base tuning and performance improvemen
- Experience with managing applications that meet Sarbanes-Oxley (SOX) process and access controls
- Experience in Test Automation using Selenium
List of Typical Responsibilities For a Data Warehouse Resume
1
Responsibilities For Data Warehouse Administrator Resume
- Perform Data Analysis to ensure feasibility (benchmarking, what if, type of requirements) based on existing data in the warehouse using SQL querying skills
- Expert SQL skills Understanding of dimensional models
- Experience with data validations tools, including Toad Data Point
- Respond promptly and effectively to resolve incidents, tasks, and projects
- Ensure that communications and people initiatives are effectively completed for US locations
- Proven excellent people manager able to lead and motivate the project
2
Responsibilities For Data Warehouse ETL Developer Resume
- Related experience in systems architecture. Ideally with medical device, healthcare produce experience. (Ideally FDA Regulated)
- Experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures
- Experience with using business intelligence tools, including Tableau
- Experience delivering solutions using agile and/or rapid application development methods
- Strong knowledge of relational database technologies: Oracle, HANA, Teradata, AWS Redshift, SQL and related data modeling techniques
- Data Warehouse and / or Data Modeling / Architect or Data Stewardship experience
- Professional experience in the following areas are required
- Run reports using BI software (i.e., BI Query) and/or SQL Assistant or a strong willingness to learn
- Experience dealing with 837 transactions
3
Responsibilities For Data Warehouse Solution Architect Resume
- Business Intelligence experience with at least one of the following tools: Cognos, Business Objects, MS Analysis Services, Hyperion, Oracle, Tableau
- Four (4) years of hands on experience with database design, dimensional modeling, data warehouse and BI / analytic tools
- Interoperability design and implementation experience using RDBMS technologies
- Experience and knowledge of upgrading from one version of BO to BI4
- Experience in UNIX/Linux/AIX operating environments is required
- Knowledge on languages like java, Python, javascript. Hands on experience on shell scripting and unix commands
4
Responsibilities For Data Warehouse Business Analyst Resume
- Experience with Entity-Relationship (ER) Modeling
- Experience with Business Intelligence BI Reporting Tools
- Hands-on experience in data analysis and data mining projects
- Data quality profiling and validation
- BI Reporting Experience - ideally BOBJ
- Experience working with a distributed team of developers and business
5
Responsibilities For Oracle Data Warehouse Database Administrator Resume
- Hands-on experience of a scripting language (e.g. Python, Perl etc...)
- Experience with SQL Server, Integration Services and Reporting Services
- Overall experience in Data Integration, Data Architecture, Data Modeling, and implementation
- Desired– Advanced SQL knowledge and experience, including stored procedures
- Reporting/Data visualization experience with SSRS
- Experience in Oracle Database, Cognos reporting, Ellucian Banner, or PeopleSoft application support
- Experience in operating systems, database design, and various microcomputer and server software packages and languages
- Experience in search results in Structured Query Language (SQL) development and scripting
6
Responsibilities For Senior Data Warehouse Administrator Resume
- Experience in providing solutions with complex OBIEE/ETL/DAC/ODI applications
- Solid T-SQL knowledge SQL query development using MS SQL 2012 and 2016
- Develop reusable templates / queries / scripts to assist with validation
- Experience in Java
- Experience with WMS application, specifically Inbound, Outbound, Pick pack and ship processes
7
Responsibilities For Data Warehouse / Database Developer Resume
- Experience with formal System Development Lifecycle and Data Quality processes
- Hadoop Big Data model and tools experience
- Related DBA experience
- ETL/SSIS experience
- Participates in the testing of applications, such as developing test plans, test conditions, and validation testing; and
8
Responsibilities For Analyst, Data Warehouse Resume
- Good in English command (Written and spoken)
- Good to have knowledge on Tableau or any similar tool
- Experience with Exadata and/or Exalogic
- Experience with OO languages (preferably C#)
- Knowledge/ Experience of SQL
- Business Analyst/Data Analyst experience
- Prerequisites (i.e., education, experience, licenses)
9
Responsibilities For Enterprise Data Warehouse Resume
- Denodo Database Virtualization technology experience is required
- Monitoring of existing Production scheduling servers and workflows for errors and resolving those errors in a timely manner
- Monitoring, operational maintenance and support of regular loading processes including root cause analysis and bug fixing in case of issues
- Troubleshooting and problem solving that focuses on identifying the root cause. Translating the root cause into a process or system improvement solution
- Understanding of enterprise data warehousing, dimensional modeling and STAR schemas
- Creating and maintaining ETL processes using OWB and ODI
10
Responsibilities For Data Warehouse Solutions Architect Resume
- Providing technical advice and guidance for infrastructure improvements and deploying and maintaining systems in accordance with established guidelines
- Preparing data marts to support the needs of the business including data analytics
- Learning and documenting Reinsurance data: the conceptual model, the physical model, and the sources and flows of our data
- Understanding the business problems and developing ways and means to solve the problems
- Working in an outsourcing environment is a major advantage
- Defining the high level solution with the help of Requirement and architect team
Related to Data Warehouse Resume Samples
Data Warehouse Analyst Resume Sample
Work Experience
• Consistently exhibits behavior and communication skills that demonstrate HealthCare Partners’ (HCP) commitment to superior customer service, including quality, care and concern with each and every internal and external customer
• Uses, protects, and discloses HCP patients’ protected health informat...
Professional Skills
• Excellent communication skills, organizati...
• Strong data analysis skills. Hands on expe...
• Strong analytical and problem-solving abil...
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 Engineer Resume Sample
Work Experience
• Create technical solutions and design for Data Warehouse
• Define overall ETL architecture including key designs on integration standards such as loading, real time/batch, CDC, data validation, parallelization etc
• Perform analysis and capacity planning to define ‘best in cl...
Professional Skills
• SQL Server ETL Development experience usin...
• Excellent technical writing skills required
• Strong analytical, problem-solving, writte...
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...