Rocky Bruce
(403) 829-7164
brucer4995@yahoo.ca
Summary
Senior Developer with over 15 years Powerbuilder Development experience
Technical Skills
Languages:
PowerBuilder 5.0/6.5/7.0/8.0/9.0/10.0, 11.0, 12.5, SQL, PL SQL, T-SQL
Databases:
Oracle 7.3/7.4/8/9.10g, MS SQL Server 6.5, MS SQL Server 2005, Microsoft Access
Other: Windows NT Server 4.0, Internet Information Server 4.0, HASP 6.2, Install Shield 5.1/6.0, Sybase SQL
Anywhere, Rational Robot, Embarcadero (DBArtisan), SQLNavigator, PL/SQL Developer, Visio, Crystal Reports,
Eclipse, MS Team Foundation Server, Assyst, TOAD SQL Developer
Work Experience
PLAINS MIDSTREAM CANADA 08/2012-09/2016
SUITE 1400, 607 – 8TH AVE S.W. CALGARY AB, CALGARY T2P 0A7
Object Oriented Designer/Developer/Analyst Level II
Project design/development – utilizing Powerbuilder 12.5 on Oracle 10g database
- Adhere to enterprise architect-ed policies and procedures for development and change management
- Participated in Agile iterative development practices
- Create scheduled deployment packages for continuous integration
- Application support – application analysis, application debugging, application unit/system testing, break
fix, generating executables, data fix (SQL scripting in Oracle)
- Utilize Microsoft Team Foundation server for source control and versioning
- Design/develop EDI application including data modeling, create tables with DDL and data mapping for Biztalk
integration
- Data mapping for Biztalk interface
- Design/develop truck file modules
- Create/modify XML code to pass data to crystal reports
- Create /modify Oracle PL/SQL store procedures for datawindow retrieval
- Create/modify Oracle PL/SQL stored procedures for reporting
- Create Powerbuilder SQL driven data window reports
- Create/modify triggers for data update and deletes
- Create ad hoc SQL Plus reports to pull data from Oracle database
- Create and maintain documentation using SharePoint repository
- Data modeling for new truck file modules
- Plan and implement conversion of applications from Powerbuilder 10 to 12.5
- Plan and implement changes required to decommission Powerbuilder (GATE) application in favor of Biztalk
interface
Technical Environment: Powerbuilder 12.5, Oracle 10g, PL/SQL, SQL Plus, MS Outlook, Windows XP, Windows 7,
PL/SQL Developer, TOAD SQL Developer, Microsoft Word, Microsoft Excel, Crystal Reports, SharePoint, Microsoft
Team Foundation Server and Citrix
ZYTECH BUILDING SYSTMS INC. 05/2009-08/2012
262029 RANGE ROAD #10, BALZAC AB T0M 0E0
- Sawyer - operate Hundeggar saw, swing saw, chop saw, table saw, chainsaw
- Operate pneumatic nail gun, pneumatic staple gun
- Truck Driver - deliver company products to clients
- Assemble pony walls and floor packages for shipping
- Forklift Operator
CorTech 04/2008-03/2009
Husky Energy
707 8 Avenue Sw, Calgary AB
Object Oriented Powerbuilder Designer/Developer - Field Data Capture IT Support Role
- Monitor Remedy Que, resolve issues as required
- Develop enhancements on Powerbuilder 10/Oracle 10 based FDC Utilities (client/server)
- Maintain Powerbuilder 10/Oracle 10 SQL based FOS report application (client/server).
- Fix issues found in QA.
- Utilize continuous integration to manage roll out from QA to Production
- Manage upgrade from Crystal 10 Enterprise to BOE XI R2 (Crystal 11)
- Support Crystal Reports web based report system
- Plan and implement conversion of existing reports from Crystal 10 to new Crystal 11 server
- Develop waste management PL/SQL Oracle stored procedure for XML data extract to Siteview
- Create SQL scripts to update Pool Codes in PVR/GFR on Oracle database
- Restore & modify projects in a broken Eclipse environment. Generate war files and promote to a test environment
- Modify reports in Crystal Reports Designer, promote to test environment
- Modify web pages in MS Frontpage and promote to production support environment
Technical Environment: Powerbuilder 10, Oracle 10, PL/SQL, SQLPlus, MS Outlook, Windows XP, Powerbuilder Foundation
Class Libraries, PL/SQL Developer, VISIO, Microsoft Word, Microsoft Excel, Crystal Reports, Eclipse, Citrix
Finney Taylor 08/2007-04/2008
Graham Group
10909 27th Street SE, Calgary AB
Powerbuilder Programmer
Object Oriented Design/Development, unit/system testing & maintenance on Powerbuilder/PFC/MS SQL Server based ToolBox
(client/server)
- Adhere to enterprise architect-ed policies and procedures for development and change management
- Participated in Agile iterative development practices for continuous integration
- Create/Modify T-SQL stored procedures
- Create/Modify Powerbuilder objects version 9 & 11
- Maintain data model via Powerdesigner
- Create/modify database tables, views & triggers via scripts
- Create scripts for data transfer & manipulation
- Modify Powerbuilder reports
- Unit/System test powerbuilder applications
Technical Environment: Powerbuilder 9 & 11, MS SQL Server 2005, T-SQL, MS Outlook, Windows XP, Powerbuilder Foundation
Class Libraries (PFC), SQL Navigator, VISIO, Microsoft Word, Microsoft Excel
COMPUTER AID INCORPORATED 02/2006-06/2007
CIT
South Service Road, Burlington ON
Powerbuilder Programmer
Object Oriented Design/Development, unit/system testing & maintenance on Powerbuilder 10/Oracle 9 client server
applications
- Worked with development team & business analysts to process business requirements
- Adhere to Agile iterative development practices for continuous integration
- Unit/System test powerbuilder applications
- Create/modify database tables, views & triggers on Oracle database
- Create SQL scripts for data transfer, data repair & manipulation on Oracle database
- Created/modified Oracle PL/SQL stored procedures/functions and Powerbuilder script for eBOSS (client/server)
- Created/modified Oracle PL/SQL packaged procedures for Auto Advisory
- Created Oracle PL/SQL packaged stored procedures for EZFX (EZForms Express interface)
- Created/Modified Oracle PL/SQL stored procedures for XML interfaces
- Created/modified mapping documents for Oracle PL/SQL stored procedure XML interfaces
- Created/modified Oracle PL/SQL stored procedures for MFS (Microsoft Financing Services web site)
- Created/modified Oracle PL/SQL stored procedures for DOC1(Electronic Document Interface)
Technical Environment: Powerbuilder 10, Oracle 9, PL/SQL, MS Outlook, Windows XP, Powerbuilder Foundation Class
Libraries (PFC), SQL Navigator, VISIO, Microsoft Word, Microsoft Excel
BANK ONE 07/2003-01/2006
Bank One Corporate
1111 Polaris Parkway, Columbus, OH
Powerbuilder Programmer
Object Oriented Design/Development, testing & maintenance on Powerbuilder 9/Oracle 9 client server based Commercial
Loan Agreement Servicing System
- Created Powerbuilder code
- Created Oracle PL/SQL stored procedures
- Created ad hoc queries and scripts for data fixes (production support) on Oracle database
- Create documentation
- Debug and repair existing problems found in Powerbuilder application (production support)
- Created temporary tables for SQL ad hoc reports and executive summaries in Oracle database
- Create executive summaries for corporate monitoring (Oracle PL/SQL stored procedures)
Technical Environment: Powerbuilder 9, Oracle 9, PL/SQL, Lotus Notes, Windows 2000, Websphere, Powerbuilder Foundation
Class Libraries, Embarcadero (DBArtisan), VISIO, Java, Microsoft Word, Microsoft Excel
Robert Half Technology 04/2002-01/2003
Accident Fund Insurance Company of America
Lansing, MI
Powerbuilder Programmer
Object Oriented Design/Development, unit/system testing & maintenance on Powerbuilder 7/PFC/Oracle 8 client server
application
- Create Oracle PL/SQL stored procedures
- Created SQL script driven data fixes in Oracle database
- Create/modify database tables, views (Data modeling) in Oracle database
- Implemented changes for corporate branding
- Created executables for PowerBuilder 7.0 applications
- Worked with business analysts to gather requirements for enhancements to existing PowerBuilder applications
- Developed application enhancements based on requirements
- Unit/System test powerbuilder applications
Technical Environment: PowerBuilder 7.0, Oracle, PL/SQL, SQL Plus, MS Outlook, NT 4.0, PowerBuilder Foundation Class
Libraries (PFC)
TEKsystems 08/2000-12/2001
Northern Indiana Public Service Company
Merrillville, IN
Powerbuilder Programmer
Object Oriented Design/Development, unit/system testing & maintenance of a Client Server PowerBuilder/PFC/Oracle
application
- Worked with business analysts to gather requirements from end users for technical specifications
- Debugged and repaired existing problems found in the PowerBuilder application
- Created/modified documentation as needed for the installation of the PowerBuilder application
- Created/modified documentation to assist non-technical staff to be able to navigate in the PowerBuilder development
environment
- Create/modify database tables, views & triggers in Oracle database
- Created SQL script driven data repairs on Oracle database
- Created PowerBuilder application executable and support files on a monthly basis for continuous integration
- System tested the PowerBuilder application with Rational Test Manager
- Packaged the PowerBuilder executable and support files with Install Shield 6
- Modified the custom Install Shield script to accommodate Oracle client upgrade
- Performed file transfers via ftp to Unix server for global distribution of the packaged PowerBuilder executable
and support files
- Performed SQL driven data fixes via SQLPlus on the Oracle database
- Created ad hoc reports using SQLPlus on Oracle database
- Notified end users of PowerBuilder application update and assist them with installation
- Evaluated the possibility of integrating other PowerBuilder applications into the existing application
- Evaluate PowerBuilder 7.0 & 8.0 to develop a plan for best conversion process
- Upgraded PowerBuilder development environment from 6.5 to 7.0
- Convert PowerBuilder application pbls from version 6.5 to 7.0
- Upgraded PowerBuilder development environment from 7.0 to 8.0
- Convert PowerBuilder application pbls from version 7.0 to 8.0
- Modified the migrated PowerBuilder script to accommodate obsolete references prior to PFC upgrade
- Upgraded PowerBuilder Foundation Class Libraries from 6.0 to 8.0
- Evaluated several products to determine the best tools for impact analysis
- Evaluated Microsoft SMS as a possible alternative to Install Shield
- Implemented Oracle client upgrade from 7.3 to 8.0
- System Tested the PowerBuilder application for compatibility problems with Windows 2000
- Resolved PowerBuilder to Oracle connection problems related to Windows 2000
- Diagnosed and corrected PowerBuilder application compatibility problems with Windows 2000
Technical Environment: PowerBuilder 6.5/7.0/8.0, C, Oracle 7.3/8.0, SQLPlus, Lotus Notes, MS Rational Test Manager,
MS Word, MS Excel
FORCE/Robak Associates Ltd. 11/1997-7/2000
Fredericton, NB
Powerbuilder Programmer
Object Oriented design/development and analysis, unit/system testing & maintenance of a Client Server PowerBuilder
/Oracle/MS SQL Server /MS Access application
Developed applications using PowerBuilder 5.0/6/6.5 and PowerBuilder Foundation Class Libraries (PFC)
- Unit/System tested powerbuilder applications
- Create SQLPlus ad hoc reports on Oracle database
Create Powerbuilder reports
Created/maintained education system for university students majoring in forestry related industry
Data modeling - Create/modify database tables, views, triggers and SQL script driven data repair on Oracle
database
- Develop a plan for locking software so it could be used as a demo
- Created registry locking mechanism for evaluation of time based software
- Involved in direct interaction with clients that included project support to project completion
- Performed network administration and configuration (NT 4.0)
- Worked on installation, configuration and administration of ftp and www services (IIS)
Performed installation and configuration of hardware and software protection utilities (HASP Security Keys)
Developed software installation packages (Install Shield) for continuous integration
process
- Created compact disks for the purpose of distribution of finished products
- Performed installation and maintenance of an Oracle 7.3 and 8.0 database
- Migrated an Access database to Oracle 7.3
- Migrated from an Oracle 7.3 to Orcle 8.0 database
- Exported and imported Oracle databases
- Created and executed PowerBuilder data pipelines
- Created documentation for PowerBuilder applications as per client request
- Created HTML based help file system
- Communicated with and assisted business partners in Spain with technical issues related to PowerBuilder applications
- Integrated CARIS technologies provided by local business partner with our existing - PowerBuilder applications
- Established and carried out communications between local client and appropriate entities for the purpose of establishing
clients web presence
- Assisted in-house university students with the concepts of PowerBuilder development
Technical Environment: PowerBuilder 5.0/6.0/6.5, PowerBuilder Foundation Class Libraries (PFC), Powerdesigner, MS Access,
Oracle 7.3/8.0, SQLPlus, MS SQL Server 6.5, Sybase SQL Anywhere 4.0, HTML, Windows NT 4.0, Internet Information Server,
TCP/IP, DNS, WINS, RRAS, ODBC, Visual Basic
Education
Advanced Training and Services 03/1997-01/1998
Fredericton, NB
Object Oriented Design and Development
Analysis, development and implementation of custom software with the use of Powerdesigner, PowerBuilder, PowerBuilder
Foundation Class Libraries (PFC), Access, Oracle, MS SQL 6.5 and Sybase SQL Anywhere 4.0,
Data Modeling
Courses
Object Oriented Design and Development, PowerBuilder 5.0/6.5, Active X, Visual Basic 4.0/5.0, Microsoft Office ‘97, Java,
Microsoft Access,
Microsoft Front Page, Web Design, SQL Server 6.5, SQL
