Matt Mannikka Email & Phone Number

Chicago, Il, Us

Chicago, Illinois, Us

Lenexa, Kansas, Us

* Plan reporting across the company for all database and reporting needs * Manage the development team to create consistent solutions across the company * Manage resources that can support the business from a technology perspective * Assist Finance Team in reporting needs* Work with all the business owners and stakeholders to get requirements and implement * Act as primary technical point-of-contact for several business unit and organization reporting * Help design data models and transformations to build Farm Journal’s data warehouse

Detroit, Michigan, Us

* Translate requirements to data models using ERwin* Author DDL (Data Definition Language) to support reporting needs (Oracle and Teradata)* Create test scripts to validate deployment of structure changes to ensure data quality* Support deployment of changes to production data warehouse and operational data store* Used File-AID/EX to create anonymous, fictionalized data based on real-production data, maintaining relational integrity* Profile Data to create appropriate structures in the data warehouse* Capture metadata for use with InfoSphere (Metadata Workbench)* Work with technical and non-technical people to develop strategies to keep the data our organization needs while purging and/or archiving the rest to reduce cost and improve performance

Detroit, Michigan, Us

• Led development team in the launch of a new data warehouse to coincide with transition to entirely new source environment.• Evaluates, hires, and separates business analysts and developers. • Gathers business requirements; analyzes content of data marts in Oracle to validate ETL meets requirements. • Quickly troubleshoots and corrects issues with data extracts sent to outside organizations using UNIX scripting and regular expressions.• Authored SQL to fix data quality issues present in the data warehouse.• Evaluates various consultants and software tools to improve performance and capability.• Provides updates for internal customers on the status of new development.• Leads Data Governance

Detroit, Michigan, Us

• Improved transaction performance of various wireless service providers beyond service level objectives by providing comparison of telephone provisioning metrics against their peers.• Proposed and led move to change from value added network (VAN) provider to direct business-to-business transactions using AS2 protocol, eliminating substantial operational cost.• Provided technical advice in contract negotiations with wireless service providers.• Provided business requirements for application programming interface (API) specifications, including a patent-pending method for handling failed transactions.• Subject matter expert in telephone number provisioning.• Managed hardware supply chain for telematics devices.

Detroit, Michigan, Us

• Led a team of twelve individuals to fix approximately 1,000 vehicles affected by a software issue.• Managed thousands of phone number changes required by area code splits leveraging a variety of software and technology including Oracle, Solaris, PERL, sendmail, Java, MS DOS, and Access.• Managed various automated processes to correct various issues experienced by subscribers.

Master Of Science Information Technology, Information Systems Management

Bachelor Of Arts, Spanish Language And Literature, Secondary Education