Ranadip Das Email & Phone Number

• 14 years of IT experience with special emphasis on Analysis, Design, Development and testing as a MDM Hub Specialist• Worked for a top Pharmaceutical company - AstraZeneca, Actavis and J&J and was responsible for development as well as support of their MDM applications• Designed, documented and configured the Informatica MDM Hub to support loading, cleansing, matching, merging and publication of MDM data• Worked on IDD/BDD (Business Data Director) Configuration• Expert in Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments• Helped business to decide the trust factor and Configured match rules• Creating Landing & Staging tables, Business Objects, Cleanse Match/Merge in Informatica MDM• Develop MDM data models (conceptual, logical, and physical master data models)• Address issues of master data definition, metadata acquisition and data migration including data profiling, validation, clean-up and remediation, and source to target mapping• Created test scripts and provided end-to-end support to clients before release testing• Efficient in maintaining off-shore team to meet project timelines• Expertise in Informatica PowerCenter 9.1/8.6/8.1 using components like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor• Extensive experience in creation of ETL Mappings and Transformations using Informatica Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, ERP Source Qualifiers, Aggregators, Filters, Joiners• Experience in source systems analysis and data extraction from various sources like Flat files, ORACLE 9i/8i, SQL Server, XML files• Experience working with Databases - Oracle 10g/11g.• Worked with packages, procedures and views for Informatica MDM User Exits and Informatica ETL mappings.• Informatica MDM 10.1 Developer certified,

Listed skills include Pl/Sql, Informatica, Requirements Analysis, Unix, and 23 others.