Mark Guan

IT Professional

Pasadena, CA *****

adc1mn@r.postjobfree.com 626-***-****

OVERVIEW

-Over 15 years of IT experience in both technical and consulting roles

-Expertise in full SDLC- IBM iSeries platforms

-In-depth experience in proprietary software development as well as in packaged solution customization

-Served businesses in retail, insurance, manufacturing, warehouse distribution, entertainment, healthcare, Transportation, auto mobile and mortgage banking

TECHNICAL EXPERIENCE

-Over 15 years of programming on IBM i/AS400 system with both on-line interactive and batch programming in RPGLE/Free Form, CL, SDA/DDS, SQL/Embedded SQL, Store procedures, DB2, client access, and all other AS400 utilities. Knowledge of IDE/RDI for iSeries.

-Experienced in ERP and conversions such as: JDA, BPCS and other distribution WMS warehouse system consolidation and interfacing, AS400 to Oracle JD Edwards OneWorld conversion, AS400/Oracle conversion and implementation, Supply chain, Data warehouse conversion, SAP exposure and conversion. Knowledge of PL/SQL.

-Knowledge of Banking loan processing system processing, Island Pacific Retail application maintenance. Manufacturing application Mapics XA, Infinium financial application support, EDI TrustedLink transition creation.

-Involved in some web front-end, Net, C#, Java J2EE, developing an* interface with HTML/JavaScript, JSON to back-end AS400 interfacing and processing. Developed AS400 Store Procedures and Trigger Program. Involved in Client/Server file transfer, AS400 iDB2 Data provider, MS IBM host integrator, ODBC connections.

-Experienced in wireless hand-held RF Autosoft warehouse application on IBM RS6000 AIX UNIX and Linux.

-Knowledge of UNIX operating system.

-Knowledge of Python/Django, some AWS/Azure, Hadoop technology

JOB HIGHLIGHTS

-Application/system analysis

-Business functional design

-Technical design and programming

-Software testing preparations, execution, reporting and full cycle system testing

-User interface and training

SOFTWARE Tool SKILLS

-VPN remote and on-call support

-AS400 Turnover, Implementer, Aldon, version control and Hawkeye Pathfinder utility

-EDI TrustedLink

-Visual Studio, SQL reporting server

-Various proprietary tools

WORK HISTORY

Learning new technologies, Python and Bigdata May 2019 – Present

GUESS, Inc. May 2018 – Apr 2019

Retail Business, Consultant

-Worked on JDA retail, supply chain merchandise system on IBMi/AS400 system. Researched, modified and created new RPGLE programs to support the company’s daily business operations in multiple countries.

-Programmed in RPGLE Free Form and used the embedded SQL to create store level IFS data to download to company store servers.

-Researched and analyzed software used in multiple countries; consolidated state and country specific program versions into one common version to simplify business processes and to improve system efficiency.

-Analyzed and enhanced the existing data reporting programs to achieve improved data archiving.

WNC Insurance Service, Inc. May 2017 – Nov 2017

Insurance Company, Consultant

-Worked on the company’s reporting system conversion.

-Researched business reporting needs; analyzed business rules; defined and created permanent/work files; converted phased out third party reporting system to AS400 based program enabling online display.

-Used RPGLE Free Form and SQLs; uploaded and downloaded files and generated IFS files.

Penhall Company Jul 2016 – Jan 2017

Servicing, distribution and Transportation Company, Consultant

-Worked on AS400 iSeries RPGLE Free Form programming on equipment management and dispatch system projects.

-Evaluated existing system and third party software; developed new interface to third party ERP system via AS400 IFS.

-Provided new project demo to division director and managers

-Supported users in equipment management and in dispatched job payroll.

-Support third party Java based system interface to AS400

Denso Products and Services America, Inc. July 2015 – May 2016

Automotive distribution, Consultant

-Worked on company business and WMS system consolidation project using AS400 RPGLE Free Form programming.

-Analyzed and modified the existing BPCS in-house programs for warehouse distribution.

-Analyzed, created EDI ASN consolidation program from separated EDI vendor specific programs.

Hyundai Autoever May 2013 – July 2015

Automotive, Consultant

-Worked on the AS400 warranty, supply chain,MPG project.

-Designed and developed project transaction and payment processing with SQL, RPGLE Free Form.

-Supported business users throughout the project duration.

-Communicated with outside IT business vendors for web interface, troubleshooting and support.

-Supported .Net C# team for front end interface and for Siebel system reporting.

Ventura Food Oct 2012 – April 2013

Distribution, Consultant

-Worked on Oracle JDE OneWorld ERP conversion.

-Provided AS400 support for WMS manufacturing, inventory and order entry.

-Developed new AS400 RPG Free Form application to Oracle JDE OneWorld interface.

-Provided business requirement analysis, programming, testing, implementation and post implementation support.

-Provided user support throughout the duration of the project.

