Power Platform Bi

LOKESH SORATE

******.******@*****.*** / 812-***-**** / Albany, NY

SUMMARY

Analytical and statistical Technical Lead Consultant with 15+ years of experience in Microsoft technologies, Power Platform, and Dynamics 365. Skilled in M365, Azure, and .NET. Adept in designing scalable solutions, streamlining processes, and driving innovation.

SKILLS

Streamlining Processes, System Integration, Architecture Design, Time-Management, Diligence Technical Skills

• Power Platform: Canvas Apps, Model-Driven Apps, Dynamics 365, Power Pages, Power Automate, Power BI, Business Process Flows, PCF Components, MS Dataverse, Power Virtual Agent, Power Platform Center of Excellence (COE) toolkit, Power Platform ALM Pipelines, Data Flows, Power Platform Creator Kit, XRM Toolbox

• Microsoft Azure: Azure Synapse, Azure App Service, Azure Functions, Azure Service Bus, Logic Apps, Application Insights, Azure DevOps, Blob Storage, ADLS Gen2, Azure SQL Server

• Programming Languages and Frameworks: C#, ASP.Net, .Net Core, ADO.NET, MVC, Entity Framework, CSOM, PowerShell, HTML5, CSS3, jQuery, JavaScript, Typescript, Razor, Blazer, React JS, Python (PySpark, Pandas, NumPy, SQLAlchemy), REST API, WCF, Web API, Redis Cache

• Microsoft Tools: Visual Studio/Visual Code, SharePoint Designer, Microsoft Forms, Microsoft Teams, Yammer, MS Office, SQL Server, SSRS, SSIS

• M365: Office 365, SharePoint 2019/2016/2013/2010/2007, Nintex Workflows, Nintex Forms, Lightning Tools, SPFx Webparts, SharePoint Designer, InfoPath Forms

• Others: Okta, Sharegate, Metalogix, AvePoint, QlikView, Rational Clear Case, Rational Performance Tester, Remedy, ServiceNow, GitHub, TFS

WORK EXPERIENCE

• PamTen Inc. - USA (Feb 2020 – Present)

• MaxoTech Solutions LLC - USA (Aug 2018 – Jan 2020)

• Infosys - USA (Nov 2016 – Jul 2018, Jan 2011 – Apr 2014)

• Infosys - India (Jan 2008 – Jan 2011, Apr 1014 – Nov 2016)

• eRaytec International Inc. - India (Aug 2005 – Jan 2008) Client: Department of Children and Families, State of FL (Apr 2023 to till date) Role: Power Platform Lead

Location: Remote

Key Result Areas

• Designed & implemented scalable, secure, & cost-effective architectures by utilizing Power Platform, .Net, & Azure, driving enterprise-wide digital transformation & aligning with business goals.

• Designed and customized solutions using the Power Platform suite (Power Apps, Microsoft Dataverse, Power Automate, Power BI) alongside Microsoft Dynamics.

• Integrated MS Dataverse with SQL Server, SharePoint, and external systems for seamless data flows and system interoperability using Dataverse and custom connectors and automated workflows with PowerApps and Power Automate to improve data accuracy and efficiency.

• Customized Model-driven PowerApps and Canvas apps using PCF Component framework, Business Process Flows, Power Automate, Business Rules, JavaScript, and TypeScript.

• Implemented enterprise-level governance with the Power Platform Centre of Excellence (COE) Toolkit and streamlined application delivery by designing and managing CI/CD pipelines using Azure DevOps and Git.

• Enhanced system performance and scalability, ensuring compliance with data privacy and security regulations.

• Designed and optimized ETL pipelines and data workflows in Azure Synapse using Python, PySpark, and SQLAlchemy, enabling seamless data integration and processing around 2TB+ of raw data while delivering actionable insights through interactive dashboards in Power BI, SSRS, and QlikView.

• Directed cross-functional technical teams to design and deliver enterprise solutions, translating complex business requirements into effective architectures and ensuring seamless implementation through POCs, wireframes, and technical documentation.

