Feb 2024 – Aug 2024 · 6 mos · Lahore, Punjab, Pakistan · Hybrid

• Develop, design, and deploy high-quality reports in Power BI to highlight KPIs for the business problem.
• Improving efficiency through complex SQL queries and to manipulate data and create data models and find out discrepancies
• Data wrangling and visualization for cleaning, validating and exploring through Python (NumPy, PySpark, Pandas, Seaborn, Matplotlib)
• Collaborate with cross-functional teams to gather business requirements and translate them into targeted and streamlined consensus-based solutions.
• Develop interactive and visually compelling reports and dashboards using Power BI for a glance and scalable insights.
• Integrate Power BI with various data sources, including databases, APIs, and other data repositories.
• Work closely and collaboratively with cross-functional teams, including business analysts, data engineers.

Feb 2023 – Sep 2023 · 7 mos · Lahore, Punjab, Pakistan · On-site

• Used Power BI, SQL, and Excel to evaluate planning interventions, leading to a 40% improvement in the water table, 6% increase in regional GDP, 20% rise in employment rate, 40% reduction in crime rate, and 10% boost in gender equality.
• Created Power BI dashboards for TOD projects, demonstrating a 20% increase in livability, 20% rise in compactness, 30% increase in walkability, 30% reduction in motorization rate, and 50% rise in passenger numbers due to data-driven planning.
• Analyzed transportation data with SQL and Power BI, covering traffic, modal share, landmark attractions, and POIs, resulting in a 70% increase in commuter satisfaction.
• Applied Excel formulas and pivot tables to analyze past census demographic data, revealing patterns in person per room, population density, houses per acre, household size, mortality rate, and fertility rate, which informed development needs.
• Forecasted demographic trends for the next four decades using Excel, informing phase-wise planning interventions, with indicators visualized in Power BI.
• Conducted multivariate analysis with Excel, ArcGIS, and Python to identify development areas, predicting a 50% increase in regional income. Analyzed variables such as slope, ownership, land type, population, proximity, road network per acre, and trade routes.
• Analyzed travel demand, passenger per train, peak hour, and POI data through SQL, leading to a 30% increase in public transport users and a 10% reduction in carbon emissions.
• Used SQL to analyze economic data, identifying emerging industries and trade routes, forecasting a 60% increase in regional income and reducing negative migration and land degradation.
• Collaborated with design, GIS, environmental experts, and other stakeholders, managing client feedback to ensure satisfaction and enhance the firm's positive outlook.

Feb 2023 – Sep 2023 · 7 mos · Lahore Division, Punjab, Pakistan · On-site

• Empowered two cohorts of over 30 individuals each in domain-specific data analysis (Environment and Real Estate Industry).
• Trained participants in data-driven decision making, focusing on problem-specific metrics and asking the right questions.
• Provided training and hands-on experience in stakeholder management and problem statement analysis to identify data needs.

Jan 2022 – Feb 2023 · 1 yr 1 mo · Bochum, North Rhine-Westphalia, Germany · On-site

• Utilized Excel for comprehensive global biome data analysis, guiding informed decision-making, indicating a leading trend of forest biome monitoring out of all.
• Conducted thorough hydrological data analysis using Excel, guiding strategic flood management interventions and demonstrated unprecedented effectiveness of nature-based solutions of 34 percent as compared to grey solutions.
• Employed Power BI for real-time analysis of nature-based solutions projects, enabling interactive dashboards for stakeholders and facilitating informed decision-making.
• Developed inclusive visualizations in Power BI for diverse audiences, enhancing informed decision-making in biome research projects which were eventually published in the research project.
• Designed privacy-conscious heatmaps in Excel, presenting biome performance indicators while ensuring data privacy and driving impactful actions.
• Leveraged Power BI and Excel for performance analysis in nature-based solutions services, optimizing service provision and informing landscape planning policies for the local authority with a resultant 30 percent increased water catchment rate.
• https://eap.geographie.ruhr-uni-bochum.de/mitarbeiter/quratulain_ayaz.html.en

Nov 2017 – Aug 2019 · 1 yr 9 mos · Lahore, Pakistan

