Ran Pan Email & Phone Number

Washington, Dc, Us

Columbia, Md, Us

Us

Designed and Developed clinical CTRO Reporting System by C# using Restful API of Enterprise Wizard and ODBC of CTRP database(PostSQL). CTRO Reporting System is a MVC web application. It is used to generate turnround/workload/sponsor...reports ,update tickets and draw the workflow chart.

Reston, Va, Us

Developed MobileExpression and UltraWallpaper. I am in Registration department, which is reconstructed later. My duty is dealing with the problems of MobileExpression from JIRA tickets and add an Email module for sending email from our UltraWapper app to clients when they register. MobileExpression is a 3-tier web application and all the front end code are generated by the code saved in database, my job is to change the related database records. UltraWapper is an app can change the wallpaper dynamically by OpenGL, my job is to call the related OpenGL library and display the wallpaper based on the data in firebase.

Designed and maintained NCI clinical database. Developed stored procedures, triggers and schedule them for clinical data ETL. My duty is learning the data relationship from domain masters(clinical data managers) and design the database schema to transfer their excels data to our Oracle Clinical system.

Created clinical warehouses based on fixed schema and did secondary development in existing enterprise software. My duty is creating and improving C# custom functions and write pl-sql stored procedures. I also writes SAS code to do edit check listing based on company SOP.

Columbia, Mo, Us

Developed several websites for University of Missouri. They are about tutor and students registering courses and making appointments. They are all 3-tier web applications based on dynamic user controls templates and master page templates. My duty is to finish 3-tier classes and write html and jquery code based on templates.

Master, Computer Engineering

Master, Control Engineering And Instruments

Bachlor, Control Engineering And Instruments