SUMMARY

• Over 8 Years of experience in Analysis, Design, Development, Testing, Management, and Implementation of various standalone and client - server architecture-based enterprise application software.
• Extensive knowledge in Python, SQL, Java, C, UNIX and Linux.
• Experience with Design, code, debug operations, reporting, data analysis and web applications utilizing Python and Java.
• Involvement in building frameworks and automating complex workflows using Python & Java for Automation.
• Good Command of web services with protocols SOAP, REST.
• Proficient in developing and testing websites and web applications using Python, Django, Flask, HTML, XML, JSON, CSS, Java, SQL & Selenium.
• Good understanding and knowledge of Amazon AWS, S3, EC2, RDS, EMR and VPC.
• Experienced in working with various IDEs like PyCharm, Spyder, Eclipse, IntelliJ and Anaconda.
• Over 6 years of strong experience working on test automation tools, Selenium and QTP.
• Hands on experience in development and execution of QA Test Plans and Test Strategies for both Automated and Manual Testing.
• Experience working in Agile Scrum, Waterfall & V model.
• Profound experience in full life cycle of project and STLC creating Test plan, Test Case and Test Strategy documents.
• Knowledge of Agile Methodology for implementing rapid and high co-ordination environment among Development and QA teams Using TDD and BDD.
• Experience with EDI 834, 835, 837 documents, HL7 and HIPAA 270, 271, Experience creating use case documents and driving UAT Testing along with User Trainings.
• Strong experience in working with HP/ALM, Quality Center, Jira and Version One.
• Experience working on Data Migration, Merger and Acquisition projects involving web-based application testing and backend database testing.
• Experience in GUI, Functional, Regression and Data Driven automation testing of the application using QTP and Win Runner.
• Strong working experience with Keyword Driven Testing, Data Driven Testing frameworks.
• Experience performing code review and creating unit tests using TestNG on applications built in Java and .Net.
• Proficient in Manual and backend Database testing using SQL Queries and PL SQL Scripts.
• Used SQL Queries for data validation/verification Back-End testing in Oracle, SQLserver databases.
• Experienced in validating Web Services implemented in SOA Architecture using SOAPUI.
• Experience in SOAP and REST based web services.
• Proficient in using Unix Shell Scripting for testing and performing backend testing.
• Proficient in using SQL for performing database testing along with white box testing.
• Create Defect Status report for Development Team and Stakeholders on a daily basis.
• Responsible for generating reports using Mercury Quality Center to deliver the End of testing notes to various teams that would help analyzing loopholes.

TECHNICAL SKILLS

Testing Tools: Selenium 2.0, Selenium IDE, Selenium GRID, WebDriver, Appium, Postman, Win Runner, Load Runner, Jmeter, SOAP UI, XML spy, HP Quick Test Pro, Cucumber, Claim Test Pro

Databases, Tools: RDBMS/Database Oracle 10g, SQL Server 2008, SQL Server 2012, MySQL, DB2, MongoDB, MS-Access, SQL Server Management Studio, Oracle SQL Developer, OBI (Oracle Business Intelligence), Quest Toad, DbVisualizer

Scripting Languages: Java Script, VB Script, Shell, Bash, Python Scripting

Software Testing Tools: HP Quick Test Pro 8.0, 9.X, 10.X, 11.X, Selenium Web Driver

Software Methodologies: Agile Scrum, Waterfall, TDD, BDD

IDEs: Spyder, Eclipse, PyCharm, IntelliJ, Anaconda, Informatica, Atom and Sublime Text

Continuous Integration: Jenkins, Bamboo and Bit bucket

Browsers: IE, Firefox, Opera, Chrome, Safari

Defect Tracking Tools: Quality Center, Test Director, Jira, Bugzilla, ALM, Version One

Web Technologies & Tools: HTML, CSS, Java Script, jQuery, XML, JSON, Xpath, Postman, APIs, AWS console

Operating Systems: Unix, Linux, Windows, MAC

