Ritesh Sil Email & Phone Number

Kolkata, West Bengal, India

Kolkata, West Bengal, India

- Curated key KPIs from application logs in a Tableau dashboard, utilizing an Azure Databricks data processing pipeline for insightful visualization.- Conducted a Proof of Concept (POC) employing classical Machine Learning and NLP techniques to intelligently analyze support tickets.- Demonstrated POCs at the enterprise level, seeking direction for appropriate implementation and securing the necessary environment.

Kolkata, West Bengal, India

- Led a major analytics development initiative in the consumer supply chain domain for EMEA customers, employing Data Warehousing, SQL, AWS Redshift, Python, and Tableau in a customer-facing role.- Developed three Tableau reports highlighting crucial KPIs for Sales, Claims, and Inventory, providing valuable insights into primary and secondary sales measures (GTS, NTS, STT, POS, CIW).- Acquired substantial domain knowledge through interactions with product owners and Business Analysts, contributing to the successful delivery of an impactful analytic solution.- Played a key role in skill development within the team, mentoring junior members to identify and address critical issues, and fostering a collaborative and growth-oriented work environment.- Executed Proof of Concepts (POCs) in Big Data using Pyspark, demonstrating cost reduction strategies for the platform and showcasing the potential benefits of integrating innovative technologies in the analytics solution.

Kolkata, West Bengal, India

- Developed a tailored analytics solution for the KSA consumers of the AMET region in the supply chain using AWS Redshift, Python, SQL, and Tableau.- Conducted thorough requirement analysis, addressed project challenges, and implemented SCDs and audit functionality in the data warehouse.- Led Tableau report development for user-friendly visualization, enhancing stakeholder insights.- Managed Big Data analytics solutions in Pyspark, Hive, and Impala within the Supply Chain and corporate domain.- Proactively identified and resolved critical issues, participated in major enhancements, and ensured smooth deployment through Change Management processes.- Demonstrated commitment to continuous improvement in analytics and Big Data domains, optimizing overall system efficiency.- Completed a Diploma in Artificial Intelligence and Machine Learning from the University of Hyderabad, in association with Applied Roots Inc.

Kolkata, West Bengal, India

- Developed Tableau reports for ETL reconciliation, incorporating conditional colour coding and parameterized fields for anomaly detection.- Enhanced Tableau reports with new charts, optimized data visualization, and improved user experience.Oversaw smooth migration of Tableau reports, addressing post-migration issues promptly.- Conducted rigorous data analysis using SQL and Tableau, handling ad-hoc data requests.- Proactively identified and resolved critical issues in Tableau reports, ensuring stability.- Utilized Python scripting for major automation, following coding standards for reliability.- Thoroughly documented application artefacts in enterprise tools (e.g - Confluence), aiding knowledge transfer and troubleshooting.- Built business acumen in Commercial Pharma domain through regular customer interaction.- Managed end-to-end batch pipeline delivery within SLA, implementing efficient processes.

Kolkata, West Bengal, India

- Monitored batch loads and report refresh cycles to ensure timely execution and optimal system performance.- Investigated and debugged data processing failures, employing a systematic approach for swift issue resolution.- Led process improvement efforts, utilizing Shell scripting for automation to streamline workflows.- Maintained detailed documentation in Confluence, capturing key processes and troubleshooting steps.- Proactively identified opportunities for improvement, contributing to a more robust analytics ecosystem.