Post Job Free

Resume

Sign in

Data Management

Location:
Fremont, CA
Posted:
February 26, 2017

Contact this candidate

Resume:

Venkat Subramanian

ENTERPRISE DATA ARTCHITECT/PROJECT-PROGRAM MANAGEMENT

***** ******* ******

FREMONT, CA 94536

acy0ip@r.postjobfree.com

PHONE: 510-***-****

PROFILE

I have 20+ years of Functional/Technical/Program management experience in Banking/financial, manufacturing, retail, production. I have successfully implemented over 4-6 MDM projects and has served as Architect/Subject Matter expert on several other MDM projects. I have successfully implemented over 10 major EAI projects including SOA projects using leading Integration middleware products. I have managed huge global ERP implementations. I have managed complex aircraft manufacturing/servicing programs. I have served as team lead/Architect on several Oracle EBS projects. Experience includes:

oExtensive project/program management experience with track record of having implemented over 40+ projects of varying complexities with team sizes as large as 300 and program costs ranging from $1M – 300M.

oExtensive knowledge of business functional areas to understand business processes easily and translate them to technical stakeholders

oExtensive functional and technical knowledge in optimal integration solutions using SOA and products such as Oracle Fusion, Oracle AIA, Siebel UAN, TIBCO, IBM MQ, Vitria etc.

oExtensive functional knowledge and experience in design, development and management of products such as Siebel UCM, Sales, Marketing, Call Center, Oracle EBS, Oracle Fusion, Oracle CDH, SAP, Sales Force, Informatica

oExtensive Enterprise data management experience including enterprise architecture, EAI architecture, Data governance, Data Quality processes with tools such as EDQ, Trillium, IDQ, IIR, Data modeling and architecture for DWH/Data Marts and analytics

oProven track record of effective program/project management of several projects over years including some very complex programs

EXPERIENCE SUMMARY

Information Architecture/Program Management Charles Schwab, San Francisco, CA

June 2015-Current

Information Architect

In charge of everything to do with retirement of an existing on-premise CRM system. In charge of ETL Development for data migration to SFDC including security, legal compliance. Using Informatica PowerCenter to build one-time migration of data including automated reconciliation for data migration. Data profiling to identify issues with data and remediating them prior to migrating to SFDC. Scanning legacy system to identify non-compliance for PCI and NPI data and remediation of these prior to migration to SFDC

Integrating SFDC CRM instances with Informatica MDM with Informatica MDM as the single source of truth for accounts and contacts

Working closely with QA/UAT team to identify test cases, test scenarios, generation of test data. Develop and implement data reconciliation process for accounting data for the ETL process from source systems to Target systems.

Working closely with DWH team to redesign data model to accommodate revised data representation on the cloud, design and implement ETL for all batch process to DWH and end consumer systems.

Coordinate with all business stakeholders to process orchestration/visualization to drive consensus and develop data retention and archival timelines for data and documents for the cloud based CRM system.

Integration of cloud data with on premise data marts, consumer applications and Data Warehouse. Integration of cloud data and on-premise customer master using RESTful service and MuleSoft middleware. Working with DW team to load data to Hadoop clusters using SQOOP, retrieval and analysis of data using Chameleon, Hive, Pig.

Design test strategy, develop test cases and test data and coordinate with QA team on successful completion of QA

End-to-end program management using Agile project methodology with direct team size of 20 onshore and 12 offshore resources. from initial analysis to go-live and post go-live support/KT, release management. Because of the meticulously detailed planning and shrewd and prompt contingency management, the project finished on target to enable Schwab to terminate the license on existing CRM products and retire all the infrastructure in total.

Big Data Management InTeliKore Corporation, Milpitas, CA

Sept. 2014-June 2015

Startup Data Enrichment Service

Solution architecture, development, testing and hosting of Data Enrichment Services. Data Enrichment service plugs data holes in sparsely populated entity data and improves the depth and breadth of the data to make it complete, correct and current through a streamlined process. The Service uses web crawler, NLP, HADOOP, Cassandra, Solr and proprietary algorithms at its core to mine big data on the internet and validate/rank data based on the authenticity and trustworthiness of the sources and corroboration of data across different sources.

