Home

Ashok Kumar - Lead Microsoft Power Platform consultant

[email protected]

Location: Edison, New Jersey, USA

Relocation: Yes

Visa: H1B

Resume file: Ashok_Power platform_1760629683148.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Ashok Kumar Microsoft Power Platform consultant Edison, NJ 08820 | [email protected] | +1- 940-945-4443 Professional Summary 11 years of IT Experience and 7+ years of experience as senior RPA Developer using Power Apps, Power Automate & Blue Prism tools. Involved in Full Software Development Life Cycle (SDLC). Used to analyze, understand, and document the business processes in detail where required using tools like Power Apps, Power Automate and Blue Prism. Hands-on experience leveraging Copilot in Microsoft 365 apps for productivity enhancement, report generation, and automation assistance. Designed interactive Power BI reports that visualize data collected via Power Apps forms, enabling stakeholders to monitor key metrics and KPIs seamlessly. Interacting with Business teams and Other Teams for requirements. Involved in Process walkthrough to understanding requirements. Involved in development in business Objects and processes for web, windows, Java, SAP, and Mainframe based applications. Developed end-to-end BI solutions using Power Apps for data entry and Power BI for analysis, improving reporting efficiency and eliminating manual processes. Worked on Process Definition Document (PDD) and Solution Design Document (SDD) step by step. Developed the Automation process as per acceptance criteria. Used Environment Locking to an achieve data integrity. Implemented Schedulers to run the Bot Fat schedule times as per client requirement. Experienced in using the Control room to execute the process and monitor the process. Experience in exception handling using exception, recover and resume stages. Experience with APIs and web services Expert in designing & developing business applications using Canvas Apps, Model-Driven Apps, and Power Apps Component Framework (PCF) for customized user experiences. Expertise in Power Pages development for building secure, external-facing portals integrated with Microsoft Data verse & other enterprise systems. Knowledgeable in authentication, security best practices, and ALM (Application Lifecycle Management) for Power Platform solutions. Automated reporting workflows by integrating Power BI, Power Apps, and Power Automate, reducing reporting time by 60% and increasing data reliability. Proficient in Power FX for writing logic expressions, formulas, and implementing business rules within Power Apps. Built model-driven and canvas apps with Dataverse as the backend, enabling secure and centralized data storage Worked extensively in analyzing and refining business processes, collaborating with business users to provide optimized, low-code automation solutions. Experience in debugging and troubleshooting Power Platform solutions, implementing error handling and logging mechanisms for high-performance automation. Hands-on experience in managing Power Platform environments, deployments, governance, and compliance to ensure enterprise-level scalability. Strong experience in training, mentoring, and guiding junior developers in best practices, coding standards, and solution design. Excellent problem-solving, stakeholder communication, and documentation skills, including preparation of PDDs, TDDs, and Solution Design Documents. Proficient in working with Agile & Scrum methodologies, ensuring timely delivery of automation projects with high quality and minimal risk. Comprehensive knowledge of Office 365, SharePoint Online, Microsoft Teams, and ServiceNow for process automation and workflow optimization. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure and strengthened in adaptability, analytical and problem-solving skill. Well-trained in using power automation tools for process automation and workflow optimization. Expertise in designing and implementing Cloud and Desktop flows within Power Platform. Hands-on experience with ServiceNow automations and integration Committed to delivering cutting-edge automation solutions to optimize business processes and drive efficiency. Proficient in Python programming for creating efficient automation solutions. Used Copilot in Power Automate and Power Apps to auto-generate flows, suggest expressions, and improve app logic through natural language prompts. Integrated Power Automate with SharePoint and Copilot to streamline approval flows and documentation publishing. Expertise in developing solutions using custom connectors and gateways. Proficient in reporting and addressing automation incidents in ServiceNow, ensuring smooth software updates, and enhancing automations across diverse environments. Expertise in troubleshooting and resolving the production issues (L1, L2, L3) Diligently review upcoming changes and maintain comprehensive documentation for seamless operations. Collaborate with Automation CoE to conduct periodic health checks and handle platform escalations effectively. Involved into the end-to-end migration of automation workflows from Blue Prism to Power Automate using Blueprint, ensuring a smooth transition with minimal business disruption. Redesigned Blue Prism workflows in Power Automate, optimizing efficiency, reducing dependencies, and improving execution speed. Converted Blue Prism automation scripts into Power Automate flows, ensuring seamless integration with Microsoft tools like SharePoint, Outlook, and Teams. Designed and implemented scalable data models using Microsoft Dataverse to support multiple Power Apps applications across departments Mapped Blue Prism queue-based processing to Power Automate, maintaining structured transaction handling and error management. Optimized existing Blue Prism processes before migrating them to Power Automate, improving workflow performance. Resolved compatibility issues when migrating Blue Prism workflows to Power Automate by modifying logic, selectors, and triggers. Provided training and documentation to help teams adapt to Power Automate after migration. Ensured compliance with security policies, updating authentication methods and permissions in Power Automate. Having work experience in Banking, Health Care and Telecom domains. CERTIFICATIONS: Power Platform Developer (PL 400) Power Platforms Fundamentals (PL 900) Microsoft Power Automate RPA Developer (PL-500) Certified Blue Prism Accredited Developer (AD01) Certified Blue Prism Professional Developer (APD01) Technical Skills Automation Tools Power Apps, Power Automate, Blue Prism, UiPath, and Automation Anywhere. Methodologies Agile, Scrum Entity Frameworks Web API, WEB Services, WCF Services, Restful Services Tools JIRA, Service Now, MS Word, MS Excel, MS PowerPoint Cloud Saas, PAAS, AWS, Azure Programming Languages C, C#, VB .NET, Python, JavaScript Data Base SQL Server Work Experience State of NC [ Department of Water Resource ] Dec 2024 - Present Lead Microsoft Power Platform consultant Designed and developed the core architecture for Power Platform applications, leveraging Canvas and Model Driven Power Apps and Power Automate to automate workflows and processes. Leveraged AI Builder to develop intelligent document processing solutions, streamlining data handling. Analyzing the problems and implement the processes to improve Innovative ideas to reduce the time span of a process Business Logic implementation / coding as per the design specifications Involved in User Interface Design as per Client specifications Involved in unit testing and Bug Fixes Defined custom tables, relationships, and business rules in Dataverse to enforce data integrity and automate validations Involved in Requirement Gathering and Analysis Attend the meetings/sessions with existing team members to understand the new applications and document the findings as Knowledge Capture Documents to upgrade the application Conducted engaging training sessions and workshops, educating end-users on effective utilization of Power Platform solutions. ETL / Data Integration: Alteryx, Azure Data Factory (ADF), Power Query, SQL Server Integration Services (SSIS), Dataflows Provide support to users for automation failures, promptly diagnosing and addressing issues based on severity levels Report, track, and address automation incidents using ServiceNow for efficient incident management Lead the deployment of new versions of updated software and enhanced automation strategies across diverse environments Utilized Dataverse auditing and change tracking to maintain data history and meet compliance requirements. Initiate and approve access requests and user provisioning to ensure seamless access to automation systems Manage the change management process for production deployments, offering review and sign-offs for smooth releases Used Alteryx workflows to automate complex data preparation tasks, significantly reducing manual effort and improving report accuracy. Developed and implemented Power Automate workflows to streamline business processes and enhance productivity Integrated Power Apps with Power Automate & Blue Prism to create cohesive business solutions Collaborated with cross-functional teams to ensure seamless integration with various systems and applications Designed and deployed connectors using JavaScript, and Python for integration with external systems Identified opportunities for process automation and provided strategic recommendations for implementing Power Automate Conducted thorough testing, debugging, and troubleshooting of Power Automate workflows and connectors Documented technical specifications, system architecture, and workflow designs for reference Assisted in user acceptance testing (UAT) and supported production deployment Stayed up-to-date with the latest developments in Power Automate and connector development Developing the process (from scratch) based on business flow in an efficient way Working close with the client at the Client Location and proactively providing inputs to their business Optimizing the code such that final process is bug free and takes less time to run completely Doing Unit testing of the code and helping testers to perform System Integrating Testing and collaborating with the client to perform User Acceptance testing Involved in the issue solving with the other teams as well Microsoft Power Platform consultant MAY 2022 to NOV 2024 CareFirst BCBS [Accenture] HYD, IN Designed and developed custom Canvas Power Apps to streamline manual business processes, enhancing operational efficiency and user experience. Created automated workflows using Power Automate to streamline business tasks, approvals, notifications, and data synchronization across Microsoft 365 and external systems. Built interactive and insightful dashboards using Power BI, connecting to multiple data sources to support business intelligence and decision-making. Integrated Power Platform solutions with Microsoft Dynamics 365, SharePoint, SQL Server, and third-party applications using standard connectors and custom APIs. Implemented robust security roles and data access policies across Power Platform components to ensure compliance and data integrity. Collaborated with business users and stakeholders to gather requirements, design prototypes, and deliver user-centric low-code solutions. Developed reusable components and custom connectors to extend the capabilities of Power Apps and Power Automate across different departments. Managed application lifecycle using ALM practices, including version control, environment strategies, and deployment via Azure DevOps. Provided ongoing support, troubleshooting, and enhancements for existing Power Platform solutions to ensure optimal performance and usability. Conducted end-user training sessions and prepared documentation to drive adoption and empower users with self-service capabilities. RPA SENIOR DEVELOPER Jan 2020 Apr 2022 Deloitte, HYD, IN Involved in all phases of RPA lifecycle which includes requirements gathering, development, testing and deploying to production using Blue Prism Configured automation processes as per Technical Design Documents Interacted with Business People in gathering more information on the Process During the live functioning of the tool developed, our task is to check for the consistency of the tool and ensure that there is no malfunctioning on the go-live Successfully handled business and system exceptions with proper maintenance of Audit Log Created Solution Design Documents (SDDs) for a Robotic Process Automation project based on Process Definition Documents (PDDs) discussions with business stakeholders Interacted with window & Web-based application and created objects and interacted all the objects in process studio and created work queues Involved in gathering detailed requirements from client for business requirements Solid design, coding, testing, and maintaining the bots Implemented Blue Prism User authentication by defining user roles, creating users and setting password policies Experience in staging and deploying the automation solution into test and live environments Maintain Login credentials for all the Live Robots, developers and ensure to reset for expiration periods Understanding of worked flow-based logic and ability to understand the business process from a workflow diagram and to conceptualize it as an automated solution Handling runs time issues and bugs on time Created and document test procedures and scenarios for the pre- UAT phases and supported operational teams during the UAT and rollout phases RPA DEVELOPER Feb 2018 Dec 2019 CenturyLink [PRICESENZ], HYD, IN Exception handling and Problem solving Feasibility analysis and understanding the business flow Analyzing the problems and implement the processes to improve Innovative ideas to reduce the time span of a process Hands on experience in creating Windows Application Extensive involvement in automating deployment process by using TFS Release management Have played significant roles in all stages of Development Life Cycle Understanding the requirement & importance of automation Responsible for building projects using Blue Prism to automate Business Process end-to- end Worked with different roles like business analyst, Solution architect during requirement gathering Expertise in Unit & SIT testing of Process before deploying to Control room Participated in UAT to provide instructions to Operator Team Participated in TGL & BGL to provide assistance Automated Windows and web-based Applications Developing and delivering automated systems of the client to improve efficiency and reduce risk Delivered solutions to complex problems and meet daily deadlines During the live functioning of the tool developed, our task is to check for the consistency of the tool and ensure that there is no malfunctioning occurring after the deployment SQL DBA & .NET DEVELOPER Sept 2014 Dec 2017 CIESTO information Technologies, INDIA Provided 24 x 7 Production support for the database issues Day to day support of SQL DB Monitoring and maintenances for high availability Very good experience in Installation, configuration and maintenance of SQL Server Experience in MS SQL Server upgrade from MS SQL Server 2000 to MS SQL server 2005 and MS SQL Server 2005 to MS SQL server 2008 Add/Delete user accounts, roles, maintain security and audit policies. Used SQL Profiler, Performance Monitor and DBCC Commands Experience in Database backup and disaster recovery procedures Experience of Log shipping and DB Mirroring Implemented and Configured SQL Cluster Environment Created API Services with Entity framework and LINQ Queries and consuming the services in Client Designed the Business Logic Layer, Data Access Layer components using C# .Net framework class library component Created Stored Procedures, Views, and Triggers Prepared the Unit Test Cases HR Recruiter Feb 2009 Apr 2014 Pro Matrix HYD, INDIA Strong communication and interpersonal skills Good understanding of recruitment tools and Applicant Tracking Systems (ATS) Time management and organizational ability Decision-making and negotiation skills Knowledge of labor laws and recruitment best practices Education : B.Sc. (Computers) Andhra University - India 2007 Keywords: cprogramm csharp artificial intelligence business intelligence database information technology golang microsoft mississippi procedural language New Jersey North Carolina South Carolina