Summary
Overview
Work History
Education
Skills
Academic Project Experience
Project
Timeline
Generic

VENKATA JAYA NIKHIL KUSUMANCHI

Hyderabad,Telangana

Summary

Data Conversion Specialist with 2+ years of experience in data extraction, transformation, and integration for client data migration. Proficient in Python and SQL, with expertise in Snowflake and Apache Airflow for efficient data processing. Skilled in data analysis, regression analysis, and business analytics using tools like PowerBI and Tableau. Experienced in collaborating with cross-functional teams to define metrics and resolve complex data challenges.

Overview

2
2
years of professional experience

Work History

Data Conversion Specialist (Member Technical)

ADP
Hyderabad
03.2021 - 08.2023
  • Extracted and transformed client data from various ERP systems using Python and SQL to maintain data integrity.
  • Identified and resolved data inconsistencies delivered standardized datasets for integration into ADP.
  • Automated data analysis processes using Excel, Pandas, and Apache Airflow, achieving a 40% reduction in manual workload.
  • Utilized advanced statistical methods and regression models to improve salary-hike forecasts by 30% accuracy.
  • Developed an end-to-end ETL pipeline to extract high-volume transactional data from SAP HANA to Snowflake via Amazon S3.
  • Created Power BI dashboards that monitored organizational metrics, supporting efficiency trends and financial summaries.
  • Coached a 14-member team on data quality assurance principles, contributing to successful project outcomes.
  • Provided strategic insights to executive leadership, influencing key business decisions effectively.

Education

Master of Science - Information Science

University of North Texas
Denton, TX
05-2025

Skills

  • Programming languages: Python, SQL, web scraping, HTML/CSS
  • Tools & Skills: Snowflake, Power BI, RDBMS, Apache Airflow, AWS, Excel, Google Sheets, Statistical Data Analysis, Data Cleaning, Data Analysis, Data Visualizations, Data Engineering, Data Warehousing, Machine Learning, Applied AI

Academic Project Experience

End-to-End Automated Real Estate Data Pipeline:

  • Created a Python-Selenium webscraper, scheduled via Apache Airflow, that harvests nearly 10 K new property listings per day from “99acres.com”.
  • Landed raw files in AWS S3 and streamed them into Snowflake with Snowpipe, layering RAW → STG → DM tables for scalable analysis.
  • Applied SQL, Streams, and Tasks to cleanse data, achieving >99% data-quality compliance for analytics.
  • Integrated Snowflake to Power BI, built DAX-driven dashboards that surface real-time price trends and cut manual reporting effort by 80%.

Project

Sentimental Analysis and Recommendation system of Swiggy Restaurants:

  • Built a multithreaded Python scraper (Requests / BeautifulSoup/ Selenium) that harvested 15 K Swiggy restaurant profiles and 200 K customer reviews, exporting raw CSV files for repeatable loads.
  • Normalized cuisine, location, and pricing attributes, token-cleaned and lemmatized review text with Pandas and NLTK, producing analytics-ready tables for NLP and recommendations.
  • Employed NRCLex to generate polarity, emotion scores and ran T-tests & ANOVA to surface statistically significant satisfaction leaders, revealing a 12% sentiment gap between top and mid-tier outlets.
  • Designed a content-based recommender that encodes cuisine and locality vectors and applies cosine similarity, delivering top-10 restaurant suggestions

Timeline

Data Conversion Specialist (Member Technical)

ADP
03.2021 - 08.2023

Master of Science - Information Science

University of North Texas

Similar Profiles

CREATE PROFILE
VENKATA JAYA NIKHIL KUSUMANCHI