Business Intelligence Consultant Resume
Title
Business Intelligence Consultant
Primary Skills
Data Warehousing, Business Intelligence
Location
Canada-ON-Oakville, GTA
Posted
Feb-06-10
Summary
Consultant provides companies with complete value-focused business intelligence (BI) reporting and analytics solutions.
The solutions incorporate both historical and forward-looking information and provide action-oriented suggestions and enhance business competitiveness.
Services
- Decision support system planning and management
- Working with managers and users to develop business requirements and to analyze/model current and proposed business process flows
- Data auditing and profiling to research data sources
- Designing data warehouse bus matrix to support each business process
- Designing strategies for extracting data from each source system
- Dimensional modeling, identifying facts and declaring grains, choosing dimensions, identifying slowly changing dimensions (SCD)
- Determining historical and incremental data load volumes
- System configuration design, including memory size, storage system
- Physical data warehouse database design
- OLAP cube design
- ETL system development
- Creating cube calculations, KPIs, actions, perspectives, translations, decorations
- Optimization analysis and performance tuning
- Developing partitioning strategies for relational and OLAP databases
- Deploying, securing, and support of DW/BI System
- Ensuring recoverability of database warehouse structures
- Developing BI reports, and report models for end user self serve ad-hoc reporting
- Users and developers training
Technical Skills Highlight
|
|
|
Experience
Unilever Canada, Toronto, 06/2008 – 10/2009
Built Data Marts for Ice-cream subdivision, forecasting, and order delivery management. The efficient solutions has met essential needs for actionable, timely information in order to manage the business effectively, became mission critical immediately and allowed Unilever Canada deriving benefits in a mere three months. It provided an immediate access for managers on different levels and sales people to the detailed data in many business areas, including customer orders, pricing and promotions, distribution, sales reporting.
Inquiry Management Services (IMS), Toronto, 05/2008 – 06/2008
Provided business intelligence training for IT staff through the use of Microsoft SQL Server 2005 Business Intelligence tools. Consulted in design and development of a BI system to reduce the complexity of organizing and distributing information for the organization. Covered data warehouse design best practices, performance optimization, MDX programming and reports authoring; recommended alternative solutions.
Hamilton Health Sciences Center, Hamilton, 01/2008 – 03/2008
Designed accounting reporting system for health care organization. Developed ETL system for data warehouse population, and OLAP cube. Implemented efficient MDX calculations on cube. Moved 30 professional healthcare reports from various reporting architectures to SQL Server Reporting Services. Addressed data compliance and conversion challenges and delivered successful reporting solution. Deployed business reports to users via company intranet.
XPI Inc., Toronto, 04/2007 – 02/2008, ongoing support
Designed Data Warehouse for a major insurance company, provided easy access to historical quotes and claims, premium data summarized by characteristics critical to decision making, capability to analyze historical trends in premiums and claims, risk analysis. Integrated data from all lines of business, including agencies, claims, accidents, human resources, and policy services.
Provided assistance in preparation of project proposals, client and vendor meetings. Gathered client requirements and translated them into data flows. Designed ETL architecture and implemented processes. Designed OLAP cube; defined hierarchies; implemented calculations. Lead ongoing communication and feedback to user community. Provided change management, support during User Acceptance Testing (UAT), and production support.
Bell Canada, Toronto, 11/2006 – 03/2007
Developed SR&ED Financial Data Warehouse for Bell Canada, to help organize data of claimants by sectors, materials and other details, and provide an effective decision support platform. Performed client data analysis, determined needs, interpreted business requirements into system requirements. Assisted in strategy planning, client meetings and opportunity evaluation. Designed analytical system. Facilitated data transformation and loading process. Identified potential bottlenecks; optimized end-user system performance and processing time. Lead enterprise report development.
CIBC, Credit Risk Analytics, Retail Portfolio Monitoring & Management, Toronto, 05/2006 – 10/2006
Designed and built Data Warehouse for Basel II project and management reporting. Modeled ETL processes. Coordinated team of developers into implementing ETL processes; eliminating data inconsistencies, integrating data from different sources including Oracle, and optimizing OLAP system performance. Proposed and implemented innovative solution of cube business logic that allowed more effective reporting. Coordinated data reconciliation process flow. Developed functional and technical documentation.
Axiom Real-Time Metrics, Oakville, 12/2004 - 04/2006
Designed data warehouse for clinical trials data. Integrated information and metadata flow. Developed clinical and management reports.
Other Software Development Experience, 1990 – 2004
Education
1991: MSc, Computer Science, South-Russian State Technical University, GPA 4.0
Certifications
- Microsoft Certified IT Professional (MCITP) Business Intelligence Developer 2008, December 15, 2009
- Microsoft Certified Technology Specialist (MCTS) SQL Server 2008, Business Intelligence Development and Maintenance, December 15, 2009
- Microsoft Certified Technology Specialist (MCTS) Microsoft® SQL Server™ 2005, Business Intelligence Development, April 23, 2008
- Solution Developer (MCSD) Microsoft Visual Studio 6.0, June 27, 2001
- Database Administrator (MCDBA) Microsoft SQL Server 2000, May 04, 2001
- Systems Engineer (MCSE) Microsoft Windows NT 4.0, October 16, 2000
- Professional (MCP) MCP 2.0 -- Certified Professional, April 27, 1999
You must be logged in and have a current resume access subscription. Login or Register »
Resumes in Oakville, GTA, ON
| Resumes in Ontario
View other Business Intelligence Consultant resumes