SUMMARY

• An Innovate IT Software Architect/Lead/Manager with a multitude of Client Projects that have utilized many different Application Integration Software Technologies.
• Experience creating POC’s for the Pre Sales Team, Design/Architect Enterprise - Wide Data Solutions, Development and Training aspects of the SDLC.
• Matt was the Co-Speaker for the Confidential MDM partner training certification with the goal of spreading best practices for Open Source Projects.
• Matt is a Technology Consultant, MDM Architect, and Solution Architect. These various roles helps him build great teams, with a keen eye on performance and process improvements.
• Excelling as a Software Manager and Leading Developers, Architects, Analyst, and System Designers in State of the Art Technologies Applications that included, Confidential MDM/Cloud/DQ/BDD/IDD/IDE/Big Data Power Center Versions 7.4- 10.1, Confidential Developer/Eclipse Development, Confidential Cloud/DI/DQ/MDM/BD/ESB V5.6 - V6.1, Component Configuration, Confidential Integration Cloud/Big Data, AWS, Confidential, Confidential MDM/OEDQ/DB ( Confidential Data Quality), Confidential EDQP, MYSQL, Objective C, Java, SSIS, SQL Server, Eclipse, Teradata, Big Data Hadoop, Cloudera, JSON, Java Script, XML Message,
• Adobe Illustrator and Photoshop, Hive, MapReduce, Pig Scripting, Confidential ETL, Message Queues, Confidential MDM Data Confidential 9.6, Jenkins (CI), Universal Customer Master (UCM) Integrated into Power Center Mappings OOTB, Data Governance, OBIEE 10/11G Dashboard/Report Development development, DAC Configuration Administration, BI Apps 7.9 configuration/installation, and Confidential Golden Gate 11g technologies. Matt provides management level leadership to all positions given.
• Matt holds a Bachelor(s) degree with a double major in Management Information Systems and International Marketing (French). Matt has managed and led numerous International development efforts in all parts of the world.

TRAINING/SOFTWARE EXPERTISE

Confidential 5.6- 6.2, Confidential Data Quality {Parse, Match,Explore } Confidential Data Quality, Confidential Data Quality(PDM), Confidential Power Center V7.4-9.1, Confidential Golden Gate 11g, Confidential OBIEE7.9 Apps, DAC, Confidential 9i,10g,11gR2, Confidential SOA suite 11g, Integration Siebel 8.0 Applications, Jasper Soft, Confidential Customer Confidential (Siebel 8.2), Confidential Hyperion Data Quality Financial Management 11.1.2 Administration, BI Publisher, OBIEE11g(11.1.1.6)

PROFESSIONAL SERVICE EXPERIENCE:

Confidential

IDQ Architect

Responsibilities:

• Designed Data Validation Framework for Deal/Loan/Pool Asset Classes
• Lead the Off-Shore Team to Build the DVF Solution Through Confidential Data Quality 9.6.0
• Met with Stakeholders to define requirements and build Solution to solve specific Accounting Violations
• Designed the Logical/Physical Data Model for Exception Handling Process and leveraging Parameterization to accommodate Scalability/On-Boarding of new Source Systems using ERWIN
• Created the DVF Mapping Specifications and ETL Intrusive Process.
• Ran the Business Workshop’s to identify Gaps in Requirements and Solution
• IDQ Version Analysis to find higher Version to accommodate new and complex requirements.
• Worked with S&P Architecture Team to align Governance Procedures and Policies with Data Validation Framework Solution.
• Installed and Configured IDQ/IDD 9.6.0 on Confidential Cloud.
• Created OBIA Canonical XML Data Model with DVF Framework Data Model using Fixed Asset, and General Ledger.

Confidential

Software Architect

Responsibilities:

