Project Manager

Title:Director

*********@*****.***

Document

Source below

NAME: mauerhofer, daniel

ADDRESS: **** ****** ******

ADDRESS2:

CITY: round rock

STATE: TX

ZIP: 78664

CANDIDATE ID: 2240580

US

CITIZENSHIP: Permit

EDUCATION: Technical Institute

EXPERIENCE: 10

WILL RELOCATE: Yes -

JOB WANTED: Any

RATE NEEDED: 75 000.00+

TELEPHONE: 512-***-****

EMAIL: *********@*****.***

HOMEPAGE:

HOTTEST SKILLS: datastage, ETI, Informatica, project management, Data warehousing

REVISION: 13-SEP-01

YOE: 10

RESUME:

Daniel Mauerhofer

Daniel Mauerhofer is a Team leader of Data Warehousing Solutions for CS

Solutions, Inc. Daniel has been with the company since the beginning of the

year 2000 and brings extensive experience in data management, data warehousing,

automated tools such as ETI, Datastage, and experience in a wide variety of

companies and industries.

Skills

LEADERSHIP/MANAGEMENT:

Leading ETL/Data warehousing projects.

Developing innovative and timely solutions for customers, based on

customized processes.

Building of Development/Implementation teams.

Proactively communicating on technical and management levels with

customer.

Developing estimating techniques for ETL projects.

Developing training curriculum for ETI conversion specialist training.

Mentoring future development leads in customer relationship management.

Introducing join knowledge sharing mechanisms through the WEB.

Using of MS Project & MS Visio for project planning and tracking.

Using ABT Team Workbench to track work hours against task based

projects.

Using Microsoft productivity tools (Word, Excel, etc) and Lotus Notes

tools.

SYSTEMS ANALYSIS AND DESIGN:

Analyze and implement computerized solutions to meet business needs.

Liaison between users and developers to establish business rules.

Application development life cycle.

Process Modeling using a Context Diagram and a Data Flow Diagram (DFD)

Data Modeling using an Entity Relationship Diagram (ERD)

CASE TOOL : VISIO PROFESSIONAL 4.5 FOR WINDOWS.

Using Visual Source Safe to track and monitor version control.

Design of tracking tools using Windows Excel.

Coaching conversion specialist in debugging techniques.

DATA EXTRACTION TRANSFER LOADING/ ETI EXTRACT

Datastage XE / Client server & OS390 Development, leadership, training.

Working in ETI 4.1 DA environment Cobolfs/DB2 & Cobol fs/Oracle.

Mapping data fields from Tandem, Swift and MVS legacy systems to

Oracle8 target DB using the Data Integration ETL tool "ETI-Extract" by ETI inc.

Creating filters, conversion properties and code blocks

using "ETI/Extract".

ETI conversion workflow analysis and tracking.

Training of conversion specialist on the ETI tool.

Analysis of customers requirements to coordinate ETL portion of project.

Ensure adherence to customer Mainframe and JCL standards.

Define work plan and lead the development team.

Perform Administrative maintenance task on Unix Server for ETI tool

directories and structures.

Export/Import ETI Metastores to optimize drive space.

Configure workstations Hummingbird Exceed software so as to access ETI

software.

Perform Back-up and other Metastore management tasks.

Perform Master User type tasks: Debugging templates, updating Global

Data, Modifying templates, Synching up of Metastore templates, installing ETI

DSL upgrades and patches.

UNIX PLATFORM

Knowledge of working with files and directories.

FTP from NT to UNIX and UNIX to NT.

Sync sort processing.

VI editor usage.

Cshell navigation

MAINFRAME

Basic knowledge of working with files and directories using TSO, ISPF &

SDSF.

FTP from NT or to NT.

Using file-aid.

Using Change Man for rolling programs into production.

Using Info man system for problem ticket creation and problem

resolution.

DATABASE SKILLS:

Using Oracle8 SQL*plus to query databases in Oracle.

Debugging Pro C Oracle code.

Using Autopilot 3.0b by Rochade to track, verify and manage the Swift,

Tandem and MVS source databases.

Using File-Aid utility by TSO/ISPF to track test data.

Using VisData (part of VB 5.0) to design and create relational

databases.

Creating report using Crystal Reports by Seagate Corp.

Designing and creating relational databases in Access.

Using Data Controls and Data Access Object structures (DAO) in VB5.0

