Post Job Free
Sign in

Sql Server .Net Developer Data Project Service

Location:
Hyderabad, AP, India
Posted:
November 13, 2013

Contact this candidate

Resume:

Frank Jiang

Background Summary:

• Expertise in Object Oriented Programming (OOP) and OOP based languages such as C#.NET and VB.NET. Deep understanding

of Software Development Life Cycle (SDLC): Planning, Analysis (requirements gathering and analysis), Design (UML and Data

Modeling), Development (coding and testing) and Implementation, and Maintenance.

• Expertise in .NET Frameworks, Common Language Runtime (CLR) and Dynamic Language Runtime (DLR) environments.

Worked with .NET Integrated Development Environment Visual Studio 2008/ 2012 Ultimate and Team Foundation Server 2012

(TFS).

• Professional in C#.NET and VB.NET: C# coding conventions, DataTypes, Type Casting, Loops, Collections (Set, List<T>,

Dictionary(Tkey, TValue), Tuple, Queue, Stack etc.), Classes and Interface, Delegates and Events, Threading, File

Input/output (I/O), Lambda Expression, frequently used interfaces (IEnumerable, IComparable, ICloneable, IDisposable)

etc.

• Strong Exposure with software architectures such as Service Oriented Architecture (SOA), Model View Controller (MVC),

Model View ViewModel (MVVM), Code Behind Methodology, C/S Model, 3 Tier/N Tier Model, Singleton/Factory Pattern etc.

• Comprehensive knowledge in working with database access ( ADO.NET + Data Binding): Language Integrated Query (LINQ to

Object, LINQ to SQL, LINQ to XML, LINQ to ADO.NET, Entity Framework), ODBC, OLEDB, SQL Server, Access, Oracle, XML,

Serialized Objects. Worked with ADO.NET Objects such as SQL Connection Object, SQL Command Object, Data Reader Object,

Dataset Object and Data Adapter Object.

• Skilled in developing and using Class Library, Assembly, and COM+. Experienced with Static Binding and Dynamic

Binding/Late Binding/ Runtime Binding.

• Expertised in developing Graphic User Interface (GUI): WinForm or Windows Presentation Foundation (WPF): XAML, Routed

Events, Dependency Property etc.

• Skilled in developing Web Application: ASP.NET (Data Sources: SqlDatasource, ObjectDataSource, XMLDataSource,

LinqDataSource, Web Controls: GridView/ ListView/ DetailsView/ FormView/ Repeater/ DataPager, Bind with ADO.NET

data provider, Membership Management (roleManager), Custom Control, Control Validation, Theming, Session, ViewState,

Caching, Cookie, Hidden Fields, Razor etc.), HTML5/ CSS3, VBScript, JavaScript/JScript, JSON, JQuery, AJAX etc.

• Worked with HTTPHandler, Request/ Response model. Familiar with GET/POST method.

• Skilled in developing provider/consumer with Windows Communication Foundation (WCF): XML, WSDL, SOAP etc. Worked with

Windows Service: development, registry, implementation etc. Worked with Windows Workflow Foundation (WF). Experienced

with software configuration, code compilation, and component registration using Command Prompt.

• Comprehensive knowledge and worked with API: Threading, Socket, Remote Method Invocation (RMI), JDBC Level 4 Driver

(API to DataSources), Enterprise Java Bean (EJB), Web Service (JWS), Servlets etc. Worked with J2EE Integrated

Development Environment NetBeans 7.2 and Eclipse Enterprise 4.2.

• Experienced with Data Modeling: Conceptual Design, Logical Design, and Physical Design. Skilled in SQL queries: Data

Definition Language (DDL), Data Modification Language (DML), Data Control Language (DCL), Transactional Control

Language (TCL) etc.

• Excellent Experience in design/development/implementation/maintenance of Database as well as SQL Server using ERwin Modeler

and Microsoft SQL Server Management Studio . Experience in connecting and retrieve data from different types of data source

