SUMMARY:

Information technology professional capable of managing technology projects from concept to completion with remarkable deadline sensitivity. Twenty four years IT experience as an information developer builder. Strong analyst skills combined with experience in various areas of Software Development. Experience includes AS400 RPG III, RPG IV/ILE, WebSphere, VB6, C#, ASP.NET, ASP, ASNA Visual RPG and Gupta SQL windows. Good communication skills. Fluent in English, Chinese, and Taiwanese.

TECHNICAL SKILLS:

Platforms: IBM iSeries(AS400), Windows Server 2003 R2Window 2000/XP/NT/Vista, CONVEX (Unix)

Languages: RPG II/III, RPG IV/ILE(procedures, modules, binding, service program), SQL/400, RPG Free, CLP, IIS, Stored Procedures, SQL, HTMLJava, JavaScript, VB Script, XML, XSLT, Webfacing, ASP, C#, ASP.NET, VB, Gupta SQL windows, C, Microsoft Access, Excel, Unix Shell Scripting, Pascal, Fortran.

RDBMS: IBM DB2, MySQL, MS SQL Server 2005 and 2008(Transact SQL, stored procedures).

Tools: MS Visual Studio 2005/2008, MS SQL Server Business Intelligence, Visual Web Developer 2008, SSIS, SSRS,MS Office Suite, Microsoft Outlook, PowerPoint, Access, Lotus Notes, IBM Data Studio 3.1.1, Hawkeye, Aldon Change Management System, Turnover, Mercury Test Director, IBM Utilities including PDM, SEU, SDA, RLU, DFU, IBM Client Access, IFS, Visio, iNavigator, Query, MQ Series, Robot Scheduler, QM Query, IBM ShowCase Query, BMC Control - M and Crystal Report.

PROFESSIONAL EXPERIENCE:

Sr. AS400 ISeries Developer

Confidential, Plano, TX

Responsibilities:

• Write RPG-SQL programs to fix records in database for accounting department.
• Write new interactive RPGLE program for Massive copy for eligible dealers.
• Modify/Write new RPGLE programs in free format to performs refreshed DEV, QA, and Based environments from tape restored process.
• Each environment to be copied would base on flag set up in data area.
• Modified existing ASNA Visual RPG programs like Dealer Inquiry which was used by HDMC. Use Turnover Client V100 to promote objects to production.
• Worked on a project for replacing a vendor FIS finance service with new vendor - CEDAR. Write new and modified existing RPGLE programs, CLLE programs and create new tables for EDI process through EXTOL tool; Populates 810 closed file, EPAY 128 Dealer profile, and add new fields information to existing ASNA RPG GUI Dealer Inquiry application.
• Modify RPG programs so it can be restored libraries from tape.
• Support Infimum Account Receivable application.
• Support any AS400 production issues or user inquires.
• Use TURNOVER for iSeries programs check in and check out.
• Coding, unit testing, debugging and troubleshooting skills.
• Provide technical detail design solution based on business requirement.
• Supporting daily issues, using ServiceNow application to create incident tickets, problem tickets and write knowledge article for the root cause.
• ITIL foundation class training.
• Schedule all the AS400 batch jobs in BMC Control-M tool; set up calendar for each job.

Consultant - Sr. AS400 ISeries Developer

Confidential, Addison, TX

Responsibilities:

• Work with mortgage department for Confidential Lender Placed Insurance Letter project, write LLD (Low Level Design), create new programs (using embedded SQL) for Weekly, Annually, and One-time process to select loans on different selection criteria and create extract file then send it to IFS folder.
• Impact analysis on LPAR project - List out RPG programs that need to be modified when move 24/7 applications from primary production server LS to secondary production server HALS.
• Use TURNOVER for iSeries programs check in and check out.
• Work on the project of IBMi stability and resiliency; modify existing programs to remove ‘PL’ system name hardcode reference, change update files to USROPN, and add copybook for a procedure reference.
• Review peer’s programs and write comments if found something incorrect.
• Write utility program for MST TEB team. The program will run on AS400DEV daily to send a message to users (testers and developers) if they have files that have not been used for more than 30 days or if their memory (DASD) utilization climbs up by more than 20% overnight.
• Work with offshore for some requests through email or MOC.
• Write test scripts and defects into a tool software called HP Quality Center.
• Testing RPG programs in CIT environment.
• Work with offshore QA in helping for the RPG programs’ test.
• Write prototype procedures and programs to retrieve secondary server information. Create modules, service program, binder language, binding directory and copybook.
• Write SQL scripts to analyze the data from system i Navigator.
• Write NEP program which contains CL and embedded SQL program to monitor data Queue process. During the process, the program reads control table information, creates new record and new data queue if no record in the table. Once wake up, it checks current data queue threshold by calling QMHQRDQD API and create a new data queue if current data queue over its threshold.

.NET programmer and Web Server Administrator

Confidential, Dallas, TX

Responsibilities:

