Sr Qa / Etl/ Tester Resume
PA
SUMMARY
- 10 years of professional work experience in Automation Testing, Functional Testing, and Data Base Testing.
- Extensive experience in Waterfall & Agile SDLC/STLC methodologies.
- Expertise in Functional Automation using UFT & Selenium Web Driver.
- Good exposure on Continuation Integration tool - Jenkins and integrate the same with Selenium projects to run the jobs after each build deployment
- Extensive experience in creating User Acceptance Scenarios, Test Strategy, Test plan and reviewing the detailed test plans.
- Extensive experience in Sanity Testing, Feature Testing, Functional Testing, System Testing, Compatibility Testing, Regression testing, Performance testing, Boundary Testing, Load Testing and Stress Testing in web based applications.
- Good exposer of EDI/HIPAA and Facets.
- Extensive Healthcare domain knowledge in Member enrollment, Groups, Claim Processing, Claims pricing, Billing and Adjudication, EDI Transactions, Medicare, Medicaid and ICD implementation projects.
- Acquired specialization in analyzing the Functional Specifications, writing detailed test cases, execution of test scenarios, analyzing the actual results against the expected results, creation of test data and analyzing bug tracking reports. Hence gained the experience of complete Testing Cycle. .
- Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
- Experience in Extracting, Transforming and Loading (ETL) data from various data sources (Excel, Flat file, DBs) to XML by using web services.
- Experience on testing Web based and Client/Server Applications, which include various technologies like Oracle Server Database and database testing using TOAD, SQL, PL/SQL.
- Extensive experience in testing of Investment banking, Health care, Finance, Retail and Home loan servicing applications.
- Strong experience in test management tools like Test Director, Quality Center, HPALM, JIRA, Rational Quality Manager
- Good expertise in using SQL*PLUS, WinSQL, TOAD, SQL Server Management Studio.
- Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
- Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
- Experience in debugging the issues using Informatica Workflow manager, Informatica Workflow monitor, Autosys and database.
- Experience in BI Reports testing usingSAS, OBIEE, Cognos, Business Objects andCrystal Reports.
- Always been a quick learner and this experience in IT have made me stronger, confident in taking up challenges and meeting deadlines making me capable to arise with bright colors even under work pressure.
TECHNICAL SKILLS
Operating Systems: UNIX and WINDOWS
Programming Languages: SQL, PL/SQL, JAVA, Unix Shell Scripting
GUI: Toad, WinSQL, SAS Enterprise Manager and SQL Developer, Teradata SQL Assistant
Version Control Tools: VSS, SVN
Tools: & Utilities: Informatica, Datastage, Abinitio, SAS, OBIEE, Cognos, Crystal Reports, Business Objects, SQL*Loader, SQL Server DTS and BCP and Import/Export, Autosys,HP UFT 12
Others: SharePoint, MS Office, MS Visio, MS Project, Visual Source Safe
CASE Tools: ERWIN
Testing Tools: Test Director 7.0, 8.0,HP ALM
PROFESSIONAL EXPERIENCE
Confidential, PA
Sr QA / ETL/ Tester
Responsibilities:
- Closely worked with development team to enhance and standardize the ETL Process to load underlying system that supports UI.
- Hands on experience in Manual/Automation testing of the application on mainframes for claims processing.
- Good experience in working in Agile and Waterfall environments.
- Technical expertise in testing data using ETL tool.
- Tested all HIPAA transactions for multi version support and validating the database to file elements.
- Developing and executes test plans and test scripts, executes planned sequences of test cases and recording test results
- Performed Smoke, Integration, functional, Regression, and system testing.
- Recording the results in Quality center Microsoft test manager tool and Excel sheets.
- Worked collaboratively with BI and ETL resources to design and develop effective solution.
- Worked directly with end users and other developers to define requirements, review design, develop and test assigned components.
- Experience on Decision Support Systems applications, directly responsible for the Extraction, Transformation and Load ETL of data from Legacy Systems using Informatica and testing them.
- Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, and scheduling the Workflows and Sessions in Informatica.
- Monitoring and testing the data load from one database to other and validating the results and generating reports.
- SQL queries were used to retrieve data from tables and to perform back end testing.
- Experience using SQL queries to test the Backend applications and database
Confidential, NY
Sr/QA Tester / EDI & Facets Tester
Responsibilities:
- Interacted with Business users and Technical team in providing clear solutions to requirements.
- Reported the defects to developers using HP ALM
- Involved in testing all back end processes using My Sql
- Presented daily test summary reports (DTSR) and software quality status reports on a regular basis
- Analyzed the Business Specification and created the test plan, test cases for functional and GUI testing
- Categorized the test cases, test data and maintained separate test sets to execute various real time transactions
- Maintaining project schedule for the QA activities by constantly reviewing the project schedule and prioritizing the QA activities
- Actively participated in business meetings and presented the QA progress.
- Coordinated the end to end testing efforts of the HIPAA compliance and EDI transactions.
- Involved in testing HIPAA EDI Transactions and mainly focused on Claims, Provider and Eligibility Transactions.
- Cross-browser testing of all the forms in all the latest versions of browsers including chrome, Mozilla Firefox, Internet Explorer and Safari
- Identify and analysis deep troubling production issues such as Overlapping Enrollment, Complex Business Scenarios with rigorous testing of numerous business scenarios and variations in data
- Web services testing using SoapUI. Performed web services testing and validated XML request/response data using SOAPUI to test the functionality of service like to extract the information.
- Created a secure communication of application test environment with service provider using SoapUI using command line to create key store of certificates.
- Tested the entire Health Information Exchange (HIE) process testing including
- Created automated test scripts using TestNg framework
- Testing of UI screens and automating the test cases using Selenium to automate the user actions and creation of common objects used in multiple screens.
Confidential, NYC, NY
QA/ETL Testing
Responsibilities:
- Extensively used ETL methodology for data extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica.
- Reviewed High Level and Low level Design docs and clarified design solutions with Developers
- Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
- Developed the ETL and BI testing strategy
- Extensively executed SQL queries in order to view successful transactions of data
- Wrote SQL queries to validate source data versus data in the data warehouse
- Identified duplicate records in target tables.
- Promoted Unix/ETL Informatica application releases from development to QA and to UAT environments
- Experienced in writing complex SQL queries for extracting data from multiple tables.
- Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
- Responsible for different Data mapping activities from Source systems to Teradata
- Involved in all walk throws for test designs, data designs and code reviews.
- Developed Test Plan, Test cases & Test Scenarios for new features.
- Updated existing Regression Test cases for impacted features due to new features.
- Tested the Application in UNIX Environment and collecting the Test data from the Business Team
- Identified the Test Environment for Database Testing.
- Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
- Used MySql for Querying the SQL Server database for data validation.
- Writing the test scripts for manual testing.
- Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis
- Executed the Stored procedure when passing the valid/Invalid Parameters.
- Involved in Data migration and Data distribution testing.
- Tested several reports developed using Business Objects.
- Scheduled the ETL jobs and ran jobs using Auto sys and automated the reports
- Analyze the results and log the defects in bug tracking tool.
Confidential, Irvine, CA
QA/ETL Tester
Responsibilities:
- Interacting with Business Analysts & developers to understand business logic & User requirements
- Worked in Agile Test Driven development
- Developed Test Plans, Test Cases & Test Scripts as per functional requirements for Manual Testing
- Extensively involved in gathering Data required by Business/End Users for Testing in UAT Environment.
- Executed test cases manually to verify the expected results worked with technical designers and architects to understand the requirements for a test environment setup
- Experience in using bug tracking tool such as Jira
- Worked on Scrum project, used Quality center test management tool
- Worked on system and data requirement document
- Highly involved logging defects as a subtask for main Jira ticket and interacting with development team in fixing the defect and track them until subtask is closed
- Maintained automated regression test cases in Selenium WebDriver using Java script
- Tested application oniPadandiPhonewhen the operating system was unveiled and also application was enhanced to be compatible with theAndroid devices
- Conducted GUI, Functional, Front end back end testing and reviewed pages for content problems, graphics problems and link verifications
- Created scripts for Regression, GUI and Database testing
- Experience in testing web services using SOAP UI
- Ability to work effectively in both Windows and UNIX environments
- Performed Smoke Testing to make sure all the Test Channels and Test Environment is working as desired
- Good knowledge of SQL for backend testing
- Performed back end testing using SQL queries in Oracle database.
- Ran SQL queries to performed database validation according to the business logic.
- Participated in meetings and walkthrough sessions with cross functional teams to discuss and eliminate defects
Confidential
ETL/ QA Test Engineer
Responsibilities:
- Develop Test plans, Test Strategy, Test Cases & decided on automation when required.
- Involved in the entire project life cycle from analysis, installation, development, testing, production and end user support
- Developed Test Plans, Test Cases, and Test Scripts for UAT tests.
- Used Informatica as an ETL Tool for testing the Data Warehouse.
- Developed Tractability Matrix and Test Coverage reports.
- Managed and conducted System testing, Integration testing, Functional testing, and UAT and Regression testing.
- Loaded data to different databases using SQL scripts to create required test data.
- Used Shell scripts extensively for automation of file manipulation and data loading procedures.
- Execute batch jobs and verify status and data in database tables.
- Tracked the defects using Clear Quest and Quality Center and generated defect summary reports.
- Executed shell scripts to run PL/SQL programs and jobs.
- Executed Informatica sessions and tasks from Informatica workflow manager and validated results from database and informatica workflow monitor.
- Prepared status summary reports with details of executed, passed and failed test cases.
- Validated report layout, data with requirements.
- Validated report security and performance matches SLA.
- Participated in regular project status meetings related to testing