• Managed the Development/Design and Architecture of the Social Messaging Gamification Application. Currently being sold on the App Store and Google Play using Objective C and Java.
• Managed and led the Web Site Design and Development, back end database and API/PHP configuration for the applications. Advising on the behavior analysis tips and habit-forming functionalities off the application.
• Mentored developers on the Gamification Platform to ensure Vision and best practices were adhered to.
• Managed the Testing/Developing/Designing Activities with our off shore team.
• Sponsored the partnership initiative with other applications to gain cross marketing and first mover advantage.
• Designed the Mouthy Data Quality Framework using Confidential IDQ 9.6.0
• Approved and ensured all expenses were within company’s guidelines.
• Help create the Gamify Project plan, Timeline to Production, and assigned tasks per skillset, per expertise history, and per the amount of time to complete tasks by degree of difficulty.
• Disbursed funds to pay all suppliers and contractors per agreed upon contract pricing for meeting and or exceeding upon project milestones.
• Help to create the 30-second explanatory video for potential users.
• Approved the High Level Architecture, ETL and Design specifications for all developers to adhere to while working in the Multi-Phased Project.

Confidential

MDM Architect

Responsibilities:

• Developed and Architected the Hilton MDM Governance Solution utilizing Confidential and Confidential MDM Web Services, UI, and Single-Sign-on LDAP configured.
• Constructed Demo’s for MDM, Big Data, Data Quality, DI, and ESB software capabilities while solving specific use cases.
• Installed/Configured/Trained other team members for After Go-Live Administration Activities.
• Trained customers on MDM Best Practices to gain alignment with Project Tasks and Milestones.
• Created Proposals for the sales team to follow up with Pre-Sales for POC presentations.

Confidential

MDM Partner

Responsibilities:

• Co-Trained the 3-day MDM Training class for Confidential Partners in Philadelphia, PA.
• Help foster relationships to ensure MDM/DI leading best practices are being implemented correctly at Confidential Clients.

Confidential

SAQ

Responsibilities:

• Confidential MDM Software Training (2-weeks).
• Solved the clients’ blocker support tickets, that needed high priority attention, or the potential loss of client was high.
• Lead SAQ data governance in Joint Solution Session with project team members to ensure success.
• Directed the Design of their ESB messaging system to ensure data governance procedures were adhered to.
• Developed a POC for using ESB for their Messaging XML solution
• Taught client the Confidential DI/DQ/AdvancedDI/Admin software stack.
• Troubleshoot any issues that arise in class with Virtual Machines. 100% success rate

Confidential

Solution Architect

Responsibilities:

• Installed and Configured Confidential Hadoop with ClouderaV6.2, running on AWS.
• Troubleshoot and Solved Major Big Data blocker for continued future software licenses renewals.
• Live-Help Support for Data Integration/MDM Clients.

Confidential

Solution Architect ETL

Responsibilities:

• Approved the Architected Solution of the DIF/Acord XML Framework using Insurity (SQL Server 2012/SSIS) in conjunction with Confidential B2B/PowercenterV9.5/InformaticaB2B/MDM Confidential V9.6.
• Approved the Proof of Concepts for the expected deliverables on their Solution Architected the MDM/Data Governance initiative with current tools in house and custom code using Ruby, Perl, Confidential IDQ, IBM Business Glossaries.
• Reviewed all of the Data Governance Requirements and created developer code to complete Business Rules Process.
• Assigned to staff the entire RAPID Solutions Project.
• Created an on boarding process to make use of the new hire learning curve to accelerate their tasks completion.
• Approved the Architecture documents for Data Governance of RAPID project.
• Configured and Design Big Data Hadoop Mappings to run on Hadoop/Hive through IDQ Developer
• Optimized the Developer Scripts to run on HDFS
• Coordinated with Project Manager to align assignments with proper task to correct developer.
• Assigned the development team coding work and tracked progress with daily stand-ups and SCRUM.
• Coordinated all Troubleshoot issues related to Overall RAPID Solution.
• Hired and ensured successful development from the developers that were to be trained and on boarded.
• Hosted weekly Architecture, Project Plan, and development efforts were being followed and any issues that arise.
• Assisted in Installing/Configuration of MDM BDD/IDE.