Solution architecture/dimensional data modeling for data loading using Informatica Power center, Informatica IDQ and PL/SQL.

Development of REST and SOAP services for seamless integration for data enrichment in real time.

Managed program including infra-structure, hardware, software, access control and security and delivered the project on time and of high quality to enable InTeliKore to sign up their first customer for the service.

Data Modeling/Web Dev/Program Management Medical Device Startup, CA

Jan. 2015-Current

Setting up a web site for a Medical Device Startup comprising the following:

Business Requirements gathering and analysis

Data Model Design and setting up database and users with appropriate privileges

Building and testing web site using WordPress, plugins and custom PHP, CSS, JavaScript

Customize WordPress Themes

Test the design for responsiveness to mobile devices for all use cases

Web hosting of the site and Search Engine Optimization

VP – EAI/MDM Serene Corporation, Santa Clara, CA

Sept. 2005-Aug. 2014

All projects listed below involve project management and knowledge transfer to operations team and 6 weeks of three levels of operation support post go-live. I have in-depth knowledge of the technologies/products and am hands-on where needed. My hands-on expertise and business knowledge gives me a unique advantage in communicating between business and IT.

While in Serene Corporation, did the projects detailed below:

SME-Informatica MDM Multiple projects

Nov. 2011-Aug. 2016

Installed and configured Informatica MDM on sandbox for pre-sales POCs and demos. Train and nurture Informatica MDM consultants. Review project implementation details with project leads on Informatica MDM implementation, identify issues and improvements and discuss with project leads.

MDM/EAI/Enterprise Data Architect/Project Management Experian, Leeds, UK

Nov. 2013-Aug. 2014

Installed and configured Oracle UCM 8.1.1.7 along with Oracle EDQ. Carried out data modeling and mapping exercise for Experian entities between Salesforce and three home-grown enterprise systems to UCM Customer model. Completed proof of concept implementation of UK Major accounts to provide customer-360 view across 4 systems. Designed and implemented ETL/EIM for loading data from four enterprise systems. Performed match profiling to fine tune matching rules.

MDM/Enterprise Data Architect Die Mobiliar, Berne, Switzerland

Dec. 2013-July 2014

Installed and configured Oracle UCM 8.1.1.7 along with Oracle EDQ. Designed and implemented custom process to do address validation against Swiss address files seamlessly with Oracle UCM. Automated ETL/EIM/PL-SQL processes for initial load and subsequent updates of Swiss address files.

MDM/EAI/Enterprise Architect Equinix, Sunnyvale, California

Dec. 2013-May 2014

Performed UCM and EDQ Health check, fine tuning and configuration for batch loading of accounts to UCM. Architected D&B integration for customer data enrichment at UCM using D&B real time web services (REST) and mapping/transformation and orchestration at the TIBCO middleware layer. Integration between Sales force, Oracle EBS and Oracle UCM using TIBCO middleware, canonical model and associated mapping and transformation. Performed address validation fine tuning for performance and matching. Did match profiling to optimize matching at UCM. Integration of data and orchestration of business processes between SFDC, UCM and EBS.

MDM/EAI/Enterprise Data Architect/Project Management Autodesk, SFO/San Rafael, California May 2013-March 2014

Performed a health check on existing 8.1.1.5 including detailed data profiling using Oracle EDQ to identify issues and developed plans for addressing issues. Did redesign/configuration of survivorship rules and business processing logic for mastering account, contact and address data. Architected and reconfigured UCM data model for Autodesk organization and person entities including relationships with address, preference and privacy data. Developed technological architecture for data enrichment from Big Data mined from public and social networks. Designed data model and integration of participating enterprise source systems – Salesforce, Siebel Sales and home-grown systems and downstream integration of customer data with enterprise data mart using HADOOP framework and TIBCO Middleware. Configuration of Trillium 13.x for multinational cleansing and matching rules implementation. Developed implementation plans using Agile methodology for the solutions. Conducted training and knowledge transfer on EDQ and data profiling to the business stakeholders.

Integration and orchestration of data sync between UCM, SFDC, SAP and Siebel systems.

Data Quality Architect Subaru, North Carolina

July 2013 – September 2013

Installed and configured Trillium 13.x, configured address validation and matching rules. Used Trillum APIs for custom batch matching using Java and updating them back in Siebel using Java.

