Project Data

SHANE A. BURKE

Home 330-***-**** ***** Kerwick Ct.

Mobile 330-***-**** Aurora, Ohio 44202 **********@**********.***

CAREER SUMMARY

Hands-on technology leader with proven record of delivering efficient technical solutions to complex business

needs. Specialized skills in Business Intelligence and Data Warehousing that help organizations leverage

operational data to gain a competitive advantage. Experienced in all phases of the project cycle and product

support including vendor selection, implementation planning, business needs negotiation, hands-on development,

and staff supervision. Customer-focused, delivery-oriented, risk-aware, innovative, and adaptable.

PROFESSIONAL EXPERIENCE

KEY BANK, Cleveland, OH 2006 to 2008

Data Architect/Developer

Collaboratively improved Marketing System interfaces to desktop (Siebel) CRM tool; project assignments

supporting business initiatives in the community bank .

Designed multi-platform regression testing prototype which reduced implementation time on quarterly

release installs.

Expedited feeds of business lead generation to mainframe repository and reporting systems.

Identified core applications required to support bank teller training; served as key member of team that

architected and implemented a full function “training region” used for training in the Community Bank.

Collaborated with line of business to redesign campaign registrations, improving usability and controls,

which provided more efficient solicitation of new business.

THINGS REMEMBERED, Cleveland, OH 2001 to 2006

Manager, Data Warehousing

Business Intelligence and Data W arehousing responsibility for 800 store specialty retailer. Responsibilities

included: staff supervision, ETL processing, business analysis, application development, database

administration, and end user reporting.

Implemented three mission critical data warehouses in a five year period to widen corporate use and

streamline ability of merchants to resolve operational issues.

Reduced system maintenance time from 70% to 30% over a three year period, freeing additional

resources for new BI initiatives and strategic analysis.

Developed Scorecard Automation Mart for KPI data (Key Performance Indicators) for evaluation of store

performance. This tool was used to facilitate immediate identification and rectification of problem areas.

Managed team that created store employee data mart, tracking associate level performance and allowing

store operations to take immediate remedial action when appropriate, reducing time needed for field

employee performance reviews by 75%.

Designed and developed SIS (Sales Information System) warehouse for business metrics at the store

level generating weekly executive reports to quickly react to operational issues.

Managed development of transactional level Data Warehouse. Daily POS data from legacy systems was

fed to a star schema model. Back -end processing was created using a blend of ETL (Datastage), shell

scripts, C code, Informix utilities, SQL, and stored procedures.

SHANE BURKE – page 2

COLE NATIONAL, Cleveland, OH 1997 to 2001

Project Leader

Supervisory and project responsibilities with focus on data warehousing. System reliability and integrity of

data resulted in the elevation to a “mission critical” status by the business. A new set of standards and

product disciplines were created for all the necessary components (database administration, business

analysis, application development, and production support).

Extracted data from AS400 operational systems and loaded to 150 Gig Informix database providing

actionable operating results to business.

Managed migration to new HP-Unix platform, supervised team of five through server and OS install,

database and reporting tool installation, and the conversion of the complete back -end ETL process.

Installed releases, created test environment, established operating standards, created concise

documentation, provided production support resulting in reduced overhead maintenance, improved data

availability and significant increase in system usage by the business.

UNISYS CORP, Cleveland, OH 1995 to 1997

Project Leader, Client Server Applications

Project responsibilities supporting an outsourcing arrangement between Cole National and Unisys.

Led requirements and functional design phases of new decision support system (DSS), replacing

mainframe “legacy” data warehouse, creating company’s first exposure to three-tier client server

architecture. This groundbreaking project laid the foundation for the company’s first BI initiative.

Migrated mainframe bank-deposit system to network/PC based package, empowering business to

assume full control and significantly reduced cash shortages at the stores.

COLE NATIONAL CORP, Cleveland, OH 1995 (and prior)

Database Designer, Programmer Analyst

Held positions with increasing responsibility working on various mainframe projects with a mainframe

concentration

Accounting Supervisor

Financial analysis, general accounting responsibilities, and technical accounting projects.

EDUCATION

SIENA COLLEGE, Albany NY B.B.A., Accounting, May 1977

TECHNICAL SKILLS

Distributed:

Data Stage(ETL) Informix (RDBMS) CA-Eureka (BI) Mercury Suite

Ab Initio (ETL) Oracle (RDBMS) SQL ASP .net

Shell scripting SQL Server (RDBMS) HP-UX Powerbuilder

C MicroStrategy (BI) SAS Web Methods

Mainframe:

JCL DB2 Endevor CICS

COBOL Scripting Languages TSO/ISPF VSAM

Contact this candidate