Achla Pathak

Mobile: 360-***-**** Email:ac7cfy@r.postjobfree.com

Professional Profile

●Over six years of diversified experience in systems analysis design development and testing applications in varying environments.

●Experience in testing Web-based / PC-based / E-commerce and Client-Server applications on different environments.

●Mentoring other members in the team. Involved in the complete software life cycle, ensuring that quality procedures are adhered and implemented.

●Developed functional specifications, user interfaces and application rules based on client’s requirements.

●Strong experience in developing Test Plans and Test cases using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.

●Expert in Installing, Configuring and Administering Mercury Automated Testing Tools (Win-Runner, Load Runner, Quality Center, Quick Test Pro, and Test Director).

●Experience in creating automation and integration scripts using Power Shell scripts

●Hands on experience on .

●Expertise in performing different types of Testing: Black box, Integration, Stress, Volume, System, Performance, and Regression.

●Good understanding of Relational Database Management Systems (Oracle, SQL Server).

●Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools like Test Director and Track Record, Team Foundation Server - TFS.

●Maintained various environments including creating and maintaining Virtual Machine and Microsoft Virtual PC.

●Involved in preparing Test data, creating and editing test data in XML schema.

●Excellent written & verbal communication skills, Documentation Skills, Team problem solving ability, analytical and programming skills in high speed, quality conscious, Multitasked environment.

●Very Good experience in using SQL Developer for backend testing.

●Experience with SDLCs: Waterfall, Spiral, Agile and/or Scrum.

●Exposure with QA Principle SEI CMM levels, ISO 9001, Software Development Analysis.

Education / Certifications / Trainings

●Masters in Business Administration (Punjab Technical University, India)

●Bachelors in Elective English (Guru Nanak Dev University, India)

●Advanced Diploma in e-commerce technologies

Technical Summary

●Functional Testing Tool: QTP8.2, WinRunner7.5, SoapUI, Postman

●Performance Testing Tool: Load Runner8.0.

●Defect Tracking Tools: Quality Center, Clear Quest, Visual Studio TFS

●Front End Tools: Visual Basic, MS Front Page

●Languages: C, C#, VB, VB Script, VBA, Python and SQL.

●Platforms: Windows 9x/NT/2000/XP/7, Unix/Linux, Mac

●Database: MS Access, Oracle, DB2, SQL Server, T-SQL, PL/SQL, PostgreSQL

●Scripting Language: VBScript, JavaScript

●Web Technologies: HTML, DHTML, XML Schema, Rest APIs, Web Services

●Bug Tracking Tools: Compuware’s Track Record, Issue Tracker, Team Foundation Server (TFS) 2013, Test Director

Engagements Overview

Project: Microsoft Windows Server Upgrade Guide July 2018 – till date

Company: Microsoft

Location: Redmond, WA

Role: Senior Software QA Engineer

Windows Server Upgrade Guide project is a marketing guide for customer to upgrade their windows servers. This guide helps customers in a step by step procedure to upgrade various versions of Windows Servers. Some servers follow the path to upgrade to on-prem and some follow the path to upgrade to Azure instances. Project is developed in ASP.Net Web APIs and with front end in Agular 5 and backend in GitHub and SQL Server.

Responsibilities:

Facilitated the definition of Test Plan, Test Strategies, QA goals and deliverables to all relevant stakeholders

Developed detailed Test Plans to monitor and track progress

Developed the Test Plan using Microsoft Test Professional

Negotiated resource availability and allocation in a matrixed environment

Provided direction and support to test team

Employed risk management techniques to minimize project and business risks

Prepared reports to communicate test progress, challenges and solutions

Utilized good change management practices to evaluate, implement and manage changes to scope, schedule and budget

Achieved time lines for each release’s regression and functional testing needs.

Worked and collaborated with other team members during the integration testing phases

Managed the offshore and onsite teams’ coordination and work

Automated, managed and integrated regression tests, and test suites using Selenium

Created hundreds of test cases from Use Cases and User Stories.

Performed cross browsers testing on all major browsers and various platforms

Environment: ASP.Net Web APIs, GitHub, Angular 5, SQL Server 2016

Project: Evosus Pro July 2015 – July 2018

Company: Evosus

Location: Vancouver, WA

Role: Software QA Engineer Lead

Evosus Pro provides SaaS based POS system to various Pool and Spa small business owners. Original system was developed in early 2000 and was developed in client server technologies. It installed the copy of the client to every customer location. The newer system is removing this requirement and all customers are connected to POS using a any web browser.

Responsibilities:

●Developed Test Strategies, Test Plans and lot of test cases.

