Project Data Warehouse

Title:Senior Network Engineer

abpynh@r.postjobfree.com

Document

Source below

NAME:,

ADDRESS:

ADDRESS2:

CITY:

STATE: UT

ZIP:

CANDIDATE ID: 2867223

US CITIZENSHIP:

EDUCATION:

EXPERIENCE: 0

WILL RELOCATE: No -

JOB WANTED:

RATE NEEDED:

TELEPHONE: 801-***-****

EMAIL: abpynh@r.postjobfree.com

HOMEPAGE:

HOTTEST SKILLS: product, programming, rpg, medical, as/400, programmer, health, claim,

lien, claim, unix, billing, data modeling, database, db2, advertising, market, marketing,

acquisition, accounting

REVISION: 08-SEP-02

RESUME:

25870 James G. Schneider

8903 S. Sutton Way

Sandy, UT 84093 801-***-**** abpynh@r.postjobfree.com JAMES G. SCHNEIDER

8903 S. Sutton Way

Sandy, Utah 84093

Home: 801-***-****

abpynh@r.postjobfree.com

SUMMARY Information technology professional for over seventeen years.

Experienced in the development of information systems from

concept through installation. Knowledgeable in data warehouse

design, BI and OLAP tools, ETL methods, ERP, MRP II and CRM

software, strategic planning, project and personnel management,

product evaluation, CASE/relational/QA/OO methodologies,

business systems analysis, OLTP application design, SMP/MPP

hardware architectures, database administration, data modeling

and structured programming. Over seven years experience with

IT consulting firms. Qualified to make an immediate impact

within any department or organization.

EXPERIENCE Industries: Insurance, health care, manufacturing, advertising,

holding companies, IT consulting, and direct marketing.

Custom Application Development: Claims operational data store,

metadata repository, provider mgt. data mart, classified

advertising PO/billing/invoicing system, job costing information

system, time accounting system, co/dept/employee efficiency

system, parts tracking system, premium remittance system, United

Kingdom Case Mix and Contracting products and custom data

communications software.

General Applications (worked with or modified): Behavioral and

medical healthcare claims, MRPII, general ledger, accounts

payable, accounts receivable, billing, purchasing, order entry,

sales analysis, bill of materials, inventory, labeling, case mix,

medical records, reimbursement management, hospital census and

various data conversions applications.

Management: Experienced in IT project management, manpower

planning, critical path and milestone definition, programming

standards and project control systems. Supervision of technical

and non-technical personnel.

EMPLOYMENT

8/95

- presentMagellan Behavioral Health (Human Affairs International,

Inc. / Aetna

) Sandy, Utah

Manager, Data Warehouse Development2/00-present

Project Leader / DBA

10/98-2/00

Business Systems Design Specialist

8/95-10/98

Responsible for the design, development and implementation

of centralized operational data stores in a heterogeneous

hardware environment (NT, AS/400, HP3000, RS/6000).

Responsible for all data acquisition and transformation

into, and out of, the corporate data warehouse. Designed

and implemented the Unix data warehouse strategy and

architecture for HAI. Architected 3 IBM RS/6000s to

support the test, development and production data

warehouse environments. Designed and implemented data

acquisition and metadata data models. Responsible for a

team of Unix developers and a data modeler. A member of

the 2000 corporate RDBMS evaluation and the 1995 ad hoc

query and OLAP (online analytical processing) tool

evaluation committees. Various corporate presentations

on data warehouse design and development. Implemented the

initial data warehouse proof of concept project (provider

mgt. reporting) using Crystal Info.

Technologies and skills: Project and personnel management,

data warehouse design and architecture, VLDB design,

database administration, operational data store and data

mart design, data transformation methods (ASCII and

EBCDIC), IBM's RS/6000, AS/400, AIX, RPG III and DB2

UDB products, data modeling (Erwin), SQL, TCP/IP, FTP,

Unix filesystem design, kornshell and C programming,

capacity planning and system recovery, AMR's CAPS and

HBOC's AMISYS claim paying systems, ICD-9 and DSM-IV

medical coding, Inmon and Kimball data warehouse

methodologies, HP's HP3000 and Turbo Image db., MS

Project and PowerPoint, Seagate's Crystal Info and

Data Junction.

1/94

- 8/95ProData, Inc. (Best Consulting) Salt Lake City, Utah

ConsultantIronman Award Winner

Performed programming and analysis for TPA (third party

administered) claim conversions at Human Affairs

International. Analysis and project management to correct

patient "typing" error in Shared Medical System's

MedSeries/4 hospital census product. Responsibilities

included problem definition, cross product analysis,

multi-product redesign sessions and programming.

Technologies and skills: AS/400 and RPG III.

9/91

- 1/94GTE Health Systems, Inc. (Shared Medical Systems) Salt

Lake City, Utah.

System Analyst

1993 Focus on Excellence Award

Designed, programmed and installed portions of the Case Mix

and Contracting products for a $13 million United Kingdom

contract. Served as interim product manager for Universal

Billing -1992 release of the MedSeries/4 Case Mix and

Reimbursement Management products. Programmed additional

modifications and enhancements to the Case Mix and

Reimbursement Management products.

Technologies and skills: AS/400, RPG III, team management,

MS Project, SEI's Capability Maturity Model, ICD-9,

DRG, UB92 and Medical Records.

10/85

- 6/91Software Alternatives, Inc. Cleveland, Ohio.

Project Leader

10/90 - 6/91 1988

Employee of Year-

Cleveland Branch

Consultant

10/88 - 10/90

Senior Programmer

6/86 - 10/88

Programmer

10/85 - 6/86

Developed, maintained and modified a wide variety of OLTP

and reporting applications, primarily MRPII, for Fortune

1000 clients. Responsible for all phases of the SDLC,

staff development and the management of client projects.

Participated on client software selection committees and

performed software evaluations for clients. Installed

and maintained IBM MAPICS (MRPII) and Lawson Associates

PINSTRIPE (financial) software.

Technologies and skills: IBM AS/400, System 34/36/38,

SAI's Project Management methodology, Personnel

supervision and management, RPG II & III, MS Project,

Financial systems and MRPII.

4/85

-10/85Kirkwood Industries. Cleveland, Ohio.

Programmer

Designed and wrote a parts tracking system. Maintained IBM

MAPICS software. Responsible for the operations of an IBM

System/34.

Technologies and skills: IBM System/34, RPG II, and MRPII.

5/83

- 4/85Hauser King Marford Co. Cleveland, Ohio.

Programmer

Responsible for the internal development of direct marketing

software. Developed label printing and premium remittance

software. Responsible for directing data entry clerks and

the operations of an IBM System/34.

Technologies and skills: IBM System/34, RPG II and employee

supervision.

EDUCATION Cleveland State University

. Cleveland, Ohio. 1991. BA in

Business Administration

.

Control Data Institute

. Independence, Ohio. 1983.

Certificate in Programming and Operations.

Youngstown State University

. Youngstown, Ohio. 1977-1982.

Course work in accounting and computer science

.

MEMBERSHIPS Project Management Institute

The Data Warehouse Institute

Currently seeking DB2 UDB certification

Contact this candidate