LEAH MARIE TABERNILLA REFUERZO

RPG DEVELOPER

Summary

Over 20 years of IT experience in all phases of software project development life cycle (SDLC) technical expertise in iSeries/AS400.

Experience in multiple projects with onsite/offshore model.

Experience in creating Functional Specifications with Business Analysis, Architecture Design – together with high level design (Outline Design) and low level design (technical design), Development, Implementation, Integration, Documentation, Testing, Deployment, Builds, Customer Interaction, Configuration and Code Management, Production / Customer Support, Maintenance, Enhancements and Quality Control

Strong experience in Development in iSeries/AS400 with languages including RPG 400/ RPG IV, RPG ILE, RPG Free, CL 400 (CLP), CLLE, DDS, Display Files, Sub-file programming, Embedded SQL programming, OPNQRYF and QRY 400. Skilled in Batch and Interactive programming and triggers/constraints.

Knowledgeable with Service programs, Procedures, Modules, Bound Programs and Binding Directories

Worked on AS400 to AS400 interfaces as well as AS400 to SQL Server.

Extensive experience with OS400, SQL, Stored Procedures and DB2 400.

Extensive experience in Client Access, i-Series Navigator, FTP, MQ series application, DBU, PFE, SDA and IFS data migration.

Experience in using MKS Implementer, Hawkeye, for source control and version control.

Experience in Robot schedule of jobs

Managed numerous projects from end to end ensuring that all requirements are met without conflict with each other

Managed resources – designers, programmers, and testers - providing technical direction for development projects

Technical Skills

RPG 400/ RPG IV, RPG ILE, RPG Free, CL 400 (CLP), CLLE, DDS, Display Files, Sub-file programming, Embedded SQL programming, OPNQRYF and QRY 400

Service programs, Procedures, Modules, Bound Programs and Binding Directories

AS400 to AS400 interfaces as well as AS400 to SQL Server.

OS400, SQL, Stored Procedures and DB2 400

Client Access, i-Series Navigator, FTP, MQ series application, DBU, PFE, SDA and IFS data migration

MKS Implementer, Hawkeye

Robot Scheduler

Professional Experience

Pointwest Technologies Corporation (PTC) http://pointwest.com.ph/

Roles: RPG Developer

Duration: August 2014 to present

Responsibilities:

RPG Developer to support needs of client, Prime Therapeutics

Enhance Surround Code for Prior Authorizations as per client’s specifications using embedded SQL, Sequel ViewPoint, Robot Jobs, MKS, DBU, PFE, Hawkeye etc.

Perform regular Mod changes for Prior Authorizations

Conduct requests and tasks related to Prior Authorization, i.e. Move/Copy Members, PA Extract, create reports, etc.

Member of the formed Run Team, participating in on-call rotation support for different

applications to provide immediate solutions with fast turnarounds.

Able to use MKS, ServiceNOW, HawkEYE, System iNavigator, Sequel Viewpoint, etc.

Worked on RxCLAIM and the different applications i.e. Eligibility, Prior Authorizations, MCEF/CEF, IPS, and RxClaim Adjudication process

ECoGlobal Consulting Inc

www.ecoglobalconsulting.com

Roles: Senior Consultant

Duration: September 2013 to March 2014

Responsibilities:

Pioneered in the “start up” company, contributing experiences in Development Customisation

Created documents and standards on Development Customisations

Analyse Funded Dev CARs for upgrade and create development options without Midas sources using externalization.

Familiarised with virtual office set up, web site creation, new products, etc.

Misys International Banking Systems

www.misys.com

Roles: Core Development – Release Design Lead

Duration: September 2010 to August 2012

Responsibilities:

Analyse business / functional requirements to produce appropriate design specifications and estimates to enable construction of the required software component(s) for Misys software products

Production of accurate, unambiguous functional specifications in own area of expertise, liaising with customers and/or business analysts as necessary, to ensure that requirements are clearly defined

Creation of accurate High Level Designs and Low Level Designs to be used by Construction, both Java and RPG as solutions to all requirements

Assist Resources throughout the life cycle of all projects, providing trainings, functional and technical overview of all projects involved in the release.

Conduct Technical Reviews of all related documents of all involved projects of the release, including Business Requirements Specifications, Functional Specifications, Estimates, High and Low Level Designs, Test Plans

Development of accurate unit test and/or system test plans and execution of appropriate level of testing to ensure that software components are delivered to a high quality first time

Construction and delivery of software components in order to deliver to the Misys product roadmap and/or customer commitments

Production of development documentation and deliverable data in line with Misys development standards in order that the software is onwardly maintainable

