ARTEMIO V. SARROL JR.
**** * ***** **, ******** Park, KS. 66212
email: abj82s@r.postjobfree.com
SUMMARY
U.S. citizen with over ten years experience utilizing SQL, DB2, PL/SQL, MS
SQL, PowerBuilder 4.x, 5.x, 6.x, 8.x, 9.x, 10.x and COBOL. Demonstrate
competency in all programming phases: analysis, design, development,
testing, and implementation. Perform analysis, fact-finding, and
consultation with others to identify and resolve production support issues.
Current experience includes full life cycle development and integration of
one or more applications into an enterprise system application. Perform
system analysis, requirement definition, and consultation with others to
identify the modifications required and estimate effort associated with
implementing new enhancements into an existing application. Support
projects from SDLC to Integration, System, and Regression Testing. Create
high-level designs and detailed program specifications that meet the
defined set of requirements for a given project. Code, test, and prepare
technical documentation for new system enhancements.
TECHNICAL SKILLS
Databases: Sybase 12.5, Oracle(Version 9i and 10g), DB2, MS SQL
Server, Informix
. Languages: PowerBuilder, PL/SQL, MicroFocus COBOL, COBOL II,
C, Pro*C, RPG II,
Smartstream, FOCUS, Easytrieve, Endeavor, PANVALET, PLI.
Operating Systems: Sun Solaris, UNIX System V, DOS, MVS/XASCMS, TSO, ISPF,
AIX, XENIX System
PROFESSIONAL EXPERIENCE
PowerBuilder/Maintenance Consultant (March 2010 - Present)
Consultant with Computing Technologies Inc assigned to DoD-USMC - Kansas
City, Mo
. Support Unit Diary Marine Integrated Personnel Systems (UDMIPS) PB
applications. Maintain PowerBuilder v10.5 application using Oracle 10.4g
as database. Perform all phases of SDLC: analysis, design, review,
development, testing, and implementation. Analyze and Trace root cause of
production problem and provide work around as temporary solution.
Created/Modified/updated PB objects (windows, structures, functions, user
objects). Use PVCS as the version control to check in/out programs and
objects.
PowerBuilder/Maintenance Consultant (December 2009 - March 2010)
Consultant with Princeton Information assigned to National Student
Clearinghouse - Herndon, VA
. Support Loan Reporting Activities application and other National Student
Clearinghouse PB applications.
Maintain PowerBuilder v8.0 application using INFORMIX as database.
Analyze and Trace root cause of production problem and provide work
around as temporary solution. Modified/updated PB objects (windows,
structures, functions, user objects, store procedure, triggers). Use
Microsoft Visual SourceSafe as the version control to check in/out
programs and objects. Uses Agile Mindset in day to day activities.
Programmer Analyst/Software Engineer (November 2008 - November 20, 2009)
Consultant with Computer Access assigned to USDA - Kansas City, MO
. Support Risk Management Agency users using Escrow, Reconciliation and
Ineligible Tracking System.
Maintain PowerBuilder v9.0 and MicroFocus Cobol application using
INFORMIX as database. Analyze and Trace root cause of production problem
and provide work around as temporary solution. Modified/updated PB
objects (windows, structures, functions, user objects, store procedure,
triggers). Use CM Synergy as the version control to check in/out programs
and objects.
Ensemble Software Developer (July 2007 - August 2008)
Consultant with Alliance Telecom Solutions assigned to AT&T - Hoffman
Estates, IL
. Provide development support for the AT&T-BellSouth merger effort. Provide
development expertise in Amdocs Ensemble platform for changes that
require rewrite. Provide MicroFocus Cobol coding and unit testing on
system application programs using ORACLE as database. Update store
procedures and triggers and embedded SQL on application. Review detail
designs, code and test results for both project work and production
support. Use CVS as the version control to check in/out programs and
objects. Use productive tools like Mercury Quality Center, Microsoft Live
Meeting, NetMeeting, FileNet P8/Workplace. Participate in rotation of off
hour's production support 24/7 on national/international Communication
Bridge. Analyze and Trace root cause of problem written in C, Pro*C,
PL/SQL, PowerBuilder 10.5 and COBOL.
Software Developer/Software Engineer (August 2006 - July 2007)
Consultant with Technology Partners assigned to Ameren United Energy - St.
Louis, MO
. Provide development assistance for EDTS project and integration with
EMPRV System. Create interface programs in PowerBuilder 9.0 between TRIS
(payroll) and job maintenance systems using SYBASE and DB2 as database.
Analyze the project requirements prior to making modifications or updates
in the system using PowerBuilder 9.0. Modified/updated PB Objects
(windows, menus, structures, functions, user objects, store procedure,
triggers). Use PowerBuilder's version control to check in/out PB Object.
Programmer Analyst/Software Engineer (December 2005 - August 2006)
Consultant with TM Floyd assigned to TENNCARE - Nashville, TN
. Analyze the Windows or systems requirements prior to update or new
development using PowerBuilder 8.0.
Know the business reasons behind its processing logic prior to
modification and update. Support the PowerBuilder Window Users of the
TENNCARE Systems modified or created. Modified/updated PB Objects
(windows, menus, structures, functions, user objects, store procedure,
triggers). Use PowerBuilder's version control to check in/out PB Object.
Programmer Analyst/Software Engineer (March 2005 - July 2005)
Consultant with Innovative Systems Group assigned to US Cellular -
Bensenville, IL
. Create and maintain data patches in Oracle PL/SQL to resolve daily
problems encountered in customer acquisition retention system (CARES).
Update and maintain the code patches for the front end and back end of
customer acquisition retention system (CARES) using PowerBuilder 9.0, and
Oracle PL/SQL.
Programmer Analyst/Software Engineer (March 2004 - February 2005)
Consultant with Innovative Systems Group assigned to BCBS/Health Care
Service Corporation - Chicago, IL
. Analyze the program or systems requirements prior to program/systems
changes. Know the business reasons behind its processing logic prior to
modification and update. Create structured or modify the existing
MicroFocus COBOL programs to use DB2 files instead of flat files.
Maintain the DB2 programs created or modified in the system. Support the
production users of the DB2 systems modified or created. Work on
production tickets created by the user of the DB2 systems.
Programmer Analyst/Software Engineer (December 2000 - February 2004)
Consultant with Innovative Systems Group assigned to US Cellular - Chicago,
IL
. Analyze and trace the root cause of the problem from the tuxedo server
down to the tuxedo services, process layer function, and data layer
function of the Cares System (i.e. AMDOCS Ensemble). Provide data or code
solutions on the root cause of the daily problems encountered in customer
acquisition retention system (CARES). Create and maintain data patches in
Oracle PL/SQL to resolve daily problems encountered in CARES. Update and
maintain the code patches for the front end and back end of CARES using
PowerBuilder, Oracle PL/SQL, Pro*C and MicroFocus COBOL in the Ensemble
portion of CARES. Mentor and assist new programmers with their
PowerBuilder 6.5 challenges. Train new employees how to resolve CSM
issues related to BAN and CTN activities. Use AMDOCS version control in
checking in/out PB objects.
PowerBuilder Developer (June 2000-September 2000)
Consultant with TAC assigned to Sears Roebuck and Co. - Hoffman Estates, IL
. Modified MPI Core application (PowerBuilder 6.5) in order to access the
MPI pending databases relative to Sears Buyer / Vendor extranet systems.
Created new data windows to accommodate search pending items using PFC.
Modified basic item and item flag tab to accommodate pending new items.
Modified/updated PB Objects (windows, menus, structures, functions, user
objects, store procedure, triggers). Utilized MS SQL to query/verify
input and output data that has been added, changed and deleted on the
database by every module added, updated or deleted on the application
being developed. Utilized MS SQL to query/verify input and output data
used in testing single application, module or whole application. Use PVCS
as version control in checking in/out PB objects.
Programmer Analyst (December 1999-March 2000)
First Penn-Pacific life Insurance Co. - Hoffman Estates, IL
. Analyzed and maintained the new Business Software for Brokerage Division
using PowerBuilder 6 and MS-SQL.
Analyzed users' requests and converted them into specs for other
programmers. Utilized MS SQL to query/verify input and output data where
a data patch was applied, where an application/system code patch was
applied on every development stage/phase, on testing single application
and systems application. Utilized MS SQL to analyze and maintain data
used by business software for brokerage division. Added and updated
stored procedures and triggers using PFC. Supervised and delegated
workload to programmers. Mentored and assisted new programmers with their
challenges. Use PVCS as version control in checking in/out PB objects.
Programmer Analyst Consultant (March 1998-November 1999)
Ryerson TulI Inc. - Oakbrook, IL
. Performed in-depth analysis and maintained GEAC SmartStream-Client/Server
process using PowerBuilder, Sybase, and MS-SQL. Added and updated ad hoc
store procedures. Converted Scripts from PowerBuilder 4 to PowerBuilder
5. Converted and tested store procedures from Sybase SQL to MS SQL
Server. Participated in the SmartStream version upgrade and service pack
update and testing. Learned other programming languages to support the
client/server. Supported the daily/monthly Account Receivable Process.
Uses PowerBuilder's version control to check in/out PB Object
Sr. Programmer Analyst (October 1997-February 1998)
Consultant with Andersen Consulting assigned to ALLSTATE - Northbrook, IL
. Analyzed and maintained old and new developments on the system using
COBOL & PL1. Interrogated inquiries received and delegated the job to
fellow programmers. Acted as mentor to new COBOL programmers. Learned new
system operation and trained group members how to maintain it.
System Consultant / TBA Developer (October 1996 to September 1997)
Hewitt Associates - Lincolnshire, IL
. Analyzed and coded the various modules of the application using object
oriented concept. Learned and mastered the COBOL Object Oriented Language
macros used in application developments. Learned the function foundation
of the Enterprise Application. Taught newly hired TBA Base employees the
object-oriented concepts.
Programmer Analyst (October 1989-September 1996)
The Signature Group - Schaumburg, IL
. Support projects from SDLC to Integration, System, and Regression
Testing. Developed, maintained, troubleshoot and analyzed existing and
specified programs and applications written in COBOL for OS390 & VM and
MicroFocus COBOL. Performed helpdesk functions using INFORMIX and UNIX
scripting.
Programmer Analyst (April 1986-August 1989)
Pre Finish Metals Inc. - Elk Grove Village, IL
. Developed, troubleshot, converted, documented, analyzed, designed and
maintained in-house systems (Payroll, Sales, Inventory Tracking,
Production Control, and Quality Control System) written in RPG, COBOL,
and FOCUS. Supported the development of EDI. Provided technical support
to all PC users.
EDUCATION
Computer Learning Center-Chicago, IL
Computer Programming Course with Honors
MAPUA Institute of Technology-Manila, Philippines
Bachelor of Science degree in Management and Industrial Engineering