John Siena

Personal Information

Mobile Phone: 416-***-****

Address: ** ******* ******** *********, *******, M9B 2V6, Canada

E-Mail: adzapi@r.postjobfree.com

Education

- Bachelor of Science Degree in Computer Science and Mathematics

- McMaster University (Hamilton, Ontario, Canada)

Professional Experience

Over 25 years of experience and expertise in all areas of Software Development

Expert in all phases of SDLC methodologies

Excellent communication skills

Proven abilities in working effectively in technical environments

Employment History

Alberta Health (Contract) (March 2022 – April 2023) – Senior Systems Analyst / Senior Software Developer

Documented hundreds of COBOL and ADABAS/Natural computer programs along with associated JCL to create functional specifications for a new system / application.

Use of Time: 50% development / 50% analysis

Bell Media (Contract) (May 2015 – June 2021) – Senior Software Developer

Fixed bugs and modified (new business functionality) multiple applications (written in PowerBuilder 11); databases: Sybase, SQL Server, Oracle

Fixed bugs and modified (for added functionality) a reporting system (written in java-script)

Created and maintained dozens of Excel VBA macros

Use of Time: 100% software development

NESIT Services (Contract) (March 2010 – May 2015) – Software Developer

Designed / developed mobile apps in both android (published app to multiple Android App Stores) and iOS

Technical skills: Android, C#, Eclipse, xCode 5, xCode6, iOS, Java, JavaScript, JSON/XML, MySQL, Objective-C, Cocoa Touch, Object Oriented Design/Programming, Interface Builder, iPhone/iPad SDK, PHP, SQLite, Swift, GIT, JIRA, gitHub, MySQL, APIs (Twitter, FaceBook), Auto-Layout, HTML, Agile, iOS7, iOS8

Use of Time: 100% software development

Project Management Consultant at multiple clients (October 2008 – May 2015)

CIBC, Bell Canada, TD Bank, Bank of Montreal, Bell Canada, Home Trust, Hydro One Telecom

Use of Time: 100% project management

Accellos (Contract) (June 2007 – September 2008) – Senior Systems Analyst

Made modifications to an existing Logistics client-server application (PowerBuilder 7, PowerBuilder 10 and PowerBuilder 11):

oReduced code duplication; re-factored/optimized code

oFixed bugs

oAdded business functionality

Technical skills: PowerBuilder 7, 10, 11

Use of Time: 90% development, 10% testing

Ford Canada (Contract) (June 2005 – May 2007)

Liaison between business groups and software developers to maintain Vehicle Incentive System

Use of Time: 40% analysis, 40% project management, 20% testing

ADP Canada (Contract) (May 2005 – June 2005) – Senior Application Developer

Made modifications to existing client-server (PowerBuilder 10) application for new functionality

Tested a new web application to ensure it meets business needs

Performed in-depth analysis of application to improve performance of slow-running areas

Mentored a small team to help reduce code duplication

Provided strategies to re-factor application

Technical skills: PowerBuilder 10

Use of Time: 50% development, 30% testing, 20% analysis

Loyalty Group (Nov 2004 – January 2005) – Project Manager

Managed the Performance Management Project to help establish an Operations Centre within the Infrastructure Group; specifically with tools and processes to provide real-time and proactive monitoring of services, applications, and network infrastructure using eHealth (Concord) and SMARTS technology

Helped negotiate contracts with two third-party external vendors for delivery of monitoring software

Created statement of work (SOW) documents to facilitate external vendor project creation

Helped capture business metrics for performance, capacity and service level reporting

Managed the AS/2 Protocol Project to help replace FTP technology with AS/2 technology (in compliance with Sarbanes Oxley)

Use of Time: 100% project management

ManuLife Financial (July 2004 – Nov 2004) – Team Lead / Senior Systems Analyst

Designed conversion processes from source systems for 2 companies (Aetna and Maritime Life) that were bought by Manulife

Led a small team of developers to design an initial set of business requirements

Analyzed target application (Vital Objects) data elements for conversion process

Wrote SQL scripts to help with this analysis

Updated and created new C# (.NET) programs to load samples of converted data

Technical skills: C#, #NET, SQL

Use of Time: 40% team lead, 30% analysis, and 30% development

ADP Canada (December 2003 – June 2004) – Senior Application Developer

Set up a “Benchmark and Optimization” process for a PowerBuilder 9 application released on a quarterly basis

Performed benchmarks for baseline purposes of ongoing software releases

Performed optimization whenever needed

Worked closely with Tech Architect on designing enhancements

Mentored PowerBuilder developers on an ongoing basis

Technical skills: PowerBuilder 9

Use of Time: 75% development, 25% testing

Canadian Institute for Health Information (July 2003 – December 2003) – Project Manager

Led a small team investigating technological/financial impact of retiring the mainframe

Determined the feasibility of migrating mission critical legacy systems to J2EE infrastructure

Determined recommendations for a strategic assessment and plan for CIHI’s overall technological infrastructure

Investigated the issues and benefits for implementing HL7 standards within the organization

Use of Time: 80% project management, 20% analysis

Bank of America (May 2003 – June 2003) – Business Analyst / Project Manager

Led a very small to team to document business requirements for a USA Government Credit Card system to be migrated from Netscape to WebSphere with Oracle 9i database

Attended multiple meetings with high-level bank VP’s to plan and document activities and tasks to accomplish this migration

Documented current process models and possible re-engineering of business processes

Use of Time: 50% project management, 50% business analysis

Ontario College of Teachers (February 2002 – February 2003) – Project Manager, Software Developer Lead

Led a team (12-15 individuals) to analyze, design (object-oriented), construct and deploy the Professional Learning Program application for the College for all phases of the systems development life-cycle (SDLC)

Initially hired as a senior developer (PowerBuilder version 8 and Java/J2EE), quickly became team lead

Coordinated implementation of electronic payment (e-payment) 3rd party software (Moneris) into application – managed interaction with Moneris personnel to retrieve documentation, batch test scenarios, and co-ordinate development process

Developed prototypes (in both English and French) to help visualize functionality

Technical skills: PowerBuilder 8, Java/J2EE

Use of Time: 75% project/team lead, 15% business analysis, and 10% development

Technical Environment: MS Project, Java, PowerBuilder 8, MS SQLServer, JBuilder, J2EE, JSP, JavaScript, IIS, UML, Rational Rose, RUP, Visio, Tomcat

ITPRO Enterprises – (January 2001 – February 2002) – concurrent with Tosco & Cambridge Malls – Project Manager, Software Developer

Led a small team of 3 developers to build a recruitment application

Use of Time: 50% project/team lead, 50% development

Technical Environment: MS Project, J2EE, JSP, Swing, .NET, Novell, Oracle, Clipper, MS Access, DB2, MySQL

Tosco – Phoenix, Arizona (August 2001 – September 2001) – Senior Application Developer

Helped convert a PowerBuilder 7 Refinery Contract / Inventory application from a 2-tier to a 3-tier methodology with Tuxedo and Oracle 8 backend for a major American oil company

Technical skills: PowerBuilder 7

Use of Time: 100% development

Technical Environment: Oracle, PL/SQL, PowerBuilder, Jaguar, EAServer, Tuxedo

Cambridge Malls (November 2000 – August 2001) – Senior Software Developer

Helped build a budget component (module) to a large existing leasing management system using PowerBuilder 7 with Sybase 10 backend and Novell architecture

Successfully implemented the budget component

Use of other technologies: Lotus Notes

Technical skills: PowerBuilder 7, Sybase, Novell, Lotus Notes

Use of Time: 100% development

Technical Environment: PowerBuilder, PFC, Sybase, Novell

Rogers Wireless (March 2000 – October 2000) – Senior Software Developer

Tested modifications to upgrade 2 systems from Visual Basic 4 to Visual Basic 6; rewritten using object oriented design/programming techniques

Helped support a PowerBuilder 6 / Oracle system using PFC for another application group

Helped support both systems with any production problem issues

Technical skills: PowerBuilder 6, Oracle, PFC, Visual Basic 4, Visual Basic 6, SQL Server, Crystal Reports, MS Access, AMDOCS

Use of Time: 90% development, 10% team lead

Technical Environment: Visual Basic, Crystal Reports, PowerBuilder, PFC, Oracle, SQLServer, MS Access, AMDOCS

Cesky Mobil – Prague, Czech Republic (January 2000 – March 2000) – Senior Programmer Analyst

Coded and tested both data and business layer COM objects written in VB6 for a CRM application

Made modifications to their existing telephony application

Helped deploy FileNet into their CRM business area

Technical skills: Visual Basic 6, FileNet

Use of Time: 100% development

Technical Environment: Visual Basic, MTS, Oracle, PL/SQL, ASP, Interdev, JavaScript, VBScript, HTML

Bell Mobility (August 1997 – November 1999) – Senior Programmer Analyst

Basically, a continuation of my role last time I was here

Made enhancements to a large online Powerbuilder (PFC) application running on an NT platform with Sybase 11 backend

Replaced many embedded SQL with Sybase stored procedures (Transact SQL using DBArtisan)

Technical skills: PowerBuilder, Sybase version 11, Transact SQL, PFC

Use of Time: 80% development, 20% team Lead

Technical Environment: PowerBuilder, Sybase, WinRunner, UML, MKS, Cobol, DB2, Y2K

Canada Life (May 1997 - August 1997) – Senior Programmer Analyst

Wrote remote procedure calls to access Sybase from Unix Cobol (data layer) for use in a 3-tier Powerbuilder online application (Prodigy similar to PFC)

Bell Mobility (June 1995 - April 1997) – Senior Programmer Analyst

Made enhancements to a large online Powerbuilder application

Air Canada (Mar 1995 - May 1995) – Senior Programmer Analyst

Converted a Pilot Utilization Report from Cobol to PowerBuilder

Helped other programmers learn and use PowerBuilder

Hudson's Bay Company (April 1994 - Mar 1995) – Senior Programmer Analyst

Helped develop a Sales Online Reporting system (PowerBuilder)

Contact this candidate