Service Project

Marlon R. Alfonso

Pasadena, CA

Cell No 626-***-****

**************@*****.***

Status : American Citizen

Technical Summary

1PowerBuilder V.5-V.12.5 (12 years’ experience), with 6 years PFC and PB native source

control and ProDiff for comparing objects in source control and local objects/files.

2Oracle PL/SQL (Stored Procedures, Triggers & Functions, Packages, Views/Materialized view, VPD, For All/Bulk Collect Object/Types/Collections, DBMS_SQL, DBMS_UTIL, RefCursors for Powerbuilder obtaining result sets from stored procedures, invoking Web Services from pl/sql, export/import/sqlloader), Oracle Enterprise Manager, SQLPlus, PL/SQL Developer, TOAD Browsing tools

3SQL (Sybase Transact-SQL) Stored Procedures and Triggers (Sybase Central & Aqua Data Studio)

4Informix with Stored Procedures and Triggers

5Background in Unix shell scripts, C, C++ and C# Programming Language

6Data Modeling using PowerDesigner, Sybase Central Utility, Wise Installer Packaging

7Other Programming Languages XBase (Clipper, Foxbase, Recital), Turbo Pascal

8Operating Systems (Windows, Windows NT/2000/XP, Linux and Unix (AIX)

9Microsoft Office (Word, Excel and PowerPoint)

10Knowledge in Local Area Networking and Wide Area Networking, VPN

11PC Anywhere for remote access and administration and Windows Remote Desktop

12IBM RS/6000 AIX and Personal Computers Windows, VMWare

Web Technologies Skills :

http://www.marlonalfonso.com:8080/shopping/shopping_login.jsp

13 Java/JEE (JSP, Servlet, EJB3, JPA, JDBC, JAX-WS/WebServices) with Oracle rdbms and User

Interface skills In HTML/CSS/Javascript/JQuery/AJAX Apache Tomcat 7 /Axis2/Glassfish4/Eclipse.

14 Background in Microsoft SQL Server 2012, ASP.Net/C#/IIS in developing shopping cart application

on these web technologies of Microsoft plus additional background skills in MVC and WCF/WebServices.

15 Working knowledge in XML and tools for consuming web services in tools such as Altova

XML Spy, SOAPUI and using Powerbuilder as Client (EasySoap or .NET) and using

Oracle PL/SQL UTL_HTTP to invoke web service

16 Background in Microsoft TFS/ClearCase/Visual SourceSafe/Serena Source Control

/ ChangeMgmt Software, Erwin

Work Experience (Highlights)

September 28, 2015 To December 15, 2016 (TCS->Meijer) in Grand Rapids, Michigan - Developer/Analyst (Powerbuilder/Sybase Transact-SQL)

- Tasked to work on a challenging project to create separate application of a certain modules of the existing 5 applications in distribution (product profile and product at location inquiry). The splitting of product profile and product at location inquiry modules from the 5 apps (Pre-Receiving, Receiving, Inventory Control, Physical Inventory and Audits application) would reduce testing efforts as its main objective when it’s de-coupled. The solution provided to break up and create a new separate application for Product Profile and Product at Location Inquiry is DDE (Dynamic Data Exchange) a messaging system of PowerBuilder capable of peer to peer data exchange/integration in windows. The separate new application Product Profile/Product At Location has a user interface capable to switch back focus directly from the calling external application (Pre-Receiving, Receiving, Inventory Control, Physical Inventory and Audits) and vice versa from these 5 calling apps. The enhanced user interface feature is to mimic the tight integration of the previous state and was implemented using external Win32 api function calls. This very challenging and difficult project is now running in production.

- Worked on another Quarantine project which involves a modification of the Inventory Control and Product Profile/Product At Location Inquiry front-end and back-end PB/Sybase DB stored procs. For this project I provided analysis and solutions to modify certain areas that are required in the front-end such as modification of existing logic in Inventory Adjustment screens and back-end changes such as create new stored procedure and modify existing related to configuration setup to certain DFs. Delivered LLD, Test Cases and performed coding/unit testing base on design document/requirement.

- Has also worked on 3 additional projects on different DFs for Convey Trayable, Witron Scan Pallet and Store Sequencing which required changes both in front-end PB and back-end Stored Procedures as well as writing required documentations.

With these aforementioned projects that I have worked and involve, it is essential to have Powerbuilder, Sybase Transact-SQL expertise and Unix skills to be able to provide right solutions and grasp complex processes. Nevertheless, good communications and interpersonal skills are also required to effectively work successfully on this project either independently and in a team environment.

- Has also been tasked for Production Support (PB/Sybase RDBMS) on Shipping Application involving modifying changes in PB front-end and long running process Stored Procedure in the resolve shipping discrepancy (rsd) functionality. Also worked production support enhancement of Audit application for the packing list/courier linking issue of un-save transaction due to system timeouts which results to billing issue. The latter enhancement implements a solution to modify PB front-end code and back-end stored procedures changes.

Utilized Tools in Meijer

-Powerbuilder 12.5 Classic with PFC, 90% 2 tier and mixed with some integration with other Systems

-Aqua Data Studio and Sybase Central for accessing database servers in SAP Sybase 15.5

-Microsoft Visual Studio for TFS source control

-Putty for accessing Unix/AIX environment and view shell script and execute SAP Sybase isql/bcp

Note: PB apps are running and deployed in Citrix/XenApp environment.

January 2012 To Present (Web Developer)

http://www.marlonalfonso.com:8080/shopping/shopping_login.jsp

-Infrastructure/Architecture built on MVC using Tomcat 5.5/Oracle 11g/10g Java and JEE (JSP/Servlet/JDBC)/html/css/javascript )

