Vatan Nayal
Toronto,Canada
Summary
Results driven Senior Data Solutions & Reporting Analyst with 7+ years of experience across eCommerce, banking, finance, and insurance domains. With a Master of Science in Computer Science, I specialize in advanced SQL querying, optimization, dashboard design and visualization, and building scalable reporting ecosystems that empower teams to make confident, data-driven decisions. I’m highly skilled in SQL, R, Power BI, MicroStrategy, SAS, and Excel, and I enjoy designing intuitive dashboards, optimizing data pipelines, and implementing best-practice end-to-end data solutions.
Overview
9
9
years of professional experience
Work History
Senior Data Solutions & Reporting Analyst
Co-operators
08.2021 - Current
- Led the automation of key reports using SAS, R, and MicroStrategy, cutting manual effort, and improving reporting accuracy.
- Reduced turnaround time for ad-hoc reporting requests, enhancing internal client satisfaction and accelerating decision-making.
- Designed and delivered custom reports that addressed complex business needs and influenced strategic planning.
- Improved existing reporting by researching data sources, consolidating datasets, and optimizing output formats.
- Analyzed Genesys call-center data to identify queue inefficiencies, implementing solutions that lowered customer wait times.
- Provided training and technical guidance to team members, strengthening analytical capabilities across the department.
- Collaborated with stakeholders to interpret trends and communicate insights, influencing data-driven decision-making.
- Contributed to the development of scalable data solutions in partnership with business and technical teams.
- Managed large, cross-department reporting initiatives, ensuring timely delivery of high-quality analytical outputs.
- Tools and Technologies:
- MicroStrategy, Power BI, SSMS, R Studio, SAS, Salesforce, and Azure Data Studio.
Business Intelligence Consultant
DATATEAM Services
01.2021 - 07.2021
- Delivered BI solutions for multiple credit unions by developing data warehouse components and producing high-impact SSRS and Power BI reports that supported operational and strategic decision-making.
- Resolved complex data quality issues across databases and reporting layers, ensuring accuracy and reliability for business-critical analytics.
- Strengthened stakeholder relationships by providing high-quality support to client inquiries and collaborating with cross-functional partners to clarify requirements and deliver insights.
- Enhanced BI processes by identifying inefficiencies and implementing improvements to support scalability and long-term maintainability.
- Tools and Technologies:
- SQL Server Management Studio, Report Studio, Azure DevOps, Power BI, and GitHub.
Data Analyst
Copperfin Credit Union
08.2019 - 10.2020
- Advised business partners on analytical insights, translating complex data into clear recommendations that supported strategic and tactical decisions.
- Identified and evaluated process improvement opportunities, delivering actionable recommendations that enhanced reporting efficiency and improved data quality.
- Enhanced enterprise data flow processes and optimized dashboards, enabling real-time performance visibility for multiple departments, and improving operational decision-making.
- Collaborated with departments to design and refine dashboards, ensuring data accuracy and adherence to strong data management practices.
- Tools and Technologies:
- Dundas BI, SSMS, Visual Studio Reporting Services, Windows Server, Active Directory, Excel, and VBA.
Data Support Engineer
Amazon
08.2016 - 08.2018
- Led projects to create dashboards & metrics for Business Intelligence team, presenting findings to senior-level management
- Automated reports using Tableau for the team to provide quantifiable insights to management and highlight the periodic increase in productivity with the percentage impact over the business
- Performed trend analysis on capacity planning activities to garner key workforce insights, identifying quality components
- Managed RedShift clusters to oversee user access and ensure seamless onboarding processes. to add and manage new users onboarding and supporting managers in launching new projects
- Automated task and performance tracking processes using R and Python, reducing daily manual efforts and ensuring timely responses to ad hoc reporting requests
- Developed and maintained end-to-end data pipelines with ETL and AWS QuickSight to support data-driven decision-making
- Applications used: Tableau, RedShift, MySQL, MS SQL, Oracle, ETL, Excel, R, Python & Jupyter Notebook
Education
Master of Science - Computer Science
Lakehead University
Thunder Bay, Ontario08-2020
Skills
- SQL, R, and SAS programming
- Report automation
- Data visualization and presentations
- Teamwork and stakeholder collaboration
- Process improvement
- Problem-solving abilities and critical thinking
Timeline
Senior Data Solutions & Reporting Analyst
Co-operators
08.2021 - Current
Business Intelligence Consultant
DATATEAM Services
01.2021 - 07.2021
Data Analyst
Copperfin Credit Union
08.2019 - 10.2020
Data Support Engineer
Amazon
08.2016 - 08.2018
Master of Science - Computer Science
Lakehead University