Database Developer , Oracle , PL/SQL , DevOps , Teradata
Aktualisiert am 20.09.2020
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 21.09.2020
Verfügbar zu: 100%
davon vor Ort: 100%
Oracle/SQL
DevOps
Teradata
Data Integration
Performance analysis
Gradle
Git
English
Fluent in reading, writing and speaking
German
Fluent in reading, writing and speaking
Swedish
Fluent in reading, writing and speaking

Einsatzorte

Einsatzorte

Deutschland
nicht möglich

Projekte

Projekte

5 Jahre 11 Monate
2018-05 - heute

Aptitude Development

Aptitude Developer, Technical Subject Matter Expert Aptitude Oracle 12c DB2 ...
Aptitude Developer, Technical Subject Matter Expert
  • Each of the below entries represents an assignment at Swiss Re.

CorUVM & CorFinCalcs

Actuarial and Calculation Engine

DevOps

  • Standardized the build process using gradle. Converted the manual build process to gradle tasks, thereby delivering consistent and reliable code across multiple test and production environments.
  • Ported, customized and maintained automated unit test using TestNG framework.
  • Set up automated nightly build pipelines in Bamboo to continuously test and deliver code.
  • Defined and enforced branching strategy in Git and Aptitude repository.

Development & Support

  • Migrated features which were initially developed using proprietary AAE to Oracle stored procedures, thereby increasing performance of some processes from 10 hours to approximately 20 minutes.
  • Development and maintenance of multiple Aptitude ETL projects and Oracle database objects. Delivered multiple business features from driving business requirements to code delivery in production.
  • Compilation and packaging of releases. Accountable for ensuring release made available for deployment into the change-controlled environments was stable, fully unit tested and would deploy without incident.
  • Worked as a production operational dispatcher and was responsible for solving multiple incidents. Ensuring that fixes to issues encountered were integrated back into the codebase.

CorFinGateway 

Integration platform and orchestration component

Development & Support

  • Developed Aptitude solutions and Oracle objects to consolidate and transport data between differing data sources to respective consumer applications. Delivered efficient and functioning code according to the strict code quality requirements.
  • Created multiple data quality rules to enforce integrity and quality of delivered data.
  • Creation of new and the maintenance of existing automated unit tests written in the Java-based TestNG framework.
  • Reviewing and critiquing the code produced by other members of the team to ensure code quality.
  • Using an Agile SCRUM development methodology, accountable for sprint reviews, delivery and retrospectives.
  • Hands on experience of developing and maintaining UC4 batch scheduling jobs, and the promotion to test and productive environments.
Aptitude Oracle 12c DB2 GIT Bamboo Bitbucket Gradle TestNG
Swiss Re, Zürich/London (Freelance assignment)
3 Jahre 6 Monate
2014-12 - 2018-05

Release management

Senior Developer, Technical Lead, Dispatcher Aptitude Aptitude Accounting Hub (AAH) Teradata ...
Senior Developer, Technical Lead, Dispatcher
  • Each of the below entries represents an assignment at Swedbank.
  • Aptitude Accounting Engine

AAH Configuration

  • Creating new and modifying existing posting patterns and account lookups.
  • Development and maintenance of processes in each layer of AAH processing from Standardisation (STN) through to Reporting Data Repository (RDR).

Release management

  • Administration of the Aptitude repository. Defined sprint-based branches performed code merges and cut labels. Responsible for ensuring that each member of the team had both committed all code to be included in forthcoming releases and that it was of an appropriate quality.
  • Deployment of releases into the production environment when necessary.

Development

  • Liaising with the release management team to ensure that the functionality desired by the business is planned into sprints.
  • Planning sprints in JIRA and delegating development tasks to team members.
  • Development and maintenance of Aptitude ETL projects.
  • Creation of new and the maintenance of existing automated unit tests written in the Java-based TestNG framework.
  • Managing source code in the GIT repository.

Application maintenance & performance

  • Proactive monitoring of the performance of the solution and refactoring code when necessary.
  • Troubleshooting issues in change-controlled test environments.
  • Ensuring that fixes to issues encountered in change-controlled environments were integrated into the codebase.
  • Reviewing & providing critique of the code produced by other members of the team to ensure code quality.

