
prema jondhale
Senior Data Analyst | Python | Power BI
Salaire / Taux journalier
Paris, France
Freelance
Expertises
Langues
À propos
Introduction
Senior Data Analyst with 8+ years expertise in Python automation, Power BI dashboards, and financial process optimization. Proven track record reducing reporting time by 40% and streamlining inventory workflows through ML models and OCR automation. Specialized in transforming manual processes into scalable solutions that drive operational efficiency and data-driven decisions.
Expérience de travail
Senior Data Analyst | Python | Power BI
GROUPE AK MARKET (franchise Franprix)
mai 2023 - Présent
3 ans 6 mois
Paris, France
I successfully transformed financial and inventory processes through automation and data analysis. Objective: Automate invoice reconciliation and supplier payment tracking , Improve inventory monitoring and demand forecasting , Analyze pricing performance, and profit margins , Deliver insightful dashboards. Key Achievements: 1. Built Python-based automation scripts using OCR tools to scan, extract, and validate invoice data Reconciled extracted data against stock movements and payment records 2. Analyzed daily sales and stock data across multiple store locations using Pandas and NumPy Detected underperforming SKUs, optimized restocking frequency, and improved inventory turnover 3. Developed machine learning models to track competitive pricing, customer preferences, and margin fluctuations 4. Worked closely with store managers and buyers to create demand forecasts . Aligned purchase planning with projected sales, minimizing overstock and stockouts Boosted operational efficiency Benefits: ✔️ Streamlined finance and inventory workflows with automation ✔️ Increased visibility across stores and suppliers ✔️ Enabled proactive business decisions through real-time data ✔️ Empowered non-technical users with easy-to-use dashboards ✔️ Reduced dependency on manual processes and error-prone Excel files
_VOIS
juil. 2018 - janv. 2022
3 ans 7 mois
Pune, Maharashtra, Inde
Senior Data Analyst | Python Developer
juil. 2020 - janv. 2022
1 an 7 mois
Pune, Maharashtra, Inde
In my role at _VOIS, I tackled significant challenges in SEO performance tracking and competitive pricing analysis. By leveraging Python for automation, I transformed manual processes into efficient workflows, resulting in improved accuracy and reduced turnaround times. Objective: 1. Monitor SEO performance and meta data for competitive benchmarking 2. Perform NLP-based sentiment analysis and classification on unstructured text 3. Automate price comparison across competitors and product lines 4. Extract insights from legal documents using NLP techniques 5. Validate and transform regulatory Excel reports for accuracy and timely delivery Key Achievements: 1. Developed an SEO monitoring tool using Python’s Scrapy, extracting 5,000+ HTML links per keyword 2. Tracked title and meta tags for the top 100 Google search results 3. Deployed on Raspberry Pi for scheduled bi-weekly analysis 2. Built a sentiment analysis model using Python NLP to classify employee reviews 3. Automated competitor price tracking via web scraping and analysis in Python and Visualized results using Power BI, reducing analysis time by 25% 4. Used NLP and Google API to extract key concepts and summarize legal content Benefits Delivered: ✔️ Automation of repetitive and complex analysis tasks ✔️ Faster decision-making through real-time and scheduled reporting ✔️ Increased accuracy in legal, pricing, and regulatory data workflows ✔️ Reduced manual intervention and report turnaround times ✔️ Scalable solutions ready for integration across departments
Associate Process Manager
janv. 2019 - juil. 2020
1 an 7 mois
Pune, Maharashtra, Inde
Skills: Software Development · Data Management · SQL · Microsoft Access · Data Visualization
Senior Executive
juil. 2018 - janv. 2019
7 mois
Pune, Maharashtra, Inde
Skills: Software Development · Visual Basic for Applications (VBA) · Data Management · Data Visualization · Data Mining
Senior Data Analyst | VBA Developer
Credit Suisse
sept. 2017 - juil. 2018
11 mois
Kharadi Pune
I successfully transformed the financial reporting process at Credit Suisse, achieving notable improvements in efficiency and accuracy. Objective : Automate and streamline Excel-based financial reporting using VBA scripting and advanced data analysis techniques to improve accuracy, reduce manual workload, and speed up delivery cycles. Key Achievements : 1. Automated regulatory reports using VBA, reducing preparation time by 40% and minimizing manual interventions 2. Developed Excel dashboards for tracking KPIs and monthly financial summaries using dynamic formulas and pivot tables 3. Built validation scripts to detect data inconsistencies and automate error flagging 4. Integrated external data feeds for daily refresh and reconciliation processes 5. Enabled version control and auto-backups for audit compliance Benefits Delivered : ✔️ Cut reporting turnaround time by 30–40% ✔️ Improved accuracy and compliance across finance reports ✔️ Increased transparency and traceability for audit readiness ✔️ Freed up analyst time for value-added tasks
Senior Data Analyst | VBA Developer
HSBC
juil. 2016 - juil. 2017
1 an 1 mois
Pune, Maharashtra, Inde
I played a pivotal role in transforming HR data management at HSBC Services Ltd., leading to enhanced operational efficiency. Objective : Automate HR data processing, reporting, and analytics to improve data accuracy, reduce manual workload, and provide actionable insights for HR leadership. Key Achievements : 1. Automated generation of HR reports using Excel VBA, reducing manual update time by 40% 2. Developed dashboards to track employee turnover, recruitment metrics, and training compliance using dynamic Excel tools 3. Implemented data cleaning and validation processes to ensure HR data accuracy and consistency 4. Integrated data from multiple HR systems for consolidated reporting and improved workforce analytics 5. Provided regular insights and forecasts to support HR strategic planning Benefits Delivered : ✔️ Increased reporting efficiency and accuracy ✔️ Enabled proactive workforce management through timely insights ✔️ Reduced errors and improved data governance in HR processes ✔️ Enhanced collaboration with automated, standardized reports
Senior Quality Executive
Eclerx Sevices Private Limited
déc. 2012 - juil. 2016
3 ans 8 mois
Hinjewadi · On-site
I successfully led initiatives to enhance data quality and reliability, resulting in measurable improvements for client projects. • Developed and executed quality assurance protocols that improved dataset accuracy by 25%. • Trained team members on best practices in data management, fostering a culture of quality within the organization. • Collaborated with stakeholders to align data quality objectives with business goals, ensuring compliance and informed decision-making.
MIS Executive
RBS Multicare Pvt.Ltd
avr. 2010 - déc. 2012
2 ans 9 mois
⦁Preparation of Daily/Weekly/Monthly MIS reports. ⦁ Creating corporate design, business stationery, brochures, and marketing collateral that profitably created and good impact. Also Responsible for designing Pop-Up & Event using HTML. ⦁ New client acquisition, providing services to existing client. ⦁ Maintain a good repo with clients. ⦁ Conceptualize, design and implement MIS reports as required by management information needs. ⦁ Good hands on with Excel tools like V-Look up, H-Look-up, Pivot charts and Graphs.
Formation
IDRAC Business school
Master of Business Administration - MBA
2021 - 2022
1 an 1 mois