GYANA RANJAN DASH
Technical Lead
Santa Clara,CA
Summary
- SharePoint & Power Platform Lead Developer with 14+ years of experience delivering enterprise solutions across Microsoft 365, SharePoint Online & On-Prem, Power Platform, and Azure, with a proven track record modernizing legacy systems and building scalable digital workflows.
- 8+ years of hands-on Power Apps development (Canvas & Model-Driven), including Dataverse driven applications, complex business rules, responsive UI design, and enterprise-grade integrations.
- 5+ years of Power BI experience building analytical dashboards, DAX-based calculations, semantic data models, and automated refresh pipelines to support operational and executive decision-making.
- Developed AI-driven automation using Microsoft Copilot Studio reducing lab operational cycle time by 70%.
- Extensive expertise designing and developing SharePoint Online intranet portals, collaboration sites, landing pages, templates, and responsive UI components using SPFx, JavaScript/TypeScript, and modern frameworks.
- Experienced in building and managing Microsoft 365 components including SharePoint sites, Teams integrations, OneDrive, governance, permissions, and enterprise content structures.
- Strong development foundation in Python, C#.NET, and SQL Server, including building REST APIs, backend services, data access layers, and optimized database queries for high-volume systems.
- Experienced in designing relational database schemas, writing efficient SQL queries, stored procedures, functions, and performing performance tuning for transactional workloads.
- Hands-on experience writing PowerShell scripts for SharePoint administration, automation, bulk operations, environment configuration, and deployment activities.
- Hands-on experience configuring and managing SharePoint permissions, including site-level security, role-based access control, groups, inheritance management, and governance best practices across Microsoft 365 environments.
- Proven ability to design and implement workflow automation using Power Automate, SharePoint Designer, and Dynamics 365 to streamline complex business processes across Microsoft 365 environments.
- Hands-on experience migrating SharePoint 2010-2019 to SharePoint Online using tools such as Sharegate and Metalogix ensuring secure and compliant transitions.
- Skilled in integrating Microsoft 365, SharePoint, and Power Platform solutions with SAP, Workday, SQL databases, and REST APIs to enable seamless enterprise data flows.
- Designed end-to-end business process flows using Microsoft Visio and ARIS.
- Created UI mockups and wireframes using Balsamiq and Figma.
- Adept at Agile/Scrum delivery, leading cross-functional engineering teams, managing SDLC execution, and driving high-quality, production-ready releases across cloud and low-code platforms.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Power Platform Lead Developer
Applied Materials Inc.
, USA
11.2021 - 12.2025
- Led Agile delivery for 5+ mission-critical platforms supporting lab operations, supply chain, and EHS, coordinating 20-30 engineers and analysts across U.S. and India.
- Designed and developed Power Apps (Model-Driven and Canvas Apps) solutions, leveraging Dataverse tables, relationships, and business rules to automate end-to-end EHS business processes.
- Design and developed AI-driven automation using Microsoft Copilot Studio, Power Automate, and AI-assisted workflows, reducing lab operational cycle time by 70% and eliminating weeks of manual processing.
- Implemented integration with SAP and Workday systems to streamline data exchange and automate lab operations workflows.
- Design and developed Power Apps and Power Pages applications to collaborate with external vendors and business units.
- Built enterprise Power BI dashboards using DAX, data modeling, and automated refresh pipelines to support leadership decision-making and operational visibility.
- Collaborated with engineering teams to design microservices, data flows, and integration patterns across Microsoft Azure, Power Platform, and legacy systems.
- Supported incident response and root cause analysis for high-severity issues, driving both rapid recovery and long-term reliability improvements.
- Facilitated Agile Scrum ceremonies (sprint planning, backlog refinement, retrospectives, UAT) while tracking velocity, risks and delivery KPIs using Confluence, Jira and MS Teams.
- Designed end-to-end business process flows using Microsoft Visio and ARIS to standardize workflows and support solution architecture.
- Created UI mockups and wireframes using Balsamiq and Figma to visualize application interfaces and accelerate stakeholder alignment.
SharePoint Developer
Tata Consultancy Services Limited (TCS)
, USA
06.2013 - 11.2021
- Designed and implemented enterprise solutions using Power Apps (Model-Driven Apps, Canvas Apps), Power Automate, and SharePoint Online, modernizing 20+ legacy Lotus Notes and SharePoint InfoPath applications into scalable low-code platforms.
- Built Power Apps applications with SQL, SharePoint, and REST API integrations to streamline business workflows and reduce manual processing.
- Developed automated workflows in Power Automate and Nintex workflow for approvals, notifications, data processing, and system integrations.
- Created Power BI dashboards for operational reporting, KPI tracking, and leadership insights using DAX, data modeling, and scheduled refresh pipelines.
- Implemented integration with Hadoop database for compliance and finance data exchange between systems.
- Migrated SharePoint InfoPath Forms to Power Apps.
- Directed secure data migrations using Sharegate, ensuring compliance and zero-downtime transitions.
Software Engineer
Zenith Software Limited
, India
06.2011 - 06.2013
- Built a full-scale web application (gotosage.com) on Microsoft SharePoint, delivering a robust platform for client engagement.
- Designed and developed webparts, permissions and responsive pages.
- Developed and supported SharePoint-based web applications for enterprise clients.
- Built custom UI components, integrated third-party APIs, and optimized application performance.
- Developed automated workflows in SharePoint designer workflow for approvals and notifications.
- Supported deployment, release management, and environment configuration ensuring smooth transitions across development, QA, and production.
Education
Master's Degree - MSC - Information Technology
Kuvempu University
IndiaBachelor's Degree - GNIIT - Software Engineering
NIIT
IndiaSkills
- Power Apps
- Power Automate
- Power Pages
- Microsoft Azure
- SharePoint
- Nintex
- Power BI
- SQL databases
- PostgreSQL
- MySQL
- C#NET programming
- Python development
- React framework
- JavaScript programming
- jQuery library
- JSON data handling
- XML data structure
- Databricks
- Tableau
- Office 365
- Jira project management
- Confluence documentation
- ServiceNow platform
- Figma design tools
- Balsamiq wireframing
- Visio diagramming tools
- Microsoft Teams collaboration
- ChatGPT
Certification
- Applied Agentic AI for Organizational Transformation, MIT
- Certified Scrum Master (CSM), Scrum Alliance
- Certified Scrum Product Owner (CSPO), Scrum Alliance
- Post Graduate Program in Data Analytics, Purdue University
- Microsoft Certified Azure Fundamentals (AZ-900)
- Microsoft Power Platform App Maker Associate (PL-100)
Timeline
Power Platform Lead Developer
Applied Materials Inc.
11.2021 - 12.2025
SharePoint Developer
Tata Consultancy Services Limited (TCS)
06.2013 - 11.2021
Software Engineer
Zenith Software Limited
06.2011 - 06.2013
Master's Degree - MSC - Information Technology
Kuvempu University
Bachelor's Degree - GNIIT - Software Engineering
NIIT