Data Analyst (Feb, 2022
–Mar, 2024) at Sheetal Group
• Engineered a Python automation solution using Selenium that effectively replaced the tasks of four team members, resulting in a substantial 100-hour weekly reduction, or 20 hours per day. Received recognition and appreciation from my manager for this successful automation implementation.
• Produced an average of 8 monthly reports using Power BI and Advanced Excel spreadsheet functions, which were meticulously distributed throughout upper management.
• Proficiently collected and analyzed extensive data, creating numerous Pivot tables for in-depth examination.
• Leveraged Excel's diverse functions, including Vlookup, Index-Match, SumIfs, and If, Iferror, to process and organize over 20,000 to 30,000 data entries.
• Utilized Visual Basic for Applications (VBA) in MS Excel to automate the extraction of distinct data segments, creating separate files in specified formats.
• Conduct in-depth Market analysis, examining pricing strategies of 15+ competitors, and correlating these data with sales metrics. Use supply-demand trends to optimize pricing, resulting in a significant revenue increase
• Delivered real-time market data for senior management through automated extraction and report generation using Power Query, enabling efficient analysis and a notable 50% reduction in data analysis time
• Generated over 15 ad hoc reports using Excel formulas, establishing a streamlined process for future reporting, saving valuable time and effort.
• Created and maintained interactive dashboards and reports for 3 different teams within the organization, facilitating data-driven decision-making and collaboration.
• Effectively led a team of 5 members by assigning tasks, monitoring progress, and ensuring timely completion of projects.