●Lead the charge of training other teams in the company with QA processes and tools

●Lead and coordinated the onsite and offshore teams on QA processes and execution

●Worked and collaborated with other team members during the integration testing phases.

●Achieved time lines for each release’s regression and functional testing needs.

●Created Test Plan/Lab libraries in Test Manager (Jeera).

●Back end testing of Rest APIs using Postman

●Created hundreds of test cases from Use Cases and User Stories.

●Performed cross browsers testing on all major browsers and various platforms.

Environment: Ruby, MySQL, NodeJS, Google Firebase, MangoDB, Rest APIs

Project: Tiger and Tila-Respa Aug 2013 – Feb 2015

Company: D+H Financial Technologies

Location: Portland, OR

Role: Software QA Engineer Lead

D+H creates financial technologies the world’s financial institutions rely on every day to help them grow and succeed. Solutions that help move the world forward; because that’s what happens when the world knows it has financial institutions they can trust. This project involves updating the E3 software with new enhancements from Freddie Mac and Fannie Mae as per new federal regulations. The most recent enhancements resulted from TILA RESPA Changes October 2015 according to which 1. Loan Estimate: Buyers must receive the Loan Estimate document three days after their loan application 2. Closing Disclosure: Lenders must provide this document to mortgage clients three business days before closing. I was part of the team implementing these changes and hence the verification and testing of the same.

Responsibilities:

●Developed Test Strategies, Test Plans and lot of test cases.

●Lead the charge of training other teams in the company with QA processes and tools

●Lead and coordinated the onsite and offshore teams on QA processes and execution

●Worked and collaborated with other team members during the integration testing phases.

●Achieved time lines for each release’s regression and functional testing needs.

●Created Test Plan/Lab libraries in Test Manager (TFS).

●Created hundreds of test cases from Use Cases and User Stories.

●Performed cross browsers testing on all major browsers and various platforms.

●Worked in Agile project methodology and performed different duties of sprint cycles.

●Analysis and design of ETL processes using SQL Server Integration Services (SSIS)

●Rigorous data testing to verify data integrity of the result of ETL processes and Web Services

●Extensive use of MS SQL for verification of data and SSIS packages outcome.

Environment: ASP.Net, .Net 4.0, C#, IIS 7.0, Test Manager, SQL Server 2012 R2, TFS,SSRS, SSIS, ETL, SSAS.

Revenue Cycle Program Management System May 2012 – Aug 2013

Company: R S Medical

Location: Vancouver, WA

Role: Sr. QA Analyst

RS Medical is America's leading provider of physician-prescribed medical devices. Revenue Cycle Management System is an implementation of integration of work flows from various applications that contribute to the calculations of the revenue stream of the company. It has Sales Portal and MDM (Master Data management) UI as the web applications that provide the front interface to gather input from end users. Various ETL processes and SSIS packages are used to perform the data integration from legacy systems like DME2 and Master Data. A state of art deployment environments are created to move the releases from development to production comprises of various stages of testing.

Responsibilities:

●Rigorous data testing to verify data integrity of the result of ETL processes.

●Extensive use of MS SQL for verification of data and SSIS packages outcome.

●Developed Test Strategies, Test Plans and lot of test cases.

●Worked and collaborated with other team members during the integration testing phases.

●Achieved time lines for each release’s regression and functional testing needs.

●Created Test Plan/Lab libraries in Test Manager (TFS).

●Created hundreds of test cases from Use Cases and User Stories.

●Performed cross browsers testing on all major browsers and various platforms.

●Worked in Agile project methodology and performed different duties of sprint cycles.

Environment: ASP.Net, .Net 4.0, C#, IIS 7.0, Test Manager, SQL Server 2008 R2, TFS, SSRS, SSIS, ETL, SSAS, Zira

Online Banking Jan 2012 – May 2012

Company: US Bank

Location: Gresham, OR

Role: Sr. QA Analyst

Online Banking (OLB) is US Bank’s very ambitious project where it implements US Bank’s integration with Western Union Money Transfer, enhancement thru Zash-Pay(P2P), Online Bill Pay module update and enhancement to Cash advances module. Previously US Bank successfully implemented Retail Internet Banking project and so client is taking this success ton next level by implementing OLB. Its considered very crucial project and so requires very stringent testing of each and everything.

Responsibilities:

●End to End testing from requirement analysis to user acceptance

●Achieved business knowledge in financial domain.

●Extensive use of MS SQL for writing validation scripts.

●Extensive use of Microsoft TFS for managing stories backlog, documenting Test Plan and Bug tracking.

