Rajan Panchal
Data Analyst @eHealth Saskatchewan
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @eHealth Saskatchewan
Regina, SK, CA
Built and maintained Power BI dashboards and scorecards by integrating data from Oracle SQL Database and other cloud-based sources, delivering real-time performance metrics to business users.Designed and optimized PL/SQL stored procedures for enterprise-scale data workflows, supporting business-critical reporting and exception handling.Performed data cleaning, metadata correction, and table optimization using T-SQL and Azure Data Studio, improving data integrity across analytics layers.Worked closely with data engineers to monitor, debug, and enhance Azure Data Factory (ADF) pipelines; identified and resolved issues across staging and production environments.Developed and deployed Python scripts within ETL pipelines for tasks such as data transformation, anomaly detection, and dynamic schema validation, leading to a 25% boost in data accuracy.Automated recurring processes with Python and Azure Functions, significantly reducing manual intervention and improving data pipeline efficiency.Used Excel for ad-hoc analysis and pre-modeling tasks, supporting strategic business decisions and root cause analysis.
EDUCATION
Northeastern University
Master of Science - MS
Parul University
Bachelor of Technology - BTech
ABOUT RAJAN PANCHAL
I’m a Canada-based Data Analytics & Engineering professional who turns complex datasets into clear, actionable insights. With hands-on expertise in Power BI, Python, SQL, and Microsoft Azure, I build scalable Data and BI solutions and data pipelines that drive smarter business decisions. Always eager to tackle new challenges, I thrive at the intersection of analytics, engineering, and cloud technologies.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.