such as SQL Data Source, Object Data Source, Access Data Source, and XML Data Source.

• Professional in MS T SQL and Oracle PL/SQL: User defined Function (UDF), Stored Procedure (UDP), Trigger, Views,

Common Table Expression (CTE), JOINS, and Cursor etc.

• Familiar with Data warehousing (ETL, OLTP, OLAP, Dimension and Fact Model etc.), worked with SQL Server Management

Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), Oracle SQL Developer &

TOAD, Oracle 11g/10g/9i, Informatica, and Cognos.

• Experienced system design with UML: Structural Diagram (e.g., Package Diagram, Class Diagram) and Behavioral Diagram (e.g.,

Activity Diagram, Use Case Diagram, Sequence Diagram, Communication Diagram, and State Machine). Familiar with prototyping.

• Knowledge in conceptual of Telecommunication and Network Security, understood TCP/ IPv4/ IPv6/ UDP/ FTP, Encryption and

Decryption processes and mechanisms, Synchronous/ Asynchronous algorithms, Private Key/ Public Key usage, and

Authorization/ Authentication/ Digital Signature Model. Worked with encryption tool GPG 4.0.

Frank Jiang

• Used StyleCop, Resharper to analyze source code to enforce a set of style and consistency rules. Used Fiddler to inspect traffic,

set breakpoints, and "fiddle" with incoming or outgoing data.

Technical Skills:

C#.NET, VB.NET, C++, T SQL, PL/ SQL, HTML5/ CSS3, DHTML/ JavaScript/ Jscript/ VBScript/

Programming Language

Regular Expression, Java/ J2EE

ADO.NET/ Entity Framework (EF), LINQ, XML/ Xpath/ XmlDocument/ XmlTextReader/ LINQ to

XML, ASP.NET/ Custom Control/ Control Validation/ Session/ ViewState/ Cache/ Cookie/ Hidden

Field/ Theming, DHTML, JScript/ JavaScript/JSON, JQuery, AJAX, MVC/Razor, WCF, SOAP,

UDDI, DISCO, WSDL, HTTP+XML, Windows Service, WinForm, WPF, XAML, Routed Events,

.NET Skills

Dependency Property, Workflow, Delegate/ Event, Arrays/ Collections, Lambda Expression, File

I/O, Serialization, Threading, Sockets, IComparable, IDisposable, IEnumerable/IEnumerator,

ICloneable, Exception Handling, Stack Trace Printing

Remote Method Invocation (RMI), Enterprise Java Bean (EJB), Servlet, Web Service (JWS),

Oracle JDBC Level4 Driver 4.0, XML/Xpath, File I/O, Event, Arrays/ Collections,Serialization,

J2EE Skills

Sockets, Threading, Exception Handling, Stack Trace Printing

Model View Controller (MVC), Model View ViewModel (MVVM), Model View Presenter (MVP),

Singleton Factory Model, Multi Tenant Architecture, Client/ Server (C/S) Model, 3 Tier Model, N

Architecture Patterns

Tier Model

Integrated Development Microsoft Visual Studio .NET 2008/ 2010/ 2012, Team Foundation Server 2012, NetBeans 7.x,

Environment Eclipse 3.x/ 4.0

Microsoft Visio 2013/ 2010, Aptana Studio 3, UMLet 11.0, ERWIN 4.X

Design Tools

Microsoft SQL Server 2012/2008 R2/2005, MSBI (SSMS/ SSIS/ SSAS/ SSRS), Oracle 11g/10g/9i,

Database/Data

NoSQL

Warehousing

Microsoft Excel/ Word/ PowerPoint/ Access/ FrontPage/ Project 2013, Photoshop CS4,

Other Tools

Dreamweaver CS4, Aptana Studio 3, GPG 4.0, VMware, Joomla

jQuery UI, knockout.js, anguler.js, ReSharper, Telerik

Third Party Tools

Agile/ XP/ Iterative Design, Parallel, Waterfall

Methodologies

