Data Test
Resume:
Kirti Aggarwal
(Email Id: ********@*****.**.**)
PROFESSIONAL SUMMARY:
•10 years of IT experience in Quality Assurance, Business/Data Analysis & ETL development.
•Expertise in Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Defect life cycle, QA Processes, testing methodologies and testing strategies.
•Extensive experience in Web services testing using SOAP UI tool.
•Familiar with automated testing with tools such as Selenium IDE, Selenium WebDriver, Selenium Grid, TestNG, Cucumber, Blue Prism
•Familiar with CI/CD, TDD+BDD testing approaches.
•Proficient in writing SQL scripts.
•Worked extensively in ETL development and testing using Ab Initio ETL Tool, Investigation tools like Vista Investigation Tool, Actimize and BI tools like tableau etc.
•Worked extensively with Teradata and Snowflake database for data analysis and data validations.
•Very Good Knowledge of Unix and Linux operating systems.
•Extensive experience in analyzing business requirements, data analysis, SQL creation, ETL development, creating documentation for entire software life cycle which includes documenting requirements, creating source to target documents, creating test plans, test scenarios, test cases, traceability matrix, test data, defect management reports & matrices.
•Extensive experience in functional testing, non-functional, unit testing, integration testing, regression testing, GUI testing, positive-negative testing and database testing.
•Extensive experience in defect tracking & defect management from the discovery of defects, submitting the defects and tracking the defect status in defect tracking tools till its closure.
•Worked extensively on post install validations and providing production support.
•Domain Expertise in Anti Money Laundering, KYC, Sanction Screening, Healthcare, Utility and Security Services
•Extensive experience in delivering small, medium and large scale features in Agile/Scrum project management methodology which includes fixing Production Incidents within budget and on time by effectively collaborating with multiple teams.
•Extensive experience in using the HP ALM and JIRA for the entire project life cycle.
•Proven ability to support multiple projects under tight deadlines, often with competing priorities and complexities.
•Ability to learn quickly and to correctly apply new tools and technologies.
•Strong team player and possess sound interpersonal skills.
•Capable of applying expert judgment to the removal of impediments, highly focused and motivated and delivering success in rapidly evolving and dynamic environments.
Technical Experience:
Technical Tools:
Ab Initio ETL Tool, Selenium IDE, Selenium WebDriver & Grid, HP ALM, TestDirector, SOAP UI, Firebug, ChroPath, TestNG, Cucumber, BluePrism
Configuration Tools
GIT, Clear Case, Visual Source Safe and CVS.
Defect Tracking Tools
Bugzilla, Clear Quest, Jira, HP ALM and Client Specific Tools.
Languages
Java, JSP, HTML, XML,
Database
Teradata, Snowflake Database, Oracle DB, Microsoft SQL Server
Web Technologies
Tomcat and WebLogic.
Operating Systems
Unix, Windows 8 and above.
Others
MS Office 2019 (Word, Excel, Power Point and MS Outlook), MS teams, Eclipse IDE, Maven, Oracle SQL Server IDE, MS Visio, Tableau, Actimize, Vista Investigation Tool and various finance related tools.
Professional Experience:
Discover Financial Services Jan 2019 - Current
Address: 2500 Lake Cook Rd, Riverwoods, IL 60015
Sr. Business/Quality Analyst
Worked extensively on various Anti-Money Laundering (AML) and Compliance Projects which includes Vista Investigation Tool for AML,KYC and FCI, Suspicious Activity Monitoring (SAM), Customer Risk Scoring (CRS), Sanctions screening, Compliance link, Sanctions metrics reporting, Fraud Aggregator, eCredit, Actimize for alerts/Case and SAR validations along with data analysis and data validations within various Bank, Card and Loan related source systems like ATLAS, ORION, Bank Fraud System, Calypso case management, FIAT/FIRE, Finacle, ATLAS, Orion, BankeSolutions, eSolutions, Focus, Compass, AOD, DLOS, Iovation etc
Responsibilities:
•Worked extensively in analyzing business requirements, data research, creating SQL queries, and ETL development using ab initio tool.
•Worked extensively in Creating test plans, test scenarios, test cases and execution for the successful completion of the project.
•Reviewed business and system requirements to create traceability matrix to identify the gap between requirements.
•Worked extensively in executing Unit tests, Smoke Tests, functional tests, Integration tests, Regression testing database tests and E2E testing etc
•Worked extensively in data research & validating data using various different tools like Tableau, Actimize, Vista investigation tool and other source systems like ATLAS, ORION, FIAT, Bank Fraud System, Calypso Case management, FIAT/FIRE, DLOS and AOD etc.
•Responsible for defect management and represented QA project teams in the Defect triage meetings with Business, development and design teams.
•Involved in project estimations, scheduling and delivery.
•Identified, investigated and worked in resolving various Project Issues/Risks.
•Worked with client to gather the information needed to set up the test environments.
•Used SQL extensively to conduct backend testing within Teradata and Snowflake database.
•Updated the project status to Senior Management and all other stakeholders on a regular basis.
•Worked with client to understand and resolve issues and maintain high level of client satisfaction.
•Coordinated the testing efforts between the team members to confirm the end to end testing results.
•Coordinated test plan/test case walkthroughs with business analyst, developers to acquire formal sign-off.
•Ensured the QC and QA standards and guidelines are followed by the team members.
•Tracking defects till closure and preparing test case reports through HP ALM, Reviewing the Test Reports and Preparing Test Summary Report
Tools and Technologies Used: Ab Initio Tool for ETL Development, Teradata, Snowflake, SQL creations, Database Testing using SQL Queries, ALM for creating test cases, test execution, defect management and generating reports, Actimize, Tableau, Vista Investigation Tool, Front End Systems like Orion, Atlas,BFU, Calypso, FIAT/FIRE Bank eSolutions etc.
Quadratic Systems Inc. Feb 2016– Jan 2019
Address: 1100 Woodfield Rd Ste 109, Schaumburg, IL 60173
Quality Analyst
Client: Discover Financial Services
Worked extensively on multiple highly visible Anti-Money Laundering (AML) and
Compliance Projects including Suspicious Activity Monitoring (SAM), Customer Risk Scoring
(CRS), Know Your Customer (KYC) team workflow and access restrictions, OFAC Sanctions Screening, Metrics Reporting, Partner Due Diligence (PDD), Client MDM, Vista Investigation Tool, Tableau, Actimize, CARs, Fraud Aggregator & Transactions Monitoring etc.
Responsibilities:
•Worked extensively in analyzing business requirements, data research, preparing test plans, test scenarios and test cases.
•Reviewed business and system requirements to create traceability matrix to identify the gap between requirements.
•Worked extensively in executing various types of testing which includes Unit Testing, Smoke Testing, functional testing, Integration Testing, Regression testing and E2E testing.
•Involved in testing data in Tableau, Actimize and Vista investigation tool.
•Responsible for defect management and represented the QA project teams in the Defect triage meetings with the Project Managers, development and design teams.
•Involved in project estimations, scheduling and delivery.
•Identified, investigated and helped resolve Project Issues/Risks.
•Worked with client to gather the information needed to set up the test environments.
•Used SQL extensively to conduct backend testing and test data management requirements.
•Updated the project status to Senior Management and all other stakeholders on a regular basis.
•Worked with client to understand and resolve issues and maintain high level of client satisfaction.
•Coordinated the testing efforts between the team members to confirm the end to end testing results.
•Coordinated test plan/test case walkthroughs with business analyst, developers to acquire formal sign-off.
•Ensured the QC and QA standards and guidelines are followed by the team members.
•Tracking defects till closure and preparing test case reports through HP ALM, Reviewing the Test Reports and Preparing Test Summary Report
Testing Tools and Technology: Teradata, Database Testing using SQL Queries, ALM for creating test cases, test execution, defect management and generating reports, Actimize, Tableau, Vista Investigation Tool, Front End Systems like Orion, Atlas etc.
Infosys Limited May 06 – Oct 10
Address: Plot No. 1, Rajiv Gandhi Technology Park, Kishangarh, Phase-I, Manimajra, Chandigarh, 160101, India
Technical QA Lead
Worked extensively on various domains like Utilities and Security Services etc.
Projects:
UtiliNet Solution Centre (USC) - A user interface which is used to collect meter reads, manage and monitor the network devices and maximize the value of automated meter reading data. It allows viewing reports, configuring the system, viewing data stored in the database or available through the network etc. The project involves testing of new features and maintenance of the USC as per the market needs and customer’s requirements.
BEA Aqua Logic Enterprise Security (ALES) - An application that allows the user to centrally define and manage policy to control access for both application software components as well as the application business objects that make up the application. Policy is evaluated and enforced locally in the application container so application context can be included as part of the access decision. Standards based’ Enterprise Security framework – Provides Application Level security. Helps enterprises define & control the security policy for multiple applications through one interface.
Responsibilities:
•Involved in analyzing business requirements, preparing test plans, test scenarios and test cases.
•Reviewed business and system requirements to create traceability matrix to identify the gap between requirements.
•Involved in defining the entry and exit criteria for the various milestones.
•Developed test strategy/plan for every project and release.
•Involved in executing Smoke Test, Black box Tests like Functional tests, Integration Tests, Regression tests and End to End tests.
•Responsible for defect management and represented the QA project teams in the Defect triage meetings with the Project Managers, development and design teams.
•Involved in project estimations, scheduling and delivery.
•Identified, investigated and helped resolve Project Issues/Risks.
•Worked with the client to gather the information needed to set up the test environments
•Used SQL extensively to conduct backend testing and test data management requirement
•Updated the project status to Senior Management and all other stakeholders on a regular basis.
•Worked with client to understand and resolve issues and maintain high level of client satisfaction.
•Coordinated the testing efforts between onshore and offshore team and with interfacing test teams to confirm the end to end testing results.
•Coordinated test plan walkthroughs with business analyst, developers to acquire formal signoff.
•Ensured the QC and QA standards and guidelines are followed by the team members.
•Point of contact for all the deployment activities and perform Smoke Test for the deployments on different (Dev/Test and UAT) environments.
•Analyzing the results and tracking defects till closure.
•Preparing traceability matrix, test case summary reports and defect status reports.
Testing Tools & Technology: HP Quality Center, Manual and Automation testing using UFT, DB testing using SQL queries, Clear Case, Share Point and Client specific defect tracking tool, report creation using HTML.
IGI (Infotech Global India) Ltd. Bangalore, India Aug 2005 – May 2006
Address: 1126, 18th Cross, 9th Main Rd, Sector 7, HSR Layout, Bengaluru, Karnataka 560102, India
Software Test Engineer
Worked extensively on various below listed Healthcare Projects.
Project(s):
MedCom Transaction Portal
MedCom ETS portal enables healthcare providers to check member eligibility via McKesson and IGI Networks, automate payment and easy pay solutions via Vital Network, process batch and data entry claims bundled through the IGI Network and then routed to the Medcom USA claims switch for payer or clearing house disbursement and offer claim status to the end user via front end edits and the WebMD payer claim status reporting. The goal of the application is to minimize the amount of data a provider’s office has to enter while keeping the system simple and user friendly. The goal of the product is to compliment and supplement the existing Medco USA POS solutions in the market.
Providers will be able to transmit transactions in the form of secure EDI files.
Responsibilities:
•Extensively involved in Business Analysis and requirements gathering
•Participated in BRD walkthroughs and analyzed business requirements, design document and prepared requirement review report
•Responsible for the effort estimation, planning, test case creation and execution of chunks of testing activities.
•Performed Smoke Testing, Ad-hoc testing in testing environment, Functional, Integration, System, Regression Testing, End to End and User Acceptance testing.
•Analyzing the test results and Defect tracking through defect tracking tools.
•Prepared test execution reports and traceability matrix.
•Performed load test to test the performance of the application.
Testing Tools & Technologies used: Manual Testing, Database Testing using SQL queries, load testing, ClearCase, ClearQuest and Client specific tools, UNIX.
Certifications: -
•Foundation Course in Software Testing Infosys (Technical)
•Java Foundation Course certification (Technical)
•Infosys Quality Foundation Certification Infosys (Process)
•Infosys Training (Generic)
•TestNG Certified by Udemy
•Cucumber Certified by Udemy
Academic: -
•B. Tech – Computer Science & Engineering– Kurukshetra University, India.
Contact this candidate