MDM/EAI/Enterprise Data Architect/Project Management US Foods, Roseville, Illinois

Aug. 2012 – May 2013

Business requirements gathering for the food distribution process and business analysis to provide high level solution design for addressing the business requirements.

Installed and configured Oracle UCM 8.1.1.4 along with Oracle EDQ to perform deduplication of customer records and standardize customer data. Carried out data modeling and mapping exercise for legacy Customer data entities to UCM Customer model. Designed and implemented automated ETL batch process involving several PL/SQL processes, EIM processes and rules validation to implement customized inheritance of attributes across customer hierarchies and associated entities. Implemented batch integration for batch load and TIBCO Middleware Integration for real time updates between Siebel, Tandem, Oracle Customer Master and Data warehouse. Dimensional data modeling for data marts and EDW.

MDM/EAI/Enterprise Data Architect/Project Management Gilead, Foster City, California

April 2011 – Aug. 2012

In charge of business requirements gathering and analysis to understand current process, strengths and limitations and review with business stakeholders to develop future system requirements. Develop roadmap for transition from existing state to desired state in a phased manner. Salvaged prior implementation fine tuning batch load performance cycle time from existing weeks down to hours. Re-Implemented UCM using service paradigm to integrate with participating legacy customer master (CMP) and CRM (Tango). Redesigned and automated ETL/EIM processes for periodic data updates from external systems. Architected and implemented data enrichment from external service providers of physician data. Venky carved out the MDM/DQ roadmap for Gilead using MDM Maturity model. Venky architected and implemented the complete solution for SunShine Act compliance and for compliance needs of sample medicine deliveries. Provided assessment for porting from Informatica IIR to Oracle EDQ. Data warehousing architecture/dimensional modeling for prescription data from physicians. Venky provided the framework and helped implement data governance at Gilead to manage enterprise data effectively.

UCM Architect WestPac, Sydney, Australia

Nov. 2010 – Apr. 2011

Performed MDM and Data Quality health check assessment. Architected address cleansing and address certification with Australian Postal Service for IIR 2.8.0.7 and Address Doctor. Architected MDM implementation using Oracle UCM 8.0.0.7, Informatica IIR 2.8 and IDQ 9.x. Architected ETL solutions using Informatica and oracle EIM. Architected sync between SFDC and UCM for data cleansing and deduplication.

MDM Program Management Visa, Foster city, California

Aug. 2010 – Nov. 2010

Information gathering, analysis and review and walk thru with business stakeholders to understand future requirements, Architected and implemented a pilot MDM program from concept to go-live for Visa in 13 weeks. The solution was focusing on Oracle UCM’s hierarchy management capabilities to provide a platform for Visa to manage multiple hierarchies such as legal, billing and marketing hierarchies to support the business activities. Architected and automated bulk batch data through TIBCO middleware.

UCM Architect Bendigo Bank, Bendigo, Australia

Jan. 2010 – Sep. 2010

Performed an assessment of the UCM architecture with SSA implementation based on business process and uses case analysis, identified gaps, provided solution alternatives and implemented recommended solution. Did a performance fine tuning for initial load process and daily batch update for accounts and contact entities.

UCM/Data Quality Architect CarreFour, France

Aug. 2010 – Sep. 2010

Developed high level architecture for bulk loading of data into UCM and Informatica IIR, including initial data load from legacy systems into UCM, monthly updates of entire legacy data into UCM and daily batches. Did a Proof of Concept by loading a sample of data, performed DeDuplication, fine-tuned the data quality parameters and set the thresholds for auto merge and manual review processes. Performed a limited data profiling analysis and identified and prioritized data quality issues that need be addressed as part of the Master Data management initiatives.

MDM Architect/EAI Online Retailer,NH

Nov. 2009 – Feb. 2010

Performed a very detailed data profiling of the customer data in all their enterprise systems and provided an analysis with a prioritized list of data quality issues that need to be addressed and their impact/ROI. Did a high level product agnostic Master Data Management architecture. He also developed detailed initial data load architecture for loading of the legacy data in MDM. Developed the end-to-end integration architecture, timeline and resource estimates and roam map for phased transition from current state to desired future state.

