Rafay Khan Email & Phone Number

Charlotte, Nc, Us

Pompano Beach, Florida, United States

• Served as the Lead Pricing & Data Analyst for LandnSea products, managing Big Data encompassing millions of records and trillions of dollars in sales. Delivered critical insights to leadership, enabling strategic pricing adjustments that led to a measurable increase in revenue in Q2 and Q3.• Scripted advanced Python (including Data Science libraries), SQL, and DAX to deliver efficient and robust solutions and integrated Python Scripts and SQL queries into Power BI, developing sophisticated models and reports. Utilized a comprehensive toolkit that included Visual Studio Code with GitHub Copilot for development, Power Automate for automations, MS SQL Server, Azure Data Studio, and DAX Studio.• Highlighted Project: Developed and deployed a 'Promotional Price Calculator' within Power BI, integrating a Python script to apply multifaceted pricing logic and SQL queries. The solution featured interactive tables and visuals, enabling management to drive promotional pricing decisions. This project resulted in a 20% profit increase compared to the previous year’s event.• Utilized PROS pricing software to set product margins and define pricing rules, ensuring compliance with strategic pricing thresholds. Employed Python scripts and Excel to automate pricing processes, optimize margin settings, and maintain pricing accuracy across over one million products.• Executed the full ETL cycle, utilizing M code, Oracle BI, Dataflows, and Power Query to transform data through complex calculations and other transformations. Extracted data from SharePoint, Azure SQL Databases, and Python-to-SQL DB connections.

Mooresville, North Carolina, United States

• Analyzed and resolved 50+ cases weekly dealing with item integrity on Lowes.com (images, specifications, pricing, etc.) using ServiceNow, Syndigo, Jira, Excel and other internal tools, thereby enhancing both brand reputation and omni-channel customer experiences.• Revamped the case submission template used by the Brand Advocate department using Excel VBA, improving data entry and validation processes, increasing productivity by 30% and reducing human error by 20%.• Used SQL, Power BI, and advanced Excel functions to query data, create automations, and generate impactful visualizations, supporting data-driven decision-making and ensuring item data accuracy and integrity.• Partnered with global Enterprise Item Content teams and external vendors to facilitate swift issue resolution, achieving an average Service Level Agreement (SLA) resolution time of 3 days.• Designed and delivered comprehensive training modules for 100+ Brand Advocates on item data management, ensuring adherence to submission protocols and reducing data discrepancies by 25%.

Mooresville, North Carolina, United States

• Leveraged Alteryx to conduct a comprehensive audit of Product Variant Selling (PVS) relationships, identifying and correcting over 1,000 PVS discrepancies, which played a pivotal role in the successful migration to the new web-based PVS tool.• Collaborated with Brand Advocates to support and optimize PVS for items on Lowes.com, utilizing MS Excel advanced functions, including VLOOKUP and Pivot Tables, resulting in a 25% decrease in time-to-market for new product variants and improved process efficiency.• Collaborated with a cross-functional agile team on a pricing project, utilizing data querying and Excel functions, which directly contributed to securing a multi-million dollar contract with Disney.• Provided training to new team members on maintaining and implementing Product Variant Selling (PVS) relationships, ensuring consistent data management and reducing onboarding time.

• Surpassed the $100,000 annual sales milestone on Amazon for two consecutive years by leveraging effective SEO techniques, strategicpricing models, and targeted advertising campaigns.• Fostered exceptional customer relations and quality service by swiftly resolving inquiries and issues, which secured a 100% positivefeedback rating from over 5,000 eBay reviews and maintained a high 93% positive feedback on Amazon through diligent monitoringof transaction processes and inventory management.• Analyzed and leveraged data analytics focusing on market trends and key performance indicators to adjust sales strategies for over 500 listed products on Amazon and eBay, resulting in a consistent monthly revenue growth of 20%.

Fort Lauderdale, Florida, United States

• Gained strong knowledge of Verizon mobile technology • Met monthly sales goal target consistently • Maintained excellent customer service and rapport

Miami Metropolitan Area

• Taught Mathematics to grades 5- 10 - Elementary Math through Algebra 2• Ensured a safe learning environment for children • Developed and implemented daily lesson plans catered to the needs of each student • Planned activities tailored to student interest • Completed all required documentation and prepared progress reports and report cards • Participated in regular staff meetings • Participated in periodic parent teacher meetings and maintained ongoing communication with parents • Utilized classroom management techniques to encourage development

Goodyear, Arizona, United States

• Earned the prestigious Instructor of the Month Award • Mastered Sylvan’s interactive iPad system and teaching techniques to enhance student learning • Planned activities tailored to student interest

Master Of Science - Ms, Data Science, A

Track: Computational Data Analytics Capstone Project: https://users.cs.fiu.edu/~giri/teach/Capstone/F19/projects/RafayKhan.html

Bachelor Of Science - Bs, Biomedical Engineering, A

Activities and Societies: • Alpha Eta Mu Beta - National Biomedical Engineering Honor Society • The National Society of Collegiate.