I have a background in efficiency, educationally trained to be an efficiency engineer and had ample opportunities to recommend and implement improved processes in Information Technology.

I had the opportunity to work in a variety of roles and with the different services of an Information Technology Organization, including development, enhancement, maintenance, and user support.

I started up the QA Team for an organization by defining the roles for a Quality Analyst to support the delivery of Business Intelligence for the organization, aside from managing the Defect Tracking and Defect Review process.

I also had the opportunity to manage the IT Services for an Organization.

My application portfolio varies from Legacy to Data Warehousing applications.

I have worked for a variety of industries, including Telecommunication, Oil and Gas, Healthcare, Manufacturing, Distribution, and Food Services and Insurance.

WORK EXPERIENCES

Period: February 1, 2009 – December 31, 2013

Position: Business Intelligence Support / Quality Analyst

Period: July 10, 2007 – January 31, 2009

Position: Business Intelligence Developer

Employer: Western Union, Vancouver (previously Custom House, Victoria)

Tasks Summary:

I provided Maintenance Support for their existing Business Intelligence Application that is in the process of being replaced.

I provided Development Support for their Finance Department’s Business Intelligence / Data Warehouse.

As a Quality Analyst, I help determine and perform the newly defined Quality Analyst Role for Data Warehousing. Testing of development processes, prior to Production Devlivery, are defined, performed and documented.

Major Accomplishment(s):

I started up the QA Team for the Business Intelligence Group, defining the Quality Analyst Roles and setting up Standards and Procedures for the Team.

Platform(s):

Microsoft SQL Server 2005 is their Database Platform. Microsoft’s Business Intelligence Development Studio, including Integrated Services and Analysis Services, is the Development Tool utilized to create their Business Intelligence cubes for utilization by their users. With the use of Pivot Tables in Microsoft Office Excel 2007, the cubes are their source of Business Intelligence data, to perform their Ad-Hoc queries and reporting. Microsoft Visual SourceSafe and Visual Studio are other tools utilized for Development Support.

Period: March 2005 – September 14, 2006

Position: Consultant (Contract)

Employer: Freybe Gourmet Foods Ltd., Langley, B.C.

Tasks Summary:

I was contracted to support their old ERP Application, TECSYS, that runs on an IBM Unix Informix Platform and assist with the conversion to the new ERP Application, IFS, that runs on a Windows NT Oracle Platform. Aside from Application support, I provided Data Base Administration Support for TECSYS.

I utilized Crystal Report to create customize reports to complement the replacement ERP Application.

I utilized PL/SQL to perform data extraction and cleansing. The data was then utilized by Crystal Report for reporting.

I work on the initial design and creation of a Data Warehouse to store their current & historical data into a SQL Server Platform. This platform will be utilized as the source for their Business Intelligence.

I utilized Informix SQL procedures to extract data from TECSYS for input into the Data Warehouse platform.

Major Accomplishment(s):

I assisted with the conversion of their existing application to IFS, an ERP application.

I designed and started up their Data Warehouse on an SQL Server Platform.

Platform(s):

IBM Unix Informix Platform to run TECSYS.

Windows NT Oracle Platform to run IFS.

SQL Server Platform to run Data Warehouse.

Period: March 2004 – December 2004

Position: Data Base Administrator (Contract)

Employer: TELUS, Burnaby, B.C.

Tasks Summary:

I provided IMS Data Base Adnministration and Tuning Support for Telus and their external clients, BC Ministries. Telus has approximately 320 databases and the Government Ministries has approximately 256 databases. Some of the Government Ministries we supported were:

oCorporate Registry

oProvincial Revenue

oPension Corporation

oSmall Business (CAWS)

oAttorney General and Land Titles

I was contracted to fill in for the Team Lead, who was providing IMS Data Base Administration Support, before she went on maternity leave.

Major Accomplishment(s):

I automated and documented the Performance Tuning Process for IMS Databases.

Platform(s):

IMS Data Base on IBM Mainframe

Period: July 2001 – January 19, 2004

Position: Senior Consultant

Employer: Keane Canada, Halifax, N.S.

Tasks Summary:

I worked with the discretionary team to perform development work for Keane’s outsource client Allmerica of Worcester, Massachusett. Allmerica was a Financial Life Insurance and Annuity Company. We worked on the Legacy to Staging phase to Extract, Transform and Load data into their Corporate database. The database platform is DB2. We used Cobol, Informatica and Crystal Report for the phase to perform data extraction, cleansing, loading and reporting.

I was part of the Keane team that achieved Capability Maturity Model (CMM) Level 5. CMM is used to measure organizations in terms of the maturity of their software development processes and methodologies. Standards were especially focused on the Testing Processe s to ensure high quality for the deliverables. Level 5 is the highest level of the CMM.

Major Accomplishment(s):

I assisted in the transformation of data from Legacy systems to the Staging Phase of a Data Warehouse.

I was part of the team that helped achieve Level 5 of the Capability Maturity Model (CMM).

Platform(s):

DB2 on IBM Mainframe

Period: September 1997 – June 2001

Position: Systems Specialist

Employer: TELUS, Burnaby, B.C. (ISM B.C. prior to being 100% owned by TELUS)

Tasks Summary:

My last assignment was with Telus' Corporate Data Warehouse Data Acquisition Team. We provided Extract, Transformation and Load of data from Legacy Applications residing in the Mainframe and other Operational Applications residing in Unix Client/Servers. I provided development, maintenance and pager support for the group. Aside from utilizing DB2 Utility Tools, one of the ETL tools that I utilized during this assignment was the ETI Extract tool.

One assignment that I successfully completed was to provide development, enhancement and maintenance support for Stentor’s International Settlements (ISDP) application utilizing Oracle Developer 2000 Tools. My roles with these projects were both as an Application Developer and as a Database Administrator. SQLForms, SQLReportwriter, PL/SQL and SQL Loader were some of the Oracle Developer 2000 Tools that we utilized.

Another assignment that I also completed successfully was to provide maintenance support for Stentor’s Call Processing (CP) and Customer Folder Management (CFM) applications running on IBM Mainframe utilizing Cobol, ADABAS & CICS.

Major Accomplishment(s):

Provided development and support for Telus’ Data Warehouse.

Developed ISDP application.

Platform(s):

DB2 on IBM Mainframe

Period: June 1997 - August 1997

Position: Senior Consultant (contract)

Employer: ISM B.C. International, Seoul, Korea

Tasks Summary:

I was sub-contracted by ISM B.C. International to work on the Corporate Database and Data Warehouse Project for Dacom, a Telecommunications company in Seoul, Korea. I was the Data Base Administrator for the project. I also helped with generating Use Cases for our Project Proposal to the Client. I provided the database consulting for this project.

I provided Database Consulting for the client’s Data Warehouse and Year 2000 Conversion Project.

I was also assigned to the Year 2000 Project. I provided liaison between the Project Manager and the client, as required. I helped with generating Use Cases for our Project Proposal to the Client.

Major Accomplishment(s):

I provided Database Consulting for the client’s Data Warehouse and Year 2000 Conversion Project.

Period: June 1996 - May 1997

Position: Freelance Computer Consultant

Employer: ISM B.C., Langley, B.C.

Tasks Summary:

I worked with a team of 10 contractors to help reduce Overwaitea’s maintenance backlog, using COBOL II, VSAM, MVS/ESA, TSO/ISPF, EZYEDIT, ENDEVOR, SMARTTEST and CICS. Applications included Overwaitea’s OMI Billing and Biceps applications.

I was also responsible for the primary pager support of Overwaitea’s Biceps application.

Major Accomplishment(s):

I reduced Overwaitea’s Maintenance Backlog.

Platform(s):

IBM Mainframe

Period: January 1995 - May 1997

Position: Freelance Computer Consultant

Employer: Self-employed entrepreneur, Vancouver, B.C.

Tasks Summary:

I enhanced and maintained a Manufacturing and Distribution package for the MCBA Users' Group, utilizing the Data General Aviion platform and running the Unix Operating system. The MCBA Classic applications were developed utilizing RM/Cobol. I utilized Intelligent Query and Access to provide my clients with custom reports. My clients utilized a mixture of terminals and Pcs utilizing Windows for Workgroups, Windows 95 and TCP/IP. Some of my clients were Doorland, Hyseco, Mantane, Racal, and Wesco Industries.

Major Accomplishment(s):

I provided Enhancement and Maintenance Support for a shared Distribution Package for the MCBS Users’ Group.

Platform(s):

Unix on Data General Aviion Platform.

Period: October 1990 - August 1994

Position: Manager, Systems and Consulting

Employer: Health Systems Support Group, Saskatoon, Saskatchewan

Tasks Summary:

I managed the systems and consulting needs for a member organization consisting of approximately 120 healthcare facilities. I managed a staff ranging from a low of 8 personnel to a high of 20 personnel.

I recommended and implemented the new corporate direction.

I co-ordinated two user groups responsible for recommending the replacement Payroll system and common healthcare systems solutions.

I was responsible for recommending a replacement data entry solution that would reduce cost by 50% and drastically reduce the percentage of data entry errors. Providing incorrect payroll cheques for our clients’ staff was a highly contentious issue and was a n for concern. The Group supported applications including Financial Accounting systems, Payroll, CPI/ADT, and Staff Scheduling System. Hardware platforms used were AS/400 and PC LANs, running OS/400 and PC LANs, running OS/400 and Novell Netware. Development software consisted of Cobol, Basic, Cognos Powerhouse and Impromptu.

Major Accomplishment(s):

I recommended a replacement data entry solution that would reduce the cost by over 50% and drastically reduce the percentage of data entry errors. Unfortunately, a bigger organization took over the company and laid me off along with the Executive Director, prior to implementing the solution.

I successfully implemented the new corporate direction, after making the recommendation directly to the Board of Directors.

Platform(s):

AS/400 and PC LANs.

Period: August 1984 - September 1990

Positions: Senior Computer Systems Analyst (1984-1988)

Coordinator, Data Management/System Development (1989)

Supervisor, Application Services (1990)

Employer: Saskatchewan Oil and Gas Corporation, Regina, Saskatchewan

Tasks Summary:

I helped develop, enhance and maintain several financial and management information systems for the Corporate Office. I supervised a staff ranging from a low of 2 personnel to a high of 8 personnel. My staff consisted of programmer/analysts and a data base administrator.

I recommended and implemented the corporate database direction, which was to be based on Oracle.

My team supported applications including HP Financial Accounting, Operations Forecasting, Human Resources, Corporate Well, Public Well, Reserves Information, Hardware Inventory and Marketing Administration. Hardware platforms used were HP3000, HP9000, and Vax, running MPE, Unix and VMS operating systems. Development software used included Cobol, Oracle and Cognos Powerhouse.

Major Accomplishment(s):

I successfully implemented my recommended Oracle Corporate Database Direction.

Platform(s):

Cobol, Oracle and Cognos Powerhouse on HP3000, HP9000 and Vax.

Period: March 1979 - March 1984

Position: Data Processing Manager (1979-1983)

Processing Service /Product Support Manager (1983-1984)

Employer: National DataCentre Corporation (1979-1983), Calgary, Alberta

NDC Computer Services Ltd. (1983-1984), Calgary/Edmonton, Alberta

Tasks Summary:

I managed the services for a Service Provider with approximately 130 clients. I managed a staff ranging from a low of 12 personnel to a high of 34 personnel. My staff complement included data entry, operations, quality control, programmers, and systems analysts.

Our organization offered applications including Financial Accounting systems, Payroll, Accountants’ Work In Progress, Property Management System and Construction Job Costing System. Hardware platforms used were Univac 9480 and Univac 9030, running OS/4 and OS/3. Development software consisted of Cobol and RPG II.

NDC Computer Services Ltd. took over the organization when National DataCentre Corporation went into bankruptcy. I was given the position of Processing Services Manager and asked to combine both the Edmonton and Calgary offices. I successfully completed the operational integration with Edmonton providing all of Alberta’s processing and Calgary simply providing data entry and reporting for their clients. However, the company went into bankruptcy again because the Vancouver and Toronto operations were not as successful in either cutting their costs or increasing their revenues.

