Summary
Overview
Work History
Education
Skills
Additionalinformation
Travelling
Timeline
Generic

TARUN KUMAR NAPIT

New Delhi

Summary

Enthusiast, self-learner, and process-oriented Team Lead with a keen interest in the latest technological development such as Analytics, Visualization, and Data Science, with a high affinity towards Data & Business Analytics, seeking a responsible full-time career opportunity in a reputable organization where I can work with experienced professionals and reach full potential.

  • Overall 9+ years of Work Experience.
  • Having 3+ years of experience as Data Analyst with the SQL, Power BI and Advance Excel.
  • Hands on Experience on creating various Views and Dashboards in Power BI.
  • Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show functionality.
  • Data Mining, Data Visualization, Data Warehousing, Data Modelling.
  • Wrote custom SQL queries to optimize extracts, and heavily relied on data blending as end workbooks ultimately required multiple fields from different data sources.
  • Deep experience with design and development of Tableau visualization solutions.
  • Strong Skill in Programming Languages, such as SQL Language.
  • Report Analysis, Tableau tool, Database design & Management. Experience in Advance Excel with Pivot Table, V lookup, Index.
  • Experience on IBM SPSS for Data cleaning, Modification and labeling part.
  • Experience on Spider for Data Analysis.

Overview

11
11
years of professional experience

Work History

Team Lead

B3intelligence
01.2023 - 05.2024
  • Established open and professional relationships with team members to achieve quick resolutions for various issues
  • Created required Data Models to accomplish various Report requirements for the client and created Dashboards after publishing into power BI Service
  • Good Command on using DAX (Data Analytic Expression) & M Code Language
  • Worked with most of the features available in Power BI Desktop in creating Reports and updated knowledge with all features
  • Worked with data models with complex relationships in Power BI and connected different data sources to Power BI Desktop
  • Prepared detailed reports on updates to project specifications, progress, identified conflicts and team activities
  • Developed monthly and daily production output plans to deliver on customer service and financial metrics
  • Reviewed project specifications and drawings prior to assembling complex components to better understand assignments and expected deadlines
  • Manage a team of 10 employees providing guidance and support to ensure successful completion of projects
  • Data Analysis by using IBM SPSS and Spider
  • Create table and query using SQL and create dashboard by using tools
  • Sort large set of Data by using advance excel and prepare the report as per client requirement
  • Monitored team performance and provided constructive feedback to increase productivity and maintain quality standards.
  • Influenced positive change within the organization through strategic thinking, innovation, problem-solving abilities, and consistent leadership style.
  • Worked on different projects i.e. NCT, Global Scam etc with Qualtrics.

Data Analyst

0101.Today
04.2022 - 08.2022
  • Established analytics goals and used some advance goggle analytics features to extract customer information and also reviewed social media to determine, identify, and translate customer behavior; performed in-depth research and analysis on all available information Prepared and created analytics reports on customer insights such as user geographic location, age groups, and gender using Microsoft excel Made suggestions on which products to use as add-ons with others, based on customer data regarding which products customers would often buy together Utilize Google analytics to track visitor flow and interaction throughout the company website Provide analysis and insight regarding various online tools such as the site search, mobile site and selection guides.

Commercial Analyst

Travelwings
03.2021 - 03.2022

Retrieve data from multiple sources and develop complex pricing models that reflect margins for promotional and seasonal pricing based on competitor, market, and customer data Perform monitoring, optimization and refinement of ETL Solutions Use variety of statistical modeling methods to prepare reports that show potential impact of various pricing strategies, including their effect on margins and costs and how twill impact profitability and sales volume Analyze data related to return on investment (ROI) for existing marketing and promotional programs, analyze customer response to marketing efforts, and determine more effective ways to reach customers and gain market share Creating Dashboards, reports as needed using Tableau Desktop and Tableau Server Preparing Dashboards using calculations, parameters in Tableau Creating database objects like tables, views, procedures, triggers, Functions using T-SQL to provide definition, structure and to maintain data efficiently

  • Used Tableau Desktop extensively to build Heat Map ,Tree Map, Bar Charts, Dashboards
  • Expertise in Joins, Data Blending and Dual Axis in Tableau.

