Georgios كوكاليس, Senior Data Analyst

Georgios كوكاليس

Senior Data Analyst

M. Giouroukeli & Associates

البلد
اليونان
التعليم
ماجستير, Operational Research (with Statistics)
الخبرات
15 years, 10 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :15 years, 10 أشهر

Senior Data Analyst في M. Giouroukeli & Associates
  • اليونان
  • أشغل هذه الوظيفة منذ يونيو 2013

The firm’s main activities involve debt collection and legal action on behalf of financial institutions. Using extensively the firm’s Business Intelligence tool, which extracts data directly from the existing database, or SQL queries and Microsoft Excel for further data manipulation, analysis and report building, my main achievements & responsibilities are as follows:

• Complete automatization of the extraction from the firm’s database of cases eligible for different types of legal action: I set up from scratch, maintain, update and export work lists (using our Business Intelligence tool) based on our clients policies, to derive, on a regular basis, cases eligible for different types of legal action (payment orders, extrajudicial letters, etc.) and collection activities.
• Portfolio analysis: Set up and perform regular, large-scale, detailed analysis of our clients’ portfolios employing business concepts and MS Excel tools and applications (advanced formulas, pivot tables, etc.)
• Production reports: Designed and produce daily, weekly and monthly production reports for the top management.
• Producing ad-hoc reports for all operations departments, as well as for clients, on a daily basis.
• Reports design and preparation for the top management’s meetings with clients.
• Designing, developing and implementing modifications on the firm’s database and Business Intelligence tool to their better functionality, in close collaboration with the Database Engineer.
• Managing the data analysis team’s junior analyst.

Key skills and competencies:

• Data manipulation and report building using MS Excel.
• Extracting data from databases using Business Intelligence tools and SQL queries.
• Assuming full responsibility for the firm’s reporting needs as well as for translating policies and business concepts to technical ones, providing guidance to operations departments and database engineers for appropriate action when needed.
• Multi-tasking, paying attention to detail and meeting strict deadlines.
• Project Management.

Business Consultant/Analyst في Bedor EXCEM S.A
  • اليونان
  • فبراير 2008 إلى أبريل 2011

As a Business Consultant/Analyst, I had the opportunity of participating in Productivity Measurement/ Improvement and Management Systems Re-Engineering projects. My main responsibilities were as follows:

• Company analysis: Operational, Behavioral, Statistical and Strategic. Detailed analysis of each department's operations leading to the development of their respective activity list. Collection and analysis of historical data on production, sales and personnel workload working hours. MS Access was used widely for this purpose. Analysis of their existing management systems based on their strengths and weaknesses.

• On site observations: Observation of the employees at work in order to measure their productivity and task completion times, to identify and propose action plans for: Better stock balancing, yield improvement, scrap reduction, lost time reduction, lead time reduction, space optimization, energy cost control, quality rejects reduction, logistics reduction and sales lost opportunities reduction.

• Data analysis in MS Excel: It involved the combination of historical data, activity lists and task completion times in order to derive the company's productivity results.

• Re-engineering of systems: Design, programming and delivery of a proposed management system for each department which included tools for targeting, planning, following-up and reporting. Proposed systems were automated and in MS Excel form. A manual was, then, prepared and delivered to all potential system's users on the clients' behalf.

• Working closely with the client: My role involved regular meetings with the client's middle and top management where our results and proposals were presented and agreed upon.

Artillery Radio Transmitter Operator في National Military Service
  • اليونان
  • أغسطس 2006 إلى أغسطس 2007

Artillery Radio Transmitter Operator

As a private, I received training in the use of guns and radio transmitters.

Internship في Titan Cement Company S.A
  • اليونان
  • يونيو 2003 إلى أغسطس 2003

Internship

As a student trainee, I assisted to the technical department's computerization creating a database of all technical blueprints.

Internship في Aluminium of Greece S.A
  • اليونان
  • يونيو 2002 إلى أغسطس 2002

Internship

As a student trainee, I participated in a continuous improvement team project where we had to measure task completion times and perform statistical analysis to the results. I also wrote up equipment manuals and presented it to the foundry's director and to the production engineer.

الخلفية التعليمية

ماجستير, Operational Research (with Statistics)
  • في The University of Edinburgh
  • سبتمبر 2005

List of courses: Computing for OR Mathematical Programming Methodology, Modelling and Consulting Skills Probability and Statistics Simulation Stochastic Modelling Statistical Modelling Time Series Analysis & Forecasting Analysis of Survival Data Combinatorial Optimization Credit Scoring

بكالوريوس, Production Engineering & Management
  • في National Technical University of Athens
  • يناير 2004

BEng in Mechanical Engineering {5 year course} - 69/100 Major: Production Engineering & Management

الثانوية العامة أو ما يعادلها, Sciences & Engineering
  • في Levadia High School
  • يونيو 1997

Specialties & Skills

Operations Research
Microsoft Excel
Data Analysis
MS ACCESS
Management Consulting
DATA ANALYSIS
MS POWERPOINT
MS EXCEL
Operations Research
Statistics

اللغات

الانجليزية
متمرّس
اليونانية
متمرّس

العضويات

Member of the Hellenic Technical Committee
  • Member
  • May 2006
Former student member of the Operational Research Society (UK) and the Hellenic Management Association
  • Student Member
  • October 2004

التدريب و الشهادات

Querying Microsoft SQL Server 2012 (تدريب)
معهد التدريب:
INFOLAB
تاريخ الدورة:
July 2014
المدة:
40 ساعة