Sophie Xiaofei Xue

Senior Full-stack Data Scientist and Ml Ai Engineer @Ernst & Young Global Consulting Services

Atlanta, GA, US

Performed data extraction on various types of files such as text extraction from PDF and Excel, image extraction from PDF and Word, frame extraction from Mp4, Gif, Html, and extract audio from Mp4 and transform audio to text using different python packages and prompt engineering with multimodal LLM such as OpenAI 3.5, LlaVa and Florence2- Deployed E2E deep learning models leveraging Azure Document Intelligence and Form Recognizer and extracted critical informations from over 3 million pages scanned 40 years ago with noises and low resolution rate, and created the database schema and loaded the information to DB for downstream usage - Designed dynamic upper and lower thresholds using statistical and time series models to catch anomalies/outliers in data quality and launch investigations- Advised a new payout structure to save clients\' resources after uncovering outliers in payments due to users stacking coupons- Conducted hypothesis tests on variables affecting users\' experience and churning behaviors to calculate and predict their lifetime value/cost- Rewrote and validated KPIs during the migration form decommissioned databases to cloud and created reporting dashboards- Fostered relationship and community building by hosting volunteering events at Girl Scouts and Atlanta Science festival, lunch and learn sessions on cloud computing, virtual yoga and meditation breaks, and internal company networking events.