Architect

Steven Valkov – Architect, Coach, Team Lead

** ******* **, *******, **, M8Y 1L7

c. 905-***-****, ******.******@*****.***, www.linkedin.com/in/stevensvilenvalkov

Solid and superior IT Expert with over 12 years experience as an Enterprise Solutions and Data Architect, Coach, and Team lead. Leader in defining system and application architecture requirements customized BI data workflows, creating data models and preparing business documentation and specifications. Analyse, easily negotiate, visualize and conceptualize complex business requirements, support the performance of ETL and SQL programming tasks and engage in database migrations. Well rounded IT Expert with solid managerial and hands on experience with numerous world-known clients, diverse projects, different teams, state of art technologies and tools. Experienced mentor, excellent communicator and motivator with exceptional analytical, interpersonal and problem solving skills.

Company

Position

Dates

Enterprise Architect

May 2012 - Present

Royal & Sun Alliance Insurance

Data Architect and Modeller

Oct 2011 - Apr 2012

IT Team Lead and Architect

Dec 2010 - June 2011

TD Securities / RVR Risk Dept

Data and Migrations Architect

May 2010 - Nov 2010

Senior Architect, Database Administrator

Nov 2008 - May 2010

Bawag P.S.K. / Much-Net / EuroRisk

Lead Data EDM Architect

Feb 2006 - Apr 2008

SysMaster / VoiceMaster

Senior Data Architect

Mar 2005 - Dec 2005

Data Architect, Team Lead

Oct 2001 - Mar 2005

Area

Proficiency

Technology

Data Warehousing (EDW), MDM, EDM, SDM, CDM, LDM, Vendor/OTS Selection and Implementation, POC - Proof of concept, Business and Technical Standards and policies, ETL/BI, Data Marts, Data Mapping, Business Processes and Data Flow, ERP, SDLC, VOIP, Reporting, Java/J2EE/ESB/JSF/JSP, .Net, Web Services, Apache/Tomcat, IIS, SOAP, XML, XSD, SOA, HR/Payroll, POS, Financials, Brokerage, Securities

Portfolio

Banking/Finance, Capital Markets, Wealth Management, Credit Risk, Compliance, Insurance, Government, Telecoms, Entertainment, Food Industry

Platforms

PeopleSoft, JD Edwards, SAP, Experian, Basel 2/3, Symantec, Murex, MaRRs, Encompass, TOH/FX, Infor, Vista, Cognos, DataStage, Much-Net, MicroStrategy, Koku/Koli, Clips, WorkBrain, WorkForce, HUON, Duck Creek

Databases

Oracle 8.05-11.2, MS SQL Server 7-2008, MySQL(INNODB,MyISAM), Sybase 11-12, DB2 9, PostgreSQL, Adabas, MaxDB, Access

Tools

ERwin, Embarcadero, Toad, Idera, Power Designer, Visio, VS, Red Gate, SQL Compare, Dia, DM

Programming

PL/SQL, T-SQL, Java, .Net, C/CGI PHP, ASP, HTML/JS, Shell/Bash/VBS/Cmd/ ETL, SSAS/SSIS/SSRS, Cobol, MQ

Virtualization

VMware, Hyper-V, Xen, Virtual PC/Server, KVM, QEMU, Chroot, Linux-Vserver

OS

Windows, Linux Red Hat(CentOS)/Debian/Ubuntu, UNIX AIX/HPUX/Solaris

IBM Canada

Enterprise Architect

2012 – Present

IBM is one of the largest technology, services and consulting organizations in Canada, home to the largest team of IBM software professionals outside of the United States.

