Este es mi perfilContactar vía CazVidEste perfil está escrito en inglés
Jigar
Data Analyst
Contacto
Competencias
Demonstrated experience with Power BI Desktop.
Demonstrated experience with Power BI Service.
Demonstrated experience with Tableau.
Demonstrated experience with interactive dashboards.
Demonstrated experience with KPI scorecards.
Educación
Resumen
Data Analyst open to new opportunities
Experiencia
Data Analyst Intern
Analyzed 12,000+ transaction, customer, and loyalty records using Python, pandas, and SQL to support Lightspeed POS integration and loyalty-performance reporting.. Gathered stakeholder requirements and converted business questions into data fields, KPI definitions, calculation logic, validation rules, and dashboard specifications.. Profiled, cleaned, transformed, mapped, and reconciled datasets by addressing missing values, duplicates, inconsistent formats, and field-level discrepancies.. Developed 3 interactive Tableau dashboards tracking 8 KPIs across transaction activity, customer engagement, loyalty participation, and operational performance.. Created calculated fields, filters, drill-down views, trend comparisons, and customer-segment views to support detailed analysis.. Established repeatable ETL and validation workflows.. Tested calculations, filters, visual interactions, reporting periods, and data completeness; supported UAT and documented approved corrections, KPI definitions, and transformation logic.
Business Data Analyst
Queried and analyzed 18,000+ sales, customer, and operational records using SQL, Advanced Excel, Power Query, and Power BI.. Gathered reporting requirements and translated stakeholder needs into reporting datasets, KPI definitions, SQL logic, dashboard layouts, and validation criteria.. Developed and maintained 20 SQL queries using joins, CTEs, subqueries, aggregations, window functions, and data-validation checks.. Built dimensional reporting models using fact and dimension tables, Power Query transformations, relationships, calculated columns, and DAX measures.. Developed 3 interactive Power BI dashboards tracking 10 KPIs across sales performance, customer activity, product trends, and operational results.. Automated recurring data-preparation and reporting workflows.. Published dashboards to Power BI Service and supported scheduled refreshes, source-to-report reconciliation, dashboard testing, UAT, maintenance, and technical documentation.
Business Intelligence Analyst
Consolidated and analyzed 8,000+ sales, customer, and operational records using SQL, Advanced Excel, Power BI, and Tableau.. Extracted data from multiple sources and completed profiling, field standardization, duplicate removal, reconciliation, and completeness checks.. Built a dimensional model using fact and dimension tables and prepared reporting datasets with SQL joins and aggregations.. Created Power BI and Tableau reports presenting sales results, customer activity, product performance, and operational trends.. Standardized reporting templates and data-consolidation workflows.. Validated dashboard results against source data and documented KPI definitions, transformation steps, calculation logic, assumptions, and validation procedures.