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.
- Data Architect
- Enterprise DW Architect
- BI Architect
- SOA Architect
- 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
- Change Control
- PROFESSIONAL EXPERIENCE:
- 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 .
- 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.
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.
MDM architect, Data Architect Data governance implementation specialist .
Environment: Discrete manufacturing, large SAP implementation.
- 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.
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 .
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.
- 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.
- 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.
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.
- 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.
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.
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.
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.
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.
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
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.
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.
- 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.
- 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
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.
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.
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.
OLAP Developer/Designer consultant on MS Analysis Server
- ETL developer with Informatica.