We provide IT Staff Augmentation Services!

Etl Tester / Application Testing Resume

Dayton, OhiO

SUMMARY

  • Over 6 years of professional experience in the Information Technology industry specializing in performing Database, Manual and Automation testing of Client/Server and Web based applications on different environments
  • Strong experience working on SDLC (Waterfall Model & Agile) life cycles
  • Expertise in Defect Reporting & Tracking and compiling Defect Metrics using JIRA, Test Director/HP Quality Center 10.0, HP ALM 12.01
  • Expertise in developing Test Estimations, Test Plans, Test Cases/Scenarios, Test Procedures, Test documentation and analyzing Test Results to produce accurate Test Metrics
  • Skilled in System Testing, Regression Testing, Data Validation testing, Black Box Testing and White Box Testing
  • Experience in Functional/Non - Functional Testing, Regression Testing and System Integration Testing (SIT) in waterfall, Iterative and Agile development environment
  • Worked in agile methodology, coordinating with the development for quick resolution of Issues on timely basis
  • Experienced in understanding and validating the SSIS transformations, Informatica mappings as per the source to target mapping document.
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Worked on Dimensional Data Modeling using Star and Snow Flake Schema.
  • Experienced working on Data Masking, Data Archiving and Electronic Data Interchange.
  • Experienced in validating SSRS Reports, Power BI Dash Boards as per the company standards.
  • Having experience on handling Medical Claims which comes through a source called Facets Application which is a product of TriZetto and having knowledge about its benefits configuration.
  • Having experience on handling pharmacy claims like CVS, Walgreens, Kroger and Walmart
  • Worked on different medical claims like Professional, Institutional.
  • Having Experience on HEDIS related Data sets, HEDIS measures and Value Based Attributions.
  • Worked with Provider data model, Claims data model and Member Data model.
  • Expertise in Risk Assessment for the Test Design & Scenarios and providing on time mitigations to meet the schedules
  • Good understanding of system workflows, computing and verifying Software Metrics and ability to communicate with both technical and non-technical teams
  • Quick learner in understanding the client’s needs / enhancements, co-ordinate with the technical team to deliver the customize products on schedule
  • Good knowledge in web services testing using SOAP UI, Fiddler and Jmeter
  • Expertise on identifying various test scenarios and possess strong ability to handle multiple tasks and prioritize them
  • Excellent analytical and problem-solving skills, planning and organizational skills and strong interpersonal skills.

TECHNICAL SKILLS

Testing Tools: HP Quality Center 9, 10, 11, Test Director, JIRA, Rally, SOAP UI, Quick Test Professional (QTP)

Web Technologies: ASP.NET, ASP, XML

IDE: VS 2005/2008/2010 , IntelliJ, Eclipse

Operating Systems: Windows 2000/2003/XP/7, Vista, Mac

SDLC Methodologies: Waterfall, Agile (Scrum)

Databases: Oracle, DB2, SQL Server 2003/2005/2008 , Tera Data, MS Access

Languages: SQL, PL/SQL, Java, Visual Basic, HTML

APM Tools: QC (ALM), Jira, Rally, TFS, Confluence

CI/CD: Jenkins, Team City, Octopus.

Software Packages: MS Project, MS Visio, MS-Office, PowerPoint, Word, Access, Excel

PROFESSIONAL EXPERIENCE

Confidential, Dayton, Ohio

ETL Tester / Application Testing

