SUMMARY:

• 9+ years of experience in Manual Testing, ETL Testing and Automation using QTP/UFT, Selenium and Robot Framework.
• Involved in functional testing and non - functional testing.
• Well acquainted with the SDLC and STLC.
• Experience in Agile (scrum) and waterfall project methodologies.
• Strong experience with JIRA and Version one as part of working with Sprint stories.
• Strong working experience with Amazon web Services (AWS), S3 buckets and data pipeline.
• Experienced in ETL testing with Informatica, Data stage, Talend (Bigdata tool)
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact, and Dimension tables in Target D/W.
• Experienced in developing Automation Scripts for Generic and Application Specific functionality on leading tools like ALM/QC, UFT/QTP using frameworks like Keyword, Data Driven and Hybrid Automation testing frameworks
• Experience in working with Selenium IDE and Selenium Web Driver using Test NG Framework.
• Experience in working with Selenium Web Driver using BDD Framework.
• Experienced in analyzing business requirements, identify test scenarios & test cases, execute tests, verify results and reporting issues performing various types of testing like Smoke, Integration, Data migration and conversion, Regression, Functional and System testing, API testing.
• Experience in creating CI/CD pipeline through Jenkins.
• Worked on web services testing using SOAPUI tool and Robot Framework.
• Experience in working with web technologies like HTML, CSS, JavaScript, AJAX, JSP, Servlets
• Experience in applications design and development using client/Server and 3-tier architecture.
• Experienced in writing complex SQL Queries and working with RDBMS like Oracle, Cassandra, Redshift, Salesforce, and MySQL.
• Well versed with Reporting Mechanism’s (Daily/Weekly/Monthly Status Reports) to Project Stakeholders.

TECHNICAL SKILLS:

Operating System: Windows 7/NT/2000/XP, Linux, Unix, DOS, IOS,Android, IPod

Programming Languages: Java/J2EE, Java Script, VB Script, Python and SQL

UI Technologies: HTML, CSS, JavaScript, JQuery, Ajax, JSON

Testing Tools: QTP 10.0/11.0, UFT 11.5, QC, ALM 11.5, Selenium (Selenium IDE, Selenium web driver, Selenium Grid), SOAPUI, Cucumber, BDD, Test Link, Bugzilla, Query surge, Apache Spark

Web Services technologies: SOAP, WSDL, Restful Services, Apache Axis2.0/CXF, Jersey Framework

XML Technologies: XML, XSLT, DOM, SAX, DTD, XML Schema, X Path

Databases & ETL Tools: Oracle 11g, DB2, My SQL, Cassandra, Redshift, Dynamo DB, Salesforce, Informatica, Data Stage, Talend(Big data), Microsoft SQL server, IBM Data Studio

Version Control tools: PVCS, CVS, SVN

Packages: MS Office, MS Project, MS Visio

Other tools / Utilities: Team Foundation Server, JIRA, Version One, Microsoft Visual Studio, Microsoft Test Manager, Eclipse IDE, Apache Tomcat Server, Maven, SVN, Jenkins, HP Service Manager, UML, AWS Cloud, Data Pipeline, S3

PROFESSIONAL EXPERIENCE:

Test Analyst Test Automation

Confidential

Responsibilities:

• Involved in Web services testing using SOAPUI
• Design and development of test planning, test specification, test automation framework.
• Created functional testing automation scripts for all the modules in Selenium Web Driver using Java and BDD framework.
• Identifying end to end scenarios and code modularity.
• Involved in creation of Jenkins job to run Automation Scripts.
• Involved in CI/CD pipeline creation for BCRM and BCG.
• Cross Browser Testing (Executing test cases against various browsers like Mozilla Firefox, Google chrome, IE and Safari etc…).
• Parallel Test Execution.
• Maintain Code versions through GIT.
• Bug Reporting and Tracking through Version One.
• Well-versed with Agile-Scrum methodologies and involved in daily scrum calls, sprint planning, sprint review and backlog grooming session meetings.

Environment: Java Web services, SOAPUI, Jenkins, Github,Admin7,Splunk,Websphere, SQL, FileZilla, IBM Mainframe, Linux, XML, Python

Confidential

Sr.QA Analyst

Responsibilities:

