With a comprehensive background in financial data analysis and a passion for in-depth statistical examination, I bring over 10 years of specialized experience in MS Access, SQL, Excel (DAX), Power BI, IBM AS400, Oracle, Cognos, and more. I provide insights, analytics and reporting to organizations of all sizes and industries to improve report accuracy and efficiency impacting strategic decision-making at all levels of management.

Carlo Reale

With a comprehensive background in financial data analysis and a passion for in-depth statistical examination, I bring over 10 years of specialized experience in MS Access, SQL, Excel (DAX), Power BI, IBM AS400, Oracle, Cognos, and more. I provide insights, analytics and reporting to organizations of all sizes and industries to improve report accuracy and efficiency impacting strategic decision-making at all levels of management.

Available to hire

With a comprehensive background in financial data analysis and a passion for in-depth statistical examination, I bring over 10 years of specialized experience in MS Access, SQL, Excel (DAX), Power BI, IBM AS400, Oracle, Cognos, and more.

I provide insights, analytics and reporting to organizations of all sizes and industries to improve report accuracy and efficiency impacting strategic decision-making at all levels of management.

See more

Language

English
Fluent

Work Experience

Master Data Analyst at Bimbo Bakeries
January 1, 2024 - February 28, 2025
Process master data requests in accordance with data governance policies and guidelines. Create and update master data records in the appropriate systems. Participate in the development and documentation of data maintenance processes. Maintain clear and up-to-date statuses on requests and incidents. Evaluate systems and processes to improve master data creation efficiency and accuracy. On-going housekeeping and data cleansing to guarantee all data records are consistently accurate. Primary tools: AS400, Oracle, MS Access, Excel (Pivot tables, V-X-Lookup, etc.)
Inventory Analyst at TD Bank
January 1, 2022 - February 28, 2023
Managed, maintained, various sources of inventory data for the TD Merchant Solutions Team. Developed and enhanced methods of analysis and reporting for management and vendors and providing insights and forecasting of POS equipment. As an experienced analyst and developer of reporting and dashboard creation I provided the team with solutions and training with – Power BI, Power Pivot, Power Query, SQL, Tableau and other methodologies and tools – used to bring insights and analysis to various departments and senior management. Developed KPIs, Metrics and Measures for tracking employee engagement, vendor and merchant satisfaction. Improved the delivery of numerus reporting to streamline the production time with improved descriptive statistics and forecasting used by Sales, Vendor Management, Asset Management, Senior and Executive Management.
Inventory Data Manager/Analyst at Canadian Outdoor Equipment
October 1, 2020 - May 31, 2021
Maintained, managed, and synchronized inventory datasets across multiple POS systems, and web-based architectures. Maintained physical inventory counts against data sets, prepared POS systems, and data for remote use. Generated and analyzed inventory data sets preparing price lists.
HR Data Insights Analyst at Cynthia Reale Consulting
September 1, 2017 - October 31, 2020
Using various Human Resources systems reporting tools, provided Human Resources data insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth. Skills include Quantitative Methods, Data Warehousing, Advanced Data Mining, Business Intelligence (BI), Data Structures, Data Technologies, Research Data Management, Statistical Computing Methods.
Sr Mgr Finance Analyst / Sr. Manager Credit Risk Administration at Scotiabank
February 1, 2014 - September 30, 2017
Worked on a project implementation of Scotiabank main Corporate Credit System migration to an Oracle based platform with BI capability to improve the Enterprise reporting and analytics as the existing legacy system was lacking BI capability. The project required extensive Credit and Finance analysis of Corporate Credit customer data – involving extensive analysis of various large data sources and area of the Enterprise developing ETL methods to migrate from the CARDS system to the new RO (Risk Origins Moody’s system).
Sr Marketing Channel Management Analyst B2B at Laurentian Bank
October 1, 2011 - July 31, 2014
As the Senior Analyst with the Marketing Channel Management my primary role was to provide statistics and insights gained through various data sources throughout the Enterprise. Financial, Sales, Broker Mortgage, Investment Lending, etc.
Sr Finance Analyst at JP Morgan Chase Paymentec
January 1, 2011 - August 31, 2011
Analyzed, classified, and reviewed highly complex financial and business-related analysis and research in such areas as financial and expense performance, rate of return, depreciation, working capital, and investment. Working with databases to support business decisions. Data mining, developing queries and analysis for report generation and automation with DBF, SQL, Access, and Excel. Preparing interpretation of financial results and advising management and executives of appropriate course of action.
Risk Specialist Data Analyst at Bank of Montreal
May 1, 2004 - January 31, 2011
Worked with BMO Financial Group primarily with Enterprise Operational Risk Management and Technology and Operations Risk Management as an Operational Risk Specialist, identifying, analyzing, and reporting Enterprise Operational Risks to Senior and Executive level management in all areas of the Enterprise from Operations to Corporate providing statistical analysis through ad hoc, monthly, and quarterly reporting. RCSA, SOX, BCM, Loss Event, Scenario, KRI, risk analysis and assessment throughout the Enterprise. Experience in all areas of Operational Risk such as: Business Continuity Management, Mission Critical Products and Services, Risk Control Self Assessment, SOX, Loss Data Collection for AMA, Corporate Audit – Issues and Gaps, Contract Management, and Product Operations, combined with a background in information technology, database management, and statistical analysis has allowed me to excel in the area of Operational Risk Management which is gaining focus in the Financial Indust

Education

Network Administration at CDI Toronto School of Business
January 1, 1998 - December 31, 2000

Qualifications

MCSE: Microsoft Office Professional
January 11, 2030 - January 19, 2026
Web Page Design
January 11, 2030 - January 19, 2026
A+ Program
January 11, 2030 - January 19, 2026
Novell Netware
January 11, 2030 - January 19, 2026
MCP, Windows NT
January 11, 2030 - January 19, 2026
Office97 (Excel, Word, PowerPoint), Microsoft Access Version 97
January 11, 2030 - January 19, 2026

Industry Experience

Financial Services, Manufacturing, Retail, Professional Services, Software & Internet, Education