-Has also developed shopping cart application base on SQL Server 2012, ASP.Net/C#/IIS Microsoft technologies.

January 7, 2013 To February 27, 2015 (26 months Powerbuilder Developer / Analyst ) – Bank Of America (Newark, Delaware) through Axelon Services

Completed working in a long term project for their entire credit card core platform modernization (C3PM) of BofA hiring new Third Party vendor TSYS as the banks credit card processor. Have been assigned to implement changes in one of their existing complex SuperStation, a powerbuilder/pfc application called Customer Leads Management System (CLMS ) built and designed on sophisticated distributed / multi-tier architecture. The application communicates with different types of middle-tier components such as Tuxedo MiddleWare and Web Services via its proprietary OCX/OLE.

Summary of Activites Performed

- Review and Analysis of the requirements and high level design on the Initial phase

- Provide Low Level detail design solution document in support of the business requirements and high

level design document for a functional enhancement of Account Information. It’s a huge task that

involves converting Tuxedo Service calls to a Web Service call and requires essential knowledge and full

understanding of the complex application architecture built on multi-tier / distributed environment as

well as functional areas of CLMS application to provide solution.

- Mapping document for fields of current (tuxedo) versus future change (web service).

- Writing codes to implement changes base on design specification.

- Unit, Integration Testing and fixing defects in various phases during Development, UAT and Production.

- Resolve issues on their Proxy Generator.

- Coordinate with different service owners to resolve issues.

- Introduced SOAPUI to CLMS powerbuilder development team as well as other teams for consuming

Web Service and provide orientation (teaching) on how to use the tool.

- The overall challenge is converting/rewriting those very complex processes of Tuxedo Service calls to a Web

Service. Additionally, has created a function/routine that enables a very long text/description to be wrap

or transform it in paragraph that is left justified on a flexible desired width.

Worked on Various Functional Areas of CLMS Application

- Account Information

- Verification Information

- Strategy (Rules Engine)

- Standard Rate Change (SRC)

- Balance Transfers

- Promotions / BT Offers / CreateOffers

- Disclosure

- Comments

- Various Web Windows/Screens (BofAs proprietary way to integrate with Web Applications)

Tools and Skills Utilized on this Project

- Powerbuilder 12.5 with PFC, OCX

- Powerbuilder Native for Source Control

- ProDiff for Objects Comparison

- SOAPUI for Web Service Testing

- HP Application LifeCycle Management (ALM) for entering defect tracking and Test Scripts

- VBScript / HTML / HTA for the complex application launcher

Conclusion : The Credit Card Core Platform Modernizaation (C3PM) project of TSYS was a success that goes in to Production mid February 2015. I'm Currently a team member in the maintenanance / support of complex CLMS application in Production.

