SUMMARY

• Passionate Software Quality Assurance & Quality Control Engineer with 10 years of experience in manual and automated testing of Business Intelligence applications, Databases, Big Data, Data Warehousing, Data marts, Cloud based applications and EMS - Request/Reply (SOAP, REST) & Pub/Sub applications.
• Skilled in Functional testing, GUI testing, System testing, Regression testing, Integration testing, Fail over testing, Ad-hoc, Exploratory testing, End to End testing and User Acceptance Testing.
• Worked in different SDLC projects- Waterfall, Agile-SCRUM, Agile with DevOps
• Experienced in implementing different QA methodologies, policies, strategies and plans in all stages of Software Test Life Cycle to improve the test process.
• Co-ordinated testing efforts and TEMPeffectively managed Off-Shore team.
• Involved in test planning, test strategizing, test co-ordinating and improving the test processes.
• Experienced in using Test Management tools like, HP Quality Center/HP ALM, TFS, Test Rail and JIRA.
• Delivered test artifacts - Test plan, Test estimation, Test scenarios, Test cases, RTM and reports
• Experienced in testing ETL applications developed by Informatica PowerCenter, Oracle Data integrator, SSIS, Ab Initio and Datastage.
• Experienced in using source control tools like GIT, Build tools like Ant/Ivy, Maven & Gradle and triggering builds in Jenkins
• In depth experience in writing SQL queries to create, retrieve and manipulate data in RDBMS
• Experienced in Pythonconcepts like Data Structures, OOPS, File Handling, Functions, Regular Expressions, Exception Handling &PythonSelenium Binding Libraries
• In depth experience in writing HiveQL queries to create, retrieve and manipulate data in Hadoop HDFS file system.
• Experienced in automating Web applications using Selenium Web Driver and performance tests using JMeter.
• Experienced in verifying and validating the distributed data in HDFS cluster.
• Experienced in manual and automated testing of REST end points.
• Experienced in testing Business Intelligence reports - SSRS,OBIEE, MicroStrategy, SAP Business Objects
• Experienced in testing SSAS - cubes, Scorecards and dashboards.
• Experienced in Web services automation

TECHNICAL SKILLS

OS Platform: Windows v7/v8/v10, UNIX, Linux

Scripting Languages: JavaScript, UNIX shell scripts, Python scripts

Programming Languages: SQL,PL/SQL,Java,Python,Hive QL

Databases: Oracle 11g/12c, SQL server 2014/2017, Teradata, PostgreSQL

Business Intelligence Tools: Informatica, Ab Initio, DataStage, ODI, SSIS, SSRS,OBIEE,SAP BO, SSAS

Protocols: TCP/IP,HTTP,HTTPS,SOAP,FTP,SFTP,SSH

Software Tools: SQL developer, TOAD, POSTMAN, SOAP UI, Confidential Office, JMeter, Pycharm, Chrome developer tool, Bit Bucket,Putty

Test Management Tools: JIRA, Test Rail, HP QC/ALM, TFS and Bugzilla

PROFESSIONAL EXPERIENCE

Confidential, California

Sr. Product Integration tester

Responsibilities:

• Prepare Test plan, Test scenarios, Test cases, Test strategy, Test estimation and RTM
• Integration tests of multiple subsystem’s REST/SOAP API using POSTMAN
• Test Restful Web Services using Google ARC, Postman by capturing the service endpoints of the application from Swagger and creating collections of all GET, PUT, POST and DELETE methods.
• Analyze the Business design documents and reported gaps and ambiguity in the requirements.
• Query the back office databases for data accuracy of data retrieved or persisted.
• Perform End to end testing of the software embedded systems.
• Measure test metrics during planning and execution of tests.
• Write Python automation scripts for EIL (Enterprise Integration Lab) for all the test tasks committed for the Agile Sprint.
• Use Pytest framework to display reports in HTML format.
• Perform data quality checks on ETL’ed data
• Perform REST api automation using REST Assured library and integrate the tests into CI/CD pipeline
• Generate reports using TestNG and Extent reports
• Verify the Kafka message flow to the queues and topics
• Validate the NiFi flow from sftp server to ODS tables
• Write UNIX shell scripts to automate the regression test of ETL application
• Test the operational, canned and analytical reports
• Involve in Sprint ceremonies and suggested test improvements
• Document the testing procedures in Confluence on “How to test a xyz”
• Debugged the application errors in database logs and server logs
• Test the Kafka API logging in Graylog by using Apache Lucene queries
• Use the Android studio to simulate the Android applications
• Use GIT to pull the latest changes of the code from STASH, build using Gradle/Ant commands and run a local tomcat instance to test the functionalities incorporated.
• Certify feature branches before it gets merged onto master branch
• Test the IOS/Android app using assortment of OS, browsers and devices
• Tested the Virtual POS transactions for a contactless smart card
• Tested the Account based and card based transactions for a travel app.
• Test the applications integrated in Confidential azure platform
• Responsible for certifying the builds in the QA environment
• Involved in defect triage meetings
• Test the different widgets on a finance and marketing dashboards
• Maintain AGILE principles throughout the testing life cycle.
• Support UAT team by executing the UAT test cases.

Environment: Apache Kafka, Apache Tomcat Server, Python 3.7, Web logic Server, Zookeeper, Embedded systems, Informatica, Oracle, Cloud Computing, Account Based Processor, Contactless Smart card, NFC enabled devices, Open Payment EMV, Virtual point of Sale, Kafka, SAP reports, SQL server, Confidential dynamics CRM, Spring Boot, REST Assured,Maven,TestNG

Confidential, Texas

Sr. Business Analyst

Responsibilities:

