Aanchal

Project I

• Defined and organized product features for solar plant projects by collaborating closely with stakeholders, including engineers, energy experts, and environmental specialists.
• Created detailed epics and user stories in collaboration with the development team to facilitate the implementation of identified features, ensuring alignment with project goals.
• Collaborated with the development team to establish clear and measurable acceptance criteria for epics and user stories, enabling effective quality assurance and validation.
• Verified the implementation of epics and stories to ensure they met the defined acceptance criteria, actively participating in testing and validation processes.
• Organized and facilitated the prioritization and planning of epics into Program Increments (PIs) and sprints, working in coordination with product owners, project managers, and development teams.
• Managed change requests and communicated modifications to requirements, ensuring alignment with project objectives while minimizing disruption.
• Maintained comprehensive and up-to-date documentation of requirements, epics, user stories, and acceptance criteria for reference and knowledge sharing.

Project II

• Orchestrated a comprehensive end-to-end test management framework for a Smart Connect Mobile Application compatible with iOS and Android devices. The application offered real-time monitoring and control functionalities for smart pumps, including rigorous testing of an intuitive web interface accessible through standard web browsers, facilitating remote access and control of pumps.
• Ensured the reliability, stability, and usability of the Smart Connect solution through meticulous testing and quality assurance processes.
• Collaborated closely with cross-functional teams to identify and resolve defects, playing a key role in ensuring the timely delivery of high-quality software.
• Developed and executed thorough test plans and test cases, encompassing diverse scenarios and use cases to validate the application's functionality.
• Actively participated in Agile-Scrum methodologies, contributing to sprint planning, daily stand-ups, and sprint reviews, fostering effective collaboration and timely delivery of features.
• Diligently recognized defects, diligently tracked and reported them in the Bug Tracking System, effectively pinpointing and validating the root cause of issues before completing retests.

• Data Validation: Perform rigorous validation of financial data within the SMD project's databases, ensuring accuracy, completeness, and data integrity.
• UI Testing: Conduct comprehensive testing of the user interface (UI) for SMD applications, ensuring usability, functionality, and adherence to design standards.
• SQL Query Development: Create complex SQL queries to extract, manipulate, and validate data from databases, identifying discrepancies and anomalies.
• Data Migration Testing: Collaborate with the data migration team to validate successful data migration, ensuring a seamless transition from legacy systems to new databases while maintaining data integrity.
• Schema and Database Design Testing: Verify that database schemas and designs align with project requirements and industry best practices, and support efficient data retrieval and storage.
• Performance Testing: Conduct performance testing for both databases and UI elements to optimize query performance and UI responsiveness. Identify and resolve bottlenecks.
• Defect Reporting: Document and report both database and UI defects and issues, track their status, and collaborate with development teams to resolve them.
• Test Documentation: Create and maintain test plans, test cases, and test scripts for both database and UI testing, maintaining detailed records of testing activities and results.

• Tested the database layer including relational databases (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB) that store and manage critical data, including user profiles, transaction records, payment history, and repayment schedules.
• Frontend Testing: Tested the user interface of the Lazypay PayU system, including web and mobile applications that handle user interactions, displaying payment options, repayment details, and transaction history.
• API testing: Verified the functionality and correctness of payment-related API endpoints, including transaction initiation, validation, and completion and validated data exchange between different components of the payment system through APIs.
• Integration Testing: Conduct integration testing to ensure seamless communication between the payment system's components, including merchant interfaces, banks, and payment gateways.
• Data Validation and reconciliation: Tested the process of comparing and verifying data between Salesforce and PayU's payment processing system to ensure data consistency and accuracy by idetifying the relevant data sources within Salesforce and PayU's payment system that need to be reconciled.

• Collaborate with business analysts and stakeholders to understand and analyze ETL requirements, data sources, transformations, and quality rules specific to the Anacredit system.
• Perform rigorous data validation and verification checks to ensure the accuracy, completeness, and integrity of data throughout the ETL processes.
• Validate source-to-target mappings and transformations, ensuring the correct extraction, transformation, and loading of data according to defined business rules and mappings.
• Test and validate error handling and exception scenarios within the ETL processes, ensuring appropriate logging, notification, and resolution mechanisms.
• Perform thorough data reconciliation between source systems, intermediate stages, and the Anacredit database to ensure accurate and consistent data transformation and loading without any discrepancies or data loss.
• Prepare and maintain comprehensive documentation, including ETL test plans, test cases, scripts, and reports, documenting test procedures, findings, and recommendations for future reference.
• Collaborate closely with ETL developers, data analysts, business analysts, and stakeholders to ensure a shared understanding of requirements, data mappings, and ETL processes, and effectively communicate test progress, issues, and recommendations to stakeholders and project teams.
• Monitor system performance on a regular basis to ensure optimal ETL processing and data quality.

• Ensured the quality and performance of the TNPM software specifically for wireless network environments.
• Worked with COTS product PMS for vendors such as Huawei, Ericsson, Alcatel Lucent, and Nokia.
• Conducted various testing activities including Smoke Testing, Functional Testing, System Testing, Integration Testing, and optimization for 3G, 4G LTE, and GSM/GPRS/UMTS/LTE networks.
• Monitored key performance indicators (KPIs) such as throughput (Upload and download speed), call drop rate, and handover success rate as per the RF performance team's requirements.
• Collaborated with Business Analysts, Developers, and Business stakeholders to provide feedback and advice on test activities and deliverables, ensuring adherence to quality requirements.
• Performed Data Validation Testing to ensure the accuracy of vendor data to the network and raw tables.
• Conducted GUI testing of Cognos Reports and Dashboards, including data validation on the reports.
• Developed Test Conditions and Test Scripts for Regression testing of the product.