About
Data Analyst with 3+ years of experience in designing and developing interactive Power BI dashboards and reports that transform complex business data into actionable insights. Hands-on experience in Power BI, DAX, Power Query, SQL, and Microsoft Excel, with expertise in data modeling, data transformation, and KPI reporting. Experienced in integrating data from multiple sources, building interactive visualizations, and delivering automated reporting solutions to support business decision-making. Familiar with Power BI Service, Scheduled Refresh, and Row-Level Security (RLS), with a solid understanding of data analysis, report optimization, and business reporting.
Skills & Expertise (14)
Work Experience
System Engineer
Tata Consultancy Services
Jun 2022 - Oct 2024
Designed and developed 10+ dashboards to monitor Sales Performance, Revenue, Product Performance, and other key business KPIs. Created DAX measures and Calculated Columns using functions such as CALCULATE, SUMX, FILTER, DATEADD, and TOTALYTD to support dynamic business reporting. Connected and transformed data from SQL Server, Excel, and SharePoint using Power Query for reporting purposes. Built data models using Star Schema concepts to improve report performance and maintainability. Developed interactive reports using KPI Cards, Matrix, Line Charts, Bar Charts, Maps, Slicers, and Drill-through functionality. Implemented Row-Level Security (RLS) to provide secure access to reports for different user groups. Published reports to Power BI Service, configured Scheduled Refresh, and monitored dataset refreshes. Wrote SQL queries using Joins, CTEs, and Aggregate Functions to extract and validate business data. Performed report testing, resolved data discrepancies, and supported UAT before production deployment. Utilized Time Intelligence functions including YTD, MTD, QTD, SAMEPERIODLASTYEAR, DATEADD, and TOTALYTD for trend analysis. Performed data cleansing and transformation using Power Query Editor. Worked closely with business stakeholders to gather reporting requirements and translate them into BI solutions. Created documentation for data models, KPIs, DAX calculations, and dashboard functionality. Supported production reports and provided enhancements based on business feedback. Reduced manual reporting effort by approximately 15%. Improved report performance by optimizing DAX calculations and SQL queries.
Developer
Iteanz Technologies Pvt. Ltd.
Dec 2021 - May 2022
Developed interactive Power BI dashboards to monitor pharmaceutical business performance, operational KPIs, and inventory trends. Performed data cleansing, transformation, and validation to improve data quality and reporting accuracy. Participated in report testing, bug fixes, and production support activities. Performed data transformation using Power Query to clean and structure raw datasets. Assisted in developing executive dashboards for tracking sales performance, inventory levels, and business operations.
Engineer
ASCENT HR
Feb 2018 - May 2020
Analyzed electronic component information by reviewing manufacturer datasheets, technical specifications, and lifecycle documentation to ensure data accuracy. Captured and validated component attributes including Manufacturer Part Number (MPN), package type, electrical specifications, and parametric information from manufacturer websites. Standardized manufacturer names, part numbers, and component descriptions based on predefined business rules to maintain data consistency. Performed Bill of Materials (BOM) validation to verify component availability and identify obsolete or discontinued parts. Reviewed component lifecycle status including Active, NRND (Not Recommended for New Design), EOL (End of Life), and Obsolete components. Conducted compliance verification for RoHS, REACH, and WEEE regulations to ensure adherence to environmental and industry standards. Performed quality checks and data validation before updating engineering databases, improving the accuracy of component master data. Generated and maintained operational reports using Microsoft Excel, including Pivot Tables, formulas, filtering, sorting, and data validation techniques. Collaborated with engineering teams to resolve data discrepancies and ensure accurate component information for downstream business processes. Maintained detailed documentation of validated component records and supported continuous data quality improvement initiatives.
Education
B. Tech (ECE) - JNTUA
2013 - 2017 ยท Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (14)
Click a skill to find developers with the same skill