Gomathi Sundaram

• Transunion Project is responsible for acquiring and loading data in database to derive the report for Colombia credit bureau. There are different input files provided from different client which are converted into standard format (TU Format) and loaded to the Oracle database.
• Developed Test Plan for the project based on SRS.
• Created Test data using UNIX.
• Tested the Ab Initio ETL mappings and other ETL process to make sure the data is getting loaded correctly.
• Validated data transformations and perform End-to-End data validation for ETL & BI systems in various Sprints.
• Entered problems and issues into an online Bug tracking tool JIRA

The purpose of this Project is to have Integration Hub to assist with policy lookup for Guidewire ClaimCenter (GWCC) and provide merge and code value translation for certain legacy extracts which form part of Project Michelangelo Phase 2.

• Led 15-member team as Module Lead - POC for Unity legacy system as part of Project Michelangelo Phase 2.
• Conducted validation of GWCC/SOAP UI data with respective legacy system Copy DB/Policy Registry in SQL Server Database for Policy Search, Risk Selection and Policy retrieve.
• Tested and developed mappings for data extraction, cleansing, transformation and loading using Informatica.
• Supported OM (Output Management)team in creating PDF documents from Thunderhead and performing document validation.
• Validated both initial and incremental load of Policy data.

Objective of the IRIP Project is to develop a custom application using Data Integrator (DI) and Datarush to migrate a custom legacy application built on SAS.

• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Understand existing SAS application and find out the gaps in requirement documents.
• Verified KNIME workflows.
• Validated DI maps to read XML files with lookup tables and Flat files to load into SQL server database tables.

The scope of the WHIO project is to maintain the healthcare insurance data. According to the business rules the SSIS workflows has been created for each client and the data will be maintained in SQL Server 2008 R2. Reporting portal is created to improve the quality of health care in Wisconsin by analyzing the result.

• Executed and Verified SSIS workflows by uploading raw files.
• Written complex SQL queries for querying data against different databases for data verification process based on mapping document.
• Analyzed various reports generated by SSRS.
• Worked on HP ALM for defect management.

A BI and .Net solution was created for Alcatel-Lucent to cater to their service assurance requirement. The raw data from Excel was loaded into SQL Server 2008 R2 database using SSIS. On top of this warehouse, reports and dashboards were developed using SSRS. Also, a front-end was developed using .Net for the customer to perform any manual reconciliation-Windows application allows administrator to view the detail and aggregation records which are not reconciled.

• Executed and Verified SSIS Packages for uploading data from Excel to SQL Server 2008 R2 database.
• Validated Integrity of data in SSRS with SQL Server 2008 R2 database in line with requirements.
• Proactively analyzed Data/Functional/Logical issues in SSIS, SSRS, dotNET module (Manual reconciliation window) and helps team members in problem resolution.
• Operated under Agile and Scrum frameworks to complete releases and well-organized sprints

Microsoft Dynamics CRM is a business software solution that allows organizations of all sizes to track, manage, and report on customer or client interactions.

• Worked on Web Application testing – Functional.
• Tested Microsoft Dynamics CRM 5.0 both on-premise and online versions for 40 languages.
• Used Orange Pride, Product Studio and Bugzilla for testing and Defect Management.

• Responsible for Data Analysis, documenting process and procedure for different Clients. Completed documents and work requests according to company standards.

• Responsible for Accounts Receivable for Health Care Claims that were unpaid by insurance companies or patients.