Uploaded File
add photo
Jim
Ojr2008@aol.com
407-574-5137
11631 Lake Katherine Cir.
Clermont, FL 34711
PowerBuilder Developer
18 years experience W2
0
Recommendations
Average rating
113
Profile views
Summary

Expertise in design and development of application in relational database and client server environment using PowerBuilder4.0/5.0/6.0/7.0/8.0/9.0/10.5/11.5/12.5 and the PFC with exposure to AGILE development methodology.

21 Years of experience in System Analysis/Design, Coding, Unit Testing, Testing, Implementation, Maintenance and enhancement of Software applications. Experience in migration from PowerBuilder to Java.

Strong Business Software design and development experience in Telecom Services Manufacturing, Government and Finance industry using PowerBuilder, Sybase, Oracle and Informix on Windows 2000, XP, Windows NT.

Have good knowledge and experience in OOAD, Software Development Life Cycle and Quality procedures in development and maintenance of the application.

Experienced in developing use case diagrams using the rational paradigm.

Good verbal, analytical abilities with excellent communication skills and interpersonal skills.

Experience
Product Support Lead
Oct 2015 - Oct 2016
Powerbuilder 7.0, Oracle 7, Mumps PFW
• Provide 3rd line Application Support on complex internally and externally developed applications.
• Act as a Powerbuilder resource for internal projects.
• Coach and develop team members.
• Interact with internal teams to trouble shoot and resolve complex problems.
• Ensure incident and problem logs are up-to-date.
PowerBuilder Oracle 8 Oracle
Remove Skill
Sr. Software Engineer
Information Technology
May 2016 - Oct 2016
Powerbuilder 12.6, Sql Server 2014 First Commercial
• Developed modifications to Invoice Exceptions to exclude printing vendor invoices that fell within a selected number of days.
• Custom labels - designed modifications to reports to display custom column labels in reports that would be determined by company name selected in user setup.
• developed modifications in reports to allow for multi-column sorting. Analysed code in Duplicate Payment reports to determine how to remove requested reporting parameters.
• developed modifications in global selection criteria for parameter to limit number of rows returned in query result set of selected reports. developed modifications in global selection criteria to allow the user to select a group of vendors and a range of fiscal for reporting.
Software Engineer PowerBuilder SQL Server SQL Database Design
Remove Skill
Sr. Software Engineer
Information Technology
May 2015 - Aug 2015
Powerbuilder 12.5, PFC, DB2 Global Billing
• Created migration plan to document procedures needed to migrate application from Powerbuider 6.5 to version 12.5 and to implement source control procedures for the new version.
• Documented problems in and developed modifications in source code to correct problems in datawindow, window and PFC service classes. Developed new billing discounts module while acting as mentor to junior developers.
Software Engineer PowerBuilder DB2
Remove Skill
Sr. Software Engineer
Information Technology
May 2014 - Mar 2015
Powerbuilder 9.0, PFC, Oracle 11g, SQL Developer IMUA
• Developed modifications to terminate subscribers and to prevent claims from being paid when the termination date is the same as their effective date. Modified package procedure (s) to create adjusting entry when subscribers are termed on their effective date.
• Developed modifications for associating bank routing numbers with individual or group record (s) for Electronic Funds Transfer processing.
• Performed data mapping for EOB letters and created procedure (s) to create data files to be sent for processing.
• Created modifications to validate required fields for the creation of new family subscriptions.Perfomed data mapping, created new table, triggers, code specs and procedures to load enrollment data from the exchange via an 834 message supplied by a third party into existing tables.
• Developed scripts to change table definition to allow users to identify subscribers by legacy id as well as member or social security number. Developed procedure to match legacy ids to current subscriber number and to load legacy ids into appropriate table.
• Created Customer Service call logging module that would allow users to log or search for calls by claim type, date of call, department, or procedure code. Developed various reports for this same module.
SQL Developer Triggers PowerBuilder Oracle 11i Oracle Software Engineer SQL 834
Remove Skill
Sr. Software Engineer
Information Technology
May 2013 - Feb 2014
PowerBuilder 11.5, PowerBuilder 12.5, PFC, XML, DB2 POS
• Designed changes in XML formatting to send cost of attraction tickets instead of price to Disney through a web service call from a POS cashiering terminal. Designed changes in POS cashier module to allow for the sale of electronic tickets through a third party gateway.
• Designed and documented application security changes to allow for assignment of functions to a given user role for a specific user assigned to a specific branch or branches.
• Migrated support applications from PowerBuilder 10 to 12.5. Created DB2 procedure and PowerBuilder non visual object to set user security credentials from PeopleSoft to be used as active directory login credentials for POS and various support applications.
• Created SQL scripts for ESR Reporting.
PowerBuilder SQL Software Engineer XML DB2 MS Active Directory Database Design
Remove Skill
Sr. Software Engineer
Information Technology
Sep 2012 - Feb 2013
PowerBuilder 12.5, Informix 11 CTrack
• Created high level design documents for changes to a case tracking module. Analyzed and redesigned existing module to include the ability to display the rehabilitation process of an individual or a group of individuals hierarchically through a tree view. These modifications included a procedures checklist that would allow the user to monitor and evaluate the progress of the individual.
• Analyzed and redesigned the appropriate database procedures for the new case tracking design changes. Created new procedures to incorporate a process checklist into the tree view.
• Design of database procedures for word merge reports through the Microsoft word OLE engine.
PowerBuilder Software Engineer Database Design
Remove Skill
Sr. Software Engineer
Information Technology
Oct 2011 - Jun 2012
PowerBuilder 9.0, DB2, C, Windows XP BenAdmin, DrugAdmin, DrugCat
• Developed modifications to DrugAdmin to reject Medicaid claims for the state of Arizona for prescription medication which were dispensed past the drug's HCFA termination date.
• Designed and developed changes to PFC extended layer to correct problem with data caching in DrugAdmin. Implemented and tested changes in C scripting to correct problem with database query. Analyzed and implemented changes in C script to update benefit coverage for a single drug or range of drugs in a particular drug class.
• Developed modifications to BenAdmin to update copay tier information for prescription medication for the state of Massachusetts. Assisted in migrating DrugCat from PowerBuilder 9.0 to 11.5.
PowerBuilder Software Engineer DB2 Database Design C Scripting Windows
Remove Skill
Sr. Software Engineer
Information Technology
May 2011 - Sep 2011
PowerBuilder 11.5, Informix 9.0, SourceSafe, Windows XP ADA Tracking
• Designed and developed an accommodation tracking module that allows users to track the requests of prison inmates and to transmit documentation to the courts and the individual's regards to the approval or denial of a specific request.
• Designed and developed statistical reports used to determine the number and type of requests per individual or facility per a given period.
Software Engineer Database Design Windows
Remove Skill
Sr. Software Engineer
Information Technology
Apr 2010 - Sep 2010
Jacksonville (Naval Air Station) Sr. Software Engineer
Software Engineer
Remove Skill
Apr 2010 - Apr 2010
Oracle 10g, PVCS, Windows XP NASDP TA & A * Analyzed code in a time and attendance application to extract and document business logic and processes for migration to Java.
No skills were added
Remove Skill
Sr. Software Engineer
Information Technology
Feb 2010 - Apr 2010
PowerBuilder 10.5, Oracle 9i, PVCS, PFC, Windows XP MACWICS, CCSP
• Designed and developed modifications for a family case management application to include the ability to search case records by name, county of residence, worker assigned and status.
• Designed and developed reports to retrieve archived correspondence from case workers and family members concerning the appeals process for a specific case.
• Created a tickler application to notify case workers and/or supervisors when status or changes were made to a specific case that involved the assigned worker.
• Designed and developed Family Checklist application to assist in the determination if a family was eligible for benefits.
Oracle Software Engineer Database Design Windows
Remove Skill
Sr. Software Engineer
Information Technology
Oct 2008 - Jul 2009
PowerBuilder 10.5, PL SQL/Developer, Oracle 8i, PVCS, PFC, DBSurfer ER Revenue, Windows XP
• Designed and developed reports to determine threshold amount of total outstanding liability to discharge for taxpayers who became deceased between the periods of 2004 and 2007. The report provided a count for total number of tax bills and total liability between 1/1/2004 and 12/31/2007 by total liability where total liability was less than $500, between $500 and $1000, between $1000 and $2500, and greater than $2500.
• Modified table based business rules that were stored in Oracle to validate and calculate sales tax due on gross sales for corporate returns and corrected formatting problems with edit controls on window and tab page controls.
• Designed and developed SQL scripts to correct problems with individual tax returns and implemented changes for tax calculation thresholds for the current tax year for individual and corporate returns.
PL/SQL PowerBuilder SQL Developer SQL Software Engineer Oracle Database Design Windows
Remove Skill
Sr. Software Engineer
Information Technology
Nov 2007 - Jul 2008
PowerBuilder 10.5, MS SQL 2000, PVCS, PFC, Windows XP EZ Callout, GIS
• Designed and developed changes to EZ Callout to allow users to temporarily pause the dialing and employee selection program to allow employees to telephone the call center and update their availability for a particular job. Documented proposed changes to allow for multiple instances of the Callout to run against different locations in the GIS system.
• Designed and developed changes to GIS to export location data for mapping.
PowerBuilder Software Engineer SQL Database Design Windows
Remove Skill
Sr. Software Engineer
Information Technology
Mar 2007 - Nov 2007
PowerBuilder 7, 10.5, MS SQL Server 2000, Windows XP MEMBERSHIP * Designed and developed various maintenance changes and migrated application to PowerBuilder 10.5. Addressed problems associated with migration of application.
PowerBuilder Software Engineer SQL SQL Server Database Design Windows
Remove Skill
Sr. Software Engineer
Information Technology
Mar 2006 - Mar 2007
PowerBuilder 9, Oracle 10g, SourceSafe, Windows XP ETF (Exchange Traded Funds), GSCI, MACROMARKETS
• Implemented changes to core system for the processing of creation and redemption orders of new indexed fund (s).
• Implemented changes to core system for the calculation of net assets on the Investment pool and the net asset value of the cash component and projected cash component of the fund (s) for each new business day.
• Implemented changes to core system for the processing of index funds whose value and yields track a benchmark index.
• Implemented changes to core system for the processing of decommissioned funds.
PowerBuilder Oracle Software Engineer Windows
Remove Skill
Sr. Software Engineer
Information Technology
Aug 2004 - Mar 2006
PowerBuilder 9, EA Server, Oracle 9i, Adaptive Server Enterprise, Enterprise Architect, Eclipse 3.0, Enterprise Java Beans, JUnit, EAServer, PVCS, PFC, Windows XP DTMS, RAPTRS, MCASSP, MARINE CASH, UDMIPS
• Assisted in the conversion of PowerDynamo scripts to Java Server Pages for the Document Tracking module (DTMS) of Marine on Line.
• Provided support for the MCASSP and RAPTRS applications by developing code and script changes for the newest release version of these PowerBuilder applications.
• Designed and developed use case, robustness, storyboards and sequence diagrams in Enterprise Architect for the conversion of the PowerBuilder DTMS application to Java.
• Created bean, data access, business object layers and unit tests for the ODSE and DAS load component of the DTMS application.
• Analyzed PowerBuilder code and created state tax calculators for the MCASSP module of the DTMS conversion.
• Created form bean, struts action and validation classes and Java Server Pages for the edit objects of the ODSE and DAS load components of the DTMS conversion.
• Designed and developed application changes and database schema per design specifications for the latest version of Marine Cash.
Eclipse Java Javabeans Junit Oracle Software Engineer Struts Database Design Windows Enterprise Architecture
Remove Skill
Sr. Software Engineer
Information Technology
Jun 2004 - Aug 2004
PowerBuilder 6.5, Test Director, Informix 7, Windows NT
Software Engineer Windows
Remove Skill
Sr. Software Engineer
Information Technology
May 2001 - Nov 2003
PowerBuilder 6.5, 8.0, PFC, EAServer 4.12, Sybase Enterprise Adaptive Server, HTML, JSP, JavaScript, PVCS, Windows NT, PVCS OMMS-NG
• Performed analysis in functionality of the OMMS ng configuration alteration, ships alteration, pen and ink and repairable modules and moved component logic for data access (DAO), business class (BO) and client interface (CIM) from window objects into nvo class objects for conversion from PowerBuilder 6.5 to 8.0.
• Designed and developed HTML and JavaScript in CIM module to create button class objects or hyperlinks on web pages. Developed the appropriate functionality behind the command buttons to perform a specific task. Navigation options were created as drop down list boxes.
• Designed and developed JSP pages to load components into browser. The functionality would parse a URL and convert arguments into their respective data type which would be used to populate data stores that were created in the data access object class (DAO).
JavaScript JSP Software Engineer HTML Database Design Windows
Remove Skill
Sr. Software Engineer
Information Technology
Nov 1998 - Mar 2001
PowerBuilder 6.5, PFC, Oracle 8, SQL Server 7, Sybase 11, Jasmine ii, Crystal Reports, Install Shield Professional, SourceSafe, Windows NT Knowledge Repository, DatAcquire, Activity Based Costing
• Evaluated requirements and developed a prototype for the Activity Based Costing module of the Bank Performance Management Suite. Developed business classes and assisted in the development of test plans for this module using PowerBuilder.
• Designed and developed the specifications and model for a reporting module in Activity Based Costing. Developed some preliminary reports for this module using Crystal.
• Designed and developed and tested procedures to create JCL files which would be used to create tables and import data into any relational database from the PowerBuilder app.
• Assisted in the testing of Enterprise Java Beans for the Activity Based Costing module.
Crystal Reports Oracle Software Engineer SQL SQL Server Java Javabeans Database Design Windows
Remove Skill
Sr. Software Engineer
Information Technology
Mar 1996 - Nov 1998
- Martin Information Systems Center Sr. Software Engineer
Software Engineer
Remove Skill
Mar 1996 - Mar 1996
Sybase System 10, SQL Server 4.9.2, Erwin 2.5, Solaris 2.5 MES-CAPP (Computer Aided Process Planning)
• Designed and developed of a manufacturing plan view that incorporated nested reports inside of a composite data window. This view was required to extract processing steps from text blobs as well as to extract and convert CAD images into bitmaps.
• Designed and developed procedures that would allow a user to validate a manufacturing process plan. These procedures would verify that a BOM had been processed correctly and that required materials were on hand before a workflow process could be initiated.
• Designed and developed a process workflow aging report that would allow the user to evaluate material and labor cost for a specific manufacturing process plan. This report also incorporated a nested graph object and allowed the user to select specific material and or labor cost codes to graph.
• The design and development of a test resource matrix that would allow the user to select specific components of a released manufacturing process or manufacturing process plan for consistency testing.
No skills were added
Remove Skill
Sr. Software Engineer
Information Technology
Jan 1996 - Mar 1996
PowerBuilder 4.0, PFC, Oracle 7.1, AIX BULLS EYE * Design and Development of an employee training system that would allow the user to trace courseware programs for employees working in specific departments. The application would allow the user to schedule required and elective courses for an employee and deliver e-mail to that employee X number of days in advance of when they were scheduled to take the course.
Oracle Software Engineer AIX Database Design
Remove Skill
Sr. Software Engineer
Information Technology
Jan 1995 - Dec 1995
PowerBuilder 4.0 - 5.0, PFC, Oracle 7.2, UNIX PCMS, MAGIC
• The design and development of procedures that would allow the user to create prepaid phone cards. This process involved the validation of an ASCII file that contained over one million randomly generated numbers that were six digits in length. The process generated these calling card phone numbers by calculating an offset into the ASCII file that was based on the number of cards ordered and information retrieved from a card schema table that calculated how to build the calling card number one physical position at a time.
• The design and development of a customer service screen which incorporated child data windows and hidden data windows that would allow the user to adjust the cost of a phone call, to adjust the value of a phone card or to deactivate it, to activate and edit encoded options on the phone card, and to validate the call rating of a specific phone card.
• The design and development of procedures that would allow the user to create information that was to be used to rate a phone call. This information was based on a rate method selected and origination zone codes.
• The design and development of traffic analysis and marketing reports based on the number of calls placed through the switch on an hourly basis and for a specific period of time selected by the user.
Oracle Software Engineer UNIX Database Design Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science
Bellarmine University 1984
Record has not been verified.
Skills
Software Engineer
2016
16
Database Design
2016
12
Windows
2012
11
Oracle
2016
8
PowerBuilder
2016
7
SQL
2016
6
Java
2006
5
Javabeans
2006
5
Crystal Reports
2001
3
SQL Server
2016
3
DB2
2015
2
Eclipse
2006
2
Enterprise Architecture
2006
2
HTML
2003
2
JavaScript
2003
2
JSP
2003
2
Junit
2006
2
Struts
2006
2
834
2015
1
C
2012
1
MS Active Directory
2014
1
Oracle 8
2016
1
Scripting
2012
1
SQL Developer
2015
1
XML
2014
1
Agile Methodology
0
1
AIX
1996
1
Informix
0
1
Oracle 11i
2015
1
PL/SQL
2009
1
Sybase
0
1
System Analysis
0
1
Triggers
2015
1
UNIX
1995
1