Jun 2024 – Present · 2 yrs

• Validated the design and development of a cloud-based data lake using GCP services, facilitating a centralized data storage solution for cross-departmental analysis. Authored complex SQL queries and transformation jobs in BigQuery that enabled quicker turnaround for data insights, becoming a cornerstone for strategic planning. Created and debugged complex ETL processes using PL-SQL queries, functions, stored procedures and SQL Server Agent jobs. Conducted ad-hoc testing, created new testing processes, actively participated in weekly team meetings. Identified defects, developed solutions, planned tests, managed and updated test case spreadsheets Wrote ad-hoc stored procedures to generate various reports for the Benefits Coordinator. Achieved Employee of the Month recognition twice for outstanding performance

Jan 2021 – Dec 2024 · 3 yrs 11 mos

• Planning of test releases based on Agile Testing Methodology.
• Created Dashboard in JIRA to map all requirements, test cases and defects.
• Have provided automated solution for comparing risk figures for different assets classes
• Have Built ETL Test Automation suite in python/clover to process E2E testing.
• Well versed with jupyter notebook, pycharm, Anaconda and python libraries
• Have worked on data frames, lists, series, dictionaries using pandas and numpy.
• Have performed Extensive ETL testing using CloverDX Graph.
• Have written script to validate API rest services response in python using request library
• Have Read, Transform and Written data from/to different source format like .csv, .xlsx,
• .json, .txt, database and .parquet files.
• Have processed BigData into chunks to convert into structural format and then created
• meaningful insights.
• Have used GITHUB to control the versioning of code.
• Have worked on Equities, derivative and Equity derivative data testing.
• Have done reconciliation of different data from different source to extract reports.
• Have worked on ActiveViam which is object-based Online Analytical Processing tool.
• Have performed BI Testing on QlikView, Qlik Sense and Pandora(In house BI Tools).

Jan 2019 – Jan 2021 · 2 yrs

• QA Analyst with 4+ Years experienced Techno-Functional Tester within Agile, V Model Dev Environment. Create/review/modify test planning documents. Also a Pega system tester with proven ability to lead test team & deliver quality & productive testing solutions.
• Proficient in Below Points
• Provided the testing effort estimation for both manual and automation testing.
• Analyzed system specification, business requirements and create the detailed test plan.
• Interacted with product experts for understanding the application and created test cases
• Developed traceability matrix to ensure that all the requirment are been tested mapped to requirement and has no defect.
• Creating test case templates to facilitate mapping of manual test cases to automation test scripts.
• Incorporate the test case document according to client review comments.
• Participated in reviews and defect reports meeting daily.
• Coordinate with team members and allocated tasks to team.
• Developed detailed Test PlanSheet for team and stakeholders for every release.
• Prepared Test completion/Signoff certificate post every release.
• Provided support to Central release team on Go-Live.
• Reviewed the test cases, defect reports and automation test scripts developed by others team members.
• Have worked as Pega application tester for banking and complex application.
• Performed debugging in Pega using Clipboard and Tracer, Managed ruleset in Pega.
• Well versed with PageList, PageGroup, pyWorkPage and Threads in Pega.
• Worked on datatable, db mapping and MasterAgent queue of Pega Application.