SUMMARY:

• QL, Query. SQL*Plus, SQL, PL/SQL.
• 20 years professional experience as a Programmer Analyst.
• Experience in Lawson ProcessFlow, Lawson ProcessFlow Designer, JavaScript, Lawson AddIns reports, Crystal reports, AS/400 COBOL, SQL, CL, DBU, DFU, FTP, Java, Oracle,

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,Brookfield,WI

Senior Programer/Analyst

• 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, AS/400 Query, QM, RPG

Confidential,Oak Brook,IL

Programmer Analyst - Lawson

• Provide day-to-day support to the business and Subject Matter Experts (SMEs).
• Provide hands on analysis, design, testing, implementation and post-implementation support.
• Utilizes SMEs and personal knowledge of the business area and applies technical expertise to determine appropriate solutions to satisfy functional gaps.
• Analyzes change requests to determine feasibility in relation to existing business requirements, processes and data models.
• Works with project leadership in determining design approach, estimating/planning, setting technical direction and identifying necessary resources for a project.
• Interfaces with vendors during project and production support activities.
• Strong understanding of software development life cycle as well as both waterfall and agile development methodologies
• Maintains in-depth up-to-date knowledge of standards, guidelines, industry trends
• Designs and delivers proof-of-concepts
• Experience supporting Lawson v10
• Mingle experience (Version 10)
• Experience supporting MHC/Document Express
• Lawson administration experience
• 19+ years designing and developing custom programs, interfaces and reports for these modules to meet the business requirements.
• Knowledge of Lawson security and administration
• Experience utilizing Lawson Process Flow; Lawson Business Intelligence (LBI); screen modifications; interfaces; and custom screens, programs and tables; Crystal reports.
• Utilize Lawson functionality whenever possible to minimize the need for customizations.
• Write and maintain process flows (IPA)
• Prepare and maintain documentation and training materials to support modifications.
• Thoroughly test all modifications and coordinate user acceptance testing.
• Participates in change management process.
• Strong Micro Focus Cobol with embedded SQL programming experience
• Maintain Lawson web pages using process automation, html, java / java script, process flows, design studio forms, or portal pages.
• Experience with Windows shell scripting, Java, HTML, XML and XLST
• Strong Oracle PL/SQL, SQL knowledge
• Experience with TOAD, SQL Developer
• Understanding of SDLC, waterfall, and Agile application design and development
• Understanding of business processes, project management/planning, time management

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

Confidential,Rolling Meadows,IL

Programmer Analyst

• 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

• 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

• Develop, test and support custom business applications on AS/400 and IBM Mainframe 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 IBM Mainframe, 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: IBM Mainframe, COBOL, CICS, JCL, Telemar, AS/400, COBOL, some RPG, SQL, Query, Register One Database, CL, DBU, DFU, FTP

Confidential,DeKalb, IL

Lab Assistant

• Software support, program debugging, MS Office Support, maintain hardware.