Sales Project

MARK GUAN

******@*****.***

626-***-**** (cell)

626-***-**** (msg)

San Marino, CA

OBJECTIVE

Interested in opportunities in IT to extend my extensive 20+ years business

IT programming and business working experience.

SKILLS:

20 + years of IS programming working experience.

0. Solid 20+ years of programming on IBM AS400, with both on-line

interactive and batch programming in RPGLE, CL, SQL, DB2, MQ Series and

all AS400 utilities.

0. Hands on web front end .Net, C# and Java web developing involvement,

with front end web and back end AS400 interfacing and processing.

Creating Web HTML/Java script programming. Interfacing from AS400 to web

sales, loan transfer application and E-commerce/Supply Chain

applications. Develop AS400 Store Procedures, Trigger program.

1. Excellent business knowledge of automobile, loan and mortgage

origination/servicing processing, retailing, entertainment,

manufacturing, healthcare business.

2. Solid 8+ years in supporting accounting users.

3. Hands on experience on ERP such as: Home grow loan processing system,

Island Pacific Retail application, Mapics XA, and MAPPAC manufacture

application, Infinium /Software 2000 financial application, JD Edwards,

Prestige payroll application, Perminor EDI and Data warehouse..

4. Experience Visual studio Dot .NET 2008/2005/2003, C# programming. Using

Framework 3.5/3.1/2.0. Involved MS Workflow, WCSF, Object Persistent

Framework, and AJAX.

5. Hands on experience on analyzing the applications, functional and

technical design, documentations and full cycle system testing.

6. Working experience of VPN dial in and on call support. Using Turnover,

Implementer, Aldan version control utility.

7. Experienced of Client/Server techno ledge file transfer, E-commerce

application. Internet ASP, front/back end web applications, AS400 iDB2

Data provider, MS IBM host integrator, ODBC connections, SQL server, MS

Access.

8. Experienced or knowledge of OOP developing Web Service using J2EE Java

platform involving applet, Serves, JSP, JDBC, some new Ajax, Hibernate,

SPRING and messaging technology using IBM Websphere, and Eclips, J-

Builder,Tomcat, Apache on Linux.

9. AS400 to JDE One word ERP interface

10. Experience or knowledge of Oracle database, PL/SQL,

Forms/Reports/Discover, Workflows, TOAD, Data loader, financial and

manufacture EPR application functions data conversion.

11. Experience in wireless hand-held RF Autosoft warehouse application

based on RS6000 AIX UNIX. Knowledge of UNIX operating system and Oracle.

12. Knowledge of AS400 MQ series. Exposure to MQ, MQSI and XML data

transmission.

13. Involved in ERP SAP, ABAP implementation.

14. Proficient in PC Windows VISTA//XP server operating system, Mobil

connection. Microsoft Excel, Word documentation, Visio documentation

software.

EXPERIENCES:

BankofAmerica 2/09 to now

Consultant

Mortgage Loan

Participate in BOA/Countrywide conversion, application gap enhancement

development. AS400/RPGLE, procedure, service program, SQL, multithreading

job process. MQ Series job process. Develop store procedures call, Java

interface. Application system analysis, and documentations. Teams

offshore coordination. Turnover source control.

Hyundai Motor America 10/07 to 12/08 Consultant

Dealership Sales Marketing

Worked on variety projects to support Sales Marketing, vehicles dealership

system.

. Programmed using Free form, imbedded SQL, Procedure Prototype

binding, with interactive programs and batch application.

. All phases of project, including business analysis and project

application design, up to user testing.

. Work on.net c# to interface to online Dealer Sales application,

AS400 data provider, Store procedure calls. Using Visual Studio

2008 frame work 3.5 and 2.0. Involved in WCSF, AJAX, Web Service.

Develop Store procedures to interface to DB2 AS400.

. Started some study and conversion of Java technology process

Countrywide Home Loan 2/07 to 09/07

Consultant

Mortgage Loan

Participate in developing new front end Dot .net and back end AS400 loan

transfer application system.

. Program on AS400 RPGLE, store procedures interfacing with Dot.net

front end. RPGLE free forms. Main responsible person for AS400

back end process for the team. Involved all user design

discussions, developing, unit and integration testing

