Sohail Shaikh

[email protected] • +91 7755973734

PROFESSIONAL SUMMARY

Results-driven Junior Software Engineer with over 3 years of experience specializing in Power Platform solutions, including Power Apps, Power Automate, and SharePoint Online. Proven track record of developing and deploying 10+ custom Canvas and Model-Driven apps that increased operational efficiency by 25% across client projects. Adept at leveraging Dataverse and SQL to design scalable data models and automate workflows, enhancing business processes in dynamic environments. Committed to delivering innovative, user-centric solutions that drive measurable improvements and support organizational goals.

WORK EXPERIENCE

Junior Software Engineer
05/2022 - Present
Lance Soft Engineering PVT. LTD, Hyderabad , Hyderabad
• Led the creation and management of over 10 SharePoint sites, site collections, and subsites, improving team collaboration and document accessibility for 200+ users
• Developed and customized SharePoint lists and libraries with advanced metadata and permission settings, enhancing data organization and security
• Automated key business processes by designing and implementing 15+ Power Automate workflows, reducing manual tasks by 30% and accelerating document approvals
• Integrated Power Apps with SharePoint for seamless CRUD operations, delivering user-friendly business applications that increased operational efficiency by 25%
• Engineered automated archiving solutions for SharePoint list items older than 30 days, optimizing data retention and storage costs
• Created dynamic Teams Adaptive Card alerts triggered by specific sender emails, improving real-time communication and response times by 20%
• Utilized Power Automate to analyze Dataverse tables and retrieve top 3 frequently occurring items, supporting data-driven decision-making
• Conducted rigorous testing, bug fixing, and flow monitoring to ensure 99% uptime and reliability of automated processes

EDUCATION

Bachelor of Science
GPA: 76.60%

SKILLS

Technical Skills: Sharepoint Online, Office 365, SQL, Dataverse, Power Platform, Power Apps (Canvas App, Model-Driven App), Power Automate, Power Fx, Custom Connectors, Jira, HTML, CSS, JavaScript, React Js

PROJECTS

ORI Dashboard
Technologies: Power Apps (Canvas), Power Automate, SQL Server (AWS), Stored Procedures, Collections, Responsive Design
• Developed a Power Apps Canvas-based dashboard for real-time boiler and container outage tracking, performance evaluations, and planning across multiple facilities
• Designed for high performance, modularity, and SQL-based data integrity
• Architected secure hybrid connectivity between Power Apps and AWS-hosted SQL Server via On-Premises Data Gateway
• Optimized data handling by consuming stored procedure outputs in Power Apps using ClearCollect() for caching, filtering, and UI binding
• Built client-side validation with IfError() and database-level validation to enforce business rules and prevent duplicates
• Developed a reusable comment popup component integrated with SQL via Power Automate or direct patching, featuring last-comment retrieval
• Delivered a fully responsive, modular UI to support both operations and engineering teams
Budget Request & Expense Management App
Technologies: Power Apps, Power Automate, SharePoint
• Developed a comprehensive business app to streamline budget requests and expense tracking across departments
• Integrated role-based access, automated workflows, and real-time budget monitoring
• Designed role-based screens for users, managers, and admins with specific permissions
• Implemented search and filter functionality by employee name, expense type, and date
• Automated email notifications for request submission, approval, and rejection using Power Automate
• Enabled attachment uploads and comments for each budget request
• Created visual indicators for budgeted, spent, and remaining amounts to enhance decision-making
Godavari Drugs Limited (Client)
Technologies: Power Apps, SharePoint
• Developed an intranet portal for a pharmaceutical company to centralize document management and communication
• Created role-based pages and customized Power Apps forms for departmental workflows
• Managed departmental document libraries and implemented metadata-driven search
• Created site collections, subsites, lists, and libraries tailored to departmental needs
• Designed role-specific homepages to improve navigation and user experience
• Configured access permissions for users and groups to ensure data security