Shubham Yadav

Power Platform and SharePoint Developer | Power Apps, Power Automate, Data Engineering

Waterloo, CA.

About

Highly accomplished Power Platform and Data Engineering specialist with 5+ years of experience, adept at designing and implementing robust, AI-driven solutions to optimize business processes and enhance data accessibility. Proven ability to lead complex migrations, develop custom applications, and integrate advanced analytics, consistently delivering significant efficiency gains and cost savings. Seeking to leverage deep expertise in Microsoft Power Platform, Azure AI, and data architecture to drive strategic technological advancements in a forward-thinking organization.

Projects

Context-Aware Institutional RAG Chatbot

→

Summary

Engineered a custom Retrieval-Augmented Generation (RAG) backend to securely query unstructured institutional data while avoiding out-of-domain hallucinations.

Employee Churn Prediction

→

Summary

Developed a predictive machine learning model to identify employees likely to leave, enabling proactive retention strategies, risk mitigation, and reduced turnover costs.

CMS Consolidation and Migration

→

Summary

Consolidated M-Files and Efecte into a unified SharePoint Online environment to enhance data accessibility and reporting.

Work

KPI Partners

|

Data Analyst II (Power Platform & AI)

Pune, MH, India

→

Summary

Currently serving as a Data Analyst II, leading the development and implementation of advanced Power Platform and AI solutions to optimize data evaluation and business processes for KPI Partners.

Highlights

Designed and developed a comprehensive Vital Signs Review Power BI report with embedded Power Apps Canvas Apps, accelerating clinical data evaluation by 60% for Scientific and Medical Reviewers.

Engineered a bulk-edit update mechanism using Dataverse/SQL Patch and ClearCollect functions, bypassing 1,000-record delegation limits via Power Automate HTTP webhooks.

Drove an automation-first mindset by developing a Power Automate workflow integrated with AI Builder, saving 15+ hours of manual assessment weekly by automating business risk evaluations and RACT categorization.

Leveraged Azure AI Foundry models to accurately extract data from vendor contracts and medical invoices, achieving a 95%+ accuracy rate in automated data capture.

Implemented Azure AI Foundry's Content Understanding service, decreasing processing time by 50% and cost savings of 70% by replacing a complex Python script for cross-referencing contract and invoice data.

Wilfrid Laurier University

|

Power Platform Assistant (CO-OP)

Waterloo, ON, Canada

→

Summary

As a Power Platform Assistant, developed and deployed Power Platform solutions to enhance student services and administrative efficiency at Wilfrid Laurier University.

Highlights

Developed a Power Automate flow integrated with webhook events to automatically generate and deliver custom certificates upon student course completion, saving 16 hours per week.

Used Microsoft Copilot Studio and developed Copilot Agents to answer student inquiries using a private knowledge base, improving student support and reducing manual effort.

Designed and deployed an authenticated Power Pages Student Dashboard, empowering students to securely view enrollment history, active courses, grades, and financial statements in real-time.

Developed a dynamic Live Course Catalog leveraging Power Pages Cloud Flow API to query Destiny One REST API, processing JSON payloads, and synchronizing live course descriptions directly into Dataverse.

Designed and updated university website sections, including FAQ and tax documentation pages, which decreased recurrent student queries by 83.5%.

Accenture Solutions Pvt. Ltd.

|

Packaged App Development Analyst (SharePoint and Power Platform Developer)

Pune, MH, India

→

Summary

Served as a Packaged App Development Analyst, specializing in SharePoint migrations and Power Platform development for diverse enterprise clients at Accenture Solutions Pvt. Ltd.

Highlights

Handled cross-tenant SharePoint migrations using PowerShell and ShareGate, ensuring seamless data transfer and system continuity for clients.

Developed an intelligent Power Automate Desktop (RPA) flow to automate post-migration testing across thousands of SharePoint Online sites, autonomously navigating pages to verify UI integrity and capture error screenshots.

Modernized legacy data collection processes by architecting and developing multiple Power Apps to replace deprecated InfoPath forms during a large-scale enterprise migration.

Architected, engineered, and automated custom Canvas and Model-driven Power Apps and Power Automate workflows for various North American clients, including complex SharePoint list updates.

Ensured data integrity during the complex migration of 500+ Nintex and SharePoint Designer workflows to Power Automate.

Education

Wilfrid Laurier University

Waterloo, ON, Canada
→
Master Applied Computing

Pune University

Pune, MH, India
→
Bachelor Computer Engineering

Languages

English

Certificates

PL-600

PL-400

AZ-204

PL-900

MS-900

AZ-900

AI-900

SC-900

Skills

Power Platform & AI

Power Apps, Power Automate, Power Automate Desktop (RPA), Power BI, Dataverse, Power Fx, Copilot Studio, AI Builder, Azure AI Foundry.

Cloud, Database & Data Engineering

Azure Databricks, Azure Functions, Logic Apps, Azure SQL, FAISS Vector Stores, ETL pipelines, KQL alerts, Fabric Capacity.

SharePoint & Migration

SharePoint Online, SPFx, PnP Framework, ShareGate, Nintex, SharePoint Designer workflows, custom webparts.

Languages

C#, Python, JavaScript/TypeScript (React, JSX), HTML/CSS, XML, PowerShell, SQL.

Tools & Version Control

Git, Jira, Confluence, VS Code.

Professional Skills

Advanced data analysis, statistical modeling, trend analysis, forecasting, Excellent verbal and written communication, report generation, stakeholder collaboration, Power Platform governance, solution adoption, Strong planning and prioritization, project management, multitasking.

Machine Learning

Pandas, NumPy, scikit-learn, SVM, XGBoost, CatBoost, Random Forest.