Konstantin Medvedev, Financial Data Developer in Toronto, ON, Canada
Konstantin Medvedev

Financial Data Developer in Toronto, ON, Canada

Member since November 28, 2015
Konstantin is a software engineer with more than eighteen years of financial sector database work. He has long term experience in the development and performance optimization of large databases with diverse data structures. His SQL and DB creation skills are top-notch and he has an excellent grasp of ERP, ERM, and SQL scripts. He is a good communicator and works well with others.
Konstantin is now available for hire



  • Financial Data 19 years
  • Database Performance 15 years
  • Performance Analysis 12 years
  • Query Optimization 12 years
  • T-SQL 7 years
  • Agile Software Development 3 years


Toronto, ON, Canada



Preferred Environment

MS SQL, Oracle Database, Sybase, Teradata

The most amazing...

...I’ve coded is a branch of Simplex algorithm; its purpose was to deliver goods to its ultimate destination in an optimal way through a sequencing of locations


  • Sr. Business Analyst

    2016 - PRESENT
    Royal Bank of Canada
    • Validated the consistency of the client data aggregation system to the business requirements.
    • Created a layer of data quality validations for the risk-related data.
    • Reverse engineered the database source code and recovered lost specifications.
    • Made a cross-system data-health check.
    Technologies: Sybase, Teradata, Hadoop, Datameer
  • Database Developer and Business Analyst

    2014 - 2015
    Incryptes Ltd
    • Designed the database structure for Bitcoin exchange.
    • Leveraged the unparalleled command of state-of-the-art trading platforms and business systems to implement and calibrate NICE Actimize system to expand the bank's capacity for global trade surveillance, AML, and employee monitoring.
    • Responsible for complex data acquisition, analysis, modeling, mapping, and quality monitoring. Rendered and analyzed equity (EQ) and fixed income (FI) business models and performed ongoing maintenance of FI, EQ, and commodity product data.
    Technologies: MS SQL, TFS, Bitcoin, BlockChain, Agile
  • Business Systems Analyst

    2010 - 2014
    Royal Bank of Canada
    • Optimized existing T-SQL code and external queries.
    • Collaborated with business and development teams to verify project requirements and statuses.
    • Demonstrated and contributed deep knowledge of Global and Capital Markets (Equity and Fixed Income products on global exchanges) to advance the effectiveness and usability of organization's client systems, eSolutions, and wealth management technology portfolio.
    Technologies: MS SQL, T-SQL, HPQC, ETL, JIRA, SharePoint, Visio
  • Team Lead and Business Systems Analyst

    2003 - 2009
    Deutsche Bank
    • Led a team of C++, Java, and Oracle developers.
    • Optimized the database.
    • Provided extensive analysis of exchange trading rules, regulations, and requirements in the United Kingdom, Europe, Hong Kong, Korea, Singapore, Taiwan, Australia, and India to optimize equity trading platform for local specific requirements.
    • Created the novel graphical data analysis tool for algorithmic traders.
    • Successfully led microprojects including the ongoing improvements for Institutional Program Trading desk in London, the replacement of a MKI trading platform in Hong Kong, the replacement of an ODIN trading platform, the migration of an operation's cash business from Royal Blue Fidessa application to Arina, did disk-related data collection, worked with the Index Arbitrage, and the implementation of Sector-Swap.
    Technologies: Oracle, C++, Java, PL/SQL, JIRA, SVN, SourceForge, VBA, XML
  • System Analyst

    1996 - 2003
    Savings Bank of the Russian Federation
    • Migrated data from legacy systems to new Processing Engine and supported “go live” activities.
    • Designed and implemented an alert system to measure and monitor the payment processing system performance in short and long terms.
    • Skilfully managed performance and monitored processes of the bank's Oracle databases; providing comprehensive technical support for the users of the Oracle-based Central Payment Processing Engine.
    • Created PL/SQL procedures and implemented major changes to the database structure.
    Technologies: Oracle, PL/SQL, VBA


  • Languages

    SQL, T-SQL, Visual Basic for Applications (VBA)
  • Tools

    Microsoft Excel, Confluence, Jira, Visio
  • Storage

    Microsoft SQL Server, Database Performance, Oracle PL/SQL, Sybase, Teradata, PostgreSQL
  • Other

    Performance Analysis, Currency Exchange, Capital Markets, Financial Data, Query Optimization, Stock Exchange, Investment Banking, Algorithms, Bitcoin, Data Structures, Algorithmic Trading, Stock Market Techinical Analysis, Cryptocurrency, Risk Reporting
  • Paradigms

    Agile Software Development, Waterfall Development
  • Platforms

    Datameer, Oracle


  • Bachelor's degree in Experimental Nuclear Physics
    1991 - 1996
    National Research Nuclear University MEPhI (Moscow Engineering Physics Institute) - Moscow, Russia

To view more profiles

Join Toptal
Share it with others