Saravanan S

About Saravanan S

Results-driven Data Analyst with over 4 years of experience in transforming complex data into actionable insights to drive business growth and efficiency. Proficient in SQL, Advanced Excel, Power BI, and Tableau, with a strong ability to analyze trends, optimize processes, and support strategic decision-making. Adept at developing dashboards, automating reports, and collaborating with cross-functional teams to enhance data-driven decision-making. Passionate about leveraging analytics, visualization, and emerging data science trends to maximize business impact. Seeking an opportunity to apply analytical expertise in a dynamic organization while contributing to business success.

Experience

1. Business Planning

   TVS Credit Services Ltd.

   Apr 2024 — Present · Chennai, IN

   Worked with cross-functional teams (Sales, Collections, Credit, Marketing, OEM, Risk, HR) todevelop a high-impact presentation for the MPR to the CEO and MD, showcasing businesstrends and tracking key AOP KPIs for the Consumer Durables Business. Tracked finance and sales KPIs such as Disbursal Volume, Value, Average order value, ROTA,subvention, PBT, Book Size, Provisions, and Revenue to identify P&L and Business trends. Generated insights for weekly, monthly, and quarterly business reviews on sales performance,OEM penetration, FO productivity, and dealer activation metrics using SQL, Tableau, and Excel,ensuring alignment with key business objectives. Prepared variance analysis, 3W1H, and QC stories for the non-achieved KPI’s to highlight theroot cause of negative deviations and proposed corrective actions to drive business recovery. Managed AOP project tracking by building and maintaining detailed Gantt charts to visualizetimelines, milestones, and cross-functional dependencies.Projects:• Automated Excel to PowerPoint report generation using VBA with the help of AI: The macrodynamically updates the input values, copies formatted ranges, and pastes them as editabletables into slides.• Cross-Sell Revenue Analysis for CD Portfolio: Built an SQL model to analyze cross-sellcomponents like warranties and insurance in the Consumer Durables portfolio. Segmentedproducts and calculated revenue from add-ons to assess upsell opportunities.• Automated Outlook Email Sender with Attachment Management Using VBA: Developed a toolto send personalized emails with dynamic subject, body, and attachments from Excel.• Excel Data Splitter: Automated Workbook Creation by Category Using VBA: Developed a VBAmacro to split a master sheet into multiple workbooks based on unique category values. Thetool filters and copies relevant data into separate files, naming each based on its category.

Education

• THANTHAI PERIYAR GOVERNMENT INSTITUTE OF TECHNOLOGY

  Master of Computer Applications - MCA

  2017 — 2019