Sonam Gyatso Bhutia
Piscataway,New Jersey
Summary
- WIth 14 years of IT experience as an Data Professional working in different data fields implementing Enterprise Data Model, Enterprise Master Data Management (MDM), Reference Data Management (RDM) , Data Architecture, Data warehouse and BI, Metadata Management, Data Quality for Life Science, Healthcare, Healthcare Insurance and Product Domains on Party , Member/ Provider , Product , Clinical Trial, Agent/ Producer,Transactions and Underwriting domains.
- Enterprise Data Modelling catering to Insurance Domain for Party / Policy/ Underwriting/ Transactions in Enterprise Data Hub (HIVE).
- Well versed, highly skilled and adept with Data Quality analysis and deriving Match Rules/ DQ Rules/ Hierarchical relationships between entities/ attribute relationships.
- Good knowledge of solution architecture of integrating MDM into the enterprise data warehouse.
- Competent with implementing Enterprise MDM Architecture.
- Proficient in Informatica MDM installations for clustered/ non-clustered environments and Disaster Recovery Setup with High availability/ Load Balancing.
Proficient in Informatica Power Center installations in multi-domains.
- Competent in creating Enterprise Data model for Healthcare Providers, Healthcare Members, Customer Master, Clinical Trials, Party, Policy and Transaction systems.
- In depth knowledge in erWin and dimensional data modelling.
- In-depth knowledge on configuring MDM Hub/ Informatica Data Director (IDD)
Practiced and hands on experience in configuring Match Rules/ Hierarchy/ Address Standardization/ Secure Access in Informatica MDM among others.
- Hands on experience on configuring IDD with Entity 360, Smart Search, workflow in IDD Tasks/ Active VOS, and exposing REST SIF APIs.
- Good knowledge on configuring ETL workflow and mappings with Informatica Power Centre and versatile with PL/ SQL statements, UNIX commands and Shell scripts.
- Well versed with milestones and deliverables in a typical end to end SDLC.
- Set Customer best practices expectations revolving around Enterprise Data Management.
- Provided product demonstrations and technical guidance to business users on the capabilities of Master Data Management.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Data Architect/ Data Modeler/Data Analyst
New York Life Insurance Co
Lebanon, NJ
05.2018 - Current
- Worked closely with business and stakeholders to gather business requirements and design data approach and modelling solutions to met the needs.
- Analysis of source data and model target entities
- Designed conceptual, logical and physical data models conforming to dimensional modelling techniques based on Industry standards and best practices on a HIVE Hadoop and AWS Redshift database.
- Create eRwin target subject areas and tables.
- Collaborated with ETL developers, QA teams, and Business team to ensure successful implementation of requirements.
- Collected, outlined and refined requirements, led design processes and oversaw project progress.
- Performed quality assurance checks on all developed models before deployment.
- Optimized queries by analyzing query plans and indexes in order to improve efficiency in Redshift.
- Identified, protected PHI/ PII and leveraged existing data in consultation with the data governance team.
- SME for Life Insurance domains (Party, Policy, Transactions, Marketer, Underwriting)
- Data migration and decommission of legacy admin systems and corporate data warehouse
- Disposition hypothesis for decommissioning of the Legacy System
Master Data Management Architect
Emblem Health Insurance
New York, NY
07.2017 - 05.2018
- Current State Analysis of the Operational systems and Enterprise Data warehouse
- Identification of the Domain and Source Systems eligible for mastering in MDM
- Source System Analysis for Data Quality Rules/ Match Rules/ Hierarchy/ Relationships
- Responsible for integration of MDM into Enterprise Data Lake for Big Data Analytics.
- Exposure to HIVE integration tools Spark, Informatica BDM
- Management of External (ISO Codes, USPS Address Standardization) and internal reference data
- Overall ownership of MDM Infrastructure Setup and MDM Server sizing
Installation of Informatica MDM Hub and Informatica Power Center (clustered/ non-clustered)
- Data Modeling for Members and Providers MDM
- Responsible for all project deliverables
- Manage and keep track of deliverables included in the Project Schedule.
- Integration of Informatica Address for US Address standardization.
Master Data Management Lead (Technical/Management)
Celgene Corporations
Summit, NJ
02.2017 - 06.2017
- Creation and review of Statement Of Work with the client.
- Responsible for all deliverables as part of Project Schedule.
- Manage and keep track of deliverables included in the Project Schedule.
- MDM Technical Lead for integration of Clinical Trial Management Systems (CTMS) into Customer Master MDM Hub.
- Requirement gathering for integration of CTMS in MDM Hub.
- Integration of Informatica Address Doctor Cloud Services for Global Address standardization.
- Enrichment of HCP/ HCO records with Med-Pro
- External reference data management for Country and State ISO Codes
- Implementation of Intra - Country match process for Global Clinical Profiles.
- Prepare SIT Plan for System Integration Testing.
- Review SIT Scripts, SIT results and Test Summary Report with the Client.
- Prepare UAT Plan, UAT Scripts and UAT Summary Report.
- Provide technical guidance to business users during UAT.
- Co-ordinate pre-deployment activities with the Operations team.
Master Data Management Architect /Tech Lead
Biogen Inc.
Boston, MA
01.2012 - 12.2016
- Architect/ Technical lead for Clinical MDM implementation.
- Involved in SOW creation, Project Estimation and Project Planning.
- Provide architectural solutions for integration of source systems into MDM and integration of MDM into Enterprise Data Ware house.
- Provide MDM BOM Server Sizing requirements
- Installation of Informatica MDM in a Weblogic Server
- Extensively worked in MDM and IDD development with Active VOS.
- Involved in integration of ActiveVos Merge, Update with Approval, Unmerge workflow with IDD applications.
- Management of Internal reference data
- Worked extensively on ActiveVos Central and Console for task management and configuration.
- Configuration of IDD with Entity 360
- Installed and configured provisioning tool.
- Provided technical guidance to MDM resources and other team members across verticals.
- Code migration across environments.
Informatica MDM Developer
Cognizant Technology Solutions
Kolkata, WB, IN
06.2011 - 01.2012
- MDM Developer for Product Master implementation.
- Extensively designed and configured MDM Hub as per the functional requirements.
- Extensively worked in IDD development and the work flow task management.
- Conducting Proof of Concepts for new IDD functional requirements.
- Code migration across environments.
Informatica MDM Developer
Cognizant Technology Solutions
Kolkata, WB, IN
08.2010 - 02.2011
- MDM Developer for HCP/ HCO Master data implementation.
- Extensively designed and configured MDM Hub as per the functional requirements.
- Extensively worked in IDD development and the work flow task management.
- Conducting Proof of Concepts for new IDD functional requirements.
- Code migration across environments.
Education
Computer Science And Engineering
RCC Institute of Information Technology
Kolkata, WB, IN08-2009
Skills
- Enterprise Data Architecture
- Enterprise Data Modeling and Design
- Master Data Management
- Reference Data Management
- Data Quality
- Enterprise Data Warehousing and Business Intelligence
- Informatica MDM Hub, Informatica Data Director, Active VOS
- Informatica Data Quality
- Address Doctor for address standardization
- Hadoop
- AWS
- PL/SQL - Oracle/MS SQL Server
- HP Quality Control
- Weblogic
- Apache Tomcat
- Redhat Jboss EAP
- Web Services
- REST and SOAP
- JSON
- XML
- Data migrations
- MS Project Manager
- ETL - Informatica, Data Stage, Talend
Certification
- Siperian Hub XU CCP
- Informatica MDM Hub 9.x, 10.x CCP
Accomplishments
- New York Life - Outstanding Performers Awards
Timeline
Data Architect/ Data Modeler/Data Analyst
New York Life Insurance Co
05.2018 - Current
Master Data Management Architect
Emblem Health Insurance
07.2017 - 05.2018
Master Data Management Lead (Technical/Management)
Celgene Corporations
02.2017 - 06.2017
Master Data Management Architect /Tech Lead
Biogen Inc.
01.2012 - 12.2016
Informatica MDM Developer
Cognizant Technology Solutions
06.2011 - 01.2012
Informatica MDM Developer
Cognizant Technology Solutions
08.2010 - 02.2011
Computer Science And Engineering
RCC Institute of Information Technology
- Siperian Hub XU CCP
- Informatica MDM Hub 9.x, 10.x CCP
Similar Profiles
Sheena A. SmithSheena A. Smith
Financial Services Professional at New York Life Securities/ New York Life InsuranceFinancial Services Professional at New York Life Securities/ New York Life Insurance
Chuntaye JordanChuntaye Jordan
CSR- Retention Analyst at New York Life Insurance CoCSR- Retention Analyst at New York Life Insurance Co
Dawn M. GreenDawn M. Green
Senior Representative Universal GBS Advocate at New York Life Insurance CoSenior Representative Universal GBS Advocate at New York Life Insurance Co