a
aojafri

Ali Owais Jafri

@aojafri

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

India
English, Hindi
About me
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.... Read more

Skills

a
aojafri
Ali Owais Jafri
Offline • 
Average response time: 1 hour

See my services

BI Analytics
I will create power bi dashboards
From$15 / projectMore details

Work experience

Self_Employed

Data Analyst

Self Employed • Freelance

May 2018 - Present • 8 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)