OBJECTIVE

• Seeking a job where I can utilize my technical and interpersonal skills in a creative fashion, and which gives a scope to learn new things and successfully contribute to the Quality assurance efforts of a project group.

SUMMARY

• 7+ years of Industrial experience related to software quality assurance, system validation and database/ETL testing of the project life cycle.
• Played variety of roles as a team lead, data validation specialist, Sr. functional test analyst in the Agile and waterfall project models.
• Delivering client value through quality assurance and testing, expertise in test design and execution and in building high performing teams and working as a technical member in the team as well.
• Experienced in using test management tools HP ALM and JIRA across software development life cycle and defect management.
• Excelled in implementing Shift - Left quality approach in the projects for the effective cost management and minimize the actual test effort through early identification of defects.
• Experienced in functional testing, application validation, database testing, data migration testing and ETL(DWH) testing.
• Hands on experience with MYSQL, Oracle Database, SQL Server using various database management tools such as Oracle SQL Developer, Toad, MYSQL workbench, Query Surge(Data comparator) etc.
• In-depth knowledge in various phases of functional and data testing that include requirements analysis, test planning, test design, test execution, test closure and overall test management.
• Analyzed source to target mappings, identified data dependencies and created test data sets.
• Assured the extract, transform and loading (ETL) functionalities and validated the ETL logic through landing/staging/presentation data layers.
• Performed back end SQL testing on transactional databases through iterative incremental releases in Agile fashion.
• Performed data renunciation between source and target tables and ensure data integrity is maintained.
• Demonstrated ability to work effectively in a fast paced, high stress environment.
• Worked with Business users in understanding the system’s business objectives, database architecture, gathering the user requirements, interpret them into system requirements using use-case diagrams and participation in UAT.
• Possesses good exposure in client interface, organizational presentations and both verbal & oral communications.
• Good understanding of Life sciences, Health care and Insurance industry regulations.
• Strong ability to train new employees regarding company’s policies, procedures & quality assurance.
• Received the Best Employee award for developing an in-house innovative tool ‘Python eComparator’ that compared the migrated data from SQL server to Oracle database.

TECHNICAL SKILLS

Programming/Scripting Languages: SQL, Python

Technologies/Tools: HP ALM, HP UFT, JIRA, SQL Server, MYSQL, Oracle database, Query surge, Toad, Remedy change management tool

SDLC Methodologies: Waterfall, Agile Methodologies

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Responsibilities:

• As a functional and data validation lead, test plan and test cases are designed, developed and executed in a structured and streamline process in the Agile SDLC methodology.
• Investigates data retrieval issues, data load failures, data redundancy and data inconsistency defects on transactional and dwh schemas, views and tables.
• Implements the Shift-Left concept in the application testing for the early detection of defects during initial SDLC phases and therefore contributes to the project cost effectiveness.
• Delivering client value through quality assurance and testing, expertise in test design and execution and in building high performing teams and also working as a technical member in the team.
• Uses HP ALM and JIRA as test management tools for test execution, test evidence capture and defect management.
• Conducts functional and data testing through phases of requirements analysis, test planning, test design, test execution, test closure and overall test management.
• Analyze the source to target mappings on Oracle Database using database design document, identify the data dependencies and gaps.
• Performs data migration and database upgrade testing using Query Surge data comparator.
• Assures the extract, transform and loading (ETL) functionalities and validated the ETL logic through landing/staging/presentation data layers.
• Performs SQL testing on transactional databases through iterative incremental project releases.
• Demonstrates the ability to work effectively in a fast paced, high stress environment.
• Calculates the project metrics, effort/cost estimations based on the system requirements and shares weekly status reports with project team.

Confidential, Hartford, CT

Responsibilities:

• As a quality analyst, performed end to end testing of new applications and COTS products.
• Acted as transactional databases and data migration test lead and managed a team for project delivery.
• Developed the complex SQL data queries to perform the data migration testing across Oracle DBs using SQL Developer and Toad tools.
• Designed the solution ‘Java eComparator’ for data validation between SQL and Oracle servers using python in Eclipse and SQL Developer for successful formal test execution which was a value-add for client.
• Performed project estimates, resource loading, test planning, test schedule design, client and stakeholder management, test design, test execution, defect management and test closure.
• Designed test cases based on system requirements, extracted regression test suites and supported business users in UAT.
• Managed a large manual and database test team of 15 members in the Modern browser program that involved 150+ applications in an Agile methodology.
• Tested new ETL/SQL functionalities by creating mock data based on different test scenarios to validate source to target data flows in SQL Server and MYSQL databases.
• Defect Tracking, closure and sign off report documentation.
• Verification of data coming from different sources through different ETL layers like landing, staging with transformational logic and presentations, as provided by business logics.
• Verification and validation of data quality maintained in the end to end flow through the downstream application such as UI or graphical reports.

Confidential, Cambridge, MA

Responsibilities:

• Manual test analyst with mere UFT automation on web applications.
• Analyzed the system requirements to design the manual test cases and get business and quality review done.
• Designed regression test suites out of the available test cases and triggered the overnight batch execution in HP ALM integrated with UFT.
• Performed the Automation feasibility study on the application based on regression test steps and designed the automated scripts in UFT.
• Calculated project metrics, effort/cost estimations based on user requirements/needs and share weekly status reports with customer.
• Worked in change management life cycle using Remedy tool through change initiation to closure phases for successful deployment in the production.