William Ruan

Built and operated an online retail brand end-to-end (Shopify/Printify stack), managing product data, digital assets, and analytics. Developed internal Python architecture and scripts for automation (data extraction, automation of manual redundant tasks, AI pipeline to brainstorm for designs based on customers preferences). Used data insights (Meta Ads, Shopify dashboards, customer segmentation) to optimize marketing ROI and operations.

Designed and implemented LLM based scripts for regulatory workflows: semantic document comparison, difference detection, compliance summarization, and decision-support. Designed and developed RAG pipelines with rerankers, multi-agent (leveraging LLMs) on compliance POCs using LangChain / LangGraph within Azure environments. Designed and developed a Chatbot for regulatory documents. Wrote supporting Python/SQL automation (including scraping) for data prep. Worked end-to-end: business requirements, architecture, programming, debugging, testing and delivery of AI solutions.

Data governance and modeling: designed operational and DWH tables with the help of Erwin Data Modeler and Azure. I also supported ETL evolution and data quality controls. Used SAS to interact with DWH and SQL for operational DB. Functional Analysis to Build/modify batches and APIs (.NET/Cobol/SQL) and maintained back end integrity and fixed defects. Collaborated on analysis, architecture, testing, and debugging.