Katyayani Jandhyala
I’m a passionate business analytics enthusiast on a quest to explore uncharted territories in data science and deliver value-driven solutions across diverse domains. I live in Urbana Champaign, Illinos
Hi there! I'm
I'm open to work immediately.
I am currently working as a Teaching Assisstant at University of Illinois Urbana-Champaign, US
I am proficient in Python, R and SQL. My field of Interest’s are building efficient ETL pipelines and also in areas related to Data and Business Analysis, Machine Learning and Cloud Computing. I have also extended my passion for developing smart data products using Python and Modern Big Data Frameworks like Hadoop, Hive and SAS, and deployed them on cloud platforms like AWS and GCP. Furthermore, I have also generated visualizations of my analyzed data on platforms like Tableau.
Please find below my Tech Stack and Skills:- Languages: Python, R, SQL
- Containerization & Orchestration: Docker, Kubernetes
- Business Intelligence Tools: Microsoft Excel, Google Sheets, Tableau, Microsoft PowerBI, SAS
- Big Data Technologies: Apache Hadoop, Apache hive, Apache Airflow, Apache Spark, Apache Nifi
- Soft Skills: Mentorship, Multi-Cultural Fluency, Team Player, Leadership
- Version Control Tools: Git, Github
- Database Technologies: Oracle, PL/SQL, PostGresSQL, Redis
- Cloud Technologies: AWS, Azure, Google Cloud Platform
Education
- currently a Teaching Assistant for Big Data at the Gies College of Business - University of Illinois Urbana-Champaign
- Course Work: Revenue Management, Business Practicum, Enterprise Database Management, Big Data Infrastructures, Supply Chain Analytics, Data Science and Analytics, Project Management, Marketing Analytics, Data Storytelling, Big Data Analytics in Finance.
Post Graduate Degree, Data Science with specialization in Deep Learning
-
International Institute of Information Technology
Mar 2020 - Apr 2021
- Pursued Data Science with concentration Deep Learning
- Course Work: Discriminative, Generative and Hybrid Learnings, Big Data Technologies, Cloud Architectuaral Design and Implementation
- Developed visualization and reporting dashboards, Time-Series Forecasting models, Demand Forecasting models etc
- Graduated from Computer Science and Engineering (SCOPE) at VIT University, Vellore with a CGPA of 3.4. During my studies
- Course Work: Machine Learning, Artificial Intelligence, Data Mining, Cyber Security, Network and Communication, Image Processing, Content Based Image and Video Retrieval, Parallel and Distributed Computing,Green and Energy Aware Computing, Theory of Computation, Object Oriented Programming in Python, Software Engineering, Sensors and Instrumentation, Internet of Things, Database Management Systems, Mass Media and Society, Principles of Marketing, Lean-Startup Management, Calculus, Statistics and Probability, and Linear Algebra.
- Board Member at IEEE-TEMS Chapter
- Innovations Intern at TIFAC-CORE in Automotive Infotronics
- Qualified for Silver & Bronze Echelon at Hack4Cause - a 24 hours Hackathon at the 16th International Conference on Science,Engineering and Technology (ICSET 2018)
Experience
Jan 2023 - May 2023
Project Intern, Business Practicum
Wolters Kluwer
Champaign, Illinois, United States
- Performed customer segmentation of large data sets using entity resolution recommendations system for anomaly detection, optimizing accuracy by deep learning with Pytorch, Keras and TensorFlow
- Implemented A/B optimization to compare parallelized processing reducing processing time from 2 hours to 50 minutes
- Leveraged advanced topic modeling techniques such as Latent Dirichlet Allocation (LDA) and guided LDA to effectively analyze copious amounts of ticketing data from multiple global regions
- Employed unsupervised machine learning algorithms to accurately classify tickets into their respective issue categories, streamlining the issue resolution process for faster turnaround times
Mar 2020 - Aug 2021
Senior Data Analyst
Ganit Inc
Chennai, Tamil Nadu, India
- Developed and deployed Tableau dashboards to track 30+ KPIs for hypermarkets, providing a data-driven platform for business stakeholders and, also, reduced weekly man hours by 66.7%
- Led the migration from SQL Server to Redshift using Amazon Athena & S3, resulting in an annual cost savings of $14,000& increased performance of 23%
- Spearheaded the design and implementation of a Jenkins-based CI/CD pipeline for a prominent retail e-commerce client. This innovative solution seamlessly integrated Docker and Kubernetes, delivering remarkable results—a remarkable 40% reduction in deployment time while fortifying security through robust Identity and Access Management (IAM) policies
- Led a data integration initiative, extracting and standardizing data from 40+ sources into a unified format via the creation of 5 ETL packages using Oracle PL/SQL. Further, developed database applications, using Packages, Functions, Procedures, Triggers in PL/SQL, with a strong background in troubleshooting, and performance tuning.
- Developed data pipelines through Apache Airflow automated python scripts to integrate and transform disparate data sources to a centralized database.
- Built & maintained the data pipeline with up-time 95 % while ingesting transactional data across 6 data sources using Apache Spark, Nifi & Hive
- Utilized customer segmentation and look-a-like profiles to generate actionable insights for optimization of campaign and store performance, maximizing return on advertising costs by 22%
July 2019 - Feb 2020
Data Analyst
Boston Consulting Group
Bengaluru, Karnataka, India
- Developed end-to-end credit risk scorecards with Python programming to predict customer default rate for auto loans which decreased loan approval period from 2 days to 10 seconds.
- Implemented an advanced personalized recommendation and offer generation tool targeted for the TMT practice area based on a collaborative filtering model in Python.
- Led supply chain optimization project by developing demand forecasting models to identify supply-demand disruptions to establish optimal product stock replenishment norms, resulting in increased operational efficiency and cost savings.
May 2018 - July 2018
Software Engineer Intern
ECIL
Hyderabad, Telangana, India
- Developed Human - Emotion Recognition App, to identify and analyze facial expressions of employees at work place.
- Assessed employees’ work interest, productivity, and contribution to the industrial sector, thereby determining the benefits of their involvement.
Projects
Retail Analytics - Product Performance
In the retail supply chain business, the category managers often require a concise overview of product sales performance across their different markets. This helps them differentiate between fast-moving and slow-moving consumer goods, allowing them to optimize their Terms of Trade (ToT) with suppliers.
Spotify Wrapped
The Spotify Wrapped dashboard delves into a users listening patterns, revealing their most frequently played tracks, genres, top artists, and preferred listening hours. It also takes a retrospective look at their listening habits over the past few years.
Airbnb Price Estimator
Airbnb hosts frequently face bottlenecks in determining appropriate pricing for their listings when compared with market trends. Recognizing the significance of listing location, room types, and availability as key determinants,I have developed a regression-based predictive model to estimate the pricing of new listings based on their specific characteristics.
Lead Scoring Use Case
Lead scoring is a pivotal metric for assessing leads and has become a standard in contemporary CRM systems. Within this repository, we delve into how the lead scoring strategy helps solve customer conversion problems, exploring the application of various supervised machine learning models.
Get In Touch
My inbox is always open. Whether you have a question or just want to say hi, I’ll try my best to get back to you!