KARL ROTHENHAUSER
(714)624-8363
krothenhauser@yahoo.com
Highlights of Qualifications
Customer-focused,
senior level information technology professional with experience in business
systems analysis, software development life cycle, software application development,
database development, presentations, customer interface, and product training.
·
Performed business system analysis for a major toy
manufacturer’s market research point of sales system, which reduced data
discrepancies with its Canadian subsidiary and major customers by 80%.
·
Performed system analysis of a start up company's business
process which resulted in an 50% reduction of manual processing for the
delivery of consumer collection information and an 80% integration of stand
alone computer programs.
·
Delivered a PowerPoint presentation to over 100 people at a
major toy manufacturer on Information Technology’s partnering with end user
departments in developing requirements and a template for the creation of
internal business center websites.
·
Designed and delivered for a paint manufacturer a new, first
ever, centralized, Customer Complaint/ Defective Product/Lab Analysis Tracking
application, which improved the tracking of defective product and customer
service by 90%.
·
Developed programs for a major health care insurance
company’s actuarial claims disparity system of major national customer
accounts, which saved $6 million in duplicate claims.
·
Industry experience includes: Health Care Insurance,
Mortgage Insurance, Real Estate Trusts, Manufacturing, Market Research,
Pharmaceutical, Financial, and Government.
Employment History
Experience
Unlimited, Pasadena, Ca. 5/2002
- 9/2003
Project
Manager
·
Planned and managed programs to deliver services to
professional job seekers.
·
Interviewed workshop presenters.
·
Increased number of educational workshops by 100%
Rydek,
Inc., Culver City, Ca. 8/2001
- 12/2001
Business
Systems Analyst Consultant
·
Conducted a JAD planning session with project team and
management for the Port of Los Angeles.
·
Redefined business rules and processes for the acceptance
and storage of EDI data from ocean shipping lines to be used for accounting
reporting.
·
Developed a current Entity Relationship Diagram for the EDI
database of in coming containers from ocean shipping lines using PowerDesigner.
·
Performed analysis on the process of the loading EDI data
from ocean shipping companies into a Sybase database for accounting reporting.
·
Evaluated new
software tools and utilities.
Dibba.Com,
Irvine, Ca. 10/2000
- 2/2001
Senior
Software Developer Consultant
·
Senior developer, mentoring a junior programmer/analyst in
developing applications using PowerBuilder for a large financial institution.
·
Re-engineered two existing applications using PowerBuilder,
PFC, Unix, and Sybase: manual exchange rate/security pricing and foreign
currency.
Metro
Information Services, El Segundo, Ca. 11/1999
- 9/2000
Business
Systems Analyst Consultant
·
Re-engineered a very large existing database to create an
Entity Relationship Diagram for the most commonly accessed tables (100 out of
700 tables), for insurance policy endorsement processing using PowerDesigner.
·
Developed standards for source code control of database
objects using SCCS.
·
Performed an impact analysis on the existing production Unix
shell scripts for insurance policy endorsement processing.
·
Lead developer directing one developer in the design and
implementation of a new reporting module for a real estate trust and mortgage
insurance company using PowerBuilder, PFC, and Sybase.
Mattel,
Inc., El Segundo, Ca. 8/1997
- 10/1999
Senior
Programmer Analyst
·
Developed and enhanced PowerBuilder applications and stored
procedures to support Mattel’s Market Research department.
·
Directed two developers and wrote program specifications for
the WorldWide Licensing and Royalty application.
·
Lead analyst in reconciling programming and data
discrepancies with Canadian subsidiary and major Canadian customers.
Dunn-Edwards Corporation, Los
Angeles, Ca. 7/1995
- 7/1997
Software
Developer
·
Develop a new Customer Complaint/Defective Product /Lab
Analysis Tracking application using full system life cycle development
methodology.
·
Gathered, defined, and documented business requirements,
business process, and business rules for the handling of a customer complaint
for a defective product.
·
Created an Entity Relationship Diagram and designed a new
Customer Complaint database.
·
Developed effective unit, system, integration, and user
acceptance test plans.
·
Developed system documentation, end user’s training manual
documentation, and provided end user training.
American
Digital Technologies, Inc., Costa Mesa, Ca. 1/1995
– 4/1995
Programmer
·
Developed a prototype pharmaceutical contract administration
system using PowerBuilder.
·
Created reports for a supplier and customer pharmaceutical
contract rebate system using PowerBuilder.
MDG
Capital, Inc., Irvine, Ca. 10/1994
– 1/1995
Business
Systems Analyst Consultant
·
Performed system analysis of a start up company's business
process, developed process flow diagrams, and defined system and program
specifications to consolidate multiple standalone computer programs and manual
functions, which resulted in an 50% reduction of manual processing for the
delivery of consumer collection information and an 80% integration of stand
alone computer programs.
Education:
·
B.S. Business Administration, and Business Computer Methods.
California State University Long Beach;
·
California State University Fullerton Extension; Fast Track
Java Programming.
·
University of California Irvine Extension; Relational
Database Design, “C” Programming.
·
University of California Los Angeles Extension; Unix.
Technical
Expertise
·
Operating
Systems:
Windows 98, Windows XP, Windows
Workstation NT, Unix
·
Languages: PowerBuilder,
SQL, PL/SQL, Object Oriented Programming, Java,
Visual
Basic .Net, HTML, UML
·
Database: Sybase, Oracle, MS SQL
Server
·
Applications: ERwin, PowerDesigner, DBArtisan,
Microsoft Office,
Microsoft
Project