Sri Krishna M

Client : Ernst & Young
Project : Fincrime 3.0
Technology Used: Azure Data Factory, azure data lake storage, Azure Data Bricks, ADO, MySQL

Fincrime 3.0 is a software tool that is designed to help financial institutions detect, prevent, and investigate financial crimes such as money laundering, fraud, and terrorist financing. This product use advanced analytics and machine learning to analyze vast amounts of data and identify patterns and anomalies that indicate potential criminal activity.

The product can analyze customer data, transaction history, and other relevant information to identify suspicious activity and generate alerts for further investigation.

Responsibilities:

• Developed test plans and strategies for products.
• Conducted functional, Load and regression tests.
• Analyzed system requirements to create test cases.
• Documented defects found during testing process.
• Participated in bug triage meetings with developers and project managers.
• Ensured the quality of software applications before release to customers.
• Monitored application performance after deployment in production environment.
• Created traceability matrices between user stories and test cases.
• Provided technical guidance to junior team members on testing processes and procedures.
• Maintained up-to-date knowledge of new technologies related to software testing.
• Interacted with stakeholders to understand their needs and expectations from product releases.
• Reviewed user documentation for accuracy and usability prior to product launch.
• Collaborated with development teams on fixing bugs and improving existing features.
• Verified that all components meet design specifications and standards.
• Identified potential risks associated with software development projects.
• Led end-to-end ETL testing efforts for complex data integration projects, ensuring accuracy, reliability, and data consistency.
• Developed and executed comprehensive test plans, including test case creation, execution, and reporting, resulting in improved software quality
• Collaborated closely with ETL developers, data engineers, and business analysts to understand data transformation rules and ensure data integrity.
• Designed and executed complex SQL queries for data validation, identifying discrepancies and anomalies within ETL processes.

Responsibilities:

• Analyzed data quality issues by using query optimization techniques.
• Played a key role in validating and ensuring the accuracy of ETL processes within large-scale data warehousing projects
• Collaborated with business stakeholders to define testing requirements, scenarios, and success criteria
• Participated actively in sprint planning, daily stand-up meetings, and retrospectives as part of Agile development methodology
• Worked closely with QA and development teams to troubleshoot and resolve defects, contributing to on-time project deliveries.
• Ability to develop using SQL developer tools to write complex queries using Joins, Sub query, Group functions, Analytical functions, Set operators, Pseudo Columns, DDL/DML/TCL & Constraints.
• Worked into various ETL schema architecture like Fact tables, dimension tables, star schema, snowflake schemas & Slowly Changing Dimensions.
• Data transformation and end to end data validation for ETL and BI systems.
• Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse

• Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
• Identified and tracked defects with ADO and supported developers in resolving problems by completing additional tests
• Tested software applications and systems to identify enhancement opportunities.
• Communicated discrepancies identified in testing to impacted areas and monitored resolution.
• Collaborated with developers to stay current on product features and intended functionality.
• Wrote and optimized test cases to maximize success of manual software testing with consistent, thorough approaches.
• Analyzing the business requirements for the Assigned Module to design the test cases as per test plan and user specs.
• Tested software applications and systems to identify enhancement opportunities.
• Performed Regression, Smoke and Sanity tests on modules and full software implementations.

• Performed analysis and maintaining Business Impact Assessment, Risk Assessment and developing Business Continuity Strategies and BCP documentations
• Managing business Continuity Testing life cycle including strategy testing, call tree testing and scenario exercise
• To conduct BC Test and Drills/BC Strategies & Recovery Plans
• Coordinate execution of plans in the event of a crisis
• Work closely with the Technology and Administration departments to ensure proactive measures are deployed for better resilience.