Sr. Quality Analyst (ETL and automation) Resume

PROFESSIONAL EXPERIENCE

Confidential

Sr. Quality Analyst (ETL and automation)

Responsibilities:

Worked as manual and automation tester for data quality. Created back end automation testing scripts in C# Junit. Scheduled jobs with Jenkins and generated report for distribution.
Analyzed Data Lineage documents and validated data flow from source to target.
Creating automation testing framework(ATF) for back - end testing with Visual Studio C#
Scheduled jobs with Jenkins and created customized reports.
Experience with analyzing large amounts of data, troubleshooting and improving data quality.
Experience in SQL Server Performance Tuning and Query Optimization.
Experience in writing and analyzing complex Stored Procedure and Functions in T- SQL.

Confidential

Sr. Quality Analyst (Frond end and API automation)

Responsibilities:

Supported VSIMS application deployment to production, worked closely with UAT team before and after production deployment. Actively worked with end user with application feedbacks.
During application development worked with developers to analyze and build application
Defect management done in jira and follow up emails send daily.
Created Selenium automation framework using java. Automation used to run on request to check sanity of application and send out email if needed automatically.
Created and run performance testing scripts using simple java and simulated like multiple users. Based on our testing results code changes, SQL query optimizations are made for better performance. And hardware upgrades are made in production servers.
Tested APIs with Postman and Insomnia.

Confidential

Quality Analyst

Responsibilities:

Participated in daily project status meetings
Managed offshore automation team, checked integrity of automation code
Created complex queries to compare tables and for other testing reasons in SQL Server
Automated data migration from sever to server using SSIS
Created useful VBA scripts/macros in Excel to compare data and other activities.
Helped PFE team move from TIBCO DataSynapse (grid computing) to IBM Symphony
Run Autosys jobs in Putty, checked logs, reported issues if found
Logged issues, created test cases in Jira and Quality center
Running ETL tasks, creating simple SSIS packages.
Heavily involved in data comparison, complex SQL queries, stored procedure testing.

Confidential

Quality Assurance PM

Responsibilities:

Networx Enterprise sanity, functional, regression testing and backend testing
Creating, maintaining, running test cases in HP QC and Jira
Managing daily defect calls, task tracking spreadsheet, sending daily reports to management
Monitoring build process, reporting build fails and finding solution.
Helping development team with backend business logic in Oracle SQL
Worked with offshore(VDSI) team, solving development issues
Automated regression testing using Selenium based on Java
Tested REST services with SoapUI
Tested 508 Compliance using aXe, Wave, JAWS tools

Confidential

Quality Assurance Analyst

Responsibilities: