Cajetan is currently unavailable
Cajetan Dsouza
Verified Expert in Engineering
Database Developer
Sydney, New South Wales, Australia
Toptal member since March 7, 2022
Bio
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.
Portfolio
Commonwealth Bank of Australia
Oracle SQL, Oracle PL/SQL, GitHub, CSV, Data Manipulation
Woolworths Group
PostgreSQL, Redshift, CSV
Emagine International (Acquired by Comviva)
Oracle SQL, Oracle PL/SQL, Oracle Cloud, CSV, Data Manipulation
Experience
- Oracle - 15 years
- Oracle SQL - 15 years
- Oracle PL/SQL - 15 years
- PL/SQL Tuning - 15 years
- Data Engineering - 5 years
- Data Modeling - 5 years
- MySQL - 3 years
- Oracle Cloud - 1 year
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
Project History
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.
Education
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
Certifications
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
Skills
Tools
GitHub, iTextPDF, Toad
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)
Frameworks
ASP.NET
Other
Software, PL/SQL Tuning, Data Engineering, Data Modeling, Data Manipulation, CSV, Payment Gateways, SMS Gateways, eCommerce
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