Sr Executive

Make My Trip
03.2020 - 06.2020
  • Aligned organizational objectives with company mission, increasing revenue, profit and business growth by collaboratively developing integrated strategies Fostered new business through participation in trade shows and initiating communications with prospective clients via phone and email Streamlined operations to maximize business efficiency and profits Work as part of team Business Analysis
  • Responsible of making Reports according to Time Basis
  • Analysis of Reports on daily /weekly basis by using Microsoft Excel
  • Analysis of data after filtering from row data
  • Create Graph and Dashboard with the help of pivot Table , Vlookup and other function in Excel
  • Conducted research on emerging trends within industry and capitalized on finds to develop new products, services and strategies.

Sr Travel Consultant

Yatra Online Pvt Ltd
10.2017 - 11.2018
  • Provided customers with best deals and well-researched travel options, successfully negotiating rates while improving customer satisfaction ratings Maintained operational proficiency in coordinating both international and domestic travel accommodations for customers, arranging for airfare as well as hotel and rental car reservations Handled sensitive personal data with discretion, including credit cards, date of birth and home addresses Work as part of team selling Flight Tickets Responsible of making reservations according to availability Domestic Flight Sales by Outbound calls Flight booking by using Galileo and Amadeus.

Travel Consultant

Elite Trip
08.2013 - 07.2017
  • Worked closely with clients to understand unique needs and meet specific travel desires Organized trips for individual, family and business travelers Informed clients of travel policies and utilized preferred vendors to maximize company profits Provided customers with best deals and well-researched travel options, successfully negotiating rates while improving customer satisfaction ratings Kept abreast of all airline rules, regulatory requirements and industry standards when scheduling travel arrangements Arranged travel accommodations for groups, couples, executives and special needs clients Responsible for providing detailed travel information to customers and deal with customer queries in relation to holiday packages Coordinates with tour operators and travel agencies regarding tour package choices, bargains with them to get most affordable rate

Network Support Engineer

Trimax IT Infrastructure & Services Ltd
12.2012 - 07.2013
  • Diagnosed network problems involving combination of hardware, software, power and communications issues Designed and implemented cloud network infrastructures, including intra- and inter-data center connections Supported users in setup and configuration of wireless bridge networks Diagnosed and executed resolution for all network and server issues Designed and evaluated WAN and LAN connectivity technologies Installation and Configuration of Routers and Switches Maintaining of LAN guard server and applying patches.

Education

10th -

GDAVM

B.Tech - Electronics & Communication Engineering

Yagyavalkya Institute of Technology
06.2010

12th - PCM

Govt Sr Sec School
06.2004

Skills

  • Tableau Desktop
  • Power BI Desktop
  • IBM SPSS
  • Microsoft Excel
  • SQL Server

Additionalinformation

H2347501, Travelling

Travelling

I am very Passionate about travelling. Travelling always inspired me to learn new skills & technologies.

Timeline

Team Lead

B3intelligence
01.2023 - 05.2024

Data Analyst

0101.Today
04.2022 - 08.2022

Commercial Analyst

Travelwings
03.2021 - 03.2022

Sr Executive

Make My Trip
03.2020 - 06.2020

Sr Travel Consultant

Yatra Online Pvt Ltd
10.2017 - 11.2018

Travel Consultant

Elite Trip
08.2013 - 07.2017

Network Support Engineer

Trimax IT Infrastructure & Services Ltd
12.2012 - 07.2013

10th -

GDAVM

B.Tech - Electronics & Communication Engineering

Yagyavalkya Institute of Technology

12th - PCM

Govt Sr Sec School
TARUN KUMAR NAPIT