Post Job Free
Sign in

Customer Service Sql Server

Location:
Ann Arbor, MI, 48108
Posted:
June 19, 2010

Contact this candidate

Resume:

chilung tan

**** *********** *****, *** *****, MI 48108

Home Phone: 734-***-****; Email: abkazz@r.postjobfree.com

SUMMARY

I'm a software developer and technical consultant experienced in employing

proactive, solution-oriented approaches to all assigned activities in a

rapidly changing environment. My IT skill set includes software

development, Shell Scripting, Cisco networking, DBMS, etc. I have strong

organization and time management skills to prioritize and meet deadlines. I

have the ability to articulate technical and user needs in a concise manner

easily understood by all audiences. I have excellent conceptual,

analytical, and problem-solving skills. I work equally well independently

or in a group environment making me an excellent addition to your team.

(Note: I only consider a full-time perm position with full employee

benefits.)

TECHNICAL SKILLS

. Accounting

. PC Hardware

. e-Commerce

. C and C++

. Java

. Java Card

. J2EE

. .Net

. Hibernate

. Spring

. JSP

. JavaScript and DOM

. PHP

. AJAX

. SQL

. JQuery

. RBDMS

. JDBC

. Ruby on Rails

. Groovy and Grails

. Visual Basic.NET

. ESQL/C

. Microsoft Dynamics GP, FRx

. Microsoft SharePoint 2007 Wiki

. XHTML

. XML, XSLT

. JSON

. CSS

. SOAP

. WSDL

. MVC

. SOA

. Shell Scripting

. Perl

. Eclipse and IntelliJ IDEA

. JUnit (Agile test driven development)

. Samba

. Apache

. Tomcat

. Ant

. CVS

. Subversion

. MS SQL Server 2008

. MySQL Server

. PKI and 3DES

. Web Security (XSS and SQL Injection Prevention)

. Windows XP and NT

. Citrix Server

. Linux System Administration

. System Backup (RAID) and Data Integrity (Shadow paging)

. Computer Network LAN/WAN technologies

. DNS

. DHCP

. NFS

. TCP/IP

. OSPF, RIP, IGRP, EIGRP, SMRP, BGP

. VPNs, SSH, FTP, SSL, Socket

. IPv4/IPv6

. LDAP

. Technical Training

. WebCT/VISTA

. Adobe Photoshop

. Adobe Captivate 4

. Visio

SAMPLE PROJECT ACCOMPLISHMENTS

. Created some demo websites with MVC architecture by adopting the DRY and

Conventions & Sensible Defaults principles in Ruby on Rails. Switched the

default SQLite3 database to MySQL database on RoR for those created

website applications.

. Provided technical consultation and support in Open Commerce Platform,

MVC frameworks, advanced J2EE, Web 2.0, Open Source tools, commercial

products, and new technologies related to Web Software Engineering, such

as JSP, Tag Libraries, XHTML, XML Schema, CSS, JavaScript, jQuery, Java

OCP widgets, CVS, and Subversion.

. Developed TanLoyaltyPurse and TanLoyalty applets installed in Java Card

(a smart card coded by Java language) for an inter-context communication

across firewalls inside a Java smart card. TanLoyaltyPurse stored

electronic money, supports credit, debit, and check-balance functions.

The TanLoyalty was used to increase or decrease the redeemable loyalty

points based on the expenditure from the TanLoyaltyPurse.

. Designed and delivered various Smart Card training courses at various

audience levels. The basic courses covered describing different types of

smart cards, explaining their different features and the benefits. I

conducted smart card training courses for the VISA International and the

MasterCard on a separate occasion.

. Developed a Java program to implement secured socket-level data

communication between client and server with PKI and 3DES cryptography

for data security in a network communication.

. Designed and developed a C++ program to simulate bank customer service

reports. The program created a model of a real world situation to measure

current business practices or to evaluate expansion. It performed an

event-driven simulation that defined objects to represent banking

activities. It measured efficiency of service to create different service

patterns and evaluate them for cost and efficiency.

. ESQL/C (embedded SQL in C) program to produce statements of both pre-

