Shital Sonare
Pune
Summary
Dynamic data analytics professional with proven expertise in leveraging advanced Excel, Tableau, Power BI, and SQL to drive decision-making at ExcelR Solutions. Skilled in transforming complex datasets into actionable insights, reducing manual effort by up to 50%. Demonstrates exceptional collaboration and strategic talent acquisition, enhancing recruitment efficiency and employer branding.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Data Analytics Intern
ExcelR Solutions
Bangalore
04.2024 - Current
- Analyzed large datasets using MySQL to extract actionable insights, identify trends, and support decision-making processes.
- Cleaned and transformed raw data using SQL and Excel for integration into reporting systems.
- Maintained data pipelines for seamless extraction, transformation, and loading (ETL) into dashboards and reports.
- Created dynamic and interactive dashboards in Power BI and Tableau to visualize key performance indicators (KPIs), and business metrics.
- Designed and automated comprehensive reports in Excel, leveraging advanced functions (Pivot Tables, VLOOKUP, INDEX-MATCH), and macros for efficiency.
- Used Power Query in Excel to clean, transform, and merge datasets from multiple sources, ensuring data consistency, and accuracy.
- Created pivot tables to summarize and analyze complex datasets, allowing for quick insights into trends and performance metrics.
- Leveraged slicers and calculated fields in Pivot Tables to provide flexible and detailed data exploration for stakeholders.
- Developed visualizations in Tableau and Power BI to present data in a clear and compelling manner for stakeholders.
- Ensured dashboards provided real-time updates, drill-down capabilities, and intuitive navigation for non-technical users.
- Wrote complex SQL queries to retrieve, join, and aggregate data across multiple tables to solve KPIs.
- Automated repetitive data tasks using Excel VBA and Power Query, reducing manual effort by up to 50%.
Talent Acquisition Consultant
Synechron Technologies | Niyuj Software | Magna Resource Consultant
Pune
07.2013 - 10.2023
- Managed the complete recruitment lifecycle, including job posting, sourcing, screening, interviewing, and onboarding for various roles across departments
- Developed talent pipelines by leveraging platforms such as LinkedIn, Naukri, and internal databases to identify and engage with high-caliber candidates
- Collaborated with hiring managers and leadership to understand workforce requirements, define job specifications, and deliver tailored hiring strategies
- Conducted competency-based interviews, psychometric evaluations, and reference checks to ensure candidate alignment with organizational values and job requirements
- Negotiated compensation packages and facilitated a seamless onboarding process, including orientation programs and compliance with HR policies
- Enhanced employer branding initiatives by promoting the organization on social media and participating in job fairs and campus recruitment drives
- Utilized applicant tracking systems (ATS) and HR analytics to monitor recruitment metrics such as time-to-fill, cost-per-hire, and quality of hire, and implemented strategies for continuous improvement
- Streamlined recruitment processes to improve efficiency and candidate experience through automation and technology adoption
Education
MBA - Human Resource, Finance
DAIMSR
Nagpur06.2013
B.Sc. - Computer Science, Information Technology
KZS
Nagpur06.2011
Skills
- Advanced Excel
- Power BI
- Python
- MySQL
- Tableau
- Power Query
- Pivot Table
- ETL Process
- Data Visualization
- SQL
- Data Modeling
- VBA
- Micros
Projects
Adventure Works Data Analytics
- Adventure Works data analytics project, which focuses on analyzing various business aspects of Adventure Works Cycles, a fictional company created by Microsoft.
- The project aims to utilize data analytics tools to derive insights from the company's sales, production, and inventory data.
Bank Analytics Data Analytics
- Bank Analytics Data Analytics Project, which focuses on analyzing banking data to derive insights that can aid in decision-making and improve financial performance.
- The project utilizes a dataset that simulates various banking transactions and client information.
Zomato Data Analytics
- Zomato Data Analytics Project, which focuses on analyzing restaurant data from Zomato to extract insights into customer preferences, dining trends, and restaurant performance.
- The project leverages tools such as Excel, MySQL, Power BI, and Tableau to conduct comprehensive data analysis.
Certification
- Data Analyst Certification presented by ExcelR, Pune
- Internship Certification presented by AI Variant, Banglore
Hobbies and Interests
- Reading
- Badminton
Languages
- English, 80/100
- Marathi, 100/100
- Hindi, 80/100
Timeline
Data Analytics Intern
ExcelR Solutions
04.2024 - Current
Talent Acquisition Consultant
Synechron Technologies | Niyuj Software | Magna Resource Consultant
07.2013 - 10.2023
MBA - Human Resource, Finance
DAIMSR
B.Sc. - Computer Science, Information Technology
KZS
Similar Profiles
Naveen RachakondaNaveen Rachakonda
QA Automation Engineer at ExcelR SolutionsQA Automation Engineer at ExcelR Solutions
AAVEZ SHAIKHAAVEZ SHAIKH
Inside Sales Manager at Excelr SolutionsInside Sales Manager at Excelr Solutions
Gokul Prasanna Gokul Prasanna null
Java Full Stack Developer at excelR SolutionsJava Full Stack Developer at excelR Solutions