Responsibilities: Defined enterprise system and solution architecture for business processes and application conceptualized continuity Provide POF - Proof of concept for OTS with vendor selections and following implementationOrganized and negotiated application dependencies, SLAs, RPOs, RTOs Advised application and database high-performance (HP), high-availability (HA), disaster recovery (DR) patternsPrepared high-availability (HA), disaster-recovery (DR) scenarios and combined overview patternsConsidered testing and recovery technologies in 24x7 environment Developed a high level road-map for migrations and high level patterns and Data Centre support for over 3000 databases and more than a hundred mission critical diverse systems Optimized backup and recovery strategies and policies for availably and monitoringAdded recovery considerations and risk assessment for redundancy and TCO improvementsProof of concept and business case scenario for custom and OTS decision and implementation process

Environment:

SQL Server, Sybase, My SQL, VMware, Access, SharePoint, BizTalk, AIX, Visio, HA, DR, Enterprise Architecture, MDM, ERD, SAAS

Royal & Sun Alliance Insurance (RSA)

Data Architect and Modeller

2011 – 2012

RSA is one of the world's leading multinational insurance groups with almost 300 years of experience and over 20 million customers worldwide.

Responsibilities:Organized and negotiated data and application architecture requirements, defining customized business procedures and processesAllowed data management to share information on the business strategies and practical implementation realities associated with effectively managing data assets on an enterprise-wide basisCreated comprehensive data infrastructures for global and specific market risks and reporting. With mark-to-market and value-at-risk processes, as well as the generation of end-of-day portfolio valuations and market risks.Performed data quality analytical processing, define data dependencies and provide advice for data error, inconsistencies and issuesOrganized high level enterprise architecture best practises, guidelines and standards for modelling and development Defined mapping templates and usage samples over the life-time of the project, supported centralized KB structures and access proceduresBuilt and visualized logical multi-dimensional multi-layer model with metadata support, ETL migration objectsConceptualized business requirements, performance needs of ETL and SQL tasks and engage in data migrations.Supported building of a Teradata industry logical model based customized Enterprise Data Warehouse with multi-dimensional design for a major MicroStrategy implementationConducted migration between different databases and versions of the DB2, Teradata, and Access.Developed customized scripts DB2/Teradata for data transformations and verification and reverse engineering of relational objects and constraintsCoached a team of BA, Modellers and DBAs in defining business workflow, data structures modelling and ETL mappingDefined knowledge-base articles, templates and programming, modelling techniquesVisualized data flows and integrated procedures in the context of Teradata industry LDMExplained historical warehouse procedure and delta changing dimensions warehouseDocumented and explained in team and one-to-one sessions good industry practices

Environment: DB2, Teradata, MicroStrategy, Erwin, Visio, Access, SharePoint, Lotus Notes, Solution, Data Architecture/Modelling, CDM, LDM, MDM, EDW, ERD, COBOL, MQ, HUON, Duck Creek

Cara Operations

IT Team Lead and Architect

2010 – 2011

Canadian legend with 125 year history, Canada's largest restaurant operator, Cara operates Swiss Chalet, Harvey's, Montana's, Kelsey's, Milestone's and other brands. Cara has 1200 restaurants and more the 35,000 employees with revenue of over 2 billion dollars.

Responsibilities:Managed an IT team of DBA, BA, networking and system support in a 24/7 production environmentSupported clustering and three tier HA/DR model with mirroring, backups and enterprise availability Virtualized multiple production and development system and database environmentDeveloped systems and application architecture achieving competitive enterprise advantagesLed an IT support and development team in a 24/7 multi-terabyte production environment:Supervised administration of hundreds of critical SQL Server databases version 2005 to 2008Supported deployments and maintenance of hundreds of systems and multi-terabyte databasesPlanned and created disaster recovery (DR) centres and migrated data in multiple locationsCoached a team of DBAs, BAs and database developers in SQL/T-SQL, ETL, SSIS, and SSASSupported knowledge-base articles and advanced documented programming objects and snippetsDefined data and systems standards and implementation policiesNegotiated and conceptualized enterprise business standardsVisualized system and application architecture for multi-dimensional and in-house systemsDefined archived historical warehouse with analysis data and achieved greater performanceCustomized BI data workflow from various solution-oriented systemsDocumented workflow processes and defined best industry practices

