Jason F.

Experience

• 

  Urban Science

  Jul 2011 - Jan 2013

  Business Intelligence Developer

  My core responsibilities lie with the development and maintenance of Urban Science’s ‘Business Intelligence’ tool. This is a web-based interactive and analytical tool that provides dealers (Car/Van) and corporate field staff with immediate access to intelligence that measures financial performance and identifies opportunities for dealership operating and profit improvement. I also handle monthly production for several clients via the Si2 and BPI systems. These are primarily online dealer performance management tool that helps increase new or used vehicle sales, provides sales assessments, and promotes best practices. I mainly use SQL (SSAS and SSIS) to load new monthly data into the relevant systems for client use as well as prepare several reports. Show less

• 

  Hotels4u.com

  Jan 2013 - Feb 2014

  SQL Developer/DBA

  • Played a key role within the e-commerce team, tasked with the development of efficient and robust database solutions that support applications in hosted and cloud based platforms by ¬ Creating stored procedures, functions, tables, triggers, indexes, jobs ¬ Preparing capacity planning and sizing. ¬ Performing stress testing and benchmarking, and query performance tuning on existing stored procedures.• Setting up and successfully managing five preproduction environments by ¬ Installing SQL server management studio instances and service packs upgrades. ¬ Automating backups and restores using maintenance plans and custom Store procedures. ¬ Creating, reinitializing and monitoring replication. ¬ Troubleshooting and resolving database issues including job failures, disk space issues, disk/memory contention issues, blocking/concurrency issues. ¬ Implementing and maintaining security within the database. ¬ Preparing and executing database deployments to production.• Provide department and business level reporting using SSRS.• Experience working in High Volume OLTP environment. Show less

• 

  192.com

  Feb 2014 - Mar 2016

  Technical Lead SQL

  Management of all company’s data, data systems and personnel within the data domain. Ensuring the efficient usage of resources in co-operation with other technical areas both internally and externally. This includes the ongoing analysis of data systems to optimize their operational value and cost efficiency. Hands-on involvement in data boarding, processing and management across the company. Ongoing research into emerging and alternative technologies and methodologies that might facilitate the company’s data capabilities or performance. Show less

• 

  KAYAK

  Apr 2017 - Apr 2018

  Senior SQL Server DBA

  I designed and engineered various ETL processes from AWS Redshift to MSSQL and vice versa as well as further database development in AWS Redshift. Performance tuning and Table partitioning were some of the ad hoc tasks I successfully performed whilst in this role.

• 

  Forum for Agricultural Research in Africa - FARA

  Apr 2018 - Apr 2020

  Technical Product Manager

  Oversaw the entire software development lifecycle of a Greenfield project which was aimed at settingup a website to capture competencies (skills, knowledge, and expertise of users) that could, for a givenlocation, build a snapshot of surpluses or deficiencies of a competency or skills. I collaborated withstakeholders for requirement gathering, refinements and retrospectives feature releases. I used this insetting the development strategy, the software roadmap, infrastructure used, defining use cases, anddefining the scope of the work in line with the overall vision of the project to ensure customer success.I organised and managed, daily stand-up, backlog refinement, sprint retrospectives and demos tostakeholders. Establish CI/DEV, QA, UAT environments and implement continuous integration anddelivery, using Azure SQL DB, Flyway DB, TortoiseSVN and TeamCity.Developed fully in Azure databases (SAAS) via SSMS 2014 setting up the supporting databases anddatabase objects (tables, views, SPs, web jobs, logins/users, and security management) from scratch.I successfully managed the cross functional team of 6, IU/UX designers, full stack developers, testers and database developers, in successfully designing, developing and delivering all requested features on time and on budget. Show less

• 

  IBM

  Jul 2018 - Jan 2019

  Application (SQL) Developer

  I successfully designed, developed, implemented and tested a data pipeline with flyway via Jenkins. I successfully completed several data migration projects in both SQL Server and Postgres environment.

• 

  Lloyds Banking Group

  Feb 2019 - Jan 2020

  Data Engineer

  Engineered data pipelines to source, stage, prep and load structured and semi-structured data of 150kdevice, 100k user and 55k application information using powershell, python and SQL in support of aWindows 7 to Windows 10 device migration. I refined existing pipelines, improving efficiency and speedof delivery with better performing SQL code and more suitable tools like python and powershell.Designed and developed a Datawarehouse to support data scientists and analysts in downstreamanalysis, data mining and reporting with PowerBI.Developed and maintained key lines of communication with various stakeholders and teams, critical toeither providing data and insights or consumers of the data and top management team, in order to keepall interested parties aligned and facilitate a smooth progression of tasks to fruition. Show less

• 

  Direct Line Group

  May 2020 - Dec 2022

  Data Engineer

  Engineered various data pipelines directly from API sources, staged in AWS S3 and transformed andloaded into structured parquet files using pyspark and AWS tool like Glue, Athena, S3, CloudFormation,Pipelines. Rework various expensive and long running legacy AWS glue jobs, written in python, resultingin an annual savings of almost £300k, utilising more efficient python/pyspark scripting and parallelprocessing.Collaborated closely with product onwers and scrum masters in requirement gathering, product backlogrefinements, sprint and PI planning. Effectively, led daily stand ups to align the data platform team withsprint goals. Frequently liaised with external stake holders to resolve issues blocking the teams workthus achieving a healthy velocity for the team. Show less

• 

  Maxeon Solar Technologies

  Jan 2023 - now

  Technical Product Manager | Business Analyst

  • Managed the SAAS setup and configuration of installer portals globally (US, EMEA, APAC,LATAM) and localization of said portal to align with customer needs and market trends.• Led data analysis initiatives to identify and implement enhancements and new features inMaxeon's tools, thereby improving user experience and efficiency through data-driven decision-making.• Liaised with business stakeholders to develop and implement product roadmaps, establishingrobust business cases for new initiatives.• Closely aligned with stakeholders from various departments, including design/UAT, channel,sales, and marketing, to prioritize product backlog inline with product roadmap.• Championed the long-term strategy, representing the company's vision and values in local teamsand at public events as a subject matter expert.• Led cross-functional teams in conducting UAT on installer portal features pre and post go-live.• Successfully trained and provided ongoing support to internal teams including first line support,sales managers, channel managers, and marketing managers on our installer portals, backend(SAAS, Salesforce, OKTA) setup and processes.• Fully documented product requirements (PRDs), User guides, SOPs, UAT handbooks, releasenotes using Confluence, Miro, MS suite.• Managed the Commercial Applications support team of 4 in resolving L2/L3 tickets. Show less