![Sonali Kumar](https://jobicy.com/react/themes/app/images/avatar.jpg) Sonali Kumar # Junior Data Analyst Actively looking · Member since 5 Aug 2026 [Message](https://jobicy.com/enter4715.php.md) ShareLocationNew Delhi, IndiaDesired salaryUnspecifiedWork preferenceRemote OnlyExperience levelJunior * [Overview](#overview) * [Portfolio 0](#portfolio) * [Services 0](#services) ## About Professional summaryI am a Junior Data Analyst and Business Intelligence Specialist based in New Delhi, India, with hands-on experience building interactive dashboards, optimizing SQL queries, and transforming complex data into actionable business insights. I work extensively with Power BI, SQL, PostgreSQL, Excel, Tableau, Power Query, and DAX. My strengths include dashboard development, KPI reporting, data visualization, data validation, ETL workflow design, and relational database analysis. I have designed Star Schema data models with fact and dimension tables, implemented Row-Level Security (RLS), and created automated reporting workflows that improve data refresh performance, governance, and operational efficiency. As a freelance data analyst, I have delivered Power BI and Excel reporting solutions for independent clients, reducing manual reporting processes and enabling clearer performance monitoring through dynamic dashboards and filters. I have also completed practical virtual case studies with Tata Group, Deloitte, and BCG X, applying data cleaning, exploratory analysis, trend analysis, and executive reporting methods to large business datasets. I am seeking a remote Junior Data Analyst or Data Specialist opportunity where I can contribute strong technical precision, detail-oriented database management, and data-driven decision-making skills. ## Skills 29 capabilities[Business Analytics](https://jobicy.com/talent/business-analytics.md)[Business Intelligence](https://jobicy.com/talent/business-intelligence.md)[Conditional Formatting](https://jobicy.com/talent/conditional-formatting.md)[Dashboard Design](https://jobicy.com/talent/dashboard-design.md)[Data Analysis](https://jobicy.com/talent/data-analysis.md)[Data Cleaning](https://jobicy.com/talent/data-cleaning.md)[Data Driven Decision Making](https://jobicy.com/talent/data-driven-decision-making.md)[Data Governance](https://jobicy.com/talent/data-governance.md)[Data Modelling](https://jobicy.com/talent/data-modelling.md)[Data Quality](https://jobicy.com/talent/data-quality.md)[Data Validation](https://jobicy.com/talent/data-validation.md)[Data Visualization](https://jobicy.com/talent/data-visualization.md)[Database Design](https://jobicy.com/talent/database-design.md)[DAX](https://jobicy.com/talent/dax.md)[ETL](https://jobicy.com/talent/etl.md)[Index Match](https://jobicy.com/talent/index-match.md)[Marketing Analytics](https://jobicy.com/talent/marketing-analytics.md)[Pivot Tables](https://jobicy.com/talent/pivot-tables.md)[PostgreSQL](https://jobicy.com/talent/postgresql.md)[Power Pivot](https://jobicy.com/talent/power-pivot.md)[Power Query](https://jobicy.com/talent/power-query.md)[Python](https://jobicy.com/talent/python.md)[Query Optimization](https://jobicy.com/talent/query-optimization.md)[Relational Databases](https://jobicy.com/talent/relational-databases.md)[Reporting](https://jobicy.com/talent/reporting.md)[ROI Analysis](https://jobicy.com/talent/roi-analysis.md)[SQL](https://jobicy.com/talent/sql.md)[Trend Analysis](https://jobicy.com/talent/trend-analysis.md)[Virtual Collaboration](https://jobicy.com/talent/virtual-collaboration.md) ## Tech stack & tools Working toolkit ### Data Stores [![Image](https://cdn.jsdelivr.net/gh/devicons/devicon@master/icons/postgresql/postgresql-original.svg) PostgreSQL](https://jobicy.com/talent?tool=postgresql.md) ### Development [![Image](https://cdn.jsdelivr.net/gh/devicons/devicon@master/icons/git/git-original.svg) Git](https://jobicy.com/talent?tool=git.md)[![Image](https://cdn.jsdelivr.net/gh/devicons/devicon@master/icons/github/github-original.svg) GitHub](https://jobicy.com/talent?tool=github.md) ## Experience Career history ### Freelance Data Analyst · Independent Clients Jan 2025 – PresentI automate reporting workflows using Power BI and Power Query, reducing manual business processing time by 30%. I create interactive Excel dashboards with dynamic slicers, advanced filters, and Power Pivot models for independent clients. I design optimized Star Schema data models in Power BI and implement Row-Level Security to support enterprise-grade data governance. I also streamline ETL pipelines with M Language in Power Query to improve refresh performance and data integrity. ### Data Visualization Specialist Case Study (Forage) · Tata Group Dates not specifiedI acted as a remote data consultant in a virtual case study focused on evaluating global expansion strategies. I identified market outliers and mapped business-growth opportunities from large retail data. I built executive-facing Power BI dashboards to clean, model, and visualize a retail dataset containing more than 500,000 transaction records. The work focused on turning complex operational data into clear decision-support insights. ### Data Analytics & Consulting Case Study (Forage) · Deloitte (Global) Dates not specifiedI completed a virtual data analytics and consulting case study focused on international market analysis for the Japanese corporate division. I transformed unstructured information into structured business intelligence for strategic analysis. I performed data scrubbing, complex deduplication, and predictive trend analysis on datasets exceeding 150,000 rows. I applied standard analytics workflows to improve the quality and usability of reporting data. ### Data Science & Strategic Analytics Case Study (Forage) · BCG X Dates not specifiedI completed a virtual data science and strategic analytics case study focused on solving complex corporate client challenges through data-driven problem solving. The analysis emphasized operational efficiency and AI-driven business analytics. I conducted exploratory data analysis on raw client metrics to identify meaningful patterns and trends. I translated statistical findings into concise executive summaries for senior stakeholders. ## Education Learning history ### Delhi University Dates not specifiedBachelor of Commerce (Honors), Commerce Bachelor of Commerce (Honors) degree from Delhi University. This professional hasn’t added portfolio projects yet. This professional hasn’t listed any services yet. ## People also viewed [![Abul Khayer Leon](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/08/avatar_71791_1785737416.jpg) Abul Khayer Leon Junior Machine Learning Engineer](https://jobicy.com/u/id71791.md) [![David Caleb Chaparro Orozco](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/08/avatar_73672_1785720848.jpg) David Caleb Chaparro Orozco Data Engineer and Data Scientist](https://jobicy.com/u/id73672.md) [![Giuliano Ottoboni](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_73243_1785366941.jpg) Giuliano Ottoboni AI Data Trainer / Data Analyst](https://jobicy.com/u/id73243.md) [![Ali Hasanov](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_73139_1785309016.jpg) Ali Hasanov Data Scientist / AI Engineer](https://jobicy.com/u/id73139.md) [![Javier Nemoga Franco](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72949_1785216066.jpg) Javier Nemoga Franco Telecommunications Engineer | Data Scientist | LLM Trainer](https://jobicy.com/u/id72949.md) [![Elina Tonato](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72852_1785177737.jpg) Elina Tonato Data Analyst & BI Specialist](https://jobicy.com/u/id72852.md) [![Burney Zhang](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72745_1785151209.jpg) Burney Zhang Senior Data Engineer / Data Analyst](https://jobicy.com/u/id72745.md) [![Ayush Khurana](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72519_1785063228.jpg) Ayush Khurana Business Analyst / Product Analyst](https://jobicy.com/u/id72519.md) [All talent ›](https://jobicy.com/talent.md)