Insurance Project

Name: Alfredo Espedido

Personal Details

Home Address : ** ********* *******, ******* ********,

Victoria 3029 Australia

Phone Numbers : +61-425-****** (mobile-Australia)

E-Mail : acfqeb@r.postjobfree.com

Citizenship : Australian (Philippines-born)

Academic Qualification

. Bachelor of Computing (Information Systems), Monash University, Victoria,

Australia

Professional Membership

. Australian Computer Society

Profile Summary

. Alfredo has Programming skills and experience in COBOL, DB2, SQL, CICS on

IBM Mainframes, plus skills on various mainframe utilities and third

party products. He has worked on development projects as well as in

Production support. Alfredo has worked on the HUON General Insurance

application. He also has design and documentation skills (Applications

and Programming) and proficiency in MS/Word and Excel. Alfredo has also

worked on software conversions, testing, data extracts and conversions to

DB2. Alfredo has also done some small team leading and software change

control administration.

List of Main IT Skills

Skill Name Years Last

Used

COBOL 15+ Current

IBM DB2, QMF, SQL 15+ Current

CICS 15+ Current

SQL (IBM) 15+ Current

JCL 15+ Current

VSAM 7+ Current

Easytrieve-Plus (including embedded DB2 SQL) 10+ current

HUON Solution/Protect: personal - motor, home products; 5+ Current

commercial insurance

FTP 5+ Current

Connect Direct 2+ Current

Change Control Management: CHANGEMAN, ENDEVOR,INFOMAN 10+ Current

Testing and debugging: FILE-AID, ABENDAID, VIA Smartest, 15+ Current

XPEDITER, CICS Explorer (DEBUG)

Systems Analysis/Development/Testing/Implementation 15+ Current

Mercury Quality Center (Test Director) 1+ Current

FILE-AID/MVS 15+ Current

FILE-AID/DB2 10+ Current

FILE-AID/ File Manager for z/OS 10+ current

IMS 10+ Current

Web Services / XML 1 2010

XML / Web Services 1 2010

SAS 2+ 2004

MQ-Series 1+ 1996

UNIX/Oracle, PL/SQL 1+ 1996

IT Experience

Organization : International Programming and Systems

at ACSC (Automobile Club of Southern California, an AAA

affiliate),

Costa Mesa, CA 92626, USA

Position : Analyst-Programmer - Dev Center - Enterprise Policy

Management

Period : Apr2012 to Oct2012

Summary of Duties

. Perform bug fixes on COBOL, DB2, CICS online subroutines for the HUON

General Insurance package.

. Perform bug fixes on COBOL DB2 batch reporting programs.

. Perform data changes using DB2 SPUFI.

. Develop new report programs with COBOL, DB2/SQL, JCL.

. Perform UT, and support UAT. Create Changeman packages for Production

install.

Products Used:

HUON, COBOL, DB2, CICS, JCL, FILE-AID, VSAM, Changeman, Debug.

(HUON is an integrated solution package for the general insurance

industry and used in Australia, UK, USA, and Canada).

Organization : CGU - Claims Transformation DB2 Conversion

181 William St, Melbourne 3000, Australia

Organization : CGU - Claims Transformation - COBOL, JCL, DB2

migration

Position : Analyst/Programmer

Period : Jun2011 to Feb2012

Summary of Duties

. Develop COBOL programs to extract insurance data from a non-DB2 legacy

application for loading into DB2 tables

. Generate DB2 table descriptive details using QMF

. Unit-test all developed programs

. Involvement in system testing activities: program migration, data

loads, tests

. Participate in daily stand up and status meetings

. Participate in data mapping activities with Business Analysts and

Technical Lead

. Develop SQL queries to retrieve data from DB2 tables

Products Used:

COBOL, DB2/SQL, JCL, File Manager for z/OS, CA-Endevor, Easytrieve-

Plus, CICS Explorer (Debug), JIRA

Organization : National Australia Bank (NAB), AD&T DLLIS, Account

Processing

555 Collins St, Melbourne 3000, Australia

Position : Sr. Analyst-Programmer

Period : July 2010 - Jan2011

Summary of Duties

. Provide Technical Solutions on (small) Projects and enhancements; e.g.

Loan Product Rationalisation, Connect-Direct conversion, Card number

validation enhancement and various Production Support solutions

o Create High Level Analysis including estimates

o Create Detailed Design Estimates

o Develop Detailed Technical Design Document

o Schedule and participate at own design walk-thru's

o Liaise with development and support team