billing and formal billing for college students.

SAMPLE TECHNICAL WRITING ACCOMPLISHMENTS:

. Wrote "Smart Card Essentials and Java Card Applet Coding" tutorials.

. Wrote "Open Commerce Platform Catalog Engine Training Material".

. Wrote "OCP Commerce Engine, Pipeline Engine, and User Engine" Training

Material.

. Wrote "OCP Content Management System and Profiling Technology" Training

Material.

. Wrote "OCP Shell Commands and Cashing/Pooling Technology" Training

Material.

. Wrote "OCP Widgets" for Fry Inc. covering all the OCP functionalities

using Java, JSP, Tag Libraries, XML Schema, and Catalog Integration, etc.

PROFESSIONAL EXPERIENCE

Senior Management Analyst, Washtenaw County Health Organization, MI,

02/2010 - Present

. Perform complex and sensitive professional administrative,

organizational, systems, budgetary and other analysis and staff support

related operations.

. Manage various projects and coordinate programmers and nontechnical

users, collect and discuss findings and make informative decisions to

ensure each project successful implementation.

. Perform IT system administrative technical support such as administering

a Citrix Server, Microsoft Dynamics Great Plains system, Microsoft

SharePoint Wiki, building and maintaining Microsoft SQL Server 2008

system, etc.

. Environment: Citrix Server, Microsoft Dynamics Great Plains, FRx,

SmartList, Microsoft SharePoint, Microsoft SQL Server 2005 and Microsoft

SQL Server 2008, SQL queries, etc.

Software Engineer Technical Trainer, Fry Inc., MI (Retail e-Commerce

Service vendor), 12/2007 - 07/2009

. Introduced and worked on new technologies to the software development

team such as Ruby on Rails, Groovy and Grails, SOA, and web security such

as guarding against any of attacks from XSS and SQL Injection on

Internet.

. Created some demo websites with MVC architecture by adopting the DRY and

Conventions & Sensible Defaults principles in Ruby on Rails. Switched the

default SQLite3 database to MySQL database on RoR for those created

website applications.

. Collaborated with other architects and developers on the e-Commerce

solution architecture.

. Provided technical consultation and support in Fry development

frameworks, advanced J2EE, Web 2.0, Open Source tools, commercial

products, and new technologies related to Web Software Engineering, such

as JSP, Tag Libraries, XHTML, XML Schema, CSS, JavaScript, jQuery, Java

OCP widgets, CVS, and Subversion.

. Performed research for project teams for any technical issue and acted as

a technology mentor for individuals on project teams.

. Provided training in the technology and tools Fry, Inc. uses to develop e-

commerce retail web sites for clients like Whirlpool, Wet Seal, Meijer,

and La-Z-Boy.

. Designed, developed, and delivered technical courses to align with

software development rollouts as well as ongoing technology skills

support.

. Trained the software engineer staff with Agile software development

methodology in back-end test-driven, test first approach, both in

classroom and through WebEx.

. Environment: OCP, Java, J2EE, JUnit, AJAX, JSP, JNDI, EJB, JSON,

Hibernate, Tag Libraries, Web 2.0, XHTML, XML, CSS, SOAP, WSDL,

JavaScript, DOM, jQuery, MVC, UML, DAO, JDBC, Tomcat, Ant, SSH, MySQL, MS

SQL Server, CVS, Subversion, Eclipse, IntelliJ IDEA, Ruby on Rails,

Groovy and Grails, SOA, WebEx, Visio, Adobe Captivate 4

Assistant Professor of Computer Science, Middle Georgia College, GA,

08/2006 - 05/2009

. Taught all the Computer Science courses in every aspect such as Computer

Science with Electronic Circuits Engineering programming in VB.NET, C++,

Java, and Data Structure.

. Developed and updated all Computer Science curricula.

. Performed role as member of the University System of Georgia Academic

Advisory Committee on Computing Disciplines.

. Served as adjunct to teach all the Computer Science courses through

WebCT/VISTA online system.

. Environment: VB.NET, C++, Java, Microsoft Office and Outlook, FrontPage,

