SHILU PANDEY
Greater Noida
Summary
Senior BI Developer and Data Analytics professional with over 7 years of experience delivering enterprise-grade, client-facing BI solutions across consulting, FMCG, energy, marketplace, and digital businesses. Proven expertise in Power BI, Tableau, SQL, data modeling, and advanced Excel, with strong exposure to Agile delivery and stakeholder management.
Overview
9
9
years of professional experience
Work History
Sr. PLM Data Analyst
Reckitt
Gurugram
03.2024 - Current
- Partnered with site stakeholders to implement the process improvements, enhancing system workflows.
- Led cross-functional teams of 2+ analysts, providing strategic insights that contributed to 95% data accuracy with site and R&D.
- Led enterprise BI dashboards integrating PLM & ERP data with 98%+ accuracy.
- Connected with global sites to understand their data to match with the PLM system.
- Extracted data from different ERP systems (JDE and SAP) and converted it into meaningful reports using PLM and ERP data.
- Executed competitive benchmarking and market entry strategies, contributing to successful investments in acquisitions and market growth.
Business Data Analyst
Siemen's Energy
12.2023 - 03.2024
- Gathered and documented business requirements (user stories), and collaborated with partners on Power BI process enhancements.
- Delivered Power BI dashboards, reducing manual effort by 50%.
- Supported pricing-related product analysis and IP tool development, generating insights that improved end-client delivery.
- Worked under the Project Leader's guidance on scope definition, data cleaning, solution design, and analysis, ensuring zero-defect outputs.
- Built dashboards and presentations that drove stakeholder conversations and validated business hypotheses.
- Maintained appropriate process documentation.
Business Data Analyst
Bagrry's
Delhi
04.2023 - 09.2023
- Worked closely with business stakeholders to analyze current processes and identify areas for improvement.
- Translated business requirements into clear, concise functional specifications.
- Analyzed using Nielsen data to obtain competitor sales and product insights.
Sr Business & Data Analyst
StockDaddy
Gurgaon
02.2022 - 03.2023
- Developed and executed comprehensive marketing campaigns that align with the company's goals and objectives, as per the trend analysis.
- Led, mentored, and managed a high-performing marketing and sales team, fostering a collaborative and results-driven work environment.
- Collaborated with leadership to design and implement partner incentive workflows and CRM-driven marketing campaigns, increasing conversion rates by 20%.
- Built customer-facing BI solutions, improving decision-making.
- Designed and implemented data-driven customer analytics frameworks, increasing portfolio companies’ acquisition rates by over 25%.
- Spearheaded data automation initiatives across operations, cutting down processing time by 30%, and improving onboarding turnaround for channel teams.
- Acted as a strategic liaison between sales, marketing, and IT for CRM enhancement, improving lead-to-partner conversion, and alignment with business goals.
- Provided regular business reports and insights to aid decision-making.
Account Manager/MIS Analyst
OLX India Pvt Ltd
Gurgaon
02.2018 - 12.2020
- Built and optimized Salesforce dashboards and reports to monitor nationwide sales activities, improving decision-making efficiency by 50%.
- Developed scalable onboarding workflows in Salesforce CRM, cutting partner activation time from 14 days to 7 days.
- Improved sales forecasting accuracy by 20% through predictive analysis models.
- Designed automated reporting workflows using SQL, reducing recurring task efforts by 60%, and improving insights across 1M+ sales records.
- Partnered with cross-functional teams to implement data-driven sales forecasting models, increasing accuracy by 20%, and supporting performance-linked incentives.
- Conducted ad-hoc analysis for sales and finance teams using SQL queries, enhancing cross-team decision-making with actionable data.
- Supported partner onboarding and account lifecycle management, ensuring seamless integration with Salesforce systems, and driving consistent partner engagement.
- Drove the creation of scalable reporting templates and dashboards used by both internal sales teams and external partners, enhancing visibility and alignment.
- Championed continuous improvement by leading monthly feedback sessions with partner managers to optimize onboarding and reporting processes.
Practitioner
Concentrix
Gurgaon
07.2017 - 01.2018
- Portfolio management and account handling as per user's request.
- Responsible for Managing account and Generating Revenue.
- Updating and maintaining reports on sales.
Education
B. Tech - CSE
Skyline Institute
Greater Noida01.2017
12th -
Notre Dame Academy
Patna, Bihar01.2013
Skills
- Business intelligence architecture and solution design
- Advanced data visualization and insight storytelling
- Client-facing analytics and executive enablement
- Time management
- Data governance, accuracy, and security
- Agile BI delivery
- Leadership
- Effective communication, critical thinking
Technical Skills
Power BI (DAX, Power Query, RLS), Tableau, SQL (MySQL), SAP, JDE, Salesforce, MS-Excel (Power-Pivot, VBA)
Timeline
Sr. PLM Data Analyst
Reckitt
03.2024 - Current
Business Data Analyst
Siemen's Energy
12.2023 - 03.2024
Business Data Analyst
Bagrry's
04.2023 - 09.2023
Sr Business & Data Analyst
StockDaddy
02.2022 - 03.2023
Account Manager/MIS Analyst
OLX India Pvt Ltd
02.2018 - 12.2020
Practitioner
Concentrix
07.2017 - 01.2018
B. Tech - CSE
Skyline Institute
12th -
Notre Dame Academy