JAIPREET SINGH
Product/Business/Data Analyst
Gurugram, IN.About
Highly analytical Product/Business/Data Analyst with a proven track record of leveraging SQL, Python, and dashboarding tools to drive efficiency and generate actionable insights. Expert in optimizing operations, managing complex projects, and enhancing product strategy, consistently delivering quantifiable improvements such as 30% efficiency gains and 20% operational boosts. Adept at cross-functional collaboration and data-driven decision-making to achieve strategic business objectives.
Work
Nat Habit
|Product & Operations Analyst
Gurugram, Haryana, India
→
Summary
Currently leads product and operations initiatives at Nat Habit, driving efficiency improvements and strategic system development through data analysis and project management.
Highlights
Developed and deployed a 'Logistics Optimization Model' from scratch using SQL, Python, and AppScript, enhancing operational efficiency by 30%.
Spearheaded in-house ERP development, defining comprehensive process flows and feature requirements across the entire value chain, ensuring streamlined operations and system efficiency.
Automated critical reporting processes with SQL and Metabase, including sales data and warehouse expenditure dashboards, reducing manual effort, improving delivery ETA by 12%, and boosting operational efficiency by 20%.
Designed and structured robust database tables using Python scripts, ensuring data accuracy and consistency to enable advanced analytical insights and dashboard creation for business and operational teams.
Implemented an MP Consignment Planning Sheet, a Google Sheet-based tool, to automate production and dispatch timelines for marketplace POs, minimizing last-minute execution gaps and aligning production with delivery schedules.
Nat Habit
|Product & Operations Analyst (Intern)
Gurugram, Haryana, India
→
Summary
Contributed to tech-driven solutions and sustainability initiatives, enhancing customer support and optimizing packaging materials.
Highlights
Collaborated with the Tech team to wireframe a chatbot for customer support, successfully reducing manual workload by 30%.
Developed a comprehensive analytical report on product packaging's environmental impact, leading to a 15% reduction in plastic waste and optimized packaging materials.
HRBOTICS
|Business Analyst (Intern)
Noida, Uttar Pradesh, India
→
Summary
Supported business development and digital presence, focusing on data-driven customer acquisition and website optimization.
Highlights
Developed comprehensive customer acquisition processes and strategy plans, encompassing data gathering, cleaning, and insight generation for HRBOTICS.
Authored Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs) to facilitate client and business pipeline development.
Enhanced product website SEO and analytics through market research and no-code design, improving online visibility and performance for clients.
Education
Netaji Subhas University of Technology
→
B.Tech
Electronics and Communication Engineering
Grade: 6.84 CGPA
Saint Joseph's Higher Secondary School
→
12th Grade
Secondary Education
Grade: 96.6%
Saint Joseph's Higher Secondary School
→
10th Grade
Secondary Education
Grade: 93.8%
Languages
ENGLISH
HINDI
PUNJABI
Skills
Technical Skills
SQL, Python (Pandas, Numpy, Sqlalchemy, Psycopg2), Power BI, MS-Excel, Spreadsheet, Metabase, ETL, ELT, Automation, Wireframing, Artificial Intelligence, HTML, CSS, JavaScript.
Business & Data Analysis
Data Analysis, Business Analysis, Product Management, Project Management, Product Operations, Logistics, Supply Chain Management, Business Interaction, Business Mapping, Data Conversion & Design, Testing & Validation, Strategic Planning, KPI Tracking, Market Research, SEO, Analytics.
Soft Skills
Communication & Collaboration, Problem-Solving & Analytical Thinking, Technical Adaptability, Leadership & Initiative, Stakeholder Management, Cross-functional Collaboration, Data-Driven Decision-Making.