John Welsch

Application Manager @ BI Worldwide, Automotive Solutions Group

Greater Minneapolis-St. Paul Area

About

I have experience with: - Relational databases (Oracle, MSSQL, Postgres) - MongoDB - Data warehousing - Database design - ETL / ELT design build - Oracle ODI - Jitterbit - Informatica - SFTP - Job automation - AWS - AWS RDS - AWS Lambdas - Command line, Linux and Windows - SSRS and SSIS

Experience

  • Application Manager at BI WORLDWIDE
    Aug 2021 - Present · 5 yrs

    Automotive Solutions Group (ASG) Oracle PL/SQL Stored Procedures Software specifications Application/Unit testing

  • Business Application Development Analyst at Hormel Foods
    Jan 2021 - Aug 2021 · 8 mos

    - Oracle Database development - inRiver (PIM) support - Nuxeo (DAM) support - Database & Application troubleshooting - Git - Subversion - Informatica development

  • University of Northwestern - St. Paul (4 yrs 1 mo)
    • Integration & Database Developer
      Oct 2019 - Jan 2021 · 1 yr 4 mos

      Data integration between various CRM systems. Integration between Oracle and SQL Server databases. Design and build database procedures, packages, functions, views etc. Perform query and index optimization.

    • Programmer/Analyst
      2017 - Oct 2019 · 2 yrs 10 mos

      Oracle PL/SQL Development, Process Automation, SQL Server Development SQL Server Reporting Services Data Integration

  • Warehouse Supervisor / Buyer at Rosenbauer America
    2013 - 2017 · 4 yrs

    • Leadership / facilitating: Converted stock inventory management from Manual KAN/BAN to utilizing an in-place ERP system • Led a team to identify bottlenecks and implement new procedures to alleviate these bottlenecks • Submitted a reorganization plan for warehousing and then managed that project with successful results

  • Owner at John Welsch Consulting, LLC
    2007 - 2013 · 6 yrs

    I was an independent manufacturer's representative, included sales, marketing, consulting, training seminars, and technical support covering a multi-state territory for multiple manufacturers.