Confidential

Solution Architect

Responsibilities:

• Responsible for doing an MDM assessment of current MDM initiative from a Global Integrator
• Gave Recommendations on Current Gaps and Moving Forward steps to correct and fix MDM solution
• Reviewed all of the current Architecture Documents and analyze potential issues with configuration and best practices that need to be implemented
• Developed EDQ Profiles/scorecards on for all Supplier, Item, and Customer schemas for data discovery and roadmap for Data Governance team to build rules upon.
• Configured Confidential Data Relationship monitor to the data quality metrics to show improvement or loss off data integrity.

Confidential

IDQ SME

Responsibilities:

• Responsible for implementing a fully automated Address/Standardization MDM Solution per requirements from the Affordable Care Act (ACA) at the State of Oregon.
• Created Matching Code with the IIR Matching Algorithm weights to find duplicates in the customer data to aid in the fraud protection project.
• Installed and configured the software to support the MDM Enterprise solution.
• Created knowledge transfer documentation
• Identified and communicated data/security risks and provided recommendations for the solution.
• Provided testing support and provided fixes for critical issues
• Used IDQ mappings and UCM Solution to accommodate mini data governance solution.
• Provided recommendations for performance improvements for ETL loads

Confidential

MDM Architect

Responsibilities:

• Installed and configured the EDQP software for their migration from IBM to Confidential RDMS system.
• Trained staff for production support.
• Created Step-By-Step documentation for each task that was to be completed daily.
• Coded the framework for the Architecture of the Data Quality Rules, Matching Rules, and Data Integration Process Flow(s).
• Solved threading issue that was causing software to crash.

Confidential

Confidential Architect

Responsibilities:

• Installed and configured OBIEE 11g with DAC, Confidential and BI apps for DEV environment for Integration into Seibel Call Center on Confidential Linux OS.
• Created off site curriculum and held training sessions to train new staff on Confidential BI products Suite and Administration.
• Created Report Documents per Business requirements document for BI Dashboards and Reports for HIX.
• Administrator for their MDM stack of software.
• Installed and configured Jasper Soft Reporting and Dashboard service for Confidential IDQ91HF5.
• Maintained and operated IDQ Administration for Global Diesel Conglomerate for Production Support.
• Installed and Configured Siebel/UCM 8.2 on AIX64 Platform.
• Performed troubleshooting for memory and performance issues.
• Performed troubleshooting for OBIEE and Siebel Marketing Server Cluster errors.
• Recommended performance improvements for Clustering ENV for their OBIEE and Siebel Instances.
• Provided Recommendation Document to client for future state of BI and best practices to implement in their current ENV
• Solved any outstanding SR’s with the client.
• Created Extensive Training Documents for installation and configuration of MDM/IDQ software.
• Trained Clients on capabilities on software for Data Quality and MDM tools.(Spanish).
• Solved Memory Issue for successful MDM implementation for an on time and on budget GO-LIVE production release.
• Profiled Health Insurance Exchange(HIX/Modernization) DB2 tables for Business/DBA analysis of current legacy systems.
• Installed and configured IDQV9.1 utilizing real time web services.
• Installed and configured DB2 Plug In for profiling along with creating custom queries for Golden Record Creation for load into UCM.
• Developed IDQ match mapping that identified duplicate citizens within their current system. Along with business feedback we were able to get match count from 350K to 250K. Saving the client time and money.
• Created mappings and DDL to create DEV environment for complex queries and data profiling and discovery.
• Installed and configured Address Doctor for Data Standardization prior to Address Match Mappings.
• Met with Team Leads of the other Software’s to Architect the Integration between all of the Confidential Product Suite(s).
• Create controls for Data Governance in relation to data steward/data quality analyst reports.

