Project Analyst
Resume:
Lewis Kwan
Scarborough, Ontario,M1V 2E6
Tel:416-***-****
*****.****@*********.**
Objective
To design and construct effective information solutions as a result-oriented senior software developer.
Education
B. Sc. Information Systems Management, State University of New York at Buffalo, 1981
Certifications
Sun Certified Java 2 Programmer
IBM Certified MQ Series Developer
Technical Summary
Programming Languages : ASP.NET, C#, C/C++, Cobol, VB, Excel VBA, Access VBA, HTML, JavaScript, CSS, COBOL, IE, Easytrieve
Java : core Java, J2EE, JSP, Servlet, JDBC, JMS, JavaMail, EJB, Swing, design patterns, concurrent and socket programming, UML
Applications : web site development, ERP software implementation, integration and customization, data modeling, data warehouse, data conversion, office productivity tool development, fleet management, production support, job scheduling, MQ Messaging, data base administration
ERP : G/L (SAP, Geac, BaaN, ACCPAC), A/P (Geac, BaaN & ACCPAC), A/R (ACCPAC), Purchasing (Geac & BaaN), Inventory Control (Geac), Budgetary Control (Geac)
Tools : Crystal Reports, various Unix shell scripts, awk, sed, SQL*plus, SQL*loader, MQ Series, JCL, CICS, XML/XSLT
Databases : Oracle, Access, Foxpro, DB2, SQL Server, VSAM
Web Servers : iPlanet, Apache, Java Web Server, IIS
Operating Systems : Unix, Linux, WIN/2000, WIN/NT, IBM/MVS
Others : quick learner, work equally well independently and as team member, ability to observe deadlines, experience in full development cycles and in many different tasks such as technical documentation, establishing programming standards, training and mentoring.
Work Experience
Aug 04 present
Panorama Software (Systems Implementation)
Got the client up and running on ACCPAC AR with opening balances in less than two weeks, and have strengthened their application security, provided interfaces and developed reports using Excel VBA and Crystal Reports.
Oct 03 July 04
Personal Development
taking advantage of the extended weak IT job market, I pursued activities for personal growth such as learning the Japanese language and doing research on financial investments.
Sep 03 Sep 03
BALtrans Logistics (Web Developer)
Nov 02 Aug 04
developed a web prototype for the clients new website using ASP.NET and C#.
Nov 02 Aug 03
Professional Development
Studied for the Oracle Certified Examination For DBA, and researched on new technologies such as ASP.NET, C# and web services etc. I also took time off to travel to East Asia both for leisure and to look for new business opportunities.
Feb 99 Oct 02
Fleet Management, City of Toronto (Technical Lead & Project Leader)
modernized the Citys fleet management system by implementing a client-server based software package and integrated it with all other systems such as the fuel subsystem and the SAP GL. I also helped the CIty to save thousand of dollars a year in license fees by building a web site that hosts reports and queries against the newly installed fleet management system. As a result, hundred of users were able to query about vehicles for maintenance and repair records via the intranet without going through expensive training and logon. I was also heavily involved in third-party software vendor engagement, user requirement study and project planning. I also helped train IT staff members by ways of mentoring and systems documentation. To deliver these functions, I used the following technologies : Core Java, JSP, Servlet, Swing, JDBC, JMS, multi-thread and socket programming, OOD/OOA, XML/XSLT, VB, Access, Unix scripting, Oracle data modeling, database triggers and PL/SQL.
Jul 97 Nov 98
Nortel Canada Ltd. (Senior Programmer Analyst & Systems Integrator)
Developed a large-scale business transaction interface system among BaaN, Oracle and Geac financial applications for 30 global sites. Worked as the MQSeries technical lead in a 12-member team, I established the programming standards, designed the message protocol, helped develop the extract and loading sections of the interface, and trained team-members on the MQSeries messaging techniques. During the project, I was sent to London and Paris for three months to deliver technical seminars and assistance to my clients European technical staff. To deliver the final product, I used the following technologies : MQSeries, C/C++, Unix scripting, Oracle data modeling, database triggers and PL/SQL.
Sep 95 - Jun 97
Nortel Canada Ltd. (Senior Programmer Analyst & Project Leader)
Worked as the systems expert in consolidating the Canadian and the U.S. Accounts Payable systems which entails the integration of two independent Geac E-Series A/P applications with differing interfaces and detailed requirements. Since this was based on RAD (Rapid Application Development) technology, I had a great deal of user interactions throughout the entire life cycle of the project, from feasibility to acceptance testing. To carry out the project leading role, I spent 30% of the time in Nashville, Tennesee to meet with the users. The technical work consisted of Oracle PRO*C, SQL*plus, shell scripts, awk, C and Easytrieve+.
I was also responsible in developing a Unix-based paging system with the clients Accounts Receivable application in the area of CICS startup notification.
Feb 95 - Aug 95
Nortel Canada Ltd. (Senior Programmer Analyst)
Developed a data warehouse application from the ground up using a very wide set of tools. Under an extremely tight deadline, I was able to integrate data from applications on 3 different platforms : HP3000, IBM/MVS and HP/UX. As a result, real-time queries can now be submitted against an Oracle data warehouse made up of raw data originated from a Geac E-Series A/P and an in-house developed Invoice-Matching application. Besides the usual MVS tools such as Easytrieve+, JCL, VSAM and Cobol, SQL*loader, PL/SQL, PRO*C, shell scripts and awk were also used.
Feb 93 - Jan 95
Nortel Canada Ltd. (Senior Programmer Analyst)
Involved in the implementation and customization of a Geac E-Series A/P application. I made extensive software modifications to the core application as well as designed and coded a major new function, the online Invoice Recycle Subsystem, to the main module. On the other hand, I also succeeded in combining tools from the MVS and the Unix platforms to construct a package that downloads data from the A/P application to an intranet site. That project required diverse skills such as Easytrieve+, CA-sort, shell scripts, awk, Perl as well as FTP.
Sep 88 - Jan 93
MSA Canada Ltd. (Intermediate Programmer Analyst)
MSA, presently known as GEAC, was then a U.S. subsidiary. I was hired as the very first P/A for the Canadian software customization department. Besides tailoring Geac software (E-Series) to meet end users needs, I also performed diverse functions such as requirement studies, software installations, troubleshooting, performance tuning and customer support. I served numerous external clients including the Ministry of Attorney General and the Ministry of Management Board Secretariat.
Apr 88 - Aug 88
Olympia & York Developments Ltd. (Programmer Analyst)
Worked as a development P/A to help build a financial package for the Canary Wharf project in the U.K.
Jan 88 Mar 88
Travelers Insurance Canada (Programmer Analyst)
Supported the operation of a number of the clients applications.
Nov 87 Dec 87
Ontario Hydro (Programmer Analyst)
Wrote several reporting programs and helped tuned a VSAM-based application.
Aug 87 Oct 87
Aetna/Laurentian Insurance (Programmer Analyst)
Helped to convert a major insurance application package.
Sep 84 - Jul 87
Central Canada Grocers Inc. (Programmer Analyst)
Worked as a maintenance P/A to support all aspects of the Geac E-series A/P applications, including supports, enhancements, user training and the care of numerous feeder sub-systems.
Apr 82 - Aug 84
International Systems Consultants (Junior Programmer Analyst)
Worked as a junior P/A to help develop software solution to a diverse portfolio of clients such as architects, municipal governments and software vendors. Applications included project tracking, permit issuance and software modifications. Being my first job, it was particularly memorable since most of the work was developed on an IBM PC with dual disk drives.
References
Available upon request
Contact this candidate