Environment: MS SQL Server 2008/2005/2000, Oracle, My SQL, Sybase, MicroStrategy, SharePoint, Windows, Embarcadero, Idera, Red Gate, OLAP, Cubes, Hyperion, JD Edwards, Large POS, Inventory Apps, Teradata, Java/ESB, CDM, MDM, EDW

TD Securities

Data and Migrations Architect

2010

TD Securities is Canada's leading provider of advisory, liquidity and capital market services, part of Toronto-Dominion Bank (TD) Group, the second largest bank in Canada by market capitalization and deposits and the sixth largest bank in North America.

Responsibilities:Developed solutions that create a single source and integrated platform of trusted data, to improve information quality and efficiency throughout an enterprise. It creates, validates, and publishes a trusted warehouse and possibly real time and in multiple formats. Allowed data management solutions making it easier to access standard content from data vendors, with ability to link product and entity information with near real time transactions and positions, leveraging operational control into financial control.Migrated 80 production databases between MS SQL Server 2000 to 2005 with complex scenarios, related business object keeping stable environment and optimizing dataflowResponsible for security audit advanced scripting, thousands of objects, changing permissions and hardening security achieving company and government standardized compliance with the latest technologiesOrganized and implemented sustainable restore and backup deployment templates for new and existing database deployment, maintaining communication with technical and business teamsCoached a team of database analysts in advanced enterprise SQL/T-SQL programming techniquesIntegrated market data feeds used for risk valuations and decision support Defined knowledge-base articles and advanced documentation of programming objects and snippetsResponsible for MS SQL Server configurations testing and parameter optimizations with unit testing and deploymentsDefined new applications and reverse engineered existing programming codeNegotiated and conceptualized business requirements and optimized business rules for risk trading with Murex, Forex and 3rd party platformsPrepared business documentation, specification and application diagramsConducted packages deployment, full patching updates and unit testingResolved software in-time issues increasing financial responsibility, up-time and stability Standardized row auditing and design practices, and architecture for reusable template IT subsystemsMaximized performance for ETL objects and maintained low TCO and high performance Defined data design and workflows for customized trading and brokerage ETL applications Planned the Risk Management system for the banking wholesale teams Updated GMO financial hierarchy and dynamic input from Murex, MaRRs, Encopass and GRIDTrained client teams in usage and configuration of custom applications Created the architecture for the advanced hardened new model for permissions for security auditsPrepared and planned security subsystem and changed the code of thousands of objectsConceptualized online change of objects without change of business distributed transactionsPrepared templates for security audit in accordance with industry and government standardsDefined data and coding templates as part of a knowledge-base for DB coaching Planned, documented and handed-off sets of standardized templatesCoached database analyst in advance SQL and T-SQL techniques and technologiesMentored replacement developers and business staff

Environment: MS SQL Server 2005/2000, Brokerage, Securities, Red Gate, MS SharePoint, CA workflow, Windows, MKS, CVS, Murex, MaRRs, Encompass, TOH/FX, Stress Limit, GPM, CDM, LDM, MDM, EDW, Migrations, SAS, SAAS

Cineplex Entertainment LP

Senior Architect, Database Administrator

2008 – 2010

Cineplex is the largest Canadian entertainment corporation, with over 9000 employees & 140 locations with over 1,300 screens serving more than 70 million guests annually.

