Olga Klimova


Business Intelligence (BI) Analyst, Architect, Developer of complex solutions who delivered multimillion dollar savings throughout 20-year career in information management.

   Customer-focused, high-quality results oriented: Created solutions that met immediate business needs, became mission-critical, and achieved company-wide adoption. Enabled 50 times increase in efficiency of accessing information and at least 20% increase in sales.

  Highly productive: Proficient in all facets of the delivery of information to end users. As companys sole BI vendor, cut implementation costs 4 times. Ensured fit within budget and time constraints.

  Resourceful, analytical: Effectively selected approaches to address specific customer needs; applied best recommended practices in BI infrastructure build out, use of Microsoft BI development tools, performance tuning, data quality control, and Kimballs data warehouse design.

  Dynamic team player: Acted as a efficient liaison between technical staff and business users.

  Effective communicator: Reported on progress and escalated issues ensuring clear timely communication to stakeholders. Defined and documented business requirements, system components, technical design, deployment procedures, and user guides. Provided developers and users training.

Endorsements

Olga provided deep technical expertise for our BI requirements great delivery and professional approach. Paul MacDonald, VP Professional Services, UNIS LUMIN

[Olga Klimovas] professionalism and quick understanding of the data and our business were superb. She is innovative in her solutions and was a tremendous asset to the project team Christina Browne, System Manager, Unilever Canada

Olga has a rare listening skill her delivery style that was empowering and made communication and therefore the outcomes easy to achieve Brahm Memone, Manager Financial Reporting, Hamilton Health Sciences Center

What we valued most was Olgas consistent approach to problem solving Rico Bottoni, Demand Planner, Packaged Ice Cream, Unilever Canada

Professional Experience

Center of Addiction and Mental Health (CAMH), Toronto (11/2013 12/2013)
As BI Solution and Data Architect, analyzed existing healthcare information systems, including ADT (admission-discharge-transfer), InfoMed, LAWSON, Cerner. Interviewed clinical, operational, and financial stakeholders and captured strategic requirements. Initiated project scope prioritization process. Profiled data sources, evaluated data availability and data quality. Extracted sampled data and prepared data model prototype to ease communication with key contacts and future solution users. Conformed data across the organization to satisfy centralized enterprise BI reporting requirements. Designed BI solution infrastructure and data warehouse to support flexible self-help data analysis by multiple dimensions including patient demographics, type of service, incidents, satisfaction.

Paradigm Quest Inc., Toronto (09/2012 09/2013)
Developed Customer Retention business intelligence solution that has enabled effective management and operational reporting for a leading company in mortgage industry. The solution has raised awareness of deals coming to maturity and allowed to accommodate resources for timely renewals to maintain client business and to discover hidden patterns in relationships with customers that have led to better business decisions.

Analyzed business needs, interviewed stakeholders and IT staff, formulated business requirements, prepared work estimation and project plan proposal, designed data warehouse & OLAP Cube, implemented daily ETL processes, enabled changed data capture to allow granular control over business operations, implemented advanced OLAP cube functionality for current and historical data and allowed corporate staff to analyze information across the organization from convenient Excel PivotTables. Provided user training manual and detailed technical support documentation. Built solution based on SQL Server 2008 R2.

Unis Lumin Inc., SuttonMed Systems, Oakville (10/2010 07/2012)
Developed business intelligence solution for the Association of Tennis Professionals (ATP). Provided self-help reporting capabilities and data analytics in athletic injury trend analysis, diagnostics and health risk management. Helped formulating business requirements. Guided infrastructure provision and server configuration. Provided ongoing support and periodic change management. Used SQL Server 2008.

   Met tight deadline for BI project implementation of less than 6 weeks.

   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 ad-hoc reporting using SQL Server Report Builder.

   Implemented solution at 20% the cost of another vendor estimation.

XPI Inc., Toronto (04/2007 04/2010)
Developed insurance data warehouse solution for Aviva Canada. Provided easy access to historical quotes and claims, premium data summarized by carriers, agencies, accidents, and other dimensions critical to decision making. Participated in preparation of project proposals. Translated client requirements into data flows. Designed SSIS ETL architecture and implemented data transformation processes. Designed and built SSAS OLAP solution. Assisted in developing Dundas Grid application interface. Managed ongoing communication and feedback to user community. Lead change management, user acceptance testing (UAT), and production support. Used SQL Server 2005.

   Ensured less than 30-seconds query performance on large data warehouse containing 1.5 terabytes of data.

   Introduced effective way for carrier-to-carrier performance analysis, replacing dozen of Excel worksheets and accelerating business decisions drastically.

