Extensive professional experience in business and data analysis, data modeling, metadata management, data lake, statistical analysis and machine learning with various distributed relational databases which provide a unique opportunity to bring in with technical expertise and the business knowledge. SELECTED RELEVANT EXPERIENCE Architectural Framework * As-is Business Processes * As-is Data Architect * To-be Data Architect * As-is Application Flow * As-is Data Flow * Systems Usage * Technology usage * End-State Architecture * Data Dictionaries * Documented, Mentored & Developed conceptual and logical data models, BPMN and application models for Quote to Cash, Customer Advocacy and Enterprise Architecture team at CISCO using IBM System Architect (Telelogic) modeling tool. * Developed BOM model at HP, COSTS & QSAR Model at IBM and Reverse Engineered Mac& Indigo Data Warehouses at Apple using ER Studio and ERWIN modeling tools. * Documented and developed as-is QTC and CA applications and data flow diagrams at CISCO using System Architecture tool for Order and Customer subject area. * Developed and standardized data flow schema using Gene & Sarson data flow methodology and implemented at Delta Dental using MS Visio for Member, Provider and Claim subject areas. * Created Data Dictionary for Order, Customer and Shipment subject area for Cisco Claim, Member and Provider subject area for Delta Dental Automobile Repair Order and Appointment subject area for Xtime Contract Manufacture and Supply Chain subject area for HP and Apple. Strategy and Tactical Data Process design * Strategic data analysis * Tactical ETL processes * Designed strategic address standardization and enrichment processes to enable all dental insurance related subject areas for deliverable addresses which enable Delta Dental to contact all their customers via mail as a part of MDM project. * Designed a tactical ETL processes to port data from main frame to 3rd party dental application databases for Member and Provider subject area for Delta Dental. * Designed analytical BI metrics measurement processes to improve performance for Xtime service marketing and management reporting. * Design NOSQL databases on HADOOP Platform like HBASE, HAVIE, GEMFIRE and Greenplum (PostgreSQL) at GE. Data Mining and Data Quality * Data Pattern * Map & Gap Analysis * Data Anomalies * Conduct RAMBO Universe As-is performance analysis and EDW data mapping for QTC at CISCO. * Analyze Bill of Material (BOM) structure and identified gap for HP and Apple. * Establish automated process to find anomalies of Claim, Member and Provider subject area for Delta Dental which helps to take data cleansing decision on data conversion processes. * Analyze Contract Manufacture supply chain data & process gap for Apple Mac and Indigo products data anomalies. * Analyze transportation and locomotive data & process gap for GE transportation products. Meta Data Architecture * Metadata Concept * Data Lineages * Web Portal * Big Data Architecture and Data Science * Design customer services metadata and presented to CISCO Enterprise Architecture Group. * Design Skill RDF metadata for CISCO services Group. * Modeled metadata and built user friendly interface for ROCHADE metadata repository tool for Delta Dental. * Build Data Lineages on Teradata databases using Sandhill Data Lineage tools for Symantec on Erwin Web portal. * Integrate various transactional sources systems to centralize at Big Data platform in the form of Data Lake for transportation industry at GE. * Design the text searching data pattern and building logistic regression analytics models for locomotive subject area at GE. * Architect and Operationalize Reliability Data Lake and machine learning platforms at GE using R Scripting for logistic regression model and text similarity model (recommendation engine) respectively.

Highlights:

Companies I like:

open to all

• Engineering
• Microsoft SQL Server
• Reverse Engineering
• SAP
• Structured Query Language
• Data Mining
• Data Warehouse
• Manufacturing
• Mining
• VISIO