. Work on several existing Dot .net C# maintenance projects in MS

VS2005 and VS2003. Front end Dot net. Screen add, change. Backend

AS400 update and repost back to front end.

Hyundai Motor America 3/06 to 01/07 Consultant

Dealership Sales Marketing

Worked on variety projects to support Sales Marketing, vehicles dealership

system.

. Programmed using Free form, imbedded SQL, Procedure Prototype

binding, Service program with interactive programs and batch

application.

. Interface to variety Web online application, Distributing the

reports from AS400 to Web. Create XML for Vendor application.

. Involved in some .NET C# project to interface and support third

party web Sales Marketing application.

. AS400 to JDE One word ERP interface.

Health net 4/04 to 11/05

Distribution and Manufacturing Consultant

Worked on a 2 years million dollars healthcare payment system development

and implementation project. Project successfully implemented for the

important business payment function.

15. Programmed using Free formed RPGLE to interface with Valutech

Mainframe application with huge transactions. Including full

development life cycle with analysis, user discussions. Documentation,

coding, testing, implementation and post production support for a big

project. . Communicate with users and other technical teams to the

best outcome for satisfy all the needs.

16. Interface with bank, Provider/Client Claims printing services.

17. Perform Viso representation of business and technical process work

flow flows to the user the other technical teams.

18. Analysis and process Company Provider 1099 for year 2004.

19. Working on HTML. Folder file to display AS400 reports on intranet.

20. Worked on FTPs, Procedure calls, batch, reports, online programming.

Using SQL, MKS implementer, Robot Scheduling. Analyze and improve

operating efficiency by coding multiple process at same time jobs

21. Troubleshoots and fix the user testing and post implementation

problems.

22. Worked interfacing to Mainframe COBOL files and mainframe based

healthcare payable system.

Toshiba 6/03 to 04/04 Consultant

Distribution and Manufacturing

Teamed up with Accenture to work on a high million dollars distribution and

manufacturing project to perform a conversion from AS400/RPGLE to Oracle

ERP. Project successful implemented in production for all planed division

functions.

0. Programmed using Free formed RPGLE for a RMA function Oracle

interface using embedded SQL

1. Work includes full development life cycle with current system

analysis, technical user discussions. Documentation, coding. Heavy

unit and integrated testing, and post production support for the big

project.

2. Performs program specification, flow charts, test plans, unit and

system test.

23. Worked on various modules like MACPAC Credit Memo, Invoice, Purchase

Order, Pricing, Inventory programs analysis and programming interface

with WebMethods, Broad Vision, Siebel interface, Oracle PL/SQL, forms

and reports/Discovery, and MS SQL Server VB application.

The Disney Store 05/02 to 02/03 Consultant

Instrumental in creating a Supply Chain for International Retail Business

sales and distribution projects.

24. Programmed using RPGLE to interface with VMI system and EDI PO

transmission, to automate PO processing. Embedded SQL with both batch

and online programs.

25. Created AS400 receiving worksheet report on web intranet through IFS

file system.

26. Extracted business data from AS 400 and interfaced with Unix based

RETEK warehouse management system.

27. Worked online and batch program for allocation and inventory balancing

between two systems.

28. Analyzed current system for an optimum programming plan to implement

pre-package functionality; documented and evaluated the current system

program, and submitted an in-depth project proposal for the half-

million dollar major system modification.

Countrywide Finance 05/00 to 5/02 Consultant

Participated in a million dollar Global Loan system project development for

United Kingdom on AS400.

29. Worked on development of new loan servicing system and interfaces for

for UK mortgage banks.

30. Programmed Free Form RPGLE/RPGLE/RPGIV batch and online, journaling,

trigger and commitment controls. Programmed embedded SQL for reports.

31. Used Turnover version control.

32. Participated in all team projects including project development,

testing and production support life cycle.

33. Involved in some MQ/MQSI XML messaging data transmission.

34. Exposure to Java development, JSP, JDBC, IBM Java Websphere and

interface with GOS loan origination.

35. Experienced using internal data conversion tools.

Fadal Engineering 12/99 to 05/00 Part time

Consultant

Programmed using Free formed RPGLE/RPGLE. Provided Mapics XA application

support

36. Provided Mapics XA application support.

