Uday

Data scientist QA

Clients : Superloop Telecom –Australia, Axtel Global Network –Mexico, Flagship Payment -USA

Objective

To employee myself in a progressive organization that provides scope to update my practical knowledge and skills in accordance with the latest trends and be part of the team that dynamically works towards growth of the organization. Looking for a software test engineer Job where I can utilize my SQL skills to validate Bigdata / Data warehousing –DWH/ETL components/System .To achieve a challenging position in Software Testing in a result-oriented company, where acquired skills and education will be utilized towards continuous growth and advancement.

Technical Qualification Headlines

Manual Testing + Database Testing + ETL/DWH Testing +CSV Dataset Automation Using Python Script + Business Intelligence +REST WS + EDI File Processing

Major Tools and Technologies Used :

• ETL Tool used : SSIS Package
• Defect Management tool : HPALM , MTM
• Agile Project Management Tool : JIRA
• Process : Agile + Waterfall Model + V Model
• BI Tools used : Power BI
• Experience in Dataset Automation using Python script
• Strong work experience area - Big Data Testing |Database testing | ETL /BI Testing | Unix | API Webservice|EDI file processing |

Domain/System/ module Worked/Working with :

Siebel CRM *Telecom BSS/OSS * Global Payment Gateway * Telecom OSS –Inventory Management (Provisioning & Activation ) * Rating Charging * Mediation *

Core Area Involvement : Agility | Database Testing | File Processing | ETL Testing | Web service testing |Role based access security system | Data volume Testing ( Shortest path Detection –Performance Testing |System Integration – Functional | MDDA –Multi dimension data analytics |

Process worked With : | Agile | V model | Waterfall

ETL Tool used : SSIS Package | Defect Management tool : HPALM , MTM |Process : Agile + Waterfall Model + Devops , Configuration Tool : GIT | BI Tools used : Power BI

Technology Involvement Area

Manual Testing * *EDI File Process * Business Intelligence- * Power BI*DWH/ETL-Data warehousing* SSIS Package *Database Testing * SOA Webservice Testing * Unix * SQL * Soap UI * HPALM * MTM * Watarfall model * Agile * JIRA * SaaS Cloud * RESTful Web service * JSON *Data Volume Peformance test * Security Test *

Experience Summary

• Overall 3.2 Years of experience in Software Testing and Quality Assurance including Database Testing ,SAS DataManagement , Datawarehousing –DWH-ETL tesing,REST Webservice testing
• Strong experience with Mediation ,Siebel CRM ,Telecom BSS/OSS ,Payment, Data analytics [DWH+BI]System/Domain.
• Analyze ETL Requirements and Mapping sheet with BA
• Map Source and target data In term of Duplicate , Count , Nullable ,String length ,datatypes ,constraint , length
• Involved in the analysis of source systems, gathering business requirements and identification of business rules.
• Prepared and run sql queries to verify Dimensional and Fact tables, Verifying the data in target database by ETL process, Transformation logic is applied before loading the data.
• Data flow validation from the staging area to the intermediate tables,Surrogate key check.
• Knowledge of all Data warehousing /DWH concepts, Good understanding of OLAP , OLTP, Star schema, snowflake schema.
• Understand and analyse SRS to ensure it meets the Customer requirement, Responsible for Test Case Writing, Execution, Bug Tracking and Reporting.
• Actively involved in Review of test Case,PerformedFunctional, Integration and Retesting, Regression, Sanity, and Database testing.
• Enough exposure to all stages of SDLC ,Mapped the business requirements with test case by preparing Traceability matrix. 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 & MTM
• Used Postman tool and Json as protocol for REST- Web service testing ,Worked on Software quality assurance Process AGILEmethodology , V Model .
• Wrote SQL