Andrew Qi Email & Phone Number

Cupertino, Ca, Us

San Jose, California, Us

Built and maintained the company-wide data infrastructure for tracking materials and battery products.● Designed and deployed the company's founding database to capture quality control and R&D data in Postgres SQL and a Flask web interface.● Improved data integrity by standardized naming conventions for lots across different departments● Built a data warehouse in SQL Server to connect process data across departments, including automated ETL pipelines, optimized for executive Power BI dashboarding● Deployed and maintained the Eyelit manufacturing execution system and cloud-based LIMS, integrating their data and interfaces for end users ● Designed MES routes for process engineering flows to capture process, QC, and genealogy data.

San Jose, California, Us

● Developed a full-stack NodeJS web application to help manage inventory from partner vendors, using Express for the backend and React for the frontend.● Implemented Microsoft Authentication Library login, before replacing it with a custom JWT authentication module● Deployed solutions on AWS EC2 and AliCloud, running on Docker and Ubuntu

DIG (fka Design Integration Group) specialized in vertical integration & automation of real estate services, cutting time and soft costs for clients by 50-80%.● Developed startup's web app MVP in Python (Django), which converts user inputs into advanced SQL queries, then generated into client-ready reports on financial and legal analysis for real estate parcels● Designed ETLs, via Python (Pandas) to help cleanse and transfer large data sets into Postgres SQL & MongoDB to optimize the app’s analytics engine● Managed web deployment and provisioning on AWS (via EC2, S3, & RDS)● Fully automated daily Excel reporting tasks via Python, using a scheduler to resend updated reports every morning to track company cash flow and revenue from clients

SVUniverse helped connect Chinese international students & professionals, looking to advance their careers, with certified mentors, networking events, and career seminars.● Developed software via Python & SQL to establish customer & partner database, to automate daily reporting tasks, and to datamine for digital marketing research● Scripted Excel VBA macros to automate updates for KPI dashboards linked to Tableau● Managed digital marketing campaigns and designed process automations on Salesforce

Pleasanton, Ca, Us

Legion Inc specialized in new-customer acquisition for consumer products, serving both local small businesses and Fortune 500 corporations.● Redeveloped strategies & training program with senior management to increase weekly profits by 20%● Used data-driven approaches to decrease costs from lost/expired inventory by over 80%● Revamped data entry and reporting, in Google Sheets & Tableau, to automate workflows and eliminate human error

Round Rock, Texas, Us

The VxRail team from Dell-EMC produced the leading on-premises cloud solution in an increasingly competitive market.● Presented competitive analysis to VPs of marketing and R&D on competition's finances, market strategies, and product values● Created original, interactive training PowerPoints for senior management teams on the state of the cloud market and detailing the competition's features● Performed data analytics (SQL & Tableau) for customer support's escalations

Redwood City, California, Us

● Worked alongside the CFO to manage bank accounts, accounting spreadsheets, and budget reports● Introduced statistical approaches to better forecast inventory needs and delivery time benchmarks for the VP of Operations ● Drastically increased efficiency in producing daily spreadsheets via Excel VBA and web automation