Sitoshna Bhoi

Client: Genworth Financial, Richmond, Virginia.

• Analyzed large datasets to assess accuracy, completeness, and consistency, supporting data integrity and quality.
• Developed and executed complex SQL queries to extract, transform, and analyze structured data.
• Created Source-to-Target Mapping (STM) documents by collaborating with business and technical teams.
• Built interactive dashboards and reports in Tableau to deliver actionable, data-driven insights.
• Automated manual data processes using Python and SQL, significantly improving operational efficiency.
• Partnered with cross-functional teams to streamline data pipelines and optimize workflow performance.
• Identified key data trends, patterns, and anomalies, providing insights to support business decisions.
• Coordinated and supported User Acceptance Testing (UAT) with business users to ensure solution readiness.

Client: Genworth Financial, Richmond, Virginia.

• Collected, cleaned, and transformed large datasets from multiple sources to ensure accuracy and reliability.
• Conducted in-depth data analysis using SQL, Excel, and Python to uncover trends and deliver actionable insights.
• Developed interactive dashboards and reports in Tableau to support cross-departmental decision-making.
• Collaborated with teams to define KPIs and build data models aligned with strategic business objectives.
• Interpreted complex datasets to provide clear, business-focused recommendations to stakeholders.
• Monitored data quality and enforced data governance best practices to ensure compliance and security.
• Delivered ad-hoc analyses to support marketing, sales, and operations initiatives.

Client: Genworth Financial, Richmond, Virginia.

• Analyzed project requirements from BRDs and specs to derive test scenarios and data validation points.
• Partnered with the Data Quality team to assess data accuracy, completeness, and consistency.
• Created detailed Test Strategy, Test Plans, and Test Summary Reports aligned with enterprise standards.
• Strong expertise in functional testing, test data setup, and mainframe test execution.
• Wrote and executed complex SQL queries to validate backend data as per requirements.
• Developed and maintained manual and automated test cases, including optimized regression suites.
• Maintained Requirements Traceability Matrix (RTM) to ensure full test coverage.
• Led functional, integration, regression, and UAT testing with client and business user coordination.
• Logged and tracked defects in JIRA and ALM, performing severity analysis and root cause investigation.
• Identified automation opportunities to reduce manual effort and enhance test efficiency.
• Drove process improvements, collaborated on data analysis, and created actionable internal reports.
• Communicated effectively with both technical and non-technical stakeholders.

Company Overview: Genworth Financial, Mumbai, India.

• Analyzed business requirements and created detailed test plans for multiple project releases.
• Designed and executed test cases for new functionalities, and regression testing.
• Estimated effort and timelines for testing deliverables, aiding project planning.
• Developed automation frameworks and scripts for regression suites (PoC), reducing manual efforts and errors.
• Logged, tracked, and analyzed defects in ALM, performing root cause analysis.
• Built macros and automation tools to streamline repetitive tasks, and improve accuracy.
• Maintained and updated scripts as per changing requirements, while ensuring coding standards.
• Managed test case and regression suite execution, ensuring full traceability in ALM.
• Communicated with clients via IM and conference calls for requirement clarification.
• Contributed to process improvements and quality initiatives using Six Sigma methodologies.

Company Overview: Initial Learning Program, Hyderabad, India.

• Analyze the requirements documents and prepare the front end of the application as per the requirements.
• Developed JCL programs and DB2 queries for database connectivity.
• Developing a test plan, executing test cases, logging valid defects, and analyzing their causes.
• Learned to interact with the client.