• Involved in Web services testing using SOAPUI tool and Robot Framework.
• Design and development of test planning, test specification, test automation framework.
• Used Selenium WebDriver, Eclipse, to create automation regression suite for downloading and uploading S3 folder in AWS.
• Created functional testing automation scripts for all the modules in Selenium WebDriver using Java and TestNG framework.
• Responsible for implementation of Hybrid Test Automation Framework build using Data driven and Modular.
• Involved in the review of Requirements with business analysts and technical specialists.
• Involved in Test Planning, writing Test Scenarios and various other quality-tracking reports.
• Involved in writing and executing the test cases.
• Executed the test scenarios for the detailed reports and implemented the testing scripts
• Involved in writing of SQL (Oracle) for database verification checks and validations.
• Executing the Regression scripts and sending Test Summary Reports to client on daily basis.
• Writing and maintaining bugs and test cases in JIRA.
• Well-versed with Agile-Scrum methodologies and involved in daily scrum calls, sprint planning, sprint review and backlog grooming session meetings.
• Involved in Migration of redshift data into Salesforce using Talend ETL tool.
• Created data migration check list and field mapping document.
• Involved in various user stories and worked with development team to test in various sandbox environments and update fields in Production.
• Periodic data load into various Configuration only and Developer Sandboxes after refreshes, using Talend.
• Extracting data from Redshift and staging in s3 of AWS and load it into Salesforce by using bulk exit in Talend and error records load into s3.
• Facilitate System, Regression, and User Acceptance Testing.
• Created and executed detail function test scripts and Test cases based on the business requirements.
• Incremental testing of Enterprise Data Warehouse.
• Responsible for Data Mapping testing by writing SQL Queries.
• Validating fields present in the reports are as agreed in specifications.
• Involved in validating Design Standard Rollup/filter/dedupe process for SQL or ETL for different clients like BCBSAL, BCBSMN, ANTHEM, HIGHMARK, HEALTHFIRST and HAP etc.
• Determined testing scope and prioritized deliverables in different phases.
• Tested ETL process for both before data validation and after data validation process.
• Involved in preparation of test strategy document, requirement traceability matrix and test scenarios and test cases in JIRA.
• Involved in production deployment post validation process.
• Involved in meeting with third party clients during testing.

Environment: Selenium Web Driver, Java, Test NG, SOAPUI, Cassandra, Amazon Redshift, AWS cloud, S3, Data pipeline, Salesforce, ETL tool Talend, Python, Jira.

Confidential, Chicago, IL

Sr. QA Tester

Responsibilities:

• Involved in the review of Requirements with business analysts and technical specialists.
• Involved in Test Planning, writing Test Scenarios and various other quality-tracking reports.
• Involved in writing and executing the test cases.
• Executed the test scenarios for the detailed reports and implemented the testing scripts
• Used Team Foundation Server for creating test cases, tracking defects.
• Used Selenium WebDriver, Eclipse, Maven, SVN, Jenkins to create automation regression suite.
• Created functional testing automation scripts for all the modules in Selenium WebDriver using Java and TestNG framework.
• Responsible for implementation of Hybrid Test Automation Framework build using Data driven and Modular.
• Expertise in Manual Testing/mobile application testing Blackberry, Android Mobile applications.
• Experience in hybrid apps and mobile apps on iOS, iPod and Android devices.
• Exported Test Case Scripts (Java-Selenium) in Eclipse IDE and modified the selenium scripts and executed.
• Knowledge of SQL (Oracle) for database verification checks and validations.
• Executing the Regression scripts and sending Test Summary Reports to client on daily basis.
• Writing and maintaining bugs and test cases in JIRA.
• Involved in defect review meeting, Tracking & Maintaining Defects and testing the fixes.
• Well-versed with Agile-Scrum methodologies and involved in creating daily burn down charts.

Environment: Selenium WebDriver, Java, TestNG, Maven, Tortoise SVN, Jenkins, Eclipse, JIRA, Mozilla Firefox, Chrome, Internet Explorer, Firebug, Fire path.

Confidential, Chicago, IL

Sr. QA Tester

Responsibilities:

• Understand & analyze the functional requirements.
• Discussion with the SME’s and Business on the requirements clarifications.
• Involved in Test Case design.
• Tested user interface and navigation controls of the application using Quick Test Pro.
• Developed Business Cases as needed
• Writing Test Plans/Test Scenarios/Test Cases/Test Matrix.
• These metrics will be delivered to the Information Management team monthly so that they can deliver a quarterly report on the overarching results of the Members Know.
• Prepared the Test Results Report and Test Closure Report.
• Created Host Claims in Medical Claim Processing (camps) and Hospital Claim
• Coordinating with onsite team on the issues.
• Involved in System Testing and Integration testing for the applications NMR, NWA (Inbox), GIN and RQS.
• Involved in Database testing.
• Coordinate with offshore team on various applications.
• Preparation of daily & weekly status report.

