We provide IT Staff Augmentation Services!

Mdm Architect Resume Profile

PROFESSIONAL SUMMARY:

Information systems professional with over 17 years of corporate IS experience. Have design and analysis experience in sales/product reporting, merchandising, financial, insurance, manufacturing process, government, law enforcement, health care/EDI, customer service applications, OLTP, CRM, ETL, MDM, CDI,PIM, data warehousing on VLDB , OLAP, data mining, clustering configuration management and others. Possess strong communication, research and technical skills, which allow me to translate concepts into practical and timely solutions.

TECHNICAL EXPERTISE:

  • Data Architect
  • Enterprise DW Architect
  • BI Architect
  • SOA Architect
  • OLAP
  • MDX
  • SQL
  • ETL Architect
  • MDM Architect
  • Data quality assurance
  • Data Modeling
  • DBA Oracle, MS SQL, Sybase ASE, Sybase IQ, Teradata, Informix, DB2,PostgreSQL, Progress
  • NoSQL HBase, Cassandra, MongoDB, CouchDB
  • VLDB Very large databases deployment Architect
  • Database Developer
  • Application architect
  • Application Developer
  • ERP financials, manufacturing .
  • Middle tier and messaging developer C/C , Java
  • Security
  • Compliance
  • Change Control
  • Hadoop
  • PROFESSIONAL EXPERIENCE:

Confidential

  • Lead of data architect, modeler team. Responsible of architecture and design of EDW, Corporate BI solution, MDM solution.
  • SAP Customer Master, SAP Org, SAP Product, Salesforce.
  • Working with MS BI Stack MS SQl 2014, SSIS, SSSRS, SSAS, Tabular, MDS, Informatica MDM Cloud, Profisee MDM .

Confidential

Consultant.

  • Business Process owner
  • Responsible for multi-domain MDM implementation, Data Governance program organization and management.
  • Design and implement multi-domain Party, Product, Finance, Location, Asset, Contract solution with global presence and multi local implementation.

Confidential

Consultant. Enterprise Data Architect.

  • Consulting in area of Enterprise data management and modeling in Agile development environment.
  • Helping to define a new a governance processes and practices for Enterprise data management, modeling and deployment in Agile development environment.

Confidential

MDM architect, Data Architect Data governance implementation specialist .

Environment: Discrete manufacturing, large SAP implementation.

My role:

  • Analyzing product and product publication data sources SAP manufacturing, PTC-PDMLink, Windchill
  • Requirements gathering, data analysis, MDM data modeling with ER/Studio 9.6 conceptual, logical, physical
  • Designing a data governance policy and procedures.
  • MDM PIM Product Master , CDI Customer Master architecture design and implementation.
  • Design and implementation of metadata repository.
  • Installation and configuration and administration MDS Master Data Service 2012
  • Implementing Product, Customer, and Account Finance MDM domains in MDS 2012.
  • Integration DAM Digital Asset Management with product MDM.
  • Designing data movement ETL architecture and mapping documents. Implemented with SSIS
  • Integration SaleForce.com, Force.com customer information with corporate MDM solution.
  • Implementation of MS 2012 DQS Data Quality Service
  • MS Sql 2012 Service message Broker implementation.
  • Active team member of Enterprise SOA implementation that responsible for designing data services and access layers.
  • Developing Enterprise taxonomies , implementing taxonomies in SharePoint 2013.
  • Managing SharePoint term store, term sets and metadata services.
  • Designing and implementing security procedures ,process and standards.

Confidential

Enterprise Data Architect, BI Architect Data governance implementation specialist

  • ODS, Integration layer, Data Warehouse data modeling and schema design. PowerDesigner 16.5 is a modeling tool. PowerDesigner administrator.
  • 3rd Normal form, Start schema dimensional design and deployment in PDW Microsoft Parallel Data Warehouse appliance .
  • MDM PIM modeling and design, deployment with MDS 2012.
  • Migration from Teradata to PDW.
  • Application and PDW DBA role. ETL design and development with SSIS 2012 and Informatica.9.1
  • MDS Master data services 2012 design and development.
  • Data governance team member.
  • Migration, re-design and new design and development BI architecture with MS BI Stack 2012 SSIS, SSRS, SSAS .
  • Deployment SSRS power view and excel services through SharePoint Server 2013.
  • Planning and implementing scale-out SSRS deployment. NLB and cluster
  • Design and development MS SSAS tabular and multidimensional models Cubes .
  • Logical and Physical modeling clickstream application for Hadoop with PDW implementation. Working with Amazon RedShift database Big Data . Creating migration plan from Redshift to PDW Hadoop .

