Learn Data Skills
Beta
Dan Vukota

Dan Vukota

Data Analyst

VCM Global Asset Management | Ontario, Canada

Technologies

My Portfolio Highlights

My New Track

AI Fundamentals

My New Course

Introduction to Python

My New Track

AI Fundamentals

Analytical luminary, illuminating the path to data-driven enlightenment.

My Work

Take a look at my latest work.

course

Understanding ChatGPT

course

Introduction to Python

course

Intermediate Python

course

Understanding ChatGPT

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Understanding Artificial Intelligence
Introduction to Power BI
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

VCM Global Asset Management | Oct 2018 - Present

Data Analyst

• Developed Power BI dashboards for financial performance, asset management and investment analytics, enhancing visibility into key metrics and reducing time to insights. • Led the design and creation of data models and a centralized Azure SQL Data Warehouse, addressing data integration challenges and ensuring data integrity, scalability, and improved accessibility. • Constructed and streamlined data pipelines, ETL processes, API integration (JSON, XML, REST), ad-hoc statistical analysis, and visualization using Python (Pandas, Numpy, SQLAlchemy, Plotly, Matplotlib, Seaborn, Scikit- learn). • Developed investment analysis tools using Advanced Excel, VBA and SQL, enabling dynamic and customizable financial modelling capabilities. • Partnered with cross-functional teams to deliver actionable insights into risk-adjusted investment strategies, leveraging legacy financial software and analytical tools.
Show More

Reitmans Canada Ltée/Ltd | Jul 2017 - Sep 2018

Business Intelligence Technical Lead

• 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. • Performed data validation and comparison on staging areas, fact, and dimension tables to ensure accurate data representation in the data warehouse.

Reitmans Canada Ltée/Ltd | Jan 2009 - Jul 2017

Senior System Analyst

• Collaborated with business and IT stakeholders to ensure backend data models aligned with organizational needs and strategic objectives. • Designed, maintained and monitored various ETL processes using Informatica. • Led the configuration and integration of the Oracle Retail Planning and Allocation system. • Designed and maintained custom Visual Basic applications and Excel-Based dashboards. • Managed database enhancements and integration testing for upgrade of the Oracle Retail Price Management system. • Supported all aspects of system development life cycle including solution design, data analysis, database programming, software configuration, shell scripting, testing, automation, troubleshooting, technical support, and on-call rotation.

My Education

Take a look at my formal education

Concordia University

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free