Data Analyst/Architect Resume

Title
Data Analyst/Architect

Primary Skills
data architecture/modeling

Location
Canada-BC-victoria (will consider relocating)

Posted
Mar-07-09

NATIONALITY: U.S. Citizen

OBJECTIVE:

Seeking an organization that will find value and appreciation of my data architecture experience related to data warehouse 'best practices' as well as my DBA skills related to performance & tuning issue resolution. Seeking project management or project-lead positions involving a data-oriented project using: Kimball or Finkelstein methodology; database performance & tuning analysis; ETL design or maintenance; data architecture/data modeling; and the facilitation of JAD sessions and business requirements gathering. The ideal position would involve enterprise-wide information engineering with the responsibilities for 'best practice' database design or for business performance 'gap analysis' as pertains to functional or enterprise process/data architecture solutions.


EXPERIENCE:

INTEL, Chandler, AZ [ 03/08 -- 11/08 ]
POSITION: (consulting contract) Data Analyst/Architect
FUNCTION: Development of data models (conceptual/logical/physical); E/R & dimensional modeling; business requirements discovery; process modeling; supply chain, procurement, materials-inventory, and credit card applications; value cost chain models(L.English methodology); data architecture and risk assessment for Information Quality&Analytics group. Devised data quality assessment method pertaining to Data Accuracy / Completeness / Consistency / Timeliness / Validity.
TOOLS: SilverRun / Teradata / SQL-Server / ProVision / SQL / MDM / SAP-BI / SAP-AII / EPCIS

HONEYWELL AEROSPACE, Tempe, AZ [ 09/06 -- 09/07 ]
POSITION: (consulting) ETL Support Analyst
FUNCTION: Run-time support of world-wide data loads from SAP to ORACLE databases. Firefighting fixes and maintenance of all production jobs in a 24/7 operation.
When not on shift I performed as an ETL developer. Both roles involved UNIX, TOAD, and Business Objects Data Integrator ETL architecture.
TOOLS: BO Data Integrator XI Designer & Administrator 11.5 / UNIX-AIX / vi / TOAD

COMMONWEALTH OF MASSACHUSETTS, Boston, MA [03/06 -- 06/06]
POSITION: (consulting) Data Warehouse Architect
FUNCTION: Data migration project lead transforming SQL-Server data warehouse to Netezza data warehouse [.75 terabyte / payroll and financial information]. ODS build; establish central data warehouse; ETL standards/procedures, design/development/delivery of initial user applications.
TOOLS: Netezza / Informatica7-PowerCenter




WALNUT VALLEY School District, Walnut, California [11/05 - 02/06]
POSITION: (consulting/part-time) SQL SUPPORT DBA / ANALYST
FUNCTION: Responsible for SQL discrepancy resolutions by providing remediation processes in support of all customers of the school district database. Utilizing knowledge of the customer database environment, responsible for delivery of timely and quality incident resolution focusing on root cause analysis, prevention, and knowledge transfer.
TOOLS: SQL-Server/UNIX/SQL-DDM/SQL-DML/SQL-DCL

STUDIO1 Art Gallery and Theater, Honolulu, Hawaii, USA [06/01 01/05]
POSITION: VENUE OWNER / DIRECTOR / GENERAL MANAGER
FUNCTION: Responsible for business law, tenant/landlord law, liquor law and entertainment law, construction regulations and contractors (rennovation of interior aspects of the gallery, bar/lounge, and stage, sound system, and theater lighting). Responsible for the actual operation of the business which involved accounting, office management, contract management, and the artists themselves. Supervised the office manager, gallery curator, event coordinator, and bar manager as well as resourcing and supervising temporary staff. Acted as event director through sharing responsibilities with independent event promoters as well as the controlling authority over the gallery events and installations.

WARNER MUSIC GROUP, INC, Burbank, CA, USA. [ 09/00 05/01 ]
POSITION: DATA MANAGER, Technology Office
FUNCTION: Internal consulting architect of central data warehouse, data marts, and ODS for consolidation of multiple music record label organizations. Projects include marketing, global daily sales, and web promotions. Devised formal data warehousing standards, guidelines, and methodology.
TOOLS: Erwin / Constellar / Brio / Bus.Objects / Oracle8I / ms-Project

TWENTIETH CENTURY FOX ENTERTAINMENT, Century City,CA[01/00-09/00 ]
POSITION: DATA WAREHOUSE ARCHITECT
FUNCTION: Designed data warehouse architecture for integration/consolidation of several independent business units on SUN E10K hardware. Developed questionnaire for business units and facilitated business requirements discovery sessions.
TOOLS: MicroStrategy / Informatica

EJ GALLO WINERY, Modesto, CA, USA [ 06/99 11/99 ]
POSITION: (consulting) DATA WAREHOUSE ARCHITECT
TOOLS: ERwin-ERX3.5 / ModelMart / Oracle7.3 / PL-SQL / Consteller

VIKING FREIGHT, San Jose, CA & Phoenix, AZ, USA [ 08/98 06/99 ]
POSITION: (consulting) DATA ARCHITECT / DBA
TOOLS: OracleDesigner/ORACLE/PowerDesigner/ERwin/MS-project

LINCOLN HOSPITAL, Phoenix, AZ, USA [ 07/98 08/98 ]
POSITION: (consulting) ORACLE / PEOPLESOFT DBA
TOOLS: ORACLE7.3 / UNIX / PeopleSoft HRSM7 & Financials7

