Arpit Kamal Email & Phone Number

Toronto, Ontario, Canada

• Reduced data breaches by implementing comprehensive encryption policies and secure access controls in Azure Synapse and Blob Storage.• Designed and implemented end-to-end BI solutions using Azure Data Factory, Azure SQL Database, and Power BI, enhancing data integration, processing efficiency, and reporting capabilities across clinical and operational departments.• Led the development of data models and ETL processes with Azure Synapse Analytics and SQL Server Integration Services (SSIS), improving data quality and streamlining workflows for patient data analysis and healthcare outcomes tracking.• Extracted and processed large datasets from various sources, enhancing data accuracy and retrieval speed using CLI tools.• Developed real-time data ingestion pipelines using Azure Stream Analytics, improving data freshness and enabling timely decision-making.• Conducted advanced data analysis and created interactive dashboards in Power BI, utilizing DAX and M language to deliver insights on patient care metrics, resource utilization, and financial performance, driving data-informed strategic decisions.• Created custom backup and restore solutions for Azure Cosmos DB, ensuring high data recovery success rates and compliance with retention policies.• Led the end-to-end development of complex data pipelines in Azure Data Factory, automating data ingestion, transformation, and storage processes, resulting in reduced processing time and ensuring seamless data flow across systems.• Developed and optimized ETL processes with tools like Informatica and Talend, reducing processing time and latency.• Managed SQL databases and Control M job schedules, ensuring high uptime and job success rates, and improved database performance and batch processing times.

Greater Toronto Area, Canada

• Optimized Big Data Processing: Reduced data processing time through seamless integration of data lakes with Azure HDInsight, enabling faster business insights.• Highly skilled in SQL, Python, and R for advanced data querying, cleaning, statistical analysis, and predictive modeling, ensuring high data accuracy and integrity.• Implemented Power BI dashboards, reducing report generation time and enabling faster decision-making and strategic planning.• Designed and optimized ETL processes using SQL and cloud-based data warehousing solutions (e.g., Amazon Redshift, Snowflake), improving data processing efficiency.• Developed and enforced data governance policies, ensuring compliance with industry regulations and reducing data privacy risks.• Streamlined data transformation workflows in Azure Data Factory and SSIS, cutting ETL process times and improving data availability.• Enhanced data security with SQL Server Transparent Data Encryption (TDE) and key vault auditing, improving data protection and compliance.• Provided actionable insights through advanced data visualization tools, contributing to increased sales revenue by identifying key market trends.• Collaborated with global teams and stakeholders, boosting project success rates and improving stakeholder satisfaction.

Bengaluru, Karnataka, India

• Implemented Power BI dashboards that reduced report generation time, enabling faster decision-making and strategic planning.• Spearheaded the development and implementation of a comprehensive PowerBI dashboard for Dynamatic Technologies, streamlining the monitoring of key performance indicators (KPIs) across various departments, resulting in improvement in data-driven decision-making efficiency.• Implemented Power BI dashboards, reducing report generation time for faster decision-making and strategic planning.• Developed data governance policies ensuring compliance with industry regulations, significantly reducing data privacy risks.• Conducted thorough database testing and validation, achieving high data accuracy and minimizing critical system errors.• Streamlined data transformation workflows in Azure Data Factory and SSIS, reducing ETL process times and improving data availability.• Enhanced data protection by implementing SQL Server Transparent Data Encryption (TDE) and key vault auditing, ensuring compliance with security standards.• Collaborated with cross-functional teams, optimizing report performance and increasing overall team productivity.