Subhendu Dey

• Served as a Data Analyst as well as Data Quality Lead for Brightspeed, owning validation of Power BI reports, end-to-end data quality across Google BigQuery; ensured accuracy of KPIs and executive dashboards used for business decisions.
• Designed and developed Power BI reports from requirements through deployment; authored optimized BigQuery SQL (queries, views, and aggregations) to support self service analytics and ad hoc stakeholder requests.
• Performed data reconciliation and root cause analysis to identify sync gaps between BigQuery and SAP, documented findings, and drove cross functional remediation with data owners until resolution.
• Acted as a Scrum Master in addition to my daily assignments: ran standups, sprint planning, reviews and retrospectives; maintained Jira backlog, created/refined user stories, and tracked delivery to meet reporting SLAs.
• Proactively identified data risks and integrity issues, coordinated mitigation with engineering, ETL and business teams, and implemented validation checks to reduce recurring data defects.
• Worked for client partner Verizon as a Data Analyst, owning the responsibilities of validating production data to make sure data is as expected to satisfy important business KPIs to improve point of sales and overall customer experience.
• Raised defects and worked with cross-functional teams to make sure TAGGING is accurate and defects are fixed and closed.
• Working on building semantic layer for the EDW to GCP move, by performing data analysis and building SQL queries that can fetch data as per the business KPIs and feed new GCP tables and Looker reporting.
• Worked for client partner Frontier Communications as a QA Lead and Scrum Master owning the responsibility of entire QA delivery with comprehensive QA strategies and processes.
• Groomed junior QA members, helped them to become single point of contact for their respective teams for QA.
• Created detailed and well-structured test plans, test cases, and test scripts, ensuring thorough coverage of requirements.
• Executed manual and automated tests, identified and documented software bugs using Jira and Confluence for tracking and management.
• Reviewed functional and technical documentation to provide timely and actionable feedback to product managers and technical leads.
• Performed System and Data Analysis from Teradata to Databricks migration, databases and provide solutions to automate testing for faster and more efficient QA delivery.
• Helped another team with QA validation of MDM – ETL process (Informatica), identified logics from stored procedure and functions and designed automation of Rest APIs with Postman.
• Identified, designed and implemented internal process improvements including re-designing infrastructure for quick results, streamlining process for optimizing data delivery and automating manual process.
• Shared test plan inputs with end-to-end test managers, review test cases for adequate coverage, create plans to complete validation inside the testing window, burndown charts to project and track daily execution along with tracking through JIRA and ALM, preparing test documentations like test exit report once validation is complete and ensuring approval from compliance team.

• • Planned and strategized the overall QA delivery including preparing and projecting reports to forecast the plan for test execution meeting the deadline through burndown Charts.
  • Participated in business requirements walkthrough, analyze business requirements and work closely with project teams, business partners to arrive at an optimal technical solution design and to create impact analysis, data mapping, test strategy documents.
  • Collaborated with Agile product delivery team to groom user stories and write comprehensive testing specifications.
  • Executed manual and automated tests using Abinitio GDE and Postman, identified and documented software bugs using Jira, ALM and Confluence for tracking and management.
  • Reviewed functional and technical documentation to provide timely and actionable feedback to product managers and technical leads.
  • Created detailed and well-structured test plans, test cases, and test scripts, ensuring thorough coverage of requirements.
  • Performed System and Data Analysis in IBM MDM, databases, files and provide solution to automate the end-to-end testing.
  • Identified, designed and implemented internal process improvements including re-designing infrastructure for quick results, streamlining process for optimizing data delivery and automating manual process.
  • Shared test plan inputs with end-to-end test managers, review test cases for adequate coverage, create plans to complete validation inside the testing window, burndown charts to project and track daily execution along with tracking through JIRA and ALM, preparing test documentations like test exit report once validation is complete and ensuring approval from compliance team.

• Delivered regression and performance testing strategies ensuring data reliability.
• Built validation test suites aligned with technical documentation.
• Developed and maintained quality assurance protocols, ensuring compliance with industry standards.
• Strengthened defect reporting standards improving resolution time.

• Owned the responsibility of entire QA delivery with comprehensive QA strategies and processes.
• Planned and coordinated end-to-end validation with Cross-Functional teams by finalizing batch calendars, test data strategies and responsibilities, testing cycles and timelines, integrated testing across the teams in parallel within the timelines.
• Effectively communicated the delivery plan, highlighted risks and shared mitigation plans with leaderships and stakeholders.
• Clearly communicated the timeline, strategy, test coverage, test data and execution plans to QA teams.
• Involved in all phases of Software Development Life Cycle (SDLC) including Requirement analysis, Design, Development, Testing, Deployment, Delivery and Support. Performing requirements elicitation to analyze potential gaps or issues in requirements and designs of complex ETL (Extract–Transform–Load) solutions using Informatica Power Center to meet the enterprise needs and standards along with its integration with MDM hub (Reltio Cloud) while creating, managing, securing and analyzing Azure APIs' to communicate with various upstream and downstream applications.
• Designed manual and automated test cases that cover data ingestion from AWS S3 to EMR to Master Data Management (MDM), to Elasticsearch along with UI applications for data stewards.
• Validated highly available, scalable, and fault-tolerant systems using Amazon Web Services (AWS) to establish golden copy of address data using MDM fundamentals.
• Developed and shared detailed metrics for completion tracking, defect prevention, and reporting, project efficiency, and quality; utilized Continuous Integration tools to merge development with testing pipelines. Helped team with reports showing daily updates about the progress and mitigation plans along with multi-layer verifications and validations.
• Executed test cases covering functionalities of all Azure APIs /SOA services that communicate with upstream and downstream applications.
• Actively participated in data analysis, defect /root cause analysis, code review and business solutions to help the system to be robust and trustworthy.
• Developed test plan, test scenarios, test cases and test results, managing the work progress in project management tools like JIRA, Rally and Planview LeanKit, owning the responsibility of a successful quality assurance cycle and henceforth a successful production release.
• Performing various data loads across all environments using Informatica PowerCenter, gatekeeping the code merges across all platforms with CI/CD Pipelines through integration tool JENKINS, codes and configurations through GITLAB.
• Lead and mentored QA teams, identified technical and functional knowledge gaps, planned and provided trainings accordingly to make sure continuous improvements.
• Planned for internal reviews and audits to ensure the quality and adherence to the process.