Confidential

OBIEE Lead

Responsibilities:

• Modify existing SDE and SIL JDE/Siebel BI apps 7.9/mappings to cater to customer warehouse deliverables and business user requirements for salesforce.com forecasting numbers.
• Created customer knowledge sharing DAC documents for future loads and how to steps for configuration of DAC.
• Performed troubleshooting on reports and repository issues while configuring DAC to run on schedule per customer requirements.

Confidential

IDQ/MDM SME

Responsibilities:

• Code and Integrated and delivered the MDM/Data Remediation Solution for a large health care conglomerate.
• Developed with Automation for numerous mapplets/mappings/profiles, and scorecards to complete the Data Remediation process.
• Migrated code from Confidential 9.0.1 to Confidential Power Center 8.6.1. Integrated the end-to-end process with Siebel and finally loaded the profiles and scorecards for the business users.
• Solaris, Confidential 10g & 11g, UCM 8.1.1.4, Confidential Data Quality Matching Server and Address Validation Server, Confidential SOA, Webmethods, Confidential Data Quality 9.01, Confidential PowerCenter 8.6.1, IIR 9.0.1, Address Doctor 5.0, 1M+ records.

Confidential

Confidential /IDQ/MDM

• The client initiated the upgrade project to take advantage of new functionality in release V9.1 and to replace their current MDM with Confidential MDM along with Data Profiling and Data Quality.
• Installed and configured PowerCenter V9.1 on AIX platform
• Installed configured Data Quality Profiler, and Data Quality Cleansing and Standardization.
• Created TDD and Run book Extensive Knowledge Transfer Documentation for client for knowledge transfer and Test and Production guidance artifacts.
• Ran Meetings with Data Governance team to discuss rules and merge logic. Created scorecards for Graphical Representations of state of data.

Confidential

MDM specialist

Responsibilities:

• Installed/Configured Confidential Data Quality, UCM, and IIR software stack.
• Created TDD Run book Artifact for client knowledge transfer.
• Met with Data governance team to review and approve business rules, relationships, merge logic for Production Go-Live.

Confidential

MDM Lead

Responsibilities:

• Set up configured the MDM solution using Confidential CRM and Confidential Identity Resolution Technology.
• Configured UCM repository, SDF file(s), and match criteria for name duplication identification for database sync from Siebel to Confidential Identity Resolution on SQL Server platform.
• Adjusted match criteria for optimal results for finding duplicates and syncing databases for Confidential Customer Master.
• Set up triggers for database sync on all customers for one version of truth of customer’s data. Created web services using WSDL’s and XML for communication between Siebel and IIR.
• Created Data Governance workflows for data remediation to capture business rule changes in the data lineage flow.

Confidential

Confidential Lead

Responsibilities:

• Configured Architecture for Control Frame Work Teradata V12 with Power Exchange TPT API.
• Installed/Configured Confidential V9.0 on SQL Server 2008 Platform for on/off-shore team.
• Lead the ETL/Mapping Design Team for Offshore Development. Lead Off-Shore Development Team Utilizing Confidential and Teradata with 1Terabyte of data for phase 1
• Profiled and created 50 Data Profiling reports/mappings for all source/target systems through Confidential Data profile pulling data from Confidential Golden Gate 10.3.1 and DB2 files.
• Altered scripts for Update Logic in CDC Golden Gate Scripts.

Confidential

Teradata V12 and Confidential Project:

Confidential ...

• Created Data Quality mappings/framework for eventual attachment to MDM solution for later phases
• Interviewed candidates and made recommendations for phase level hiring
• Installed latest patches and hot fixes for Teradata and Confidential V8.6
• Created MDM data Confidential for customer address utilizing the clients established data governance team and data quality/ETL software of Data Flux and Confidential
• Met with data stewards and senior leadership to outline principles to be followed and correct SME’s to verify data values for load into Data Confidential .

