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
<p>Presented insights and solved business questions by preprocessing, exploring, and visualizing ecommerce sales transactions data<br>
Built ETL pipeline that can be run from the CLI or by using Docker<br>
Communicated campaign strategies and key insights developed from analyzing customer segments created based on RFM metrics using percentile ranking and Kmeans clustering</p>
Oracle Business Analyst - North American Finance | PLSQL
<p>Supported procurement and finance teams with their business questions and queries by producing analytics reports extracted from multiple databases utilizing PLSQL queries<br>
Analyzed, investigated, and resolved Oracle AP workflow errors, vendor credits, and unaccounted transactions<br>
Involved in Oracle project implementations within Accounts Payable and Fixed Assets from testing in the test environment, documenting observations, and providing go-live decision<br>
Provided first-level support to Oracle AP end users<br>
Performed balancing activities on customized system jobs (PE) in Oracle (EDI, payment interface, payment feed)</p>
Vendor Master Data Specialist | Accounts Payable & Receivables
<p>Spearheaded the vendor data cleaning project, which resulted in the clean-up of 80% of vendor records<br>
Identified and escalated trends and patterns that affect vendor data quality, data integrity, and process efficiency<br>
Initiated the reconfiguration, redesign, and implementation of the iSupplier portal in collaboration with procurement, finance, and Oracle technical teams<br>
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<br>
Maintained the vendor master which involved scrutinizing new supplier accounts, approval of data change requests, as well as deactivation and reactivation of existing suppliers<br>
Managed Accounts Payable in the Legal and ETS operations as well as Accounts Receivable for Mubadala and its wholly-owned entities</p>
Accountant for Head Office & Joint Venture
<p>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<br>
Controlled site petty cash, prepayments, and special cash advances and ensured that the accounts were reconciled at all times<br>
Validated and processed supplier invoices, resolved discrepancies in billing and payment certificates, reconciled supplier accounts and purchase orders<br>
Facilitated Oracle cash module user training for project site users</p>
Receivables & Collections Analyst
<p>Analyzed and reconciled customer accounts and receivables transactions<br>
Measured the performance of accounts receivable operation by tracking AR KPIs and metrics (DSO, aging, past-due invoices, AR turnover)<br>
Resolved customer issues, account discrepancies, delinquencies, disputes, and procedural errors<br>
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</p>
Accounts Receivable | Credit & Collections Officer
<p>Monitored Aging and Run Aging analyses and reporting requirements<br>
Made a substantial decrease in high and long overdue receivable balances and improved AR Aging and DSO<br>
Set up negotiations with client company payment decision-makers to work out payment plans and coordinate with the collection agencies for unmanageable accounts<br>
Administered creation and retention of client profiles and credit evaluation reports</p>
General Accountant | Financial Coordinator
<p>Performed monthly reconciliation on AR, AP, inventory, general journal adjustments, payroll, fund management, and financial analysis<br>
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<br>
Involved actively in the implementation and migration during the automation of the accounting system (FinPerf)</p>