Bank of America Oct 2010 – Oct 2012

Mortgage Loans, Consultant

-Worked on BOA application initiative development and enhancement.

-Involved in various critical projects for the Fees Due team with big volume update processing.

-Used AS400/RPGLE, RPG Free Form procedure and service program, store procedures, SQL, Turnover.

-Provided performance analysis and used multi-threading and proper file indexes.

-Interfaced with .Net C# front end application.

-Provided application system analysis and documentation. Worked with analysts, QA, LOB, MQ, including Maximo incident approval process.

Hyundai Motor America Mar 2010 – Oct 2010

Industry Parts, Consultant

-Worked on two Customs Parts regulation projects.

-Full SDLC development both online and batch programming, including Free Form, procedure calls, embedded SQL, and commitment control.

-Developed functional and technical specifications, test scripts and implementation documentation.

-Involved in user meetings, discussion, testing, and after-implementation support.

-SAP implementation exposure and interface.

Bank of America Feb 2009 – Mar 2010

Mortgage Loans, Consultant

-Participated in BOA/Countrywide HELOC and Investor Accounting conversion and application gap enhancement development.

-Used AS400/RPGLE Free Form, procedure, service program, SQL, and multithreading job process.

-Developed stored procedures calls and Java J2EE interface.

-Provided application system analysis and documentation.

-Coordinated with various teams and provided offshore support. Used Turnover source control.

Hyundai Motor America Oct 2007 – Dec 2008

Dealership Sales Marketing, Consultant

-Worked on a variety of projects to support Sales Marketing, vehicles dealership system.

-Programmed using Free Form, embedded SQL, Procedure Prototype binding with interactive programs and batch application.

-Participated in all phases of the project, including business analysis and project application design up to user testing.

-Worked on .Net C# interface and online Dealer Sales application, AS400 data provider, and store procedure calls.

-Used Visual Studio and was involved in Webservice. Developed store procedures to interface to DB2 AS400.

Countrywide Home Loan Calabasas Feb 2007 – Sept 2007

Mortgage Loans, Consultant

-Participated in developing new front-end (.Net) and back end (AS400) loan transfer application system.

-Programmed on AS400 RPGLE Free Form, store procedures interfacing with .Net front-end. RPGLE Free Forms.

-Main person who developed the AS400 back end process for the team.

-Involved in all user design discussions, developing, unit and integration testing

-Worked on some existing .Net C# maintenance projects in MS VS2005 and VS2003.

-Screened, added, and changed backend AS400, updated and reposted back to front-end.

Hyundai Motor America Mar 2006 – Jan 2007

Dealership Sales Marketing, Consultant

-Worked on a variety of projects to support Sales Marketing and the vehicles dealership system.

-Programmed using Free Form, embedded SQL, Procedure Prototype binding, Service program with interactive programs and batch application.

-Interfaced to a variety of Web online applications, distributed the reports from AS400 to Web.

-Created XML for Vendor application.

-Involved in some .NET C# projects to interface and support a third party web Sales Marketing application.

Health Net Apr 2004 – Nov 2005

Healthcare and Accounting, Consultant

-Worked on a two-year, million-dollar healthcare payment system development and implementation project.

-Project was successfully implemented for the important business payment function.

-Programmed using Free formed RPGLE to interface with Valutech Mainframe application with huge transactions.

-Included full development life cycle with analysis, user discussions.

-Provided documentation, coding, testing, implementation and post-production support for a big project.

-Communicated with users and other technical teams to get the best outcome.

-Interfaced with the bank and Provider/Client Claims printing services.

-Performed Visio representation of business and technical process workflow to the user and other technical teams.

-Analyzed and processed Year 2004 Form-1099s for submission to the company’s providers.

-Worked on HTML. Folder file to display AS400 reports on intranet.

-Worked on FTPs, procedure calls, batch, reports, online programming. Used SQL, MKS implementer, and Robot Scheduling to analyze and improve operating efficiency by coding multiple processes at the same time for jobs

-Troubleshooted and fixed the user testing and post implementation problems.

-Worked on interfacing to Mainframe COBOL files and mainframe based healthcare payable system.

Work history prior to 2004, including permanent employment, available upon request:

-Retail and distribution: Toshiba, Disney Stores, Duty Free Shoppers, Federick’s of Hollywood

-Mortgage : Countrywide, Kubota Tractors

-Manufacture: Fadal Engineering, Korody Colyer

TECHNICAL TRAINING

-AS400: Many seminars, onside and offside training.

-Dot Net: Moorpark College.

-Java: Cal Poly and Colleges

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

EDUCATION

University of California, Irvine

Department of Computer Science Irvine, CA Graduated Dec 1986

Bachelor of Science in Computer Science

GPA: 3.6

Pasadena City College

Department of Computer Science Pasadena, CA Graduated June 1984

Associate Degree in Computer Science

GPA: 3.4

Contact this candidate