• Worked on a project to develop a new online order web application for auto parts by using Transact-SQL, Server SQL 2005/2008, AJAX, C#, ASP.NET 3.5 and Visual Studio 2008. The major function of screens is online order, view my cart, and view history. Also, email online order(s) to one of 13 warehouse locations based on user’s selection once order has been placed.
• Support for three SQL Servers that are using for Confidential online order, a maintenance program for parts, pricing, images, interchangeable parts information and vender information, Comet Tracker application and a testing server.
• Wrote Confidential -SQL trimming strings that have redundant space and tab char from tables before it feeds to Excel file. Also, set it up on the job scheduler.
• Wrote SQL, functions, stored procedures, Web Services and classes that can be used to perform searched function, data binding and data displaying. Connection database through ODBC.
• Maintenance of Confidential web applications using Microsoft .NET technologies.
• Updating the databases, supporting system implementation and maintenance.
• Using Microsoft BI to develop SSIS packages to extracting data from Excel files into tables in SQL Server; also, exporting data from SQL Server to Excel.
• Modified existing TMTWeb application by writing few asp files to display the DRP price and Keystone partslink information from these newly created tables.
• Using C# to develop an application program to allow user selecting various reports from different store locations, then create a report in Excel format.
• Added jobs to SQL Server Agent; Write store procedures and Confidential -SQL statements to SQL Server Agent to perform data conversion from Excel file to SQL Server table or update tables from one server to another server.
• Provide documentation to management department for our daily data upload process from TMTWeb Server to Confidential Server.
• Installation web application to IIS on Window Server 2003 R2.
• Modification .NET on-line order web application in C# to add search function by writing store procedures to perform search function; Write a class to perform calculation of customer’s price besides listing price on auto parts.
• Administration on Web Server issues; Disk available space is too small; the on-line program can' Confidential update the record; Shrank log files on databases in SQL Server.
• Replaced back up server’s hard disk with two new hard disk; Installed this back up server as production server, installed all required software, and installed Windows Server 2003 R2 operating system.
• Created new html files and modified some files of html to add new locations and its new link. Modified gif file to add new location from Adobe software.
• Modified existing VB6 login.asp and verification.asp to add new location ID in CA. Also, adding new logical for this new location even if user id and password are matched but IP address does not matched, still can’ Confidential allows user to login.
• Modified VB6 program to add new logical to populated additional records to file INMAS.
• Modified online order programs to add a web page for displaying part no, customer price, list price, interchangeable part no and photo.
• Sometime, Helping clients with account information set up such as user id, password, and IP address.
• Responsible for designing and implementing system modules using C#. NET, Visual Studio 2005 and 2008.

Consultant - Sr. RPG Developer

Confidential, Rochester, NY

Responsibilities:

• Worked on data conversion gaps’ analysis project on DPI billing system using AS400 RPG languages, IBM utilities and Turnover.
• Modified existing maintenance programs to add new options/features using RPG IV/ILE.
• Modified Line Card Maintenance program to allow user manually enters address information or F11 to Scroll SAM address and select the address from the screen using RPG IV/ILE, RPG free, Sub-file and API.
• Wrote RPG, embedded SQL, and CLLE program to create extract file for Confidential & Confidential with tariff code of GVN in California.
• Supported AS400 production issues and fixed defects using RPG languages.

Consultant - Sr. RPG Developer

Confidential, Houston, TX

Responsibilities:

• Created Sales Cycle Time report file/table in DB2.
• Wrote ILE RPG program to create the sales work file to be used in Showcase Strategy Query by sales department.
• Wrote various sales tracking reports for sales department using CLP, ILE RPG with embedded SQL to interface with Web application.
• Researched and wrote one-time fix program RPG or embedded SQL to correct the data in the database.
• Modified existing inquiry programs to add new features using RPG IV/ILE.

Sr. Programmer Analyst

Confidential

Responsibilities:

• Developed job control application programs to monitor AS400 jobs based on run time criteria.
• Automatically send out email to Helpdesk or on-call programmer when an error message occurs. Completed the project by using RPG ILE, Embedded SQL, CL, DSPF, API, Data Queue, Create tables in DB2 and exit programs setting up from WRKREGINF.
• Wrote java on line application using IBM WebSphere Application Server (WAS) tool to develop Java application program for user to inquiry the GL account information, list detail and has option to print the detail into Excel format.
• Updated/Inserted/Deleted/Query data using SQL.
• Wrote some AS400 RPG interactive programs for user to create a new record, update a record, delete a record or display a record.
• Interacted with users to solve business problems primarily with AS400 applications.
• Designed, developed, tested, and maintained IBM iSeries (AS400) RPG applications used by DSL and messaging users.
• Wrote RPG programs to create extract data files and send it to URL in Excel format for user access.
• Supported AS400 Order Entry application, Order generation process, Messaging billing process; Generated mailboxes monthly orders for each billing cycle, interfacing (Through FTP) with Mainframe to send electronic billing data and get confirmation report.
• Responsible for database queries.
• Migrated ABS data from remote database to AS400 database by using RPG programs.
• Migrated AS400 CPE data to ESS (Oracle) using RPG ILE and Embedded SQL.
• Development of projects using an EXPRESS (SDLC) methodology; Used waterfall methodology in the project.
• Used Aldon Change Management tool to check in and check out programs from production and development box.
• Supported Messaging group of mailboxes provisioning process.
• Gathered the business requirement, wrote technical design, high-level design, detail design, coding, test plan and operation installation guideline (OIG).
• Modified all the programs that have Y2K issues.
• 24 X 7 on-call support for production issue.

Sr. Programmer Analyst

Confidential

Responsibilities:

• Developed and maintained manufacturer applications in RPG language.
• Wrote RPG to developed various reports for accounting department.
• Modified RPG programs to simplify the EOM process.
• Modified all the RPG programs that have Y2K issues.