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
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/.