Confidential

Enterprise Data Architect

  • Application DBA Oracle 11.2, MS SQL 2008 R2
  • Logical and Physical data modeler with PowerDesigner 15.1
  • Main role is to create a logical model for Medical Benefit product MDM application Aka: PIM that will function as a master data for downstream applications claims, operations, regulatory, DW, BI, reporting system .
  • Contribution for creation of data governance procedures and policies.
  • Physical database design and deployment on Oracle 11.2 and MS SQL 2008R2
  • Working with .NET team to help UI application design and deployment with ASP .Net MVC framework.

Confidential

Data architect

  • Teradata application DBA
  • Semantic layer architect.
  • BI Architect and developer.
  • Migration DW from DB2 into Teradata 13.10.
  • Migration DW application from DB2 into Teradata 13.10:
  • Logical reverse engineer existing physical DW.
  • Add a new functionality.
  • Create a new Teradata specific physical data models.
  • New application and functionality design:
  • Worked with Target SME in area of brick mortar store inventory management, return, back room inventory, sales floor inventory, logistics to design a logical data models.
  • Created a physical data models in Erwin 7.3 for Teradata 13.10 database as a target platform.
  • Worked with off shore team to design and implement ETL objects, deployment scripts and test scripts.
  • Participated in design and development performance layer of the DW and Bi applications.
  • Designing semantic layer and performance layer that being consumed by Microstrategy.
  • Working with Microstrategy and related team member to improve BI aspect of the reporting tools including Microstrategy.
  • Involved with performance tuning effort.
  • Oversaw all the deployment stages off the application from development, test and production environments.

Confidential

  • Data Warehouse architect. ETL mapping design, data analyst
  • Modeling with Erwin 8.2 Designing semantic layer on Teradata 13.10:
  • Designed a performance layer of the DW application.
  • Data marts, semantic views, application specific temporary objects.
  • Migration of Oracle databases and applications to Teradata:
  • Analyze database and schema change impact for an existing application.
  • Provide data and application migration path from Oracle to Teradata 13.10
  • Prototype migrated functionality in a new database platform.
  • SQL development with Teradata 13.10:
  • Migrate existing Oracle SQL into Teradata version.
  • Create new views, external stored procedures.

Confidential

Enterprise Data Architect, Data Warehouse Architect

  • Design Enterprise data model, data ware house data model with Erwin 8.1:
  • Gather requirement and analyze existing data marts.
  • Create subject area conceptual models, DW logical models.
  • Participate and recommend naming standards, model management standards.
  • Design and deploy DW and mart schemas onto Oracle 11.1
  • Create a physical data models. Indexes, partitions and other schema details maintained in the Erwin model .
  • Generate DDL s and create deployment scripts.
  • Work with operation DBA s to deploy application and monitor performance.
  • Design and deploy custom ETL scripts.
  • Creating mapping documents. Creating custom scripts in PLSQL and shell scripts
  • Data sources Epic, Clarity external providers, HL7 messages, EMR information design.

Confidential

MDM Architect

  • Data Architect, Data Analyst, BI Architect, Deployment Architect. SQL Server 2008 R2 2005 and 200 DBA and developer, Oracle DBA 10g-11g R2, Oracle developer PL/SQL, forms, report.
  • SSRS, SSIS, SSAS designer and developer.
  • Standard SSRS deployment, administration of SSRS and related metadata.
  • Deployment of SSRS and MS Sql Server into VMware virtual servers.
  • MS Sql , SSAS, SSRS administration deploy, monitor, security configuration, performance management
  • Vivisimo's Velocity platform administrator and developer. ERP Ross, iRen package developer.
  • Technical lead for DW design and implementation effort.
  • Enterprise data modeling,
  • Process Modeling.
  • Design develop reporting system from Process Manufacturing, AR, AP, HR and other sources.
  • Search Engine implementation using Velocity platform. Designing enterprise search application.
  • XML, XPATH, XSL, XLST development.
  • Oracle 11gR2 installation on Windows 2008.
  • Migration applications from Oracle 10g to Oracle 11gR2.
  • Designing messaging system with MS SQL Service Broker 2008 R2
  • MDM architecting with PIM Product Information Management .
  • Creating MDM deployment roadmap.
  • Modeling data structures for MDM deployment.
  • Deploying reference data and building data governance strategies around that.
  • Creating Data HUB for analytical, operational and collaborative use.

