Suryanarayanareddy M

Automation Engineer @Nsight, Inc

Design and Document Test plan, Test Scenarios, Test cases from the Requirements • Working as Sr Data QA for highly visible end to end products with Kafka Streaming data and migration from SSIS to Google cloud• Validated data ingestion and performed data analysis/ETL validations from storage to downstream layers• Designed and Engineered QA Automation framework for regression testing using python libraries and SQL• Planned and working on automatic deployments using CI/CD pipelines and performed integration/functional/regression/System testing across systems for agile and waterfall methodologies for front end/ web / standalone applications and databases• Created stored procedures and user defined functions to support defect analysis. • Expert in writing complex SQL queries and data cleansing and analysis and validated etl flows as per business logics provided.• Validated tableau/power BI and excel reports as per business requirements.• Validated data Ingestion from AWS S3 buckets to Hadoop and validated aggregation within Hadoop using Hive and data export from Hive to Oracle• Created a script to perform data scraping and data wrangling to validate front end data with backend• Coordinated with multiple teams /business/development/UAT and completing tasks in time leading team, and presenting testing progress using Confluence, JIRA.• Certified ISTQB & Six sigma (Internal)• Created tools, and automated API data collection and processing, automated mundane tasks, Validated JSON/XML using python and performed analysis using SQL/Pandas