Power Bi Platform

Akhilesh D

Sr. Power Platform Developer *************@*****.*** +1-469-***-****

PROFESSIONAL SUMMARY:

With 7 years of hands-on experience in IT, I have specialized in working with Microsoft Power Platform Applications, including Power Apps, Power BI, Power Automate, Power Virtual Agents, and SharePoint. Proficient in managing the entire project, including initial design, development, rigorous testing, and successful deployment of these tools.

Skilled in Power Apps Developer specializing in the creation of user-friendly Model-Driven and Canvas Apps, with a strong background in data integration and workflow optimization.

Operated responsive PowerApps solutions with offline capability, incorporating AI Builder for invoice processing and creating reusable components to optimize end user adoption and usability.

Proficiency in application development using Microsoft PowerApps with a strong command of Common Data Service (CDS), SQL, Forms, SharePoint Online, Dynamics 365 CRM, Azure, C#, ASP.Net, and Web Services.

Experience in developing and configuring various SharePoint components, including Sites, Site Columns, Lists, List Views, List Definitions, Site Templates, Wiki Sites, Team Sites.

Orchestrated the migration of content from older SharePoint versions (SharePoint 2010/2013) to the modern SharePoint Online platform using Sharegate, ensuring a seamless transition and preserving data integrity.

Skilled in customizing SharePoint using Power Automate, InfoPath, and Nintex workflows. Proficient in creating tailored SharePoint apps with programming techniques like CSOM and JSOM.

Orchestrated REST API services to seamlessly integrate SQL data into NINTEX workflows, automating updates to SharePoint Lists and enhancing process efficiency by transforming raw data into actionable insights.

Proficient Power BI Developer skilled in creating compelling reports, dashboards, and custom visuals, leveraging DAX expressions, OLAP, and OLTP data sources to deliver actionable insights.

Proficient in Business Intelligence tools, especially Power BI Desktop, SSRS, SSIS, with a strong aptitude for crafting compelling visuals, intricate dashboards, and utilizing DAX for detailed data analysis and KPI reporting.

Worked with ETL, creating dashboard and report by combining data from multiple source systems within Power BI to create executive reports with row level security and publishing it to Power BI service to distribute among end user and keeping it update by scheduling gateway refresh.

Experience with Microsoft Dataverse, with expertise in centralizing data storage and management and ensuring connection with PowerApps, Power BI, and other Microsoft solutions.

Proficient in crafting stored procedures and triggers using SQL and T-SQL within relational databases, including MS SQL Server 2017/2012.

Highly adept in Azure, leveraging its capabilities to architect scalable solutions while seamlessly integrating custom APIs. Proficiently establish end-to-end CI/CD pipelines, ensuring swift code delivery and enabling Robotized testing for development efficiency.

Orchestrated the development of specialized Custom Connectors, facilitating seamless interoperability between PowerApps applications and external systems.

Employed Power Virtual Agents for chatbot development, improving user interaction and service efficiency.

By using Agile methodologies, specifically Kanban, to structure workflows, manage work in progress, facilitate daily stand-up meetings, and promote transparent communication within cross-functional teams, resulting in effective project management and iterative development cycles.

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.

Languages:

C, C + +, JavaScript, .Net, Python, SQL, VN.Net, SAS, C#, ASP.Net, Powershell

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.

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

ETL, Agile, Waterfall, Kanban.

WebDevelopment 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

Company: Microsoft Nov 2023 – Present

Power Platform Developer

Responsibilities:

Created and deployed the BAP Global Engagement Portal, a powerful model-driven and canvas app solution built using Power Apps that aims to provide the BAP Trust project with a smooth data integration and service delivery.

Spearheaded the creation of the BAP Global Engagement Portal as a responsive PowerApps solution with offline capabilities, leveraging advanced features such as AI Builder for document processing and sentiment analysis.

Engineered multi-capable Chatbots with Natural Language Processing (NLP) and Machine Learning (ML) capabilities within the BAP Global Engagement Portal, enabling real-time data access and personalized interactions, resulting in significant improvements in user satisfaction and support efficiency.

Utilized Copilot Studio (Power Virtual Agents) to design and deploy advanced user interactions within BAP Global Engagement Portal, including the development of chatbots for 24/7 support.

Implemented Generative Answers feature in Copilot Studio within the BAP Global Engagement Portal, enhancing user interaction and communication by enabling more natural and responsive responses, thereby elevating the overall service quality and client engagement metrics.

Leveraged Azure AI Studio to develop Copilots with advanced Natural Language Processing capabilities within the BAP Global Engagement Portal, including Keyword search and Semantic search features, ensuring superior user experience and satisfaction levels.

Orchestrated the management of SharePoint Online environments to support the BAP Global Engagement Portal, streamlining document management and collaboration across departments, optimizing data access and sharing mechanisms.

Leveraged Power Apps integration with Dynamic CRM to streamline data access and facilitate seamless interactions with customer relationship management systems within the BAP Global Engagement Portal, enhancing client engagement and service delivery.

Utilized Power BI extensively within the BAP Global Engagement Portal, employing DAX, SSRS, and SSIS to create compelling visualizations, real-time dashboards, and comprehensive data analytics solutions, driving data-driven decision-making and strategic insights.

Ensured data integrity and consistency by centralizing data storage and management using Dataverse, SQL, and Excel within the BAP Global Engagement Portal, enabling seamless data flow and accurate reporting functionalities.

Embraced Agile methodologies, particularly Kanban, to structure workflows, manage work in progress, and promote transparent communication within cross-functional teams, facilitating iterative development cycles and adaptive planning for the BAP Trust project.

Company: Kenvue, Texas April 2022 – Nov 2023

Power Apps Developer

Responsibilities:

Developed and implemented Model-Driven and Canvas Apps using Power Apps, resulting in a user experience that facilitated seamless feedback submission, personalized product recommendations, and user engagement, leading to a 60% increase spike in overall client satisfaction scores and service delivery

Set up backend databases customized for the Customer Feedback and Product Recommendation System project, ensuring robustness and scalability. Deployed PowerApps to facilitate efficient data flow between SharePoint and Common Data Services (CDS).

Created user-friendly front-end interfaces in PowerApps, optimizing consumer access to product details, virtual consultations, and feedback functionalities; resulted in a 30% increase in satisfaction with customers and a 25% reduction in support tickets.

Launched a PowerApps application tailored for efficient data handling, integrating image storage capabilities in SharePoint using JSON.

Established an enhanced interface through the strategic utilization of Microsoft Custom Connectors, elevating API integration efficiency and expanding the system's versatility within the designated context.

Implementing Power Automate, encompassing desktop flows, cloud flows, for streamlined appointment bookings with experts and facilitating user consultations. This strategic execution led to a notable 60% decrease in administrative tasks.

The COE toolkit is used to centralize and streamline healthcare product development, ensuring consistency, best practices, and compliance across self-care, skin health & beauty, and essential health categories.

Deployed Azure services, deploying secure solutions and collaborating with teams to optimize Dynamics 365 for improved consumer interactions, feedback management within the platform functionalities.

Constructed custom webparts using SPFX and PowerApps in Office 365.

Successfully migrated content from SharePoint 2010/2013 to SharePoint Online using Sharegate.

Crafted custom forms using HTML, CSS, JavaScript, and jQuery to create responsive and interactive user interfaces, merged with diverse platforms including SharePoint, Dynamics CRM, and Power Apps.

Utilize Power BI APIs to seamlessly integrate dashboards and reports into custom apps. Develop concise status reports, precise project specifications, and clear user requirement translations using tools like Visio and PowerPoint.

Proficient in crafting advanced ETL SSIS Packages, designing integration solutions that connect heterogeneous data sources including Excel, CSV, flat files, and text formats.

Used Agile methodologies, specifically Kanban, at Kenvue, visualizing workflow, setting work-in-progress limits, and prioritizing tasks in real-time. This approach facilitated efficient code delivery and automated testing through CI/CD pipelines, ensuring rapid development and deployment.

Successfully worked with Power Virtual Agents to create a chatbot for Kenvue website, leading to a significant 45% reduction in response time for patient self-service within the healthcare domain.

