chunyan luo

* Updated logistic information in databases and created logistic information reports * Monitored and supported broker compliance; interceded with broker and Customs to ensure compliance to expedite entry release * Monitored international shipments moving, provided shipment visibility and status, and ensured delivery on time * Communicated with vendors, buyers, customs, brokers, and forwarder for steamship lines to increase productivity

Retrieved patient medical information from hospital data warehousing; updated data in database, queried reports and created views Entered patients information into database; ensured high data quality with consistency, accuracy, and completeness, and collaborated with P.I. , medical doctors, and/or lab technicians to resolve data discrepancies and missing Maintained data security to comply with regulations and privacies

* Conducted statistical reports on daily purchasing and controlled quality of products * Projected inventory demand in future and contained cost of inventory * Collected oil market information, appraised and wrote quality reports * Scheduled distribution of oil to gas stations and filed records of contracts and transaction records

*  Write SQL Scripts to load different format data into database, join tables, update/modify datasets as needed, etc. *  Collect and evaluate statistical data from multiple data sources. Interpret and analyze healthcare utilization data from various sources and provide data solutions and customization reports to clients *  Write complex formula and create PIVOT TABLE to calculate health care cost and Medicare reimbursement for clients by using EXCEL IF/ VLOOKUP/ MATCH functions *  Develop and construct queries to perform reports on Medicare and Medicaid data. Generate standard reports by utilizing healthcare and financial data using MYSQL. Present reports to management team and data end users *  Verify hospital claims for reimbursement by using 3M™ Core Grouping Software *  Produce visualization healthcare reporting metrics across hospitals, physicians, insurance programs, and regions using TABLEAU software

* Analyzed cost comparison and reported to operation department manager. * Provided customers support by retrieving information from system. * Kept track sale orders, worked with customer service and support, and ensured the products were delivered on time.