Neeraj Jain Data Analytics
No reviews yet

Senior Data Analyst with 6+ years of experience in data analytics and 4+ years
of hands-on expertise in Power BI. Strong in building interactive dashboards,
data modeling, Dax calculations and transforming raw data into actionable
business insights. Experienced in collaborating with Stakeholders and Clients
to understand the requirements, analyze data and deliver actionable insights

• Optimized complex T-Sql Queries, Stored Procedures for data extraction and reporting
• Cleaned and transformed large dataset using Power Query Editor. Used data modelling in Power BI.
• Interactive dynamic dashboards and reports using Power BI for real time business insights by connecting to multiple data sources. Utilized Dax formulas for calculations and KPI’s, used Row-Level Security
• Created Calculated Columns and Measures using DAX Expression.
• Used Bookmarks, Scheduled Refresh and Gateway concept
• Expert in Excel Functions, including VLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, OFFSET, etc Dynamic Pivot Table and conditional formulas to streamline data processing
• Skilled in Macros, automating repetitive tasks to enhance efficiency and accuracy in data handling
• Experienced in Power Pivot, creating complex data models and relationships to support in- depth analysis
• Created data insights and dashboards using Power BI and maintained KPI’s
• Dashboard sharing using Power BI Service by applying Row Level Security for data security
• Train team members on Excel and data analysis tools, fostering a culture of data literacy within the organization.
• Helping client on scaling operations to improve revenue and help them to prepare ahead

Subjects

  • SQL Beginner-Expert

  • Power BI Beginner-Expert

  • Excel (Basic) Beginner-Expert

  • Excel (Advanced) Beginner-Expert

