Manager Project

Davina R Thompson

* ****** **** ****: 317-***-****

Bella Vista, Arkansas 72715 ********.******@*****.***

summary

A logical and hardworking information technology professional with

extensive experience in dashboard, scorecard and report development,

database administration, project management, data analysis,

implementations, IT security, hardware/software, help desk operations,

and end user support. Implements new systems to create actionable

information. Oversees concurrent tasks to maintain smooth operations.

An innovative thinker who leverages keen eye for detail to ensure

accuracy, securing lasting success and prosperity for an enterprise.

computer skills

Expert: Cognos BI, MS Office Suite, ETL Tool Decision Stream, Visio

Intermediate: Oracle BI, BRIO, Crystal Reports, Erwin, MS SQL, Oracle

Brief: Informatica, Teradata, DB2

experience

D&H Distributing, Harrisburg, PA

Business Intelligence Consultant May 2009-Current

. Evaluate data warehouse and current ETL, produce change documentation.

. Produce BI Vision, Strategy and Plan documentation with target completion

dates.

. Develop and implement appropriate governance, policy and procedure.

. Interview stakeholders, develop gap analysis.

. Provide standard naming conventions, dashboard layout, and standard

report layouts.

. Design and develop reports, cubes and dashboards for initial

implementation.

. Provide reporting solutions for various customer classes including E-

Commerce, Retail, Key Accounts, Govn/Ed Res, DMR, etc

. Provide Profitability Dashboards; include Cost-to-Serve

Technical Environment: MS SQL 2005, Cognos 8.3 converting to 8.4

(Feb,2010), Framework Manager, Report Studio, SQL, Analysis Studio, data

modeling

Walmart Bentonville, Arkansas

Senior Strategy Manager, Business Intelligence April 2008-April 2009

. Led Business Intelligence initiative for US Innovation department.

. Acted as point of contact for customer initiative groups/business units,

information systems associates, and consulting firm hired to develop

Oracle BI business/presentation layers.

. Facilitated interviews as well as JAD sessions and made key contributions

to processes.

. Developed standard attributes, naming conventions, and presentation

layouts.

. Introduced core foundation data approach for company data warehouse,

laying out data necessary for hierarchy structures and reporting.

. Guided ISD, business associates, and upper management in multiple areas

in new business intelligence process.

Technical Environment: Teradata, DB2, MS SQL 2005, Oracle, Informix,

OBIEE/v10, Queryman, SQL, MS Project, MS Office, Clarity, VISIO, Access,

Excel, IBM WebSphere, Star schema and dimensional modeling

Klipsch, Inc Indianapolis, Indiana

Senior Business Intelligence Specialist March 2007-March 2008

. Held responsibility for creating enterprise data warehouse able to manage

multiple currencies and languages, setting up dashboard for global sales

division and providing reporting to sales/finance departments.

. Created base for enterprise data warehouse similar to dimension database,

hiring contractor to code ETL using MS SQL 2005.

. Analyzed sales data and developed business layer in Cognos Framework

Manager, creating star schemas for reporting and set up packages for

multiple teams by geography. Oversaw project security.

. Completed enterprise dimension and sales data storage/reporting. Created

sales dashboard using Cognos Report Studio in Cognos Connection.

. Presented first demo to company and sales executive management,

displaying recent data as well as month-over-month, quarter numbers to

date and information in different currencies to enable communication with

diverse parties.

Technical Environment: MS SQL 2005, MS SharePoint, Navision, ROI, JDE,

Cognos8 to 8.3, Framework Manager, Report Studio, Query Studio, Cognos

Connection, Active Directory, SSIS, BIDS, SQL, MS Office, MS Project,

VISIO, Access, Excel, Kimball, Star schema and dimensional modeling

SIMON Property Group Indianapolis, Indiana

Senior Business Intelligence Specialist July 2004-March 2007

. Led BI specialists, setting standards, creating business/presentation

