​

• Analyzed requirements and developed comprehensive project plans to guide data science initiatives

• Strategized and implemented detailed work plans to ensure project milestones and deadlines were met

• Designed and developed an innovative academic enhancement product using LangChain and LLM, improving teaching and correcting workflows

• Collaborated in an Agile team to deliver high-performance ETL data pipelines using Spark, Hadoop and SQL in Databricks, processing over 10 billion rows of grocery ad data for forecasting and analysis.
• Crafted an interactive QuickSight dashboard that visually presents diverse customer metrics, unveiling spending patterns across customer types, facilitating in-depth analysis of purchase behavior and empowering strategic marketing/inventory management
• Optimized SQL queries to reduce dashboard data retrieval time by 60%, significantly cutting cloud resource consumption and improving overall processing speed.
• Engineered predictive models for ad effectiveness using advanced techniques, achieving an R2 score of 0.85 for three product categories across two banners, helping shape business decisions.

• Developed and optimized complex SQL queries and performance tuning through indexes, partitions, stored procedures, triggers and aggregations, resulting in faster generation of reports for stakeholders.
• Leveraged Apache Spark for efficient data extraction, transformation, and aggregation of large datasets from diverse sources to enhance demand forecasting accuracy by 18%, optimize inventory management, and reduce stockouts by 15% using transactional and demographic data.
• Conducted exploratory data analysis (EDA) using Python libraries like Pandas, to identify trends and patterns in customer booking behavior, leading to targeted marketing campaigns boosting customer engagement by 25%
• Developed interactive visualizations and dashboards using Tableau, AWS QuickSight and PowerBI, transforming complex datasets into actionable insights for stakeholders, which improved decision-making
• Collaborated with teams including marketing, operations, and IT to translate business requirements into data-driven solutions, ensuring alignment with overall business goals