• An Electrical Engineer with 10 years of experience in the IT field as a SQL/VBA Developer working for Canada Federal government and financial institutions. • Expert level in developing and supporting complex MS Office (Excel, Access, Word) custom applications using advanced VBA macros, ADO/DAO data object models. • Advanced levels in Excel formulas (VLOOKUP, SUMPRODUCT, SUMITS, OFFSET, CHOOSE, IFs, INDEX, MATCH) as well as in automatization by integrated Excel, Word, and Outlook data. • 5+ years of experience in database designing and managing Access, SQL and client-server architecture applying object-oriented concept using SQL queries, and stored procedures. • Profound skills in data analysis and data presentation using charts, dashboards, and Pivot Tables. • Proven knowledge of technologies: VB/VBA, MS Office, Excel, Access, Power Point, Visio, SQL, SSMS, HTML, Essbase, JSON, Share Point, BI Power Query, Agile (JIRA). • A high level of expertise in collecting, evaluating requirements from users, shareholders and translating them into effective and functional project solutions. • Excellent analytical, time management and problem-solving skills. • Self-starter, detail oriented and quick learner with ability to easily learn new applications and technologies. • Excellent inter-personal and customer service skills, team player, strong verbal, and written communication skills. • Strong work ethic and demonstration of professional standards. • Ability to deliver high results working with technical or non-technical people.

Rocco Todorovic

• An Electrical Engineer with 10 years of experience in the IT field as a SQL/VBA Developer working for Canada Federal government and financial institutions. • Expert level in developing and supporting complex MS Office (Excel, Access, Word) custom applications using advanced VBA macros, ADO/DAO data object models. • Advanced levels in Excel formulas (VLOOKUP, SUMPRODUCT, SUMITS, OFFSET, CHOOSE, IFs, INDEX, MATCH) as well as in automatization by integrated Excel, Word, and Outlook data. • 5+ years of experience in database designing and managing Access, SQL and client-server architecture applying object-oriented concept using SQL queries, and stored procedures. • Profound skills in data analysis and data presentation using charts, dashboards, and Pivot Tables. • Proven knowledge of technologies: VB/VBA, MS Office, Excel, Access, Power Point, Visio, SQL, SSMS, HTML, Essbase, JSON, Share Point, BI Power Query, Agile (JIRA). • A high level of expertise in collecting, evaluating requirements from users, shareholders and translating them into effective and functional project solutions. • Excellent analytical, time management and problem-solving skills. • Self-starter, detail oriented and quick learner with ability to easily learn new applications and technologies. • Excellent inter-personal and customer service skills, team player, strong verbal, and written communication skills. • Strong work ethic and demonstration of professional standards. • Ability to deliver high results working with technical or non-technical people.

Available to hire

• An Electrical Engineer with 10 years of experience in the IT field as a SQL/VBA Developer working for Canada Federal government and financial institutions.
• Expert level in developing and supporting complex MS Office (Excel, Access, Word) custom applications using advanced VBA macros, ADO/DAO data object models.
• Advanced levels in Excel formulas (VLOOKUP, SUMPRODUCT, SUMITS, OFFSET, CHOOSE, IFs, INDEX, MATCH) as well as in automatization by integrated Excel, Word, and Outlook data.
• 5+ years of experience in database designing and managing Access, SQL and client-server architecture applying object-oriented concept using SQL queries, and stored procedures.
• Profound skills in data analysis and data presentation using charts, dashboards, and Pivot Tables.
• Proven knowledge of technologies: VB/VBA, MS Office, Excel, Access, Power Point, Visio, SQL, SSMS, HTML, Essbase, JSON, Share Point, BI Power Query, Agile (JIRA).
• A high level of expertise in collecting, evaluating requirements from users, shareholders and translating them into effective and functional project solutions.
• Excellent analytical, time management and problem-solving skills.
• Self-starter, detail oriented and quick learner with ability to easily learn new applications and technologies.
• Excellent inter-personal and customer service skills, team player, strong verbal, and written communication skills.
• Strong work ethic and demonstration of professional standards.
• Ability to deliver high results working with technical or non-technical people.

See more

Work Experience

