CV General Concise

S. MURAT CAKIR Email: earloflondon@gmail.com Central Bank of the Republic of Turkey Structural Economic Research Department Ankara, Turkey Phone: +90 505 726 2022 LinkedIn: /murat-cakir-422b804/ 

PROFILE 

Seasoned multidisciplinary DM&ML field expert and research analyst highly driven by the exciting nature of hands on exhaustive data analysis, having dealt with primarily accounting, finance and economics data and statistics for over 20 years. Holds insatiable desire and controlled grit for learning new knowledge technologies. Proven track record of innumerable studies covering different disciplines including reports, notes, analyses, statistics and research for internal use, in policy-making and informing the public. Designed, managed and implemented projects that are still being in use in situ and/or inspired various others utilized elsewhere. Bringing forth the ability to approach the issues with a polymathic and systemic mindset to offer the incumbents the best products and services. 

PROFESSIONAL SUMMARY 

Design, Programming and Database Management Project Development: Originated the 2nd generation platform idea. Co-developed its conceptual design with IT. Independently designed the 3rd generation platform. 

IT Collaboration: Collaborated on online report dissemination and website servicing. Led analysis efforts with IT project groups. 

Database Management: Created and managed sub-databases. Ensured data integrity and consistency. 

Data Analysis and Reporting: Conducted diverse analyses. Managed data processing and report generation. 

Automation Projects: Contributed to automation initiatives. Designed system analysis pseudo-codes. Overall, your role seems to have been crucial in the development, management, and improvement of analytical platforms and processes within your organization, with a focus on integrating technology with data analysis for informed decision-making. 

Data Management Data Integrity: Ensure accuracy and consistency of raw and processed data. 

Financial Data Processing: Gather, correct, and process financial data from banks and firms. Public Financial Data Compilation: Collect and rectify financial information from public sources. Data Correction and Organization: Rectify errors and organize data systematically. 

Firm Categorization: Categorize firms based on various criteria. 

Software Application Usage: Utilize specialized software for data collation and analysis. 

Database Management: Transfer processed data, maintain integrity, and generate reports. Overall, your responsibilities encompass a wide range of tasks related to data management, financial analysis, and decision support within the financial and industrial sectors 

Analysis, Reporting, Data Dissemination and Publishing Financial Statement Analysis: Analyze aggregated financial statements statistically and dynamically for manufacturing and services sectors. Conduct detailed financial analysis for individual firms, evaluating performance and trends. 

Report Preparation: Prepare electronic and printed financial reports for online and offline distribution. Generate standard and ad-hoc reports for senior management, stakeholders, and the public. 

Sector-Based Data Analysis: Analyze sector-specific data to identify trends and opportunities. Produce reports for academic research and public consumption on sector performance. 

Management Reporting: Provide standard and ad-hoc reports to upper management. Present key financial metrics and insights to support decision-making. 

Firm and Sector Analysis: Conduct comprehensive analysis of firms within manufacturing and services sectors. Prepare reports on financial health, competitive positioning, and strategic outlook. 

Academic Research and Consultancy and Teaching and Tutoring General and Other Efficiency Enhancement: Improved report quality and efficiency through automation. Provided feedback on financial stability and policy framework. 

Research Activity Enhancement: Boosted departmental research activities and developed original project ideas. 

Data Analysis and Modeling: Utilized data mining and machine learning for financial system assessment. Developed quantitative methods for analysis. 

Project Management: Guided project teams and organized testing procedures effectively.

Database Management: Prepared and maintained database libraries for streamlined data management.

Platform Management Documentation: Created and updated manuals and Wiki pages for online platform management.   

Team Management: Directed teams of 5 to 10 members, resolving key project issues and improving performance and fund utilization. Mentored staff to enhance task leaders and assistants' performance. 

Data Management and Analysis: Provided tutorials on data management techniques and offered technical recommendations. Conducted thorough data validation and presented models for business team review. Utilized exploratory data analysis to identify patterns and trends. 

Project Coordination and Client Interaction: Coordinated with external companies for data integration and acted as the primary client contact. Managed financial, sectoral, and economic analysis projects, introducing significant improvements. Interacted with the community to coordinate country assistance programs. 

Automation and Process Improvement: Implemented automation to streamline processes and increase productivity. Introduced improvements in research systems for enhanced resource management. 

Report Generation and Stakeholder Engagement: Created reports and statistical analyses, providing a framework for evaluating techniques. Collaborated with stakeholders to identify process improvement opportunities and external data sources. 

Leadership and Initiative: Spearheaded the innovative [Project Name], from inception to Board presentation, pioneering a unique initiative. Successfully advocated for transitioning from [Previous Program] to [New Program], resulting in widespread implementation. 

Project Management: Oversaw project design, regulation, and daily management. Analyzed business performance, developed workflow diagrams, and ensured projects were completed on time and within budget. 

Business Analysis and Financial Reporting: Provided guidance to junior analysts and conducted impact analysis of technology changes. Generated financial statements, including cash flow charts and balance sheets, for sectors and overall. Conducted proprietary risk analyses and prepared routine and ad-hoc reports for upper management. 

Budgeting and Forecasting: Produced various financial reports, budgets, and forecasts, ensuring accuracy and alignment with business goals. 

Work Experience Roles and Responsibilities: Managed design, programming, database management, analysis, reporting, and team membership across various reports. Oversaw team efforts and organized work streams, leading and guiding project groups. 

Project Management: Led and organized multiple project and work groups, both domestically and internationally. Represented the organization in meetings and made presentations at various forums. 

Reporting and Presentation: Prepared ad-hoc reports and technical notes for upper management, academia, and the public. Presented findings to stakeholders at meetings and workshops. 

Automation and Productivity: Implemented automation to enhance productivity, reducing manpower needs and minimizing errors. 

Projects Portfolio Efficiency and Quality Enhancement: Improved efficiency and report quality through automation. Provided feedback on financial stability and policy frameworks. 

Project Development: Conceived original project ideas and designed conceptual frameworks. 

Analytical Methods and Management: Applied analytical methods and developed proprietary quantitative techniques. Managed project teams and organized project tests. 

Database and Platform Management: Prepared database libraries and maintained online platform management manuals and Wiki Pages. 

General and Other Team Oversight and Planning: Supervised teams across various levels. Organized work streams for different groups. 

Leadership and Collaboration: Led and guided multiple project groups. Held positions such as Information Security Group correspondent. 

External Collaboration and Representation: Collaborated with the Ministry of Finance. Represented the organization at meetings. 

Contributions to Reports and Publications: Contributed to the Financial Stability Report. Analyzed data dissemination methods and prepared reports. 

Manual Preparation: Authored the "Statistics, Data, and Database Management Manual." 

EXPERIENCE 

Sep, 2017 - Present Seasoned Expert and Research Analyst Central Bank of the Republic of Turkey - Structural Research 

Mar, 2014 - Sep, 2017 Experienced Expert Central Bank of the Republic of Turkey – Statistics

Feb, 2006 - Feb, 2014 Senior Specialist Central Bank of the Republic of Turkey – Statistics 

Oct, 2001 - Feb, 2006 Specialist Central Bank of the Republic of Turkey – Statistics 

Oct, 2001 - Feb, 2006 Officer Central Bank of the Republic of Turkey 

–Statistics Professional experience in data analysis, including collection, compilation, and dissemination of statistical data. Proficiency in applying and/or developing quantitative research methods in compliance with standard statistical principles. Skilled in using statistical software packages such as STATA and R as required. Experience in managing international statistical databases and producing statistical data at the international level. Familiarity with developing methodological statistical standards to ensure data quality and consistency. Experience in project management and evidence-based policy formulation. Capable of providing education and training to colleagues as part of personal development strategies. 

#4 SKILLS Microsoft Office (Advanced Proficiency) | SAP | TRS | LARS | LMS | Adobe Acrobat | SharePoint 

EDUCATION 

Sep, 2000 Oct, 2001 MSc in Finance - Bayes Business School, City, University of London Sep, 1997 Jan, 1999 Special Studies in Economics (Master Level) - Middle East Technical University Sep, 1991 Jul, 1996 BSc in Management - Middle East Technical University Computing and Analysis Skills, and 

Certificates Computing Skills: 

Office Productivity Tools: MS Office 2019 (Excel & VBA, Word, PowerPoint, Access), MS Power BI, Power Pivot, Report Builder Database Querying and Reporting: Business Objects Web Intelligence, MS Query, Oracle 

Business Intelligence, SAS Enterprise Guide, PostgreSQL Data Analytics and Visualization: Tableau, MS Power BI, MS Power Pivot, Google Data Studio 

Data Analysis and Statistics: SAS Base, MATLAB, R, Python Statistics and Econometrics: MATLAB, WinRATS, STATA 

Programming Languages: VBA, R, Python, JavaScript 

Data Mining, Machine Learning, and Data Science: WEKA, KNIME, MOA, ADAMS, MEKA, Google Colab 

Network Analysis: NodeXL, Gephi 

Computing Certificates 

Data Science, Data Analysis and Analytics 

• The Data Science Course 2022: Complete Data Science Bootcamp (UDEMY) 

• The Data Analyst Course: Complete Data Analyst Bootcamp 2022 (UDEMY) • The Complete SQL Bootcamp 2022: Go from Zero to Hero (UDEMY) 

