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

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

DataCamp Course Completion

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

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