Yuping Yang Email & Phone Number

Programmed a time series forecasting software (in progress). Already accomplished components are: o used some python mathematic libraries: numpy, pandas, matplotlib, pickle, h5py, sklearn.cluster Kmeans, DBSCAN, AgglomerativeClustering, tslearn.clustering TimeSeriesKmeans, sklearn.metrics, dtaidistance dtw, fastdtw tslearn.metrics cdist_dtw o used.

Redwood City, California, United States

• System setup and upgrading of c3 AI platform
• used VM, WSL2, linux in WSL2, docker, mac, github, python, node.js, c3 AI cloud
• participate in client engagement for AI projects

San Jose, California, United States

• Because of the stealth nature of the project, I do not disclose the goal and scope of the project. I function as a foundation engineer to probe the design, technical viability, and construct a POC of a complete AI.
• Investigated various installations of openpose, mediapipe, Yolov8, Yolo-nas, under a variety of environments: Linux, Windows, docker images and containers, Dockerfile, pre-configured images, cmake, python virtual.
• Used vision ML packages (object recognition, pose estimation) yolov8, yolo-nas, openpose, mediapipe, pytorch for object detection and pose estimation.
• Used vision package opencv
• Used pretrained models and done some model training. Used annotation software cvat to prepare labels for training.
• Done affine transformations for 3D modeling: translation, rotation, quaternions, 3D transformation matrices, etc.

Menlo Park, California, United States

1. Done analysis to optimize marketing campaigns parameters (presto SQL/Hive/notebooks).Details: initially to analyze the effect of bid cap, through investigation in database. Bid Cap is one of the ad parameters. During investigation, I found that many other parameters affect the campaign effect, and can be formulated as a high dimensional optimization.

Columbus, Ohio

• Work as a senior technical member in data solution team, with diverse duties and tasks
• Data Mining (Text Data Pattern Matching and Apriori): Independently built a program to find more than 1000 useful patterns with over 99% accuracy in a database. To compare, previously, two analysts worked over 6 months.
• Text Data Classification: Independently built a program to classify product tier in a database with product info. This program replaced previous manual work. The effect of a single run is equivalent of two-people.
• Text Parsing: Independently built a program to parse US Patent Office PDF documents (>50K docs) to do OCR and extract relevant patent citations information with 95-97% accuracy. These docs are prepared by USPTO patent.
• Data Search Tool: Independently built a MS SQL database search tool with a Windows GUI (PyQt, python). It can be used to visually search and display aspects of a relational database, such as table relationships.
• Graph Data Visualization: Built a visual interface to display lines & nodes representing graph data in a SQL Graph database.Coding work are python coding with PyQt (GUI), D3 Js (Web node graph), tesseract (OCR), re.

Columbus, Ohio, United States

A personal effort to get funding for a software I created.(1) Coded a data lineage search software for use with MSSQL, done with MVP (similar to www.getmanta.com), 15k lines python.(2) Coded a socket-based office document sharing software, done with MVP, 5k lines of pythonBoth programs used PyQt GUI and PostgreSQL as backend(3) Create a Django based web.

Columbus, Ohio

Wrote a versatile data converter in python, for loading medical data from diverse sources of various hospital systems into a universal schema OMOP. data sources contain medical codings from SNOMED, CPT-4, and ICD9.program is based on python, with csvkit and lucene search engine.

Columbus, Ohio

(1) debug and modified a software for monitoring financial transactions.(2) Investigated feasibility for data level linking DB2 based system to Oracle based system(3) Wrote a complex Java program to convert data formats.(4) reverse engineered the logic of an old system as preparation for building new.(5) Actimize rule engine study and POC as preparation.

Columbus, Ohio

Re-architected a funding tracking DW for full life cycle tracking of research applications and projects.Work involving investigating the old system, current projects and people usage information, and data modeling, and ETL, etc.

Columbus, Ohio Metropolitan Area

• Misc consulting projects. Most were ETL, Data Warehouse or BI related. Roles in each project involved client project proposals, scoping, budgeting and implementation (70%)Selected Projects:
• Etech, an Ohio government agency: Reorganize of state-owned buildings and teacher data.
• 31gifts Co.: SQL Server Replication and ETL work using SSIS.
• Ohio Department of Development: ETL using T-SQL and SSIS.
• Cardinal Health: Scan code patterns in a large repository of deployed programs using Perl.
• Ohio Department of Insurance: Built BI Platforms and two data marts using SSIS, SSRS, SSAS.

Cincinnati, Ohio, United States

• Worked to support the integration of several very large databases during the merge of GE Aircraft Engines and GE Locomotives
• Conducted extensive data analysis and re-designed the data model of databases and data warehouses of GE Transportation (Parent company of GE Aircraft Engine and GE Locomotive) into six subject areas: Human Resource.

Columbus Metropolitan Area, Ohio, United States

• Proposed a ultra-fast flat-bed scanning device, applied and obtained patents, conducted research on imaging software and hardware, and did many funding raising activities
• Created a high-speed, large-area flatbed scanner using a matrix of optical sensors for split-second document scanning with visual correction. Researched numerous patents, optical imaging devices, and embedded.

Cambridge, Massachusetts, United States

• Profitlogic is a software startup aimed at forecasting prices for retailers. JC Penny project ($15m) is the last and the biggest project done by this company before it sold to Oracle. I joined at start of this project.
• Designed a large database (At the time, a few Trillion bytes, in today’s terminology, it is more close to a data lake, with core parts having relational schema as well as star schemas), leading a team of 7 developers.
• Led a team of seven Engineers in building a large data warehouse for JC Penny's pricing optimization system, handling 3.5 million active SKU's across 1,020 stores. The project was implemented on an Oracle database.

Cupertino, California, United States

• Electron Economy is a software startup funded with $86m venture funding. I was hired without a role assignment and my role was determined 2 month after I joined the company, when I proposed an automatic, modularized.
• Conducted supply chain visibility analysis and proposed a real-time online business transaction project based, leading to the establishment of the Intelligence Commerce Engineering (ICE) division (members: 10 PHDs, 5.
• Collaborated on Java software design and implementation.
• Created a reporting data mart for the central database, utilizing ERwin, Pro*C, C, Java, and Oracle

Phd, Computer And Information Sciences

Master Of Science - Ms, Computer And Information Sciences, General

Master Of Science - Ms, Mathematics

Bachelor Of Science - Bs, Computational Mathematics