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