Mike Taveirne Email & Phone Number

Chicago, IL, US

San Francisco, California, US

Boston, Massachusetts, US

• 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

Chicago, Illinois, US

• 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

Minneapolis, MN, US

• 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

Armonk, New York, NY, US

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.

Seattle, WA, US

First Chicagoland Business Intelligence Consultant!

Rosemont, IL, US

• 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

Northbrook, IL, US

• 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

Northbrook, IL, US

• 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

Chicago, Illinois, US

• 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

Northbrook, IL, US

• 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

Dublin 2, IE

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

Richfield, Minnesota, US

• 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

New York, NY, US

• 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

New York, NY, US

• 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

New York, NY, US

• 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

Irving, Texas, US

• 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

Irving, Texas, US

• 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

Rosemont, IL, US

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

London, England, GB

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

US

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

Vernon Hills, IL, US

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

Chicago, Illinois, US

• 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

Education record

Bachelors, Computer Science

Computer Engineering