applications.

SQR programming for reports, DSS development.

Using Visual Sqribe to develop reports.

VISUAL C++: (Basic level)

Object orienting programming for DOS.

SOFTWARE IMPLEMENTATION KNOWLEDGE:

Accpac Accounting for small businesses.

The Blue Book Estimating Software.

Quick-Books Accounting.

Using WinZip to compress and uncompress files.

Excel.

Education

Datastage XE/OS390. ETL developer training (basic & advanced)

April August 2001

Attendance to DAMA International/Meta-Data Conference

March 3-8, 2001

Attendance/Mentoring team members at SkillPath Training

Seminars; 2000

Successful Project Management.

Managing Multiple projects.

Coaching & Teambuilding Skills for Managers.

Sagent Technology inc. Data Mart training. OLAP; Star Schema; fact/dimension

tables. 1999

ZD University, Intro to Microsoft Networking (3 CEUs)

1999

SQRIBE Technologies. Visual SQRIBE, SQR for Programmers part I & II Ver. 4

Certificate of Completion

1999

"ETI-Extract" conversion specialist training. Norwest Financial, Des Moines, IA

1998

Computer Programming and Systems Analysis Diploma, C++ (basic level), Visual

Basic 5, 1997-98

SQL, Crystal Reports.

Toronto School of Business,

Kingston, Ontario, Canada.

Self-study: Oracle8, ActiveX and other advanced VB skills

1998

Train the Trainer, Hospitality Industry Training, Ontario Tourism

Department

1988

Deerhurst Resort,

Huntsville, Ontario, Canada.

Business Administration diploma

.

OSullivan Business College,

Montreal, Quebec, Canada.

1983

-84

Business Studies,

DeRoberval High School, Montreal, Quebec, Canada

1978

-83

Work Experience

August 2001

PresentCS Solutions Inc

. DW/ETL project implementation lead

Texas Workforce Commission, ETI Extract 4.1 Classic CobolFS/Sybase NT

platform. IBM Warehouse Manager.

Installing IBM DB2 UDB Enterprise Edition v 7.2 for Windows.

Installing IBM Warehouse Manager (formerly IBM Visual Warehouse)

Configuring IBM Warehouse Manager and ETI ETL tool so as to extract

Metadata.

Extract and manipulate Metadata to meet customers requirements and

query using SPSS & Cognos OLAP tools.

May 2001

June 2001CS Solutions Inc

. ETL project Configuration / Master User

Fleetguard, Inc./Cummins, ETI Extract 4.1 Classic CobolFS DA4.1 *

AS/400 * Oracle DA

Creating New project Metastore.

Installing Oracle DA DSL.

Installing Cobolfs 4.1 DA DSL

.

Installing AS/400 DSL.

Configuring connections between 4 Sun servers.

Setting up users.

Testing implementation of new DSL's.

Transfer knowledge to onsite conversion specialists.

April 2001

- PresentCS Solutions Inc

. ETL Developer/Lead

Ascential Software, Datastage XE ETL tool.

Developing ETL Jobs using DS Designer, Monitoring jobs using DS

Director &

DS Manager, Configuring DS using DS Administrator.

Developing training on our own server so as to train internal resources.

Setting up of training facilities at head office so as to connect using

TCPIP to conduct DS training over the Internet.

Conducting training sessions over Internet with trainees.

Acting as channel partnership lead between CSSI and Ascential.

Marketing CSSI ETL resources to Ascential Consulting network.

December 2000

April 2001CS Solutions Inc

. ETL project implementation lead/Master User

Texas Workforce Commission, ETI Extract 4.1 Classic CobolFS/Sybase NT

platform.

Editing ETI templates so as to generate production JCL as per TWC

specifications.

Generating/ testing/ scheduling/ flowcharting of 210 ETI conversions.

Porting to production using the Changeman framework 210 ETI conversions.

Coordinate documentation effort of 3 conversion specialists.

Created and maintained project ETI Metastores (Back-ups;

Export/Imports).

Participated in ETI template modifications according to the CS

Solutions ETI Jobstream MVS infrastructure to meet other TWC requirements.

Trained 3 conversion specialists to use Change Man to put programs into

production.

January 2000

November 2000CS Solutions Inc

. ETL project lead/Master User

American Express, ETI Extract 4.1 Classic CobolFS/DB2

