Vikram Ramagiri

As part of my role, I actively engage in a range of Data Analyst responsibilities alongside my core duties, contributing to more data-driven decision-making and the effective resolution of incidents. Here is a detailed description of my current responsibilities:

• Proficient in Microsoft Power Query for ETL (Extract, Transform, Load) processes: Adept at utilizing Microsoft Power Query to efficiently extract data from various sources, perform necessary transformations, and load it into target systems, enabling seamless data integration.
• Experienced in data flow management and preparation: Possess extensive experience in creating and managing data flows to streamline the data preparation process. This includes organizing and structuring data to ensure it is ready for analysis and reporting.
• Handling Customer Reported Incidents (CRIs):
• Handle CRIs of severity 2 to 4: Proficiently manage Customer Reported Incidents, focusing on those rated with severity levels 2 to 4. This involves comprehensive analysis, troubleshooting, and thorough investigation.
• Conduct Root Cause Analysis: Expertise in conducting Root Cause Analysis to identify underlying issues and emerging trends that contribute to reported incidents.
• Create Troubleshooting Guides (TSGs): Develop Troubleshooting Guides based on identified trends to streamline the resolution of common issues, enhancing supportability and incident resolution efficiency.
• Utilize Azure Data Explorer: Employ Azure Data Explorer, a fully managed data analytics service, to conduct real-time and time-series analysis on large volumes of data streams, including customer logs, usage data, and incident data.
• Extract Key Insights: Extract key insights from the data streams to improve services and the performance of the Power BI Gateway product.
• Data Sanitization and Filtering: Apply data sanitization and filtering techniques to ensure data quality, asking questions and iteratively exploring data to enhance customer experiences, monitor devices, and optimize operational processes.
• Identify Data Patterns: Quickly identify patterns, anomalies, and trends in the data, enabling data-driven decision-making and strategic adjustments.
• Documentation and Knowledge Management.
• Create Documentation Bugs: Proactively identify and create documentation bugs to ensure that documentation and wikis are continuously updated to reflect the latest information.
• Maintain Knowledge Base: Effectively maintain a knowledge base with troubleshooting guides and lessons learned, contributing to ongoing improvements in supportability and issue resolution.
• Dashboard Development and Reporting:
• Utilize Power BI: Create visually compelling dashboards using Power BI, effectively tracking metrics and providing stakeholders with visual insights for data-driven decision-making.
• Author and Send Weekly Reports: Prepare and send weekly reports that comprehensively summarize deployment efforts, including detailed information on builds, branches, deployments, blocking issues, and migration issues, ensuring effective communication with project stakeholders.
• Investigate and Resolve Issues: Take on additional responsibilities aimed at enhancing supportability, including investigating and resolving customer-reported issues to improve overall service quality.
• Utilize the SAW machine to deploy Power BI clusters to the production environment, ensuring smooth transitions and system reliability.
• Effectively address any deployment issues that may arise, minimizing disruptions and ensuring the success of deployment processes.

In this role, I have effectively merged data analysis skills with BI lead responsibility to enhance our services, streamline issue resolution, and support data-driven decision-making across the organization.

• Coach and mentor the Power BI team engineers to deliver exceptional customer service.
• Empower peer team and internal teams to help, advise and endow customers to achieve more.
• Handle escalations in such a way that customers trust in Microsoft products and services is regained.
• Ensure the engineers are achieving their goals by constantly maintaining focus on our key factors/fundamentals such as individual case load, current bin size, meeting customer expectations on SLA (Service Level Agreement), resolution, swarming, communicate effectively without any delays, paying attention to the customers problem, and most importantly being empathetic.
• Focus on readiness and technical triage/training creation and delivery
• Collaborate across teams and across technologies by working with resources from other groups as needed to resolve customer issues. Collaborates with other Technical Advisors and escalation resources when appropriate.
• Act internally as a customer advocate and collaborate with Product Engineering groups to help improve the product and make the experience better to the customers.
• Maintain a proactive approach to customer happiness, identifying customer satisfaction concerns and managing customer expectations with our frontline engineers.
• Respond to incidents during on-call rotations and alert product teams to major customer impacting issues
• Expertise on analyzing fiddler traces, Wireshark, querying Kusto telemetry to identify opportunities

• Design and generate compelling and interactive analysis reports and dashboards using Power BI as per client’s requirement.
• Generate reports and self-service methods that help ensure data is available to decision makers.
• Import data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Create Dax Queries to generated computed columns in Power BI.
• Generate computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Publish Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Use Power BI Gateways to keep the dashboards and reports up to date.
• Install and Configure Enterprise Gateway and Personal Gateway in Power Bi Service.
• Publish reports and dashboards using Power BI.
• Own, troubleshoot and solve customer technical issues, using collaboration, troubleshooting best practices and transparency within and across teams (e.g. swarming)
• Identify cases that require escalation (either technically or strategically)
• Create and maintain incident management requests to product group/ engineering group
• Contribute to case deflection initiatives, automation and other digital selfhelp assets to improve customer/ engineer experience
• Provide ramp activities, knowledge sharing, documentation, troubleshooting guides, blog articles, technical coaching and mentoring
• Drive technical collaboration & engagement outside of CSS for example with Azure Logic Apps Product Engineering Groups.

• Interact with business users internally, gather and analyze requirements
• Create SSIS packages to automate the ETL processes and load existing data into SQL Server from different environments for the SSAS cubes
• Create calculate member in MOLAP cube using MDX in SSAS
• Design, build the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose
• Create complex stored procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications
• Develop complex stored procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Generate computed tables in Power BI by using Dax
• Develop Up-selling and Cross-selling reports using DAX functions
• Create Row level security with power bi and integration with power bi service portal.