Summary
Overview
Work History
Education
Skills
Timeline
Generic
Lilly Mariya D

Lilly Mariya D

Pune

Summary

Dynamic professional seeking to excel in a collaborative and innovative work environment. Committed to delivering results by adhering to project schedules and contributing to organizational success. Passionate about personal growth through the achievement of high-quality standards and timely task completion. Eager to leverage skills and dedication to drive excellence and support team objectives.

Overview

14
14
years of professional experience
3
3
Languages

Work History

Sr. Associate

Northern Trust
02.2020 - Current

Title :QA Lead/Sr.Associate:

Year :2023-current

Team Name: TLM Recon

Responsibilities:

  • Leading a team of 5 (offshore) members and resolve issues and challenges faced by team during test planning and execution.
  • Review and approve test plans, test cases, and test results.
  • Manual Testing (Functional, Regression and System Testing) + CICD pipeline implementation.
  • Attending Requirement review meetings and communicating with business analysts to get more knowledge, also informing any gaps in requirements.
  • Identifying scenarios to cover more functionalities of application.
  • Writing, Reviewing and Executing Test Cases along with enhancing the scripts as per schedule and report periodically to Test Manager.
  • Mapping Test Cases and Test Scripts on Requirements Traceability Matrix.
  • Having direct interaction with Product owners..
  • Participated in regular project status meetings related to testing activities and sending Daily and Weekly Status Reports to Test Manager.
  • Actively participated in agile project ceremonies, including sprint planning, daily stand-ups, demos and retrospectives to support efficient project progress and alignment.
  • Understand the functionality of the entire product and takes ownership of the fixes allocated for testing
    Tracking QA metrics like defect densities and open defect counts.
  • Prepared Test Report based on the Test results
  • Estimate, prioritize, plan and coordinate testing activities.



Title :QA Engineer/Sr.Associate:

Year :2022-2023

Team Name: SQM Analytics

Responsibilities:

  • Develop, document, and execute test plans, test cases, and test scripts for Power BI dashboards
  • Validate data accuracy, functionality, performance, and visualizations in Power BI reports and dashboards.
  • Expertise in Data Mapping based on the given requirements.
  • Identify, report, and track defects and inconsistencies using ADO.
  • Conduct regression testing to ensure existing functionality remains unaffected after updates or enhancements.
  • Participate in requirement reviews and provide input from a testing perspective.
  • Maintain testing documentation and create reusable templates for future use.
  • Strong understanding of Power BI, including DAX, Power Query, and data modeling
  • Knowledge of relational databases, SQL, and data validation techniques.
  • Expertise in comparing the XML data validation using Soap UI/Postman tool along with database.
  • Hands-on experience with defect tracking tools (e. g., JIRA, Azure DevOps).
  • Good understanding of software development life cycle (SDLC) and agile methodologies.


Title :QA Engineer/Associate:

Year :2020-2022

Team Name: DWS [Data Warehouse Solution]

Responsibilities:

  • Developed automation scripts using Python to automate the data comparison between the source and target systems.
  • Responsible for performing data validation from source systems (CSV/Excel files) to Snowflake and from SQL DB2 to Snowflake.
  • Modified Unix shell scripts for automation tasks related to ETL testing, job executions, and data validation.
  • Responsible for communicating with the source system team about getting the file for data comparison.
  • Coordinating with the offshore team on testing needs and providing guidance throughout the entire testing life cycle.
  • Responsible for creating test cases, executing test cases, troubleshooting test scripts/code, reviewing and remediating test findings, communicating findings to Solution Architect and recommending actions to Solution Architect on how issues can be resolved as well as prevented in future development.
  • Responsible for explaining the root cause of issue to Product Owner, Business Analyst and to development team and solution on how to avoid in future development.
  • Experience in testing Netezza, Snowflake based Spark ingestion data pipelines to create data lake.
  • Responsible for developing complex queries with multiple join conditions for various source and Target system.
  • Validated acceptance criteria for features and stories.
  • Co-ordinate with Development Product Owners on production release communications. • Attending daily standup /Iteration retrospect/ weekly status meetings.
  • Engage with Information Governance to review sensitive data management standards and highlight areas of potential risk/opportunities and Promote awareness on how to protect sensitive data elements.



Sr. Business Analyst

BNP PARIBAS
02.2017 - 02.2020
  • Will ensure the Portfolio/Benchmark weights have been calculated without any issue as per the market standards.
  • Responsible for calculating the fund returns & performance returns with respect to the available NAV and also able to calculate the benchmark values associated with the underlying index present under it. And also able to calculate and prove the returns of the consolidated fund with respect to the underlying conso funds.
  • Will provide the Monthly/Quarterly/Annually and Since Inception Performance reports to the respective stake holders.
  • Consulted with functional unit management/stakeholders to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements.
  • Responsible for gathering/documenting the detailed business requirement by interacting with Clients, this is to share with IT developers to analyse feasibility of the requirements mentioned in Business Requirement Document (BRD) and to get the appropriate sign-off from the IT as well as from the business.
  • Coordinating with Project Manager to arrive at estimated cost for each CR/new functionality and prepare a project plan and Test plan based on the business requirements.
  • Providing continuous support to IT team during the implementation of new functionalities and make them to understand the requirement during the development.
  • Generating the Reports using the inbuild applications, able to read the logs generated in the backend of the application. From the generated logs, will analyse the issues and give the proper solutions to Ops team.

Sr. Test Analyst

Cognizant Technology Solutions (CTS)
10.2011 - 02.2017
  • Currently working from offshore and coordinating with onsite team through calls and allocating tasks to offshore team.
  • Understand & Review the functionality of the application.
  • Has played a crucial role in handling the project and involved in every stage of the testing lifecycle including Requirement analysis, Understanding document preparation, Defect Simulation, Clarification tracking.
  • Test preparation, Execution, Defect Tracking, status reporting, UAT support
  • Involved in SIT Test Planning, Test scenario and Test Case design with Traceability Matrix.
  • Test scenarios and test case design.
  • Creating reports in Decision Analyst.
  • Comparison of data from one base to another.
  • Involved in Smoke and Functional Testing and Regression Testing.
  • Day to Day tracking of activities/ attending daily calls with technology and development team
  • Defect tracking and reporting.
  • Expertise in creating SWIFT Messages based on the business requirement and booked the trades via SWIFT Message.

Education

Master's Degree - Computer Application

SRM Arts & Science College
01.2011

Bachelor's Degree - Computer Science

Holy Cross College
01.2008

Skills

  • Unix
  • Software Quality Testing
  • Snowflake
  • Soap UI
  • Python
  • Postman
  • Github
  • Java, Maven, TestNG
  • SQL Server
  • Oracle Sqldeveloper
  • Winscp
  • Data Analysis
  • Mainfram
  • Power BI
  • Azure DevOps
  • Agile Methodology
  • Business Analyst
  • Spark

Timeline

Sr. Associate

Northern Trust
02.2020 - Current

Sr. Business Analyst

BNP PARIBAS
02.2017 - 02.2020

Sr. Test Analyst

Cognizant Technology Solutions (CTS)
10.2011 - 02.2017

Bachelor's Degree - Computer Science

Holy Cross College

Master's Degree - Computer Application

SRM Arts & Science College
Lilly Mariya D