SKILLS

• SQL
• RPGILE
• COBOL
• RPGIV
• Windows PDM
• OS400 DB2

PROFESSIONAL EXPERIENCE

Confidential

Senior Programmer/Analyst

Responsibilities:

• Programs were written to create reports for balancing accounts and for governmental reporting. Programs were written to maintain files to hold account numbers used in reporting programs.
• Programs were written to change Policy Status and Bill Mode AS/400 using RPG(Free), RPG - ILE, COBOL, SQL, DDS and Query. Programs were written to import data to Tracker Software to handle Escheated property to create letters and report to the states.
• Also Maintenance programs were written to populate and maintain files containing business rules. Code was written to support and maintain all existing systems that run the business.

Confidential

Senior Programmer/Analyst

Responsibilities:

• Programs were written to interface with the WEB to allow agents to Endorse and Reinstate policies on-line. Stored Procedures were also created to interface with the WEB.
• Be lead programmer in the coding of software to complete 9 digit Zip Codes and determine distance between two addresses on the AS/400 using RPG-ILE, COBOL, SQL, DDS and Query.
• Also Maintenance programs were written to populate and maintain files containing business rules. Code was written to support and maintain all existing systems that run the business.

Confidential

Consultant

Responsibilities:

• Work with DBA to finalize Technical Specifications. Play a vital role in designing new system for automated credit approval for corporate customers. Be lead programmer in the coding of the selection
• Financial Programs for new system on the AS/400 using RPG-ILE, COBOL, SQL, DDS and Query. Also Maintenance programs were written to maintain files required to populate the appropriate financial programs, pricing and other information available to the customer.

Confidential

Consultant

Responsibilities:

• Programs were written and maintained for manufacturing and warehousing systems. Programs were written for Accounting, Sales, Shipping and International applications.
• Programs were written on an iSeries AS/400, DB2 using RPG-IV, RPG-ILE, CL, Query, DBU, DDS, DFU and SDA. I also worked as DBA creating files, validating and correcting existing data.
• This included the use of subfiles, windows and help screens. I worked on EDI applications, form 810.

Confidential

Foster Parent

Responsibilities:

• Classes and training courses were taken to be certified as a foster parent. Two children have been in residence since 03/2004. An Additional child was placed in home in June.

Confidential

Consultant

Responsibilities:

• Wrote a Bonus System for a mortgage service company to track performance by loan service personnel to assure tasks were completed before awarding bonuses. Programs were written on an iSeries AS/400, DB2 using RPG-IV, RPG-ILE, CL, Query, DBU, DDS, DFU and SDA.
• This included the use of subfiles, windows and help screens.

Confidential

Consultant

Responsibilities:

• To write and maintain programs that report prescription information to pharmacies and insurance providers. Programs were written on an iSeries AS/400, DB2 using RPG-IV, RPG-ILE, COBOL, CL, Query, DBU, DDS, DFU, SDA and SQL.
• Aldon Change Management System was used. Data was used by pharmacies to obtain information such as number of refills, date limitations on refills, maximum number of doses, copay, etc. Providers used the information in data warehousing and for other reporting.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• To write and maintain programs to report tax information from County, City and/or school district tax rolls. Programs were written on an AS/400, DB2 using RPG-IV, RPG-ILE, COBOL, CL, Query, DBU, DDS, DFU, SDA and limited SQL.
• Data was used for paying property taxes by TRETS, and for reporting property tax status to major mortgage firms. Wrote automated edit program to reduce number of verification runs.

Confidential

Consultant

Responsibilities:

• To write and maintain programs and systems to produce reports, update files and On-line Screens for Warehouse Software system on an AS/400 using RPG-IV, RPG-ILE, Query, DBU, DDS, DFU, SDA and limited SQL.
• Responsibilities included administrative controls such as adding or changing peripherals, operating software and PTF’s. Work was done with other systems in Accounting, Purchase Orders, Warehouse Management and Inventory Control.

Confidential

Programmer/Analyst

Responsibilities:

• To write and maintain programs and systems to produce reports, update files and On-line screens for Electronic Data Interchange system on an AS/400 using RPG-IV, RPG-ILE, Query, DBU, DDS, DFU and SDA. Work was done with other groups as needed on Accounting, Purchase Orders, and Inventory systems.

Confidential

Programmer/Analyst

Responsibilities:

• To write and maintain programs and systems to produce reports, update files and On-line screens for Claims, Policy Services, Customer Service, Underwriting and Accounting on an AS/400 using COBOL, Query, DDS, DFU and SDA. Aldon Change Management System was used.

Confidential

Programmer/Analyst

Responsibilities:

• To write and maintain programs and systems to produce reports and update files and On-line screens for Claims, Policy Services, Customer Service, Cash Operations, Underwriting, and Accounting on an AS/400 using COBOL, Query, DDS, DFU, and SDA.
• Performed all aspects of operations, including monthly runs, adding/deleting profiles, system administration, PTF’s, etc. Also worked on conversion to Client Server Arena programming with GUPTA SQLWindows.