DATA WAREHOUSE/BUSINESS INTELLIGENCE CONSULTANT
A business intelligence/data warehouse consultant with formal training from the Kimball University and over five years consulting experience using the Microsoft business intelligence toolset. A consultant who has developed business intelligence for a wide variety of industries including; natural resources, communications and the financial sector, in both Canada and the U.S. An individual who has consistently delivered high quality solutions while earning trust and building strong relationships with clients, coworkers and Microsoft representatives. Consistently demonstrated the ability to understand and deliver complex solutions in new and unproven technologies while developing best practices and implementation recommendations. Developed a broad range of communication skills in order to deliver effective and understandable presales presentations to non technical business users and executives as well as providing leadership and mentoring for clients and junior resources to help them grow in their roles as business intelligence professionals.
PROFESSIONAL SKILLS
- Ability to understand complex business requirements and relate these to technical solutions
- Consistently established trust and rapport with coworkers, business sponsors, end users and Microsoft representatives
- Excellent problem solving skills
- Highly motivated and accountable for actions and deadlines
- Strong communication and presentation skills
- Effective team leadership and mentoring skills
TECHINCAL SKILLS
- Data Design – deep understanding of data warehouse design and concepts
- Database – SQL Server (2000/2005/2008), Oracle, Access
- ETL – SSIS, DTS, SQL
- OLAP – Analysis Services (2000/2005/2008) cubes
- Reporting – Reporting Services, Crystal Reports
- Analytics – ProClarity, Excel
Dashboards – Performance Point Monitoring, Excel, SharePoint
- Planning – Performance Point Planning
- Programming – VB.Net, C#, HTML, JavaScript, CSS
PROFESSIONAL EXPERIENCE
MobEIM Inc. Apr 2007 - Jan 2009 Calgary Alberta CANADA
Senior Business Intelligence Consultant
- Worked in conjunction with Microsoft to present the new features and advantages of SQL Server 2008 to the Calgary IT community
- Developed and presented a working PerformancePoint Planning proof of concept and presentation for Microsoft, USA
- Implemented PerformancePoint Planning for a business unit of a large U.S. energy company including setting up the budgeting cycles and submission hierarchies and all ETL to move data into and out of PerformancePoint Server at the start and completion of the budget cycle
- Designed and developed a comprehensive and extensible SSIS solution for international communications provider using best practices to help them transition from DTS to SSIS
- Designed and developed ETL solution to populate a new reporting environment for a province wide credit union, including training client developers in SSIS and developing corporate standards and best practices
- Designed and developed data marts, reports and dashboards for Large U.S. energy corporation, including extracting and conforming data from Great Plains, custom applications and excel data sources
- Assisted in developing corporate best practices for data mart and ETL design and implementation
Ideaca Knowledge Services Nov 2002 - Apr 2007 Calgary Alberta CANADA
Business Intelligence Architect
- Developed and presented proof of concept using MS Analysis Services 2005 and ProClarity in association with Microsoft Sales team
- Designed and documented reporting and information management strategies for Calgary based energy corporation
- Designed dimensional reporting solution and mentored client staff on Microsoft DTS to populate the reporting database to support automated executive dashboard reporting for national communications company
- Develop proof of concept for SQL Server 2005 BI tools and trained client staff on using the new technology for a Calgary based energy corporation
- Designed data warehouse and ETL solution for western Canada’s largest private land management and logging company
- Assisted in training and mentorship of Ideaca consultants for dimensional modeling and ETL development
- Assisted in developing Ideaca’s Business Intelligence strategy and best practices for data mart design and development.
Business Intelligence Developer
- Developed dimensional model, DTS solution, Analysis Services cubes, Reporting Services reports, and ProClarity briefing books for national financial services company
- Trained client staff members to support BI solution for national financial services company
- Implemented reporting services, developed reports and trained staff how to use reporting services for an international energy company’s oil sands project
Custom Development
- Used the .Net framework and Visual Studio toolset to develop custom projects including procurement application, custom web applications, DotNetNuke modules and Microsoft Content Management Server development
Calforex/AFXSoft (contract work) May 2002 to Sep 2002 Calgary Alberta CANADA
.Net Developer
- Assist AFXSoft develop a retail management and point of sale system for Calforex using the Microsoft .Net platform
- Develop Reports for new system
- Design look and feel of user interface
EDUCATION
DeVry Institute of Technology Mar 1999 to Feb 2002
Bachelor of Science, Cum Laude
Computer Information Systems (CIS)
CERTIFICATIONS & TRAINING
Kimball University - Dimensional Modeling in Depth
MCP – Microsoft Certified Professional
Dale Carnegie – Effective Communications & Human Relations