Network Security, TCP/ IP, UDP, Symmetric/Asymmetric Encryption/ Decryption, Key

Network and Telecom

Distribution/ Authentication, Distributed Network/ LAN/ WAN/ VPN

Professional Experience:

.NET Developer: Vensoft AZ, US May’13 – Till Date

Project PRONTOH.COM Online Health Care Provider appointment portal

PRONTOH.COM is a medical care scheduling service, designed to be efficiently used by primary and specialty care clinics, patients to

manage access to service providers, as well as by hospitals to schedule elective surgeries. It is also aimed at improving access to

healthcare. Subscribers can gain access to the scheduling system and find doctors, as both online service and via deployed office

calendar or integrated with their websites. Patients can access the website at no cost and can see the schedule of subscribers – doctors.

Frank Jiang

Responsibilities:

• Worked on Agile Development Methodology. Iterated the SDLC (planning, analysis, design, coding, unit test, and

acceptance test) to develop final delivery.

• Worked with Model View Controller (MVC) architecture as well as both Inline Model and ASP.NET Code Behind Model.

• In the server side, Used Telerik to automate data access object generation. Implemented business logic functions with LINQ (e.g.,

LINQ to Objects, LINQ to XML, and LINQ to SQL).

• Developed Webservice providers using WCF, disposed and consumed the functions and data using WSDL, UDDI, DISCO and

SOAP.

• Developed WCF services to interact with third party systems to pull patient, Facility and Provider’s information.

• Used Design Patterns such as Factory Method, Singleton method patterns in the applications to make interactions between classes

or objects, without specifying the final application classes or objects that are involved.

• Created web forms, applying master page, custom controls and styling (skins and themes) on dynamic web pages with

ASP.NET and wrote static pages to return to clients enhanced by code in JavaScript/JScript and JQuery/JQuery UI/knockout.js.

Adjusted page layout and style in HTML and CSS. Created validation controls to validate input.

• Worked with ViewState/ Hidden Field, Cache and Cookie to store or partially store a page and its information. Used Session to

manage user login and logout.

• Experienced with Request/ Response process, GET/ POST method, and redesigned navigations using Hyperlink/ Transfer/

Redirect linking methods.

• Created user group and membership management module using ASP.NET Configuration Tool. Configure web.config file and set

up roleManager. Based on different user group, users (practitioners or patients) will get different dashboards and corresponding

functionalities.

• Cooperated in data modeling: transferred business requirements into tables. Cooperated in normalization: normalized tables into

3rd level, and design Entity Relationship Diagram.

• Created specific views, stored procedures, triggers used to safely retrieve or update data from the underlying table in order that

could be accessed by .NET application.

• Cooperated in UML (class diagram, package diagram and sequence diagram) design, modification and documentation.

• Prepared user manual and trained users regarding the use of application. Installed and tested application packages.

Environment:.NET Framework 4.5, Visual Studio 2012, MVC, ASP.NET, C#.NET, Telerik, ADO.NET, IIS 6/7, XML, XSLT, MS SQL

Server 2012, T SQL, JQuery/JQuery UI, JavaScript/Jscript/JSON, LINQ To SQL, LINQ to Objects, LINQ to XML, WCF, NUnit,

Visio 2010, UMLet 12.0, MS TFS 2012.

.NET Developer: University of Florida Jan’13 – Apr’13

Project UFCR System

UFCR system is a powerful CRM tool for developing long term relationship with current and future customers. With sophisticated business

logic components in built, it provided market agents and managers with information gathering tools, analytic tools and report subsystems

providing smarter customer intelligence.

Responsibilities:

• Used Team Foundation Server (TFS) to perform group tasks. Cooperated with team members and clients, working on Agile

Development Methodology. The system was deployed as an ASP.NET web application running on IIS.

• Worked with Model–view–controller (MVC) software architecture pattern, coded web pages using Web Form plus Razor notation.

• Deployed distributed system using Service Oriented Architecture (SOA). Utilized WCF Web Service to dispose server data and

business functions.

