Market Research · Canva · A/B Testing · Design · Product Road Mapping · Business Analysis · Product Discovery · User Research · Design Thinking · Product Lifecycle Management · Product Strategy · Product Management

I am working on a project at EY where I use the MS Azure Purview Tool

• Creation of test plans and test cases , preparing and managing test data which includes verifing mapping doc whether corresponding ETL information is provided or not.Source data type and target data type should be same length of data types in both source and target should be equal • all the expected data is loaded in target table and compared the record count between source and target whereas checked for rejected records as well.• Needed to check the numbers, date of all the data.• Validated the unique key, primary key, duplicate values as per the business requirements. As per the client requirements, needs to be ensure that no duplicates in combination of multiple columns within target only.Unnecessary columns should be deleted before loading into the staging area.• Identifying, isolating, and recording bugs. -> Calculation bugs, ECP related bugs, Input/output bugs, Race Condition bugs etc.• Used Informatica Data validation option which accelerate and automate ETL testing in both production environments and development and test.• Responsible for regression testing which validates the ETL produces the same output for a specific input before and after the change.• Used to work for data integrity which is the major tenet of this tool and comprehensive ETL testing coverage means lower business risk. • Communicating with developers, product owners, and business partners on issues and solutions

(1) Optimizing standard operating procedure workflow and processes- understand the operations of the technical division and optimize the technology department. This workflow will help to simplify the process and visualize the proper structure of the workflow. In any business, the operation is very crucial and all the departments are interconnected among themselves. By preparing SOP, the Operation team helps the technological division of the company and helps to become a more effective company among all NBFCs as well.(2) Analysis of the Task Management System and preparing the document on the same- Multiple departments are involved through TMS. If FPO wants some change in their proposal it will have happened through the Relationship Manager (RM) of the company. So, Audit team, Finance Team, Operation team, Business process team, Human Resource all the department are involved themselves for transacting any loan for the client. If the Business process team is responsible for any work then that task will be visible in TMS for the Business process team and that same task must be completed in the stipulated time which is also mentioned in TMS. Turn-Around-Time (TAT) is helped to increase accountability and helps to understand the various department operations and activities as well.(3) Bridging sales and challenges with technology tools- helps to understand the Sales activity and sales Cycle of Samunnati. Relation Managers are Facing a lot of challenges during this time. A lot of issues are visible in front of the eyes. Those issues must be resolved because these affect the work process of the Samunnati. A Mobile Application (Samunnati Agro Finance) will be provided to the FPO who wants to do the business with the Samunnati. I provided a Mobile Application structure for the FPO which will be used for FPOs before having the transaction.

• Worked as Quality Assurance in a Health Care Project and worked on the enterprise data warehouse model which is a top-down approach• Validated the required data /data sources by reviewing metadata/data dictionary and test data preparation.• Worked for Data profiling which include source to target mapping, ETL Testing• Ensured data quality and performance acceptance criteria by validating ETL/Data warehouse architechture.• Ensured that all expected data is loaded by means of each ETL procedure.• Ensured that all data to be transformed is completed correctly according to business rules and design specifications.• Ensured that the ETL process correctly rejects incorrect data, substitutes default values, modifies, handles invalid data.• Ensured that data loads and SQL queries perform within expected periods and that the technical architecture is scalable.• Confirmed that the ETL process functions well with other upstream and downstream processes.• Ensured existing functionality remains intact each time a new release of ETL code and data is completed. • Employed working knowledge of Teradata and SQL programming languages. • Designed databases facilitating application development allowing creation, modification, and implementation of queries. • Worked in the Agile team, where I used to work in FitNesse to prepare test suits that will test the methods in the code. In Fitnesse, I created tests and suite • Using Jenkins, was started the build to run the test then reviewed result using test reports• In Jenkins, at test result, the information on what machines tests ran, their run time and the number of logged errors and warnings.