MDM Architect Move.com, Los Angeles, CA

Aug. 2009 – Nov. 2009

Performed a detailed data quality analysis and data profiling on existing systems on their enterprise and identified and prioritized the data quality issues. Did a high level analysis on current enterprise system, their business processes and recommended appropriate master data architecture to address their issues including an ROI assessment of the proposed solution.

UCM/Enterprise Data Architect/EAI MLC/NAB Sydney, Australia

June 2009 – Aug. 2009

Performed a high level analysis of the business processes on current and planned enterprise systems, cursory analysis of data quality and provided a high level Master Data Management architecture appropriate for their enterprise. Also provided a high level estimate and proposal for implementation of such a system including initial load of data in MDM system, implementation of the end-to-end integration architecture and UCM implementation. Also provided a road map for MLC/NAB transition from current state to future state.

MDM Architect/Program Management Oracle, Redwood Shores, CA

Jan. 2009 – Jan. 2011

Oracle and Serene are development partners, for their product on Oracle UCM/DQ. Worked with Oracle Engineering team to architect optimal solutions to address issues with the current implementations of the Siebel DQ and connector. Worked with third party vendors such as Informatica to coordinate, design and build these enhancements in Siebel UCM/DQ module. Setup and evaluation of competing MDM products such as Siperian - Informatica MDM, IBM Infosphere products and fine tuning each and doing performance benchmarks and functional comparisons.

MDM Program Management/Architect/EAI SuperValu, Boise, ID

July 2008 – Dec. 2011

In charge of information gathering to understand the several channels of customer and their interaction with the system along with associated data flows. Architected the solution to address cascaded matching functionality required by SuperValu and not supported by Siebel UCM OOB. Architected and designed the initial Data load strategy to seamlessly generate automated test data to address all use cases. Architected and implemented the messaging using TIBCO middleware including message serialization/consolidation and handling of concurrent updates. Initial loading using Trillium batch processes to load more than 60 million customers. Used ingenious and simple spreadsheet based solution for generating test data for every possible use case to test the robustness of matching algorithms. Integration with data warehouse for consumer data.

EAI/DQ Architect/Project Management NetApp, Sunnyvale, CA

Nov. 2007 – Nov. 2008

In charge of program management including information gathering/analysis to solution design/review/implementation, management project end-to-end across several teams, integrations with other enterprise systems, coordinate with QA teams to develop QA strategy, test cases and test data generation, deployment planning, go-live, KT and post go-live support and release management.

Architected, designed and built a solution for Account Cleansing and Deduplication using Siebel DQ and Trillium. Architected/implemented seamless integration of Siebel Sales with Oracle CDH for mastering Account data including real time orchestration of all account/contact/address. Designed dynamic account hierarchy maintenance system based on D&B hierarchy. Architected the SOA based integration using Oracle Fusion Middleware between Siebel Sales and Oracle EBS. Orchestrated messaging middleware solution between Siebel and all participating system using TIBCO middleware and JMS messaging. Performed Business use case analysis for all master data related data for CDH and interaction with all participating systems.

EAI/UCM Architect VMware, Palo Alto, CA

Jan. 2007 – Aug. 2007

Lead for the architecture and Design for a Service Oriented Architecture (SOA) Solution providing a single view of customer across all enterprise applications – Siebel, Oracle EBS and Oracle Order Management. Architected, designed and built SOA Architecture across the enterprise Applications using Oracle Fusion Middleware integrating Siebel 7.5, Oracle EBS and Custom portal with UCM with Trillium DQ.

EAI/EIM Architect/Project Management Charles Schwab, San Francisco, CA

May 2006 – Dec. 2006

As part of the Solution, led and delivered the Architecture and Design for integration Architecture using IBM MQ messaging as part of Siebel Upgrade from 7.5 to 7.8. Architected the complex batch loading system using MQ, ETL, Siebel EIM and Autosys to sync data from various enterprise systems with Siebel Call Center. Architected and implemented an innovative insurance system to fall back to Siebel 7.5 system by syncing data seamlessly between the upgraded and dormant 7.5 system.

OTHER PROJECTS EXECUTED

Siebel Projects

oIntel – TIBCO based enterprise Integration across enterprise

oAutodesk – Siebel UAN

