Summary
Overview
Work History
Education
Skills
Certification
Languages
Key Projects And Accomplishments
Accomplishments
Timeline
Generic
Devaraj K. Shiraguppi

Devaraj K. Shiraguppi

Bangalore

Summary

Data Analyst with expertise in data automation, visualization, and process optimization. Proven track record of streamlining reporting workflows, resulting in over 20 hours saved monthly. Facilitates informed decision-making through clear and actionable analytics.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Analyst – MIS

Gallagher Service Center
Bangalore
01.2023 - Current
  • Automated reporting workflows using VBA, cutting prep time by 25% and saving 1.25 FTEs annually.
  • Designed and deployed Excel dashboards, giving leadership real-time KPI visibility.
  • Performed data queries and generated reports on a daily, weekly, monthly, and quarterly basis.
  • Maintained and optimized VBA programs, increasing efficiency and reducing repetitive manual tasks.

Senior Analyst

Gutsy Innovation
Bangalore
08.2020 - 01.2023
  • Extracted, transformed, and analyzed large datasets from Oracle, improving supply chain efficiency.
  • Developed SQL scripts to accelerate data retrieval and support business decisions.
  • Created Power BI dashboards & Excel scorecards, enhancing performance tracking.
  • Automated recurring reporting tasks, eliminating 20+ hours of manual effort monthly.

Education

B.E. - Mechanical Engineering

Rural Engineering College
Hulkoti
01.2020

Diploma - Mechanical Engineering

Mount Faran Polytechnic
Hubli
01.2017

SSLC (10th) -

Shri Vighneswara High School
Hubli
01.2014

Skills

  • Data analytics and visualization
  • Excel
  • Power BI
  • Databases
  • SQL
  • Oracle
  • VBA automation
  • Process optimization
  • Data cleansing
  • Data transformation
  • Validation
  • Workflow automation
  • Business communication
  • Stakeholder reporting
  • Presentations
  • Cross-functional collaboration
  • Data visualization
  • Data analysis
  • Data extraction
  • ETL processes
  • Problem solving
  • Excel dashboarding

Certification

Lean Six Sigma White Belt, 2024, White Belt Project: Delivered 1.25 FTE savings through automation and process optimization

Languages

  • English
  • Kannada
  • Hindi

Key Projects And Accomplishments

  • Developed automated payout calculation system in VBA, eliminating manual interventions.
  • Designed loop-based macros to generate team-level reports and auto-save outputs by manager.
  • Automated employee data extraction from SQL databases, enabling fully hands-free reporting cycles.

Accomplishments

  • Half early recognition award - PEARL Award 2023
  • Quarterly award – Shining Star Award
  • High-productive employee award
  • Precious gem award

Timeline

Analyst – MIS

Gallagher Service Center
01.2023 - Current

Senior Analyst

Gutsy Innovation
08.2020 - 01.2023

B.E. - Mechanical Engineering

Rural Engineering College

Diploma - Mechanical Engineering

Mount Faran Polytechnic

SSLC (10th) -

Shri Vighneswara High School
Devaraj K. Shiraguppi