C# .Net developer expertise in C#/.Net, PowerShell, SQL and Excel VBA

JANET (JIA) ZHAO

** ***** ******, *********, **, 02420

Tel: 617-***-**** Email: *****.*******@*****.***

EXPERIENCE

CHARLES RIVER DEVELOPMENT Burlington, MA

Senior Automation Engineer/C# .Net developer Jan 2015-Present

• Expertise in C#/.Net, PowerShell, SQL and Excel VBA, Excel DNA programming; excellent debugging skills

• Develop API methods on product GUI with C#/.Net

• Develop and maintain automation core infrastructure with C#/.Net, SQL, Windows PowerShell and Silk4Net

• Develop SaaS application for automating customer workflows with C#/.Net, Excel VBA, and Excel DNA

• Develop programs for lab and test management with C#/.Net, PowerShell, SQL and VMware API

• Build test labs with Windows/Linux OS types and SQL Server/Oracle DBMS types

• Maintain automated testing results website with ASP and SQL scripting CHARLES RIVER DEVELOPMENT Burlington, MA

Automation Engineer Feb 2011-Dec 2014

• Created test plans with reusable test cases from business requirements and functional specifications documents

• Executed automated software regression testing on central testing environments and analyze results

• Developed and maintain automated testing script libraries with SilkTest, PowerShell and SQL

• Set up and maintain central testing environments on multiple platforms, including Windows, Unix, MSS and Oracle CHARLES RIVER DEVELOPMENT Burlington, MA

Product Specialist Oct 2010-Jan 2011

• Developed test plans for Investment Management System on equities, fixed incomes, and derivatives

• Executed manual tests on portfolio management, trading, compliance, post-trading, system administration modules TECHNICOLOR Beijing, China

Excel VBA Developer (Intern) Jul 2007-Jan 2008

• Designed and developed Excel macros to migrate data between Word and Excel files with VBA programming

• Maintained and upgraded macros for new user requirements EDUCATION

Boston University, Graduate School of Management Boston, MA Master of Science, Mathematical Finance September 2010

• Overall GPA: 3.84 / 4.0, High Honors, Member of Beta Gamma Sigma Honor Society Term Projects:

• Developed C++ programs to calculate option prices based on Black-Scholes and Heat Equations

• Utilized MATLAB programming to perform Monte Carlo Simulation with multiple security price distributions

• Financial time series study: collected 4900 stock index data from CRSP and Yahoo! Finance, created S-Plus code to regress ARIMA/GARCH models, and analyzed three different financial markets Tsinghua University, School of Economics and Management Beijing, China Master of Management, Management Science and Engineering July 2009

• Published IEEE Symposium paper using SPSS analysis: “Impact of Seller's Reputation on Online Auction Price”

(IEEE Symposium on Advanced Management of Information for Globalized Enterprises, 2008), First Author

• Published CNAIS Conference paper using SPSS analysis: “Factors Impacting Auction Results in Taobao.com”

(China Association for Information Systems 2009 Annual Conference), First Author Bachelor of Management, Information Management and Information Systems July 2007

• Hang Seng Bank Scholarship for academic excellent (first prize)

• Vice President of Management Information Systems Club; Class President SKILLS

• Expertise in C#/.Net, PowerShell, Excel VBA, Excel DNA programming, and MS SQL design

• Experience in MATLAB, S-Plus and Linux shell programming

• Experience in Agile/Scrum environment, Perforce, Microsoft Visual Studio and SQL Server Management Studio

• CFA Level 1 passed

• Green Card holder

Contact this candidate