Janaki Padalkar

Business Analyst

Mumbai, Maharashtra, India 1+ yrs exp 73 · Very Good

About

No bio added yet

Skills & Expertise (16)

Python Intermediate

7.4/10

Years Exp

SQL Intermediate

7.2/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

NumPy Intermediate

6.8/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

XGBoost Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.0/10

Years Exp

Random Forest Intermediate

6.0/10

Years Exp

Logistic Regression Intermediate

6.0/10

Years Exp

Feature Engineering Intermediate

6.0/10

Years Exp

Tkinter Intermediate

6.0/10

Years Exp

Time Series Intermediate

5.5/10

Years Exp

Decision Trees Intermediate

5.5/10

Years Exp

ARIMA Intermediate

5.0/10

Years Exp

Operations Research Intermediate

5.0/10

Years Exp

MS Office

Work Experience

Business Analyst

The Jewelry Co. (Affiliate of SRK Exports Pvt. Ltd.)

Aug 2025 - Present

DCB automation: Designed and deployed a Python-based automation tool (GUI [Tkinter] integrated, rule-based logic) compiled as an executable for non-technical users to parse and reformat ERP-generated quotation documents into client-specific outputs, reducing manual processing time by 98% (8 hours to 5 minutes) for all active accounts. Manufacturing workflow modeling: Developed a structured workflow model across various jewelry production paths, mapping interdependent manufacturing sequences and common sub-processes to replace a generic process map, enabling lead time estimation, validation of production cost per SKU, and a significant reduction in operational errors. Customer segmentation: Aggregated year-wise data to customer level for segmenting them by design preference, sample adoption, and purchasing behavior, revealing that customers across different regions and salespeople were independently converging on the same product types, exposing demand trends for the developing customized design concepts. Preference & trend analysis: Analyzed three years of sales data to detect material preference shifts at the client level, identifying systematic transitions (gold to silver, platinum to gold) and translating findings into actionable signals for product development and sales outreach prioritization.

Management Trainee — Data Science

Shree Ram Krishna Exports Pvt. Ltd.

Mar 2025 - Jul 2025

ML model & feature engineering: Built an XGBoost classification pipeline on high-dimensional diamond inventory data, incorporating SQL-based extraction (multi-table joins, window functions) and composite feature engineering to drive bid selection for a flagship sales event—reducing manual analyst effort by 40% and selection turnaround by 70%, while maintaining high recall for broad customer coverage.

Data Analysis Intern

Akasa Air

Jun 2024 - Aug 2024

ETL pipeline & reporting: Created a data pipeline ingesting large-scale Parquet and Excel booking data on 3-hour refresh cycles, reducing manual data preparation effort by 60% and enabling near real-time analytical monitoring for business teams. Revenue & capacity analytics: Engineered revenue metrics (Average Fare, Passenger Load Factor) across seasonal and cyclical sales patterns, and implemented weighted spoilage scoring models to capture demand shifts, enabling more accurate pricing decisions. Identified peak and low-demand event windows by analyzing booking spikes and trend spans to support capacity planning and pricing optimization during high-impact periods.