Dorothy

Dorothy

Finance/Business Data Analyst
Germany
German, English

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…

Experience

Data Analyst/Data Engineer Trainee

Women AI Academy/Ethos AI
Mar 2023 - Present · 3 years 3 months

• 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

Women AI Academy, Germany
Mar 2023 - Sep 2023 · 6 months

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

Xerox Shared Services Philippines
Feb 2015 - Jun 2017 · 2 years 4 months

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

Mubadala Development Company
Dec 2011 - Jun 2014 · 2 years 6 months

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

Saif Bin Darwish
Jan 2009 - Jan 2011 · 2 years

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

NetSuite Philippines
Jan 2007 - Jan 2009 · 2 years

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

Ingersoll-Rand Philippines
Jan 2005 - Jan 2007 · 2 years

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

Levi Strauss Philippines ECCI
Jan 2000 - Jan 2005 · 5 years

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)

Skills

Integrated Business Intelligence Python SQL Database Data Analysis and Reporting Data Analytics SQL BigQuery Tableau Excel MySQL DBeaver PyCharm Jupyter GitHub AWS Redshift Oracle R12 NetSuite SAP R3 PLSQL Docker CLI ETL Kmeans clustering ABC analysis Pareto RFM metrics Data preprocessing Data exploration Data visualization Data analysis Financial reporting Accounting Business analysis Process improvement Oracle AP Accounts Payable Accounts Receivable Fixed Assets Vendor master data Data cleaning Data integrity Data quality Oracle project implementations Testing Documentation Go-live support Customer segmentation A/B testing Data modeling Apache Cassandra Postgres SQL queries Dashboarding
Report this Profile?