• Conducted and facilitated various JAD sessions for multiple iterations withbusinessto gather requirements and perform GAP analysis.
• Conducted walkthrough, demos, preparing Questionnaires, Interview, Brainstorming and presentation of the proposed functionality to stakeholders to filter the requirements.
• Proficient in creating "As-Is" and "To-Be" process flow to determine the process and structure the requirements.
• Established traceability matrix for the current processes and proposed changes.
• Proficient in creating Requirement Specification (SRS) and FRD/FDS capturing Process Flows, Use Case Document, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams.
• Experienced in developing Interactive UI's and Mockups using MS Visio and MS Paint for the proposed functionality describing how varioussystemsand actors will interact will each other and wat different use cases are involved to accomplish goals.
• Coach junioranalystin various aspects like how to identify and write the requirements, creating process flows.
• Assisted Project Manager in Data Analysis, Feasibility Analysis and SWOT Analysis to check the compatibility of the existingsystem infrastructure with newbusinessrequirements.
• Worked closely with the SME's,businessusers and developers, to facilitate and better understand the project.
• Worked with testing team, providing relevant test scenarios for System Testing, Integration Testing, and Implementation Testing and make sure that the testing results meetsbusinessexpectations.
• Conducted User Acceptance Testing and Quality Assurance Testing to support functional and maintenance releases.
• Assisted in writing SQL queries with the team to retrieve desired information.
• Worked withbusinessteam,systems analyst, developers and test team to resolve any follow up and action items.
• Conducted walkthrough sessions withbusiness, developers and test team.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases.

Environment: Waterfall, Java, XML, Balsamiq Mockups 3.2, MS Visio, Web Services, HP ALM, JVM, JSP, Spring, Hibernate, Tomcat Apache, jQuery, Eclipse, MS SharePoint 2013, Informatica PowerCenter, Oracle 11g, SQL Server 2012, MS Project, MS Office Suite (Word, Excel, PowerPoint)

Confidential, North Carolina

Sr. Test Engineer - ETL/Big Data

Responsibilities:

• Analyzed the Business Requirements Document (BRD), Technical Design documents and Data lineage documents.
• Actively participated and Interacted with product management teams in the review and analysis of functional/technical requirements.
• Executed HIVE queries to submit Map Reduce jobs on HDFS cluster
• Validated the data in HIVE external tables and views.
• Created HIVE tables using Partitions and Buckets to increase the performance of the queries
• Tested SSAS cube finance metric calculations against different attributes as per requirements.
• Tested OBIEE finance report fact calculations across multiple dimensions as per requirements.
• Tested the Marketing reports generated by Microstrategy
• Tested the data granularity and data accuracy across dimensions
• Extensively used Oracle SQL queries to validate the data.
• Validated the batch data movement from Source to HIVE
• Validated the data in HIVE tables using Source to target mapping document.
• Tracked bugs in HP ALM and JIRA and assigned it to the respective team.
• Reported the status of the test execution to different stakeholders

Environment: Hadoop, HDFS, Map Reduce, Hive, Squoop, Spark, OBIEE, Google Cloud Platform, JIRA, Oracle 12C, SQL Server, Microstrategy,SSAS, SSIS

Confidential, Texas

QA Analyst

Responsibilities:

• Involved in Sprint planning and estimated test activities.
• Tested the EMS data implemented in REST and Pub/Sub model.
• Automated OPS suite website using Selenium Web driver
• Identified Web elements using ID, Name, Class Name, Xpath, Link text and CSS selector and performed operations using Selenium JAVA with TESTNG framework
• Performed Browser compatibility test.
• Prepared the test data with Positive, Negative, Boundary values and edge case values.
• Tested the SOAP and REST endpoints. Mocked the unavailable service using Javascripts
• Worked closely with the Business Analysts, Developers and DBA team to resolve issues
• Logged the defects in HP ALM and created issues in JIRA
• Reviewed the Test scenarios and test cases with Product owner and Business Analyst
• Supported Business users by executing UAT test cases.
• Participated in QA improvement process and bug triage meetings.
• Certified the software build in the QA environment.

Environment: Agile - Scrum, SOAP, REST, Selenium WebDriver, HP ALM, JIRA, XML, JMS, JavaScript, JSON, Selenium Web Driver, JAVA

Confidential, Virginia

Senior Test Engineer

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Attended Sprint ceremonies.
• Created Test plans, Test scenarios, Test cases, Test data and RTM
• Invoked the Ab Initio graphs using Ksh scripts in UNIX terminal
• Validated the data using Ab Initio commands in UNIX
• Tested the ETL data flow process from Source to staging, staging to data warehouse and finally to datamart
• Created test data files in UNIX with mocked data using VI editor
• Used powerful UNIX commands like Awk, Sed for string manipulation.
• Tested the data correctness, data completion, data transformation, data reconciliation and rejected data
• Validated the data transferred to the upstream and downstream systems.

Environment: Agile-Scrum, Ab initio, Ab Initio Web EME, Oracle, SQL server, UNIX

Confidential, Washington

QA analyst- ETL

Responsibilities:

• Analyzed the Business Requirement Specification Documents, Technical Design documents and Source to Target Mapping Documents and identified the test requirements.
• Interacted with Business Analyst and Product Owners to understand the requirements
• Analyzed the data from the source system to understand the trends, patterns and frequency of the data
• Performed feature testing in AGILE scrum team and used JIRA to track the activities
• Verified and validated the ETL data flow from Legacy Oracle EBS system to Confidential dynamics CRM
• Developed SSIS data validation packages.
• Prepared the high level and low level test scenarios and reviewed with the team.
• Co-ordinated with the offshore counter-part for daily updates and gave KT sessions on the business requirements.
• Responsible for maintaining the test suites and defects in TFS
• Involved in performance testing of the SSIS packages.
• Involved in testing process improvement meetings.