SQL Server 2008/2012/2014

SQL Server 2005/2008

SQL Server 7.0/2000

Visual Studio 6.0/.NET

Windows 2000/2003

Oracle9i Database

Certified Financial
Management Advisor

Project Management
Anton Svendrovski
Job History
Enbridge Inc. (Edmonton, Canada)
Position: Senior Data Architect (contract)
Designed and implementing operational data store (ODS) for Land Services group consolidating spatial and tabular data from various external and internal systems/vendors (including ArcGIS, Oracle, SharePoint lists and PostgreSQL)
Built and maintained ErWin data models for various layers of solution (staging, ODS, data warehouse, data marts and cubes) including meta-data, data dictionary, source-to-target mapping, business rules and definitions
Applied MDS principals and DQS components to implement centralized data management hub (ODS)
Created business intelligence reporting/visualizations and analytic solutions using PowerBI, DataZen, Tableu and SSRS
Developed ETL packages using SSIS, VB.NET modules, SQL stored procedures and internal ETL framework
Aug 2015 - Dec 2017
Public Consulting Group (Montreal, Canada)
Position: Senior Microsoft Business Intelligence Architect
Designed and implemented data warehouse solutions for multiple clients (school districts) using Microsoft SQL Server technology (SSIS, SSAS, SSRS) and internal ETL framework
Built data management systems to consolidate information from various sources (school information systems, financial, budget, accounting, HR, teacher performance applications, external files, state/province level test results)
Guided a team of BI developers through implementation of back-end/front-end and dashboards applying a variety of platforms (Performance Point, Silverlight Controls, DSPanel Performance Canvas, ASP.NET WebParts, SSRS)
Designed, managed implementation and support for a hosted multi-client EDW solution using SQL Server 2012 platform with Master Data Management (MDM) technology
Optimized performance of SQL-based data management solutions by implementing indexes, denormalization, functions
Jun 2011 - May 2015
Austin Water Utility (Austin, TX, USA)
Position: Data Architect (contract)
Reviewed current and future architecture, engineered Business Intelligence (BI) and reporting solution for seven subject areas of the company
Documented solution definition, conceptual data model, BI roadmap and ETL strategy
Engineered pilot system to demonstrate capabilities of EDW, SQL ETL (loading work order related data from Hansen and Infor EAM systems), Cognos BI and reporting, dashboard with KPIs
Oct 2009 - Jun 2011
Goldcorp Inc. (Toronto, CANADA)
Position: Project Architect (contract)
Reviewed current implementation of Land Asset Management (LAM) system and business requirements for the future
Helped to create conceptual architecture (domain model, use case model, application architecture) using Zachman approach
Provided technical assessment of various options for LAM system available to the client
Mar 2009 - Oct 2009
Manulife Financial (Toronto, CANADA)
Position: Senior Business Analyst (contract)
Reviewed and documented business processes of geographically diverse Sales Support group
Developed strategic roadmap and proposed series of operational and business process improvements
Developed logical data model and data dictionary for SQL data repository in Client Reporting group
Reviewed existing sources of data, created ETL requirements and helped to assess development costs
Aug 2008 - Jan 2009
Travel Insurance Coordinators (Toronto, CANADA)
Position: Technical Lead (contract)
Helped users to formulate business requirements for technology initiatives at TIC
Provided architecture solution to System Integration projects
Designed and developed dataload system to integrate multiple sources of insurance policies into a centralized data repository (IBIS)
Designed and developed one-time load process to bring agency information from retiring UNIX system
Documented solution at various levels (business, architecture, system design, users manual)
Nov 2007 - Aug 2008
Cryptologic Inc. (Toronto, CANADA)
Positions: Enterprise Information Architect, Senior Systems Analyst
Structured documentation process and requirements for Poker department to align it with PDLC framework
Managed implementation of truncation and archival system for main database components reducing storage requirements by 80% and improving performance of OLTP systems
Participated in systems analysis and design of integration components between internal and external licensees systems
Managed development of automated tool to perform regression testing of poker DB system (.NET, XML)
Documented structure of business databases and communication with game server and external components
Documented reporting systems and production environment architecture (for Sarbanes-Oxley compliance and gaming software certification initiatives)
Optimized storage solution for game logs using compressed XML objects in SQL database reducing space requirements by 90%
Created efficient business tool to manage Poker tournaments using .NET/XML Web services interface to SQL database storage
Participated in architecture/design projects to optimize system performance and address scalability/maintainability of SQL based solutions
Oct 2004 - Nov 2007
TD Bank Financial Group (Toronto, CANADA)
Position: Project Consultant/IT Solutions Developer
Managed intranet development project to calculate client investment risk based on client profile information
Developed SQL Server based application to translate/reconcile trades between two external systems FMCNet and SEI
Defined conversion procedures for CRM Janna including SQL database server upgrade
Developed SQL Server based application to reconcile positions between external custodian services (CIBC Mellon) and internal holdings
Coordinated design and development process of proxy reporting system for ADP IICC
Designed and implemented set of procedures to test new fee calculation process on SEI system
Coordinated CCP (credit processing application) countrywide rollout across Private Banking branches
Dec 2001 - Oct 2004
TD Waterhouse (Toronto, CANADA)
Position: Information Technology Analyst
Administered SQL 6.5/2000 as a database back-end for Janna CRM system in Private Client Group
Developed dataload process from mainframe environment (MPOWER system) to SQL database for financial client information as part of Canada Trust and TD Bank integration process
Developed number of VB programs and SQL scripts to perform/automate CRM front-end features changing data directly on SQL database
Modified and supported FMC Pages client performance reporting application (SQL Server 6.5/7.0, MS Access, Visual Basic)
Developed web-based system for online forms processing (ASP, SQL Server)
Oct 2000 - Dec 2001
  Facilitate IT Inc. (Toronto, CANADA)
