Sonal Bhandagi

About Sonal Bhandagi

Oracle certified Associate PL/SQL and ISTQB Certified with 10+ years of experience in IT Industry working as Data Quality Analyst, ETL/Data Warehouse and Business Intelligence and Analytics QA.I have an extensive experience in testing and analytics of BI Reports and Analytic tools viz. Cognos, QlikView & Tableau tools.I am very proficient in advanced excel skills like V lookup, pivot tables, pivot reporting, and automation in excel by using VBA, and Macros for inserting, deleting and transposing the data.I am expertise in Test Strategy, Test Plan, Efforts Estimation, Test Scenarios, Test Cases Design, Review, Execution, Tractability Matrix, Defects finding, Defect Triage, and Defects Matrix, Reviews, Risks-Issue Identification/Mitigation, and QA Team lead activities. Well acquainted with HP Quality Center 10 and ALM 11.5 for defect tracking and RTM. I have excellent knowledge and experience in Waterfall & Agile SDLC Methodologies, STLC and V-Life Cycle Model. CERTIFICATIONS ISTQB Certified Tester (Foundation Level) Oracle Certified Associate Certification (OCA) A certified software testing (DST) with grade A+ from SEED, InfoTech.

Experience

1. Database Marketing Analyst

   AIG

   Nov 2016 — Present

   Pre and post-campaign analysis to assist with key strategic and tactical initiatives. • Supporting and enhancing the existing reporting capabilities through extensive use of automation and metadata • Working on analysis and high-level summary of finding on KPI evaluation, campaign logic and client and broker data. • Analyzing data on clients/brokers identify potential markets and factors affecting product demand/and sales • Forecasting and tracking marketing and sales trends, KPI’s, analyzing collected data • Working with internal constituents to collaboratively gather information and gain complete understanding of data, models, processes, business and other variables required to perform analysis • Timely reporting on key metrics and underlying drivers as specified by management • Supporting ad hoc analyses and campaigns as assigned by management

Education

• Vivekanand Education Society's Institute Of Technology

  Bachelor's Degree, Electrical, Electronics and Communications Engineering, A

  2001 — 2004

• Seed Infotech

  Diploma in software testing, QA testing, A+

  2005 — 2005

• Welingkar Institute of Management

  Business Management

  2008 — 2009