• Analyzed real estate investment opportunities using Power BI and Excel, increasing saleable land by 7%, and communicated findings through compelling data visualizations.
• Conducted geospatial analysis using GIS and visualized data in Power BI to forecast land saleability based on accessibility and proximity to services, presenting insights to stakeholders for informed decision-making.
• Performed cost-benefit analysis of apartment vs. lot development using Excel, resulting in a 15% increase in sales, and narrated the data story to illustrate the impact on revenue.
• Optimized plot numbers for amenities according to Lahore Development Authority guidelines using Excel, securing a 12-year pending approval and achieving a 30% profit increase, using data-driven storytelling to advocate for changes.
• Visualized cost and profit changes for developers and board members using Power BI to enhance design iterations, effectively communicating the financial implications and benefits.
• Utilized landmarks and site analysis for five major development projects, optimizing preferred investment and expediting a 7-year revenue increase through clear and impactful data presentations in Power BI.
• Collaborated with marketing and sales teams, design teams, and Lahore development officials to analyze marketing and sales strategies by examining past sales data and marketing budgets using Excel and Power BI, leveraging data storytelling to drive strategy improvements.

Jan 2017 – Oct 2017 · 9 mos · Lahore, Pakistan

• Performed ETL on environmental monitoring sensor data, authority records, and surveys for a comprehensive carbon emissions analysis. Conducted in-depth analysis in Excel, including traffic flow metrics (traffic count, modal share, travel time, road geometry, road congestion, peak time durations, speed, and traffic, and parking policy trends). Identified a 14% increase in carbon emissions, identifying focus areas to address the rise.
• Re-evaluated bus rapid transit systems, comparing current data with ITC benchmarks. Identified 30% infrastructural improvements, 15% efficiency gains, and 17% increased punctuality, which upgraded the system's ranking from bronze to gold and silver standards, enhancing the firm’s reputation and service quality.
• Analyzed travel demand data using SQL, Python, and ArcGIS to pinpoint high-traffic origin-destination stations and significant network buffers resulting in targeted infrastructure upgrades, leading to 90% passenger satisfaction with just a 20% budget allocation, demonstrating significant ROI.
• Utilized pedestrian data to identify top hindrances and their significance. Recommended targeted upgrades that used only 20% of the budget but resulted in a 50% increase in pedestrian traffic, enhancing urban mobility.
• Applied Python (Pandas, Seaborn, NumPy, Matplotlib) to correlate road network disparity with socioeconomic conditions and income. The analysis highlighted deprived regions, and insights were presented in a Power BI dashboard, guiding strategic investments to address disparities.
• Evaluated transit station accessibility and walkability to develop standards for an optimized network. This analysis ensured enhanced commuter experiences and increased network efficiency.
• Analyzed parking metrics (duration, type, travel mode, user perspective, traffic turnover) to devise optimized parking strategies for the Mayo Hospital project area leading to efficient parking management and improved user satisfaction.

Oct 2016 – Dec 2016 · 2 mos · Lahore, Pakistan

• Carried out data collection and data analysis in the transport sector, as assigned from time to time while designing tools and formats for the collection and analysis of relevant data from the field.
• Making valuable research analysis and Planning which could make our Housing and transportation system more environmentally conducive and more economically sustainable.
• Assisting in the development, scrutiny, and appraisal of project proposals and other related documents.
• Served as transportation staff liaison to all regional transportation organizations and established academia-industry linkages.
• Trained the replacement recruit.
• Served as Research officer for transportation planning and engineering studies and as transportation staff liaison to all regional transportation organizations and establishing academia-industry linkages.
• Achievements: · Formulated Manuals and guidelines namely “Punjab Public Transport Manual” and “Punjab Pedestrian Policy Guidelines” · Devised relevant policies namely “Road Sector Policy” · Did a research project:” “Accessibility of Parks, Open Spaces and Retail around Green Line Lahore” also wrote a paper about it Projects: “Punjab Spatial Strategy” The Punjab Spatial Strategy was to assess the potential of Punjab’s growth corridors and growth nodes.