Madhumitha Mohan

• Worked in Pyspark and shell scripts to create single customer view report in Data Lake from various systems to help business in taking decisions and increase appointment booking from customers.
• Worked in hybrid environment where legacy and data warehouse applications and new big-data applications co-existed.
• Worked in Azure ADF pipeline which will load data from SIPD to azure sql database where source data is picked from ADLS which is replacement of Data Export Services, to load data in Hadoop Data Lake using in-house framework.

Implemented robust security measures to protect sensitive company information from unauthorized access or disclosure.

• Performed Data obfuscation process for more than 20 systems to obscure meaning of data as added layer of data protection in Non Production Environment and ensured data is GDPR compliant.
• Test data creation and extraction based on requirements for Performance test teams to perform their tests.
• Developed custom scripts to automate repetitive tasks, resulting in reduced manual labour, improved productivity and increase in revenue for team by supporting all requests coming in.

• Preparation of functional and technical Test Scenarios by analyzing scope and conversion of same into Test Cases.
• Gathering all requirements and in scope functionalities that needs to be covered as part of testing.
• Ingestion of data from different sources like Oracle, SQL, PostgreSQL, API into Hadoop data-lake using various frameworks like data-tap, File manager and Jobex.
• Validated result-sets created with HQL/Pyspark code against transformation/ Mapping provided by business to meet their functional requirements.
• Power BI Report testing which includes data reconciliation and evaluated visual dashboards based on business requirement.
• Successfully tested and shared data in JSON extracts to MDS through EMFT with minimal defect rate.
• Data Load from various sources (flat file, SAP CRM & ISU) into all underlying data objects in BW Functional and Regression Testing of Bex reports and Open hub reports in SAP BW Worked in data Migration of Dyno CRM database to Dynamics 365 database.
• Responsible for providing daily status to Client by sharing Daily Summary Report. Responsible for back track issues and finding cause for issues raised by users.
• Streamlined testing processes for increased efficiency and reduced overall test cycle time.
• Collaborated with developers to ensure timely resolution of identified issues, resulting in improved customer satisfaction.
• Executed test cases and documented defects, confirming resolution and mitigation of defects.
• Reduced defect leakage rate by conducting thorough root cause analyses and proactively addressing areas of concern in future release cycles