Data Jira

Deepak Khadka

Email:adjku1@r.postjobfree.com Work Authorization: US Citizen

Ph # 571-***-****

PROFESSIONAL SUMMARY:

* **** ***** ** ** experience, as a Lead QA Analyst and QA Tester in the Healthcare, Banking (Financial), Education and Manufacturing domain.

Working knowledge on Software Development Life Cycle (SDLC) and project life cycle, Waterfall model and Agile methodologies.

Experienced in the creation of use cases and the development and maintenance of test specifications, test planning, test cases, test scripts and test data.

Performed Manual Testing like Positive testing and Negative Testing using test cases.

Experience in working with agile methodologies and active participant of SCRUM meetings.

Experienced in various types of testing including Black Box Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing and Regression Testing of Stand-alone, Web Based and Client-Server applications.

Attended requirements and design meetings, review and analysis of requirements and design documentation.

Excellent understanding of all modules of Quality Center/ALM (Application Lifecycle Management) such as Requirements, Release, Test Plan, Test Lab, Defects and Analysis feature.

Working knowledge of creating different types of test reports through Quality Center such as Test Execution Status/Summary, Defect Status/Summary, Defect Injection rate etc.

Participated in design walkthroughs and verified Quality Center Test Scripts and results.

Proficient in developing and maintaining of functions, procedures, triggers, indexes using MySQL and Oracle database programming languages using tools such as TOAD and MySQL Database,Microsoft Management Studio.

Expertise in back end testing and writing SQL queries, Joins, Procedures using Oracle and SQL Server.

Performed Structural changes to Database like creating tables, adding columns according to business requirement.

Performing Mobile testing in UAT, SIT, Prod fix and Production.

Experience with testing a web-based payment/banking gateway application that would be used by the clients to transfer funds electronically using ACH Payment and Wire transfer.

Knowledge on Electronic data interchange (EDI) transaction, All scripts Electronic Health Record (EHR) and Health Information Technology (HIT)

Familiar with HIPAA EDI transactions such as 834, 837 (P, D, I) 270,271 etc

Effective Time Management Skills and consistent ability to work in fast paced environment to meet client deadline.

Creating Automation Script using VB Script in UFT and working with data driven framework.

Performed Automation testing using UFT to SAP Logon.

Excellent analytical, problem solving, presentation, and interpersonal skills.

Extremely focused and detail oriented with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment.

TECHNICAL SKILLS

Project Methodologies: Waterfall, Agile, SCRUM

Languages: C, C++, Java, Java Script, UNIX, Linux, SQL, MySQL, Mainframe, VB Script, .NET, COBOL

Web Technologies: HTML, XML, CSS, JavaScript, Java, CSV, JSON.

Testing tools: Mercury Quality Center 9.2, HP ALM 11, 12, Adobe report builder, Jira X-Ray, QTP/UFT, Telerik Test Studio, Jenkins, Selenium Web Driver

SCM Tools: Tortoise SVN

Defect Tracking Tools: HP ALM, JIRA, Rally, HP Quality Center, Clear Quest

Operating Systems: Windows XP/Vista/7, Mac OS, Android, Linux, Mainframe

Database: Oracle, DB2, SQL Server, Mainframe, IBM Db2 on Cloud

Query Tools: MS SQL Server (Management Studio), Oracle (TOAD), SQL Developer

Business Applications: Microsoft Office Suite – MS Word, Excel, PowerPoint, Outlook, MS Visio, Citrix, VM Ware

Certification:

Automation Tester using Selenium

Fundamentals of Java Development

Programming Foundations with JavaScript, HTML and CSS

Databases and SQL for Data Science

Agile with Atlassian Jira

PROFESSIONAL EXPERIENCE

Employer: Wells Fargo Bank, Charlotte, NC

Oct 2019- Present

Role: System QA Analyst

Wells Fargo Treasury Management have lockbox system which is collection mechanism in which mail containing payments bypasses corporate offices, going directly to bank of deposit reducing collection float. After deposit of the check, remittance advices, photocopies of the check and other supporting material are forwarded to the corporate credit payment. The lockbox is the most widely used service for accelerating the collection of remittances.

Responsibilities:

Developing test plan, test scenarios, test strategy and taking part in different phase of testing.

Developing requirement matrix and providing estimation for testing efforts to team.

