Fernando Alonso Mendo, PhD

Experience

• 

  Ministerio de Defensa

  Nov 1994 - Jun 2000

  Finance Administrator

  • Recorded financial transactions on separate ledgers using the TA accounting software package (Liqhabi).• Received supplier invoices and processed BACS payments to strict deadlines.• Drafted financial statements, petty cash management and bank statements reconciliations.• Monitored central funds income and expenditure for Army budget codes (e.g. consumables, equipment and rations) and provided monthly budget reports.

• 

  Brunel University London

  Oct 2002 - Oct 2007

  PhD Researcher / Graduate Teaching Assistant

  • Conducted a longitudinal study of the evolution of Small and Medium-sized Enterprises (SMEs) web sites in the UK, which utilised both quantitative and qualitative research methods. • Employed monitoring and web content analysis techniques to identify and observe changes in features and functionality on a sample of SMEs web sites over time. • Conducted telephone interviews to investigate SMEs web site planning and maintenance practices and obtain an understanding into the reasons behind the decision of the businesses to redesign their web sites. • Used SPSS to perform a series of correlation analyses, using the Pearson correlation coefficient, to determine the degree and direction of relationship between drivers of web site redesign and business variables (e.g. length of experience operating a web site, business size, industry, etc). • Developed excellent written and communication skills by writing several journal papers and presenting my work at research seminars in my department and also at national and international conferences (see list of publications below). • Organised workshops for mathematical concepts (sets, recursion, etc) for Models of Computation & Systems (1st year level, 2003 spring semester).• Tutored students with their dissertations (Java, VB and UML) for the Information Systems Project (3rd year level, 2003 spring semester).• Supervised labs on object-oriented programming and Java for Construction of programs (1st year level, both semesters 2003/2004).• Lead Statistics seminars, organised labs on MS Excel and SPSS for Foundations in Computing (1st year level, 2004 spring semester).• Lead practical workshops for O-O conceptual modelling and UML for IS Analysis & Design (Master level, 2004 autumn semester). Show less

• 

  The Open University

  Oct 2005 - Apr 2010

  • Collated data from various MI systems using SAS, compiled statistics and produced quarterly and annual HR key indicator reports, including staffing (headcounts, promotions and turnover), sickness levels, salary surveys and staff diversity.• Managed five members of the IT & Systems team agreeing clear task objectives and clarifying requirements, delegating work according to individual experience and workload and monitoring progress. • Implemented new MI systems (e.g. SAS Enterprise Guide and Web Report Studio reports) to enhance reporting, data availability, data mining and enquiry answering capability.• Produced ad-hoc reports to meet management requests and needs for HR related (e.g. trends and benchmarking).• Provided specialist advice and recommendations regarding workforce development and planning to VCE, University Secretary and HR Director in the form of formal written reports. Show less

  • HR Analyst

    Feb 2007 - Apr 2010

  • Computing Helpdesk Advisor

    Oct 2005 - Jan 2007
• 

  The Open University

  Jul 2010 - Sept 2012

  • Maintained the OU Data Warehouse, and associated MI reports, using the SAS 9.2 BI toolset (including Data Integration Studio, OLAP Cube Studio, Information Map Studio and Web Report Studio). • Designed and maintained the setup of over 200 SAS user accounts with the relevant groups, permissions and user roles in SAS metadata, using SAS Management Console, and the underlying physical environment on six Linux SAS servers. • Designed and implemented Enterprise Guide workflows to automate the maintenance of all SAS user accounts across six servers and synchronize these accounts with Windows Active Directory groups. • Identified business and organisational information requirements to meet University objectives and designing, building and testing new SAS applications and user procedures to meet them. • Analysed and documented information requirements and assessing their efficiency and effectiveness in meeting overall University objectives. Show less • Managed and co-ordinated the efficient functioning of the OU Spanish Residential Summer School Office in Santiago de Compostela during the summers of 2010, 2011 and 2012.• Managed one Disability Support Co-ordinator and one Assistant School Administrator• Ensured high quality administrative support to the School Director, Module Directors, Learning Advisers, Tutors and students.• Maintained accurate staff and student records and liaised with host site personnel.• Assumed responsibility for petty cash and for conducting the imprest account. Show less

  • SAS Developer

    Apr 2010 - Sept 2012

  • School Administrator

    Jul 2010 - Aug 2012
• 

  BVGroup

  Oct 2012 - Sept 2014

  SAS Analyst / Platform Administrator

  • Designing and maintaining the security model of the SAS Environment using ACTs, permissions, User Groups and Roles to restrict access to sensitive columns, libraries and reports.• Designed and implemented Enterprise Guide workflows to automate the maintenance of over 300 SAS user accounts across production and test environments and synchronisation with Windows Active Directory groups.• Extracting, transforming and loading SAS logs for auditing and security purposes.• Working closely with other teams in IT to maintain, support and enhance the current SAS infrastructure.• Applying relevant hotfixes to the Test and Production servers using the SAS Hot Fix Analysis, Download and Deployment Tool. • Designed and implemented Fact Tables and Dimensions to produce Payments indicators, and associated MI reports, using the SAS 9.3 BI toolset (including Data Integration Studio, OLAP Cube Studio, Information Map Studio and Web Report Studio).• Promoting the use of SAS technologies, investigating new SAS products and disseminating SAS best practice of Business Intelligence design (i.e. cubes, information maps, portal, etc.), job scheduling, security and data modelling. Show less

• 

  Katalyze Data (formerly Amadeus Software)

  Oct 2014 - Sept 2015

  Senior SAS Managed Services Consultant

  • Maintaining the SAS environments of a range of customers to ensure optimal performance and uptime.• Researching and resolving issues raised by customers and managing the delegation and resolution of incidents within customers' SLAs.• Analysing and identifying trends in issue reporting and devising preventative solutions. • Creating, updating and maintaining documentation of best practices, common tasks and issue resolutions for customer environments.

• 

  SAS

  Sept 2015 - now

  • Providing technical support to both internal and external SAS customers on BI and VA product areas and resolving customer issues in general support areas such as SAS programming, platform administration, installations, etc.• Interpreting documentation and explaining error messages to audiences with varied backgrounds, suggesting appropriate SAS procedures and language features for the particular type of analysis/functionality requested.• Collaborating with experts across technical support departments and SAS divisions to troubleshoot, diagnose, and resolve software problems.• Maintaining the Technical Support SAS 9.3 and 9.4 Test servers to aid issue replication. Show less

  • Systems Developer

    Apr 2018 - now

  • Senior Customer Support Consultant

    Sept 2015 - Apr 2018