PROFESSIONAL SUMMARY:

• 15 Years of experience in various part of Software Industry such as Quality Assurance Supervisor, Assistant Manager, Test Lead, Data Analyst, System Analyst, Data Quality Assurance and Control, Test Automation development for Frontend web based Application using DevOps concept, Application Integration / Component Level Validation, ETL Validation, Project Migration, identifies high - level business requirements (to-be), Gap Analysis, Black Box, White Box / Unit Testing and Manual Testing.
• 8 years of extensive test management experience. Has sound knowledge in establishing QA process from scratch using various automation integration tools like Jenkins, Gits ets.
• Having great experience in documented as-is and to-be process flows.
• Develop maps and flowcharts of current and future business analysis processes. As a Test Lead, me develop a clear understanding of existing business functions and processes.
• Proficient in user interaction, requirement gathering, user story and story mapping development.
• 7 years of experience in agile methodology and over 6 years of experience in Scrum Master Role.
• 7 years of direct client interaction experience. Able to gather requirement with client independently, benchmark performance and able to handle/analyze any intermittent issues.
• Has been able to identify the core functionality and the crux of the project in a minimal span of time, having about 15 + years of software testing experience and adept technical background has helped me to achieve these goals at all times.
• Facilitated and contributed to discussions surrounding changes to project roadmaps, planning, team composition, and. performance appraisal.
• Run Scrum Meeting, Retrospective, Mid Sprint Review, Standup, Points Grooming, Requirement Analysis.
• Solid analytical, expert judgment and dynamic troubleshooting skills.
• Extensive experience in setting QA process from scratch, has defined SOP for two complex health care application and completed many FDA and HIPPA successful audit over 7 years. (Eversight not for profit organization and Confidential a MTF group).
• Extensive experience in testing webservices using XML and Database techniques.
• Hands on experience in Backend Technical Product Support work. Manage customer support Lookup Data, Transactional Data, SSRS Report, Crystal Report and Procedure fixes on need basis in timely manner.
• Hands on experience in post-production support. Analyze, identify and fix customer support issues, provide accurate details to management with in short period of time.
• Adaptive, Flexible, Independent, Problem Solving, Loyal and Discreet and Strong in Work Ethic.
• Experience in Test Effort Estimation, Preparation of Test Plan, and Test strategy, Roll-up Reports and Release / Sprint Planning.
• Experience in SOA, GUI, A/B, Functional, Sanity, Adhoc, Regression, UAT/OAT, Product / System Integration and End to End Testing.
• Experience in the Web Services (XML/SOAP &REST API’s), HTTP, Mobile, IPTV, VOIP, STB (Set top box), Cloud and Browser Compatibility Testing.
• Experienced in writing complex SQL Queries and DWH ETL (Oracle, SQL Server) testing.
• Established 5-member onsite QA team (3 Manual + 2 Automation), has successfully delivered FDA, EBAA validated software for 8 years.
• Effective test resource management: Provided- technical training to existing manual test resource towards test automation. Training given to QA team member in SQL and Selenium has increased team morale and helped us to boost test team productivity.
• Assessed the flaws in the existing AS-IS system and made clear recommendations of business process improvements and BPR and incorporated them in the TO-BE system design.
• Changed Test Automation from QTP license version to Selenium Java open source tool.
• Created Template Database for more TEMPthan 5 new clients. Interact with client, collect reference, lookup data related information.
• Independently write SQL queries to pull data from production and data warehouse databases for analysis.
• 5 year of experience in performance planning & forecasting, monitoring, diagnosis, testing, tuning and capacity planning.

TECHNICAL SKILLS:

Methodologies: Scrum, Kanban and Waterfall

Dev Ops tools: Jenkins and GIT.

Test Automation Tool: Selenium with Java, TestNG, Maven, GIT, Jenkin, SoupUI, LoadRunner, Jmeter, Charles, Exposure to WinRunner, WebFT, and WebLOAD.

Defect Management Tool: JIRA, TFS and Version One. Exposure to Collab Centre.

Test Case Management Tool: SAS, Microsoft Test Manager 2015 MTM, VersionOne and JIRA.

Languages: SAS Programming Proc SQL and Data, Java, Exposure to C++.