o Provide consulting and mentoring during Build, Testing and

Implementation phases

o Consult with Business Analysts for design details and issues

o Liaise with Project management (delivery, business and technical

project managers)

Products Used:

COBOL, DB2, IMS, JCL, FILE-AID/MVS, ENDEVOR, INFOMAN, Easytrieve-Plus,

Connect-Direct, FTP, BMC, FILE-AID/DB2, Mercury Quality Centre (Test

Director), OPCA.

Organization : Suncorp - Business Technology

605 St. Kilda Rd, Melbourne 3004, Australia

Position : Software Engineer (Analyst-Programmer), Niche-

Protect (HUON)

Period : October2008 - July2010

Summary of Duties

. BT Commercial Insurance I2P, Conversion of in-house developed

insurance package to Protect-Huon, (Testing)

o Utilise DB2 SPUFI/SQL or BMC-DB2 utility to search for and

validate converted data

o Liaise with the Insure team - BA's and System teams based in

Brisbane, Liaise with the Protect team - System teams based in

Melbourne

o Build Test Cases for various commercial risk types based on

Story Lists (Agile Methodology) for conversion: building/fire,

miscellaneous property, burglary, money on premises, public

liability

o Develop Easytrieve JCL/jobs to search for test data on the

extract and load data files. also use of FILE-AID/MVS

o Perform manual System and Validation tests on the target

(Protect/Huon) mainframe

o Create/build test policies on the source (Suncorp/Insure) and

target mainframe systems,

o Create test cases and log test status and defects on the Mercury

Quality Centre (Test Director)

. APIA Sales Revitalisation project

o Development and enhancements on the Niche Protect system using

COBOL, DB2 SQL, CICS, JCL to support front-end sales

o Enhance existing CICS screens

o Liaise and coordinate with external printing provider on test

runs

o Participate at daily stand-up meetings (Agile methodology)

. Commercial Insurance (Vero) Pricing for Motor

o Development and enhancements on the CI - Niche Protect system

using COBOL, DB2 SQL, CICS, JCL, and Web Services to retrieve

insurance prices from third party pricing engine (GIPE)

o Develop new subroutines to send pricing requests thru Web

Services / XML

o Develop new subroutines to receive pricing values thru Web

Services / XML

o Enhance CICS screens

o Liaise with project members located remotely (Sydney)

o Participate at daily stand-up meetings (Agile methodology)

o Participate at Iteration start and close sessions (Agile life

cycle stages)

Products Used:

COBOL, DB2, CICS, JCL, FILE-AID, ENDEVOR, INFOMAN, Easytrieve-Plus,

Connect-Direct, FTP, BMC, Mercury Quality Centre (Test Director),

Agile Methodology, Web Services / XML, JIRA

Organization : National Australia Bank, Accounts Processing - Core

Systems, Technology - BA

555 Collins St, Melbourne 3000, Australia

Position : Analyst-Programmer

Period : July2007 to October2008

Summary of Duties

. Decision Tools-DZ Credit Rating/Scoring project: Perform program

enhancements and changes for Credit Rating/Scoring - BASEL II RRA

Enhancement for Decision Tools DZ:

o Develop and enhance programs with embedded DB2 SQL

o Liaise with Retail Credit Australia (business users) and

external third party Experian for User Testing

o Liaise with Data Warehouse/other systems groups and business

users for End To End Testing

o Help migrate changes to various test environments using ENDEVOR

o Create WOPA (whole of project artefact - management summary)

o Coordinate change implementations according to tight deadlines

o Create INFOMAN Change record

o Participate in System and User Testing

. Customer Accounts - CAMS Lending Mortgage Insurance (LMI2) project:

o Perform program enhancements and changes with embedded DB2 SQL

o Create Program Specs and Unit Test Plan documents on MS Word

o Perform Unit Testing and produce Unit Test results documents

including interrogation of DB2 databases using SQL

o Conduct Peer review/QA activities: program code walkthru,

documentation and test results

o Participate and support System Testing, log defects and test

status into Mercury Quality Centre

o Help coordinate change migration using ENDEVOR

o Provide help and support during installation phases: components

check, OPCA Scheduling audit including off-hours support

. Compac (PU Account Packaging), a subsystem of CAMS:

o Help review Detailed Design

o Create Program Specs (including DB2 SQL interrogation) based on

Detailed Design

o Oversee program construction and mentoring of external

programmers

o Conduct review/QA activities: program code, documentation, test

results

. CAMS Support team:

o Incident records investigation and resolution