Confidential

Data Architect, Data Analyst, BI Architect, Deployment Architect

  • Technical lead for DW design and migration project.
  • Design, develop and deploy Enterprise Data Warehouse.
  • Implement Corporate Card product master database.
  • Design, develop and deploy ETL architecture for DW loading from TSYS Total System and other sources.
  • Working with AML Anti-Money Laundering system Actimize software.
  • Dimensional Database modeling with Erwin 7.3
  • ETL design with SSIS 2008 R2.
  • OLAP design with SSAS 2008 R2
  • Design Data Warehouse. Migrate/deploy from MS SQL 2000 to MS SQL 2008 R2 64 Bit.
  • Data Sources: Mainframe DB2, MS SQL 2008
  • Physical deployment with SQL server partitioning.
  • Storage design recommendation for best practice DW deployment.

Confidential

System Architect, Data Architect, BI Architect

  • Architecting and designing EDW enterprise data warehousing . Source system data modeling. Dimensional data modeling. ELT design with TSQL and CLR stored procedures. ETL design with SSIS. Writing a custom data extraction procedure ADO.NET from Progress database.
  • Deploying ETW into MS SQL 2008 R2.
  • Cube design with MS SQL 2008 R2 SSAS. Source system is Vantage ERP manufacturing system with Progress database.
  • Migration CoreVu reports/SQL into MS reporting services and OLAP cubes.

Confidential

System Architect, Data Architect, BI Architect

  • Platform Migration from UNIX to MS Windows 2008.
  • Migrating Oracle 10G databases to MS SQL Server 2008.
  • Migrating Application with Oracle backend to Window platform with MS SQL 2008 backend.
  • Managing ERP manufacturing system, administration, development and support.
  • Designing Efficacy test application for microbiology test department and lab.
  • Designing Efficacy test data mart. Deploying BI Application from departmental data mart and with Target software.
  • Enterprise data modeling, physical database design and deployment. Data quality assurance process design and implementation, ETL design and development with SSIS 2008. OLAP Cube development with SSAS 2008.
  • Oracle and MS SQL DBA.
  • Oracle 10g Windows DBA, MS SQL: 2000/2005/2008 DBA
  • Installation Liferay Portal 6.1 and administration.

Confidential

Data/System Architect, Team Lead

  • Installing Oracle Fusion Middleware. WebLogic server deployment. Oracle Identify management deployment. Installation Oracle database 11g R2 on Linux. Migration databases from 10g to 11gR2,
  • Deployment oracle forms 10Gg onto Forms 11g.
  • Deploying Oracle SOA suite and administration.
  • Install and deploy OBIEE 11 on Linux.
  • Create a reporting and analytical application with OBIEE and BI Publisher.
  • Linux shell scripting, Perl, Python 2.7 scripting.
  • Installation Oracle RAC 11gR2 on two node cluster. ASM storage deployment. Installation Oracle Grid Control and deployment of grid control agents on clustered and non-clustered nodes. DBA tasks.
  • Installation and setup ODI Oracle Data Integration .
  • MDM Master Data Management project technical leader and architect. Designing and implementing data governance processes.
  • Enterprise Data Modeling with Oracle designer, Oracle SQL Data Modeler new oracle modeling product .
  • Migration Oracle Designer 10 model object into Oracle Data Modeler 2.0.
  • Enterprise data warehousing, ODS design. Working with Fiserv source systems.

Confidential

Data Architect, Lead Application DBA

  • Enterprise Data modeling Conceptual, Logical, Physical with Power Designer 15.
  • Model administration, model quality, standards control procedure creations and maintenance.
  • Install Power Designer 15 with repository. Migration of existing models from Power Designer 12 to 15. Set up repository version control and user groups in PowerDesigner 15
  • Domain modeling for deployment on Oracle 10g /11g and Sybase Adaptive Server 15.
  • Application DBA for Oracle, MS SQL Server and Sybase Adaptive Server 12, 15.
  • Migration Oracle designer into Sybase PowerDesigner 15

