Pawan Verma Email & Phone Number

Madhya Pradesh, India

Kolkata, West Bengal, India

●Employed SQL techniques such as CTEs, subqueries, joins, and window functions alongside Python libraries including pandas, numpy, os, openpyxl, and matplotlib to analyze data from 10+ political campaigns. Identified key trends and optimized targeting strategies. ●Automated 25+ reports for various campaigns, ensuring alignment with Key Performance Indicators (KPIs) to facilitate streamlined decision-making. Employed Python scripting and task scheduling for implementation● Developed a… Show more ●Employed SQL techniques such as CTEs, subqueries, joins, and window functions alongside Python libraries including pandas, numpy, os, openpyxl, and matplotlib to analyze data from 10+ political campaigns. Identified key trends and optimized targeting strategies. ●Automated 25+ reports for various campaigns, ensuring alignment with Key Performance Indicators (KPIs) to facilitate streamlined decision-making. Employed Python scripting and task scheduling for implementation● Developed a strategic war room using Google Sheets automation for West Bengal, covering each of the 7 phases of the 2024 general election, to estimate vote shares among different parties.●Processed OCR text data from 80,000 West Bengal electoral roll PDFs using Python pytesseract. Led a team to verify and cleanse the data, ensuring accuracy and reliability. Show less

Kolkata, West Bengal, India

● Utilized SQL and Python to analyze data across various political campaigns, identifying key trends, and optimizing targeting strategies. Automated reports aligned with Key Performance Indicators (KPIs) to streamline decision-making processes● Scraped data from various websites according to specific requirements.● Assisted in crafting report formats for campaigns by comprehending client needs.● Developed Python scripts for daily and cumulative outbound leads to… Show more ● Utilized SQL and Python to analyze data across various political campaigns, identifying key trends, and optimizing targeting strategies. Automated reports aligned with Key Performance Indicators (KPIs) to streamline decision-making processes● Scraped data from various websites according to specific requirements.● Assisted in crafting report formats for campaigns by comprehending client needs.● Developed Python scripts for daily and cumulative outbound leads to facilitate smooth operation of calling survey campaigns.● Automated daily deliverable reports for diverse campaigns using Python code and task scheduler. Conducted booth-level analysis by creating Python scripts utilizing Form 20 data for elections in West Bengal.● Utilized OCR-Tesseract in Python to extract text data from approximately 80 thousand PDFs of electoral rolls for West Bengal. Led a team to verify and clean the extracted raw data. Created a user-friendly dashboard using Streamlit in Python to provide essential information to callers for a specific survey campaign.● Cleansed and matched raw mappings data from standard mapping using fuzzy lookup in MS Excel.● Generated demographic mappings for rural and urban areas in Meghalaya, Sikkim, Assam, and Bihar. Also, prepared electoral data for the last four assembly and general elections in these states.● Produced various QGIS maps tailored to specific report requirements. Show less

• Data Analysis of the United States Housing Affordability Data System• Merged and cleaned data from the American Housing Survey for the years 2005, 2007, 2009, 2011, and 2013.• Conducted hypothesis testing to compare market values between vacant and occupied houses across these years.• Developed a Linear Regression model using MS Excel to predict the market value of housing units in 2013, exploring the relationship between the dependent variable and independent… Show more • Data Analysis of the United States Housing Affordability Data System• Merged and cleaned data from the American Housing Survey for the years 2005, 2007, 2009, 2011, and 2013.• Conducted hypothesis testing to compare market values between vacant and occupied houses across these years.• Developed a Linear Regression model using MS Excel to predict the market value of housing units in 2013, exploring the relationship between the dependent variable and independent variables.• Identified significant variables influencing house prices and eliminated variables that did not impact house prices. Show less

Varanasi, Uttar Pradesh, India

● Explored multiple workshops specializing in the manufacturing and assembly of spare parts for Diesel-Electric locomotives.● Completed comprehensive training in TR, ROTOR, EES, and ETS shop areas.● Witnessed the practical application of theories learned on an industrial scale.