Naga Charan

A highly skilled Software Quality Engineer with 6+ years of experience in ETL Testing, AEM Testing, and Manual Testing. Proficient in testing e-commerce platforms to ensure functionality, usability, and compatibility. Adept at collaborating with cross-functional teams to deliver high-quality software solutions while meeting deadlines. Committed to continuous learning and adopting emerging trends in the software testing domain.

• Extensive experience with Adobe Experience Manager (AEM) workflows and components.
• Proficient in content authoring, publishing, and global content management.
• Skilled in optimizing content for SEO and performance.

• Strong knowledge of Data Warehousing concepts and ETL processes.
• Proficient in SQL queries for data verification and validation.
• Expertise in validating data transformation across staging, dimension, and fact tables.

• Experienced in creating detailed test plans, test cases, and defect tracking.
• Skilled in functional, integration, regression, and UAT testing.
• Hands-on experience with tools like Jira, HP ALM, and Azure.

• Extensive experience in Agile and Waterfall models, ensuring efficient test management.

• Strong communication skills with active participation in status and defect review meetings.
• Proven ability to perform under pressure and meet project deadlines.

Project 1: Microsoft WEB Store Project 1.1: Xbox Project 1.2: Adobe Experience Manager (AEM)

LTI-Mindtree

Role: Senior Test Engineer
Duration: September 2022 – Present

Scope: To provide Microsoft customers worldwide with access to all products listed on the Microsoft portal across regions (NA, EMEA, APAC) and their respective markets.

Responsibilities:

• Developed comprehensive test plans, resulting in a 40% increase in test coverage and reduced production issues.
• Conducted various testing types, including smoke, integration, functional, ad hoc, accessibility, browser compatibility, and regression testing.
• Collaborated with product managers and developers to define clear and comprehensive test cases and acceptance criteria.
• Performed daily SQL data validation, ensuring 99.9% accuracy of database records.
• Worked on technical aspects of order management, pricing, and product configuration in an e-commerce application.
• Conducted thorough exploratory testing, identifying and documenting over 300 bugs and issues, significantly improving product quality.
• Designed a comprehensive test plan for API testing, achieving high coverage and accuracy while reducing testing time by 40%.
• Enhanced the support for Excel files using Apache POI with XML and Java for efficient data handling.

Scope: E-commerce project for Microsoft, focused on new Xbox product launches before the holiday season.

Responsibilities:

• Performed functional, integration, regression, and validation testing with 95% adherence to development standards, contributing to a customer satisfaction rating of 4.8/5.
• Designed and executed over 500 test cases for regular maintenance and enhancements.
• Reduced product defects by 20%, increasing customer satisfaction by 10%.
• Utilized Jira and Azure Web for defect tracking and reporting, achieving a 100% closure rate.
• Conducted API testing on 50+ endpoints, identifying and resolving over 80% of integration issues before development.

Scope: A dynamic content and digital asset management solution for creating, organizing, and delivering content across digital touchpoints.

Responsibilities:

• Proficient in Adobe Experience Manager (AEM) and its components in Azure.
• Created, edited, and published web content in AEM, ensuring proper organization, version control, and asset management.
• Recommended development changes, reducing customer-reported defects by 30%.
• Developed and maintained AEM templates and components for various web pages.
• Conducted SEO optimization for improved search rankings and user experience.
• Analyzed testing results of software applications, identifying areas for improvement and increasing overall product quality by 20%.
• Collaborated with UX/UI designers and developers to ensure effective content presentation aligned with brand identity.

Duration: December 2021 – August 2022
Location: LTIMindtree, Bangalore
Operating Systems: Windows 7, 8, 10
Testing Approach: Manual
Team Size: 60

Scope: AEM (Adobe Experience Manager) is a leading content management platform. The project involved authoring and retesting tasks for Microsoft web pages across various products and electronics. Testing focused on ensuring localized content with accurate pricing, terms, and conditions for different countries.

Responsibilities:

• Performed content authoring, including publishing and unpublishing content on Microsoft websites.
• Conducted Payment Gateway Testing and User Acceptance Testing (UAT) for seamless transactions.
• Executed Smoke Testing and collaborated on page creation alongside QA testing efforts.
• Actively participated in all phases of the project, including web production and QA environments.
• Provided quick support and ensured availability during critical launches.
• Logged and tracked engineering bugs, maintaining comprehensive details for each issue.
• Resolved end-user issues by analyzing problems and escalating technical challenges to the development team.
• Engaged in end-to-end analysis of new requirements, ensuring clarity and feasibility for implementation.

Client: One of the Leading Banks in the USA
Duration: [Specify duration if known]
Solution Environment: DataStage, DB2, AQT, ALM
Role: Off-Shore QA Member

Description:
This project aimed to provide detailed banking activity reports for a federal bank to track deposits, loans, cash flows, commitments, and customer data. The ETL process included data ingestion from files, staging data, applying business logic, and loading it into core tables. The processed data was organized into daily and monthly views for reporting purposes, enabling upstream teams and third-party banks to analyze information on daily, monthly, and ad hoc bases.

Responsibilities:

• Reviewed requirements and initiated clarifications to ensure clear understanding.
• Collaborated extensively with developers and business teams to understand design specifications.
• Prepared test plans, test cases, and test data for thorough testing coverage.
• Developed complex SQL queries to verify data across multiple table layers during the ETL process.
• Validated target data in Data Warehouses and Data Marts transformed and loaded using DataStage.
• Tested and reviewed mapping and transformation specifications based on business requirements.
• Prepared daily status reports detailing executed, passed, and failed test cases along with defect status.
• Provided weekly status updates to the Project Manager, highlighting quality metrics and challenges.
• Prepared detailed test reports and contributed to project closure activities by creating System Understanding Documents (SUD).

Client: One of the Leading Banks in the USA
Duration: [Specify duration if known]
Solution Environment: DataStage 9.1, DB2, AQT, ALM
Role: Off-Shore QA Member

Description:
The Multi Card project revolved around credit cards assigned to multiple users under the same account. The ETL process involved creating stage, dimension, and fact tables to store transaction and customer data. Reports were generated to analyze product preferences and customer trends.

Responsibilities:

• Reviewed requirements and clarified queries for accurate testing preparation.
• Collaborated with developers and business teams to ensure clear understanding of design specifications.
• Created test plans and test cases tailored to project requirements.
• Developed complex SQL queries to verify data across various database layers.
• Provided knowledge transfer sessions to team members, including translating requirements into test scripts and preparing mockup data conditions.
• Performed positive and negative testing against requirements to ensure robustness.
• Tested reusable transformations facilitating daily, weekly, and monthly data loads.
• Validated target data in Data Warehouses and Data Marts processed through DataStage.
• Generated ad hoc reports using SAP BO based on business requests.
• Prepared daily status reports detailing test execution, pass/fail results, and defect tracking.