Data Manager
Resume:
Breakthru Systems Development, Inc.
Coral Springs, FL 33065
***@***.***
Aaron L. Dukes
Objective: Challenging position as a leader and innovator in
championing, designing and implementing Analytical Business
Intelligence methodologies and systems utilizing my
formidable skills and experience in:
. Data Mining, Predictive Modeling
. Designing and carrying out Statistical Experiments
. Architecting and Implementing Analytics-Driven Decision
Support Systems
to achieve corporate mission-critical goals in Business,
Financial and Marketing Performance Measurement and
Optimization;
or as a
. Lead Clinical Statistical Programmer
. Manager, Statistical Programming
. BioStatistician: (Clinical Trials, Experimental Design,
Response Surface Modeling)
at a Pharmaceutical, Medical, or Contract Research
Organization.
Summary: 30 years experience as a SAS Developer, Data Analyst, and
Statistician. Expert with designing, developing and
implementing SAS/Macro - based systems to automate data
management, data warehousing, ETL, statistical analysis, and
tabular reporting. I proficiently integrate SAS with other
applications such as Sybase and Oracle (using SAS/Access and
the SQL pass-through facility) to extract data and create
source databases, and with MS/Excel (using ODS) for tabular
reporting. I also design optimal statistical experiments
for non-standard situations and carry them out, automating
the discovery and modeling of statistical relationships,
with particular expertise in response surface modeling,
parsimonious multiple regression, logistic regression, Cox
regression, growth curve analysis, repeated measures,
rerandomization significance determination, equivalence
testing, cluster analysis, mixed modeling, automated
forecasting, and data mining.
I function well in each of the roles of Statistician and
Programmer, and can fuse them into a synthesized whole,
enabling my clients to leverage my versatility and my bigger-
picture view. Similarly, my experience across a broad
range of industries enables me to capitalize on
opportunities for cross-fertilization of approaches from one
industry to another.
My areas of application include:
. Retail and Consumer Packaged Goods (3 years with SAS
Institute and Prognos enabling and implementing SAS
Institute's Solutions for the Retail industry at 4 major
retailers)
. Financial Systems Design, Development and Statistical
Modeling (3 years at Bankers Trust, McKinsey, JPMorgan,
and CX/Analytics),
. Market Research (3 years at Avon, AT&T, ICE.com &
TiqIQ),
. Telecommunications Reporting Systems Development and
Regulatory Compliance Analysis (8 yrs: CGEY, DCI, NECA,
Unified Systems Solutions, AT&T Solutions, Predictive
Systems),
. Statistical Experimental Design, Modeling and Analysis
of Oil Additive Mixtures (4 years at Exxon Chemicals),
. Pharmaceutical and Medical Research Clinical Trials
Statistical and Programming Support (10 years at: TKL
Research, Knoll, Sandoz (now Novartis), Sloan-Kettering,
Montefiore).
I have both a B.Sc. (Computer Science and Statistics) and an
M.Sc. (Statistics) at U of Manitoba, and took all the
courses and passed the qualifying exams towards a Ph.D. in
Statistics at Rutgers.
Experience:
9/07 - present SAS Institute, SAS Canada (via Prognos) - SAS
Retail Analytics Consultant USA & Canada
. Designed, developed and implemented processes and systems to
enable automated analysis and reporting of sell-thru, recovery,
and model health achieved by SAS Markdown Optimization at a major
retailer.
. For a large chain of self-serve, cash-and-carry neighborhood
discount stores
> Developed process and systems enabling automated production of a dynamic
decision support tool for retailers to perform SKU rationalization
> Performed data integration, statistical cluster analysis and reporting of
different clusters' market demand patterns and their corresponding
demographic profiles
. In order to accurately forecast localized weekly production and
demand for the Food and Snacks Division of one of the world's
largest prepared foods companies, taking into account promotion,
pricing and calendar event effects, developed analytic processes
and systems enabling
> calculation of weekly effective percent discount;
> repeated measures lift estimates of effects of promotions, discount
depth, pantry loading, calendar events
> CPI adjustment of prices and sales
> SAS HPF automated model selection, fitting and forecasting
. Advanced the implementation of SAS Regular Price Optimization at
one of Canada's largest food retailers
> Developed improved automated Forecast Accuracy reports
> Analyzed anomalies to determine how to improve Model Configuration
> Performed Model Calibration
> Developed processes to combine and refine data from many sources to build
historic, and preprocess incremental staging files for loading into SAS
Demand Intelligence Data Mart. Performed incremental loads. Analyzed
load exceptions and recommended upstream process improvements.
. SAS (Base, Macro, STAT, ETS, SQL, Enterprise Guide, Revenue
Optimization, High-Performance Forecasting, CONNECT, ODS, ExcelXP
tagset, Management Console, Demand Intelligence, Markdown
Optimization, Regular Price Optimization, DI Studio), Excel,
Windows, AIX, Unix shell scripting, FTP
7/09 - present TiqIQ, (a startup event ticket aggregator) -
Predictive Analytics Consultant NY and Israel
. Designed compact form for data entry of venue seating plans and
face prices;
. managed data entry and reviewed and improved data quality
. Developed text analysis process to determine most likely section
and row from free form ticket listing information. Combined face
prices with all ticket information and performed cluster analysis
to determine initial section grading.
. Demonstrated feasibility of successfully predicting direction of
ticket prices using time series methods.
9/09 - 10/09 CX/Analytics - SAS Financial Services Developer
Franklin, TN
. For an overseas bank's credit card operations, provided major
functionality enhancements to the process which loads all credit
card operations related data: collections, phone call records,
payments, customers, personnel, etc, and combines them into an up-
to date view whenever the underlying data has been updated.
3/07 - 8/07 TKL Research - Senior Biostatistician and Statistical
Programmer Rochelle Park, NJ
. Wrote Statistical Analysis Plan, performed Blinded Data Review,
and programmed production of Tables, Listings, and Graphs for
clinical trials demonstrating bioequivalence of a generic Candida
therapy with a standard treatment, and demonstrating efficacy and
safety of an adjunct treatment for acute respiratory infections.
. Designed and prototyped innovative and efficient approach to
clinical trials information processing flow.
. SAS, Excel, ODS RTF
7/04 - 8/06 McKinsey & Co. - Corporate Financial Performance Metrics
SAS Developer New York, NY
. Designed and developed systematic codification of corporate
financial knowledge and best analysis practice, and implemented
it on large corporate database to produce a data warehouse
serving comprehensive up-to-date corporate finance data and
analytical capabilities to be used by all McKinsey consultants.
. Designed and developed a querying and reporting system using the
abovementioned data warehouse, incorporating complex
summarization, and producing automated reports in the form of
nicely formatted multi-sheet Excel workbooks using SAS's ODS
ExcelXP tagset.
. Researched anomalous results to determine coding errors or
incorrect source data.
. SAS, Oracle, Excel, DDE, ODS
7/05 - 11/05 ICE.com (200)- Data Mining / Market Research Analysis
. Cleaned data obtained from web-site clicks, and built a market
analysis data mart.
. Determined value-related segmentation drivers, value of customer
by market segment
. Reviewed and evaluated resumes for Senior Data Mining Analyst
position.
. SAS (Base, Macro, STAT, Enterprise Miner, SQL, ODS, ACCESS,
ExcelXP tagset), Oracle, Excel, Windows XP
8/99 - 7/04 Cap Gemini, Doherty & Co. - Performance Audit
Statistician CA, AZ, PA, NY
. Wrote Statistical Approach sections for proposals to several
state Public Utility Commissions to demonstrate parity of RBOC
Operational Support Systems service for Competitive Local
Exchange Carriers with RBOCs' own Retail Service and to audit
accuracy of supporting data and implementation of RBOC
Performance Assurance Plans.
. Designed efficient and robust statistical experiments properly
controlling the risk of decision-making errors, determined their
test generation parameters, liaised between ILECs and CLECs on
the relevant statistical issues.
. Developed SAS-macro based systems to readily generate performance
measurement results in accordance with a range of different
statistical approaches.
. Audited RBOC performance measurement systems to determine whether
measurements were being calculated as documented. Initiated
rapid prototype application development of refined performance
measurement data and results as a code-testing and auditing
technique with greatly improved reliability.
. Reconciled CLEC-received and ILEC-stored ordering, provisioning
and repair data.
. Represented test administrators, auditors and state PUC's
technically in California and Arizona state 271 application
proceedings and in Pennsylvania and New York performance
assurance audits.
. Excel, SAS (Base, Macro, Stat), Win/95/2K/XP, Excel, Word,
Project, WinZip
3/99 - 9/99 National Exchange Carrier Association - SAS
Programmer/Analyst Whippany, NJ
. Converted telecommunications databases, systems and user
applications from MVS to Client/Server Architecture
. SAS (Base, Macro, Connect), MVS/TSO, AIX, Win/95, ReelExchange
2/98 - 2/99 Knoll Pharmaceuticals - Clinical Trials Statistical and
Programming Support Mt. Olive, NJ
. Designed, developed and implemented SAS/Macro-based systems for
clinical data management, statistical analysis and NDA table
production for a stroke drug. These included general
infrastructure, laboratory analyses, time-window definitions,
units conversions, efficacy, mortality and adverse event
analyses, integrated safety and efficacy summaries (ISS / ISE)
. Led project team in preparing data and programs for electronic
submission of Statistical Section of BLA to FDA Center for
Biologics Evaluation and Research.
. Performed statistical validations of other programmers' work;
provided extensive statistical and programming support to
Biostatistics and Data Management.
. SAS (Base, Macro, Stat, Graph, Connect), Excel on VAX/VMS and
Win/NT/95.
6/97 - 2/98 Predictive Systems - Telecom & Finance Web Reporting
Application Developer New York, NY
. Designed, developed and implemented a SAS/macro report generation
application system to enable standardized requesting of a variety
of data summarization and subsequent tabular and graphic
reporting modules for Web-based Reporting of network performance
data managed by IT/ServiceVision. For a major Network Operations
Center.
. Designed, developed and implemented a network resources
chargeback accounting application based on IT/ServiceVision-
managed data for a financial services client. Data Warehoused
via ITSV, SAS macros, Perl scripts.
. SAS (Base, Macro, Graph, ITSV, Web Enablement Tools), Excel,
Oracle, Perl on Sun/Solaris and Win95
8/94 - 7/97 Unified Systems Solutions, AT&T Solutions - SAS
Application Developer Florham Park, NJ
. Developed Global Service Center Performance Metrics Reporting
Application, an AF-Frame/SCL GUI with multiple dynamic
interdependent context-sensitive listboxes calling 50 SCL entries
to generate appropriate report.
. Designed and developed bulk load and incremental update processes
to build a Unified Reporting Datamart via Sybase triggers on
Asset tables and Remedy-generated Trouble Ticket tables.
. Developed SAS/CPE Performance Reporting Subsystem with batch-
scheduled HP OpenView-managed SNMP data collection, gathering,
and processing into PDB's, distribution of the PDB's and batch
and interactive generation of Router and LAN Utilization reports.
. SAS (Base, Macro, CPE, Acc/Sybase, SQL, AF/Frame/SCL, Connect,
QC) HP OpenView NNM, Unix, shell-scripting, Sablime, Sybase.
5/95 - 11/95 AT&T Marketing Sciences - Statistical Marketing Data
Analyst Basking Ridge, NJ
. Analyzed effectiveness of various marketing programs in retaining
and acquiring customers and stimulating usage
. Analyzed Local vs LD company preference in bundled service
environments
. Initiated survival analysis approaches for customer retention and
acquisition.
. Managed integration of multiple large datasets from different
platforms.
. Developed macros to assist in data management and statistical
modeling.
. SAS (Base, Macro, Stat, Connect, DDE), S-Plus(CART), Excel,
FoxPro, Word, MVS/TSO, Windows
11/90 - 6/95 Sandoz Pharmaceuticals - Clinical Trials SAS Programmer &
Statistician East Hanover, NJ
. Designed, developed and implemented flexible and modular
SAS/Macro systems to prepare several hundred statistical tables
for final NDA reports for several classes of medications. These
systems write the appropriate SAS statements to perform complex
data management and statistical analyses, generalized tabular
reporting including border characters, downloading of listings
and their conversion to final Wordperfect documents, all with a
minimum of user effort (See my contribution to SUGI -18
Proceedings).
. Designed and developed SAS/AF/Frame/SCL front end to encompass
generalized Clinical Pharmacology studies and New Drug
Applications
. Provided innovative statistical analysis leadership for a major
multi-center Cardiovascular clinical trial. Designed, analyzed,
and wrote up for publication a longitudinal quality control study
of the Ultrasound Reading Process.
. Managed and upgraded central library of common statistical
programs and utilities
. SAS (Base, Macro, Stat, AF, Connect); Wordperfect macros; VM/CMS;
VAX/OpenVMS; DOS, OS/2, Windows
3/90 - 10/90 Bankers Trust Global Markets Credit, Credit Policy -
Financial Data Mgmt, Modeling, and Reporting
. Designed and developed programs to combine customer and facility
info with outstanding swap, foreign exchange and currency options
transactions
. Designed and developed menu-driven financial reporting
application (AF)
. Modeled spread transactions using auto-regressive time series
. Proposed multidimensional approach to computing credit risk
exposure for long-term transactions involving several currencies
simultaneously
. Studied commodity price and volatility distributions. Determined
standard option pricing model based on unrealistic assumptions;
proposed a simpler and more appropriate model whose impact would
permit more business with each counterparty without increasing
credit risk beyond tolerance limits.
. SAS (Base, Macro, Stat, ETS, AF, Connect, Access/Rdb); Excel;
VAX, PC
3/85 - 5/90 Exxon - Statistician, Statistical Systems Manager,
Scientific Applications Developer Linden, NJ
. Conceived and championed Formulator's Assistant, an AI-based
advisory system to help chemists and engineers formulate cost-
optimal performance additives meeting multiple engine test
requirements based on automatically updated nonlinear
multivariate models.
. Evaluated hardware and software platforms for modeling capability
and user-friendliness. Proposed combining Macintosh front-end
with VAX-based statistics, graphics, and database management.
. Negotiated almost-free long-term pilot test of MicroVax II and
BBN's RS/Explore data analysis advisory system and RS/Discover
automated experimental design system. Motivated and assisted
several professionals to each use the software to come up with
new previously unattainable discoveries, each worth more than the
entire system cost, thereby achieving cost-justification of
system purchase.
. Drafted and implemented division-wide three-tiered networking
architecture, with MicroVax as hub, acting simultaneously as:
file-server to 60-user Ethernet PC and Macintosh network,
communications gateway to corporate mainframe databases, and
scientific computing, data analysis and molecular modeling
computer.
. Took complete systems management responsibility (installations,
updates, backups, telecommunications, troubleshooting, tuning,
vendor relations, until I built a team consisting of VAX
Systems Manager, Network and PC technician, Statistical
Assistant / User Contact, and Backup/Supplies/Data Entry Clerk.
. Solved the problem of predicting additive formulation stability
using multivariate survival analysis. Used resulting models to
design and implement a user-friendly system to predict stability
of as yet unblended formulations.
. Initiated use of Macintosh to prepare technical presentations and
brochures.
. Created, maintained, updated, and enhanced several large
databases.
. Award: employee most contributing to goal of Continuous
Improvement
. Customized course design, training, and application of RS/Explore
and RS/Discover software
. Authored report on alternatives for a statistically-based
industry-wide (automobile manufacturers, oil companies, additives
suppliers) Candidate Oils Approval System (see publication cited
below)
. Designed and developed hierarchical menu-based Chemometrics
Toolkit for statistical and graphical exploration and analysis of
analytical spectra and chemical properties using Principal
Components Regression and graphical diagnostics.
. Introduced and implemented a new method of background correction
for infrared spectra
. SAS (Base Stat FSP): BBN RS/1, RS/Explore, RS/Discover; VM/CMS,
Microvax/VMS, PCs, Macintosh, DEC Networking and File Services;
Precision Visuals / Wave
10/88 - 11/89 Avon Products (3000) - Statistical Modeling,
Marketing Analysis New York, NY
. Analyzed sales incrementality, cannibalization amongst product
categories.
. Performed nonlinear forecasting, modeling, optimization under
synergies and antagonisms
. Assembled historic databank from several sources containing
potentially useful variables for forecasting and modeling sales
and profit
. Recognized non-linearity of effects of variables on sales, and
synergies (and antagonisms) of product category advertising
emphasis with seasonality factors
. Used quadratic response surface analysis and iterative variable
selection to produce a reasonably precise, yet very parsimonious
model for the time series.
. Performed constrained nonlinear optimization to derive optimally
successful (seasonal) mixture of product category advertising
emphasis.
. Model successfully predicted sales and profit within +/- 5%over
the next 20 2-week sales campaigns, and was implemented as the
company standard to predict cannibalization and incrementality of
new product lines.
. Developed spreadsheet-based cannibalization/incrementality
decision support system.
. SAS (Base Macro Stat ETS Access/SQL-DS), Excel; VM/CMS,
Macintosh
7/80 - 4/85 Sloan-Kettering Institute, Montefiore Medical Center
New York, NY
Research Statistician, Scientific Programmer,
Statistical Image Modeler, Systems Manager
. Performed data management and statistical analysis of health
outcomes on large medical and epidemiological databases:
Descriptive and Graphical Analyses; ANOVA; Survival Analysis;
Prognostic risk factor identification by stepwise multiple
logistic & Cox regression; Residuals Analysis; Wrote Methods &
Results sections of publications; Designed multicenter clinical
trials comparing therapies for polyps and mutagenicity
. Coordinated Software Development; Designed, developed, tested and
implemented statistical software packages; Assisted statisticians
and programmers in use of available software; Designed and
organized a seminar series Software Review, on descriptive data
analysis, survival analysis, model fitting, data management, and
graphics
. Researched Sample Size and Power Considerations for clinical
trials, Growth Curve Analysis; Smoothed Locally Weighted
Logistic Regression
. Developed techniques for Maximum likelihood Positron Emission
Tomography image reconstruction; Improved simplex method
nonlinear optimization; Optimized CAT-scan sequencing via
simulation and nonlinear model-fitting; Calibrated PET scanner,
evaluated its performance and controlled its quality
. Was completely responsible for VAX/VMS Systems Management;
evaluated and tuned its performance; Ensured user-friendliness
and security of applications; Interfaced Forms Management, Data
Retrieval, and Statistical software to achieve a unified and
complete Screen Data Entry / RDBMS / Stat Analysis system
functionality for new applications
. Fortran, SPSS, SAS (Base, STAT), BMDP, FMS, Datatrieve, CDC-6000,
VAX/VMS, PDP-11, IBM MVS/TSO
8/81 - 3/85 Rutgers University, Dept of Statistics - Instructor and
Consultant Statistician New Brunswick, NJ
. Taught several introductory courses in Statistics
. Performed statistical design and analysis of experiments for
university research projects in the areas of Zoology, Nutrition,
Radioactive contamination, Ceramic Engineering, Forestry,
Psychiatric Nursing.
. SAS (Base, STAT), IBM MVS/TSO
Education:
(70-73) University of Manitoba, Winnipeg, Canada B.Sc. 1973
Computer Science and Statistics
(73-75) University of Manitoba, Winnipeg, Canada M.Sc. 1976
Statistics
(76-76) Weizmann Inst of Science, Rechovot, Israel Cert.
1976 Statistics & Computing: Isotope Research
(76-77) University of Manitoba, Winnipeg, Canada PhD Studies
in Statistics & Operations Research
(77-77) Case Western Reserve U, Cleveland, Ohio PhD Studies
in Systems Engineering, Math & Statistics
(77-79) Rabbinical College of America, Morristown, NJ Jewish
Philosophy and Law
(79-80) Yeshiva Gedola of Seattle, Seattle, WA Jewish
Philosophy and Law
(81-83) Rutgers, New Brunswick, NJ PhD
Candidate in Statistics
(83-83) Digital Educational Services, New York, NY Dipl.
1983 VAX/VMS Utilities and Commands
Dipl. 1983 VAX/VMS Systems
Management
(87,88) Gordon Research Conference, New Hampton, NH
Statistics in Chemistry and Chemical Engineering
(88-88) BBN Software Services, Cambridge, MA Cert. 1988
Advanced RS/1
Cert. 1988 RPL Programming
(93-93) SAS Users Group Intl Conf New York, NY Presenter
Information Systems Section (see publications below)
(01,05) Intl Torah & Science Conf. Miami, FL
Presenter (see publications below)
(05-05) SAS Education New York, NY Cert. 2005 Advanced
ODS Programming
(05-05) Northeast SAS Users Group Portland, ME Cert. 2005
XML for SAS Programmers
Cert. 2005 ODS Integration
with MS Office
Publications and Reports:
M.Sc. Dissertation-Statistical Decision Theory: Improved Estimation
in Restricted Parameter Space Problems, Univ. of Manitoba, 1975.
. Dukes AL: An evaluation of Brown & Herson's STPLAN - A computer
system for performing statistical calculations needed to plan a
study. Biostatistics Laboratory - Sloan Kettering Institute 1981.
. Dukes AL: A report on sample size and power considerations in
comparing two binomial proportions. . Biostatistics Laboratory -
Sloan Kettering Institute 1983.
. Braun TJ, Dukes AL, Geller NJ, Mertelsmann RH, Clarkson BD:
Chronic Myelocytic Leukemia: A multivariate analysis of prognostic
and treatment variables. Proceedings of the Amer Assoc of Canc
Res, 1983.
. Shonubi P, Dukes AL, et al: Report to the Robert Wood Johnson
Foundation on: Factors affecting location choice of primary care
physicians in medically underserved areas. Montefiore Medical
Center 1984.
. Kearfott, K. J., Thaler, H. T., Dukes, A. L., Carmichael, P. G.:
The Use of Median Polish (MP) for the Daily Quality Assurance of a
Multiplanar Positron Emission Tomograph (PET), J Nucl Med, vol.
25, no. 5, p. P104, 1984.
. Hinkle LE, Thaler HT, Dukes AL, Merke DP, Kantz C: Factors
affecting risk of sudden arrhythmic death among ambulatory middle-
aged men: II. Ventricular Dysrhythmias. Amer J Cardiology, 1985.
. Junck LR, Dhawan V, Dukes AL, Thaler HT, Rottenberg DA: Effect of
stable xenon on regional cerebral blood flow in the rat. Annals
of Neurology 1986.
. Kearfott KJ, Thaler HT, Dukes AL, Carmichael PG: Xenon CT
measurements of regional cerebral blood flow in man: "Baseline
Bias", Repeated least-squares correction for tissue heterogeneity,
Optimal scanning strategy. J Cereb Blood Flow Metab, 1986.
. Thaler HT, Dukes AL: Locally weighted logistic regression.
Submitted to J Amer Statist Assoc, 1983.
. Dukes AL: Alternatives for a Statistically-based Industry-wide
Candidate Oils Approval System - Towards a Level Playing Field.
Paramins Technology Division of Exxon Chemicals internal report.
63pp. Submitted to Motor Vehicle Manufacturers Assoc., 1989.
. Dukes AL: Getting what you want out of the TABULATE Procedure with
Pre- and Post-Processing. Proceedings of the SAS Users' Group
International 1993 Conference (Honorable Mention among
Contributed Papers, Information Systems Section).
. Dukes AL: Friday After Midday - The Imminent Y6K Problem.
Presented at the Fourth International Miami Torah & Science
Conference, "Time, Space, & Being", 2001.
. Dukes AL : Entering the Sabbath of History. B'Or HaTorah Vol 15,
2005, pp. 115-135.
Contact this candidate