PROFILE

**+ years IT experience primarily in the Financial and Banking sector as a Business and Systems Analyst.

Demonstrated deep skills and experience gained working with various complex computerized financial systems, and providing support/expertise/training to staff, suppliers and customers.

Demonstrated analytical, documentation and communication skills, able to develop good business relationships with internal and external clients, and able to work independently with minimum supervision.

Demonstrated experience in software development life cycle (SDLC) methodology and practices, including Agile-SCRUM, CMMI, Waterfall methodologies and frameworks, using BABOK guide and recommendations.

Solid mathematical background (Quantitative Data analysis, Probability, Statistics, Random Processes).

EMPLOYMENT HISTORY

Adastra Corporation, Toronto Jan 2023 to Nov 2023

Data Analyst

Elicitation, elaboration, analysis and validation of business requirements and data needs.

Document and manage Data Quality rules and reports, Business and Technical requirement documentation.

Detailed analysis of current data flows, capture and document business requirements, design and modelling of solutions.

Conduct data analysis in support of applications and projects, including identifying and documenting business rules, data needs and data specifications.

Technical Environment: Amazon Work Space, Azure SQL Server, Azure Data Studio, JIRA, Confluence, Qlik View, Power BI

CIBC bank, Toronto Apr 2022 to Aug 2022

Sr. Business Systems Analyst

Data warehouse design project based on Big Data technology (FX, Fixed Income, Payments records).

Analysis of ISO 20022 format for Interac e-Transfer transactions

Mapping JSON REST API extracts to Big Data Warehouse objects

Design of ETL procedures for foreign exchange transactions based on Bank of Canada and Wallstreet FX data.

Technical Environment: Hadoop Cloudera, Impala, Hue, SQL querying, Postman, JIRA

Manulife, Toronto Nov 2019 to Feb 2022

Business/Systems/Data Analysis

Capital Market transactions data warehouse design project based on Big Data technology.

Collection of information and requirements from customers, as well as for data modeling, data wrangling, data onboarding and data analysis.

Identification of patterns, relationships and trends in large data sets

Documenting requirements for extraction, transfer and load of operational data across various platforms and asset classes including FX trades (Wallstreet and BOC FX rates).

Testing the REST API external data providers extracts using Swagger and Postman apps.

Corporate regulatory reporting project: gathering requirements, data source identification, source to report attributes mapping, design the Power BI reports layout, filters, data transformation logic. Data visualization using Power BI and Excel tools.

Working as part of the solution delivery team and providing inputs to enable the team to understand detailed “as is” processes and functional requirements.

Working with Developers, Testers and other data analysts to ensure design meets requirements and to verify the results of development.

Acting as a point of contact between business users and solution delivery team to document and clarify both requirements and design, to conduct user acceptance testing and production delivery, to support changes implementation requested by users.

Technical Environment: Hadoop Cloudera, Hortonworks, Oracle SQL Developer, HiveQL scripts, Kerberos authentication, Python, Power BI, Salesforce, Salesforce Data Loader, Azure SQL Server, Postman, Swagger, JIRA

Auto Case Financial, Toronto Oct 2018 to July 2019

Business Systems Consultant

Consulting in various methods and IT systems for large datasets processing. Set up, configuration and administration of Oracle and SQL Server databases, Oracle SQL developer tool. Assisted in creation of complicated PL/SQL, T-SQL queries and scripts for data analysis and reporting.

Data analysis using Statistical and Machine Learning methods (Python, R), visualization of data analysis results using R and Power BI tools.

Canadian Tire Corporation, Toronto May 2018 to Aug 2018

Sr. Business Systems/Data Analyst

Consulting with business subject matter experts for development requests, making recommendations for the business solution, process and work flows.

Documented requirements, prepared presentations to translate customer’s development request into technical terminology, including user stories, use cases and test cases.

Support and Optimization of SQL complex queries to improve the efficiency of BI reports. Automation of SQL queries testing using Python scripts.

Technical Environment: PeopleSoft 9.2, PeopleSoft Application Designer, Send Master, Oracle SQL

Developer, PL/SQL scripts, Oracle SQL queries and stored procedures, PeopleCode scripts, VB.NET, Power BI, JIRA

Ontario Lottery and Gaming Corporation (OLG), Toronto May 2016 to Apr 2018

Sr. Business Analyst

Provided a comprehensive range of IT business analysis services for clients with diverse business and technology needs.

Technical Environment: MS-Office (Word, Excel, Visio, Power Point), SQL Server, Power BI

Bank of Nova Scotia, Toronto May 2015 to Dec 2015