• Optimized Power BI dashboards by structuring ADLS Gen2 datasets into Delta Tables and utilizing DAX for real-time analytics.

• Good understanding of Sales, Marketing, Field Service, and Customer Service modules in D365.

• Collaborated with Agile teams in sprints and standups, achieving 95% on-time delivery of planned features. Client: Regeneron Pharmaceuticals (Feb 2020 to Mar 2023) Role: Power Platform/M365 Consultant

Location: Rensselaer NY, USA

Key Result Areas

• Spearheaded the technical and architectural design of Canvas and Model-Driven PowerApps solutions, driving improved productivity and collaboration across multiple business units.

• Customized Canvas and Model-Driven PowerApps using PCF Component Framework, Business Process Flows, Business Rules, JavaScript, and TypeScript to enhance app functionality.

• Created custom workflow components leveraging PowerApps, Power Automate, Nintex Forms, SharePoint Framework

(SPFx), and Designer Workflows to streamline operations.

• Led SharePoint migration from SP2013 to O365, redesigning custom components for seamless integration and enhanced functionality.

• Proficient in executing projects with the .NET framework using C#, ASP.NET Core, ASP.NET, MVC, ADO.NET Entity Framework, SQL Server, HTML5, CSS3, Bootstrap, jQuery, React JS, Redis Cache, and CDN.

• Developed and managed Azure APIs, WCF, REST Services, SharePoint Server APIs, SharePoint Object Model, SharePoint REST and ODATA services, ensuring adherence to best practices with respect to sizing, architecture, and search.

• Integrated Office 365 tools like Yammer, Planner, Delve, and Teams to enhance SharePoint collaboration capabilities.

• Designed intranet solutions using SharePoint Online Provisioning Service and Hub Sites for improved organization and navigation.

• Migrated ASP.NET MVC applications to Azure Cloud using Azure App Services, Azure Functions, and Web Jobs for better scalability and performance.

• Designed and developed databases on SQL Server, creating Stored Procedures, Triggers, and Indexes to optimize data management.

• Implemented CI/CD pipelines with Azure DevOps and Git to improve deployment efficiency and maintain version control. Client: Cummins Inc

Role: Technology Lead

Location: Columbus IN, USA (Nov 2016 to July 2018) and Pune, INDIA (Jul 2014 to Nov 2016) Key Result Areas

• Streamlined and automated application migration processes for implementing IBM connections to O365 applications for 11,000 applications which reduced migration timeline by 30%.

• Strategized IT Service Management processes, day-to-day SLA/KPI reporting, and escalation handling, assisting RFEs, including interactions with Client Managers.

• Functioned as the single point of contact (SPOC) for technical escalations, ensuring swift issue resolution and informed decision-making throughout the project lifecycle.

• Built custom components using Power Apps, Power Automate, Nintex forms and workflows, SharePoint PHA, SharePoint custom web parts, designer workflows, Event Receivers, Feature Receivers, Timer Jobs, PowerShell, and SharePoint framework (SPFx).

• Utilized Bootstrap, jQuery, JavaScript, TypeScript, Angular, React and CSS to create responsive front-end designs and enhance site aesthetics per user requirements.

• Created a Digital Record Canter in SharePoint O365 using OOTB features, custom APIs to migrate file shares across cross functional teams to O365 record centre and adhere organizational ECM policies.

• Proficient in creation, modification and effectively use of database objects like SQL Tables, Constraint, Indexes, Triggers and Stored procedures.

• Developed and maintained interactive reporting dashboards using tools like Power BI, SSRS, and Excel, enabling data- driven decision-making and delivering actionable insights to stakeholders.

• Participated in all phases of the software development lifecycle, including user meetings, requirement gathering, project milestone tracking, status meetings, application testing, and end-user training.

• Gathered and documented requirements from non-technical business users, translated business requirements into system requirements, created prototypes, demoed to users, and implemented solutions.

• Utilized DevOps (VSTS) with Git repository for code versioning and deployment. Client: Intel Corporation (May 2011 to Jun 2014)

