Created Excel based Analysis and Reports using various Advanced Excel Formulas and Functions.Developed Excel BI Analysis and reports using VLOOKUP, Pivot tables, and complex DAX languages.Extracted of Dataset from Multiple Data Sources including primary, secondary, internal, and external sources to generate relevant datafor analysis. Created Visualizations, including Dashboards, Charts, and various graphs to relay business concepts through visuals to theManagement, colleagues, and other stakeholders.Interpreted of raw datasets to identify underlying patterns for easy comprehension for non-technical audience. Analyzed company’s operations for trends, volume, demographics, and operator’s metric to support decisions. Developed Tableau visualizations and dashboards from extracted reports using Tableau DesktopGenerated BI reports in pivot charts, graph, and other visualization formats to Analyze trends.Utilized simple and complex SQL Queries to extract specific information from database, migrated them into excel for analysis.Imported data to Access and SQL Server from flat files and Excel spreadsheets.

Collected data from DHS and coordinated with IREA in processing background checks.Developed Access User forms (U/I) to extract data and insertion into tables using backend VBA QueriesData migration and Data validation/Testing through VBA modules between MS Access (SQL Database) and MS ExcelDeveloped Tableau visualizations and dashboards from extracted reports using Tableau DesktopGenerated BI reports in pivot charts, graph, and other visualization formats to Analyze trends.Wrote complex SQL queries using various joins, unions, and functions for report purpose.Interacted with Business Analyst, SMEs, and other Data Architects to understand Business needs and functionality for various projectsolutions.

Collected data from DHS and coordinated with IREA in processing background checks.Developed Access User forms (U/I) to extract data and insertion into tables using backend VBA QueriesData migration and Data validation/Testing through VBA modules between MS Access (SQL Database) and MS ExcelDeveloped Tableau visualizations and dashboards from extracted reports using Tableau DesktopGenerated BI reports in pivot charts, graph, and other visualization formats to Analyze trends.Wrote complex SQL queries using various joins, unions, and functions for report purpose.Interacted with Business Analyst, SMEs, and other Data Architects to understand Business needs and functionality for various projectsolutions.