PROFESSIONAL SUMMARY:

• Over 9 years of experience in Software Quality Assurance, Testing and Automation specializing in Client/Server, Database, ETL/Data Warehouse/Reporting and Web based applications on Windows and Unix/Solaris/Linux Platforms.
• Experience with all phases of Project Life Cycle including requirement gathering, analysis, design, development, implementation, testing.
• Experience in working with end users in developing various test scenarios and test cases for UAT.
• Experience in testing BIG Data (Hadoop/HDFS) in a range of big data architecture and frameworks including (Hadoop ecosystem, java, MapReduce, pig, hive, hue, sqoop, Fluid query, Spark etc.)
• Excellent knowledge with distributed storages (HDFS) and distributed processing (Map reduce, Yarn).
• Knowledge in Intelligent Automation using UI path to increase speed, quality and efficiency of business process.
• Complete understanding of QA methodologies and Waterfall, Agile Scrum and RUP methodologies.
• Strong experience in performing different kinds of testing like Black box testing, White box testing, Functionality testing, GUI testing, Unit testing, Integration testing, Backend testing, Performance testing, Load testing, Facet testing, End to End, Stress testing, Regression testing.
• Experience in working with open source tools Selenium (Selenium IDE, Selenium Web Driver), JUnit, Eclipse and preparation of automation test framework.
• Worked on different automation frameworks using various languages like Ruby, Junit, C# and Capyberra.
• Worked on Informatica, Qlikview, Microstrategy Developer, Microstrategy Integrity manager, Microstrategy Web and Guidewire policy center, Claims center and Billing center, Talend, Cyberlife applications.
• Worked on Mule,Java, .NET, Linux, Unix, Verizon, Amazon, Liferay, IBM WebSphere and Oracle Applications environments.
• Excellent Understanding of Service Oriented Architecture (SOA) on ESB.
• Hands - on experience on JAVA programming and tools like - Selenium and SOAP UI.
• Work experience in JSP, Servlets, JAXB, Hibernate, Struts, JSTL, spring, POI, Jasper Reports, etc.
• Hands on experience in Keyword Driven, Data Driven Automation Frameworks.
• Experience with EDI HIPAA 270, 271, 276, 277, 837 and 835 Transactions.
• Strong experience working with ETL Data warehouse implementation and complex SQL queries.
• Strong experience in working with HP/ALM, Quality Center and QTP.
• Strong working knowledge of Team Foundation Server (TFS), Confluence, JIRA, Test rail and Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
• Experience performing Security, Compatibility and Heavy load website testing including performance validation and Load testing.
• Experience
• Strong Experience in writing test plan, traceability matrices, test scenarios and test cases.
• Expertise in providing Team QA estimates, facilitating daily status meetings and status report communication with PMO.
• Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems.
• Effective leadership skills with good written, verbal communication and presentation skills.

TECHNICAL SKILLS:

Platforms: UNIX, LINUX and Windows 7, XP, 2000, NT, 98, 95, MAC iOS, AndroidBI/ETL Tools: Informatica, Crystal Reports, Cognos, MicroStrategy, Business Objects, QlikView

RDBMS: Oracle, SQL Server, DB2, TOAD

Languages: C, C++, Java, J2EE, ASP.Net, VB.Net, C# .Net, SQL, PL/SQL, HTML, XML, Unix Shell Scripting, JAVA Script

RPA: UI path