Environment: Microsoft Azure Cloud, .NET Client Libraries, PowerShell, SQL Server 2014, 2019, Azure SQL, CI/CD Pipelines, Office 365, AWS Cloud, Power Apps, Power BI, Power Automate, SharePoint Online, SharePoint 2019, C#.Net, ASP.NET Core, HTML5, CSS3, JavaScript, jQuery, Agile, Dynamic CRM,. Sharegate, O365

Miller Coors, Atlanta Sept 2020 – Dec 2021

Power Platform Developer

Responsibilities:

Built an Microsoft Power Apps using Model-Driven, Canvas App for the Supplier Relationship Management (SRM) Portal at Miller Coors. This included developing apps for Android, iOS, and web platforms.

Engineered Model-Driven App to address supplier reliability concerns, effectively monitoring and managing supplier performance, ensuring timely order fulfillment, and mitigating risks associated with supplier financial and operational challenges.

Systematized communication workflows using Power Automate, incorporating Desktop flows, Cloud Flows, and Data Flows to boost collaboration and streamline supplier interactions, leading to a substantial 75% reduction in manual workload.

Integrated SRM portal data sources such as Dataverse, SQL, and SharePoint to create a unified data ecosystem. This facilitated agile data access, real-time analysis, and customized reporting, empowering data-driven decision-making.

Formulated Automation using Microsoft Flow using multiple connectors including HTTP REST API and custom connectors. Administered the environments and Dynamics instances using Power Platform.

Used Power BI to generate detailed insights into supplier performance, procurement trends, and cost-saving opportunities using DAX, and consolidated SSIS/SSRS to develop comprehensive data analytics solutions within the SRM Portal.

Used JSON to run a flow for selected document type in SharePoint list and library.

Maximizing the potential of SharePoint within the SRM Portal, created dynamic collaboration platforms for document management, knowledge sharing, and team collaboration, ensuring seamless communication with suppliers.

Customized lists and workflows using InfoPath to streamline and automate complex approval processes.

Strengthened supplier relationship management by optimizing Dynamics CRM, designing specialized solutions for supplier interactions, document tracking, and compliance management.

Designed and built an action button within the Power Platform tools, utilizing Visual Studio and C# with ASP.NET integration. This button was smoothly integrated into the ribbon to enable efficient list item printing, perfectly aligning with business requirements.

Improved user experiences using JavaScript, which added interactivity and interactive features to Power Apps.

Created Tableau for unconventional data visualization, transforming raw supplier feedback into colorful, emotionally expressive charts, helping MillerCoors connect with suppliers on a deeper level and adapt supplier management strategies accordingly.

Set up (CI/CD) pipelines using Azure DevOps. Enabled the continuous delivery of updates, automated testing, and deployment of enhancements, ensuring consistent communication and collaboration.

Embraced an Agile development approach, embracing iterative development cycles, frequent feedback, and collaboration with stakeholders to adapt to changing supplier needs and deliver value incrementally throughout the SRM Portal project.

Environment: Microsoft Azure Cloud, SQL Server 2019, Office 365, Power Apps, Power BI, Power Automate (Flows), Azure (CI/CD pipelines), SharePoint 2016, Visual Studio, C#, ASP.NET, JavaScript, Tableau, Agile, Dataverse, HTTP, CSS, InfoPath.

Vertex Pharmaceuticals, Boston March 2019 – Aug 2020

Power BI Developer

Responsibilities:

Led Pharmaceutical Document Management and Financial Reporting System project at Vertex Pharmaceuticals, using Power BI to create flexible compliance, version control, and audit dashboards. Upgraded data-driven document management, meeting strict compliance requirements, resulting in a 80% boost in data-driven decisions.

Expertly combined diverse data sources using SSIS, ensuring comprehensive data representation in Power BI dashboards. Managed data extraction, transformation, and loading (ETL) processes for seamless data flow between OLTP and OLAP systems.

Fabricated the cube wizard and T-SQL programming to construct Dimensions, while ensuring up-to-date information through cube refreshes for OLAP databases. Successfully deployed Cubes to the production server.

Applied DAX and SSMS for intricate data modeling, fostering efficient data analysis in financial metrics and KPIs.

