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.