Resume

Ensuring EMIS Phase 3 project is approved and appropriately funded.

Ensuring EMIS Phase 3 project is completed on time and within budget.

Creating and maintaining project plans and resource plans for each release.

Hiring additional personnel as required.

Producing project status reports.

Working with business clients to produce business functional specifications and user requirements.

Working with data architecture for data modeling requirements.

Mentoring team members in programming techniques, SQL query optimization and understanding business processes.

Obtaining approval from the Environment Management team for software promotions - (acceptance to PROD support and PROD environments).

I also continue to develop in C, Pro*C, PL/SQL, UNIX shell scripts, Oracle and MQ Series.

Developing PL/SQL packages to store train events, train schedules and train plans in Oracle.

Developing C and Pro*C routines to get train events, train schedules and train plan messages from MQ and call PL/SQL packages to store the messages in Oracle.

Obtaining approval from the Environment Management team for software promotions (acceptance to PROD support and PROD environments).

Creating Oracle reports.

Creating JSP pages to interface with the Oracle reports.

Creating Java XML web services to interface with both internal and external funds data.

Utilizing PocketSOAP, VB, VBA and Java Beans to create web services for Excel spreadsheets.

Creating VB forms in Excel spreadsheets to interface with web services to retrieve data from SQL server and Oracle to populate spreadsheets.

Proven ability to work under pressure and meet deadlines. I consistently meet timelines with all deliverables, including design, development, unit testing, system testing and documentation.

Primary middle layer (PL/SQL) developer for all eGIP related development (e.g. Web Services).

Successfully developed and unit tested the Reversals (receipting) project middle layer (PL/SQL), which was very complex in nature and the timeline was extremely tight.

Assisting others in tuning PL/SQL code for performance. For example, I provided guidance and coaching in performance tuning for the Billing Optimization (BOP) project.

Made significant enhancements to the PL/SQL code within BOP to improve performance and error handling.

As a member of the support team, working on bug fixes and enhancements to PL/SQL code, UNIX shell scripts and Oracle tables/views.

Very thorough unit and system testing, preventing many bugs from reaching the user test phase.

I have made it a point to understand the business processes within RIMS, allowing the development of solid enhancements and bug fixes.

Creating estimates for work requests.

Working with business clients to produce business functional specifications.

Follow all RIMS development procedures including documentation, coding standards, testing and software promotion.

Ensuring projects are completed on time and within budget. EME Corrections, a 2003 project with a $1.5 million dollar budget, was completed on time and $260,000 under budget.

Managing multiple projects. Typically, managing 5 to 10 projects simultaneously, ranging in budgets between $10,000 and $300,000.

Ensuring all projects are approved and appropriately funded.

Creating estimates for work requests.

Creating and maintaining project plans.

Creating and maintaining resource plans.

Hiring additional personnel as required.

Producing project status reports.

Approving contractor timesheets.

Working with business clients to produce business functional specifications and user requirements.

Working with data architecture for data modeling requirements.

Mentoring team members in programming techniques, SQL query optimization and understanding business processes.

Obtaining approval from the Environment Management team for software promotions – (acceptance to PROD support and PROD environments).

I also continued to develop in C, Pro*C, PL/SQL, UNIX shell scripts, Oracle, MQ Series and COBOL DB2/IMS.

Ensuring projects are completed on time and within budget.

Managing multiple projects. Typically, managing 5 to 8 projects simultaneously, ranging in budgets between $20,000 and $550,000. I managed both the TSD/CTN and EME/CSD teams at the same time.

Ensuring all projects are approved and appropriately funded.

Creating estimates for work requests.

Creating and maintaining project plans.

Creating and maintaining resource plans.

Hiring additional resources as required.

Producing project status reports.

Approving contractor timesheets.

Working with business clients to produce business functional specifications and user requirements.

Working with data architecture for data modeling requirements.

Obtaining approval from the Environment Management team for software promotions – (acceptance to PROD support and PROD environments).

Creating estimates for work requests.

Working with business clients to produce business functional specifications and user requirements.

Analyzing user requirements and creating program specifications for team members.

Working with data architecture for data modeling requirements.

Mentoring team members in programming techniques, SQL query optimization and understanding business processes.

Ensuring all software releases are promoted on time.

I also continued to develop in C, Pro*C, PL/SQL, UNIX shell scripts, Oracle, MQ Series and COBOL DB2/IMS.

Developing PL/SQL packages to store equipment event, shipment and trip plan information, sourced from mainframe legacy systems via MQ and InfoRefiner, in Oracle.

Developing C and Pro*C routines to get equipment event messages from MQ, call PL/SQL packages to store the events in Oracle and publish standard event messages via MQ.

Developing data propagation processes, using InfoRefiner, to access IMS and DB2 logs to propagate legacy data from the mainframe to Oracle.

Developing COBOL DB2/IMS MPP programs to feed legacy data to Oracle via MQ.

Developed and supported the Shipment Management System (SMS), which maintains shipment trip plans (local and interline) for all CP rail and intermodal equipment. SMS is an on-line and batch system, written in COBOL II and accesses MQ Series, IMS and DB2.

Supported the Facilities Management System (FMS), which maintains TELUS' facilities (e.g. telephone number, service address, line equipment, terminal and cable) for Alberta. FMS is an on-line and batch system, written in OS/VS COBOL and COBOL II, accessing IMS and DB2.

CORE (TELUS' integrated service order, billing and facilities systems) Installation Team Leader, responsible for installing and replicating CORE software releases at TELUS from BCTEL.

Worked in an advisory role on the CORE Process Data Alignment (CPDA) project, resolving technical FMS related issues.

Contracted at Alberta Government Telephone (AGT), working on the Facilities Management System (FMS) Project, which was responsible for implementing the software from BCTEL and converting the AGT software systems.

Responsibilities included infrastructure, software installation, data conversion and FMS technical support for the test, training and production environments.

Developed and support a Paradox application to maintain volunteer registration, agency registration, agency requests and volunteer hours.

Maintained HRSB's three DB2 databases (test, acceptance and production).

Responsible for the migration of COBOL programs and CSP applications from the test environment to the acceptance environment, and from the acceptance environment to the production environment.

RACF security coordination.

Responsible for setting up a new training environment, including: liaising with CITEC to set up a new CICS region for the new training environment; creating the RACF security profiles for training; creating and loading (from production) all required datasets for the training environment; writing the Data Dictionary Library (DDL) entries required to create the training database; designing, coding and testing of the COBOL programs required for loading and unloading of data from one environment to another (included data located in VSAM datasets, sequential datasets and DB2).

Developed a suite of CSP applications to improve Human Resource Management System (HRMS) usability and enhance performance.

As Backup RACF Administrator, assisted clients with any problems they had with RACF security in using RACF Forms Automation System (RFAS).

The RFAS/RACF Discrepancy System, my third year project, was undertaken at CITEC. It is responsible for maintaining integrity between the RFAS database and the RACF database.

Responsible for the maintenance of RACF Forms Automation System (RFAS), which is an on-line menu based system for control of RACF security at CITEC.

As Backup RACF Administrator, assisted clients with any problems they had with RACF security of in using RACF Forms Automation System (RFAS).

Worked on the Netview Access Administration Project and responsibilities included: updating RFAS to incorporate Netview Access processing; designing and coding a CSP application to allow RACF co-coordinators to add/delete Netview Access Applications; updating TSO RFAS (RFAS request processing) to incorporate Netview Access processing; designing and coding batch programs to perform Netview Access processing; creating the Netview Access VSAM datasets in the test environment for system testing.

Responsible for the maintenance of RFAS, which included: re-writing all RFAS CSP applications to conform to CITEC standards and improve performance; re-writing all TSO RFAS CSP applications to conform to CITEC standards and improve performance.

General clerk for Canada Safeway, perishables manager for Woolworths Australia, Stand Chief for Mister Minit Australia, construction laborer and cleaner.  Details available on request.