Sr. Data Warehouse/etl Tester Resume
Franklin, TN
PROFESSIONAL SUMMARY:
- 7+ years of experience working as QA Engineer for Software Development (SDLC) and Testing Life Cycle (STLC) including preparation of Test Cases, Test summary reports and good understanding of Test Plans and Test Strategy reports for both Web and Client - Server Applications.
- Highly skilled in creating and executing Manual test cases.
- Proficient in developing Test Cases, Defect tracking and Defect metrics.
- Expertise in various testing methodologies.
- Experience in all types of testing including Functional, Integration, System, Regression, Positive, Negative, Database, Sanity and User Acceptance testing.
- Knowledge in different Databases like MS SQL Server, Oracle.
- Experienced in interfacing with development teams to report bugs and track issues until resolution.
- Experienced in performing Quality Assurance duties in an Agile Project Environment.
- Participated in QA Team meetings and walkthroughs.
- Experience in documenting the testing process using MS-Office tools including Word, Excel and Power Point.
- Extensive Work Experience in Automation Testing, Database Testing and Manual Testing for Applications.
- Experience creating Test Plans, thorough hands on experience with designing test cases covering all test conditions and eliminating redundancy and duplications.
- Responsible for sprint deliverables and In-sprint automation scripts using
- Tested different functions of the POS system like scanning, payments and returns. Moreover, make sure that the system met the requirements and expectations.
- Good experience in integrating Automation scripts.
- Expertise in developing, estimating, documenting, executing test cases manually, and generating automated scripts using Selenium IDE, RC and WebDriver.
- Worked on testing Electronic Data Interchange (EDI) according to HIPPA Compliance.
- Worked on Black Box testing, Database and Backend testing
- Proficient in creating automation script from scratch. Sound knowledge of developing different type of framework like Module driven, Data driven and Hybrid framework.
- Hands on experience in writing SQL Queries, extract data from MS-SQL Server, MySQL, DB2 and Oracle.
- Expert in performing different tests types, QA Methodologies: Black Box, Front-End and Back-End, Stress & Load, Regression, Configuration, Functional, Installation & Integration, Smoke, and User Acceptance Testing
- Experience understanding the code written in different programming languages Java, Python, Java Script and databases like Oracle, SQL Server.
- Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
- Sound knowledge on Object Oriented Programming concept. Extensively used Java for test case automation.
- Experience in both Waterfall (Software Development Life Cycle -SDLC) and Agile Project Environment.
- Developed the Test Cases Client based on Confidential 'S and Business Rules and for Web Client Test Cases based on Use Cases, Wire Frames, Annotated Documents and Business Rules.
- Solid SQL skills, can write complex SQL queries; functions, triggers and stored procedures for Backend testing and End-to-End testing.
- Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment.
- Good analytical and communication skills and ability to work independently with minimal supervision and perform as part of a team.
PROFESSIONAL EXPERIENCE:
Confidential, Franklin, TN
Sr. Data Warehouse/ETL Tester
Responsibilities:
- Actively participated in the SCRUM meetings for daily update and Iteration Planning meetings and Retrospective meetings.
- Performed Static testing of the Stories (requirements) for gaps and coverage by reviewing business and functional requirements and mapping documentation.
- Worked with Stakeholders, Program Managers, Business Analysts and Developers resolve issues with requirements/mapping transformations.
- Assisted in entering and updating Issues (Epics, Stories, and Tasks) into VersionOne Project /Task management tool.
- Analysis of ETL Mappings based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables.
- Analyzing Data Processing implementing Data Mart applications mainly transformation processes using ETL tool and understanding of ETL workflows and ETL mappings and also monitoring the Production Environment.
- Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
- Performed extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds all the way to Target.
- Performed functional testing of large Extract files on Datastage Linux server.
- Performed Regression testing to test the impact of bug fix.
- Extensively used complex SQL queries for data validation and backend testing.
- Created Test Plans and test scripts, documented testing process and defects.
Environment: Oracle / Sql developer, MS Excel,, SQL Server / SQL Server Management Studio, TextPad, Linux, Datastage 8.1, Putty, Winscp, MS Outlook, Microsoft Office.
Confidential, Confidential, TN
Sr. Quality Analyst
Responsibilities:
- Preparing test cases and coordinating with the onsite team.
- As an individual contributor, perform critical testing activities.
- Create and maintain Log of all issues/bugs reported by different team and assign to respective parties.
- Participating in defect review meetings and proactively bringing up issues to get them resolved.
- Updating the status reports and test execution plan.
- Coordinating with offshore team and providing additional information on test execution and defects.
- Communicating with Business Analysts, Developers and Test Leads to decide the scope of testing and ensure proper understanding of requirements is obtained within the team.
- Performing automation validation of regression suite of test cases and reports.
- Providing test support to other Confidential projects.
- Creating RFM packages from RFM application and applying them to the test labs.
- Patch upgrade for various builds in the labs.
- Performing Mobile Offers testing on KIOSK and also on POS.
- Worked on Point of Sale (POS). Functionality of the application and routing process of the business.
- Worked on installing the store Labs.
- Worked on different types of Point of Sale (POS) like Par and Pan.
- Worked on First data credit card processing equipment.
- Tested all transactions using credit cards, Debit cards and Gift cards.
- Worked on Chip Cards Transactions.
- Executing SQL Queries to determine Cashless transactions and to define SAF limits.
Environment: JIRA, MS SQL Server Management Studio, Windows XP, POS (Point of Sale) specific devices - Kiosk, Registers (Front Counter and Drive-Thru) and KVS equipment, IBM RFT, Mobile & HHOT, Pin Entry cashless devices and Mobile devices.
Confidential, Confidential, TN
QA Analyst
Responsibilities:
- Analyzed and reviewed the Software Requirements, Functional Specifications and Design Documents.
- Created test requirements hierarchy to represent the features and functionality that needs to be tested in the application using Mercury Quality Center.
- Managed requirements, test cases and test scripts using Mercury Quality Center.
- Developed Automated Test Cases, using Selenium IDE.
- Extensively worked on performing unit test cases using J-unit.
- Created Keyword-Driven Automated Frameworks using Selenium RC configured under Eclipse J-unit environment.
- Developed J-Unit test cases and test functions for the Customer Management module of the application developed in Java.
- Created and executed the Test plan, Test Cases, Automation Test Scripts, and Test Steps for all the modules and stored in SVN and JIRA.
- GUI testing was done on the Command Center to ensure that the module meets the requirement specifications. Functional testing was performed on the various functionalities of Command Center such as Snap Ticket, Conditional Orders, Market Edge, Market Motion Detector, Pattern Matcher, Quote Scope etc.
- Conducted User Interface, Functional, Integration, UAT, and Regression testing and interacted with developers to resolve the technical issues.
- Used Team Track for bug tracking and followed up with the development team to verify bug fixes and update bug status.
- Worked in team environment to achieve project quality goals.
- Use JIRA in conjunction with HP Quality Center to report defects and monitor progress on defect resolution
- Used Rational Clear Quest to record, report and track defects and worked with development team to resolve defects.
- Involved in preparing timely test reports, status and updated documents.
- Assisted various members of the project team including development, technical and business team.
- Attended design review conference meetings with on - site team.
- Coordinated with beta client team for application configuration issues, defect analysis and timely release of test versions of application.
- Utilized Rational Clear Case for Test Documentation and version control.
- Was responsible for performing Backend testing by using PowerBuilder's data handling objects Data Window to edit and display data from the database and detect anomalies.
- Performed Data - driven test on the database using Quick Test Pro.
- Performed Load testing to check the system behavior and resolved the performance issues using Load Runner.
- Analyzed the performance based on the reports generated.
Environment: Java, J2EE, Jira, JUNIT, HTML, XML, Visual Basic, Oracle 9i, XML, PowerBuilder, Unix, Quality Center, Selenium, Load Runner, PERL.
Confidential, Brentwood, TN
QA Analyst
Responsibilities:
- Work on Confidential EDI 4010/5010 with Confidential -9and Confidential -10, analysis and compliance experience from payers, providers and exchanges perspectives with primary focus on coordination of benefits
- Intensive working on the current Confidential code conversion from Confidential 9 to Confidential 10, assisting and leading various teams by complying with already going works in the health care domain and work with the conversion.
- Involved in testing a claim processing system for the healthcare management client system. It allowed the user to inexpensively capture information regarding patient, summary of medical history, symptoms ( Confidential -10 codes), and treatment (CPT).
- Tested the adjudication of Claims and Migration Process.
- Worked on SSRS.
- Wrote test scripts on the basis of the business requirement documents and designed IT test plan documents.
- Maintained traceability matrix and tracked test scripts and defects through Quality Center.
- Created test plans, test scripts using HP ALM Mercury Quality Center and JIRA.
- Worked on Agile Methodology.
- Worked through all the SIT cycles by strictly adhering to the Release cycle schedule and assisted the business in the UAT validation.
- Coordinated the team in the production validation testing while following the release deadlines.
- Reviewed and gained thorough understanding of all the data models and the process flow diagrams pertaining to each project.
- Demonstrated team spirit and multitasking skills by managing multiple projects and working with multiple team members at the same time.
- Performed integration and regression testing after each build cycles.
- Worked with team lead, test manager, project manager, 3rd party associates and the business to ensure deliverability of the high quality product.
- Worked on UAT with Client providing test cases and defect life cycle.
Environment: Java Springs, .Net, XML, HTML, HP ALM Quality Center 11.0, Excel, Oracle, Microsoft Office, IE, Firefox, Chrome and Safari.
Confidential, Charleston, TN
QA Analyst
Responsibilities:
- Involved in analyzing the business requirements, created and executed test cases.
- Wrote test plan and test cases by going through the design, functional requirements and user (business) requirements documentation.
- Prepared the test data for interpreting the positive/negative/regression results.
- Created and maintained test matrices from available design documents and functional Specifications for product quality assessment.
- Performed automated and manual testing. Automated test case scenarios using QTP.
- Parameterized test scripts for data driven testing in Quick Test Pro.
- Involved in functional, integration, system and regression testing.
- Involved in developing and implementing customized automation framework.
- Involved in developing unit test cases.
- By using quick test pro created scripts by descriptive programming and executed the test cases with per action mode in object repository.
- Enhanced the recorded script by using properties and its values from the object properties. Automated test cases by using various checkpoints and output values.
- Reviewed test cases based on functional requirements and use cases specifications.
- Created recovery scenarios for handling the unexpected error in the application.
- Extensively used SQL to perform data integrity test.
- Worked on Quality Center to track the defect status.
- Experience in documenting test execution results, preparing test reports, and gathering and evaluating test metrics for reporting.
- Conducted system and integration testing, debugged the software errors and interacted with developers to resolve technical issues.
Environment: HTML, VB Script, Java Script, Selenium, ASP, Java, Java Web Start, .NET, XML, COM/DCOM, Web Services, IIS, SQL Server, SQL Navigator, Spotlight, DTS, Load Runner, Win Runner, HP, Test Director, Mercury, Microsoft Excel, Visio 2000, Win tail, Windows NT, Unix, VI editor, Perl, Terminal Services Client, Rumba, DB2, Cyberprise, IBM Client Access, Internet Explorer.