layers, and developing standard reports.

. Contributed to production of standard reports for lease and accounting

departments. Worked closely with DBA, ETL team, and business customers

to create accurate and timely standard reports.

. Developed company data warehouse (CDW). Provided consolidated data from

disparate systems.

. Designed data mart, technical lead, Framework modeler, and report

developer for new applications, including sales, general ledger

transactions, and inventory/PO applications.

. Documented core applications, defining fields stored in CDW. Developed

metadata repository with One Source of Truth concept. Created ad-hoc

reporting environment and training materials.

. Generated standard company reports in HTML and PDF formats. Developed

dashboards for upper and mid-level management. Trained IT personnel on

BI reporting tool.

. Created and maintained Framework Manager models. Developed and migrated

new reporting environment, replacing Notes database and reporting.

. Interviewed business owners, gathering requirements for reporting needs.

Managed business owner expectations.

Technical Environment: DB2, MS SQL 2005, JDE, PeopleSoft, Cognos Decision

Stream, Cognos8 to 8.3, Framework Manager, Report Studio, Query Studio,

Analysis Studio, PowerPlay, Transformer, Active Directory, SQL, Lotus

Notes, Excel, Access, Visio, MS Project

Independent Contractor Indianapolis, Indiana

Contractor January 2003-July 2004

. Coordinated project management.

. Developed Impromptu reports, catalog administration/development.

. Conducted Cognos training at client site, including Impromptu, Impromptu

Administration, IWR Administration, IWR Server Administration, PP

Exploration, and Report Building.

. Performed training for PP Transformer OLAP Modeling, PP Advanced

Administration, PP Enterprise Server Administration, and Access Manager

Administration.

Technical Environment: Oracle, Cognos 7 to 8 (Conversion), Impromptu

Catalog to Framework Manager, Impromptu to Report Studio, PowerPlay,

Transformer, SQL, MS Office, MS Project, Visio, Excel

tRAVELOCITY.COM Fort Worth, Texas

Manager, Business Intelligence June 2002-December 2002

. Sabre buyout resulted in BI Team layoffs.

. Managed team of 15 direct reports in four locations.

. Built creative dashboards for top advertisers - Pixel location on

window; how does that relate to sales.

Technical Environment: Teradata, Perl, Cognos Series 6 to Series 7

(Conversion), Impromptu Catalog and reporting, PowerPlay, Transformer,

SQL, MS Project, Visio, Erwin, Access, Excel, WORD

CISGI Carrollton, Texas

Senior Front-End Developer August 2000-June 2002

. Served as developer, analyzing existing data marts, creating as well as

maintaining reporting standards, and overseeing document process.

. Led data warehouse development and production support for existing

warehouse. Analyzed existing data marts, source systems, and

business/technical needs to deliver solutions.

. Created Impromptu reports and PowerPlay cubes, distributed on web,

performing management and client reporting using Cognos Series 6.

. Managed financials, geographical, statistical, productivity, on-demand,

custom, and scheduled reporting. Acted as administrator of Cognos

catalog and project lead for converting clients.

. Worked closely with data modelers and DBAs to ensure best practice for

reporting needs. Acted as Impromptu catalog administrator. Served as

technical and user documentation writer.

. Developed and maintained reporting standards. Mentored new business and

technical team members. Acted as project lead for converting clients

and adhering to Life Cycle methodology.

. Oversaw data warehouse development and production support of existing

warehouse. Obtained knowledge of liability and workers' compensation

business rules. Created new Impromptu reports for new clients.

. Led major conversion initiatives to pull additional source systems into

warehouse. Conducted performance modifications to standard and custom

Impromptu reports.

Technical Environment: Oracle, Cognos 6 and 7, Impromptu Catalog,

Impromptu reports, Cognos Query, Cognos Architect, Cognos Noticecast,

PowerPlay, Transformer, SQL, MS Office, MS Project, Visio, Excel, WORD,

