Business Intelligence
Resume:
Olga Klimova
Business Intelligence Consultant
Hamilton, Ontario, Canada
****@********************.********** intelligence developer with 20 years’ experience in information management, 8 years in Business Intelligence (BI).Specialized in Microsoft business intelligence technologies: Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS), SQL Server 2008, SQL Server 2005.Implemented complete data warehouse (DW) solutions for wholesale, distribution, insurance, telecommunications, financial, banking, healthcare, and pharmaceutical companies.Proficient in each phase of BI development life cycle, from business analysis to DW design and implementation.Experienced business analyst and data warehouse architect, gathered business requirements and designed solutions that delivered real business value.Follows best practices and Microsoft recommendations for business intelligence infrastructure build out, use of Microsoft BI development tools, performance tuning, data quality control, and Ralph Kimball’s data warehouse design principles.Experienced business analyst and data warehouse architect, provided clients with solutions solutions that delivered real business value.
Microsoft CertificationsMicrosoft Certified IT Professional (MCITP), Business Intelligence Developer 2008Microsoft Certified Technology Specialist (MCTS), SQL Server 2008, Business Intelligence Development and MaintenanceMicrosoft Certified Technology Specialist (MCTS), SQL Server 2005, Business Intelligence DevelopmentMicrosoft Solution Developer (MCSD), Visual Studio 6.0Microsoft Database Administrator (MCDBA), SQL Server 2000Microsoft Systems Engineer (MCSE), Windows NT 4.0Microsoft Certified Professional (MCP) 2.0
Complete certifications and exams taken are listed on .
Business Intelligence ServicesBusiness analysis and requirements gatheringBusiness intelligence reporting solution architectureExtract-transform-load (ETL) processes designData integration and conforming from multiple sourcesOngoing user support and education
Business Intelligence Experience
Unis Lumin Inc., SuttonMed Systems, Oakville, 10/2010 – ongoing support
Designed and implemented Athlete Health Management data warehousing and business intelligence reporting solution for the Association of Tennis Professionals (ATP) to assist them with self-help reporting capabilities and data analytics in athletic injury trend analysis, diagnostics and health risk management. Provided business analysis consulting services, helped formulating business requirements. Guided infrastructure provision, servers’ configuration and defined security policy. Served as a single resource of full-cycle BI system development – from data warehouse architecture design, through SSIS ETL processes implementation, SSAS OLAP cube design, to SSRS report prototyping and user training in self-serve reporting. Provided ongoing support and periodic change management.
XPI Inc., Toronto, 04/2007 – 04/2010
Designed and developed data warehouse solution for Aviva Canada, a major insurance company, provided managers and analysts with an 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; included agencies, claims, accidents, and policy services dimensions.
Assisted in preparation of project proposals, client and vendor meetings. Gathered client requirements and translated them into data flows. Designed ETL architecture and implemented data transformation processes. Designed and built SSAS OLAP solution. Managed ongoing communication and feedback to user community. Lead change management, user acceptance testing (UAT), and production support.
Unilever Canada, Toronto, 06/2008 – 10/2009
Designed and 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 mere three months. Provided 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.
Used Microsoft Business Intelligence development platform: SSAS, SSIS, SSRS; Proclarity reporting; Oracle and SAP data sources.
Inquiry Management Services (IMS), Toronto, 05/2008 – 06/2008
Provided technical training for IT staff through use of Microsoft SQL Server 2005 Business Intelligence tools. Consulted software developers and guided them through design and development of a BI system, to reduce complexity of organizing and distributing information for the organization. Covered data warehouse design best practices, performance optimization, MDX querying and reports authoring.
Hamilton Health Sciences Center, Hamilton, 01/2008 – 03/2008
Designed accounting reporting system for health care organization. Developed SSIS ETL system for data warehouse population, and SSAS OLAP cube. Moved 30 professional healthcare reports from various reporting architectures to SQL Server Reporting Services. Addressed data compliance and conversion challenges and delivered efficient reporting solution. Delivered business reports to users via company intranet.
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 SSAS OLAP solution. Facilitated data transformation and loading process. Identified potential bottlenecks; optimized end-user system performance and processing time. Lead enterprise report development using SSRS.
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 DTS and SSIS ETL processes, eliminating data inconsistencies, integrating data from different sources including Oracle database, and optimizing SSAS 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. Tools used: SSAS, SSIS, SSRS.
Developed other software solutions, 1990 – 2004:
Artificial Neural Devices (AND) Corporation, AcSys Biometrics, Toronto, 10/2001 – 11/2004
Developed facial recognition system applications.
Sochrys Inc., Moscow, 07/2000 – 08/2001
Developed software package for data analysis in molecular biology.
InfoSoft Inc., Moscow, 04/1998 – 06/2000
Designed a 3-tier Internet-based database system for IT recruiting services company.
Sberbank of Russia, Novocherkassk, 01/1996 – 04/1998
Built fraud detection reporting system.
Siberia-Hermes-Don Inc., Novocherkassk, 11/1993 – 12/1998
Developed accounting database system for oil and gas transportation.
Orbita, Design Bureau of Spacecraft Technology, Novocherkassk, 03/1990 – 10/1993
Developed integrated console of human physical signals digital processing and analysis project.
Education
1991: MSc, Computer Science, South-Russian State Technical University, GPA 4.0
Business Intelligence Skills Highlight
Business Intelligence development SQL Server 2008/2005 Business IntelligenceSQL Server Analysis Services (SSAS)Integration Services (SSIS) Reporting Services (SSRS)SharePoint Server 2010Performance Point 2010Business Intelligence ReportingKey performance indicators & dashboard design
Online PublicationsBlog posts about benefits of business intelligence on
Complete served, from clients and are available on consultant’s website.
Contact this candidate