Summary
Overview
Work History
Education
Skills
Certification
Recognition
References
Additional Information
Timeline
Generic
Shashank S

Shashank S

Data Reporting Analyst
Bengaluru

Summary

Hands on experience of Oracle, MS SQL Server Advanced MS Excel and Power BI tool for reporting. Utilize SQL for data extraction, transformation, and loading (ETL) processes, utilizing Query Editor to clean and shape data for optimal performance and accuracy. Have expertise in data transformation and data Visualization using MS Excel, ETL tool Power BI Adept at using DAX for data modelling and building dashboard in Power BI using different visualization chart . Translating numbers and facts to inform strategic business decisions Proficient in analyzing data by finding the pattern and behavior of data over a time (by observing historical trend). Study, analyze and understand business requirements in context to KPI/Dashboard. Stay up-to-date with the latest industry trends and best practices in Power BI development, including performance optimization, data modeling, and visualization techniques.

Overview

12
12
years of professional experience
4
4
years of post-secondary education
3
3
Certifications

Work History

Data Reporting Analyst

Diageo
11.2023 - Current
  • Optimized data visualization techniques to simplify complex information for non-technical stakeholders.
  • Contributed to continuous improvement initiatives by proactively identifying areas for potential enhancements in data reporting and analysis processes.
  • Evaluated new tools and technologies to stay current with industry best practices in data analysis and reporting.
  • Ensured compliance with industry regulations and company policies regarding data privacy and security.
  • Leveraged advanced statistical methods to draw actionable insights from raw data sets.
  • Enhanced data accuracy by implementing rigorous validation and cleaning processes.

Data Analyst

Oracle
07.2021 - 05.2023
  • Global Countries Sales Account Data Validation Tasks
  • Extracting preferred data by leveraging SQL scripts on
    Oracle database .
  • Eliminate redundant data using Joins, Sub-Query, Unions, Regular-Expression and SQL functions etc.
  • Scrape data from various sources over internet, determine the mapping of data, Data validation.
  • Achieving Weekly target by providing at-most matches.
    Responsible for quality check on processed data using SQL Scripts.
  • Continuously endeavouring on ways to Strategise weekly target.
  • Maintaining dashboard for worked accounts data using Power BI tool
  • Improved decision-making processes with accurate data analysis and visualization techniques.

Project Associate

Indian Institute of Science
01.2016 - 07.2021
  • Maintain the Database of Helium users using Oracle SQL
  • Taking actions to prevent or rectify abnormal plant and production situations.
  • Maintain the Database of Helium users using Oracle SQL.
    Fixing the database on daily/weekly/Monthly basis on Helium supplied and Transfer of Helium Gas.
  • Data Visualization – Dashboard creation by using pivot, slicer and suitable graphs to showcase data trend.
  • Data Analysing – Highlighting facts and figures, key areas that contribute to decision making.
  • Supported project managers in the execution of large-scale projects, effectively coordinating tasks among cross-functional teams.

Test Engineer

RELTEC Engineers
08.2012 - 12.2015
  • Annual Testing Calibration of all Testing Calibration Magnetic, Protective Relays 'Energy Meters, Ammeters, Voltmeters Frequency, Current Transformers, Potential Transformers
  • Testing & Servicing of all Types of Circuit Breaker. Responsible for all planning and execution works at site.
  • Preparations and Checking of Bill of Quantity & Drawings Well experience in Auto cad and Sld diagrams of layouts.

Education

Bachelor of Engineering(EEE) - Electrical Engineering

Visveswariah Technological University
Bangalore
05.2008 - 05.2012

Skills

Oracle SQL

undefined

Certification

Tableau 2022 A-Z: Hands-On Tableau Training For Data Science, 02/2023 - Present, Udemy

Recognition

  • Outstanding Performer, Oracle -Business Analytics, 01/2023
  • Outstanding Performer, Oracle -Business Analytics, 08/2022

References

  • Thomson Varghese, Director Business Analystics, Thomson.varghese@oracle.com, 9880210379
  • Mahesh Maney, Senior Technical Architect, Mahesh.maney@tarento.com, 7019242044

Additional Information

Projects Handled


Employee Attendance Dashboard

HR Attrition Dashboard

Learning Analysis Dashboard

Sales and inventory Analysis of a Marketing Client (ORACLE)
CXD-DF Data Analysis for various Domain Marketing
Product Sales Data Analysis: Analyse sales data to identify trends and patterns.
Data Mining and Analysing: Accumulated sale and Inventory report data, cleaning and exploring data.
Dashboards: Established visually impactful dashboards in Excel and Power Bi for data reporting by using DAX,Pivot table, VLOOKUP and aggregate functions.
Generation and analyzing MTD reports on daily basis with the support of revenue tracker report and mailing it to Various clients
Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful and decision-making information.

Timeline

Data Reporting Analyst

Diageo
11.2023 - Current

Data Analyst

Oracle
07.2021 - 05.2023

Project Associate

Indian Institute of Science
01.2016 - 07.2021

Test Engineer

RELTEC Engineers
08.2012 - 12.2015

Bachelor of Engineering(EEE) - Electrical Engineering

Visveswariah Technological University
05.2008 - 05.2012

Similar Profiles

CREATE PROFILE
Shashank SData Reporting Analyst