• Developed the user controls using code behind classes. These were integrated with the AJAX enabled Telerik controls for extended

functionality providing a rich presentation layer.

• Worked with N layers architecture to reuse code, enhance data security, and simplify code structure. Focused on implementing logic

and design on Three layers (business object layer, data access layer, and presentation layer).

• Enhanced static pages with DHTML technology such as CSS, JavaScript/JScript and JQuery/JQuery UI. Created user friendly

graphic interface using master page, custom controls, client side validation, tooltip controls and Theming.

Frank Jiang

• Worked with Request/ Response process, properly use GET/ POST method, familiar with the use of Hyperlink/ Transfer/ Redirect

page navigation methods.

• Wrote custom exception class to catch specific exceptions, print detailed error message, and take corresponding measures.

Worked with Exception handling to deal with runtime errors and improper user input.

• Used server controls such as DetailedView, FormView, and DataPager to properly display data retrieved from SQL Server. Worked

with AJAX Control Toolkit (ScriptManager plus UpdatePanel Control). Used server side validation as a double secure

measure on data imported.

• Defined user group with ASP.NET Configuration Tool and add authentication rules in web.config file, creating user roles and

setting up roleManager properties.

• Used ADO.NET Dataset Object to access the databases and gather all relevant information to be stored. Developed stored

procedures to carry out all the Data Manipulation operations on the Database.

• Defined and implemented customized configuration settings for the local Web.Config file of application. Created and modified class

libraries to provide desired functionalities and identified the best data sources to gather information for presentation.

• Coded database access library and performed data exchange and modification with ADO.NET (e.g., Connection, Command,

DataReader, DataAdapter, and DataSet) and Entity Framework. Wrote and compiled stored procedures and queries to retrieve

data from views and underlying tables.

• Assisted on requirements gathering and data modeling (database design, normalization and forward engineering). Created and

managed database roles, set up foreign key relationships, established triggers and cursors to enforce data reading and writing

rules.

• Used NUnit to test C#.NET classes. Performed unit test and performance analysis on SQL queries. Documented test results and

each version after updating.

Environment:.NET Framework 4.0, Visual Studio 2012,Telerik Controls, ASP.NET, C#.NET, VB.NET, ADO.NET, IIS 6/7, XML,

XSLT, MS SQL Server 2012, T SQL, JQuery/JQuery UI, JavaScript/Jscript/JSON, AJAX, LINQ To SQL, LINQ to Objects, LINQ to

XML, WCF, NUnit, Visio 2010, UMLet 12.0, MS TFS 2012.

.NET & J2EE Developer: University of Florida Jul’12 – Dec’12

Project Order Invoice Recording System

The Order and Invoice Recording System accepted orders through multiple sources, online or on site, and then generated invoices as well

as updated dataset synchronized with the central database. The project was developed with a combination of technologies derived from

.NET and J2EE, which allowed the system to work in a platform independent environment.

Responsibilities:

• Worked as a team member and assisted with the design, documentation, development, maintenance, and testing of the system.

Frequently communicated with clients and end users, working on Rapid/Agile Development Methodology. Iterated the SDLC

(planning, analysis, design, coding, unit test, and acceptance test) to develop final delivery. Recorded detailed program

specification, user manual, test cases, and functionality dictionary in order to extend existing functionality for future programming

teams.

• Coded database access library with ADO.NET (e.g., Connection, Command, DataReader, DataAdapter, and DataSet).

