Chetankumar Sirokha

Developer

Tata Consultancy Services•  January 2024 - Present•  Mumbai

Developed a comprehensive data warehouse architecture and designed an optimized schema to facilitate efficient data storage, retrieval, and analysis. Engineered a robust ETL pipeline using python and SQL, streamlining the extraction, transformation, and loading processes from various database servers to the data warehouse. Conducted performance tuning and optimization of ETL processes, resulting in improved data processing speed and reliability. Documented all ETL workflows, performance metrics, and troubleshooting procedures to enhance knowledge sharing and maintain compliance with business requirements. Collaborated with cross-functional teams to gather requirements and ensure the ETL pipeline met evolving business needs, contributing to increased data accessibility and reporting accuracy. Monitored ETL performance and implemented enhancements based on feedback and analysis, ensuring consistent delivery of high-quality data for decision-making. Hands-on experience with AWS S3 for efficient data storage, retrieval, and integration with ETL workflows. Developed and deployed a chatbot for interactive data querying, allowing users to retrieve desired outputs from the data warehouse through an intuitive conversational interface, streamlining data access and analysis.

Production Support Executive

Tata Consultancy Services•  February 2020 - November 2022•  mumbai

Developed and implemented shell scripts for efficient data extraction from production servers, facilitating the generation of critical reports. Led a team of 10 executives, providing training and mentorship to enhance team performance and skill development. Monitored and delivered key reports within established SLA timelines, ensuring high-quality output and stakeholder satisfaction. Received commendations from management for exemplary performance and contributions to the team's success.