JPMorganChase· Chapter 01

Implementation Engineer

Enterprise SaaS implementation, database engineering and client onboarding for financial applications.

April 2013 - December 2013Oracle + PL/SQLMulti-tenant SaaSProduction ownership

The implementation problem

Making a shared product feel ready for a new enterprise client.

This was the foundation of my JPMorgan experience. I worked on implementing a multi-tenant SaaS product for new enterprise clients, taking ownership of the technical work required to move a client from initial setup to a production-ready environment.

My work sat across Oracle database engineering, data migration, application configuration, integrations, reporting and production deployment. Client-specific requirements had to be supported without compromising the standard product.

Client environment provisioning

Preparing the database and application foundation for onboarding.

  • Created and configured Oracle databases for new client implementations.
  • Prepared database schemas and application configuration required for onboarding.
  • Validated database structures before moving the environment into production.
  • Managed multiple client implementations in parallel.
  • Kept client-specific configuration isolated from the standard SaaS product.
  • Worked directly with production environments rather than treating implementation as a purely QA activity.

Data migration and initial client setup

The client needed the right data, users and permissions on day one.

I worked with client-provided Excel data and converted it into structured database information using PL/SQL-based migration processes. The objective was not simply to load data; the client needed to log in on day one and see the correct organizational structure, users, permissions and data already available.

  1. Migrated initial client data into Oracle.
  2. Created the initial user population.
  3. Built organizational and territorial hierarchies.
  4. Assigned users to the appropriate hierarchy levels.
  5. Mapped users to authorities and permissions.
  6. Validated completeness and accuracy before launch.
  7. Corrected migration issues before production.
  8. Supported complex migrations where databases or organizational subdivisions had to be consolidated.

Database engineering

Hands-on Oracle development behind the implementation.

  • PL/SQL procedures and functions
  • Triggers and database links
  • Reporting views and auditing tables
  • Data migration scripts
  • Scheduled database jobs
  • Reporting jobs designed for accuracy, consistency and execution speed

Client-specific development and integrations

Extend the product without breaking the product.

Not every client could be onboarded through configuration alone. I understood the existing application architecture, identified where configuration was insufficient, and developed application or database changes while keeping client-specific behaviour isolated.

  • Understood the existing application flow.
  • Designed database changes when required.
  • Validated behaviour against the standard product.
  • Avoided changes that could affect existing clients.

I also worked on integrations between client environments and the SaaS platform.

  • Handled client-provided file inputs.
  • Defined file-based integration flows and system handshakes.
  • Validated incoming data at the database and application layers.
  • Troubleshot integration failures and processing issues.

Production ownership

Implementation was production-aware engineering from the beginning.

I had production database write access and was directly responsible for implementing and validating changes in live environments. That meant thinking beyond “Does the code work?” and asking “What will this change do to the client’s production environment?”

That level of ownership shaped the production-aware engineering mindset that later became central to my support and automation work.

What I learned

The implementation mindset that carried into production support.

Small database changes can have large production consequences.

ApplicationDatabaseConfigurationIntegrationProduction

I learned how applications depend on their database structure, how configuration can affect shared product behaviour, how migration can determine implementation success, and why standardisation is critical when supporting multiple clients at once.

Next chapter
L2/L3 Production Support Engineer