Rohini Kharujkar

An IT Professional possessing around 3.8 years of experience in Manual, Data warehousing, ETL testing. Good knowledge on data warehouse concepts like star schema, snow-flake schema, fact table, dimension table. Hands-on experience on HP ALM. Having complete defect life cycle knowledge of data.

Experience on Oracle database. Hands on experience in writing SQL queries. Extensively used workflow manager, workflow monitor in Informatica Power center.

Experience in source data and Target data validation. Hands on experience on UNIX Environment.

Senior Software Engineer - TATA COMMUNICATIONS LTD - Bangalore, India

(2024-04)

Project: NAB TRADE. NAB Ltd is an international financial service organization with over 1,27,00,000 customers, 42,000 employees, and more than 1,700 stores and business banking centers. Most of the financial service businesses operate in Australia and New Zealand, with other businesses located in Asia, along with UK and US.

Our brands share a commitment to provide customers with quality products and services with fair fees and charges. The system generates banking reports with business logic and implements in business.

• Involved in understanding the business requirements.
• Involved in writing test scenarios and test cases.
• Preparation of MTP(Master test plan) and presentation in front of client.
• Update Sprints in Ralley.
• Prepared test data for testing.
• Involved in writing SQL queries for data validations.
• Uploading test cases in to Qtest.
• Running the jobs/workflow for ETL process in Databricks.
• Verifying the records count between source and target databases.
• Verifying the column mapping between source and target database.
• Log the defects in JIRA and send the status report.

Senior Software Engineer - Kaleyra - Bangalore, India

(2022-05 - 2024-03)

Project: Sainsbury's Supermarket DWH. The system has a database which stores information about sales, profits and contacts of customers. Using this existing database, the system should analyse the sales and profit and generates reports for sales and profits in month wise and year wise.

The resulting model gives us an idea about growth in profit, prediction about increase in sales. The data warehouse was further used to do Market Based analysis. Sainsbury's Supermarkets Ltd, which is one of the Organizations that sells various numbers of products.

Sainsbury's Supermarkets Ltd have various stores, which maintains Database has lots of historical data. This project was to create Sales Data Warehouse and generate reports using Business Objects.

• Understand the customer requirement.
• Running the job for ETL Process.
• Verify the ETL data in the Target database.
• Verify the data which is loaded in the Target database.
• Reporting daily testing status report.
• Develop, Review and Executed Test scripts and designed test data.
• Identify the test scripts from regression testing.
• Defect Analyzing and reporting in HP ALM.

Bachelor of Engineering - Visvesvaraya Technological University - Belgaum