Confidential

Data/System Architect, Team Lead

  • Data Architect. Oracle Designer, PowerDesigner, Conceptual, Logical, Physical Modeling
  • Architecting database and application security framework. Masking, Encryption, Enterprise role deployment
  • DBA Oracle 10G, 11G. Migration from 10g to 11g
  • Oracle portal developer and admin.
  • Java developer: J2EE, SOA, Integration.
  • Oracle Discoverer developer and admin.
  • Oracle Application Server 10g Admin and developer.
  • Oracle Forms Reports 10g developer and admin. Form generation with Oracle Designer.
  • Oracle Collaboration Suite 10g Admin, developer.
  • Oracle 9i, 10g, 11 developers.
  • DW/BI Architect.
  • Project Lead.
  • Linux administration.
  • Storage Architect SAN, ISCSI
  • Installing VMware and consolidating servers.
  • .Net design with C and Share Point 2007.
  • Design Analytical and Reporting system with MS SQL 2008 BI technology. SSIS, SSAS, SSRS
  • Design and deploy MS BI stack, administration of MS Sql, SSAS, SSRS.
  • Ongoing, migrating reporting system from Oracle Discoverer, Oracle Reports 10g. Currently in Prototyping stage.

Confidential

Data Architect/Data warehouse Architect

  • Data architect.
  • Integration architect.
  • Lead of data warehousing, application integration, CDI, MDM initiatives.
  • Customer data de-duplication, matching, maintaining reference data.
  • MS SQL 2000/2005 DBA.
  • Migration Sybase Anywhere 9 to 10.
  • Migration PowerBuilder 8 to 11.
  • Application development with PowerBuilder 11.
  • Data Modeling with Power Designer 12.
  • Designing OLAP cube on MS Analysis Services SSAS 2005 .
  • Deploying ETL with SSIS 2005.
  • Deployment of ProClarity Analytical Server 6.3 and ProClarity Desktop 6.3.

Confidential

Database Consultant

  • Sybase DBA/AIX Administrator.
  • Migration Sybase database and AIX application from version 4.3 to 5.1
  • Migration from 32 bit to 64 environments.
  • Performance tuning of application and OS.
  • C/C application development with Sybase backend.

Confidential

DW/BI Architect

  • DW/BI project technical lead.
  • Migration DTS packages to SSIS 2005.
  • Migrating OLAP cubes to 2005
  • Migration MS SQL 200 databases to MS SQL 2005 64 bit platform .
  • Architecting and designing ETL processes.
  • Database storage analyst for DW.
  • Database centric custom .Net application with C

Confidential

System / Data Architect

  • Applications, shell scripts, C/C code Migration from Sun Solaris 9 to Linux Read Hat 3 Intel
  • Database application development with MFC and Sybase backend.
  • Migration Sybase Adaptive Server 12.5 from Sun Solaris into Linux Intel platform
  • On-line hot Migration Sybase Replication Server from Sun Solaris into Linux.
  • Sybase database and replication administrator.
  • Architecting and designing ETL processes.
  • Architecting distributed transaction management system.

Confidential

Data Warehouse / ETL architect

  • Designing real time Data Warehouse/ BI.
  • MS OLAP developer. Cubes/Dimensions. MDX development.
  • Migration MS SQL 2000 database to MS SQL 2005.
  • MS SQL Server DBA.
  • Migration/ Design MS Analysis Server to MS Analysis Server 2005.
  • Project Technical lead.
  • Physical database deployment, storage architect.

Confidential

OLAP Developer/Performance Analysis

  • Optimizing existing data warehouse, Cube, Dimension design and deployment for performance. Improving Cube processing and optimizing MDX queries.
  • Recommending and implementing solutions for existing technical problems.
  • ProClarity administrator.
  • Physical Database design/deployment on Oracle 9.2.
  • Designing .Net analytical custom application with C .
  • Working with DB storage project SAN, NAS.

Confidential

OLAP Developer/Designer consultant on MS Analysis Server

ProClarity Administrator.

  • ETL developer with Informatica.

Hire Now