.Net Developer
Resume:
Danny Lu
h34oeb@r.postjobfree.com
Richardson, TX 75082
RELEVANT EXPERIENCE
Information technology professional capable of managing technology projects from concept to completion with remarkable deadline sensitivity. Fifteen years experience as an information developer builder. Strong analyst skills combined with experience in various areas of Software Development. Experience includes RPG III, RPG IV/ILE, WebSphere, VB6, C#, ASP, ASP.NET and Gupta SQL windows. Compatible team player through complete project cycles, testing, and final implementation, good communication skills. Fluent in English, Chinese, and Taiwanese.
TECHNICAL SKILLS
Platforms: IBM iSeries, Windows Server 2003 R2, Window 98/2000/XP/NT/Vista,
CONVEX (Unix)
Languages: RPG II/III, RPG IV/ILE, RPG Free, CLP, Stored Procedures, SQL,
Java, JavaScript, HTML, XML, XSLT, Webfacing, ASP, C#, ASP.NET, VB, Gupta SQL windows, C, Access, Excel, Unix Shell Scripting, Pascal, Fortran.
RDBMS: IBM DB2, MySQL, MS SQL Server 2005 and 2008.
Tools: MS Visual Studio 2005/2008, Visual Web Developer 2008, MS Office Suite, Microsoft Outlook, PowerPoint, Access, Lotus Notes, Hawkeye, Aldon, Turnover, Mercury Test Director, IBM Utilities including PDM, SEU, SDA, RLU, DFU, IBM Client Access, Visio, Query, MQ Series, and QM Query.
EDUCATION
MS in Computer Science - University of Texas at Dallas, Richardson, Texas
BS in Navigation - TAMKANG University, Taipei, Taiwan
PROFESSIONAL EXPERIENCE
.NET programmer and Web Server Administrator – PartsChannel, Inc. in Dallas, TX
(October 2008 – Present)
· Working on a project to develop a new online order web application by using ASP.NET 3.5, C#, ASP.NET and Visual Studio 2008. The major function of screens is online order, view my cart, and view history. Also, sending an online order to one of 13 warehouse locations based on user’s selection.
· Write SQL, functions, stored procedures, Web Services and classes that can be used to perform searched function, data binding and data displaying.
· Maintenance of PartsChannel web applications using Microsoft .NET technologies.
· Updating the databases, supporting system implementation and maintenance.
· Using Microsoft BI to develop SSIS packages to execute the job of converting two Excel files into tables in SQL Server; then 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.
· Add jobs to SQL Server Agent; Write store procedures and T-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 PartsChannel 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't 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’t 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 – Frontier Communications in Rochester, NY (October 2007 – June 2008)
· Worked on data conversion gaps’ analysis project 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 created extract file for AT&T with tariff code of GVN in California.
· Supported AS400 production issues and fixed defects using RPG languages.
Consultant – Daniel Measurement and Control in Houston, TX (July 2007 – September
2007)
· 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 AT&T (May 1999 – February 2007)
· 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.
· Wrote some 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; Generate mailboxes billing orders for each 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.
· Migrated AS400 CPE data to ESS (Oracle) using RPG ILE and Embedded SQL.
· Development of projects using a EXPRESS (SDLC) methodology.
· Experienced with Aldon Change Management toolset.
· Support Messaging group of mailboxes provisioning process.
· Gathered the business requirement, wrote technical design, high-level design, detail design, 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 BeautiControl Corp (March 1998 – May 1999)
· 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.
Programmer Analyst CompUSA, Inc. (December 1996 – March 1998)
· Wrote both on line and batch program in RPG for financial application system.
· Each program from system design, program specification, test plan, QA, then
implementation, it all follows the guideline of system Design Life Cycle (SDLC).
· Participated in the regular coverage for on-call support and problem resolutions for production systems.
Programmer Analyst Unger & Associates, Inc. (April 1995 – December 1996)
· Developed and maintained finance applications system in RPG language.
· Worked on client-server environment; Developed window applications to allow user to enter customer’s information using Gupta SQL Windows tool.
· Data conversion from IBM DB2 to MS SQL server.
· Created program icons, and teach operator how to run the daily/monthly process.
· Resolved end users PC's or AS400 related problem.
· Provided the application design, coding, testing, and documentation.
· Developed business application system for accounting department by using Gupta SQL windows front-end development tool.
Programmer American Hallmark Insurance Company (October 1992 – February 1995)
· Provided new system development and enhancement for automobile
insurance applications by using RPG programming language.
· Supported approximately 50 local and remote users on 9 communication lines..
Contact this candidate