Management Data
Resume:
Bestselling Books
Amazon best seller in Excel books
Top Amazon Hot New Release for Microsoft Application books
Contact Conrad
CONRAD G. CARLBERGCONSULTING STATISTICIAN AND MICROSOFT EXCEL DEVELOPER Profile
Nationally recognized expert in Microsoft Excel and relational databases.
Extensive experience with all methods of statistical inference including
multivariate general linear model, multinomial logistic regression and
predictive analytics. Proven track record of applying data management
and analysis techniques to solve a broad variety of business problems,
from inventory control and budget variances to process control and
performance analysis. Particular strengths in:Decision and Predictive AnalyticsActiveX Data Objects (ADO)Visual Basic for Applications (VBA)Technical SkillsAcceptance sampling and process controlAnalysis software: SAS, R, ExcelDatabases: Oracle, SQL Server, Access Professional HistoryPresident, Network Control Systems, Carlsbad CA, 1995 - 2012
Developed and implemented the following systems for a 500 bed hospital in Southern California (1995 - 2007):
Statistical process control application to track treatment quality
measures, from data identified via cluster analysis in hospital's
operating systemsMethod to share information on doctors' privileges over hospital's network,
restricting sensitive information such as DEA numbers to authorized
usersParticipation on hospital's IRB for experimental design and statistical analysis
Database to define and track and control Engineering Department's
maintenance tasks and new projects; online reporting and response to
trouble ticketsDatabase design for tracking of ongoing treatment provided by thoracic surgeons, cardiologists and burn specialists
Data mining of substance abuse specialists and facilities in Southern
California for referrals to newly established hospital clinic
Sample of corporate activities outside health care industry (1994 - 2011)Asset Management via Regression Analysis
Advised an asset management firm concerning its effort to replace a Modern
Portfolio Theory product. Devised a returns sampling method to conform
to the mathematical assumptions of regression analysis, resulting in
more robust asset allocations.
Created an automated bid system for a major HVAC/CAD software publisher, based
on Excel's external data query and pivot table capabilities. Extract
parts and specifications from the CAD tables and assembles suppliers'
bids to derive the mix that minimizes the contractor's project costs.
Design, create and market software that enables CRM and financial analysis by
users of QuickBooks Premier and Enterprise editions.Director, Inventory and Data Product Management, Regional Bell Operating Company, Denver Colorado (1986 - 1993)
Managed ten direct reports who developed company's data communications product
line and controlled inventory levels for all resale products. Reduced
resale inventory level from $24 million to under $10 million in 18
months. Led the development of a data communications product line.
Negotiated resale agreements. Oversaw product rollouts and ongoing
product management. Education
PhD, Statistics, University of Colorado
MA, Psychometrics, University of Colorado
BA, Anthropology, Oberlin College Selected PublicationsPredictive
Analytics: Microsoft Excel 2010, Que, 2012 Statistical Analysis:
Microsoft Excel 2010, Que, 2011Business Analysis with QuickBooks,
Wiley, 2009 Excel for Accountants, CPA911 Publishing, 2007 Excel Sales
Forecasting for Dummies, Wiley, 2005 Excel 2002: The Complete Reference
(with Kathy Ivens), Osborne/McGraw Hill, 2001Excel 2000: The Complete
Reference (with Kathy Ivens), Osborne/McGraw Hill, 1999Microsoft Office
Expert Solutions, Que, 1996 Managing Data with Excel, Que, 1995
(subsequent edition 2004) Business Analysis with Excel, Que, 1995
(subsequent editions 2004, 2007, 2010)The Excel 5 Professional
Solutions Guide, New Riders Publishing, 1994
Copyright 2012 Conrad Carlberg
******@**************.***
Copyright © 2012 Conrad Carlberg
Contact this candidate