Michael Pilotti

About Michael Pilotti

Team lead and application developer for Data Warehouse, Business Intelligence and Master Data Management implementations. Specialties: Data Warehousing, Business Intelligence, Analytical Reporting, Database Administration, Master Data Management, ETL

Experience

1. Senior Database Developer

   Hibu

   Nov 2010 — Present

   Lead developer on a successful conversion from D&B’s Pruisma MDM Product to Informatica’s MDM Product, including development, testing, reporting of conversion effort while working with data governance teamSupporting Informatica MDM for managing business as location domain data sourced from multiple in house and third party data providers, including administration of Hub & IDD applications, and application servers. Lead Developer on multiple successful source system conversions for Informatica’s MDM Product, including development, testing, reporting of conversion effort while working with data governance team.Support processes accessing materialized views for ease of access of business as a location data along with its classification on Oracle 11g database. Develop, Optimize, run and monitor Informatica mappings/workflows and PL/SQL programs for loading data into MDM platform and into the data warehouse, and for extracting from Warehouse for regularly scheduled and ad hoc data requests.Modify IDD application using application configuration parameters.Support data governance team with data quality, data cleansing, re-processing and deleting old source data.Create staging/landing tables, set trust setting at source/column levels, add validation and match rules.Support web services for querying MDM data using different match rules.Manage off-shore operations team.

Education

• Pennsylvania State University

  BS

  1994 — 1999

Skills

• Master Data Management
• Oracle Sql
• Informatica Mdm
• Data Marts
• Microsoft Sql Server
• Data Analysis
• Erwin
• Datastage
• Olap
• Etl
• Performance Tuning
• Obiee
• Amazon Redshift
• Informatica
• Purisma
• Peoplesoft
• Business Objects
• Oracle
• Epm
• Pl/Sql
• Data Warehouse Architecture
• Oracle Pl/Sql Development
• Cognos
• Amazon S3
• Informatica Cloud
• Data Warehousing
• Amazon Web Services (Aws)
• Amazon Dms
• Business Intelligence
• Data Modeling
• Oracle Database
• Informatica Administration