About Me
Data Analyst with 4 years of experience transforming operational, project, sales, financial, and HR data into actionable insights to support business decision-making. Skilled in SQL (SSMS), Power BI, Tableau, Excel, and …
Data Analyst with 4 years of experience transforming operational, project, sales, financial, and HR data into actionable insights to support business decision-making. Skilled in SQL (SSMS), Power BI, Tableau, Excel, and Python (Pandas, NumPy), with experience developing interactive KPI and SLA dashboards, automating reporting workflows, and analyzing data across multiple business functions. Experienced in end-to-end data analytics, including data extraction, validation, transformation, data modeling, and BI reporting, with practical experience building data warehouse solutions and scalable reporting workflows using SQL and BI tools.
Experience
Data Administrator - Analyst
<p>Manage the end-to-end e-invoicing lifecycle across multiple supplier portals and enterprise systems, including Oracle, SAP, Microsoft Dynamics 365, and other business applications.</p><p> Monitor invoice workflows from submission and validation through approval, rejection, and payment, ensuring timely follow-up and resolution of outstanding invoices.</p><p> Perform invoice reconciliation between supplier portals and internal systems, identifying discrepancies, missing invoices, incorrect amounts, duplicate records, and status mismatches.</p><p> Oversee customer follow-up to obtain required GRN, ASN, and SES for invoice submission, while coordinating with customers and internal teams to secure POs required for invoice creation.</p><p> Review rejected, pending, and blocked invoices, identify internal issues and rejection root causes, and coordinate with relevant teams to resolve problems and ensure successful resubmission.</p><p> Prepare monthly management reports and dashboards covering invoice status, payment progress, aging, outstanding invoices, rejection reasons, internal issues, and unbilled projects and services, highlighting key issues and coordinating with relevant teams to drive timely resolution.</p><p> Develop PMO reports and dashboards covering project progress, project costs, manpower utilization, inventory status, and key project KPIs to support project monitoring and management decision-making.</p><p> Develop sales performance reports and dashboards covering quotation-to-order conversion rates, salesperson performance, sales targets vs. actuals, order pipeline, revenue trends, and key sales KPIs.</p><p> Analyze invoice, financial, operational, customer, quotation, order, and sales data using SQL, Excel, and Power BI to support reconciliation, reporting, data validation, performance monitoring, and management decision-making.</p>
Data Analyst
<p>Analyzed retail sales data for a multi-branch confectionery chain (ice cream, nuts, candy, chocolate) operating in major shopping malls.</p><p> Extracted and processed transactional data from the EPOS point-of-sale system using SQL (SSMS), delivering insights into sales performance, product trends, and customer behavior.</p><p> Built dynamic Tableau dashboards tracking daily, weekly, and monthly sales per branch, top-selling products, and customer purchase patterns.</p><p> Delivered ad-hoc reports to answer critical business questions, including identifying underperforming products, evaluating promotions, and analyzing sales fluctuations.</p><p> Developed regression-based forecasting models using Scikit-learn to predict sales trends, enabling data-driven goal setting and KPI forecasting.</p><p> Partnered with business and operations teams to translate insights into strategies that optimized sales campaigns and improved branch performance.</p>