July 9 2012 To November 12 2012 (Powerbuilder Developer V.9 with Oracle PL/SQL) – Kinetics Concept Inc (KCI) – Medical Company / Arc-Intel –San Antonio, Texas

Worked on a short term projects for the enhancement of their huge and complex applications HERO (Order System) and GENESIS (Fulfillment System) built on Powerbuilder PFC base and Oracle 10g. Role involves creating Technical Design Document base on functional design/requirements. Perform coding/development/unit-testing base on technical design. Creating test plan is also part of the task of the projects. Collaborate with BA's and other developers to formulate the right solution for every project. Here are the details of the 3 projects :

–Enhancement of their GENESIS application – AHS Goes To Market which involves changing existing business rules for deliveries via UPS in the front-end as well as back-end (Packages/Stored Procedures). Creating new package for interfacing Web Service call for UPS-Best Delivery Options. The package has features for parsing and and building XML dynamically the payload envelope using DBMS_LOB, Arrays, Object Types, Cursors. DBMS_HTTP has been utilized for the Web Service call.

–Worked on another project JetStream Paging System, an enhancement of their HERO application which involves changing Messaging and Order Query Screens in the front-end which contains Customer Service Representative teams (CSR) and Territory Manager information job titles. This project also involved changes on the back-end side such as stored procedures.

– KCI has embarked a new feature in their system, Electronic Signature engaging DocuSign, a third party provider for Electronic Signature that utilizes Web Service for interfacing KCI requirements. My major task involves creating TDD, Coding/Development in Powerbuilder and Oracle Triggers/Stored Procedures creating new Packages, Unit Testing and Creating Test Plans. Programming involves changes in the HERO application (Order System) to accommodate new field information related to the Electronic Signatures such as Ordering Physicians Email Address. Created new Package which will serve as middle tier for HERO (PB app) and KCI Express (Web base app) for accepting request information for Electronic Signatures. The new package also include features for invoking Web Service using DBMS_HTTP.

Nov 2011 To April 30, 2012 (Senior Powerbuilder Developer V.9 with C / Analyst) – IBM / Express Scripts, Inc -- Bloomington, Minnesota

