Shital Pilare

Sepsis Project : Conducted deep analysis of clinical markers (ABG, Heart, Kidney, Lungs, Liver) for early sepsis detection and risk stratification using APACHE/SOFA/MOD scores. Designed a Tableau KPI dashboard for ICU Sepsis patients, focusing on length of stay and throughput, aimed at improving operational efficiency by 30%. Derived insights from demographic parameters, identifying high-risk vulnerability in males aged 65+.

• Analyzed large datasets to identify trends and inform business decisions.
• Developed interactive dashboards using Tableau to visualize key performance indicators.
• Collaborated with cross-functional teams to streamline data collection processes.
• Conducted statistical analyses to support strategic initiatives and optimize operational efficiency.
• Implemented data cleaning procedures enhancing accuracy of analytical outputs.
• Utilized data visualization tools to effectively communicate business insights.
• Led projects focused on improving data accessibility and user engagement across departments.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Used statistical methods to analyze data and generate useful business reports.
• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
• Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.

• Conducted comprehensive quality assessments to ensure product compliance with industry standards.
• Developed and implemented testing procedures to enhance accuracy of quality evaluations.
• Collaborated with cross-functional teams to identify and resolve quality-related issues effectively.
• Analyzed product defects and initiated corrective actions to improve manufacturing processes.

Project: BidQA (Web-Based Application)
• Performed extensive manual testing including functional, regression, integration, and system testing to ensure application quality before automation.
• Designed and executed detailed manual test cases and test scenarios for UI workflows, form validations, navigation, and business logic.
• Conducted cross-browser testing (Chrome, Firefox) to validate UI consistency and responsiveness of the web application.
• Built an automation testing framework using Selenium WebDriver with Java to validate end-to-end web application workflows.
• Automated regression test suites using TestNG/JUnit for faster and reliable test execution.
• Implemented data-driven testing techniques to enhance test coverage and scalability.
• Identified, logged, and tracked defects with proper documentation, including steps to reproduce and severity classification.
• Used structured reporting and logging mechanisms for clear test execution results and debugging.
• Demonstrated strong understanding of SDLC, STLC, QA methodologies, and automation design patterns.

Project 1: Lomotif (Mobile Video Editing & Social Sharing App)
• Tested end-to-end functionality of a mobile application for video creation, music integration, and social media sharing.
• Validated integration with social platforms such as Twitter, Snapchat, and WhatsApp for seamless content sharing.
• Performed compatibility testing across iOS and Android devices to ensure consistent performance.
• Designed and executed detailed test cases for features like media upload, music search, playlist playback, and project sharing.
• Conducted GUI, usability, functional, and stress testing under real-world conditions (battery levels, incoming calls, SMS, multi-video selection).
• Evaluated application performance under varying network conditions and internet speeds.
• Reported and tracked defects using Bugzilla and performed regression testing after bug fixes.


Project 2: B-Scape (Web-Based Application)
• Performed end-to-end manual testing including functional, regression, integration, system, and UAT testing.
• Automated regression test suites using Selenium WebDriver with Java and TestNG framework.
• Conducted cross-browser testing across Chrome, Firefox, and Internet Explorer to ensure UI consistency.
• Performed mobile compatibility testing to validate responsive design and usability.
• Developed and maintained test data frameworks using XML and properties files.
• Executed performance testing using JMeter to assess system scalability and response time.
• Worked in Agile environment with CI/CD tools such as Jenkins and Git for continuous testing and deployment.
• Generated detailed QA reports and tracked defects using JIRA.

• Environment & Java, Selenium, Intelli-J, TestNG, Maven, Oracle, JMeter, GIT, Jenkins, Tools: BugZilla
• Project OPWDD NY is connected to various Physically and Mentally challenged people through the Summary voluntary agencies. These agencies are responsible for taking care of physically and mentally challenged people and NY state provides the funds for the same.
• The underlying projects deals with funds allocation and tracking the status of money being spent in effective manner.
• Responsibilities
• Developed and execute test cases, test scenarios and followed-up defects
• Studied User Requirement Specifications (URS) and converted them to Functional Requirement Specifications (FRS) and Software Requirement Specifications (SRS) for application modules
• Bug reporting, tracking and documentation using BugZilla
• Utilize Selenium WebDriver/Java for cross browser and functional Testing
• Involved in designing and building automation frameworks in support of continuous integration in atest-driven development (TDD)
• Used Maven for building the WebDriver project. Integrated with Continuous Integration tools Jenkins for running test on nightly basis automatically
• Developed SQL Queries to perform database testing

• Duration July 2007 - June 2008
• Environment & Java, Eclipse, JUnit, Ant, Oracle, Perforce Tools:
• Project The underlying project was an Enterprise portal for ILT India, which deals with various Summary operations of company like sales, accounting, HR etc.
• Responsibilities
• Exploring the Software Functionalities and preparing Check list document
• Executing test cases, generating bug report using and reporting details to development team for followup
• Performing Functional testing, Usability testing and Browser Compatibility testing during different phases of application development
• Track Bug Report to its closure
• Developed SQL Queries to perform database testing. Performed Backend Testing using Toad
• Verifying the accuracy and completeness of the project released and ensuring defect free quality product as per specification is delivered to the customer
• Conducted Gap Analysis to ensure all Business Requirements are covered by testcases.