About Me
A curious analyst with a knack for numbers and a passion for precision paired with a toolbox of Python, SQL, and Tableau for data preprocessing, exploration, and visualization. An experienced Accounting & Business Analys…
A curious analyst with a knack for numbers and a passion for precision paired with a toolbox of Python, SQL, and Tableau for data preprocessing, exploration, and visualization. An experienced Accounting & Business Analyst, bringing over 10 years of experience analyzing business transactions and financial data, managing accounting processes, financial reporting, and implementing systems and process improvements. As a business analyst, I have seen how accurate analyses solve problems, optimize processes, and create business value. Thus, I am passionate about leveraging data, transforming insights, and applying strategic decisions that contribute significantly to the success of an organization. I have worked on end-to-end projects ranging from product and customer segmentation, ETL pipeline, and product category analysis, to A/B testing.
Experience
Data Analyst/Data Engineer Trainee
• Presented insights and solved business questions by preprocessing, exploring, and visualizing ecommerce sales transactions data
• Built ETL pipeline that can be run from the CLI or by using Docker
• Communicated campaign strategies and key insights developed from analyzing customer segments created based on RFM metrics using percentile ranking and Kmeans clustering
• Developed dashboards in Tableau
Data Analyst/Data Engineer Trainee
Presented insights and solved business questions by preprocessing, exploring, and visualizing ecommerce sales transactions data
Built ETL pipeline that can be run from the CLI or by using Docker
Communicated campaign strategies and key insights developed from analyzing customer segments created based on RFM metrics using percentile ranking and Kmeans clustering
Oracle Business Analyst - North American Finance | PLSQL
Supported procurement and finance teams with their business questions and queries by producing analytics reports extracted from multiple databases utilizing PLSQL queries
Analyzed, investigated, and resolved Oracle AP workflow errors, vendor credits, and unaccounted transactions
Involved in Oracle project implementations within Accounts Payable and Fixed Assets from testing in the test environment, documenting observations, and providing go-live decision
Provided first-level support to Oracle AP end users
Performed balancing activities on customized system jobs (PE) in Oracle (EDI, payment interface, payment feed)
Vendor Master Data Specialist | Accounts Payable & Receivables
Spearheaded the vendor data cleaning project, which resulted in the clean-up of 80% of vendor records
Identified and escalated trends and patterns that affect vendor data quality, data integrity, and process efficiency
Initiated the reconfiguration, redesign, and implementation of the iSupplier portal in collaboration with procurement, finance, and Oracle technical teams
Participated in the testing and development of new tools involving customization and modification of modules within Oracle Payables and Receivables in support of process optimization
Maintained the vendor master which involved scrutinizing new supplier accounts, approval of data change requests, as well as deactivation and reactivation of existing suppliers
Managed Accounts Payable in the Legal and ETS operations as well as Accounts Receivable for Mubadala and its wholly-owned entities
Accountant for Head Office & Joint Venture
Analyzed and visualized the top 3 major operating costs (manpower hire, heavy equipment & machinery rental, and water consumption) as well as cash expenses, and communicated key insights to maximize profits
Controlled site petty cash, prepayments, and special cash advances and ensured that the accounts were reconciled at all times
Validated and processed supplier invoices, resolved discrepancies in billing and payment certificates, reconciled supplier accounts and purchase orders
Facilitated Oracle cash module user training for project site users
Receivables & Collections Analyst
Analyzed and reconciled customer accounts and receivables transactions
Measured the performance of accounts receivable operation by tracking AR KPIs and metrics (DSO, aging, past-due invoices, AR turnover)
Resolved customer issues, account discrepancies, delinquencies, disputes, and procedural errors
Maintained customer accounts which involved the review and updates of all customer accounts including accounts assignment/re-assignment, collection statuses, follow-updates, collection notes, accounts under finance payment plans
Accounts Receivable | Credit & Collections Officer
Monitored Aging and Run Aging analyses and reporting requirements
Made a substantial decrease in high and long overdue receivable balances and improved AR Aging and DSO
Set up negotiations with client company payment decision-makers to work out payment plans and coordinate with the collection agencies for unmanageable accounts
Administered creation and retention of client profiles and credit evaluation reports
General Accountant | Financial Coordinator
Performed monthly reconciliation on AR, AP, inventory, general journal adjustments, payroll, fund management, and financial analysis
Acted as Financial Coordinator and led the accounting team; conducted internal audit; prepared financial statements and financial analysis including profitability and performance ratios, projection, and budget reports
Involved actively in the implementation and migration during the automation of the accounting system (FinPerf)