Responsibilities:

  • Actively interacted with the Business users, product owner and the developers in the agile team to understand the test scenarios.
  • Created a Test Strategy, Test Plan and Test Cases.
  • Created and mocked up test data and designed test cases according to data mapping STM (Source to Target) document.
  • Experience in Data integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
  • Experienced working with huge volumes of data, analyzing record sets for Data Quality, Data Validation and Metrics using SQL and PL/SQL.
  • Involved in creating Automation framework from scratch by using Sql Stored Procedures
  • Experienced in writing SQL Stored Procedure to automate the Test Cases which handles Integration and Regression Testing.
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Experienced in understanding and validating the SSIS transformations, Informatica mappings as per the source to target mapping document.
  • Validated the Medicaid and Medicare member records and their eligibility details in the Databases using SQL Queries.
  • Interacted with multiple databases like Tera Data, Facets and SQL server while migrating data to SQL Server 2012.
  • Actively participated and performed data validation during Informatica to SSIS data migration from multiple sources.
  • Executed ETL jobs to load the data from source to target and validated Informatica log files
  • Worked on Dimensional Data Modeling using Star and Snow Flake Schema.
  • Experienced working on Data Masking, Data Archiving and Electronic Data Interchange.
  • Experienced in validating SSRS Reports, Power BI Dash Boards as per the company standards.
  • Having experience on handling Medical Claims which comes through a source called Facets Application which is a product of TriZetto and having knowledge about its benefits configuration.
  • Having experience on handling pharmacy claims like CVS, Walgreens, Kroger and Walmart
  • Worked on different medical claims like Professional, Institutional.
  • Possesses extensive knowledge of transformation rules verification processes and data sample comparisons.
  • Having Experience on HEDIS related Data sets, HEDIS measures and Value Based Attributions.
  • Worked with Provider data model, Claims data model and Member Data model.
  • Performed smoke and regression testing by using SQL.
  • Interacted with development team for clarifications
  • Executed SQL test cases and reporting defects.
  • Executed the web-service test cases using SOAP UI, Fiddler and Jmeter tools.
  • Performed trouble shooting when the nightly jobs failed.
  • Tested Applications compatibility on different browser versions (IE, Firefox).
  • Extensively worked with End-to-end testing for User Acceptance Testing (UAT).
  • Collaborated with business owners in validating the data in certification Environment
  • Used Jenkins to deploy the builds to test environments.
  • Collaborating with Change Management team to deploy the changes all the way through production.
  • Dealt with the Bug life cycle phases like Defect analysis, bug tracking and Retesting is performed and maintained the status of reports.
  • Lead the showcase meetings for all the sprint releases.

Confidential

ETL Tester

Environment: Informatica, SQL Server, Teradata, Oracle, SQL, Agile, SQL Assistant, Windows, TOAD, MS Excel, Flat files, UNIX, HP Quality Center

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel.
  • Conducted source-system data analysis to understand current state, quality and availability of existing data.
  • Verify the source to target data movement and verify the target data by writing SQL and PL/SQL
  • Design and execute the test cases on the application as per company standards
  • Experience in Data integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
  • Identifying the Test Cases to be automated and developed automation test scripts using Selenium Web
  • Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
  • Participated in defining and executing test strategies using agile methodology.
  • Traceability Matrix and Integration Test activities.
  • Tested data migration to ensure that integrity of data was not compromised.
  • Queried Teradata Database and validated the data using SQL Assistant.
  • Tested XML files using Soap UI
  • Involved in system Integration testing (SIT), System Verification Testing (SVT) and User Acceptance Testing (UAT).
  • Worked with SAOP UI to manually test REST services for the response messages.
  • Performed Integration testing to verify the data interface between various application modules.
  • Worked with collaborative testing with developers as per the SCRUM meeting
  • Performed Root Cause Analysis for the reported issues
  • Extensively used Rally for all the projects.

Confidential

QA/SQL Tester

Environment: Informatica, Business Objects, Win SQL, Quality Center, Waterfall Model, Oracle, SQL, SQL Server.

Responsibilities:

  • Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
  • Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
  • Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Testing the source and target databases for conformance to specifications
  • Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
  • Designed and prepared scripts to monitor uptime/downtime of different system components
  • Participated in weekly meetings with the management team
  • Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
  • Performed the back end testing by using SQL Queries and verified the data integrity.
  • Coordinated with the developers to resolve defects.
  • Involved in documentation in order to maintain and run scripts for future enhancements.
  • Worked with team in developing selenium automation scripts.
  • Updated the automation scripts based on changes made to the application.
  • Closely worked with developers and System Engineers to nail down the technical problems.
  • Reported the bugs, Email notifications to the developers using the Jira Defect Tracking Tool.
  • Monitored Jira to close the bugs/cases as and when developers fix the bugs.

Hire Now