V
Vishal S
About
Detail
Toronto, Ontario, Canada
Résumé
Jobs
verified_user
0% verified
Sr. Data AnalystTMX GroupAug 2022 - Current (4 years 2 months)As a Sr. Data Analyst, I developed Python-based data transformation and feature engineering pipelines using Pandas and NumPy to prepare large-scale financial datasets for BI reporting and machine learning models. I built reusable Python modules for data validation, anomaly detection, and outlier handling, which significantly improved upstream data quality before ingestion into Azure Synapse and Power BI semantic models. Additionally, I implemented Python-driven forecasting and churn analysis workflows using Scikit-learn, encompassing model training, cross-validation, and performance evaluation (MAE, RMSE). I integrated Python scripts with Azure Machine Learning pipelines for automated model retraining and scoring, enabling adaptive forecast- Bi & Data AnalystCienaSep 2020 - Jul 2022 (1 year 11 months)Built SQL-based ETL setups using Azure Data Factory - slashed spreadsheet use by 80% while making data more reliable. Moved BI jobs to Azure Data Lake along with Synapse Analytics - flexibility got better yet reports from across the firm now live in a single place. Designed secure, high-performance Tableau dashboards using composite models, DirectQuery, and row-level security (RLS). Developed robust ETL/ELT pipelines in Azure Data Factory with parameterization, logging, and error handling, reducing manual reporting by 80%. Applied Azure AI Text Analytics and NLP techniques to customer feedback data, contributing to a 9% NPS increase. Built Python-based forecasting models in Azure ML to improve demand planning accuracy and reduce inventory s
- Data AnalystAltaMLOct 2019 - Aug 2020 (11 months)- Set up live views in Tableau using Azure's smart notifications, enabling the team to identify and address performance lags sooner, resulting in an 18% increase in operational efficiency through improved flow checks.
- Cleaned medical files using Python, subsequently adjusting layouts via SQL, which led to a 40% increase in data stability and reduced gaps between Electronic Medical Records (EMR) and everyday tools.
- Utilized Azure Data Factory to automate report generation, ensuring that Tableau consistently updates data for quicker access to real-time performance metrics.
- Initially employed Microsoft Excel for data transformations, which laid the groundwork for developing robust data models in SQL Server and Power BI,
Education
verified_user
0% verified
- Masters in Computer ScienceWestern Illinois UniversityJan 2014 - Jan 2016 (2 years 1 month)
- JBachelor in Computer ScienceJNTUJan 2007 - Jan 2011 (4 years 1 month)