Sonali Gupta
Projects And Reporting Analyst at Vensysco Technologies Limited
Noida, Uttar Pradesh, India
Summary
👤
Senior🎓
Top SchoolSonali Gupta is an experienced projects and reporting analyst with 11 years of expertise turning complex datasets into actionable business insights using Power BI, SQL, ETL, and advanced Excel. She has driven large-scale HR analytics initiatives—consolidating data from 25 plants and maintaining records for 10,000+ employees—while building interactive dashboards that inform operational decisions. Sonali blends hands-on technical work with content creation, running a YouTube channel that demystifies Excel, SQL, and Power BI through practical case studies. Her open-source contributions include maintaining Zotero translators, demonstrating strong web-scraping and data-extraction skills applied to real-world sites like The Economic Times and the BBC. Comfortable in both corporate and independent settings, she pairs a BE in Information Technology with a Master’s in Business Analytics to bridge business needs and technical solutions. Always open to collaboration, she focuses on delivering precise, scalable reporting that drives measurable improvements.
11 years of coding experience
PCM, PCM at A.M.I. Shishu MandirBachelor of Engineering - BE, Information Technology, 8.10, Bachelor of Engineering - BE, Information Technology, 8.10 at ITM Gwalior
English, Hindi
Stackoverflow
494reputation
50kreached
1answer
58questions
Github Skills (18)
javascript10
translater10
webscraping10
html-parsing10
translate10
data-extraction10
translator10
translators10
css-selectors9
regular-expression8
apache-poi6
recursion6
binary-search-tree6
apache-commons6
acl6
Programming languages (8)
Github contributions (5)
zotero/translators
Mar 2017 - Nov 2017
Zotero Translators
Role in this project:
Full-stack Developer
Full-stack DeveloperContributions:8 commits, 8 PRs, 26 comments in 8 months
Contributions summary:Sonali primarily contributed to the development and maintenance of Zotero translators, which involve parsing and transforming data from various websites into a Zotero-compatible format. Their commits demonstrate a strong understanding of web scraping techniques and data extraction processes. The user added, updated, and debugged translators for diverse websites such as The Economic Times, The Open Library, The Globe and Mail, and the BBC. This required adapting to site changes and ensuring accurate data retrieval.
translatorstranslationzotero
sonali0901/summervacation
May 2015 - Aug 2019
Contributions:23 pushes, 1 branch in 4 years 3 months
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.