• Advanced SQL Bootcamp (UDEMY) 

• Statistics for Data Science and Business Analysis (UDEMY) • Data Science A-Z™: Real-Life Data Science Exercises Included (UDEMY) • Learning Python for Data Analysis and Visualization (UDEMY) 

• Introduction to Data Science in Python (DATACAMP) 

• Introduction to Accounting Data Analytics and Visualization (COURSERA) 

• Accounting Data Analytics with Python (COURSERA) • Data Manipulation at Scale: Systems and Algorithms (COURSERA) 

• R Programming (COURSERA) Data Mining and Machine Learning 

• Data Analyzing and Machine Learning Hands-on with KNIME (UDEMY) • Machine Learning, Data Science and Deep Learning with Python (UDEMY) 

• Python for Data Science and Machine Learning Bootcamp (UDEMY) 

• Machine Learning A-Z™: Hands-On Python & R in Data Science (UDEMY) 

• Data Mining for Business in Python (UDEMY) 

• Professional Certificate in Data Mining & Machine Learning (UDEMY) • Data Mining with R: Go from Beginner to Advanced (UDEMY) • Data Mining with Weka (FUTURELEARN) – Introductory / Certified • More Data Mining with Weka (FUTURELEARN) – Intermediate • Advanced Mining with Weka (FUTURELEARN) – Advanced • Machine Learning for Accounting with Python (COURSERA) • Applied Text Mining in Python (COURSERA) • Applied Machine Learning in Python (COURSERA)

BoE - Lead Data Analyst in Current Economic Conditions Division

Lead Data Analyst in Current Economic Conditions Division Monetary Analysis (MA) provides the core analytic support that underpins the setting of Bank Rate each month by the Monetary Policy Committee (MPC) to meet its inflation target. Department Overview Current Economic Conditions Division (CECD) provides the MPC with assessments of the current state of UK economic activity and inflation, the near-term outlook, and the uncertainties around this view. This is typically some of the most central information in the monetary policy debate. We do this by analysing a wide array of official data, surveys and other information. We maintain and develop state-of-the-art econometric models to produce short-term forecasts and interpret current economic developments. And we draw these materials together to form an overall picture and highlight important developments for UK monetary policy. In response to both new challenges and new opportunities for our data analysis, we are looking to enhance our data capability and analytical infrastructure along several dimensions, with this Lead Data Analyst role sitting at the heart of that. We are a division of around 25 people with a range of backgrounds and experiences. Job description We are recruiting a Lead Data Analyst to join the Division at an exciting juncture, as we gear up to enhance our analytical infrastructure. The successful applicant would be part of a newly formed function in the division, and therefore play a pivotal role in helping to set the blueprint for the work. The exact nature of this role can be tailored to the interests of the successful candidate. Although three broad areas in which we would expect to make progress are: 1) opening up new avenues for analysis using modern methods, for example improving our micro-data manipulation capabilities, or applying machine-learning methods to forecasting and other problems; 2) increasing the impact and reach of our analysis, for example by developing new data visualisations, dashboards, etc; and 3) helping to make our analytical and modelling processes more efficient and robust through greater use of automation, more sophisticated coding, etc. As a Lead Data Analyst in CECD, you will be at the centre of scoping out the exciting possibilities and setting out a strategy for this new function, in collaboration with our group of Senior Economists and Leadership Team. In your day-to-day you will be expected to take the lead on development work and deliver on a range of outputs, working with colleagues from across the Division, but potentially also beyond, for example with experienced Data Scientists sitting in the Bank’s Advanced Analytics Directorate. You do not need prior knowledge of economics. We think you can learn what you need to help guide and maximise the impact of your work in the role, provided you have a good quantitative background. In case of interest, this role will also provide plenty of opportunity to develop deeper economic expertise, for example by getting involved in more specialist analytical or model development projects, in close collaboration with our experienced teams of Economists and Researchers. Monetary Analysis is fully committed to having a diverse and inclusive working environment. These roles can be done as part of a job share and/or with flexible working. Role Requirements If you believe you have the skills to help us make progress in some or all of the three key areas listed above, whatever your background, we welcome your application; please do not be put off from applying if you do not strictly meet all the criteria in the below. As a general guide though, we would expect the successful applicant to have: Essential Requirements a postgraduate qualification in a quantitative subject, for example data science, other STEM degrees or economics/finance, or an equivalent level of work experience. delivered projects or work that rely on coding in popular modern languages such as R or Python. ability to produce high-quality analysis to tight deadlines. Excellent time management and organisational skills. Desirable Requirements a few years of relevant work experience undertaking analysis of large or complex data sets/databases. excellent data manipulation and ‘dataviz’ skills, as well as knowledge of modern data science methods such as machine learning. flexibility to deploy these skills in a potentially less familiar context, and the imagination to help us find innovative use cases. interest in learning about the UK economy and helping the Division provide high quality analysis to the Monetary Policy Committee. Core Values Integrity is one of the Seven Principles of Public Life. Our personal interests should never influence our decisions at work. We must be free of any suggestion of inappropriate influence. Selflessness, objectivity and impartiality are a core part of our Bank values. We strive to be objective in our decision-making and decisive in our actions. We take pride in the quality and the impartiality of our analysis and research. We engage with others professionally and make decisions fairly and on merit, using the best evidence available. We know that our reputation for impartiality and independence is vital to our effectiveness and, if lost, would be hard to recover.

EIB Job Apllication - (Senior) Data Management Officer (Luxembourg)

