As per the TJX policies need to delete the customer details in TJX account.I have created test data and applied the transformation according to TJX rules and purge the details.

Commission sales exchange:

the overview of the project is to describe the sales amount of the customer as per the Optus rules and regulations.

• Understanding the client requirements
• Designing the High level test scenarios for given test cases
• Create test data for all three source(MXI,TRAX& WZRD)
• Validated data in Target database according to business rules
• Prepared SQL queries and executed to validate the ETL processed data in target database
• Run the SQL queries in Oracle and Sql Server
• Involved in functional study of the application
• Interactions with BA &Dev teams to resolve the issues
• Reporting daily testing status report
  • Defect Analyzing and Reporting in ALM

The TJX Companies, Inc. is the leading off-price apparel and home fashions retailer in the U.S. and UK and Europe countries as well. As per the client requirement we need to purge and Anonymize the customer data, which is not usable and which is not- Transactional data based on the time period of the customer. We are performing Historical purge and Increamental purge the customer details information in TJX Database. To Create the test data according to the business and validate the business data which is eligible to purge and anonymize the customer information.

Gilead Sciences is an American biopharmaceutical company that discovers, develops and commercializes drugs. the company concentrated primarily on antiviral drugs used in the treatment of HIV, hepatitis B, hepatitis C, and influenza, including Harvoni and Sovaldi., also provides other insurance and financial services products & for small and medium-sized businesses.The project main aim is to create the data warehouse data comes from various streams.

Genworth finance is leading insurance holding company in US. It services the life and life style protection, retirement income, Claims , investment and mortgage insurance. The project main aim is to create the data warehouse data comes from various streams for Genworth finance administration purpose. The objective of the project is to design and maintenance of target systems for query and analysis using the Informatica, an ETL Tool .Data is extracted from Oracle and Flat File data sources, Transformed and Loaded into Target.

EBridgeAP is a middleware application which establishes the connectivity with other interfaces and eBridgeAP is the payment gateway which manages Payment files from Asia Pacific and Middle East region.