| Candidate Information | | Title | Power Bi Data Analysis | | Target Location | US-WA-Federal Way |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateEXPERIENCE SUMMARYDeveloped and maintained Power BI Reports, tools, and portals for Incident volume data analysis and for Monthly/Weekly reviews for various projects representing the KPIs and team metrics.Utilized advanced DAX functions and Power Query to optimize data models, ensuring efficient and accurate data reporting.Collaborated with cross-functional teams to gather requirements and deliver actionable insights, enhancing decision-making processes.Worked on Database Backup Restore and implementing Disaster recovery strategies.Performed Database administration activities (creating logins, users, roles, and assigning permission)Have knowledge of SAP BO reports, Informatica and Data Warehousing Concepts.Have Sentiment Analysis and topic modelling on GST using Social Media Data.Performed Web scrapping, Data cleaning, Data analysis and Data interpretation.Understanding of NLP techniques for text representation, semantic extraction techniques, data structures and modelling.SKILLSTechnology:Microsoft Power BI, Microsoft SQL, Machine Learning TechniquesPrimary Skill(s):MSSQL, DBA, BIDW, Power BI reporting and VisualizationTechnical Skills:T-SQL, Data warehousing & ETL, Reporting and Visualization,Industry Domain:Microsoft Services Operations and supportEMPLOYMENT DETAILSOrganizationFromToRoleLTIMindtree04/09/2017Till DateSenior Specialist Data EngineeringTech Mahindra11/18/201308/17/2017Senior Software EngineerWipro08/08/201109/20/2013Project EngineerPROJECT EXPERIENCEProject 1Identity - Service Reliability Engineering April 2024 to till dateCustomer NameMicrosoft Power PagesDescriptionThis project is to analyze the usage of portals and applications created for each tenant to derive insights on tenant usage patterns and optimize performance.Tools & TechnologiesPower BI, LensExplorer, AzureOperating SystemWindowsRole PlayedTechnical LeadResponsibilities / Contribution Coordinated between the offshore team and the client to ensure seamless communication and project execution. Developed and maintained Power BI Reports, for usage analysis for the tenants. Worked on Lens Jobs to get the data from upstream entities from various geos and loaded to the tables Worked with DAX Queries, calculated columns, measures, and scheduled refresh in Power BI Service. Worked on S360 incidents to keep the entities compliant with the policies. Created dashboards to monitor the overall performance of the reports and to track the related incidents if any.Team Size6Project 2Identity - Service Reliability Engineering Feb 2021 to April 2024Customer NameMicrosoft Identity -Service Reliability EngineeringDescriptionThis Project, Service Reliability Engineering is to provide Designing, development, maintenance, enhancement services for Power BI (Business Intelligence) Reports, tools, portals, and specific engineering projects based on requirements provided by customer.Tools & TechnologiesAzure, Kusto Explorer, Log Analytics, Power BIOperating SystemWindowsRole PlayedTechnical LeadResponsibilities / Contribution Developed and maintained Power BI Reports, tools, and portals for Incident volume data analysis and for Monthly/Weekly reviews for various projects representing the KPIs and team metrics. Imported data from SQL Server DB, Kusto and SharePoint to tables to generate and publish the reports. Worked with DAX Queries, calculated columns, measures, and scheduled refresh in Power BI Service. Included custom visuals depending on the given requirement for better representation. Performing log analysis and incident analysis using Kusto query tool to identify patterns and address the root cause. Created automated flows to monitor and check the data load success, failure, and volume. Created SOPs and provided knowledge transition to the team members involved.Team Size10Project 3Customer Care Intelligence Nov 2018 to July 2020Customer NameMicrosoft Customer care IntelligenceDescriptionThis Project is to handle V1 and higher versions of the CCI bot environments. It involves maintaining the health and availability of Bots of various internal and external customers.Tools & TechnologiesAzure, Kusto Explorer, Log AnalyticsOperating SystemWindowsRole PlayedTechnical ArchitectResponsibilities / ContributionVirtual Chat Bot Agents Availability Monitoring done by using App Insights, using AI availability ping tests and Dash boarding.Ensuring the health of apps and availability built in PowerApps and AI Builder.Initial triage of all Incidents and communications received via email (IcM Incidents)Assist in outage restoration actions.Classification according to volume, severity, impact, and noise ratio, suggest updates to live site process.Trend analysis for reoccurring incidents and suggest recommendations to CCI Incident Management Team/Engineering team.Perform Noise Reduction Analysis on weekly/monthly basis report weekly/monthly Delivery Review Meetings and recommend changes.Team Size10Project 4MSA/ORGID Nov 2017 to Oct 2018Customer NameMicrosoft MSA/ORGIDDescriptionThis Project is to handle V1 and higher versions of the CCI bot environments. It involves maintaining the health and availability of Bots of various internal and external customers.Tools & TechnologiesMSSQL, Kusto, Cosmos DBOperating SystemWindowsRole PlayedTechnical ArchitectResponsibilities / ContributionMaintaining the health of the environment, taking care of hardware issues.Troubleshooting user issues related to Microsoft Accounts.Performing Back Up and Restore of Databases in different environments.Working on Disk Space issuesEnsuring quality Deliverables to the clients.Handling Client Escalations and identifying the areas of improvements and value additions to the project.Team Size10EDUCATIONYearDegreeMajor SubjectInstitution2011Bachelor of TechnologyBiotechnologyKarunya University2007Intermediate (+2)Biology, Physics, ChemistryGayatri Junior College200510thIndian School of Secondary ExaminationSt. Josephs Convent School |
