PROFESSIONAL SUMMARY:

• 20 years professional experience as a Technical Software Applications Analyst.
• Over 10 years experience working in ERP Systems.
• Current experience in Lawson applications including General Ledger, Accounts Receivable, Billing Revenue, Activity Management, and Accounts Payable modules.
• Experience with Infor Lawson including application production support, in - house job creation, enhancements, problem resolution, reporting, and more.
• Experience in Lawson ProcessFlow, Lawson ProcessFlow Designer, JavaScript, AS/400 COBOL, SQL, CL, DBU, DFU, FTP, Java, and Lawson Add-Ins,Oracle, SQL, Query. SQL*Plus, SQL, PL/SQL.

TECHNICAL SKILLS:

Database: Oracle 10/10i, Workflow, Banner, AS/400 DB2, Lawson, MS Excel, SQL server

Software: Lawson ProcessFlow, Lawson Add-ins, Oracle Toad

Language: AS400 COBOL/CL, SQL, PL/SQL, SQL*Plus, C/C++, Java, JavaScript, Oracle

Operating Systems: Unix, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Oak Brook, IL

Project Programmer Analyst

Responsibilities:

• Create programs, modules, and/or functions from detailed technical specifications or similar information.
• Identify opportunities and take advantage of code reuse.
• Follow established programming standards including naming conventions and formatting.
• Participate in groups reviewing and enhancing programming standards and conventions.
• Document work according to existing templates and standards.
• Perform unit testing on the programs/functions created.
• Assist programmers conducting unit testing.
• Perform performance testing and review modules and functions for performance improvements.
• Work with others to contribute to test plans.
• Participate in system integration testing.
• Conduct code reviews and other walkthroughs
• Participate in product and vendor evaluations
• Lead or co-lead small development or research projects.
• Provide estimates for project planning purposes to project managers.

Environment: AS/400 COBOL, COBOL II, CL, DBU, DFU, SQL, Lawson, ProcessFlow, Java, Oracle 11, Workflow, Banner, PL/SQL, SQL Server Enterprise Manager, Toad, OSS, Confidential, JCL, TSO

Confidential, IL

Programmer Analyst

Responsibilities:

• Worked on cross-platform integration team, responsible for the development, testing and implementation of application software programs in AS/400-iSeries and network environments.
• Responsible for the day-to-day automation needs of insurance business through maintenance.
• Completed and participated of an integrated TPA UPLOAD system.
• Analyzed, designed and completed CI interface to Point (AS/400) system functionality.
• Completed Draft Honoring project in Harco AS/400 online system.
• Significantly supported accounting department daily production problems.
• Analyzed and designed new Harco Lease and Rental Application job stream.

Environment: AS/400, COBOL, SQL, Query, DB2 Database, CL, DBU, DFU, FTP

Confidential, Woodridge, IL

Oracle Developer

Responsibilities:

• Conducted DB design, created tables, loaded data into tables.
• Used ERwin (ERD, ERM); did forward engineering, reverse engineering.
• Collected data, populated tables using SQL *Loader.
• Created DB backup plan and procedure, and implemented DB backup.
• Created Oracle Forms and created Oracle Reports.
• Republished application to Internet.

Environment: Visual Basic 6.0, Oracle 8/8i, SQL *Plus, SQL, PL/SQL, Oracle Forms 5.0, Oracle Reports 3.0

Confidential, Vernon Hills, IL

Programmer Analyst

Responsibilities:

• Develop, test and support custom business applications on AS/400 and Confidential systems.
• Analyze and design Sales/Marketing programming job stream.
• Set up AS/400 and Telemar access for users, and solve Telemar (AS/400) problems.
• Create confidential reports by using COBOL programming.
• Solve help-tickets for the users.
• Create quick report through the AS/400 Register One databases by using query.
• Use SDA create interactive programming.
• Use SQL to manipulate data, retrieve data from the files.
• Solve production problems.
• Participate in discussing with end user needs and translate them into ASW functionality.
• Participate in analyzing and mapping mainframe data structure into ASW system.
• Migrated programs and files from Mainframe to AS/400 ASW system.
• Create quick report through MS SQL Server 7.0 database using Topdog.
• Resolved production problem through migrations from Mainframe to AS/400.
• Completed and participated of an integrated ERP system.
• Analyzed, designed and completed more than 60% of our Sales/Marketing application reports job stream.
• Completed Confidential, and AS/400 system Y2K projects.
• Designed and implemented all the Sales/Marketing files on the ASW system.
• Significantly improved Help Desk customer service - reduced average “hold” times.
• Designed and implemented our Internet files from Telemar for the networking department.
• Designed and implemented customer-buying group files on ASW system.
• Designed job stream of the introduction letters for the Inside Sales Department and HealthCare Department.

Environment: Confidential, COBOL, CICS, JCL, Telemar, AS/400, COBOL, some RPG, SQL, Query, Register One Database, CL, DBU, DFU, FTP