Data Analyst Power Bi

Summary

Nikita Jayanand Ware

Data Analyst

Pune +91-920******* ************@*****.*** LinkedIn Portfolio

Analytical and result-oriented Data Analyst skilled in data analysis, validation, solutioning, and delivering enterprise-ready insights through advanced SQL, BigQuery, and visualization tools.

Strong foundation in data modeling, mapping, data lakes, and SQL optimization to enable accurate and scalable business decision- making.

Proficient in translating complex business requirements into technical data solutions using Google BigQuery, Tableau, Power BI, Alteryx, AtScale, and GCP platforms.

Collaborative in cross-functional environments, adept at facilitating requirement sessions, whiteboarding, and presenting insights through dashboards, scorecards, and client-facing reports. Skills

Programming & Tools: Python (Pandas, Scikit-learn, TensorFlow, Cloud Functions, Colab), R, SQL (MySQL, BigQuery – advanced query optimization, debugging), Jupyter, GitHub, Power BI, Tableau, Excel (Macros, Power Query), Looker Studio Data Engineering & Analytics: ETL, Data Wrangling, Data Validation, Data Mapping, Pipeline Automation, Data Modeling/Design, OLAP/Dimensional Design, Data Lakes

Big Data & Cloud: Google Cloud Platform (GCP), Hadoop, AtScale, Alteryx, Azure, Google Analytics Business & Functional Analysis: Requirement Documentation, Whiteboarding, Rapid Prototyping, Hypothesis Testing, Cause-and-Effect Analysis

Collaboration & Communication: Business Analytics, Stakeholder Engagement, Data-Driven Decision Making, Enterprise Data Platforms

Professional experience

Aditya Enterprises, Pune Data Analyst (Business Intelligence) Aug 2023 - Present

Scoped, designed, and developed analytics solutions leveraging SQL (BigQuery), Power BI, and Tableau to support KPI tracking, pricing, and sales analysis.

Built advanced SQL queries for data extraction, manipulation, validation, and optimization, improving accuracy of reports by 22%.

Developed enterprise-ready dashboards and scorecards, supporting leadership with real-time insights for strategic decision- making.

Automated ETL pipelines, data mapping, and data validation workflows, reducing manual reporting effort by 25%.

Partnered with business units to gather requirements, conduct whiteboarding sessions, and translate them into functional and technical specifications.

Applied statistical models and hypothesis testing to uncover revenue patterns, improving forecasting precision by 15%.

Collaborated across business, product, and data governance teams on large-scope, complex projects, ensuring alignment with enterprise objectives.

CodTech IT Solutions Data Science Internship (Remote) Jan 2025 – Feb 2025

Automated ETL and validation processes using Pandas and Scikit-learn, reducing manual data handling time by 70%.

Designed CNN models in TensorFlow for image classification (92% accuracy) and deployed via Flask API for real-time predictions.

Contributed to end-to-end data pipeline integration, simulating enterprise-grade workflows in production settings. Projects

Impact of Lifestyle Choices on Human Health Academic project analyzing the effect of lifestyle variables on health outcomes using statistical techniques.

Conducted multivariate statistical analysis on responses from 450 participants to evaluate links between sleep, diet, activity, and health metrics.

Designed Power BI dashboards and structured models to assess patterns across physical and mental health outcomes. Customer Churn Prediction Supervised ML model for churn risk classification and improve retention strategies.

Built and fine-tuned churn prediction models using logistic regression and ensemble methods, reaching an accuracy of 85%.

Delivered Power BI visualizations to stakeholders to track retention metrics and campaign performance. Nifty 50 Stock Market Analysis Time series forecasting project analyzing stock trends and generating investment insights.

Integrated historical stock data via APIs and built predictive models using ARIMA and linear regression (R = 0.99).

Distributed weekly forecasting reports with insights on 50+ stock price trends, volatility, and investment signals. Certification

Google Data Analytics Professional Certificate Coursera

Machine Learning Training Certificate Internshala Trainings

Data Analytics and Visualization Job Simulation - Accenture North America Forage Education

M.Sc. Statistics – Dr. D. Y. Patil ACS College, Pune CGPA: 7.82 (2023 – 2025) B.Sc. Statistics – Dr. D. Y. Patil ACS College, Pune CGPA: 8.22 (2020 – 2023)

Contact this candidate