| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLES U M M A R Y O F E X P E R I E N C E:Over 11 Years of experience in Quality Assurance specialized in ETL/Data warehouse testing with a solid understanding of Test Planning, Test Design, Test Execution and Defect Reporting and Tracking.Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).Actively involved in User Acceptance Testing and Training the end users. Participated in cross-functional teams to re-engineer and improve business processes.Experience in validating data with Snowflake data warehouse and AWS S3 bucket includes nested JSON formatted data.Proficient in backend database/ETL testing by writing SQL and PL/SQL scripts to verify data integrity in Snowflake, MS-SQL Server, Sybase, MySQL, Teradata and DB2.Developed SQL Stored Procedures and Queries using Database Views for Back end testing.Experience in creating rules using query pairs for automating ETL Testing using ICEDQ tool and scheduling rules for continues monitoring on daily basis.Experience working in DevOps Environment and Agile (SCRUM) methodologies.Good expertise in peer reviews (Test Design and Defect Reporting) and analyzing the results and reporting Suggestions and defects.Good expertise on Exploratory Testing using Domain Knowledge and worked closely with development and Technical Support teams to resolve quality issues.Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.Strong interpersonal, analytical & problem solving skills; excellent team player and individual contributor with good sense of planning, prioritizing of work and time management.Well versed with test planning, effort estimation, defect and test management, resource allocation, communication to clients and reporting.Experience in interacting closely with scrum team members and in understanding User Stories to full fill the tasks associated with user stories.Expertise in understanding Business process for writing Test plans and Test Cases perfectly.Excellent Communication skills, Team problem solving ability, Analytical skills, and skills in High speed, Quality conscious and multitasked environment.Expert in analyzing test results and preparing test/defect summary report for Sr. Management.Excellent leadership qualities, team player, enthusiastic initiator, and ability to learn the fundamental concepts effectively and efficiently.A R E A S O F E X P E R T I S E:ETL Tools and UtilitiesMS-SSMS, Toad, Duck Creek, Informatica, Autosys, Altova Xml Spy, PuttyTest Management ToolsRally (CA Agile Central), JIRA, HP - QC/ALM and TFSDatabasesSnowflake, SQL Server, Teradata, MySQL, DB2, Sybase, Oracle and KylinCloud TechnologiesAWS S3 and Azure SQLProgramming LanguagesSQL, Cucumber, Selenium with Core JavaEducation:Bachelor of Technology in Computer Science, JNTU, Hyderabad, India.Awards:Received Client Appreciation Certificates from eBay and Anthem along with Bonus.P R O F E S I O N A L E X P E R I E N C E:ClientThe Hartford, CTTitleQA LeadProjectNewCoDuration3/2021 to PresentDescription: The Hartford is a leader in property and casualty insurance, group benefits and mutual funds. With more than 200 years of expertise, The Hartford is widely recognized for its service excellence, sustainability practices, trust and integrity. NewCo program reinvents Personal Lines Business for The Hartford and creates a market leading technology platform that will help to increase The Hartfords industry performance and strengthen pricing and product relevance, creating a better human experience.Responsibilities:Managing and reporting status of offshore teams in daily scrum and defect triage meetings.Prepared Test Scenarios document and written Test Cases as per functional requirements.Created Test Folders, Test Sets, and Test Cases and ran Tests in Rally.Validated pre-production and production environments to ensure data flow is correct.Executed test cases on Snowflake and configured test cases to automate the regression testing.Created home and auto policies in Duck Creek to prepare the test data to validate data load.Verified failed tests in front-end application Duck Creek.Ran Autosys load and automation jobs and validated data load.Performed various data quality checks and tested end-to-end flow of data from Duck Creek to Snowflake.Converted data quality checks to Snowflake queries and ran on daily basis on all environments.Created test scripts in Snowflake SQL based on mapping documents.Validated data ingestion on AWS S3.Environment: Rally, SQL Server, Snowflake, AWS S3, Duck Creek, Altova Xml Spy, Putty, Windows 10.ClientAnthem, VATitleQA LeadProjectAEON ReportingDuration10/2018 to 08/2019Description: Anthem as an insurance payer has been contracted as an MCO to provide Medicaid Benefit Administration in multiple states it does business. Each MCO has to report the Claims Encounter Data to the state per the contract. Encounter Data Management Team deals with the submission of Medicare and Medicaid encounter information to State/CMS to meet the contractual compliance set forth by CMS/State.Responsibilities:Conducting daily standup calls to update current plan to the team.Prepared test cases and test metrics documents and shared with client.Provided support in the performance testing using JMeter task includes developing test plan, test script and reports.Run scripts and prepare regression results for various data marts and report to business team.Compared data between SQL Server to JSON and JSON to Teradata.Compared data between Pharmacy Files and JSON files for POST 837 submission.Mocked data for POST 837 submission files.Mocked data for X12 files by using EDI document.Compared data between X12 and JSON files using Looky tool.Testing of EDI X12 and 837 transactions sets for claims processing.Prepared test data and verified all claims from Sources to Targets.Created ICEDQ automation scripts and configured jobs to run periodically to monitor.Environment: JIRA, SQL Server, Teradata, JSON, ICEDQ, Windows 10.ClientFarmers Insurance, CATitleQA LeadProjectEDBIDuration07/2018 to 10/2018Description: Farmers Insurance Group is an American insurer group of automobiles, homes and small businesses and also provides other insurance and financial services products. EDBI integrates major insurance data domains, drives data marts, provision finance files/reports and provides operational reporting data and management support.Responsibilities:Conducting daily standup calls to update current plan to the team.Run scripts and prepare regression results for various data marts and report to business team.Modified existing stored procs as per new requirements.Verified steady state defects and documented the testing details.Triggering and monitoring workflow sessions in Informatica Workflow Manager.Data comparison/validation using TOAD for various stages.Performed tests on various features of Agile/SCRUM development process.Environment: HP Quality Center 12.20, DB2, Informatica PowerCener 10.11, TOAD 6.2, Agile/Scrum, Windows 7/10.ClienteBay, Bellevue WATitleQA LeadProjectsMarketing ONE (M1) & ADPO & Customer DNADuration10/2015 to 07/2018Description: eBay Inc. is an American multinational e-commerce corporation based in San Jose, California, that facilitates consumer-to-consumer and business-to-consumer sales through its website.Responsibilities:Identified the test requirements based on application business requirements.Performed Manual testing and maintained documentation on different types of Testing viz., Positive, Negative, Regression, Integration, System, User-acceptance and Performance Testing.Writing Automation Test Scripts Using Core Java in Selenium WebDriver and Cucumber.Created Test cases and test script and developed Requirement Traceability Matrix to match the requirement.Developed test code in Java language using Eclipse IDE and Selenium and Cucumber framework.Involved in performing System Testing of the entire applications along with team members.Created automation scripts using JMeter for Performance Testing.Developed Test scenarios and test procedures based on the test requirements.Participated in Preparing Test Plans during initial stages of testing.Analyzed and Identified Test Scenarios, prepared Test Cases using Core Java for Automation (Selenium).Investigated defects and interacted with Developers to resolve technical issues and used JIRA to log and track defects.Performed Backend testing to validate the data using complex SQL queries to the required Test cases.Performed ETL Testing in Teradata database by writing queries on source and destination tables/views.Migrating tables from Teradata to Hive using DSS tool.Manually compared migrated tables by using Hive QL and Spark Sql CLI.Automated tables comparison to reduce manual work using DQ Recon tool.Environment: JIRA, MySQL, Teradata, Kylin, Hive, Spark, DSS, Java, Selenium, Cucumber, Widows 7 and UNIX.ClientFreddie Mac, Tysons Corner VATitleSenior QA AnalystDuration11/2014 to 12/2014Description: Servicers with an active Freddie Mac Seller/Servicer number must report delinquency and default information to Freddie Mac monthly for all Freddie Mac single-family mortgages in default through Electronic Default Reporting (EDR). Information services are required to report includes the Due Date of the Last Paid Installment (DDLPI), Default Action Codes (Status and Event), Default Reason Codes, Occupancy Status Codes and Property Condition Codes. Servicers must send Freddie Mac monthly EDR transmission on the first, second, or third business day of a month to report all activity that occurred in the previous month. Servicers must report on all mortgages that are 30 days or more delinquent or where the borrower is in bankruptcy, whether or not the borrower is current on mortgage payments. If servicers have no activity to report under one or more Seller/Servicer numbers, servicers must send Freddie Mac a monthly transmission to indicate "no activity" for each Seller/Servicer number that has no activity for the monthResponsibilities:Analyze application requirements, specifications and test results.Created test cases and test scenarios for production issues.Created test cases for new requirements in HP ALM.Written SQL queries using Rapid SQL to pick service numbers which are in delinquent and fore closure statuses.Written SQL queries to check the tables whether DDLPI updated.Created input files for UNIX jobs and ran them via putty emulator.Running batch processes in UNIX and validating the data in database.Performed Backend testing using SQL Developer.Environment: Quality Center 9.0, Rapid SQL, DB2, UNIX, Putty, Windows 7.ClientAINS India Pvt. LtdTitleQA AnalystDuration6/2009 to 12/2012Description: FOIAXpress is the most comprehensive web-based commercial-off-the-shelf (COTS) application available for electronically processing Freedom of Information Act (FOIA) and Privacy Act (PA) requests. As emphasis on government openness and transparency continues to increase, agencies and institutions are looking to find ways to streamline FOIA request management and facilitate citizen interaction. FOIAXpress is a one-stop software that manages the entire lifecycle of a FOIA request from initial request to final delivery of documents, including request management, correspondence management, document management, fee/payment management, document review and redaction, and reporting.Responsibilities:Performed End to End Manual Testing.Create story level Test Scenarios for every 2 weeks sprint.Performed Back end testing using SQL Developer.Performed Functional, Black Box, System, End to End and Regression testing.Extensively used Smoke, Sanity and Integration Testing.Prepared Test data to enable the software to be quality checked.Involved in system requirements reviews and technical reviews & testing implementations.Performed end-to-end testing for both data transformation as well as functionality testing.Responsible for supporting all data and environment issues associated with test execution.Problem reporting and management, including timely and accurate communications to the impacted teams.Identified bottlenecks, data errors and integration problems and revised application to enhance performance.Environment: Oracle 10g/9i, SQL Server 2008/2005, TFS, Windows 7. |
