Umang Pandya Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

- Developed efficient ETL pipelines to simplify data flow and reporting services with SQL and integration tools like SSIS and Talend.- Worked on numerous data migration projects for both on-prem and cloud customers.- Designed customer BI reports with SSRS and Microstrategy.- For our cloud customers, extensively used GCP tools like bigQuery, Composer and DataPrep.

Peterborough, Ontario, Canada

Bhavnagar, Gujarat, India

• Responsible for developing a rigid pipeline with Apache Kafka and Airflow for one client. Was responsible for writing DAGs for Airflow, in Python. The data we scrapped was structured and hence dumped in MySQL and later analysed.• The analysis included the stages of procuring data, preprocessing, predictive modelling and validation and finally generating forecasts by finding trends. • Worked for a second client to perform web scrapping and by performing ELT, it was first dumped to MongoDB (on-premises database) before it was transformed.• Later, we shifted to cloud (Azure) and used CosmosDB for our NoSQL database, Azure Data Factory for data integration, Snowflake for data warehouse.

Bhavnagar, Gujarat, India

• Worked as an intern, in making various important decisions like expanding to two major cities in India and entering the business of bulk SMS services, by carefully processing, analysing, and visualising data with various tools like MySQL, Python libraries, ML algorithms and PowerBI.

Master Of Science - Ms, Big Data Analytics

Bachelor Of Engineering - Be, Computer Engineering