EXPERIENCE & SKILLS
01
REQUIREMENTS & SCOPING
Establish DW/BI roadmap and program scope, as well as gather requirements for specific efforts
02
DATA ARCHITECTURE & DESIGN
Design and build a flexible and integrated data model to support business users' current and future analytic questions
03
DATA PROFILING & ANALYSIS
Identify gaps and land mines in the data early on, in order to optimize the design and minimize rework
04
ETL ARCHITECTURE & DESIGN
Implement a high-performing ETL system built on reusable design patterns and components
05
db & etl performance tuning
Improve the performance of reports and queries, as well as the ETL system, via techniques such as indexing, compression, partitioning, aggregates, query rewrite, and more
06
BI ARCHITECTURE & DESIGN
Partner with report writers and other BI developers to maximize value derived from data infrastructure investment
07
DEPLOYMENT & training
Help effectively deploy solutions to end users with the training they need to be successful
all
PROBLEM SOLVING & COMMUNICATION
Help address the many business and technical questions that arise throughout the DW/BI lifecycle via communication, technical and troubleshooting skills honed from years of experience
mentor & develop team
Partner or embed with client team (FTE and/or contractor) in all project phases and mentor junior team members in order to lift the delivery quality and time-to-market for the overall team
Need more details?
See my LinkedIn profile, or click the Contact button to send me a message
and see how I may be able to help you achieve your objectives.