Looking for a job

Tejkanwar Singh Sohal

@tejkanwarsinghsohal

Lead Data Analyst at Capco, supporting HSBC transaction analytics with KPI definitions, data-quality rules, and analytical guidance.

India

Message

At Capco, I provide transaction-data subject-matter guidance for the HSBC engagement, aligning business definitions, data flows, controls, and reporting requirements.

I translate stakeholder needs into analytical specifications, KPI definitions, and data-quality rules, and review outputs and models for consistency with business use cases.

At ClearTrail Technologies Pvt Ltd, I designed PySpark data models and built DORA metrics and operational dashboards using data from Jira, SonarQube, Jenkins, GitHub, and Zephyr.

At Unacademy / PrepLadder, I defined and analyzed product and business KPIs, maintained Tableau dashboards, and supported data science initiatives. Across my data analyst roles, I’ve worked on Python and SQL analysis, data quality, reporting, and decision support.

Experience

Work history, roles, and key accomplishments

Current

Lead Data Analyst & Transaction SME

Current

Capco Private Limited

Feb 2024 - Present (2 years 8 months)

Lead analysis of transaction data for HSBC engagement, providing subject-matter guidance on business definitions, data flows, controls, and reporting requirements. Translate stakeholder needs into analytical specifications, KPI definitions, and data-quality rules.

Transaction analysis KPI Frameworks Data Modeling Data Quality Stakeholder Management SQL Python PySpark Tableau Power BI AWS RedShift GCP Machine Learning NLP

Senior Data Analyst

ClearTrail Technologies Pvt Ltd

May 2023 - Feb 2024 (9 months)

Designed and implemented PySpark data models for large-scale data processing and built DORA metrics and operational dashboards using data from Jira, SonarQube, Jenkins, GitHub, and Zephyr. Produced comparative, growth, and sales dashboards and performed root-cause analysis.

PySpark Data Modeling DORA Metrics Dashboarding Jira SonarQube Jenkins GitHub Zephyr Root Cause Analysis SQL Python

Senior Data Analyst

Unacademy / PrepLadder

Sep 2021 - May 2023 (1 year 8 months)

Defined, monitored, and analyzed product and business KPIs, designed and maintained Tableau dashboards, and performed semantic and text analysis to identify themes and insights. Supported data science initiatives through data preparation, feature engineering, and model evaluation.

KPI Analysis Tableau Dashboarding Semantic Analysis Text Analytics NLP Data Preparation Feature Engineering Model Evaluation SQL Python

Data Analyst

Niveshan Technologies Pvt Ltd

Jan 2021 - Oct 2021 (9 months)

Built dashboards, charts, and visualizations for business reporting, evaluated data validation tools, and produced KPI reports. Designed Tableau-based BI solutions and monitored data flows for data quality.

Tableau Dashboarding Data Validation Data Quality KPI Reporting SQL Python

Data Analyst

Guru'z Infotech

Jun 2016 - Jan 2021 (4 years 7 months)

Began career in data analytics, building foundations in Python, SQL, data preparation, and reporting. Collected, cleaned, and transformed datasets, wrote SQL queries and Python scripts, and produced KPI reports and dashboards.

Python SQL Data Preparation Data Cleaning KPI Reports Dashboarding Root Cause Analysis