Deepak Anand
- QA Analyst
- Chicago, IL
- Member Since Jun 17, 2023
Deepak Anand
12 years of diversified experience in Quality Assurance. Conducted manual testing of Client-server and Web-based applications. Excellent understanding of QA methodology, Software Development Life Cycle (SDLC), and Testing Life Cycle. Possess extensive knowledge of Problem Solving Techniques and excellent Analytical skills coupled with Good Communication and Interpersonal skills describing a committed Team Player.
Summary
· Proficient in all phases of software test life cycle (STLC) from test planning to defect tracking
and managing defect lifecycle.
· Experience working with Insurance, Investment/Brokerage, Retail and Healthcare sectors.
· Sound Knowledge of health information and health care services regulatory environment
including HIPAA Medicaid/Medicare
· Tested web applications in both Waterfall and Agile development processes.
· Experience with continuous integration and Jenkins.
· Excellent knowledge and working experience with Requirements gathering, Test Planning,
test Execution and Test Result Analysis.
· Expertise in analyzing Business Requirements/Rules, software Specifications, Use cases and
detailed design to develop Test Requirements and Procedures and Test cases.
· Thorough hands on experience with all levels of testing viz., Integration, Regression, Sanity,
Functional and System testing.
· Extensive experience in testing and supporting both Web and Client Server Applications.
· Proficient in performing both Front-end and Backend validation.
· Multi-task across multiple project efforts simultaneously.
· Good experience of working with various bug tracking tools like JIRA, HP Quality Center,
Rational ClearQuest, Bugzilla and a very good understanding of the Bug Life Cycle.
· Experience of working with QuickTestPro to automate web based test scripts and test plans.
· Experience with Test Methodology, Test Plans, Test Cases and Test Scripts on Unix,Linux platforms.
· Performed Extensive testing on C, C++, Java, .NET and VB platforms.
· Experience in Web technologies like HTML, XML, ASP, PHP, JSP, Java Script and VBScript.
· Ability to collaborate with testers, business analysts, developers, project managers and other team members
in testing complex projects for overall enhancement of software product quality.
· Created and reviewed comprehensive system documentation including TestScripts,Test Plans etc.
· Performed Web Service Functional Testing to ensure that the web service is functionally correct.
· Prepare and send QA status reports to development and higher management on a regular basis.
· Involved in UAT testing phase to support client.
· Have experience in handling databases like Oracle, MS-Access, MySQL, DB2 and Sybase.
· Proficient experience in Windows NT/2000/9x/XP/2003 server, Linux and UNIX platforms.
Technical Skills
Languages |
C, C++, PL/SQL, VC++, Visual Basic, Visual C++, Java, Python,Pascal, COBOL, Fortran |
Operating Systems |
Windows NT/9x/2000/XP, Sun O.S, Redhat Linux, IBM AIX, Mac OS X |
Web Technology |
PHP, HTML, CGI, ASP, XML, JSP, J2EE, JDK, JavaScript, VBScript |
Web Servers |
Apache, IIS, iplanet |
Database |
Sybase,DB2, SQL Server, Oracle (SQL*Plus, PL/SQL),Forms & Reports9i,11g MS Access, MySQL |
Test management Tools |
JIRA, HP Quality Center (12.0), IBM’S Test Tracking Tool (TTT). IBM Rational Doors |
Middle Tier |
EJB, Websphere, Weblogic |
Configuration management Tool |
CVS, MS SharePoint |
Web Accessibility Tools |
Webking 5.0 and HPR 4.0 |
Other |
AppPerfect Web Test, Lotus Teamroom, Eroom, Activity tracker, Oracle SQL Navigator, Rapid SQL, TOAD, DBVisualizer, Snagit, Vmware, SOAP UI |
Education:
Bachelor of Engineering in Computer Science from University of Madras, India, 2003.
Oracle certified in SQL, Oracle Corporation, India.
Oracle Applications 11i workflow, Oracle corporation, India.
Professional Experience
USG, Chicago May'16-Jul’17
Project: L&W Pricing and Quoting
Role: QA Analyst
To improve L&W profitability by building new pricing and quoting capabilities and to sustain gross margin improvement. Provide efficient price administration and simplified quoting.
Responsibilities:
· Participated in daily Scrum meetings and sprint planning meetings.
· Prepared test scenarios and detailed test tasks in HP ALM
· Created test plan, test cases and performed unit testing, regression testing and UAT.
· Validated product price flow from Woodstock to PROS and vice versa
· Validated data flow between Woodstock and PROS using WebMethods(middeware)
· Verify the file transfers as the events occurs, such as completion of a batch job.
· Query the backend tables to make sure the corresponding records are updated.
· Provide Testing summary graphs and reports to Project Team and Management.
· Mentored junior team members and reviewed their tasks.
· Represent business stakeholders and facilitate team interactions.
· Provided guidance to business users to use the newer version of the application efficiently
·
Environment: MS Sql server, WebMethods, IBM iSeries, Agile, MS SharePoint, Pros cloud, HP ALM, Jira
Allstate, Northbrook, IL Dec’14 – Mar’16
Project: Allstate DriveWise
Role: System Analyst
Allstate Drive Wise is a safe driving initiative from Allstate Insurance that helps a policy holder for Auto in monitoring driving behavior based on data collected through a device installed in the vehicle. This project rewards customer on good driving habits over a period of time based on an algorithm of driving events and factors.
Responsibilities:
· Partner with business analysts to ensure requirements are understood for proper testing.
· Translate business requirements into testing scenarios to enable testers to effectively validate software.
· Create, maintain, and execute complex test scripts using HP Quality Center.
· Worked extensively in back-end data testing and proficient in creating complex SQL queries
· Coordinated QA efforts across multiple projects and multiple teams that work from remote locations.
· Perform System Integration, Regression, and provide support for User Acceptance testing.
· Performed testing of Allstate mobile app on iOS & Android devices.
· Performed cross browser and cross platform testing of web applications.
· Lead the end to end testing efforts across multiple teams.
· Performed web service testing by validating XML response against different set of input data.
· Tested functionality of REST and SOAP based Web Services using SOAP UI tool.
· Identify, analyze, and document defects and inconsistencies in product functions, outputs.
· Develop and implement testing of Batch jobs, web services and GUI
· Coordinated with developers in understating the root cause of the issues and getting them fixed.
· Track and report results of testing and evaluate results with test lead and project team.
· Provide senior management with regular updates of testing status
· Coordinated with offshore team in getting the issue resolved.
·
·
Environment: JAVA/J2EE, Oracle 11g, SOAP UI 5.2.0, XML, Windows 8, MS SharePoint, HP Quality Center 12.0
AonHewitt, Chicago, IL May’14 – Sep’14
Project: Benefit Management
Role: System Analyst
AON benefits management application has organized a systematic way of supporting multinational corporations in their global benefits efforts. Aon’s benefits management application provides next-generation global benefits management platform, which leapfrogs other commercially available systems and offers greater flexibility and advanced analytic capabilities. The configuration management tool is a component of the absence management application which allows for new client implementations. Providing the clients with a user interface to perform configuration will significantly lessen the dependency on development teams, thereby saving both time and cost.
Responsibilities:
· Worked in an Agile development environment with frequently changing requirements and features.
· Gathered business requirements from business analyst and groom the user stories with addition of tasks.
· Develop detailed test plans based on requirements.
· Determine changes or improvements needed to support the QA System and business driven objectives.
· Provide work estimates, in terms of time, and resources
· Coordinated with developers in understating the root cause of the issues and getting them fixed.
· Lead the system integration testing efforts across multiple teams.
· Provide senior management with regular updates of testing status.
· Provide test data to UAT team by querying database & set up the test environment for UAT testing
· Participated in retrospective meetings for each sprint.
· Delegated work to offshore team & reviewed the completed work done by the offshore team.
·
·
Environment: JAVA/J2EE, Oracle 10g, Windows 8, MS SharePoint, Jira, MS Excel
AIM/WellPoint, Chicago, IL Oct’12 –March’14
Project: Radiation Therapy/Medical Oncology
Role: Sr QA Consultant
Diagnostic imaging is one of the fastest growing types of health care expenditures in the United States, with a double digit annual growth rate. WellPoint has seen a dramatic reduction in its radiology trend with AIM's technology and expertise. This transaction enables WellPoint to apply AIM's capabilities to other high tech, high cost categories where technology is driving uncertainty in ordering and increased health care costs. The AIM tools help bring transparency to health care categories where, as with radiology, price and quality vary dramatically within markets. AIM pioneered the use of web technology in diagnostic imaging management to create a more effective and efficient clinical review process to support the physician- patient relationship. AIM's web capabilities also help to improve quality and efficiency by facilitating information transfer between ordering physicians and rendering facilities to deliver a complete and correct understanding of the clinical order, helping to reduce potential waste and administrative burden caused by poor communication
Responsibilities:
· Worked in an Agile development environment with frequently changing requirements and features.
· Review and approve project documentation associated with the SDLC to support business.
· Worked on production issues identified by business users.
· Actively participated in Scrum meetings, reviews and developed test plan & test case documents.
· Coordinated QA efforts across multiple projects and multiple teams.
· Set up test data & test environment based on the testing needs.
· Assist Application Developers in identifying and resolving problems.
· Provide senior management with regular updates of testing status
· Identify automation candidates and performed Data Driven Testing to test the application with multiple sets of data.
· Prioritization of testing activities.
· Performed UAT testing along with the users on release nights.
· Mentorship of junior team members.
Environment: Quality Center (11.0), QTP 11.0, VB.Net, SQL server 2000, Sybase, Tibco, Jira, Remedy.
ExactTarget, Indianapolis, IN Aug’12 –Sep’12
Project: Email Marketing
Role: QA Consultant
ExactTarget is an email marketing and interactive marketing provider headquartered in Indianapolis, Indiana.
ExactTarget provides on-demand software for permission-based email marketing, mobile marketing and social media marketing. They provide software as a service (SaaS).
· Tested mobile applications in an agile environment.
· Performed backend validation of web based applications
Lincoln Financial Group, Rolling Meadows, IL Jul’11 – Jul’12
Projects: Enhanced Web Loan Request and Withdrawal & Payroll Processing
Role: Sr QA Analyst
Enhanced Web Loan project will enable clients to direct participants and/or plan sponsors to the TRAC Web Innovation sites to process loan requests. Plan Sponsors will have the ability to: Submit a personal loan or mortgage loan request on behalf of a participant & Review, approve, deny or withdraw a loan request. Payroll and Eligibility Service History Tracking will modify TRAC to address viewing and maintenance of compensation, hours, and employment service dates history for the large employer plan market.
Responsibilities:
· Set-up different types of shareholder accounts for various Plans using DST SmartDesk for testing various business scenarios.
· Prepared the Test Plan and documented the Test scenarios and test cases.
· Performed testing of payroll processing and Loan processing modules.
· Prepared scenarios to validate the steps in a multi-tier Loan approval process.
· Ran batch scripts connecting to remote Unix servers and reported the results.
· Identified defects and linked defects to the failed test cases.
· Performed mainframe testing by accessing mainframe CICS screens.
· Coordinated with the offshore team and delegated work to offshore team members.
· Gave presentations on the modules/sub modules to the UAT team.
· Facilitates meetings with testing team(s), development team, and business owners.
· Analyzed business requirements, and participated in Defect review meetings.
· Validated the backend of the application by connecting to backend tables in the Loans Database.
· Ensures requirements traceability by overseeing the mapping Test Cases to appropriate business requirements in the Requirements Traceability Matrix in Quality Center.
· Performed parameterized tests using QTP.
· Tracked the defects to closure using HP Quality center.
Environment: Mercury Quality Center (11.0), JAVA, Oracle10g, QTP 11.0, VC ++, Windows XP. Mainframes,
MS SharePoint.
Client: National Health Service Mar’09 – Apr’10
Project: Clinical Data Capture (CDC)
Role: Sr Quality Engineer
Lorenzo is the core application widely acknowledged as the world's premier health care information management solution. It is designed primarily to meet the administrative and clinical information management of healthcare providers with rich user interface. Patient information is organized in a manner which allows the users to navigate rapidly and easily. CDC tool helps the system administrator in a hospital to create customized forms based on their requirement. Forms in turn contain fields of different types that can capture clinical data. This is achieved using data items. Each data item can be configured as mandatory or to capture value within the specified range etc. The design of the Form can be done the same way a user designs a Form in Microsoft's IDE.
Responsibilities:
· Performed review and analysis of Requirements and design documentation.
· Involved in creation of Health Plans for participants of the sponsoring companies using Smartdesk.
· Developed SQL Queries to query the database to test the backend process of the application.
· Worked with customers to assure a quality product. Supply them with use cases and other
testing requirements and verify that their responsibilities have been met.
· Actively participated in creating requirements traceability matrices, and test plans.
· Design, develop and execute used cases to validate the clinical data capture modules.
· Performed Regression testing and Web Security testing to prevent possible security breach.
· Used Defect tracking system to report errors in the various releases of the application.
·Configured and maintained CVS for configuration management.
·
Environment: IBM Rational DOORS, IBM Rational Change Synergy, Rational ClearQuest, C#.Net, ASP.NET
and SQL Server 2000, Silver light.
Client: Yahoo, CA Oct’ 08 – Feb’09
Project: Yahoogreetings.com
Role: Test Analyst
Yahoogreetings.com is a web application to merchandise (buy/send) customized products (cards) and order it in easy steps. By using the application user can navigate to various categories of items, customize the items in their own choice, order, pay and get the products delivered. Customization of the dynamic web pages, discounts based on time, payment, order management and printing/ production management can be handled using the application.
Responsibilities:
· Worked closely with the Business Analysts in eliciting requirements.
· Data integrity validation of both internal/external data systems
· Performed testing of Order management and payment processing module.
· Prepared the Test Plan and documented the Test scenarios and test cases.
· Worked in an Agile software development cycle with daily Scrum meetings.
· Gave presentations on the modules/sub modules to teammates.
· Analyzed business requirements, functional specifications and mock ups of financial to
provide functional decomposition.
· Tracked defects to closure using Bugzilla.
Environment: Mercury Quality Center (9.0), VB.Net, SQL Server2000, VC ++, Windows XP.
Am safety, USA & Midstate Sep ’07 – Sep ‘08
Project: Simple Insure (Client-Server)
Role: Sr QA Tester
Simple Insure: The Simple insure applications are being developed to cater to the needs of clients – Amsafety and Midstate. Am safety application offers superior Policy, Accounts, claim management and adjustment from the initial report of a policy to its ultimate conclusion. This client is particularly dealing with Property insurance. Midstate Mutual Insurance Company offers a variety of products to insure homes, farms and small businesses for property losses (fire, windstorm, etc.) and for third-party liability occurrences when someone is injured on one’s property or someone else's property is damaged as a result of one’s negligence.
Responsibilities: