Jonathan Orlowski-| github.com/jonorl | - | -
Summary
Experienced technologist pivoting from business intelligence to software engineering, bringing strong full-stack
development skills and proven ability to build scalable database solutions and web applications.
Skills
Languages & Frameworks: JavaScript (ES6+), React, Node.js, Express.js, HTML5, CSS3, Tailwind, C, Python.
Backend & APIs: RESTful APIs, Express.js, JWT authentication, Passport.js, bcrypt, CORS.
Databases: PostgreSQL, Prisma ORM, MS SQL Server, database design & normalization.
DevOps & Deployment: Azure, Docker, CI/CD, Git, Railways, Neon, Netlify, Koyeb.
Testing & Tools: Jest, Git, npm, dotenv, multer, debugging, performance optimization.
Data & Analytics: Power BI, Azure Data Factory, ETL processes, data modelling, Python analytics.
Additional: Agile/Scrum methodologies, technical leadership, business requirements analysis.
Experience
Commercial Analytics & Information Manager, St John Ambulance – London, UK
July 2022 – Jan 2024
● Dynamics 365: Contributed in strategic meetings, reviewed technical requirements and validated SQL queries.
● Qlikview to PowerBI migration: For SAP BI and St John Ambulance’s proprietary training booking software.
● PowerBI and APIs: Developed new e-learning dashboard using Stripe’s API documentation and a RESTful approach.
● Databases: Normalised DBs and used SSIS scripts to automate data entry tasks, avoid duplication.
● Reporting and analytics: Reported on revenue flows for £60M coming from training and supplies retail sales.
● Leadership: Led a team of 6 people — 4 database analysts and 2 business analysts.
Business Information & Data Manager, St John Ambulance – London, UK
Jan 2015 – Jun 2022
● Access to SQL Server migration: Normalised DB, validated, migrated and liaised with infra to assess requirements.
● SQL DB Management: 3 B2B and 1 B2C databases with a combined volume over 2M records
● Data protection champion: Implemented of GDPR measures, applied marketing deletion policies and QA processes.
● Automation: Automated a key marketing process using VBA/Flow/PowerAutomate saving 1 PTE worth of time.
● Reporting and analytics: Reviewed the performance of +20,000 courses including length, price and location.
● Leadership: Led a team of 8 people — 4 database analysts and 4 business analysts.
Sr. Business Information Analyst, St John Ambulance – London, UK
Feb 2013 – Dec 2014
● Reporting: Used Qlikview and MS Excel for Finance, Operations, Marketing, Sales and Upper Management.
● Analysis: Reviewed revenue and debt flows.
● Pricing: Created and Maintained the Pricing Tools using MS Excel and VBA.
● Sales & Marketing: Created and maintained the outbound sales calling lists which represented 15% of total sales.
● Finance & HR: Implemented the sales commissions calculation and reported to upper management/HR.
Front of House Administrator, Doubletree by Hilton – London, UK
Apr 2012 – Jan 2013
Client Financial Management Analyst, Accenture – Buenos Aires, Argentina
● Finance Modelling: Developed costing models for IT/consulting services.
● Accounting: Recognised revenue for projects worth up to 100M USD.
● Sarbanes-Oxley: Performed quarterly audits to maintain compliance.
Jul 2010 – Dec 2011
Projects
Messaging App
message-app-top.netlify.app/
● Summary: Real-time chat application with user authentication and persistent message storage. Features include
private conversations, message history, and secure user registration.
● Repo: github.com/jonorl/messaging-app
● Tech: Node.js, Express, PostgreSQL, Prisma, JWT
Blog
users-frontend.netlify.app/
● Summary: Full-stack blogging platform with CRUD operations, user authentication, and responsive design. Includes
admin dashboard for content management.
● Repo: github.com/jonorl/blog-API
● Tech: React, Node.js, PostgreSQL, Tailwind CSS
Where’s Waldo (Bluey)
wheres-bluey.netlify.app/
● Summary: Interactive game demonstrating DOM manipulation and responsive design. Features real-time
leaderboard and precise click detection.
● Repo: github.com/jonorl/wheres-bluey
● Tech: React, Node.js, PostgreSQL, Prisma
Education
Del Salvador University, Buenos Aires, Argentina – 5yr degree in International Cultural and Business Studies
Universität Passau, Passau, Germany – Double degree as above
-
