Abhishek

Data Scientist

DataworksAI•  April 2024 - Present•  Boston, MA, USA

• Architected scalable microservices chatbot using PostgreSQL, MongoDB and containers for optimal performance. • Applied advanced prompt engineering (few-shot, zero-shot, CoT) to enhance LLM performance and accuracy. • Implemented user and conversation tracking using Redis in FastAPI backend for personalized, context-aware chat sessions. • Deployed chatbot on Red Hat OpenShift AI, utilizing Kubernetes for scaling, security and CI/CD integration.

Senior Software Engineer

PowerSchool•  March 2018 - August 2022•  Bengaluru, Karnataka, India

• Developed a data warehouse using Databricks, integrating student data from Azure Data Lake, RESTful APIs, MongoDB, and AWS S3. • Automated ETL using RPA and Airflow for multiple portals, reducing project completion time by 25% with Docker and Git Actions CI/CD. • Implemented Azure SQL Server stored procedures (T-SQL) to log and analyze RPA project data, enhancing tracking capabilities. • Applied real-time monitoring system using SageMaker, Kafka, Elasticsearch, Kibana, Tableau, and Power BI, boosting automated ETL process efficiency by 15%. • Developed regression models using Scikit-learn to forecast monthly CRM/ERP data migration requests. Visualized results with Tableau/Looker, leading to a 20% improvement in data migration planning efficiency. • Mentored 20+ new hires in problem-solving and automating ETL pipelines within Agile framework, using JIRA for tracking. • Developed MySQL/Java web interface for database exports, improving productivity 9%. Containerized with Kubernetes for scalability.