Ravi Daya

Business Intelligence Analyst

Career Aspiration

7+ years of extensive experience working in Business Intelligence Analyst profile in Supply chain Domain, building strong connection with client and team members. Seeking to leverage my Professional experience, business acumen and data analysis expertise to grow in the new role of Data Analytics. Supported by my leadership, mentoring experience and ability to develop cohesive result-oriented deliveries.

Capability Summary

7+ years of rich experience in the Data analysis to drive compliance for Business Operations in varied projects.

Experience in the analysis, design, and development of Business Intelligence solutions using Data Warehouse BI for logistics and supply chain.

Advanced Excel proficiency including Pivot tables, Vlookup/Hlookup, Graphs, VBA Macros Etc.

Proficient in data visualization and presentation by developing dashboards and story with different chart types including Line Chart, Bar Chart, Pie Chart, Scatter Plots.

Design & develop methods to analyze relevant data, share insights & provide recommendations.

Strong analytical and problem-solving skills, multitasking abilities, with proven experience in utilizing resources and knowledge to assist in decision-making.

Technical Skills

Reporting & Visualization tools

Tableau, Power BI, QlikView

Languages

SQL, VBA, Python

Microsoft tools

Excel, Word, PowerPoint, Sway, Share Point

Databases

SQL, One Scan, Invoize, GISS, GIPS, JD-Edward, SAP, MFG Pro, OBIEE, Access

Web Tools

HTML, CSS, JavaScript

Work Experience

Global Supply chain, Centre of Excellence

Eaton corporation, Pune. Oct 2019 – Till date

Role: Business Intelligence Analyst

Preparing data/Visualized reports for global supply chain leadership as per requirement.

Preparing Daily, Weekly, Monthly analytical Dashboard for different plants/Region.

Quarterly/ YTD KPI dashboard for different sites/region.

Data Gathering, Cleansing, Analyzing & Standardizing to solve business problems.

Report standardization for different workstream logistics/Materials for data of one or more plant/ region.

Preparing plant wise/region wise supplier/Customer dashboard for OTD & DPPM and other Metrics.

Handling high 5 dashboard for business sector, which provides detailed overview for all Regions/Plants.

Identifying productivity & improvement areas in day to day activity.

Optimizing stable & repetitive task with best practice sharing.

Automating daily reports/activities with VBA & python technology.

Automation of activities to reduce manual efforts to 95-100 %.

Python RPA Deployments for different regions.

Preparing & deploying Power BI Dashboards to Stakeholders for different entities.

100 % adherence to QMS, with no OTD/Accuracy hit.

Handling multiple transitions/ Customer at a time for different reports/ activities from onshore.

Establish process to improve all transition /reporting documentations.

Conducting trainings on different tools & technologies to get understanding of user experience.

Being SME training user about all activities, roles & responsibility.

Billing, Dispute & Compliance Management

Searce Logistics & Analytics, Pune Jul 2016 – Sep – 2019

Role: Business Data Analyst

Handling team of 10 Members. Mentoring them, Auditing work and to catch errors for improving process accuracy.

To create and execute training plan for new employee in process and cross training within team members.

To schedule and join weekly calls for new changes and to share challenges in process and to provide solution for same.

Tariff Integration: creation of an auto-rating tool, which will help user to rate the shipments accurately at first time without any manual intervention.

Gathered Dispute Invoice Data across various units and automated system logs.

Performed Gap Analysis and Impact Analysis on entire Order to Cash process for identifying gaps/opportunities and possible financial impact on business.

Created a story & dashboard indicating total disputes raised V/s total volume which eventually helped in analyzing dispute trend over time

DERA (Dispute & Exception Reporting and Amendments)- Centralized Billing pending report, dispute report and exception report in terms of ageing, issues, scope and dependencies for management/user visibility.

Streamline different report at one center like- Intercompany Pending, file not billed, file not delivered, disputed invoices, exception raised invoices for quick view.

Conducting weekly calls with the client.

Member of Emergency Response team.

Data Analytics Searce Logistics & Analytics, Pune Jul 2014 – Jul 2016

Role: Senior Data Analyst

Collect and analyze data from various systems using Pivot Table and LOOKUP; prepared weekly tracking and tracing data reports.

Understood end-to-end operational process flow and effort mapping with the help of processed volume data analysis.

Created a dashboard to regularly monitor the timeliness of different accounts for stakeholders to identify late delivery and delay time.

Find out root cause for delays by making analysis of data.

Identified and researched client accounts for discrepancies and acted to recover it to avoid fines.

Validating the documents and raising concern for any discrepancies.

Sharing the On-Time Performance report with supervisors and discussing on the failures.

Handled multiple accounts and shows improvement areas reducing the total FTE’s for the team

Sorting out request with respect to workload, feasibility, time complexity etc.

Data Analyst

Searce Logistics & Analytics, Pune May 2013 – Jul 2014

Role: Data Analyst

Understanding complete process flow in term of work and accuracy.

Worked with international track & trace team handling the top client.

Meeting service level agreement in a proper manner.

Development of Reports & Dashboard in Excel and provide online Support and update for Dashboard.

Merge multiple data sources by joining multiple tables and using data blending.

Engage different teams to work and resolve online errors.

24*7 Dell website performance monitoring and health check.

Data analysis and conducting Online Peer Audit.

Education

Education Projects

Name

Details

Term

ANALYTICAL SERVICES IN OPERATION SUPPORT FOR FREIGHT FORWARDING COMPANY

This project is based upon Data analysis for logistics domain which helped to identify the delays for root cause and improvement in timeliness

Developed during MBA II semester

Jewelry Shop Management

In this project worked Java and SQL, to manage the shop in good and attractive manner to manage easily and to keep records of data for customer, products and billing.

Developed during TYBCS

Building material supply and management system

Project is a documentary with all its concepts and with all flowchart life cycle of material movements

Developed during SYBCS

Strengths

•Quick learner and can adapt well to changes and pressure in workplace.

•Managing relationships & working efficiently with diverse groups of people.

•Hard work and Enthusiasm for learning new things.

•Ability to cope up with different situations.

•Can efficiently handle many data stations at a time, single handedly.

Achievements

Winner in Council events.

Received Point E-Star appreciation for Customer Focus.

Received valuable feedback & appreciations from Management & Stakeholders.

Kaizen award winner 3 times in a year, also in top list for 5 times.

More than 16 Kaizens submitted in a year with productivity of more than 34 hours individually, supported Kaizen for productivity of 26 hours.

Multiple appreciation emails from customer and onshore team.

Given creative contribution in achieving more business by making perfect work and providing improvement ideas.

Recognized areas of improvement to reduce Manual efforts and for better data accuracy worked with development so, to create automation.

Consistently commended by superiors for resolving volatile user’s situations quickly and courteously.

Built a strong team providing with all the necessary information required for them to manage their work in a systematic manner.

Received appreciation and award for the best performance in the team with highest productivity and multi-tasking.

Got appreciation certificate from Searce Logistics & Analytics on successfully completing training on Microsoft Excel 2010 with score 95%

Extra-Curricular

Participated in all council events at Organization & Winner for some of it.

Event planner/organizer for solving Business Problems & forming Team Bonding.

Owner for all team bonding activities and team outing.

Participated in all cultural and sports activities

Awarded as student of year.

College level Volleyball player.

Prize Winner in Singing and Dancing.

Involved in social services through Blood Donation Camps.

2013

2014

2016

2015

Senior Data Analyst

Data Analyst

2019

2018

2017

2020

Business Process Analyst

Business Intelligence Analyst

Contact this candidate