PEOPLESOFT, INC., Newton, MA [06/98 07/98 ]
POSITION: (consulting) ORACLE / PEOPLESOFT ADMIN.
TOOLS: ORACLE7.3 / SQR3 / UNIX / PeopleSoft HRMS7

IEI CONSULTING SERVICES, Phoenix, AZ [ 01/98 05/98 ]
POSITION: DATA BASE MANAGEMENT / President
TOOLS: NETWARE 4.1 ADMIN / ORACLE 7.3

STATE OF DELAWARE, Dover, DE [ 01/97 - 06/97 ]
POSITION: (consulting) DBA, PeopleSoft Security
TOOLS: ORACLE / SQL*Plus / PL-SQL / SQL*Loader / SQR

OPTIMALCARE, Phoenix, AZ, USA [ 08/96 - 10/96 ]
POSITION: (consulting) DATA BASE ANALYST
TOOLS: ORACLE 7.3 / SQL*Loader / SQL*DBA / ADABAS-PREDICT

DISNEY INTERACTIVE, Glendale, CA, USA [ 01/96 - 05/96 ]
POSITION: (consulting) BUSINESS INFORMATION ENGINEER
FUNCTION: Advisor and promoter of business information engineering methods and tools. Wrote IE methodology (Finkelstein based); directed project mgt phase (educated sponsor/team members, prepared mgt. questionnaire, wrote project charter); directed project through business goal and market analysis.
TOOLS: IE-Advantage / ORACLE / MS-Project

KNIGHT-RIDDER Information, Mountain View, CA, USA [ 02/95 - 10/95 ]
POSITION: (consulting) BUSINESS INFORMATION ENGINEER
FUNCTION: Senior IE consultant to the business information engineering project team. Selection, customization, and implementation of strategic planning methods (project initiation, scope, and education; business goal analysis; internal/external market appraisal; conceptual data and process models). Directed JAD sessions and presentations.
TOOLS:IE-Advantage/SQL-Server/Excelerator/ORACLE/SQL/ERwin

JOHNSON CONTROLS, Los Alamos, NM, USA [ 10/90 - 02/95 ]
POSITION: ADABAS DATA BASE MANAGER (DBA & DA)
TOOLS: ADABAS / VAX-VMS5.4 / ADA-SQL / PREDICT

ARIZONA STATE BOARD OF EXAMINERS, Phoenix, AZ, USA
[ part-time, 1995 & 1996 ]
POSITION: Malcolm Baldrige quality award examiner
(ITcategory specialist)

IEI CONSULTING SERVICES, Las Cruces, NM, USA [ 10/89 - 10/90 ]
POSITION: DATA ADMINISTRATOR & DATA BASE MGT CONSULTANT
TOOLS: ADABAS / NATURAL / PREDICT / SECURITY / ADA-SQL
TRW DEFENSE SYS GROUP, White Sands, NM, USA [12/88 -10/89 ]
POSITION: MIS DBA / PROJECT ENGINEER
TOOLS: ADABAS / NATURAL / PREDICT / SECURITY / ADA-SQL

CITY & COUNTY OF HONOLULU, Honolulu, HI, USA [ 04/87 - 12/88 ]
POSITION: DATA BASE MANAGER (DBA & DA)
TOOLS: ADABAS / NATURAL / PREDICT / SECURITY / ADA-SQL

STATE OF HAWAII B&F, Honolulu, HI, USA [ 11/86 - 04/87 ]
POSITION: (consulting) DBA & DA
TOOLS: ADABAS / NATURAL / PREDICT / SECURITY / ADA-SQL

UNITED BLOOD SERVICES, Scottsdale, AZ, USA [ 12/84 - 10/86 ]
POSITION: DATA BASE ADMINISTRATOR
TOOLS: ADABAS / NATURAL / PREDICT / SECURITY / ADA-SQL



AMERICAN COMPUTER PROFESSIONALS, Columbia, SC, USA [ 05/84 - 12/84 ]
POSITION: (consulting) P/A (IMS DL/1 database analyst)
TOOLS: IMS-DL1 / DOS-VSE / ICCF / VSAM / COBOL

COLLEGE OF CHARLESTON, Charleston, SC, USA [ 05/82 05/84 ]
POSITION: PROGRAMMER / ANALYST (IMS DL/1)
TOOLS: IMS-DL1 / COBOL / OS-MVS-CMS / PANVALET / WANG


EDUCATION:

B.S. Computer Science
01/97 - 12/98 Alameda University, Boise, Idaho
(Computer Science)
06/80 - 06/81 Ft. Lauderdale College, Ft. Lauderdale, FL
(Computer Science)
05/79 - 05/80 Loyola College of Baltimore, Baltimore, MD
(Computer Science)
01/79 - 05/79 Towson State University, Towson, MD
(Computer Science)
06/75 - 12/78 Howard Community College, Columbia, MD
(Data Processing)
01/72 - 12/72 University of Hawaii, Manoa, HI
(Linguistics)
09/67 - 12/71 Memphis University, Memphis, TN
(Philosophy)
International School of Bangkok, Thailand
(High School)

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in victoria, BC | Resumes in British Columbia

View other Data Analyst/Architect resumes