Konstantin Medvedev

Konstantin Medvedev

Toronto, Canada
Hire Konstantin
Scroll To View More
Konstantin Medvedev

Konstantin Medvedev

Toronto, 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
Portfolio
Experience
  • Financial Data, 19 years
  • Database Performance, 15 years
  • Performance Metrics, 12 years
  • Performance testing, 12 years
  • Query optimization, 12 years
  • T-SQL, 7 years
  • Agile Software Development, 3 years
Toronto, Canada
Availability
Part-time
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
Employment
  • Sr. Business Analyst
    Royal Bank of Canada
    2016 - PRESENT
    • 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
    Incryptes Ltd
    2014 - 2015
    • 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
    Royal Bank of Canada
    2010 - 2014
    • 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
    Deutsche Bank
    2003 - 2009
    • 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
    Savings Bank of the Russian Federation
    1996 - 2003
    • 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
Skills
  • Languages
    T-SQL, SQL, Excel VBA
  • Tools
    JIRA, Confluence, Excel, Visio
  • Paradigms
    Performance Metrics, Waterfall development, Agile Software Development
  • Storage
    Database Performance, MS SQL, Oracle PL/SQL, Oracle, Sybase, Teradata, PostgreSQL
  • Misc
    Performance testing, Investment Banking, Financial Data, Capital Markets, Currency Exchange, Stock Exchange, Query optimization, Stock Market Techinical Analysis, Bitcoin, Cryptocurrency, Algorithms, Algorithmic Trading, Risk Reporting
  • Platforms
    Datameer
Education
  • Bachelor's degree in Experimental Nuclear Physics
    National Research Nuclear University MEPhI (Moscow Engineering Physics Institute) - Moscow, Russia
    1991 - 1996
I really like this profile
Share it with others