Arjun Varma Email & Phone Number

Bothell, Wa, Us

Bothell, Washington, United States

Hyderabad, Telangana, India

Hyderabad, Telangana, India

Leading multiple teams for a total of 10+ members.Unblocking team for technical issues.Review, suggest and brainstorm new requirements and how to solve them.Review code, test coverage and whether all organizational best practices and followed diligently.Debug and analyze bugs and items which are of high value to customer/users.Gatekeeper for any changes that are to be deployed to the Production Environment.Responsible for overall project health tracking and taking steps to ensure Project is always in healthy state.Ensuring and tracking personal learning for each of the team members

Redmond, Washington, United States

Work with Stakeholders to gather business requirements and convert them into technical specifications, carve out milestones and modularize parts of the requirements to enhance understanding of Dev team and help them achieve the set expectation with highest level of parallelism.Review/Test daily build from dev team, demo it to stakeholders and gather feedback.Gatekeeper for all changes that go to Production.Design/Propose Architecture as well as help in visualization and facilitate creation of mockups for reporting

Hyderabad, Telangana, India

Proficient in SQL, SSIS and Excel PowerPivotWorked on performing data refresh for an executive level report where in validation of eachdata point was to be done and recorded into to visual studio onlineCreated an Excel based validation framework which would help in verification of each sectionin report by comparing, it against the computed data directly from source systemWorked on identifying business definitions for each of the KPIs in the Executive report andperformed feasibility analysis of the same including identification or source from which datawould be consumedAnalyzed multiple sources to find required data points and worked on onboarding the datapoints to internal staging layer using SSIS writing queries using SQL, MDX and DAXCreated stored procedures for business logic processing and created reporting storedprocedures to store data for each KPI which can be broken down into GeographiesExplored Power BI and developed prototypes which were first in the organization andpresented to end clients thus shifting the reporting layer from HTML to Power BIReportsShifted to SSAS Tabular Model which provided better usability, maintainability, anddevelopmentDeveloped expertise in DAX and Power QueriesWorked with senior team members to migrate from On-premises to cloud solutions i.e.,On-premises Servers for SQL DB to Azure SQL for Reporting DBs and, SSIS to Azure DataFactory, Staging and Data warehouse to ADLS, migrated complete code base from Storedprocedures and views to Azure Databricks.Developed fresh reporting requirements from scratch starting from data onboarding usingADF, business logic processing using Azure Databricks, developing SSAS models to host Power BI ReportsCreating 6+ Power BI Reports with an aggregate of 50+ pagesCreated Power BI Dashboards which provide one single view for multiple reports by using outof the box as well as custom visuals with features like drill down, drill through, bookmarks,sync slicer