Neeraj Jain Data Analytics
No reviews yet

Hi,
I am a dynamic and talented Data Analyst (IT) and has worked with lot of companies.

My Total Experience is 16+ and in Data Analytics is 7 Years having good knowledge in analyzing data, deploying and preparing reports.

Have worked on various tools like:-

Excel (7 Years)
Advanced Excel (7 Years)
Power BI (3 Years)
Sql (3 Years)

Please connect with me

Power BI:
==================
 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

Advanced Excel:
==================
 VBA Macros
 All kind of formulas in various reports
 Automate Reports by writing VBA Code
 Data Consolidation & all Analyst Activities
 Charts, Reports & Dashboards in Excel
 Preparation of Interactive MIS Reports & Dashboards by using Advanced Excel
 Automation of Daily Productivity Report

SQL:
==================
 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
 Understand complete concept of DDL | DML | DCL

Subjects

  • SQL Beginner-Expert

  • Power BI Beginner-Expert

  • Excel (Basic) Beginner-Expert

  • Excel (Advanced) Beginner-Expert

Experience

  • 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.95/hour)

Reviews

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