Pranjal Shandilya

Proficiently bridged the gap between business objectives and data insights by employing Python to develop adaptable, modular scripts for data cleaning and transformation. Spearheaded the creation of a robust data model and pipeline leveraging Amazon S3 bucket and SQL in conjunction with Python, ensuring the seamless availability of data for dashboard visualization and machine learning models within PgAdmin. Empowered a Fortune 500 client by establishing essential Key Performance Indicators (KPIs), meticulously crafted for presentation on Power BI dashboards across various industry verticals, facilitating actionable insights and data-driven decision-making. Pioneered the development of scalable machine learning models, including Exploratory Data Analysis (EDA), Feature Engineering, and the implementation of advanced techniques such as Boruta and Optuna/Hyperopt for hyperparameter tuning, to forecast critical business requirements. Elevated model efficiency by optimizing queries and machine learning code, systematically reducing runtime complexities. Maintained comprehensive version control and documentation by utilizing Git, Jira, and Confluence, ensuring clarity and transparency in code commits, client interactions, and data model iterations. Drove project timelines and skillfully executed end-to-end project management, facilitating successful project outcomes.

Led the data-driven initiative for new product development and strategic planning of a cutting-edge e-commerce website from inception for a prominent US Healthcare leader (Fortune 500 - Henry Schein). Applied data analytics expertise to refine user stories, aligning them with comprehensive test cases through in-depth analysis of UX/UI input. Played a pivotal role in requirement elicitation for emerging user stories, adeptly handling inquiries and clarifications from business stakeholders and clients by leveraging data-driven insights. Collaborated seamlessly with cross-functional teams, partners, and support functions, leveraging data analytics to ensure rigorous unit and module testing. Proficiently detected, reported, investigated, and remedied application defects. Translated stakeholder requirements into tangible, data-driven deliverables, including functional specifications, EPIC documents, user stories, and visual representations such as workflow/process diagrams and data flow/data model diagrams.

Unleashed the power of data analytics to unearth profound customer spending patterns, resulting in the delivery of actionable insights that drove transformative changes. Leveraging Nielsen Panel data, I spearheaded a game-changing project for Unilever. Led the charge in elevating Unilever's Net Revenue Management strategies within the highly competitive Consumer Packaged Goods (CPG) industry. Through an in-depth analysis of brand positioning, category growth, strategic pricing, and pack & price architecture, I contributed to substantial market impact and revenue growth. My data-driven contributions extended to Unilever's Food & Refreshment sector, where analytics played a pivotal role in optimizing business decisions. Likewise, in the Fabric Solutions domain, my insights facilitated informed choices, driving tangible results and enhancing Unilever's market presence. Analyzed Nielsen and Kantar data to pinpoint Unilever's top-performing products. Examined key metrics like sales growth, market share, and consumer demographics for these products. Developed market-specific strategies based on data insights for optimal sales in different markets. Optimized product positioning, pricing, and marketing campaigns to maximize revenue. Provided Unilever with data-driven decision support for product portfolio management and market performance enhancement. Contributed significantly to Unilever's global success through data-driven insights and strategic planning.

Spearheaded data extraction and meticulous data cleaning from the extensive Global Vehicle Database, employing SQL queries to ensure data integrity and reliability. Took the lead in conceiving, designing, and meticulously developing Aftersales diagnostic codes and procedures, contributing to the enhancement of product functionality and usability. Played a pivotal role in the technical documentation of aftersales diagnostic procedures, translating complex technical information into comprehensive and user-friendly documentation.

Activities and societies: Academic Merit Rank - 3, 1st Rank in Capstone Project

Activities and societies: Top 10 in the batch, IAESTE CLUB MEMBER, Community Services as being part of a club