Gaurav Mittal

Mob. No. – +1-818-***-****

Email – ac4yep@r.postjobfree.com

Total Experience – 10.4 Years

PROFESSIONAL SUMMARY:

Expertise in both SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle).

Experienced working in Agile/Scrum Methodology for over 5 years.

Have 4.6 Years of specific Healthcare Insurance domain experience, 2.6 Years on Auto Insurance domain and more than 3 Years of Experience in Annuities Financial domain.

Expertise skills in SOA testing, API testing, Functional testing, and Black Box testing.

Experience working with DevOps for continuous integration using Jenkins.

Good experience with test management tools like HP ALM.

Experience in testing, test management with software teams including analyzing and integrating with wide range of Distributed applications

Expertise in TDD review, Functional Design walk-through and BRD walkthrough.

Experience of leading both Onshore and Offshore team together in complex distributed system projects.

Expertise knowledge in quality assurance methodologies, multiple databases, testing techniques, and test management.

Expertise in writing functional test plans, test results analysis and reports with creative and innovative QA artifacts.

Expertise with the integration of test procedures, including debugging/analysis of issues to determine root cause.

Expert knowledge of system testing based on both user requirements and business systems requirements.

Experience in creation & execution of user acceptance test cases.

Ability to comprehend various architectures to identify performance concerns and assist with defining performance improvements.

Experience in supporting Performance test team for data needs, Performance requirements and Environment readiness.

Strong knowledge of functional & regression testing using Soap UI and Rumba.

Strong knowledge of relational database, writing SQL queries and test data mining.

Good Experience of writing automated test scripts using VBScript, Groovy, Java Script and using java with tools like Selenium.

Knowledge of Configuration Management, Defect Management and Knowledge Management.

Ability to identify gaps in current process and tools and suggest new ways to improve them.

Strong problem solving, and analytical skills demonstrated by the ability to assimilate new information, understand complex topics and arrive at sound analysis and judgment.

TECHNICAL SKILLS:

Testing Tools

Soap UI, Selenium Webdriver, TestNG, Rumba, PgAdmin, Test Link, TRAC, Admin 7, Quality Centre, HP ALM, JIRA, RFT, Rational Clear Quest, Lotus Notes, CA WILY, SPUNK, Jenkins.

Programming Languages

Java, Java Script, Groovy Script, VBScript, HTML, MS Excel Macros, JSP, JMF.

Application Software

Microsoft Visio, Visual Source Control, MS-Excel, MS-Word, MS PowerPoint.

Databases

DB2, Postgres, Oracle, Microsoft Access, Microsoft SQL Server.

Database UI

PgAdmin, IBM Data Studio, QMF, SPUFI, TOAD, SQL Analyzer, SQL Developer.

Operating Systems

Win 7, 8, XP, 03, 08, MS-DOS.

SOA / Middleware testing expertise

SOAP web services, REST web services, API, ACCORD, XML, JSON, XSLT, WSDL, JMS, Message Queues, Broker, BRE, Automation using Groovy, ODM, Translations, Message Transformation, Message Enrichment, Logging and Auditing Frameworks, Service Virtualization.

EDUCATION/TRAINING:

Bachelor’s in technology (IT) in 2007 from Galgotia’s College of Engg. & Tech., Gr. Noida (Affiliated to U.P.T.U, India).

Certified by ISTQB, American Health Insurance Plans (AHIP) Part A and Part B, Validation Solutions Technical Foundation.

PROFESSIONAL EXPERIENCE:

Employer – Cognizant Technologies Solutions

Client – Prudential Financial,

April 2015 – Till Now

Technology Specialist / QA Lead

Job Description:

Working on testing of 120+ SOAP and REST Web Services.

Working on testing of 50+ API’s interacting with web services and other 3rd party external/internal systems.

Experience with service virtualization.

Very good hands on experience in automating the web services using Groovy script.

Good hands on experience in automating web test cases using Java in Selenium.

Working on testing of various ESB components like ESB like IIB (Message Broker), Data Power, BPM, Web Service Orchestration, Web service Functionality, ODM rules, Layer 7, WSRR, Message Queues, Message Enrichment, Transformation & Translations, Rules Validations and ESB Filtering.

QA Lead on complex projects where multiple services are orchestrated together to send Email and SMS to customers for any transaction they do.

QA lead on projects having team size of 10+ people, including both Onshore and Offshore.

Good experience working with distributed applications that integrates with 3rd party vendor products using data files and using web services.

Work on Soap UI tool for web service testing and used SQL / Stored Procedures for validating web service response against SQL server database and 3rd party external databases.

Participated in Application Development Sessions and Walkthroughs to analyze the requirements.

Worked closely with developers, and business users to develop test scenarios and verify functionality to be implemented.

Lab planning and setup test lab for test environment.

Designed, developed, and implemented testing methods, plans, and procedures for software systems.

Conducted System Integration Testing (SIT) and Acceptance Testing (UAT).

Performed Smoke testing of different Modules.

Provided all aspect of test management (requirements, work distributions and defects).

Worked in Agile Methodology.

Interacted with Product Owner and developers with requirement analysis, design reviews, testing and documentation for applications developed in Agile environment.

Involved in performing functional and regression testing.

Created test cases based on the BRDs and FDDs.

Created reports that included a general overview, open bugs and enhancement requests.

Tracked and maintenance of testing environments to ensure smooth transition for production release.

Communicated daily project status to varying levels of management.

Identified gaps in current process and tools and suggested new ways to improve them.

Managed multiple priorities and adjusted to changing priorities.