Responsibilities:Migrated Live PeopleSoft ERP from version 8.9 to 9.0 and upgraded Oracle databases from Oracle version 9 release 2 to Oracle version 10 release 2 with full patching updates and unit testing, achieving non-stoppable workflow and financial and organizational accelerationOrganized and achieved a stable and self-sustainable Oracle environment and delivered state of the art backup and daily automated restore bringing downtime from 85% to the four nines (99.99%)Standardized design guidance and best practices for database and system architecture, naming and development, conceptualizing clients business goals and delivering model IT subsystems .Net, Java/ESB and proprietary codeMaximized performance and minimized costs for HR(Infor) and POS(Vista) MS SQL Server systems Supported a team of a dozen developers, computer support and PeopleSoft migration expertsPlaned system and database timelines and resource requirementsConceptualized clients' business goal and planned the IT subsystems implementations Mentored and coached software teams, technical support and junior personnel Integrated PeopleSoft ERP from 8.9 to 9.0 version and optimized large Oracle databases (VLDB) Fully transformed database configurations and objects for definite financial performance gainMigrated metadata and data for 150 thousand objects and more than 500 million recordsTweaked windows configurations and CMD/VBS scripting, Oracle internal and external jobsOptimized financial, ledger operations and support, dealing with distributed business units and trees in hundreds of locations and pleads of external partners, clients and systemsConceptualized the data architecture for databases, operating systems and infrastructureCreated system and database naming and development standards Defined database templates for setup, objects, audit, historization and metadataDefined logical and physical multi-dimensional cube structures in both Cognos and SSAS Supervised Oracle 10g and 160 MS SQL Server instances for development, testing and productionPerfected and documented OS parameters, database installation and configurationsDefined automated backup, restore and standby strategies and Rman and hot backup scriptsMigrated data structures between heterogeneous sources and destinations with complex ETLMigrated data and metadata between Oracle 11g/10g/9i and MS SQL Server 2008/2005Defined automated data interfaces between MS SQL Server and Oracle in a transparent fashion Replicated and synchronized data changes with error handling and dataflow control

Environment:Oracle 11g/10g/9i, SQL Server 2000–2008, My SQL, PeopleSoft, INFOR/WorkBrain, VISTA, Cognos, Windows, Java/ESB, CDM, LDM, MDM, EDW, ERD, SAAS

BAWAG P.S.K. / Much-Net / EuroRisk Systems

Lead Data EDM Architect

2006 – 2008

BAWAG P.S.K. is one of the largest European financial groups with 7-10 million customers in 7 countries. Bank f r Arbeit und Wirtschaft und sterreichische Postsparkasse Aktiengesellschaft(BAWAG P.S.K.) has over 120 years history and is one of the largest banks in Austria, operating more than 150 BAWAG branches and 1,300 P.S.K. post offices. The group has banking units in Germany, Malta, Slovenia, Hungary, Czech Republic and Libya. By 2004, the bank had assets of 56.2 billion euros, and a 170 million-euro annual profit.

