5+ Years enabling data-driven decision making through 100+ interactive dashboards, CRM automation, and business intelligence.
I'm Ravi Ranjan Kumar, a results-driven Data & Business Operations Analyst with 5+ Years of Professional Experience (including 3+ Years as a dedicated Data Analyst) spanning CRM management, workflow automation, business intelligence, and sales operations. I hold a Bachelor's degree in Economics (Hons.) from B.R.A. Bihar University.
I have a proven track record of designing and delivering 100+ interactive dashboards across Power BI, Metabase, Tableau & Looker Studio — automating reporting pipelines and driving a 40% improvement in sales team productivity through strategic CRM implementation. Expertise in end-to-end lead management, customer lifecycle analytics, and process optimisation across e-commerce, financial services, and digital product verticals.
Adept at leveraging n8n, Pabbly, Claude AI, and SQL to deliver measurable business impact, scalable operational excellence, and data-driven decision making at every level of the organisation.
Data Analyst @ The Batraa Numerology
5+ Years Professional · 3+ Years as Data Analyst
100+ Interactive Dashboards (Power BI · Metabase · Tableau · Looker Studio)
Senior Data Analyst · BI Analyst · Sales Ops · MIS Executive
New Delhi, India · Open to Remote
The Batraa Numerology (Batra Numerro Pvt. Ltd.) · New Delhi, India
Innovate Insights Consultancy · Noida, UP
Client:
ONE97 Communications Ltd. (Paytm)
Maral Overseas Ltd. · Noida, UP
IIFL Samasta · Madhubani, BH
The pipeline behind 100+ dashboards and the automation that keeps sales teams moving.
End-to-end revenue tracking with funnel-to-conversion analysis, booking trends, and real-time sales KPIs across all product lines.
Multi-dimensional lifecycle dashboard with product-affinity segmentation, stage tracking, and lead nurturing intelligence.
Executive performance tracking with call activity, lead coverage, conversion rates, and productivity benchmarks across teams.
Ratnakrit store performance: product sales, inventory, order trends, and customer behavior for crystals, rudraksha, and accessories.
Intelligent lead segregation, 15-day untouched-lead auto-alerts, and Google Sheets automation for attendance, leave & conversions.
Automated attendance management with leave tracking, event reminders, and MIS reporting via Google Sheets and Claude AI.
Leadership report with period slicers, 13-month & 90-day trends, click-to-filter drill-down and ad-spend vs. leads — every visual auto-tested with DAX.
Product-to-product conversion engine and L2/L3 social-media funnel with customer de-duplication, duplicate-transaction detection and daily auto-refresh.
Read-only API sync of orders, shipments, returns, tracking and WhatsApp broadcast/button analytics into MySQL master tables that feed dashboards.
Advanced SQL to extract business insights from order and delivery datasets.
View on GitHubThrough strategic TeleCRM & Smartflo deployment and structured lead management protocols.
Via n8n and Pabbly automation workflows replacing repetitive reporting and lead management tasks.
Power BI, Metabase, Tableau & Looker Studio dashboards spanning revenue, customer journey, sales operations, e-commerce & BI reporting.
Through structured SOP creation, process documentation, and cross-team operational guidance.
Google Sheets workflows automated via Claude AI — attendance, lead bifurcation, reporting & reminders.
Delivering data-driven insights and automated reporting solutions across fintech, manufacturing, and digital product verticals.
Babasaheb Bhimrao Ambedkar Bihar University
2018 · Muzaffarpur, Bihar
Open to roles, collaborations, and interesting conversations.