Cajetan Dsouza, Developer in Sydney, New South Wales, Australia
Cajetan is available for hire
Hire Cajetan

Cajetan Dsouza

Verified Expert  in Engineering

Database Developer

Location
Sydney, New South Wales, Australia
Toptal Member Since
March 7, 2022

Cajetan has specialized in Oracle SQL and PL/SQL for 13 years. He has also written and worked with MySQL, PostgreSQL, and Microsoft SQL Server databases and has recent experience with AWS technologies and Oracle Cloud. Cajetan has delivered solutions for banking, credit cards, and finance at Commonwealth Bank of Australia and ICICI Bank; supply chain management software for Woolworths Group; and a campaign management platform for telecom. He has a master's degree in computer application.

Availability

Part-time

Preferred Environment

Windows, Oracle, Toad, PL/SQL Tuning

The most amazing...

...thing I've developed was a complete housing society portal, using ASP.NET on the front end and MySQL on the back end.

Work Experience

Database Development Specialist

2018 - PRESENT
Commonwealth Bank of Australia
  • Developed major CBA products, including AdvancePay, StepPay, and Hardship digitization.
  • Played a key role in optimizing the high resource-consuming code to improve performance.
  • Mentored and reviewed colleagues and team members.
Technologies: Oracle SQL, Oracle PL/SQL, GitHub, CSV, Data Manipulation

Senior Developer

2017 - 2018
Woolworths Group
  • Worked on reward management software developed in-house.
  • Assisted in building a new campaign for rewarding customers and encouraging higher spending.
  • Helped migrate data from PostgreSQL to an Amazon Redshift database.
Technologies: PostgreSQL, Redshift, CSV

Technical Lead

2016 - 2017
Emagine International (Acquired by Comviva)
  • Worked on the Campaign Management Platform (CMP) product, which was implemented to run customer campaigns and offers in the telecom sector.
  • Built and maintained the development Oracle Database on a local server and Oracle Cloud and monitored it for day-to-day functioning.
  • Created the PDB on Oracle Cloud for development and testing purposes.
Technologies: Oracle SQL, Oracle PL/SQL, Oracle Cloud, CSV, Data Manipulation

Senior Oracle PL/SQL Developer

2014 - 2015
Commonwealth Bank of Australia (Contract)
  • Worked on the back end for CommSee, the in-house product used across all CBA branches in Australia.
  • Performed data modeling for new requirements and defect investigation and fixes for production issues.
  • Mentored and advised less experienced PL/SQL programmers.
Technologies: Oracle SQL, Oracle PL/SQL, CSV, Data Manipulation

Delivery Module Leader

2013 - 2014
Mphasis
  • Managed the SDLC from requirements analysis to closure: prepared the development project plan based on program specs, prepared project trackers, highlighted issues and concerns, identified risks, and prepared mitigation and contingency plans.
  • Provided input for the architecture and design of the customization requirement and assisted the team in developing customizations on SQL and PL/SQL using advanced performance tuning techniques.
  • Interacted with the client and onsite coordinator to discuss requirements and prepare the specs.
Technologies: Oracle SQL, Oracle PL/SQL, PL/SQL Tuning, CSV

System Analyst

2010 - 2012
Hexaware Technologies
  • Performed development in Oracle SQL and PL/SQL using BULK COLLECT and COLLECT to handle high volume efficiently.
  • Owned handling and resolution of defects in production.
  • Interacted with Alliance Bernstein, a client in the United States.
Technologies: Oracle SQL, PL/SQL, PL/SQL Tuning, CSV

Senior Software Engineering

2004 - 2010
3i Infotech
  • Performed system analysis and development for the ICICI Bank credit card project.
  • Created new credit card products and promotions using PL/SQL.
  • Tuned an existing application to improve performance.
Technologies: Oracle SQL, PL/SQL, PL/SQL Tuning, CSV

CommBank AdvancePay

A new feature to give CBA customers access to limited funds in advance when they expect their pay to arrive in their CBA account in a few days so they can pay the total amount. I played a key role in developing the complete new data model, from application origination to fulfillment.

CommBank StepPay

I was involved in developing a new solution for account location service. This was a UUID-based system for storing corporate-level accounts, credit card, and client information. Designed the complete data model, including the SP for API. Also created SP for loading high-volume recon files daily.

MySocietyBilling

A housing society billing portal that includes customer profiles, billing records, payment gateway integration with auto adjustment, an SMS gateway, and customized bill generation. I developed this portal single-handedly.

Up to 100% Cashback

Involved in designing and developing a complete promotion of "Up to 100% cashback" for ICICI bank. It was a dynamic reward program designed around the auth code of the transaction, and cashback reward given to customer depending on the bucket which the auth code total falls. It was a very critical and high volume processing projects, which was successfully carried out.

Languages

SQL, VB.NET, CSS, HTML, JavaScript

Paradigms

ETL, Database Design

Platforms

Oracle, Amazon Web Services (AWS)

Storage

Oracle PL/SQL, Oracle SQL, PL/SQL, SQL Loader, RDBMS, Databases, Oracle Cloud, MySQL, PostgreSQL, Microsoft SQL Server, Redshift, Amazon S3 (AWS S3)

Other

Software, PL/SQL Tuning, Data Engineering, Data Modeling, Data Manipulation, CSV, Payment Gateways, SMS Gateways, eCommerce

Tools

GitHub, iTextPDF, Toad

Frameworks

ASP.NET

2007 - 2010

Master's Degree in Computer Application

Sikkim Manipal University - Gangtok, Sikkim, India

1998 - 2001

Diploma in Computer Science

Bangalore University - Belgaum, Karnataka, India

DECEMBER 2021 - PRESENT

Oracle Cloud Infrastructure Foundations 2021 Associate

Oracle

JUNE 2018 - PRESENT

Exam 70-461: Querying Microsoft SQL Server 2012/2014

Microsoft

MAY 2012 - PRESENT

Oracle Advanced PL/SQL Developer

Oracle

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring