$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Developer
Abisha
,
LONDON, United Kingdom
Experience
Other titles
Skills
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
• 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
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - 2019
freelance
Consultant
Atos Syntel.
India
Client: State Street, United States
Project: AIS - ISS (Insured Shared Services)
Duration: Aug 2018 to Jul 2019
Role: Consultant
Responsibilities
• Worked on agile development environment which involves bi-weekly iteration, daily scrum meeting, Business meetings on requirements to track the iteration progress, feedback discussions and retrospective meeting.
• Worked on ISS finance application to generate various kinds of reports.
• 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
• 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
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• 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.
• 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.
• Updated oracle forms as per user requirement and debugged form level error and provided solutions.
• Good Experience in generating oracle reports.
Client: State Street, United States
Project: AIS - ISS (Insured Shared Services)
Duration: Aug 2018 to Jul 2019
Role: Consultant
Responsibilities
• Worked on agile development environment which involves bi-weekly iteration, daily scrum meeting, Business meetings on requirements to track the iteration progress, feedback discussions and retrospective meeting.
• Worked on ISS finance application to generate various kinds of reports.
• 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
• 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
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• 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.
• 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.
• Updated oracle forms as per user requirement and debugged form level error and provided solutions.
• Good Experience in generating oracle reports.
Sql, Scrum, Oracle, Agile development, Agile, Database, Unix, Pl/sql, Finance, Stored procedures, Developer, Development, BEE, Tuning, Performing
2013 - 2018
job
Oracle Developer/Release Manager
PRS for Music.
Performing Rights Society for Music (PRS) is a society of songwriters, composers and music publishers. PRS administrates the performing right for public performance of music, including concerts on websites, for radios and TV and for online streaming services. It is an umbrella name for two collecting societies. Mechanical Copyright Protection Society (MCPS) operates under the PRS for music brand. PRS collects and distributes the music royalties. In total, PRS represents the repertoire of more than two million songwriters and composers, including approximately ten million musical works.
Responsibilities
• Managing all aspects of release process on repertoire application.
• Holds overall responsibility to plan, develop, coordinate and lead software release activities with application and support teams.
• Ensure the consistency of test environment and production.
• Maintenance of Oracle Production, Development, Testing and QA databases.
• Alert monitoring and Ticketing.
• End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.
• Create and maintain Release notes and track corrective actions of change related incidents and create new change request for all releases.
• Responsible to continually improve change/release processes hence to proactively minimize change-related risks.
• Responsible to gather business requirements, conduct gap analysis, identify issues and suggest workarounds.
• Responsible for setting up ITIL based processes in the Release Management space.
• Created several artefacts for the Release Management processes.
• Conducted QA test management for the various test releases as part of improving the service quality of the applications.
Technical Development and Releases
• Worked on Pan European Licensing (PEL) system which involves creating and overriding licenses, loading and approving invoice files, validating the payments and distribution.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Partitioning and re-organization of table and indexes.
• Providing application support and addressing the issues raised by the users and providing relevant information.
• Responsible for resolving production job failures in the transactional batch schedule.
• Creation of users and Granting them privileges and roles.
• Optimization and tuning SQL queries using EXPLAIN PLAN.
• Created database objects such as Constraints, Database links, Database triggers, Indexes, Materialized views, Packages, Sequences, Stored functions and procedures, Synonyms, Tables and Views and proficient in advanced features in Records and Collection, Ref. Cursors, Nested tables and Dynamic SQL.
• Worked on optimization for faster processing such as making use of Bulk processing, analytic functions and providing hints to the queries.
• Hands on experience in Oracle Forms and report changes based on user requirements.
Responsibilities
• Managing all aspects of release process on repertoire application.
• Holds overall responsibility to plan, develop, coordinate and lead software release activities with application and support teams.
• Ensure the consistency of test environment and production.
• Maintenance of Oracle Production, Development, Testing and QA databases.
• Alert monitoring and Ticketing.
• End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.
• Create and maintain Release notes and track corrective actions of change related incidents and create new change request for all releases.
• Responsible to continually improve change/release processes hence to proactively minimize change-related risks.
• Responsible to gather business requirements, conduct gap analysis, identify issues and suggest workarounds.
• Responsible for setting up ITIL based processes in the Release Management space.
• Created several artefacts for the Release Management processes.
• Conducted QA test management for the various test releases as part of improving the service quality of the applications.
Technical Development and Releases
• Worked on Pan European Licensing (PEL) system which involves creating and overriding licenses, loading and approving invoice files, validating the payments and distribution.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Partitioning and re-organization of table and indexes.
• Providing application support and addressing the issues raised by the users and providing relevant information.
• Responsible for resolving production job failures in the transactional batch schedule.
• Creation of users and Granting them privileges and roles.
• Optimization and tuning SQL queries using EXPLAIN PLAN.
• Created database objects such as Constraints, Database links, Database triggers, Indexes, Materialized views, Packages, Sequences, Stored functions and procedures, Synonyms, Tables and Views and proficient in advanced features in Records and Collection, Ref. Cursors, Nested tables and Dynamic SQL.
• Worked on optimization for faster processing such as making use of Bulk processing, analytic functions and providing hints to the queries.
• Hands on experience in Oracle Forms and report changes based on user requirements.
Support, Manager, Processes, UP, Release manager, Processing, Performing, Online, Tuning, Production, Streaming, Software, Music, Development, Monitoring, Testing, Sql, Developer, It, TV, Stored procedures, Service, QA, Test, Management, Pl/sql, Test management, Database, ITIL, Oracle, Websites
2008 - 2010
freelance
ERP Consultant
Cognizant Technology Solutions (CTS).
Project: Chase Finance
Duration: Dec 2008 to Dec 2010
Role: ERP Consultant
The project involves application server collecting dealer application all over the country which provides a consolidated data repository. It will support several business processes and facilitate downstream analysis and enhancement.
Responsibilities
• Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Applied CPU patches.
• Worked with Data Pump to take the logical backups of databases.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Developed Advanced PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• Conferred with the client to determine the different user requirements and data needed to develop the application enhancements.
• PL/SQL coding for Exception Handling and Duplicate Data maintaining.
• Used materialized views for generating Data warehouse reports on OBIEE
• Rewriting and optimized large packages and complex trigger to improve the performance of the job processing time.
• Monitoring and scheduling the daily jobs using in built packages like DBMS_SCHEDULER and DBMS_JOBS.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Performed SQL and PL/SQL tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.
• Worked on Informatica Power Center tool-Source analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Responsible for troubleshooting and resolving issues related to data sourcing, data quality, ETL development, system performance, Quality Assurance and User Acceptance.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Writing SQL scripts to extract the data into a flat file from one server and transfer the data electronically to another server and load the data into target database-using SQL LOADER.
• Responsible for code review, report & metric preparations. Adherence to Quality research process and able to identify business & systems process improvements.
Duration: Dec 2008 to Dec 2010
Role: ERP Consultant
The project involves application server collecting dealer application all over the country which provides a consolidated data repository. It will support several business processes and facilitate downstream analysis and enhancement.
Responsibilities
• Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Applied CPU patches.
• Worked with Data Pump to take the logical backups of databases.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Developed Advanced PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• Conferred with the client to determine the different user requirements and data needed to develop the application enhancements.
• PL/SQL coding for Exception Handling and Duplicate Data maintaining.
• Used materialized views for generating Data warehouse reports on OBIEE
• Rewriting and optimized large packages and complex trigger to improve the performance of the job processing time.
• Monitoring and scheduling the daily jobs using in built packages like DBMS_SCHEDULER and DBMS_JOBS.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Performed SQL and PL/SQL tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.
• Worked on Informatica Power Center tool-Source analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Responsible for troubleshooting and resolving issues related to data sourcing, data quality, ETL development, system performance, Quality Assurance and User Acceptance.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Writing SQL scripts to extract the data into a flat file from one server and transfer the data electronically to another server and load the data into target database-using SQL LOADER.
• Responsible for code review, report & metric preparations. Adherence to Quality research process and able to identify business & systems process improvements.
Quality Assurance, Processes, Oracle Dataguard, Processing, Logic, Tuning, Power, Server, Storage, Development, Backup, Monitoring, Implementation, Transformation, Support, Sql, Data quality, It, Sourcing, Finance, Oracle database, Pl/sql, ETL, Data Warehouse, Database, ERP, Oracle, Research, Writing
2006 - 2008
freelance
Techno- Functional consultant
3i Infotech.
Project Name: Premia (Insurance product)
Duration: May 2006 to Dec 2008
Role: Techno- Functional consultant
The project involves the customization of the product Premia 10.4 (General Insurance) using oracle forms. It involves different modules i.e. underwriting, claims, billing, quotations, policies, notes, management and authorization. The objective of the project was to develop customized Premia product.
Responsibilities
• Worked as a Techno Functional consultant for the project VFB.
• Based on the FSD (functional specification document) PREMIA product is customized
• using Oracle Forms.
• Involved in developing different insurance modules like underwriting, policy screens, authorization and billing.
• Worked on various external validations using PL/SQL programs in oracle forms and developed packages, stored procedures, and form based triggers.
• Thorough hands on experience in SQL queries for DML operations and worked on database objects like tables, synonyms, sequences and views.
• Preparing Sql scripts and testing it in development area before deploying in production
environment.
• Documented the root cause analysis for all the bug fixes.
• Maintained check in and checkout process in PVCS and strict adherence to coding
standards.
• Prepared unit test cases and executed the test scripts test environment to ensure the screens developed are defect free.
• Attended trainings on PREMIA product and general insurance.
• Provided test support for System Integration Testing (SIT), live support to underwriting
module.
Duration: May 2006 to Dec 2008
Role: Techno- Functional consultant
The project involves the customization of the product Premia 10.4 (General Insurance) using oracle forms. It involves different modules i.e. underwriting, claims, billing, quotations, policies, notes, management and authorization. The objective of the project was to develop customized Premia product.
Responsibilities
• Worked as a Techno Functional consultant for the project VFB.
• Based on the FSD (functional specification document) PREMIA product is customized
• using Oracle Forms.
• Involved in developing different insurance modules like underwriting, policy screens, authorization and billing.
• Worked on various external validations using PL/SQL programs in oracle forms and developed packages, stored procedures, and form based triggers.
• Thorough hands on experience in SQL queries for DML operations and worked on database objects like tables, synonyms, sequences and views.
• Preparing Sql scripts and testing it in development area before deploying in production
environment.
• Documented the root cause analysis for all the bug fixes.
• Maintained check in and checkout process in PVCS and strict adherence to coding
standards.
• Prepared unit test cases and executed the test scripts test environment to ensure the screens developed are defect free.
• Attended trainings on PREMIA product and general insurance.
• Provided test support for System Integration Testing (SIT), live support to underwriting
module.
Unit test, Production, Underwriting, Insurance, Development, Testing, Support, It, Stored procedures, Sql, Test, Integration, Management, Pl/sql, System Integration, Database, Operations, Oracle
My education
?
-
2009
M K University University
Masters, Masters of Computer Applications
Masters, Masters of Computer Applications
?
-
2006
Ethiraj College for Women
BSc, N/a
BSc, N/a
?
-
2006
NIIT
N/a, Software Architecture
N/a, Software Architecture
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.
37900+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark