Summary John Dempster is a Data Warehousing professional with focus on delivery of high-capacity information applications. He has been instrumental in incorporating state-of-the-art technologies effectively and efficiently, meeting and exceeding project goals, and has extensive experience with the full life cycle of information technology projects. Veteran systems architect with expertise in coding, application design, defined architectures and successful project leadership. Systems architect with expertise in requirement gathering and analysis, architectural, component and interface design and development for web-based applications in multiple domains.
Expert in Java, PHP and Perl
Excellent problem-solving abilities
Windows and Linux
Technical specifications creation
Excellent communication skills
Excellent diagnostic skills
02/2013 to Current
Principal Business Intelligence Consultant
Facilitated proof-of-concept of KliqMap (QlikView extension) by providing guidance on installation, configuration and usage to client internal staff Designed and implemented changes to data model, ETL and user interface for multiple QlikView applications to extend and reconfigure functionality Performed impact assessment on multiple QlikView applications for four major development projects Designed and benchmarked solution for capturing national data within reduced QlikView documents Designed and implemented NPrinting solution (QlikView extension) to automate the production of 250 PowerPoint reports for sales and marketing team resulting in a savings of 120 person-hours per month.
01/2011 to 01/2013
Lead the design, implementation, and maintenance of ETL processing supporting PRA Enterprise Data Warehouse, Revenue system, PMO Resource Allocation analysis, and client extracts Lead the design and implementation of data model enhancements to dimensional Enterprise Data Warehouse Design and implement business and presentation layers of subject areas in Oracle Business Intelligence Regularly consult with internal users to gather requirements and design solutions to identify opportunities for both operational and strategic improvement Re-designed existing ETL processes to improve performance resulting in a reductions in runtime up to 93% Trained ETL developers with respect to both dimensional data model design and "best practice" use of Informatica Championed the use of staging processes, master workflows, and consolidation of code onto a single platform to promote data consistency across the warehouse as well as improved performance of nightly workflows Responsible for planning and implementation.
01/2008 to 12/2010
Business Intelligence ConsultantResolvit Resources at CISCO Systems
Designed, implemented, and maintain full Siebel Analytics implementation including data model design, ETL, and presentation to provide analytics for Know The Network initiative Designed and implemented multiple QlikView applications to enable Global Theater Operations teams to perform ad hoc research on the full Cisco installed base Designed and implemented sourcing strategy to create a common QlikView data model used to populate all QlikView applications Responsible for the design and implementation of enhancements to web-based contract management application serving over 200 stakeholders in more than 150 countries Designed and implemented process to create and publish monthly SCM Dashboards resulting in a 96% reduction in processing time Designed and led execution of proof-of-concept effort to compare functionality of QlikView against Oracle Business Intelligence with respect to SCM business requirements Performed ad-hoc contract and customer analysis for special reporting projects as needed.
06/2007 to 01/2008
Senior ManagerFidelity Investments
Managed and mentored development team of 5 employees responsible for maintenance and implementation of new functionality for FESCO Marketing Data Warehouse.
Performed data model design for all new enhancements.
Created and maintained all release schedules.
Defined development processes and standards.
11/2005 to 06/2007
Development Team LeadBlue Cross Blue Shield of North Carolina
Team Lead for a team consisting of two full-time and three contract resources Served as technical resource for questions regarding Ab Initio functions, component usage, and graph efficiency Defined, designed, and implemented dimensional data structure holding member eligibility information for the Enhanced Eligibility Initiative, Blue Exchange, and CAQH (Council for Affordable Quality Healthcare) reporting Participated in and oversaw design of ETL for eligibility database Developed transformation and load processes for inbound data for Blue Health Intelligence project Designed and implemented extract process to provide data to external vendor for financial recovery of claims paid after policy expiration Designed and implemented extract process to provide data to the Blue Cross and Blue Shield Association for the Blue Health Intelligence initiative Designed and implemented processes to load member, group, product, and provider information to Corporate Data Warehouse Designed and implemented.
07/2004 to 11/2005
Senior Analytics Developer
Designed, implemented, and maintained Supply Chain Analytics application including database schemas and ETL processes.
Liaison to Professional Services Team to define requirements for new implementations and individual customer modifications.
Performed pre-sales demonstrations and post-sales training for Supply Chain Analytics application as needed.
02/2002 to 11/2005
Senior Application Developer
Performed analysis, design, implementation, and maintenance of web-based Supply Chain Management application Created core application module to produce customer internal and external documentation (invoices, packing lists, etc) Integrated third-party scheduling package with existing Track & Trace application to provide for the scheduling of user reports and internal batch jobs Designed and implemented Data Quality module of Track & Trace application Designed and implemented modifications to inbound and outbound messaging module to allow customer trading partners to create EDI message sets through web interface Solely responsible for ongoing design and development of internal application suite designed to improve the speed and quality of initial and ongoing customer configuration.
03/2001 to 02/2002
Technical Product Manager
Managed team of three developers for project to facilitate the negotiation and award of service contracts between shippers and ocean carriers.
Elicited and documented software requirements for new product offerings.
Assisted with existing customer projects, new business efforts, and system demonstrations as needed.
06/2000 to 11/2005
Management Dynamics, Inc
06/2000 to 02/2002
Project Manager / Release Manager
Developed, implemented, and maintained requirements gathering and documentation procedures as well as application release procedures that defined software release inputs and quantified release planning.
Elicited and documented software requirements for the implementation of new clients.
Performed analysis and documented requirements for multiple internal and external projects.
Performed consulting and documented business requirements for custom application enhancements for the world's largest retailer.
06/1997 to 08/2000
Earned graduate degree at North Carolina State U
06/1995 to 06/1997
Assistant Vice-President / Accounting OfficerFirst Citizens Bank
Managed all aspects of eleven member accounting group supporting the periodic processing of over 200 defined contribution retirement plans.
Defined department work flows and procedures.
Provided consulting services to new corporate retirement plan customers.
Served as team technical resource for both accounting activities and securities valuation activities.
09/1993 to 05/1995
Special Projects CoordinatorINVESCO Retirement Plan Services
Defined requirements for multiple modules of new accounting system, including stock accounting module.
Responsible for new customer implementations and data conversions.
Provided consulting services to new corporate retirement plan customers.
Supported external business process reengineering consultants.
12/1990 to 08/1993
Special Projects CoordinatorWachovia Bank of North Carolina – Winston-Salem, NC
Completed Management Training program.
Performed plan processing and accounting system programming for new and existing customers.
Presented fund accounting concepts to consultants and prospective customers.
BA: EconomicsUniversity of North Carolina - Chapel Hill
Master of Science: Computer Science North Carolina State University - Raleigh, NC