MELANI ERDOGAN
Data Analyst
Ridgefield,NJ
Summary
Enterprising Financial Analyst with proven success in recommending appropriate financial plans based on accurate data collection, financial monitoring and business strategizing. Expertise includes financial analysis and reporting, contract management and forecasting. Develops and maintains high standards of quality and issue resolution through effective financial planning. Adept at utilizing top-of-the-line communication skills to build and foster long-term relationships.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Financial Data Analyst
1st Bergen Federal Credit Union
Hackensack, NJ
04.2024 - Current
- Conducted a review of over 1,500 general ledger entries, as well as Wisdom, Nautilus, and Alloya reports, achieving 99.8% accuracy to ensure financial consistency.
- Generated over 50 detailed reports through Reporting Analytics, enhancing performance monitoring by 20%.
- Handled over 500 ACH transactions monthly, maintaining a 0% error rate in recording and reconciliation.
- Prepared 10+ month-end reports, improving financial reporting accuracy by 15%.
- Resolved 95% of 25+ disputes monthly through diligent monitoring and follow-up.
- Generated 30+ loan performance reports, enhancing portfolio efficiency by 10%.
- Supported investment planning with sector rate data, improving decision-making by 20%.
- Evaluated 100+ clients' credit for business lending, reducing credit risk by 8%.
- Generated ALCO reports that enhanced balance sheet management efficiency by 10%.
- Achieved a 15% reduction in regulatory non-compliance by implementing effective risk mitigation strategies.
Senior Data Analyst
Is Investment
Turkey
01.2018 - 01.2023
- Reported investment banking sales realizations for 420 investment advisors and 35 branches to the Vice President
- Calculated revenue of 10 billion U.S
- Dollars for capital market products, including derivative products and stocks
- Analyzed a volume of 1000,000 client data using Power BI and Business Objects tools, producing reports to assist management in creating strategic plans and operational decisions to enhance sales performance
- Implemented a new 360 CRM system for an investment bank, resulting in a 45% increase in sales realizations
- Analyzed branch profit and statements to maximize profitability
- Developed and implemented database, data collection, and data analytics process improvements to help optimize statistical efficiency and quality of results
- Lead the development, data integration and data analysis of internal portal, used to analyze customer and employee data on sales targets, revenue, and product volumes
- Collaborate with top management to prioritize business and information needs for required reports
- Work closely with branch managers and sales team to ensure overall improvement of CRM activity; partner with data team to ensure all international CRM plans are integrated into plan
- Monitored of KPIs utilizing strong SQL/data analysis skills
- Implement feedback and analysis to drive improvements across all international CRM campaigns
- Identify, analyze, and interpret trends or patterns in complex data sets.
Corporate Credits Supervisor
BankPozitif Kredi & Kalkınma Bank (Affiliate of BHI)
Turkey
02.2015 - 01.2018
- Conducted analysis on 50+ corporate audit reports, generated 100+ credit reports, and delivered presentations to committees, securing approval for key decisions.
- Skilled in risk assessment and credit analysis, optimizing credit processes and reducing risk exposure by 12%.
- Demonstrated strong analytical skills and financial modeling, achieving 100% of project milestones within deadlines and budgets.
- Collaborated with credit analysts, finance teams, and senior management to ensure alignment with corporate credit objectives on 20+ projects.
- Prepared cash flows and sector analysis reports, efficiently managing daily financial activities within the bank, enhancing productivity by 15%.
- Participated in marketing and execution of Corporate & Investment Banking transactions, including 10+ Corporate Finance and Project Finance deals.
- Analyzed the progress of investments across various sectors, contributing to a 10% improvement in portfolio performance.
Education
Bachelor of Science - Mathematics & Computer Sciences
Istanbul Kultur University
ISTANBUL, TURKEY01.2013
Skills
- Advanced Excel
- Business Objects Reporting (SAP)
- Data Modeling
- SQL
(VBA,Pivot Tables,Macros)
- CRM
- Power BI
- Portico
- Wisdom
Certification
- Capital Market Activities Level 3 License
- Derivative Instruments License
- Credit Analysis for Construction Firms
- Balance sheet interpretation Techniques
- MS Excel Advanced Level Certificate
- Database and SQL Programming Certificates
- SAP BusinessObjects Web Intelligence Report Design Certificate
Workauthorization
SPONSORSHIP OR WORK VISA NOT NEEDED
Languages
Armenian
Native or Bilingual
Turkish
Native or Bilingual
German
Elementary
English
Native or Bilingual
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Financial Data Analyst
1st Bergen Federal Credit Union
04.2024 - Current
Senior Data Analyst
Is Investment
01.2018 - 01.2023
Corporate Credits Supervisor
BankPozitif Kredi & Kalkınma Bank (Affiliate of BHI)
02.2015 - 01.2018
Bachelor of Science - Mathematics & Computer Sciences
Istanbul Kultur University