DB

Dwij Bhagatji

Ouvert aux possibilités

Results-driven Data Analyst

Canada

EQ Bank
Conestoga College

À propos

Results-driven Data Analyst with 3+ years of experience using SQL, Power BI, Python, and ETL pipelines to turn large, complex datasets into actionable business insights. Strong experience in improving reporting efficiency by 35% and cutting manual effort by 40% through dashboard automation and process optimization. Expertise in data modeling, data governance, predictive analytics, and cloud platforms (Azure, AWS, GCP), with hands-on experience translating business requirements into KPI frameworks within Agile/Scrum environments. Strong communicator known for partnering with cross-functional and executive stakeholders to drive data-informed decisions across banking, technology, and operations.

Compétences

  • Amazon Web Services
  • Jira
  • Microsoft Azure
  • Microsoft Excel
  • MySQL
  • Oracle
  • PostgreSQL
  • Power BI
  • Python
  • Salesforce
  • SQL
  • Tableau

Expérience

  1. Data Analyst

    EQ Bank

    oct. 2024 to Aujourd’hui

    • Built and maintained interactive Power BI and Tableau dashboards using SQL and DAX, improving reporting efficiency by 35% for executive and business stakeholders. • Wrote and optimized complex SQL queries (joins, CTEs, window functions) to extract, clean, and analyze large-scale datasets across MySQL, PostgreSQL, and SQL Server. • Automated recurring ETL and reporting workflows using Python and Excel VBA, reducing manual processing effort by 40% and improving data delivery turnaround. • Led data cleaning, transformation, and validation processes that strengthened data accuracy, consistency, and governance across enterprise reporting systems. • Partnered with cross-functional teams to define KPIs and business metrics for sales, operations, and customer analytics, supporting data-driven decision-making. • Developed predictive analytics models in Python (Pandas, Scikit-learn) to identify customer behavior trends and support forecasting and risk initiatives. • Supported ETL and data pipeline integration of structured and unstructured data into centralized, cloud-based reporting platforms. • Delivered ad hoc analyses and executive-level presentations that informed strategic business and operational decisions. • Drove Agile/Scrum ceremonies including sprint planning and backlog refinement to align analytics deliverables with business priorities.

  2. Junior Data Analyst

    Hexaware Technologies

    juill. 2021 to nov. 2022

    • Analyzed business and operational datasets using SQL and Excel to generate actionable insights for management and leadership teams. • Designed Power BI and Excel KPI dashboards that enabled leadership to monitor performance metrics and business health in real time. • Performed data validation and quality assurance checks to maintain data integrity across multiple enterprise systems. • Supported cloud-based reporting and analytics initiatives leveraging AWS, Azure, and Google Cloud Platform tooling. • Improved reporting accuracy by identifying and resolving data inconsistencies across raw datasets and source systems. • Contributed to data migration and transformation projects supporting enterprise reporting modernization. • Built Python automation scripts for data extraction and preprocessing, streamlining analytical workflows. • Collaborated with business users to gather reporting requirements and translate them into scalable technical solutions.

Formation

  1. Conestoga College

    Post-Graduate Diploma, Business Analytics

    2024 to 2024

  2. Conestoga College

    Post-Graduate Diploma, Global Business Management

    2023 to 2023

  3. DRB College

    Bachelor of Business Administration, Major in Finance

    2018 to 2021