Dinesh Babu D.S

Data Analyst with 5+ years of experience building scalable BI solutions and transforming raw data into actionable business insights. Deep expertise in Power BI, SQL, DAX, and Advanced Excel with a strong track record in data modeling (star schema), ETL processes, and end-to-end dashboard development. Experienced in integrating CRM and billing platforms for unified reporting, automating workflows using Power Automate, and leading cross-functional teams to deliver high-impact reporting solutions.

Data Analyst - Infrascale India Private Limited

(2024-06)

• Integrated data from Chargebee (billing system) and Zoho CRM into Power BI to enable unified, cross-platform business reporting.
• Designed and implemented star schema data models to optimize report performance and ensure scalable, maintainable BI architecture.
• Performed end-to-end ETL processes — including data extraction, transformation, and cleaning — using Power Query for reliable and consistent data pipelines.
• Developed advanced DAX measures to calculate key business metrics: Monthly Recurring Revenue (MRR), Customer Retention & Churn Rate, and Renewal Rates.
• Built and delivered four interactive Power BI dashboards: Renewal & Retention Dashboard, MRR Dashboard, Sales Performance Dashboard, and Support Analytics Dashboard.
• Automated recurring reporting workflows using Power Automate, significantly reducing manual effort and improving reporting turnaround time.
• Developed Cash Forecasting and Accounts Receivable (AR) dashboards in Excel for the finance team.
• Migrating legacy Excel reports to Power BI for enhanced automation, scalability, and real-time visibility.
• Delivered real-time, actionable insights to business stakeholders, directly supporting data-driven decision-making across Sales, Finance, and Support teams.

Data Analyst - Autosense Pvt Ltd

(2021-01 - 2024-04)

• Led a team of 5 members and delivered end-to-end BI dashboard solutions to clients.
• Developed business intelligence solutions using Power BI and Tableau for performance analytics and reporting.
• Optimized report performance through SQL query tuning and efficient data modeling.
• Built DAX calculations and data models to support complex business reporting requirements.
• Integrated APIs with CRM platforms to streamline data flows and automate data collection.
• Cleaned and preprocessed large datasets to ensure data accuracy and consistency.

Associate - Wipro

(2018-12 - 2021-01)

• Developed Excel dashboards and automated reporting using Power Query and Power Pivot.
• Managed a team of 9 members and handled client communication and deliverables.
• Performed data analysis and reporting using SQL and Advanced Excel.

Bachelor of Engineering - Electronics & Communication Engineering - Panimalar Engineering College, Chennai

Diploma - Electronics & Communication Engineering - Panimalar Polytechnic College, Chennai