C#.net developer

C#.NET Consultant Eric (Chunyi) Liu

Professional Summary

Five plus years of experience in full life cycle of software project development in various

areas like Web Applications, Database, Client-Server Architecture

Five plus years of experience on Microsoft Technology Visual Studio,NET 4.0/3.5, C#.NET,

C++, SQL Server, ASP.NET,MVC 3, jQuery with Computer Science background and

Financial industry experience

Created VBA programs to automatically update Excel workbooks, encompassing class and

program modules and external data queries

Extensively used Excel functions in development, focusing on read/write integration to

databases.

Solid experience in Analysis, design, development and deployment of various n-tier

client/server, Web Applications and Windows Applications

Good experience in Website design, hosting, configuration, IP Address scheme, Policies,

security issues, administration, updating

Expertise in Web IIS, Application and Database server installation

Expertise in MS SQL Server with SSMS/SSIS/SSRS 2000/2005/2008/2012, ETL, OLTP and

OLAP

Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS)

Strong experience with third party controls tool kits like Telerik

Well versed in managing the project with MS Visual Source Safe, Tortoise SVN and Visual

Studio plug-in AnkhSVN

Experiences of using C#/C++ program debug and memory-leakage-check tool to debug C#/C+

+

Experience in working with XML technologies like XML, XSL, XSD, XSLT and DTD

Extensive experience in developing Stored Procedures, Views, Indexes, Triggers, Cursors,

XML, Joins, user defined data types, functions and other Complex Queries on SQL

Server 2005/2008

Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules,

Performance Tuning, Query Optimization and Validation issues.

Experience in Microsoft Visual C#.NET in script component of SSIS

Built effective queries for high-performance reports and rendered them to HTML, XML, PDF

and Excel formats using SSRS

Created SQL Server Analysis Projects (SSAS) and proficient in Referenced relationships for

Business Intelligence applications using MS SQL Server 2005/2008

Experience in Managing Alerts, Operators and Jobs through SQL Server Agent and also

with SQL Mail

Data Modeling experience focusing on high-activity Normalized transaction systems (OLTP),

highly-usable Renormalized Reporting Systems (OLAP) as well as staging areas and data

marts

Good Hands on experience with Security implementation worked hands on with creation and

maintenance of databases, creating roles and managing user permissions

Has very strong background in a disciplined software development life cycle (SDLC) process

and has excellent analytical, programming and problem solving skills.

Experience in working with Operating System such Linux(Ubuntu) and Windows OS

(7/2003) administration activity and Security

email: ****.*********@*****.*** ph: 312-***-**** Page 1

C#.NET Consultant Eric (Chunyi) Liu

Extensive experience in software development methodologies including both Agile (Scrum)

and Waterfall models

Good hands on experience with production support on Large VLDB instance and provided

support 24x7

Good knowledge of various mathematical modeling methods for financial derivatives

Experience in Insurance Sales and Marketing domain

Has the ability to work in a fast paced environment, Good team player and can work

independently. Helped the database developers on technical issues

Technical Skill Set

Operating Systems Windows 2003 Server, Windows 2000, Windows XP, Windows Vista,

Windows 7, Linux

MS SQL Server SQL Server Management Studio, Business Intelligence tools (SSIS, SSAS,

components/environment SSRS), Crystal Report, BO, Performance Tuning, Capacity Planning,

Database modeling by using Erwin Data modeler

Languages C, C++, SQL, T-SQL, PL-SQL, Visual C#, Python, VBA, HTML, PHP,

JAVA. JAVA Script, XML, Telerik Web Controls

RDBMS SQL Server 2005/2008,MySQL,MS Access, My SQL

CASE Tools Erwin, Visual Studio, .NET, C#, VB.NET, ASP.NET, JAVA, Eclipse, Perl

& Shell scripts, MATLAB, IIS(Web Server)

Database Query Tools MS SQL Server Query Analyzer, SQL Profiler, SQL Server Management

Studio (SSMS)

Professional Experience

Cook County Chicago – Chicago, IL October 2011 – Present

Cook County has around 40.5 percent of all Illinois residents. Cook County's population is

larger than that of 29 individual US states and the combined populations of the seven

smallest states. There are over 130 incorporated municipalities in Cook County, the largest

of which is Chicago, which makes up approximately 54% of the population of the county.

.Net/Database Consultant

Web Form design and coding using Master Pages, Server controls, Cascading Style

sheet, JavaScript, html

Designed and coded Web Form using Mater Pages, Map Site, Cascading Style Sheet

(CSS), and HTML

Developed a prototype from scratch using ASP.NET MVC 3 and Entity Framework 4.3 for

referring patients to pharmacies within a network.

Involved in developing UI in the Presentation Layer, business logic and access in Business

