Lokesh Sorate

About Lokesh Sorate

Strategic and purposeful Technical Consultant with over 15 years of expertise in software design, development, and deployment across diverse industries. Skilled in full-stack development, system migrations, and cloud integration, with a strong focus on scalability, process optimization, architecture Design, and digital transformation. Demonstrated expertise in guiding teams and driving impactful, forward-thinking solutions that enhance business efficiency and innovation. My experience spans: Solution Architecture: Designed and implemented scalable, secure, and cost-effective architectures utilizing D365, Power Platform.NET, and Azure, driving enterprise-wide digital transformation and aligning with business goals. System Integration and Data Management: Engineered seamless integration of diverse systems with Dataverse, developed custom connectors, and optimized data migration processes ensuring data reliability and scalability. Data Engineering and Business Intelligence: Built efficient ETL pipelines and data workflows in Azure Synapse, Azure Data Factory, Databricks, Azure Fabric and ADLS leveraging Python, Spark and SQL Alchemy. Delivered advanced analytics and actionable insights via interactive dashboards in Power BI, SSRS and QlikView. Governance and DevOps Frameworks: Established enterprise-grade governance using the Power Platform Center of Excellence (COE) Toolkit. Designed and managed CI/CD pipelines with Azure DevOps and Git, ensuring consistent and streamlined application delivery. Leadership and Strategic Collaboration: Led cross-functional technical teams in defining and delivering enterprise solutions. Collaborated with stakeholders to translate complex business requirements into effective architecture, producing POCs, wireframes, and technical documentation to ensure seamless implementation.Passionate about technology and continuous learning, I empower organizations by blending technical prowess with effective end-user training and strategic stakeholder engagement, positioning myself as a transformative asset in any enterprise setting.

Experience

1. Technical Consultant

   PamTen Inc

   Feb 2020 — Present

   Key Result Areas• Designed & implemented scalable, secure, & cost-effective architectures by using Power Platform suite (Power Apps, Microsoft Dataverse, Power Automate, Power BI), M365.Net, & Azure, driving enterprise-wide digital transformation & aligning with business goals.• Customized Model-driven PowerApps and Canvas apps using PCF Component framework, Business Process Flows, Power Automate, Business Rules, PowerFx functions, JavaScript, and TypeScript.• Integrated MS Dataverse with SQL Server, SharePoint, and external systems for seamless data flows and system interoperability using inbuilt and custom connectors, SSIS and automated workflows with PowerApps and Power Automate to improve data accuracy and efficiency.• Experienced D365 Customer Relationship Management, Sales, Marketing and developed custom workflows, plug-ins, ribbon controls, sitemap, and integrated custom web pages into CRM.• Enhanced system performance and scalability, ensuring compliance with data privacy and security regulations.• Developed adaptive solutions that combined RPA with AI capabilities for intelligent decision-making, enhancing data analysis and process improvements.• Designed and implemented AI-powered solutions within Power Automate and Power Apps, using Copilot Studio to enhance workflow automation, improve decision-making, and integrate intelligent conversational experiences. • 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.• 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.• Collaborated with Agile teams in sprints and standups, achieving 95% on-time delivery of planned features.

Education

• Nagpur University

  BE, IT

  2001 — 2005

Skills

• Avepoint
• Css
• Extract, Transform, Load (Etl)
• O365
• Vb.net
• Nintex
• Concept Search
• Sql
• Asp.net
• Itil
• Databases
• Microsoft Office Sharepoint Server
• Jquery
• Web Applications
• Javascript
• Requirements Gathering
• Itil Process
• Asp.net Ajax
• C#
• .net
• Microsoft Power Bi
• Css3
• Html5
• Docave
• Design Patterns
• Bmc Remedy
• Sharepoint
• Jquery Mobile
• Sdlc
• Sql Server Reporting Services (Ssrs)
• Microsoft Sql Server
• Scrum