Attending daily standup calls, defect triage calls, sprint planning and sprint retrospective as providing feedback.

Providing application demo and allocation of story points in each sprint.

Executing test cases in ALM and keeping track of defects in both ALM and Jira.

Validating front end WLI (Wholesale Lockbox Image) application to verify if any data change has been populated in User Interface.

Working with backend system to make sure data populated in UI is correct.

Cross referencing validation between UI and backend application.

Validating application in different environment UAT, SIT, PFIX and Production.

Making sure data flow is correct from LIDDS and LADRS, Data displayed in WLI application is correct.

Validating WLI application populate correct lockbox site code, account number, DDA (Demand Deposit Account), batch number, check number, check amount etc.

Validating WLI application generates correct lockbox details report, cash equivalent report and Lockbox Availability from TIR (Treasury Information Reporting System).

Creating complex SQL statements to validate data populated in report is correct and compares it with UI of WLI.

Performing End to End testing for WLI application in UAT.

Execute batch jobs to generate reports.

Creating automation scripts using WAF BDD framework with Cucumber.

Submitting jobs using Vulcan and distribution of test result to team through QMETERY.

Creating, Enhancing, debugging and Running Test Cases.

Modify scripts for WLI application using Selenium Web Driver to perform regression testing.

Participating in production application and CR implementation.

Validate IFI (Image File Import) generates correct image of check deposited by the customers.

Validate BIR (Batch Image Retrieval) data and image is correct in the report.

Cross browser testing for WLI application in Internet explorer, Google Chrome and Firefox Mozilla.

Performing mobile testing in various iOS and Android devices in different browsers and Wells Fargo native app.

Data mapping for backend fields and WLI front end application.

Validation of data populated in WLI application according to the business logic.

Create test scripts with guideline of user stories in each sprints execute it and login defect if it doesn’t meet business requirements.

Guidance to less experience team members in the team.

Environment: Agile, Microsoft SQL Server, Microsoft SQL Server Management Studio, Batch Testing, WLI (Wholesale Lockbox Image), ALM, Selenium Web Driver, TestNG, Jira, Jenkins, GitHub, SharePoint, Outlook, IE, Firefox, Chrome, Citrix.

Employer: Fujitsu America, Durham, NC

Client: Minnesota Department of Education (MDE)

Feb 2019- Oct 2019

Role: Senior Technical Consultant/Lead QA Analyst

Fujitsu is collaboration with Minnesota Department of Education (MDE) in regards with the MDE Modernization project. The purpose of this project is to convert the 30 Minnesota Department of Education (MDE) applications hosted on the Unisys Clear Path mainframe to a web application architecture running on a modern Microsoft Windows Server and Microsoft SQL Server environment. The primary drivers for this project are the rising costs of maintaining the Unisys Clear Path mainframe and the anticipated difficulty in finding COBOL developers experienced in the Unisys Clear Path and DMS-II environment.

Responsibilities:

As a QA Lead developing test plan, test scenarios, test strategy and taking part in different phase of testing.

Attending daily client calls, validating defects raised by client, education business users to validate application.

Acting as liaison between clients and Fujitsu to verify regarding any testing topics.

Conducting daily defect calls and testing team meetings, assigning tasks to team.

Creating Dashboard and reports regarding testing execution and distributing it to management teams.

Executing test cases using Jira and comparing it with Windows UI and Mainframe and validating it is identical.

Executing batch jobs and generating user codes programs reports.

Using Microsoft Management Studio to retrieve data and validate report using SQL complex statement to data which has been populated in batch job.

Conduct batch testing and compare text report populated by code to the pdf report send by MDE.

Use Telerik Test Studio automation tool to automate manual scripts and records data used for testing for execution of scripts.

Import test cases in Jira using X-ray from excel spreadsheet and execute them in Jira.

Maintain and create Jira work flow for testing team.

Mapping and verifying between programs send by MDE and related test cases before it is send to team for testing.

Assigning programs and test cases in Jira to team members.

Creating defect and assigning it to right person on Jira and tracking of those defect.

Checking test case quality sends by MDE to Fujitsu for testing.

Environment: Telerik Test Studio, Beyond Compare, Microsoft SQL Server, Microsoft SQL Server Management Studio,Batch Testing, FileZilla Backup, Mainframe, and Microsoft Visual Studio, Tortoise SVN, Jira, Jenkins,Windows, SharePoint, Outlook, IE, Firefox, Chrome, Citrix.

