Manager Data

D ouglas A. Jones

* * ** ******* **, Flower Mound, TX 75022

C ertified BI Architect

* **.***.**** (M) 9 72.355.2502 (H )

d ******@******.***

P ROFILE

I nformation technology professional with 1 2 y ears experience in d ata management, architecture,

d evelopment and delivery of Business Intelligence solutions. Strong background in technical account

m anagement, p roject management a nd resource development, with the capability to manage, design

a nd d eliver a ll components of a D ata W arehouse / B usiness I ntelligence solution .

E xtensive e xperience i n ETL, data mart creation and automation, metadata modeling,

m ultidimensional analysis, managed reporting, adhoc reporting, data visualizations, notifications

/ alerts and balanced s corecards. H ave led successful migrations of enterprise initiatives from earlier

v ersions of the Cognos tools to Cognos 8. H ave consulting background, specializing in analysis, data

m odeling, application development and implementation. C an architect a nd deliver all components of a

b usiness intelligence solution, including data warehouse, reporting and analytics metadata, production

r eports and web portal. Have managed solutions delivery teams a nd delivered solutions as lone

r esource. C ertified throug h Cognos certification program as Solution s A rchitect and c urrently h old 1 0

p roduct c ertifications t hrough Cognos .

S pecialize in project recoveries in which the overall success of a Data Warehouse / Business

I ntelligence initiative is at risk of failure a nd have worked with client executives and development

t eam s t o successfully deliver the solution . Strong proponent of Cognos best practices and proven

t echniques and have created custom solutions methodologies based on the Cognos Implementation

M ethodol ogy, but modified to reflect the specific business needs of the client. H ave created a nd

d elivered custom training for a variety of Business Intelligence tools and have delivered Data

W arehousing “Boot Camps” to other consultant practices.

I n January of 2 005, partnered with former Senior Partner of Bain and Company to create a

p rofessional service s p ractice called Texas Wasatch Development, L.P ., i n the c apacity o f Managing

D irector. Specific responsibilities included hiring, managing and mentoring staff, contract negotiation,

a rchitecting client solutions, s olution development, c lient development, partner development, a nd all

a spects of day to day operations. Became a Cognos partner in June of 2005 and was brought into

C ognos consulting engagements as a s ubject matter expert. S ervices provided included analysis and

d esign of Data Warehouse and Business Intelligence solutions, m anagement of solution delivery,

c ustom training and mentoring other developers. Texas Wasatch Development engagements are

n oted i n the project history below the consulting role in the engagement.

P ROJECT HISTORY

A lcon, Inc., F ort Worth, Texas N ovember 2007 – P resent

B usiness Intelli g ence / Data Warehouse Architect

T exas Wasatch Development, L.P. Contract

B rought into Alcon t o review existing D ata Warehouse and Business Intelligence initiatives for the

I nternational Business Intelligence practice and to recommend methods t o e nsur e c onformance with

b est practices. D elivered proof of concept to demonstrate the viability of the C ognos tools to deliver

r eporting an analytics to a global. Following the approval of the proof of concept by the CIO,

r esponsible for expanding scope of effort to production ready solution that will provide multilingual

r eporting and analytics to affilia tes in over 40 countries w orldwide . Specific responsibilities include:

D elivery of star schema data mart with conformed dimensions, surrogate key substitution

a nd support for T ype II Slowly Changing Dimensions u sing Cognos Data Manager 8.2 .

C reation of me tadata mod els for reporting and analytics using Cognos Transformer 8.2(7.4),

F ramework Manager 8.2.

P reparation of the “Go Forward” plan that would become the model for creating production

r eady solution.

P rovide knowledge transfer and g uidance to manageme nt and team members to ensure use

o f Cognos best practices.

A dditional responsibilities include prototyping alternative s olutions to business problems u sing p roven

p ractices t o p air the best tools a nd methods with each business problem. D ocumented best pr actices

a pproach to a variety of business problems and participated in meetings with delivery teams and

s trategic meetings with management.

I n August of 2008, joined Alcon as a full - time employee and took on added responsibilities, which

i nclude:

