Data Analyst Power Bi

AVANTIKA DOKHALE

913*******

*****************@*****.***

https://www.linkedin.com/in/avantika-

dokhale/

PROFESSIONAL SUMMARY

Data Analyst with hands-on experience in Python, SQL, Power BI, and automation using Power Automate. Strong foundation in statistical modelling, forecasting, and data visualization. Passionate about solving real-world problems through data-driven insights. SKILLS

Programming: Python, R, SQL

Analytics & BI: Excel, Power BI, RStudio

ML & Stats: Machine Learning, Time Series, Statistical Modelling

Automation: Power Automate Desktop

Soft Skills: Communication, Teamwork, Problem-Solving CERTIFICATES

1. Accenture Data Analytics and Visualization Job Simulation August2024

Enhanced data visualization capabilities, leading to a 20% improvement in business decision-making processes during simulations.

2. Python (Basic) Certification Hacker Rank

August 2024

3. SQL (Basic) Certification Hacker Rank

PROFESSINAL EXPERIENCE

1. Fibi tech Solutions Pvt. Ltd Winter Intern Dec 2024- Apr 2025

Contributed to the AI-Enabled Vendor Portal by designing 2-way and 3-way invoice matching logic using complex SQL queries to match purchase orders, GRNs, and invoices.

Developed an automated desktop solution using Power Automate Desktop to:

Extract key fields (company/applicant/co-applicant) from Excel

Perform automated Google and legal history checks (via Indian Kanoon & CIBIL Suit)

Capture full-screen screenshots and compile them in Word documents dynamically Helped streamline the due diligence process by reducing manual search time by 50%.

2. Bosch India Summar intern June2024 - Aug2024

Managed a team in building a digital solution that streamlined candidate processing workflows, cutting processing time by 30% and improving HR operations by 20%.

Utilized statistical approaches such as probability evaluations, textual analysis, and data normalization to refine recruitment data, leading to a 25% gain in selection accuracy.

Developed the application using Django, Bootstrap, and Google Sheets, which improved system usability and contributed to a 20% increase in overall HR efficiency.

Created automated reporting mechanisms that minimized manual input by 40%, enabling quicker insights and enhancing data-driven decisions. PROJECTS

Time Series Forecasting – Power Usage Analytics

Techniques Used: AR, MA, ARMA, ARIMA, Stationarity Testing, Decomposition Analysed historical electricity consumption data using classical time series models including AR, MA, ARMA, and ARIMA to uncover underlying usage trends. Evaluated data stationarity through unit root tests and plotted temporal patterns for visual interpretation.

Decomposed the series into trend, seasonality, and residuals to derive meaningful insights into usage behaviour.

Built forecasting models to predict future consumption patterns and share price movements, enabling improved resource planning and strategic decision-making. EDUCATION

Symbiosis Statistical Institute, Pune Master of Science Applied Statistics 2023 – 2025 HPT Arts RYK Science college, Nashik Bachelors of science (Statistics) 2020 – 2023

Contact this candidate