37. Used AS400/InternetWeb auto entry data to create AS400 interface to

trigger and update Mapics application.

38. Automated Web order to auto pick/pack, ship and auto invoice.

39. Created Auto inventory backflash/bill of material order input.

40. Used VB, Visual Studio.NET, and ASP applications to interface with

AS400.

41. Used CRM software interfacing.

42. Provided proof of concepts with Java, AS400 and JSP.

43. Worked on API development using IBM Java Age.

Frederick's of Hollywood 04/99 - 12/99 Consultant

44. Programmed RPGLE on AS400 on online, batch, and RPGLE procedure

programs.

45. Supported Mozart Internet Web order and Catalog mail order programs.

46. Supported Island Pacific retail applications.

47. Programmed POS data transfers.

48. Developed AS400, Prestige Payroll, and STR POS time hours interfacing

programs.

49. Used DB400 ODBC to Access database.

Retail Aspect StartUp Co 04/99 - 07/99

Offhour/PartTime Consultant

0. Programmed RPGLE on AS400 to support IP applications with retail

clients.

1. Interfaced and posted Journals IP to JD Edwards.

2. Started Java programming, AS400 interface and API development using

Eclips.

IBM/Kubota Tractors 09/97 - 04/99 Contract

Developer

3. Programmed in RPGLE to support company loan system. Programmed in

embedded SQL for all the reports.

4. Contracted to IBM ISSC and consulted for IBM's client Kubota Tractors

5. Develop loan Origination front end, and service backend Loan servicing

package. From user information screen validation, updates and

important loan amount calculations.

6. Programmed RPG400/RPGLE interactive subfiles/batch on AS400.

7. Provided hands on programming and created Internet application in

HTML/Java, CGI on AS400.

8. Supported front end/backend Loan servicing package and Dealership

warranty system.

9. Used IBM Client Access, Lotus Notes/Dominos Client Server software.

10. Involved in SAP ERP implementation, ABAP4 programming.

11. Used IBM Java age for proto-typing of Java demonstration.

The Disney Store 5/96 - 09/97 Sr Programmer

Analyst

12. Supported Island Pacific Retail package.

13. Programmed RPG400/RPGLE interactive subfiles/batch and performed SQL

programming.

14. Supported Multi-country retailing/distribution application, and

traveled to Disney.

15. UK for programming support.

16. Worked on AS400/RS6000 PCS warehouse application interface projects.

17. Used Rumba Client Server software.

18. Exposure to SAP/ABAP4 initial testing implementation.

Duty Free Shoppers 9/91-4/96 Sr Programmer Analyst

19. Programmed RPGLE on IBM AS400 in retail environment on RPG400/RPGLE.

20. Supported GL/AP/AR for accounting for end user using Software 2000

GL, Computer Associate AP.

21. Worked on POS data transfers.

22. Responsible for AS400 evening problem on-call/dial-in support.

23. Programmed on SQL.

24. Converted and supported RS6000 AIX Unix wireless handheld RF

Autosoft/Noran warehouse distribution system.

25. Involved in Monarch/Intermix bar code AS400 interfacing.

26. Used Netsoft Client/Server for AS400/PC interfacing.

27. Supported nationwide remote location users.

KORODY COLYER 12/89-8/91 Programmer Analyst

28. Programmed on IBM AS400, RPGIII/400.

29. Supported PC users.

30. Performed AS400 conversation.

31. Wrote AS400-PC ADP payroll transmission interface program.

32. Provided in-transit warehouse distribution package interfacing.

GIFTREX LTD 4/88-11/89 Sale Manager

1. Worked as manager for small trading Department.

1. Worked in import and export business.

1. Product management, QA,, shipping and sales..

IBM 10/87-3/88 System Coordinator

System Coordinator

Performed IBM VM system maintenance and VM user support on IBM

3080/3090s.

Configured system.

EDUCATIONS

University of California, Irvine: BS, Computer Science, December 1986.

GPA3.6

Pasadena City College, Pasadena AA, Computer Science, July 1984. GPA 3.4

Technical trainings:

AS400: Many different seminars

Java:: Cal Poly & Colleges

Oracle: PL/SQL, Forms/Reports, Oracle University

Contact this candidate