Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Affiliations
Timeline
Generic

Shubham Yadav

Agra

Summary

Seasoned Business Intelligence Analyst with background in converting complex data into actionable insights to drive decision-making processes. Skilled in analyzing trends, crafting detailed reports, and enhancing business operations through technology solutions. Demonstrated ability to work collaboratively across teams to implement improvements, leading to increased efficiency and productivity.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Analyst

NTT Data Services
Noida
02.2022 - Current
  • Company Overview: Conducted in-depth data analysis using SQL and Power BI to extract actionable insights for business decision making at Bank of Ireland
  • Conducted in-depth data analysis using SQL and Power BI to extract actionable insights for business decision making at Bank of Ireland
  • Developed SQL queries and used stored procedures to optimize data retrieval as per the requirement of the business counterpart and reporting efficiency
  • Extracted, transformed, loaded (ETL) and analyzed large sets of data from Bank of Ireland’s corporate banking website Business Online database for insights and trends
  • Engaged with business stakeholders to gather and understand reporting requirements, translating them into efficient power BI solutions and optimized database queries
  • Automated analytics and reporting, including dashboards, KPIs, and productivity metrics using Power BI, improving operational efficiency
  • Conducted in-depth data analysis using SQL and Power BI to extract actionable insights for business decision making at Bank of Ireland

Services IT Dev. Program Sr. Assoc. Ll

NTT Data services
Noida
11.2020 - 02.2022
  • Made cosmetic as well as small functionality changes using jsp and js to the Business Online corporate banking website to enhance UI/UX.

    Managed the corporate banking application, ensuring smooth operation and user accessibility. Collaborated with stakeholders to implement changes and resolve issues.

    Assisted in maintaining and improving website performance. Ensured compliance with banking and security standards while making modifications.

Education

Bachelor of Technology (BTech) -

Dr. A. P. J. Abdul Kalam Technical University
Agra, Uttar Pradesh
07.2020

Skills

  • SQL
  • ETL
  • Power BI
  • Python
  • NumPy
  • Pandas
  • NLP
  • AWS
  • Git
  • Excel
  • Scikit-Learn

Certification

  • PL-300 Microsoft Certified Power BI
  • AWS Solution Architect Associate (AWS)-Percipio
  • ITIL-4 Foundation Introduction
  • ITIL-4 Foundation Key Concepts of Service Management
  • SQL (5 Star) -Hacker Rank
  • SQL concepts-Percipio

Projects

  • Optimizing Pharmaceutical Supply Chain, Build a data pipeline that integrates data from multiple sources, performed transformations using Python (NumPy, pandas) and load to destination., Implemented real-time data ingestion pipelines by leveraging PostgreSQL’s LISTEN/NOTIFY system, which triggers alerts when specific events occur (e.g., stockouts, delayed shipments)., Performed Analytics and Reporting using Power BI. Automated daily report generation and email dashboards or reports to stakeholders.
  • Exploratory Data Analysis-IMDB movies dataset, Conducted EDA using Python (Pandas, NumPy, Matplotlib, Seaborn) to analyze movie trends., Cleaned and transformed data, uncovering key insights to optimize movies revenue.

Affiliations

  • Winner of college football competition 2 years in a row
  • members of fun and sports group.

Timeline

Data Analyst

NTT Data Services
02.2022 - Current

Services IT Dev. Program Sr. Assoc. Ll

NTT Data services
11.2020 - 02.2022

Bachelor of Technology (BTech) -

Dr. A. P. J. Abdul Kalam Technical University
Shubham Yadav