F unction a s o ne of four S olutions A rchitects tasked with architecting a nd managing the

d elivery of s trategic g lobal Data Warehouse and Business Intelligence solution s to over 40

c ountries.

F acilitate discussions associated with identification of strategic initiativ es that focus on

s pecific subject areas and functions, but also compliment the vision of an enterprise data

w arehouse characterized by global dimensional conformity.

M anaging Alcon’s Business Intelligence Center of Excellence, w hich is responsible for is t o

p rovide value to the business by moving BI from disparate tactical deployments with

i nconsistent information toward consistent tools, standards, definitions, and policies that

r esult in a trusted source of accurate and relevant information across all fun ctions of the

o rganization.

P rovide ongoing support, knowledge transfer and mentoring to development staff and

s olution support teams.

P rovide organization with insight into emerging technologies that will deliver solutions of

i ncreased business value in t he context of global strateg ic objectives.

T ools Used:

C ognos Data Manager 8. x C ognos Transformer 8. x

C ognos Analysis Studio 8. x C ognos Report Studio 8. x

C ognos Query Studio 8. x C ognos Analysis for Excel 8.x

C ognos Framework Manager 8.x

J uly 2007 – S eptember 2007

T he Hershey C ompany, H ershey, Pennsylvania

B usiness Intelli gence / Data Warehouse Architect Consultant

T exas Wasatch Development, L.P. Subcontract

W orked with The Hershey Company t o create a B usiness Intelligence s olution u sing the Cognos su ite

o f tools SAP BW and Teradata d ata s ources. I nitially, the purpose of this engagement was to optimize

t he existing Cognos implementation following the Cognos sales cycle, in which the performance

d emonstrated during sales meetings was significantly bet ter than was achieved in the production

e nvironment. Following efforts to optimize the solution to the fullest extent, other options were

e xplored, including transferring data from SAP BW into Teradata where the dimensional structure of

t he data is better s uited for high performance BI.

S pecific responsibilities included:

A nalyze and benchmark existing SAP BW reports written with BEX, including creating

d atabase traces that would allow us to understand specific points of r esource usage.

C reate reports com parable in content to the BEX queries using report metadata created

d irectly on top of SAP BW Info Providers and compare contents and database traces to

u nderstand resource usage.

U se ETL processes using Data Manager 8.2 to transform flat file extracts tak en from SAP BW

i nto a format suitable for the creation of a Cognos PowerCube and author reports in Analysis

S tudio 8.2.

P repare documentation providing granular detail of three different approaches and processes

i nvolved with preparing each for user intera ction.

C reate reporting metadata against Teradata database for different approaches to reporting

a nd analysis, including relational modeling and dimensional modeling in Framework Manager

f or reporting and analysis.

A ccomplishments included:

E stablishing s ufficient credibility and proving capabilities of tools to the client to openly

d iscuss an architecture based on the needs of the business, rather than the capabilities (and

l imitations) of a single component (reporting) of a suite of tools capable of func tioning as an

e nterprise performance management solution.

T ools Used:

C ognos Data Manager 8.x C ognos Transformer 8.x

C ognos Analysis Studio 8.x C ognos Framework Manager 8.x

M icron Technologies, B oise, I daho A pril 2007

T rainer to Micron Staff and Me ntor to TWD Consultants

T exas Wasatch Development, L.P. Subcontract

P repared one week training curriculum for Micron IT staff that would be responsible for maintaining

B I solution following production implementation. Curriculum focused on metadata modelin g for

r eporting and analysis using Cognos Transformer and Framework manager. Course content included

a pproximately 375 page M icron branded m anual with hands on demonstrations, workshops at the end

o f each module and PowerPoint presentations for each modul e.

A lso functioned as mentor to two of our consultants that were part of the long term solutions deliver

t eam that included reporting, analysis and balanced scorecarding. The method of mentoring was

p rimarily through Friday meetings in the office, in wh ich we would gather in the boardroom as a team

a nd work together to address specific challenges they were encountering with their assignments at

t he client site.

T ools Used:

C ognos Transformer 8.x C ognos Framework Manager 8.x

U niversal Weather and Avi ation, H ouston, Texas J anuary 2007 – A pril 2007

