profile-pic

Aquib Nawaz Khan

Aquib Nawaz Khan

I turn raw data into clear, actionable insights for a living. With hands-on experience in SQL and Power BI, I enjoy building intuitive dashboards and simplifying complex datasets to help teams make informed decisions. My focus is always on finding smarter, more efficient ways to manage and analyze data, whether it’s optimizing a reporting process or uncovering trends that drive business success.

  • Role

    Power BI Developer

  • Years of Experience

    6 years

Skillsets

  • Data Visualisation - 3 Years
  • Power BI - 3 Years
  • Power BI - 3 Years
  • Data Analysis - 3 Years
  • data analysis
  • data management
  • Data Mining
  • Data Validation
  • dax
  • Microsoft power bi

Professional Summary

6Years
  • Mar, 2018 - Present7 yr 1 month

    Power BI/Database Administrator

    Tata Consultancy Services (TCS)
  • Mar, 2018 - Present7 yr 1 month

    Data Analyst

    Tata Consultancy Services
  • Mar, 2018 - Present7 yr 1 month

    Power BI Developer

    Tata Consultancy Services

Applications & Tools Known

  • icon-tool

    SQL Server Management Studio 2022

  • icon-tool

    SQL Server Integration Services

  • icon-tool

    Microsoft Power BI

  • icon-tool

    PowerApps

  • icon-tool

    Microsoft Excel

  • icon-tool

    Python

Work History

6Years

Power BI/Database Administrator

Tata Consultancy Services (TCS)
Mar, 2018 - Present7 yr 1 month
    Collaborated with business analysts and stakeholders to gather requirements and understand data visualization needs. Developed and implemented Power BI solutions, including interactive dashboards and visualizations to provide actionable insights to business users. Conducted data analysis and modelling to ensure data accuracy, reliability, and performance optimization. Utilized DAX expressions to create calculated columns, measures and KPIs for effective data analysis and reporting. Designed and implemented data transformation process using Power BI query to clean, filter and shape data from various sources. Created data visualization that effectively conveyed complex data patterns, trends and relationships using a variety of PowerBI visualtizations and custom visuals. Worked with the data engineering team to ensure data extraction, transformation and loading processes from various data sources into Power BI. Provided training and support to ensure effective adoption and utilization of Power BI solutions. Actively participated in project meetings, status updates and agile development sprints to ensure timely and successful project delieveries. Conducted performance tuning and support to ensure effective adoption and uitlization of Power BI solutions.

Data Analyst

Tata Consultancy Services
Mar, 2018 - Present7 yr 1 month
    Design, develop, and maintain BI reports and dashboards using Power BI, delivering clear insights. Work closely with business units to gather requirements and translate them into effective technical solutions. Automate data extraction and reporting workflows, significantly improving operational efficiency and freeing up time for more in-depth analysis. Analyze business trends and deliver data-driven recommendations to senior management, supporting strategic initiatives and uncovering opportunities for growth. Utilize SQL to pull and analyze large datasets, identifying patterns and trends that provide valuable insights into business performance. Create interactive Power BI dashboards that make KPIs accessible and visually compelling, helping teams understand key metrics at a glance. Clean and pre-process data from multiple sources to ensure accuracy and reliability in analysis and reporting. Develop advanced DAX queries and optimize data models to improve dashboard performance, creating fast, efficient reporting experiences for end-users. Partner with stakeholders to design custom dashboards tailored to their specific goals, ensuring each report aligns with business priorities and provides actionable insights. Enhance data security and accessibility by implementing row-level security (RLS) and other Power BI features, maintaining compliance and ensuring data integrity. Write complex SQL queries for efficient data extraction, manipulation, and reporting, helping streamline access to critical information. Diagnose and optimize SQL queries, fine-tuning database performance to improve query efficiency and reduce processing times. Develop stored procedures and functions to automate routine tasks and enhance data retrieval processes, making it easier for team members to access the information they needed. Regularly monitor data quality, conduct audits, and resolve any discrepancies to maintain a high level of accuracy across all reports. Communicate findings and insights in clear, digestible formats for both technical and non-technical stakeholders, ensuring everyone can leverage data for decision-making. Proactively identify areas for process improvement within reporting and analysis, implementing solutions that boost productivity and data accessibility across teams.

Power BI Developer

Tata Consultancy Services
Mar, 2018 - Present7 yr 1 month

    Design, develop and maintain Power BI Reports and Dashboards.

    Work with business units to gather requirements.

    Automate data extraction and reporting workflows.

    Analyse business trends and deliver data-driven recommendations to senior management.

    Utilize SQL to pull and analyze large datasets.

    Create interactive Power BI Dashboards that made KPIs accessible and visually compelling.

    Clean and process data to ensure accuracy and reliability in analysis and reporting.

    Develop advanced DAX.

    Monitor data quality.

    Communicating findings and insights in clear formats for both technical and non-technical stakeholders.


Achievements

  • Silver Medalist in State Level Boxing Game

Education

  • Class 12th

    Saifee Hall (2012)
  • Bachelor of Commerce (Hons)

    Prafulla Chandra College (2017)
  • Bachelors of Commerce

    University of Calcutta (2017)

Certifications

  • Certi

  • Certified full stack data analyst