Prateek Rajpal
New Delhi,DL
Summary
IT professional with having 10+ years of experience in Data warehousing solutions with a strong background in ETL strong knowledge on Data Warehousing and RDBMS concepts Handling Team issues with Business and stake holder with the requirement. Hands on Experience in lead and manage Team QA Team Experience in working on projects using AGILE Sprints methodology. Ability to communicate effectively with technical and non-technical stakeholders. Strong organizational and time management skills. Hands-on experience in ETL & BI tool, Writing SQL complex queries to perform backend validations. To implement CI/CD tools using Jenkins Analyze business requirements and technical specifications to define test scenarios and cases.. Knowledge of data warehousing concepts (e.g., star schema, snowflake schema). Strong abilities in Functional, Regression, Retesting, GUI Testing and SQL Queries. Ability to analyse complex data sets and identify anomalies. Strong problem-solving skills to troubleshoot ETL issues. Experience with test automation tools using PyCharm Python Automation Hands on Experience with ETL Test Automation using python. Result driven experience in python PyCharm to implement various Test Automation process as per Business requirement. Coordinating with business analyst and Teams to implement the business Good Exposure to Data Warehousing concepts. Knowledge on writing Test Automation Scripts for (Python) Hands-On experience with writing Test python scripts for Data Validation Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management. Ability to work against tight deadlines. Hands-on experience with BI Tools (Power BI, Tableau, SSRS, OBIEE).
Overview
12
12
years of professional experience
Work History
Quality Analyst
Cigniti Technologies
04.2024 - 12.2024
- Company Overview: Cigniti Technologies is a global leader in independent quality engineering and software testing services.
- Understanding the business requirement as per the business.
- Involved in the DB /DWH Testing process and understanding OLTP Process.
- End to end Data Testing.
- Writing simple to complex queries and provide to support team for their health checks.
- Maintain and Execute test Scripts at the time of regression Testing.
- Involved in logging the Defects, Defect Reporting and Tracking.
- Cigniti Technologies is a global leader in independent quality engineering and software testing services.
Quality Analyst
NTT DATA
07.2021 - 01.2023
- Company Overview: NTT DATA is a global IT service provider and global innovation partner headquartered in Tokyo, Japan.
- Understanding the business requirement as per the business.
- Involved in Testing stored procedures and complex joins.
- Involved in the DB /DWH Testing process and understanding OLTP Process.
- Using different FTP commands to transfer files from one server to another.
- Involved in functional study of the application.
- Maintain and Execute test scripts at the time of regression testing.
- Monitoring and Stabilizing Jobs.
- End to end Data Testing.
- Involved in Testing.
- End to end Survey Testing which are sent to users for feedbacks.
- Writing simple to complex queries and provide to support team for their health checks.
- NTT DATA is a global IT service provider and global innovation partner headquartered in Tokyo, Japan.
Quality Analyst
BD CareFusion Pvt Ltd
03.2020 - 01.2021
- Company Overview: BD CareFusion is a global medical technology company that provides innovative solutions for healthcare.
- Handling client discussions to understand business requirements.
- Detailed analysis on the client’s requirements to deliver high quality product.
- Preparing test plans and test cases.
- Designing and Developing Effective Test Scripts.
- Updating the existing automated script.
- Maintain and Execute test scripts at the time of regression testing.
- Involved in logging the Defects, Defect Reporting and Tracking.
- Testing of the system at various stages in the development phase.
- Doing peer review of another team member TC’S.
- Interacting with client on daily basis for status update and for upcoming changes.
- Attended production launch call.
- Involved in Data Migration Testing from Flat Files to Cloud DB.
- Involved in the ETL process for loading data into the data warehouse.
- Write script for test cases, which cover a broad function scenario.
- BD CareFusion is a global medical technology company that provides innovative solutions for healthcare.
Quality Analyst
Cigniti Technologies Ltd
09.2019 - 02.2020
- Company Overview: Cigniti Technologies is a global leader in independent quality engineering and software testing services.
- Handling client discussions to understand business requirements.
- Detailed analysis on the client’s requirements to deliver high quality product.
- Preparing test plans and test cases.
- Designing and Developing Effective Test Scripts.
- Updating the existing automated script.
- Maintain and Execute test scripts at the time of regression testing.
- Involved in logging the Defects, Defect Reporting and Tracking.
- Testing of the system at various stages in the development phase.
- Doing peer review of another team member TC’S.
- Interacting with client on daily basis for status update and for upcoming changes.
- Attended production launch call.
- Cigniti Technologies is a global leader in independent quality engineering and software testing services.
Production Support Engineer
Steria India Limited
12.2012 - 08.2019
- Company Overview: Steria India Limited is a leading provider of IT services and solutions in India.
- Understanding the requirement.
- Works as Production support engineer.
- Creating Incidence Tickets for any Production queries.
- Assigning Tickets to the concern Desk.
- Creating Backlogs Tickets for Production issues.
- Involved in the Productions Maintenance support.
- Involved in frontend UI and Backend DB Data Testing.
- Involved in validate the changes occurs in UI and DB.
- Attend the Team Meeting, Grooming Calls.
- Steria India Limited is a leading provider of IT services and solutions in India.
Education
Master of Computer Application -
MDU
Rohtak, HaryanaBachelor of Computer Application -
IGNOU
Maiden Garhi, DelhiSkills
- Windows
- Unix
- Python
- C
- SQL Server
- Oracle
- Data validation
- Informatics
- Functional testing
- MSBI
- Power-BI
- PyCharm-python
- TFS
- ALM
- Jira
- Git-hub
- Jenkins
- Regression testing
- Test case development
- QA methodologies mastery
- Test automation
- Defect tracking
- SQL
- Software quality assurance
- Mastery of QA methodologies
- QC testing
- Testing documentation maintenance
- Defect logging
- Structured query language mastery
- Software testing
- Root-cause analysis
- Bug tracking and resolution
- Software compatibility testing
- Team collaboration
- Test implementation
- Scenarios and use cases
- Manual test case preparation
- Manual testing
- Test plans and test methodologies
- Test scheduling
- Black box testing
Languages
English
Hindi
Disclaimer
I hereby declare that the details furnished above are true and correct to the best of my knowledge.
Personal Information
- Hobbies: Football, Basket-Ball
- Date of Birth: 09/23/87
Football , Basket Ball
Football and basketball both are hobbies! Both are not just great for physical fitness but also for improving teamwork, strategy, and decision-making skills
Timeline
Quality Analyst
Cigniti Technologies
04.2024 - 12.2024
Quality Analyst
NTT DATA
07.2021 - 01.2023
Quality Analyst
BD CareFusion Pvt Ltd
03.2020 - 01.2021
Quality Analyst
Cigniti Technologies Ltd
09.2019 - 02.2020
Production Support Engineer
Steria India Limited
12.2012 - 08.2019
Bachelor of Computer Application -
IGNOU
Master of Computer Application -
MDU
Similar Profiles
Shweta ShreeShweta Shree
Senior Test Engineer at Cigniti TechnologiesSenior Test Engineer at Cigniti Technologies
Mumtaj ShaikMumtaj Shaik
Test Lead – Projects at Cigniti TechnologiesTest Lead – Projects at Cigniti Technologies
Sirisha KommireddiSirisha Kommireddi
Associate Vice President & Global Head Talent Development at Cigniti TechnologiesAssociate Vice President & Global Head Talent Development at Cigniti Technologies
Aravind ReddyAravind Reddy
Associate Director at Cigniti TechnologiesAssociate Director at Cigniti Technologies
SANDHYA JAINSANDHYA JAIN
Account Manager at EncoreAccount Manager at Encore