MELANI ERDOGAN Cliffside Park, NJ ad119t@r.postjobfree.com 201-***-**** DOB:7/6/1991

SPONSORSHIP OR WORK VISA NOT NEEDED

Quantitative & Qualitative Analyst, Project Manager Drive solutions to complex business problems. Advanced Excel(VBA,Pivot Tables,Macros ),Business Objects Reporting (SAP), Data Modeling, SQL, CRM, Python,,Power BI

PROFESSIONAL EXPERIENCE

Is Investment, Turkey 2018 - 2023

Senior Data Analyst

Customer Experience and Data Analysis

§ 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.

§ 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. BankPozitif Kredi & Kalkınma Bank (Affiliate of BHI),Turkey 2015 – 2018 Corporate Marketing Supervisor (2017-2018)

Corporate Marketing Analyst (2015-2017)

§ Analyzed corporate audit reports, prepared credit reports, presented to committee for approval.

§ Skilled in risk assessment, credit analysis, and implementing strategies to optimize credit processes.

§ Strong analytical skills, financial modeling proficiency, and a results-oriented approach to achieving project milestones within established timelines and budgetary constraints.

§ Adept at collaborating with key stakeholders, including credit analysts, finance teams, and senior management, to ensure projects align with corporate credit objectives.

§ Prepared cash flows and sector analysis reports,organized daily financial activities within the bank.

§ Participated in marketing and execution of Corporate & Investment Banking transactions - Corporate Finance, Project Finance, Post-Financing, Club Loans.

§ Monitored existing investments in Energy, Construction, Real Estate, Textile etc. EDUCATION & TECHNICAL SKILLS

Bachelor of Science, Mathematics & Computer Sciences, Istanbul Kultur University, Turkey (2009-2013)

Trilingual Armenian,English,Turkish Speaker

Microsoft Office Suite - Outlook, Word, PowerPoint, Excel (Pivot tables, Vlookups, Advanced data analysis) Business Objects Reporting (SAP), Data Modeling, Project Management, SQL, Python, Power BI CERTIFICATIONS & SEMINARS

• 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

• PMP® Exam Prep Seminar, J. Phillips Certificate