JERIN T. JAMES
Tampa,USA
Summary
- Having 15+ years of IT experience in Software Testing and strong Domain expertise in Financial, Banking, and clinical Systems.
- Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
- Solid Back End Testing experience by writing and executing SQL/PL-SQL/ T-SQL.
- Extensively strong on databases including MS SQL Server 2000 /2005/2008, Oracle /11g10g/9i/8i, Teradata V2R6/12/13, DB2 8.x.
- Conducted functional, integration, regression and UAT of the applications.
- Experienced in planning and executing System, Integration, Functional Testing, Regression Testing, Performance, and UAT Testing.
- Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrix.
- Expertise in designing the test scenarios and scripting the test cases in order to test the application.
- Expertise in Testing complex Business rules by creating mapping and various transformations.
- Good understanding of OOPS concepts.
- Conducted Automation testing using selenium using Java in TestNG Framework.
- Good experience in data centric.
- Experience in mobile, Tablet App testing. Good experience in adhoc Testing. Extensive experience in Black Box Testing, User Acceptance Testing and Database Testing.
Overview
10
10
years of professional experience
Work History
Tester
DTCC
Tampa, FL
01.2021 - Current
- Created, maintained, and executed epic-based test cases
- Used JIRA, Microfocus ALM, Bitbucket, Git, and Jenkins
- Experience in smoke testing, Functional Testing, UAT Testing as well as regression testing
- Experience in service now, Created, monitored and approved using service catalog workflow items to generate RITM tickets in servicenow
- Experience in Importing and exporting and modified XML data for validate data for testing purposes
- Experience in SQL
- Experience in Tableau
- Experience in working as a tester with Disaster Recovery and fallback and audit results review
- Worked with sales force environment (Classic version)
- Experience in ITDR reports workflow solutions that provide value in detecting and preventing cyberattacks
- Experience in API testing using Postman
- Experience in Capital Market domain and trade lifecycles
- Good experience in Equities, debt and Settlement services
- Experience in Waterfall linear approach
- Experience in working with multiple projects
- Managed offshore team projects
- Experience in Agile methodologies
- Participated and aware of all sorts of agile ceremonies (user story grooming, sprint planning, sprint retrospectives)
- Able to break the larger epics into smaller user stories
- Experience in Collibra
- Proficient in creating user stories and estimating them accurately using story points
- Experience analyzing client requirements, conducting review meetings, directing teams, and working with functional teams
- Experienced in Agile/Waterfall, onsite/offshore work model and coordination
- Experience presenting to business users/stakeholders
QA Analyst (Contract)
DTCC
Tampa, FL
06.2019 - 01.2021
- Responsible for verifying the build in the lower and higher environment
- Responsible for work with Functional team
- Work closely with team during the deployment and report issues accordingly
- Responsible for finish the testing in the allowed time
- Define Test sets, created test scenarios on Application Lifecycle Management ALM software
- Work on CMS features like format-management, indexing, version-control to manage client data
- Execute test runs and map UAT test cases and test scenarios in ALM
- Retest defects using Manual Testing, and update the defects using JIRA
- Actively participate in the UAT transition, retested UAT defects and updated comments in JIRA on client feedback
Database Test Engineer
Freelancing Project
NY
10.2018 - 05.2019
- Closely involved in gathering requirements, design, development and implementation of the project
- Developed relational databases optimized to provide data to websites
- Analyzed and interpreted data feed sources (FTP connections, direct server queries, raw data files) to migrate data from various data formats into SQL Server databases using daily automated import processes (DTS and SSIS packages, etc.)
- Ran and validated current scripts provided by the Data Warehouse team and modify, expand and improve necessary test scripts for reuse and automation purposes
- Responsible for analysis of current programs including performance, diagnosis and troubleshooting of problem programs
- Knowledge of schema changes, store procedure and database reporting
- Deep knowledge of Relational Databases
- Responsible for validating data mining models
- Responsible for validating XML structure
Backend Tester (Contract)
Capital Confirmation Inc.
Tampa, FL
08.2017 - 09.2018
- Company Overview: Audit confirmation platform is used by thousands of accounting firms, law firms, banks, and companies worldwide
- World’s leading provider of secure online audit confirmations
- Tested application and verified data table content by using SQL queries
- Used SQL tools to run SQL queries and validate the data loaded in to the target tables
- Performed database testing such as data integrity, accuracy of stored data, data type, data size, data security, and database performance
- Assisted in the planning of testing for applications
- Work closely with the Data Warehouse and Business Intelligence teams to test data load processes
- Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL
- Loader
- Involved in writing complex SQL Scripts (Multi-Join, Unions) using Toad, WinSQL and SQL Developer
- Performed Backend Testing by using SQL Queries for the purpose of database integrity
- Reviewed system documentation, identifying test objectives, developing/updating test scenarios, and executing functional and regression test scenarios for a web-based application
- Created and executed test scenarios in addition to analyzing and clearly documenting all programming defects software bugs
- Created SQL queries against a relational database when necessary to verify business scenarios
- Conducted Regression testing on written test cases
- Used SOAP UI to execute the test cases
- Checked the release of functionalities before executions of test case using Atlassian Confluence
- Performed Manual Testing on various modules of the application
- Conducted cross-browser testing
- Worked on organizing the client data using CMS features like format-management and indexing
- Worked on data migration and executed test cases to perform integration testing
- Retested Defects using Manual Testing, and update the defects using JIRA
- Performed daily smoke testing and updated comments using Manual Testing
- Conducted system testing for comprehensive data using Manual Testing
- Audit confirmation platform is used by thousands of accounting firms, law firms, banks, and companies worldwide
- World’s leading provider of secure online audit confirmations
- Environment: SQL Server 2005/2008, SSIS, VBScript, XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)
Tester (Contract)
Keystone Mercy
Philadelphia, PA
02.2017 - 07.2017
- Company Overview: Keystone First is Pennsylvania's largest Medical Assistance (Medicaid) managed care health plan serving more than 300,000 Medical Assistance recipients in Southeastern Pennsylvania
- Involved in the Review of Requirements Specification with functional manager and technical specialists of the application
- Designed and executed Test Plans and Test Cases, generate Test Scripts and Test scenarios
- Prepared Test cases, according to the business specification and wrote test scripts and maintained them
- Prepared proper documentation with reference to company policy
- Implemented the whole life cycle of QA methodology starting from planning, capturing, creating, executing reporting and tracking the defects using Test Director
- Keystone First is Pennsylvania's largest Medical Assistance (Medicaid) managed care health plan serving more than 300,000 Medical Assistance recipients in Southeastern Pennsylvania
- Environment: FACETS, Quick Test Pro, Test Director, Facets, Windows XP, C++, PL/SQL, Oracle, UNIX, Manual Testing
QA Analyst (Contract)
Worldselectshop
Tampa, FL
07.2015 - 12.2016
- Participated in client onboarding process
- Coordinated the activities required to meet these quality standards
- Worked as manual tester to create test scenarios, test plan, test cases of system design documents
- Involved in Regression, Functional, Integration, System and User acceptance Testing
- Mapped the Requirement to test cases (Traceability) for SIT and UAT
- Worked all the phases of software testing life cycle
- Implemented Agile (Scrum) QA methodologies
- Preparation of Defect Metrics and Productivity Metrics for the team, worked as back end tester worked in creating manual test cases
- Responsible for conducting the weekly quality assurance review meetings with the development team manager, SMEs and the tester to review the results
- Involved in testing data integration, System integration and Business Workflow
- Identified automated Testing Approach
- Strong experience in defect life cycle
- Strong experience in exploratory testing, Functional testing, regression testing, integration, sanity, smoke testing, User acceptance testing and back end testing
- Environment: JavaScript, PHP, HP ALM, Rally, SVN, TFS
Education
Master - Computer Application
Anna University
IndiaBachelors degree - computer science
Bhartihar University
IndiaSkills
- Windows 98
- Windows XP
- Windows 2000
- Windows 2003
- Windows Seven
- Macintosh
- Ubuntu
- UNIX
- Quality Center
- Test Director
- Mantis
- Jira
- Microsoft Test Manager
- C
- C
- PHP
- Net
- Java
- Selenium
- TFS
- HTML
- XML
- CSS
- Python
- JavaScript
- SQL Server
- Zephyr
- Tester suite
- Test Collab
- Nmap
- Metasploit
- Silk mobile
- Calabash
- IOS-driver
- Robotium
- Appium
- Rally
- Perfecto
- Load runner
Technical Summary
Windows 98, Windows XP, Windows 2000, Windows 2003, Windows 7, Macintosh, Ubuntu, UNIX, Quality Center (QC) 8.0/9.0/10.0, Test Director 7.2/7.5/8.0, Mantis, Jira, Microsoft Test Manager, C, C++, PHP, .Net, Java, RC & Web driver, TFS, Selenium IDE, Firebug, HTML, XML, CSS, Python, JavaScript, SQL Server 2000, SQL Server 2005, SQL Server 2008, Zephyr, Tester suite, Test Collab, Nmap, Metasploit, Silk mobile, Calabash –android, IOS-driver, Robotium, Appium, Rally, Perfecto, Load runner, Test director
Timeline
Tester
DTCC
01.2021 - Current
QA Analyst (Contract)
DTCC
06.2019 - 01.2021
Database Test Engineer
Freelancing Project
10.2018 - 05.2019
Backend Tester (Contract)
Capital Confirmation Inc.
08.2017 - 09.2018
Tester (Contract)
Keystone Mercy
02.2017 - 07.2017
QA Analyst (Contract)
Worldselectshop
07.2015 - 12.2016
Master - Computer Application
Anna University
Bachelors degree - computer science
Bhartihar University
Similar Profiles
Deijah SimonDeijah Simon
EDGE IT BSA at DTCCEDGE IT BSA at DTCC
Santosh ReddySantosh Reddy
Senior Technical Lead at DTCCSenior Technical Lead at DTCC
Adam KaddahAdam Kaddah
Learning Program Manager at DTCCLearning Program Manager at DTCC
Nicholas CarlinNicholas Carlin
Regional Sales Representative at CrossBoss MediaRegional Sales Representative at CrossBoss Media
Jasmine JohnsonJasmine Johnson
Customer Service Representative at Catalyst SolutionsCustomer Service Representative at Catalyst Solutions