PROFESSIONAL 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

SURESCRIPTS July 2019 – December 2019

Senior ETL Test Analyst

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.

SECURIAN FINANCIAL October 2018 – June 2019

Senior QA Consultant

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.

CARLSON WAGONLIT TRAVEL October 2016 – July 2018

Senior ETL QA Analyst Consultant

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.

SMARTBASE SOLUTIONS June – August 2016

Report Analyst Consultant

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.

DATA RECOGNITION CORPORATION (DRC) December 2015- June 2016

QA Consultant

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

HEALTHPARTNERS August 2013- December 2015

Senior QA Analyst Consultant

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.

MEDTRONIC 1999 - 2013

Senior Software Engineer / Data Warehouse Test Lead (2008 – 2013)

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 (2004 – 2008)

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.

Senior Software Engineer / Software Verification Test Lead (1999 – 2004)

Led verification test team in creating test cases and procedures, test review, and test execution for a wide-area network (WAN) development project.

Responsible for developing testing plans, test supporting documents, and schedules working with project manager, system engineers, and development team members.

Mentored junior engineers regarding requirements, testing, and processes to ensure delivery of product driven by patient safety.

EDUCATION

University of Minnesota – Twin Cities, Institute of Technology

Bachelor of Electrical Engineering

Kerala University, India

Master of Science in Physics

Training courses from Center for Professional Development @ ITT Technical Institute, formerly known as Benchmark Learning

Querying Microsoft SQL Server 2012– taken September 2014

Developing Microsoft SQL Server 2012 Databases – taken September 2014

Implementing a Data Warehouse with MS SQL Server – taken April 2015

Implementing Data Models and Reports with MS SQL Server – taken June 2015

Designing Self-Service Business Intelligence and Big Data Solutions – taken September 2015

VOLUNTEER ACTIVITIES /AWARDS

Served as a presenter with the Medtronic Masterminds science education outreach program in 2003

Recognized as Medtronic Star of Excellence in 2004

VP of Education and VP of Membership in the Medtronic Toast Masters club – 2009 to 2011

VP of Membership in the HealthPartners Toast Masters club – Present

Served as Medtronic Exploring Post advisor from 2004 to 2013

Held a volunteer position as the President of Community Women’s Forum from 2009 to 2011

Coached 5th and 6th grade math team, leading one of them to first place in the regional competitions

Promoted and organized many community cultural programs

Active member in various church women ministries

Contact this candidate