• Python automation of ETL process by automating data extraction, conversion and data cleaning by implementing web scraping, conversion of OCRs and readable PDFs to DataFrames and Excel sheets.• Helping the chief minister of Punjab in determining social media strategy for Punjab assembly elections 2022, by designing and developing PowerBI and excel dashboards and analyzing his social media data.• Helping various political parties of India and Ghana in getting more votes by providing… Show more • Python automation of ETL process by automating data extraction, conversion and data cleaning by implementing web scraping, conversion of OCRs and readable PDFs to DataFrames and Excel sheets.• Helping the chief minister of Punjab in determining social media strategy for Punjab assembly elections 2022, by designing and developing PowerBI and excel dashboards and analyzing his social media data.• Helping various political parties of India and Ghana in getting more votes by providing strategic inputs and solutions by using Advanced excel, SQL queries and analyzing historical data of Indian elections.• Leading the development of a successful on-site new analytical project for an Ex-CM of Uttar Pradesh, the project included data collection, data entry, data visualization through PowerBI, handling various teams, client interactions, client presentations.• Increasing the brand value of the company by leading the development of a brand value campaign project, researching and collecting data from the internet on various topics, cleaning the data, and making visualizations on Matplotlib and Visme.• Managing 8 projects, getting mobile applications and web apps developed, delivering them to clients.Technologies used - Python (Numpy, Pandas, BeautifulSoup, Selenium, Camelot, Tabula, Matplotlib), PowerBI, Qlik, Social Media Analytics, Advanced Excel, Pivot tables, Project management, Software testing, client handling, vendor handling, Presentations skills, Visme.co Show less