B usiness Intelligence / Balanced Scorecard / Data Warehouse Architect C onsultant

T exas Wasatch Development, L.P. Subcontract

W orked w ith g lobal trip support services provider, t o assist with the architectur e and delivery of

m ultiple data warehouse, scorecard and performance management initiatives using Oracle, SQL Server

a nd Cognos 8 Business Intelligence Tools. I n addition to solutions design and delivery, responsible

f or knowledge transfer and mentoring o f client staff.

S pecific responsibilities include d :

C omplete delivery of scorecard pilot that had stalled with previous delivery team.

W ork with corporate data architect to design and deliver p roduction executive scorecards and

s upporting Business Intell igence content using ETL, OLAP analysis, reporting and event

d riven alerts.

W ork with data architect to architect and delivery executive dashboard that provides real -

time and near real - time delivery of content and initialization of processes when actiona ble

e vents occur and/or predefined conditions have been met.

C ontinue to mentor and transfer knowledge all project stakeholders on design and delivery of

s olutions using Cognos 8 .x .

T ools Used:

C ognos Metrics Designer 8.x C ognos Metric Studio 8.x

C ognos F ramework Manager 8.x C ognos Transformer 8.x

C ognos Analysis Studio 8.x C ognos Report Studio 8.x

C ognos Query Studio 8.x

C asella Waste Systems, Rutland, Vermont J une 2005 – J anuary 2007

B usiness Intelligence / Balanced Scorecard / D ata Warehouse A r chitect C onsultant

T exas Wasatch Development, L.P. Contract

W orked with leading waste management organization to architect BI solution that includes Balanced

S corecards, Visualizations, OLAP analysis and Reports. I ncluded migration of e ntire performance

m a nagement system to Cognos 8. According to Cognos partner manager, this is the largest balance

s corecard application ever deployed using the Cognos tools.

S pecific responsibilities include d :

W ork with executive team to ensure proper alignment of executio n and strategy that could

b e measured through the corporate performance management system’s presentation of Key

P erformance Indicators.

D esign and d eployed d ata warehouse consisting of 8 subject oriented s tar schema data m arts

u sing c onformed dimensions. F ollowed Ralph Kimball data warehouse methodology.

D eliver B alanced Scorecard application that includes o ver 200 scorecards and 9 8 m etric types

u sing Cognos Metrics Manager.

U se Metrics Designer to configure B alanced Scorecard to source data from OLAP cube s as

o pposed to flat files, which was used previously .

I ncorporate strategy maps and cause and affect relationships between KPIs.

C reate and deploy reporting solution with Cognos ReportNet that includes report design and

a uthoring, advanced prompts and dis tribution strategies (on demand, scheduled, bursting).

D esign OLAP cubes using Cognos Transformer and deploy to the web using PowerPlay

E nterprise Server.

S eamlessly integrate all components of the solution, including BI content integrated into the

B alance d Scorecards, drill through from Visualizations to ReportNet reports .

R emove any dependency on SQL Server DTS jobs to ensure that the entire solution could be

a utomated using only Cognos technology.

D evelop training course, including instruction and works hops and delivered to over 130

m anagers that would be daily users of the system.

P articipate with client and Cognos resources in the sales cycle to ensure proper alignment of

t echnology to business needs.

T ools Used:

C ognos Metrics Designer 7.x, 8.x C ogno s Metric Studio 7.x, 8.x

C ognos Data Manager 7.x, 8.x C ognos Transformer 7.x, 8.x

C ognos Analysis Studio 8.x C ognos Report Studio 8.x

C ognos Query Studio 8.x C ognos Framework Manager 1 .x, 8 .x

C ognos PowerPlay Enterprise Server 7.x C ognos ReportNet 1 .x

C ognos Visualizer Client 7.x C ognos Visualizer Web 7.x

G reen Mountain Coffee Roasters, W aterbury, Vermont M arch 2006 – M ay 2006

B usiness Intelligence Architect C onsultant

T exas Wasatch Development, L.P. Contract

C ollaborative effort with Cognos s ale representative to assist GMCR with the evaluation of Cognos