Participated in improving processes in the Development Cycle, particularly Estimate Creation, Design Documentation, Quality Assurance

Conduct Group Review of internal business requirements, functional specifications, high level and low level designs, unit and system test plans, and documentation ensuring that inputs from Project Manager, Business Analysts, Designers, Programmers, and Testers are accounted for.

Create Estimates for Design and Construction using Estimation Tool which is according to industry standards and is regularly calibrated to ensure accuracy.

Production of design documentation in accordance with company standards

Provide Functional and Technical Overview during Project kickoff and Lessons Learnt

Roles: Core Development – Lead Design

Duration: June 2005 – September 2010

Responsibilities:

Conduct Group Review of internal business requirements, functional specifications, high level and low level designs, unit and system test plans, and documentation ensuring that inputs from Project Manager, Business Analysts, Designers, Programmers, and Testers are accounted for.

Create Estimates for Design and Construction using Estimation Tool which is according to industry standards and is regularly calibrated to ensure accuracy.

Production of design documentation in accordance with company standards

Provide Functional and Technical Overview during Project kickoff

Roles: Funded Development – Technical Lead

Duration: June 2003 – June 2005

Responsibilities:

Review and acceptance of externally produced business requirements and functional specifications to ensure completeness of inputs for design phase

Production of design documentation in accordance with company standards

Construction and delivery of software components for the product

Development of test plans and conditions

Assistance with technical and/or functional issues to improve the individual’s knowledge and understanding of the system

Roles: Core Development – Team Leader, DPS5

Duration: April 2001 – May 2003

Responsibilities:

Lead a team within Core Development, providing technical leadership in design, construction and delivery of Software Development Projects

Roles: Core Development – Team Leader, DPS4

Duration: April 1999 – March 2001

Responsibilities:

Lead a team within Core Development, providing technical leadership in design, construction and delivery of Software Development Projects

Roles: Core Development – Analyst/Programmer

Duration: March1998 – March 1999

Responsibilities:

Analyse and understand business requirements in order to design / construct the required software component(s)

Roles: Core Development – Junior Programmer

Duration: February 1997 – February 1998

Responsibilities:

Construction and delivery of software components for the product

Roles: Trainee Programmer

Duration: May 1996 – January 1997

Responsibilities:

Undergo training for AS400, under IBM

POINTWEST TECHNOLOGIES CORP. US

Roles: Software Engineer 5

Duration: March 2015 – present

POINTWEST INNOVATIONS CORPORATION

Roles: Software Engineer 5

Duration: August 2014 – February 2015

ECo GLOBAL CONSULTING

Roles: Senior Consultant

Duration: September 2013 –March 2014

Misys INTERNATIONAL BANKING SYSTEMS

Roles: Junior Programmer/Programmer/Analyst/Team Leader/Technical Lead/Lead Design/Senior Consultant/Release Design Lead

Duration: May 1996 – August 2012

Offshore Assignments

Off-shore assignment to Minnesota, USA Oct 2014 – present

RPG Developer to support needs of client, Prime Therapeutics

Off-shore assignment to HCL, India Jun 2008 – Jun 2008

Provide assistance to designers and programmers to outsourced resources for German Features

Conducted trainings to Core Coding Standards and Standards to Core Incorporation

Off-shore assignment to London Branch Apr 2008 – Jun 2008

Requirements Gathering for German Features

Review of Business and Functional Requirements Specifications and High Level Designs

Attended Project Overviews from Business Analysts which and participated in meetings to determine which are to be incorporated into core

Off-shore assignment to London Branch Oct 2007 – Nov 2007

Requirements Gathering for Teller API

Off-shore assignment to Singapore Branch Jan 2006 – Apr 2006

Provide support for Singapore clients when necessary

Install developed software in clients’ system

Directly liaise with clients to establish requirements, ballparks, and estimates

Off-shore assignment to London Branch Jan 2001 – Feb 2001

Deliver and re-test developed projects to be incorporated into Core.

Off-shore assignment to London Branch Nov 1998– Aug 1999

Maintain project control documentation, specification changes and user documents for Syndicated Lending Enhancements, coordinating issues between Manila, New York, and Wimbledon, finalizing fixes for delivery

Involved in the development of numerous projects

Technical Trainings and Seminars

Structured Systems Analysis Design and Development, SSADD July 2006

Basic Banking Systems May 1996

AS/400-OS/400 Functions and Operations, RPG/400 May 1996 Programing, CL/400 Programming by MKI

Awards Received

Local Hero Award Sep 2011

Outstanding Award Apr 2011

Educational Background

June 1991 - March 1996

Mapua Institute of Technology (MIT)

Manila, Philippines

Contact this candidate