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

Advance Excel
DAX
SQL
Data Visualization
ETL
MS PowerPoint
Power BI
Power BI
Azure Data Factory
SSIS
SSRS
Power Automate
SharePoint
SQL Server
SAP
Pandas
NumPy
Matplotlib
Seaborn
Advanced Excel
Power Query
VBA
SQL
Python
Google Sheets
Tableau
MySQL
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