Home

Excellent Consultant On My Bench - Power Platform Developer

[email protected]

Location: Remote, Remote, USA

Relocation: Any

Visa: OPT

Name: Sagar Total Experience: 9+ Years Work Authorization: OPT Current Location: Open Availability to start: Immediately Willing to relocate: Open Resume Of My Candidate : Sagar Krishna Kashyap Sr. Power Platform Developer | [email protected] | +1(470) 500 9734 Professional Summary: Experienced Power Platform Developer with 7+ years of expertise in designing, developing, deploying and supporting enterprise level solutions in Microsoft Power Platform, including Power Apps, Power Automate, Power BI, Power Virtual Agents, Dynamics 365 and SharePoint. Developed Power Platform solutions utilizing advanced Power Fx and Power Query formulas, API connections, and Azure integrations. Expertly applied the Microsoft Power Platform Center of Excellence starter kit to establish enterprise-grade governance, ALM, and DevOps processes. Skilled in full-stack development, integrating data from Common Data Service (CDS), SQL, SharePoint, Dynamics 365 CRM, and Azure to enhance business processes and improve operational efficiency. Demonstrated expertise in building canvas apps, model-driven apps, portals, and chatbots, as well as designing end-to-end automation workflows using Power Automate. Adept at using the Microsoft Power Platform Center of Excellence(CoE) starter kit to establish enterprise-grade governance, ALM, and DevOps processes. Proven ability to develop interactive Power BI reports and dashboards, utilizing DAX expressions, OLAP, and OLTP data sources for comprehensive business insights. Skilled in Business Intelligence tools, particularly Power BI Desktop, SSRS, and SSIS, with a talent for creating insightful visuals, comprehensive dashboards, and leveraging DAX for in-depth data analysis and KPI tracking. Configured and deployed Dynamics 365 using both managed and unmanaged solutions, leveraging out-of-box features like Business Rules, Business Process Flows, and Synchronous Workflows to optimize business operations. Integrated Project Service Automation and Field Service Automation modules to streamline service delivery and resource management. Leveraged KingswaySoft for efficient data migration from SQL Server to Dynamics CRM, ensuring data integrity and smooth transitions. Utilized ASP.NET AJAX controls, extenders, and Win Forms to develop complex UI elements, enhancing cross-program functionality with jQuery and JSP for an intuitive user experience. Highly experienced in developing custom SharePoint solutions, including sites, lists, workflows, and custom web parts, using modern web technologies and frameworks such as SPFx, CSOM, JSOM, and REST APIs. Skilled in customizing SharePoint using Power Automate and Nintex workflows. Proficient in creating tailored SharePoint apps with programming techniques like CSOM and JSOM. Managed code version maintenance and tracking through Microsoft Team Foundation Server (TFS) and Visual Source Safe (VSS), ensuring consistent and reliable deployment of SharePoint solutions. Skilled in deploying site features and custom lists with site columns and content types using SharePoint Management Shell. Leveraged InfoPath forms, CAML Queries, and custom Ribbon controls to develop intuitive interfaces and workflows, enhancing user interaction and data management within SharePoint Strong background in full-stack development with C#, ASP.NET, JavaScript, HTML, CSS, and integrating Microsoft 365 services like MS Teams with Power Apps and Power Automate. Skilled in creating responsive user interfaces (UIs) and optimizing applications for various device form factors. Leveraged Power Virtual Agents to deliver automated, context-aware support and interactions, significantly enhancing customer and employee engagement. Proficient in implementing robust security measures using Microsoft Dataverse security roles, Azure Identity Services, and Access Management (IAM), ensuring comprehensive data protection and access control. Experienced in database development, including creating complex queries, views, stored procedures, and triggers using SQL and T-SQL in relational databases such as MS SQL Server. Skilled in designing complex reports using SQL Server Reporting Services (SSRS). In-depth knowledge of Agile methodologies, particularly Kanban, to manage workflows, facilitate daily stand-up meetings, and promote transparent communication within cross-functional teams. Proficient in establishing end-to-end CI/CD pipelines using Azure DevOps, Jenkins, and Docker, ensuring swift code delivery and enabling automated testing for maximum development efficiency. Certificates: Microsoft Certified: Power Platform Developer Associate(PL-400) Technical Skills: Power Platform: Microsoft PowerApps, Power Automate, Power BI, Dataflows, Portals, Custom Connectors/APIs, Power Virtual Agents, COE Tool kit, DataFlows, Co-Pilot Studio, PowerShell, VBA Languages: C, C++ , Java, JavaScript, .Net, Python, SQL, VN.Net, SAS, C#, ASP.Net SharePoint: SharePoint Online, SharePoint, InfoPath, SPFx, REST, WCF services, Nintex, Sharepoint Designer, ShareGate, Metalogix. Database: Dataverse, Oracle, Azure SQL, CDS, My SQL, Microsoft SQL Server, MongoDB, MS Access BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica, Power BI, Tableau, DAX, Power BI Desktop, Power BI Gateway. Methodologies Agile, Waterfall, Kanban. Web Development Technologies: HTML, CSS, React JS, Angular, JSOM, NodeJS, jQuery, JavaScript. Cloud Platforms and Tools: Microsoft Azure, .NET Client Libraries, App Scripts, App Maker, Docker, Office 365,AWS Cloud, Visio, Snowflake Professional Experience: Client: Albertsons Companies September 2023 - Present Role: Microsoft Power Platform Developer Description: Developed a comprehensive solution using Microsoft Power Platform to manage staff schedules, track working hours, and facilitate shift swaps and time-off requests. The app was designed to streamline scheduling processes, ensure adequate staffing, and improve overall staff satisfaction. Responsibilities: Developed and implemented a comprehensive staff management solution using PowerApps to create a user friendly interface for staff scheduling and time management. Designed and developed Model-Driven and Canvas apps in Power Apps with a client-centric approach, creating well-organized, information-rich interfaces. This solution enabled efficient scheduling, and time-off requests, enhancing user experience and operational efficiency. Integrated the app with SharePoint for comprehensive document management, using Sharegate to migrate from SharePoint 2019 to SharePoint Online. Developed custom lists, document libraries, site columns, and content types, leveraging InfoPath for custom forms and Nintex for automating workflows, which optimized data handling and user interaction. Deployed site features and custom components using SharePoint Management Shell and SPFx (SharePoint Framework). Enhanced site functionality with custom web parts and extensions, ensuring a structured data management approach and consistent access to information across SharePoint Online. Utilized Power Automate to streamline shift scheduling, shift swaps, and time-off requests, integrating with payroll systems using Webhooks and Custom Connectors to ensure accurate tracking of working hours and automated payroll processing, reducing administrative workload and payroll errors by 25%. Implemented role-based security and access control within Dataverse and Sharepoint Lists, using Microsoft Entra ID and Multi-Factor Authentication (MFA) for accessing Power Apps. Enhanced the app s functionality by integrating with Dynamics 365, improving the existing customer relationship management and data consistency. Additionally, utilized ASP.NET AJAX controls, extenders, and WinForms to develop a responsive and dynamic user interface. Utilized HTML, CSS, and jQuery to enhance the user interface, creating a more engaging and interactive experience with dynamic content and responsive design elements. Developed advanced Power BI reports and dashboards using DAX and SQL Server Analysis Services (SSAS) for real-time insights into staff scheduling, time-off trends, and staffing levels, facilitating informed decision-making and resource optimization. Generated custom reports with SQL Server Reporting Services (SSRS) for detailed analytics on staff schedules, shift swaps, and time-off requests, enhancing operational oversight and visibility. Utilized Snowflake for cloud-based data integration and Microsoft Access for local data handling, automating processes with VBA scripting. This approach optimized staff schedule management and data accuracy, while also enhancing the overall functionality and reliability of the solution. Utilized C# and .NET to develop custom functionalities and integrations within the Power Apps environment. Created machine learning models with Azure Machine Learning Studio to predict employee availability and optimize resource allocation. Integrated these models with CoPilot Studio, using Natural Language Processing (NLP) to enhance chatbot interactions with predictive analytics. This led to a 20% improvement in scheduling accuracy and a 15% reduction in manual tasks. Established CI/CD pipelines with Azure DevOps to automate the deployment and testing of Model-Driven apps, accelerating the development lifecycle and ensuring high-quality updates and feature enhancements. Applied Agile methodologies, specifically Kanban, to manage the development process. Implemented visual workflow management, set work-in-progress limits, and prioritized tasks in real-time, resulting in efficient project management and iterative development cycles. Environment: Power Platform, Power Apps (Canvas and Model-Driven), Power Automate, Power BI, SharePoint Online, Dynamics 365, Azure Machine Learning Studio, CoPilot Studio, Dataverse, SharePoint Management Shell, SPFx (SharePoint Framework), HTML, CSS, jQuery, C# and .NET, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) , DAX, Azure DevOps (CI/CD Pipelines), Custom Connectors, InfoPath, Nintex, Microsoft Entra ID, Agile Client: Molina Healthcare August 2022 - July 2023 Role: Power Platform / Dynamics 365 Developer Description: Developed an insurance tracking and management system using Power Platform and Dynamics 365 for Molina Healthcare. The system includes Model-Driven apps for insurance tracking, Canvas apps for reporting and managing insurance data, and Dynamics 365 for customer relationship management. Leveraged Power Automate for process automation and Power BI for real-time analytics, ensuring enhanced data management and improved operational efficiency. The solution facilitated effective insurance tracking, accurate reporting, and robust customer relations, streamlining operations and boosting overall performance. Responsibilities: Developed and implemented custom Canvas and Model-Driven apps using Power Apps, integrating with SharePoint and Dynamics 365 to manage insurance policies, claims, and customer interactions. Integrated SQL Server and Dataverse with Power Apps and Dynamics 365 to centralize and manage data related to insurance policies, claims, and customer interactions, ensuring data consistency and integrity. Utilized SQL Server entities and Dataverse tables to structure and organize data within the app, improving accessibility and user experience. Leveraged SharePoint's out-of-the-box (OOTB) functionality and custom web parts developed using the SharePoint Framework (SPFx) to enhance data management and visualization, optimizing insurance policy management and claims processing. Customized SharePoint site templates and content types to enhance data management and integration with SQL Server, utilizing PowerShell for deployment, maintenance, and automated Power Query refreshes. Leveraged Windows Task Scheduler to ensure up-to-date information and maintain consistency and accuracy. Enhanced SharePoint document management by using JSON for custom formatting of policy documents and claim forms. Leveraged the Center of Excellence (CoE) Toolkit to set up best practices, monitor usage, and ensure smooth operations, making data management consistent and efficient. Designed and implemented task-led business process flows with Power Automate, using Cloud and Desktop flows to automate insurance claims processing, policy updates, and customer notifications. This improved efficiency by 30% and reduced processing times through real-time data integration and optimized workflows. Augmented the application with Microsoft Custom Connectors and XRMToolbox for advanced API integration, incorporating interactive features through JavaScript to create dynamic user experiences. Leveraged machine learning models for intelligent data processing and predictive analytics, and developed Custom APIs to extend app capabilities, improving data consistency and operational efficiency. Generated detailed reports and real-time dashboards using SSRS, DAX, and Power BI, delivering advanced analytics on insurance policies, claims statuses, and customer interactions. Leveraged Power BI Desktop, Power BI Gateway, and SSIS for effective reporting, data visualization, and integration of data from various sources. Developed and integrated custom entities, views, forms, ribbons, sitemaps, and web resources in Dynamics 365, utilizing ASP.NET AJAX controls and extenders for enhanced UI functionality and jQuery for cross-program interactions. Utilized KingswaySoft for efficient data migration from SQL to Microsoft CRM, ensuring data integrity and transition. Leveraged CRM features such as new security features, enhanced business rules, and hierarchy visualization for robust system management. Implemented Project Service Automation and Field Service Automation modules in Dynamics 365, developing WCF services and applications using TFS, C#, ASP.NET, and T-SQL on SQL Server 2014. The development process was supported by Visual Studio 2013 IDE, jQuery, and AJAX, facilitating complex UI designs and intuitive user experiences. Developed advanced AI-driven functionalities using Azure Machine Learning integrated with Power Virtual Agents, leveraging Natural Language Processing (NLP) to enhance chatbot interactions with predictive analytics and automate decision-making workflows. Collaborated with cross-functional teams to gather requirements, design solutions, and conduct thorough testing using Test Studio, ensuring the app met stakeholder needs and operated smoothly within the existing IT infrastructure. Environment: Power Platform, Power Apps (Canvas and Model-Driven), Power Automate, Power BI, SQL Server, Dataverse, SharePoint, SharePoint Framework (SPFx), PowerShell, Power Query, JSON, Center of Excellence (CoE) Toolkit, Microsoft Custom Connectors, XRMToolbox, AI Builder, SSRS, DAX, Dynamics 365, ASP.NET AJAX, jQuery, KingswaySoft, CRM, Project Service Automation, Field Service Automation, WCF Services, TFS, C#, ASP.NET, T-SQL, Test Studio, Agile (Kanban) Client: Cognizant Technology Solutions Role: Software Engineer/Power BI Developer July 2020- June 2022 Description: Developed a comprehensive Power Apps and Power BI solution for the Google Appeals Team, streamlining the management of over 500 daily cases and Chrome extension compliance reviews. The system enhanced data collection, real-time insights, and compliance monitoring, significantly improving operational efficiency and decision-making. Responsibilities: Leveraged Power BI to create real-time dashboards and advanced reports using DAX, providing insights into case status, compliance scores, and common issues. Utilized SSIS and T-SQL for ETL processes to generate detailed analytics on Chrome extensions and violation monitoring, resulting in a 30% reduction in review time and a 40% improvement in report performance and data clarity. Implemented FTP Task and Bulk Insert Task within SSIS to automate data import/export operations, improving efficiency and ensuring timely data updates. Employed Power BI Gateway for secure data refreshes, ensuring stakeholders have access to the latest information and insights. Collaborated with stakeholders to deliver customized BI solutions, including creating tailored dashboards and reports using Power BI Desktop. Provided training and support to over 40 engineers on Power BI, SSIS, and T-SQL, and documented all BI solutions for effective knowledge transfer and ongoing maintenance. Designed and developed a custom Canvas app for logging, updating, and tracking cases, including developer feedback and actions taken. Enhanced case management and compliance tracking by integrating Dynamics 365 to provide better data context. Leveraged out-of-the-box(OOTB) SharePoint functionalities, such as calendars and web parts, to create and manage custom tables, views, and indexes. Developed advanced search, crawl, and indexing capabilities for notes, and utilized ASP.NET AJAX controls, Extenders, and WinForms, along with jQuery, to build user-friendly cross-program functionalities and complex UI elements, improving overall user experience and operational efficiency. Implemented SharePoint for data storage and document management by customizing Site Templates and Definitions, creating Custom Web Parts, and using Business Connectivity Services. Applied CAML Queries, jQuery, and InfoPath forms with validation and filtering to efficiently handle datasets and ensure secure, organized storage for sensitive compliance data. Developed and executed complex data migration and integration processes by utilizing Snowflake for cloud-based data warehousing and Microsoft Access for local data storage. Employed VBA scripting within Microsoft Access to automate data manipulation tasks, optimizing workflows and enhancing data accuracy across platforms. Designed and developed a custom action button within Power Platform tools, using Visual Studio and C# with ASP.NET integration. Integrated this button into the app's interface, enhancing functionality and user interaction. Created and managed MSBI SQL cubes and data mining models, enhancing analytical capabilities and enabling data-driven decisions that improved compliance rates by 25%. Client: Shell Role: Microsoft SharePoint Developer March 2019- May 2020 Description: Developed a comprehensive employee onboarding and offboarding management system using Power Apps, SharePoint, Dynamics 365 Human Resources, and other Microsoft tools to streamline and automate the processes associated with employee transitions. This solution centralized task management, improved compliance, enhanced security, and provided real-time analytics, thereby optimizing HR operations and improving the employee experience. Responsibilities: Created custom Canvas and Model-Driven apps to manage onboarding and offboarding processes, providing a centralized platform for new hires and departing employees to access tasks, documents, and resources. Utilized SPFx (SharePoint Framework) to develop custom web parts and extensions, optimizing the system's user interface and functionality. Integrated REST API services for data exchange, and employed ShareGate and Metalogix for efficient migration and management of SharePoint content. Integrated SharePoint 2016 for efficient document management, including storage and retrieval of employment contracts, NDAs, training materials, and other relevant documents. Enhanced the management system by integrating InfoPath for custom form development and utilizing SharePoint Designer to automate workflows. Utilized Power Automate to automate task assignments and notifications, ensuring timely completion of HR, IT, and administrative tasks related to employee onboarding and offboarding. Integrated the solution with Dynamics 365 Human Resources and other HR systems to synchronize employee data, streamline data management, and automate record-keeping. Configured Azure Active Directory (AAD) for role-based access control, ensuring secure and compliant access to sensitive employee data and documents. Created detailed Power BI reports and dashboards using DAX, along with SSIS for ETL processes, SSAS for data analysis, and SSRS for custom reporting. Provided comprehensive insights into onboarding timelines, task completion rates, and employee feedback, enabling data-driven decision-making and process optimization. Utilized HTML, CSS, and JavaScript to design and implement a responsive and intuitive user interface within the Power Apps environment. This customization enhanced user experience by providing dynamic content and interactive elements tailored to the needs of new hires and departing employees. Leveraged SQL to manage and query employee data, ensuring accurate and efficient data handling within the system. Developed custom scripts to automate data integration tasks, such as syncing employee records between the SQL Server and Dynamics 365 Human Resources, streamlining data consistency and reducing manual data entry efforts. Client: Cigna Healthcare Role: Dynamics 365 Developer June 2017- February 2019 Description: Developed an integrated system using Dynamics 365 and SharePoint to improve business processes and data management. Created custom entities, workflows, and web parts, and utilized different tools for data migration and SSIS for data integration, enhancing user experience and operational efficiency. Responsibilities: Developed a Unified Service Desk for Dynamics 365, integrating various UI elements through ASP.NET AJAX controls and custom modules. Utilized jQuery and JSP for complex UI interactions, including agent scripting and configurable toolbars. Implemented custom entities, views, forms, ribbons, and sitemaps in Dynamics 365, enhancing the system's usability and functionality. Integrated with SharePoint objects such as lists, libraries, and web parts for comprehensive data storage and display. Utilized advanced data migration techniques for efficient transfer from SQL Server to Microsoft CRM, ensuring integration and data integrity. Designed and built SSRS reports in SQL Server Management Studio (SSMS) for detailed analytics. Developed WCF services and applications using TFS, C#, ASP.NET, and T-SQL queries, integrated with SharePoint for enhanced business connectivity. Leveraged PowerShell scripts for automated deployment and maintenance of SharePoint site features. Customized SharePoint site templates and definition customizations, implementing custom web parts, business connectivity services, and master pages. Utilized frameworks like Office365, SharePoint 2013, and SharePoint 2010 to enhance content management. Created and managed custom workflows and InfoPath forms in SharePoint, incorporating rules like validation, formatting, and actions. Developed custom ribbon controls and associated workflows with the Client Object Model for improved user interactions. Leveraged Dynamics 365 CRM features, including new security features, enhanced business rules, and hierarchy visualization, to optimize business processes and data security. Integrated these features with SharePoint's OOTB functionality for a seamless user experience. Developed and deployed Project Service Automation and Field Service Automation modules in Dynamics 365, using Visual Studio 2013 IDE. This included customizations using jQuery, AJAX, and web forms for intuitive user interfaces. Utilized CAML queries and LINQ for efficient data extraction and manipulation in SharePoint, enhancing data management capabilities. Integrated SQL Server data with SharePoint using Business Data Catalog (BDC) Meta-Man. Implemented OData, plugins, workflows, and API integrations using the Dynamics SDK, facilitating seamless data flow and integration with external systems. Supported these integrations with custom SharePoint web parts and site features. Managed DevOps processes, including integration with source control systems and environment troubleshooting, using tools like TFS, VSTS, and ReSharper. Automated deployments and ensured smooth transitions from staging to production. Designed and executed ETL processes using SSIS, extracting, transforming, and loading data from various sources into Dynamics 365 and SharePoint environments. Monitored search, crawl, and index operations to optimize data retrieval and user experience. Thanks & Regards, Lisa, Bench Sales Recruiter Stier Solutions Inc T. (610) 735 8665 | E. [email protected] Keywords: cprogramm cplusplus csharp continuous integration continuous deployment artificial intelligence user interface javascript business intelligence information technology microsoft procedural language Colorado Idaho