B usiness Intelligence tools, as part of a broader effort to evaluate Business Intelligence tools by

C ognos, Microsoft and Oracle.

T ools Used:

C ognos Transformer 7.x, 8.x C ognos PowerPlay Ent erprise Server 7.x

P owerPlay Client 7.x

M KS Instruments, A ndover, Massachusetts M ay 2005 – J une 2 005

B usiness Intelligence A rchitect / D ata W arehouse Architect C onsultant

T exas Wasatch Development, L.P. Subcontract

P erformed a naly sis o n e xisting data w arehouse a nd business intelligence initiative and to recommend

m odifications in accordance with best practices.

S pecific responsibilities include d :

P erform analysis on processes associated with data acquisition from legacy systems,

r elational databases an d flat file extracts.

D esign conformed dimension model based on contents of data staged to the operational data

s tore a nd functional use of structural data.

O ptimize D ecisionStream E TL process by reducing processing done on database server and

f ully levera ging transformation capabilities of ETL tool to transform data in memory.

R ecommend modifications to data validation process to leverage data lookups based on pre -

v alidated dimensional data.

U se D ecisionStream t ool to create aggregate tables as necessary.

M odify data warehouse meta data to create database independent metadata, such that the

d ata warehouse can be moved to different database servers with little or no modification to

m eta data.

I ncorporate additional data sources into the data warehouse as par t of migration from legacy

s ystem to O racle environment.

P erform analysis of BI meta data and recommend changes in accordance with proven best

p ractices and to ensure meta data reflects users’ understanding of the business.

T ools Used:

C ognos Data Manager 7 .x C ognos Transformer 7.x

C ognos PowerPlay Client 7.x C ognos PowerPlay Enterprise Server 7.x

C ity of Dallas, D allas, TX J an 2005 – M ay 2005

C ity Hall & Dallas Police Department

B usiness Intelligence / Data W arehouse Architect C onsultant

T exas Was atch Development, L.P. Subcontract

D elivered B usiness Intelligence solutions to the City of Dallas. Complete projects for Dallas City Hall

a nd for the Dallas Police Department.

S pecific responsibilities include d :

A rchitect enterprise b usiness intelligen ce solutions that include a ddressed specific mission

c ritical initiatives for Dallas City Hall and the Dallas Police Department.

S erve as liaison between client and solutions delivery team to ensure that business

o bjectives and technical architecture and d eliverables are properly aligned.

I ncorporate best practices in design and implementation through use of proven methodology

c reated over several years of solutions delivery.

F unction as Business Intelligence / Data Warehousing subject matter expert sub - con tractor

f or consulting organizations that are pursuing enterprise initiatives.

A ccomplishments Include d :

C reation of 911 Call Analysis for the Dallas Police department. Solution was responsible for

d iscovering anomalies that existed in the data, but were n ot known for several years prior to

t he project.

P rovide strategic guidance on development of BI architecture to address immediate needs

a nd long term vision of Dallas Police Department.

D evelop multi - query ReportNet reports for City of Dallas City Manage r and City Department

M anagers.

W ork directly with Citiy of Dallas CIO, Department Managers and Senior Project Managers to

d esign department - specific BI tools, with the intent that these will eventually rollup into an

e nterprise BI implementation.

T ools Us ed:

C ognos Transformer 7.x C ognos PowerPlay Enterprise Server 7.x

C ognos Framework Manager 1.x C ognos ReportNet 1.x

C ognos PowerPlay Add - In for Excel 7.x F ramework Manager

W CI Consulting, D allas, TX S ep 2004 - Dec 2004

S olutions Lead C onsultant

W as hired by current employer to assist in establishing a partnership with Cognos Corporation and

l ead in the development of a Cognos practice.

S pecific responsibilities include d :

L everage existing relationships within Cognos to help organization gain cre dibility as a new

C ognos partner.

S erve as the subject matter expert on strategy, development, and implementation of

C orporate Performance Management, with particular focus on mid - tier organizations not

t ypically considered strong candidates for Corporate P erformance Management.

W ork directly with Cognos to develop co - branded marketing collateral, services messaging

a nd strategy.

A dditional c lient responsibilities include d :

D evelopment of d ata warehouse using Business Objects Data Integrator for E TL process ing

f or international distributor home décor products.

T ools Used:

B usiness Objects Data Integrator

B rierley & Partners, D allas, TX A ug 2003 – S ep 2004

S enior Business Intelligence Architect

H ired to lay foundation of a new Business Intelligence prac tice targeting increased penetration with

e xisting clients and identifying new opportunities for business growth and industry leadership in CRM

m arket and beyond.

S pecific r esponsibilities include d

D evelop Business Intelligence Methodology t hat incorporat es adhoc reports, managed

r eports, OLAP Analysis, visualizations, balanced scorecards, notifications and data

w arehousing.

W ork with partners to develop Corporate Performance Management (CPM) models that

l everaged the Kaplan/Norton methodology of strategy m apping with balanced scorecards and

B I technologies.

F unction as data warehousing architect and subject matter expert for design and delivery of

d ata warehouse initiatives.

F acilitate discussions with clients and delivery team to articulate business need s and

d etermine appropriate technologies to address those needs.

D esign Business Intelligence architecture and deliverables to address short and long term

o bjectives.

A udit of existing BI implementations.

I dentify opportunities for new BI initiatives.

F unc tion as lead Technical Architect f or t eam of 6 B usiness Intelligence developers a nd

a dvisor to Directors, Vice Presidents and the company President f or new Business

I ntelligence initiatives.

I nterview prospective employees for the purpose of gaining a clea r understanding of

c andidate’s use of best practices, industry experience and depth of experience.

F unc tion as subject matter expert and mentor for other Business Intelligence developers.

C ontribute to the Technology Architecture Group, which is responsibl e for all strategic

t echnology decisions related to core l oyalty p latform and service offerings.

A ccomplishments I ncluded:

I dentified need for structured method of BI development, and on own initiative, authored the

B rierley & Partners Business Intellig ence methodology. Built web site to provide remote

a ccess to all components of the methodology, including; document templates for all stages of

p roject development, client presentations, best practices documentation and project

m anagement. Methodology h as b een positioned with clients as a separate purchasable

B rierley tool.

W orked w ith V ice Presidents of Strategy and Analysis to p rovide leadership for co -

develop ment o f u nique messaging of Brierley ’ s approach to Business Intelligence, as a

s trategic value - ad d. Brierley Business Intelligence offering is defined as the union of

s trategy, analysis and enabling technologies. The enabling technologies incorporated in the

s olution include ETL, OLAP, managed reports, adhoc reports, data visualizations, balanced

s cor ecards and a web enabled BI portal.

I dentified significant market opportunity for establishing leadership position in Corporate

P erformance Management implementations.

W orked closely with president of Brierley to define parameters of vision and have cont inued

t o work with Vice President of Strategy to finalize CPM messaging.

F unction ed a s technical lead on s uccessful delivery of $ 3 million data warehousing/BI project

u sing DecisionStream and Cognos BI .

T ools Used:

C ognos Transformer 7.x C ognos PowerPla y Enterprise Server 7.x

C ognos ReportNet 1.x C ognos Alerts 1.x

C ognos Data Manager 7.x C ognos Impromptu Web Reports 7.x

C ognos Impromptu Client 7.x

C ognos Corporation, I rving, TX F eb 2 000 – A ug 2003

B usiness Intelligence Solutions Architect

F o r Cognos Corporation, functioned as Technical Account Manager for the Cognos Partner Channel in

S outh Central Region. Responsible for technical account management of OEM partners, Big 5

C onsultancies as well as technical recruitment of new OEM partners. A l so p articipated in beta testing

o f new Cognos reporting authoring tool, ReportNet.

S pecific responsibilities include d :

P rovide leadership and mentoring to Cognos partners (OEM and VAR) in enterprise BI

a rchitecture.

C onsult with candidate OEM partners to d efine business needs and to architect a solution

t hat addresses short term and long term objectives in a context that compliments OEM

p artner’s product offerings.

F unction as “Data Warehouse Champion” for the western Half of North America, assisting all

