Name: Jigar Patel
Email: ******@*****.***
Phone: 267-***-****
Status: US Citizen
Summary
Software Business/Quality Analyst with 11 years of experience in Quality Assurance and Business Analysis.
Experience in Software Quality Assurance (SQA) methodology, quality models like ISO 9000, SEI-CMMI and Software Development Life Cycle and working in SEPG and Quality Assurance Groups.
Experience in maintaining and improving Software processes (Quality Management System), performing quality audits and metrics generation and analysis.
Extensive working experience in Mortgage, Insurance and finance.
Strong knowledge of Software Quality Control methodologies including development, execution, and maintaining Test Plans, repeatable tests, test result documents and bug reporting.
Specialized in business requirement analysis, documenting test plans, identifying test scenarios from requirements, use cases or design documents and test case design, manual and by using Automation Tools (QTP).
Experienced in structural approach for testing where test scenarios are identified, possible reusable functions are identified and developed followed by manual testing or basic scripting methods.
Extensive working experience involving complete testing life cycle. Extensive experience of test execution, defect reporting and verification, managing defect life cycle using Lotus Notes, customized tools or manually. Extensive experience in defect prevention activities.
Extensive working experience in System Testing, Functionality Testing, Regression Testing, Integration Testing, UAT, Migration testing, smoke testing.
Used various defect tracking tools like bugzilla, JIRA, Lotus Notes for reporting, tracking defects.
In depth knowledge of RUP’s Iterative Software Development Life Cycle.
Studies: Finance, Temple University, Fox School of Business & Management
Technical Skills:
Testing Tools
Quality Center, Quick Test Professional, ALM, Perfecto, MTM, JIRA, Bugzilla.
Software Methodologies
Agile, Waterfall
Operating Systems
MS DOS, Windows NT/95/98/2000/XP/Vista/7, Unix, Apple IMac
Database
SQL Server 2005/2008, MS Access, Oracle 9i/10g/11g
MS-Suite
MS Visio, MS Office 2003/’07/’10 (Word, Excel, Power Point, Outlook)
Domain
Banking & Finance, Health care.
BNY Mellon, Pittsburgh, PA
Role: Sr. QA Engineer Lead Feb 2017 – April 2019
Project: Enterprise Risk Initiative
Responsibilities:
As Data Support Lead with Bank of Mellon’s Integrated Regulatory Data Mart team within the Enterprise Risk Initiative organization and responsible for all aspects of data management for the entire lifecycle.
Data Management responsibility for the entire lifecycle of the Enterprise Risk Initiative project, involving collaboration across multiple teams such as Data Model, Dev Ops, LOB Risk, Onboarding, Collateral, Financial Regulatory Reporting and BAU.
Work with different line of business peoples to get the data feed from different source system for Intraday Exposure and Direct Credit.
Participated in Financial Regulatory Reporting Meetings; responsible for accurate and timely response to FRR/BAU tester’s queries on data analytics, data quality and overall data management for Enterprise Risk Initiative project.
Led the Integrated Regulatory Data Mart that was responsible for development and implementation of data quality and data management standards for ERI, with the goal of meeting standards for Credit Risk Data Warehouse decommissions.
Responsible for active engagement, challenge and debate with across multiple teams and Allowance Teams to proactively self-identify and address data quality issues in order to improve risk management capabilities.
Lead the QA team for test data and test environment set up for each requirement to ensure accuracy of test data which are implemented.
Facilitate defect review meetings with other teams including Dev team, A team and Product owners with reference to both Risk Measure Aggregation Engine and BNYM Risk Nexen reporting.
Responsible for loading source system data into database and have done end-to-end testing of entire risk system.
Worked with Dev. team for preparation of High Level design for Integration using BNYM Risk ETL tool, BNYM Credit Classification Tool, Risk Measure Aggregation Engine and BNYM Risk Nexen reporting.
Assisted the team in developing test strategy and test plan from the perspective of BNYM Risk ETL tool, BNYM Credit Classification Tool, Risk Measure Aggregation Engine and BNYM Risk Nexen reporting.
Performed the Data Transformation logic and Data Mapping Document.
Drafted and finalize the test scenarios and test cases after understanding business and technical requirements using BNYM Risk ETL tool, BNYM Credit Classification Tool, Risk Measure Aggregation Engine and BNYM Risk Nexen reporting
Post Implementation Production support BNYM Risk ETL tool, BNYM Credit Classification Tool, Risk Measure Aggregation Engine and BNYM Risk Nexen reporting.
Developed Task Management and Resource Allocation using JIRA and ALM.
PNC BANK, Pittsburgh, PA
Role: QA Engineer Lead May 2015 – Feb 2017
Project: PNC Retirement Directions
Responsabilités:
Participating in system specification meetings, design reviews, requirement study and the preparation of the test plan outlining the scope of the project.
Performing QA tasks as they relate to creative, functional, and backend new system launches.
Performing QA tasks as they relate to existing application upgrades and enhancements.
Involved with all aspects of application phases from design through deployment, following agile process.
Documenting detailed test scenarios and test scripts derived from defined business requirements and supported the QA manager to coordinate test plans across multiple parties.
Participating in multiple Project Releases.
Executing formal test plans with attention to detail, ensuring all system components function per defined requirements and were production ready prior to launch.
Developing, and maintaining functional test cases and other test artifacts like test data, test matrices, data validation, harness scripts and automated scripts.
Held and facilitated test plan/case reviews with cross-functional team members.
Executing and evaluating manual and automated test cases and reporting test results.
Performed raw data structure and content validation especially in the support of feeds integration testing including product, content translation, warehouse, sales, and marketing feeds.
Isolated, replicated, and reported defects and verified defect fixes using JIRA.
Identified potential quality issues and escalated them immediately to management.
Ensured validated deliverables meet functional and design specifications and requirements.
Performing Black-box testing, functional testing, UI testing, integration, end-to-end testing, Regression Testing, performance testing, UAT and build acceptance (smoke) testing after each build.
Performing Cross-Browsers/Platforms Testing of many web based applications including Mobile Devices like iPhone, iPad, and Android.
Working closely with Off-shore testing team on creating and executing test cases and test data.
Reporting the status and results to the management and team lead in timely matter
Attending Stand up, planning meeting, reviews and other project and QA related meetings.
Deloitte, State Govt of PA, Harrisburg, PA
Role: QA Engineer Jan, 2014 – April, 2015
Project: ICIS
Responsibilities:
Involved in Functional Testing, Regression Testing, Sanity Testing, Ad-hoc Testing and User Acceptance Testing.
Created Recovery Scenarios to handle Exceptional Scenarios.
Involved in preparing Traceability Matrix for the functional requirements of the system
Executed SQL Statements for Database Testing using QTP
Worked with XML, SOAP and performed SQL validation against XML, generated by the web-services
Analyzed business requirements, functional specifications to provide inputs to future release.
Worked on SCRUM Project Management and Agile scrum Methodologies for Software Development Life Cycle (SDLC).
Authorized and reviewed the test cases for the newly identified test scenarios on sprint basis.
Experience in Facets Workflow application includes advanced client service features
Work with automation team to build basic smoke tests suite for every build in different test environment.
Writing test cases, executing and logging defects using Microsoft Test Manager as Defect Tracking Tool.
Investigating bugs and interacting with developers and use MTM as Defect Tracking Tool.
Used TFP for management and to coordinate with team.
Environment: MTM, TFP, .Net, Oracle 10g, HTML5, Main Frames, Internet Explorer, Firefox, SOAP UI
J. P Morgan Chase, Wilmington, DE
Role: Sr. QA Analyst Jan, 2010 – Dec, 2013
Project: Portfolio Management System
Responsibilities:
Played a key role in the planning, testing, and implementation of system enhancements and conversions.
Functioned as the primary liaison between the operations and the technical team and resolved process issues throughout the project cycle.
Provided the management with test metrics, reports, and schedules as necessary and participated in the design walkthroughs and meetings.
Manage and controlled change using Jira and ALM, associated requirements to specific change request/enhancements/defects and make sure that other teams were following the change requests guidelines.
Produced Functional Specifications and led weekly meetings with technical teams to discuss outstanding technical issues and deadlines that had to be met.
Provide the test lead with accurate LOE estimates for test planning, preparation, and execution.
Working knowledge of testing concepts, verification and validation techniques, defect management, quantitative methods, risk management and measurement programs.
Analyze business requirements and technical specifications. Design, develop and execute testing scripts, SQL queries, and test drivers for a mortgage application rules engine based on requirements, specifications, and other relevant documentation
Analyzed research on operational procedures and identified opportunities for improvement with an emphasis on automation and efficiency.
Developed and executed associated project plans and test scripts for User Acceptance Testing (UAT) and subsequent user training.
Report and track problems by providing reproducible test cases, and working with other product team members to close problem reports.
.Conduct root cause analysis of identified defects, providing technology and business partners with sufficient detail to understand, replicate and resolve outstanding issues and defects.
Create, review, validate and maintain comprehensive regression test suite(s). Execute regression test suite(s) and report results and issues in a timely and accurate manner.
Used Jira, ALM, MTM and Excel for storing requirements, bug tracking and reporting activities.
BNY Mellon (PFPC), King Of Prussia, PA
Role: QA Analyst May, 2007 – Oct, 2009
Responsibilities:
Worked closely with the SME’s and Risk Professionals to identify elements that contributes to Credit Risk.
Developed re-usable scripts for improved and repeatable test execution
Involved in Design and development of test plans based on high-level and detailed designs.
Analyzed the use cases given by the business analysts and developed test cases using them.
Responsible for preparing and analyzing financial reports and statements.
Tested the ETL business logic for different feeds and checking the log files for data counts.
Documented end to end mapping of Data elements to support Metadata requirements.
Data Integration testing for products, reference data and customer master data management (MDM).
Written SQL queries for data validation and data verification.
Analyzed, reported and kept track of defects using Quality Center and Bugzilla.
Documented the daily defects status with the help of test metrics.
Environment: Informatics 6.1, Windows NT, Share Point, HTML, MS-Office Tools, SQL, IBM DB2, Oracle, Test Director, Manual Testing.