Kimball methodology

Citizens Communication Plano, Texas

Senior Systems Analyst September 1999-August 2000

. Conducted analysis, conversion, and reporting for company.

. Contributed to senior management reporting project, analyzing existing

accounting reports, map reports to 14 revenue systems, and SAP expense

feeds.

. Worked closely with in-house and third-party systems. Created data

mart, Oracle, feeding Essbase cube used to produce AlphaBlox reports.

. Completed system rewrite for work force management replacement project.

Analyzed customer, WFM, and operational data. Created data marts with

custom reports for specific business units using BRIO 6.0.

Technical Environment: Oracle, Essbase, AlphaBlox, Brio, SQL, Erwin, MS

Office, MS Project, Visio, Excel, WORD

Sprint Irving, Texas

Project Lead March 1997-September 1999

. Analyzed existing billing systems, MPS/IPS, creating solutions to future

needs addressed by marketing as well as oral and written communications.

. Contributed to feasibility, requirements, and design sessions with major

business groups. Focused on new business requirements. Acted as

liaison between marketing and developers.

. Completed necessary documentation, including functional specifications

and forms to elevate project to next appropriate level.

. Led inception through implementation and managed customer expectations.

. Trained new employees and consultants on systems as well as procedures.

Technical Environment: COBOL, SQL, Erwin, MS Office, MS Project, Excel,

WORD

Additional Experience

AMS, Inc, Albuquerque, New Mexico, Business Analyst, Developer, 1996-

1997. Performed analysis, database design, facilitation, and

documentation. Analyzed child welfare, care, and support systems for

New Mexico. Oversaw database front-end design, develop forms, and

reports. Used Sybase 11 and PowerBuilder 4.0.6 with MicroFocus COBOL

for batch/conversion programs. Facilitated requirements and design

sessions. Documented requirements. Produced operations and end user

manuals.

Technical Environment: Power Builder, WORD, Excel, MS Project,

MicroFocus COBOL, Sybase

El Paso Natural Gas, Inc, El Paso, Texas, Senior Analyst, Developer,

1990-1996. Converted pipeline scheduling system from Wang/PACE

environment to client/server using Erwin, Sybase 10, and PowerBuilder

4.0.3. Worked closely with in-house users to develop menus, online

forms, display windows, and modification windows with Power Script

edits for internal/external applications. Created test criteria using

SQA Team Test. Trained schedulers to ensure ongoing tests using

Impromptu for reporting needs. Developed Power Builder/Impromptu

reports for audit management and scheduling.

El Paso Natural Gas and Galey & Lord, El Paso, Texas, Contract

Programmer, 1990-1992. Developed Pipeline Scheduling system in

Wang/PACE using COBOL, HLI, and Procedure language. Created project

time line, documented procedures, developed programming standards,

named standards, and performed operation backup schedules in textile

manufacturing plant.

Motel 6, LLP, Dallas, Texas, Senior Analyst, Developer, 1987-1990.

Moved company headquarters from Santa Barbara, California to Dallas,

Texas. Acted as Wang/Pace expert. Converted mainframe payroll system

to Wang/PACE environment. Led initiative to create and implement

correspondence system, enabling marketing to enter customer

names/addresses quickly, scan letter/enter codes specific to

concerns/interests, and generate responses. Created database, entry,

and modification windows/reports for budget department.

National FSI, Dallas, Texas, Analyst, Programmer, 1983-1986. Developed

and maintained benefits software using COBOL/Procedure language in

Wang environment. Contributed to customer service help desk,

including hardware and software support.

Technical Environment: (through El Paso Natural Gas) WANG VS, COBOL,

Host Language Interface (HLI), Procedure Language, MicroFocus COBOL,

PACE (Professional Application Creation Environment), SQA Team Test,

Power Builder, Cognos Impromptu

Certification

IT Certification, Texas Institute, 1983

Contact this candidate