• Coded data access library with Java Database Connection API Oracle JDBC level 4 driver (Class.forName,

DriverManager.getConnection, and performed type casting in order to conform SQL server data types to Java data types.

• Wrote data validation mechanisms to prevent underlying errors throughout runtime, e.g., replaced system keywords of the

destination with placeholders before data transfer.

• Integrated business logic libraries implementing data accessor into Enterprise Java Bean (EJB). Deployed Stateful Session

Beans, Stateless Session Beans, and Singleton beans. Use EJB to encapsulate business logic and manage the application

transaction.

• Developed Web Service in JWS (hosted in Glassfish), which was then transferred into WCF application (hosted in IIS). Worked on

ABC “addresses, bindings and contracts” model.

• Cooperated to develop consumer applications of multiple technologies and consume functions disposed by the WebServices,

including a WPF client, an ASP.NET web application, a Java Servlet, and a Java GUI client.

Frank Jiang

• Design WPF application with Model View ViewModel (MVVM), thoroughly separated business logic from View layer. Created tabs

under the main window, sub windows and controls. Bound data sources retrieved from web services with controls. Designed and

deployed input error check and control validation and verification.

• Applied process logics on controls and specified events triggered when controls are interacting with the user. Customized Delegates

and EventHandlers to raise custom events.

• Developed rich presentation components using Blend Tool in WPF (XAML/BAML), which massively improved visual experience and

loading speed (use BAML Loader to load .baml file). Coded WPF layouts (e.g., StackPanel, GridPanel, DockPanel, and

Canvas) and controls (e.g., Tabs, Inputs, Brushes, and Calendars) implementing two way binding with data sources. Worked

with routed event and enhanced the user experience. Created and registered custom dependency properties.

• Assisted on requirements gathering and data modeling (database design, normalization and forward engineering). Created and

managed database roles, set up foreign key relationships, established triggers and cursors to enforce data reading and writing

rules.

Environment:.NET Framework 4.0, J2EE, Visual Studio 2012, NetBeans 7.2, JDK 7.0, ASP.NET, C#.NET, ADO.NET, IIS 6/7,

Tomcat, XML, XSLT, MS SQL Server 2008 R2, T SQL, JQuery/JQuery UI, JavaScript/JScript, LINQ To SQL, Blend, WPF, WCF,

JWS, EJB, NUnit, Visio 2010, UMLet 12.0, MS TFS 2012.

.NET Developer: University of Florida Dec’11 Jun’12

Project Gator State Travel Planner

Gator State Travel Planner was a management tool designed for individuals or agencies that are busy gathering travel documents and

organizing travel plans. It aimed at building a cloud platform that stores user travel data especially for tourists. Besides, users could share

travel plans and city information with each other. Through collecting and analyzing user preference from database, the server would

prompt the most popular travel plans to the all clients.

Responsibilities:

• Established detailed program specification for the “Travel Planner”, including use case diagram, class diagram, sequence

diagram, data flow diagram user manual, test cases, and functionality dictionary. Focused on improving user experience and

ensured that functions are easy to use.

• Designed a complex class collection and applied abstract classes and interfaces on classes. Refined class design and code reuse

to improve system performance and code readability.

• Designed and deployed XML structure for persistent object storage with System.Xml and System.Linq. Used XMLDocument to

record objects, use LINQ to XML query on the .xml file and then pass the result collection to DataSource. Worked with root, node,

element, and attributes in XML.

• For private data that was authorized to be synchronized to the server, the server would upload data and download data through web

service in WCF.

• Created and registered windows services listening and taking care of time management in order to handle automatically triggered

alarm events.

• Extensive use of the Calendar and GridView controls for display and date selection. Extended the functionality of the calendar

control to make it possible to display and work with the scheduling of different appointments for online exam scheduled for each day.

• Worked with delegates and events, coded custom EventHandler as a container of target methods, implemented the project using

WinForm in C#.

• Used System.Xml and System.Linq to perform data reading/writing actions on XML file, e.g., XmlDocument, XmlTextReader,

LINQ to Xml.

• Applied exception handling with try catch block. Logged exception and error information by using StackTrace class and File I/O.

• Added periodically backup function with File I/O, serializing persistent objects (e.g., contact information, ticket booking

confirmation, and user configurations) that would be saved on local disk when the application was on close. Ensured that the planner

system would de serialize the most recent backup and recover data from the binary file. Implemented detailed presentation logic,

coded data sorting function using IComparable.

• Cooperated in designing and modifying UML, e.g., use case diagram, class diagram, package diagram, state machine and

sequence diagram.

Frank Jiang

Environment: .NET Framework 4.0, Visual Studio 2012, SQL Server 2008 R2, WCF, C#.NET, XML, XSLT, NUnit, Visio 2010,

UMLet 12.0.

.NET Developer: Quzhou Hengxiang Machinery Co. Ltd., China Jan’10 Jul’11

Official Website Re engineering

As a large scale manufacturer and vender, the company periodically updates its website the platform providing company news, products

information and e commerce functionality for clients. The product page played the most critical role on the whole. It allows user to have a

delicate view of the products on sale by sorting categories and displaying detailed information including machine models, prices and the

corresponding parameter lists.

Responsibilities:

• Cooperated to manage web application in ASP.NET and programmatically update its components based on program

documentations about the website left by the original website builders. Modified existing custom user controls and created new

ones with enhanced validation controls and mechanisms based on the feedback provided by website users. Worked with AJAX

Control Toolkit (ScriptManager plus UpdatePanel Control).

• Implemented Tracing and diagnostic functionality for workflow engine using Debug/Trace.

• Adjusted page layout in HTML and applied themes in CSS, used master page to unify website style. Created site map controls

(<asp:Menu>, <asp:TreeView>, and <asp:SiteMapPath>) that allows user to navigate based on a XML file referred by

<asp:SiteMapDataSource>.

• Based on the changing requirements, retrieve new information from views in the product database with stored procedures and other

queries. Binding single source with various controls for display GridView, ListView, DetailsView, FormView, Repeater and

DataPager in order to adapt to preferences of different users.

• Wrote client side validation, tool tips and popup dialogs using HTML/CSS events as well as styling and implementation of business

logic in JavaScript/ JQuery/JQuery UI. Performed input validation using regular expression and JavaScript.

• Optimized client browsing performance by rewriting the code of postback pages and several existing classes that were not properly

organized.

• Experienced with Request/ Response process, GET/ POST method, and redesigned navigations using Hyperlink/ Transfer/

Redirect linking methods.

• Optimized server performance by setting up page caching, bettered user experience using ViewState, hidden field, cookie and

session.

• Enhanced data display performance by adjusting read in capacity of DataSet and optimizing data access logics, used paging and

caching to unload burden on the server side.

• Coded Exception handling to deal with runtime errors.

Environment:.NET Framework 3.0, Visual Studio 2008, Dreamweaver, Photoshop, ASP.NET, C#.NET, ADO.NET,IIS, XML, XSLT,

MS SQL Server 2008 R2, T SQL, JQuery/JQuery UI, JavaScript/JScript, LINQ To SQL, LINQ to Objects, LINQ to XML, WCF, MS

TFS, MS Office Tools.

.NET Developer: Quzhou Hengxiang Machinery Co. Ltd., China Jul’08 – Dec’09

Project Caiwuguanli

Caiwuguanli a finance reporting system was designed to store, modify and extract information from the main Financial Database. It

analyzed data and then generated statistics and user behavior pattern reports that were finally sent to branch president and department

managers.

Responsibilities:

• Planned on software development life cycle (SDLC), analyzed system requirements, and translated business requirements to

program requirements. Gathered customer requirements from finance managers, collected business process information from clerk.

• Worked on structure diagrams, designed classes, attributes, objects, packages, and relationships. Worked on behavior diagrams,

designed activities, use cases, communications, and state machine. Worked on data modeling, from conceptual modeling, logical

modeling, to physical modeling. Designed databases structure based on finance documentation and business processes.

Frank Jiang

• Worked with N layer architecture (business object layer, data access layer, presentation layer, and other layers hiding

internal implementations) to reuse code, enhance data security, and simplify code structure.

• Coded comprehensive GUI using WinForm, containing main window, tabs, functional dialogs, tooltips, help windows, and

input and search controls. Extracted secured data by consuming Java Web Service (JWS) and WCF web service. For non

secured data, coded data import application from multiple Data Sources, e.g., flat file, SQL server, and XML. Focused on data

consistency.

• Coded C# classes and SQL queries that are responsible for processing raw data, such as tables, views, user defined functions,

and stored procedures.

• Involved in data migration of ETL process from SQL Server 2000 to SQL Server 2005 using SQL server Integration Service

(SSIS).

• Implemented membership that supports SqlMembership Provider storing membership data in the Microsoft SQL Server. Coded

membership management classes, retrieve user information and construct group objects with ADO.NET Entity Framework.

• Used Threading to allow multi user access. Cooperated to design system architecture with high performance and less the errors,

solved dead lock situations. Coded components for data update from the source, report generation, access log and periodical

backup. Performed unit tests and fixed potential exceptions with Try Catch block.

Environment:.NET Framework 2.0, Visual Studio 2005, C#.NET, XML, XSLT, NUnit, Visio 2005, MS SQL Server 2005, SSIS, T

SQL.

Other Projects: Sep’07 – Jun’08

Project “Car Rental Automation”

“Car Rental Automation” was a database and data warehousing project providing car rental agents with a powerful database system to

handle massive daily business in a car rental company and its branches.

Responsibilities:

• Cooperated in data modeling from scratch based on functional and system requirements.

• Made conceptual models, logical models, and physical models. Did normalizations and optimization of database structure.

• Implemented models with DDL, aggregated the columns from different tables into views for public use, and packed Query and

DML/TCL into stored procedures. Wrote triggers to change the status of certain objects.

• Worked on optimization of query performance.

Market Department Internship: Industrial & Commercial Finance of China (ICBC, Ranking 54th by Fortune (US) 500 in the

year of 2012)

“ICBC Enterprise Information Management System” is a massive ERP system. From high executives to counter staff, each employee had

a distinct role to access and interact with system with different authorities. The system itself was strictly designed within a multi functional,

multi layer and multi user group structure and only used in ICBC’s Intranet. Market staff could conduct functionalities such as customer

relationship management, loan processing, and credit line management.

Responsibilities:

• Experienced system maximized functionalities within the authorization of marketing department.

• Learned some structures and mechanisms of Finance and Marketing Systems, like tracking customer credits.

• Assisted the market manager to process loans (79 million RMB in total for 370 qualified customers) through the system.

Module Editor: sunshine.zstu.edu.cn at Zhejiang Sci Tech University (ZSTU)

“sunshine.zstu.edu.cn” is a comprehensive website propagating college culture and providing students with a communication platform. It

was developed and maintained by students at ZSTU. The website comprised several modules such as campus news and forum containing

rich information related to students and the university. The website project team recruited a group of technical students to periodically

update modules with the management tool at the back end.

Frank Jiang

Responsibilities:

• Weekly Updated “Sunshine News” module style and content with HTML/CSS, submitted news content embedded in HTML/CSS

code through website management tool.

• Coded font style, alignment pattern, paragraph indent, hyperlink, word image wrapping, and rolling items for news content.

• Used CSS to create and apply multiple themes in order to update webpages’ visual effects.

• Used JavaScript to create client validation on registration page.

Technical Support: Zhejiang Sci Tech University Law School

Responsibilities:

• Design and make web pages and windows widgets by consuming WebServices, like “DIY Weather Forecasting Widget” that displays

area weather information based on either city name or zip code using VB.NET.

• Installed and configured study aid software for school computers.

• Volunteered to help anti virus, diagnose, recover and repair desktops and laptops for Law School students.

Education:

Master of Science in Information Systems

Training & Certificates:

• Certificate: Computer Technology “Visual Basic” Level II

• Certificate: Computer Technology “Network Technology and Security” Level III

• .NET Frame Work and AJAX framework ATLAS, WCF, WPF by VENSOFT INC.

• Object Oriented Design and Analysis using UML by NETG.

• Business Process Engineering & Analysis using UML, RUP and Data modeling and

RDBMS Fundamentals by Thomson Group.



Contact this candidate