SUMMARY:

More than 23 years programming and application development experience.

TECHNICAL SKILLS:

LANGUAGES:

Proficient in: IDMS/ADSO, BASIC, RPG II & III, MVS/JCL (& PROC’s), Easytreive Plus 6.2, DB2, QMF, IDEAL, VMS, MAPC, Data Junction, XML.

Familiar with: TSO/ISPF, Xpediter, Endevor, CA7, Fileaid, Oracle SQL Developer, SoapUI, Ultra - Edit 32, CA Panvalet.

SOFTWARE:

Database: Microsoft SQL Server, Datacom DB, Oracle 11g & 10g, RDBMS, ADABAS and Microsoft Access

Platforms: IBM Mainframe 3370 & 3390, PDP 11/44, VAX 11-750, AS/400, Microsoft Windows® 98, Microsoft Windows XP, Microsoft NT, Isolutions.

EXPERTISE AREA:

• Designed a new buying system that allowed more information to be available to the buyers. This permitted them to make better purchasing decisions.
• Rewrote two inventory systems from RPG to Confidential to stream line processes for the on-call programmers, maintenance and enhancements.
• Rewrote job streams to convert all in stream Easytreieve programs to Confidential for maintenance and enhancements.
• Designed a Cashback system that allowed a customer to earn a cash rewards based on amount spent for qualified members.
• Used Confidential screens to design new stand-alone application (EACP) that was used to monitor production standards.
• Used Confidential Web Service to design a program for missing purchase data information.
• Used Confidential Web Service to design a process for adding, updating or removing membership information.
• Developed enhancements to the Vendor Swell process which ran for 40 hours (one step) down to 8 hours for the same step; which made the job stream run more efficient. By adding an alternate index to an old process.
• Developed the template used by Confidential to sunset their legacy system into JAVA specifications.

EXPERIENCE:

Confidential, NY

Sr. Programmer Analyst

Responsibilities:

• Created extract programs ( Confidential ) to load data into PeopleSoft.
• Created QMF queries to validate program totals (reconciliation totals).
• Validation of recon-totals from extract file loads.
• Preformed code modification per load report errors.
• Performed data mapping for extract files.
• Perform analysis from load error reports to modify extract programs.

Confidential, Schenectady, NY

Sr. Programmer Analyst

Responsibilities:

• Validating code changes and test all parts before install.
• Confidential program modifications, adding fields to the screens.
• Responsible for of all modifications to the label and scanning systems

Confidential, Latham, NY

Sr. Programmer Analyst

Responsibilities:

• Validating code changes and test all parts before install.
• All systems source code is Easytrieve.
• Validated data for online program using DB2 SQL queries.

Confidential, Glenmont, NY

Programmer Analyst

Responsibilities:

• Migration project, validating code changes and test all parts before install.
• Validating software changes (Isolutions).
• Enhancements to Confidential programs along with BMS maps.
• Performing parallel testing to validate changes.
• Creating test plans, documentation of process flow.
• On call rotation.

Confidential, Bentonville, AR

Programmer Analyst SR

Responsibilities:

• Lead resource for New Mobility Tablet project: reviewed all code before install.
• Designed a load and unload process for Teradata (which includes creation of the tables).
• Developed file layouts, Confidential program and formatted the file for several processes (Journal Sweeping, Daily Balance Recon, Confidential Web Services).
• Designed the program specifications for Cash Rewards project.
• Designed a Confidential Web Service program for missing purchases for club members (Used WSDL’s).
• Design process for FTP data from Mainframe to Cassandra (repository for data - tables).
• Performed maintenance patches on the Autorenew process.
• Designed a Confidential Web Service to update, remove or add membership information (Used WSDL’s).
• Created the documentation for turning jobs over to the support team.
• On call rotation.

Confidential, Schenectady, NY

Programmer Analyst

Responsibilities:

• Documentation of the PPR & PPA system.
• Data conversion.
• Created Java specifications from PowerBuilder Code.
• Created Java specifications from Confidential programs.
• Analyzing the Confidential code and all DB2 functions.
• Data Mapping documents for PPR & PPA system.

Confidential, Albany, NY

Programmer Analyst

Responsibilities:

• Developed online and batch test plans.
• Data conversion.
• Resync project when multiple enhancements for the same program, but have different implementation dates.
• Modified PA Paper process - copybooks, database tables, programs, and VSAM file, per new lines on the PA Paper form.
• Developed queries and updated the database using SQL.
• Provided technical support between teams when programmers would work on projects for other teams.
• Modified and tested Data Junction enhancements (interface that translates the transaction).
• Programming and implementation support to the Health Care System, written in Confidential and DB2.
• Developed test plans and data, and user documentation for the Health Care System.
• Modified the HIPAA 278 transaction for conversion from 4010 to 5010 (X12 format).
• Modified transactions 837D (Dental), 837I (Institutional).
• Designed a special report from a 997, 999, TA1 validation transaction.
• Designed a file for HL7 request for Patient Medical History information (90 days worth of data),
• XML file format.
• Modified and tested the Paper Form Process using Confidential and DB2.
• Performed system enhancements and maintain existing programs.
• Developed and maintained programs using Confidential /COBOLII, Confidential, Easytreive Plus 6.2 and DB2.
• VSAM file processing
• Used INTERTEST debugging tool for the Confidential programs.
• On call rotation.

Confidential, Springfield, MA

Programmer Analyst

Responsibilities:

• Developed and tested the new process to determine the top ten Brokerage Directors, using Easytreive.
• Developed queries and updated the database using SQL & QMF.
• Modified the MEC System when a policy change happens (PC01, PC03, PC06 or 708 transactions) within 90 days of issue, using Confidential and DB2.
• Modified the COA Letter (removing specific sentences) process, using Confidential and DB2.
• Prepared test plans and data for the Quota Buster system.
• Developed the requirements and documentation for a Schedule A Project, adding comp type to the PSS text file, which was uploaded to the client’s database. Designed the FTP process to accomplish this task.
• Modified the file extraction process for writing agent’s W-2 error with the state information on the extract tax form.
• Developed a process to prevent FTP’d files from getting overlaid when the client did not rename the files before the next time the file was created.
• Researched the retired contract agents not paying persistency fees. Found out that retired agents over 10 years are still generating policies and need to be paid premiums for those policies.
• Modified the FTP process to prevent files from getting overlaid when a client submits a new file.
• Modified the process to consolidate DASD space, reallocated space from cylinders, changed the way of archiving of files.
• Prepared documentation for all systems.
• Developed and maintained online transaction programs.
• Developed and maintained programs using Confidential /COBOLII, Confidential and DB2.
• VSAM file processing.
• Used INTERTEST debugging tool for the Confidential programs.

Confidential, Keene, NH

Programmer Analyst

Responsibilities:

• Developed and tested the new buying system and user documentation, using Confidential and DB2.
• Developed and tested the new EAPC system (used to track production standards) and user documentation, using Confidential & Confidential .
• Developed and tested new inventory management system and user documentation, converting RPG to Confidential including updating into Datacom.
• Provided technical support between teams when programmers would work on projects for other teams.
• Developed queries and updated the database using SQL.
• Performed system enhancements and maintain existing programs using Confidential, Confidential using both DB2 & Datacom.
• Modified and tested the warehouse system after new warehouse acquisitions, using Confidential .
• Responsible for new warehouse setups, realignments and data conversion.
• Modified job streams to remove inline Easytreive programs converting them into Confidential .
• Problem-solved Vendor Swell process from 3 days to 8 hours. By adding an alternate index to an old process.
• Prepared documentation for all systems.
• Developed and maintained batch and online programs using Confidential /COBOLII, Confidential, DB2, Easytreive plus 6.2 and with databases Database used was Datacom.
• VSAM file processing.
• Modified code on the label system.
• Used INTERTEST debugging tool for the Confidential programs.
• On call rotation.

Confidential, Denver, CO

Software Engineer

Responsibilities:

• Developed and tested Medicare system, including online transactions, using Confidential /COBOLII.
• Modified and tested claims detail & summary screens, using Confidential & Confidential .
• Prepared test plans and data, and user documentation for Medicare system.
• Provided technical support between teams when programmers would work on projects for other teams.
• Designed a file consisting of UB92 transactions to send to the Government, XML file format.
• VSAM file processing.
• Used INTERTEST debugging tool for the Confidential programs.
• On call rotation.

Confidential, Boise, ID

Programmer Analyst

Responsibilities:

• Developed and tested new radio frequency system (RF) and user documentation, using IDMS, Confidential & Confidential .
• Responsible for new warehouse setups, realignments and data conversion.
• Developed and tested new warehouse equipment tracking system, using IDMS, Confidential .
• Developed and tested new inventory management system and user documentation, using IDMS, Confidential & Confidential .
• Provided technical support between teams when programmers would work on projects for other teams.
• Performed system enhancements and maintain existing programs.
• Performed modifications on financial reporting system using IDMS, Confidential .
• Modified and tested order processing system using Confidential .
• Responsible for new warehouse setups and realignments.
• Performed Y2K modifications on warehouse system.
• Developed and maintained batch and online transaction programs using Confidential /COBOLII and IDMS (RDBMS).
• VSAM file processing.
• Modified code on the label system.
• On call rotation.