Software Engineer Service

Ziqi Liu

Phone: 201-***-****

Email: *******@*****.***

Skills:

Hadoop, Mave, Git, Svn, Bsh, Java, JavaScript,C, C++, .Net C#, XML, InfoPath, VB, Vbscript, VBA, Power Shell, Bsh, Selenium, Webdirver, Firebug, Firefox, OTA

Platforms:

Linux, Windows, Unix, Sharepoint, Salesforce, WRT

Work Experience:

6/2012-Present, Programmer/Analyst Becton Dickinson

Linux

Plateau Learning System customization and enhancement

System integration engineering.

Sharepoint

Web based application test design and engineering: Selenium, Webdirve, C#, Nunit

Architected, designed, developed, maintained Powerpivot automated dashboard on Sharepoint.

Designed, developed, maintained, upgrade InfoPath XML form and functionality

Designed, developed, maintained, upgrade Nintex work flow and Web Service for users across organization

Designed, developed, maintained selenium automation test framework for HPSM, Sharepoint infopath with Selenium IDE and Webdriver

Designed, developed, maintained workflow and OTA application for HPQC

Expanded InfoPath form functionality with C# and Visual Studio

Architected, Designed, developed, implement and maintained Sharepoint solutions

Configured and maintained Sharepoint structures (such as documents libraries, list, and Sharepoint site collections)

created a virtual environment using SQL Server 2008 R2, Oracle 10g, Sharepoint Server 2010 with Powerpivot Service, Window Server 2008 R2 64x, Excel 2010 and VMware Player

BI

Architected, Designed and developed BI Analysis Report (Operational Metrics, SLA) with Excel Powerpivot

Architected, Designed and developed Sharepoint Powerpivot automated solution

Automated Pdware report

SAP BI explorer and cube creation

Designed adhoc query for Oracle, SQL server, Access data analysis

Data Quality & Management and Business Process Improvement

Application Development & UAT Testing

Production Support

HP Quality Center, Quick Test Professional

SAP Solman

Replicon

Pdware

G3

HPSM

Salesforce

6/2006-6/2012, Senior Software Engineer Moody’s

Web Intranet Report Extraction System

Architected, Designeded and implemented integration to consolidate heterogeneous UNIX applications into one web application.

Customized Apache Http web server to bind Tomcat as one web server virtually for end user.

Found and Implemented remediation for the integration, software upgrade and system migration. (C/C++, Perl, Sybperl, PHP and Python, JSP and Java Servlet)

Optimized Java code with Spring and Hibernate. Improved enhancement productivity 200%.

Optimized data connection code with JNDI data source.

Led a team of engineers proceeding QA process for task above.

Moody's Financial Metrics

Designed and maintained Sharepoint site collaboration between development and rating group

Requirements acquiring, Data analysis, Database modeling, Application development.

Rating Committee Package, LGD, Key Indicator/Workforward Report, Summary Financials Report, Rating Predictor Mode, RTM lite, Rating Methodology and industry Median Excel based report development and enhancement.

SQL server and Sybase schema and stored procedure Designed and coding.

Dynamic VBA coding for Excel/Pivot/Chart powerpoint report.

Skillset: C#, AJAX(JSON), LINQ, Entity Framework, Web service, SQL coding.

Excel Financial Data Entry and Edit Tool

Dynamic Excel Template.

GUI and layout Designed, Event handling.

C#/VBA implementation with OLEDB.

Software upgrade and migration

Coordinate system backup, test, remediation and deployment for Corporate Finance Groups

Win XP to Vista, AIX 5.1 box to 6.1 box, Java 1.3 to 1.5, Visual Studio 2003 to 2008.

Migrated VB.NET to C#.NET, MS Access to Mysql.

Throughout experience in Moody’s

Working with business stakeholders, and production teams and across functional units to identify business needs and analyze data to provide solution option

Excel worksheet and report automation.

Ad hoc SQL query, Data Extraction and Transformation with DTS/SSIS.

Unit test case automation for Excel, Stored Procedure and Web page.

Debian/Firefox compilation, installation, configuration through Mercurial