RDBMS: Teradata, MS-SQL Server, Oracle, MS Access, Excel.

ETL Tools: SSIS and Diffkit, InetPDF.

Source Control: Microsoft VSS, GIT.

Operating Systems: Windows.

Cloud: AWS and Azure.

PROFESSIONAL WORK EXPERIENCE:

Confidential, West Des Moines, IA

Analytical Lead t - Develop Analytical Approach

Responsibilities:

• Prepare DAQC plan for each remediation and maintain in documentum; including executed test plan and proof of validation centralized in one location.
• Interact with line of business owners and product owner to identify the business requirement, and interact with Test Team to identify areas for improvement in Confidential GAP, CPI and Homelending customer remediation process.
• Perform Database Testing as per business acceptance criteria in the user stories.
• Write complex SQL queries based on Data Mapping documents to validate the Dimensional and Fact Data from different Source Systems
• Coordinate the onsite and offshore teams, Also Conduct Knowledge Transfer sessions to the team.
• Review and continually improve quality assurance practices, including creation and update of documentation related to quality assurance processes and guidelines.
• Develop a clear understanding of existing remediation processes.
• Participate in remediation incident report analysis and process improvement.
• Participate in remediation review, testing, validation and auditing.
• Participate in remediation execution/release and remediation life cycle activities in accordance with applicable policy and procedures.
• Run or Participate in Sprint planning. Identify test resources, estimate test effort for the upcoming remediation.
• Identify Test Approach to validate RMAT, RIAD, Requirement and Data Complexity workbook, Analytical Approach and Corrective Action Plans.
• Interact with Remediation Lead, Execution Lead and Business Leads to understand the remediation flow and plan test resources for each remediation.
• Implement test scope to validate DAQC1 (Analytical Approach Verification), DAQC2 (Population Identification and Verification) and DAQC3 (Population Execution and remediate the customer).
• Validate Test Result on DAQC-2 supporting documents like Population Water Fall, Change Log, Target and Final Population.
• Help Quality Assurance team member in throughout DAQC-2 validation.
• Track and report Data Analytics development and test activities, test results, test case coverage to DAQC Manager and Remediation team.
• Identify Test Approach to validate DAQC-3 final output using Financial Algorithm for customer remediation, create segmented population and final executable output to Quality Assurance Team.
• Interact with QA and Execution team, deliver the project to customer remediation head for final signoff and execution.
• Responsible for performing highly complex activities related to business analysis and/or modeling.
• Responsible for senior level consulting partnerships including delivery of findings and recommendations.
• Responsible for providing insights, developing analytical strategies, performing analytical support and/or modeling regarding a wide array of business initiatives.

Environment: SAS, Visual Studio, TFS, Teradata, SQL Server, Oracle SQL Developer, Unix, tableau, Jason and XML.

Confidential

System Analyst cum Business Analyst

Responsibilities:

• Involve in software merge process. Identify gaps between two application functionality, create GAP analysis report.
• Setup Automation Test Framework using Selenium Web driver with core Java and TestNG framework using eclipse as IDE.
• Setup Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle.
• Test and validate UNOS upload and import mapping in SOAPUI, analyze graphs and reports to check for performance delays, network delays, CPU performance, me/O delays, database locking, or other issues at the database server.
• Track and report testing activities, test results, test case coverage.
• Prepare testing plan for each release and maintain in MTM; including executed test cases and proof of verification etc.
• Implement SOP in each release and get release signoff from Program Director and QA Director.
• Test Data Integrity and Data Validity when new functionality is introduced.
• Test functions, procedure and triggers on need basis.
• Test data whenever data merge happens either Database to Database or Data Table to Table.
• Test webservices manually using XML SoapUI automation tool and Database techniques.
• Establish Java/Selenium Page Object Model Framework on a Web based application.
• Integrate Functional Tests and smoke tests into Jenkins for continue Integration.
• Review and Test Selenium Test Script, Execute and Analyze Selenium Test.
• Configure necessary hardware and operating environments as needed to complete assigned testing and support needs.
• Coordinate with developer, identify impact scenario and provide automation test script for impact regression testing.
• Maintain build version using Jenkin.
• Lead testing tasks and ensures issues are tracked, reported and resolved in a timely manner, Identify critical issues with ease.
• Test Suite and Review Test Cases in Microsoft Test Manager.
• Develop SQL queries to ease test execution process.