Environment: Java, Windows XP, DB2, QTP, Oracle, TOAD, UNIX, Web applications, QC.

Confidential, AZ

QA Tester

Responsibilities:

• Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis, and Loading process of collected data.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end & performed end-to-end testing.
• Tested Web Services using testing standards like validating XML, WSDL and Soap UI.
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter, and Union to develop robust mappings in the Informatica Designer.
• Prepare estimations for all the projects.
• Documenting and reporting defects
• Provide estimated testing level of efforts, duration, and dependence in support of project planning and scheduling
• Coordinating with client team to discuss on project related action items
• Reporting metrics/status reports for Test Execution phase on daily/weekly basis (Test Management Office)
• Used Test Director to track and report system defects and bug fixes.
• Created Test input requirements and prepared the test data for data driven testing.
• Involved in developing detailed Test plan, Test cases and test scripts using Mercury Test Director for Functional and Regression Testing.
• Performed Database testing (Data Warehouse / ETL) on ETL applications validating
• Conduct defect review meetings.
• Utilized my knowledge of middleware software to finalize the system architecture in terms of the interface protocols for the product.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Assignment, Timer, and Scheduling of the workflow.

Environment: Informatica9.1, Oracle 10g, DB2, Windows 2003 Server, AIX, Erwin, Web Services, XML, QC, QTP, Java 2.0, JSP, Servlets

Confidential, Charlotte, USA

Test Engineer

Responsibilities:

• Preparation and Execution of Manual Test Cases.
• Involved in writing test cases using MQC based on the requirements
• Conducted GUI testing, System testing, Regression Testing, Security, and Adhoc Testing.
• Preparation of Defect Profile Document.
• Designed Test cases, test plan creation and Companion Guide development from stage to production, including both internal and external requirements
• Tested and delivered Inbound/Outbound Facets interfaces
• Used Quality Center Checker Diagnostic, a tool to test many of the QC components.
• Reporting to Test Lead about the task completed on a weekly basis
• Managed Financial Processing that served as primary lead for corporate financial systems, including accounting processes for accounts receivable and accounts payable systems.
• Manage financial spreadsheets and vendor accounts. Spearhead collection processes and manage accounts receivable personnel
• Designed Test cases, test plan creation and Companion Guide development from stage to production, including both internal and external requirements Set up test environment
• Involved in writing test cases using MQC based on the requirements
• Unit testing documentation developed using Excel. Artifacts were created and listed for UAT validation. Writing/validating Use Case Documents
• Perform end to end testing
• Reporting Defects in Test Director on testing the application.

Environment: Java, DB2, Oracle 11i/10g, Flat files, TOAD, SQL Server, Manual Testing, Test Director.

Confidential, Cincinnati, OH

QA ETL Tester

Responsibilities:

• Involved in meeting with business to gather, Designed the target load process based on the requirement documents.
• Provide technical leadership to other support team members and resolution of technical issues
• Optimized the performance using Informatica performance concepts.
• Developed/Updated/Modified automated QTP scripts for functional and regression testing
• Extensively used QTP Data driver wizard for data base testing.
• Responsible for System, Functional and user acceptance testing (UAT).
• Responsibilities include creating the sessions and scheduling the sessions.
• Recovering the failed Sessions and Batches.
• Involved in the Testing of ITS Claims - Creating SF’s (Diamond) and DF’s (Mainframe).
• Test cases will be developed based on the requirements supplied then scripts will be written to execute the testing steps.
• Involving in extracting the data from Oracle and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings, and sessions to improve performance Understanding the Functional Requirements.
• Developing, Testing, and debugging the mappings in Informatica.
• Support project planning efforts by providing inputs to and estimates for project schedules, scope, and resource requirements.
• Maintained test logs and test summary reports. Performed XML document validation and developed UNIX Shell scripts
• Data validation testing.
• Responsible for GUI Testing, System Testing, Regression Testing, and Acceptance Testing.
• Preparing the documents for test data loading.

Environment: Informatica Power Center 9.1, Oracle 10g, PL/SQL, TOAD, Flat Files, Unix