Business Systems/Data Analyst, Customer MDM Solutions

Responsible for analysis of business systems, interface development, usability concepts, and industry requirements.

Supported data and functionalities migration from AS400 mainframe applications to IBM Infosphere MDM using Agile framework.

Worked with stakeholders to interpret & understand requirements and transform them to user stories and system specifications.

Complex SQL queries and stored procedures design, testing, development support and implementation. Analysis and support of VB.NET applications – resolving issues, optimization, adjustments to meet the new requirements.

Management of work of project team (BA, 2 Developers, Legacy System analyst)

Technical Environment: DB2, IBM Infosphere (MDM), dB Visualizer, UNIX, VB.NET, Python, MS Office (Outlook, Visio, Excel, Word, VBA), DB2 SQL queries and stored procedures

SEARS Canada, Toronto Apr 2014 to Nov 2014

Sr. Business System Analyst/Data Modeler

Responsible for creating a data analysis solution with reliability, scalability and reusability in mind.

Provided data architect/data modeler support using logical and dimensional modelling technic to ensure business data requirements are realized in strategic architecture of the warehouse.

Design of Financial System Logical Data Model (FSLDM) for Oracle to Netezza data integration and reconciliation using SQL queries.

Designed, developed, tested and implemented ETL packages.

Maintenance, issue resolution, support Great Plains users.

Technical Environment: Oracle, TOAD, ERWIN, Netezza, Aginity Workbench, VB.NET, Python, MS Office (Outlook, Visio, Excel, Word, VBA), DataStage, Netezza SQL queries and stored procedures, Great Plains

BMO Capital Markets Group, Toronto Nov 2013 to Apr 2014

Business System Analyst

Responsible for analysis of applicable Capital market business systems, interface development, usability concepts, and industry requirements.

Provided analysis of Basel III wholesales credit risk, interest risk and market risk parameters calculations, design of determination of the Asset Class, FX rates, LGD, EAD, PD and other coefficients, bond and derivative math calculations.

Defined user procedures, evaluated alternative workflow solutions, developed conversion and implementation strategies and verified conversion using complex SQL queries, provided user documentation and user training

Technical Environment: Oracle, TOAD, TOAD Data Modeler, ERWIN, Oracle SQL queries, MS Office (Outlook, Visio, Excel, Word), SharePoint 2010, Oracle SQL queries and stored procedures

Temenos Canada Inc., Mississauga Apr 2012 to Oct 2013

Financial / Business Systems Analyst

Responsible for analysis of applicable business systems, interface development, usability concepts, and industry requirements in the Wealth Management domain.

Participated in all stages of SDLC and was responsible for analysis of current state and understanding the "to-be" (future state) processes and procedures according to the stakeholders’ and user requirements

Develop specifications for business processes, processing workflows and data flows for various financial asset classes (equities, fixed income, FX, commodity, and rates) and derivative products.

Analyzed and profiled client large datasets using SQL queries

Technical Environment: HP QC, Oracle SQL Developer, Perl, UNIX, Fitnesse QA tool, SQL Server, SSIS, Excel Macros, SVN Tortoise, Java, Eclipse, XML, Web Services (REST API), PuTTY, FileZilla, PL/SQL, VB.NET and Python scripts, Oracle SQL queries and stored procedures, MS Office (Outlook, Visio, Excel, Word, PowerPoint, VBA), MS Project.

TD Bank, CSTS Risk Solution, Toronto Feb 2011 to Aug 2011

Sr. BSA/QA Analyst

BMO Capital Markets Group, Toronto Dec 2009 to Dec 2010

Sr. Business System Analyst

Citi Cards Canada, Toronto Oct 2007 to Oct 2008

Sr. Business System Analyst/Data Architect

RBC Dexia Investor Services, Toronto Feb 2007 to Jul 2007

Financial/Business System Analyst

TD Bank Financial Group, Toronto May 2006 to Dec 2006

Sr. Business Analyst/Project management

Coventree Capital Group Inc., Toronto Sep 2005 to Apr 2006

Implementation/Data Analyst

TD Bank Financial Group, Toronto Mar 2004 to Jun 2005

Sr. Financial Analyst

Ajilon Communication Canada, Toronto Jul 2003 to Feb 2004

Sr. Financial Analyst

Open Access Limited, Toronto Jan 2001 to Mar 2003

Business System/Data Analyst

EDUCATION AND PROFESSIONAL DEVELOPMENT

CGA Ontario Program 1999 to 2003

MSc (with Honors), PhD (Applied Math & Statistics)

State University of Physics and Technology, Moscow (Evaluated by York University).

Contact this candidate