Services

Business Services

Data Warehousing

Data Modeling

	Define data relationships
	Resolve Anomalies such as many-to-many relationships
	Define Schemas for data constructs
	Incorporate business rules
	Sample data for verification and prototyping

Database Administration

Data Architecture

	Normalizations
	Propagation of subscribed data to data marts as required
	Sourcing of data from legacy systems and other applications (data collection, editing, and preparation)
	Distribution of data to actual warehouse tables
	Error handling
	Record locking rules
	Data integrity
	Data access/retrieval guidelines

Data Analysis

	Process errors
	Perform summarization/aggregation
	Generate information required to make mission critical decisions
	Perform data analysis to find patterns and trends
	Efficiently retrieve and integrate data into an organization's workflow
	Data Scrubbing & Data Cleansing
	Data Auditing

Home Services

	Determining computer needs (i.e. hardware, software)
	Assisting in the ordering/purchasing of hardware or software
	Setting up computer or printer
	Installation of software
	In home training and continued support
	Upgrades
	Networking
	Repair

Hardware/Software Tool Skill Summary

Hardware:

IBM p570, IBM RS/6000, Unisys ES/7000, AS400, IBM SP2, IBM Mainframe, PCs

Operating Systems:

UNIX AIX 4 – 5L, Microsoft Windows (3.1, 95, NT, XP, 2000, 2003), MVS/ESA

Languages:

SQL, SAS, UNIX shell scripting, PERL/CGI, PL/SQL, writing stored procedures/triggers, MS Access, VB

Scripting, Visual Basic, Delphi, FoxPro, Easytrieve, Focus, COBOL, MVS/JCL and utilities

Data Access:

Oracle, SQL Server, DB2, IMS/VS, VSAM, IDMS

Supporting Software:

Cognos, Brio, Sybase Power Designer, TOAD, Ascential Data Stage, Tivoli, Autosys, PL/SQL Developer,

Microsoft Office Products, Hummingbird, Visio, Microsoft Project Manager