freiberufler Senior Oracle Developer auf freelance.de

Senior Oracle Developer

offline
  • auf Anfrage
  • 60389 Frankfurt
  • Weltweit
  • hi  |  en  |  de
  • 07.08.2019

Kurzvorstellung

▪ Over 9 years of programming experience in Analysis, development and testing of Oracle products and Business Applications.
▪ 9 years of experience in development and maintenance of PL/SQL procedures, packages, reports etc.

Qualifikationen

  • Oracle Business Intelligence (BI)
  • Oracle Database
  • PL/SQL

Projekt‐ & Berufserfahrung

Senior Software Engineer
Hamburg Commercial Bank, Kiel
8/2019 – offen (4 Jahre, 8 Monate)
Banken
Tätigkeitszeitraum

8/2019 – offen

Tätigkeitsbeschreibung

NA

Eingesetzte Qualifikationen

Oracle Database

Lead Engineer
HCL Technologies Germany GmbH, Frankfurt
8/2018 – 3/2019 (8 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

8/2018 – 3/2019

Tätigkeitsbeschreibung

▪ Worked with program managers and business users to capture and analyze business requirements.
▪ Conducted gap analysis and developed data migration and integration plans for conversion of DB2 data to Oracle using Anubex Dataturn tool.
▪ Integration of data systems and define what data flows across the repository.
▪ Pre-Migration testing, post migration testing and validation of all data elements been converted.
▪ Database impact analysis, preparing migration strategy and anonymization of data.
▪ Developed PL/SQL packages for data anonymization while transfer from prod to non-prod environments.
▪ Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, Detailed Design Documents and Requirement Matrix.
▪ Involved in gathering requirements, developing QA test plan, designing the QA test steps, writing QA test cases and running QA test scripts
▪ Ensured the appropriate parties review and sign-off on QA test cases prior to test execution.
▪ Responsible for conducting user Acceptance Testing (UAT).
▪ Used Parameterization to perform Data-Driven testing
▪ Login defects according to priority and severity levels.
▪ Participated in defect call and production checkout testing.
▪ Managed quality assurance, audit testing and reviews.
▪ Performed database testing using SQL, executed various DDL and DML statements.
▪ Enforced soft code/hard code freeze guidelines after the test execution phase for a project.
▪ Evaluated Business Risks involved after migration and presented findings to management so that migration process is conduced as per company’s regulatory policies.
▪ Ensured sanity test are executed after hard code freeze.

Eingesetzte Qualifikationen

PL/SQL

Associate IT Consultant (Festanstellung)
ITC Infotech Ltd, Doha
8/2017 – 8/2018 (1 Jahr, 1 Monat)
Dienstleistungsbranche
Tätigkeitszeitraum

8/2017 – 8/2018

Tätigkeitsbeschreibung

▪ Solving production issues prioritized into tickets, which need immediate attention based on priority.
▪ Development, support, enhancement, bug fixes on PL/SQL packages, Data fix, Analytics, performance tuning etc.
▪ Wrote Shell Scripts for Data loading and DDL scripts.
▪ Performance tuning of Oracle Databases and User applications.
▪ PAX, Cargo, TAX report developments based on business requirements and ensuring the delivery on time.
▪ Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
▪ Production activities like PAX MIS, Cargo MIS monthly closure, daily closure activities which involved many stakeholders.
▪ Automation of few regular manual activities, thus reducing the workload on team and increase of efficiency, precision.

Eingesetzte Qualifikationen

PL/SQL

Senior Consultant (Festanstellung)
Oracle Financial Services Software Ltd, Bangalore
1/2015 – 8/2016 (1 Jahr, 8 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

1/2015 – 8/2016

Tätigkeitsbeschreibung

▪ Production issues prioritized into tickets, which need immediate attention based on priority.
▪ Development, Support, enhancement, bug fixes on PL/SQL packages and JS, Data fix, Analytics, performance tuning etc.
▪ Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle.
▪ Wrote Shell Scripts for Data loading and DDL Scripts.
▪ Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
▪ Prepared functional and technical risk analysis reports and presented findings to management.
▪ Used Oracle JDeveloper to support JAVA, JSP codes used in modules.
▪ Created back end database table for pick up from these web pages and validate using pl sql scripts which in turn return data to web page to automate confidential survey process.
▪ Performed Database Administration of all database objects including tables, clusters, indexes.
views, sequences packages and procedures.
▪ Performance tuning of Oracle Databases and User applications.
▪ Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
▪ Development and deployment of web services, MDBs, EJBs with unit and database testing.
▪ Understanding client requirements and involved in mapping of various interfaces across systems.
▪ Development of IDDs, Interfaces, FCUBS Installation, Patch Set installation, Test plan preparation, QA, Performance Tuning etc.
▪ Managed quality assurance, audit testing and reviews eliminating potential risks involved.
▪ Development, support, enhancement, bug fixes on PL/SQL packages, data fix, analytics, performance tuning etc.
▪ Analysing client’s requirements and ensuring timely program delivery in conformity with quality standards.
▪ Collaborating with the team members and senior management to maintain a continuous stream of information regarding the project status and progress.
▪ Implementation of Flexcube 12.0.3, Customization, Deployment of changes, WebLogic support etc.
▪ Deployment Support, Knowledge transition, Migration and reconciliation support, user support for any Flexcube queries- functional / technical.
▪ Development and deployment of web services, MDBs, EJBs with unit and database testing.

Eingesetzte Qualifikationen

PL/SQL

Senior Software Engineer (Festanstellung)
Capgemini, Bangalore
12/2013 – 12/2013 (1 Monat)
Dienstleistungsbranche
Tätigkeitszeitraum

12/2013 – 12/2013

Tätigkeitsbeschreibung

NA

Eingesetzte Qualifikationen

Oracle E-Business Suite, PL/SQL

Systems Engineer (Festanstellung)
Infosys Ltd, Bangalore
12/2009 – 12/2013 (4 Jahre, 1 Monat)
Dienstleistungsbranche
Tätigkeitszeitraum

12/2009 – 12/2013

Tätigkeitsbeschreibung

▪ Development, enhancement, bug fixes on PL/SQL packages, performance tuning, reports, XML reports, Data fix, Analytics etc.
▪ Testing, preparing test plans, Data Migration etc.
▪ Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
▪ Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
▪ Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
▪ Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
▪ Involved in the continuous enhancements and fixing of production problems.
▪ Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
▪ Developed PL/SQL triggers and master tables for automatic creation of primary keys.
▪ Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
▪ Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
▪ Created indexes on the tables for faster retrieval of the data to enhance database performance.
▪ Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
▪ Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
▪ Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
▪ Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
▪ Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
▪ Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
▪ Partitioned the fact tables and materialized views to enhance the performance.
▪ Extensively used bulk collection in PL/SQL objects for improving the performing.
▪ Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
▪ Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
▪ Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
▪ Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
▪ Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
▪ Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
▪ Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
▪ Involved in Logical & Physical Database Layout Design.
▪ Set-up and Design of Backup and Recovery Strategy for various databases.
▪ Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data.
▪ Used SQL*Loader as an ETL tool to load data into the staging tables.   
▪ Designed and developed data cleansing, data validation, load processes ETL using Oracle SQL and PL/SQL and UNIX.
▪ Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL).
▪ Perform ETL Testing by validating data.
▪ Developed UNIX Shell Script, Perl, Windows Batch Script to automate ETL processes.
▪ Development of Business Intelligence solutions using data modelling, Dimension Modelling, ETL Processes, Data Integration, OLAP and client /server application.
▪ Developed mappings, sessions, and workflows to load transformed data (offline data ingestion in batches) into Oracle from various source systems such as SQL Server and Flat Files.
▪ Extracted data from heterogeneous sources and performed complex business logic on data transformations.
▪ Development of design documents, FRS, TRS etc.
▪ Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
▪ Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
▪ Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
▪ Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
▪ Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
▪ Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
▪ Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
▪ Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
▪ Created some Custom reports and Forms for the end users to check the details and errors.
▪ Development, enhancement on PL/SQL packages on Oracle 12c database, Oracle reports, XML publisher reports etc.
▪ DBA activities include planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS.
▪ Installation and management of Oracle database using database control.
▪ Create and manage documentation on the configuration and support of the Oracle database 12c.
▪ Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
▪ Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
▪ Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
▪ Performed modifications on existing form as per change request and maintained it.
▪ Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
▪ Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
▪ Linux server installation, File server installation and support, SVN installation etc.
▪ Installation, up gradation and supporting of oracle database 12c, app server etc.
▪ Working on prioritized tickets, solving issues, debugging, change requests in shifts.
▪ Job monitoring, data fixes and data flow monitoring between upstream and downstream from and to Oracle systems.
▪ Interacting with the clients, on site and educating them on systems. Up gradation, documentation etc.

Eingesetzte Qualifikationen

Oracle Business Intelligence Publisher, Oracle Database, Oracle E-Business Suite, PL/SQL

Zertifikate

ITIL v3 Foundation Certified
2017
EDB Postgres Advanced Server 9.5 Professional
2017
Hortonworks (HDP) Certified Associate
2017
Oracle Certified SQL Expert
2015

Ausbildung

Computer Science
Bachelor Of Engineering
2010
Bangalore

Über mich

I am actively looking for Freelancing opportunity.

Weitere Kenntnisse

SQL, PL/SQL, ETL, Oracle Database, ETL, Data Warehousing, OBIEE etc.

Persönliche Daten

Sprache
  • Deutsch (Grundkenntnisse)
  • Englisch (Fließend)
  • Hindi (Muttersprache)
Reisebereitschaft
Weltweit
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
2987
Alter
35
Berufserfahrung
13 Jahre und 7 Monate (seit 08/2010)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden