Divya

Total Experience: 9 Years 

Experience as ETL & IDQ Developer: 7 Years

Experience as Sybase Developer : 2 Years

EXPERIENCE SUMMARY:

7 years of IT experience in design, development and Implementation in which 4 years of experience in developing solutions for Data Integration, Cleansing and Data Migration using Informatica Power center and IDQ

Around 2 Years of experience in Sybase ASE.

Good Understanding of Informatica Concepts. 

Performed the Data Profiling and Data Analysis making use of Informatica Data Analyst and Informatica Data Quality (IDQ).

Expertise in Building Business Rules in IDQ and Integrate them with Informatica Power Center Mappings, as a cleanse functions in MDM and consume cleanse functions in User Exists or in external web services.

Expertise in Implementing Exception Handling in data process and generate Human Tasks using Informatica Data Quality (IDQ) for Data stewards to correct them.

Good understanding of Data warehousing concepts. And developed Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type I and Type II)

Worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, DVL, Sybase, Flat files and XML files.

Expertise in performance tuning, debugging and Error handling of mappings, sources and targets for better performance, also identified and fixed the bottlenecks.

Expertise in creating Mapplets, Worklets used event wait, event raise, decision box, email and command tasks in Workflows.

Good understanding of RDBMS concepts and experience in writing queries, procedures using Oracle and Sybase Databases. 

Good knowledge on Unix commands

Good Understanding on Control-M scheduling tool

Involved in Unit Testing and System Integration Testing.

Ability to work efficiently, quickly learning & working with new technologies to fulfill customer needs.

PROFESSINAL EXPERIENCE:

Current Employer

Employer  :  Tata Consultancy Services

Designation:  IT Analyst

Date of Employment:  5-Mar-2012 to Till Date

Technical/Functional Competencies: Informatica Power Center 9.X, 10.1, IDQ Developer 9.X, 10.1, Oracle PL\SQL 11g, Sybase, UNIX Shell Scripting.

Assets  :

Self-motivated smart worker.

Strong analytical and reasoning skills.

Excellent problem solving skills and a Quick learner.

Ability to take ownership and can work as part of a team.

Good attitude towards learning and grasping new technologies

High Points:

Have Received CIO Award for the contributions made to Moodys Customer.

Have Received Star of the Month award for providing solution to the performance issues in ETL processing

PROJECT EXPERIENCE SUMMARY:

Company: Tata Consultancy Services

Project Name: Shell Finance MDM Implementation(IDQ & MDM Tech Lead)

Duration: Jan 2020 to till date

Client: Royal Dutch Shell, Netherlands

Environment: IDQ 10.4.1, Oracle 12g, SQL Developer, Rapid SQL, MDM Hub, MDM Provisioning Tool, Entity 360

Roles and Responsibilities:

Use data quality tool to profile the project source data, define or confirm the definition of metadata, cleanse and accurately check the project data, check for duplicate or redundant records.

Data Cleansing, Standardizing, Profiling using IDQ

Responsible for design, development, testing, deploying and documenting data quality procedures and their results

Had authoritative level understanding of the data management landscape and specialist understanding of core data quality design patterns and the associated challenges involved with data analysis, data modeling quality improvement and metadata management implementation.

Tracking and updating the progress of tasks

Ensuring that data quality issues are reviewed and that corrective and preventive actions are defined to resolve them.

Judge the significance of issues and raise accordingly to client.

Identifying key areas of improvement.

Company: Tata Consultancy Services

Project Name: Master Data Management System(MDM Developer)

Duration: March 2016 to till date

Client: Moody’s Investor Services, USA

MDMS (Master Data management systems) is to provide central management (creation, consolidation, validation, enrichment and correction) of data areas such as organizations and instruments that are classified as master data for Moody’s. Mastered data will be used by newly developed systems to provide ratings by the analysts this will reduce the number of systems used to create and manage Master and Reference Data. Improve the Quality of Data and Regulatory Integrity of Data And Advanced Organizational Agility. This Project enriches the Moodys Legacy data with the feeds from third party data providers Thomson Reuters(TR) and Standard & Poor(SNP) and create Master data in Informatica MDM. Which will be consumed by different downstream applications EDW,ORP,AHS to derive ratings and do research and publications