Responsibilities:Defined architecture and negotiated requirements for the Central EDM, MDM Data Warehouse compiling via complex customized proprietary high-end MDM/ETL/BI/Risk/Java/ESB/JSF, Brokerage and Credit modulesImplemented integrated capital markets platform for Much Net with Market Data interfaces (for live feeds from Reuters and other market data source in real time and near real time)Responsible to collect, standardize, consolidate, and manage information about securities, products, customers, transactions, and other operations, to better manage the distribution of critical data to business applications.Standardized prices and curves in commodity data environments, combining off-the-shelf feed handlers with a data standardization process, with the ability to generate commodity forward curves such as straight par futures par curves, spread curves and swap spread curves, for efficient commodity data management.Defined unique data model and framework that covers all financial instruments, customers and counterparties, and extends to transactions and positions based on Canadian rule based engine and Java/ESB/JSF, Apache/Tomcat, SolarisAdded ability to connect, organize and aggregate trusted information that helps customers achieve their business goals by reducing risk and enabling better decisions making. The framework solutions are used by forward-looking banks, brokers, investment managers, service providers, and exchanges to reconcile tactical departmental goals and strategic enterprise objectives mainly across EU.Allowed higher financial and credit standards by providing central repository with hundreds of tables and terabytes of allowing financial expansion to tens of millions clients and unlimited successionsOptimized operations on tens of billions of records with time efficient ETL with up to 500.000 records per minute, allowing BI engine calculations, statistics and limit hierarchiesCoached a dedicated team of five DBAs and defined best practices allowing fast deployment and system optimizations thus ensuring the adoption of our solution versa external vendors as SAPConceptualized the entire Central Banking Data Warehouse, subsystems KOKU, KOLIPrepared the solution used by seven million clients from seven countries with a handful of systems and cultural differences, working with multiple business and tech stakeholdersHeaded database development of a multi-terabyte (10 billion records) Centralized Banking Warehouse Supervised a database development of an agile team of database interface Java Developer and two JSF Application Developers between 2005 and 2008 fulfilling the needs of the financial group B.A.W.A.G. P.S.K. and being preferred as the ASP provider versus very popular names like S.A.PManaged complex customized Marketing, Credit and Risk Assignment Centralized Data Warehouse with major BI element (based on the Canadian engine "Clips")Successfully implemented two stages of the project for less than three years saving million in software development costs and protecting the client from further negative credit exposureCoached five DBA teams on the client's site and defined requirements with management and IT staff negotiating implementation policies and timeframesUtilized Oracle 10/9 in Solaris/AIX/Red hat environment and relied on technologies as partitioning, merges, external tables, customer database java sourcesScaled database and interfaces for 15-20 million of customers with UTF conversion, ETL, data matching and cleansing of multi-lingual financial and client data from seven countriesManaged IT teams and Data Architecture (DSS, OLAP) for enterprise systems and databasesNegotiated business requirements and project scope with high level managementCoached and trained DBAs for implementation of standards and best practicesImplemented standards and data configuration templates for audit, multi-language, and IOT historySupervised ETL, imports and exports for multiple terabyte datasets with security and access controlDeveloped architecture for import of ~500.000 rows per minute with Oracle external templates Normalized materialized view, tables and vertical/horizontal partitions of 200 million rowsSetup database links, detailed logging in all levels – successful, bad and rejected rowsMigrated data and databases between heterogeneous sources and destinations with complex ETLMigrated data and metadata between Oracle 10/9 and MS SQL Server 2005/2000Designed data migration and data cleansing with MS SQL Server 2005/2000 and Oracle 10/9Replicated delta changes between heterogeneous systems with DAL interface layerSupported Business Intelligence (BI) engine for assignment of financial and risk limitsOptimized OLAP hierarchy aggregation related trees as views and change triggersDesigned rule based data interfaces for duplication searches and conditional calculations Managed 12 Oracle 10/9 and seven MS SQL Server 2005/2000 databases for development and testingMaintained, tuned, patched and administered storage, backups/recovery and scripting Supported environment of Linux Red Hat (RHEL/CentOS), Solaris and VMware

Environment: Oracle, MS SQL Server, My SQL, DB2, Teradata, Linux Red Hat (CentOS), Solaris, EDM, SDM, MDM, EDW, ETL, BI, Brokerage, Securities, Compliance, Basel 2/3, Java/ESB/JSF, CDM, LDM, ERD, SAAS

SysMaster

Senior Data Architect

2005

Responsibilities:Supported VOIP billing and Quadruple Play database for VoiceMaster VOIP billing softwareCustomized logging of deadlocks/locks, system monitoring, audit, access and statementsDefined Quadruple Play system (VOD/PPV/Live) billing, sessions re-initialization and playlistsProgrammed Linux (Red Hat 7.2) for bash scripting, cron tasks, monitoring and C/CGIMigrated data and databases between heterogeneous sources and destinations with complex ETLMigrated data and metadata from Sybase to MS SQL Server 2000Defined interfaces for ETL of text data into Sybase databases object with custom replication

Environment: Sybase, My SQL, MS SQL Server, Red Hat Linux, Fedora, Windows, C/C++/CGI

Soci t G n rale EB Bank

Data Architect, Team Lead

2001 – 2005

