Data Analyst
Current• Understanding business requirements in the BI context and designing data models to transform raw data into meaningful insights.• Analyzing current ETL process, defining and designing new systems using SSIS.• Used Power BI features to build and configure Hierarchical dimensions, Measure, Calculated-Columns, KPI, Filter, and Aggregations.• Designing and developing filter-driven interactive Dashboards, trend-based KPIs, summary and detail reports featuring parameters, sorting, expressions, drill down and drill through, etc.• Assisting in data storage structures, data mining, and data cleansing.• Using Pandas, NumPy, and Matplotlib to manipulate and analyze the data values visually.• Using statistical tools to interpret data sets, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts.• SQL querying for best results, use of filters and graphs for better understanding of data.• Preparing reports for executive leadership that effectively communicate trends, patterns, and predictions using relevant data.