WebCT/VISTA

Instructor, ITT Technical Institute, TX, 06/2004 - 08/2006

. Taught various courses such as PC Hardware (CompTIA's A+), VB GUI Design,

C++ Programming, Windows XP and NT Operating System, Red Hat Linux

Operating System, Linux System Administration, LAN/WAN Architecture,

Network+ Technology & Service Integration, Network Systems Management.

. Environment: PC Hardware (CompTIA's A+), VB GUI, C++, Windows XP and NT,

Red Hat Linux Administration, Perl, Shell Scripting, SSH, DNS, DHCP,

Samba, Apache, System Backup (RAID) and Data Integrity (Shadow paging),

VPNs, FTP, SSL, Socket, Network LAN/WAN Infrastructure.

Professor of Computer Information Systems, Central Pennsylvania College,

PA, 06/2002 - 05/2004

. I taught both through web-based online and in classroom courses such as

Java Programming, Object-Oriented Programming in C++, Cisco

Internetworking Technology, Red Hat Linux 9, Novell Netware 5.0/5.1 for

CNA, Cryptography and Data Security, Microsoft Active Directory, LDAP,

Operating Systems, A+ Hardware, Computer Organization & Architecture,

Database Management, and Data Modeling courses. I also worked in academic

advising, supervising senior projects, developing and evolving CIS

curriculum, and other professional activities.

. Environment: PC A+ Hardware, C++, Java, RBDMS, Cisco Networking, Red Hat

Linux, VPNs, FTP, SSL, Socket, DNS, DHCP, Database, Data Modeling

Technical Consultant & Trainer, Gemplus International, TX (Smart Card

vendor), 05/2000 - 04/2002

. Delivering technical presentations including product demos, proof of

concept evaluations, answering technical questions, responding to

Requests for Information (RFI), providing technical feedback; creating

technical solutions for customers' business problems and consulting with

customers on implementation issues.

. Developing Java Card applets (applications installed into Java smart

cards).

. Designing and delivering advanced Java smart card training to better

cover information security and cryptography like 3DES Encryption modes,

asymmetric algorithms such as PKI and Certificates, functions of JCRE,

VM, PC/SC and OCF.

. I designed and developed a C++ program to simulate bank customer service

reports with scheduled sessions, needs-analysis, and outcome expectations

to clients. The program created a model of a real world situation to

measure current business practices or to evaluate expansion. It performed

an event-driven simulation that defined objects to represent banking

activities. It measured efficiency of service to create different service

patterns and evaluate them for cost and efficiency.

. Developed a Java program to implement secured socket-level data

communication between client and server with PKI and 3DES cryptography

for data security in a network communication.

. Wrote "Smart Card Essentials and Java Card Applet Coding" tutorial.

. Conducting research on new smart card technologies and creating new

training programs.

. I conducted smart card training courses for the VISA International and

the MasterCard on a separate occasion.

. Environment: Java, C/C++, Visual Basic, JBuilder IDE, RAD, PKI, 3DES

Encryption, JCRE, OCF, Visio, Adobe Captivate

Programmer Analyst, Grinnell College, IA, 05/1999 - 05/2000

. Worked on a UNIX system with C/C++, SQL, UniBasic programming languages

in an extended relational application development environment.

. Customized off-self software products to meet the college's needs from

their Accounting Department and to use SQL queries to retrieve various

data for their Human Resource Office, and others.

. ESQL/C (embedded SQL in C) program to produce statements of both pre-

billing and formal billing for college students.

. Environnent: UNIX, Perl, Shell Scripting, VPNs, FTP, SSL, Socket, C/C++,

SQL, UniBasic

. Technical Trainer (China Eastern Airlines) 07/1987 - 02/1993

. Airport Operations Supervisor (United Airlines) 06/1985 - 07/1987

. Manager of Air Cargo Transportation Division (CAAC) 10/1980 - 06/1985

EDUCATION

. Masters of Science, Computer Science, University of Illinois, Illinois

(1997-1999)

. Bachelors of Science, Accounting, Illinois State University, Illinois

(1993-1997)



Contact this candidate