- Has been the Technical Lead in working with a project for the DrugAdmin application (Medicare - Short Cycle Fill) built on a three (3) tier architecture on Powerbuilder 9/PFC, C-Middleware (Nxtera. As the lead for the project, I was responsible on creating High Level and Detail Designs for the Powerbuilder and C part. It is imperative that full knowledge of SDLC and good communication skills are required. Furthermore, skills in C programming language, Unix as well as expertise on how Powerbuilder communicates with the C-MiddleWare. One of the major tasks and activity in the design is developing a system prototype which are the basis for the mock-ups as well as presents the whole picture of what the system would look like base on requirements.

- Involved in another project for the Benefits Administration (BenAdmin) application built on a 3 tier architecture on PB / C for their (MA Blue Cross Blue Shield - Enhance Home Delivery project). My role for this project is performing bug-fixes (troubleshooting) and unit testing reported bug by QA team as a result of their regression testing.

- Worked on production issues for their DrugAdmin application in troubleshooting and provide fixes/solutions for the bug in PB front-end. Perform unit testing and create test scripts as well as test results.

- It is imperative to possess good interpersonal and communication skills to be successful in working with the two (2) aforementioned projects.

June 2011 To October 2011 (Senior Powerbuilder V.8/Oracle PL SQL Developer/Analyst) – U.S. Department Of Health and Human Services (Program Support Center) / Intellizant LLC – Rockville, Maryland

- Worked on a project in enhancing their core application named PRICES particularly on its Invoicing Entry Module. The objective of enhancement is to streamline dataflow in sending data (IPAC flat file) to external system in the Department Of Treasury and its own UFMS (Financial Management System). The project task involves in-depth analysis on the existing application of the front-end powerbuilder and the back-end Oracle PL SQL codes with a minimal documentation is provided. Create design document (functional and technical) base on requirements. Perform reverse engineer using CA ERwin for an existing database to obtain design model and entity relationship of undocumented database. Perform coding/development in Powerbuilder front-end user interface enhancement and modification of the INVOICING entry module by adding new fields, change layout designs, placing validation base on business rules in the design specification. Also performing modification and refactoring on the complex PL SQL stored procedures, packages for the loading batch process as well as stored procedures that process IPAC file (flat files exported) for Treasury and UFMS AR base on design specification. Created and modify existing complex ad hoc SQL queries (statistical reports such as revenue by cost centers, revenue by customers) requested by client. Develop Test Plans, test scripts and deployment plan. The project demands a high level of expertise in Powerbuilder and PL/SQL since PRICES Application is design and built on complexity. Performed migration/upgrading of PRICES application from Powerbuilder 8 to Powerbuilder 12 and identified/resolved issues in the migration particularly on ActiveX/OCX on Formula One Excel. Can work independently as well as on a team environment.

July 2010 To June 2011 (Powerbuilder V.12/Oracle PL/SQL/Sybase Developer) – Wells Fargo Capital Markets/Mortgage (SMS Department) Frederick, Maryland

- Has been involved in the Database Migration Project Sybase-To-Oracle which demands expertise in Powerbuilder and PFC for the conversion of their big and complex front-end Secondary Marketing System Application (SMS) from Sybase to Oracle. Converting Datawindows to work in Oracle as well as embedded SQL within Powerscript. Doing bug-fixes, enhancements on their front-end SMS application on issues in multi-table datawindow, multi-user/concurrent datawindow update issues and so many very hard and difficult to accomplish tasks and issues in a production environment.

- Has been given a tough challenging task in resolving major issues in Oracle Triggers (Mutating Issues) and was able to wrestle and resolve it through redesign of triggers by creating oracle packages, adding after statement level trigger on the existing before each row level trigger. Perform enhancements on triggers to support BULK DML OPERATIONS through the use of collections and nested table.

- Doing bug fixes and enhancements on Oracle Triggers and Stored Procedure. Also tasked for performance tuning in stored procedures by reengineering some of the repeated process of the export by introducing sql pivot capabilities of oracle which will shorten the process.

- Successful on the task to research on Powerbuilder Document Object Model (PBDOM) for the export project on MISMO XML for Fannie Mae and Freddie Mac.

- Delivered the most challenging task to create a stored procedure that will a pivot a complex report and eventually to be invoked in a datawindow. Additionally, create a stored procedure that will create a dynamic temporary table base on unknown columns, populate the temporary table with data using dynamic SQL or Oracle DMBS_SQL package and eventually call the stored procedure in powerbuilder to formulate SQL syntax for the dynamic table created by the stored procedure that is finally being combined by another complex SQL syntax to become the dataobject for the dynamically created datawindow on the fly.

Aug 21, 2009 To March 31, 2010 (Powerbuilder Developer Ver 11.5 against Informix database– Colorado Department of Corrections) Colorado Springs, CO

- Tasked for maintenance, enhancements and technical support of their many complex integrated applications built in PFC and native on their existing applications such as Parole Board, Case Management Tracking System, Time and Release, Admission Data Summary System, Financial Reporting System and Grievance Tracking System. Created documentations for User Document Requirements, Technical Requirements and system flow diagrams for new systems development projects. Perform programming for the enhancements of the aforementioned applications assigned from various technical leads. Have been successful in all the projects assigned either on team base or individual. Good communication skills are imperative to successfully implement these projects. Powerbuilder 11.2 interfaced in a Microsoft Visual Source Safe and Informix RDBMS running under Solaries is the computing platform for all their powerbuilder applications. One of the complex and challenging task is creating a datawindow report base on composite and nested.

Oct 15, 2008 To Mar 31, 2009 (Powerbuilder Developer V 10.5 /Oracle PL-SQL – NY State Budget Dept / Keane) Albany, New York

-Tasked for maintenance and technical support for the complex application Integrated Budget System (IBS) of New York State built on a full blown object oriented using Powerbuilder V10.5 (PFC base)/Oracle10g. Performed analysis and programming to enhance some modules of the application which is built with Powerbuilder/PFC Framework.

-The major challenging task being undertaken during this period were investigating and modifying some of the complex SQL syntax on datawindow reports, creating NVO’s (or Custom Class) and new visual objects to enhance window user interface interaction, creating export facilities using excel OLEObject automation by reusing existing overloaded functions and creating new functions, and enhanced IBS application interface using some WIN32 external function calls (PB communicating outside application) to identify other window active applications running on the background and foreground. Create test plans for the task in preparation for acceptance test and perform check in/check out of objects and newly created objects in the source control code native of powerbuilder.

-Good interpersonal relationships and effective communication skill towards technical leads has been an imperative requirements to achieve overall success of this tasks.

Feb 12, 2008 To Aug 30, 2008 (Powerbuilder Programmer V6-10.5 / Sybase/Oracle/Unix– Sony Electronics Corp) Park Ridge, New Jersey

-Tasked for migration projects of Sony’s upgrading of 10 applications in powerbuilder from PB version 6, 7, 8, 9 to be converted to PB version 11. These 10 applications are various non-pfc and pfc base with different backends running in Sybase 12.5 and Oracle 8i/10g. Worked with related unix scripts in analysis/modifications which are related to SAP and Oracle data feeds to applications integration. Packaged some of the migrated powerbuilder applications using wise installer software (with scripting) packaging for ease, faster and convenient application deployment.

-Trace and analyze Powerbuilder Codes on how logon process is implemented such as passing through different stages of security databases from user defined security database up to system or sybase owned database in resolving user logon issues.

-Create documentation and process flowcharts for all powerbuilder applications on the login process flow on how security is implemented for each application.

-Implement modifications/bug fixes on the front-end powerbuilder application for features that are not applicable to the backend from oracle version 7 to higher versions in oracle 8i/10g.

-Trace and analyze Unix Scripts to perform modification related to migration/upgrading of/or moving to another physical server for the unix job to run on different server.

-Performed test run for all the migrated powerbuilder applications, unix scripts and wise installer software package before deployment to production.

-Make documentation/users guide on how to create packaging of applications in wise installation software for all the powerbuilder wise full build created.

.

June 2003 To October 2007 (Analyst Programmer (Powerbuilder V.9/Sybase 12.5)– Talisay City Government - Philippines)

Overview of Projects Fully Developed

- Real Property Tax Management System (RPTMS) – is the main core business revenue generation of talisay city government located in Cebu Philippines. This operation is handled and managed by the assessors department. The main purpose and objective of developing and automating RPTMS is to capture all document information in tax declarations and field appraisal and assessment data of all real properties of the city to achieve an efficient, faster retrieval of information of every tax payers such as printing of tax declarations form, tax assessment form and its tax collectibles. This system improves the city’s tax collection drive since it can generate periodically timely reports on tax collection bill for every tax payer in the treasury department. The system helps identify all delinquent tax payers and notify them with their unpaid tax obligations.

- Business Tax and Licensing Management System (BTLMS) - this is another core business revenue generating of the city and is managed and handled by its treasury department. Its main purpose and objective of the developing the automated system is capturing all information on all business name establishments within the city to improve business tax collection. The system maintains a tax ledger for every business establishments so that statement of account of collectibles will be automatically generated every year renewal of mayors/business permit. The system has a way of knowing and identifying delinquent business establishments and notifies for their unpaid tax obligations.

Overall Tasks Performed

- Full systems development life cycle from analysis and design which gathers user requirements, database design, development (programming/testing), implementation (training of users/data capturing/testing/fine tuning)

- During the business analysis design stage, I perform extensive and comprehensive interviews on the domain user to gather functional specifications.

- I use Sybase PowerDesigner tool in database and table design and analysis

- PowerBuilder v.9 and Sybase 12.5 Adaptive Server Enterprise computing environment/platform is the technology being used and recommended by the analyst/programmer contractor because of its robustness, stability, cross platform and open standard architecture.

- In addition to the entire systems development tasks, computing platform preparation was also perform such as application deployment to PCs, Windows 2000 Server installation and configuration, Sybase Installation and Database Server Configuration and Database Connectivity to all PCs with powerbuilder deployed applications. These tasks mentioned are coordinated with the city’s networking LAN engineer.

- Perform technical support during production of the entire applications in the area of application revision and fine tuning, database administration, training of additional users.

2003 Jan – May 2003 (Innocom Telecom – Oakland, CA) – Analyst Programmer (Powerbuilder 7/Sybase 12.5)

- Hired for 4 months as a freelance developer by a telecom company to develop their own in-house telecom billing system to replace a costly billing service provided by application service provider. My experience in telecom billing system was reused in this company. Created an application that is capable of background processing (unattended processing simulated like a unix job). The background processing inserts an average of thirty thousand rows (30k-50k) in one process per day which totals an average of 30 million rows in 6 months. The telecom billing system parses (read) text file from a telecom switch and dump it to Sybase database in order to extract reports on time usage for every customer. Successfully implemented the system and help save the company from a recurring cost charged from the application service provider. The billing system was developed on powerbuilder 7 (front-end) and sybase 12 rdbms (back-end) platform. In this project, I perform the task of analyst programmer; do the implementation and training of user, deployment of applications to workstations and set-up/configure Sybase ASE to windows 2000 server. The system was later implemented and deployed in their Hong Kong operations remotely through the use of PC Anywhere.

March 2001 To Jan 2003 (Analyst Programmer (Powerbuilder V9/Sybase 12.5) – Trans Asia Shipping Lines, Inc. - Philippines)

- This is my first project as a freelance programmer. I was hired to redo the entire system of the company’s frontline operations in issuing online passenger tickets across the country. After I have successfully implemented this project, Trans Asia has given me another project to re-develop their accounting or financial system that will fully integrate the frontline ticketing operations. These projects have been fully developed in Powerbuilder 7 and Sybase 12 using Windows 2000 Server operating system. The following are the names of projects I have contracted and have performed a full development cycle of the following projects :

a. Passenger Ticketing System (setup on LAN/WAN)

b. Financial System (GL/AR/AP)

2001 January - February 2001 (Eagle Bell Telecom – Downtown Los Angeles)

- I was hired for 2 months as a freelance developer by a telecom company to develop their own in-house telecom billing system to replace a costly billing service provided by application service provider. The telecom billing system parses (read) text file from a telecom switch and dump it (convert and write) to SQL database in order to extract reports on time usage for every customer. Successfully implemented the system and help save the company from a recurring cost charged from the application service provider. The billing system was developed on powerbuilder 7 (front-end) and sybase 12 rdbms (back-end) platform. In this project, I perform the task of analyst programmer; do the implementation and training of user, deployment of applications to workstations and set-up/configure Sybase ASE to windows 2000 server.

1989-2001 Analyst/Programmer (Clipper\Foxbase\Recital &Unix\Powerbuilder\Sybase 12- FastCargo Logistics Corp. (Philippines)

- Responsible in the overall conceptualization, system analysis and design in all applications that have been developed. Provide technical support in all applications including hardware/software maintenance. Recommend in choosing the right hardware and software technology platform to use to fit in the right application software.

- Developed Cargo Tracking System to monitor customer package/parcel/container from the time it receive from origin up to the time it is delivered in the destination. This application had improved customer service and satisfaction as well as provides efficiency and reduces cost on operation. This application developed under recital programming language (originally from clipper code base) running on Unix/AIX IBM R/S 6000 computing platform. This was later converted to a client/server technology using powerbuilder 7 and sybase12 to be fully integrate in the company’s financial system.

- Developed Financial Information System (General Ledger, Accounts Receivable and Accounts Payable System) to provide timely financial reports such as balance sheet, income statement and cash flow for the month and year to date results. This financial system was built on PowerBuilder 7 (front-end) and Sybase 12 (back- end) computing platform.

- Team Lead in the software development of Warehouse Management System. This application was created to provide inventory control to the company’s warehousing customer as an added value services of their warehouses and warehouse facilities.

- Coordinate with assistant programmers in all system development projects. This covers distributing tasks, impose timelines so that all project will be delivered on time.

EDUCATIONAL BACKGROUND

1Graduated Associate in Marine Engineering

Cebu Central Colleges (1984-1986)

Cebu City, Philippines

2Graduated High School

Don Bosco Technical High School 1979-1984

Cebu City, Philippines

Contact this candidate