Omkar Sonawane

Data Manager

Uber • Tiempo completo

Nov 2023 - Present • 2 yrs 6 mos

Hello! 👋 I am a professional Data Analyst & MIS Specialist with hands-on experience in data cleaning, processing, analysis, dashboard creation, and automation. I help businesses and individuals turn messy, raw data into clean, structured, and meaningful insights so you can make faster, smarter, and data-driven decisions. 🔹 Services I Offer: ✅ Data Cleaning & Processing Clean, structure, and standardize raw data Remove duplicates, blanks, and incorrect entries Format large datasets properly Data validation & error handling ✅ Data Analysis & Reporting In-depth business data analysis Identify trends, patterns, and insights Daily, weekly, and monthly MIS reports Performance tracking (Sales, Operations, Finance, HR, etc.) ✅ Google Sheets & Excel Expert Advanced formulas: ARRAYFORMULA, QUERY, VLOOKUP/XLOOKUP, INDEX+MATCH, FILTER, IF, IFS, COUNTIFS Google Forms auto data collection & reporting Master MIS from multiple sheets Real-time dashboards & visualization Professional Excel dashboards, Pivot Tables & Charts, Conditional Formatting Automation using formulas and scripts ✅ Dashboard Creation Easy-to-understand dashboards for management Clear charts, KPIs, and graphs Minimized manual work Dashboards for Sales, Operations, Inventory, HR, Finance, and more ✅ Google Apps Script Automation Automate repetitive tasks Auto email reports Button-based automation Data transfer between sheets automatically Trigger-based actions (time-based or on form submission) 🔹 Why Choose Me: ✔ Fast delivery & 100% accurate work ✔ Clean, organized, and user-friendly dashboards ✔ Scalable & reusable solutions ✔ Clear communication & client satisfaction priority ✔ Long-term support 🔹 Industries I Work With: Sales & Marketing Logistics & Operations Vehicle / Fleet Management Charging & EV Operations HR & Attendance Tracking Small Businesses & Startups 🔹 Tools & Technologies: Google Sheets Microsoft Excel Google Apps Script Google Forms MIS Reporting