Project Analyst

JAMES C. DREW

Burbank, CA *****

818-***-**** http://www.linkedin.com/in/jdrew1 ******@*****.***

SUMMARY

Detail-oriented and highly focused Senior Applications Analyst / Developer with extensive programming experience utilizing RPG, CL, Subfiles and SQL for AS/400 / I-Series computer system. Detailed knowledge of insurance claims and premium accounting. Sound trouble shooting and analytical skills. Demonstrated ability to deliver technical code that is easily understood and well tested, increasing maintenance efficiencies while providing continuous program access and availability.

TECHNICAL SKILLS

Operating Systems OS400

Software / Languages RPGIV, RPG3, RPG2, RPG FREE, CL, COBOL

RDBMS DB2

Additional SQL, Subfiles, SDA, DDS, PDM

PROFESSIONAL EXPERIENCE

REPUBLIC INDEMNITY, Encino, CA

Sr. Apps Analyst Developer 2010 – 2011

Designed, coded, tested, debugged, documented, and maintained application programs written in RPG and CL.

• Managed Premium Accounting department applications successfully completed assigned Underwriting projects which increased departmental efficiencies and capabilities.

• Rewrote and successfully implemented Direct Collection System for Premium Accounting providing efficient vehicle for handling account inventory processing and management; assumed responsibility of gathering / determining system requirements after original system was rejected based on analyst specifications.

• Delivered improved payment security and compliance with PCI (Payment Card Industry Security Standard) as contributing member of 5-person project team which provided enhanced design of existing Premium Payment System.

Sr. Programmer Analyst 2006 – 2010

Designed, coded, tested, debugged, documented and maintained application programs written in RPG, CL. for Claims and Premium Accounting departments.

• Served as lead programmer for WCIS project (Workers' Compensation Information System) ensuring state requirements were met by creating claim submission and reporting functionality.

• Increased reporting levels from 5 to 10 for NCCI and California as reported to insured through development and completion of Unit Stat (Unit Statistical reporting) project.

• Modified programs to utilize newly created printer control file in completing Printer Control Project for IT Claims Group, allowing ability to control all distribution information in delivering reports to correct destinations.

Programmer Analyst 1992 – 2006

Designed, coded, tested, debugged and maintained application programs written in RPG, CL, and COBOL for Claims and Premium Accounting departments.

• Ensured accuracy in auto-generated communications by creating and revising various business letters and related programs, including Claim, Medical, Rehab, Disability and Litigation letters.

• Verified compliance to government requirements through completion of modifications to 1099 forms processing.

JAMES C. DREW PAGE TWO

REPUBLIC INDEMNITY (Continued)

• Modified programs as contributing team member of Claim Conversion Project; ensured all functionality requirements were met through completion of thorough testing prior to production release; project completion enabled business continuation by increasing claim and policy number fields.

• Ensured date usage capacity of programs, files and sorts increasing to 8 bytes as required by Y2K Project; tested and ensured system capabilities successfully meeting department wide deadline.

• Developed and utilized system which facilitated ability for claims personnel to add, change, delete, display and print notes regarding each claim, increasing efficiencies in procedures.

Additional Positions Held

• Programmer

• Programmer Trainee

• Tech Assistant

• Computer Operator

EDUCATION

Coursework, Computer Science / General Education, Los Angeles Valley College, Valley Glen, CA

Relevant classes include: RPG, COBOL, Access Database, Java, Visual Basic, Advanced Visual Basic

Contact this candidate