Common Staging Area (CSA)

  • Development Aptitude solutions to Shred (unpack) data from XML files and subsequent load into the database.
  • Migration of the Aptitude server and the Aptitude repository from Aptitude version 4.10 to 5.10. Migrated codebase from SVN to GIT.
  • Maintenance of the Aptitude repository and resolution of conflicts.
  • Design and development of Teradata stored procedures, views and objects.
  • Managed various test environments, deploying builds and troubleshooting day-to-day activities.


Production Support

  • Resolution of critical incidents in the production environment
  • Provision of assistance in migrating the CSA application from Teradata 14 to Teradata 15.
  • Extraction of ad-hoc reports and data analyses as requested by key business stakeholders.
Aptitude Aptitude Accounting Hub (AAH) Teradata SVN GIT Bitbucket Gradle TestNG
Swedbank, Stockholm
3 Monate
2014-01 - 2014-03

Database Development

Database Developer SQL Server 2008R2 T-SQL
Database Developer
SQL Server 2008R2 T-SQL
Swedish Financial Supervisory Authority
4 Monate
2013-06 - 2013-09

Database Development

Database Developer SQL Server 2012 SQL Server Integration Service SSIS SSRS and management studio
Database Developer
SQL Server 2012 SQL Server Integration Service SSIS SSRS and management studio
Midroc Electro AB

Aus- und Weiterbildung

Aus- und Weiterbildung

  • Aptitude V4 for Aptitude Accounting Hub (AAH)
  • Microsoft Certified Solutions Associate (MCSA) ? SQL Server 2012

09/2009 - 08/2012

Master?s in Computer and Systems Sciences - , Stockholm University, Sweden.

08/2004 - 05/2008
Bachelor of Technology in Information Technology - Anna University, India.

Kompetenzen

Kompetenzen

Top-Skills

Oracle/SQL DevOps Teradata Data Integration Performance analysis Gradle Git

Produkte / Standards / Erfahrungen / Methoden

Technical Skills Summary

Integration tools:

  • Microgen Aptitude
  • SQL Server Integration studio
  • Informatica PowerCenter


Database Administrative Tools:

  • SQL Plus
  • SQL Developer
  • Toad
  • SQL Server Management Studio


CI Tools:

  • Bamboo
  • Jenkins 
  • Bitbucket


Version Control:

  • GIT
  • SVN

Betriebssysteme

Unix
Windows server

Datenbanken

DB2
Oracle
12c
SQL Server
2012
Teradata
14 , 15

Einsatzorte

Einsatzorte

Deutschland
nicht möglich

Projekte

Projekte

5 Jahre 11 Monate
2018-05 - heute

Aptitude Development

Aptitude Developer, Technical Subject Matter Expert Aptitude Oracle 12c DB2 ...
Aptitude Developer, Technical Subject Matter Expert
  • Each of the below entries represents an assignment at Swiss Re.

CorUVM & CorFinCalcs

Actuarial and Calculation Engine

DevOps

  • Standardized the build process using gradle. Converted the manual build process to gradle tasks, thereby delivering consistent and reliable code across multiple test and production environments.
  • Ported, customized and maintained automated unit test using TestNG framework.
  • Set up automated nightly build pipelines in Bamboo to continuously test and deliver code.
  • Defined and enforced branching strategy in Git and Aptitude repository.

Development & Support

  • Migrated features which were initially developed using proprietary AAE to Oracle stored procedures, thereby increasing performance of some processes from 10 hours to approximately 20 minutes.
  • Development and maintenance of multiple Aptitude ETL projects and Oracle database objects. Delivered multiple business features from driving business requirements to code delivery in production.
  • Compilation and packaging of releases. Accountable for ensuring release made available for deployment into the change-controlled environments was stable, fully unit tested and would deploy without incident.
  • Worked as a production operational dispatcher and was responsible for solving multiple incidents. Ensuring that fixes to issues encountered were integrated back into the codebase.

CorFinGateway 

Integration platform and orchestration component

Development & Support

  • Developed Aptitude solutions and Oracle objects to consolidate and transport data between differing data sources to respective consumer applications. Delivered efficient and functioning code according to the strict code quality requirements.
  • Created multiple data quality rules to enforce integrity and quality of delivered data.
  • Creation of new and the maintenance of existing automated unit tests written in the Java-based TestNG framework.
  • Reviewing and critiquing the code produced by other members of the team to ensure code quality.
  • Using an Agile SCRUM development methodology, accountable for sprint reviews, delivery and retrospectives.
  • Hands on experience of developing and maintaining UC4 batch scheduling jobs, and the promotion to test and productive environments.
