Summary
Overview
Work History
Education
Skills
Certification
Languages
Work Availability
Work Preference
Timeline
Generic
ISTIAK KHAN

ISTIAK KHAN

Dhubri

Summary

Dynamic Data Analyst with a proven track record at Tezpur University, leveraging advanced SQL and Power BI to deliver impactful insights. Expert in time-series forecasting and data visualization, I excel in storytelling and cross-functional collaboration, driving strategic decisions that enhance operational performance and marketing ROI.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Data Analyst

Freelance
Tezpur
12.2024 - Current
  • Developed interactive Power BI dashboards with advanced DAX measures and KPI tracking to monitor sales trends, operational performance, and marketing ROI in real time.
  • Wrote and optimized complex SQL queries for data extraction, transformation, and aggregation from multiple relational databases to accelerate report generation.
  • Conducted time series forecasting using ARIMA and Prophet models to predict sales and revenue trends, enabling proactive business planning.
  • Implemented ETL workflows using SQL and Python to automate the collection, transformation, and loading of data into Power BI for centralized reporting.

PhD Researcher

Tezpur University
Tezpur
07.2024 - Current
  • Queried and retrieved large-scale datasets from public astrophysical archives (e.g., SDSS, Gaia) using SQL queries and Virtual Observatory tools.
  • Performed data cleaning and preprocessing on astronomical datasets, including handling missing values, noise reduction, and cross-matching multi-wavelength data from different sky surveys.
  • Implemented machine learning models (Random Forest, Gradient Boosting) for object classification, evaluating performance with precision, recall, and F1-score metrics.
  • Applied advanced statistical techniques for error propagation, uncertainty estimation, and correlation analysis in astrophysical measurements.

Education

Integrated M.Sc. - Physics

Tezpur University
Tezpur, Assam
08-2022

Higher Secondary -

Anundoram Borooah Academy
Pathsala, Assam
08-2017

Skills

  • Excel/Google Sheets
  • Statistical Analysis (A/B Testing, Hypothesis Testing)
  • Power BI
  • SQL / Advanced SQL
  • Python (Pandas, Matplotlib, Seaborn)
  • Data Modeling
  • Data visualization
  • Time-Series Forecasting
  • Dashboarding & Reporting
  • ETL (Basic)
  • Analytical Skills
  • Operational Analytics
  • Storytelling & Stakeholder Communication
  • Problem solving
  • Cross-functional collaboration

Certification

  • Data Analysis using SQL | Analytics Vidhya
  • Insights of Power BI | Analytics Vidhya
  • Microsoft Excel | Analytics Vidhya
  • Applied Machine Learning | Analytics Vidhya
  • Fundamentals of AWS | Analytics Vidhya

Languages

Hindi
First Language
English
Advanced (C1)
C1

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full TimePart Time

Work Location

RemoteOn-SiteHybrid

Important To Me

Work-life balanceCareer advancementWork from home optionFlexible work hoursHealthcare benefits

Timeline

Data Analyst

Freelance
12.2024 - Current

PhD Researcher

Tezpur University
07.2024 - Current

Integrated M.Sc. - Physics

Tezpur University

Higher Secondary -

Anundoram Borooah Academy

Similar Profiles

CREATE PROFILE
ISTIAK KHAN