Ms. Wenqi Ma

Phone: (C) 917-***-**** *** Parsonage Hill Road

E-mail: ac711n@r.postjobfree.com Short Hills, NJ 07078

Profile

Senior IT system specialist with more than 18 years of experience in commodity trading/pricing systems and web-based design strategies using various technical tools and methodologies. Successful team-player who has been able to deliver solutions and projects on time and to maximum efficiency in energy pricing/trading/middle office, finance, education, e-commerce, telecommunications, e-learning, marketing, logistics, and corporate management.

Computer Skills

OpenLink Endur, Oracle, JVS/Java, Eclipse, AVS scripting, WCF

SQL Server 2012/2008/2005/2000, SSIS, SSRS, Oracle backend for Endur

ASP, C#, VB.Net, ASP .Net, ADO.Net, JavaScript, MVC, Node.js, JQuery, JSON, AJAX, CSS and HTML5

MS IIS, SiteMinder, Google Search Appliance

Visual Studio, Crystal Reports

OOP, Full project life cycle, Agile, Enterprise Architect, Architecture

Experience

Power Trading System Specialist, Direct Energy; Woodbridge, NJ 08/2015~ present

Improved physical gas settlement accuracy by writing new settlement invoice to settle with the counterparties by using Java/JVS scripting, Oracle skills

Improved ICE to Endur deal booking efficiency by customizing its logic and return message and this helped traders and product control to book trades faster

Use C/AVS scripting, SQL Server skills to support OpenLink Endur V9

Facilitated the migration from Endur v9 to v14 by writing SQL scripts to migrate volatility and correlation

Improved deal booking process by writing new business functions to book/amend trades

Have business knowledge of commodity trading and support traders/middle office/back office on a daily basis

Projects

OpenLink Endur V9 migration to Endur V14

OpenLink Endur V9 daily support and Endur V14 daily support to front office traders

Power pricing system developer, Direct Energy; Woodbridge, NJ 12/2009~ 08/2015

Use C#., VB.Net, Visual Studio 2010/2012, SSIS, AJAX, SQL server 2005/2012 to enhance and support an application that has high performance requirement to support electric sales/pricing operations and wholesale trading desk.

Greatly improved pricing application performance by properly indexing the tables, rewriting stored procedures and modifying the application coding

Modify, enhance and add new functions to the web service to connect Salesforce and Genesis application in a WCF project.

Improved system efficiency and performance by reviewing the system architecture and identifying technical bottleneck spots to improve.

Helped power pricing team, Sales, billing and Trading Desk to price power deals quickly and realize sales more quickly

In-depth business knowledge of power pricing and electric market

Projects

Proposal management system – Genesis, Interface between Genesis to Endur, Interface between Salesforce and Genesis, Interface between HU and Genesis.

Consultant, Aegis; East Rutherford, NJ 10/2009~ 12/2009

Use C#., Visual Studio 2008, AJAX controls, SQL server 2005 to write an Asp.net reinsurance application in WCF.

Projects

Alliance reinsurance application for the finance department.

Senior Software Engineer, Kaplan K-12 Learning Services; New York, NY 09/2008~ 06/2009

Used C# to write new features for existing applications and wrote all required stored procedures and SQL functions.

Used Enterprise Architect to do UML design for Customer Care Tool.

Used C# and .Net 3.5 to write new components to integrate different applications and enhance the security of existing applications.

Used SQL Server Reporting Service to complete ACT online reporting application.

Projects

Customer Care Tool to manage teacher/student course/test registration.

ACT Online Reporting to report ACT test results for different school districts and schools.

LMS (Learning Management System) to manage causes/tests at levels of school districts, schools, teacher and students; Custom Membership Provider for security enhancement.

A tool to export xml to csv in both windows and web environments.

Senior Web Developer, National Financial Partners; New York, NY 07/2007~ 08/2008

Researched user needs and different technologies; implemented optimal solutions to meet NFP’s business needs.

