Lokesh Pandey
Rudrapur
Summary
Seeking a Data Analyst role where I can contribute by transforming business data into strategic insights, leveraging strong analytical and communication skills acquired through extensive experience in sales operations and data reporting.
Analytical and results-driven Data Analyst with 5+ years of cross-functional experience in pharma and retail operations. Proficient in leveraging tools like Excel, SQL, Python, and Power BI to generate actionable insights, optimize inventory, and improve sales performance. Proven ability to communicate complex data findings clearly and support strategic business decisions.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Sales Executive
Reliance Retail
01.2023 - Current
- Analyzed sales data to forecast demand and adjust inventory levels accordingly.
- Developed dashboards that monitored key performance indicators, boosting visibility for management.
- Improved sales by over 20% for 5+ months through data-driven product placement strategies.
- Earned 'Best Employee Award' in 2024 for exceeding operational KPIs.
Senior Executive
Netmeds Pharmacy
01.2018 - 12.2022
- Optimized warehouse inventory flow using SAP and Excel reporting dashboards.
- Streamlined dispatch processes, improving delivery accuracy by 15%.
- Mentored new employees and enhanced team productivity by implementing standard operating procedures.
Education
Bachelor of Business Management -
Swami Vivekanand Institute of Management Science & Technology
01.2020
Skills
- Excel
- Python
- Pandas
- NumPy
- SQL
- Exploratory Data Analysis
- Power BI
- Matplotlib
- Business Dashboards
- MS Office
- SAP ERP
- Google Sheets
- Problem-solving
- Communication
- Team Collaboration
- Business Intelligence
- Data Cleaning
- Reporting Automation
Certification
- Certified Data Analyst, OdinSchool
- Google Data Analytics Professional Certificate, In Progress
- Excel to MySQL: Analytic Techniques for Business Specialization, Coursera
Projects
Sales Trend Dashboard, Power BI, Created an interactive dashboard for monthly sales analysis; reduced report creation time by 30%. Customer Purchase Pattern Analysis, Python, Pandas, Performed customer segmentation using EDA to uncover purchase behaviors and improve marketing strategies. Retail Inventory Optimization, SQL, Wrote complex SQL queries to analyze stock levels, reorder trends, and supplier performance. Helped reduce overstock and out-of-stock issues by 18% through data-driven reorder thresholds.
Timeline
Sales Executive
Reliance Retail
01.2023 - Current
Senior Executive
Netmeds Pharmacy
01.2018 - 12.2022
Bachelor of Business Management -
Swami Vivekanand Institute of Management Science & Technology
Similar Profiles
Subhranshu RoutSubhranshu Rout
Customer Relationship Manager at Reliance Digital (Reliance Retail Limited)Customer Relationship Manager at Reliance Digital (Reliance Retail Limited)
Srikant Kumar NayakSrikant Kumar Nayak
Manager-HRBP at Reliance Retail Ltd(Reliance Jewels)Manager-HRBP at Reliance Retail Ltd(Reliance Jewels)
SAGNIK CHOUDHURYSAGNIK CHOUDHURY
Brand Planner at Reliance Retail(Reliance Trends)Brand Planner at Reliance Retail(Reliance Trends)
Sundeep RauSundeep Rau
AVP and Head of HR & LnD at Reliance Jewels ( Reliance Retail)AVP and Head of HR & LnD at Reliance Jewels ( Reliance Retail)
Vikas PaliwalVikas Paliwal
Technical Support Executive at IenergizerTechnical Support Executive at Ienergizer