Power Bi Data Engineer

Melissa Ay

E-mail: ********@*****.*** - Phone: 917-***-**** – Philadelphia, PA

Broad experience in financial analysis, accounting, and data management across multiple industries. Proficient in strategic planning, improving processes and systems, and creating financial metrics. A goal-oriented professional with a solid record in reducing costs, automating systems, meeting, and exceeding expectations, and delivering on time. Skills

• Data Extraction, Cleaning, Formatting, Normalizing, Storing, Analysis, and Visualization

• P&L, Balance Sheet, and Cash Flow preparation and analysis

• System implementation, automation, and process improvement

• Microsoft Excel, SQL, Tableau, Power BI, Python

• SAP, Concur, Workday, NetSuite, PeopleSoft, Oracle ERP, Hyperion SmartView, Anaplan

• Project Management & Agile Tools: Jira, Confluence, Agile Methodology, Kanban Experience

Senior Data Engineer & Analyst, BNY Mellon, 11/2023 – Present

• Develop and maintain Power BI dashboards and financial models to track expenditures, ensuring data-driven decision- making, which resulted in a 15% reduction in unnecessary spending.

• Manage Oracle database and create data pipeline working alongside with ETL engineers.

• Collaborate with IT and finance teams to reconcile technology spend, identify cost-saving opportunities, and improve financial planning, leading to a 10% increase in budget accuracy.

• Automate data extraction and reporting processes using SQL, Python, and Power BI tools, enhancing efficiency and accuracy by 20%.

• Monitored technology budgets, analyzed variances, and provided insights on trends impacting financial performance, contributing to a 12% improvement in financial forecasting. Senior Financial Analyst, New York Stock Exchange, New York, NY, 12/2022 – 8/2023

• Managed monthly, quarterly, and annual budgeting cycles, ensuring efficient processes for budgeting, forecasting, and performance reporting, which improved reporting timeliness by 18%.

• Coordinated and processed necessary journal entries during monthly close, reducing closing time by 25%.

• Provided variance analysis for P&L to management level, leading to a 10% improvement in financial decision-making. Senior Accounting Analyst, Mizuho Bank, New York, NY, 08/2019 – 08/2022

• Managed and maintained expenses and made sure transactions align with compliance.

• Performed master data maintenance (employees, vendors, GL, and cost centers), which increased data accuracy by 15%.

• Oversaw annual budget process and monitor budget spendings throughout the year, and automated car service and storage processes that saved the company over 3MIL annually. Accountant, WME Entertainment/IMG Models, 07/2015 – 09/2018

• Established accounting department along with three other accountants, streamlining AR, AP, and GL processes, resulting in a 25% improvement in reporting accuracy.

• Implemented SAP and SAP-Concur systems, reducing manual entry errors by 30% and enhancing financial reporting efficiency.

• Mentored and trained a team of 5+ accounting staff, driving a 15% improvement in team performance and professional growth.

Education

• Pace University, New York, NY – Bachelor of Business Administration in General Business/Accounting

• Full Stack Academy, New York, NY – Certificate in Data Analytics (SQL, Python, Tableau, AWS) – Oct 2023

• Columbia Business School/Emeritus Institute of Management – Marketing Analytics Certificate – Sept 2018

Contact this candidate