Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
    Andy Hammett

    Andy Hammett

    MS Excel / MS Access VBA RAD Developer

    Portsmouth, United Kingdom

    Excel and Access VBA RAD Developer with 10+ years Investment Banking Experience. I have worked in Information Technology for over 25 years, 10 years in hardware and the last...Read moreExcel and Access VBA RAD Developer with 10+ years Investment Banking Experience.

    I have worked in Information Technology for over 25 years, 10 years in hardware and the last 17 years in various Support Desk / Development roles, primarily in the Investment Banking Sector.

    I am articulate and well spoken individual with the ability to communicate the most complex of IT issues in the kind of simple and understandable terms, required by clients. I have a vast amount of experience with many and varied operating systems, RDBM’s and office based applications.

    If you are looking for a professional, friendly, articulate, knowledgeable and committed individual, with the ability to think quickly and where necessary learn new products quickly then I am the person to talk to about your project.

    I have a limited command of French which is improving with time, should this become a future requirement.

    Area Covered: Microsoft Excel and Microsoft Access RAD Developer
    Industry: Information Technology
    Employees: 1


    Work Experience
    -----------------

    Summary: I have worked for the last 17 years as a freelance VB & VBA Contractor / Freelancer.

    My core expertise is in developing streamlined MS Excel and MS Access applications.
    Job Title: VBA Solutions Analyst / Developer
    Company: BNP Paribas Fortis
    Description: Primary RAD report development analyst for the IS Central Decalog team, creating ad-hoc reports against middle and front office systems within the FIM / BNPP IP framework. I have developed a personal detailed knowledge of the Decalog Database structure, to compliment my existing knowledge of the Latent Zero Database structure and am able to extract data from multiple systems to produce finalised reports.

    In addition I have been responsible for multiple business developed Microsoft Access databases, and have assisted the business on a number of occasions with additional development of databases, queries and adhoc data extracts.

    I have also further developed my skill set in this role to include the MS Outlook object model and Outlook macro VBA having worked on a number of Outlook related automation projects for the OTC Pricing team.
    From:01/Sep/2008 To:07/Oct/2011

    Job Title: Support Analyst / VBA Support Analyst
    Company: BNP Paribas Fortis
    Description: Primary Business Application Support for Latent Zero products, Decalog, and Thinkfolio as well as taking on responsibility for adhoc MS Access business developed databases.
    From:04/Feb/2008 To:27/Jun/2008

    Job Title: Support Developer Dealing Desk / Trade Floor
    Company: Marshall Wace Asset Management
    Description: Development and support for in house trading, research and Order Management System.

    Primary responsibility for Ongoing Trade support, active / live bug fixes.
    From:20/Nov/2006 To:23/Feb/2007

    Job Title: Support Developer Front Office IT
    Company: Threadneedle Investments
    Description: Support of Primary Financial Market Trading Systems (Latent Zero Sentinel, Minerva and Tesseract). Fully conversant with Latent Zero Environment as well as databases and data structures.

    Support / developer for UK, EU & US Hedge Fund Managers. UK, EU and US Hedge Fund Managers use complex Excel spreadsheets to track Fund performance. Each of these spreadsheets incorporates live Bloomberg and Reuters (3000 xtra) live data feeds. Hence live, rapid data fixes have been required.

    Support / developer for FX Treasury and Short Term Investment Fund MS Access based applications. Again Live data feeds and back end connectivity to LZ Minerva / Tesseract OMS.

    Support for External Overnight and Intraday data feeds from numerous sources, including Factset Equity and Fixed Income universes, in addition to Benchmarks from Factset, Bloomber and JP Morgan.

    Support for Broker connectivity via Fix, including responsibility for intraday maintenance of connectivity and data feeds in and out of the Order management System.
    Support responsibility for downstream delivery of data to Back Office functions (including settlements), from OMS environment.

    Support responsiblity to IIS (Information Systems) for Eagle PACE data Warehouse.
    From:18/Jul/2005 To:17/Nov/2006

    Job Title: Lead Developer
    Company: Lloyds TSB
    Description: Development of Management Information System for Telephony department. Generic reporting tool taking data from multiple sources (CSV outputs and direct database connectivity) and manipulating into large complex Excel spreadsheet reports.
    From:05/Jan/2004 To:09/Jul/2004

    Job Title: Analyst / Programmer
    Company: Cogent Investment Operations
    Description: Responsible for developing a secure environment for a large Transaction Agency System written in MS Access 97. This involved combining elements of both inherent NT 4.0 security and the Access 97 security model. This environment was packaged as a stand alone VB 6.0 DLL.

    Was also responsible for providing day to day support to Compliance department to ensure that the database used to record trading and compliance issues and errors for the FSA, remained both stable and operational.
    From:20/Feb/2002 To:21/Nov/2002

    Job Title: Support Analyst / Programmer
    Company: JP Morgan Flemings Asset Management
    Description: Working primarily as Trading and Fund Management support on several large Visual Basic Front End / SQL Server & Ingres DB back end trading systems including support for reports written in Crystal Reports 7.0.

    Working in a highly pressurised environment, to maintain trading systems on an on-going basis, identifying, categorising (high/medium/low priority) bugs in code and reports and fixing (often on the fly). Responsible for maintaining good communication with the traders and relationship managers, as well as maintaining good documentation and adhering to change control procedures.
    From:05/Feb/2001 To:18/Oct/2001

    Job Title: Senior Analyst / Programmer
    Company: Barclays Bank PLC
    Description: Analyst Programmer on the International Credit Advisor Project. This system was a Customer Relationship Management system, developed to enable Corporate Lending decisions and analysis, to take place in a global environment. Based on EMAIL enabled databases passing credit applications around the world. The purpose of the system was to enable centralisation of Corporate Credit Risk assessment while reducing the time taken to approve facility requests, to a matter of hours. Was the only team member for entire project cycle (phases 1 & 2).

    Senior Analyst Programmer on the BarclayLoan Management Information System (BMIS), an Access 97 management information tool used for assessment of Credit Risk scorecards used in personal loan application processing in the Barclays Africa Territories. Original format was an Excel 97 spreadsheet, which required transfer to an Access database format.
    From:16/Sep/1997 To:16/Jan/2001

    • £30
      /hr
    Contact

    Skills

    microsoft excelstructured query language (sql)Microsoft SQLServermicrosoft accessVisual Basic programming language

    Insights

    Freelancer Buyer
    Projects listed
    11
    Freelancers worked with
    10
    Last active
    Apr 19 2021
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Apr 19 2021
    Response time
    instantly

    Skills

    microsoft excelstructured query language (sql)Microsoft SQLServermicrosoft accessVisual Basic programming language

    Insights

    Freelancer Buyer
    Projects listed
    11
    Freelancers worked with
    10
    Last active
    Apr 19 2021
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Apr 19 2021
    Response time
    instantly
    Skills Insights

    Insights

    Freelancer Buyer
    Projects listed
    11
    Freelancers worked with
    10
    Last active
    Apr 19 2021
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Apr 19 2021
    Response time
    instantly
    Skills Insights
    microsoft excelstructured query language (sql)Microsoft SQLServermicrosoft accessVisual Basic programming language
    • Reviews
    • Purchases
    • Endorsements
    Hide feedback
    The user has no activity as a Freelancer

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2022 People Per Hour Ltd
    We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy