Loyola University Chicago

Data Analytics at Stripe

San Francisco, California, United States

Stripe

Data Analytics / Technical Operations

- Designed ETL, optimized queries and maintained data pipelines; Expertise with SQL beyond querying- Automated manual reporting to fully automated self-service dashboards for downstream teams- Scoped, tested, and migrated codes in our repository to different database as part of company-wide database management software migration- Drafted reconciliation requirements and partnered with accounting, payments, product, and engineering teams to ensure those requirements are met- Gathered requirements and created machine learning model to train multiple years of processing data; Used the model to predict revenues and fees related to each processor to facilitate faster accounting month close- Supported numerous processor integrations by providing data validations, ensuring that processor data met our expectations as well as verifying that our system correctly aggregated and exposed that dataSome of the languages and tools I used - SQL, Python, Airflow, Looker, GCS, Hive, Vertica, Snowflake, BigQuery, BigQuery ML, and etc..

Square

Data Analyst, Reconciliation

- Gathered requirements, designed testing approach, communicated with offshore supporting teams, planned budget and monitored execution; Managed over 10 projects concurrently and ensured quality and timely delivery- Analyzed and provided assurance over the companies’ financial data by testing math accuracy, completeness, and integrity using SQL & Audit Command Language (ACL) - Led team of three to deliver audit support through innovative use of auditing techniques. This includes managing the team to deliver over 30 projects in the bay area- Regional Champion for Journal Entry testing dashboard- Understood client’s revenue recognition process and provided assurance over client’s revenue reports by reviewing client’s SQL code and re-performing the revenue recognition in a separate environment to ensure the accuracy of the reports

Jun Xu