Position: contract in Web site development
Developed internet-based barter site for Ontario Waste Materials Exchange (technologies used: ASP, VBScript, JavaScript, SQL Server)
May 2001 - Aug 2001
Canadian Federation of Independent Business (Toronto, CANADA)
Position: Systems Analyst
Redesigned Territory Management and Prospect Distillery System SQL Server based applications (stored procedures, DTS, SQL Mail, VB programs).
Created web based interface to facilitate the users requesting ACT format databases over the web.
Provided Contact Management software installation technical support (ACT 4.02, VPN, Archer, different versions of Internet Explorer and Windows operating systems). Provided technical support for the Territory Management application.
Investigated and researched Internet Security issue, IIS web server stability.
Administered SQL Server 6.5 and 7.0 (backup/restore, performance tuning, data transfer)
Assisted in table design and data testing in "eRock" project.
Feb 2000 - Oct 2000
Ryazan Orthopedic Workshop (Ryazan, RUSSIA)
Positions: Systems Analyst, Database Designer (contract)
Designed system model, and database structure
Designed client-server application using Microsoft SQL Server 7.0 and Visual Basic 6.0 (ADO)
Installed and configured Windows NT 4.0 Server and Windows 95/98 clients
Utilized Microsoft FoxPro for DOS to make a data transfer programs from DBF to SQL database
Nov 1999 - Dec 1999
  Computer Center "RITEK Plus" (Tomsk, RUSSIA)
Positions: Managing Director, Systems Analyst, Computer Trainer
Basic administration (managing) of the company, coordinating of the work in departments
Developed software using Microsoft FoxPro
Developed a customer keeping system using client/server technology (Microsoft SQL Server 7.0 and Microsoft Visual Basic 6.0)
Technical consulting for customers
Trained basic course (Microsoft Windows 95/98 and Microsoft Office), SQL Server Introduction
Jul 1993 - Dec 1999
Tomsk Orthopedic Workshop (Tomsk, RUSSIA)
Position: Computer Programmer (part-time)
Developed and applying software using Microsoft FoxPro, Visual C++
Maintained computer equipment and network (based on Microsoft Windows NT Server 4.0)
Trained employees using computers
Dec 1992 - Dec 1999
Tomsk Regional Ecology Group "SIBECO" (Tomsk, RUSSIA)
Position: Computer Programmer (part-time)
Developed the account and special software using Microsoft FoxPro, Visual Basic and Visual C++
Maintained computer hardware
Managed and controlled several projects: regional ecology lottery, Tomsk Yellow Pages company's information gathering and processing
Aug 1996 - May 1998

 Email: anton@antononline.com Web: www.antononline.com