Dmitry Lazarev

Dmitry Lazarev

Business Analyst - Consultant at Scotiabank

Mount Laurel, NJ


  • Business Analyst / Data Analyst / Technology Professional with 15 years in Financial Industry
  • Successful solutions delivery within large financial organizations covering Compliance, Regulatory Reporting, Trading, Back Office operations, Credit Risk Management, Wealth Management
  • Proficient in Data Extraction, Analysis, Processing and Transformation
  • Hands-on experience in eliciting requirements and preparing specifications, working with front-to-back office users as well as various technical teams and external vendors


2018 Mar - Present
Business Analyst - Consultant
Scotiabank / Toronto, ON
  • Implemented Finra Consolidated Audit Trail (CAT) reporting for Global Banking and Markets (Lead Business Analyst)
  • Implemented Nasdaq SMARTS US solution for Trade Surveillance Group (Lead Business Analyst)
  • Collected and analyzed bank's data to define scope and prepare requirements to cover equity markets activity
  • Prepared technical specification for development teams for data transformation and processing logic
  • Worked directly with vendors (Nasdaq, Fidessa) to clarify specifications, identify gaps and resolve any issues with provided systems

Tools: Python, Elasticsearch, SQL, FIX Protocol, Apache Nifi, JSON, JIRA

2014 Sep - 2018 Mar
Business Analyst, Team Lead
Royal Bank of Canada / Toronto, ON
  • Implemented Nasdaq SMARTS for US Trade Surveillance Team (Lead Business Analyst)
  • Performed Data acquisition and integration for NICE Actimize surveillance system for CA, US, European and Asian markets (Data Analyst)
  • Performed data collection, analysis, extraction, mapping, quality monitoring
  • Coordinated activities between various data providers, development teams and business stakeholders
  • Maintained Financial Products database and Pricing feeds (Bloomberg, Reuters) for various compliance systems
  • Supported regulatory requests

Tools: Microsoft SQL Server, Python, FIX Protocol, Excel, VBA, JIRA

2011 Jan - 2014 Sep
Senior Technical Systems Analyst
RBC Capital Markets / Toronto, ON
  • OpenLink Endur Upgrade Project (Technical Analyst)
  • Managed technical requirements for new system components roll-out - Databases, servers, application code, frameworks, disaster recovery
  • Automated and configured various processing tasks for data transfer, EOD reporting and simulation, IT controls
  • Led system deployment in virtual environment - Citrix, VMWare
  • Interacted with various groups to resolve issues or implement changes/fixes/improvements - Development, DBA, Infrastructure/Server Support, Application Access Control teams
  • Provided support for various business teams - Back Office, Front Office, Market Risk
2010 Mar - 2011 Jan
IT Business Analyst
TD Bank Financial Group / Toronto, ON
  • Managed requirements and supported Credit Risk Data Mart for various businesses and technology partners - Enterprise Credit Risk Reporting, Regulatory and Basel reporting, Credit Risk Modeling
  • Gathered requirements related to new functionality, improvements in data flows processing and reporting
  • Worked with development team to translate requirements and implement appropriate solutions
  • Performed testing and coordinated related change activities
  • Documented and updated specifications and internal processes, participated in audit activities
2008 Sep - 2009 Jul
IT Business Analyst
Barclays Capital / Moscow
  • Barclays Capital Russia office launch and integration of Expobank Financial markets division into Barclays global environment (Project Sirius)
  • Back Office and Finance Systems rollout: Organized JAD sessions with users, collected and documented requirements from Operations, Finance and Compliance departments Liaised with vendor to develop additional functionality and make improvements Compiled test scenarios, coordinated user testing and changes implementation Planned and installed production and UAT environments for Back Office and Finance systems based on 1C platform
  • Defined and documented disaster recovery requirements for the systems
  • Configured and supported brokerage systems, performed client software roll-out for Trading, Operations, Finance and Compliance departments: Bloomberg and Reuters terminals, Regulatory reporting system for Federal Financial Markets Service, OTC trades reporting system for Moscow Interbank Currency Exchange, CitiDirect Online banking system, Moscow Interbank Currency Exchange trading and Settlement terminals SWIFT terminals
2006 Aug - 2008 Sep
Sr Programmer Analyst
UBS Investment Bank / Moscow
  • Documented user requirements for improvements in OLYMPIC banking system, prepared detailed development specifications for vendor, organized related user acceptance testing sessions, coordinated changes implementation with infrastructure team
  • Designed, developed, documented and supported modules of data synchronization between internally developed Custody, Settlement, SWIFT server, Client Reporting systems located in Moscow, London and Zurich (iHub project) using Java and Informatica Powercenter: Collected and documented requirements for incoming and outgoing dataflows Provided detailed description of desired changes to all involved teams and vendors Programmed data interchange proxies Installed, configured and documented local Websphere MQ server for message-based iHub interfaces Provided support during UAT and Production stages
  • Developed queries and reporting front-end using SQL and Visual Basic for Custody and Settlement systems
2005 Aug - 2006 Aug
Database Analyst
Citibank / Moscow
  • Provided daily support for datawarehouse based on MS-SQL server within Strategic Analytics Unit (SAU) (used for collecting and analyzing data about Citi retail banking activities in Russia)
  • Collected requirements and analyzed different banking systems / data sources for further data extraction
  • Designed data-mapping rules, dataflows, source data parsing models
  • Changed and added new data structures to datawarehouse for detailed elaboration of information representation
  • Developed ad-hoc analytical and data extraction reports for senior managers and colleagues
  • Controlled and documented changes in datawarehouse using approved procedures
  • Implemented and improved data integrity checking procedures
  • Automated batches monitoring / notification scripts
  • Liaised with other global teams to resolve and escalate all DBA and loading issues
  • Provided administration and access control to datawarehouse
2004 Jan - 2005 Jan
IT Specialist, Co-Op
Philips Electronics / Moscow


National Research University Of Electronic Technology
Bachelor of Science, Computer Science

Bachelor of Science, 2006

National Research University Of Electronic Technology, Moscow, Russia

Field: Computer Science