Project Data Warehouse

Title:Mary Wolf

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

Document

Source below

NAME: Vincent Humplick

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

CITY: Dallas

STATE/PROVINCE: TX

ZIP/POSTAL CODE: 75287

COUNTRY: USA

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

PHONE: 972-***-****

CANDIDATE ID: 114963

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: No

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: Open

HOMEPAGE:

HOTSKILLS: Data Warehouse =5+ yrs, Informatica =2+ yrs, Oracle =2+ yrs, Sybase =4+ yrs, Sybase IQ =3+ yrs, UNIX =5+ yrs, Programming =5+ yrs, SQL =5+ yrs

ESUME

SUMMARY:

Data Warehouse Developer spanning all aspects of data warehouse implementation including

data modeling, database construction, source data analysis, data extraction,

transformation and loading techniques. Strong implementation skills whose foundation is

based on a history of custom UNIX software development and deployment projects. Industry

experience spans transportation, retail, point-of-sale applications, distribution and

trucking operations, information publications, banking, managed healthcare systems and the

alarm monitoring industry. Extensive programming experience including SQL and its

extensions in RDBMS flavors, UNIX scripting tools, C/C++, UNIX systems programming

featuring inter-process communications such as Message Queues, Semaphores, Shared Memory,

Sockets and RPC. Project lead experience in mission critical software development projects

through the full life cycle systems development, interacting with developers, end-users,

project sponsors and all levels of client management.

TECHNICAL SKILLS:

Programming Languages and Software: Data Modeling: ERwin, PowerDesigner; Data ETL tools:

Informatica, Ardent; Database tools: Oracle, Sybase IQ, Sybase, INFORMIX, Red Brick, SQL,

Stored Procedures, Triggers, ODBC; Reporting Tools: Business Objects; Programming: C/C++,

Visual Basic, Pascal, FORTRAN; UNIX development tools and the X-Windows environment.

Messaging and Groupware products, Lotus Notes.

UNIX Systems Programming: Inter-Process Communications: Message Queues, Semaphores,

Shared Memory, Sockets, SUN RPC

Hardware and Operating Systems: IBM RS6000, AIX; AT&T, System V; UNIX platforms such as

Sun Microsystems, HP, Motorola, NCR, Sequent, UNISYS; Macintosh, Windows 95 and NT.

Teklogix RF terminals, TCP/IP, and Radio Frequency communications.

HISTORY:

Strong technical and analytical skills quickly create an efficient and productive team

member. Adept at learning new tools, programming languages, proprietary interface systems,

protocols, business and software products. Representative projects include:

* Data Warehouse Developer: Protection One - Dallas Texas

July 1998 - Present

Rapidly growing leader in the Security Monitoring Industry: The Data Warehouse

consolidates data from a variety of Data systems including Oracle, DB2 Mainframe, Sybase,

Microsoft SQL Server and proprietary Security Monitoring, Financial and Customer Care

software systems from which datamarts are deployed to the Business community. On-site

projects, responsibilities and accomplishments include: analysis, design and creation of a

data structures; Extract, transformation and loading using appropriate tools including

Informatica, SQL, Oracle and Sybase Bulk extractors and loaders, UNIX script utilities.

Also included Informatica ETL tool evaluation, selection, implementation and deployment,

creation of utilities to maintain and report on the Informatica Repository; Data cleansing

tool selection and implementation.

Technology: AIX, Informatica, Business Objects, Oracle, Sybase IQ, Sybase, Microsoft SQL

Server, AS/400, ERWin, PowerDesigner DataArchitect, Centris AddressBroker, Tivoli Maestro

Scheduler, SQL, shell scripts and C.

Data Warehouse Developer

: PHH Fleet - Baltimore MarylandMarch 1998 - June 1998

Industry leading data warehouse for decision support, Intranet applications and client

web access. The data warehouse incorporates data from a variety of enterprise-wide

information systems ranging from legacy Mainframe systems to client/server OLTP systems.

Scheduled automated migrations incorporated source data extraction and file transfer, data

validation and cleansing, data normalization, transformation of the varied source data

into a consistent warehouse format and generation of roll-up summaries. Large databases

necessitated software design and programming considerations to reduce the impact on other

database users yet achieve sufficient performance to maintain the schedule.

Responsibilities included analysis, software maintenance and programming extraction,

transformation and loading. C programming support to ETI*Extract developers for extending

the functionality of the ETL tool.

Technology: Sun Solaris, AutoSys Scheduler, Sybase, SQL, Stored Procedures, Triggers,

shell scripts and C.

* Project Sponsor: Roadway Express

-

Akron Ohio August 1997 - March 1998

Vehicle Maintenance Software System: The system replaced legacy vehicle maintenance

software and paper-based manual processes with a custom distributed client-server system.

Key participant during the project estimation and bidding phase, RFP content preparation

and review, and its final presentation to the client during the vendor selection phase.

Once the project began supported the on-site project management team utilizing previous

client project history. Other responsibilities included technical consulting for the

software design, setting standards and procedures and resolving technical issues on the

project, providing pre-engagement preparation for developers. Training incorporated UNIX

software development skills, Relational Database technology, SQL, C programming and the

Vermont Views API for building the interface.

Technology: IBM RS6000, RF Mobile Terminals, AIX, INFORMIX, C, Vermont Views API; Shared