Testing Tools: HP Quality Center 11.0, HP Quick Test Pro 11.0, Load Runner,JMeter, SOATest, SoapUI, Tools Selenium (Selenium IDE, Java Script,Appium, Jmeter,MS office tools, Eclipse, Pycharm, AutoIT

Testing framework: Robot Automation Framework, Junit, TestNG

Test management: Testrail, JIRA, Bugzilla,Sharepoint, Rally, Quality center, confluence

GUI: Visual Basic 6.0

Web Technologies: HTML, XML, XSD, WSDL

Devops Tools: GIT,SVN, Jenkins, Maven

Test Methodologies: Waterfall, Agile, Kanban

Domain Knowledge: Life insurance, Auto Insurance, Health insurance, ecommerce, Telematics,Healthcare, Banking, and Finance

PROFESSIONAL EXPERIENCE:

Confidential, Aliso Viejo, CA

QA Lead/Automation Engineer

Responsibilities:

• Analyze business, technical design specification, Business/Information requirements, mapping documents and developing test plans, test cases and test scripts, test results and reporting defects.
• Leading the QA team and coordinating testing activities.
• Defining project testing strategy, providing test LOE’s, developing test scenarios / cases,report test status.
• Develops and administers QA Schedules and monitors performance against the schedules.
• Mentoring and motivate other team members in QA best practice.
• Ensuring excellent communication and collaboration between all internal and external teams
• Work on finding defects in upstream applications, Data Centric Life cycle and end-user reports.
• Prepare automation test plan using Robot framework to prepare bulk test data and to perform report testing
• Create test cases (Functional, Smoke and regression testing) and automation test scripts for the application under test.
• Utilize Robot framework, Selenium2webdriver, AutoIT, Pycharm and other technologies to automate web,API, XML, Desktop apps.
• Utilize GIT version control for effective source control of test automation scripts.
• Utilize Jenkins CI/CD model for effective delivery of applications.
• Preparation of test environment and taking baseline of data prior to start testing.
• Cross team interaction for the Integration testing as well test data preparation.
• Running DB scripts for any data structural changes before loading the loads.
• Running the workflows to load data from Source to target through Informatica power center workflow manager
• Monitoring the loads using Informatica power center workflow manager
• Verifying the parameterization of the mappings by checking the parameter file in Linux server
• Verifying the ETL process, data loads to Oracle database is successful as per business logic
• Verifying the load statistics and checking the source to target counts
• Verifying the functional changes to the DCLC by performing both functional, Integration and regression testing
• Create test cases to validate the new test data flow from WAVES app>Staging>Base>Datamart>reports
• Handover test scenarios to developers for unit test before migrating to QA
• Verify the Data flow, data Transformation logic from source to target works as expected
• Verify Database structural changes if any, DB fields and field data is loaded without any truncation
• Verify the Load logic (ex: full vs incremental), success of informatica loads (jobs/tasks)
• Verify the DCLC to Qlikview attribute mapping, Qlikview metric attribute relationship
• Perform Data validation like - Valid values, null value check, duplicate check, blank record check, and? checks
• Verify the data integrity and performing Referential Integrity Checks for keys and IDs
• Performed Backend Testing, by executing complex SQL queries through SQL server management studio
• Handover QA test scripts and test results to Business Analyst as part of QA hand-off
• Transformations testing in App>STG>Base>Datamart by writing SQL queries.
• Worked on various JAVA and .NET based web applications- UI, Functional testing, System testing, Integration testing, End to End testing and User Acceptance Testing (UAT) and production support
• Tested Integration Web Services and Application Integration with EDW as well the reports
• Tested the data in various upstream, downstream system files that were critical for business operations
• Maintaining Test plan, Test execution, test scripts, test cases, defect report from JIRA and Test Summary reports and participated in Daily Stand ups, Inter/Intra QA meeting, defect review Meetings.
• Validating Qlikview reports that are generated based on Database using Qlikview which is one of BI analytics tool
• Validating Quarterly/Weekly/monthly /Yearly Qlikview reports against the Vital business reports as QA exit criteria
• Automating desktop apps using integration of AutoIT and Robot framework (Selenium webdriver)
• Using Sauselabs integration for automation of web apps on multiple OS and browsers.
• Involved in POC phase of RPA business process automation using UI path.
• Hands on experience in testing and comparing with large data bases and files.

Environment: Informatica, Qlikview, Robot framework, SQL server management Studio, UNIX, JIRA, Testrail, SQL, WinScp, XML

Confidential, Brea, CA

Sr. QA Analyst/Automation Engineer

Responsibilities:

• Analyze business, technical design specification, BRD, mapping documents and developing test plans, test cases and test scripts, test results and reporting defects using Quality center
• Work as Business Systems Analyst in designing the FRD on analyzing the original FRD’s from guidewire application team and prepared Data mapping documents for EDW.
• Work on finding defects in upstream applications, report center, EDW and end-user reports.
• Prepare automation test plan using Microstrategy integrity manager to test bulk reports to perform multiple iterations of testing
• Prepare regression framework to re-use and improve the turn-around time of testing.
• Cross team interaction for the Integration testing as well test data preparation.
• Running DB scripts for any data structural changes before loading the loads.
• Running the workflows to load data from Source to target through Informatica power center workflow manager
• Monitoring the loads using Informatica power center workflow manager
• Verifying the parameterization of the mappings by checking the parameter file in Linux server
• Verifying the ETL process, data loads to Oracle database is successful as per business logic
• Verifying the load statistics and checking the source to target counts
• Verifying data integrity of different Vital measures like- claims, Policies, quotes, Inforce counts, earned premium, written premium, New apps by joining to various dimensionalities
• Verifying the functional changes to the EDW by performing both functional, Integration and regression testing
• Use existing smoke test validation against vital reports for other GW states and also other source systems
• Create test cases and work with Business users to validate Data visualization of CARS facility report/Ranking reports/Dashboards for CARS (Customer Authorized Repairs Service Shop) operations, Supervisors and Reinspects
• Develop test scripts to validate data for each test case
• Verify the Data flow (Data mapping, Counts) from source to target
• Verify the data Transformation logic from source to target works as expected
• Verify the Load logic (ex: full vs incremental), success of informatica loads (jobs/tasks)
• Verify the EDW to MSTR attribute mapping
• Verify the MSTR metric attribute relationship
• Performed Backend Testing, by executing complex SQL queries in Netezza through SQL server management studio, DB visualizer, TOAD
• Worked on various JAVA and .NET based web applications- UI, Functional testing, System testing, Integration testing, End to End testing and User Acceptance Testing (UAT) and production support
• Maintaining Test plan, Test execution, test scripts, test cases, defect report and Test Summary reports and participated in Daily Stand ups, Inter/Intra QA meeting, defect review Meetings.
• Validating Microstrategy reports that are generated based on Database using Microstrategy which is one of BI analytics tool
• Validating Weekly/monthly /Yearly Microstrategy reports against the Vital business reports as an QA exit criterion
• Automation of ETL test process using in-house tool ARF(Automation regression framework) as part of regression testing
• Hands on experience in testing and comparing with large data bases and files.

Environment: Informatica, Microstrategy, Oracle, Netezza, UNIX, ARF, JIRA, Quality center, SQL, Toad, WinScp, XML, Web Services,Hadoop, Hive, Pig, Fluid query, Map Reduce, Sqoop, HDFS

Confidential, Santa Monica, CA

Sr. QA Analyst/Automation Engineer

Responsibilities:

• Analyze business, technical design specification, BRD, mapping documents and developing test plans, test cases and test scripts and reporting defects using JIRA
• Creating test orders for various product lines by choosing product specific offer codes in OMX-GUI
• Preparation of test data for Daily Data Load checks in OMX-GUI and run jobs for successful processing of orders
• Verifying the ETL process, data loads to OBIEE, Oracle database is successful as per business logic
• Validating Cognos Cubes and reports that are generated based on Database using BI Cognos which is one of BI analytics tool
• Validating Weekly production reports against Cubes that are generated based on BI weekly loads
• Involved in Functional testing, System testing, Integration testing, End to End testing and User Acceptance Testing (UAT) and production support
• Running and monitoring daily ETL Informatica test jobs in various QA/Dev/Prod environments
• Testing various daily processing SQL jobs and verifying the results.
• Performed Backend Testing, by executing complex SQL queries in Oracle through SQL server management studio, Oracle SQL developer, TOAD
• Performing ETL/Back end testing on various Batch Processing Modules using SQL queries.
• Creating and executing SQL queries to perform Data Integrity testing.
• Performing data warehouse validation of source to target transformations using SQL queries.
• Wrote source to target SQL queries and validated data in the staging tables, ODS and EDW target warehouse tables.
• Maintaining Test plan, Test execution, test scripts, test cases, defect report and Test Summary reports and participated in Daily Stand ups, Inter/Intra QA meeting, defect review Meetings.

Environment: Informatica, Cognos, VBScript, Oracle, UNIX, Quick Test Professional, JIRA, Oracle, SQL, Toad, WinSql, UNIX, Filezilla, Soap UI, XML, Web Services, Selenium Webdriver.

Confidential, Torrance, CA

Sr.QA Analyst/Automation Engineer

Responsibilities:

• Analyzed software and business requirements documents and created traceability matrix and high-level test scenarios.
• Responsible for creating and executing test plans, test cases, test scripts, test scenarios and test reports for system testing and user acceptance testing.
• Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.
• Verifying the ETL loads of data to BI Oracle database is successful as per business logic
• Testing various daily processing SQL jobs and verifying the results.
• Responsible for deploying web applications in QA environment.
• Performed Backend Testing, by executing complex SQL queries in Oracle through SQL server management studio, Oracle SQL developer.
• Performed extensive Database Testing by writing complex SQL Queries in TOAD, to test different scenarios of the application
• Performing ETL/Back end testing on various Batch Processing Modules using SQL queries.
• Creating and executing SQL queries to perform Data Integrity testing.
• Performing data warehouse validation of source to target transformations using SQL queries.
• Wrote source to target SQL queries and validated data in the staging tables and target warehouse tables.
• Performed load testing using SOAP UI to validate the performance of the web application
• Developed and Executed automated test scripts using Selenium IDE and Webdriver.
• Involved in Automation of Mobile and web Telematics apps using Selenium webdriver /Appium.
• Performance testing is also done to on the apps to check the performance of the apps on multiple user interactions.
• Performance tested using JMeter.
• Regression test cases were automated using Selenium WebDriver.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the testing environment using Selenium.
• Developed automated scripts using QTP to perform functional and regression testing.
• Responsible for creating test data for various applications.
• Created and executed UAT test cases and coordinated with users on change requests.

Environment: Visual Basic, Oracle 10g, DB2, Toad, MS-Word, Ms-Excel, MS-Project, Quality Center, QTP, ETL, Cognos, SoapUI, SOA, XML, Selenium (Junit, JAVA Script), webdriver,, JMeter

Confidential, Quincy, MA

Sr. QA Analyst

Responsibilities:

• Analyzed software and business requirements documents and created traceability matrix and high-level test scenarios.
• Worked on ETL transformations implementation and Cognos reports validation.
• Performing ETL/Back end testing on various Batch Processing Modules using SQL queries
• Responsible for creating and executing test plans, test cases, test scripts, test scenarios and test reports for system testing and user acceptance testing.
• Designed changes to Oracle application (EBS) and its related sub-systems
• Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.
• Performed SCRUM testing to validate the applications using Agile tracking tools.
• Performed Backend Testing, by executing complex SQL queries in Oracle and DB2 databases.
• Responsible for testing XML workflows using Web Services.
• Responsible for creating test data for various applications.
• Validated the integration of SOA Web Service applications using SOAP UI
• Created and executed UAT test cases and coordinated with users on change requests.
• Involved in thorough compatibility testing of the site on different browsers and different OS.
• Interacted with developers, business analysts and the project manager.
• Actively participated in daily defects scrubs, reviews, and walkthroughs.
• Coordinated with the offshore team by assigning them the daily tasks and reviewing their work.
• Provided time and resources estimation to the QA manager regarding new and existing projects.
• Responsible for creating release notes for production.
• Used QC for Test Plan creation, execution, and defect tracking.

Environment: Visual Basic, ASP.Net, XML, Oracle 10g, DB2, Toad, MS-Word, MS-Excel, MS-Project, QTP 11.0, Quality Center 11.0, ETL, Informatica, Cognos, SoapUI, SOA, Selenium webdriver, Selenium (JAVA Script)

Confidential

QA Analyst

Responsibilities:

• Analyzed software and business requirements documents and created traceability matrix and high-level test scenarios.
• Responsible for creating and executing test plans, test cases, test scripts, test scenarios and test reports for system testing and user acceptance testing.
• Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.
• Performed Backend Testing, by executing complex T-SQL queries in Oracle and DB2 databases.
• Tested XML messages using SoapUI.
• Responsible for creating test data for various applications.
• Responsible for writing UAT Test Cases and creating production like realistic test scenarios data.
• Involved in thorough compatibility testing of the site on different browsers and different operating systems.
• Interacted with developers, business analysts and the project manager and used VSTF 2010 to manage the product life cycle.
• Actively participated in daily defects scrubs, reviews, and walkthroughs.
• Implemented smoke tests to validate the Test environment readiness and performed extensive positive and negative scenario testing
• Involved in Functional, Integration, User Acceptance, Compatibility, and Comparison testing.
• Coordinated with the offshore team by assigning them the daily tasks and reviewing their work.
• Provided time and resources estimation to the QA manager regarding new and existing projects.
• Responsible for creating release notes for production.

Environment: Visual Basic, Oracle 10g, DB2, Toad, MS-Word, MS-Excel, MS-Project, Quality Center, QTP, ETL, Informatica.