•Understanding of ETL requirements, Mapping documents and Transformation logics.•Worked in Agile Scrum to prepare test plan, test case development.•Writing SQL queries and scripts to validate and verify data transformations.•Conducted end-to-end testing of ETL process to validate data accuracy and completeness. •Performed System Integration,Regression & Pre UAT Testing.•Identified, Logged & Tracked Defects using JIRA ensuring timely resolutions and providing status updates to the client. •Preparing Validation Document & Data Profiling sheet. Present Demo to the client.

• Testing Power BI reports for data accuracy.• Creating Dashboards using Google Looker Studio as per business analysis requirements.• Pulling SEO reports from Google Analytics.

• Understanding ETL requirements, Mapping documents and Transformation logics• Worked in Agile methodology to prepare test plan, test case development and execution.• Understanding and analyzing source database. Applying source data validations. • Writing SQL Queries for various test scenarios.• Participating in daily meetings and sending daily status report.• Testing the components of the data warehouse after transformations.• Perform various tests like Regression, System & Performance testing .• Defect Logging in Jira.• Preparing Test Reports.• Communicating with clients to refine requirements and deliver quality data.

• A data-driven role in ecommerce analytics and reporting. Pulling and analyzing weekly and monthly reports from Google Analytics for multiple ecommerce platforms.• Transforming raw data into visually engaging insights through Google Data Studio dashboards, providing stakeholders with actionable information. • Validating and rigorously testing Power BI dashboards to ensure data accuracy and reliability. • Effectively communicated complex analytics to non-technical stakeholders and committed to delivering high-quality analytics solutions for ecommerce success.