PROFESSIONAL SUMMARY:

Information systems professional with over 19 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 SKILLS:

• Data Architect
• Enterprise DW Architect
• BI Architect
• SOA Architect
• OLAP
• MDX
• SQL
• ETL Architect
• MDM Architect
• Data quality assurance
• Data Modeling
• DBA (Oracle RAC, Exadata, MS SQL, MS PDW, Sybase ASE, Sybase IQ, Teradata, Informix, DB2, PostgreSQL, Progress)
• GoldenGate replication. Oracle Data Guard.
• NoSQL (HBase, Cassandra, MongoDB, CouchBase)
• 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
• HPC (High Performance Computing)
• Simulation software support.
• Temporal data design.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Solution Consultant

Responsibilities:

• PIM (Product Information Management) Ecommerce solution architect with InRiver PIM.
• Technical lead for digital transformation projects. NetSuite (Cloud ERP) API developer and integrator

Confidential, Plymouth, MN

DW, BI, PIM Architect

Responsibilities:

• Lead Data Architect. Designing Data Warehouse, BI and PIM. Data Governance adviser.
• Centralized Audit log design and development.
• MS Sql 2012, 2016. Power BI, MS MDS 2016
• Idera (Embarcadero) Data Architect 2016.
• JSON, REST API. Distributed applications.
• Writing complex SQL,TSQL codes for ELT/ETL and for reporting.
• Integration with Oracle ERP (Finance and Manufacturing, Order Management System). Oracle MDM (Customer Master Hub, Oracle Site Hub).

Confidential, Minneapolis, MN

Data Architect, Solution Architect, BIG Data Architect

Responsibilities:

• Architecting of a data and an application solutions for billing and invoicing business processes of Confidential HIE (Health Information Exchange) and EDI X12
• Converting legal contracts (unstructured data) into structured business application and creating automated billing and invoicing solutions.
• The billing application deployed on Oracle 12c and invoicing and metering solution deployed on Cloudera Hadoop, HBASE and Spark.
• Modeling tools: Erwin 9.7, Visio 2016, Oracle Data Modeler.
• Programming: Oracle PL/SQL, Scala, Java API, .Net., Oracle Enterprise Data Quality, ODI.

Confidential, Charlotte, NC

Consultant, Enterprise Data Warehouse Architect, MDM Architect, Database Engineer

Responsibilities:

• Lead Data Architect. Designing Data Warehouse (Data Lakes, Data Vault, Star Schema) for Capital Market, Risk Management business domains.
• Enterprise Architecture with TOGAF, Zachman frameworks.
• FIBO (Financial Industry Business Ontology) integration POC
• Data Governance program lead.

Confidential, Plymouth, MN

Consultant, Enterprise Data Architect, Informatica Data Quality Architect

Responsibilities:

• A leader of Enterprise Architecture roadmap, business/subject modeling for multiple line of businesses(Retail Banking, Commercial Banking, Equipment Finance, Commercial Lending and others). Leading Enterprise Data Governance effort.
• Informatica IDQ (Data Quality) architect, admin, developer. Installation of IDQ 10.1 on Linux, configuration, application deployment. Oracle 12c Database install and configuration, Oracle Application DBA. Configuration and Automation scripting (Chef, Puppet, DevOPS). Informatica PowerExchange CDC (change data capture) for Oracle.
• Database, middle tier, application security configuration with accordance of company policy.
• Design and deploy Informatica Business Glossary, Metadata Manager, reference data, data profiling, business rules and others. Using Confluence for a team collaboration.
• Informatica Hadoop ETL mapping configuration. Kafka data streaming design. Data Lakes proof of concept design. Implementation on Couchbase and MongoDB platforms.
• MDM (Master Data Management) and RDM (Reference Data Management) architecture initiatives.
• ABA(American Bankers Association) operational risk / loss data reporting design with Tableau and.
• Deploying HADOOP/Spark application onto Azure (cloud) platform.

Confidential, Eagan, MN

Consultant, Data Architect, MDM Architect, Database Engineer

Responsibilities:

• Proposing and driving information governance strategy and enterprise level data vision.
• Directing data stewardship activities across the organization.
• Aligning business and IT to support a data quality.
• Working with internal and external organizations on data privacy, security and regulatory compliance for the enterprise.
• Report development with BO and Tableau.
• Business Glossary Design, Data classifications, Taxonomy, Canonical model design and management.
• Modeling Tools: IDA (IBM InfoSphere Data Architect, InfoSphere Information Server).
• Designing SAP Business Object Universe, analytical applications, reports.

Confidential, Edina, MN

Consultant: Oracle OBIEE 11g, ELT, PL/SQL coding, Linux shell scripting Oracle EBS

Responsibilities:

• Fixing and migrating legacy codes, designing new reports, data extraction, automation shell and PL/SQL scripts, ETL/ELT redesign and documentation.
• Installing and configuration Oracle 12c RAC, Oracle Data Guard 12c, Oracle GoldenGate replication.
• Toad, Jira

Confidential, Plymouth, MN

System/Data Architect, Engineer

Responsibilities:

• Implementing data management and MDM (PIM), SDM (Simulation data management), data governance practices within R&D departments.
• Analyzing data sources for various application data. Analyzing pre and post processing data modeling data structures, metadata design.
• Gathering and documenting a functional and technical requirement for computational and simulation modeling deployment on HPC platform: hardware, storage configurations, modeling network topologies. Working with HPC vendors (IBM, HP, Dell, SGI and others) for turnkey solutions options. Assessing feasibility of deployment of cluster file and parallel file systems on Linux. (Lustre, GPFS), cluster workload management software, job schedules and etc. System configuration (CPU, cores, GPU, memory storage, network, infiniband, etc.)
• Supporting (installation, configuration, license management) modeling and simulation software Abaqus, Ansys, SolidWorks, Matlab and others.
• Scripting with Perl, Python, and Linux Shell scripts. Database design with PostgreSQL for various internal web and client - server applications. Large data set analysis with Python.
• Microsoft CRM, MDS 2012(Master Data Services) as PIM (Product MDM).
• MS SSIS 2012 as ETL platform.
• MS SSAS, SSRS 2012 as reporting and analytics platform.

