• Participated an enterprise search engine data pipeline modernization project that moved from decades old Java implementation with lots of technical debt into AWS solution using modern technical stacks, then migrated it into GCP using Google’s counterparts. [AWS, Airflow, EMR, Spark/Scala, HBase, MySQL, GCP, Composer, Dataproc, BigTable, BigQuery, Pub/Sub, Cloud Run Function]

• Leaded a team of engineers developed a cloud based ETL pipeline that ingest, cleanse, normalize and store golden data for search engine, reduced the 3-months full reseed cycle into a weekend activities. [Snowflake, Python, AWS (Step Function, Batch, Lambda), Docker, Terraform]

• Collaborated with data scientists to develop a NLP model that evaluate daily massive amount data search requests to quantify inquiry quality with search results. [Snowflake, Python (NumPy, pandas, NLTK), AWS]

Served as the IT team lead of Verizon Wireless retail inventory planning and replenishment and market demand planning systems.

• Developed data wrangling and improved statistically modeling system with structured sales, inventory, forecast, shipment data and unstructured business inputs to optimize inventory level via safety stock and archived savings in millions per quarter. [Python (NumPy, pandas), PySpark, Hadoop, Hive, R]

• Created an interactive website that performs time series forecasting with various statistical methods (moving averages, seasonal, ARIMA), time horizon, product family/grouping, empowered demand planners to visually explore forecast and identify optimal model. [R (shiny), Hadoop, Hive, SQL]

• Programmed supply chain data extraction/ingestion workflows for advanced analytics, centralized sporadic data stores and enabled data-driven decision making. [SQL, Hadoop, Hive, Oozie, Sqoop]

• Architected and deployed cross-channels inventory allocation logic that intelligently segregates warehouse inventory into pools for channel consumption based on forecasts and various business controls. It automates most inventory planning tasks and has planners focusing on exception cases.

• Spearheaded supply chain planning IT of SAP IS-Retail project and architected/coded complex business logic and rolled-out flawlessly over 1700 retail stores and 3 warehouses.

• Led inventory planning IT team for replenishment process optimization project that cut down store replenishment cycle time, saved one day worth of cycle stock/working capital and replaced planners daily busy tasks with highly customizable configuration.

• Collaborated with business partners to streamline inefficient business processes and led IT team to incorporate new processes into Logility Voyager ERP upgrade project that archived higher SLA with high-availability disaster recovery capabilities that ensured business continuity.

• Guided JDA's Sales & Operations Planning (S&OP) implementation that enabled collaboration between device marketing, supply chain planning and execution.

• Stabilized problematic supply chain management system by building robustness (for inconsistent data) and fault-tolerant (for inconsistent environment) into it, converted legacy file-based interfaces into managed ETL solution and improved daily system SLA by 2 hours.

• Automated data-driven warehouse inventory replenishment process by daily triggering and reconciling inventory movement in ERP/WMS/OEMs and archived working capital reduction by $20 million.

• Developed Java web-services perform PL/SQL bulk queries over 500+ millions of mobile handset dataset that eliminated inefficient multiple calls and ensured adequate performance for 4G adoption.