Open to opportunities

Nikita Lohakare

@nikitalohakare

Message

Senior Data Analyst turning complex datasets into executive-ready market and business insights.

India

Message

What I'm looking for

I’m looking for a role where I can lead analytics and market intelligence—building executive-ready dashboards, KPI reporting, and strategic recommendations from complex datasets, collaborating cross-functionally, and owning end-to-end insight delivery.

I’m a Data Analytics & Business Intelligence Consultant with 6+ years of experience transforming large datasets into actionable business insights across telecom, semiconductor, technology, FMCG, and healthcare. I focus on turning structured and unstructured data into clear trends, performance metrics, and strategic recommendations.

I’ve delivered 250+ executive reports and developed 12 interactive Tableau dashboards to support executive decision-making for Fortune 500 clients. In my work, I translate revenue indicators, monetization performance, and KPI trends into insights stakeholders can act on.

I combine market intelligence and strategy with strong analytics execution—using SQL, Tableau, Advanced Excel, and Python for KPI reporting, dashboard development, revenue analytics, pricing analysis, and data visualization. I also apply statistical testing (Chi-Square, Regression) and exploratory data analysis (EDA) to validate findings and surface drivers.

At Dolcera, I led analytics and reporting across 100+ client projects spanning 18+ industries, analyzing large-scale datasets across 40+ countries. I’ve managed 4–5 concurrent project streams and mentored 4 junior analysts, while delivering studies and market assessments such as telecom/IoT/semiconductor analytics for Qualcomm and competitive intelligence across AR/VR and connected retail ecosystems.

Experience

Work history, roles, and key accomplishments

Current

Business Research Consultant

Current

Dolcera

Jun 2023 - Present (3 years 1 month)

Provide business research and analytics consulting, producing executive-ready reports and presentations for client strategy and decision-making.

Business Intelligence Market Intelligence Competitive Intelligence Pricing Analytics Market Sizing Tableau Advanced Excel SQL Python Data Visualization Dashboarding

Associate Business Research Consultant

Dolcera

Oct 2019 - Jun 2023 (3 years 8 months)

Supported analytics and reporting for business research engagements, translating datasets and KPI trends into actionable insights for stakeholders.

Business Intelligence Market Intelligence KPIs Tableau Advanced Excel SQL Python Data Visualization

Business Development Manager

Sitsl

May 2019 - Jul 2019 (2 months)

Worked as a Business Development Manager supporting business growth activities during the stated tenure.

Plant-Based Products Innovation Tracking

Vitasoy

Tracked innovation and strategy roadmaps for plant-based products, delivering executive-ready market assessments and consumer preference analyses across multiple categories and regions.

Tableau Advanced Excel Market Assessment Trend Analysis Data Visualization

Telecom, IoT & Semiconductor Analytics

Qualcomm

Analyzed telecom and smartphone market data to identify trends in subscriber growth, shipments, revenue, ARPU, churn, and technology adoption, and delivered executive analytics reports.

SQL Advanced Excel Tableau Python Data Cleaning data transformation Window Functions Data Mapping Dashboard Development

Oral Care Analytics

Colgate

Evaluated product launch and ingredient datasets to identify innovation trends and business opportunities, and produced competitor benchmarking and consumer preference analyses for executive reporting.

Data Analysis Tableau Advanced Excel Benchmarking Data Visualization

Smart Retail & Beverage Intelligence

PepsiCo

Performed analytics and benchmarking across connected retail and beverage technologies, comparing products and global brand performance to support market intelligence.

Market Intelligence Competitive Benchmarking Data Analysis Data Visualization Trend Analysis

AR/VR Smart Glasses Market Analysis

Luxottica

Built competitive analytics for smart eyewear and XR ecosystems, analyzing technology trends and use cases to support strategic planning and executive decision-making.

Competitive Intelligence Data Analysis Market Assessment Trend Analysis Tableau Advanced Excel

Education

Degrees, certifications, and relevant coursework

Great Lakes (in association with Texas McCombs)

Post Graduate Program, Data Science and Business Analytics

2023 - 2024

Completed a Post Graduate Program in Data Science and Business Analytics with Great Lakes (in association with Texas McCombs School of Business) from 2023 to 2024.