DAN VUKOTA
Oakville,ON
Summary
Results-driven data professional with extensive experience in analytics, business intelligence, data integration, modeling, and automation. Proven ability to deliver data-driven solutions and custom reporting that drive strategic decision-making, streamline processes, and optimize workflows, leading to measurable improvements in accuracy, efficiency, and business growth.
Overview
16
16
years of professional experience
Work History
Data Analyst
VCM Global Asset Management
Nassau, Bahamas
10.2018 - Current
- Designed and created a centralized Azure SQL Data Warehouse and local SQL server database, overcoming data integration challenges and ensuring data integrity, scalability, and efficient data accessibility
- Constructed and streamlined data pipelines, data cleaning, ETL processes, API integration (JSON, XML, REST), algorithmic trading, communication automation, and ad-hoc statistical analysis and visualization using Python
- Implemented insightful Power BI dashboards for financial performance, asset management and investment analytics, improving visibility into KPI metrics and cutting down time to insights
- Developed investment analysis tools using advanced Excel, Power Query, VBA and SQL, enabling dynamic and customizable financial modelling capabilities to support consolidated, data-driven decision-making
- Partnered with cross-functional teams to deliver actionable insights into risk-adjusted investment strategies, leveraging legacy financial software and analytical tools
BI Data Integration Tech Lead
Reitmans Canada Limited
Montreal, Canada
07.2017 - 09.2018
- Directed the redesign of data models and mapping frameworks for business processes and analytics logic, transitioning from MicroStrategy to Infor Birst, optimizing dashboard capabilities, scalability, and user experience
- Optimized data integration workflows for Infor Birst by leveraging Informatica ETL to meet new requirements, ensuring seamless data flow between data warehouses and BI platforms while enhancing performance
Senior Systems Analyst
Reitmans Canada Limited
Montreal, Canada
01.2009 - 06.2017
- Managed database enhancements, data integration, and regression testing for upgrade of the Oracle Retail Price Management system, enhancing pricing processes and performance using Agile methodologies
- Designed, maintained and monitored various ETL processes using Unix bash shell scripting and Informatica, improving the efficiency of data transformation and reducing processing time
- Led the configuration and integration of the Oracle Retail Planning and Allocation system, addressing key challenges in supply chain operations, and optimizing inventory management across eCommerce and retail channels
- Designed and maintained custom Visual Basic applications and Excel-Based dashboards using VBA and Access
- Supported all aspects of system development life cycle including solution design, data analysis, software configuration, database programming, process scheduling, testing and troubleshooting
Education
Bachelor of Arts - Statistics
Concordia University
Montreal, QCMicrosoft Power BI Data Analyst -
Coursera
Data Warehousing for Business Intelligence -
Coursera
Associate Data Scientist in Python -
DataCamp
Skills
- Analytics & Reporting
- Data Mapping & Modeling
- ETL & Automation
- Data Warehousing
- SQL (Advanced)
- Python
- Power BI
- VBA
- Excel (Advanced)
- PL/SQL
- Unix/Linux Bash Shell
Timeline
Data Analyst
VCM Global Asset Management
10.2018 - Current
BI Data Integration Tech Lead
Reitmans Canada Limited
07.2017 - 09.2018
Senior Systems Analyst
Reitmans Canada Limited
01.2009 - 06.2017
Bachelor of Arts - Statistics
Concordia University
Microsoft Power BI Data Analyst -
Coursera
Data Warehousing for Business Intelligence -
Coursera
Associate Data Scientist in Python -
DataCamp
Similar Profiles
Michael DiecMichael Diec
Retail Sales Associate at Bank of Montreal, Global Asset ManagementRetail Sales Associate at Bank of Montreal, Global Asset Management
Michael OmodeleMichael Omodele
IT Support Specialist at ThomasLloyd Global Asset ManagementIT Support Specialist at ThomasLloyd Global Asset Management
KENNETH PEREZKENNETH PEREZ
Conference Coordinator/Receptionist at Allianz Global Asset ManagementConference Coordinator/Receptionist at Allianz Global Asset Management