Employer: CGI INC

Client: BMW Manufacturing Group, Spartanburg, SC

June 2017- Feb 2019

Role: Lead QA Analyst

The next generation of BMW X5 PHEV (G05 PHEV) will be produced at Plant Spartanburg. It will replace the current F15 PHEV. The G05/06/07 IT program (GRIPPS ID: PR-007234) covers all necessary IT measures to support the successful introduction of the new LG models including the G05 PHEV at Plant 10.

Objectives of this is to design a future orientated IT solution to fulfill the requirements for the G05 PHEV HVB assembly including inbound and outbound processes in such a way that the additional variant for the G01 PHEV can be assembled without additional software changes. Future changes for a planned export capability can be kept at a minimum. It aligns with the target IT landscape. Implement the template solution for HVB production according to Plant 2.2 Dingolfing for production control functions (STARD FP, IPS-C) Successful deployment of the IT solutions in time to support the G05 PHEV launch as well as the subsequent G01 PHEV launch. The established solution including the underlying IT infrastructure has to fulfill all standard operations requirements defined within the applicable SLAs and handing over of the implemented solution to the defined maintenance and operations organization (including support structure and service level).

Responsibilities:

As a QA Lead developing test plan, test scenarios, test strategy and taking part in different phase of testing.

Attending requirement analysis and Business requirement Documents meetings.

Creating project structure for the project and assigning it to release and various sprint cycles in ALM (Application Lifecycle Management).

Prepare and distribution of testing execution Dashboard to Management, Business Sponsor and Release management.

Create projects, Sprints and Release Management in ALM according to due date of projects.

Developing and uploading test cases in ALM and assigning it to right (project > cycle> Sprint) and to right KU (Key Users).

Providing access of ALM projects to key user and IT team who are involved in testing with correct authorization privilege.

Develop test handbook for various projects.

Involvement in Integration and System integration testing (IT testing).

Conduct defect meeting and escalate it according to the priority and severity of the defect.

Login and Keep track of defect and testing activities.

Guidance to less experience testing resources, helping team regarding any issue with ALM access and troubleshoot.

Helping automation team to create script, verification of scripts using UFT (Unified Functional Testing) tool.

Creating and modifying data driven VB Script using excel spreadsheet ad ins with UFT which will be compatibility to SAP Logon.

Validating automated test scripts in MCQ (Testing Environment) and MCP (Pre-production Environment).

Execute automation test cases for Material planning, demand and consumption, finance and warehousing for each release management to provide report to Upper Management.

Provide testing estimate timeline to management team for testing planning for the various projects.

Involvement in creating test script and review them with business stake holders to get feedback from business to make sure we imply correct functionality as business expectation.

Provide training to Key User to use ALM and login defect on it.

Work with IT and Key User during line balance, material refresh testing to provide assistance regarding testing activities.

Conduct testing for each release management with IT team and Key User stake holders.

Environment: Agile, SAP, ALM,JIRA,UFT, HTML, XML, UML, MS Office, Windows XP/2000, Java, MYSQL, SQL Server, Oracle,,Toad, SharePoint, Outlook, Internet Explorer, Mozilla, Chrome,Web Services.

Employer: Tek System

Client: HSBC Bank, Buffalo, NY

Sep 2016 – June 2017

Role: Lead QA Analyst

HSBC is currently running on IBM’s Portal Server (WPS) 6.0 platform which will no longer be supported by IBM after 2Q2016. WPS 6.0 supports multiple PWS and PIB functions in production therefore require and upgrade to the newer WPS version 7.0 so that we remain on the supported IBM platform. So, PWS migration is required. DCO (Digital Customer On boarding) is another project in which HSBC bank is offering credit cards to customers who necessarily doesn’t have accounts with HSBC bank. Objective of this project is to go out to market offering credit cards to customers who fulfill the requirements to get credit cards from HSBC.

Responsibilities:

Developed Test Plan, Test Cases, Test Scenario and User Stories for mobile application and web application to support PWS (Public Web Site), GETS (Gifts and Entertainment Tracking System), DCO (Digital Customer On boarding) Cards and RMP (Relationship Management Program) projects.

Conduct defect tracking meeting each day and week depending upon requirement and nature of project.

Prepare and distribution of forecast and Testing execution Dashboard for SIT and UAT phase of testing to the Management and Release Management.

