CHAMARTHI YASHWANTH

GEN AI ASSISTANCE TOOL

• Developed an innovative GenAI tool with Streamlit, automating the generation of user stories, tests, and SQL scripts.
• I built an AI agent and used SQLDatabaseToolkit for live DB querying, achieving 80% accuracy in user stories and test cases.

WEB APPLICATION DEVELOPMENT

• Built web application servers and APIs across Supply Chain, Logistics, and Predictive Maintenance using Python, Flask, MSSQL, and DGraph, with ORMs and ODBC for efficient data access.
• Implemented advanced optimization techniques, including caching, data modeling, and indexing, resulting in a performance improvement of over 50%.
• Integrated Celery for supporting scalable background task processing.
• Led a cross-functional team of 5 or more members, ensuring seamless collaboration.

WEB APPLICATION DEVELOPMENT

• Built a workforce planning tool rivaling top tools, achieved over 60% performance gains through caching and indexing, enhanced scalability via Celery, and over 30% improved responsiveness using SSE.
• Led client demos and resolved issues, contributing to 20% business growth.

PIPE LINE DEVELOPMENT

• Designed and developed end-to-end ETL pipelines using Sqoop, Hive, SQL, and Shell Scripting, reducing data processing time by 40%.
• Implemented Slowly Changing Dimensions (SCD Type 1 and Type 2) to ensure accurate historical data tracking across millions of records, enhancing data consistency.
• Optimized SQL queries and indexing, leading to a 60% reduction in query execution time and improved database performance.
• Worked on data migration and transformation tasks, ensuring smooth integration of structured and semi-structured data into enterprise data warehouses.
• Gained hands-on experience in big data frameworks like Hadoop and Apache Spark, optimizing large-scale data processing.