• Mastering DELL & EMC customers and building 360° customer view
• Deploy Customer data Governance (globally & regionally)
• Identity management , Matching methodology & results to manage local files delivery
• Additional & new data feeds integration & governance
• Linking online digital behavior sources into accounts universe for Dell & EMC
• Enable linkage between online info above and offline sales & marketing history from Dell & EMC
• Identify & classify accounts by customer journey stages (Silent, explore, Discover, Educate, Compare, Buy, Grow) to be customer centric

• Understanding the client requirements.
• Verifying the column mapping between source and target databases.
• Running the Spark jobs for ETL process
• Verifying the data which is loaded into target database.
• Executed test cases through TFS MTM
• Run the Informatica Workflows for ETL Process.
• Validated data in Target database according to business rules.
• Prepared Hive queries and executed to validate the ETL processed data in target database.
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status report.
• Defect Analyzing and Reporting in MTM

Global Client Intelligence (GCI) is a product which will be used by the Deloitte Audit and Tax clients around the globe. The data will be gathered by Tax and Audit Channel Studios team for all the member firms which deals with Engagement and Opportunities. The financial data of different countries will be validated against its respective country currency .The currency value pulled dynamically through Synaptica calls.

Mastering DELL & EMC customers and building 360° customer view Deploy Customer data Governance (globally & regionally) Identity management , Matching methodology & results to manage local files delivery Additional & new data feeds integration & governance Linking online digital behavior sources into accounts universe for Dell & EMC Enable linkage between online info above and offline sales & marketing history from Dell & EMC Identify & classify accounts by customer journey stages (Silent, explore, Discover, Educate, Compare, Buy, Grow) to be customer centric

• Understanding the client requirements.
• Verifying the column mapping between source and target databases.
• Running the jobs ETL process in Informatica BDE
• Verifying the data which is loaded into target database.
• Executed test cases through TFS MTM
• Run the Informatica Workflows for ETL Process.
• Validated data in Target database according to business rules.
• Prepared Hive queries and executed to validate the ETL processed data in target database.
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status report.

Defect Analyzing and Reporting in MTM

Dell International Services is a US based multinational computer technology. Dell develops, sells, repairs, and supports computers and related products and services. Dell wants to enable Dell Kunshan Trading Company to perform trading business and Intercompany Transaction for export shipments to EMEA, DAO and APJ. This will allow Dell continue to receive the incentive from Kunshan Government for notebook which manufactured in Kunshan and export through Kunshan. This involves regression testing for 8 reports in order to ensure the Kunshan data flow from all upstream applications to Dell Data Warehouse.

• Understanding of BSD and TSD
• Analysis of Business transformation logic using Bteq Scripts
• Preparation of Test Plan & Test Approach
• Preparation of Test cases with SQL Queries
• Preparation of Test Data based on the requirement
• Hands on in preparation of RTM, Test Closure Document, uploading TC into RQM
• Performed validations like Count, load log Key, duplicate, RI, Audit Balance, Impacted column, Non-Impacted column verification & project specific Business validations & regression testing for History & Incremental Fixes
• Identification of Defects and notified to Dev Team through Clear Quest
• Participation in Defect Triage call & Client status call

WellPoint Information Management (WLP IM):- WellPoint Information Management (WLP IM) is a centralized team to fix all the data related issues. EDWard (Enterprise Data Warehouse And Research Depot) should be operational and other legacy DWH should be decommissioned. 20 Subject Area, 27 heterogeneous source systems & legacy DWH pool data into EDWard. History and Incremental fix is part of each release. Data follows from Source Systems (SS) to Landing Zone (LZ) to Confirmed Stating Area (CSA) to EDWard (EDW). Team performs Load Log Key Validation, Count Validation, Duplicate Check, Referential Integrity, Audit Balancing &Data Profiling for each Project.