AMRUTA ANIL KAMBLE
Pune
Summary
Detail-oriented Data Analyst with experience in data extraction, cleaning, and analysis to support business decision-making. Skilled in SQL, Advanced Excel, and Power BI for building dashboards, performing data validation, and identifying trends. Experienced in handling large datasets, developing KPI reports, and delivering actionable insights to improve marketing and operational performance.
Overview
3
3
Languages
4
4
years of professional experience
Work History
Research Analyst
S2W Media
06.2026 - Current
- Conducted LinkedIn-based research to identify leads as per project or client requirements.
- Used tools like Sales Navigator, Apollo.io, and Hunter.io for data collection and validation.
- Analyze records using Advanced Excel (Pivot Tables, Power Query, VLOOKUP) to identify business trends.
- Automate recurring reports using VBA macros, reducing manual reporting time and improving efficiency.
Research Analyst Data Practices
XDBS Worldwide
06.2024 - 03.2026
- Extract and analyze 10K+ rows of marketing and sales data using CRM systems, campaign logs, ad servers.
- Perform ETL processes to clean, transform, and validate datasets for accurate analysis.
- Developed and maintained Excel and Power BI dashboards to track outages, resolution timelines, and operational KPIs for leadership review.
- Automate recurring reports using VBA macros, reducing manual reporting time and improving efficiency.
Support associate
IGT Solutions
05.2022 - 09.2023
- Analyzed Flight operational and customer data to generate actionable insights for business reporting.
- Cleaned and structured large datasets using Excel and SQL, enhancing clarity for analysis and reporting.
- Prepared performance reports and dashboards for stakeholders, facilitating informed decision-making.
- Maintained data quality and performed data validation to ensure accuracy in reporting.
Education
Bachelor of Engineering - E&TC
Dr. Babasaheb Ambedkar Marathwada University
Aurangabad12-2020
Diploma - E&TC
Maharashtra State Board of Technical Education
Mumbai01-2017
Skills
- Advanced Excel: PivotTables, Power Pivot, XLOOKUP/VLOOKUP, Macros, Advanced Formulas, Conditional Formatting, Charts
- Automation: VBA, Excel Automation, Workflow automation, reporting optimization, error reduction
- Data Management: Data Cleaning, Data Validation, Data Transformation, Data Accuracy Checks , Load (ETL)
- Analytical Techniques: Campaign Analysis, Trend Analysis, Root Cause Analysis, Statistical Analysis, Data Segmentation, KPI & performance reporting
- Business & Collaboration: Stakeholder Management, Requirements Gathering, Executive Reporting, Cross-functional Collaboration
- AI Tools: ChatGPT, Microsoft Copilot (AI Agents)
- Power BI
Websites, Portfolios, Profiles
https://www.linkedin.com/in/amruta-kambledata-analyst
Websites, Portfolios and Profiles
https://www.linkedin.com/in/amruta-kambledata-analyst
Languages
Hindi
Marathi
English
Awards
Productivity Champ, Recognized for delivering high-volume and accurate incident resolutions while maintaining SLA compliance.
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge.
Other
Leadership & Volunteering: Mentor
Timeline
Research Analyst
S2W Media
06.2026 - Current
Research Analyst Data Practices
XDBS Worldwide
06.2024 - 03.2026
Support associate
IGT Solutions
05.2022 - 09.2023
Bachelor of Engineering - E&TC
Dr. Babasaheb Ambedkar Marathwada University
Diploma - E&TC
Maharashtra State Board of Technical Education