Teamed with colleagues and vendors such as Google Tech Support, Computer Associates security consultants and other development consultants to implement software to facilitate NFP’s business development.

Worked on the Foreign Currency Enhancement for NFP’s account/finance software

Used asp, javascript, sql server to program complicated cash management, revenue/expenses tracking functions

Used C#.Net, ASP.Net, Google Search Technology, Microsoft Mappoint Web service, Computer Associates SiteMinder/Identity Minder, weather.com web service to program Secure Site Search, People Search, Firm Search, Weather, and other Intranet components in web service oriented architecture.

Used C#.Net to write a system application to monitor and manage web service

Used C#.Net, ASP.Net, SQL server 2005 to prototype the integration of Dot.Net controls from ComponentArt with the classic asp application

Programmed in C# to integrate all the third party components into one unity for the intranet project

Used Crystal Reports to create complicated financial reports for the web application

Used C# to combine the Google Search technology with the security software SiteMinder to implement secure search based on the users’ security rights

Used C#.net to program the request system with custom base classes for the intranet

Used SharePoint to manage application ticket status

Projects

NFP Intranet and Public Site using C#, VS 2005, Google Search Appliance, SiteMinder, CMS, MS Mappoint.

Management of Information Systems, an accounting/finance software used to manage revenue, personnel, and finance reporting.

Consultant 01/2007~ 06/2007

Developed software for hedge funds and other finance companies with C# and SQL Sever 2005. In charge of the application structure design, interface programming, and database programming.

Used VB.Net to program SSIS project to export/import data

Used C#.Net to program functions with interface inheritance for a public site

Consultant Kraft Food International Headquarters; East Hanover, NJ 06/2002~ 12/2006

Obtained end-user specifications and conduct project planning and project management work during the whole process of software development

Designed and optimize database structures; created views, triggers, and stored procedures in MS SQL 2000 server to meet complex business logic requirements

Developed Intranet applications with ASP, ASP.NET, C#, XML, XSLT, JS, VB, DLL, COM, Adobe Products for a marketing application

Developed Windows-based applications using VB6 for global marketing management

Assisted and trained end-users in applications usage, provided on-going support to users

Projects at Kraft Food

CARRIER RATES, a logistics Intranet application for the Export Transportation Department, including generating numerous web reports for senior management decision-making support

ACES (Agency Client Evaluation System) for Marketing Department, including:

- A web-based application for worldwide corporate Intranet end users

- A windows-based administration tool for headquarters management

Various web-based and windows-based reporting tools for marketing management

Special Situation, an application developed from scratch and used by the legal department to manage teams and all contacts

Consultant, Alden Design, Inc.; Westport, CT 04/2001~ 03/2002

Clients: Pfizer, Honeywell, National Corporate College

Designed database structures and relationships from scratch

Programmed for web and windows applications with Oracle, Cold Fusion, ASP, JS

Projects

University of Pfizer career development Intranet application

University of Pfizer management/administration Intranet application

Global Learning & Development Intranet application for Pfizer

Recruiting web site for National Corporate College Consultants, Inc.

Animal Health campus Intranet application for Pfizer

IHR Phase VII management Intranet application for Pfizer

An Internet-based survey tool for Honeywell

Consultant, Keane, Inc.; Danbury, CT 09/2000~ 04/2001

Client: Silicon Valley Group (ASML) Wilton, CT

Designed and implemented a database for a management application with Oracle

Designed and programmed user interface with VB 6.0, using external objects (Office objects), ADO and many VB6 ActiveX controls

Wrote ActiveX controls, Class modules with VB6 for application development

Project

A manufacturing management application for Silicon Valley Group with VB6, Oracle

Education

Master of Science (M.S.) in Information Systems,

Penn State University, PA

GPA 3.79 / 4.0

Bachelor of Science (B.S.) in Accounting & International Banking,

Central University of Finance & Economics, Beijing

GPA 3.6 / 4.0

Contact this candidate