Summary
Overview
Work History
Education
Skills
Websites
Research
Professional Skills
Personal Information
Timeline
Generic
Vikas K Yadav

Vikas K Yadav

Gurgaon

Summary

Experienced Senior Consultant with over 9 years of expertise in Operations Management, Project Management, Reporting, Data Analysis, and Dashboard Creation. Proficient in Power BI, ADF, SQL and Python with a customer-centric and results-driven approach. Strongly involved in manipulation of Relational Database tables, Requirement Analysis, Data Analysis, Pipeline creation, worked on large datasets using multiple tools and technologies using Agile Methodologies with multiple domains like, Operation management, PR & Media, GPS, Digital Marketing.

Overview

10
10
years of professional experience

Work History

Senior Consultant

E&Y
Gurgaon
07.2022 - Current
  • Conduct in-depth analysis of data to identify trends, patterns, and insights.
  • Interpret complex data sets to provide actionable insights and recommendations to clients.
  • Develop and maintain data models, databases, and data pipelines.
  • Ensure data integrity and accuracy through rigorous data validation and cleansing processes.
  • Design and create interactive dashboards, reports, and visualizations using tools like Power BI, Tableau.
  • Present data findings and insights in a clear and compelling manner to stakeholders.
  • Work closely with clients to understand their business needs and challenges.
  • Develop data-driven strategies and solutions to address client-specific issues and objectives.
  • Lead and manage data analytics projects from inception to completion.
  • Ensure projects are delivered on time, within scope, and within budget.
  • Utilize advanced statistical, analytical, and machine learning techniques to solve complex problems.
  • Implement and optimize data analytics solutions using programming languages like Python, SQL, and relevant data analytics platforms.
  • Collaborate with cross-functional teams, including IT, marketing, finance, and operations, to ensure alignment and successful implementation of data analytics initiatives.
  • Communicate findings and recommendations effectively to both technical and non-technical audiences.
  • Mentor and guide junior analysts and team members.
  • Analytics Tools: SQL, Python, ADF, Snowflake, Tableau, Google Sheets, Power BI, Power Apps, Power Query, DAX Functions, ETL(SSIS), QGIS, Linux, Microsoft Office (Word, PowerPoint, Advance Excel), Power Automate, SharePoint, OLAP/OLTP Cubes, MS SQL Server, MYSQL, Data Lake, Azure Synapse, DAX, Outlook, GitHub, API's, Data Modelling, Data Profiling, Data Visualization, Generative AI, LLM Models
  • Project Management and CRM tools: SalesForce, Jira, Zoho, Lever, linkedin.com/in/vikas-Yadav-01363391

Senior Executive

Wipro
Gurgaon
07.2018 - 06.2022
  • Assists in the research of business goals, objectives and needs to align information technology solutions with business initiatives for multiple, less complex accounts.
  • Serves as the liaison between technical personnel and business area for multiple accounts in UK PR and Media.
  • Define quality attributes, external interfaces, constraints, and other nonfunctional requirements.
  • Reporting and analysis of survey results.
  • Experience in Reporting using V/H Lookup, Index, Match, Filtering and Advanced filtering and Sorting. Worked with Pivot tables, Dashboards, Slicers, Conditional Formatting.
  • Creating interactive visuals and dashboards using excel and Power BI.

Associate Analyst

Skymap Technologies (Subsidiary of GroundTruth)
Gurgaon
08.2015 - 06.2018
  • Provide support and maintenance to existing MIS.
  • Generate and distribute MIS/Dashboard, periodic and ad-hoc reports in an accurate and timely manner.
  • Data Quality Assessment, Data Analysis using Python (pandas, NumPy).
  • Statistical Modelling Concepts, data Insights and Visualization using Power BI.
  • Increased 15% Ads delivery on mobile devices for a specific location.
  • Improved CPV (Cost-Per-Visit) campaign for Location Marketing.
  • Data Scrapping from brand sites using UiPath (Robotic Process Automation Tool).
  • Email Automation using UiPath (Robotic Process Automation Tool).
  • Implemented ETL (Extract, Transform and Load) projection SQL Server using SQL Server Integration Services (SSIS).

Education

MCA - Computer Application

Pratap University (MPGI Group)
01.2014

BCA - Computer Application

Rajasthan University
01.2010

Higher Secondary - Science

RBSE
01.2007

Senior Secondary - undefined

RBSE
01.2005

Skills

  • Financial Analysis
  • Data Analytics
  • Negotiation
  • Market Research
  • SQL
  • Python
  • ADF
  • Snowflake
  • Tableau
  • Google Sheets
  • Power BI
  • Power Apps
  • Power Query
  • DAX Functions
  • ETL(SSIS)
  • QGIS
  • Linux
  • Microsoft Office
  • Power Automate
  • SharePoint
  • OLAP/OLTP Cubes
  • MS SQL Server
  • MYSQL
  • Data Lake
  • Azure Synapse
  • DAX
  • Outlook
  • GitHub
  • API's
  • Data Modelling
  • Data Profiling
  • Data Visualization
  • Generative AI
  • LLM Models
  • SalesForce
  • Jira
  • Zoho

Research

AI and IoT enabled Automation in Supply Chain and Procurement, Conduct training sessions and workshops to build data literacy and analytical skills within the organization., Ensure data analytics practices adhere to regulatory requirements and industry standards., Implement data governance policies and procedures to maintain data security and privacy.

Professional Skills

Proficient in financial analysis, budgeting, and forecasting., Skilled in data collection, analysis, and interpretation to inform business decisions., Strong negotiation skills in dealing with clients, business partners and internal stakeholders., Proficient in conducting market research with other teams and identifying market trends.

Personal Information

Title: Senior Consultant - BI & Data Engineering

Timeline

Senior Consultant

E&Y
07.2022 - Current

Senior Executive

Wipro
07.2018 - 06.2022

Associate Analyst

Skymap Technologies (Subsidiary of GroundTruth)
08.2015 - 06.2018

MCA - Computer Application

Pratap University (MPGI Group)

BCA - Computer Application

Rajasthan University

Higher Secondary - Science

RBSE

Senior Secondary - undefined

RBSE

Similar Profiles

CREATE PROFILE
Vikas K Yadav