Environment: SQL, SSMS, ETL, SoupUI, Microsoft Test Manager and Lab Center, Jenkin, TFS, XML, EDI, EBAA, HIPAA.

Confidential

Quality Assurance Supervisor cum Business Analyst

Responsibilities:

• Helped Development team in AWS migration. Worked with developers and signed off VM to AWS migration. During dis phase, analyzed, implemented and verified application validated functions, integration part of application, all webservice and verified database integration and jobs.
• Interact with product owner, identify the business requirement, and interact with user and identifying areas for improvement.
• Develop user story and story mapping development.
• Develop flowcharts of current and future business processes.
• Helped Hybrid Automation framework from scratch using Page Object Model design pattern.
• Develop Prototype for Base, Page, Test, Config, Data, Reports packages in POM design pattern from scratch.
• Review and test the automation scripts.
• Interact with product owner, identify the business requirement, and interact with user and identifying areas for improvement in Midwire Processing 20/20 application.
• Develop user story and story mapping development.
• Develop flowcharts of current and future business processes.
• Develop BRD for new requirement and Update Technical Specification according to new enhancement.
• Support the clinical information system through consultation, analysis, test plan and test case design and implementation of SQL scripts, SSRS reports, techniques and other deliverables.
• Participate in software requirements analysis and process improvement.
• Review Selenium Test and Execute Selenium Test. Analyze automation test report + create bug for fix.
• Test Data Integrity and Data Validity when new functionality is introduced.
• Test Data base related performance on all application performance related customer support tickets.
• Test functions, procedure and triggers on need basis.
• Test data whenever data merge happens either Database to Database or Data Table to Table.
• Test data in Datawarehouse.
• Coordinate with developer, identify impact scenario and provide automation test script for impact regression testing.
• Maintain build version using Jenkin.
• Test webservices manually using XML and Database techniques.
• Develop Test Plan, Test Suite and Review Test Cases in Microsoft Test Manager.
• Develop SQL Query + add it in test suite to support and minimize test execution time.
• Registry Mapping, configurations and settings for all MTF registry clients like One Legacy, Gift of Life, Nebraska Organ Recovery Systems and Nevada Donor Network.
• Integrate DonorNet to DonorTrac, DonorNet Data Dictionary, and Lookup Lists.
• Participate in Sprint planning. Identify test resources, estimate test effort and define test schedule in TFS.
• Tested Wisconsin Eye Bank and IOWA Eye Bank Referral integration XML with Saving Sight Referral Services application using SoapUI.
• Tested and validate Match Surgeon Interface application XML data integration with Midwire core application interface using SoapUI.
• Tested and Validate Core Midwire Database integration with various other core application databases.
• Designed multiple Load Runner scripts (Vugen) with different protocols like Web, BPM, Flex, AJAX, TruClient, Citrix, Web services for load testing different GUI and other applications.
• Analyzed graphs and reports to check where performance delays occurred, network or client delays, CPU performance, me/O delays, database locking, or other issues at the database server.
• Worked on Throughput, Hits per seconds, Network delays, latency, and capacity measurements and reliability tests of on multi- layer architecture.
• Test various integration part of application like Quickbooks, Graitplain, Broadcasting, Referral Facility, Serology facility, email and fax.
• Test/QA, Training/UAT and Demo server maintenance.
• Participate in Sprint planning. Identify test resources, estimate test effort and define test schedule in TFS.
• Track and report testing activities, test result, test case coverage.
• Prepare validation plan for each release and maintain in MTM; including executed test cases + proof of verification.
• Get release approval from Program Director, QA Manager and Product Owner, send final release notification to all end client.
• Provide technical guidance to junior analysts in their assigned job duties.
• Hire, train, and supervise software quality assurance and business analyst staff members.
• Prepare Release Plan, get approval from Program Director, QA Director and Product Owner.
• Manage production release from release notification till post production verification.
• Collect testing signoff from all testers and create Test Completion Report for production release.