Tools: Soap UI, Selenium Webdriver, TestNG, SQL Developer, Lotus Notes, XML, HTML, MS-Office, WSDL, WADL, SOAP UI automation using Groovy Script, JSON, ESB, Data Power, SPLUNK Logs, HP ALM.

Types Of Testing: SOA Testing, Web testing, Functional Testing, System Testing, Client Server Message Queue (MQ) Testing, Web Service Testing, Data Validation Testing.

Employer – Accenture

Client - State Farm Insurance,

April 2012 – April 2015

Senior Software Engineer / QA Lead

Job Description:

Worked on SOA Testing on SOAP Web Services, System Migration Testing, and Mainframe Testing using DB2.

Test Lead on very complex projects involving multi-platform components, and processing more than 100K transactions every day in Production.

Test Lead on testing and automation of 25+ web services catering the need of different departments across State Farm.

Has worked on Soap UI tool for web service testing and used SQL / Stored Procedures / IMS transactions for validating web service response against DB2 and Postgres databases.

QA Lead with team size of 15+ people at both onshore and offshore.

Participated in Application Development Sessions and Walkthroughs to analyze the requirements.

Worked closely with developers, and business users to develop savoury test scenarios and verify functionality to be implemented.

Lab planning and setup test lab for test environment.

Designed, developed, and implemented testing methods, plans, and procedures for software systems.

Conducted System Integration Testing (SIT) and Acceptance Testing (UAT).

Performed Smoke testing of different Modules.

Provided all aspect of test management (requirements, work distributions and defects).

Worked in Agile Methodology.

Interacted with Product Owner and developers with requirement analysis, design reviews, testing and documentation for applications developed in Agile environment.

Involved in performing functional and regression testing.

Created test cases based on the BRDs and FDDs.

Performed database testing on DB2 and Postgres using SQL queries.

Created reports that included a general overview, open bugs and enhancement requests.

Tracked and maintenance of testing environments to ensure smooth transition for production release.

Communicated daily project status to varying levels of management.

Identified gaps in current process and tools and suggested new ways to improve them.

Managed multiple priorities and adjusted to changing priorities.

Tools: Soap UI, Rumba, Postgres, DB2, Lotus Notes, XML, HTML, MS-Office, WSDL, SOAP UI automation using Groovy Script, Message Driven Bean, JSON, ESB, Data Power, KDiff3, SVN repository, SPLUNK Logs, Log Scan, WSRR, HPSM, Test Link, HP ALM, CMP, App Watch, Admin 7, Mothra, SharePoint.

Types Of Testing: Mainframe Testing, Functional Testing, Java Testing, System Migration (DB2 to Postgres) Testing, Client Server Message Queue (MQ) Testing, Java Web Service Testing, Data Validation Testing.

Employer – Infosys Technologies Ltd.

Client – Anthem-WellPoint,

Nov 2007 - April 2012

Test Analyst

Job Description:

Involved with requirements generation and analysis, development of software testing documentation.

Participated in the analysis of requirements and specifications to create test models.

Worked closely with developers, and business users to develop savoury test scenarios and verify functionality to be implemented.

Lead testing effort for multiple complex projects and comparatively small scale change requests at the same time.

Worked in round the clock delivery model with offshore.

Tested complex Healthcare Insurance business logics viz. Claim processing, Member Enrollments, Benefit processing, EDI (834, 835, 837 and 274 formats), HIPAA compliance, ICD 9, ICD 10, Capitation, Medicare and Medicaid Claims, ITS Processing of Claims.

Created several Test Unit Estimations, Test Plan, Requirement Traceability Matrix (RTM), Test Cases, and Automated Test Suites using RFT, Defect Status Reports, Daily Test Execution Status Reports, and Regression Test Suites.

Created tool in VB Script using excel macros to make CICS screen testing easy.

Worked on Test Execution of multiple new and ongoing projects.

Has done UAT on couple of projects as UAT Test Analyst.

Test planning and setup test application in test environments.

Designed, developed, and implemented testing methods, plans, and procedures for software systems.

Worked in Waterfall and Iterative Methodology.

Designed and implemented software automation techniques to improve test execution, reliability of test results and improve overall time.

Documented test equipment requirements and configure test equipment as required for specialized testing and evaluation of software products.

Performed manual and automated testing of new/modified system/software.

Performed extensive black box testing on the mainframe system.

Designed, built and executed development and system tests for both browser and non-browser applications.

Created, enhanced and maintained high-end test scripts for various functional and regression using Quality Centre and Rumba.

Developed, enhanced and maintained automated testing scripts with VB Script for functional Regression testing.

Provided all aspect of test management (requirements, work distributions and defects) using Quality Center.

Supported Performance team to verify the Load and TPS as per the client Requirements.

Performed database testing on RDBMS like Postgres and DB2 using influx of SQL queries.

Tracked and maintenance of testing environments to ensure smooth transition for production release.

Communicated project status to varying levels of management.

Identified gaps in current process and tools and suggested new ways to improve them.

Managed multiple priorities and adjusted to changing priorities.

Tools: Quality Center, QMF, Rumba, TSOA, File Aid, File Manager, ITS, EDI (274, 834, 835,837), DB2, Dispatch Reports, Rational Clear Quest, IPM+ for defect logging, CICS Test Data Setup, Citrix, QMF, SPUFI, SOAP UI, Groovy Scripting, Postgres, Message Queues, SharePoint, XML, HTML, Visual Source Safe, MS-Office .

Types of Testing: Mainframe Testing, Black Box Testing, Functional Testing, Browser Testing, 27x HIPAA Transaction Testing, EDI Files Testing, Testing on Claims Processing, Membership Enrollment and Member Benefits, Capitation Testing.

Contact this candidate