Abha Kumari

About Abha Kumari

I am a results-driven Database Developer currently contributing to Microsoft\'s Zoltar project, a KPI-driven revenue model. In this dynamic role, I actively engage in SQL Server tasks, intricate query writing, procedure understanding, validations, audits, reporting, and analysis. Proficient in tools like Excel and Pivots, I excel in day-to-day activities, involving requirement analysis, crafting SQLs for complex reporting, addressing user issues, and ensuring effective collaboration in revenue planning and forecasting. Prior to Microsoft, my journey included a significant tenure at Amdocs as a Data Engineer, where I honed skills in gathering business requirements, coordinating ad-hoc data activities, and executing SQL scripting for data cleansing and manipulation. My responsibilities extended to agile environments, sprint planning, report generation using SQL and Tableau, data assessment, and data mining for billing reports. I bring a wealth of experience as a Data Analyst at Idexcel, where I performed data analysis and validation using complex SQL queries. My expertise spans the Software Development Life Cycle, modeling data objects, utilizing Excel for ad-hoc analysis, and contributing to automation processes for data maintenance. Key Skills: SQL, Extract, Transform, Load (ETL), Reporting & Analysis, SQL Server Management Studio, Microsoft Power Query, Data Validation, SQL Server Integration Services (SSIS), Microsoft Excel.

Experience

1. Database Developer

   Microsoft

   Aug 2023 — Present · Redmond, WA, US

   Zoltar is a KPI-driven revenue model that involves a top-down cascade of revenue targets and guidance from corporate to various levels within the organization. It is combined with a bottom-up approach from field teams. All iterations of budgets and forecasts are stored in a database and then integrated into a financial planning tool like Plancast or MS Sales for effective monitoring and decision-making.While working in Zoltar project, I have worked on SQL Server work, complex query writing, procedure understanding, validations, audits, reporting, analysis, and proficiency in tools such as Excel and Pivots. My day-to-day activities involved requirement analysis, creating SQLs for complex reporting, addressing user issues, and ensuring effective collaboration in revenue planning and forecasting.

Education

• Visvesvaraya Technological University

  Bachelor of Engineering - BE