Environment: SQL Server, SSIS, SSRS, Jenkin, JIRA, XML, EDI, Charles. EBAA, HIPAA, EDI, HL7, Crystal Reports.

Confidential

Assistant Manager - Quality

Responsibilities:

• Interact with product owner, identify the business requirement, and interact with user and identifying areas for improvement.
• Run Scrum, Mid Sprint Review, Every Day Standup meeting and Requirement Analysis.
• Hire, train, and supervise software quality assurance staff members and report team status to QA Manager.
• Mapping, X.12 EDI transactions (EDIFACTS, SAP IDOCS, 810, 850, 856, 860, 852, 820, 834, 835, 837, 999 XML etc.)
• Validate 834, 278 and 837 Transaction and report issue in JIRA in timely manner.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Setting up Communications via FTP, AS2.
• Hire, train, and supervise software quality assurance staff members and report team status to QA Manager.
• Develop BRD for new requirement and Update Technical Specification according to new enhancement.
• Prepare Test Plan, Test Strategies, High, Medium & Low Level Scenarios, System Test Cases, Requirement Traceability Matrix, Test Checklist, Test Status, Product Configuration Guides, Feature Matrix, Test Checklist & Client Profile documents as based on Client’s Work Orders (Change Requests)
• Conduct frequent Knowledge Transfer session to Development Team.
• Conduct internal weekly meetings in offshore teams to discuss all features, technical functional workflows of project.
• Design, develop and implement 'Test Automation' solutions using the QTP automation tool.
• Find Load Testing scenarios, Automate and execute them using LoadRunner testing tool.
• Performs System, End-to-end, UAT testing and report the issue in Version One Defect Tracking Tool.

Confidential

Test Lead

Responsibilities:

• Interact with product owner, identify the business requirement, and interact with user and identifying areas for improvement.
• Run Scrum, Mid Sprint Review, Every Day Standup meeting and Requirement Analysis.
• Hire, train, and supervise software quality assurance staff members and report team status to QA Manager.
• Mapping, X.12 EDI transactions (EDIFACTS, SAP IDOCS, 810, 850, 856, 860, 852, 820, 834, 835, 837, 999 XML etc.)
• Validate 834, 278 and 837 Transaction and report issue in JIRA in timely manner.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Create Interim Build releases for iterative testing using Microsoft Project Management Plan.
• Prepare High, Medium & Low Level Scenarios, System Test Cases, Requirement Traceability Matrix, Test Checklist, Test Report documents based on Client’s requirement.
• Participate in Weekly Client Project Meeting and report about the current Project Testing Activity status.
• Prepare Test Plan, Test Strategies, High, Medium & Low Level Scenarios, System Test Cases, Requirement Traceability Matrix, Test Checklist, Test Status, Product Configuration Guides, Feature Matrix, Test Checklist & Client Profile documents as based on Client’s Work Orders (Change Requests)
• Maintain the Defects summary of every build’s JIRA Roadmaps as based on release in Test Status document in prescribed format and directly report to Onsite associated Project Managers & Development Leads.

Confidential

Sr. Software Engineer

Responsibilities:

• Single Point of Contact key person between Off-Shore QA Team and On-Site associated Project Managers & Development Leads.
• Participating in Weekly Client Project Meeting and expose about the current Project Testing Activity status.
• Conduct internal weekly meetings along with Off-shore—QA & Development Teams to discuss about all features, technical functional workflows about Health Care domain products.
• Performs System, Integration, Regression, Database, End-to-End, Adhoc & Retesting on the various Products’ functional workflows enhancement as based on fixes made by the developers by using on-line JIRA Defect Tracking and Project Management Tool of Atlassian product.
• Perform Sanity Testing on product’s major workflows.
• Prepare Test Plan, Test Strategies, High, Medium & Low Level Scenarios, System Test Cases, Requirement Traceability Matrix, Test Checklist, Test Status, Product Configuration Guides, Feature Matrix, Test Checklist & Client Profile documents as based on Client’s Work Orders (Change Requests).
• Maintaining the Defects summary of every build’s JIRA Roadmaps as based on release in Test Status document in prescribed format and directly reporting to On-Site associated Project Managers & Development Leads.