Rowena M. Guevara
IT Professional
* ********* ********** ** *** IBM mainframe and client server environments. Involved in
all phases of the development life cycle that included requirements gathering, detailed
analysis and design, development, unit, system, integration, and acceptance testing,
quality assurance, implementation, production support, and documentation.
2 Industry background includes Telecommunications, Freight Forwarding, Healthcare
Insurance, Book Services, State Government and Banking. Particularly adept at legacy
maintenance and support, conversions, migrations, acquisitions and functional testing.
3 An output oriented team player, very flexible and fast learning. Alert and congenial, easy
to work with.
TECHNICAL SKILLS
COBOL I & II, CICS, JCL, TSO/ISPF, IMS DB/DC, DB2, Oracle/SQL, VM/CMS, VSAM,
Easytrieve Plus, REXX/CLIST, XEDIT, Syncsort, Version Merger, Data Ager, Softfactory 2000,
SPF/PRO, FOCUS, Oracle 8i/9i, MS SQL Server, MS Access, VB, Toad, Mercury Test Director,
Expediter, SmartTest, InterTest, AbendAid, FileAid, SCLM, Panvalet, SPUFI, Platinum, MVS,
OS/390, FTP, NDM, MS Visio, MS Office.
PROFESSIONAL WORK EXPER I E NCE
NEXTSOURCE Aug 2008 – Feb 2009
PROGRAMMER / ANALYST
ODOT TAD MAINTENANCE
Provided maintenance support of ODOT’s Transportation Application Systems.
Responsible for the completion of assigned work requests from initiation to
implementation. Duties included research and analysis, revising and testing programs,
developing batch jobs and online DB2 programs, interacting with the users, implementing
changes through SCM process, participating in peer reviews, and providing input to
discussions on programming issues.
PACIFIC CREST TECHNOLOGY INC. May 2006 – Sept 2006
PROGRAMMER / ANALYST
BLACKWELL’S BOOK SERVICES 13-DIGIT ISBN PROJECT
Involved in the system enhancement of the Ordering System to recognize the new 13-
byte ISBN format. Duties included detailed analysis and design of the affected programs,
preparing program specifications, coding, testing, and implementing the changes.
MERIDIAN TECHNOLOGY GROUP Aug 2005 – Dec 2005
SENIOR SOFTWARE CONSULTANT
DHS MEDICARE MODERNIZATION ACT (MMA) PROJECT
Implemented MMA changes for MMIS (Medicaid Management Information System).
Duties included coordinating with users and clients to gather requirements and obtain
signoff, analyzing the system, developing online and batch programs, unit and system
testing, and documenting the changes.
PACIFIC CREST TECHNOLOGY INC. July 1998 – July 2005
PROGRAMMER / ANALYST / QA ANALYST
Key projects and achievements included:
CENTURYTEL LEGACY SUPPORT
Performed production and helpdesk support for the Service Order, Cash, Toll, Polling,
and Billing systems.
4 Prepared design specifications and ball park estimates, developed and revised
programs, performed unit, system, and user acceptance testing, investigated and
fixed problem tickets, and documented the system.
5 Developed the test bill process and trained team members.
CENTURYTEL SUNSETTING OF THE LEGACY SYSTEM
Performed extensive analysis of Polling, Toll, and Billing System to identify components
that will stay in Legacy system after conversion to Ensemble suite. Produced detailed
design of the proposed system.
CTE ENSEMBLE CUSTOMER SERVICE AND BILLING
Determined usage requirements and worked with test planning team to define and
validate requirements.
6 Provided usage data for testing and supported test execution team by reviewing test
results, researching errors, and resolving issues.
7 Developed processes to provide reporting and balancing of data results and created
an application to warehouse data.
8 Involved in four major releases. Performed test planning and execution for EMS
(Error Management System) that required developing test plans, creating test cases
and setting them up in Mercury Test Director, executing test steps. Supported
regression and user acceptance testing.
CTE VERIZON ACQUISITION
Analyzed and designed the conversion process for the Polling, Toll, and Billing systems,
coded programs, identified and set up new calling plans, performed unit, system, and
user acceptance testing, documented the test results and processes, implemented the
changes and provided production support.
OREGON PERS RIMS MODIFICATION
Analyzed the Benefit Calculation jobs and programs, prepared detail design
specifications, revised and unit tested modules, participated in code reviews, prepared
test cases, performed system testing and supported user acceptance testing.
FREIGHTLINER SERVICE LINK VERSION 3.4
Coded and tested changes for several APIs to standardize error handling and XML
response format.
MULTNOMAH COUNTY PAYROLL SYSTEM UPGRADE AND Y2K RENOVATION
Estimated revisions, analyzed and remediated Easytrieve and Cobol programs,
developed conversion programs for the data expansion, performed baseline and
regression testing, and documented remediation and testing results.
DMV Y2K REMEDIATION
Analyzed Driver’s system, reviewed inventories and annotation responses, remediated
the system by running Smart fix process and applying manual date fixes, conducted unit
testing, performed quality assurance.
FAR EAST BANK AND TRUST COMPANY Aug 1996 – Mar 1998
TEAM LEAD / ANALYST / PROGRAMMER
Maintained the entire credit card system as the bank converted to the CardPac system. Was the
primary on-call for any production failures.
9 Investigated and resolved issues, addressed user requests, delegated tasks to team
members, prepared program specifications, and provided status reports for each
subsystem.
10 Developed and revised conversion programs, maintained the base (model office),
performed unit and system testing, implemented the system in production, trained new
employees, and documented the system.
EDUCATION AND TRAINING
BSCS-IT De La Salle University 1995
11 Program Logic Formulation, Asia Pacific College 1996
12 Structured COBOL Programming, Asia Pacific College 1996
13 COBOL/CICS, Asia Pacific College 1996
14 MVS/JCL and VSAM, Far East Bank and Trust Co. 1997