We provide IT Staff Augmentation Services!

Master Data Management Administrator / Modeler Resume

Houston, TX

SUMMARY:

Highly motivated specialist in the MDM, data warehousing and data modeling marketplace. Over twenty years experience in the design and delivery of successful mission critical systems including two years of MDM development and twelve years developing data warehouse applications. Exceptional problem solving and communication skills. Recent experience in the Product Testing, Freight Management and Oil and Gas market segments.

SKILLS TECHNOLOGIES:

  • Informatica MDM Hub Configuration
  • Informatica MDM IDD Implementation
  • Data Warehouse Designer
  • Data Architect / Modeler
  • Informatica MDM 10.1 Multidomain Edition; JBoss EAP 6.1
  • PowerDesigner 16.5; CA Erwin 9.x
  • SQL Server 2008 - 2012 R2; Oracle 11-12g; DB2 9.7
  • Informatica Power Center 8.1.1/9.6
  • Sun Solaris 5.8; HP UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Master Data Management Administrator / Modeler

Responsibilities:

  • Informatica Administration and Development
  • Directly performed MDM life cycle processes for domain development and maintenance of schema and configurations in the MDM Hub console for domains.
  • Designed integration changes for domain requirements. Responsible for ongoing model changes.
  • Performed deployments between environments and servers.
  • Develop and maintain Customer, Reference and Product Category domain schemas and roles
  • Manage the Hub security model and user access maintenance
  • Informatica Data Director Administration and Development
  • IDD application development and maintenance
  • Performed deployments between environments and servers.
  • Troubleshoot issues including role security and provisioning composite objects
  • Informatica Data Quality Development
  • Performed Informatica Data Quality Profile and Scorecard Development
  • Troubleshoot issues including user security
  • MDM Support Duties
  • Performed general support and troubleshooting activities related to JBoss EAP, JMS queues, message publishing and ESB tracing
  • MDM and publishing configuration file maintenance and support
  • JBoss 6.1 configuration file maintenance and support
  • MDM ORS creation, maintenance and troubleshooting duties
  • Publishing / ESB troubleshooting and track end-to-end tracing
  • Data Analysis
  • Performed source data analysis using IDQ profiles and data quality scorecards
  • MDM Source-to-Target Mapping Documentation for PHX, eCM/GIS, ILS (Customer, Product Category, Reference domains, plus future domains)
  • Data Warehouse Data Modeler
  • Project Based Data Model Development
  • Develop and maintain EDW and BI repository models, DDL, DML, reports, glossary terms
  • Power Designer administration, patch maintenance and user maintenance

Confidential, Houston, TX

BI Data Warehouse Architect

Responsibilities:

  • Responsible for assessing and transforming business opportunities and challenges into identification of technical specifications, and the subsequently overseeing the deployment of technology solutions that require development to be viable and supportable.
  • Designed and deployed project solutions using data warehouse architecture (ETL Processes, ODS, EDW, Data Marts) sourced from SAP ECC.
  • Designed and ETL processes for Informatica and Data Services to deliver scheduled updates.
  • Designed and developed data model and load of aggregates for a revenue leakage KPI dashboard used to identify differences between quotes, sales orders and invoices sourced from SAP ECC.
  • Evaluated and corrected the implementation of the GPI PUP Tax BI application used to identify and report the accumulated GPI PUP difference month-to-month for material and plant receipts and issues from SAP ECC. Made data model and ETL process adjustments.
  • Oversaw the architectural design enhancements for the Vendor On Time Delivery and Vendor PO/MRP reporting for operational plants.
  • This included data model, ETL loads, and SSRS report delivery.

Environment: Oracle Exadata, Microsoft SQL Server 2008R2, Spotfire 6.0, Microsoft SSAS/SSIS, Informatica 9, and SAP Data services.

Confidential, Houston, TX

Managing Consultant

Responsibilities:

  • The application provides a workflow for municipal violations and citations that pass through the Houston municipal courts system and the resulting case judications.
  • Managed schema changes in Confidential ; provided data/object validation and clean up; created build scripts from Confidential ; optimized sql server configuration; configured database alerts; performed performance testing and monitoring; built next development release DB; built next QA, UAT, and Training release databases.
  • Developed data dictionary for data model.

Confidential

BI data architect

Responsibilities:

  • The objective was the integration of SupportAssist structured data sources into the ODS and Reporting database to support “ Confidential Super Offer “ reporting in MicroStrategy KPI dashboards.
  • Created and maintained the As-Maintained Database (AMDB) dimensional data model in Erwin.
  • Created and maintain data dictionary including source to target mappings.
  • Developed database deployment scripts.
  • Assisted with ODS data model. Created and maintained load strategy document and change log.

Confidential

BI data architect

Responsibilities:

  • created logical and physical data models for a departmental data mart to support analytical KPI dashboards.
  • The objective was to reduce journey incidents through automated driver and vehicle compliance and risk management in the Confidential QHSE organization.
  • Created scripts for SQL Server 2008 R2 database objects.
  • Developed data dictionary for data model. Developed source and target data flow and process flow diagrams.

Confidential

Team lead

Responsibilities:

  • Led a team of seven infrastructure and Confidential engineers to migrate workstations, printers, and local servers and applications from the Confidential domain to the new Orion domain. Our team successfully migrated the plant in Kalscheuren, Germany.

Confidential

BI data architect

Responsibilities:

  • Performed data analysis and profiling of contact data from external sources.
  • Created DB2 stored procedures to implement data cleansing.
  • Led a team of two infrastructure engineers, a network engineer and one Confidential engineer to migrate workstations, printers, and local servers and applications from the Confidential domain to the new Orion domain.
  • Our team successfully migrated plants in Malmo Sweden, Ravenna Italy and the headquarters in Hanau Germany.

Hire Now