Aptitude Oracle 12c DB2 GIT Bamboo Bitbucket Gradle TestNG
Swiss Re, Zürich/London (Freelance assignment)
3 Jahre 6 Monate
2014-12 - 2018-05

Release management

Senior Developer, Technical Lead, Dispatcher Aptitude Aptitude Accounting Hub (AAH) Teradata ...
Senior Developer, Technical Lead, Dispatcher
  • Each of the below entries represents an assignment at Swedbank.
  • Aptitude Accounting Engine

AAH Configuration

  • Creating new and modifying existing posting patterns and account lookups.
  • Development and maintenance of processes in each layer of AAH processing from Standardisation (STN) through to Reporting Data Repository (RDR).

Release management

  • Administration of the Aptitude repository. Defined sprint-based branches performed code merges and cut labels. Responsible for ensuring that each member of the team had both committed all code to be included in forthcoming releases and that it was of an appropriate quality.
  • Deployment of releases into the production environment when necessary.

Development

  • Liaising with the release management team to ensure that the functionality desired by the business is planned into sprints.
  • Planning sprints in JIRA and delegating development tasks to team members.
  • Development and maintenance of Aptitude ETL projects.
  • Creation of new and the maintenance of existing automated unit tests written in the Java-based TestNG framework.
  • Managing source code in the GIT repository.

Application maintenance & performance

  • Proactive monitoring of the performance of the solution and refactoring code when necessary.
  • Troubleshooting issues in change-controlled test environments.
  • Ensuring that fixes to issues encountered in change-controlled environments were integrated into the codebase.
  • Reviewing & providing critique of the code produced by other members of the team to ensure code quality.

Common Staging Area (CSA)

  • Development Aptitude solutions to Shred (unpack) data from XML files and subsequent load into the database.
  • Migration of the Aptitude server and the Aptitude repository from Aptitude version 4.10 to 5.10. Migrated codebase from SVN to GIT.
  • Maintenance of the Aptitude repository and resolution of conflicts.
  • Design and development of Teradata stored procedures, views and objects.
  • Managed various test environments, deploying builds and troubleshooting day-to-day activities.


Production Support

  • Resolution of critical incidents in the production environment
  • Provision of assistance in migrating the CSA application from Teradata 14 to Teradata 15.
  • Extraction of ad-hoc reports and data analyses as requested by key business stakeholders.
Aptitude Aptitude Accounting Hub (AAH) Teradata SVN GIT Bitbucket Gradle TestNG
Swedbank, Stockholm
3 Monate
2014-01 - 2014-03

Database Development

Database Developer SQL Server 2008R2 T-SQL
Database Developer
SQL Server 2008R2 T-SQL
Swedish Financial Supervisory Authority
4 Monate
2013-06 - 2013-09

Database Development

Database Developer SQL Server 2012 SQL Server Integration Service SSIS SSRS and management studio
Database Developer
SQL Server 2012 SQL Server Integration Service SSIS SSRS and management studio
Midroc Electro AB

Aus- und Weiterbildung

Aus- und Weiterbildung

  • Aptitude V4 for Aptitude Accounting Hub (AAH)
  • Microsoft Certified Solutions Associate (MCSA) ? SQL Server 2012

09/2009 - 08/2012

Master?s in Computer and Systems Sciences - , Stockholm University, Sweden.

08/2004 - 05/2008
Bachelor of Technology in Information Technology - Anna University, India.

Kompetenzen

Kompetenzen

Top-Skills

Oracle/SQL DevOps Teradata Data Integration Performance analysis Gradle Git

Produkte / Standards / Erfahrungen / Methoden

Technical Skills Summary

Integration tools:

  • Microgen Aptitude
  • SQL Server Integration studio
  • Informatica PowerCenter


Database Administrative Tools:

  • SQL Plus
  • SQL Developer
  • Toad
  • SQL Server Management Studio


CI Tools:

  • Bamboo
  • Jenkins 
  • Bitbucket


Version Control:

  • GIT
  • SVN

Betriebssysteme

Unix
Windows server

Datenbanken

DB2
Oracle
12c
SQL Server
2012
Teradata
14 , 15

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.