o Perform business users request tasks (BOSS/BEST): respond to

queries by interrogation of DB2 databases, draw reports using

SQL, prepare and submit special batch jobs

o Involved in pre-implementation tests

o Create and implement program changes thru INFOMAN Change records

Products Used:

COBOL, DB2, IMS, JCL, ENDEVOR, INFOMAN, Easytrieve-Plus, Connect-

Direct, FTP, BMC, FILE-AID/DB2, FILE-AID/MVS, Mercury Quality Centre

(Test Director), OPCA.

Organization : ACSC (Automobile Club of Southern California, an AAA

affiliate), USA

Position : Sr. Programmer- Analyst. HUON Underwriting Team

Period : May2004 to Mar2007

Summary of Duties

. Program development and enhancement of HUON Screens (SDFII) and other

components/modules using COBOL, CICS, DB2/SQL

. Develop simplified program solutions to problems in complex and

highly integrated insurance application

. Help enhance and update Business rules tables: Business Manager Tables

(BMT), Literal Expansion Tables (LXT), Validation rules (Valrules)

. Leading role in Change Control activities using CHANGEMAN: audit

reporting, build retrofit list, create re-compile list and perform

promotes to higher test regions

. Coordinate external interface loads from third party providers for

Motor Vehicle and Credit Score Ordering and during business testing of

interfaces with other systems

. Liaise with external systems and external third party providers: DMV

(Dept. Of Motor Vehicles) records, accident and violation records,

credit checks and others for vehicle model data/information

. Involvement in business functional tests: Quotes, New-Business,

Amends, Renewals

. Log problem resolution using the Huon PAR system

. Perform function tailoring: screen design, program development and

enhancement

. Unit testing for auto, home, and watercraft product lines for several

states

. Involvement in Servitised project for re-development of existing

systems

Provide System Test, User Test and installation support

Involvement in several development projects for insurance product

implementations: watercraft, excess insurance and various car insurance

projects for several states. ACSC provides insurance products for the

following states: CA, TX, NM, ME, VT, NH, HI, PA

Products Used:

COBOL, DB2, CICS, JCL, SDFII, FILE-AID, VSAM, Changeman, Expediter, Debug

(HUON is an integrated solution package for the general insurance industry

and used in Australia, UK, USA, South Africa and Canada).

Organization : Huon Corporation, now The Innovation Group plc,

Melbourne

Position : Technical Consultant (Analyst-Programmer)

Period : 2000 to 2001

Summary of Duties

. Development and enhancement on the Huon Solution: general insurance

system; vehicle, home and boat product lines. Huon is an online

integrated insurance application based in COBOL, CICS and DB2

. (Small) Team mentoring/leading and QA on Small to Medium Enterprise

Commercial (SME) packages development

. Huon function tailoring: screen design, program development and

enhancement, system testing, requirements analysis, write high level

design document

. Development for customisation of Payroll Deduction Manager-Australian

version, and Yasuda-Japan (in Melbourne)

. Client on-site work: CGU (02/00 - 05/00), NRMA (08/00 - 03/01)

including SGIO/SGIC integration

Products Used:

Endevor, Changeman, COBOL, DB2, CICS, Windows/NT, DB2/UDB for

Windows/NT, CICS for Windows/NT (IBM VisualAge CICS, COBOL), SPF/PRO

(ISPF/NT), SDFII (Screen Builder)

Other IT Experience (Summarised)

EDS Australia/Telstra Transformation Project, Melbourne, 2007, Technical

Analyst (Analyst-Programmer).

Program enhancements and changes for FLEXCAB, CDBOR screens, EMPTOR and

AXIS to CDBOR Interface modules within tight deadlines. Formulate Detailed

Technical design for EMPTOR and AXIS to CDBOR Interface modules.

Documentation task: modify Technical (Application) Specification/Detail

Design (TAD) based on Impact Assessment document, modify module

specification and description (T227,T235) based on TAD, helped modify RTM

(Requirements Traceability Matrix). Create B&A (Build & Acquire) Status

report. Perform Unit Testing: create test plan document using Word, perform

testing and produce Test Results document. Provide support for Application

Acceptance Testing. Conduct review/QA activities: program code,

documentation, test results. Set-up and coordinate DB2 Abend Testing for a

new module (major component). Provide Detailed Design and Program specs in

MS Word for offshore developers. Coordinate/review program development with

offshore developers.

Products - COBOL, DB2, IMS, JCL, FILE-AID, Telon, Endevor

