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
Hulkoti01.2020
Diploma - Mechanical Engineering
Mount Faran Polytechnic
Hubli01.2017
SSLC (10th) -
Shri Vighneswara High School
Hubli01.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