Sunil T Email and Phone Number

Interacted with the Business Team to understand the requirements and prepared technical documents for implementing the solutions as per Business needs. Configured and installed Informatica MDM Hub server, Cleanse, resource kit, and Address Doctor Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub. Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems 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 Created Sessions/Batches in Informatica server manager to execute mappings. 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. Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data for Dealer, Dealer Group, OEM, AD-Agency, Rental Car Company, Nameplate, Worker subject areas in IDD data tab. Deployed new MDM Hub for portals in conjunction with user interface on IDD application. Responsible in installing the SIF Services Development Kit (SDK) and used the Java classes by running a Java virtual machine (JVM) High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role Finally, Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowle

Professional Experience:Raymond James, St. Petersburg, FL AUG14-PRESENTInformatica MDM DeveloperRaymond James Financial is a diversified holding company providing financial services to individuals, corporations and municipalities through its subsidiary companies that engage primarily in investment and financial planning, in addition to investment banking and asset management. The main goal of the project was to identify single customer master across the enterprise.

Nationwide Insurance provide full range of insurance and financial services across the country. A real-time operational MDM hub integrating multiple services, establish cross-functional data governance, and measure ongoing data quality project for customer data, through the use of multi domain MDM.

Autodesk, Inc. is an American multinational software corporation that makes software for the architecture, engineering, construction, manufacturing, media, and entertainment industries. Autodesk is headquartered in San Rafael, California, and features a gallery of its customers' work in its San Francisco building. The aim is to develop MDM business strategy and roadmap for person master for B2C customers.

This project is to master the Global Payment Customer data across all consumers, financial institutions, merchants, governments and businesses worldwide units using MDM Hub implementation

Cummins Inc., a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines Headquartered in Columbus, Indiana, (USA). Employs approximately 46,000 people worldwide and serves 190 Countries and territories through a network of more than 600 company-owned and 6500 dealer locations.The goal is to have information across the globe to be consolidated into a single data warehouse and generate consolidated and detailed reports out of it. The data is loaded into the data warehouse (Teradata) using Informatica as the ETL Tool. The critical part of the project is to make available this data updated daily.

Created and when required, modified already existing stored procedures, triggers, views, indexes. Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications. Designed and created views for security purposes, implemented rules, defaults, and user defined data types.Tested queries to optimize the procedures and triggers to be used in production. Extensively used SSIS Import Export Wizard, for performing the ETL operations. Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa. Involved in writing MDX Scripts for the OLAP CUBES.Created Static Reports using MDX queries and creating MDX Base Report Definition. Created the SSIS DTS packages and scheduled them. Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS). Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.