SUMMARY:

• PowerBuilder 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.
• Oracle 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
• SQL (Sybase Transact-SQL) Stored Procedures and Triggers (Sybase Central & Aqua Data Studio)
• Informix with Stored Procedures and Triggers
• Background in Unix shell scripts, C, C++ and C# Programming Language
• Data Modeling using PowerDesigner, Sybase Central Utility, Wise Installer Packaging
• Other Programming Languages XBase (Clipper, Foxbase, Recital), Turbo Pascal
• Operating Systems (Windows, Windows NT/2000/XP, Linux and Unix (AIX)
• Microsoft Office (Word, Excel and PowerPoint)
• Knowledge in Local Area Networking and Wide Area Networking, VPN
• PC Anywhere for remote access and administration and Windows Remote Desktop
• Confidential RS/6000 AIX and Personal Computers Windows, VMWare

WEB TECHNOLOGIES SKILLS :

• 13 Java/JEE (JSP, Servlet, EJB3, JPA, JDBC, JAX - WS/WebServices/JMS/Spring/Hibernate) with Oracle rdbms and User
• Interface skills In HTML/CSS/Javascript/JQuery/AJAX Apache/Ant/Maven Tomcat7/Glassfish4/Eclipse.
• 14 Background in Microsoft SQL Server 2012, ASP.Net/C#/ADO.Net/Entity Framework/IIS in developing shopping cart application n 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):

Confidential, Grand Rapids, Michigan

Developer/Analyst (Powerbuilder/Sybase Transact-SQL)

Responsibilities:

• 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.
• 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

Web Developer

Confidential

Responsibilities:

• 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.
• Completed working in a long term project for their entire credit card core platform modernization (C3PM) of Confidential 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.
• 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 transform it in paragraph that is left justified on a flexible desired width.
• 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: 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

Powerbuilder Developer with Oracle PL/SQL

Confidential, San Antonio, Texas

Responsibilities:

• Enhancement of their Confidential application - Confidential Goes To Market which involves changing existing business rules for deliveries via Confidential in the front-end as well as back-end (Packages/Stored Procedures). Creating new package for interfacing Web Service call for Confidential -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.
• Confidential 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 Confidential 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 Confidential Express (Web base app) for accepting request information for Electronic Signatures. The new package also include features for invoking Web Service using DBMS HTTP.

Senior Powerbuilder Developer

Confidential, Bloomington, Minnesota

Responsibilities:

• 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- Confidential 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.
• 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.

Senior Powerbuilder V.8/Oracle PL SQL Developer/Analyst

Confidential, Rockville, Maryland

Responsibilities:

• 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 Confidential (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 Confidential 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.

Oracle PL/SQL/Sybase Developer

Confidential, Frederick, Maryland

Responsibilities:

• 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 Confidential and Confidential .
• 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.

Powerbuilder Developer

Confidential, Colorado Springs, CO

Responsibilities:

• 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.