Krushna Shamrao Pawar
Aurangabad
Summary
Senior Data Analyst with 3+ years of expertise in Python, SQL, and Data Analytics, specializing in web scraping, process automation, and business intelligence. Experienced in developing end-to-end data pipelines, cloud storage solutions (GCS), visualization tools (Power BI, Tableau), and advanced analytics frameworks (Pandas, Keras). Past experience of AI-driven solutions, with hands-on experience in machine learning, data validation, and full-stack integration using Fast API.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
eClerx Services Ltd.
08.2023 - Current
- Designed a system to track client planogram for their authorized partners performance of countries from APAC and EMEA
- Led a team of 7 analysts to implement a scalable planogram tracking system for 15+ APAC/EMEA countries, improving and maintaining compliance within 6 months
- SKU-to-URL Mapping: Managed mapping of client SKUs to dynamic product URLs, enabling real-time monitoring of Share of Search (SOS), pricing compliance, and product availability metrics
- Performance Analytics: Delivered monthly reports on regional category performance, partner KPIs, and price deviation analysis, driving strategic adjustments to maximize client revenue and market share
- Process Automation: Built Python scripts to automate data collection, validation, and report generation, reducing manual effort by 70% and ensuring error-free delivery of insights on seller ratings, image compliance, and product availability
- KPI Optimization: Managed weekly tracking of client 3P partners performance on key metrics such as image count and seller ratings, using Amplify reports to highlight actionable areas
- Competitive Benchmarking: Developed and managed weekly reports for clients, analyzing and comparing the performance of their products with their competitors
- Focused on critical parameters including pricing, specifications and product features
- Provided actionable insights to help optimize product strategies and identify areas for competitive advantage
- Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
- Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
Senior Data Analyst
eClerx Services Ltd.
06.2022 - Current
- Automated Data Extraction: Developed Python web scraping solutions using requests and Selenium libraries to extract structured data from 30+ e-commerce websites across the Middle East, aligning with client-specific requirements
- Data Pipeline Management: Engineered end-to-end data workflows, including daily automated product data reporting and quarterly full-site crawls, with seamless integration into Google Cloud Storage (GCS) for client access
- Quality Assurance: Conducted comprehensive data validation audits to ensure 95%+ accuracy, refining scripts to resolve discrepancies and enhance data reliability for client decision-making with help of automated python script for validation
- Client-Centric Insights: Analyzed extracted datasets to identify market trends, pricing patterns, and product availability, delivering actionable recommendations that informed client inventory and sales strategies
Education
PG Diploma - Big Data Analytics
CDAC’s Institute For Advanced Computing & Software Development
Pune, Maharashtra05.2022
Bachelors - Instrumentation and Control Engineering
Jawaharlal Nehru Engineering College
Aurangabad, Maharashtra08.2018
Skills
- Python
- SQL
- Pandas
- Requests
- Power BI
- Advanced Excel
- PyCharm
- Rapport Building
- People Management
- Cross-functional Collaboration
Languages
English
Marathi
Hindi
Personal Information
- Date of Birth: 10/05/96
- Nationality: Indian
Disclaimer
I hereby declare that the information given above is true to the best of my Information knowledge belief.
Skillssummary
Python, SQL, Pandas, Numpy, Scikit-Learn, Matplotlib, requests, FastAPI, Power BI, Excel, PowerPoint, Tableau, MySQL, MongoDB, PyCharm, Jupyter Notebook, Visual Studio Code, Intellij IDEA, Rapport Building, People Management, Excellent communication, Cross-functional Collaboration
Certification
NISM-Series-VIII: Equity Derivatives Certification
Hobbies
I love watching and playing football.
I love reading books.
Timeline
Senior Data Analyst
eClerx Services Ltd.
08.2023 - Current
Senior Data Analyst
eClerx Services Ltd.
06.2022 - Current
NISM-Series-VIII: Equity Derivatives Certification
PG Diploma - Big Data Analytics
CDAC’s Institute For Advanced Computing & Software Development
Bachelors - Instrumentation and Control Engineering
Jawaharlal Nehru Engineering College
Similar Profiles
Rex JohnRex John
Senior Financial Analyst at Eclerx Services Ltd.Senior Financial Analyst at Eclerx Services Ltd.
Raj KhotRaj Khot
Process Manager at eClerx Services Ltd.Process Manager at eClerx Services Ltd.
Sayli TelangeSayli Telange
Senior Analyst at eClerx Services Ltd.Senior Analyst at eClerx Services Ltd.