Lead analytics projects in web search, marketing, finance, CPG, health insurance, and telecommunicationsLead analytics projects around credit scoring, customer segmentation, customer LTV, shopper profile, click-stream analysis, propensity modeling, incentive offersRecent Analytics Projects:For a major retail / CPG data aggregator and coupon platform, I designed a system to cluster source code of 10k SAS programs to identify commonality of data sources and data preparation routines. I implemented the initial version in Python and supervised development of a "quick win" version in SQL and Java, then a more sophisticated version using Python scikit-learn. For a top-three US automotive search site, I implemented a predictive model in R for click-through propensity, with some features derived from a collaborative filtering system I designed to classify products based on consumer search history at the site.For an international CPG manufacturer, I redesigned an existing modeling process in R to use Hive for data preparation, R for modeling, and Hive for model prediction resulting in very large efficiency gains. I also demonstrated moving the modeling process from R to Spark (with examples in both Python and Scala).For a US housing lender, I designed a system to use their MPP system directly to calculate financial metrics such as IRR, rather than transferring data to SAS to perform calculations.

Design and support multi-terabyte analytics warehouses accessed by SAS, R, and BI toolsLead projects to design multi-terabyte databases on the Netezza MPP platform and to implement ETL to Netezza from Oracle, web log flat files, and other sourcesLead projects to implement the Aginity Amp™ platform (also known as Aginity Customer Intelligence Appliance, and as IBM PureData Solution for Customer Insight)Lead predictive analytics projects supporting multiple data science resources creating thousands of analytic attributes over billions of rows of dataLead analytics projects around customer segmentation, shopper profile, click-stream analysis, propensity modeling, incentive offersDesign and implement BI tagging system for a major automotive search engine

Administer SAS 9.2 EBI environment with 80 TB of data, supporting 600+ users; applications include Enterprise Guide, Enterprise Miner, IML Studio, Web Reports Studio, SPD Engine, SPD Server, and Information Delivery Portal (JBoss on AIX mid-tier)Administer SAS 9.2 Advanced Analytics environment with 20 TB of data, supporting 30+ advanced quantitative usersInstall and Administer SAS 9.3 environments with SAS Customer Intelligence – Marketing Automation on AIX compute and Metadata tier and Windows mid-tier using WebLogic; Prod and QA environments, each with multiple contextsDesign ETL both within the SAS environment and from outside data sources including Netezza, Oracle, and Microsoft SQL ServerAIX system administration on LPARs on IBM P795 and P595 serversPrototype SAS 9.3 Grid environment with 5 AIX compute nodes, 1 AIX SAS Metadata server, and a Linux RTM serverProvide 3rd level support for SAS Enterprise Guide, SAS Macros, PROC SQLDesign and initiation of enterprise-wide migration to SAS 9.3 and Enterprise Guide 4.3

Lead team of local and off-shore developers to develop ETL and Data Analytics applications in multi-terabyte environment using SQL, PL/SQL, Informatica, QlikViewManage all aspects of software development life cycle in highly regulated health insurance environmentUse Python, Perl, Shell, and other tools to automate Data Warehouse processesUse Python, PL/SQL, and QlikView to automate testing of Data Warehouse applicationsAdjunct instructor for Humana IT Learning Services teaching Advanced User Stories, Agile Team Member, and Agile Product Owner

Design, implement, and document all aspects of development and use of the Data WarehouseCode custom ETL components in Python, Perl, and JavaExtract data from iSeries, Oracle, SQL Server, and MySQLAnalyze organization reporting needs and design tables, views, packages, reports and external tools to support those needs

iSeries database and system administration, and application developmentDevelop server applications to allow users to safely interact with corporate data using iSeries server languages and tools such as PL/SQL, Python, Perl, Jython, Query/400, QMQRY, RPG, and RexxDevelop client applications and reports using Python, Perl, PHP, Rexx, DB2/PL, PL/SQL

Manage research database vendor relationships for hundreds of Kentucky librariesAssist in vendor evaluation, contract negotiation, training, and research database support for Kentucky libraries Lead state-wide work groups with members of various levels of state government and the Kentucky university system to improve research sources and servicesEvaluate use of research sources and services to identify areas for improvement and trainingDesign, manage, and teach online and classroom educational modules pertaining to research methods and sources

Edit, index, conceive, plan, manage authors, type-set and market legal publicationsManage a staff consisting of a graphic design professional and several legal researchersPlan, manage speakers, market and supervise continuing legal education seminarsWrite software to automate the publication pipeline

Consult in the areas of library management, information policy, and software developmentAdvise library clients on vendor selection and evaluation for information resources, library management systems, and other technologiesDesign and implement technology projects in public librariesDocument existing iSeries databases for migration to commercial Unix systemWrite Python, Perl, and SQL to extract iSeries data, clean it and prepare it for loading on other systemsSpecialized, complex reporting and data aggregation Perform security functions including changing system passwords and analyzing security logs for possible intrusion attemptsWrite database applications to add features to legacy system without re-writing RPG codePlan and perform end-of-year processing Instrumental participation in planning and executing a multi-year, multi-million dollar project to convert one of the largest public library systems in the U.S. from a legacy, iSeries-based library catalog to a commercial Integrated Library SystemDatabase administration for DB2/400 (IBM iSeries), Microsoft SQL Server, and MySQL on both Linux and Windows 2000 Advance ServerDevelop software for data conversion among disparate systems including legacy catalogs, OCLC, Innovative Interfaces, DRA, Sirsi, Clio (ILL system) and dozens of PC-based programsDuring annual audit by the state of Ohio, provide reports and answer questions regarding iSeries security, operations, and disaster planningConfigure Client Access in Citrix/Windows 2000 Advance Server environment

Analyze case law and produce concise case summaries within established editorial guidelines

Supervise professional and support staff, including library trainers, technical writers and computer programmers and techniciansAdminister all aspects of AS/400 databases including design, implementation, access, and optimizationResponsible for all technical support for both in-house and commercial applications to librarians at the Main Library and in 42 Branch Libraries; responsible for all technical support for the public