Unilever Canada, Toronto (06/2008 10/2009)
Implemented data marts for ice-cream subdivision, forecasting, and order delivery management. Provided immediate access for managers and sales people to detailed data including customer orders, pricing and promotions, distribution, sales reporting. Used SQL Server 2005, SSAS, SSIS, SSRS; ProClarity for reporting; Oracle and SAP as data sources.

   Performed the work in less than 3 months. Equivalent solution development previously required 6 months of 2 full-time employees.

   Developed solution that boosted sales by 20%.

   Innovative solution was subsequently adopted by corporative U.S. head office.

   Reduced data access efforts from over 4 hours to 5 minutes through introduction of effective OLAP solution.

   Allowed increase customer satisfaction level with steady 97% on-time product delivery due to improved data visibility and effective case management.

Inquiry Management Services, Toronto (05/2008 06/2008)
Provided technical training for IT staff through use of Microsoft SQL Server 2005 business intelligence tools. Guided software developers through design and development of new BI system, to reduce complexity of organizing and distributing information for the organization. Training covered: data warehouse design best practices, performance optimization, MDX querying, and reports authoring.

   Allowed company to avoid expenditure of outsourcing BI development and train staff to develop BI solution in-house.

   Anticipated and addressed possible roadblocks in converting specific corporate data into BI solution.

Hamilton Health Sciences Center, Hamilton (01/2008 03/2008)
Designed accounting reporting system for health care organization. Developed SQL Server 2005 SSAS OLAP cube and SSIS ETL processes to populate data warehouse. Delivered business reports to users via company intranet. Addressed data compliance and conversion challenges.

   In less than 60 days, moved 30 professional healthcare reports from various reporting architectures to SQL Server Reporting Services, while enabling interactive data analysis and creation of more ad-hoc reports.

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. Developed OLAP solution with SQL Server 2005 Analysis Services. Facilitated data transformation and loading process. Identified potential bottlenecks; optimized end-user system performance and processing time. Lead enterprise report development using SQL Server Reporting Services.

   Guided team of 5 developers through BI system improvements to achievement of clients approval. Provided technical guidance, reasoned and persuaded development team to make positive changes by utilizing best BI practices and Kimballs data warehouse design principles.

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 using SQL Server 2000 & 2005. Modeled ETL processes. Coordinated team of developers to implement DTS and SSIS ETL processes, eliminate data inconsistencies, integrate data from different sources including Oracle database, and optimize SSAS OLAP system performance. Proposed and implemented innovative cube business logic that allowed more effective reporting. Coordinated data reconciliation process flow. Developed functional and technical documentation.

   Effectively overcame challenges of loading big data from financial system; reduced loading time from several days down to hours that fit into nightly data loading time window.

   Provided fast report user performance through improved OLAP design and query tuning.

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. Used SQL Server 2000/2005, SSAS, SSIS, SSRS.

   Introduced SQ Server 2005 business intelligence and presented to business to simplify report development, free IT resources, and improve report quality and consistency.

Fourteen years prior background in production environments, gaining hands-on software development and database management experience (1990 2004)

Education and Certification

Degree:

Bachelor of Computer Science, Novocherkassk Technical University, Russian Federation

Certification:

 

Microsoft Certified Solutions Expert (MCSE), Business Intelligence, SQL Server 2012

Microsoft Certified IT Professional (MCITP), Business Intelligence, SQL Server 2008

Microsoft Certified Technology Specialist (MCTS), Business Intelligence, SQL Server 2005

Microsoft Database Administrator (MCDBA), SQL Server 2000

Microsoft Solution Developer (MCSD)

Microsoft Systems Engineer (MCSE)

Expertise

Business intelligence solution design and development. Business analysis. Requirements gathering. Project planning. SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server 2008, SQL Server 2005, SQL Server 2000. Data warehouse design and implementation. ETL. OLAP. Report authoring. Multiple sources data integration. Data cleansing. Data conforming. Data validation. Performance tuning. User education.

Publications

   Published technical articles with SQL Server Central:

Custom SSMS Shortcuts for ETL Developer. Part 1: SELECT in a Keystroke

Custom SSMS Shortcuts for ETL Developer. Part 2: Extended Properties

Custom SSMS Shortcuts for ETL Developer. Part 3: Source-Target Mapping

   Wrote ROI business intelligence blog posts at http://www.ReturnOnIntelligence.ca/ideas-advice/.