Hema (Dhamal) Patil

Products: Solara / OKGO 1.0 / FlexRandomizer

• Product: Solara (Ongoing Development): Cloud based Solara unlocks the strategic potential of the biostatistician, enabling development teams to thoroughly explore statistical design options, decide together, and clearly communicate business trade-offs
• Managing testers from 7 scrum teams (Manual + Automation Testers), Stakeholder reporting, timesheet building for Testing Team
• Oversees Test Leads to ensure a cohesive approach to testing across the project, including functional and non-functional testing
• Architects an overall holistic integrated test approach based on the end user and product implementation
• Guides Test Leads on implementing a risk-based and shift-left approach to testing and maintaining high test coverage
• Develops and documents the overall test strategy and test plan for the product - what to test, how to test, when to test, how much to test
• Oversees implementation of a robust, comprehensive, and automated regression test suite at different architecture layers like component, micro services, API and UI layer
• Documents and maintains applicable high level test plans and reports (e.g. SDLC TPR, SATPR, SATS, etc.)
• Helps Test Leads participate effectively in story grooming and sprint planning meetings to maximize testing effectiveness
• Optimizes resources [people and equipment] through targeted testing and environments to reduce ineffectual testing efforts
• Coordinates internal/external process audits
• Oversees performance and security testing
• Generates project metrics
• Represents Test Leads in BRD process, defect triage, PI activities, internal/external quality audits, RCAs, and SDLC reviews
• Works cross-functionally, particularly with Customer Support and IT
• Works with Program Manager and Principals to balance workload and maximize productivity across all teams
• Proved successful working within tight deadlines and fast-paced atmosphere.
• Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
• Resolved conflicts and negotiated mutually beneficial agreements between parties.
• Participated in team-building activities to enhance working relationships.
• Environment and Tools Used: Postman, Python-PyTest + Selenium, TestRail, Jira, Azure, Confluence, JavaScript
• Press Release: https://www.cytel.com/software/solara

Product: (In maintenance mode): OKGO 1.0 / FlexRandomizer:

• Leading the test activities + internal/external quality audits
• OKGO 1.0: is web-based application developed as a standardized statistical tool that implements the evidence‐based Go/No‐Go decision-making framework, allowing clinical teams to streamline their decision process
• Press Release: https://www.cytel.com/software/ok-go
• FlexRandomizer: is web-based application developed for accurate randomization forms, the backbone of any clinical trial
• Press Release :https://www.cytel.com/software/flexrandomizer

Account: Riva Financial Services, UK

• Project For: Franklin Templeton - Riva Transfer Agency Application
• Met project deadlines without sacrificing build quality.
• Identified plans and resources required to meet project goals and objectives.
• Facilitated communication between internal personnel and client for project cohesion.
• Achieved project deadlines by coordinating with all teams to manage performance.
• Planned, designed and scheduled phases for large projects.
• Drove team success through shared vision and recognition of quality performance.
• Made decisions independently and collaboratively on testing related challenges.
• Managing test team (Team Size 7), Manager + Client reporting, timesheet building for Testing Team, assigning tasks to Team members.
• Timesheet management for Testing Team, work allocations to Team members
• Involved in Requirements Analysis and Listing of Test Scenarios (BUI, Functional, Unit, Integration, System, Database, Regression, Web, API)
• Involved in Test Case Scripting, Execution and Test Case Reviews
• Defect Reporting and Verification
• Mentoring the New Teammates regarding various modules
• Generation of defects report, test execution status reports for weekly meetings with senior management
• Planning, deploying, and managing the testing effort for any given engagement / release
• Co-ordination with in-house, on-site development team as well as FT UAT and FT Production Support team

Accomplishments during the tenure:

• Certificate of Appreciation” award from Client (Riva Financial System): Signed by Ghassan Hakim, CEO – Riva and Tim Leeming, Director – Riva
• Awarded 3 times Quarterly and Monthly Summit Award: Best Employee – Mphasis Ltd
• Awarded 2 times for Valuable Team Contribution – Summit Awards

Account: Express Scripts, USA

• Collaborated with product owners to stay current on intended functionality.
• Designed testing scenarios for Functional testing.
• Design test plan, test consideration, test case document, test result document
• Execute test cases (Functional, Integration, and Database)
• Test Documentation creation and management (Tool: Quality Center)
• Assessed software bugs and compiled findings along with suggested resolutions for development team members.
• Verify data using DB2 and performed database testing by writing and executing Queries
• IBM Mainframes Testing using CICS/DB2, HIPAA transaction set number 835 (Health Care Claim Payment/Advice), modifying the JCLs, executing the JCLs for validating the data in DB2 tables
• Environment: Windows XP, IBM – Anchor (Mainframe Application), DB2, Quality Center MS Excel.

Account: HDFC Bank Ltd

• Applications tested: FlexCube Investment Services- FCIS (Host System) & FC@IS (Web Application), FlexCube Investment Services (Systematic Investment Program), FinnOne - Finance against Securities (FAS)
• Responsibilities for Both Applications: User Acceptance Testing for all new enhancements/modules
• Collaborated with product owners to stay current on intended functionality.
• Analysis of requirements followed by the setup and execution of baseline tests
• Ensured that testing standards are adhered to in the modules and fixed deadlines for each module
• Designed test plans, test specifications
• Identified & analyzed risks and devised plans to mitigate the business risks
• Prepared and executed test cases (GUI, Functional, Unit, Integration, System, Database, Regression, Web, and Business Objects), Design documents and Manuals
• Generated defects report, test execution status reports for weekly meetings with senior management
• Co-ordination with in-house production team as well as Oracle solution team
• Responsible for developing and tracking design documents and scripts
• Designed a basic setup for automation by using Rational Robot and VBA Macros in MS Excel for creation of test data
• Enhanced and modified the scripts (Rational Robot and VBA) according to the test case scenarios
• Verified data using Toad and performed database testing by writing and executing Queries
• Database Migration Testing / ETL Testing
• Created successful test scripts to manage automated feature testing (Tools Used: SQL Server 2000, WS-FTP, ASP, Java, Rational Robot, MS Excel, VBA Macros)

Account: NSDL

• Designing Automation setup and creation of regression test case suite
• Setup and execute baseline for automation setup using Quick Test Pro (QTP) 9.0 – now known as UFT
• Creation of regression test case suite and VBA Macros in MS Excel
• Responsible for monitoring the test logs, generated defects report and test execution status reports.

Account: ABN-Amro

Applications tested: Access Online(Single window financial trading portal

• Creation of regression test case suite for the entire Asia-Pacific region
• Development and Execution of Test Cases
• Wrote SQL queries to extract relevant data to aid in analysis and decision support and VBA Macros in MS Excel for creation of test data
• Environment: Linux, Quality Center, DB2, MS Excel