Ahsan Khalid

Lead Dynamics 365 CE design, development, and continuous improvement across business areas.

• Act as technical lead for CRM enhancements with stakeholders, suppliers, partners.
• Gathered, analysed, and documented requirements to create scalable Power Platform solutions that meet business needs.
• Designed and implemented end-to-end processes with Dataverse, Power Apps, Power Automate to streamline operations.
• Design data models, rules, security roles, forms, views, and model-driven apps.
• Design and support integrations using REST APIs, app registrations, and Power Automate.
• Develop and optimise SQL queries, stored procedures, and reporting datasets.
• Design and deliver executive Power BI dashboards for forecasting and KPIs.
• Lead solution deployments across development, UAT, and production using Managed Solutions.
• Develop Power Pages portals and Customer Voice solutions for engagement improvements.
• Perform system analysis, root cause investigations, and impact assessments for incidents.
• Ensure data quality through validation automation and governance across Microsoft ecosystem.
• Provided technical leadership and mentoring while delivering third-line support for business-critical applications, ensuring system reliability.
• Collaborate with senior management on digital transformation and process automation opportunities.
• Produce functional specs, technical documentation, solution designs, and user stories in Agile.

• Analyzed and documented high level and detailed business requirements and translated them into a use-case diagram.
• Defined and documented high-level business requirements to align with stakeholders' expectations and improve project outcomes.
• Analysed the lack of reporting in existing business systems and implemented a Power BI reporting solution using APIs.
• Analyzed reports and database to identify inconsistencies and ensured the adequate implementation of the new system.
• Analyzed data performance and implemented changes necessary to improve execution time.
• Analyzed repetitive tasks in the business and developed automated solutions using Alteryx and Microsoft Power Automate.
• Managed internal ticketing and asset management system, SysAid, ensuring optimal functionality for user support.
• Established goals and key operational metrics to evaluate work group performance and drive continuous improvement.

• Published Power BI reports and made dashboards accessible via web clients and mobile apps for organisational stakeholders.
• Analysed data using multiple visualisation techniques in Power BI. and across multiple visualizations using Power BI.
• Created DAX queries for computed columns in Power BI to enhance data analysis capabilities.
• Generated computed tables in Power BI by using Dax.
• Imported data from SQL Server and Azure SQL databases into Power BI for report generation.
• Published reports and dashboards using Power BI.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Created new stored procedures and optimised existing queries and stored procedures.

• Provided technical support, resolving queries via phone and email.
• Logged and prioritised system and user support calls for second line support team, ensuring efficient resolution.
• Recorded and actioned faults on PCs, servers, laptops, and mobile devices to restore functionality.
• Determining the nature of faults and the steps required to rectify them.
• Remote administration and management of customer premises equipment.
• Created and maintained email profiles for users, ensuring proper access and functionality. email profiles for users.
• Closed support tickets promptly after confirming restoration of normal service.