HELLO, MY NAME IS

Manu Pranay

Transforming data into powerful insights and scalable solutions.

[email protected]​
263-993-8765​
About Me

I am a dedicated Azure Cloud Engineer and BI Developer with over 5 years of experience. My passion lies in designing scalable cloud solutions and developing data-driven BI insights to drive business growth.

I develop powerful and insightful data solutions.

With over 5 years of experience as an Azure Cloud Engineer and BI Developer, I have honed my ability to design scalable cloud solutions and develop insightful business intelligence tools. I have collaborated with businesses across various industries, ensuring that their data-driven needs are met with precision and innovation.

Throughout my career, I have worked extensively in cloud technologies, ETL processes, and data visualization. From building comprehensive BI architectures and optimizing SQL queries to developing dynamic Power BI reports and implementing Azure Synapse solutions, I bring a wealth of experience to every project. My expertise spans cloud platforms, scripting languages, and reporting tools, allowing me to provide robust and reliable data solutions.

Having successfully delivered numerous projects that are currently in use, I am well-equipped to offer the best possible insights and recommendations for your data needs. With me, you’re not just getting a service provider; you’re gaining a collaborative partner. I present a range of options and work with you to find the perfect solution tailored to your specific requirements.

What I Do

Design Scalable Cloud Solutions

With a deep understanding of Azure Cloud technologies, I design and implement scalable, secure, and efficient cloud architectures. My expertise in Azure Data Factory, Databricks, and Azure Synapse allows me to build robust solutions that support your business’s growth and data needs.

Develop Dynamic Business Intelligence Tools

I specialize in creating comprehensive BI tools that transform raw data into meaningful insights. Utilizing Power BI, SSRS, and advanced SQL techniques, I develop interactive dashboards and reports that help businesses make data-driven decisions with confidence.

Optimize Data Performance and Integrity

Ensuring optimal performance and data integrity is at the core of my work. I optimize SQL queries, manage ETL processes, and implement best practices in data management to provide seamless, reliable, and fast access to critical business data

Skills

Cloud Technologies

Azure Data Factory, Databricks, Azure Data Lake Storage, Azure Synapse

Scripting

SQL, Python, PowerShell, T-SQL

ETL Tools

SSIS, ADF, Fabric

Reporting Tools

Power BI, SSRS

Database Technologies

SQL Server, MySQL, MS Access, MongoDB

My Experience

Jun 2022-Present

Adastra, Montreal, QC

Data Engineer

At Adastra, I analyze client requirements, evaluate data sources, and establish project timelines. I develop and implement scalable BI architectures, ensuring seamless integration with existing systems and databases. My role involves conducting stakeholder workshops, preparing detailed documentation, and coordinating with other developers to maintain consistency in data definitions and metrics. I design custom SSRS reports with advanced data visualization techniques, optimize SQL queries, and ensure data integrity through thorough testing and debugging.

Jun 2020- Feb 2022

Condo Control, Toronto, ON

BI Developer

I accelerated the growth of Azure Synapse by implementing modern data warehouse solutions. I educated customers on Synapse components, performed POCs in customer environments, and provided technical support. My responsibilities included creating pipelines in ADF, designing tables, managing external tables, and implementing security measures. I also configured connections between Synapse and reporting tools like Power BI and Tableau, ensuring efficient data processing and visualization.

May 2018 -Jun 2020

Imagine Communications, North York, ON

BI Developer

I gathered and analyzed business requirements to design long-term BI solutions using SQL Server, SSIS, ADF, SSAS, Power BI, and other Azure tools. I optimized SQL performance, created stored procedures, and developed ETL packages. My work involved data modeling, migrating on-premise SQL schemas to Azure, and collaborating with QA teams for performance testing. I also developed complex Power BI reports and implemented security measures to ensure data integrity.

Personal Projects

Coffee Orders-Excel Dashboard
HR insights with SQL & Power BI – Page 1
HR insights with SQL & Power BI – Page 2
British Airways Reviews Dashboard in tableau
Coffee Orders-Excel Dashboard
HR insights with SQL & Power BI – Page 1
HR insights with SQL & Power BI – Page 2
British Airways Reviews Dashboard in tableau
Scroll to Top