Bingjin Jiang

HongKong SMO Business Strategy Analyst

China SMO Business Analyst

• Supporting researcher computational needs, including provisioning and supporting hardware and software • Creating and optimizing data collection instruments in REDCap • Cleaning and integrating data into a SQL data warehouse • Using R, RStudio, Python, Octave, Matlab, etc. to organize and analyze data • Interacting with researchers of all levels • Developing web applications and other software • Performing data discovery and data pulls • Supporting the activities of the Data Team more generally

Business Intelligence Analysis • Designed and created report templates, bar graphs and pie charts based on financial and operation data. Extract and gather data to create report on a daily basic to support business review. • Continuously monitor performance of newly developed business line, using Tableau for data visualization. Created and published interactive dashboards for review. Perform process improvements and evaluate the result through business intelligence analysis. • Wrote complex SQL queries using joins, sub-queries, and CTE for inventory management. Used various SSIS/ETL tasks for data scrubbing and data validation checks. Business Development & Revenue Generation • Built new business partnerships with warehousing operators, carriers and brokers through a global industry network (WCA), conducted onsite evaluation of facilities and negotiated pricing packages. • Developed the Custom Clearance business line and within two months processed 306 shipments with 1,430 containers, accounting for 30% of the total revenue. • Increased the success rate of order acquisition by 5.7% through reducing offer prices by 20% on average. This was achieved by decreasing shipping costs through negotiation and improved quotation management. Process Improvement & Cost Reduction • Reduced the company’s warehousing cost by 40% through establishing a new warehouse to replace the more expensive facility in use before. This new warehouse accounts for 95% of the total shipments and 69% of the total revenue. • Increased the process efficiency for the Custom Clearance business line by 24.1% within two months by refining documentation procedures that involve complex anti-dumping and countervailing cases. Baseline Operation Support • Conduct monthly onsite inventory check and operational monitoring at all warehouses on the east coast. Reconcile invoices from carriers, brokers, and warehouse operators and maintain an oversea warehouse management system (OWMS).

• Supported senior analysts in pricing mortgage-backed securities and other swaps using mathematical models. • Analyzed companies’ liquidity and activity ratio with industry average, and screened their capital structure. Supported credit review by forecasting companies’ long-term development opportunity through common-size. Determined the line of credit and wrote reports of credit extension plan.

Assisted in daily operation in ILL department. In charge of borrowing and lending request management, inter-department communication and cooperation, and new recruits training.

• Researched customer profiles to asses risks of corporate loans and maintained stable customer relationships • Analyzed companies’ liquidity and activity ratio with industry average, and screened their capital structure, which ensured low default risk of a corporate loan • Supported credit review by forecasting companies’ long-term development opportunity through common-size

Assisted with developing and executing a marketing campaign for a new hotel product, leading to 18% increase in sales. This included conducting market research, defining target customers, designing marketing theme, distributing promotional materials and evaluating sales performance.

• Assisted the manager in coordinating day-to-day business with individual customers and corporate clients • Provided customers with consulting service towards various business and guaranteed the daily management while manager was out of office • Promoted the entrusted funds to willing customers, dealt with the formalities of subscription and redemption.

National Scholarship 2009-2010(1%) National Scholarship 2010-2011(1%) Outstanding Student at ECNU (3%)