Software Engineer / Developer

Christy (Hongxia) Zhao

Tel: 713-***-****; Email: ***********@*******.***

========

Summary

========

• Outstanding experience in designing, developing and maintaining business decision support systems, Dashboards and ad-hoc data analysis using MS SQL Reporting Service (SSRS), MS ACCESS, MS EXCEL (mainly pivot table, VBA Macro) and MS ASP.NET

• Solid skills in database design and data management in MS SQL Server 2005

• Intensive experience in computer programming with C/C++, SAS, SQL, ASP.NET, HTML, VB Script, Java Script and VBA

===========

Experience

===========

(1). Sr. Analyst, Pricing and Revenue Management Department, AMTRAK, 2007— Current

• Designed, developed and maintained Pricing and Revenue Management Dashboards using MS ASP.NET and MS SQL Server 2005 Reporting Service (SSRS) to support corporate profitability.

• Created ad-hoc reports and conducted data analysis in MS ACCESS, MS EXCEL (mainly pivot table & VBA Macro) and SSRS to support business decision making.

• Designed and developed Overbooking, High Revenue Spill/Low Revenue Spoil, RASM (Revenue per Available Seat Mile) KPI reports.

• Created and designed OLAP Cubes prototypes using MS SQL Server Analysis Services (SSAS) to support better revenue management practices.

• Monitored and maintained system functions to enhance the accuracy and responsiveness of several revenue and capacity management systems in MS ACCESS and maintained several big databases with millions records in MS SQL Server 2005.

• Actively involved in the whole life cycle of several business projects, leaded requirement collection, system design and user acceptance test.

• Practiced dashboard and reports design using Crystal Xcelsius and Crystal Report.

Research/Teaching Assistant, ISE Department, University at Buffalo, SUNY, 2004—2006

• Proposed new models and optimization approaches to solve NP-Hard integer and linear programming problems.

• Directed graduate level students on course work (Discrete Optimization, Stochastic Methods) and mathematical software (ILOG OPL) usage.

(2). Research/Teaching Assistant, ISE Department, University at Buffalo, SUNY, 2004—2006

• Proposed new models and optimization approaches to solve NP-Hard integer and linear programming problems.

• Directed graduate level students on course work (Discrete Optimization, Stochastic Methods) and mathematical software (ILOG OPL) usage.

(3). Graduate Assistant, University at Buffalo Information Technology Center (UBIT), 2002—2004

• Provided consulting services to academic users in University at Buffalo of mathematical and statistical softwares, including: MATLAB, MAPLE, Mathematica; SAS, SPSS

• Tested aforementioned mathematical and statistical softwares before their academic usage in University at Buffalo.

• Developed a prediction algorithm (a modified data mining algorithm for classification) to identify potential customers who are interested in a car insurance policy.

==========

Education

==========

Ph.D. Industrial and Systems Engineering, University at Buffalo, SUNY

M.S. Computer Science and Engineering, University at Buffalo, SUNY

Contact this candidate