Power Bi Data Analysis
Resume:
EXPERIENCE SUMMARY
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.
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.
SKILLS
Technology:
Microsoft Power BI, Microsoft SQL, Machine Learning Techniques
Primary Skill(s):
MSSQL, DBA, BIDW, Power BI reporting and Visualization
Technical Skills:
T-SQL, Data warehousing & ETL, Reporting and Visualization,
Industry Domain:
Microsoft Services Operations and support
EMPLOYMENT DETAILS
Organization
From
To
Role
LTIMindtree
04/09/2017
Till Date
Senior Specialist – Data Engineering
Tech Mahindra
11/18/2013
08/17/2017
Senior Software Engineer
Wipro
08/08/2011
09/20/2013
Project Engineer
PROJECT EXPERIENCE
Project 1
Identity - Service Reliability Engineering April 2024 to till date
Customer Name
Microsoft – Power Pages
Description
This 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 & Technologies
Power BI, LensExplorer, Azure
Operating System
Windows
Role Played
Technical Lead
Responsibilities / 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 Size
6
Project 2
Identity - Service Reliability Engineering Feb 2021 to April 2024
Customer Name
Microsoft – Identity -Service Reliability Engineering
Description
This 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 & Technologies
Azure, Kusto Explorer, Log Analytics, Power BI
Operating System
Windows
Role Played
Technical Lead
Responsibilities / 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 Size
10
Project 3
Customer Care Intelligence Nov 2018 to July 2020
Customer Name
Microsoft – Customer care Intelligence
Description
This 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 & Technologies
Azure, Kusto Explorer, Log Analytics
Operating System
Windows
Role Played
Technical Architect
Responsibilities / Contribution
Virtual 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 Size
10
Project 4
MSA/ORGID Nov 2017 to Oct 2018
Customer Name
Microsoft – MSA/ORGID
Description
This 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 & Technologies
MSSQL, Kusto, Cosmos DB
Operating System
Windows
Role Played
Technical Architect
Responsibilities / Contribution
Maintaining 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 issues
Ensuring quality Deliverables to the clients.
Handling Client Escalations and identifying the areas of improvements and value additions to the project.
Team Size
10
EDUCATION
Year
Degree
Major Subject
Institution
2011
Bachelor of Technology
Biotechnology
Karunya University
2007
Intermediate (+2)
Biology, Physics, Chemistry
Gayatri Junior College
2005
10th
Indian School of Secondary Examination
St. Josephs Convent School
Contact this candidate