About Me
4.5 + years of total experience with expertise in Business Intelligence, coupled with extensive proficiency in PowerBI, SQL and Data Warehouse. I offer a wealth of experience in ensuring Data extraction and its validatio…
4.5 + years of total experience with expertise in Business Intelligence, coupled with extensive proficiency in PowerBI, SQL and Data Warehouse. I offer a wealth of experience in ensuring Data extraction and its validation. My skill set encompasses a comprehensive ability to create complex Data Blending and visually appealing Dashboards and stories to showcase insights of the business decisions. I firmly believe in the concept of making my customers happy hence constantly thrive to give more attention to the details of any project.
Experience
lead data analyst
1.Prepared BRD and transformed business requirements 2.Created SUBSCRIPTION and ALERT for the report on Power BI Services. 3.Worked on multiple Data Connection (SQL Server and flat files) and Validate data. 4.Performance Optimization of Dashboards. 5.Created Slicers, Bookmarks, table calculations, calculated measures and KPI’s for purpose of monitoring business analysis.
Lead Data Analyst
Prepared BRD and transformed business requirements into technical intentions.
Created SUBSCRIPTION and ALERT for the report on PowerBI Services.
Worked on multiple Data Connection (SQL Server and flat files) and validate data.
Migrating pre-existing Tableau Reports into PowerBI Dashboards to show trends on YoY, QoQ, YTD, QTD types of analysis.
Performance Optimization of Dashboards.
Led a team of 4 and worked as a Developer and Lead.
Dealt a data set of 2 million and figured out the Junks and Logical discrepancy before the development phased commenced.
Prepared the major KPI’s of the business to depict the trend analysis of Current Year vs Previous Year Attrition.
Created complex logics using DAX functions to segregate data to determine the Key Metrics like Active, Inactive Customers.
Prepared interactive dashboards using Swap sheet functionality to check different profiles Week on Week.
Lead discussions with stakeholders to prioritize tasks and meet the deadlines of the deliveries.
Introduced Agile Methodology within the team to manage the project management flow.
Data Analyst
Developed High-cost claimant’s analysis through forecasting.
Analysis of Sales and Target impacts at multiple regions and BU’s through PowerBI visualizations like pareto chart, line charts and complex calculated fields using DAX functions.
Created dashboard to track payments for merchant coupons in different gateway.
Created Trend lines, Forecasting and Reference Lines.
Created Slicers, Bookmarks, table calculations, calculated measures and KPI’s for purpose of monitoring business analysis.
Use of customized charts like Donut Chart, Waterfall Chart to provide better view of the analysis.
Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.
Giving the dashboard presentation to the onsite coordinator and Clients.
Got opportunities to work on Prototype & Analytics Projects with the technology team.
Worked on Analytics Projects which involved entire KPI design and development.
Figured and highlighted the logical discrepancies in the data which received a lot of appreciation from the stakeholders.
Created Claim and Fraud Dashboards.
Created drill down reports which showed the Age wise claims together with their occupation.
Created tool tip chart to show granular insights of the data involving multiple KPI’s.
Heavily involved in the entire life cycle of the report starting from Sprint plan, daily scrum call, blocker discussion, sprint review and retrospective session.
Data Associate
Enhanced quality and productivity on the Facebook E-Commerce platform through strategic changes.
Developed and maintained operational policies and procedures for efficiency.
Actively participated in client meetings to discuss progress and identify improvement areas.
Managed E-Commerce marketing, overseeing renowned branded product development.
Crafted, monitored, and updated product content on E-Commerce portals for accuracy.
Demonstrated multitasking ability, meeting deadlines with attention to detail.
Possessed comprehensive knowledge of E-Commerce industry trends, including marketing and industry trends.
Ensured accuracy and completeness of product details across platforms.
Optimized existing PowerBI Reports into optimized dashboards with various performance optimizing techniques like extracting the required fields, avoiding usage of nested calculations.
Implemented robust strategies for Unit Testing.
Leveraged techniques like data-driven testing and dynamic data generation to enhance the efficiency.
Acted as a bridge between development and QA teams, facilitating seamless collaboration and knowledge sharing.
Worked closely with Stakeholders to understand report architecture and design development components.