Utsav Chaudhary
Pune
Summary
Dynamic Team Lead at Digitide Solutions with a proven track record in optimizing workflows and enhancing operational efficiency. Expert in SQL and Power BI, I leverage data-driven insights to drive team performance and exceed client expectations. A creative problem solver, I excel in fostering collaboration and delivering impactful results.
Overview
5
5
years of professional experience
Work History
Team Lead
Digitide Solutions
Pune
05.2023 - Current
- Accomplished Team Leader with extensive experience managing a high-performing team of 15+ professionals in fast-paced operations.
- Liaised between client and team, ensuring expectations were met while collaborating with departments and management to implement feedback-driven improvements and address operational challenges.
- Expert in leveraging advanced Excel functions and Power BI to deliver actionable insights, optimize workflows, and enhance operational efficiency.
- Developed Python automation code to extract data from Outlook mails using the graph api, streamlining report creation.
- Used pandas for data cleaning and transformation, creating actionable reports that informed decision-making.
- Worked at Conneqt Business Solutions, supporting operational goals.
- Tech Stack: Python || Pandas || Excel || AWS s3 || Team Management || Workflow Management
Marketing Collaborator + Video Editing of Promotional Ad's + App Bugs Finding Intern
COLCO
02.2021 - 05.2021
- Assisted in content development: Created and edited content for blogs, social media posts, email campaigns, newsletters, and website content to enhance audience engagement.
- Gathered performance data: Tracked marketing metrics and key performance indicators (KPIs) like website traffic, conversion rates, and campaign results to inform strategy adjustments.
- Assisted in report creation: Compiled data for monthly or quarterly marketing reports and presented findings to the team to support data-driven decision-making.
- Conduct competitor analysis: Gather information on competitors' marketing strategies and assess their strengths and weaknesses.
- Tech Stack: Power BI | Excel || Word || Power point
- Areas of Responsibility: Managing a team of 3, Designing, Building, Delegating, and Reviewing tasks.
Education
B.Tech - Computer Science and Engineering
Sandip University
Nashik, Maharashtra08-2021
Skills
- Leadership
- Teamwork
- Strategic Thinking
- Problem Solving
- Python
- SQL
- AWS
- MS Excel
- Power BI
- Data visualization
- Tableau
Accomplishments
- Participated in National Level COEP Zest 2018 in basketball, cricket, table tennis, badminton, and ball badminton.
- Secretary of SUN TREKKING CLUB and member of SUN HELPING HANDS of our SUN.
- In the HR committee of our SANDIP FOUNDATION Have Organized GANESH UTSAV 2K19, DANDIYA NIGHTS 2K19 for the campus and EXCUBERANCE 2K20 for department level.
- Volunteer in NIRBHAYA MARATHON 2K20 is organized by NASHIK POLICE (3KM, 5KM and 10 KM).
Hobbies and Interests
- Cricket
- Event Management
- Basketball
Projects
- Sales Insights, Python, SQL, Power BI, Utilized Python with Selenium and Beautiful Soup to scrape and gather data from a website., Developed an interactive Power BI dashboard to analyse sales trends of hardware products based on the extracted data., Delivered a user-friendly dashboard that effectively visualized sales patterns, enabling data-driven decision-making.
- Festive Sales Data Analysis, Python, Pandas, SQL, Crawled daily prices of products from e-commerce websites during festive sales offers and loaded them into the SQL tables., Using crawled data, a report is created to understand the price variation of products during offers., With the help of pandas, transformed data using group, merge, and melt functions.
- Web Scraping and Analytics Project, Python, Pandas, SQL, AWS (S3), Selenium, Developed web crawlers to extract sponsored product data from various e-commerce platforms, including Google search results., Utilized Python libraries such as requests, Selenium, and Beautiful Soup to scrape website data while ensuring compliance with robots.txt., Stored extracted data in multiple formats, including flat files and databases, for further processing., Designed crawlers to collect comprehensive product information, including company product lists, brands, and detailed product pages., Gathered product reviews for sentiment analysis to derive consumer insights., Worked with HTML DOM, using XPath and regular expressions to extract relevant data efficiently., Debugged existing code and developed new scripts to enhance data-crawling processes., Built and maintained Python-based scrapers and crawlers to fetch website data, exporting results to CSV, Excel, or databases for seamless integration., Leveraged stored data for reporting and analytics, tracking price fluctuations of selected products, and generating price trend reports using pandas and SMTP for sending emails., Used pandas and SQL to perform analysis and derive required KPIs from the data.
Languages
- Hindi
- Marathi
- English
Certifications And Courses
- Software Testing (pursuing) at QSpider
- POWERBI AND ADVANCE EXCEL SPECIALIZATION, LET'S DO IT FOR YOU (LUDIFU), 2021-2022, Pune, Maharashtra
- BIG DATA ANALYTICS, CDAC, 2021, Nashik, Maharashtra
Timeline
Team Lead
Digitide Solutions
05.2023 - Current
Marketing Collaborator + Video Editing of Promotional Ad's + App Bugs Finding Intern
COLCO
02.2021 - 05.2021
B.Tech - Computer Science and Engineering
Sandip University