QA Analyst/ Developer

Senior Programmer/Analyst

Alan W. Schoen

Telephone: 1-209-***-****

******@*******.***

Objective

To bring to my new employer the following:

•Excellent analytical skills

•Team leadership

•A proven ability to meet deadlines

•A flexible workhorse who is able to multi-task and learn new technologies quickly

Skills

Programming Languages,Operating Systems,Applications and Utilities.

All versions of RPG(II, III, IV, ILE),CL,Websphere,Open Query Files,

Java, OCL, Bookmaster, SQL, Java Script, MVS/JCL, JDE, JDBC, Cobol, Linux,

Harbinger & Extol EDI, FEU, Lansa, Windows Server 2003, BPCS, ZMOD, HTML & CSS,

Windows XP, Itera, Socket Servers, XML, Apache, Hawkeye, DBU, PHP, Turnover, WAMP,

MYSQL, Roadshow, XSLT, Dreamweaver

Experience

International Business Systems

Folsom, CA

June 2006 - March 2009

Position: Senior Programmer Analyst

•Developed, enhanced and maintained Bookmaster application for client base

•Conversion of Bookmaster application from release 7.2 to 7.3 and from 7.3 to 7.4

•Worked with sales team to take prospective client requests and modify Bookmaster systems to show capability of system for demos

•Worked with Bookmaster E-commerce product. Installed, maintained, modified and tested E-commerce web site (front end and backend (AS400)) using Websphere, JDBC, Java and Java Script

Accomplishments at International Business Systems

•Using data From Excel spreadsheet we developed a system to update the data into a universally defined data base on the AS400, which in turn was used to display various information on the product pages of the website. This saved many man hours keying in data and allowed for better maintenance of the web pages

•Worked closely with client to successfully have E-commerce website up and running

•Learned Websphere, Java, Java Script, Html

•Trained several people on the installation of the E-commerce software and the use of Websphere

Nor Cal Beverage

West Sacramento, CA

July 2005 - May 2006

Position: Senior Programmer Analyst

•Consolidated branch information (Salesman, Routes, Sales, Sales History, Accounts) as branches were combined

•Designed and implemented reporting process to report sales and bill back information for rebate programs. Sent reporting data via EDI for payment

•Mastered EDI processes using Trusted Link

•Supported application called Roadshow. Streamlined deliveries and tracking systems. Created additional reporting and delivery route change applications

•Used and monitored ITERA disaster recovery systems

Accomplishments at Nor Cal Beverage

•Designed bill back system to look at each sale during the month and calculate those items for which a rebate program existed. This process brought back into the company thousands of dollars each month

•Successfully converted one branch to another as branches were being consolidated

Delta Health Systems

Stockton, CA

May 2004 - June 2005

Position: Senior Programmer Analyst

•Upgraded Legal Defense Fund Systems from RPGII to ILE. Made functional changes to the old process to enhance reporting and data entry

•Identified and changed all existences of the employee number field which was increased from 5 to 7 positions

•Analyzed, enhanced and maintained core medical claims systems

•Designed 837 EDI mapping programs to work with EXTOL for hospital claims

•Developed and tested voids and refund processes. Also used RVI imaging systems to store and redisplay claims documentation for customer service people to better assist the client base

•Learned and implemented ZMOD functionality. Automated FTP processes for sending and picking up customer DDM files which, upon receiving data, also kicked off remote jobs. This process eliminated manual intervention

London Pacific Life & Annuity

Natomas, CA

Feb 2000 - Sept 2003

Position: Senior Programmer Analyst

•Gathered specifications, designed, tested, and implemented a Conservation System saving the company $5 million dollars

•Analyzed, enhanced and maintained (in RPG and LANSA) valuation systems (the core systems of the insurance company)

•Developed and implemented systems which met the Department of Insurance requirements

Packard Bell

Sacramento, CA

Sept 1998 - Jan 2000

Position: Senior Programmer Analyst

•Led a team that designed, enhanced, and tested a new interface for Harbinger EDI to process orders into BPCS

•Implemented order confirmation transactions using EDI transactions to meet customer requirements

•Maintained and enhanced KIOSK system enabling customers to build and order their own computers at various sites

Education

College, Location, Degree Field of study

Queens brougho Community College, Bayside, NY, Associates DegreeData Processing

Baruch College, New York, NY, Major - Computer Information Systems

AcademyX, Natomas, CA, Certificates for - HTML,CSS,Search Engine Optimization,JavaScript,

SQL,MYSQL, PHP, WAMP, Dreamweaver Basic and advanced, XML and XSLT

Contact this candidate