Upload test cases in Quality Center according to project and allocate them to requirement project and resources.

Verifying DCO customer in MDM (Master Data Management), Validating it in CIF (Customer information File), Json, Avoka Transact Manager and Groovy Log.

Performed UAT, Functional, Non-Functional, Integration, Regression, Smoke and Sanity Testing

Planned, coordinated, and monitored project levels of performance and activities to ensure project completion before or On-Schedule with Onshore and Offshore Team. Participated in writing data mapping documents and performing gap and Impact analysis on the systems as point of contact for PSW migration Team.

Testing DCO Card application using COBOL Languages and JCL.

Supervise and guide to new and less experience team members.

Worked on cross-functional project teams compromised of Software Verification Engineers, System Engineers and Human Factor Engineers.

Extensively worked with Development Engineers and Tech support personnel to recreate and resolve systems issues.

Performed SIT Front-End and Back-End testing for mobile app and web application.

Research the scope of the Business need and created user story.

Performed Backend Testing by writing SQL statements to review the returned data to ensure that the correct data was retrieved.

Validating data from source to target.

Developed and executed several SQL queries for backend testing.

Planned, coordinated, and monitored project levels of performance and activities to ensure project completion before or On-Schedule. Participated in writing data mapping documents and performing gap analysis on the systems.

Performed Smoke, Regression, Integration, UAT Testing.

Involvement in mobile testing for iOS and andoriod devices in various browsers.

Reviewed extensive SQL Queries with complex multi-table joins and nested queries.

Created and managed system testing schedule.

Running smoke tests and daily health checks in QA environment to ensure services are up and running.

Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.

Conducted regression testing on new builds/versions.

Environment: Agile, ALM, HTML, XML, UML, MS Office, Windows XP/2000, Java, MYSQL, SQL Server, Oracle, Mainframe,COBOL,JCL,DB2,Toad, SharePoint, Outlook,iOS, Android, Internet Explorer, Mozilla, Chrome,Web Services.

Employer: Tek System

Client: Wells Fargo Bank, Winston-Salem, NC

May 2015-Sep 2016

Role: System QA Analyst

Wells Fargo uses internal tool ARTi ( Analysis Re-pricing Tool Intranet) for Re-pricing project to implement strategy changes to simplify customer billing that introduce new elements ID’s to bill for new services or changes to services and Align pricing across price class and lines of business. So, Wells Fargo can increase revenue hosted by Treasury Management. Report testing for TIR (Treasury Information Report) application in CEO portal was one of validation procedure for verifying changes.

Responsibilities:

Developed detailed Test Cases based on Functional Design Documents (FSD) and Business Required Documents (BRD).

Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings.

Performed production incident testing for fixes and closed the defect tickets in HP ALM.

Reporting and tracking the detected defects by using HP ALM.

Involved in back end testing using SQL query for data validation and generating reports.

Tested different detail, summary reports and on demand reports.

Conducted regression testing on new builds/versions.

Performed Grey Box, White box testing, Black box testing and User Acceptance Testing.

Mobile testing for break-even page, responsive of application in mobile.

Report testing for TIR (Treasury Information Report) application.

Performed White Box Testing for entire application.

Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.

Performing UI testing in UAT environment.

Experience with testing a web-based payment/banking gateway application that would be used by the clients to transfer funds electronically using ACH Payment and Wire transfer.

Testing TIR application in different browsers (IE11, IE10, IE8, Firefox, and Chrome).

Testing TIR application in various devices with different operating system such as IOS, Android.

Mobile testing for Responsive Design, Breakpoint and Framework Component for different devices ( IPhone6s, I Phone 6,IPhone5s,IPhone5, Samsung Galaxy s4 and s5, Samsung tablet, iPad mini, iPad, HTC one, Motorola razor etc. )

Validating wireframe and break points in different browser and devices.

Validating functionality, layout, filtering of application.

Validating data populated in report, writing complex SQL query against EWI database.

Performing regression, detained regression for various report in different environment ( UAT, SIT, Prod fix and Production )

Testing ACH payment, Wire Transfer, E-Box, Lockbox Detail reports with legacy.

Generating reports in different browsers for various formats (HTML, PDF, CSV, EXCEL, BAI v2 and FPF) and comparing populated reports with Quick report panel and Account panel.