Version Control, Build & Deployment: SVN, Git, GitHub, Jenkins, PIP, Maven

Cloud: AWS, S3, EC2, VPC, EMR, RDS

Software Testing: Manual, Automated, Functional, Regression, Smoke, Negative, White-box, Integration, Black-box, TTD, ATDD and UAT

Utilities: UltraEdit, Beyond Compare, Programmer Studio, WinSCP, putty, Appworx, Postman, SOAP UI, XML spy, Notepad++

Unit Tests: Junit, Mockito

Performance Testing: JMeter, Load Runner, Win Runner

Languages: Python, C, C++, Java, J2EE, SQL, PL/SQL, HTML, XML, Jquery

Web Services: SOAP, Rest

Application Servers: Apache Tomcat, WebSphere, GlassFish, RedHat, JBOSS

PROFESSIONAL EXPERIENCE

Automation Engineer/ SDET/ QA Lead

Confidential, MN

Responsibilities:

• Developed automation framework to test the functionality of business-critical applications using Java, Python, SQL, HTTP Client/Server, REST Assured, Maven, PIP, Git, SVN.
• Developed API automation scripts to validate the Request and Response between multiple API’s, both internal and external to the organization using REST Assured, HTTP Client, Java, Python, Spring, Spring boot, Hibernate.
• Developed automated integration test suites to validate the integrations between the applications used internally within the organization and report the metrics regularly.
• Developed automation programs to ingest data from a variety of sources in varying formats. Analyze, process, identify patterns, house data and route it to the appropriate applications and data warehouse based on business rules and logic using Python, Pandas, PySpark, cx Oracle, Jupyter Notebooks, Numpy and SQL.
• Developed Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems.
• Developed and execute detailed ETL related functional, performance, integration and regression test cases, and documentation.
• Performed data analytical testing for the BI systems across multiple data warehouses.
• Performed validation of data transformations and perform End-to-End data validation for ETL & BI systems.
• Performed source to target testing by writing complex SQL queries.
• Interpreted business rules, translated them into system requirements, configured and implemented using standardized BPMN (Business Process Model and Notation) rules engine DROOLS, to achieve desired system functionality.
• Built application to read large volumes of data and scrub and retain the processed/standardized data, apply transformations and business rules in integration with DROOLS (BPMN engine) and persisted the data in database using Python, Pandas, PySpark, Oracle, SQL Server, cx Oracle, Jupyter Notebooks, Numpy.
• Built, tested multiple reports in collaboration with data architects and reporting team using OBI and Crystal reports reporting tools.
• Designed and built multiple test applications for administrative, reporting, monitoring and business user transaction purposes using Python, Django, Flask, APIs, PySpark, SQLAlchemy, Oracle, SQL Server, Java, HTML, CSS, Java Script, jQuery, XML, JSON, Xpath, Spring, Hibernate.
• Evaluated, created, maintained and documented standard procedures to perform system, regression, and performance testing for Client/Server enterprise applications.
• Designed and integrated architecture between automated scripts across multiple new and existing applications.
• Wrote complex SQL queries and scripts to verify data flow and integrity between multiple components and systems using Python, Pandas, Spark, Jupyter Notebooks, Numpy, SQL Developer, Quest Toad and Advanced Query Tool in Oracle and SQL Server databases.
• Edited existing EDI 834, 835 and 837s using UltraEdit and Claim Test Runner to create test data for testing.
• Used Tibco (internal file processor, ETL) to extract the data from the edited EDIs 834, 835 and 837 and load the data into the databases for testing purposes.
• Developed scripts to support other developers and infrastructure team to validate the functionality and performance of the application for environmental (pre/production) upgrades.
• Performed and coordinated multiple types of black-box, white-box, and grey-box testing including functional, system, end to end, data integrity, user acceptance, smoke, regression, and ad-hoc testing on enterprise applications to make sure quality standards and specifications are met.
• Scheduled multiple execution and build jobs on Jenkins & Automic for timely execution of automation scripts and programs.
• Performed regular maintenance of existing automated scripts and making necessary changes to the Java and Python code.
• Reviewed business requirements, stories, system and architectural designs, and continually seek to understand all facets of application development activities for the purpose of providing the most efficient and effective technical based solutions.
• Attended and actively contributed to general scrums, sprint planning, brain storming sessions, technical discussions, status meetings and other project related meeting to ensure continuous timely delivery.

