Gurpreet Singh Email and Phone Number

• Developed and implemented a Flex Analysis report using Python and BigQuery, automating the identification and communication of dropped offers from our JDA planning tool to merchants. This initiative resulted in a $100k cost savings in a single cycle, while preventing empty fixtures in stores.• Developed and deployed a Microsoft PowerApps-based application for the Merchandising team, providing real-time access to reports, forecasts, and key metrics for informed decision-making in merchandise planning.• Created a regression model for Produce categories, significantly enhancing sales and cost forecasting accuracy from 60% to 88%. This allowed for advanced planning up to 14 weeks ahead, reducing shrink and improving ESG scores.• Developed Wholesale LE, a forecasting tool for Center of Store categories in the Wholesale Division, achieving a remarkable 98% accuracy rate. This tool provided reliable forecasts for sales, margins, and tonnage, enhancing planning efficiency.• Conducted day-to-day ad-hoc analyses and delivered comprehensive reports, such as the No Name Campaign, to categories, demonstrating campaign and program performance results.• Conducted Inventory Analysis to optimize stock distribution, identifying excess inventory of PCO Baby items in distribution centers. Implemented allocation strategies to ensure sell-through before end dates, benefiting franchise stores.• Led BOGO Analysis initiative, managing billbacks to vendors for Buy One Get One offers, optimizing cost recovery for products distributed during promotions.

• Develop cross-merchandising boosting recommendations for PCX's online groceries by analyzing top 5000 search terms and suggesting complementary product bundles.• Utilize customer basket data to identify frequently co-purchased items and propose strategic cross-selling opportunities.• Implement an automated PDF generation system for in-store promotions using Python, streamlining the creation of promotional materials for Loyalty promotions.• Collaborate with third-party template providers to transition towards an automated PDF creation process for in-store promotions.• Document the Forecasting Tool, Corp LE, and other reports onto Confluence, ensuring clear and accessible insights for the team.• Analyze the impact of Loyalty promotions on new customer acquisition, developing a self-serve tool to monitor the effectiveness of Member Only offers in attracting new customers.

• Utilized GA4 to analyze and derive insights on website and application traffic and user behavior, enabling data-driven decision making.• Leveraged Microsoft Excel to create and manage data reports for the company.• Used Microsoft PowerPoint to present findings and information to the team and stakeholders, effectively communicating SEO strategies and recommendations.• Analyzed keyword performance data, including search volume, competition, and click-through rates, to identify opportunities for optimizing keyword targeting.• Developed and executed an SEO/SEM strategy.• Performed ongoing keyword discovery, expansion, and optimization.• Implemented technical SEO tactics including metadata, keywords, URL structure and slugs, hosting, indexing, and page loading.• Recommended changes to website and application architecture, content, linking, and other factors to improve SEO positions for target keywords.

• Developed and designed multiple websites for small businesses and startups using HTML, CSS, JavaScript, and React• Provide the clients with several mock-ups to choose from and work alongside developers to come to a final design concept.• Utilized frameworks such as React, Bootstrap, and WordPress for interactive elements like buttons, carousel, and jQuery library for pop-ups• Implement PHP to connect the contract forum to the hosting server’s webmail and Google Maps API to map the business location.

• Taught coding concepts in PYTHON, JAVA, C++, and other languages using a play-based curriculum at Code-it Hacks.• Updated lesson plans and gaming projects based on Code-it Hack's methodology, incorporating personal coding contributions to align with my teaching style.• Formed student teams to create a collaborative working environment that fostered knowledge-sharing and teamwork.• Documented class progress and provided detailed reports to parents after each session.• Developed and introduced unique coding projects beyond the proposed curriculum to enhance student engagement and offer diverse learning experiences.• Prepared thoroughly for each class, ensuring a well-organized and effective teaching approach.• Managed classroom setup and cleanup to create a conducive learning environment.• Sent out regular weekly parent communication emails to keep them informed about their child's progress and important updates.

• Delivered exceptional customer service, providing a positive and professional experience while effectively explaining the benefits of our products and services.• Demonstrated a thorough understanding of our products and services, ensuring customers were well-informed and confident in their purchasing decisions.• Documented relevant customer information accurately and efficiently, maintaining detailed records for future reference and analysis.• Maintained a strong working knowledge of calendar management, effectively scheduling appointments and managing conflicting priorities.• Prioritized customer satisfaction by promptly responding to inquiries, resolving issues, and addressing customer concerns in a timely and satisfactory manner.• Collaborated with cross-functional teams to ensure seamless coordination and smooth customer interactions.• Stayed updated on product knowledge, industry trends, and competitive offerings to provide informed recommendations and insights to customers.• Actively sought opportunities to upsell or cross-sell products and services, maximizing customer value and revenue generation.