SUMMARY

• Senior QA Analyst/ETL Test Professional with expertise in all aspects of verification and validation including hardware, firmware, software, web & mobile applications, web services, and data warehousing.
• Effective team member with strong problem solving and analytical skills who works collaboratively with Business Analysts, Architects, Project Managers and Developers to complete testing.
• 15+ years of experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution. In depth grasp of software capabilities, consistent application of software systems and effective writing of SQL queries.
• 4+ years of experience in developing SQL queries in both Microsoft and Oracle environments to validate ETL and Reporting data from multiple sources into Data warehouse and validate the data flow in Source, Staging, Data warehouse, and Data marts.
• 3+ years of experience in testing Web/Mobile applications, XML, and Web Services.
• Well - versed in Waterfall and Agile Software Development methodologies.
• Focused on Functionality testing, Integration / System testing, Regression testing, User Acceptance testing, E2E testing, with interest in both manual and automation methods.
• Passionate about Software Quality. Inquisitive, organized, detail-oriented, team player.

TECHNICAL SKILLS

Software/Applications: MS SQL, HTML, C++, C, Visual Basic, AutoCAD, Word, Excel, Lab VIEW

Data Management/Reporting Tools: SQL Server Integration Services (SSIS), TOAD, Rational Requisite Pro, Cucumber / Eclipse, DOORS, Quality Center, Tableau, Informatica

Database/Operating Systems/Devices: Oracle, Microsoft SQL Server 2008 R2, Hadoop, Windows 95/98/NT/2000/XP, Linux, Mac, Android, iPad, Chrome Book

Web Browsers: Internet Explorer, Firefox, Chrome, and Safari

Documentation and Tools: Agile, Kanban,Waterfall SDLC, HP Quality Center, Documentum, JIRA, Rally, TFS, Beyond Compare, DBbVisualizer, Business Objects, Test Fairy, Meraki, Google hangout, Hip Chat

Automation Tools: Postman, Cucumber, Datastage

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Test Analyst

Responsibilities:

• Responsible for validating source to target data load from Salesforce, Hadoop, Oracle source systems using Datastage to Landing and Foundation data warehouse tables. ’
• Perform requirements analysis, formulate test coverage, write test cases, execute system, regression, and integrated tests for data across multiple environments as changes are promoted and staged for production.
• Support the automated test efforts within the agile team by developing complex SQL scripts and identifying manual tests to be included in automated test suite.
• Use Apex as ETL job scheduling tool to schedule datastage jobs for specific dates as required during the QA validation.
• Create and run Adhoc Salesforce reports to generate source data for comparison against target data.
• Perform load testing/validations by connecting to Load Test (Pre-Prod) environment using SecureVDI.
• Compare data from Hadoop to Oracle database using DbVisualizer to connect to and query Hadoop database views.
• Collaborate within an agile team providing input for product backlog, sprint planning, story development and testing, demos, team retrospective, and test report documentation using Kanban board using JIRA.

Confidential

Senior QA Consultant

Responsibilities:

• Responsible for validating java-based web pages and services for a variety of systems through API testing and UI testing
• Design and development of test planning, test specification, test automation framework for API endpoint testing using Postman tool which reduces test execution time thereby decreases project release time to market.
• Review business requirements and major enhancements for the group insurance Application and develop tests and execute them
• Work with Business and product management teams for review of Business Requirements, Functional Specification and Technical Design Documents
• Coordinate and perform requirement reviews and scenario design per established software process working closely with development team to help discover and fix bugs early in the test process within 2 weeks sprint agile environment.

Confidential

Senior ETL QA Analyst Consultant

Responsibilities:

• Responsible for coordinating testing activities and optimizing test cycles working with development team for validating client Data Warehouse application including requirements review, scope create, test case development, test execution and test report generation in 3 weeks sprint agile environment.
• Responsible for performing QA on the load of data into the data warehouse system from external sources (XML files, CSV/EXCEL, OLTP DB).
• Performed manipulation of data loaded via Informatica tool within the warehouse whether that is calculation in the warehouse schema or movement from the warehouse to the mart schema.
• Independently perform analysis on requirements and constructing complex SQL statements that mathematically prove the correct implementation of the required calculation or data movement / manipulation as specified in the story.
• Validate new data warehouse data match with that of Legacy reporting system.
• Record test cases in the test management tool, Rally, and retrieve all test SQL code and results in the SVN repository.

Confidential

Report Analyst Consultant

Responsibilities:

• Took a short project with a startup company to support the business manager to develop business solutions on cloud-based infrastructure.
• Built and prototype workbooks and dashboards using Tableau desktop to provide business insights that can be presented to clients for feedback.
• Developed rich interactive visualizations integrating various reporting components from multiple data sources like excel and data warehouse.
• Worked as part of a project team to verify client server software applications across different software platforms to support a proven, powerful, and secure online testing system that enhances the testing experience for students and educators.
• Responsible for independently reviewing business rules to identify and execute test cases to ensure that technical, functional requirements are being met throughout the SDLC.
• Performed test data validation using SQL queries to ensure student responses were stored in the databases accurately.
• Verified complex business rules of various client configurations and validate data across various mobile devices and platforms including Windows, Chrome book, Android, iPad, Linux, Mac
• Participated in pre-release smoke testing and production testing

Confidential

Senior QA Analyst Consultant

Responsibilities:

• Responsible for test scenario and test data development and test execution in a 2 weeks sprint in the agile environment. Developed automated tests by creating feature files to verify test code written in Java using Cucumber tool
• Responsible for developing and executing test cases to verify functionality of web services applications in compliance with privacy, security, and healthcare requirements.
• Worked very closely with business analyst, and development team on a daily basis to complete given tasks on time in agile methodology.
• Responsible in performing functional, integration, and regression testing of features under test. Collaborated with developers in automating functional test cases using BDD tool, Cucumber.

Confidential

Senior Software Engineer / Data Warehouse Test Lead

Responsibilities:

• Led verification and validation of software/system requirements for the Data Warehouse, Data Marts and Reporting products and services . Written Complex SQL queries to validate the ETL data flow and PDF reports.
• Responsible for testing Extraction, Transformation and Load (ETL) of data from Legacy systems using MS SQL Server Integration Services (SSIS).
• Developed and debugged SQL queries to validate data completeness, correctness, Data Transformation and Data Quality testing
• Tested Business Intelligence reports generated by Business Objects, verifying the output data of the reports against data warehouse.
• Extensive experience in defect identification, tracking, and reporting using Software Change Request (SCR) system.
• Supported system engineers in creating complete and testable requirements by reviewing requirements and communicating feedback in 1:1 and team environment.
• Proposed and created best practice documents to bring increase efficiency and consistency in test process among development and test team members.
• Expert in multiple phases of a Project Life Cycle, including Requirement gathering, Analysis, Testing, Software quality standards, change management and Quality procedures

Senior Software Engineer / Web Application Test Lead

Confidential

Responsibilities:

• Performed test functions of test design, implementation, review, and execution for a front-end web application project.
• Played key role in testing the front and back-end processes of web-based application data collected via a remote patient monitoring system using functional, regression, integration, and system testing.
• Led test development, reviews, dry run, and formal run resulting in consistent and timely release of projects to the market
• Executed automated and manual test scripts and test procedures during functional, system, integration, ad hoc testing, end to end, regression, and user acceptance testing phases
• Performed White box / Black box and GUI interfaces testing.
• Owned software features for verification and worked closely with system engineers and development team to generate testable and complete software requirements.
• Created many “best practice” documents to improve efficiency and consistency in test processes among team members.