Paul Bierwagen

About Paul Bierwagen

BI, Data Warehousing, Oracle RAC 12c, Informatica 6.2 - 9.7.1, UNIX, Linux, Dashboards, Microstrategy 10, Cognos 7.3Specialties: Complex ETL work for Microstrategy dashboards, MDM, Data Governance, ESRI, Python, dashboards, analytics, reports, JDE EOne and Salesforce data integration.

Experience

1. Business Intelligence Analyst Iii

   Interstate Batteries

   Oct 2002 — Present

   Informatica PowerCenter, Informatica MDM, Business Intelligence, Data Warehousing, Oracle 11g, Alteryx, Tableau, SAP MDM, SAP BODS, SAP IS, SAP CMC, Microstrategy, Dashboards, ESRI, Python, UNIX, and Cognos 7.3• Developed and delivered Informatica Master Data Management (MDM) solutions with Weblogic, Informatica Data Quality (IDQ), Trillium Data Quality tool, Informatica PowerCenter, Tidal scheduling tool• Developed and delivered Business Intelligence ETL solutions including Dashboards using Microstrategy, ESRI, and custom built web application written in VB.NET and ASP.NET. • Programmed complex Oracle PL/SQL packages, stored procedures, and functions. Designed and implemented Korn shell scripts in a UNIX environment running Sun Solaris.• Analyzed data using Microstrategy and Cognos Impromptu reports, Cognos PowerPlay cubes, Excel spreadsheets including Pivot tables, and Dashboards with KPI, trend analysis, and inventory depth and breadth analysis and reporting.• Designed, created, implemented, tested, and maintained Informatica PowerCenter Extract, Transform, and Load (ETL) source code using Informatica 6 - 9.1, Oracle 9i - 11g, UNIX, Red Hat Enterprise Linux scripts.

Education

• ESRI User Conference 2014 in San Diego

  GIS, Python scripting

  2014 — 2014

• Texas A&M University

  BS, Computer Engineering

  1989 — 1994

• The University of Texas at Dallas

  MS, Computer Science (Track C - Software Engineering)

  1995 — 2000

Skills

• Oracle Sql
• Informatica Mdm
• Cognos
• Shell Scripting
• Software Engineering
• Access
• Data Management
• Data Warehousing
• Hands-on Training
• Software Development
• Red Hat Linux
• Solaris
• Data Analysis
• Pivot Tables
• Microstrategy
• Soft Skills
• Requirements Management
• Testing
• Sharepoint
• Data Integration
• Software Requirements
• Database Design
• Excel
• Database Administration
• Extract, Transform, Load (Etl)
• Informatica
• Sql Server
• Pl/Sql
• Software Implementation
• Requirements Gathering
• Sql
• Business Analysis
• Microsoft Sql Server
• Dashboard
• Software Design
• Requirements Specification
• Business Intelligence
• Oracle
• Databases
• Requirements Analysis