Experience

• 

  Northwestern Mutual

  • Greater Milwaukee Area

  • Data Integration Analyst

    • Oct 2014 - Present
    • Greater Milwaukee Area

    I start Monday.

• 

  The Judge Group

  • Greater Milwaukee Area

  • Data Analyst/ETL Developer

    • Aug 2014 - Sep 2014
    • Greater Milwaukee Area

    Working on Dell Telephony Project on a one month contract for Lochbridge subcontrating through Judge.

• 

  Codeworks, Inc.

  • Greater Milwaukee Area

  • ETL/Workflow Developer

    • Jan 2014 - Jul 2014
    • Greater Milwaukee Area

    Artisan PartnersActiveBatch Conversion Project - Worked on project to convert atomized, complex job scheduler workflows from out-of-support version of legacy Tidal scheduler to ActiveBatch scheduler. Workflows which move data between applications, data repositories, and/or data vendors. Interviewed stakeholders to learn and document business processes. Analyzed and documented legacy jobs that served those business processes. Created like-for-like or refactored workflows designs in conjuction with peer reviews and data architect input. Developed ActiveBatch workflows. Conducted unit, end-to-end, and user acceptance testing. Coordinated with ActiveBatch administrator to deploy from test to stage to production environments.

• 

  Compuware

  • Data Warehouse Specialist

    • Oct 2005 - Dec 2013

    I worked at many clients during this time: GE Healthcare, MillerCoors, P&H Mining, and Kohler are among them. Some for multiple engagements.My experience at Kohler as a Data Warehouse System Analyst would be of special note:Worked in a fully-developed data warehouse department pulling data worldwide on a 24/7 schedule from 3 SAP instances and flat file sources using batch and real-time loads. Interviewed team members, business units, SMEs to detail business processes and requirements. Created new and enhanced existing ETL processes. Designed, developed, tested, promoted to production, scheduled, and performed troubleshooting. Promoted new and modified objects between code library, development, QA, and production environments.Deep-dive analyzed data warehouse systems from source to ETL to target, to identify and resolve production data and logic issues. Documented in detail the findings and any recommendations. Analyzed and modified indexes for performance issues to reduce report and cube build time to meet SLA on data delivery. Provided 24/7 support carrying pager on rotating basis, monitored key processes, and helped improve department procedures to minimize development risks and increase efficiency.Tools there: SAP, Business Objects Data Integrator, Oracle, Toad for Oracle, PL/SQL, Visual SourceSafe

• 

  Nemschoff

  • Programmer/Analyst, DBA

    • Feb 2004 - Oct 2005

    Developed web and desktop applications. Performed SQL Server database development and administration. Developed web-based quoting/order application, which enables customer service and registered dealers to select healthcare furniture models and to specify options. Developed applications with MS Access front-ends to maintain system base data in SQL Server such as contracts, discounting, models, options, web page content, and fabrics. Created DTS packages to daily rebuild base data used by the system. Developed and maintained key MS Access and MS Excel applications. Researched, designed, and implemented database maintenance plans for all production SQL Server databases. Performed daily, weekly, and monthly database administration tasks.

• 

  Jagemann Stamping

  • Programmer/Ánalyst

    • Nov 2002 - Oct 2003

    Gathered, defined, and analyzed process requirements. Designed, coded, and supported new applications or changes. Designed, implemented, and administered databases. Trained users. Freed up 15 hours per week of the AS400 programmer’s time by replacing existing time-consuming, multi-stepped, manual process with new reports in a self-service portal/process in Access.

• 

  RTC Technologies

  • Programmer

    • Feb 2002 - Nov 2002

    Implemented enhancements to the company's software product, Scrap Trakker.

• 

  Earth Tech

  • Programmer

    • 1995 - 2002

    Created MS Access database applications, interfaced with Office Automation, for internal and external clients.