Biplab Chatterjee Email & Phone Number

• Overall 3+ Years of experience in Software Testing and Quality Assurance including Database Testing , Business Intelligence BI, SSIS Package , Data warehousing DWH-ETL testing ,REST & SOA Web service testing • Analyze ETL Requirements and Mapping sheet with BA • Map Source and target data In term of Duplicate , Count , Nullable ,String length ,data types ,constraint , length • Prepared and run sql queries to verify Dimensional and Fact tables. • Data flow validation from the staging area to the intermediate tables, Surrogate key check. • Good Knowledge Network Switch, Mediation, Siebel CRM, Telecom BSS, Payment, Data analytics [DWH+BI] System/Domain.• Knowledge of all Data warehousing /DWH concepts, Good understanding of OLAP , OLTP, Star schema, snowflake schema • Understand and analyze SRS to ensure it meets the Customer requirement, Responsible for Test scenario, Test Case Writing, Execution, Defect Tracking and Reporting. • Actively involved in Review of test Case, Performed Functional, Integration and Retesting, Regression, Sanity, and Database testing. • Strong knowledge over whole Software Test Life Cycle (STLC). • Work closely with other testers and developers with bug fixes and Defect Analysis Using defect management tool such as HP ALM. • Used Postman tool and JSON as protocol for REST- Web service testing.• Worked on Software quality assurance Process AGILE methodology, V Model. • Wrote SQL queries to access the data from the database tables to ensure data integrity. • Knowledge about UNIX Commands to validate server data. • Experience in Map Reduce programming model for analyzing the data stored in HDFS • A result-oriented team player and skillful in coordinating with development team and problem solving abilities. • Capable of working under time constraints in a target-oriented environment, Self-motivated, Pro- Active and Quick learner of new concepts and technologies.Defect Management tool : HP ALMAgile Project Management Tool : JIRA ETL Tool used : SSIS PackageBI Tools used : Zoho Analytics BI, TableauLanguages: SQL/PLSQL, Python

Listed skills include Matlab, Microprocessors, Microsoft Word, Electronics, and 5 others.

• 

  Software Test Engineer

  Ascend Avenue Solutions Pvt Ltd

  Apr 2021 - Present - Hyderabad, Telangana, India