profile-pic

Ramkumar Ekantheeswaran

As a Team Lead at CohnReznick Professional Services Pvt Ltd, I applied my data analytics skills and Google Data Analytics Certificate to deliver high-quality business reviews and analysis for various clients. I led a team of five analysts and ensured the accuracy, timeliness, and relevance of our reports and recommendations. I also collaborated with other teams and departments to support the company's growth and innovation goals. Previously, I worked as a Deputy Team Lead at JD Glassworks, where I managed the database and data quality of the glass manufacturing company. I also contributed to the development and implementation of data-driven solutions and strategies to improve the efficiency, productivity, and profitability of the company. Before that, I was a Database Associate at Justdial, where I collected, verified, and updated the information of local businesses and services for the online directory and search engine. I have over six years of work experience in data analytics, business reviews, and database management. I have a Bachelor of Engineering degree in Aeronautical Engineering from Anna University Chennai, and I am passionate about applying my analytical skills and attention to detail to solve complex problems and create value for the customers and stakeholders. My core competencies include data analysis, data quality, data visualization, business intelligence, team leadership, communication, and collaboration.

  • Role

    Head - Analytics / BI

  • Years of Experience

    7.10 years

Skillsets

  • DAX
  • ETL
  • Report generation
  • Stakeholder Management
  • Python - 5 Years
  • SQL - 7 Years
  • PowerBI - 6 Years

Professional Summary

7.10Years
  • May, 2023 - Nov, 2023 6 months

    Deputy Team Lead Reporting & Analytics

    Cohn Reznick Professional Services Private Limited
  • Sep, 2019 - Jan, 20233 yr 4 months

    Data Analyst

    JD Glassworks
  • Sep, 2017 - Aug, 20191 yr 11 months

    Database Associate

    Just Dial Limited
  • May, 2016 - Feb, 2017 9 months

    Researcher Data

    BoardEx India Private Limited

Applications & Tools Known

  • icon-tool

    Advance Excel

  • icon-tool

    DAX

  • icon-tool

    SQL

  • icon-tool

    Data Visualization

  • icon-tool

    ETL

  • icon-tool

    MS PowerPoint

  • icon-tool

    Power BI

  • icon-tool

    Power BI

  • icon-tool

    Azure Data Factory

  • icon-tool

    SSIS

  • icon-tool

    SSRS

  • icon-tool

    Power Automate

  • icon-tool

    SharePoint

  • icon-tool

    SQL Server

  • icon-tool

    SAP

  • icon-tool

    Pandas

  • icon-tool

    NumPy

  • icon-tool

    Matplotlib

  • icon-tool

    Seaborn

  • icon-tool

    Advanced Excel

  • icon-tool

    Power Query

  • icon-tool

    VBA

  • icon-tool

    SQL

  • icon-tool

    Python

  • icon-tool

    Google Sheets

  • icon-tool

    Tableau

  • icon-tool

    MySQL

  • icon-tool

    DAX

Work History

7.10Years

Deputy Team Lead Reporting & Analytics

Cohn Reznick Professional Services Private Limited
May, 2023 - Nov, 2023 6 months
    Lead a team of three members, achieving a significant increase in data analysis efficiency MoM. Developed impactful dashboards utilizing Power BI and Advanced Excel, resulting in a 17% improvement in Employee Utilization monitoring and a vital increase in revenue analysis accuracy. Resolved 90% of reporting issues through critical thinking, enhancing data accuracy and integrity using SQL and Power query. Executed streamlined budget analyses and scheduling, utilizing scheduling tools such as SAP and Profinda, resulting in significant reduction in project delivery time. Collaborated with operations team to build a standalone reporting system for the US team, reducing manpower costs by $5M and providing actionable insights to management. Leveraged expertise in Excel, Power BI, SQL, and Python to extract, clean, manipulate, organise, analyse data into actionable insights and presented to the projects management team, contributing to momentous growth in Operational Performance & utilization.

Data Analyst

JD Glassworks
Sep, 2019 - Jan, 20233 yr 4 months
    Partnered directly with the executive team as the first data hire to formulate and report on KPIs across their web properties that received 25M visitors annually using SQL and Google Sheets. Built a logistic regression model to help the SEO team decide which keywords to target, resulting in a 15% lift in YoY site visitors in 2022. Collaborated with product managers to perform cohort analysis that identified an opportunity to reduce pricing by 22% for a segment of users to boost yearly revenue by 10%. Developed root cause reports to address problems with customer conversions, successfully revealing insights that boosted conversions by 32%.

Database Associate

Just Dial Limited
Sep, 2017 - Aug, 20191 yr 11 months
    Maintained databases, achieving utmost data accuracy and ensuring security and integrity using Power query. Executed data entry and updates, and also addressed internal queries promptly, achieving a 95% resolution rate within 24 hours. Conducted regular data reviews using SQL (MySQL), resulting in a significant reduction in duplicates and inconsistencies. Documented database structures and procedures, ensuring 100% compliance with company standards. Produced monthly reports using Tableau on database performance, usage statistics, and data quality, facilitating informed decision-making to the management.

Researcher Data

BoardEx India Private Limited
May, 2016 - Feb, 2017 9 months
    Conducted in-depth market research, analysing a minimum of 100 industry-relevant data points per study and identifying emerging trends, competitors, and potential opportunities within the market per quarter. Utilized predictive research methodologies and tools such DAX for data gathering and analysis, ensuring comprehensive insights. Compiled monthly reports using Power BI and presented them with greater accuracy, aiding strategic decision-making. Collaborated with the research team to improve data quality by implementing constructive enhancements per quarter. Communicated research findings to stakeholders through quarterly presentations, ensuring 100% understanding and engagement.

Achievements

  • I effectively allocated personnel to projects, ensuring optimal resource utilization
  • I oversaw the recruitment process, assessing candidate suitability and managing onboarding
  • Coordinating with project managers, I aligned staffing needs with project requirements
  • Improved stakeholder visibility and reporting consistency
  • Enhanced reporting performance and data reliability
  • Improved data delivery efficiency
  • Strengthened data privacy and regulatory compliance
  • Enabled secure, role-based insights across geographies
  • Enabled data-driven workforce planning
  • Optimized dashboard performance
  • Increased report accessibility
  • Improved operational efficiency
  • Enabled data-driven decision-making
  • Enhanced reporting efficiency
  • Improved sales forecasting accuracy
  • Accelerated data readiness
  • Streamlined data integration
  • Increased reporting efficiency
  • Enhanced reporting timeliness
  • Generated strategic business intelligence insights
  • Enhanced data-driven decision-making
  • Improved data integrity
  • Achieved a significant increase in data analysis efficiency MoM
  • Developed impactful dashboards utilizing Power BI and Advanced Excel
  • Resolved 90% of reporting issues through critical thinking
  • Executed streamlined budget analyses and scheduling
  • Collaborated with operations team to build a standalone reporting system
  • Built a logistic regression model to help the SEO team decide which keywords to target
  • Collaborated with product managers to perform cohort analysis
  • Developed root cause reports to address problems with customer conversions
  • Maintained databases, achieving utmost data accuracy and ensuring security and integrity
  • Conducted in-depth market research, analysing a minimum of 100 industry-relevant data points per study

Major Projects

1Projects

Workforce Planning Report

    Created dashboards with Power BI for real-time view of resource allocation, historical utilization, and projecting future needs.

Education

  • BE - Aeronautical Engineering

    Anna University (2015)
  • High School

    Vidyaniketan High School (2011)

Certifications

  • Google data analytics certified

  • Lean six sigma green belt certified