• Pre/Post sales - Demonstrated and supported DataRobot architecture, integration, and model deployment capabilities across many technologies, customers, and use cases• Advised customers on best practice scoring pipelines given use case, technical stack, and scoring burdens (eg. real time 20 calls/second, batch scoring of 30m rows daily)• Created a variety of dashboards with on-prem and SaaS usage data to identify meaningful insights and actions to take• Participated in new community user forum, including authoring 17 articles ranging from best practice advice to detailed end to end solutions

Solutions Architect at the hottest growing consulting firm in Chicago.• Provided Modern Data Architecture solutions on the AWS Cloud platform• Snowflake Database, Matillion ETL, Lambda, SQS, SNS and more

Sysadmin, DBA, data modeler, & SQL/SAS/Tableau developer for all things Netezza.• Three physical boxes, TwinFin3, TwinFin12, Mako10• Wrote custom warm Disaster Recovery (DR) scripts to automate database shipping DR environment• Wrote custom history reporting queries and marts. User and group experiences across many metrics can be produced. ETL performance and health metrics are also available.• Wrote custom SQL watching scripts to trigger action when problematic hand written SQL situations are produced. An e-mail is sent to users noting the opportunity for improvement and logged into the system.• Ported Oracle warehouse objects to Netezza data warehouse• Learned SAS Programming and assisted in porting SAS jobs to NZ; multiple 10+ minute SAS on NZ programs rewritten to be 10 seconds or less. These numbers are for *average* cases, not the biggest wins!• Created and delivered multiple rounds of SAS best practices training.

Sales and support for the PureData for Analytics / Netezza data warehouse and analytics appliance and IBM Big Data portfolio. Primary coverage areas across Illinois, Wisconsin, and Minnesota.

First Chicagoland Business Intelligence Consultant!

• Quickly learned custom built CRM application with no documentation• Documented technical architecture and back-end processes• Designed and built ETLs based on unix shell scripting and PL/SQL• Discovered data integrity problems, performed data analysis and proposed resolutions• Modeled tables and designed loads to bring in new Safety subject area data to Exadata warehouse• Created and validated complex dashboard metrics

• Created Business Objects Xcelsius dashboards to meet needs of multiple areas of the business• Designed database, ETL, and Business Objects universes to meet dashboard and WEBI reporting needs• Replaced 2+ week manual process to report complaints in a fixed view with a daily updated dashboard with multiple dimensions available to the entire enterprise. Presented dashboard to the CIO• Created a dashboard on complaint resolution metrics. Delivered metrics that the business had previously been told were too difficult to create• Created near-real-time call center dashboard to display actual call center metrics versus forecast activity. Dashboard includes automatic diagnosis of poor service level based on business logic• Created system availability dashboard to slice application outage by time to reveal trends and allow more meaningful calculations of uptime• Created several other dashboards, applications and one-off reports

• Ported MS Project custom reporting solution into Investments from Claims area with enhancements• Modeled and created SQL Server database to store data from Microsoft Project Server and Sharepoint• Designed and built SSIS ETL jobs to extract data from Project Server tables and Sharepoint lists• Created excel macro tool to connect to database and generate excel reports

• Designed Netezza distribution scheme and created DDL scripts• Replaced Oracle functions and procedures with logic in ETL designs and views• Advised schema enhancements to fully utilize dimensional modeling benefits

• Modeled data mart to support creation and replatform of existing excel based capacity report to Business Objects/SQL Server• Modeled slowly changing resource dimension among others, including the recursive rebuild of the organizational reporting structure (unbalanced hierarchy)• Designed Extract, Transform, Load (ETL) process to be used for populating project data mart via Microsoft SSIS from Microsoft Project Server system of record• Designed ETL process to detect changes in data should the business be unable to provide delta data only

PTAG (Products Technical Architecture Group)Intern -> Analyst -> Consultant

• Created data mapping and component design documents• Built, tested, tuned and scheduled ETL jobs to load ODS and Data Warehouse• Reconstructed existing ETL with order of magnitude speed improvements • Quickly learned Cognos ETL tool without training and trained colleagues in its usage• Advised improvements to target warehouse database model

• Lead Data Architect for Factory Raw Data Store (RDS)• Created size estimation model and estimated database to be 30 terabytes• Tested several modeling approaches to determine feasibility of options• Created data model to store the raw data collected by a multitude of sources in disparate formats• Designed model with flexibility to add new types of source record data with no change in physical table structure• Designed model to support future processes to manipulate and standardize data while maintaining entire record history• Created conceptual, logical, and physical database design deliverables and scripts• Created java batch program to load post-ETL data to Netezza database• Trained colleagues in maximizing performance of Netezza database

• Net improvements resulted in 2 day process to a few minute process• Learned client data warehouse quickly during short term high visisbility project• Created model to store multiple product hierarchies with various depths (client defined) • Created Java batch program to calculate and aggregate facts at all levels of product and (client defined) market hiearchies• Recognized and reported several bugs in Netezza to vendor• Created documentation and became Subject Matter Expert for Netezza performance tuning• Advised several other projects at other clients on how to maximize Netezza performance• Modeled relational data to meet complicated marketing requirements• Suggested improvements to dataflow which shortened ETL load time

• Modeled and created or improved 80% of 114 table database representing complex marketing data• Modeled abstract custom marketing concepts extensively across product dimension• Acted as functional subject matter expert in multiple areas of very custom client business• Worked with client contacts and team to analyze and resolve loosely defined processes• Developed and reviewed SQL for java application team data access objects• Wrote PL/SQL procedures and fuctions to generate data for crystal reports• Wrote PL/SQL procedures to perform business logic for application where appropriate• Designed or improved various application component logic; complex characteristic resolution algorithm improved 30x over original• Created and maintained realistic test data• Supported work in multiple environments and maintained database consistency with migrations across all• Wrote unix shell script to deploy database and all objects within schema

• Prioritized and managed work effort in over 20 separate environments• Investigated and resolved unfinished flows• Reduced failed data by 95% for multiple environments providing a savings of 4 man-hours daily in each• Identified interface problems in EAI code and requested tickets for code fix and migration• Became expert and trained teammates on the resolution of flows in Peoria, Manila and Buenos Aires• Coached client customers in the process, investigation and resolution of failed flows on-site in global locations• Modeled data and created asp tracking system for gathering team and environment status metrics• Created asp tools for resolving individual flows which queried EAI, ERP, and Siebel CRM databases - slashing 10+ minute investigations into seconds• Led weekly global status meetings among team members to discuss assigned client environments• Identified and suggested resolutions for problem situations in client 6 Sigma project for unfinished flow reduction

• Prioritized and managed work effort in over 20 separate environments • Supported shared architecture consisting of database servers, terminal servers, and load balanced IIS webservers• Identified database collation problem in Backup Recovery Process; created and executed plan to correct collation for multiple production databases in global datacenters• Performed code migration for fat client and web application• Applied security patches to MS SQL database servers• Resolved security and configuration issues created by sharing servers amongst multiple environments• Administered users MS SQL database and windows domain groups• Administered users in front and back office of application• Provided deployment support when deploying application suite to new client customers (CAT dealerships)

• Created initial phase project documentation and design• Diagrammed to-be proposed solution architecture

• Created network and server architecture diagram to work on connectivity issues• Performed miscellaneous database work

• Spent all day essentially manually inputting credit cards• Didn't fall asleep or go crazy

• Developed batch style work processing which peers adopted due to enhanced productivity• Wrote computer macros to replace repetitive manual work

• Rocked the grill area• Didn't Q (microwave) the lettuce on sandwiches like lazy peers• Handled all 4 grills producing 12 patties apiece for hours during the Beanie Babies rush