Dharmesh Kolli
*****************@*****.***
LinkedIn URL: https://www.linkedin.com/in/sai-dharmesh-/
(Microsoft Power Apps Consultant)
Professional Summary:
Microsoft PowerApps Consultant with 9 years of experience designing and implementing enterprise-grade solutions in Dynamics 365, PowerApps, and Power Automate. Proven expertise in building Model-Driven and Canvas apps, automation using Power Automate, and seamless integrations with external systems like Azure, SharePoint, and third-party APIs. Passionate about optimizing business processes and enhancing system performance through low-code/no-code solutions.
Experienced in PowerApps, Power Automate, custom workflows and business process flows within D365 CE. Experienced in Java script Web API
Created multiple Model Driven Apps and configured them according to the security roles.
Have experience in building model driven apps using Microsoft PowerApps and automate process using power automate.
Expertise with custom integrations (Scribe, Kingsway Soft, Azure Data works, Workfront, ESOA, Mailchimp, DocuSign and other CRM ISV providers)
Implemented CI/CD model pipelines with GitHub Actions.
Enhance MS Dynamics CRM usability by designing and optimizing navigation, forms, and layouts.
Implemented CI/CD model pipelines with Azure Dev Ops Actions
Involved in mapping customer requirements and process mapping to Microsoft Dynamics.
Build and Develop Custom Workflows in CRM and Process flows.
Custom Screens were built in Dynamics 365 using HTML and Java script Web Recourses.
Design and develop Orchard CMS, and Orchard Core CMS Themes and Modules.
Experienced in using Source Code Version Control Systems like Tortoise SVN, TFS.
Involved in developing API controller to consume the Restful Web service. And used this
Web services inside CRM plugins and workflows to get data.
Demonstrated proficiency in implementing and customizing MS Dynamics 365 ERP Suite, with a focus on delivering comprehensive solutions.
Collaborative Problem-Solving: Collaborated with cross-functional teams to identify and resolve complex issues, ensuring the continuous improvement of ERP solutions
Customization of Microsoft Dynamics CRM system, based on functional requirements of the client and use of out-of-the-box features, required configuration and customization for various functionalities and requirements.
Deployed and processed various SSAS cubes to Azure Analysis Services.
Understanding PowerApps formulas and development methods.
Designing, customizing, and implementing Dynamics 365 (Cloud).
Documented SharePoint configurations and architectures for the business use.
Experienced in Power Platform.
Developed application in Power Apps using Common data source CDS, Flow, Forms and SharePoint online.
Expertise with Dynamics 365 CRM from 4.0 to latest version, PowerApps, on-premises/Online Power Automate Flow, Power BI, Deployment, customizations, and development including plugins, workflows implementation.
Agile development with Azure DevOps, GitHub, Azure functions.
Programming Languages
Power Fx, JavaScript (for PowerApps customizations), TypeScript, C# (for plugins & extensions), SQL.
Power Platform
PowerApps (Canvas & Model-Driven Apps), Power Automate (Cloud & Desktop Flows), Power BI, Power Virtual Agents
PCF (PowerApps Component Framework), AI Builder, Microsoft Dataverse, Custom Connectors.
Microsoft Dynamics 365 & CRM
Dynamics 365 (CRM: Sales, Customer Service, Field Service, Marketing, Project Operations)
Business Rules, Workflows, Business Process Flows (BPF), Plugins & Customizations.
SharePoint Development & Administration
SharePoint Online, SharePoint Lists & Libraries, SharePoint REST API, SharePoint Framework (SPFx), Role-Based Access Control (RBAC)
Power Automate for SharePoint Workflow Automation, Document Management, SharePoint Webhooks & Triggers.
Governance & Compliance for SharePoint & Power Platform, Data Loss Prevention (DLP) Policies.
DevOps & Security
Azure DevOps, GitHub Actions, CI/CD Pipelines for Power Platform, Power Platform ALM (Application Lifecycle Management)
Azure Active Directory (AAD), Role-Based Security, OAuth Authentication.
Data & Reporting
SQL Server, SharePoint Data Integrations, Power BI Dataflows, API Integrations (REST, OData, Graph API).
Microsoft Teams Integration, SharePoint & Data verse Data Modeling.
Professional Experience
Santander, Dallas, TX
Sep 2023- Till Date
Sr. Power Apps Consultant
Responsibilities:
●Assess suitability for solutions in CRM Online and the Power Platform (Power Apps, Power Automate, Power BI)
●Analyze requirements and advise on design and configuration settings on Microsoft Dynamics.
●Analyzed and documented the database architecture and data transformations necessary.
●Advised development team on design options in line with project life cycle.
●Work with business owners to convert business rules to project requirements and prepare project plans.
●Implemented CI/CD model pipelines with Azure Dev Ops Actions
●Involved in mapping customer requirements and process mapping to Microsoft Dynamics.
●Build and Develop Custom Workflows in CRM and Process flows.
●Designed and developed Canvas & Model-Driven Apps integrated with Microsoft Dataverse and Dynamics 365, optimizing sales and customer service processes.
●Demonstrated proficiency in implementing and customizing MS Dynamics 365 ERP Suite, with a focus on delivering comprehensive solutions.
●Developed and deployed AI Builder models in Power Automate to extract business insights.
●Automated complex business workflows using Power Automate, reducing manual effort by 40%.
●Implemented PCF controls to enhance UI/UX and extend out-of-the-box PowerApps capabilities.
●Set up CI/CD pipelines in Azure DevOps & GitHub Actions to streamline Power Platform
●Extensively worked with MS Dynamics CRM reports, Power BI reports and Out of the box reports. Developed complex reports using Power BI and deployed into MS CRM.
●Created and implemented various forms using InfoPath form, PowerApps, SharePoint designer.
●Implemented various Power apps and power forms. Created various web pages and integrated the Power apps and forms.
●Created SharePoint Designer 2013 workflows for managing documents in various lists and libraries.
●Developed custom Web Part to list all the sites in the SharePoint Farm for easy access to navigate Usage Detail of each site in order to keep track of the usage of the SharePoint Sites.
●Worked and used Azure DevOps and Power Apps.
●Assist project manager to develop and ensure accuracy of daily, weekly, and monthly metric reports.
●Design solutions using Azure DevOps, Azure Functions, Logic Apps, CICD with established patterns and best practices for Azure and office integrations
●Design and develop solutions for SharePoint that take advantage of standard web technologies, such as CSOM, REST, JavaScript, and OData
●Provide support and guidance to users on SharePoint and Power Platform features and functionalities
●Provide technical advice to team members and customers on best practices for CRM Online / Power Platform development.
●Provide input and advice regarding Microsoft Dynamics CRM capabilities, functions, and features to clients and prospects
●Successfully integrated eCommerce platforms within the MS Dynamics 365 environment to streamline sales processes and enhance customer experiences.
●Conduct hands-on implementation, configuration, and development of the various components of Microsoft Dynamics CRM
●Implemented CI/CD model pipelines with Azure Dev Ops Actions.
●Develop analytical and insightful recommendations to meet deliverable targets, and complete project tasks within budget and to customer satisfaction
●Perform requirements gathering, Business Process Analysis
Environment: MS Dynamics CRM Online, Azure DevOps, VS 2015, MSMQ, ESOA, Siebel CRM, Informatica Cloud.
Staples, Mountain View, CA
Jun 2021 – Aug 2023
Power Apps Consultant
Responsibilities:
●Using CRM Customization's, plugins and workflows provide the business functionality throughout the above modules.
●Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM system.
●Installed and configured MS Dynamics CRM system for development and testing, configured server instance, created organizations.
●Integrated MS Office Outlook 2013 with MS Dynamics CRM.
●Integrated and monitored SharePoint integration with CRM for document management under different site security settings.
●Created custom pages and configured forms and views for new modules added to MS Dynamics CRM system.
●Designed and optimized Microsoft Data verse data models for scalability and performance.
●Integrated PowerApps with SharePoint, SQL Server, and REST APIs for seamless data connectivity.
●Custom Screens were built in Dynamics 365 using HTML and Java script Web Recourses.
●Design and develop Orchard CMS, and Orchard Core CMS Themes and Modules.
●Experienced in using Source Code Version Control Systems like Tortoise SVN, TFS.
●Involved in developing API controller to consume the Restful Web service. And used this
●web services inside CRM plugins and workflows to get data.
●Created custom dashboard, create custom Ribbon button and configured sitemap using Pragma toolkit.
●Used Bing Maps API to design and develop dashboards to display incoming customer requests and update address coordinates in the Microsoft Dynamics CRM.
●Develop plug-ins to synchronize/update payment details to CRM system.
●Coordinated with third-party vendors to identify and implement effective solutions involving SharePoint and MS Dynamics CRM.
●Integrated and monitored SharePoint integration with MS Dynamics CRM for document management.
●Monitored data transfers from MS SQL Server and wiring SQL queries.
●Good experience working on Ribbon Workbench.
●Using JavaScript created multiple validations on different entities to avoid Duplicates.
●Created and Configured Power Apps Portals for the Users outside of organization.
●Developed plugins, workflows, business process flows.
●Deployed CRM solutions from environments.
●Analysis, design, development, implementation, and support of customized CRM solutions.
●Document maintain and track the project status as well as design, test, and user manuals for the projects.
●Source Control Technologies: Visual Source Safe, Team Foundation Server, Assemble, Git
●Third party vendors to identifying best possible solutions to the client requirements Agile project management and SDLC practice.
●Lead and manage the release cycles, deployments.
●Implementing agile practice for product life cycle.
●Utilized Zendesk to correspond with end-users on reported issues, troubleshooting and resolution.
Environment: MS Dynamics 365, Omni channel, PowerApps, Power Automate, Visual Studio, Model Driven Apps, Power BI, Customer Voice, Azure DevOps, Power Apps Portals, Stored procedures, SQL, Azure.
AbbVie, Chicago, IL
Nov 2019 – May 2021
Power Apps Consultant
Responsibilities:
●Consume the Restful Web service. And used this
●Web services inside CRM plugins and Analysis, design, development, implementation, and support of customized CRM solutions.
●Document maintain and track the project status as well as design, test, and user manuals for the projects.
●Source Control Technologies: Visual Source Safe, Team Foundation Server, Assembla, Git
●Third party vendors to identifying best possible solutions to the client requirements Agile project management and SDLC practice.
●Lead and manage the release cycles, deployments.
●Implementing agile practice for product life cycle.
●Utilized Zendesk to correspond with end-users on reported issues, troubleshooting and resolution.
●Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM system.
●Installed and configured MS Dynamics CRM system for development and testing, configured server instance, created organizations.
●Integrated MS Office Outlook 2013 with MS Dynamics CRM.
●Integrated and monitored SharePoint integration with CRM for document management under different site security settings.
●DevOps, Power Apps Portals, Stored procedures, SQL, Azure.
●Developed plugins, workflows, business process Created custom pages and configured forms and views for new modules added to MS Dynamics CRM system.
●Hauntological Expertise: Familiarity and experience with Hauntological, leveraging its capabilities to enhance and extend MS Dynamics 365 functionality.
●Custom Screens were built in Dynamics 365 using HTML and Java script Web Recourses.
●Design and develop Orchard CMS, and Orchard Core CMS Themes and Modules.
●Experienced in using Source Code Version Control Systems like Tortoise SVN, TFS.
●Involved in developing API controller to workflows to get data.
●Created custom dashboard, create custom Ribbon button and configured sitemap using Pragma toolkit.
●Used Bing Maps API to design and develop dashboards to display incoming customer requests and update address coordinates in the Microsoft Dynamics CRM.
●Develop plug-ins to synchronize/update payment details to CRM system.
●Monitored data transfers from MS SQL Server and wiring SQL queries.
●Good experience working on Ribbon Workbench.
●Using JavaScript to create multiple validations on different entities to avoid Duplicates.
●Created and Configured Power Apps Portals for the Users outside of organization.
●Deployed CRM solutions from environments.
●Using CRM Customization's, plugins and workflows provide the business functionality throughout the above modules, 2008R2, Zendesk, Orchard CMS, RabbitMQ.
Environment: MS CRM Dynamics 2011, VS 2012/2010, Assemble, Tortoise SVN, Web Services, Java Script, SharePoint Designer 2007, WSS 3.0, SQL Server 2012
Global Data Solutions, Hyderabad, India
May 2016 - Sep 2019
SharePoint developer
Responsibilities:
●Involved in the application testing process for SharePoint projects, identifying and resolving issues to ensure high quality and functionality.
●Played a pivotal role in configuring SharePoint security settings for KPMG, implementing stringent access controls to protect sensitive information.
●Supported the seamless migration of data from legacy systems to SharePoint for KPMG, leveraging PowerShell scripts to ensure accuracy and minimize disruption.
●Monitored SharePoint sites for performance issues, using diagnostic tools to optimize performance and enhance user satisfaction.
●Created comprehensive user training materials and documentation for SharePoint, significantly improving platform understanding and facilitating smoother user adoption.
●Implemented SharePoint workflows to streamline and improve business processes at KPMG, leading to significant efficiency improvements and enhanced user engagement.
●Contributed to the design of user-centric SharePoint interfaces, utilizing HTML, CSS, and JavaScript to craft responsive and engaging designs.
●Participated in SharePoint and integration projects, enhancing data interoperability and the functionality of custom applications.
●Facilitated advanced data management and integration through -based API development for SharePoint, enabling sophisticated data manipulation for KPMG.
●Assisted in the development and customization of SharePoint solutions, using and to adapt functionalities to specific project needs.
●Conducted thorough audits of SharePoint sites, optimizing content organization to enhance site structure and improve user engagement.
●Stayed engaged in continuous professional development, keeping up to date with the latest SharePoint advancements and actively participating in community forums.
Environment: SharePoint 2013/2010/2007, SharePoint Designer2013, InfoPath 2010/2007, Visual Studio 2012/ 2010, SQL Server 2012, jQuery, Java Script, HTML.