Sonali Kumar
@sonalikumar
Data Analyst specializing in Business Intelligence—building Power BI dashboards, optimized SQL, and governed ETL pipelines.
IndiaWhat I'm looking for
I’m a Data Analyst with hands-on experience developing interactive Power BI dashboards, optimizing SQL database queries, and designing efficient ETL data pipelines. I build robust Star Schema data models and configure Row-Level Security (RLS) to ensure data governance, transforming complex datasets into actionable business intelligence.
In my work, I deliver measurable impact through precise modeling and reporting. I engineered an operations dashboard using a Star Schema model with 10+ business metrics, authored 25+ DAX measures for dynamic KPIs, and implemented RLS for enterprise-grade access control; in SQL analysis, I optimized reporting accuracy by 35% with strict validation and parameterized filtering across 25+ advanced queries.
As a Freelance Data Analyst (Remote), I’ve automated workflows with Power BI and Power Query, reducing manual processing time by 30% and improving data refresh performance and integrity using M Language. I also completed virtual corporate analytics experiences (Tata Group, Deloitte, BCG X), where I built executive-facing dashboards, performed rigorous data scrubbing/deduplication, and synthesized insights for senior stakeholders.
Experience
Work history, roles, and key accomplishments
Freelance Data Analyst
Freelance
Jan 2025 - Present (1 year 6 months)
Automated reporting workflows using Power BI and Power Query to reduce manual processing time by 30%. Built interactive Excel dashboards and designed Power BI Star Schema models with Row-Level Security to improve data governance and refresh performance.
Data Analytics & Consulting Case Study
Performed large-scale international market analysis for the Japanese corporate division by transforming unstructured inputs into structured strategic business intelligence. Conducted data scrubbing, deduplication, and predictive trend analysis on 150,000+ rows.
Data Science & Strategic Analytics Case
Applied data-driven problem-solving to address client challenges focused on operational efficiency and AI-driven business analytics. Performed exploratory data analysis to extract patterns and convert statistical findings into executive-ready summaries.
Data Visualization Specialist Case Study
Acted as a remote data consultant to support global expansion strategy by mapping business growth opportunities and isolating market outliers. Built Power BI dashboards to scrub, model, and visualize a large retail dataset with 500,000+ transaction records.
Education
Degrees, certifications, and relevant coursework
University of Delhi
Bachelor of Commerce (Honors), Commerce
Bachelor of Commerce (Honors) degree from University of Delhi.
Tech stack
Software and tools used professionally
Availability
Location
IndiaAuthorized to work in
Social media
Job categories
Interested in hiring Sonali?
You can contact Sonali and 90k+ other talented remote workers on Himalayas.
Message SonaliGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
