Business Analyst
Physics Wallah (PW)
02.2023 - Current
- Independently built end-to-end reports using SQL and spreadsheets, generating daily reports on business health, academic performance, and operational tracking with insights and creating live dashboards
- Wrote complex queries Redshift to accurately track and report
daily business health. - Worked with cross functional teams and performed RCA using.
- Voluntarily contributed to database documentation by adding
column descriptions and creating ERD Diagrams. - Reporting on Business Operations Identifying growth
opportunities. - Managed the team database with 99% accuracy, facilitating another team’s RCA. Automated, Various daily reports using SQL, Power BI, Google Spreadsheets and Excel.
- Analyzed and comprehended problem statements and client communications to automate processes and provide solutions. - Integrated automation jobs into Jenkins, maintained test automation logs, and verified bug resolutions
- Implemented new processes across 8 teams, created test quality metrics, and organized onboarding, improving work processes for production defects. - Generated weekly Business and Operations Review (WBR/WOR) reports to enable senior leadership to make decisions by streamlining KPI measurement and consolidating data
- Conducted research and analysis of sales productivity data to leverage targeted marketing campaigns, increasing business ARR by 25%. - Implemented a PTM (Parent-Teacher Meeting) dashboard on Looker Studio, enhancing user experience and allowing scalability and scope.
- Delivered spreadsheet training sessions to non tech department
members at our center to enhance their productivity. - Error handling in data and supporting the team with data
Planning, Analyzing, Solving problems and optimists through
data. - Developed and designed dashboards to highlight critical insights for leadership, facilitating data-driven decision-making. Specifically, created logic dashboards to assess the daily productivity of the sales team.
