a
aojafri

Ali Owais Jafri

@aojafri

Data Analyst, Business Analyst, Advanced Excel, SQL, MySQL, Power BI and Tableau

India
Inglese, Hindi
Alcune informazioni sono riportate in lingua inglese.
Chi sono
Data Analyst skilled in Advanced Excel, Power BI, Tableau, SQL/MySQL, Python, Pandas, NumPy, and Power Query. Expertise in data cleaning, ETL workflows, data modelling, dashboard development, KPI reporting, data visualisation, business intelligence, and AI-assisted analytics. Experienced in analysing inventory, procurement, MTO, and operational datasets to deliver accurate reports, interactive dashboards, actionable insights, automated reporting, and data-driven solutions that support informed business decisions, process optimisation, operational efficiency, and strategic decision-making.... Continua a leggere

Competenze

a
aojafri
Ali Owais Jafri
offline • 
Tempo di risposta medio: 1 ora

Consulta i miei servizi

Analisi BI
I will create power bi dashboards

Esperienza lavorativa

Self_Employed

Data Analyst

Self Employed • Freelance

May 2018 - Present8 yrs 3 mos

Key Responsibilities • Performed data cleaning, transformation, validation, reconciliation, and quality assurance to ensure the accuracy, consistency, and reliability of business datasets. • Developed interactive dashboards, analytical reports, and KPI scorecards using Advanced Microsoft Excel and Power BI to support business reporting, performance monitoring, and operational decision-making. • Conducted material, inventory, procurement, and MTO analytics to improve reporting quality, operational visibility, resource planning, and process efficiency. • Built reusable reporting templates and automated reporting workflows that reduced manual effort, improved reporting efficiency, and standardised business reporting. • Created business intelligence dashboards and data visualisations that delivered actionable insights and supported operational performance monitoring and management reporting. • Collaborated with cross-functional teams to gather reporting requirements, understand business objectives, and translate analytical needs into practical data-driven solutions. • Utilised SQL and MySQL to extract, query, validate, and analyse structured datasets for reporting, business intelligence, and analytical applications. • Applied Python (Pandas and NumPy) for data preparation, transformation, automation, exploratory data analysis (EDA), and efficient processing of business datasets. • Supported ETL workflows using Power Query and Python to prepare reliable, analysis-ready datasets for dashboards, reporting, and business intelligence solutions. Tools Used • Advanced Microsoft Excel (Power Query, Pivot Tables, Pivot Charts, XLOOKUP, INDEX-MATCH, Advanced Formulas) • Microsoft Power BI (Power Query, DAX, Data Modelling, Interactive Dashboards, KPI Reporting) • Tableau (Dashboard Development, Data Visualisation, Storytelling) • SQL & MySQL • Python (Pandas, NumPy)