Sunilkumar Patel
Summary
10 years of experience in Quality Assurance with expertise in ETL flows, Business Intelligence Reports, and Web-based and Client/Server applications, utilizing both manual and automated testing tools. Proficient across all phases of the Software Testing Life Cycle (STLC) with a strong understanding of the Software Development Life Cycle (SDLC). Experienced in various SDLC methodologies, including Waterfall, Agile, and RUP models, adapting to different project needs and timelines. Skilled in analyzing Business Requirements (BRD), High-Level Design Documents (HLD), and Use Cases to draft comprehensive test scenarios, cases, and scripts. Extensive experience in inspections/reviews, test execution, test data preparation, test environment setup, and metrics collection to support efficient QA processes. Proficient in creating Traceability Matrices to ensure complete requirement coverage by linking test scripts to requirements. Expert in writing complex SQL queries for data validation and testing across large datasets. Extensive hands-on experience with Functionality Testing, GUI Testing, Integration Testing, Regression Testing, Performance Testing, and System Testing based on business and system requirements. Strong working knowledge of DSS (Decision Support Systems) applications and ETL (Extraction, Transformation, and Load) processes using tools such as Informatica, DataStage, and Ab Initio. Expertise in testing complex business rules, mappings, and transformations using Informatica and other ETL tools, ensuring data integrity and accuracy. Experience in integrating various data sources with relational databases such as Oracle, SQL Server, Db2, Teradata,and MS Access, along with flat files, XML, and VSAM files. Skilled in test data preparation for positive and negative testing scenarios to ensure full test coverage. Proficient in SQL, Unix Shell scripting, Perl, and Java for creating and executing tests and automation scripts. Extensive involvement in SIT and UAT, supporting end-users and stakeholders, while driving the implementation of QA processes. Significant experience in testing Data Marts and Data Warehousing/ETL applications developed using Informatica and DataStage with Oracle. Proven track record as an effective technology evangelist in leading platforms like Microsoft SharePoint Online (SPO), SharePoint 2013 & 2016, Office 365, and related ECM tools. Deep experience with ECM projects using SharePoint, Office 365 (OneDrive for Business, Office Groups, MS Teams), and other Office 365 tools. Proficient in defect management using tools such as Quality Center HP ALM, VersionOne, and JIRA to track, manage, and resolve defects efficiently. Experienced in the preparation and execution of regression suites, ensuring stability of the application after code changes. Hands-on experience with Test Management Tools including Rational Test Manager, Mercury Quality Center (Test Director), and qTest. Collaborated closely with developers and business users to facilitate an efficient testing process and address any challenges. Proven ability to work under tight deadlines and manage multiple projects simultaneously while maintaining high-quality output. Quick learner with a willingness to adapt and master new technologies in rapidly changing environments. Possess excellent communication, interpersonal, problem-solving, and leadership skills, driving success in cross-functional teams.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Sr. Quality Assurance Analyst Manager/Lead
Edward Jones Investments
, USA
07.2021 - Current
- Developed and executed comprehensive test cases for the Sales and Distribution module based on BRD, Technical Specifications, Functional Design, and Use Case documents, ensuring proper functionality, test requirements, and coverage
- Designed detailed test plans and strategies, specifically tailored to Salesforce applications, for thorough and accurate testing
- Conducted manual testing using a test management tool for tracking test cases and defects within Quality Center and qTest
- Delivered all assigned tasks efficiently using Rally and JIRA for task management and issue tracking
- Created and maintained RTM documents to ensure comprehensive test coverage of all requirements, identifying both manual and automated test cases
- Collaborated with stakeholders and end users to execute data migrations from confidential sources into SharePoint 2013 sites, validating Salesforce application functionality through manual test cases
- Led the provisioning of new SharePoint sites, executing data migrations with appropriate tools, followed by thorough QA validation
- Conducted SharePoint data analysis utilizing advanced Excel functions to ensure accuracy and efficiency
- Developed automation scripts using QTP to enhance testing efficiency and coverage
- Collaborated with developers to resolve technical issues, investigating and addressing software faults promptly
- Analyzed functional specifications and provided guidance to the QA team to achieve test goals
- Utilized Quality Center and qTest for defect tracking, reporting, and analysis to ensure the timely resolution of issues
- Engaged in test automation using QTP, including back-end testing with SQL queries and database checkpoints
- Wrote and executed SQL queries for back-end testing, validating data integrity and consistency.
- Prepared SD module documentation for management review and project presentations, ensuring clarity and thoroughness
- Authored test summary and evaluation reports for project stakeholders, highlighting key testing outcomes and recommendations
- Demonstrated strong knowledge of JavaScript, UNIX, UNIX scripting, SQL, and Data Warehousing
- Validated data security and sharing rules within Salesforce, testing users, profiles, role hierarchies, and permission sets to ensure adherence to security protocols
- Excelled in both independent work and collaboration with cross-functional teams to meet project deadlines
- Environment: HP Quality Center, qTest, Windows XP, Unix, MS Excel, MS Word, Oracle 10g, Putty, TOAD, Oracle Database, SQL, Office Communicator, SharePoint, Web Services, WSDL, SoapUI, Salesforce.com Platform
Sr. Quality Assurance Analyst Lead
CCC Information Services Inc
, USA
03.2019 - 12.2020
- Demonstrated expertise in JavaScript, Unix, Unix scripting, SQL, and Data Warehousing with a solid understanding of data modeling concepts
- Strong organizational skills with excellent attention to detail, ensuring high-quality test coverage and defect tracking
- Ability to work independently and lead highly cross-functional teams, fostering collaboration and communication across departments
- Proficient in writing and troubleshooting SQL queries, coupled with strong analytical skills for diagnosing and solving complex data-related issues
- Led regression testing efforts using automated testing tools such as QTP and Selenium, ensuring seamless software updates
- Designed, executed, and maintained automated test cases for regression testing using Selenium WebDriver (TestNG, JUnit), increasing test efficiency
- Selected and prioritized test cases for automation, performing functional testing of front-end applications using Selenium (IDE and WebDriver)
- Executed parallel browser testing across multiple machines using Selenium Grid, enabling effective cross-browser testing
- Collaborated with the Collaboration Services Group as an Analyst during the Office 365 rollout, contributing to strategic decision-making and implementation
- Planned and executed migration strategies from eRoom to SharePoint 2013, ensuring secure and seamless transitions
- Possesses excellent verbal and written communication skills, with professional proficiency in English, enabling effective stakeholder interaction and documentation
- Strong troubleshooting abilities, following established processes with attention to detail for identifying and resolving issues
- Knowledgeable in web technologies including HTML, CSS, JavaScript, and DOM, facilitating better understanding of front-end testing
- Demonstrated deep understanding of industry standards, quality processes, and metrics, contributing to continuous improvement in QA practices
- Skilled in Quality Assurance using tools like Squish and JavaScript for automating testing processes
- Basic knowledge and experience with SQL for writing and understanding queries and procedures
- Environment: Java, WebServices, WSDL, XML, SoapUI Pro, Selenium, Maven, JUnit, Jenkins, Linux, Oracle Database, SQL, Toad, HP Quality Center, Putty
Sr. ETL / DW Tester Manager/Lead
BLUE CROSS BLUE SHIELD (HCSC)
, USA
12.2018 - 03.2019
- Validated the conversion of outbound batch processes for a customer application from Mainframe to ETL, ensuring accuracy and consistency
- Performed requirements gathering and analysis for the migration process, ensuring comprehensive understanding of business needs
- Reviewed and analyzed Business Requirement Documents (BRD) and Technical Specifications to ensure precision and accuracy for testing, and to implement effective test plans and test cases
- Developed and executed test-related documentation, including Test Plans, Testing Processes, and Schedules to ensure smooth execution and tracking of testing efforts
- Estimated testing efforts and revised estimates as necessary when changes occurred, maintaining alignment with project timelines and resources
- Conducted and participated in technical reviews and walkthroughs for QA deliverables, including Test Plans, Test Strategies, and Test Cases
- Collaborated closely with Project Managers, Business Analysts, SMEs, and Development teams to ensure alignment on project goals and testing needs
- Organized early sync-up meetings with the QA team as part of the Test Preparedness and Defect Prevention process to enhance efficiency and mitigate issues
- Validated that the output files generated by the Mainframe batch and ETL processes were consistent, with no deviations
- Consulted with business leaders on challenges and best practices for migration into both Mainframe and ETL systems
- Performed site provisioning and data content migration using Metalogix and ShareGate, ensuring a seamless transition
- Ensured that job flows and intermediate output files from the ETL process matched those of the Mainframe batch, maintaining consistency throughout the migration
- Created a Requirement Traceability Matrix (RTM) and conducted Test Case walkthroughs to ensure comprehensive coverage of all business and technical requirements
- Developed a Regression Suite and SQL queries to assist the automation team in building automated testing scripts
- Led testing efforts to completion by adhering to test schedules and tracked testing progress throughout the entire Software Testing Lifecycle (STLC)
- Managed defects from creation to closure using HP ALM, ensuring efficient tracking and resolution
- Delivered tasks using Rally and JIRA for task management, ensuring transparency and timely communication with the project team
- Created defect reports and daily/weekly status reports, effectively communicating progress with project stakeholders and making recommendations on process improvements and testing approaches
- Provided guidance and support for the development of the automated testing suite to streamline the testing process and improve overall efficiency
- Environment: HP Tools (Quick Test Pro (QTP), JIRA, Oracle APPS, XML, Rally, Web Services, PeopleSoft, HTML, UML, DataStage, Oracle RAC, Oracle FWM, EBS, Business Objects, Microsoft Project, Visio, Active Reports, Crystal Reports, IIS, SQL, XML, UNIX, Windows XP, MS Excel, MS Word, Notepad++
Sr. ETL / DW Tester Lead
BLUE CROSS BLUE SHIELD ASSOCIATION
, USA
01.2018 - 12.2018
- Analyzed the Business Requirements Document and system specifications and identified the test requirements
- Prepared extensive set of validation test cases to verify the data
- Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code
- Studied and understood the Data warehouses, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams to understand the business activities and application programs and document the understandings for internal team referencing
- Prepared the test plans and test cases for different functionalities involved in the application
- Used Quality Center as the test management tool for the maintenance of the test cases and to track the defects
- Experience working in Agile environment
- Promoted Unix/Informatica application releases from development to QA and to UAT environments as required
- Validated the data of reports by writing T-SQL queries in PL/SQL Developer against ODS
- Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update
- Extracted data from Oracle and uploaded to Teradata tables using Teradata utilities FASTLOAD
- Used TOAD Software for Querying ORACLE
- And Used Teradata SQL Assistant for Querying Teradata
- Conducted regression testing on the application under test
- Created and executed load test plans and scripts using Load Runner
- Developed regression test scripts for the application
- Extensively utilized the Hyperion intelligence (Brio), Hyperion Web Analyzer, SQL, PL/SQL and worked as a part of the Data Warehouse group on projects relating to formulating and analyzing core data relating to business activity
- Involved in metrics gathering, analysis, and reporting to the concerned team
- Tested the Oracle PL/SQL testing programs
- Extensively tested the cubes developed using data from various OLTP systems and various relational data marts using Essbase Studio
- Extensively tested several ETL Mappings developed using Informatica
- Designed, built, and tested reports, Dashboards, and other functionality within the OBIEE suite
- Involved in testing data reports
- Written several SQL queries for validating the front-end data with the backend
- Extensively tested the reports generated by Hyperion Web Analyzer and Hyperion Interactive Reporting
- Conducted test case reviews to ensure scenarios accurately capture business functionality
- Worked with ETL Source System and Target System (ETL Mapping Document) to map the data from source to target and test the load process from source systems to data warehouse
- Validated SQL queries with Oracle Data Warehouse System against Business Requirements Document
- Conducted end-to-end data validation testing by writing SQL queries to validate the data for accuracy from source to target
- Validated the output data from the various Reporting tools (Business Objects, Brio, Crystal Reports, etc.) against the source data
- Designed the Test Plan/Strategy for testing of the Business Objects Reporting system
- Validated that the Business Intelligence tools, such as Business Objects and Brio, function correctly and provide accurate reporting and data analysis
- Environment: Oracle, PL/SQL, Teradata, SQL Server, Informatica, Data Stage, Windows XP, MS Office Suite, Load Runner, Quality Center, Brio, Business Objects, Hyperion, Windows
Sr. ETL / DW Tester
BLUE CROSS BLUE SHIELD ASSOCIATION
, USA
01.2016 - 12.2017
- Analyzed specifications to identify source data needs for migration to the data warehouse
- Well-exposed to SDLC (Software Development Life Cycle) and testing methodologies
- Created ETL test data for all ETL mapping rules to validate the functionality of the Ab Initio graphs
- Designed and developed stored procedures using PL/SQL and optimized SQL queries for performance improvement
- Utilized debugger tools to test data flow between source and target systems, addressing invalid mappings effectively
- Extensively used Ab Initio for migrating data from OLTP systems to the Enterprise Data Warehouse
- Designed Microsoft Visio diagrams to represent workflows and execution processes in reinsurance
- Tested complex reports and Cognos cubes by writing intricate SQL queries per business rules
- Monitored security batch processing jobs across multiple platforms via Control-M and Tidal Schedulers
- Employed SQL queries to assess storage accuracy and integrity within database tables
- Analyzed data to identify quality issues and contributed to resolving them
- Engaged in ETL process testing using Ab Initio ETL tools
- Conducted database testing by writing and executing SQL and PL/SQL queries using TOAD to ensure data accuracy in tables
- Managed defect creation, tracking, and resolution using VersionOne defect tracking tools
- Collaborated on requirements/ETL analysis, testing, and flow design for data warehouse projects
- Validated Cognos Standard Reports developed based on Framework Manager and cubes with SQL queries
- Handled application responses for positive and negative data sets using data-driven testing, along with manual testing
- Communicated weekly status reports to the client, ensuring transparency and project updates
- Executed tests in alignment with the test strategy and schedule, identifying issues and conducting data mining exercises
- Tested the ETL process, ensuring both pre- and post-data validation, including message verification from the ETL tool
- Executed and monitored jobs through Control-M
- Automated and scheduled Ab Initio graphs using UNIX Shell Scripting
- Used Test Director/Quality Center for defect tracking and reporting, designing test plans, scripts, and cases
- Participated in daily and weekly status meetings, coordinating with Development, Business, and QA teams for progress updates
- Environment: Ab Initio, SQL, PL/SQL, Cognos, UNIX Shell Scripting, Control-M, Oracle 11g, ALM/HP Quality Center 11, Microsoft Visio, HP Tools (Quick Test Pro (QTP), Winrunner, XML, Fitnesse, Rally, Web Services, PeopleSoft, Flash, Macromedia FLEX, UML, Toad, SQL Plus, Oracle RAC, Oracle FWM, EBS, Business Objects, Microsoft Project, Visio, Active Reports, Crystal Reports, IIS, SQL, XML, UNIX, Windows XP, MS Excel, MS Word
Sr. ETL Tester
DOLLAR GENERAL
Goodlettsville, USA
04.2015 - 01.2016
- Engaged in understanding client requirements and project functionalities through review meetings and walkthroughs
- Analyzed requirements to design test cases, resolving ambiguities in collaboration with Business Analysts (BA)
- Prepared Test Plan documents and created test cases for the project
- Extensively utilized Informatica Workflow Manager for executing workflows
- Automated job scheduling using UNIX Shell Scripting to enhance testing efficiency
- Conducted Build Verification Testing (BVT) to assess build stability
- Effectively identified, tracked, and reported defects utilizing VersionOne defect tracking tools
- Collaborated with development teams to investigate and resolve software bugs based on testing outcomes
- Executed various testing types, including functional, regression, and user acceptance testing
- Created a Requirement Traceability Matrix (RTM) to ensure all test requirements were covered
- Coordinated offshore tasks, analyzing workloads and assigning tasks to team members
- Provided daily status updates on task progress to stakeholders
- Documented overall testing status for releases and communicated results effectively
- Environment: Oracle, PL/SQL, SQL, TOAD, MS Office, XML, Informatica, Visual Basic, HTML, JavaScript, Windows 95, UNIX, IE
Education
MasterClass Software Testing with Jira & Agile-Be a QA Lead -
Udemy
07-2022
The Complete SQL Bootcamp 2022: Go from ZERO to Hero -
Udemy
07-2022
Leadership: Practical Leadership Skills -
Udemy
03-2022
Basics of Scrum, Agile And Project Delivery -
Udemy
01-2022
Certified Scaled Agile SAFe 5 -
Scaled Agile, Inc.
04-2021
Agile at Work: Driving Productive Agile Meetings -
LinkedIn
01-2019
AWS Certified Developer - Associate -
Amazon
09-2018
Bachelor of Arts - History And Economics
N.S. Patel Arts College
Anand, Gujarat, India12-1998
Skills
- Best practices and methodologies
- Mentoring and training
- Efficient time management
- Employee Supervision
- Test case development
- Quality Assurance Controls
- Framework Development
- Improvement Recommendations
- Systems Analysis
- Team leadership abilities
- Software Development Lifecycle
- Automation understanding
- Software system testing
- Requirements Analysis
- Agile Methodology
- User Acceptance Testing
- Scrum Methodology
- Root Cause Analysis
- Test script development
- Technical Writing
Certification
- Basics of Scrum, Agile and Project Delivery, 2022
- The Ultimate Azure API Management Course, 2022
- Leadership: Practical Leadership Skills, 2022
- MasterClass Software Testing with Jira & Agile-Be a QA Lead, 2022
- The Complete SQL Bootcamp 2022: Go from ZERO to Hero, 2022
- Machine Learning for Absolute Beginners - Level 1, 2022
- Machine Learning for Absolute Beginners - Level 2, 2022
- Scrum Master Certification 2024 + Agile Scrum Certification, 2024
Technicalsummary
Oracle, SQL Server 2005/2008, IBM DB2, Teradata, Selenium IDE, Selenium WebDriver, Eclipse, Maven, Test Director 8.0, Quality Center, qTest, WinRunner 7.0, Quick Test Pro (QTP) 8.2/8.0, LoadRunner 8.0, PL/SQL, T-SQL, SQL, XSLT, Visual Basic, Perl, Shell Scripting, MS Office Suite, MS Project, Microsoft SharePoint (2010, 2013, and Online), UNIX, Linux, Windows, RequisitePro, ClearCase, ClearQuest, Manual Tester, Rally, VSTS 2008, METAL, SQL Server Analysis Services (SSAS), TOAD 9.2, WinSQL, Teradata SQL Assistant, SSIS, SSAS, SSRS, XML, HTML, JavaScript, VBScript, Web Services, SOAP, WSDL
Personal Information
Citizenship: U.S.A Citizen
Languages
English
Full Professional
Gujarati
Professional
Hindi
Professional
Timeline
Sr. Quality Assurance Analyst Manager/Lead
Edward Jones Investments
07.2021 - Current
Sr. Quality Assurance Analyst Lead
CCC Information Services Inc
03.2019 - 12.2020
Sr. ETL / DW Tester Manager/Lead
BLUE CROSS BLUE SHIELD (HCSC)
12.2018 - 03.2019
Sr. ETL / DW Tester Lead
BLUE CROSS BLUE SHIELD ASSOCIATION
01.2018 - 12.2018
Sr. ETL / DW Tester
BLUE CROSS BLUE SHIELD ASSOCIATION
01.2016 - 12.2017
Sr. ETL Tester
DOLLAR GENERAL
04.2015 - 01.2016
MasterClass Software Testing with Jira & Agile-Be a QA Lead -
Udemy
The Complete SQL Bootcamp 2022: Go from ZERO to Hero -
Udemy
Leadership: Practical Leadership Skills -
Udemy
Basics of Scrum, Agile And Project Delivery -
Udemy
Certified Scaled Agile SAFe 5 -
Scaled Agile, Inc.
Agile at Work: Driving Productive Agile Meetings -
LinkedIn
AWS Certified Developer - Associate -
Amazon
Bachelor of Arts - History And Economics
N.S. Patel Arts College
Similar Profiles
Eric FitzgeraldEric Fitzgerald
Insurance Annuity Specialist at Edward Jones InvestmentsInsurance Annuity Specialist at Edward Jones Investments
Eric NavarroEric Navarro
Office Manager at Edward Jones InvestmentsOffice Manager at Edward Jones Investments
Kirsten CrattyKirsten Cratty
Branch Office Administrator at Edward Jones InvestmentsBranch Office Administrator at Edward Jones Investments
Matthew DemingMatthew Deming
Securities Information Manager at Edward Jones InvestmentsSecurities Information Manager at Edward Jones Investments
Matthew GenestMatthew Genest
Quality Assurance Team Lead / Quality Assurance Analyst at BM TechnologiesQuality Assurance Team Lead / Quality Assurance Analyst at BM Technologies