Chinnu Sudha Mohanan

Domain: Insurance

Project : Transformation for UK

Description: Data testing using Python pandas

Responsibilities

• Involved in Requirement Refinement, Test script creation, Test run and Test report generation.

• Performing Data extraction and flow analysis using of bulk file using python pandas

• Automated all the test scripts using python pandas

• Prepared daily confluence project updates and Lesson learnt report

Project : Data Migration

Description :ETL of data transformation from legacy system to new application system

Responsibilities

• Prepared QA scope analysis and QA Strategy and presented for approval with Client

• Prepared proposal for the functional testing regression suite to implement automation for functional testing

• Involved in Test scenario preparation and query tracking, Test script preparation and execution

• Automated using Flask python framework ,python pandas and matplotlib to visualize the discrepancy in source data.

Domain: Banking

Project : US based Leading Global Bank

Description: ETL testing of data transformation through various systems

Responsibilities

•Active representative for Requirement Analysis and Scope planning t

•Preparing test scenarios , test cases and SQL query scripts

•Analysing and monitoring the team SQL Query test scripts

•Exposure to Oracle Domain

•Job Analysis using Autosys Tool

Domain : Health

Project : US based heath care chain

Description: ETL and API testing of data transformation from various upstream to downstream systems.

Responsibilities

•Involved in Requirement Analysis, Test case creation, Test Execution and Test report

generation.

•Performed System Integration Testing, End to End Testing, User Acceptance Testing and

Regression testing.

•Exposure to Teradata, Oracle and Exadata domains.

•Job analysis using BCM Control-M and shell scripting.

•Code debug and code analysis in Oracle PL/SQL and Oracle/Teradata to setup test data.

•Handled web service testing using POSTMAN,KAFKA to ensure the data flow from the downstream DB system to upstream Snowflake DB System.

•PYDACT an Infosys owned tool used for JSON data Comparison.

Domain : Retail

Project : Leading Retailer in US

Description: Snowflake Migration Program. Data migration testing from Netezza on premise to snowflake cloud for all the business process and customer data hosted in Netezza,flatfiles etc.

Responsibilities

•Involved in estimation, sprint planning, scheduling, design review and Testing of the migrated data.

•Testing of the Cognos reports pointed to Snowflake as part of migration using TOSCA

Automation tool.

•Ensuring that team is completing the deliverables on time, co-ordination between offshore and onsite.

•Involved in the Defect triage, testing sign-off, retrospective meeting and all agile related meetings

Domain : Forensics

Description: The project involved in a forensics department to analyse various encrypted files.

Responsibilities

• Worked as an software developer to develop a prototype to decrypt encoded files

• Provided various cyber forensics tool training and demo to Cops of State Government.