Layer

Wrote business logic code in C#, C++ code behind files to read data from database stored

procedures

Parsing of XML documents was done using SAX and DOM and XML transformation was

done using XSLT

email: ****.*********@*****.*** ph: 312-***-**** Page 2

C#.NET Consultant Eric (Chunyi) Liu

Maintained local and offsite data storage and installed, configured, and supported IIS Web

Servers

Created different hierarchical, interactive reports using C# for Streams, Sectors

Designed User Interface using ASP.NET, C#. Written Business Layer in C# and wrote web

service Interfaces using C#. NET, ADO.NET, jQuery

Add new MS .NET components to existing COM and COM+ applications to develop a

.NET application that can do things like participate in transactions, take advantage of role-

based security, or interact with a queue

Developed Pages using Ajax enabled Telerik Controls for rich UI design and reduce post

back effect

Worked with Data Modeling and handling OLTP Databases and ability to design

databases upon requirements

Involved in Normalization and De-Normalization of existing tables for faster query

retrieval

Created daily queries involving self joins, correlated sub-queries, CTE and XML

techniques for diverse business requirement. Tuned and optimized queries by altering

database design, analyzing different query options, and indexing strategies

Created databases, tables, stored procedures, indices, foreign keys and any other objects

within the databases based on requirements from Developers

Wrote stored Procedure, scripts, cursors for the bulk application, tested them on the test

servers and moved them to the production

Created triggers to keep track of changes to the fields of tables when changes are made

Strong experience with SQL Server performance tuning and optimization, query

optimization, index tuning, caching and buffer tuning

Create a Microsoft Access project and connect it to an existing Microsoft SQL Server

database

Created SSIS Packages using SSIS Designer for export heterogeneous data from Access,

OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008

Designed and developed SSIS Packages (.dtsx files) to import and export data from MS

Excel, Access, SQL Server 2005 and Flat files

Worked on different kinds of Transformations in SSIS as per the client’s Requirement.

Created Extract, Transform and Load (ETL) processes

Designed and developed various complex reports such as Drill down, Drill Through,

Cross Tabbed using MS Reporting Services

Involved in design and deployment of Report Models for generating Ad-Hoc reports as

per the client requirements

Created Report Snapshots and Report caching to show the data changes over time

Assisted in developing OLAP cubes, wrote queries to produce reports using SQL Server

Analysis Services (SSAS) and Reporting Services (SSRS)

Experience in building Data Marts and multi dimensional models like Star Schema and

Snowflake schema

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and

aggregate views of large sets of data and used Multi-Dimensional expression (MDX) to

access them

email: ****.*********@*****.*** ph: 312-***-**** Page 3

C#.NET Consultant Eric (Chunyi) Liu

Development of system maintenance tasks such as Database Backup & Recovery,

database mirroring and replication and apply in Dev and Testing Environment

Assigned permission to user(s), roles, and object. Administrate security for servers logins

(Windows and SQL Accounts)

Skills into maintaining, writing, debugging and testing code in applicable programming

languages

Monitored growth of data and managed space allocation accordingly

Provided 24x7 production support for the US client's mission critical database

environments

Environment: MS SQL Server 2008/2012, Visual Studio 2005/2008/2012(SSIS, SSRS, SSAS),

OLTP, OLAP,T-SQL, Telerik Controls, IIS(Web Server), MDX, Web Services, Excel VBA,

ASP.NET, MS Access 2007, C#.NET, ADO.NET, .NET 4.0 T-SQL, and SQL Server 2005

Manager Studio, SQL Analyzer and Enterprise Manager and SQL Agent.

Exelon – Chicago, IL September 2010 – September 2011

Exelon Corporation (Exelon) is a utility services holding company engaged, through its

principal subsidiaries, Exelon Generation Company, LLC (Generation), in the energy

generation business, and Commonwealth Edison Company (ComEd) and PECO Energy

Company (PECO), in the energy delivery businesses.

SQL Server Developer

Implemented database design, modeling and handled OLTP and OLAP databases

Wrote business logic code in C# code behind files to read data from database stored

procedures.

Gathered requirements from end user and involved in developing logical model and

implementing requirements in SQL Server 2008, data validation, complete technical specs

and post production support

Designed User Interface using ASP.NET, C#. Written Business Layer in C# and wrote web

service Interfaces using C#. NET, ADO.NET, jQuery

Developed tables, indexes, stored procedures, triggers, views, and adding/changing tables

for data load and transformation and data extraction

Created and administered all SQL Server databases, objects, logins, users, and

permissions in each registered server.

Used SQL Server Profiler for troubleshooting, monitoring and tried to Optimize SQL

queries for improved performance and availability.

