Summary
Overview
Work History
Education
Skills
Languages
Key Responsibilities
Timeline
BusinessAnalyst

Esmeralda C. Galvez

Brampton,Canada

Summary

With over 20 years of experience in information technology, I have worked in diverse teams in both the private and public sectors. As a Consultant (Senior Programmer/Analyst), I have specialized in the Insurance/Finance, Provincial Government, and Tele-Communications industries. My expertise lies in the full software development lifecycle, including analysis, design, development, implementation, testing, and production support of various applications. Whether working independently or collaboratively, I consistently demonstrate exceptional efficiency and adaptability in delivering high-quality results.

Overview

29
29
years of professional experience

Work History

Computer Programmer Analyst

RSA Group
04.2006 - 09.2020

Engaged in multiple system enhancements for HUON-Insurance Package System.

Designed, maintained, and streamlined interfaces for multiple systems including GISA, Salesforce CRM, and BCAA.

Provided assistance with the HUON insurance package in a production support capacity.

Computer Programmer Analyst

Ministry of Community and Social Services
03.2000 - 04.2006

Contributed to enhancing service delivery models for Ontario Works and Disability Support Program. As well as the development of Service Delivery Model Technology (SDMT).

Created software solution for improved connectivity with National Child Benefit Support.

Senior Programmer Analyst

CGI
05.1998 - 02.2000

· Involved in the SF11 Project (OMS, Order Management System), release 1 – Migrate MFAS (VAX) to Network Activation Manager (UNIX) through MVS platform, and Release 2 – Pass Error Messages from OMS to Error Management System (EMS) and vice versa for Call Answer and Wireless Services. Defined MQSeries objects in MVS platform and set up the connections between MVS and UNIX platforms.

Contributed to the implementation of IPAIRS and new area code 647 in the 416 Overlay Project.

Senior Programmer Analyst

RSA Insurance
09.1991 - 05.1998

Participated in developing the Canadian and Royal Insurance Package System in the HUON project.

Mastered essentials of DB2 and SQL programming after comprehensive training.

Enhanced system functionality for both personal and commercial insurance sectors.

Coordinated with users to identify and meet their needs.

Compiled data into reports through OLQ and Easytrieve.

Completed training in IDMS, Easytrieve, and ADS/O.

Education

Computer Programming And System Analysis -

Cdi College
Mississauga, ON

Bachelor Of Science - Chemical Engineering

Mapua Institute Of Technology
Manila, Philippines

Skills

    Hardware:

    - IBM 9021-821

    - IBM 3390-500J

    Operating System:

    - MVS, OS/390

    Language:

    - CICS, Cobol II, Cobol, SQL, ADS/O, MQSeries,

    Database: - DB2, IDMS, IMS

    Software Tools:

    - DBVisualizer, ITSM, Lotus/Notes, SPUFI, JESM, ADSA, ADSalive, Changeman, DB File-aid, Debug, DMLO, Easytrieve Plus, file Manager, Expeditor, Flasher, IDD, Infoman, Intertest, ISPF, JCL JES2, OLQ, Panvalet, SCLM, SDF2, Smartest

    Applications: HUON (Insurance, Personal & Commercial), GuideWire,

    SDMT (Service Delivery Model Technology), Government (MCSS)

    Order Management System (OMS, Network Activation and Service Reply, TeleCommunications

    IPAIRS (Integrated Plant Assignment Inventory Records System, 416 Overlay), TeleCommunications

Languages

English
Full Professional

Key Responsibilities

· Follow the established company standards and software development life cycle procedures in application development.

· Extensive hands on experience on IBM Mainframe application programming with OS/ 390, MVS, ISPF, COBOL, DB2, CICS, IMS DB-DC, SAS, JCL, VSAM, Easytrieve Plus, File Aid, Xpeditor, Endeavor, JIRA, Remedy, IBM Utilities and CA-7 / Control M

· Assist in technical systems analysis and specifications for medium to high-complexity tasks to facilitate effective application design.

· Attending meetings with business client, stakeholders, DBA’s, architects and team to determine system functional requirements.

· Developed functional and technical documentation detailing enhancements and changes made to applications.

· Developed and unit test fully structured online and batch programs for the solutions of medium to high-complexity items according to programming specifications.

· Production and Post implementation support performing troubleshooting and correction of online and batch programs, Jobs and production control problems and coordinate all changes with impacted partners.

Timeline

Computer Programmer Analyst

RSA Group
04.2006 - 09.2020

Computer Programmer Analyst

Ministry of Community and Social Services
03.2000 - 04.2006

Senior Programmer Analyst

CGI
05.1998 - 02.2000

Senior Programmer Analyst

RSA Insurance
09.1991 - 05.1998

Computer Programming And System Analysis -

Cdi College

Bachelor Of Science - Chemical Engineering

Mapua Institute Of Technology
Esmeralda C. Galvez