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 wif teh SDLC and STLC.
• Experience in Agile (scrum) and waterfall project methodologies.
• Strong experience wif JIRA and Version one as part of working wif Sprint stories.
• Strong working experience wif Amazon web Services (AWS), S3 buckets and data pipeline.
• Experienced in ETL testing wif Informatica, Data stage, Talend (Bigdata tool)
• Sound Knowledge and experience inMetadata 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 wif Selenium IDE and Selenium Web Driver using Test NG Framework.
• Experience in working wif 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 wif 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 wif RDBMS like Oracle, Cassandra, Redshift, Salesforce, and MySQL.
• Well versed wif 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

Confidential

Test Analyst Test Automation

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 teh 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 throughGIT.
• Bug Reporting and Tracking throughVersion One.
• Well-versed wif 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 teh 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 teh review of Requirements wif business analysts and technical specialists.
• Involved in Test Planning, writing Test Scenarios and various other quality-tracking reports.
• Involved in writing and executing teh test cases.
• Executed teh test scenarios for teh detailed reports and implemented teh testing scripts
• Involved in writing of SQL (Oracle) for database verification checks and validations.
• Executing teh Regression scripts and sending Test Summary Reports to client on daily basis.
• Writing and maintaining bugs and test cases in JIRA.
• Well-versed wif Agile-Scrum methodologies and involved in daily scrum calls, sprint planning, sprint review and backlog grooming session meetings.
• Involved in Migration ofredshift data into Salesforce using Talend ETL tool.
• Created data migration check list and field mapping document.
• Involved in various user stories andworked wif development teamto test in various sandbox environments and update fields in Production.
• Periodicdata loadinto various Configuration only and DeveloperSandboxesafter 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 teh business requirements.
• Incremental testing of EnterpriseData Warehouse.
• Responsible for Data Mapping testing by writing SQL Queries.
• Validating fields present in teh 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 wif 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 teh review of Requirements wif business analysts and technical specialists.
• Involved in Test Planning, writing Test Scenarios and various other quality-tracking reports.
• Involved in writing and executing teh test cases.
• Executed teh test scenarios for teh detailed reports and implemented teh 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 teh 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 teh selenium scripts and executed.
• Knowledge of SQL (Oracle) for database verification checks and validations.
• Executing teh 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 teh fixes.
• Well-versed wif 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 teh functional requirements.
• Discussion wif teh SME’s and Business on teh requirements clarifications.
• Involved in Test Case design.
• Tested user interface and navigation controls of teh 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 teh Information Management team monthly so dat they can deliver a quarterly report on teh overarching results of teh Members Know.
• Prepared teh Test Results Report and Test Closure Report.
• Created Host Claims in Medical Claim Processing (camps) and Hospital Claim
• Coordinating wif onsite team on teh issues.
• Involved in System Testing and Integration testing for teh applications NMR, NWA (Inbox), GIN and RQS.
• Involved in Database testing.
• Coordinate wif offshore team on various applications.
• Preparation of daily & weekly status report.

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

Confidential, Phoenix, AZ

QA Tester

Responsibilities:

• Worked wif Source System Subject Matter Expert (SME) to ensure dat teh 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 teh design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Actively tracking schedule, clear and crisp communications wif key resources, stake holders and SMEs to keep everyone involved in teh project on teh same page, milestone tracking and avoiding scope creep issues
• Used various transformations likeFilter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter, and Unionto develop robust mappings in theInformaticaDesigner.
• Prepare estimations for all teh projects.
• Documenting and reporting defects
• Provide estimated testing level of efforts, duration, and dependence in support of project planning and scheduling
• Coordinating wif 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 teh 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 noledge of middleware software to finalize teh system architecture in terms of teh interface protocols for teh product.
• Worked on different tasks in Workflow Manager likeSessions, Events raise, Event wait, Decision, E-mail, Command, Assignment, Timer,andSchedulingof teh workflow.

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

Confidential, Charlotte

Test Engineer

Responsibilities:

• Preparation and Execution of Manual Test Cases.
• Involved in writing test cases using MQC based on teh 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 teh QC components.
• Reporting to Test Lead about teh task completed on a weekly basis
• Managed Financial Processing dat 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 teh 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 teh 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 wif business to gather, Designed teh target load process based on teh requirement documents.
• Provide technical leadership to other support team members and resolution of technical issues
• Optimized teh performance usingInformaticaperformance concepts.
• Developed/Updated/Modified automatedQTP scriptsfor functional and regression testing
• Extensively usedQTP Data driver wizardfor data base testing.
• Responsible for System, Functional and user acceptance testing (UAT).
• Responsibilities include creating teh sessions and scheduling teh sessions.
• Recovering teh failed Sessions and Batches.
• Involved in teh Testing of ITS Claims - Creating SF’s (Diamond) and DF’s (Mainframe).
• Test cases will be developed based on teh requirements supplied tan scripts will be written to execute teh testing steps.
• Involving in extracting teh data from Oracle and Flat files
• Implemented performance tuning techniques by identifying and resolving teh bottlenecks in source, target, transformations, mappings, and sessions to improve performance Understanding teh Functional Requirements.
• Developing, Testing, and debugging teh mappings inInformatica.
• Support project planning efforts by providing inputs to and estimates for project schedules, scope, and resource requirements.
• Maintained test logs and test summary reports. PerformedXMLdocument validation and developedUNIX Shell scripts
• Data validation testing.
• Responsible for GUI Testing, System Testing, Regression Testing, and Acceptance Testing.
• Preparing teh documents for test data loading.

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