libraries, Dynamically Linked Object Modules, SQL, Stored Procedures, and Triggers.

* Technical Lead: OneNet, ICI. - Cleveland Ohio July 1996 - March 1997

Process Oriented, Recruitment Automation Product: A custom software solution developed

for high volume, demanding environments with short lead times. This phase entailed

wrapping up the final stages of the software product life cycle before its next

incarnation as a client-server distributed software system. Performed analysis and review

of development and runtime platform choices, developed prototypes and feasibility studies

for select portions of the new system including data administration, security access

controls, advanced querying and data browsing.

Technology: Windows 95, Visual Basic, ODBC, and SQL.

* Technical Lead:

VIPS, Inc

. - Baltimore Maryland October 1995 - March 1996

Decision Support System: The industry-leading enterprise solution for Health and Managed

Care Decision-Making consisted of several large components. Among the components were the

Data Integration modules that performed the critical task of preparing legacy data for the

high-tech data warehouse. Responsibilities included: technical lead for the Data

Integration UNIX team developing software development standards, resolving technical

issues, serving as a technical anchor, designing and creating development environment.

Analysis, design and programming modules executed as synchronized concurrent processes.

Technology: Sun Solaris, Red Brick Data Warehouse, C, SQL, Windows NT, and X-windows.

Lead Analyst

: Roadway Express - Akron Ohio April 1993 - May 1995April 1992

- December 1992

Yard Control Software System: The software provided an inventory system, the ability to

request and track movement of equipment within the yard, history and productivity for long

term planning. Responsible for research, design, specification, implementation and

software delivery. Technical anchor, team leader and trainer. Project scheduling, release

and deployment coordination with other client projects. Liaison between the applications

development team and user departments. Technical program design and implementation

responsibilities for select modules: these included libraries implementing the business

rules and the RF terminal system featuring a background process listening for connection

requests after which it spawned and managed child processes that interacted with the user

at the RF terminal. Cross platform inter-process communication was implemented using RPC.

Technology: IBM RS6000, RF Mobile Terminals, AIX, INFORMIX, C, Vermont Views API, SQL,

Inter-process communications, sockets, and RPC.

Project Analyst

: Roadway Express - AkronOhioJanuary 1993 - August 1993

An Automated Freight Handling System: Arriving freight is separated into conveyable and

non-conveyable components. A first in the LTL business, the software determines the

shipping destination of the freight, tracks each component of the shipment on the dock and

ensures that the conveyables arrive at the loading dock door within a short time of the

non-conveyable units. Duties included researching, designing and writing specifications.

Provided technical assistance to team members and took part in design meetings both within

the team as well as with members from impacted systems. Programming design and

implementation responsibilities for select modules.

Technology: IBM RS6000, AIX, INFORMIX, C, Vermont Views API, and SQL.

Project Analyst

: Jewelry Retail Firm - Akron, Ohio 1991

Credit Request Reports transmitted from proprietary point-of-sale systems located in the

client's outlet stores were forwarded to the corporate office for review and approval. The

project required analyzing the proprietary point-of-sale system to reverse engineer the

communications protocol. Responsibilities included developing a server-based process that

communicated with the P.O.S. systems, credit bureaus and the Mainframe. A file

transmission queue was maintained to ensure the critical FIFO ordering. The system was

designed to allow multiple concurrent queues and was user configurable for load balancing

and to handle seasonal data volume. Tools were developed for system tuning, monitoring and

printing reports.

Technology: UNISYS, System V R3.2/R 4.0, INFORMIX, C, and SQL.

LEADERSHIP: While engaged in the above consulting assignments, advanced through the

management of a dynamic start-up consulting firm whose revenues increased more than 500

percent during that time span:

* Vice-President: OneNet ICI - Cleveland Ohio

July 1996 - March 1998

Management and coordination of corporate support functions. Executive coordination

between Specialty Practice Groups, Emerging Technologies Consulting Group, Operating

Managers, Training, Special Projects and Services. Duties included participation in the

development of new clients, proposals, RFPs and presentations; Training and mentoring new

managers and project leaders; Technical training for staff prior to engagement; Career

counseling planning and management. Technical component in the team development of

marketing opportunities. Technical anchor and advisor in client engagements as well as in-

house projects. Client contact in select engagements and hands-on technical participation

as needed.

Operations Manager

: OneNet ICI - Cleveland Ohio July 1995 - June 1996

Participation in the development of new clients, proposals, RFPs and presentations.

Technical representation in marketing calls. Corporate support for Account Managers and

staff engaged at client sites. Participation in the development of corporate policy and

procedures.

Account Manager

: OneNet ICI - Cleveland Ohio September 1992 - June 1995

Liaison between client and parent company. Management and responsibility for employees

assigned to the client site. Assist in identifying and implementing growth of account,

company policy and relationship with client. Technical anchor for company staff assigned

to client site.

EDUCATION: Colby College,

Waterville, Maine, B.A. May 28, 1989

Double Major: Mathematics and Physics

Concentration: Computer Science

Honors: Magna cum Laude, Phi Beta Kappa

Sigma Phi Sigma - Honorary Physics Society

Bixler Scholar Award 1986, 1987, 1988

Case Western Reserve University,

Cleveland, Ohio

11/2 years of Post Graduate

studies in Computer Science

PROFESSIONAL AND PERSONAL REFERENCES AVAILABLE ON REQUEST

Contact this candidate