Data Warehousing Resume Sample
Annie Morar
51557 Senger Mill,
Phoenix,
AZ
+1 (555) 497 1473
Work Experience
Data Warehousing Specialist
01/2016
-
PRESENT
Philadelphia, PA
- Identifying and profiling
- Meeting all service level agreements (SLAs),
- Key performance indicators (KPIs),
- Engage Concentra Business and Technology teams and Business Analytic stakeholders to understand business and operational needs to plan and align current and future data warehousing capabilities to support enterprise and business priorities and initiatives, and address the resulting capability gaps/needs
- Provide thought leadership and problem solving skills to address current and future Business Analytic issues, including Big Data and analytics, structured and unstructured data
- Thorough understanding of appropriate technologies and develop the team’s ability to resolve various application problems, engage with support channels on other teams and/or vendor support lines
- Analyze problems to achieve complete understanding; identify and engage SME's outside of the immediate team, if required, to clarify the requirements
- Utilize his/her experience in using enterprise-wide requirements definition and management systems and methodologies required
- Application management and BAU/Project enhancements
Data Warehousing Analyst
08/2013
-
11/2015
San Francisco, CA
- Performance optimization initiatives
- Supporting business users for BAU deliverables
- Interface with MatchPoint Coder, a system used for coding of clinical data in MedDRA and WHO-DD drug dictionaries
- Interface with JReview version 12.0
- A generic file loading utility to load non-RAVE data into LSH
- A study set-up utility which creates containers and objects in LSH to support development, validation, and production work
- A study promotion utility which clones work areas to a specific target in LSH
- Experience as a project/delivery manager in BI/Analytics area from Big 4 consulting and overall 15 years of experience in delivery
Data Warehousing
06/2009
-
06/2013
Phoenix, AZ
- Works collaboratively with analytical and data management teams to develop analytical tools to manage/measure care processes, models, and clinical guidelines
- Participates in the development of new goals and strategies based on interactions with primary user
- Partners with user in designing features for technology
- Managing technology delivery in projects and providing technical guidance / solutions for work completion
- Develop and guide the team members in enhancing their technical capabilities and increasing productivity
- Ensure technical compliance in the assigned development and participate in technical discussions/review
- Consultative role with Business Analysts on multi-dimensional BI reporting, structure and referential integrity
Education
Palm Beach Atlantic University
2005 - 2009
Engineer's Degree in Computer Science
Professional Skills
- Budget and Resource Management experience; including management experience with multiple diverse teams and experience conducting formal performance reviews
- Experienced professional with at least 5 years of experience working across Analytics & Machine Learning domain
- Extensive experience in Data Analysis - Skilled in uncovering insights and identifying patterns
- Proven experience in predictive modelling using R/Python
- Expert dimensional data modeling skills
- Understanding of and advanced experience with Software Engineering Concepts and Methodologies
- At least three years of data modeling experience, and knowledge of 3NF, Star-Schema and other data warehousing modeling techniques
How to write Data Warehousing Resume
Data Warehousing role is responsible for modeling, languages, programming, finance, integration, database, security, java, architecture, reporting.
To write great resume for data warehousing job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Data Warehousing Resume
The section contact information is important in your data warehousing 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 Warehousing Resume
The section work experience is an essential part of your data warehousing 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 warehousing 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 warehousing position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Data Warehousing resume experience can include:
- Five or more years of experience with data analysis and data profiling using SQL and other tools
- Experience mentoring and developing resources in a high performance culture
- Six years of experience using Oracle with expertise in SQL, PL/SQL and SQL Loader utilities for ETL processing
- Five or more years of experience with the Microsoft Data Warehousing and Business Intelligence stack (SQL Server, SSIS, SSRS, SSAS, PowerPivot, Power BI)
- Experience with BI reporting tools
- Advanced knowledge of Project/Program Management, Strategic Planning, some finance experience and related curriculum
Education on a Data Warehousing Resume
Make sure to make education a priority on your data warehousing resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your data warehousing 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 Warehousing Resume
When listing skills on your data warehousing 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 warehousing skills:
- Superb coding, testing and debugging skills
- Solid understanding and hands on experience of UNIX & Shell Scripting
- Solid understanding and hands on experience of RDBMS & SQL
- Solid understanding and hands on experience of Agile and Waterfall methodologies
- Good understanding of UNIX system, shell or perl scripting, windows scripting
- 6+ yrs experience within BI development including Full Life Cycle projects (ex. ETL, data warehouse development, data processing – ingestion and extraction)
List of Typical Experience For a Data Warehousing Resume
1
Experience For Data Warehousing Analyst Resume
- Five or more years of experience as a Data Warehouse architect and ETL developer
- Comfortable with ambiguity, and changes in priority
- Mentoring other engineers, fostering our speed-oriented culture in them, and helping to cultivate a fast-growing team
- Conducting technical interviews
- Follow best practices for data creating and managing the data extraction, transformation and loading (ETL) framework
- Design dimensional Star Schema data models to support front-end BI tools including ad-hoc reporting
- Create and support all ETL jobs pulling data from various source systems and loading into the data warehouse
2
Experience For Data Warehousing Engineer Resume
- Create reports using SQL Server Reporting Services (SSRS)
- Develop data architecture, data modeling, and ETL mapping solutions
- Support the data warehouse technical ecosystem, including Power BI for the delivery of reporting and analytic applications
- Recommendation and design of solutions meeting business needs and leveraging business opportunities
- Develops automated processes wherever possible with the goal of providing self-service sourcing functions for end users
- Assists/recommends higher management in areas of budgeting, resourcing, standards and policies
- Create dashboards using Microsoft Power BI or Tableau
- Work with all levels of end users, including executive staff
3
Experience For Data Warehousing Specialist Resume
- Comfortable working in a collaborative, team-centric environment
- Develops and maintains the appropriate end to end transformation and load processes associated with Data Warehouse and Data Marts, including
- Interest and proficiency in learning to lead a cross functional team
- Gather and document requirement for the data warehouse
- Design and create a semantic layer to support end-user self-service
4
Experience For Manager Enterprise Data Warehousing & Analytics Resume
- Quickly and accurately respond to Ad-Hoc information requests
- Forecast, analyze data and trends and create reports that highlight areas in need of performance improvement
- Interact with customers as a technical resource to troubleshoot problems with the delivered BI solutions
- Design and build Data Warehouse structures (databases and SSAS cubes)
- Takes independent action, makes decisions and takes on ownership of applications
- Architect data mart databases and modifications
5
Experience For Big Data Warehousing Manager Resume
- Create reliable pipelines for data movement/consumption
- SSIS, Informatica and other ETL toolsets
- Leads and assists others in a team environment
- Translate functional and technical requirements into detailed architecture and design
- Participate in code and design reviews to maintain our high development standards
6
Experience For Business Intelligence Data Warehousing Manager Resume
- Experience with parallel query optimization and execution, large scale data analytics, highly available/fault tolerant systems, replicated data storage, and operating complex services running in the on-prem or cloud are all pluses
- Strong Core Java developers (Java Server side), Multi-threading, Design Patterns, Spring, Messaging, JMS, Database, Sybase, FIX Protocol, Test Automation, Test Driven Development, etc. Exposure to Highly Performant Front Office OMS’s
- Defines clear success criteria and goals for self and monitors and measures performance against these
- Conveys sensitive and controversial information in a thoughtful and a considered manner
- Actively builds relationships with peers and across teams
7
Experience For Senior Data Warehousing Engineer Resume
- Manages own interactions to resolve differences/conflicts
- Sense of team spirit and participation
- Actively engages in process improvement
- Contribute in POC’s and assists in quick ingestion if required by business for exploration purposes
- Infrastructure (extends across applications): SQL/MySQL/Postgres
- Mso-fareast-font-family:"Times New Roman"">Deep knowledge of Enterprise Data
8
Experience For Senior Data Warehousing Specialist Resume
- KEY RESPONSIBILITY: Set-up subsequent work areas in the data flow, including development & validation of mapping programs to transform data to enriched data format (in SAS or PL/SQL). Monitor daily execution of programs once established
- Monitor system performance and integrity from user perspective, and report any deficiencies to technical colleagues. Work with technical colleagues on identification and implementation of corrective and preventative actions, as required
- What's the increase in demand/Driver behind the incremental ask
- Coordinates the data administration technical function for both data warehouse development and maintenance
- Demonstrates strong understanding of the processes, procedures and issues within their area. Areas include ITIL, agile and waterfall, as well as the fundamentals of requirement specification, design, coding, and testing of business applications systems, specifically, Data Warehouses and Business Intelligence solutions utilizing SQL and ETL tools
9
Experience For Data Warehousing / Modeling Resume
- Able to resolve or facilitate the resolution of complex issues within their area. Has a strong working understanding of installed systems, with the ability to troubleshoot and resolve many problems on the existing systems supported
- Recent experience
- Responsible for completion of all phases or components of a project
- Assist Data Scientists
List of Typical Skills For a Data Warehousing Resume
1
Skills For Data Warehousing Analyst Resume
- Experience leading and/or participating on project teams
- Software development / consulting experience on Enterprise Data warehouse architecture, Design and development
- Professional experience working in an Agile environment
- Experience in DBA, data modeling and ER schema
- Experience working within an Agile BI environment
2
Skills For Data Warehousing Engineer Resume
- Experience with OLAP tool cube/report design/deployment
- 2+ yrs Teradata Data development experience
- Experience with, and general knowledge of, multiple RDBMS platforms (ex. Oracle, SQL Server, DB2, and Informix)
- Over 5 years of experience in Project & Program Management
- Experience with software solutions delivery
3
Skills For Data Warehousing Specialist Resume
- Data warehouse experience
- Extensive professional experience in data analysis and report design/development
- Experience in presentation/interface creation
- Experience working with Azure and/or AWS
- Strong sense of ownership for deliverables and a sense of urgency to promptly resolve issueswww.amway.jobs
- Experience with ANSI-SQL and/or PL/SQL
- Database architecture and design experience
- Work with other teams, understand their requirements and deliver and operate appropriate large scale, distributed services
4
Skills For Manager Enterprise Data Warehousing & Analytics Resume
- Managing, monitoring and maintaining databases
- Understanding of source control repository and Database (SQL queries )
- Approving requested changes, updates and modifications to database structure and data
- Ensuring database integrity, stability and system availability
- Approving solutions for database backup and recovery infrastructure
- Working in a matrix environment with solution management, architects and “virtual” team members
5
Skills For Big Data Warehousing Manager Resume
- Proficiency in machine learning and data mining techniques ? Feature engineering, regression, classification, clustering, time series analysis etc
- Analytical: Critical thinking; Data mining; Debugging; Problem Solving
- Manage Finance workflows – funding procurement, allocation, tracking, reporting
- Analyze query performance and perform query tuning to assist development engineers in designing and optimizing queries
- Technical training/mentoring/coaching to the junior members
- Ability building and delivering complex algorithms around data transformation
- Demonstrated experience in design, development and implementation of SQL scripts, stored procedures, cursors and triggers on Oracle / Teradata / SQL server platforms
- Proven experience in development of conceptual, logical, and physical data models for OLTP, DSS relational, EDW (enterprise data warehouse) and OLAP database solutions
6
Skills For Business Intelligence Data Warehousing Manager Resume
- Experience with various aspects of HANA modeling such as Attribute Views, Analytical Views and Calculation Views
- Experience with any of the Relational Database Data Modeling tools (Powerdesigner, ERWin, ER/Studio, Oracle SQL Developer)
- In-depth experience and understanding in Software Development and Delivery practice
- Over 5 years of experience managing a Globally Distributed Software Development Team in a Tech Innovation or Startup firm
- Experience in the following areas required
- Prioritize and manage deliverables with competing deadlines
7
Skills For Senior Data Warehousing Engineer Resume
- Strong background with data warehousing principles, OLAP, and relational database architecture
- Familiarity with at least one family of SAP Reporting/Analytics solutions (desired)
- Facilitate modeling sessions and design walk-throughs with the development team members
- Knowledge of maven and TeamCity, Spring framework
- Expertise in handling large data volumes MPP databases like Greenplum
- Produce executive reports and discuss project(s) and program status including but not limited to risks, issues, achievements with client senior leadership
- Develop and test programs using SQL, PL-SQL and SQL Loader for database applications
- Assist other database engineers with the day-to-day activities, including databases maintenance such as installation, backup, restore and security control
8
Skills For Senior Data Warehousing Specialist Resume
- Lead or actively managed team of EDW engineers on Projects (desired)
- Exposure to "big data" and large-scale data aggregation and transformation
- Drive technical discussions and implementation decision process
- Skills on Enterprise Business Intelligence Platform/Universe/Semantic Layer sizing, tuning, optimization and system landscape integration in large-scale, enterprise deployments
- And good understanding of the end to end flow viz., front office – middle office – back office
- 5+ yrs developer experience in Informatica
- Agile product development methodologies (SCRUM) is required
- Lead and collaborate with other functions
- Manage and follow strict timelines towards deliverables
9
Skills For Data Warehousing / Modeling Resume
- Communicate with senior business partners, business analysts and
- Comfortable in a leadership role of indirect and direct teams
- SQL able to create advanced queries
- Interface with business owners for project and product requirements and scope
- Step in design, Develop and Deliver software and data solutions as needed
- Ability and knowledge to assist in process development and establish plans
- Intermediate in architecture and design
- Advanced in software development
10
Skills For Data Warehousing Architecture Team Lead Resume
- Accurately present delivery Status to Executive Management
- Create Oracle PL/SQL packages, complex stored procedures, partitioned tables, ad-hoc queries to support development and business needs
- Collaborate with stakeholders to plan and deploy new database releases
- Troubleshoot production support issues in the application environments
- Work as a part of a development team to implement product enhancements
- Overall accountability of the technical delivery of the project
- High level and detailed technical design for the project
- Configuration Management and software factory
Related to Data Warehousing Resume Samples
Data Analytics Resume Sample
Work Experience
• Strong experience using data to tell a story via easy-to-understand visualizations, specifically with Tableau
• A proven ability to work on and lead multiple projects simultaneously, meet deadlines under pressure, and communicate and work with multiple stakeholders
• The abil...
Professional Skills
• Essential skills needed include exceptiona...
• Strong critical-thinking skills and proble...
• Demonstrated skills using high level compu...
Data Protection Resume Sample
Work Experience
• In depth knowledge of firm and regulators’ data privacy and protection rules and policies as well as familiarity with other RM initiatives outside of their specific RM area
• Independent work capabilities
• Directs the Global Vulnerability Management (GVM) activities and over...
Professional Skills
• Strong leadership skills with demonstrated...
• Strong leadership skills with the ability ...
• Strong communicator with proven effective ...
Data Solutions Resume Sample
Work Experience
• Own and deliver individual
• Responsible for defining and documenting the architectural strategy and high level solutions, ensuring that it meets business requirements and performance goals and that the technical direction is consistent with that of the enterprise
• To define...
Professional Skills
• Comprehensive set of skills required to bu...
• Solid general architectural skills, with p...
• Excellent written and verbal communication...
Data Mgmt Analyst Resume Sample
Work Experience
• Participate in projects and other initiatives per year that influence GOMD and Dell’s strategic objectives
• Management and coordination of configuration/data management system for both commercial and government projects
• Responsible for software configuration, participate i...
Director Data Resume Sample
Work Experience
• Market services to brand Zones Data Center solution capabilities
• BS or MS in Computer Science or other Science/Engineering related field or significant demonstrable professional work experience
• Experience in Finance or Payment Services s industries, with clear understandi...
Professional Skills
• Excellent presentation skills and demonstr...
• Demonstrated experience and skills at arch...
• Possesses excellent people interaction ski...
Data Collection Resume Sample
Work Experience
• Build lasting relationships with Humana’s customers
• Fluent – in Chinese language as this role is APAC focused
• Willingness to learn and hungry to grow
• Associates or BA (or demonstrated progression for pursuit of an education)
• &nb...
Professional Skills
• Excellent communication, interpersonal and...
• Excellent communication, strong organizati...
• Excellent interpersonal and communication ...