Experience

  • Teaching (Oct, 2025–Present) at Self
    Taking Class for Power BI and Advanced Excel
  • Senior Software Eng (Nov, 2024–Sep, 2025) at NeoSoft Technologies, Mumbai
    Optimized complex T-Sql Queries, Stored Procedures for data extraction
    and reporting
    • Cleaned and transformed large dataset using Power Query Editor. Used
    data modelling in Power BI.
    • Interactive dynamic dashboards and reports using Power BI for real time
    business insights by connecting to multiple data sources. Utilized Dax
    formulas for calculations and KPI’s, used Row-Level Security
    • Created Calculated Columns and Measures using DAX Expression.
    • Used Bookmarks, Scheduled Refresh and Gateway concept
    • Expert in Excel Functions, including VLOOKUP, INDEX-MATCH, SUMIF,
    COUNTIF, OFFSET, etc Dynamic Pivot Table and conditional formulas to
    streamline data processing
    • Skilled in Macros, automating repetitive tasks to enhance efficiency and
    accuracy in data handling
    • Experienced in Power Pivot, creating complex data models and
    relationships to support in- depth analysis
  • Assistant Manager - Data Analytics (Jun, 2024–Nov, 2024) at Jainsons Engineering
    Writing SQL Queries for data extraction and reporting
    • Dynamic dashboards and reports using Power BI for real time business
    insights to visualize key metrics and insights for stakeholders. Utilized Dax
    formuas for calculations and KPI’s
    • Cleaned and transformed dataset using Power Query Editor. Used data
    modelling
    • Analyze trends and patterns in data to identify opportunities for
    improvement and optimization
  • Assistant Manager - Data Analytics (May, 2023–Nov, 2023) at Shubham Housing Finance
     Extraction, Transformation & Loading (ETL)
     Used various sources to pull data into Power BI like Sql Server, Excel and CSV etc.
     Experience in writing complex Dax Functions in Power BI
     Created Calculated Columns and Measures
     Experience in Business Intelligence (Power Pivot, Power View, M-Query (Power Query), Power BI Desktop, Power BI Service
     Created various visuals using basic Line / Column Charts, Tree Map, Funnel Chart, Histogram Chart, Doug nut Chart, Pie Chart, Gauge Chart, Waterfall Chart, Table / Matrix Table, Card, Slicers, Drill Down, Scroller & lot more
     Schedule automatic refresh and scheduling refresh in Power BI Service
     Good experience to work with all the Power BI Functions like, Bookmarks, Creating Buttons, Working Selection Pane
     Having exposure on all the Filters like (Page Level, Report Level, Visual Level and Top N, Basic / Advanced Filters)
     Expert in publishing Power BI Reports of Dashboards and scheduling the dataset to refresh for upcoming data
     Data Consolidation & all Analyst Activities
     Charts, Reports & Dashboards in BI & Excel
  • Assistant Manager - Research & Data Analyst (May, 2022–May, 2023) at Techarc, Gurgaon
     Extraction, Transformation & Loading (ETL)
     Used various sources to pull data into Power BI like Sql Server, Excel and CSV etc.
     Experience in writing complex Dax Functions in Power BI
     Created Calculated Columns and Measures
     Experience in Business Intelligence (Power Pivot, Power View, M-Query (Power Query), Power BI Desktop, Power BI Service
     Created various visuals using basic Line / Column Charts, Tree Map, Funnel Chart, Histogram Chart, Doug nut Chart, Pie Chart, Gauge Chart, Waterfall Chart, Table / Matrix Table, Card, Slicers, Drill Down, Scroller & lot more
     Schedule automatic refresh and scheduling refresh in Power BI Service
     Good experience to work with all the Power BI Functions like, Bookmarks, Creating Buttons, Working Selection Pane
     Having exposure on all the Filters like (Page Level, Report Level, Visual Level and Top N, Basic / Advanced Filters)
     Expert in publishing Power BI Reports of Dashboards and scheduling the dataset to refresh for upcoming data
     Data Cleaning by using Tool like - Advanced Excel & Power Query Editor (ETL Tool)
     Data Modelling Concept
     VBA Macros
     All kind of formulas in various reports
     Automate Reports by writing VBA Code
     Data Consolidation & all Analyst Activities
     Charts, Reports & Dashboards in BI & Excel
     Writing SQL Queries, Sub Queries by applying various functions like Concat, DatePart, Year, Month, Day, Cast, Convert, Format, DateAdd, Eomonth, Replace, Substring, Grouping, Joins and as per need
  • Assistant Manager - Data Analytics (Dec, 2021–May, 2022) at Varuna Group, Gurgaon
     Advanced Excel (VBA Macros) and various kind of formulas
     Automation of Daily Productivity Report
     Automation of Weekly Productivity Report
     Automation of Monthly Productivity Report
     Automation of Consolidated Report
     Extraction, Transformation & Loading (ETL)
     Having exposure on all the Filters like (Page Level, Report Level, Visual Level and Top N, Basic / Advanced Filters)
     Expert in publishing Power BI Reports of Dashboards and scheduling the dataset to refresh for upcoming data
     Data Cleaning by using Tool like - Advanced Excel & Power Query Editor (ETL Tool)
     Writing SQL Queries, Sub Queries by applying various functions like Concat, DatePart, Year, Month, Day, Cast, Convert, Format, DateAdd, Eomonth, Replace, Substring, Grouping, Joins and as per need
  • Senior Executive (Nov, 2018–Dec, 2021) at SE2 Digital LLP, Gurgaon
     Preparation of Interactive Dashboards by Using Advanced Excel
     Experience in Business Intelligence (Power Pivot, Power View, M-Query (Power Query), Power BI Desktop, Power BI Service
     Automation of Daily Productivity Report
     Created various visuals using basic Line / Column Charts, Tree Map, Funnel Chart, Histogram Chart, Doug nut Chart, Pie Chart, Gauge Chart, Waterfall Chart, Table / Matrix Table, Card, Slicers, Drill Down, Scroller & lot more
     Good experience to work with all the Power BI Functions like, Bookmarks, Creating Buttons, Working Selection Pane
     Having exposure on all the Filters like (Page Level, Report Level, Visual Level and Top N, Basic / Advanced Filters)
     Preparation of SLA, TAT and Ageing Report
     Data Cleaning by using Tool like - Advanced Excel & Power Query Editor (ETL Tool)
     Charts, Reports & Dashboards in BI & Excel
     Writing SQL Queries, Sub Queries by applying various functions like Concat, DatePart, Year, Month, Day, Cast, Convert, Format, DateAdd, Eomonth, Replace, Substring, Grouping, Joins and as per need
  • Senior Executive (Dec, 2016–Oct, 2018) at Supernet Infocomm, Gurgaon
     Preparation of Attendance Report
     Preparation of Salary and Incentive Report
     Preparation of MIS reports using Advanced Excel and VBA Macros

Education

  • NIIT (Aug, 1995–Feb, 1997) from NIIT, GURGAON–scored 97%
  • B.A (Mar, 1993–Apr, 1995) from Osmania University, Hyderabad

Fee details

    ₹500/hour (US$5.26/hour)

Reviews

No reviews yet. Be the first one to review this tutor.

© 2016 - 2026 TeacherOn. All rights reserved