Served as Data Extraction Project kick-off & team lead for 2 projects

Totaling 90+ conversion programs.

Served as intermediary between the Data Extraction team and the OLAP

Front End team, the specifications writers, Systems infrastructure team and

production implementation team.

Trained and mentored 8 different team members over 8 months.

Hands on set-up of conversion structures for new members.

Direct ETI Data Extract development workflow.

Created and maintained project ETI Metastores (Back-ups;

Export/Imports).

Participated in ETI template modifications according to the CS

Solutions ETI Jobstream MVS infrastructure.

Coordinated all physical and systems set-up for new team members.

Created Extract WYSIWYG documentation to illustrate ETI Data Extraction

Logic employed.

Mentoring 2 future team leaders.

Developed Data Extraction project estimating methodology.

February 99

November 99

Logan/Britton, Data Conversion Analyst

Experian . ETI Extract 4.0.1 Cobol fs to Cobol fs

Liaison between users and developers to establish business rules.

Hands on development of 30 conversions for a Marketing endeavor

relating to client customer data.

Analyzed SAS data files located on an MVS system.

Developed conversions which match logic and merge logic.

Developed conversions to aggregate and summarize data.

Edited JCL to manually run conversions on MVS platform.

Manually creating Unix scripts to run conversions.

Using MVS fileaid to verify data and test runs.

Used MVS sync sort and Unix sync sort for summarizing data.

Created Documentation to detail step by step procedures for client.

Created Extract WYSIWYG documentation to illustrate Extract Logic

employed.

August 98

' February 99Norwest Financial, Des Moines, IA

-Conversion Analyst

assisting Master Users.

ETI Extract: 4.0 Cobol fs to Oracle.

-Creating conversions based on existing conversions, and editing mappings.

-Editing the Merge files and Proc files.

-Choosing and running specific portion of JCL files depending on which I files

need to be rerun because of changes.

-Debugging Oracle ProC and Exe files to reconcile differences between what is

expected based on the ETI Schemas and the output.

-Testing of accuracy of source and target Metadata in ETI. Testing

conversion population accuracy. Using TSO/SPIFY & SQL*Plus interfaces to

track results.

Unix platform:

-Monitor jobs on the Unix host so as to eliminate jobs that have abended.

-MVS: -Using the Spiffy tool to view test data.

-Using the File Aid tool to view the JCL files generated with the execution of

a conversion

Oracle Database:

-Using the Oracle SQL Plus 8.0 program to access the target schema.

-Using SQL count command to check if target tables are being populated.

Cobol Platform:

-Debugging Cobol JCL files when JCL jobs that have abended.

-Proofing Cobol Schema properties, data types, to find unsynchronized data

sizes.

-Training and assisting other Conversion Specialists using the ETI tool.

-Developing user specific guide documentation to aid in the learning

curve with the ETI tool.

-Assigning conversions to Conversion specialist to work on based on difficulty

and persons abilities.

-Assisting Conversions Specialist with filter creation and Scrubbing rules

application.

-Setting control and tracking mechanisms based on particular needs of

conversions.

-Track and resolve legacy issues so as to maximize the Conversions Specialists

time.

-Track and follow-up with legacy schema changes, post-conversion creation.

March 98

'-April 98' CORK (Canadian Olympic Regatta Kingston) I was part of

the Development Team developing a volunteer tracking system using Visual Basic

5.0. I interfaced with the client to do the data modeling on an Access

database. I worked on the Quality Assurance team testing the interfaces and

forms built by the coding team. We used the Visual Source Safe version

control system to ensure proper documentation of code evolution. We built our

own database in Access to track and document the bugs that we found.

Kingston, Ontario, Canada

1995

-1996 The Travel Broker travel agency. Analyzed and developed

business plan for Website/Reservation business and group tour business.

Advised on purchase of computer equipment and programs for office and

facilitated training. Planned, marketed group tours. Escorted group tour to

Alaska.

From Kingston, Ontario, Canada.

1989

-1996Operated Nordic Contracting Inc. A contracting firm of 5-12

year round employees. Personally responsible for all facets of

administration. Set-up an employee training program and company policies.

Effectuated Computerization analysis of office operations resulting in

implementing accounting software and Graphics software to design all graphic

and add copies for the company.

Huntsville, Ontario, Canada.

~ References available

Contact this candidate