Profile Picture
0 jobs

Developer

Abisha , LONDON, United Kingdom


Experience

10 - 14 years

Other titles

Oracle Developer/Release Manager

Skills

Database modeling Database systems DB2 Mapping MS SQL Server + 11 more

I'm offering

• 10 years of focused experience in IT industry in various fields like banking, insurance, finance and retail.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, Oracle 6i and 9i forms and reports and SQL*LOADER.
• Experience in design and develop custom UI and reporting using Oracle Forms, Oracle Reports.
• Design and develop new datasets, data feeds, reports, and analysis features ensuring high performance and future scalability;
• Experience in working with Agile software development methodologies.
• Experience with Dimensional Data Modelling.
• Ability to document data validation and discovery information about DW data, schema, and processes.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Expertise in Oracle Forms and Reports
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in ETL techniques and Analysis and Reporting.
• Good Knowledge on Azure DevOps.
• Knowledge of big data technologies like Hadoop/HDFS/Hive/Hbase/Impala & ETL tool integration
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Demonstrated experience working with a project team to develop a design, technical solution, and ultimately to implement high quality technical solutions

Markets

United Kingdom

Language

English
Fluently

Ready for

  Smaller project
  Ongoing relation / part-time
  Full time contractor

Available

Typically available right away

My experience


My education




Abisha's reviews

Abisha has not received any reviews on Worksome.


Contact Abisha

Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.

Create a login and get the opportunity to write to Abisha directly in Worksome.

Continue



37900+ qualified freelancers
are ready to help you

Tell us what you need help with
and get specific bids from skilled talent in Denmark