SocGen EB is a division of Soci t G n rale which employs 120,000 people in 80 countries and is the 3rd largest corporate and investment bank in the Eurozone and the 20th largest retail bank in the world. In France, Soci t G n rale is active in retail banking with more than 2,700 branches (including its Cr dit du Nord banking division). Soci t G n rale (Euronext: GLE) is one of the main European financial services companies totalling in 2009 a revenue of 21.73 billion.

Responsibilities:Managed and coached DBAs and Application Developers leaving a stable and wholesome of trained MS SQL Server and Oracle team minimizing downtimes to less than 5%Conceptualized and managed Central Bank EDM Data Warehouse with over five million transactions daily, 120 locations, automated ETL entry and complex BI and management decisions reportingMet with internal and external client and designed all the reporting and data supportDefined system, database, hardware, backups and restore standards used more than 8 yearsCollaborate with multiple teams to choose, define and construct business and technical use cases for a proof of concept with TCO analysis in choosing enterprise solutions and preferred vendorsManaged and supervised major implementation stages of a three year project for integration of a customized banking ERP software "Thrace" Working with Market Data (live feeds from Reuters and other Market Data Sources, in real and near real time)Led Product Integration and organized database implementation of Core Experian Credit Risk Scoring (Transact/PPI) as well as define standards and classifications for a securities and Brokerage systems Setup all minor banking subsystems as debit/credit card payments and assetsConsidered and assigned implementations of database and applications development teamsManaged development of a terabyte (2 to 3 billion records) SGEB Banking Data Warehouse VLDB Led a team of two Database Programmers and four (to six at times) Front-End Programmers developing a Banking Data Warehouse based on MS SQL Server 2000, DTS, VBS, CMD between 2002 and 2004 Consolidated partition ranges through views, complex triggers (800 million records) and federated tables allowing centralizing ETL input from 120 location with error-handling and notificationsFacilitated historical versions with time machine information up to any date in the pastDefined and enforced standards and conventions for data management in the organization Headed a DBA department team DBAs, BAs, .NET, Java/ESB and Delphi Developers Hired, trained and coached junior and mid-level DBA personnel Defined task and assessed employee performance and professional profilesAuthorized purchase of hardware and software and custom, VB, .Net, Java/ESB, etc., developmentEstablished in-house Business Intelligence (BI), DSS and OLAP databases for events and trendsDefined requirements and automated management reports for balance and credit trendsDeveloped hierarchy objects, rule-based triggers for multi-table, multi-rows operations, and history auditDevised materialized views and stored procedures for tuning of front applicationsMigrated data and databases between heterogeneous complex ETL (DTS, VBS, CMD)Defined MDM Product evaluations and map core banking, security related vendor feeds, government compliance feed into the client's master data model within different sub-groups. Migrated data and metadata from MS SQL Server 7 to 2000 and beta-version 2005 YukonMigrated data and performed ETL, BI from MS Access 2000/2002/2003 to MS SQL Server 2000 Migrated custom inventory data from Oracle 9 to MS SQL Server 2000 with proprietary scriptingDesigned data migration and data cleansing from MS SQL Server 2000 to Oracle 9Automated ETL from/to MS SQL Server, MS Access, Excel, DBF, CSV, PDF, HTML, OracleCoordinated access for heterogeneous sources/destination via database linked serversHarvested HTML web parses, Windows domain information (ADSI) and lob/blob objectsOrganized databases for five Experian Credit Risk Scoring systems (Transact/ PPI)Designed scheduled multistage ETL and metadata transformations (> 1600 rows T-SQL)Operated multi-node application level fail-over cluster (Windows and MS SQL Server)Modelled Black List, in-house negative accidents and documents database for unwanted clientsManaged corporate and individual clients, statistics, and multilevel hierarchiesAttained debts and court (internal/external), (Internet, newspapers) with trust percentageArranged document management with history of packaging, senders (recipients) and blobsAdvised database architecture for Phone Banking IVR (Alcatel PBX) systemDesigned the login system, sessions prompts and client information and linked users

Contact this candidate