Umair Sohail

As an Analyst within Landsec’s Aspire team, I delivered data solutions that improved service quality and operational performance across a major real estate portfolio. I partnered with the central DataOps team and frontline property teams to turn data into fast, reliable insights that supported day-to-day decision-making. Using SQL, DAX, Excel, Power BI, and Azure, I led end-to-end analytical initiatives that automated manual work, strengthened reporting accuracy, and improved visibility across the property estate. My contributions drove measurable impact, including: Optimised Azure Data Lakehouse pipelines, improving data refresh reliability and reducing latency for operational dashboards. Built Power BI dashboards (using DAX and SQL) that gave property managers real-time insight into service performance, attendance, and contractor KPIs that enable faster response and tighter quality control. Automated Excel and SQL workflows, reducing manual reporting time by X% and freeing teams to focus on higher-value tasks. Enhanced data quality across assets by standardising inputs, cleaning irregular datasets, and identifying gaps that directly affected bonus schemes, service audits, and financial forecasting. Improved query performance through SQL optimisation, cutting processing time and speeding up data-driven decision cycles. Strengthened operational planning by providing data models that helped forecast service demand, track site performance, and support strategic initiatives across the real estate portfolio. Across all projects, I focused on delivering solutions that were scalable and automated driving higher efficiency, clearer insight, and more confident decision-making throughout the organisation.

In my role supporting NHS workforce and recruitment operations, I analysed large, complex healthcare datasets to deliver accurate weekly, monthly, and quarterly insights to NHS partners and internal stakeholders. Using SQL, Power BI, and Excel, I transformed raw recruitment, staffing, and performance data into clear, actionable intelligence that directly supported hiring decisions, workforce planning, and service delivery. I played a key role in strengthening recruitment reporting workflows and ensuring leadership had the insight needed to align staffing levels with operational demand. My work drove measurable improvements across efficiency, visibility, and data quality. Key impacts include: Streamlined recruitment and workforce reporting, reducing preparation time by 15% through SQL optimisation and Excel automation, ensuring consistent and timely submissions to NHS stakeholders. Built Power BI dashboards that gave recruitment and HR teams real-time visibility into candidate pipelines, vacancy trends, onboarding performance, and fill rates — enabling faster and more informed decision-making. Automated recurring reports for hiring managers and NHS partners, improving accuracy, cutting manual work, and providing up-to-date insights on staffing levels and operational capacity. Enhanced data quality across recruitment records, identifying inconsistencies, standardising inputs, and improving the reliability of workforce metrics. Advised leadership on a future-ready database roadmap, supporting system improvements that strengthened recruitment analytics, data governance, and long-term workforce planning. Across every initiative, my focus was on delivering insights that supported effective hiring decisions, improved operational efficiency, and helped the NHS maintain high-quality, well-staffed services.

As a Database Analyst at TwentyCi, I managed high-volume operational databases that supported marketing intelligence, consumer insight, and property-sector analytics. I ensured the accuracy, accessibility, and performance of datasets used by both internal teams and external clients, working closely with data engineering, analytics, and product teams to maintain efficient workflows and reliable decision-making. I played a central role in strengthening data quality processes for millions of consumer and property records, using SQL, Excel, and internal ETL tools to enhance dataset integrity, streamline data flows, and improve downstream reporting accuracy. I designed and implemented rigorous data quality control procedures that reduced discrepancies and duplicate records by 25%, and I cleansed, validated, and mapped over 1.5 million records to improve integration across CRM systems, marketing platforms, and analytics tools. In addition, I monitored and optimised database performance by identifying slow-running processes, resolving data issues, and enhancing refresh reliability for operational users. Through close collaboration with cross-functional teams, I improved the usability and structure of core datasets, enabling more accurate segmentation, modelling, and customer insight generation. I also led the rollout of new data systems and governance strategies, increasing overall data accuracy and usability by 20% and strengthening confidence in high-volume datasets across the organisation. To support long-term operational efficiency, I developed scalable documentation and data mapping resources that streamlined onboarding and reduced reliance on manual knowledge transfer. Collectively, my contributions helped build a more robust, high-quality data ecosystem that elevated TwentyCi’s business intelligence capabilities and supported stronger, data-driven operations.

As a Data Security Analyst at Cardtronics, I monitored and assessed security threats across the UK ATM asset portfolio, ensuring proactive risk mitigation and operational continuity. I produced daily and weekly threat intelligence reports for internal operations teams and external stakeholders, improving transparency around emerging risks and strengthening incident response preparedness. I maintained a central master data repository to ensure the accuracy and reliability of descriptive and diagnostic security reporting, using historical data to identify patterns, recurring vulnerabilities, and high-risk asset behaviours. In collaboration with engineering, operations, compliance, and field security teams, I supported the implementation of targeted security controls on ATM assets and helped embed a culture of security awareness and GDPR compliance throughout the organisation. I also contributed to the development and testing of incident response plans, enhancing organisational readiness and ensuring that teams were equipped to respond effectively to potential security breaches. My work helped fortify Cardtronics’ security posture, improve risk visibility, and strengthen the integrity of critical operational assets across the network.

A comprehensive program that combines the principles and practices of computer science with advanced training in cyber security. The program is designed to equip leaders in their career fields and understand the societal implications of their work.

A deep dive on how societies allocate scarce resources and make decisions both for individuals and systematic levels adhering to libertarian paternalism principles. A combination of quantitative analysis, statistics, critical thinking and theoretical modelling to explore issues such as markets, incentives, economic growth, in equality and policy design.