Data Analyst and Reporting Specialist

Shilpa Pradeep

Data Analyst Reporting Analyst

Email: ***************@*****.*** Phone: 226-***-**** Location: Toronto, Canada

LinkedIn : https://www.linkedin.com/in/shilpapradeepdataanalyst/ Work Authorization : Canadian Citizen

PROFESSIONAL SUMMARY:

• Data Analyst with 3+ years of expertise in end-to-end data pipeline management, including data extraction (ETL), cleaning, transformation (Power Query, DAX), and database optimisation (SQL Server, On-Premises Data Gateway) to deliver reliable datasets for strategic initiatives.

• Data-driven professional with expertise in creating interactive dashboards and reports using Power BI and Tableau, enabling real-time monitoring of key performance indicators (KPIs) for improved decision-making

• Strong background in optimising complex SQL queries and automating data validation processes, resulting in faster data retrieval and reduced errors

• Proficient in Python (Pandas, NumPy) for building predictive models, leveraging machine learning techniques like clustering and regression to identify trends and inform strategic marketing decisions

• Expertise in unifying disparate data sources (CRM, ERP) through Power Query and SQL Server, streamlining data integration

• Advanced proficiency in Excel (Power Pivot, VLOOKUP, Macros) for automating financial forecasting models and improving budget cycle efficiency

• Knowledgeable in cloud data warehousing with Snowflake and modern business intelligence tools like Looker, ensuring scalable solutions for growing business needs

• Collaborative team player with experience in Agile/SCRUM environments, driving data initiatives across cross-functional teams

SKILLS

• Data Analysis & Reporting : SQL Advanced Excel (Pivot Tables, VLOOKUP, Macros) SAS SSRS, Python (NumPy, Pandas) Statistical Analysis KPI Optimization

• Database & ETL Management : SQL Server Snowflake On-Premises Data Gateway, ETL Tools: Power Query SSIS Data Integration

• Automation & Scripting : VBA Scripting (Excel Macros) Power Automate Python, Workflow Automation Task Scheduling Data Preparation

• Data Visualisation & BI Tools: Power BI (Data Modelling, Dashboards) Tableau Looker, Interactive Reporting DAX Calculations Dynamic Visualisations

• Additional Tools & Methodologies : CRM Software Google Sheets Windows Authentication, Agile/SCRUM Lean Practices Data Governance

• AI & Machine Learning

TensorFlow PyTorch Microsoft Copilot MLflow XGBoost LightGBM

• Cloud & Data Platforms

Azure Data Factory Azure Synapse AWS Redshift GCP BigQuery Snowflake Databricks dbt

PROFESSIONAL EXPERIENCE:

Data Analyst NTT Data, Canada Nov 2025 to present

• Architected ETL processes with Power Query and SQL Server, integrating disparate data sources (e.g., CRM, internal databases) to enhance data accessibility and consistency.

• Designed and deployed interactive Power BI dashboards with DAX-driven metrics, enabling stakeholders to track KPIs in real-time and drive data-driven decisions.

• Optimised SQL Server database performance by refining queries, implementing Windows Authentication, and configuring On-Premises Data Gateway for secure hybrid data connectivity.

• Collaborated with cross-functional teams to automate legacy processes using Power Query and Power Automate, including data validation and report distribution.

• Improved data validation workflows by scripting macros in Excel VBA, reducing manual errors and improving data accuracy by 25%.

• Successfully migrated 3+ manual reporting processes to automated workflows using Power Automate, saving 15+ hours/month in manual effort.

Data Analyst Xahive, Canada Jun 2025 to Nov 2025

• Automated manual data workflows by designing Power Automate flows and Excel VBA macros, eliminating repetitive data entry and report distribution tasks — reducing overall manual workload by 40% and cutting report generation time from 2 hours to under 30 minutes

• Designed and deployed 10+ interactive Power BI dashboards with custom DAX measures and calculated columns, providing senior stakeholders with real-time visibility into operational KPIs — replacing static weekly Excel reports and enabling same-day decision-making across business units

• Collaborated with stakeholders across Operations and Finance to gather reporting requirements, translating business needs into automated Power BI and Excel solutions — reducing back-and-forth revision cycles and delivering reports 2x faster than previous manual processes

• Designed and implemented end-to-end ETL pipelines using Power Query and SQL Server, consolidating data from CRM systems and internal databases into a single unified source — eliminating data mismatches and improving cross-departmental reporting consistency by standardising over 5+ data feeds

• Developed automated data validation scripts using Excel VBA macros to detect anomalies, flag missing values, and enforce data formatting rules at the point of entry — reducing manual errors by 25% and improving downstream reporting accuracy across finance and operations teams

Reporting Analyst Nordia, Canada Apr 2023 to Feb 2025

• Developed and maintained dynamic reports and dashboards using Power BI, enabling real-time data visualisation for senior management to drive decision-making processes across key business functions.

• Performed in-depth data analysis using SQL to extract, clean, and transform large datasets from multiple sources, ensuring accurate and actionable insights for stakeholders.

• Collaborated with cross-functional teams, including Marketing, Finance, and Operations, to identify data requirements and deliver customised reports tailored to their specific needs and KPIs.

• Streamlined reporting processes by automating data pipelines and creating dynamic reporting templates, reducing manual effort and improving overall report delivery efficiency by 30%.

• Conducted ad-hoc data analysis and performed root cause analysis on performance trends, highlighting key findings and offering actionable recommendations to improve operational efficiency.

EDUCATION

• Master in Computer Application, Mahatma Gandhi University, India Sep 2013- Sep 2016

• Bachelor in Computer Application, Mahatma Gandhi University, India Aug 2010- Aug 2013

Optimization, indexing, partitioning, MongoDB, Cassandra, Scikit-learn, TensorFlow, predictive analytics, time series forecasting, GCP, Azure, Hadoop, Spark, Databricks, Apache Airflow, Jenkins, R, data governance & compliance, ETL processes, data cleaning & transformation, AWS, Snowflake, Redshift, Looker, QlikView, data analysis & interpretation, predictive statistical analysis, KPI tracking & reporting, trend analysis, team collaboration, communication, project management, critical thinking, data management, data integration, data collection & control, data aggregation, data transformation, data cleansing, data wrangling, cross-functional stakeholder communication, problem-solving, attention to detail, time management, process optimisation, project management, customer interaction, reporting & presentation skills, Collibra, business intelligence reporting, reporting tools, SQL Server, Apache Airflow, Kafka, Google Cloud Redshift, Snowflake, Redshift data warehousing, query optimisation, indexing, partitioning, MongoDB, Cassandra, NoSQL databases, Scikit-learn, TensorFlow, machine learning

Contact this candidate