Import Data Sets from various sources like MS Access Databases, Oracle, Flat Files,

and Excel into SQL Server Data Warehouse.

Administered and enhanced SQL Server Integration Services (SSIS) data loads.

Created Query Parameters and Report Parameters to control data returned by the query and

filter data at report level

Developed queries for drill down reports to get the dataset required building the report,

created data source and data sources views for metadata view

Created SQL server Analysis Projects (SSAS) using MS SQL Server 2008

email: ****.*********@*****.*** ph: 312-***-**** Page 4

C#.NET Consultant Eric (Chunyi) Liu

Expert in calculating measures and dimension members using multi dimensional

expression (MDX), mathematical formulas, and user-defined functions.

Environment: MS SQL Server 2008, Visual Studio 2008(SSIS, SSRS, SSAS), OLTP, OLAP,T-

SQL, MDX, Web Services, Excel VBA, ASP.NET, MS Access 2007, C#.NET, T-SQL, and SQL

Server 2005 Manager Studio, SQL Analyzer and Enterprise Manager and SQL Agent.

Harbin Bank – Harbin, China September 2009 – August 2010

Harbin Bank is a Commercial bank, It was established in 1997 as Harbin City Commercial

Bank, opened its branches in Harbin City only, but changed its name to Harbin Bank in 2007

and has since opened branches in Dalian, Tianjin Shuangyashan and Jixi

Application Developer

Created Windows applications that gets all data from SQL Server and displays in DataGrid

by C# for automated trading platform

Used C#.NET to create applications that connects to database and downloads all the

columns into Datasets

Written separate C#/C++ Win Forms application to read and load the fixed length files in

to SQL server 2008 database

Implemented CRUD functionality with Entity Framework in ASP.NET MVC and

implemented sorting, filtering and paging with Entity Framework in MVC

Responsible to verify the incoming is well formed and well formatted using XSLT

Built numerous C# UI components and business modules

Proven background translating cell formulas in Excel into VBA code and using Excel-

based VBA to design, analyze, and deploy programs for finance industry

Assisted with automation of finance department’s manual processes by writing VBA code

and using macros and formulas to speed processes and maximize accuracy.

Developed stored procedures, triggers, views and adding/changing tables for data load and

transformation, and data extraction on SQL Server 2005/2008

Evaluated database performance and performed maintenance duties such as tuning,

backup, restoration and disaster recovery

Wrote scripts to review object permissions in all databases.

Performance Monitoring with SQL Profiler and Windows System Monitor.

Successfully deployed reports in various sources like XML, Web browser and PDF on

SSRS

Extensively involved in designing the SSIS packages to export data of flat file source to

SQL Server database

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS

Created maintenance procedures and provided Data Integrity strategies in SSIS

Used different Transformation in SSIS as per design specifications.

Identified and defined the Datasets for the report generation and defining the report layouts

Modified report content and exported reports in multiple formats based on user input

Involved in requirement gathering, analysis, design, development, change management,

deployment and user training

email: ****.*********@*****.*** ph: 312-***-**** Page 5

C#.NET Consultant Eric (Chunyi) Liu

Advanced Mathematical modeling credentials- Stochastic Calculus, PDE’s, Black

Scholes, Monte Carlo etc.

Proactive and Reactive tuning of databases in every stage of the project

Environment: Linux, Windows XP,C#.Net, J2EE, IIS(Web Server), MS SQL Server 2008/2005,

OLTP, T-SQL, Visual Studio 2005/2008, .NET 3.5 SSIS, SSRS Web Services, Excel VBA,

Oracle 10g, ASP.NET, MS Access 2007, SQL Analyzer and Enterprise Manager and SQL Agent.

Harbin Anzhixin Technology Co. Ltd – Harbin, China June 2007 – September 2009

Junior Database Consultant

Involved in writing scripts for the clients requirements for reporting purposes

Developed and maintained Database administration with SQL Server 2000/2005

Developed stored procedures, advanced queries, trigger, views, indexes by using T-SQL

Maintained databases, configured permissions, and conducted backup and recovery

Performed daily administration, monitoring, and documentation of SQL Servers

Responsible for tuning data, indexes, and queries

Automated and enhanced daily administrative tasks, including space management,

backup & recovery and performance monitoring

Database capacity planning and space forecasting

Assisted for Development and design the GUI with Eclipse and Visual Studio like MS Flex

Grid, List View, Tree View, etc.

Environment: Linux, Windows XP, Excel VBA, MS SQL Server 2000/2005, Visual Studio

2005, Eclipse, SQL Query Analyzer, Profiler, XML, Java, Erwin.

EDUCATION

Heilongjiang University – China

• Bachelor of Science

email: ****.*********@*****.*** ph: 312-***-**** Page 6

Contact this candidate