Nov 2022 – May 2023 · 6 mos · Hydrabad · Remote

• Extracted data from WOK & UTask on Google Sheets and designed interactive, performance & real-time dashboards on Google Sheets & Google Data Studio weekly.
• Ran query successfully on PrestoSQL.

May 2022 – Aug 2022 · 3 mos · India · Remote

• Power BI Desktop, Filtering Visuals in Power BI, Advanced Visuals, Power BI Service, Functions in Power Query, Append & Merge Queries, Shaping Data & M - Functions, Power BI Dashboards, Interactive Dashboards Management, Solved Case Study on Bank Loan

Mar 2022 – Apr 2022 · 1 mo · India · Remote

• MIS Reporting, Excel Dashboards, Power BI, Dashboards Management, Problem Solving Statistics, Mathematics, Tableau Dashboards, Data Cleaning Techniques, Data Preparation, Predictive Analysis

Nov 2021 – Dec 2021 · 1 mo · India · Remote

• Basic Excel, Excel Formulas, Working with Data, Advanced Concepts, MIS Reporting & Dashboarding, Data Validation, Conditional Formatting, Pivot Table, Excel Dashboards

Dec 2020 – Nov 2022 · 1 yr 11 mos · Pune, Maharashtra, India · Remote

• Managed data analysis reports and distributed them to management staff.
• Managed & handled 100+ datasets effectively via ETL, Power Query, Power View, Power Pivot & Power BI service.
• Reported data after getting insights by using MS Excel & Power BI tools.
• Data blending & managed 50+ datasets effectively & interactive dashboard management on Google Data Studio.
• If you torture the data long enough, it will confess to anything.
• These are my top 5 - Interactive Dashboards.
• 1) Skill Nation's HR Dashboard, Skillnation, Mumbai
• https://lnkd.in/d-P9Fzx8
• 2) Supermarket Sales Dashboard by LegalEase, Chennai
• https://lnkd.in/dVcBzrY7
• 3) Municipal Corporation Servey Dashboard, Strelema, Pune
• https://lnkd.in/dW_4qCBZ
• 4) EuroMart Sales Dashboard, Skillnation, Mumbai
• https://lnkd.in/dAsfBZnw
• 5) Electronics Accessories Sales Dashboard, bizwiz.co.in
• https://lnkd.in/gbqWEaST

Jun 2019 – Nov 2020 · 1 yr 5 mos · Bangalore Urban, Karnataka, India · On-site

• Collected data from NCSRR (National Center for Simulation in Rehabilitation Research) for the design of the human walking mechanisms.
• Collected & Organise data from the OpenSim community, USA to design a normal human walking model. Run this model & calculated Energy Expenditure (Metabolic Rate) during walking & Muscle Activations of the right leg.
• Extract this result data on MS excel & design dashboards. Furthermore, I collected data on metabolic rate & muscle activations for hemiparesis, hemiplegia, lame, disabled, elderly patients & design comparative dashboards w.r.t. Normal Human.
• Moreover, I collected data from the Opensim forum, the USA for assisting devices and applied this device on each patient and collected the results and designed dashboards for the same.
• Optimization of assisted devices data based on Length, Coordinates & force.
• Complete analysis of the walking pattern of each patient and calculated overall results of energy required during walking & muscle activations in the form of Graphs, Pivot Charts & Dashboards.
• After that, Designed Dashboards of providing assistance to the model Vs without providing assistance to the model of each patient in terms of Energy Expenditure (Metabolic Rate) & Muscle Activations of the leg.
• Achievement -
• Finally, Reduced efforts of walking up to 35.88% & reduced muscle activations of the leg according to the patient requirement.
• Day to day work report to the scientist within time.
• Weekly presentation in front of CSIR project head & scientists.
• Live discussion and chat with the Stanford University Scientists to confirm the result.
• Research paper and report writing under the guidance of scientists.