Generating reports in mobile in HTML and PDF format and comparing it to mockup and legacy.

Comparing different report using adobe report builder.

Environment: SQL Server 2008, Mainframe, HP ALM 12.0, Adobe report builder, Windows, MS office, HTML, SQL, MS Office, Share Point, Regression Testing, System Testing, Outlook, IOS, Android, IE11,IE10,IE8,Firefox,Chrome.

Employer: Neftek Inc

Client: BCBSM, Detroit, MI

Nov 2014 – May 2015

Role: QA Analyst /Data Analyst

Blue Cross Blue Shield of Michigan (BCBSM) uses Edge server, external data gathering environment via Centers for Medicare and Medicaid Services (CMS) that proposed a rule amending Revenue Management and Risk Adjustment (RMRA), risk corridor and reinsurance rules. BCBSM under Affordable Care Act (AAC) changed the way healthcare is financed, delivered and regulated.

Responsibilities:

Validating data and performing backend testing.

Involved in writing and reviewing the test scripts.

Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings.

Involved in gathering Functional Requirements, Business Requirements and Design Documents.

Developed detailed Test Cases based on the Functional Requirements and Design Documents.

Identified the test data to execute the test cases.

Experience in automation testing using QTP and UFT to test the functionality of the application.

Create and execute test script in QTP/UFT for regression testing and perfume Data Driven test using test data from excel file.

Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.

Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Test Manager.

Developed IT SOX compliance internal audit controls, procedures, testing, and reporting documentation.

Created and implemented test cases for EDI files generated for various transactions as 834 .

Tested for 270/271 EDI Transactions.

Performed User Acceptance Testing (UAT).

Was responsible for UAT execution and tracked and managed defects and enhancements.

Worked with business to create controlled UAT input data.

Created tickets for all defects and enhancements identified in UAT.

Created daily status reports during UAT execution. Involved in regular reports, feedback and communication with the management

Data validation and testing for DQ tickets/error analysis based on business requirements, ICD and other related documents.

Extracting required data from EDGE complete and loading it to sandbox for each error assigned.

Update share point with analysis notes/document for review.

Created Pivot tables for HEBW custom reports for claims matching highest rank.

Convert xml reports to access for RA/RI analysis.

Involves interacting with business users to resolve data quality problems using techniques such as root cause analysis as well as collecting user requirements.

Identify, assess, document, and communicate potential quality issues in the way data is collected, stored, processed, or used.

Extensively used SQL to verify and validate the data loaded into Target.

Involved in extensive DATA validation using SQL queries and back-end testing.

Documentation of CMS and Altegra errors and presenting it in weekly touch point meeting.

Verifying and validating CMS and Altegra errors and providing solution approaches to fix those errors to IT team.

Environment: Oracle 11g, Quality Center 11,Mainframe, QTP/UFT,SQL Server 2012,Toad, SQL Developer, Windows XP, Unix, Web services, JUNIT, Web logic, Rational Team Concert 3.0, MS Office, Crystal reports, and HTML

Client: Washington Mutual Bank, Washington, DC

Feb. 2012 – Oct 2014

Role: Junior Tester

RLC (Reimbursement Letter of Credit) System is a negotiated financial instrument system developed for Chase Manhattan Bank. The system is designed, developed for RLC purposes basically contains instructions to the negotiating bank, a bank other than the issuing bank of the L/C, authorizing claim reimbursement on a third bank upon compliance with the terms of L/C. RLC is developed utilizing SQL Server as database on Windows NT platform as its data stores and Java Script as frontend. Test cases are written and executed to increase both coverage and depth of testing.

Responsibilities:

Determined test objectives through detailed analysis in order to test features comprehensively.

Developed, planned and implemented manual test cases based on software requirements and technical understanding, as well as developed and extended the current test infrastructure to be more efficient, both in execution and reporting.

Updated test cases according to changed requirements as well as using Rally for regression testing.

Identified software capability and reliability by conducting functional, system, and regression tests.

Documented and reported test outcomes by collecting, analyzing, interpreting and summarizing data to development team.

Assisted in reproducing, investigating and debugging software issues in coordination with the development team.

Worked with minimal supervision, whilst being responsive in a fast paced development environment. Also, mentored others in software testing best practices.

Environment: Rally, SQL, Windows XP.

EDUCATION:

Bachelor of Science in Management

Contact this candidate