Shreyan Das

𝗔𝗯𝗼𝘂𝘁 𝘁𝗵𝗲 𝗽𝗿𝗼𝗷𝗲𝗰𝘁: ➤ Comprehensive Business Intelligence & Analytics platform for a key player in the Oil & Gas/City Gas Distribution (CGD) Sector ➤ Delivered 1500 KPIs through 500 dashboards with 200+ active users, catering to all core business functions including corporate finance, sales, customer acquisition, marketing, operations and management, assets and inventory, HR, IT 𝘐𝘮𝘱𝘢𝘤𝘵 ✔ Boosted operational efficiency by streamlining business processes and identifying bottlenecks ✔ Offered deep insights, enabled data-driven decision-making through complex descriptive, diagnostic and prescriptive analytics ✔ Supported strategy for loss prevention/recovery via early forecasting through ML models ✔ Reduced time- and resource-intensive manual processes through report automation ✔ Configured instant alerts on critical metrics, enabling immediate action on deviations from the norm 𝗖𝗼𝗿𝗲 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀 ➤ Lead discussions with end-users, senior stakeholders, higher management to identify key business issues, gather technical requirements, communicate project progression and coordinate UAT ➤ Synthesize discussions into well-structured action plans, translate business requirements into efficient data models ➤ Develop end-to-end enterprise big data pipelines with PySpark on Databricks ➤ Orchestrate ingestion and ETL jobs using Azure Data Factory to process data from 15+ disparate data sources (incl SAP, CRM, MongoDB, MySQL, SCADA, Mobile/Web Apps, flat files) and allow flow to downstream applications, visualization tools, data science teams ➤ Manage a 200 TB data lake, relational data warehouse on development and production environments, handle deployment activities ➤ Develop performant SQL queries, views and stored procedures for complex analytics, reporting and execution of regular data tasks ➤ Perform RCA, resolve critical time-sensitive production issues within tight deadlines to prevent overheads

➤ Developed a PoC (Proof of Concept) migrating the company's ed-tech application from a LAMP software bundle to a purely Python-based tech stack along with a NoSQL database (MongoDB). ➤ Designed, trained and deployed 4 Machine Learning (ML) models to enhance the customer experience using SciKit, VADER, REST APIs.

➤ Fixed bugs in client data feed scripts. ➤ Added unit tests to pad edge-cases from failure. ➤ Built a web-based dashboard to display stock data visually to clients.

➤ Secured the position of Vice President in the very first semester, standing out among 72 competing departments in a university of 44,000 students. ➤ Expanded club membership from a small initial group to 150 members, achieving a remarkable 10x growth. ➤ Organized and coordinated 11 diverse literary events on campus, managing meetings, budgets, and event logistics. ➤ Facilitated student participation in international poetry competitions through strategic external collaborations. ➤ Drafted detailed documentation, event reports and proposals to strategically plan and optimise club operations.