oCISCO –Siebel Sales Marketing Call Center integration using TIBCO and Siebel UAN

J2EE/EAI Projects

oMirant, Georgia

oNovartis, New Jersey

oJI Case, Wisconsin

Enterprise Integration Projects

oIntegration Architect, Intel

oEnterprise Architect, Covisint

oIntegration Architect/Tech. Lead, Quest Communications

oTech. Lead/Bell South

oIntegration Architect, SBC Wireless

oIntegration Architect/Tech. Lead, Mirant

oIntegration Architect/Tech. Lead, Novartis

Oracle EBS Projects

oTech. Lead/Techno-Functional SME, Global EBS Implementation, Michelin, Green Ville, SC

oTech. Lead, Golden Books, Racine, WI

oTech. Lead, Quest Communications

oTech. Lead, Bell South

WebLogic configuration/Administration

oMirant, Georgia

oNovartis, New Jersey

oAll Oracle UCM projects – UCM data governance manager application runs on WebLogic.

EDUCATION

Ph.D. Business Administration Kent State University, Kent, OH

B.S. Mechanical Engineering Annamalai University, India

Skills

Program/Project Management:

-Managed 40+ projects/initiatives

-Off-Shore resource management and coordination

-Waterfall/Agile/Scrum methodologies

Functional/Industries:

-Data Governance

-Master Data Management, Data Quality, Big Data Mining, Data Enrichment, Address Validation

-Data Marts, Data Warehouse

-Call Center/Service, Mktg., Sales

-Siebel Financial Services

-Insurance

-eCommunications

-Consumer Goods

-Cloud Services

-Big Data

Integration Technology:

-Oracle Fusion/SOA

-TIBCO

-IBM MQ

-Vitria

-Siebel UAN

-Oracle AIA

-Web Services

-RESTful Web Services

-XML/XPath

-Data virtualization frameworks such as Denodo

-Integration frameworks - OAG/HL7/.Net/Oracle AIA

Business Process:

-Accounts, Contacts, Activity, Service Requests Mgmt.

-Email marketing

-Campaign Mgmt.

- Opportunity Mgmt.

-Quotes, Order Mgmt.

-Test Strategy, Test methodology, Automated test data generation

ERP Applications:

-Oracle EBS – Technical and functional (almost all modules)

-Oracle Customer Data Hub

-SAP

Siebel Configuration:

-Siebel Tools

-Siebel Data Model/Repository

-Siebel eScript

Siebel EAI/EIM:

-Integration Objects

-Business Process Automation/Workflow

-Transport Adapters

-ASI (Application Services Interfaces)

-VBC/EBC

-Web Services

-JMS Receivers

-Enterprise Integration Manager (EIM)

Siebel Administration:

-Batch Job, RCR

-Performance Optimization

- Component Mgmt.

-Workflow Monitor Agents

-Generate DB Extract

-JMS Receivers

-Communication Outbound Manager

Specializations:

-Project/Program Management

-Master Data Management and Data Quality

-Oracle UCM

-Informatica MDM

-Custom Master Data Solutions

-TIBCO MDM

-Informatica Data Quality products – IDQ, IIS, IIR, Address Doctor

-Trillium

-SSA

-FirstLogic

-IBM InfoSphere solutions

-Java/J2EE

-Informatica PowerCenter

Languages:

-Java

-J2EE

-C++

-Pascal

-ALGOL

-COBOL

-Visual Basic

-PHP

-JavaScript/Python

Certifications:

PowerBuilder

Web Development:

-WordPress

-HTML

-CSS

-JavaScript

-PHP

-MySQL

-Python

Operating Systems/scripting:

-Windows – all

-Linux

-UNIX

-DOS – Batch

-PowerShell

-Windows Scripting

Database:

-Oracle

-DB2

-Sybase

-MS SQL Server

-ANSI SQL

-PL/SQL

Web Servers:

-WebLogic

-IBM WebSphere

-JBoss

-Apache

-

Open Source Solutions:

-Apache Sqoop

-Apache Hadoop

-Cassandra

-Talend

-Mongo DB

-HBase

-NumPy

-Spark

-Solr/Lucene

-Hive

-Pig

-Map Reduce/MAPR

-KAFKA



Contact this candidate