Sakshi Kotnala

Data analyst

0+ yrs exp 81 · Excellent

About

I am a motivated and detail-oriented Data Analyst fresher with a strong foundation in Excel, SQL, Python, Power BI, and statistics. I enjoy analyzing data, creating dashboards, and solving real-world business problems. I am a fast learner, a good team player, and committed to continuously improving my skills while contributing to organizational success.

Skills & Expertise (26)

Pandas Intermediate

5.5/10

0.5

Years Exp

GitHub Intermediate

5.5/10

0.5

Years Exp

Git Intermediate

5.5/10

0.5

Years Exp

Jupyter Notebook Intermediate

5.5/10

0.5

Years Exp

VS Code Intermediate

5.5/10

0.5

Years Exp

Statistical Analysis Intermediate

5.5/10

0.5

Years Exp

Exploratory data analysis Intermediate

5.5/10

0.5

Years Exp

MySql Intermediate

5.5/10

0.5

Years Exp

Python Intermediate

5.5/10

0.5

Years Exp

NumPy Intermediate

5.5/10

0.5

Years Exp

Matplotlib Intermediate

5.5/10

0.5

Years Exp

Seaborn Intermediate

5.5/10

0.5

Years Exp

SQL Intermediate

5.5/10

0.5

Years Exp

SQLite Intermediate

5.5/10

0.5

Years Exp

Documentation Intermediate

4.5/10

0.5

Years Exp

Power BI Intermediate

4.5/10

0.5

Years Exp

Tableau Intermediate

4.5/10

0.5

Years Exp

Advanced Excel Intermediate

4.5/10

0.5

Years Exp

Power Pivot Intermediate

4.5/10

0.5

Years Exp

XLOOKUP Intermediate

4.5/10

0.5

Years Exp

Regression Intermediate

4.5/10

0.5

Years Exp

Classification Intermediate

4.5/10

0.5

Years Exp

Clustering Intermediate

4.5/10

0.5

Years Exp

scikit-learn Intermediate

4.5/10

0.5

Years Exp

Data Governance Intermediate

4.5/10

0.5

Years Exp

KPI Definition & Tracking Intermediate

4.5/10

0.5

Years Exp

Work Experience

Data Analyst Intern

Bluestock Fintech

Jun 2026 - Present

Built an end-to-end Mutual Fund Analytics pipeline as part of a 7-day capstone project, designing a 6-table SQLite star schema and loading data via SQLAlchemy. Fetched live NAV data from the mfapi.in API and cleaned 64,320 NAV history records and 32,778 investor transaction records, ensuring data integrity through forward-fill and validation. Wrote and executed 10 analytical SQL queries to extract fund performance insights; conducted exploratory data analysis producing 9 visualizations and 10 documented key findings using Python (Pandas, Matplotlib, Seaborn, Plotly). Maintained version control via Git/GitHub and authored a data dictionary to support project reproducibility and team handover.

Junior Data Analyst – Agribusiness

YuvaIntern

Feb 2026 - Apr 2026

Collected, cleaned, and analysed 5-year price, production, and sales data for 3 key agricultural commodities; identified seasonal pricing patterns that informed procurement timing and operational planning. Mapped end-to-end supply chain for 2 commodity categories; defined KPIs and tracked operational metrics, pinpointing 4 bottlenecks and proposing process changes projected to reduce lead time by ~15%. Built a cost–benefit model with payback period estimates and BCR calculations for a proposed infrastructure investment, summarised in an executive-level report. Developed a risk assessment matrix using likelihood–impact scoring and sensitivity analysis across 6 risk scenarios, enabling prioritised mitigation planning. Produced a Triple Bottom Line sustainability report covering economic, environmental, and social dimensions; maintained structured data documentation and governance records delivered to project stakeholders.