This is a full time temporary position at grade 5/6. The term of this contract will be 2 years. *internal benchmark: (Senior) Officer Portfolio Management Panel interviews are anticipated for beginning of April 2024. PURPOSE The purpose of the role is to oversee data management initiatives related to the role of a data owner for signed/disbursed exposures, driving precision in data operations, spearheading enhancements to data structures, and shaping comprehensive data and business rules, ultimately advancing the Bank's mission of ensuring superior data quality and robust governance practices. The Joint Middle Office (JMO) sits between the Operations (OPS) EIB Global (GLO) and Portfolio Management and Monitoring (PMM) directorates. Under the 3LoD, OPS and PMM constitute the core of the First Line of Defence, whose job it is to assess and manage all risks inherent to our client-facing activity. The JMO centralises the middle office activities previously carried out within OPS/GLO (e.g. disbursements and allocations) and PMM (e.g. post-disbursement events, portfolio-monitoring support, know your customer (KYC) checks). It has a functional reporting line to both directorates. PMM/JMO/EP&MS division is part of the Joint Middle Office department and is currently composed of 3 units: Portfolio Monitoring Support and Guarantee calling unit (PMS&GC), Arrears, Collaterals and Covenants (ACC) and Events processing Unit (EP). This particular position will be allocated to the PMS&GC unit and is expected to perform operational activities in the area of data management assuming the role of data owner for signed/disbursed exposures. This role is accountable for the aforementioned dataset and has the capacity to ensure data are managed correctly (i.e. is accountable for the business logic of the data calculation and proposes changes to the data structure). Data owner is also in charge of the definition of the data and related business rules as well as steering the quality of the data and related data management and governance activities. In this context, this role is also expected to manage ad-hoc transversal/cross divisional projects. OPERATING NETWORK As a (Senior) Data Management Officer you will report to the Head of the PMS&GC Unit. You will have regular contact with colleagues within Portfolio Management and Monitoring Directorate as well as in other Directorates, notably with the Group Data Office and IT Services within the Group Corporate Services Directorate, the Group Risk & Compliance Directorate, the Operations Directorate, EIB Global, Financial Control, the Finance Directorate and the General Secretariat Directorate. ACCOUNTABILITIES Acquire in-depth knowledge of the Bank’s lending portfolios and products; (incl. some specific products such as quasi-equities, full/partial delegation linked/de-linked risk sharing, indexed linked loans, loans with capitalisation parameters etc.); advise on exposure data topics in relation to newly proposed products. Review and regularly maintain/update exposure data inventory and catalogue. This is a catalogue of the various exposure data categories and underlying data of which they are composed/which are collected (along with metadata about each data, such as data source) and the calculation logic (incl. proposing changes to the data structure, e.g. in relation to deployment of new products, etc.). Establish rules and procedures for exposure data management, including data access, data quality controls, and audit change log. Communicate with stakeholders on exposure data usage guidelines and best practices. Provide support to other Services to pick the right exposure data set for their respective needs by providing explanations on how respective exposure data sets are calculated on how exposure should be displayed in front office systems (e.g. Serapis). Assume the lead on User Acceptance Tests (regression testing) in new projects in or upgrades of systems etc. to ensure that data collection works as previously. Manage rules for storing the exposure data, e.g. access controls, procedures for archiving (data backup, versioning, retention etc.). Prepare an exposure data management plan for execution of detailed data analysis and control processes. Prepare tools that will be used to analyse exposure data, designed to communicate key findings and insights from the data in a clear and easy-to-understand format. Review the EOM exposure data reconciliation across relevant systems (regular and continuous monitoring of data quality). Continuously adjust the data quality controls based on newly identified issues as well as new product/mandate/system developments etc. Identify and contribute to resolution of exceptions/DQ issues. Contribute to the Group Exposure definition (in context of BSBC239), in liaison with DGO. Conduct regular reviews of data management processes and policies to identify areas for improvement. Support the Head of Unit in execution of other day-to-day operational tasks of the unit upon request. Encourage information and knowledge sharing and promoting data quality within the Bank. Ensure overall quality of the data output, and minimization of operational risks. Constant review of processes and proposing adaptations, with a view to ensuring streamlining. Management of or contribution to transversal projects linked to development of existing/new processes. QUALIFICATIONS University degree (minimum an equivalent to a Bachelor), preferably in finance, business analytics or data science, economics, or information management/information systems. At least 5 years of relevant professional experience in data management, ideally in the field of banking or finance. Knowledge of MS office tools, in particular Excel (ideally incl. VBA), PowerPoint, knowledge of SQL and data virtualisation tools (e.g. Denodo). Understanding of the EIB mission and activities as well as the operating and political framework in which the Bank operates. Knowledge of the Bank’s lending products and mandates, exposure to new products, good knowledge and/or previous experience with administration of some specific products (such as quasi-equities, risk sharing etc.), would be considered an advantage. Knowledge of EIB processes and procedures related to the administration, control and monitoring of lending operations would be an asset. Knowledge of IT applications supporting lending operations in EIB e.g. CLM, Serapis would be an advantage. Fluency in English and a good command of French** is required. Another EU language would be an advantage. COMPETENCIES Your core competencies at the EIB: Achievement Drive: You continually keep an eye on performance, focus on improving it, show drive and determination to meet short and long-term goals. Change Orientation: You adapt to differences and changes in the environment; you take a flexible approach to reach outcomes. Collaboration: You work cooperatively as part of a team and collaboratively with peers across organisational boundaries based on a genuine interest in and an accurate understanding of others and your individual perspectives and concerns. Organisational Commitment: You are willing to commit to an organisation whose mission is to support Europe and is open to diversity, and to align your own behaviour with the organisation’s needs and intrinsic values, acting with integrity in ways that promote the organisation’s mission, policies and rules. Your managerial competencies at the EIB: Developing Others: You build the long-term capability of others by guiding and developing them to make the most of their competence and potential, based on an accurate understanding of their true strengths and development needs. Strategic Thinking: You think about the long-term organisation strategy and how to align to and implement it; you come up with useful new strategic insights. Team Leadership: You build a high-performing team, ensuring it is focused, motivated and inspired to achieve organisational objectives; you encourage performance excellence and address underperformance when required. Apllıcatıon - QUALIFICATIONS MOTIVATION LETTER AND OPEN QUESTIONS WHAT’S YOUR EXPERTISE LEVEL IN EXCEL. (BASIC, GOOD, VERY GOOD, PROFICIENT). PROFICIENT PLEASE MENTION DATA VISUALIZATION TOOLS YOU HAVE EXPERIENCE WITH AND WHAT’S YOUR LEVEL OF EXPERTISE IN EACH OF THEM (BASIC, GOOD, VERY GOOD, PROFICIENT). WHAT’S YOUR EXPERTISE LEVEL IN SQL. (BASIC, GOOD, VERY GOOD, PROFICIENT). VERY GOOD PLEASE EXPLAIN, IN MAXIMUM 5000 CHARACTERS (ABOUT 700 WORDS), YOUR MOTIVATION / REASON FOR APPLYING FOR THIS POSITION. Dear Hiring Committee, I am writing to express my sincere interest in the (Senior) Data Management Officer position at the European Investment Bank (EIB). With over two decades of comprehensive experience in multidisciplinary data management and machine learning, coupled with an unwavering commitment to excellence, I am eager to contribute to the EIB's esteemed mission while aligning with its core values. Throughout my extensive career, I have demonstrated a relentless dedication to exhaustive data analysis, particularly within the realms of accounting, finance, and economics. My portfolio boasts numerous studies covering diverse disciplines, yielding reports, analyses, statistical findings, and research pivotal in informing internal decision-making processes, shaping policy frameworks, and disseminating crucial information to the public. Over the years, I have played a pivotal role in the design, development, and successful implementation of innovative projects aimed at enhancing operational efficiency and facilitating informed decision-making. Notably, I spearheaded the conceptualization and realization of cutting-edge analytical platforms, collaborating closely with IT teams to ensure seamless integration and functionality. My ability to adapt to dynamic environments and embrace change has been instrumental in driving continuous improvement in analytical processes and platforms. In addition to my technical prowess, I possess a strong aptitude for leadership and collaboration. As a seasoned team leader, I have demonstrated an adept ability to foster a culture of excellence and accountability, guiding teams towards the achievement of organizational objectives. My collaborative approach, coupled with effective communication skills, has enabled me to leverage the diverse perspectives of team members to drive innovation and achieve optimal outcomes. Furthermore, my commitment to organizational values and mission alignment is unwavering. I am deeply passionate about supporting Europe's development and promoting diversity and inclusion within the organizational framework. My track record of delivering high-quality results while upholding integrity and professionalism aligns seamlessly with the values upheld by the EIB. In summary, I am excited about the opportunity to contribute my expertise to the core of data management at the EIB. With a proven track record of success, a strong commitment to excellence, and a collaborative mindset, I am confident in my ability to make meaningful contributions to the EIB's continued success. Thank you for considering my application. I look forward to the opportunity to further discuss how my qualifications and experiences can contribute to the strategic objectives of the EIB. Yours sincerely,

Data Science Interviews

https://github.com/youssefHosni/Data-Science-Interview-Preperation-Resources/tree/main

CERTIFICATE PROGRAMS

Data Science and Analytics Courses

    UDEMY: The Data Science Course 2022: Complete Data Science Bootcamp / In progress

    UDEMY: The Data Analyst Course: Complete Data Analyst Bootcamp 2022 / In progress

    UDEMY: The Complete SQL Bootcamp 2022: Go from Zero to Hero / In progress

    UDEMY: Advanced SQL Bootcamp / In progress

    UDEMY: Statistics for Data Science and Business Analysis

    UDEMY: Data Science A-Z™: Real-Life Data Science Exercises Included

    UDEMY: Learning Python for Data Analysis and Visualization 

    DATACAMP: Data Analyst with Python 

    70 Data Science Cheat Sheets for Everyone in 2022

Data Mining and Machine Learning Courses

    UDEMY: Data analyzing and Machine Learning Hands-on with KNIME

    UDEMY: Machine Learning, Data Science and Deep Learning with Python

    UDEMY: Python for Data Science and Machine Learning Bootcamp

    UDEMY: Machine Learning A-Z™: Hands-On Python & R In Data Science

    FUTURELEARN: Data Mining with Weka / Certified (29th September 2022)

    FUTURELEARN: More Data Mining with Weka

    FUTURELEARN: Advanced Data Mining with Weka

 

/ In progress

    COURSERA: Accounting Data Analytics Specialization    
        Introduction to Accounting Data Analytics and Visualization
        Machine Learning for Accounting with Python
        Accounting Data Analytics with Python
        
    COURSERA:Data Science at Scale Specialization    
        Data Manipulation at Scale: Systems and Algorithms
        
    COURSERA: Applied Data Science with Python Specialization    
        Applied Text Mining in Python
        Applied Machine Learning in Python
        
    COURSERA: Data Science: Foundations using R Specialization    
        R Programming

 

 

World Bank Group - Economist - req18322

1. Tell me about yourself (1-2 minute overview focusing on relevance to the position).

 I am an experienced expert and a research analyst at CBRT’s Structural Economic Research Department. I am a specialist in real sector analysis, risk, and banking. I am responsible for preparing ad-hoc reports and notes for the upper management about the systemic and credit risks of the financial and non-financial sectors, financial stability, and development issues.

I have also worked on establishing the departmental research and reporting data warehouse coordinating efforts with the Statistics Department and on the design. For the last year and a half, I have been tasked with managing the editorial work of the CBRT's online publication Central Bank Review, hosted by Elsevier. Recently, I was selected as a tutor/trainer for an in-house position to teach Data Analytics and Visualisation, Data Mining, and Machine Learning subjects.

Before I moved here, I have worked in the Statistics Department for about 19 years. I have worked on many projects along with many other duties related to real sector statistics. I have made a lot of improvements, led project teams and task groups, delivered projects of all different scales.  I have inspired the designs of many projects which are still in use in the bank and other institutions and represented the bank both abroad and domestically.
Over the years, my focus was on real and financial sectors within financial stability and macro-prudential policy-making framework. My work has been a crucial source of contribution to supporting the policy-makers.
I have always had a heavy workload spread around the year with challenging deadlines and tight time budgets. I could manage these challenges and be productive by being highly organized and thorough meticulous planning efforts. One last thing I should say, all these years I have dealt with large datasets and I have become comfortable in handling them productively and efficiently.

Over the years I have worked for the CBRT, my job has involved an extensive focus on the real and financial sector analyses in financial stability and a macro-prudential policy-making framework. In this endeavour, my work has been a crucial source of contribution in supporting the policymakers. My past and current work schemes have required a considerable extent of analytical skills, which have proved to be vital in the achievements of my practical experience as well as my theoretical work.

