Seraj Khan
127 Tramway Road ,Enderley, Hamilton New Zealand
Summary
- Total having 5+year of work experience.
- 4+ years of work experience in software testing as ETL, BI, Database and Functional Manual tester using SSIS, SSMS, and Oracle.
- Well versed with ETL SSIS, Tableau, Telecom BSS/OSS & Agile concepts
- Expertise in ETL, BI, Database, Functional and API Testing.
- Well versed with knowledge in tools like Oracle, Tableau, SSMS, SSIS, and JIRA.
- I am highly motivated, results-driven individual with a proven track record of exceeding sales target and client satisfaction in the small to medium enterprise segment of business dealing with key decision makers.
- Logical and analytical thinker with a strong problem-solving approach to work.
- Strong project management skill, a high attention to detail and focused a quality standard of customer service.
- Good knowledge of telecommunications product and service.
- Expertise in writing/ reviewing test plans, test scenarios, test cases and test summary with expertise in performing Functional, System, Retesting and Regression Testing.
- Familiar with all phases of SDLC and STLC and AGILE Testing.
- Expertise in different level of testing (Manual Testing), Integration, system, end-to-end testing, Sanity and UAT.
- Good knowledge on fact and dimension tables. Prepared and run SQL queries to verify Dimension and Fact table.
- Strong Knowledge on SQL Queries.
- Experience in working on SCD1 and SCD2 dimension. Strong Knowledge on OLTP and OLAP.
- Very good experience in various types of ETL transformation.
- Experience in Metadata and Star schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
- Participated in Scrum meetings to discuss issues and work activities.
- Self-motivated and disciplined, with strong focus towards achieving set targets and business goals.
Overview
6
6
years of professional experience
Work History
QA Engineer
Qualitest India Pvt. Ltd
09.2022 - 12.2023
- Conducted functional and user interface testing on Creative Cloud-Learn on Web (LoW) and Learn Content Portal (LCP).
- Document and detail user needs in form of BA requirements.
- Evaluate User stories and revise design specifications.
- Review design documentation provided by BA.
- Identify scenarios and write test cases for each.
- Execute test cases derived from use cases to meet business requirements in both applications.
- Login the defect and also tracking the bug
- Collaborated with development team to resolve bugs.
- Participation in project Scrum Meeting
- Developing and maintaining the salesforce activities and pipeline for targeted customer
- Be the primary point of contact for all the matters related to newly acquired customers and existing customers
- Assisting with arranging installation and provision of services
- Daily meetings with manager about the day-to-day planning and procedures
- Customer escalation handling and resolutions
Software Test Engineer
Zoompare Hyper local Indian Pvt. Ltd
03.2019 - 08.2022
- Handled daily triage calls and gathered test data.
- Coordinated project planning and test execution activities.
- Directed cross-functional and technical teams to coordinate between Onsite and Offshore teams.
- Reviewed TC's to ensure accurate data mapping during ETL process.
- Data validation, transformation/business rule validation.
- Conducted ETL testing to ensure accuracy of data migration.
- Crafted complex SQL queries for data analysis.
- Prepare and Execution of Test cases from Use case to meet Business Logic.
- Done the review and send review comments to others.
- Conducted SCD-1 and SCD-2 mapping tests.
- Run the SQL Queries and validate the data.
- Documented and resolved bugs within Defect Tracking tool.
- Interaction with development team in defect fixing process.
- Participation in project Scrum Meeting.
RF Engineer and Admin executive
Metro Teleworks Pvt.Ltd
12.2017 - 02.2019
Education
Bachelor of Engineer - Electronics and Communication
Dr.A.P.J. Abdul Kalam Technical University
Uttar Pradesh, India01.2016
Skills
- UNIX
- JIRA
- Oracle SQL
- Manual Testing (Functional Testing)
- ETL Testing
- Database Testing
- BI Testing
- Postman
- API Testing
- Python
- Agile
Projects
Adobe Creative Cloud (Learn on Web) & (Learn content Portal), Adobe, California, U.S, Performing functional testing and user interface testing, Capture user stories as requirements, Analyze User stories and User Interface Specifications, Write and execute test cases, Log defects and track bugs, Interact with development team for bug fixing, Participate in project Scrum Meetings, Develop and maintain salesforce activities, Handle customer escalations and resolutions
Personal Information
- Passport Number: P2767749
- Date of Birth: 07/15/93
- Nationality: Indian
- Marital Status: Married
Timeline
QA Engineer
Qualitest India Pvt. Ltd
09.2022 - 12.2023
Software Test Engineer
Zoompare Hyper local Indian Pvt. Ltd
03.2019 - 08.2022
RF Engineer and Admin executive
Metro Teleworks Pvt.Ltd
12.2017 - 02.2019
Bachelor of Engineer - Electronics and Communication
Dr.A.P.J. Abdul Kalam Technical University
Similar Profiles
Sayan BhattacharyaSayan Bhattacharya
Performance Engineer at Qualitest India Pvt. LtdPerformance Engineer at Qualitest India Pvt. Ltd
Ayushi SonnetAyushi Sonnet
Engineer at Qualitest India Pvt. LtdEngineer at Qualitest India Pvt. Ltd
Anjali YadiyalAnjali Yadiyal
Senior Data Analyst at Google Via Qualitest India Pvt LtdSenior Data Analyst at Google Via Qualitest India Pvt Ltd