Confidential

Lead Trainer

Responsibilities:

• Trained Analyst and Consultants on PowerCenter V8.6.1
• Trained Business Analyst on IDQV8.6 Workbench and IDQ Server
• Installed IDQ and IDE V8.6. 1 workbench and IDQ server
• Trained newly hired IT personnel on TDV12 express edition
• Created training/labs BTEQ, MLOAD, FASTLOAD, and T-SQL procedures for 3-week class.
• Performance tuning of Confidential mappings/IDQ plans with SQL Server 2005 and Confidential 10g source/targets using Indexing, complex data transformations, and date conversion(s).

Confidential

Confidential /BI Lead

Responsibilities:

• Design and lead code development for a Nuclear Facility’s threat level survey reporting project
• Coded with PL/SQL with Confidential Data Integrator through Confidential knowledge Modules and merge to perform the functions necessary for accurate ETL loading for threat reporting from facilities around the nation
• Created custom star schema(s) created for this client through design time repository.
• Architect of Web Service Integration Server framework into Rogers Web Solution
• Created Survey Dashboard through Answers to encompass threat levels for monthly reports
• Designed RPD Business Layer, Presentation Layer, and Physical Layer(s) to maximize joins from the Database Fact and Dimension Tables.

Confidential

Confidential /BI Lead

Responsibilities:

• Conducted/Configured Training to a team of 17 developers for 7-week course on Confidential 8.6.1, Confidential 11g and OBIEE 10.1.3.3.3 , DAC, SDLC, and Project Management
• Conducted and lead teaching effort for banking client on Confidential Power Center and Data Quality
• Led team of off-site consultants in the development and implementation of an Enterprise-Wide Data Warehouse
• Implemented upgrade of Confidential Business Intelligence Enterprise Edition 10.1.3.3.3 , DAC 7.9.5.1, OBIEE Apps 7.9.5.1, Confidential 8.1.1 SP5, to Confidential Business Intelligence Enterprise Edition 10.1.3.4, DAC 10.1.3.4, OBIEE Apps 7.9.6, Confidential 8.6.0 SP10
• Created custom Confidential mappings to extract and load data from multiple casino source system’s (AS400, SQL Server) to the Data Warehouse Confidential 11G
• Modified OOTB Confidential mappings from the OBIEE Apps to extract and load data from multiple source systems to the Data Warehouse.
• Configured and executed custom DAC ETL automatic process for both full and incremental loads.
• Assisted in the customization of the repository architecture for MDM-CDI solution for vendor that was in charge of data quality deliverable (Pitney Bowes).
• Configured IBM drivers to pull data from DB2 source and translate hexadecimal values
• Worked closely with Seneca stakeholders in the discovery and design phases.
• Implemented an out of the box casino management MDM-CDI Architecture utilizing 3 different vendors software(s) following Confidential and Spoke Architecture.
• SDLC Methodology applied to all phases from requirements gathering to Go-live Deliverable.
• Created Dashboards and Reports for Casino Gaming System with KPI’s for tables games and slots.

Confidential

ETL Team Lead

Responsibilities:

• Installed/configured/developed PC 8.6/Data Quality and Power Center mappings/mapplets for off-shore team.
• Performance Tuning of PowerExchange for SQL Server CDC and PowerCenter.
• Created mapping and data quality specs per subject area for off shore team to code.
• High data volumes with matching per CSV flat file using mapplets inside the mappings for seamless integration once match were verified by customer then we went database centric
• Did performance tuning on Workflows/BTEQ script for Push Down Optimization loads using TPUMP, MULTI-LOAD for Teradata targets.
• Validated code and did re-work on IDQ plans on time sensitive CDI portion.
• AS400, CDC SQL SERVER, all using Confidential PWX 8.6
• Compiled mappings specs for hand off to customer for go-live.

Confidential

Principal Consultant

Responsibilities:

