• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to business rules.
• Created mappings using Informatica Power center and loading data into pre-landing tables.
• Created Unit Test Case Document, Detailed Design Document, Supplementary Document and Knowledge Transfer Document.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

• Develop database solutions to store and retrieve company information
• Install and configure information systems to ensure the functionality
• Analyze structural requirements for new software and applications
• Migrate data from legacy systems to new solutions
• Design conceptual and logical data models and flowcharts
• Improve system performance by conducting tests, troubleshooting and integrating new elements
• Optimize new and current database systems 

• Working closely with SME, Work Stream Leaders and BA to understand the existing systems requirements and prepared functional and technical solution documents.
• Responsible for defining road map for migrating from client server architecture (Teradata) to private cloud and levering Microsoft Azure Services such as SAAS, PAAS and IAAS.
• Currently spearheading a framework for a Business-Driven approach defining a system agnostic Data Architecture. 
• Proposed developing Enterprise Business Process Models and Data Models with common business semantics and supporting change control and governance processes. 
• Established guidelines for reconciliation and mapping of legacy information.

• Led the technical effort to redesign the PQRS Claims Processing engine.
• Designed a Rules engine in Oracle to evaluate Medicare claim data. This led to an 80% increase in system throughput compared to the Legacy rule engine.
• Analyze the functional and non-functional requirements and provided overall solution working with application architect.
• Prepare high level process flow from data ingestion to reporting 
• Designed the source feed to the rule engine in Teradata SQL and BTEQ to make use of Teradata MPP processing.
• Designed the logical and physical data models for the PQRS DataWarehouse.
• Involved in implementing the process of loading the customer Data Set into Informatica MDM from various source systems.

• Led the technical effort to redesign the PQRS Claims Processing engine. 
• Designed a Rules engine in Oracle to evaluate Medicare claim data. This led to an 80% increase in system throughput compared to the Legacy rule engine. 
• Designed the source feed to the rule engine in Teradata SQL and BTEQ to make use of Teradata MPP processing. 
• Designed the logical and physical data models for the PQRS DataWarehouse. 
• Gathering business requirements from Business Analyst and created source to target mapping documents and ETL data flow documents. 
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems. 
• Worked on data cleansing using the cleanse functions in Informatica MDM. 

• Direct or coordinate activities of engineering or technical personnel involved in designing, fabricating, modifying, or testing of code.
• Defined and configured schema, staging tables, and landing tables, base objects foreign key relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.

• Provided key technical inputs to multiple contract proposals
• Led the technical effort to redesign the PQRS Claims Processing engine
• Prepared high level BRD, SRS DTD documents by adhering to CMS/CSRA documentation standards
• Designed a Rules engine in Oracle to evaluate Medicare claim data. This led to an 80% increase in system throughput compared to the Legacy rule engine. The performance improvement significantly contributed to task expansions from CMS resulting in contract awards 
• Designed the source feed to the rule engine in Teradata SQL and BTEQ to make use of Teradata MPP processing
• Designed the logical and physical data models for the PQRS DataWarehouse 
• Architected data loading strategies and business processes

• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate  data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment. 
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Helped the testing team for data integrity and consistency.