John F. White

**** *. **** **.

Tulsa, OK *****

918-***-****

ac7l4u@r.postjobfree.com

PROFILE

Senior Business Intelligence consultant with nineteen years in the IT field, fifteen years dedicated to BI systems design, administration, maintenance, and content development. Fully trained and qualified in Business Objects Enterprise, Crystal Reports, Web Intelligence, Universe design, Dashboard design, SQL development, and database administration.

CERTIFICATIONS AND ACCREDITATIONS

BECP (Business Objects Certified Professional), Business Objects Enterprise XI R2 and XI 3.x

BECP (Business Objects Certified Professional), Crystal Reports XI and 2008

Business Objects XI R2 Migration Specialist

Business Objects Demo Validated

EDUCATION AND TRAINING

Web Intelligence XI

Advanced Web Intelligence

Universe Design

Advanced Universe Design

Xcelsius Core and Connectivity

TECHNICAL SKILLS

Business Intelligence: Business Objects Enterprise XI R2, XI 3.1, BIP 4.x, Crystal Enterprise 8.5/9/10, Seagate Info 7, Web Intelligence, Universe Designer, Infoview, Live Office, Xcelsius

Databases: Oracle 7/8/9, SQL Server 7/2000-2012, Pervasive, DB2, Informix, Access

Server Operating Systems: Windows Server 2000-2008, Red Hat Enterprise Linux 5.3

Languages: Transact-SQL, PL/SQL

ETL Tools: SQL Server DTS 2000/7.0, Business Objects Data Services

EXPERIENCE

Oklahoma State University Medical Center Tulsa, OK (2011 - Present)

Business Intelligence Architect

Creation of business intelligence environment from the ground up, including building and populating data warehouse, building universes, Crystal and Web Intelligence reports, dashboards, and reporting portal.

Assist in migration of data from legacy systems to new clinical system (Meditech 6).

Train junior developers in report creation and delivery.

Regional Medical Laboratory Tulsa, OK (2009 - 2011)

Information Analyst III

Create and improve existing Desktop Intelligence, Web Intelligence, and Crystal reports.

Integrate new Business Objects products, such as Xcelsius and Live Office, to BI arsenal.

Created curriculum and taught class in SQL for Report Developers to department of 10.

Identify opportunities for labor and/or cost savings utilizing report automation.

Advise on potential changes to data warehouse schema.

CNE, Inc. Haddonfield, NJ (2005 - Present)

Business Objects Consultant

Teach Crystal Reports and Business Objects Enterprise classes for Business Objects Gold Partner.

Install and configure Business Objects Enterprise for clients on Windows and Linux platforms.

Create Crystal and Web Intelligence reports, Xcelsius dashboards, and universes.

Configure Business Objects applications and perform database migrations for clients.

Perform demos for potential clients.

GDH Consulting Tulsa, OK (2007 - 2008)

Consultant

Contract position for St. John Health System.

Administer remote hosted Business Objects Enterprise solution.

Train users and developers.

Develop content, dashboards, and universes.

Advise on data warehouse architecture.

Consultant

Contract position for Williams Energy.

Architect Business Objects Enterprise for company-wide rollout to 4000 users.

Create and maintain security model compliant with SOX and FERC regulations.

Mentor developers in each business unit.

Oaktree Consulting Tulsa, OK (2006 - 2007)

Consultant

Contract assignment for ONEOK.

Create Crystal reports, stored procedures, and SQL scripts as needed for new enterprise application.

Saint Francis Heart Hospital Tulsa, OK (2005 - 2006)

Senior Database Analyst

Design and deliver reports for one of the world’s most advanced digital cardiac hospitals.

Design and implement data warehouse to enhance reporting efficiency.

Install and configure Business Objects Enterprise XI for web based delivery of report content.

Cendant Corporation Tulsa, OK (2004 - 2005)

Database/Reporting Analyst

Design SQL Server based data warehouse for car rental reservations and revenue data.

Write stored procedures to generate data for internal and external reporting requirements.

Replace outdated Excel based reports with more efficient SQL and/or Crystal Reports based versions.

Alliance Data Systems Tulsa, OK (2004 - 2004)

Programmer/Analyst (Contract Position)

Design Oracle stored procedures and functions to facilitate complex reporting requirements.

Format and distribute reports using Visual Basic for Applications.

Appointed to team responsible for expediting projects for company’s largest client.

Matrix Service Company Tulsa, OK (1999 - 2003)

Information Architect

Create Crystal reports and queries for of information from Oracle and SQL Server databases.

Install, configure, and maintain Seagate Info software for deployment of enterprise reporting solutions.

Create stored procedures, functions, OLAP cubes, web pages, and Visual Basic applications as needed.

Design databases and application interfaces for secure access to company data.

Migrate data from legacy systems into Oracle and SQL Server databases.

Profiled on Crystal Decisions web site for innovative use of Seagate Info solutions.

Contact this candidate