Business Analyst at Algal Engineering Ltd.
September 1, 2024 - May 1, 2025
Analyzed, planned and executed a data migration of 200,000 records from QuickBooks into Unanet CRM (SQL database) while maintaining data integrity. Conducted data quality assessments pre- and post-migration to ensure integrity and compliance. Developed and implemented data mapping strategies to ensure accurate data transfer. Utilized Excel Power Query ETL tool to extract, transform, and load data efficiently from QuickBooks. Wrote, executed SQL procedures to import and check data integrity after uploading. Updated the Document Management System CRM web application developed in PHP frontend and SQL backend by developing new SQL procedures and PHP functions.
VBA Excel Developer at Office of the Auditor General (OAG-BVG), Ottawa
January 1, 2024 - April 1, 2024
Analyzed the existing complex Excel PROXI Travel Template application used by Federal Government departments to justify travel expenses. Documented the analysis and developed a business model. Redesigned the tool and wrote and executed VBA Excel macros to implement new and improved existing functionalities; reduced manual effort from four hours to 15 minutes. Tested the tool, documented improvements, and provided knowledge transfer.
VBA Excel Application Support at EMPLOYMENT AND SOCIAL DEVELOPMENT CANADA (ESDC), Ottawa
May 1, 2022 - September 1, 2023
Collaborate with stakeholders to document project requirements regarding the CPPCM – Canada Pension Plan Calculation Model, an automated benefit calculation tool that uses MS Excel VBA templates. Analyzed the current solution and recommended modernization/improvements. Wrote new/modified VBA functionalities, and collaborated with IT to resolve production issues. Participated in Agile processes and daily scrums.
VBA Developer at TD TRUST – Retail Model Development, Toronto
October 1, 2021 - April 1, 2022
Developed an Excel 2019/365 application that fetches data from Excel and Word sources and generates Word reports (over 200 pages). Reduced reporting time from 2 days to minutes. Implemented text extraction, bookmarks, headings, Table of Contents, tables and formatting.
VBA Excel Developer at INNOVAPOST, Ottawa
March 1, 2021 - September 1, 2021
Developed an Excel 2016 application to consolidate, reconcile, and extract financial project budgets and costs from multiple Excel files; automated data access across folders and loaded into main app; created tables and PivotTables for analysis; assisted cloud migration team; tested and fixed issues.
VBA Excel Application Developer at CANADIAN HUMAN RIGHTS COMMISSION, Ottawa
July 1, 2020 - February 1, 2021
Developed Excel 2016 application for Ontario Pay Equity Act wage analysis; implemented formulas, VBA modules, charts, and dashboards; tested and provided support.
SQL/VBA Excel Application Developer at BMO
February 1, 2020 - June 1, 2020
Improved the Corporate Deposit Cash Management tool and weekly Excel reports; wrote SQL/VBA to fetch data from SQL Server; enhanced Excel functions for automation and reporting.
VBA Excel Developer at NATIONAL DEFENCE, Ottawa
December 1, 2019 - January 1, 2020
Collected requirements and modified an Excel DB; added worksheets, dashboards, pivot tables, charts, and dynamic data presentation; delivered user training.
VBA Excel Application Developer at BMO, Toronto
September 1, 2019 - November 1, 2019
Integrated two separate complex financial Excel applications into a single template; automated data import and updated client profiles; improved layout synchronization.
SQL/VBA Application Developer at DELLOITE, Toronto
September 1, 2018 - August 1, 2019
Updated complex corporate Excel applications; recoded VBA procedures, formulated formulas, and integrated data exchange with in-house systems; JSON export.
SQL/VBA Application Programmer IV at TD CANADA TRUST, Toronto
March 1, 2018 - August 1, 2018
Developed code in MS Access, SQL and VBA to support Business Analytics & Reporting; connected to SQL and SharePoint to download input data; built operational reports and automated daily/weekly/monthly reporting.
SQL/VBA Application Developer at BMO - Capital Markets, Toronto
March 1, 2015 - February 1, 2018
Enhanced CMR (Capital Market Reporting) application; front-end Access, back-end SQL Warehouse and Essbase; developed complex SQL procedures, functions and queries for P&L; exported results to Excel; automated daily/monthly/quarterly/yearly reports; implemented email templates; used SSMS and managed large data sets.

Education

Bachelor of Science in Electrical Engineering at Serbia
January 11, 2030 - December 9, 2025

Qualifications

Security Level II (Secret)
January 11, 2030 - December 9, 2025
PMP Examination Preparation Seminars
January 11, 2030 - December 9, 2025

Industry Experience

Government, Financial Services, Professional Services