Confidential, Redlands, CA

Enterprise Data Architect, MDM Architect, ETL designer

Responsibilities:

• Lead data architect, head of data modeling team. Responsible of architecture and design of EDW, Corporate BI solution, MDM solution. Enterprise ETL architecture design and implementation with data lake concept.
• Erwin 9.5 workgroup edition with model mart.
• SAP Customer Master, SAP Org, SAP Product, Salesforce integration design.
• Working with MS CRM, BI Stack (MS SQl 2014, SSIS, SSSRS, SSAS, Tabular, MDS, Informatica Customer 360 MDM Cloud, Profisee MDM).
• Designing multitenant databases on Microsoft Azure SQL.
• Migration of in-house MS SQL databases into Microsoft Azure SQL databases. (Cloud multitenant database)
• Evaluation of EBX5 for multi-domain MDM solution.
• Configuring an existing applications to work with Azure SQL.

Confidential, San Francisco, CA

Consultant Enterprise Data Architect

Responsibilities:

• 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.
• Designing data structures for Java objects data access and persistent layers (Hibernate, Sprint Data and others).

Confidential, Bloomington, MN

MDM architect, Data Architect

Responsibilities:

• 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), CRM, 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.
• Design new web applications with NoSql platform (CouchBase, MongoDB)

Confidential, Richfield, MN

Enterprise Data Architect, BI Architect

Responsibilities:

• ODS, Integration layer, Data Warehouse data modeling and schema design. PowerDesigner 16.5 is a modeling tool. PowerDesigner administrator.
• Enterprise Architecture with TOGAF framework.
• 3rd Normal form, Start schema (dimensional) design and deployment in PDW (Microsoft Parallel Data Warehouse appliance).
• MDM (CDM) modeling and design, deployment with MDS 2012.
• PIM, Location MDM, CRM, Assets MDM implementation with IBM InfoSphere.
• 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 AWS Redshift to PDW (Hadoop).
• Migration of some Teradata databases into HADOOP Data Lake and AWS Redshift.
• Designing cloud ETL.
• Deployment and administration of Cassandra, HBase and Mongdb for real time data ingestion. Evaluating various application with NoSQL platforms. Python, PHP, Perl scripting for internal web applications utilizing Google MAP API, PosgtGIS database.

Confidential, Bloomington, MN

Enterprise Data Architect

Responsibilities:

• 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, Minneapolis, MN

Data architect, Teradata application DBA

Responsibilities:

• 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 Confidential 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 Confidential 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, Eagan, MN

Data Warehouse architect. ETL mapping design, data analyst

Responsibilities:

• 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.
• 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, MN

Enterprise Data Architect, Data Warehouse Architect

Responsibilities:

• 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 (v2) messages, EMR information design.
• Interfacing with Siebel CRM (Oracle) system for data extraction.

Confidential, Golden Valley, MN

Data MDM Architect, Database Engineer

Responsibilities:

• 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.
• Architect and development of CRM system with Microsoft Dynamics CRM 2011
• Deploying reference data and building data governance strategies around that.
• Creating Data HUB for analytical, operational and collaborative use.
• Product catalog web application design with MongoDB.
• Creating a custom extension for Pivotal CRM, creating an integrated solutions for customer and marketing information.

Confidential, Minneapolis, MN

Data Architect, Data Analyst, BI Architect, Deployment Architect

Responsibilities:

• 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.
• Working with Oracle Exadata X2 platform for Syncada project. Large DW and OLTP application deployment,. Architecting and designing a custom ETL/ELT data load solution for Exadata load.

Confidential, Minnetonka, MN

System Architect, Data Architect, BI Architect

Responsibilities:

• 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, Golden Valley, MN

System Architect, Data Architect, BI Architect

Responsibilities:

• 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 Confidential 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 Forms 10g, Reports 10g
• Oracle 10g Windows DBA, MS SQL: 2000/2005/2008 DBA
• Installation Liferay Portal 6.1 and administration.
• Migrating Linux based PostgreSQL database and application into Oracle 10g.
• Migration Sybase database and applications to Oracle 10g.

Confidential, Morgan, MN

Data/System Architect, Team Lead

Responsibilities:

• 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, Minneapolis, MN

Data Architect, Lead Application DBA

Responsibilities:

• 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.
• Oracle ERP Application DBA, MS SQL Server and Sybase Adaptive Server 12, 15.
• Migration Oracle designer into Sybase PowerDesigner 15
• Migration Sybase ASE 15 to Oracle 11G (database and applications)

Confidential, Morgan, MN

Data/System Architect, Team Lead

Responsibilities:

• 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. Deployment of RAC, ASM. DBA (RMAN, Performance Tuning).
• 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, Plymouth, MN

Data Architect/Data warehouse Architect

Responsibilities:

• Data architect.
• Integration architect.
• Lead of data warehousing, application integration, CDI, MDM initiatives.
• E-Commerce project lead, WCS (WebSphere Commerce Suite), Store Fronts, Customer.
• Customer data integration with E-Commerce data (channel sale).
• Customer data de-duplication, matching, maintaining reference data.
• MS SQL 2000/2005 DBA. Oracle 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, Minneapolis, MN

Database Consultant

Responsibilities:

• 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.