Message

SNEHA BHATTACHARYA

 Detail-oriented data analyst with over 3.8 years of experience in data collection, analysis, and visualization, including specialized expertise in web scraping. Skilled in using various analytical tools and software, such as Excel, SQL, and Python, to interpret and manage complex datasets. Demonstrates proficiency in developing and implementing web scraping solutions to extract valuable data, tackling challenges such as captcha resolution and dynamic content. Proven ability to identify trends, patterns, and insights that drive informed business decisions. Adept at creating detailed reports and visualizations using tools like Tableau and Power BI to communicate findings effectively. Strong problem-solving skills, excellent attention to detail, and a collaborative team player dedicated to optimizing data processes and supporting strategic initiatives. 

Key Skills

SQL
Python
Pandas
Web Scraping
Scrapy
BeautifulSoup
Selenium
Numpy
Flask
Web Crawling
Power BI
Matplotlib

Professional Experience

Oct 2021
Present
Data Analyst
Forage AI New York, US
Data Automation
  
  • Web Scraping and Data Extraction: Developed and implemented web scraping tools to extract data from diverse online sources, resolving challenges such as captcha and dynamic content. Ensured data integrity, accuracy, and consistency through robust monitoring systems.
  • Client Collaboration: Partnered with clients to understand their business challenges and deliver tailored data-driven solutions. Designed and executed efficient crawling architectures to meet specific data needs.
  • Data Management: Fetched, cleansed, and stored data regularly, maintaining high standards for data quality and usability. Ensured ongoing data health and integrity.
  • Cross-Functional Collaboration: Worked with cross-functional teams to understand business requirements and deliver effective data solutions. Communicated insights to stakeholders to support informed decision-making.
  • Analytical Tools and Reporting: Proficient in Excel, SQL, and Python for data management and analysis. Created detailed reports and visualizations using Tableau and Power BI to effectively present data insights.
  • Problem-Solving and Optimization: Applied strong problem-solving skills and attention to detail to optimize data processes. Provided actionable insights and recommendations based on comprehensive data analysis.

Projects:
 
Healthcare Data Aggregation(Python Web Scraping):
  • Implemented a comprehensive web scraping solution using Python to gather critical data from diverse healthcare sources.
  • Adding SQL script for automation QA to flag the error patterns in the output.
  • Data cleaning using python scripts.
 
LLM based identification and extraction of wedding packages from websites:

       Build a page navigation process to identify the page where relevant and structured data can be found. 
       Keyword Matching: Extract all the URL from a website and narrowing down to relevant pages where structured data can be found using keywords matching in the URL path. 
       Metadata Analysis: Further locating presence of specific elements in the html of the URLs usually found in structured data. 
       Developed a prompt tailored to extract specific details related to wedding packages from target webpages. 
       Achieved reduction in time and cost when compared to XPath based extraction. 
 




Sep 2020
Aug 2021
Data Analyst Trainee
Marico Kolkata, IN
Automation
 
  • Research and Data Procurement: Executed both primary and secondary research methodologies, including web scraping, to gather data on market trends, industry shifts, and competitor activities.
  • Data Analysis and Insight Generation: Employed statistical methods and software tools to analyze scraped data, uncovering pertinent patterns, trends, and correlations essential for achieving business objectives.
  • Market Trend Analysis: Analyzed market trends and industry shifts through comprehensive data collection and analysis, providing actionable insights to inform business strategies.
  • Competitive Analysis: Monitored and assessed competitor maneuvers using scraped data, delivering strategic recommendations to maintain competitive advantage.
  • Statistical Tools Proficiency: Utilized advanced statistical methods and software tools such as Python and SQL to perform data analysis and generate meaningful insights that support business goals 


Education

May 2018
May 2020
PGDM in THIAGARAJAR SCHOOL OF MANAGEMENT
KAMARAJA UNIVERSITY
Aug 2014
Jun 2017
Bachelor of Science in Hooghly Mohsin College
Burdwan University

Get in touch with SNEHA