Role: Technology Lead

Location: Hillsboro OR, USA

Key Result Areas

• Used ASP.NET MVC4 to build the application, used Razor View Engine and Worked on Views, Controller, and Models for Patients and Payment module.

• Used JQuery, JavaScript, Bootstrap and CSS to enhance the sites look and feel as per the user requirements.

• Developed custom functionality such as document upload with the web service.

• Generated Reports for statistical analysis of data at user level using SSRS.

• Preparing training documentation to developers and stakeholders.

• Involved in all phases of the software development life cycle. It includes leading user meetings, facilitating requirement gathering, tracking project milestones, conducting project status meetings, testing applications, and training end users.

• Responsible to integrate of software modules (version control and Package releasing). Client: Volkswagen (Jan 2011 to May 2011)

Role: Sr. Software Developer

Location: Auburn Hills MI, USA

Key Result Areas

• Created ASP.NET web tool to read EDI maps from vendors and push to DB using web service.

• Developed Pages of ASP. NET using HTML Controls, Data Grid, Data List and Validation controls.

• Developed ASP.NET (ASPX) class/modules to display backend data on the web browser using ADO.NET.

• Configured Web service to authenticate clients with Windows credentials for intranet applications for login validations. Client: Emerson (Jan 2010 to Jan 2011)

Role: Sr. Software Developer

Location: Mangalore, INDIA

Key Result Areas

• Facilitate requirement gathering sessions and drive requirement harmonization process.

• Performed estimation, planning, and scheduling tasks.

• Created different users, roles, document libraries, form libraries, Team sites for projects, issue Lists on MOSS 2007.

• Created Sites and Sub-sites within the site collections for Various Departments and accordingly created new Site Permission levels and Groups for SharePoint 2007 site.

• Involved in designing and creating Master Pages and various page layouts.

• Deployed Site Features and Custom List with Site Columns and Content Type by using SharePoint Management shell.

• Developed Event Handlers to update the comment history for the comments entered in the InfoPath browser enabled forms.

• Worked on developing Search, Crawl, and Index notes for searching and bringing the documents into SharePoint Portal Server & maintaining backups and recovery for the entire SharePoint sites.

• Developed Unit test cases and executed them.

Client: Eastman (Jan 2008 to Jan 2010)

Role: Sr. Software Developer

Location: Mangalore, INDIA

Key Result Areas

• Participate in the planning and execution of development tasks while ensuring high site availability and uptime.

• Gather and document requirements from non-technical business users, translate the business requirements into system requirements, create a prototype of recommended solutions, demo to the users, and implement the solution.

• Created different users, roles, document libraries, form libraries, Team sites for projects on SharePoint Server 2007.

• Developed new Features to create new sites, new list definitions, new document libraries using C# coding and deploying features at various levels Web application, Site level and site collection level.

• Configure and maintain various SharePoint applications including lists, document libraries, site collections.

• Involved in designing and creating Master Pages and various page layouts.

• Performed administrative activities using Power Shell such as backup, restore, migration of sites, installing Features, indexing and deployment of Solution packages.

• Developed custom web parts and deployed using features.

• Written complex procedures, function, and triggers in SQL database to implement business logic.

• Optimum use of Web services for distributed application functionality and scalability. Employer: eRaytec International Inc. - India (Aug 2005 – Jan 2008) Role: Software Developer

Location: Pune, INDIA

• Worked on complex .Net multitier applications.

• Written complex procedures, function, and triggers to implement business logic.

• Optimum use of Web services for distributed application functionality and scalability

• Designed innovative User Interface for web application which helped my employer to win prospective project. CERTIFICATIONS

• Microsoft Power Platform Solution Architect (PL-600)

• Microsoft Power Platform Developer Associate (PL-400)

• Microsoft Azure Developer Associate (AZ-204)

EDUCATION

Bachelor of Engineering in Information Technology

Nagpur University – Nagpur, Maharashtra, India.

LINKS

https://www.linkedin.com/in/lokeshsorate

Contact this candidate