Data Management Visualization
Resume:
Lan Shen
********@*******.***
Experience Summary
With extensive experience, Lan has developed diverse skills in data modeling, data architecture design, master data management (MDM), data integration, and data visualization. Throughout his career, Lan has excelled in various roles, including solution architect, developer, and tech lead. As a 25 years of data consultant, Lan is a quick learner with exceptional analytical abilities.
Skills
Skill Set 1: Data management: Data Modelling, Master Data Management, Data Integration, Data Visualization, and Data Quality Management, Data Governance
Business analysis, data management maturity level evaluation, and profiling
Solution consulting and data architecture design
Data Modeling: ERWin and ER/Studio
Data Integration: Talend, Equalum, Azure Data Factory, and Denodo
Data Visualization: PowerBI, Tableau
Master Data Management: IBM, Informatica, and in-house developed
Languanges: Java, Java Script, C++, Python, SQL Script, SQLCMD(T-SQL), DAX
Skill Set 2: Gen AI: Gen AI, Azure AI Cognitive Services, Data Science, Data Visualization
Strong math and statistics background
Trained in Gen AI, Azure AI Cognitive Services, Data Visualization
Big Data technical design and development (Cassandra)
Strategy, solution, integration, and data ingestion design (Hadoop)
Industries
Pharmaceutical, Banking, Insurance, Retail/Manufacturing
Employment History
-TCS: 2011 - 2024. Data Architect, Data Modeler, and MDM Architect
-IBM: 1999 - 2011. Siebel and MDM Architect
Personal Information
-Gender Male
-Nationality US Citizen
-Base Boston, MA
-LinkedIn (27) Lan Shen LinkedIn
Education
-Ph.D: Electrical Engineering, Georgia Institute of Technology, 1992-1998
-MS: Computer Science, Georgia Institute of Technology, 1995-1997
-MBA: Finance, Georgia Institute of Technology, 1994-1006
Selected Project Assignments
Project: In-house developed proprietary material item master data management application. 4/2020 - 6/2024. A worldwide top pharmaceutical company
Role: Data architect and developer, data modeler, and data integration team lead
Responsibility: Strategy consulting, requirement analysis and translate into data model and data integration requirements. Data modeling, database development, and data integration design and development.
Technology: ER/Studio, ERWin, Azure SQL Server, Denodo, Azure Data Factory, Equalum
Client: GSK
Project: Merge and Spin IT Migration. 5/2018 - 2/2020. A worldwide top material, seed and chemical manufacturer in US
Role: BA, Consultant, Site IT migration decommissioning manager
Responsibility: Site IT post-migration process design, template preparation; Repository sharepoint design and administration; Site IT connectivity analysis, initial IT inventory preparation.
Site Lead communication coordination, site testing coordination, User story analysis and task definition; data model / metadata update and development; UI metadata update and development; data publish framework update.
Technology: MS Office, MS Project
Client: DuPond
Project: Customer Master File Build. 8/2017 - 4/2018. A top regional insurance company in US.
Role: MDM architect and developer, data modeler
Responsibility: User requirement analysis; solution design; data model design and mapping; matching metadata design, SDP/EG design and configuration; data injection to MDM and DataLake design, onshore/offshore development coordination.
Technology: IBM MDM AE 11.5, DataStage, AVI, IGC, Hadoop and BigInsight
Client: Ohio National (ONFS, Phase II), Life, Property&Casualty
Project: Single View of Customer. 2/2017 - 8/2017. A top nationwide insurance company in Canada
Role: MDM architect and developer, data modeler
Responsibility: User requirement collection and analysis; solution design; data model update and mapping; matching metadata update, SDP design and development; data injection and real-time integration design, onshore/offshore coordination.
Technology: IBM MDM AE 11.5, IGC, DataStage, Ab Initio, AVI, BigInsight
Client: Great West Lifeco Inc., Life, Health
Project: Enterprise Data Integration, Reference Data Migration. 9/2016 - 12/2016. A top nationwide insurance company in US.
Role: Integration architect and developer, data modeler
Responsibility: User requirement collection and analysis; Reference and organization hierarchy data model design and development; metadata and DQ business process design; data integration to EDW design.
Technology: IBM MDM/RDM 11.4, ERWin, DataStage
Client: Nationwide Ins., Property&Casualty
Project: Data Ingestion IMDG; Data Processing on Redshift (AWS). 2/2016 - 8/2016. A top worldwide pharmaceutical company in US.
Role: Talend integration architect and developer.
Responsibility: Gemfire data ingestion Spring XD developer; Talend integration environment setup,Talend integration with Redshift (AWS) design and development, AWS query scripting; Talend SAP Hana data extraction design and development.
Technology: Redshift (AWS), Talend, Gemfile, Spring XD
Client: Jason pharmaceuticals (John & Johnson)
Project: Data Intake Solution Design. 8/2015 - 2/2016. A top worldwide enterprise rating company in US.
Role: Integration Architect.
Responsibility: Metadata based data ingestion solution and technical design; application data and metadata data modeling; PoC design and development management.
Technology: ER Studio, Informatica, Eclipse for Java.
Client: Moody’s
Project: Enterprise Data Management Strategy and Roadmap Consulting. 6/2015 - 8/2015. A top regional insurance company in US.
Role: EDM Solution architect.
Responsibility: EDM maturity assessment and data profiling, Data quality management and data governance maturity assessment, EDM strategy and roadmap design.
Technology: MS Office, Hadoop.
Client: Ohio National (ONFS, Phase I), Life, Property&Casualty
Project: Retirement Plan Report Foundation.1/2015 - 6/2015. A top nationwide insurance company in US.
Role: EDW architect and data modeler.
Responsibility: EDW business requirement analysis, EDW model design and mapping, EDW modeling; ETL solution design.
Technology: ERWin, Netezza, Informatica.
Client: Nationwide Ins. Property&Casualty
Project: Enterprise data quality management consulting. 11/2014 - 1/2015. A top global reinsurance company in US.
Role: DQ management consultant.
Responsibility: EDM data profiling design and development, DQ management maturity analysis and assessment, Metadata and DQ management solution and roadmap design.
Technology: MS Office, SalesForce on cloud, MDM.
Client: Swiss Re Group
Project: Hospital Encounter Summary. 5/2014 - 11/2014. A top nationwide hospital management company in US.
Role: EDM architect and MDM solution architect, data modeler
Responsibility: Requirement analysis, end-to-end data flow design, DataLake solution design, MDM strategy and roadmap design, MDM patient data model design.
Technology: Informatica MDM, Hadoop, Cloudera, Teradata.
Client: Community Health Systems
Project: Project Execution Service (PES). 10/2013 - 5/2014. A top nationwide Explore and Production Company (EPC) in US.
Role: EDM reference architect and MPM architect.
Responsibility: Integration reference architecture solution, data and data hub reference architecture, enterprise ODS model, MPM data ingestion, data modeler
Technology: ERStudio, MS SSIS, BizTalk, .Net framework, Stibo MPM.
Client: Performance Energy Services
Project: Legal Entity Status. 2/2013 - 10/2013. A top nationwide asset management firm in US.
Role: MDM (Customer master) architect and developer, data modeler
Responsibility: Requirement analysis and high level MDM solution design, technical design, application configuration and customization development.
Technology: IBM MDM Server 9, WebLogic, Eclipse, MQ.
Client: Northern Trust
Project: Customer Knowledge Profile. 8/2012 - 2/2013. A top worldwide retail company in US.
Role: Technical designer and Java developer, data modeler
Responsibility: Low level Java batch service design and development and testing.
Technology: Cassandra, Eclipse with Jason structure services, Maven, git, Hadoop.
Client: Walmart
Project: CDIC Project. 11/2011 - 8/2012. A top worldwide bank in Canada.
Role: MDM (Customer data) architect and development lead, data modeler
Responsibility: Requirement collection and analysis, solution and technical design, SDP/EG design and application configuration, onshore/offshore development coordination.
Technology: IBM MDM Server 9, MQ, Rational ClearCase, Informatica.
Client: Scotiabank Canada
Project: Customer Data 2012. 4/2011 - 11/2011. A top worldwide insurance company.
Role: MDM (Customer data) architect, data modeler
Responsibility: Requirement collection and analysis, solution and technical design, data mapping, service development review and lead, customized matching and collapse code development, onshore/offshore development coordination.
Technology: IBM MDM Server 8.
Client: AXA
Contact this candidate