Summary
Overview
Work History
Education
Skills
Summary Of Experience
Accomplishments
Timeline
background-images

ADARSH SRIVASTAVA

Gurugram

Summary

Results-driven Business Intelligence (BI) and Analytics professional with over 11 years of experience in data analysis, visualization, and reporting. Expertise in leveraging SQL, Power BI, OBIEE, MS Excel, and SSIS to enhance data-driven decision-making processes. Demonstrated ability to create and deliver impactful digital analytics reports and dashboards on the Microsoft Power BI platform, along with extensive knowledge of data extraction and query execution within a data warehouse environment.

Overview

12
12
years of professional experience

Work History

Data Analytics Lead

Gartner
02.2023 - Current


  • Collaborate with senior leadership to develop and implement digital product analytics reporting capabilities utilizing Power BI Dashboards and reports, across Gartner's web experience and digital tool and app innovations.
  • Work closely with product leaders throughout the product life cycle to establish product goals, benchmarks, happy paths, and data collection opportunities, while ensuring data quality through best practices and processes.
  • Collaborate with other members of the Data and Analytics team to define data capture, tag parameters, and pipeline data for reporting purposes.
  • Prioritize data attributes or events required for reporting and maintain a roadmap and release schedule for analysis and dashboard views.

Sr. Business Intelligence Analyst

Gartner
08.2018 - 01.2023
  • Lead the design, development, and maintenance of ongoing metrics reports & dashboards in Power BI using various DAX functions, visuals, and slicers to solve the requirements.
  • Creating and maintaining SQL scripts and Power BI Dataflows.
  • Actively involved in the migration process from Oracle SQL to T-SQL.
  • Work on QC of dashboards before delivering them to the stakeholders.
  • Helping with the hiring process by shortlisting and interviewing the right candidates for the team.
  • Providing hands-on training and mentoring the new hires.

Digital Analytics Specialist

Gartner
10.2016 - 08.2018
  • Responsible for managing the web analytics portal in collaboration with the BI team for constant improvement in Gartner's website content.
  • Managed data analysis, data visualization strategy, and tracking conversion rates.
  • Managing their Practice/Program dashboards in Microsoft Excel.
  • Using SAP Business Objects to cater various data needs of the stakeholders.

Sr. Associate

Annalect (An Omnicom Media Group Company)
01.2014 - 10.2016


  • Collaborating with a team of developers in designing, developing, and implementing a BI solution for Sales and campaign Performance as per the KPIs.
  • Develop SSIS Packages using Derived Columns, Condition Split, Merge Join, Execute SQL Task, Data Flow Task, and Execute Package Task, etc. in SQL Server Integration Services 2008. (SSIS).
  • Create database objects such as views and stored procedures in MsSQL.
  • Create Dashboards in Tableau with filters, parameters, and calculated fields.
  • Analysis of campaign data pulled out of the Ad-servers and analytical tools (like, Adobe, Google Analytics, Facebook, YouTube Analytics, Radian6, etc.).

Education

B.Tech. - Engineering - IT

Uttar Pradesh Technical University
05.2013

Skills

  • Power BI expertise

  • SQL expertise

  • Data visualization

  • Python programming

  • ETL development

  • Agile methodology

  • Advanced analytics

  • Data warehousing

Summary Of Experience

  • 11+ years of experience specializing in Business Intelligence (BI) and Analytics.
  • Proficient in utilizing SQL, Power BI, OBIEE, MS-Excel, and SSIS to perform data analysis, visualization, reporting, and ETL processes.
  • Skilled in creating and delivering digital analytics reports and dashboards using the Microsoft Power BI platform.
  • Extensive knowledge and expertise in using SQL to extract data, comprehend data structures, and execute queries within a data warehouse environment.
  • Proficient in developing SSIS Packages using various components such as Derived Columns, Condition Split, Merge Join, Execute SQL Task, Data Flow Task, and Execute Package Task in SQL Server Integration Services 2008 (SSIS).

Accomplishments

    Awarded Rising Star - Employee Excellence Awards (2014), Annalect

Timeline

Data Analytics Lead

Gartner
02.2023 - Current

Sr. Business Intelligence Analyst

Gartner
08.2018 - 01.2023

Digital Analytics Specialist

Gartner
10.2016 - 08.2018

Sr. Associate

Annalect (An Omnicom Media Group Company)
01.2014 - 10.2016

B.Tech. - Engineering - IT

Uttar Pradesh Technical University

Similar Profiles

CREATE PROFILE
ADARSH SRIVASTAVA