Project Sql Server

Kean Zheng

Phone: 206-***-****

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

**** ** ***** *****, *********, WA 98682

Objective:

Seeking a challenging position with potential and opportunity for

professional growth.

Professional Skills:

. 20 years of experience and in-depth knowledge on IBM midrange systems

from System/38, AS400, iSeries Server and its HTTP/Apache, WebSphere

Servers, and AIX/Linux platforms. Associate worked on Windows

Server/NT/2000/2003, MS SQL Server 2000/2005/2008, MS SharePoint in

the complex environments.

. Supported for a variety of business environments and their information

services needs in business activities, good understanding of business

functions and financial principles.

. Excellent work ethics with self-motivation and self-initiative, strong

problem-solving and hands-on skills. Good communication skills with

all level of customers, work well independently and collaborating with

teams.

Employment:

2013 -- 2014 TEKSystems; Warsaw, Indiana

Infor ERP Consultant

. Worked with a client on the project to upgrade IBM systems OS 6.1 and

Infor ERP release updates. The assignments were to provider technical

support for

end user community testing and go live phases of the project, also to

analysis, troubleshoot and solve raised issues during entire project.

. Developed the tool that creates the indexes process which base upon

iSeries Index advisor for improving DB2 database performance, and

created clearing records process to reduce database file size in

test/developer environments for utilizing maximax system storages.

. Implement Concur ETL process to allow multiple data sources feeding

into the systems legacy GL database. Also, investigated and resolved

post upgrade issues and give recommendation and most efficient and

effective solutions for fixing the problems.

2010-2013 Exotic Metals Forming LLC; Kent, Washington

Computer Programmer

. Maintained and implement existing functional of the ERP Application

to support business day to day production operations. Worked on multi

- partitions IBM i Server, Java Server, FTP Transfer protocol Server

and MS SQL Servers with very strong troubleshooting problems and re-

solve issues skills.

. Developed new solutions to follow business analysis and design

specifications

with strong PRGLE and CL and SQL coding skills, and created unit-

testing

scripts to meet the business needs and all level users requests. Good

work experiences with the changes control management and

technical document.

. Worked with team members to performance systems upgrades which

includes IBM OS, HMC updates, MS SQL Server upgrades and

consolidation. Technical leaded Infor ERP applications migration and

upgrades.

1998-2009 Columbia Machine, Inc.; Vancouver, Washington

Systems Administrator / Programmer

. Performed iSeries Server tuning, system securities control and

configuration, hardware/software upgrades and PTF/Patch installations.

. Monitored job, message and output queues; analyzed access and error

logs to provide 24x7 production supports.

. Scheduled systems backup and monitored systems/jobs remotely,

developed business disaster recovery plan and ensured integrity and

confidentiality of business database.

. Maintained Lawson M3 Application Server, DB2 UDB and Reporting

Services to support the core business ERP applications in a complex

network, and set up new user and users' access permissions in the

applications.

. Administered WebSphere, Apache and HTTP Servers on iSeries platform to

enhance ERP supplemental functionalities and to exchange data with MS

SQL Server and other platforms.

. Deployed modifications and updates, and developed new functionalities

to meet business demands, improvement requests and user needs.

Key accomplishments:

. Supported 400 + users on a heavy customized MAPICS Package on AS400

with solid coding skills in RPGIII/RPGILE/CL/SQL for 6 + years,

experiences with PDM/SEU/SDA/DFU/Query400 and Hawkeye/Ezview/IQuery,

knowledge of SNA/TCP/IP/FTP protocols, Client Access and ODBC/JDBC

connectivity.

. Good understanding of web services in i5/OS: experiences with

Apache/WAS 4.x/5.x/6 installation/migration, configuration, deployment

and troubleshooting, familiar with IBM WDSC/RWD/RSDP 6.0 and Eclipse

IDEs.

. Experienced with, Java/J2EE, and CGIDEV2 programming and DB2 UDB

administration, familiar with IFS/NFS, Qshell and JDK environments,

and Zendcore for i5/OS with PHP practices. HTML/XML and

JavaScprit/Perl coding.

. In an ERP implementation project, assisted consultants in installing,

compiling and configuring Java-based Lawson ERP package, and converted

business data from IBM traditional files to DB2 UDB on iSeries Server.

. Technical lead capacity in designing and developing all business

activity reports and forms for EPR project based on advanced streaming

technology. Assisted peers in developing interfaces to replicate and

synchronize database from iSeries platform to MS SQL Server that

allowed for customizing and implementing ERP application

functionalities without modifying vendor's source codes.

1996-1998 Legacy Health System; Portland, Oregon

Programmer / Analyst

. Maintained and supported the Patient Billing, AP, AR, accounting

modules in Medical Information System, and experienced with Source

Change Control Management Application in multi-AS/400s and R6000

network environment.

. Responsible for Y2K compliance updates, testing and verifications.

. Assisted Systems Administrator to design and program on systems' jobs-

controlling, securities-auditing for administering user tasks more

efficiently.

. Assisted in HL7 (Health Level Seven) integrated interfaces project to

design and program with C++, Tcl/Tk, Oracle/PLSQL and Delphi

Client/Server concepts on an interface application to extract,

transform and load electronic medical records.

1994-1996 Association of Washington Business; Olympia, Washington

Computer Services / Programmer

. Provided technical support on a Novell Netware that combined PCs, Macs

and IBM AS400. Responsible for the network configuration and

connection, hardware/software installation and troubleshooting

problems. Performed AS400 updates, backups and administered user

accounts and access.

. Maintained a membership management application on AS400, designed and

programmed programs and applications to meet business requirements.

. Assisted consultants and involved in evaluation project to select new

network. Helped set up Window NT Server and networking, converted and

migrated the membership database from AS400 to MS SQL Server database.

Education:

1978 -1982 Bachelor degree in Computer Science

Reference:

References provided upon request.

Contact this candidate