Martin Lee Pan

Martin Lee Pan

Junior Business Intelligence Developer

Followers of Martin Lee Pan882 followers
location of Martin Lee PanOeiras, Lisbon, Portugal

Connect with Martin Lee Pan to Send Message

Connect

Connect with Martin Lee Pan to Send Message

Connect
  • Timeline

  • About me

    Software Engineer, avid learner and tech enthusiast

  • Education

    • University of Cape Town

      2008 - 2012
      B.Com Honours in Information Systems Informatics
    • University of Cape Town

      2009 - 2012
      Bachelor of Commerce (B.Com.) Honours Information Systems
  • Experience

    • Saratoga Software

      Jan 2013 - Nov 2014
      Junior Business Intelligence Developer

      I worked as a consultant at different sites and with different clients depending on the contract. I have worked at two departments within Old Mutual (Anti-money laundering for Old Mutual Namibia and Old Mutuals Customer Analytics Mart) and have also worked on a Web migration project at UCTAnti-money laundering for Old Mutual Namibia:On this project I built data driven rules to detect and notify the Old Mutual staff, for the Namibian division, of suspicious financial activity.Customer Analytics Mart (CAM):I worked as a Business Intelligence (BI) developer to build and maintain the Extract, Transform and Load (ETL) process for a specialised Data Mart that consolidated customers' portfolios over the various Old Mutual products. Show less

    • JUMO.WORLD

      Nov 2014 - Mar 2023

      As a senior software engineer I worked on the core Lending platform. The service was a Ruby on Rails monolith that we were migrating to a new service in Kotlin.My responsibilities were maintaining and building features for the core Lending product. Helping the team by facilitating Agile processes. Mentoring younger members of my team in career growth and multi-dimensional skills (other than standard engineering skills).Refactoring old components of Legacy code without causing downtime.Managing infrastructural changes to our databases in AWS, scheduling maintenance windows, communication and rollout plan with rollback procedures - almost always without any down time.Involved in architectural design by committee by submitting proposals and gathering feedback and signoff.Handling many Ruby language upgrades as well as Rails upgrades from Rails 3 to 4 to 5 without breaking the production system.Handling inter-department requirement gathering and developing solutions to streamline business as usual processes. Show less

      • Senior Software Engineer

        May 2020 - Mar 2023
      • Intermediate Software Engineer

        May 2017 - May 2020
      • Software Engineer - Ruby on Rails

        Nov 2014 - Apr 2017
    • Indie Campers

      May 2023 - now

      My main role as a Tech Lead is to lead a team of 4-5 engineers (including myself) as the core team.Our primary focus is on performance optimisation, code standardisation and modelling the data structures around the core system.On a day-to-day I juggle between development, code reviews, mentoring and scoping work and planning new work for the team.I help to design the code patterns, standards and models that support the business to scale.Additionally, due to the lack of a devops team. I work on the CI/CD pipelines to speed up test execution times, monitor database and service performance and intervene when necessary.I implemented an optimisation that improved the latency of an API by 99% in the worst cases. Show less When I arrived at Indiecampers, I was hired as a senior backend engineer. However the team was very small and there was no devops team.So my first work was around CI/CD.The test suite for the monolith application was taking more than 20 minutes to execute and often the task running the tests exceeded the time limit and timed out. I implemented a parallel testing execution which cut the total execution down to about 10 minutes (more than 50% increase).I also performed a few Ruby version upgrades with zero downtime.I worked on and led many projects, with teams between 4 -10 team members. Some of these are: a complete rebuild and simplification for our survey mechanism tool, building a custom feature flagging implementation which facilitated percentage based roll outs, per location or other use cases. I worked on many other projects, bug fixes and incident detection and prevention.I automated many manual tasks that employees were repeating week after week.I led a few different teams of software engineers and was heavily involved with the product team in scoping and discussing possibilities or trade offs.I architected data structures and/or orchestration between services for new features. Deciding on API conventions and payloads.I mentored many of my team mates on best practices, monitoring and building robust and idempotent software.I also performed a full migration of the monitoring tools from New Relic to Datadog for around 4-5 services Show less

      • Tech lead

        Jan 2025 - now
      • Senior Back End Engineer

        May 2023 - Jan 2025
  • Licenses & Certifications

    • Administering Microsoft SQL Server 2012 Databases (70-462)

      Microsoft
      View certificate certificate
    • Querying Microsoft SQL Server 2012 (70-461)

      Microsoft
      View certificate certificate
    • Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)

      Microsoft
      Oct 2014
      View certificate certificate