e fforts of Partner Channel and OEM team for all initiatives that included a Data Warehousing

c omponent.

W ork directly with the “Enterprise Business Partner Team” to provide mentoring, leadership

a nd guidance to BI implementation teams representing the “Big F ive” consultancies.

D evelop expertise with all Cognos Business Intelligence tools (Impromptu, Impromptu Web

R eports, T ransformer, PowerPlay, PowerPlay Enterprise Server, Visualizer, Visualizer Web

S erver, NoticeCast Authoring, NoticeCast Web Server, Cogn os Query, Architect, M etrics

M anager, U pfront a nd DecisionStream).

E nsure successful development and implementation of Business Intelligence solutions.

A ctivities with OEM partners include d:

S erved as instructor for one week data warehouse “Boot Camp” to a g roup of data

w arehouse developers from Fujitsu consulting in Vancouver, British Columbia.

W orked extensively with some of Cognos’ largest global OEM partners, including SSA Global

T echnologies in Chicago to develop and present CRM messaging, which includ ed development

o f Balanced Scorecards with MetricsManager, OLAP Cubes with PowerPlay, managed reports

w ith Impromptu Web Reports and visualizations with Visualizer.

P rovide leadership / knowledge transfer to OEM partners in architecting and messaging

e nter prise BI solutions.

P articipated in the delivery of solution messaging in national and international local and

g lobal user conferences.

C omplex on - site proofs of concept.

F unction as dat a warehousing subject expert.

T each a nd mentor d ata warehousing admi nistration u sing Cognos DecisionStream.

A ssist in authoring RFPs/RFIs.

M anaging the technical relationship with partners and providing strategic guidance with

r egards to BI content integr ation with product offerings.

R eceived three awards for recognition o f outstanding performance, specifically, these awards are:

R aging Bull Award, awarded at Annual Cognos Kickoff Conference in March 2002 for

e xcellence i n leadership and execution.

R eceived quarter ly A bove and Beyond Award twice for outstanding leadership, c ommitment

a nd execution.

T ools U sed:

D ecision Stream (6.x, 7.x) R eportNet 1.x

I mpromptu (5.x, 6.x, 7.x) I mpromptu Web Reports (5.x, 6.x, 7.x)

T ransformer (5.x, 6.x, 7.x, 8.x) P owerPlay (5.x, 6.x, 7.x)

A rchitect (6.x, 7.x) M etrics Manager 2.x

P owe rPlay Enterprise Server (6.x, 7.x) C ognos Query (6.x, 7.x)

P owerPlay Add - In for Excel F ramework Manager (1.x, 2.x, 8.x)

S ierra Systems Consultants Inc., E dmonton, Alberta M ay 1998 – F eb 2 000

S ystems Analysis, Design and Development C onsultant

F or A lberta Learning, participated in the L abor F orce Statistics Re - Development Project (LFS). The

g oal of the L abor F orce Statistics Re - Development project was to convert a manually intensive system

t hat relied solely on flat data files to a highly automated s ystem that follows a relational paradigm

w ith cutting edge reporting tools.

R esponsibilities for this project inc luded:

D eveloped flat file format used by Statistics Canada to prepare raw data file of national

e mployment sta tistics for Alberta L earning.

D erived logical d atabase m odel from existing system reports (the old system did not use the

r elationa l model for data management).

C reated LFS Reports Impromptu catalog that functioned as metadata for the LFS Reports

P owerPlay cube and the data source f or a dhoc Impromptu reports.

C reated Readers Impromptu catalog that was used to produce all material required for the

d istribution of the LFS reports and f or adhoc Impromptu reports.

D eveloped and optimized LFS Reports Cognos Transformer model and th e LFS Repor ts

P owerPlay cube.

D e veloped 160 separate PowerPlay canned q ueries using the PowerPlay client for Excel. The

u se of the Excel client made it possible to produce new high performance reports that

m atched the format of the original APL reports (i.e. An Excel f ile containing 40 references to

t he LFS Reports cube requires approximately 90 seconds to automatically refresh against the

l atest build of the cube versus approximately 2 hours to run the same independent queries in

I mpromptu.).

F or Advanced Education a nd Career Development, participated in the development of the Intellectual

I nfrastructure Partnership Program Reporting System (IIPPRS). The goal of the IIPPRS project was to

p rovide members of the Intellectual Infrastructure Partnership Program with a me ans of recording

d etails of proposals submitted by research institutes requesting government funding. The purpose of

t he system is to assist in the decision making process for determining which projects would receive

f inancial assistance and to track how t he government funding was utilized over the life of the project.

R esponsibiliti es for this project included:

A nalysis of proposed data model relative t o the corporate data model.

C reating a logical data model that incorporated aspects of the corporate mod el and all

a dditional d atabase o bj ects required for the system.

G enerating the physical d atabase f rom the logical data model using the most rec ent release

o f Designer 2000.

C reating system pre - generation system modules that were subsequently generated into

a pplication screens, m enus and function libraries.

U sing Developer 2000 to make post - gener ation changes to the windows.

C reating Impromptu catalog as the foundation for PowerPlay repo rts.

C reating PowerPlay cube and eight c anned r eports that serve as a st aring point for c ustom

a nalytical reporting.

C reating user interface for accessing PowerPlay reports using Cognos Portfolio. - C onducting

t esting/training workshops for the IIPPRS application and u se of the PowerPlay reports.

P reparing technical documentat ion, user manual, online help and training material user

c ommunity.

T esting and implementing the system.

T ools U sed:

I mpromptu (5.x) I mpromptu Web Reports (5.x)

T ransformer (5.x) P owerPlay (5.x)

P owerPlay Add - In for Excel

E DUCATION

D eVry Institute o f Technology 1 0/1995

B achelor of Science Degree

M ajor: Computer Science

G PA: 3.89 /4.00

S umma Cum Laude

C ERTIFICATIONS

C ertified Cognos Business Intelligence Architect

C ognos ReportNet R eport Author

D ecisionStream Product Professional

I mpromptu Prod uct User

P owerPlay Product User

I mpromptu Product Professional

I WR Product User

I WR Product Professional

P owerPlay Product Professional

A ccess Manager Product Professional

T OOLS

D ata Manager (8.x)

M etric Studio ( 8.x)

M etrics Designer (8.x)

A nalysis Stud io (8.x)

R eport Studio (8.x)

Q uery Studio (8.x)

D ecision Stream (6.x, 7.x)

R eportNet (1.x see also Report Studio and Query Studio)

I mpromptu (5.x, 6.x, 7.x)

I mpromptu Web Reports (5.x, 6.x, 7.x)

T ransformer (5.x, 6.x, 7.x, 8.x)

P owerPlay (5.x, 6.x, 7.x, 8. x)

A rchitect (6.x, 7.x)

M etrics Manager (2.x, see also Metric Studio)

P owerPlay Enterprise Server (6.x, 7.x)

C ognos Query (6.x, 7.x)

P ROFESSIONAL COURSES

I mplementing and Maintaining Microsoft SQL Server 2008 Integration Services

D ecisionStream (6. x, 7. x)

A dvanced DecisionStream – D ata Warehouse Workshop

A dvanced DecisionStream – B est Practices and Implementation

D ecisionStream 7.0 MR2

C ognos ReportNet – I nternal Training a nd Member of Internal Beta Testing Team

C ognos Metrics Manager – I nternal Training a nd Public Classes

C ognos Introduction to PowerPlay (5.x)

C ognos PowerPlay Data Exploration (6.5)

C ognos Report Building with PowerPlay (6.5)

C ognos PowerPlay Administration (5.x, 6.5)

C ognos In Depth PowerPlay (6.6)

C ognos Report Building with Impromptu ( 5.x)

C ognos Advanced Impromptu Reporting (5.x)

C ognos Impromptu Administration (5.x)

C ognos Query “End to End”

C ognos KPI Business Pack (1.0)

C ognos Analytical Applications

P artner Architect (6)

I n Depth Impromptu Web Reports (6.0)

P roject Management Skil ls

R equirements Analysis Overview

D ata Modeling

O racle Designer/2000 System Modeling and Tools

Contact this candidate