Ahu Ezgi

Ahu Ezgi Email and Phone Number

Director of Financial Data Analytics at Vega USA Consulting Inc. @ Vega USA Consulting Inc.
Ahu Ezgi's Location
Alpharetta, Georgia, United States, United States
Ahu Ezgi's Contact Details

Ahu Ezgi personal email

n/a
About Ahu Ezgi

I am a Finance professional with 10+ years of experience in business intelligence, financial reporting, advanced data analytics with proven hands-on skills for analyzing large general ledger data using Snowflake SQL, Databricks, Microsoft Excel to perform financial analysis using Snowflake. Proficient in programming for extracting, transforming, and cleansing extensive datasets of significant size (multi-terabyte). I lead and collaborate with a team of highly skilled IT and Finance professionals dedicated to extracting meaningful insights from extensive datasets and financial reports that provide valuable intelligence for strategic decision making.I hold an MBA from San Francisco State University, specializing in corporate finance, and a bachelor’s degree in economics from Istanbul University, Turkey. My educational foundation serves as a cornerstone for leveraging analytical skills and leadership capabilities to optimize intricate financial data processes, guaranteeing accuracy and relevance in my reporting. The harmonious blend of my academic foundation and hands-on experience positions me as a strategic asset, facilitating the provision of actionable financial intelligence and proficient data analysis.

Ahu Ezgi's Current Company Details
Vega USA Consulting Inc.

Vega Usa Consulting Inc.

View
Director of Financial Data Analytics at Vega USA Consulting Inc.
Website:
vega-us.com
Employees:
2
Ahu Ezgi Work Experience Details
  • Vega Usa Consulting Inc.
    Director Of Financial Data Analytics
    Vega Usa Consulting Inc. Mar 2017 - Present
    Contributed to fostering better relationship with the finance team of Coca-Cola bottling business partners in the US while leading highly skilled IT professionals to generate results using Snowflake SQL and Databricks platforms. Programming for extracting, transforming, and cleansing extensive datasets of significant size (multi-terabyte) and reconciling profit and loss statements through advanced analysis in MS Excel. Curating financial data using Python and Databricks and Data Visualization tools to provide strategic insights for processing. Supporting diverse and complex bottler profitability projects for Coca-Cola US bottling business partners.Acting as a financial controller for the inputs and methodologies used within the unique tool that is called Bottler Profitability Management (BPM), critical for leadership and managerial decision making of our partnering customers. Delivering executive level presentations of the results. Building reports and other data mechanisms to streamline Ad-Hoc requests from Coca-Cola US bottling business partners and automation of controlling, reporting, reconciling and planning process for high quality results in limited available time.
  • Vega Consulting
    International Financial Analyst
    Vega Consulting Apr 2014 - Feb 2017
    Crafted Teradata SQL queries to analyze value chain management and facilitated Activity Based Cost allocation for Coca Cola Refreshments company and managed deadlines. Engaged in thorough research and analysis to reconcile intricate periodical financial reports using SQL queries, Excel reports and Big Data tools.Acted as a financial controller for the inputs and methodologies used within the unique tool that is called Bottler Profitability Management (BPM), critical for leadership and managerial decision making of our partnering customers.
  • Naz Baking Co.
    Co Owner
    Naz Baking Co. Jan 2012 - Dec 2013
    Managed financial data, prepared and analyzed monthly financial statements including forecasting, cash flow analysis, quarterly and year end reporting. Maintained accounting databases using Quickbooks.Developed and supported various ad-hoc projects and reports. Created and maintained all departmental complex budget worksheets with expenses detailed by the production process.Prepared budget to actual reports along with the production and operation summary reports. Analyzed the variances monthly and quarterly periods. Created and managed advanced spreadsheet for production and inventory control, analyzed the business process.
  • Garanti Asset Management
    Financial Analysis, Reporting And Budget Planning Supervisor
    Garanti Asset Management Oct 2007 - Jan 2010
    Maintained periodical and multi-year financial planning, analyzed and reported within company. Collaborated with other departments across the organization to form and improve the forecast reliability. Adjusted projections accordingly, compared forecast results to actual financial performance, prepared variance analysis including all elements of the P&L and Balance Sheet, generated graphics and spreadsheets to support decision makers. Provided timely, daily, monthly, quarterly and annual financial data along with the consolidated data for the CFO, VP and the Board of the company as well as the Garanti Bank.Prepared IFRS and other necessary reports for the Capital Market Board of Turkey along with the consolidation reports for the Garanti Bank.Analyzed monthly divisional financial statements and expense reports.Worked cooperatively with PwC audits for quarterly IFRS reports. Created new tools/reports to support the expansion of Financial Planning and Analysis responsibilities. Prepared sophisticated financial modeling in Excel for IFRS reporting purposes
  • Tepe Construction Ind. Inc
    Budget Planning And Financial Reporting Supervisor Of The Sales And Marketing Department
    Tepe Construction Ind. Inc May 2005 - Oct 2007
    Analyzed and reported the monthly, quarterly and annual financial data. Planned and prepared the financial projections of the sales and marketing department for its operations. Coordinated and prepared all departmental forecasting and prepared variance analysis. Analyzed the market research of the construction projects in Istanbul. Followed up the A/P for the suppliers of the marketing department and the A/R (cash and real estate loans) from the customers who signed the contract of the housing projects.Prepared bi-monthly financial reports for the creditor bank- Finansbank. Controlled the reporting interaction between Finansbank, and Tepe Construction.
  • Hsbc Bank
    Commercial Banking Supervisor Assistant
    Hsbc Bank Nov 2004 - May 2005
    Analyzed historical financial performance and company profiling of the small businesses. Updated database, reported the trade credit applications and the financial data of the companies in branch level using ORACLE CRM tools. Issued the documentaries to the system and followed up the daily transactions of the commercial customers. Marketed the international trade service products of the bank to the importers and exporters.

Ahu Ezgi Skills

Financial Analysis Financial Reporting Planning Budgeting And Forecasting Proficient In Excel Forecasting Financial Modeling Strategic Financial Planning Budgets Cash Flow Variance Analysis Ifrs Financial Statements Consolidation Valuation Spreadsheets Microsoft Excel Cash Flow Forecasting Analysis Business Planning Finance Financial Planning Business Strategy Budgeting Analytical Skills

Ahu Ezgi Education Details

  • San Francisco State University
    San Francisco State University
    General
  • Istanbul University
    Istanbul University
    Economics

Frequently Asked Questions about Ahu Ezgi

What company does Ahu Ezgi work for?

Ahu Ezgi works for Vega Usa Consulting Inc.

What is Ahu Ezgi's role at the current company?

Ahu Ezgi's current role is Director of Financial Data Analytics at Vega USA Consulting Inc..

What is Ahu Ezgi's email address?

Ahu Ezgi's email address is ah****@****llc.com

What schools did Ahu Ezgi attend?

Ahu Ezgi attended San Francisco State University, Istanbul University.

What are some of Ahu Ezgi's interests?

Ahu Ezgi has interest in Snowboarding, Jigsaw Puzzle, Bicycling, Skiing.

What skills is Ahu Ezgi known for?

Ahu Ezgi has skills like Financial Analysis, Financial Reporting, Planning Budgeting And Forecasting, Proficient In Excel, Forecasting, Financial Modeling, Strategic Financial Planning, Budgets, Cash Flow, Variance Analysis, Ifrs, Financial Statements.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.