Smitha Kamath

Smitha Kamath

Data Analyst
UAE
Kannada, English, Hindi
Full-time On-site

About Me

Results-driven MCA graduate with 6 years of experience in data analysis, including 4 years at Mitsubishi Motors MEA (Dubai) and 2 years at Tally Solutions (Bangalore). Skilled in automated reporting, KPI tracking, and ge…

Experience

Data Analyst

Mitsubishi Motors Middle East and Africa · Dubai
Jul 2022 - Present · 4 years 4 months

<p>Created and maintained 30+ weekly and monthly sales reports, enhancing reporting visibility and supporting data-driven business decisions.</p><p> Analyzed sales performance versus forecasts, improving forecast accuracy by 5–10% and enabling more informed planning.</p><p> Automated 60–75% of reporting workflows, significantly reducing turnaround time and minimizing manual errors.</p><p> Conducted meetings and consolidated monthly performance information for one GCC country, providing a clear view of business status and defining key next steps to support performance improvement and target achievement for the GD.</p><p> Tracked and automated Business Excellence Program sheets and calculations, improving efficiency and reducing manual reporting efforts.</p><p> Developed core dashboards and reports (Weekly Sales, Stock, Car Flow, TIV, GD Performance) for senior management and distributors using advanced analytical tools.</p><p> Standardized reporting formats, cutting preparation time by 40–60% and improving consistency across deliverables.</p><p> Monitored market and economic updates to support proactive sales planning and identify potential risks and opportunities.</p><p> Utilized advanced Excel, PowerPoint, Outlook, and Power BI to manage and analyze 100K+ monthly data records and present insights to stakeholders.</p><p> Defined and tracked 15+ KPIs, delivering regular performance and variance insights to support strategic and operational decisions.</p><p> Built scalable data models with 99% accuracy to ensure reliable reporting and robust analysis.</p><p> Produced clear, user-friendly data visualizations to communicate complex findings to both technical and non-technical audiences.</p><p> Coordinate with cross-functional teams to gather data and fulfill reporting requirements.</p><p> Advanced proficiency in Microsoft Excel, including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, complex formulas, and data analysis.</p><p> Independently managed the Bahrain market, analyzed sales performance, coordinated with distributors</p>

Data Operation Executive

Tally Solutions Pvt Ltd · Bangalore
Dec 2019 - Dec 2021 · 2 years

<p>Extracted, curated, and interpreted data from multiple primary and secondary sources to generate meaningful insights.</p><p> Developed and implemented data collection systems and strategies to improve data quality, accuracy, and efficiency.</p><p> Identified and analyzed new products, services, customer segments, and market trends to support business decisions.</p><p> Collected and evaluated data on customers, competitors, and marketing channels to support market and business analysis.</p><p> Provided technical expertise in data storage structures, data mining, data cleansing, and data validation.</p><p> Utilized advanced tools and techniques to extract, transform, and process large datasets.</p><p> Collaborated with diverse teams across Data Operations including Data Enrichment, Data Labelling, and Catalogue Management.</p>

Junior Administrator

Diya Systems · Mangalore
Oct 2018 - May 2019 · 7 months

<p>Provided front-line support via chat, resolving technical and non-technical issues for web hosting plans and services.</p><p> Analyzed and addressed customer technical and sales queries, troubleshooting system issues as per requirements.</p><p> Resolved bugs related to cPanel and website CRMs, and assisted with POP3, IMAP, and SMTP configurations.</p><p> Managed WordPress tools and supported 100+ clients per day, ensuring timely and effective solutions.</p><p> Delivered high-quality customer service while maintaining efficiency in a high-volume support environment.</p>

Skills

Advanced Excel Formulas Pivot Tables Dashboards SQL Data Visualization Storytelling Retail / Sales Performance Analysis Report Automation Power BI Microsoft Power point MIS & Business Performance Reporting Data Accuracy Validation Teamwork XLOOKUP VLOOKUP INDEX-MATCH
Report this Profile?