My particular work scheme in the CBRT has always involved a very heavy workload spread all around the year constrained by very strict deadlines and by very tight time budgets, all quite challenging. I have learned through the years how to manage these constraints and transform the stress and uncertainty along with it into productivity rather successfully by being highly organized and thorough meticulous planning. I have had longer than 10 years of experience in leading project teams successfully. I have also had inter-organizational experience in data management issues both within the country and abroad in meeting and/or co-working levels. As to statistics and data issues, I can comfortably say that the heavy workload I carried through these years involved dealing with very large datasets, processing them, and turning them into information for policymaking.

Currently, I am working as a research analyst in the Structural Economic Research Department of CBRT, and as a seasoned expert in real sector analysis, risk, and banking. My current responsibilities involve the coordination of the establishment and the development of research and reporting data warehouses. I am also responsible for preparing ad-hoc reports and research notes and papers for the upper management regarding the credit and systemic risks of real and financial sector firms, as well as the financial stability and economic development issues. I have also been responsible for editorial issues related to the CBRT’s online publication Central Bank Review hosted by Elsevier, for about a year. Recently, I have applied for an in-house tutor/trainer role and I hope to train the next generation colleagues in mostly data analysis and reporting issues.

For all the years I have worked at the CBRT, my job has always required meticulous work in managing the data. My approach to data, in general, is to put an effort to acknowledge the possible uses of the data in question, at first, if I have a first-time encounter with it rather than catering to it myself to fill a need. This usually, essentially means a reasonably deep mental focus on the whole process for me, involving all the details from the collection to possible outcomes/end products. If the need for data arises from an end-product or a prospective design then I look for the raw data, possible sources for it, and for ways of obtaining the most optimal way of collecting the cleanest data as quickly as possible. Further, I try to imagine the data processes, draw simple flowcharts, and write the pseudocodes as much as I can if possible.