Environment: Python, Pandas, PySpark, cx Oracle, Jupyter Notebooks, Numpy, Java, HTTP Client/Server, REST Assured, Django Rest Framework (DRF), Kafka, Spring, Spring boot, Hibernate, DROOLS (BPMN), Django, Flask, APIs, SQLAlchemy, HTML, CSS, Java, XML, JSON, Xpath, Jenkins, Maven, PIP, Git, SVN, Automic, Agile (Scrum), Jira, Version One, SQL, SQL Developer, Quest Toad, Advanced Query Tool, Oracle, SQL Server, Informatica, OBI, Crystal Reports, Ultra Edit, Notepad++, Beyond Compare, WinSCP, putty, Health Rules.

QA Analyst

Confidential, MN

Responsibilities:

• Worked on test planning, documenting, coordinating, and executing activities related to the testing of Confidential systems, databases and user interfaces.
• Testing included manual and automated test execution for functional, integration, regression, performance testing required to meet the business requirements.
• Performed backend testing using SQL queries in SQL Server Management Studio and Oracle SQL Developer to check backend data and data integrity.
• Worked in a team environment with the business user community, technical teams, and end-users to successfully develop and implement quality changes into production.
• Performed black box testing, database testing, and web-based testing on several test phases. Developed components for each transaction used in the test script or scenario.
• Collaborated with business partners, IT team leads, project leads, business analysts, end users and third-party contacts to design, plan, execute, and validate test scenarios, scripts, and procedures to test system modifications and receive business user acceptance prior to implementation.
• Developed testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, and usability.
• Used Amisys for adjusting, resetting and re-adjudicating claims to test the claims processing and billing processes.
• Edited existing EDI 834, 835 and 837s using UltraEdit and Claim Test Pro to create test data for testing the claims payable process.
• Used Biztalk (internal file processor, ETL) to extract the data from the edited EDIs 834, 835 and 837 and load the data into the databases for testing the claims payable process.
• Used Amisys, SQL Server Management Studio and Oracle SQL Developer for backend data validation after the successful completion of the claims payable process.
• Designed and created automated test scripts and scenarios using Selenium and Java.
• Used Selenium locators like Xpath, CSS Selectors, Fire Bug, Fire path locator and WebDriver to test the web application.
• Identified, analyzed, and documented problems with program function, output, online screens, and content.
• Analyzed WSDL and XML files, and test Web Service through Soap UI.
• Performed Web services and Message testing tasks using SOAP UI tool.
• Used SOAP UI tool on SOA based application to test SOAP services and REST API.
• Performed REST API Testing using Http java Test Client for SOAP/REST web APIs.
• Documented software defects, using Bugzilla, and reported defects to software developers and project managers, leads. Monitored bug resolution efforts and tracked successes.
• Planned test schedules, strategies in accordance with project scope and delivery dates.
• Participated in product design reviews, providing input on functional requirements, product design, schedules and potential risks.
• Reviewed software documentation to ensure technical accuracy, compliance, completeness to mitigate risks.
• Complied with standards and tollgates of the software development life cycle and follow strategies, plans and procedures within IT.
• Contributed to, suggesting and implementing process improvements that accomplished team, department and business goals. Strive for efficiency, consistency and effectiveness.

Environment: Claim Test Pro, Selenium, Java, Amisys, SQL Server, SQL Server Management Studio, Oracle SQL Developer, Windows, Agile Scrum Methodologies,, SOAP, REST, SOAP UI, Postman, XML, JSON, MS-Office, MS-Visio, Ultra Edit, Putty, Programmer Studio, Appworx, JIRA, EDI 834, 835, 837 transactions, Client Custom Reports.