• Installed and configured V8.6 server/client on SQL SERVER 2005 for Off-Shore branch.
• Wrote ETL code to implement a LEAD MNGT User Interface Sales Lead capturing system. Used PL/SQL and Confidential 7.1.4.
• Held various presentations to clients regarding CDC initiatives and ETL/Data Quality software(s) to be incorporated into current IT architecture.
• Configured Web Methods to consume web services from PowerCenter.
• Published a White Paper for MDM regarding importance of data quality as integral component.
• Worked on various projects throughout AVNET using Silver Creek Systems 4.0 and 4.2 versions and Confidential for Managing Product Data.
• Created automation for Taxonomy, Standardization, and Matching on all data from supplier catalog to create a standard template for suppliers to use when sending data to Avnet.
• Upgraded Silver Creek System 4.0 to 4.2.
• Implement Master Data Management (MDM/PIM) process throughout all projects using Silver Creek Systems.
• Wrote SQL queries for data input using PL/SQL/; TOAD.
• Ongoing governance for Product Information Master Data Management(PIM) and Initial and continuing loading of data.
• Created 25 Data Lens and 25 Process Maps in Silver Creek. System to run data through software with performance tuning as main criteria
• Created Architecture; schema(s), tables and views in SQL Server 2005 for loading from outside vendor data from raw stg to clean stg. Business rules applied in this stage.
• Created Stored Procedure/ Confidential mappings to load outside vendor catalog data to coincide with the current schema containing part data for feed into multiple tables that e-commerce site(s) .

Confidential

Data Quality Developer

Responsibilities:

• Developed 30 data quality plans using IDQ 3.0 and Power Center 7.1.4 for data cleansing, standardization, and matching for large project to consolidate all vendors into one single target database ( Confidential 9i) for cost saving purposes for all clients hospital accounts.
• Source data was coming through in flat files (MS Excel, pipe delimited, and comma delimited).
• Developed the rules for data mapping, cleansing and consolidation using IDE and IDQ.
• Installed Server and Client for Confidential 7.1.4.
• Configured the software to cleanse, validate and identify duplicates as the data is entered to Siebel CRM system.

Confidential

Data Quality Developer

Responsibilities:

• Received source data from SAP and various legacy systems for data cleansing, standardization, and matching for global coupon/rebate saving program for MDM project
• Cleansed data was to be loaded using Confidential 7.1.2 into Target database ( Confidential 9i).
• Developed 35 plans to accomplish rules that incorporated business and technical specification per customer.
• Tested target database writing various SQL scripts to Unit Test software code.

Confidential

Developer

• Created ODM for MONX credit scoring system using comma delimited files from outside vendor.
• Coded with Confidential 7.1.4 for target database for SQL Server2000
• Created 50 mappings to accomplish the data mart
• Created schema for testing purposes on all target databases
• Sourced pipe delimited flat files from mainframe system to be transformed though Confidential to be loaded into ODS
• Created 36 mappings for ETL process to be completed using complex JOINS and cross system LOOKUPS
• Wrote FTP scripts for loading of flat files to ODS directory residing on UNIX.
• Design specification provided to customer and sign off was completed.

Confidential

Developer

Responsibilities:

• Successfully upgraded Confidential PowerCenter 7.1.4 to PowerCenter 8.1.1. Platform on AIX.
• Coded UNIX (shutdown/startup/workflow) scripts to be used for running production checks through INFA command line.
• Upgraded PowerCenter 7.1.14 to 8.1.1. Provided step by step documentation to client.

Confidential

Developer

Responsibilities:

• Successfully created XML files through mappings using Confidential PC8.1.1, source/target database was Confidential 10g.
• Developed mappings using XSD/XML(s) provided by customer per technical design specifications.
• Provided audit requirements for each file through exception code.
• Installed and configured Confidential V8.1.1 on server and client on SQL SERVER 2000/2003.