Data Warehouse

Alice A. Steinke

*** **** **** **** 602-***-****

Phoenix, Arizona 85021 ************@*.***

Business Intelligence Specialist / Data Architect

Results oriented Business Intelligence specialist with outstanding record

of implementing new business concepts and delivering innovative business

solutions with a strong emphasis on risk management alternatives. Effective

leader and contributor for BI teams through all phases of large-scale BI

roll out including management, cost analysis, planning, vendor selection,

software/hardware acquisition, data architecture, database management, ETL,

reporting and overall utilization of the BI experience. Proven abilities

in Data Mining, Statistical Analysis, Geo-demographic and Demographic

analysis.

Skills

. Hardware: IBM Mainframe: DOS, OS, MVS, AS400, AiX, Teradata, Unix,

Honeywell Mainframe: GCOS, Control Data Mainframe: NOS/BE, Scope, IBM

compatible PC's, Apple/Mac Compatible PC's

. Databases (As DBA): DB2 UDB/PE, Oracle 8/9i/10g, Teradata, MS SQL Server,

IMS DB/DC, SUPRA, Netezza, ODBC

. Business Intelligence: Microstrategy, Business Objects, Cognos, ETI

Master User, Sagent, Essbase, Data Stage, Rodin ETL & Reporting

. Statistical Tools: SAS, SPSS

. Languages: COBOL/II, CICS, XML, SQL, PL/SQL, Visual Basic, Assembler,

RPGII, REXX, HTML,

. Utilities / Other: Shell Scripts, FTP, CLISTS, Panvalet, Xpeditor, Data

Dictionary, Platinum Repository

. Data Architecture: Er Studio, ErWin, IEF, Excelerator

. Project Management: Method/1, LBMS, Microsoft Project, Yourdon, Stradis,

SSADM

Professional Experience

American Express - Spherion / Technisource Phoenix, AZ

2006-Present

Senior Data Architect

Supported Global Risk Management, Account Monitor, Worldwide Credit &

Collection and the Anti Money-Laundering applications by creating and

maintaining logical data models that provided a comprehensive view of the

business data.

Facilitated collaboration between technology and business teams to align

the metadata for various projects, while maintaining Enterprise level

standards. This resulted in the teams aligning with the Enterprise

standards earlier in the development lifecycle, which shortened project

timelines.

Standardized templates for data models and reports, generating many cost-

avoid situations. Managed multiple initiatives and priorities across all

business lines. Ensured that my management team was regularly informed

about all projects' status and notified of any issues in a timely manner.

WOLTERS KLUWER HEALTH / Keane (formerly NDC Health), Phoenix, AZ

2004-2006

Senior Data Architect

Created extensible and flexible logical data models that were used by the

DBA's to create the physical database structures and by the technology

teams to understand the business and data structures. Worked closely with

the DBA's to ensure the planned structures were viable and sustainable in a

20 TB environment. Redesigned and structured data model

prototypes/templates used by the team to enable rapid initiation of all new

data modeling efforts. Trained employees to perform Data Architecture

tasks and to follow best practices.

AAA Arizona, Phoenix, AZ

2002-2004

Database Mining and Marketing Specialist

Initiated and implemented new data architecture and procedures for the

deployment of the Marketing Data Warehouse. Standardized data mining

reports into a dashboard used by all departments to enhance their marketing

efforts. Using the Marketing Data Warehouse and Geo-Demographic analysis,

recommended locations for new AAA retail outlets. Two of the

recommendations were implemented and these locations are still in operation

today.

Alice A. Steinke Page 2

Independent Consultant, Phoenix, AZ 1998-2002

Data Warehouse Architect (DHL)

. Managed Data Architect team of 12 to support a BI implementation in a

Teradata environment, planning for a 20 TB Data Warehouse.

Data Warehouse Architect (Arizona Public Service & Starwood Hotels)

. Architected Financial DW structures enabling clients to create

comprehensive Strategic Financial Analysis and Data Mining environments.

This new functionality provided profound insights into the financial data

and initiated the implementation of financial best practices across all

regions.

Data Warehouse Specialist (Greenbrier & Russel)

. Created and maintained project methodology templates and project plans

that provided uniform structure to the BI teams executing data warehouse

projects. Resulted in projects operating at a reduced cost to the

consulting firm. Managed teams of 12 - 15 people for several data mining

projects such as Clickstream Analysis and Targeted Marketing.

