Dec 2022 – Aug 2024 · 1 yr 8 mos · Bengaluru, Karnataka, India · Hybrid

• #Automated Quote Generation System Development -
• +Spearheaded the development of a cutting-edge automated quote generation system using Google AppScript, SQL (with ETL processes), Excel, and Google Sheets. Revolutionized data retrieval and logistics cost calculation, seamlessly integrating comprehensive data analysis to refine pricing strategies. Achieved a remarkable 70% reduction in quote preparation time while significantly enhancing data accuracy and workflow efficiency.
• +Provided actionable insights that supported strategic decision-making, driving notable improvements in team productivity and operational effectiveness.
• #Data collection & Management -
• +Streamlined data collection for Project RFQ by creating an advanced Google Sheets system with automated categorization using complex formulas and scripting, and subsequently migrated data management to MySQL with ETL processes, enhancing integration and workflow efficiency by 30%.
• +Standardized data across customer churn metrics, achieving a 15% reduction in churn, regional order analytics, resulting in a 20% increase in orders, and product SKU information. Applied data wrangling techniques such as normalization and aggregation using SQL and Excel array formulas to improve overall data accuracy and consistency by 25%.
• # Data Analysis & Visualization –
• +Developed automated dashboards in Looker Studio, Power BI, and Google Sheets (Pivot). Conducted analyses like category wise Profit and Loss order, top-selling product identification, sales forecasting, market segmentation, and inventory turnover. Improved decision-making, leading to a 20% increase in sales accuracy and a 15% reduction in inventory costs. Delivered actionable insights through data visualization for strategic growth.

Feb 2022 – Nov 2022 · 9 mos · Bengaluru, Karnataka, India · Hybrid

• #Orders Workflow Automation:
• +Spearheaded the comprehensive implementation of Zoho Projects for order tracking, meticulously designing project timelines and workflows. Successfully implemented web-hooks and developed an in -built tracker to monitor task statuses and order positions. This initiative resulted in a 30% improvement in tracking efficiency and a 25% reduction in task completion times.
• #Data Analysis & Visualization -
• +Analyzed data to uncover trends, collaborated with teams on data-driven solutions, and designed dashboards for stakeholders. Mentored junior analysts, executed A/B tests, and ensured data quality and governance. Managed multiple projects, stayed current with industry trends, and communicated technical concepts effectively to non-technical stakeholders. Used - SQL, Excel and Python for analysis and Looker, PowerBI and Pivot for Visualization.