Windows, Linux (Debian/Ubuntu) Virtual Machine (kvm/Xen/Vmware) installation, configuration and integration. KVM/Xen, Vmware and Virtual PC conversion. Physical to Virtual conversion.

Setup simplified development and test environment for FM Corporate Finance Group.

3/2005-5/2006, Senior Consultant (CTG) Citi Group

Stepped in on 4 monthly report that were running behind schedule and shipped them on-time by automation

General ledge data analysis, Database Remodeling, report optimization, ad hoc report. And routine report solution development.

Developeded new processes to facilitate import and normalization, including pivoted data for counterparties through DTS.

Developeded Automatic Dynamic Analysis Web Reports with C#, ASP.NET, VB.NET, Excel, Web Service and middle tier Active X Component.

5/2004-3/2005, Sr. Software Engineer (Tek System) AT&T

Developeded Excel Strategic Pricing Tool

developed web service to find breakeven point for the tool.

Integrated Excel/C# applications with Web Service.

Create web form and event handler for ASP.NET application

Created Excel mega-algorithms.

Used .NET studio to developed web service for Excel application

Used Excel/VBA to collect customer information submitted through the web service.

Designeded database and Created stored procedure for SQL server and Oracle.

The other ad hoc tasks:

Used Macro/SAS to perform customer and data segmentation.

Used Crystal to produce reports to identify potential customer segments.

Created pivot table report and published it on the web for company management by using ASP.NET and ADO.NET technology with Oracle and SQL server.

Prepared data (treating missing value, finding outlier, etc.) for descriptive statistics, proceeded multi-regression analysis, hypothesis test and Exploratory Data Analysis.

Designeded and implemented website with Linux/Tomcat, LAN, WAN, DNS, Firewall, VPN and email.

2002-2004, System Architect (Genewiz)

End-to-end Hardware and system integration: Redhat, apache, Tomcat

Engineering and Migration Windows web application to Linux Web application

Enhancement Php, Perl and Java for Linux Web Application

1997-2004, Software Engineer (Vital Computer Service)

ATT Cost Analysis Excel/C# Web application:

Hardware and software Designed, development and deployment.

Full life cycle: Evaluation, Analysis, Designed (hardware, software), Implementation (Hardware selection, purchase order, OS installation, configuration, software configuration coding), Testing, Production.

Integrated SourceSafe with Excel/VBA development environment.

SDAT application

End-to-end Designed, development and deployment.

Simplified workflow scattered across different Excel spreadsheets.

developeded modules using ADO, ASP, Stored Procedures and Views.

Designeded and developeded and integrated dynamic Excel MapInfo circuit report

Set up and hosted IIS on NT to support running the applications

OCX Application

Set up and administered a Netscape server on UNIX to support running OCX Web application

Designeded and developeded VB script tools for production maintenance simplification.

Using SAS as data engine to produce analysis report for web application on fly.

Responsibilities and Tasks:

Automated charts, pivot tables and the other mundane tasks such as formatting weekly reports.

Created SAS data set

The details including daily jobs but not limited to:

Created Excel spread sheets to analyze sales cash flow or circuit spare capacity by utilizing statistics add-in or pivot tables etc; developeded Excel/ VBA /SQL code to connect front desk spreadsheets to various systems such as Oracle, Sybase, SQL sever, Access and other spreadsheets; Captured and archived live data (Electronic Data Capture) on a regular basis; Supported data-intensive Excel VBA applications;

Compared budget data in Excel against data imported from corporate budgeting system; Interacted with users across organizations and other technical and business groups, iteratively gathered user requirements, converted them to technical specifications, incorporated them into a model leading to Designed and coding, deliver high availability applications in a fast paced environment.

Education:

MS and BS in Computer Science

Certification:

MCP,http://www.mycertprofile.com/Profile/460-***-****/12/6/share

MCAD,http://www.mycertprofile.com/Profile/460-***-****/50/441/share

MCSD,http://www.mycertprofile.com/Profile/460-***-****/12/6/share

Training:

Sharepoint BI, Sharepoint development, Cognos 8 BI, AMA’s Finance Workshop, IBM RAD, Spring and Hibernate, Solman

Contact this candidate