Manisha Shendge

Projects Undertaken   Project 1: BizApps_CTDWH             • Database: SQL Server 2019 • Duration: September 2022 to June 2023 • Role: QA (ETL Tester and Database Tester) • Testing tool: SSIS with Visual Studio 2019   Description     The project aimed to establish a comprehensive data warehouse, integrating information from various sources including PGS, CentriCT, MYNextHire, and MYCT into a unified repository. It enhanced transaction processing system efficacy and protected customer-facing databases from extensive analysis queries.   Database used: Source database, Metadata, Landing, Archive, EDW.             Responsibilities       • Executed ETL testing procedures ensuring data accuracy and integrity. • Analyzed requirements and implemented changes. • Tested packages using SSIS with Visual Studio tool. • Actively participated in daily scrum meetings. • Improved database efficiency through SQL Server 2019 stored procedures and complex queries. • Prepared test scenarios and cases, involved in test planning using Jira Xray management tool. • Conducted regression and performance testing. • Logged defects in JIRA and communicated test results to stakeholders. • Prepared test documents, QA sign off documents. • Conducted RAB process for Production    Project 2: Project Governance System   • Front End: HTML, CSS, JQuery • Technologies: C#, MVC 5, Web API 2, Entity Framework, JavaScript • Database: SQL Server 2019 • Duration: November 2021 to September 2022 • Role: QA (Manual Tester and Database Tester)   Description     The project aimed to provide HRIS solutions, managing employee-related data and satisfaction reports across various modules like PGS, QMS, CMS, and IMS.             Responsibilities       • Understood requirements and analyzed changes. • Actively participated in daily scrum meetings. • Improved database efficiency through SQL Server 2019 stored procedures and complex queries. • Prepared test scenarios, cases, and conducted testing. • Identified and reported software defects in JIRA. • Conducted user acceptance testing (UAT) and usability testing. • Collaborated with developers on API specifications. • Prepared test documents. • Conducted RAB process for Production. Project 3: CTEngage Modern Workspace Project                                • Front End: HTML, CSS, JQuery • Technologies: C#, MVC 5, Web API, Entity Framework, JavaScript • Database: SQL Server 2019 • Duration: September 2021 to November 2021 • Role: QA (Manual Tester and Database Tester)                                         Description:     The project facilitated a FPR dashboard capturing project-related information and providing a Knowledge Centre for various project-related functionalities.             Responsibilities       • Understanding the requirement and analysing the changes. • Preparing Test Scenarios and Test Cases. • Keeping track of the requirements for the Test Environment. • Collaborated with development team to ensure quality deliverables.  • Logging defects in JIRA with proper steps. • Preparing Test documents, QA sign off document. • Give demo to stakeholders. • Testing for Power BI reports.