Platinum Repository Specialist (Salt River Project)

. Launched and administered the Platinum Repository. Gathered, maintained

and made available all application metadata. Development teams were able

to more easily locate data structures which facilitated re-engineering

projects and shortened development time by 25%.

IBM Global Services, Intelligence National Practice, Phoenix, Az

1997-1998

Senior IT Specialist

. Architected initial data warehouse structures for several clients.

Assisted clients with database selection, data architecture, data quality

programs, data mining and establishing standards and best practices.

Assisted clients with advocating the advantages of a data warehouse

environment to their peers and managers.

American Express, Phoenix, AZ 1996-1997

Acting Development Leader (1996-1997)

. Managed the DW team of 25 that supported the conditioning and loading of

data from various American Express applications to the global data

warehouse, initially 10 TB. Created and developed a team to perform at

the highest professional level and actively support the many teams that

interfaced with the data warehouse.

Systems Integrator for the Global Data Warehouse (1996)

. Developed architecture, technology strategy and training as it related to

warehouse implementation.

. Formed and led a liaison team that demonstrated how the data collected

for the warehouse could be used to make strategic decisions through data

mining, and performed Cardmember Targeted Marketing.

Independent Consultant, Phoenix, AZ and Minneapolis, MN 1986-1996

Project Lead /Database Architect (Allied Signal 1995 - 1996)

. Initiated and installed the Just In Time Data Warehouse which enabled the

manufacturing area to reduce its inventory costs. Created the worldwide

sales monitoring warehouse structure and application allowing all sales

reps to be paid commissions up to two weeks sooner.

Consulting Database Architect (PDS 1994)

. Re-engineered IMS database structures that improved performance and data

availability by 25%.

Data Warehouse Manager (GTE Health Systems 1992-1993)

. Developed a project to restructure the DB2 claims warehouse of

approximately 5 TB to take the DW to its next logical level of maturity.

The process improved accessibility of data and ensured the reliability of

the data collected. Architected the collection of additional data needed

for more robust data mining. Proved the POC proposed for data mining

functionality. Improved SLA from overnight to sub-hour for complex

queries.

. Director of Software Development (Physician's Software Company 1991-1992)

Conducted a re-engineering study and provided re-engineering and

restructuring recommendations that resulted in the creation of a

management plan to improve the company's software development process.

The company implemented the first phase and shortened software

development time by 30%. Improved SLA's were created and enforced due to

this new development process.

Data Warehouse Consultant (Nielsen Market Research (aka A.C. Nielsen) 1990-

1991)

. Performed data architecture for a DB2 data warehouse and eventually

performed data mining to track and analyze the statistical data used for

targeted marketing.

Senior Database Consultant (H.C. Prange Department Store 1989-1990)

Alice A. Steinke Page 3

. Architected and implemented a SUPRA relational database and converted IMS

databases to the new relational structures. Database performance and

availability was improved by 55%.

IT Manager, Data Warehouse Environment (Health Risk Management 1988 -1989)

. Managed IT department of 15. Created an inter-departmental management

team to coordinate use of IT resources. IT backlog was cleared within

45 days. As primary architect for the warehouse structure, improved the

quality and the accessibility of the data mining reporting and dashboards

that were provided to the company's clients. Met all client & internal

SLA's. Created a positive and collaborative work environment reducing

turnover from 200% to 4.5%.

Data Warehouse Manager (State of Minnesota Department of Health 1986-1988)

. Reported directly to the State Health Care Commissioner and the

Legislature for the development of a new health care claims processing

and reporting data warehouse of approximately 3 TB. Managed team of 35

analysts, architects, DBA's and programmers to develop a new Long Term

Care Data Warehouse. Established new database architecture standards and

methodologies, including data quality applications. Data Mining projects

as well as improved patient verification resulted in savings in excess of

$5 million for the State within the first 6 months of operation.

Other Professional Experience

. Provided training programs and motivational seminars for large

corporations and small business groups.

. Provided recruiting, proposal creation and personnel services to several

medium IT Consulting Firms.

Education

Arizona State University ( BA

Arizona State University ( Graduate Level Courses in Statistical Analysis

Control Data Institute - Arlington, Virginia ( Certificate in Programming

Technology

AWARDS

Distinguished Service award at the completion of the Worldwide Sales

project, Aircraft Engine Manufacturer

Distinguished Service award for leadership for the Global Data Warehouse

POA Solution

Contact this candidate