Konstantin Medvedev, Developer in Toronto, ON, Canada
Konstantin is available for hire
Hire Konstantin

Konstantin Medvedev

Verified Expert  in Engineering

Financial Data Developer

Location
Toronto, ON, Canada
Toptal Member Since
June 18, 2020

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.

Portfolio

Royal Bank of Canada
Datameer, Hadoop, Teradata, Sybase
Incryptes Ltd
Agile, Blockchain, Bitcoin, TFS, Microsoft SQL Server
Royal Bank of Canada
HP Quality Center (QC), Visio, SharePoint, Jira, ETL, T-SQL (Transact-SQL)...

Experience

Availability

Part-time

Preferred Environment

Teradata, Sybase, Oracle Database, Microsoft SQL Server

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

Work Experience

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: Datameer, Hadoop, Teradata, Sybase

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: Agile, Blockchain, Bitcoin, TFS, Microsoft SQL Server

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: HP Quality Center (QC), Visio, SharePoint, Jira, ETL, T-SQL (Transact-SQL), Microsoft SQL Server

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: XML, Visual Basic for Applications (VBA), Subversion (SVN), Jira, PL/SQL, Java, C++, Oracle

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: Visual Basic for Applications (VBA), PL/SQL, Oracle

P&L Reports Database

A profit and loss (P&L) report and full system balance—opens, closes, and turnovers—for the back-office database of an FX trading application.

Languages

SQL, T-SQL (Transact-SQL), C++, Java, XML, Visual Basic for Applications (VBA)

Tools

Microsoft Excel, Confluence, Jira, Visio, TFS, Subversion (SVN), HP Quality Center (QC)

Storage

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

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, Trading Applications

Paradigms

Agile Software Development, Waterfall Development, Agile, ETL

Platforms

Datameer, Oracle, Oracle Database, Blockchain, SharePoint

Frameworks

Hadoop

1991 - 1996

Bachelor's Degree in Experimental Nuclear Physics

National Research Nuclear University MEPhI (Moscow Engineering Physics Institute) - Moscow, Russia

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring