President and Senior Consultant, Server-Centric Solutions Inc.
Toronto, Canada Area
- Current
-
- President and Senior Consultant at Server-Centric Solutions Inc.
- Past
-
- ETL Consultant at Alberta Services
- Consultant at Pfizer
- President and Lead Architect at Canadian Information Systems Inc.
- Assistant Controller, Financial Systems at Princess Margaret Hospital
- Assistant Controller at Extendicare Inc.
- Education
-
- Concordia University
- Recommended
-
10 people have recommended Jim - Connections
-
38
connections
- Industry
- Information Technology and Services
- Websites
Jim Spraggett’s Summary
I am a Senior Consultant with twenty years of experience developing systems for Manufacturing, Retail, Pharmaceutical, Government, and Hospital organizations.
I have focused primarily on the implementation of systems based on Oracle and SqlServer.
For example,
ETL and Data Warehouse Systems - Pfizer's Global Financial Warehouse;
Financial Systems – Ecommerce for Grand&Toy, Billing for Princess Margaret Hospital, GL and AP for Stratford General Hospital, Payroll and Human Resources for Extendicare;
Government Systems - AP and a specialized Paramedic System for the Ministry of Health, Case Tracking for the Ministry of Labor, and Patient Care for Kitchener Waterloo Hospital;
I have extensive experience in the Analysis, Design, Development, and Implementation of Data Warehousing solutions using the latest ETL and Data Modeling tools. I have worked with the two leading ETL tools, Informatica and Sagent. I am currently a member of the Informatica Devnet Developers Group and have hands-on experience with Informatica 8.1.1.
I have led many projects from their initial conceptual design phase through to their successful implementation. I promote team co-operation, effective communication between team members, users and management, reusability in building blocks of codes, system ownership, and a structured approach to system design and implementation.
Jim Spraggett’s Specialties:
Data Warehousing Consultant, ETL Developer ( Informatica, Sagent, VB, PL/SQL ), E-Commerce Designer/Developer, Data Architect, System Architect, Project Manager, Oracle / SqlServer Developer, .Net Developer ( C# , VB.net )
Jim Spraggett’s Experience
-
President and Senior Consultant
Server-Centric Solutions Inc.
(Computer Software industry)
April 1988 — Present (21 years 4 months)
Server-Centric Solutions is a consulting company that specializes in the Design, Development and Implementation of quality database driven appplications. These include transactional and datawarehouse systems.
Oracle is our preferred database. In the ETL / DWH world, Informatica is our preferred ETL tool. C# is our language of choice. -
ETL Consultant
Alberta Services
(Government Administration industry)
October 2007 — December 2008 (1 year 3 months)
In the role of an ETL Informatica Developer, my mandate was to build an ODS and DWH to facilitate the reporting of vehicle registration data that was stored in their Adabas Mainframe.
This data was extracted to Oracle and SQLServer databases. The ETL tool was Informatica. The reporting tool was Cognos. -
Consultant
Pfizer
(Public Company; 10,001 or more employees; PFE; Pharmaceuticals industry)
February 1999 — August 2007 (8 years 7 months)
Pfizer’s Global Financial Warehouse
As a hands-on Project Manager / Lead Developer, I was responsible for the Financial Project Code subject area of the Global Financial Data Warehouse.
This included project management activities, the development of ETL mappings, and data migration and cleansing activities. I worked with the Informatica and Sagent ETL tools on SqlServer and Oracle databases.
Special Projects:
I participated in the POC (Proof of Concept) study to choose the best ETL tool for Pfizer. I co-wrote the POC document. Informatica was recommended and selected.
I was the Project Manager / Lead Developer on a special project that was asked to demonstrate the feasibility and advantages of integrating the Japan financials into Pfizer’s Global Data Warehouse. -
President and Lead Architect
Canadian Information Systems Inc.
(Privately Held; 1-10 employees; Computer Software industry)
April 1988 — October 1996 (8 years 7 months)
Grand & Toy Limited August 1993 – August 1998
Designed and implemented Internet Ordering system. Developed Orderpoint system using PowerBuilder.
Livingston HealthCare October 1997 – June 1998
Developed secure Electronic Ordering system “ProCure”.
Bureau of Broadcast Measurement August 1992 – August 1993
Managed data architecture using Oracle Case. Developed SqlForms and PowerBuilder applications.
Domtar Packaging December 1990 – June 1992
Lead Architect. Converted Legacy App into Oracle.
Others
Group Leader / Developer re Case System for the Ministry of Labour.
Developer re the ADP Accounts Payables System using Oracle, for the Ministry of Health.
Project Manager re the development of the Oracle GL and AP systems for Stratford General Hospital.
Developed system for the Oracle for Ministry of Health, Ambulance Services Branch. -
Assistant Controller, Financial Systems
Princess Margaret Hospital
(Government Agency; 501-1000 employees; Hospital & Health Care industry)
May 1984 — June 1986 (2 years 2 months)
I was hired to manage the Doctors Billing and the Patient Care Billing departments (approx. 20 staff with 2 supervisors); and to replace the hospital's financial systems.
To this end, Oracle was purchased and a new Oracle based doctors' billing system was designed and implemented. On this project, I wore 3 hats: System Owner, Oracle Developer, and DBA. -
Assistant Controller
Extendicare Inc.
(Public Company; 1001-5000 employees; Hospital & Health Care industry)
May 1982 — May 1984 (2 years 1 month)
Another dual role position.
On the IT side, I was responsible for the implementation of a new Human Resource package to administer the organization's Benefit and Payroll requirements. The MSA package was purchased and implemented successfully.
On the Accounting side, I was responsible for the management of the Payroll and Benefit departments.
Additional Information
Jim Spraggett’s Websites:
Jim Spraggett’s Interests:
Everything IT, Chess, hiking, camping, old motorcycles, target practice
Jim Spraggett’s Groups:
The Internet Chess Club, Ajax Rod and Gun Club
-
Business Intelligence Professionals
Jim Spraggett’s Honors:
2002 Pfizer Chess Champion (Groton / New London sites, Connecticut)
