Tehsin

Data Analyst | Dashboarding And Reporting

Bangalore, India

Profile summary

Data Analyst with 6 years of experience specializing in SQL, Python, Power BI, and global real estate analytics. Proven record of delivering end-to-end reporting, building sales forecasting models that improved accuracy by 25 percent, and identifying supply chain cost reductions of 15 percent.

Career highlights

Global Real Estate Analysis: Delivered end-to-end analysis from data extraction to dashboard build for human resources and commercial real estate datasets spanning 25 global sites.

Sales Forecasting Models: Developed regression-based sales forecasting models that improved forecast accuracy by 25% and enabled more effective business planning.

Supply Chain Cost Reduction: Performed vendor and supply chain analysis, identifying cost optimization opportunities that reduced operational expenses by 15%.

Professional Certifications: Completed specialized training in Python for Data Science and statistics and machine learning for data science.

Key skills

TechnicalSQL (Joins, CTEs, Window Functions) Python (Pandas, NumPy)
ProfessionalData Analysis Exploratory Data Analysis (EDA) KPI Analysis Dashboarding & Reporting Data Visualization Power BI (DAX, Data Modelling) Advanced Excel (Pivot Tables, Power Query, XLOOKUP) Tableau Data Warehousing Data Lake / Medallion Architecture Data Cleaning & Transformation ETL Fundamentals Data Modelling KPI Definition Commercial Real Estate Analysis Cost & Revenue Analysis Stakeholder Reporting & Storytelling Process Improvement

Professional experience

Data AnalystJun 2026 - Present
Google (via JLL)Bengaluru, India

Directs analytics initiatives for human resources and commercial real estate operations across global sites, overseeing data extraction, dashboard development, and quality standard maintenance for enterprise clients. Coordinates closely with cross-functional stakeholders to align reporting frameworks with organizational goals.

  • Executes end-to-end data analysis workflows covering extraction, cleaning, and ongoing monitoring for datasets spanning 25 global sites.
  • Performs statistical evaluations and SQL queries to detect operational trends, patterns, and anomalies across facility management environments.
  • Builds and maintains Looker dashboards and reports to communicate workplace real estate metrics to clients and internal teams.
  • Collaborates directly with clients to identify data requirements and provide analysis supporting workspace planning strategies.
Product Analyst - Development leadFeb 2020 - Nov 2023
Glaukoustech Solutions Pvt LtdBengaluru, India

Directed development operations for intralogistics products, overseeing cross-functional teams of engineers across mechanical, electrical, electronics, and software disciplines. Managed supplier relationships with industrial automation providers and administered budgetary allocations through competitor benchmarking.

  • Executed end-to-end development of an automated pallet shuttle system, retaining ownership of electronics, electrical design, vendor selection, and delivery under strict NDAs.
  • Established partnerships with Siemens, Phoenix Contact, Schneider Electric, and SICK, introducing technologies that reduced product cost by 15% and increased operational efficiency by 20% through rigorous testing and optimization.
  • Managed development budgets through competitor benchmarking while keeping costs within 10% of target across multiple intralogistics product lines.
Business AnalystAug 2017 - Jan 2020
Storage Technologies Automation Pvt LtdBengaluru, India

Guided analytical operations focusing on market research and sales evaluation, supporting internal stakeholders with strategic planning, vendor assessment, and business development initiatives.

  • Performed vendor and supply chain analysis, identifying cost optimization opportunities that reduced operational expenses by 15%.
  • Developed regression-based sales forecasting models, improving forecast accuracy by 25% and enabling more effective business planning.
  • Conducted market and sales analysis, identifying trends that supported business growth initiatives.

Projects

SQL Data Warehousing & Analysis Project

Designed a multi-source data warehouse using medallion (bronze/silver/gold) architecture with fact and dimension tables for structured, analysis-ready data organisation. Authored complex SQL scripts utilizing CTEs and Window Functions to generate automated metric reports.

Power BI & Advanced Excel Analytics Project

Constructed dynamic dashboards that streamlined data preparation via Power Query, replacing manual data compilation tasks. Utilized Advanced Excel features, including Pivot Tables, XLOOKUP, and formulas, to validate data accuracy and improve report precision.

Education

Bachelor of TechnologyJun 2012 - Aug 2017
BMS College of Engineering, Bangalore

GPA: 7.45

Certifications

Python for Data ScienceLearnbay
Statistics and machine learning for data scienceLearnbay