The datasets I’ve worked on in particular have included the credit/loan data, bank financials, and individual real sector firm financials. Those datasets are mostly very granular and complex if not highly frequent (from daily to annual), and very large given the number of individual unique IDs and spanning a range of 15-20 years depending on the datasets. As detailed in my CV, my work has encapsulated all ranges of subprocesses including the data collection to the production of final reports published, ensuring high quality in the data in terms of integrity, validity, and accuracy at all times as much as possible.
During the years I’ve worked, at the Statistics Department particularly, I’ve either managed project teams as well as task groups or I’ve individually run projects which I independently designed. Those projects and tasks themselves involved extensive use of analysis and reporting applications (e.g. SAS, Business Objects, Oracle BI, sometimes Excel and VBA) which I also employed to carry out a considerable amount of work. I also have used statistical and mathematical analytic methods, especially in both project designs and in preparing report templates. I further employed data mining and machine learning methods both for data analysis, pattern recognition, and rule learning although not extensively. Also worth mentioning, I have designed numerous interactive and dynamic data forms, and reports as well as a web-based reporting platform using SAS, Business Objects, Oracle BI, VBA, and QlikView, and helped the crew maintain CBRT’s Electronic Data Delivery System (https://evds2.tcmb.gov.tr/index.php?), in the absence of now available data analysis and visualization tools like Tableau and MS Power BI.

 I am an experienced expert and a research analyst at CBRT’s Structural Economic Research Department. I am a specialist in real sector analysis, risk, and banking. I am responsible for preparing ad-hoc reports and notes for the upper management about the systemic and credit risks of the financial and non-financial sectors, financial stability, and development issues.

I am also responsible for managing the departmental data warehouse. I was transferred from the Statistics Department five years ago for this and my other capabilities relating to the real and financial sector research and statistics background.

For me, data analysis has two perspectives: researcher and end-user.
I believe a researcher should have an innate drive for data analysis before anything else, and a statistician should have more so. Preliminary data analysis constitutes an essential basis for any type of analysis. With this in mind, I have always valued data wrangling as the first and foremost step for analysis and decision-making. I have spent almost 60 percent of the time throughout my whole working life dealing with all the facets of the data exhaustively. It included all stages from the collection to analyzing and producing reports and further supporting the policymaking.

From a naive user's perspective, on the other hand, data comes last as they usually just want a result that would tell them almost exactly what they need to do. That is to help them make an informed decision. For an analyst, the needs and demands of the end-users are paramount as they determine the schema for data procurement efforts and constrain the data evaluation being part of the establishment of the objective function and targets. Therefore, for an analyst, though a clear-cut definition of the problem and a perfect data source would be the best, rarely do these two come together. Thus, especially data procurement can be defined as a dynamic and recursive process, that demands a continuous back and forth until an optimal model is built; therefore a model-driven one.

 

2. Why are you interested in this position/unit?
 First off, I should say that I believe, working in a place that values (Impact, Integrity, Respect, Teamwork, Innovation) challenge, collaboration, initiative-taking, self-development, and that fosters leadership would be a good one for me. I admit that I have not directly worked with any cash data before. But, I reckon for those who have dealt with large amounts of complex datasets with high granularity and frequency, any data framework has a high potential to be acquainted with easily and comfortably. Furthermore, I have more than 20 years of experience handling data about bank loans and financials, trade credits, individual company financials, and macroeconomic statistics like GDP, exchange rates, and interest rates on loans.

Along with the leading, mentoring, advising capacities, and I have considerable expertise and experience in data matters.  Besides, I believe my problem-solving skills, drive for perfection, and nimble-mindedness to improvise and innovate would be useful and my experience in the CB would align with this job's requirements if not perfectly. Let me explain. I have had numerous incidents where I had to deal with crises of different scales. (2011 Company Accounts Crisis). I guess this would make a sufficient example of how I could succeed in the advertised position.

What I can bring to the table .....
Data Strategy ......
Data Management Handbook
Projects Management (YEAGM, RSVFSAP,
Data Mining (Thesis, paper 

Our Core Values,    Impact, Integrity, Respect, Teamwork, Innovation

1. Understand the job: Look over the job description and note keywords that the hiring manager will want to hear that also align with your own skill set. This will reinforce that you're a perfect fit for the role.
2. Research the company: Doing so will provide a clearer understanding of various aspects of the company, its culture, and its long-term goals and strategies. Most company websites also include a mission statement and bios of company leaders that may inspire you. You can find keywords on the website as well that you can incorporate into your answers.
3. Explore their media coverage: Search beyond the company website and learn how the company and its leaders are viewed by the media and the public. Research media coverage, press releases, and social media presence on various platforms.
4. Reach out to your network: If you’ve been in a specific industry for a while, there’s a good chance that your network overlaps or has connections to the company where you’re interviewing. There are multiple social media platforms that will show those connections; create a list of people you can reach out to in order to get more information.
5. Outline your career path: Consider where you see yourself in a year, three years, and five years in your career. What are the roles you need in your career trajectory to achieve those goals?
6. Find alignment: After looking through all your research of the company and the people who work there, what aspects align with your career timeline? What keywords from their website and media coverage can you highlight to connect yourself to this company?
7. Find specific examples of reasons to work with them. This could include the company’s reputation, admiration for their products or services, wanting to work with their company values and culture, or being inspired by the company’s leaders.
 

3. What do you know about us?
The World Bank Group consists of five organizations:

The International Bank for Reconstruction and Development
The International Bank for Reconstruction and Development (IBRD) lends to governments of middle-income and creditworthy low-income countries.

The International Development Association
The International Development Association (IDA) provides interest-free loans — called credits — and grants to governments of the poorest countries.
Together, IBRD and IDA make up the World Bank.
 

The International Finance Corporation
The International Finance Corporation (IFC) is the largest global development institution focused exclusively on the private sector. We help developing countries achieve sustainable growth by financing investment, mobilizing capital in international financial markets, and providing advisory services to businesses and governments.
 

The Multilateral Investment Guarantee Agency
The Multilateral Investment Guarantee Agency (MIGA) was created in 1988 to promote foreign direct investment into developing countries to support economic growth, reduce poverty, and improve people’s lives. MIGA fulfills this mandate by offering political risk insurance (guarantees) to investors and lenders.
 

The International Centre for Settlement of Investment Disputes
The International Centre for Settlement of Investment Disputes (ICSID) provides international facilities for conciliation and arbitration of investment disputes.

Projects
The World Bank provides low-interest loans, zero to low-interest credits, and grants to developing countries. These support a wide array of investments in such areas as education, health, public administration, infrastructure, financial and private sector development, agriculture, and environmental and natural resource management. Some of our projects are cofinanced with governments, other multilateral institutions, commercial banks, export credit agencies, and private sector investors.

Products and Services
The World Bank provides a suite of financial products and technical advice and analysis to address development challenges, helping countries find solutions to achieve sustainable and inclusive development.

1. Advice and Analytics
The World Bank undertakes analytical and advisory activities to inform country, regional and global development agenda in line with its commitment to the twin goals of eliminating extreme poverty and boosting shared prosperity in a sustainable manner.

2. Financing
We finance government programs to support achievement of country development objectives, and support policy and institutional reforms of national and subnational governments by providing budget financing and global expertise. We also finance public projects to build physical and social infrastructure, and develop institutional capacity.

 

4. Why do you want to leave your current position?
For a better job and for a better place in a more reputable institution. What more could I ask for?

 

 

 

 

 

 

5. This job, has as a key component, X. Give us an example of a time when you have had to…
(a component or function of the job as detailed in the announcement).
 

 

 

 

 

 

6. In this position, you will have to… (key challenge of the job as detailed in the job announcement). Tell us about a time when you have had to. (key challenge).
 

 

 

 

 

 

7. What would you do if you found you were unable to. (stress factor you have been able to identify from the announcement)?

 

 

 

 

 

 

8. Tell us about a project when things did not go as planned.
 Another thrilling example of a once-in-a-lifetime challenge happened about 11 years ago. I was at the banks for 13 years and was just a senior specialist and did not have a formal and official managerial title. My management experience was limited to leading roles in project and task groups in the division at the time. Honestly speaking, I was happy with the geek role since I have always thought I wasn't too much of a people person when it comes to managing. Anyway, important things happened that year. I was working as a part of a team with very experienced members, especially the middle and upper management. Those who once designed the first generation were all transferred to other posts at the bank. Unfortunately, the only person with all the technical details of the business was me. The Company Account Statistics Report was meant to be published exactly on the 15th of November, as it was made part of the official statistics calendar that very same year. Before then the publication date was flexible and usually two months after the new one. Another problem was that we couldn't find the storage media (CDs) with which we used to collect the data,  as the person responsible for the data collection was transferred to our post in London on short notice. All these, we have encountered when we only had about two months left to the publication deadline. After a thorough search when we finally found the CDs we had only 50 days left for production. So I made a decision to take the initiative and the responsibility for the publication on the advertised date. I made a broad and simple plan. I would process all the data myself by using VBA codes instead of letting my colleagues do it. Otherwise, they would have to use the VB application and process each form individually which would be time-consuming. Processing some 15000 individual forms in batch would seriously increase the speed and lower the labor time as well as lower the errors. So I wrote some 2000 lines of code in a week and processed the whole data myself. The only thing left to my teammates was to upload the data in the individual forms into the database. Since I did not want to lose time learning the specifics and break the integrity of the VB application, I found the solution to batch filling in the forms with error-free data again with the VBA codes. Then I let my colleagues batch process and upload these forms into the database. We ended up with some 13000 individual forms that could be used for the production of Company Accounts Statistics for that year. We had about three weeks left, and with some overtime spent, we could manage to finish the whole study two days before the deadline. We were all content since the CBRT did not have to lose its credibility by not publishing on a strict deadline. I was very happy too since I  succeeded to keep my promise to deliver on time, and for solving an obvious crisis. By taking the initiative, I ended up proving that I could operate the whole system very efficiently through meticulous planning.
I learned an important lesson from all these incidents. We had to carefully plan everything, especially the human resources. Later on, as we still did not have enough expertise in such a short time, I decided to do an HRAnalytics study I devised to determine the shortage of workforce, and I could manage to persuade the upper management and secure five posts to be filled with recruits to train for our work.

 

 

 

 

 

 

9. Give us an example of a time when you had to work under pressure and tight deadlines. How did you handle it?
 

 

 

 

 

10. Describe a time when you had to face a conflict on a team and how you handled it.
 

 

 

 

 

11. Tell us about a difficult decision related to work that you had to make.
 

 

 

 

 

12. Give us an example of a time when you motivated others.
 Motivation isn’t a one-size-fits-all solution, so I like to really get to know my team on an individual level.  I feel like this gives me a good feel for what works for each person.
I believe non fınancıal rewards are usually more effectıve than the fınancıal ones. Still, depending on an employee's character they may also substitute each other. Therefore, I would try to learn what would motivate them by asking them. Involving, trusting, inspiring, appreciating what they do, rewarding, challenging, and celebrating are ways to motivate the employees.
Once, I was leading a small task force with a lot of work to be handled in a very short period ofo time. Everyone was very stressed. I thought I could motivate the people by involving the members in the planning efforts. We planned together the work calendar with targets, resources, etc. This careful and naive behavior encouraged them to play by the action plan and fortunately, we could finish our duties by their deadlines.
 

 

 

 

 

13. Would you say you are more of an individual or a team player?

14. No one is perfect. Where do you think you might still need to improve? (Think about one skill that can be improved through learning and that you have worked on/are working on.)

I believe my greatest weakness would be my perfectionism when it comes to work. Regarding statistics production, perfecting the end product is not always achievable, since the input or raw data usually includes defects and errors. Endeavoring to serve the best outcome does not guarantee these results. Therefore, perfectionism makes you feel stressed at times. But now I can say through the years I have learned that given the data is not totally error-free or flawless, the optimal solution, not the perfect one is the best solution. I should again say, however, we should always look for continuous improvement in all types of processes including the output whether a set of statistics or a report, and internal processes to handle the input. For example, automation in data handling compared to a manual or a visual one, lowers the processing time, decreases the errors, and saves precious labor time that can be channeled to personal improvement and training. Therefore, it is one among many improvement efforts on the way to a perfect outcome.

15. What would your current manager say about your performance?
 

 

 

 

 

 

16. What would your colleagues say about you?
 

 

 

 

 

17. What has been the most frustrating part of your current role?
 

 

 

 

 

 

18. What would you consider the most significant accomplishment in your career so far?
 

 

 

 

 

19. What do you think you can bring to this department/unit? (How can you add value?)

 1. Professional experience in data analysis, as well as in the collection, compilation, and dissemination of statistical data: Through the years I have worked at the Central Bank (CBRT), my job description was not limited to data collection, compilation, dissemination, and analysis. During my 19 years in the Statistics Department, I have made significant contributions in various fields, from the design phase to the realization of many projects at diverse levels. For example, while working on the old system used in the production of the Company Accounts, one of the most important reports prepared by the Real Sector Data Division, I contributed to the design phase of the second-generation platform. After a while, all stages of the third-generation platform "Integrated Company, and Real Sector Analysis Platform" except coding, were prepared and implemented with my initiatives and efforts. I have also made significant contributions at every stage of many other principal studies and projects. 

2. Experience in applying and/or developing quantitative research methods in compliance with standard statistical principles. In principle, a researcher should consider every viable approach in carrying out his/her work, both quantitative and otherwise. Hence, in CBRT’s Statistics and Structural Economic Research units, quantitative research methods have been the dominant design and operational factors determining the framework in the majority of the tasks I have carried out. Cross-sectional, longitudinal, and panel data models have been decisive in the empirical studies and reports I have conducted in the statistics unit. Correlational, causal-comparative, and experimental research methods have set the framework for conceptual, theoretical, and empirical studies in the structural research unit and my academic studies in general. Additionally, Data Mining and Machine Learning techniques have formed the analytical framework I have used in some of my empirical studies since 2002. Recently, as an extension of Data Mining and Machine Learning methods, I started working on Deep Learning in the Google-Colab environment. 

3. Experience in using statistical software packages (e.g. STATA, R) as required: Research implores the same flexibility in choosing research tools just as in selecting the research method to analyze a subject. For me, the same principle applies where the content of the relevant research topic is the prime determinant of the software to be used. Therefore, though I am not an advanced expert in any specific software, I have had training in a range from introductory to advanced levels in most. I also had extensive experience in most common statistical, database, analysis, and reporting applications for a given field of research. While using MS Excel, VBA, and SAS software in data collection and processing, I employ Eviews, Matlab, Stata, and WEKA for analysis purposes. For Data Mining and Machine Learning analyses, I use WEKA and purpose-built Java codes, and for network research, I employ NodeXL. I also started learning Python, R, and JavaScript but they are still at an intermediate level. 

4. Experience in the management of international statistical databases and the production of statistical data at the international level: Having worked as the representative of CBRT before ECCBSO for three years, I made the necessary theoretical and conceptual preparations for the harmonization with the BACH database. We could not integrate the data with any of the databases during that period due to structural inconsistencies at that time. However, It is now possible to contribute to the current databases, and shortly, it will be possible to integrate with the BACH database, mostly based on the preliminary studies I did. The ECCSBSO databases for which Turkey's data are available today are the Trade Credit and Financing Cost Data Bases, which are under the responsibility of the ERICA and FSA Working groups. One can obtain information about those databases at https://www.eccbso.org/wba/databases. 

5. Experience in developing methodological statistical standards: My work descriptions had always involved using and manipulating/fine-tuning (if not developing) statistical standards at both usage and design levels, including all stages. Design efforts, like platform development, user interfaces, data forms, online manuals, and WIKI pages, all designate some sort of statistical standard for data to collect and use. Hence, though I cannot specifically identify a particular standard, I developed or helped develop; I can comfortably say that examples include some of them in a couple of my works. I can tell “Integrated Company and Real Sector Analysis Platform”, “Integrated Structural Economic Research Department Database, and Data Warehouse Research Platform”, to name a few. For details, please refer to the resume or have me refine the matter if needs be. 

6. Experience in project management, as well as evidence-based policy formulation: As described on my resume, most of the work I carried out in the Statistics Department, involved project management by definition. From the very early days on, I worked on all stages of several projects and managed the most. All, as they were meant to assist the policymakers in their decision-making, involved design criteria for policy formulation from the very start. “Integrated Company and Real Sector Analysis Platform” and “Integrated Structural Economic Research Department Database, and Data Warehouse Research Platform” were designed for helping them analyze the real sector, “Bank Financial Stability, Strength and Rating Estimation, and Evaluation Project” for the analysis of bank and real sector relationship, etc. Other projects listed on the CV can be further examples of those projects I worked on at all stages through the years. 

7. Experience in education and training of colleagues as part of personal development strategy: As a considerably recent development in my career, I have been selected as an in-house tutor for Data Analytics and Visualisation, Data Mining, and Machine Learning subjects. Though I haven't started teaching yet, in a couple of months this will probably be a part of my curriculum/agenda.

INTERVIEWING SUCCESSFULLY (BY WBG)

Introduction

 Successful interviewing requires the ability to clearly demonstrate you have the qualifications and qualities the interviewer and the organization want in the ideal candidate, as well as to determine if the candidate is a good fit for the organization and how you can add value. Preparation and practice is a key component to successful interviewing.

Contacted for an Interview?

BEFORE THE INTERVIEW:

> Respond promptly to show interest. Express thanks for the opportunity and get specifics on logistics:
address, special entry requirements, and the names of those with whom you will be interviewing. You will need these names so that you can research these individuals prior to your meeting.
> Research the interviewers, the organization, and the sector/department/ division. In addition to reading, talk with others who might have knowledge. Based on what you learned, prepare questions you
can ask about the organization, department, and/or position. Show, through these questions, that you are
knowledgable and that you have done your research.
> Review the position announcement and the value you will bring. Make a list of what is required and
desired; then, make a comparable list of what you can bring to the organization to meet these requirements. Think about experience, strengths, education, and feedback others have given you about your work and about you as a person.
> Consider relevant accomplishments or projects you have undertaken. Review your résumé to remind you. Using STAR (Situation, Task, Actions, Results), prepare “mini-stories” that describe your
accomplishments and demonstrate your ability to meet the position requirements.

> Two critical things that every interviewer wants and needs to know are why you want this particular job and what value you will bring. Think carefully about this. A desire to escape your current position or to get a promotion is not an appropriate response.
> Prepare and practice a focused, two-minute overview of your career (experiences, skills, technical
qualifications, interests) as it relates to this position. Interviews often begin with a variation of the “Tell me about yourself” question.
> Develop and get completely comfortable with interview questions and formats. Practice responses
to any “sticky” interview questions that you are worried about being asked. Prepare for “typical”
interview questions as well as behavioral questions where you will provide specific examples of things you have done that relate to the position. Consulting firms may use a case interview format; prepare accordingly.

Plan ahead:

> Determine your interview outfit in advance rather
than the night before. Professional attire (e.g. suit) is
expected for an interview.
> Know the location and plan to arrive 15 minutes
before the interview time. Factor in traffic or
possibly getting lost.
> Pack your bag: Prepare the materials you are taking
with you (i.e. copies of your résumé, portfolio, writing
samples or publications).

DURING THE INTERVIEW:

> Be confident. Think about this interview as an information exchange. You are trying to determine
what needs exist that you can meet and the organization is trying to determine if you can do the
job, want to do the job, and will be pleasant to work with as a colleague. As Amy Cuddy, social
psychologist and researcher from Harvard, tells us (Your Body Language Shapes Who You Are
http://www.ted.com — highly recommended): Breathe deeply, take up space, and stand tall. Show
your confidence and you will feel confident.
> Do what makes you calm. Breathe deeply, read a motivational quote while waiting, visualize a positive experience about to happen and the after-interview feeling of success – whatever it takes to help you relax. Silence your cell phone.
> On arrival, give a firm handshake to each person you meet and smile. A smile is the first thing to go when one is nervous and yet, it’s a critical factor in developing rapport.

AFTER THE INTERVIEW:

> Within 24-48 hours, send an individualized thank you letter/e-mail to each person who was in the interview with you. Customize each in case the letters land side-by-side or are compared. Consider the role each person plays and tailor your comments to this. Include a few ideas discussed as well as anything you forgot to mention. Stress why you believe you are uniquely qualified for this position.

Behavioral Interviews

Behavioral interviewing

> is based on the premise that past performance predicts future performance.
> ask for examples in your past that demonstrate key competencies required for the position for
which you are interviewing.
> can be entirely behavioral or a combination with other interview styles.

As a candidate, you can use behavioral interviewing techniques to your advantage if faced with a
traditional interview format. By citing specific examples of past performance, you build credibility
and demonstrate that you can meet the job requirements.

To prepare for a behavioral interview,

> review the job posting to identify the key competencies required.
> determine the specific non-technical requirements to be met by the person taking this position.
> make a list of specific examples of things you have accomplished in your experience that
demonstrate the competencies required and needs to be met.
> identify 6-8 of these examples where you demonstrated key requirements and skills for the
position.
> prepare a brief mini- story for all these examples (again using the STAR model as mentioned on page 2).

The behavioral interviewer can, and often will, drill down for more information by using follow-up questions. Practice telling these stories so that you can tell them clearly and concisely, without rambling. Examples of behavioral questions (with competencies they are designed to assess):

1. Tell us about a time when you had to deal with a difficult client. What happened and were you
successful? (conflict management, interpersonal strengths)
2. Could you give us an example of a time when you had to handle conflicting priorities? (multitasking, organizational and planning, and communication skills)
3. Tell us about a time when you had to manage a team of people who did not want to work together. (leadership and teambuilding skills)
4. Describe a decision you had to implement that was unpopular and how you did it. (engaging stakeholders and developing collaboration)
5. Give us an example of a time when you had to develop an innovative solution to streamline operations or improve product or service delivery(innovation)

The Interviews

Phone interviews are used as an initial screening mechanism to determine which candidates should be
invited for in-person interviews. They are usually brief: 20-30 minutes.

If you are contacted and unprepared, ask if you can schedule a future convenient time and provide alternate dates/times rather than move into the interview unprepared.

Prepare as you would for an in-person interview, including doing some research about the positions, the business context and the specific requirements and prepare your examples and your mini-stories (see page 6).

If this is an initial screening interview by Human Resources, the interviewer may be more interested in
covering details of your résumé. In this case, be prepared to discuss job transitions as to why you moved from one position to the next. Respond factually, positively, and with confidence. 

Ensure you are away from all noise and distractions. Consider using a landline if you are at all concerned about cellphone reception.

Smile! A smile can be heard over the phone as confidence and warmth. When you smile and talk, your tone will be upbeat andpositive.

Many prefer to stand up when talking or sit up straight vs. being relaxed in a chair. The intent is to send energy and reflect confidence. It is suggested that you also consider dressing professionally so that you feel as if you are in an actual interview.

> When the conversation is ending, thank the interviewer and ask if itwould be possible to meet in person.
> Take notes on what you learned immediately after the conversation. Send a follow-up thank you e-mail within 24-48 hours to the interviewer, restating your interest in the position and summarizing what you uniquely will bring to the position.

Panel Interviews

A panel interview is a personal interview held with three or more people. In addition to all the basic recommendations mentioned on previous pages for interviews in general, keep in mind the following as tips for this specific situation: 

If possible, get the names of the panel members in advance. This information will help you to feel more comfortable about meeting with them. Also, this enables you to send personalized thank-you notes to each panel member after theinterview. 

Bring extra copies of your résumé to share in the event that someone on the panel has not yet seen it or joins the panel at the last minute. 

Make a strong first impression. As panel members are introduced to you, smile, make eye contact, and greet them using their names. When possible, shake each panel member’s hand. Ask permission if you want to take notes but realize that it is distracting for a panel to watch a candidate write during an interview so use any notetaking sparingly. It is inadvisable to write down questions you are asked. 

Share your attention with everyone on the panel. When answering questions, make initial eye contact with the person asking the question and then try to briefly look at each of the other panel members as you are talking and make a connection with the entire panel. As you end your answer, look at the person who asked the question to see if you need to provide more information. 

Continue to engage all panel members. Use a panel member’s name, when answering, and consider the panelist’s organizational role as you respond. Also, show the relationships between an answer you are giving and a prior panelist’s question, when appropriate, to keep panel members engaged. For example, “This actually ties into what Paul asked earlier about...” 

Ask for clarification if you don’t understand a question and give yourself time to pause and reflect, if you need it. It’s better to think through an answer than to answer incorrectly or ramble.

Prepare for group dynamics. In a panel interview, there are different personalities and interviewing styles. You may be able to tell if someone is in doubt or not as open to your responses. Try to give a clear, confident response to this person. Try to establish rapport with as many as possible but also realize that you may not be able to satisfy all interviewers with your responses all the time.

Prepare for interruptions. It is not uncommon to have someone enter late or have to leave early to catch another meeting. Stay calm and carry on.

Prepare for two questions asked simultaneously. In a panel interview, it is not uncommon for two questions to be asked at once, based on the fact that there are multiple people trying to get information. This can feel stressful. If asked more than one question at a time, answer one and then go back and ask for the other question to berepeated.

You may have to repeat a response. In a group interview, not everyone hears everything the same way. Do not be surprised or feel impatient if you are asked the same question twice or asked for further clarification on something you have already explained.

Questions from you are expected, so have questions ready to ask about the work or the group. These questions should reflect your research. If you can address these questions to different panel members, you will continue to keep panel members involved and interested in the interview (and in you).

Thank all panel participants. At the end of the interview, make eye contact with all and try to shake hands with each person. Follow the interview by sending an individualized thank-you letter/e-mail to each panel member. Customize each letter in case the letters land side-by-side or are compared. Consider the role each person plays and tailor your comments to this. Include a few ideas discussed as well as anything you forgot to mention. Stress why you believe you are uniquely qualified for this position.

Practice Interview Questions

There is no one set of questions, as you know, for every interview. However, by reviewing and developing responses to the questions below, you will gain confidence and focus in talking about
yourself which is a major goal of interview preparation.

Possible interview questions

1. Tell me about yourself (1-2 minute overview focusing on relevance to the position).
2. Why are you interested in this position/unit?
3. What do you know about us?
4. Why do you want to leave your current position?
5. This job, has as a key component, X. Give us an example of a time when you have had to…
(a component or function of the job as detailed in the announcement).
6. In this position, you will have to… (key challenge of the job as detailed in thejob announcement). Tell us about a time when you have had to. (key challenge).
7. What would you do if you found you were unable to. (stress factor you have been able to identify from the announcement)?

8. Tell us about a project when things did not go as planned.
9. Give us an example of a time when you had to work under pressure and tightdeadlines. How did you handle it?
10. Describe a time when you had to face a conflict on a team and how you handled it.
11. Tell us about a difficult decision related to work that you had tomake.
12. Give us an example of a time when you motivated others.
13. Would you say you are more of an individual or a team player?

14. No one is perfect. Where do you think you might still need to improve? (Think about one skill that can be improved through learning and that you have worked on/are working on.)
15. What would your current manager say about your performance?
16. What would your colleagues say about you?
17. What has been the most frustrating part of your current role?
18. What would you consider the most significant accomplishment in your career so far?
19. What do you think you can bring to this department/unit? (How can you addvalue?)

Possible questions to ask at the interview

Review the position’s context and mission objectives. You can inquire about growth priorities, how innovation is encouraged, how client satisfaction is measured - in other words, questions developed from your research - as well as questions regarding the position.

1. What are the greatest challenges facing this position?
2. What would be the first issue that you would want me to address? or What would you like me to accomplish in the first 60-90 days?
3. How would you describe the ideal candidate for this position?
4. What are the key performance indicators for this role?
5. What are the reporting relationships in this position?

Post-interview Thank You Letter/ E-mail

> Send a thank you letter within 24-48 hours.
> If you send an e-mail to each member of an interview panel, customize and individualize each one as your e-mail may be read and compared by all members of the panel. An option is to send one e-mail to the panel chair, thanking the chair and the panel members.
> Focus on being concise and to-the-point. This is a short letter.

Dear X:

First paragraph (and possibly a second): Thank the interviewer(s) for taking the time to meet with you and restate your interest in the position. Try to recall something from the interview or comments/questions that were of interest or helpful to you. Highlight specific skills and experiences that will enable you to bring value to the organization. Here is also the place to mention anything you forgot to discuss in the interview or to elaborate on items discussed.

Second – third paragraph: Restate your appreciation for being considered and your belief in being able to make a strong contribution. Indicate that you are looking forward to hearing from him/her soon. 

Sincerely (Best regards, etc.),

Your name, e-mail, and phone number

Useful phrases:

> I enjoyed meeting with you to discuss...
> I appreciate the importance of...
> From our discussion, I...
> I was impressed by...
> I am excited about this chance to...
> I believe I can... I feel confident that I can...
> After reflecting on our meeting...
> I also wanted to mention that...

CREATING A STRONG RÉSUMÉ (BY WBG)

 This excerpt is exactly copied from WBG for self-educative purposes

Introduction

The résumé is a career marketing document that takes time and attention to create. The main goal of the résumé is to get invited for a personal interview. This guide is a self-directed resource to get you started, as well as to complement what you learn in one of our workshops. It can also help you prepare for a meeting with a career advisor so you can have a more productive session. It contains a number of resources to help you create and revise your résumé in order to align it with the targeted position and highlights relevant skills, accomplishments, and qualifications.

How to Write Accomplishment Statements

When viewing your CV/résumé, employers look for accomplishments rather than a description of your responsibilities. Accomplishment statements appear at the top paragraph on your résumé and they demonstrate your proven ability to summarize what you have achieved in former positions. 

One suggested format is to begin your description of each position with an overview of the job, i.e., what you helped do, figure out, or answer in your role; who you served; your budget; the region you were responsible for; the number and kind of staff you managed or were a part of; product or service lines, etc. 

After this brief overview, what employers want to see is what you achieved on the job – and this is where accomplishment statements have value. Accomplishments refer to actions you have taken that show results or impact as opposed to tasks or effort. In other words, employers want you to differentiate
yourself by showing why your actions have mattered and what difference you were able to make. The following examples show the impact of using accomplishment-driven statements.

> Relocated office over one weekend, planning and coordinating the logistics. (good)  

> Relocated corporate office of 130 staff members over one weekend, planning and coordinating
the logistics to result in zero disruption to operational schedules and productivity. (better)

> Managed international development conference, coordinating all aspects from planning through
implementation. (good) 

> Managed a 2-day sustainability conference for 175 professionals from 6 regional offices. Planned and coordinated event logistics. Communicated with all participants and presenters. Result: ratings of “outstanding” by 95% of participants regarding event logistics, communication, and materials. (better)

> Developed new presentation methods for annual meetings to make presentations more interesting to participants. (good)

> Developed innovative presentation methods for annual meetings using visual effects technology. Increased viewer interest through video imagery and creative visual effects, resulting in specific feedback on improved presentation methods by more than 85% of participants. (better)

To write accomplishment statements, follow this two-step process:

• Before you start writing your résumé, think about each position you have held and create a list of accomplishments that are related to the kind of work you are pursuing. Always use results, measurable impact and metrics when describing accomplishments.

• To help you to develop this list, ask yourself if you:

> increased efficiency or effectiveness
> accomplished more with fewer resources
> initiated or implemented something that went
above and beyond what was in your job
description
> designed and implemented a technique, strategy,
innovation, or improvement
> solved a challenging problem
> did something that improved client relations or
resulted in greater stakeholder engagement
> improved a process
> saved money, time, or other resources
> implemented a policy, procedure, system, or best
practice
> were recognized informally by clients
> Authored or co-authored a published article or
book
> improved profitability
> enhanced productivity
> contributed something that was above and
beyond

Sometimes, looking at past performance reviews will
help to jog your memory of accomplishments.
Also, consider feedback you have received from
managers, colleagues and clients.

> Use the STAR model to write your accomplishment statement. STAR stands for:
S = Situation solved or opportunity created
T = Tasks that needed to be done
A = Actions you took
R = Results achieved

For each accomplishment statement, briefly tell:

> What was the SITUATION: What was the problem, need, or issue?
> What TASKS needed to be done: Describe the challenge and expectations.
> What ACTION did you take: What was your role? What did you do? What challenges did you
overcome? What steps did you take? What
techniques did you use?
> What were the RESULTS? What was the impact of the actions you took? What were the benefits:
Quantify the results whenever you can, using metrics such as numbers, $, %. When you cannot
quantify, show the impact of your action (i.e., saving time, increasing efficiency, strengthening communication, streamlining operations, building relationships with external stakeholders, expanding product lines).

Key success concepts in writing STARs are:

- Start each with an action verb. (Use past tense for
completed accomplishments).
- Be specific.
- Quantify, using metrics whenever possible (and
when it is helpful).
- Show concrete results or the impact of your
actions.

How to Identify and Use Keywords

When you align your CV/résumé content with an employer’s requirements for a position or TOR, it makes it easier for an employer to shortlist you. Alignment is not about copying the job posting and placing the exact contents into your CV/résumé. (Yes, we have seen it happen!). It’s about making a list of keywords and key phrases that are common to job postings for your field that show what employers are typically looking for and making sure that, when true, these are represented in your CV/résumé.

Keywords and key phrases are what recruiters and Applicant Tracking Systems (software used by organizations to do an initial screening of incoming résumés) search for when reviewing your CV/résumé. They are the nouns and phrases that describe the skills and qualifications employers typically search for as they identify qualified candidates for your field. They can include skills, experience, knowledge, areas of expertise, certifications or special training, education, and personal qualities that are core to the kind of position you are seeking.

A good exercise before updating your résumé is to identify the keywords and key phrases that show up most frequently for your field. Sources for identifying keywords and key phrases for your field include:

> job postings: Review 5-7 job postings (e.g. on Compass) and make a list of keywords and key phrases that come up most often in job postings for your role.
> employer websites and mission statements
> social media profiles of others in your field
> colleagues
> professional associations

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

How to Write a Career Profile (also known as a Career Summary or Executive Summary)

Placed at the top of your résumé underneath your contact information, this is prime real estate in a CV/résumé. Its purpose is to show an overview of your core qualifications and the value you bring to an employer. It can be a paragraph overview or it can be a paragraph followed by a bullet listing of core qualifications, special skills, certifications, or areas of expertise.

The summary can include:

> How much and kinds of relevant experience you have
> Key qualifications and skills (These are the keywords
and key phrases that are most important to your
field and to the position)
> Specialty area of expertise and experience
> Differentiators (what makes you unique when
compared to other candidates)

One model to use for developing your Career Profile is that each sentence answers a different question for the reader.

> 1st sentence: Define yourself in terms of your career. This can be by position, title, field, or a specialized functional area or area of expertise within your field.
> 2nd sentence: Identify the strengths you are promoting about yourself.
> 3rd sentence: Provide additional depth or breadth. Can also define the kinds of activities you would like to do that are required for the positions you are seeking.
> 4th sentence: Define unique traits as they relate to the position and organization. Here’s a chance to showcase soft skills (personal qualities or strengths that support the job). Think about what others say about you, what you are known for, what people come to you for when asking for your help, etc.

 Phrases that may be helpful to you as you develop your Career Profile:

> Over X years of experience in..., Extensive experience in…, Expertise in…
> Proven strengths in…, Major strengths include…, Skilled in…, Core strengths include…
> Proven ability to…, Proven success in…, Proven record of …, Excellent track record of…, Demonstrated X capabilities with…
> Strong background in…, Background includes…
> Recognized for…, Recognized as a…, Consistently
acknowledged as a…
> Country experience includes…
> Regional experience includes…
> Sectors include…
> Languages...

Examples:

#1: CAREER SUMMARY
Skilled learning specialist, with over 10 years of experience in public, private, and nonprofit organizations. Proven strengths in needs assessment, program design and delivery, and program evaluation. Strong background in working with all levels of management and staff, consistently improving organizational performance through classroom and virtual programs. Recognized for facilitating active learning and incorporating innovative learning strategies to motivate others to achieve their personal best.

#2: PROFESSIONAL SUMMARY
Extensive experience in environmental policy and strategy development for global development organizations, with expertise in carbon finance. Proven background in carbon fund operations in the South Asia, East Asia and Pacific regions. Field experience includes land use, land-use change, and forestry. Recognized for developing highly effective partnerships with stakeholders to establish and implement carbon fund programs.

> REDD + Readiness
> Capacity building
> BioCarbon Fund (BioCF)
> Portfolio management
> Forest Carbon Partnership Facility (FCPF)
> Carbon finance training
> ERPA
> Development finance

#3: PROFILE
Over 10 years of experience leading administrative support staff to provide comprehensive program support services. Proven organizational and time management skills, prioritizing and delegating work to ensure that tight deadlines are met. Recognized for applying strong research and analytical skills to manage and track data, produce reports, and strategically respond to client issues. Committed to demonstrating sensitivity in handling confidential information.

#4 SKILLS
Microsoft Office (Advanced Proficiency) | SAP | TRS | LARS | LMS | Adobe Acrobat | SharePoint

Action Verbs

Powerful action verbs help your achievements to come out clearly, emphasize the contributions you have made in former positions and increase your chances to be found and shortlisted if an employer uses software support. Here is a list of ACTION VERBS you can use.

accelerated, accepted, accomplished, achieved, acquired, adapted, added, addressed, adjusted, administered, advanced, advised, allocated, analyzed, announced, answered, anticipated, applied, appointed, appraised, approved, arranged, assessed, assigned, assisted, assumed, attained, audited, augmented, authorized, awarded, 

balanced, bargained, bolstered, boosted, bought, briefed, brought, budgeted, built, 

cataloged, caused, certified, chaired, changed, clarified, classified, closed, coached, collaborated, collected, combined, communicated, compared, compiled, completed, composed, computed
conceived, conceptualized, concluded, conducted, confirmed, constructed, consulted, contacted, contracted, controlled, converted, conveyed, convinced, cooperated, coordinated, corrected, counseled, created, critiqued, cut, 

decided, decreased, defined, delegated, delivered, demonstrated, described, designated, designed, detected, determined, developed, devised, diagnosed, directed, discovered, discussed, disseminated, distributed, documented, earned, 

edited, educated, eliminated, employed, enabled, encouraged, endorsed, engineered, enhanced, enlarged, enlisted, enriched, ensured, equipped, established, estimated, evaluated, examined, exceeded, executed, exhibited, expanded, expedited, experienced, experimented, explained, explored, expressed, 

facilitated, filed, filmed, financed, finished, forecast, formulated, fostered, found, founded, fulfilled, furthered, 

gathered, generated, guaranteed, guided, 

handled, helped, hired, 

identified, illustrated, implemented, improved, improvised, incorporated, increased, indexed, indicated, influenced, informed, initiated, insisted, inspected, inspired, installed, instituted, instructed, insured, integrated, interacted, interpreted, interviewed, introduced, invented, investigated, involved, issued

joined, justified, 

kept, 

launched, learned, leased, led, leveraged, licensed, linked, located, logged, 

maintained, managed, mandated, matched, measured, mediated, mentioned, mentored, met, modified, monitored, motivated, moved, multiplied, 

named, negotiated, 

observed, obtained, opened, operated, ordered, organized, outlined, oversaw, 

paid, participated, partnered, perceived, performed, persuaded, pioneered, placed, planned, prepared, presented, prevented, priced, prioritized, processed, procured, produced, programmed, projected, promoted, prompted, proposed, provided, published, purchased, pursued, 

qualified, quantified, 

ranked, rated, received, recognized, recommended, reconciled, recovered, recruited, reduced, referred, refined, regulated, related, released, renegotiated, reorganized, replaced, replied, reported, represented, requested, researched, resolved, responded, reevaluated, retained, revamped, reversed, reviewed, revised, 

salvaged, saved, scheduled, screened, secured, selected, serviced, set, settled, shaped, simplified, solved, sorted, sought, specified, spoke, staffed, stimulated, strategized, streamlined, strengthened, structured, studied, submitted, substituted, succeeded, suggested, summarized, supervised, supported, surveyed, synthesized, 

tackled, targeted, taught, tested, trained, translated, transported, traveled, treated, troubleshot, turned, 

uncovered, unified, updated, upgraded, used, 

validated, visited, 

worked, wrote

Tips for Preparing a Statement of Interest (SOI)

> The Statement of Interest (SOI) is similar to a cover letter but it can be longer (2 pages maximum) and does not use business format.
> Read the announcement carefully and highlight or underline all of the items in both the Duties and
Accountabilities and Selection Criteria sections that match your experiences, skills, and education.
> Prepare statements describing your qualifications for each of the items you have highlighted or underlined. What examples can you provide? You can showcase a few specific details from your résumé. Select and describe relevant experiences, showing their significance to the position. Make the connection for the reader in an interesting way.
> The SOI does not need to be chronological. Lead with the most relevant information or an impactful
statement or story.
> Avoid using general terms such as several, numerous, various, or familiar with.
> Limit self-reported behaviors/skills, such as “excellent communicator” or “good people skills.” Instead, describe an experience that validates the skills and/or behaviors.
> Keep the information in your application relevant to the vacancy announcement. Information not related to the vacancy can cause the reader to wonder if you read the announcement.
> It is not necessary to describe the issues related to the position. The readers should be aware of them.
> Limit your text. Two pages are sufficient.
> Proofread carefully to eliminate any grammar, punctuation, or spelling errors. Do not rely on spell
check to catch grammar and spelling errors!

Statement of Interest Format

> 1st paragraph:
Begin with interest statement that emphasizes why you are interested in this position and the value you will bring. Ask yourself and address: Why are you interested in this specific position? What draws you to this position? Avoid describing how you will benefit from the position if selected. The reader wants to know your motivations.
> Following paragraphs:
Use a 2-page maximum length: Use your prepared statements describing your qualifications for the Duties and Accountabilities, Selection Criteria, and Competencies of the announcement. Include specific accomplishments or experiences that are of greatest interest and relevance to this position and unit.
> Closing paragraph:
Thank the reader for his/her consideration and review of your attached CV and indicate you look forward to the opportunity to meet to further discuss how you can meet their needs.

CV/Résumé and Statement of Interest Checklist

Layout and Appearance

- Name is at top of page and in bold and larger font.
- Address, phone number, and email (LinkedIn URL optional) are easy to read.
- Résumé is appropriate length (generally 2 pages for experienced professionals).
- There are 1” (1/2” minimum) margins all the way around.
- Font size is clearly legible (usually 11 or 12 pt; 10 is minimum, depending on font style).
- Formatting is consistent throughout (font size, bullet sizes, heading sizes).
- Verb tenses are in the present for current jobs, unless an accomplishment stated has been completed. Verb tenses are in the past for previous jobs.
- Weight and balance are clear: positions at the WBG and those with greatest relevance to the job you are seeking have greater length and description.
- The most important information is on the top half of the résumé.
- Headings (Name and Page Number) are placed on Page 2 and subsequent pages.
- You have not overused bullets.
- In about a 10-second scan of your document, the reader's eye is drawn to your most important points.

Content

- Summary statement at top shows direction, focus, an overview of your strengths, and the
value you bring.
- Relevant jobs and experiences are included that show you are qualified for the position.
- Keywords are used in the summary and throughout the résumé.
- Statements demonstrate accomplishments rather than routine tasks and duties.
- Each statement begins with an action verb. Responsible for is not an action verb!
- Metrics are included, when possible, and/or the impact/results of your actions. A model to use is: Action verb + action taken on your part + results.
- Statements support and demonstrate the summary at the top of the résumé.
- There are no complete sentences. There are no I statements.
- Descriptions are clear, concise, compelling, and confident.
- The résumé is free of spelling, punctuation, and grammatical errors.

Statement of Interest

- It is two pages or less.
- It addresses the key elements in the job announcement.
- It begins with an interest statement that shows why you are interested in the position and the
value you will bring.
- It follows with an unfolding of your background as it relates to the position. It has paragraphs
that describe your relevant experience and qualifications.
- It includes accomplishments that are of greatest interest and relevance to the position.
- It is free of grammar, punctuation, and spelling errors.