Generated compelling Power BI and SSRS visualizations and real-time dashboards, providing insights into financial trends, customer behaviors, and transactional data, thereby driving data-informed strategies and decisions.

Utilized Power Apps Model-Driven that enhances budgeting and planning by efficiently feeding historical financial data into Power BI for forecasting and resource allocation.

Conducted targeted workshops and in-depth training sessions to equip financial teams with advanced Power BI skills, fostering a culture of informed and data-driven decision-making.

Consolidated data from Dataverse and SQL ensuring a holistic and accurate representation in Power BI reports.

Effectively employed custom connectors/APIs within Power BI to facilitate seamless data exchange between financial systems, including SharePoint, Dynamics CRM, and external databases.

Implemented continuous integration and continuous delivery (CI/CD) pipelines using Azure DevOps to automate the build, test, and release processes for Power BI solutions.

Use of Kanban methodology to visually manage projects, promoting transparency and facilitating collaboration among team members in Power BI report development, resulting in refined workflows and alignment.

Environment: Power BI, SSIS, Teradata, T-SQL, SSRS, Dynamics CRM, PowerApps, Dataverse, SQL Server, Azure (CI/CD pipelines), SharePoint 2016/2019, SharePoint Online, JSON, DAX, DSS, Dynamic CRM, Kanban, Microsoft Azure, Powershell, HTML, CSS, Azure (CI/CD pipelines).

SharpInfo Tech, Hyderabad March 2017 – March 2019

SharePoint Developer

Responsibilities:

Spearheaded digital transformation initiatives in the insurance sector, leveraging SharePoint to centralize shared documents, enhance collaboration, and streamline workflows, resulting in a 75% uptick in process efficiency.

Adopted SharePoint's versatile framework to develop and customize intranet portals, ensuring responsive solutions that maximize information accessibility for insurance teams.

Developed Power BI dashboards combined within SharePoint, employing DAX, SSRS, and SSIS to provide transformative insights into insurance trends, customer behaviors, and sales metrics.

Designed REST API services to efficiently fetch SQL Data, seamlessly integrating it with NINTEX workflows to populate and update SharePoint Lists, thus bridging the gap between raw data and actionable insights for insurance operations.

Established CI/CD pipelines within the SharePoint environment when developing custom web parts, features, and solutions using C# and ASP.NET. This enabled continuous integration and efficient deployment of code changes, ensuring alignment with evolving business needs.

Collaborated with teams to harness Dynamics 365, delivering tailored solutions for optimal customer interaction within the insurance domain.

Led data consolidation initiatives within SharePoint, integrating Dataverse, SQL, and Excel, and crafting interactive dashboards to provide insurance agents and underwriters with real-time insights.

Leveraged PowerApps to craft Canvas and Model-Driven applications, enabling data storage in both SharePoint lists and Dataverse.

Architected an application system to modernize the manual communication process for insurance claims using Power Automate, and mentored insurance adjusters and data analysts on PowerApps and Power BI.

Revamped the user interface of the insurance intranet portals by incorporating CSS and JavaScript, ensuring a refined look and feel while enhancing site functionalities for a better user experience.

Crafted centralized JavaScript methodologies tailored for the insurance domain, enabling the creation of lists, libraries, columns, and SharePoint Pages. This initiative provided a reusable foundation for fellow developers, promoting consistency and efficiency in ongoing and future developments.

Leveraged Azure services to enhance data storage, security, and scalability within SharePoint, ensuring data flow and better performance across platforms.

Adopted Agile principles when developing the SharePoint intranet portals, working in sprints, managing Kanban boards, and conducting regular standups and retrospectives. This promoted iterative delivery and continuous enhancement of the responsive portal solutions.

Environment:

SharePoint On-Premises, SharePoint Server 2013/2016, SharePoint Designer, VS.NET, C #, ASP.NET, Power Automate, PowerApps, Power BI, Dynamics CRM, DAX, Dataverse, SSIS, SSAS, SSRS, SQL Server, Excel, Azure, CI/CD pipelines, Agile methodologies, Nintex Forms, CSS, HTML, JavaScript

Contact this candidate