HIC (Health Insurance Commission), Canberra, 2003-2004: Analyst-Programmer.

PBS (Pharmaceutical Benefits Scheme) Team,Development, enhancement and

support. Build new user reports and data extracts using SAS, DB2/SQL,

EasytrievePlus. Build new screens and programs using DELTA-COBOL, CICS. On-

call support and provide Production problem resolution. Products: MVS,

DELTA-COBOL, DB2/SQL, CICS, SAS, EasytrievePlus

Scottish Widows plc (a member of Lloyds TSB group), 2001-2003 Edinburgh EH2

4QD UK: IT Developer (Analyst-Programmer). HR conversion to TSB Group

suite: DB2, EasytrievePlus. FTP/Connect-Direct, JCL for data transfers, DB2

utilities-unload/load, image copies, recovery. SAP-OLAS interface: COBOL &

JCL changes. Project Green: IMS data extracts for Marketing campaign,

policy statements/forms printing, reformatting with EasytrievePlus.

Financial Framework: data transfer to Datawarehouse, DB2 programs,

JSP/MetaCobol, EasytrievePlus, FTP, DB2 table design for add of columns,

DB2 utilities-reorg & loads, JCL. Settlement reporting system: DB2 data

extracts and reformatting with EasytrievePlus. Technical analysis & design

of jobs and programs .Liaison with business users & operations support.

Products: COBOL (MetaCOBOL), JSP (Jackson Structured Programming),

DB2/COBOL, SPF/PRO (ISPF/NT), EasytrievePlus, JCL, Data Dictionary, Rules

Database, DB2 Utilities, FTP, Connect-Direct, IMS DB, FILE-AID.

EDS-USA (Systemhouse) CSAA Project, San Francisco, USA (AAA affiliate- car

insurers) 1998-99: Consultant Analyst/Programmer). Customer Profile

(datawarehouse), develop and modify extract programs, Unit and System

Testing and liaison. Documentation project: system documentation, program

documentation; functional descriptions, flowcharts, schedules and lists of

Jobs/Functions, programs, I/O, databases. Tasks include: analysis of

production schedules, interview of relevant application support team,

testing of online functions, and perform queries of DB2 system catalogues.

Products: COBOL, DB2, JCL, CICS, DB2, VSAM, IDEAL DBMS.

Ansett Airlines 1996-97 Senior Analyst, Decision Support System and Data

Warehouse Team: Data Modelling using IEF Composer, Design of Oracle

databases, Perform Analysis and Design of enhancements to MIS applications

with COBOL, DB2 SQL, Develop QMF/COBOL programs to retrieve flight data

from interfaced flight systems, Production Support of MIS applications.

Products used: COBOL, DB2, QMF, IMS, VSAM, MQ-Series, UNIX/Oracle, PL/SQL,

SQLPlus, FTP, FILE-AID. also Analyst-Programmer / Data Analyst, Aspire 2

Project - Legacy to SAP Data Conversion, Melbourne: Extract data for

loading into SAP system from legacy engineering applications using SAS, DB2

SQL. Build Extract scripts for DB2 and IMS data bases using SAS. Transform

data using MS/Access. Perform Requirement analysis, and formulate and

document Technical design for data extraction. Products used: SAS, JCL,

DB2, IMS, FILE-AID, COBOL, MS/Access, VSAM.

Coles Myer Corporate-ISPD/ Myer Grace Bros 1988-95.

Coles Myer Corporate-ISPD: Application Analyst (Analyst-Programmer) 1988-

93. Accounts Payable system (DB2,COBOLII,CICS); Lease Management system

(DB2,COBOLII,CICS); Asset Management system QSP-OLAS (IMS/DB, VS/COBOL,

CICS, Easytrieve-Plus), EFTPOS Settlement System (DB2,COBOLII,CICS); Re-

development of EFTPOS Settlement System (NAVIGATOR Methodology, ADW,

Microfocus-COBOL Workbench,), DBA role (1992). Perform Unit & System

Testing and User Testing Support. Perform analysis and design of

enhancements to Accounts Payable system. Has small team leading role on the

Lease Management system.

Myer Grace Bros.: Senior Analyst-Programmer 1993-95. MIS Systems, Stock

System (merchandising, product codes, item registration): Build user ad-hoc

reports from DB2 tables using SQL and QMF/ Perform program development,

enhancements, production support duties, unit & system testing, user

testing support. Products Used: DB2, IMS, CICS, COBOL, QMF, VSAM,

CHANGEMAN, Smartest, FILE-AID.

Contact this candidate