- Design and implement data pipelines that power workforce planning and scheduling systems of Amazon Last-mile warehouse network.- Collaborate with cross-functional teams such as business, science, product, program and software engineering to launch workforce-supporting systems.

- Design and implement Apache Airflow’s workflow and DevOps process for the deployments of Region’s data products.- Lead a team of four in a data engineer project that leverages Spark and SQL, among other tools, to aggregate data from a variety of source systems and file formats into a one-stop data mart for a department of more than 20 people.- Co-operate with an external vendor to re-develop the consumer credit underwriting models; successfully parsed raw credit bureau reports using Spark to extract consumer’s credit attributes.- Enhanced a Docker image to add functionalities and resolve dependency issues during data products’ deployment.

- Led a cross-functional analytics project to revamp the line assignment process; three new strategies expected to cut charge-off loss by $4M and increase revenue by $2M (40% improvements).- Pioneered and implemented the integration of profitability into credit risk strategy formation and created a complex SQL program to aggregate profit data; the resulted proposals were well-received by both risk and finance groups.- Developed a Python pipeline that automated the experiment of multiple line assignment strategies.- Collaborated in multiple data ETL and visualization projects to monitor models’ and portfolios’ performances.- Developed machine learning models to predict account’s metrics: delinquency, activity, and profitability.- Collaborated with multiple groups in collecting system requirements and led the programming efforts to productionize a Java-based decision engine.- Developed a Python-powered tool and GUI to fully automate the testing of the decision engine’s API.- Managed two Rotational Risk Analysts whose later contributions within only six months were well recognized.- Enhanced an existing Sublime Text’s data querying package to accommodate the internal Big Data platform; the tool was considered somewhat better than the data vendor’s tool (HUE) and widely used by many co-workers.

- Improved 45% accuracy in variable costs forecasting by conducting variance analysis and analyzing inventories data.- Formulated and convinced leaders to implement an A/B test over a low-performing process; Coordinated 4 teams to accomplish the test, improving KPIs (63%), customers’ satisfactions and reducing costs (67%).- Designed 5 representative test groups by analyzing data and clustering features of very diverse users.- Communicated between operations and IT teams to understand business requirements; Developed VBA macros to reduce 90% processing time and integrate features that met the requirements.- Developed financial models to evaluate the impacts of 5 process-improvement initiatives on the 5-year expenditure planning.- Proposed a relational database to replace existing Excel-file collections, improving data integrity and enabling inventory tracking.

- Examined financial statements and capital budgeting of 40+ stock offerings and presented the projects’ feasibility to leaders.- Initiated a process to classify complaints and denunciations, reducing 60% workloads.- Acted as liaison between 3 teams to revised the formula of calculating the illegal profit, enabling for the first confiscation of $17,000. - Applied analytical skills (hypotheses formulating, data mining, visualization) to identify trading trends and suspicious transactions from large trading data sets; 13 violations leading to $200,000 in penalties were discovered.- Facilitated the establishment of the first DBMS by documenting business and functional requirements and coordinating between engineers and end-users; Acted as change champions in all IT initiatives.- Conducted interviews to investors and policy makers to match market’s expectations and regulatory requirements; An improper rule was repealed, increasing trading activities from thousands of investors. - Detected the accounting irregularities of 2 firms by analyzing inventories data and financial statements.- Oversaw cross-functional teams in 5 inspecting engagements and participated in 20+ similar engagements.- Presented regulatory solutions to senior leaders and interacted to diverse groups: investors, C-suites, policy makers. - Uncovered the insolvency and asset management fraud of a top-ten brokerage by inspecting its balance sheets, cash-flows and information management, resulting in a $15,000 fine and the suspension of its business.

- Advised customers about their banking needs and presented loan proposals to branch’s leader.- Developed plans for marketing banking products and acquiring customers for the new office.