Major Accomplishment(s):

I successfully integrated the 2 branches in Alberta (Calgary and Edmonton) into one with the Head Office integrated processing in Edmonton with a satellite office in Calgary providing the Data Entry and output of deliverables. This was done when National DataCentre Corporation went into bankruptcy and NDC Computer Services took over, firing both Branch Managers and the Data Processing Manager of Edmonton and giving me the Processing Service/Product Support Manager position.

Platform(s):

Cobol and RPG II on Univac 9480 and Univac 9030.

Period: 1977 – 1979

Position: Senior Systems Analyst

Employer: Sperry Univac, Calgary, Alberta

Tasks Summary:

I provided pre-sales and post-sales support for the Univac 9000 Series clients. Some of the clients I supported included the City of Medicine Hat, Calgary Herald, Calgary Separate School Board, and National DataCentre Corporation. My Pre-Sales support included responding to RFPs, requirements planning, proposals and presentation to prospective clients. My Post-Sales support included conversion, training, operating system upgrades and on-going technical support.

Major Accomplishment(s):

Successfully converted City of Medicine Hat, Calgary Herald, Calgary Separate School Board and National DataCentre Corporation to utilize Sperry Univac’s 9000 Series Platform.

After the successful conversion of National DataCentre Corporation, I ended up taking over the position of the Data Processing Manager of the Calgary Branch while he joined the Sales Force of Sperry Univac.

Platform(s):

Univac 9480 and Univac 9030.

Period: 1975 - 1977

Position: Programmer Analyst

Employer: Advanced Computer System, Winnipeg, Manitoba

Tasks Summary:

I provided programming support for a Service Provider with approximately 20 clients, including Manitoba Dairy and Poultry, Flyer Industries, and Midwest Detroit Diesel.

I supported applications including Financial Accounting, Payroll, and Bill of Materials. Hardware platforms used were Univac 9480 and Univac 1001, running OS/4 and Assembler. Development software consisted of Cobol and Assembler.

Major Accomplishment(s):

I converted new clients to run on Univac 9480 by programming Applications to run in Cobol. We bought time share to utilize Canada Safeway’s Univac 9480 computer.

Platform(s):

Cobol on Univac 9480

EDUCATION / TRAINING

B.Sc. Industrial Management Engineering

Oracle Database Administration

Oracle Relational Database Design

Oracle Performance Tuning

Cognos Powerhouse Tools

Introduction to Data Warehousing (Informix)

Using Informix Metacube for Data Warehousing

SAS Fundamentals

Productivity Management

Frameworks

Technical Skills Inventory

Hardware/Software

Data General Aviion/DG Unix - 2 yrs

HP 9000/HP Unix - 5 yrs

IBM AIX/AIX Unix – 2 yrs

IBM AS400/OS400 - 4 yrs

IBM Mainframe/TSO-ISPF - 6 yrs

Vax/VMS - 2 yrs

ERP

IFS - 1 yr

MCBA – 2 yrs

TECSYS – 2 yrs

Languages/Tools

CICS - 2 yrs

Cobol - 12 yrs

Cognos Impromptu - 4 yrs

Cognos Powerhouse - 4 yrs

Crystal Report - 3 yrs

DB2 - 3 yrs

Easytrieve - 2 yrs

ETI Extract - 1 yr

Expediter - 2 yrs

IBM JCL - 6 yrs

IMS/90 - 2 yrs

Informatica - 3 mths

Informix - 2 yrs

Intertest - 2 yrs

Microsoft SQL Server – 7 yrs

Microsoft Business Intelligence Development Studio (Integrated & Analysis Services) – 7 yr

Microsoft Management Studio – 7 yr

Microsoft Visual SourceSafe – 7 yr

Oracle Developer 2000 (SQLForms, SQLReportWriter, SQLMenu, PL/SQL, SQL Loader) – 7 yrs

PL1 - 1 yr

Smartest - 2 yrs

Unix Shell - 5 yrs

Methodologies

Keane Productivity Management - 2 yrs

Perform - 2 yrs

Contact this candidate