●Closely worked with Business process lead (BPLs) to identify core functional test scenarios for each application.

●Extensively involved in regression and smoke testing.

●Performed Integration testing by collaborating teams and requirements.

●Created test plans and Test Strategy documents.

●Created Test Plan/Lab libraries in Quality Center.

●Created hundreds of test cases from Use Cases and User Stories.

●Performed cross browsers testing on all major browsers and various platforms.

●Worked in Agile project methodology and performed different duties of sprint cycles.

Environment: ASP.Net, .Net 4.0, C#, IIS 6.0, Quality Center 10, Mainframe HOGAN, SQL Server 2008, IBM Clear Quest, IBM Clarity 7.

Bottomline Invoice Management Systems Feb 2011 – Jan 2012

Company: Epiq Solutions

Location: Beaverton, OR

Role: QA Engineer

The Bottomline Invoice management system is developed to process various invoices originating from emails, fax, PO boxes, FTP uploads. These invoices are processed by OCR (Optical Character Reader) and finally imported to database. The source database is then imported to destination database following the complex business rules. There are many admin pages of the Bottomline application exist to manage the status of various imports e.g. failed import, successful etc.

Responsibilities:

●Involved in gathering business requirements and writing a Test Plan based on Business Requirements Specifications.

●Developed and documented the test cases from User Stories.

●Validation of web application across multiple browsers – IE, Chrome, and Mozilla Firefox.

●Performed GUI, Ad-hoc, Web, Interface, Functional, Integration, compatibility, Usability Regression and User Acceptance Testing

●Responsible for arranging meeting with clients to bug scrubs.

●Responsible for maintaining the build process and report to build engineer in case of failure.

●Performed manual testing and updated the status in Quality Center. Provided various status reports to the management about the test execution status.

●Performed unit tests written in C# and using NUnit test suit.

●Responsible for testing the state of the destination database and report issues by performing database/back-end testing.

●Developed and tested SQL scripts for functional and regression testing.

●Responsible for UAT kick off to client and performed UAT with client.

●Defect reporting and bug assignment/management using TFS and VSTS.

●Executed the SSIS packages as part of the import process.

Environment: ASP.Net, .Net 4.0, C#, IIS 6.0, Quality Center 10, SQL Server 2008 R2, SSIS, SSAS, TFS, VSTS, Visual Studio 2010.

Rent your stuff Jan 2010 – June 2011

Company: renturstuff.com

Role: QA Engineer

The renturstuff.com is an e-commerce based online portal through which various users can utilize the services such as posting your items for rent or sale. The primary goal of this application is to provide various users the ability to post your items for rent, their items management, their profile management as a owner or renter, inventory management, and various other ways to market their items for availability etc. This application is still is in-progress state and team is working on extending its functionality further. The main modules of this application are; Registration Page, Advanced Search, Item Description Page, Bid Now page, Review and Confirm page, Item upload page, My Account page etc. This application provides a owner the option to choose to rent their items on bid basis or direct rent on the sole discretion of the owner of the item(s).

Responsibilities:

●Extensively involved in requirement analysis and writing a Test Plan based on Business Requirements Specifications.

●Involved in creating initial documentation of the project with lead developers and analysts

●Created QA documentation including QA Test Plans, QA Strategy, Test Cases models before getting it verified and accepted by client

●Developed and executed the test cases manually and with Automation as well.

●Validation of web application across multiple browsers – IE and Mozilla Firefox.

●Tested web UI of the application on various environments and browsers.

●Assigning bugs and enhancement request follow up to the developer’s team.

●Participated in bugs and enhancement review meetings.

●Performed GUI, Ad-hoc, Web, Interface, Functional, Integration, compatibility, Usability Regression and User Acceptance Testing

●Tested payment system with PayPal, Credit Cards, Electronic checks etc. to verify payment module using Chase Paymentech third party tool.

●Verify the security page and stability of the application.

●Extensive work through Virtualized Environment including Virtual Machine(VM) and Microsoft Virtual PC

●Developed functional and regression automated test scripts using data driven techniques.

●Extensively worked in all testing stages including User Acceptance testing (UAT) for various modules.

●Written SQL statements to retrieve the data from one or multiple tables.

●Experience with writing and executing manual and automated test cases.

●Reporting the defects through Defect Management using Quality Center.

Environment: ASP.Net, C#, IIS 6.0, Quality Center 9.2, Team Foundation Server, Visual Studio 2008, SQL Server 2008, Firefox 2/3, IE 6/7, Chase Payementech.

Various other smaller projects.

Contact this candidate