NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
Crop Picture
Auto Cropped
Note:Microsoft Internet Explorer restricts the images to be uploaded one by one. To upload multiple images at the same time please use other browser.
Moshe kolimi
Senior Pl SQL Developer
Banque Saudi Fransi - Riyadh, Saudi Arabia
Summary
Summary
9+ years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of Projects using ETL/Oracle (SQL, Pl-SQL).
Skills
• Active member in Banque Saudi Fransi Customer Profitability Function (BSF - CPP) Database Development Team.
• Treasury banking knowledge – Member of Credit Suisse Treasury Management.
• Health Care Experience - Order Line Analytics Project.
• Insurance domain knowledge – American Physician Insurance Company (PREMIA10i) insurance management and control system.
• Proficient in Oracle, Pl-SQL Extraction Transformation and Loading (ETL) concepts and have used various tools like Inofrmatica, Data Stage.
• Proficient in reporting concepts and have used tools like Business Reports.
• Intermediate level of knowledge in UNIX shells scripting.
• Extensive working experience in writing various modules like functions, stored procedures, cursors (Implicit, Explicit, REF),Packages, triggers and creating tables, views and materialized views using Oracle SQL and Pl/SQL.
• Proficient in Oracle tools and utilities such TOAD, PL - SQL Developer, SQL Developer.
• Experience in Data Warehouse design, Data modeling and schema design.
• Proficient in Oracle SQL Tuning Pl/SQL debugging.
• Experience in performance tuning using various types of Hints, Partitioning, Indexes, SQL Trace, TKPRO, and Explain plan.
• Good knowledge of the RDBMS concepts advanced Oracle queuing and Oracle Workflow.
• Extensive experience in client facing role and working in multicultural multi-geographic teams.
• Ability to be an effective team player and work under time constraints.
• Deep understanding of software development cycle (SDLC) and implemented various models like spiral, Agile (XP, SCRUM).
Projects
American Physician Insurance Company
Quote to Cash
Order Line Analytics
Credit Suisse Treasury Management
Banque Saudi Fransi Customer Profitability Function (BSF - CPP)
Experience
Senior Pl SQL Developer
Banque Saudi Fransi
Feb 2018
- Present
| Riyadh, Saudi Arabia
Education
Intel Institute Of science
Master,
Masters,
Masters in Science,
Masters in Science
American Physician Insurance Company
PREMIA10i a Product of well-known product of 3i-INFOTECH LTD in Insurance world. It is an enterprise-class insurance management and control system, which is backed by comprehensive financial accounting, reporting and analysis. It is designed to meet all the Requirements of the global insurance market and is flexible, easy to operate and implement and very powerful in both entry and retrieval of business-critical information. The feature-rich PREMIA makes all the functionalities of an insurance company streamlined and easy, be it rating, quoting, policy administration, billing, claims, reinsurance.
The core finality of this project includes conversion of reports to Business Objects from D2K and providing the ad-hoc reporting solutions for the end users.
Responsibilities:
• Impact Analysis of the proposed changes and Analyzing Technical specification
• Involving in the discussions with the customers for initial analysis
• Work on enhancement initiatives identified by client in existing application
• Coding SQL queries, PL/SQL Stored Procedures, Functions, Packages, Database Triggers
• Tuning SQL queries using Explain Plan, SQL Trace, tkprof, Indexes and hints
• Tune the Oracle SQL Queries and Configurations of the database
• Strong understanding and experience using Oracle Utilities/technologies
Environment:
Oracle 11g database, SQL,PL/SQL Toad, XML, Jira, PL-SQL Developer ,Unix Scripting ,Windows 7.
Quote to Cash
The Q2C [Quick to Cash] Strategic Program aims to improve and simplify the Q2C process through fundamental changes to Healthcare’s Supply Chain. The projects that are part of the Q2C program are targeting critical processes to improve the efficiency, effectiveness and transparency of the Q2C cycle.
This project is part of the Supply Excellence within Healthcare Commercial Operations. The Q2C SC Visibility work stream is an enabler for the other work streams residing within the Q2C program (e.g., planning, project management and installation, order management, catalog and quoting, etc.).
Responsibilities:
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Responsible for Analyzing and Implementing the Change Requests
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data
• Designing Tables, Constraints, Views and Indexes etc. in coordination with the application development team
• Tuned complex SQl queries and Stored Procedures for faster execution
• Conforming to the Quality Procedures and Standards related to the project
Environment:
Oracle 11g database, SQL,PL/SQL Toad, XML, Jira, PL-SQL Developer ,Unix Scripting ,Windows 7
Order Line Analytics
The OLA [Order Line Analytics] Strategic Program aims to improve and simplify the OLA process through fundamental changes to Healthcare’s Supply Chain. The projects that are part of the OLA program are targeting critical processes to improve the efficiency, effectiveness and transparency of the OLA cycle.
This project is part of the Supply Excellence within Healthcare Commercial Operations. The OLA SC Visibility work stream is an enabler for the other work streams residing within the OLA program (e.g., planning, project management and installation, order management, catalog and quoting, etc.).
Responsibilities:
• Involving in Extracting data from SAP BW team and transferring the data by using Oracle Objects like Procedures, Functions and Packages.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Experience in Working with fact and dimension tables
• Created Tables, Complex views, Materialized views, Force views, synonyms, Indexes, Stored procedures.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• 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
Credit Suisse Treasury Management
The Global Markets division offers a broad range of financial products and services to client-driven businesses and also supports Credit Suisse's global wealth management businesses and their clients. Our suite of equities, solutions and credit products and services includes global securities sales, trading and execution, prime brokerage and comprehensive investment research. Our clients include financial institutions, corporations, and governments, institutional investors, such as pension funds and hedge funds, and private individuals around the world.
Responsibilities:
• Involved in the maintenance and enhancement of the application.
• Maintain logical and physical structure of the database.
• Crating table space tables views scripts for automatic operations of the database activities.
• Coded various stored procedures packages and triggers to incorporate business logic into the application.
• Used the technical document to design the database tables.
• Data conversion from flat file to intermediate tables using SQL*Loader data mapping.
• Gather database and user level statistics and analyze overall system performance
• Designed/developed and system backups develop oracle stored procedures functions packages and triggers that pull the data for reports.
• Develop UNIX shell scripts to administer the system.
• Extensively worked with dynamic SQL composite data types & Global Temporary tables.
• Responsibly for purging and archiving the production database.
• Involved in interacting with users, error fixing by enhancing PL–SQL package stored procedure & functions.
• Performed logical back using export and import utilities.
• Developed database objects including tables indexed views sequences packages triggers and procedures to troubleshoot any database problem
• Involved in Unit testing stored procedure and functions.
• Created SQL Loader scripts to load data into the temporary stating tables.
• Created custo
Banque Saudi Fransi Customer Profitability Function (BSF - CPP)
Senior Oracle PL-SQL Developer Feb 2018 to Current
Banque Saudi Fransi Customer Profitability Function (BSF - CPP)
Riyadh
Banque Saudi Fransi
Banque Saudi Fransi is a full service commercial bank serving the local and international banking needs of its clients. It is a leading provider of comprehensive financial services and products in the Kingdom of Saudi Arabia and other markets.
Responsibilities:
• Creating new Procedures, Functions, Triggers, Materialized views, Packages simple ref &
Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Working on SQL*Loader to load data from flat files obtained from various facilities every day.
• Expertise in UNIX shall Scripts according to the changing needs of the projects and client
requirements.
• Wrote UNIX shell scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involving in continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote in stances.
• Developing PL/SQL triggers and master tables for automatic creation of primary keys.
• Creating Pl/SQL stored Procedures, functions and packages for moving the data from staging area to data mart.
• Extensively working to create new tables, views, queries for new enhancement in the application
• using TOAD.
• Creating indexes on the tables for faster retrieval of the data to enhance database performance.
• Involving in data loading using Pl/SQL and SQL*Loader calling UNIX scripts to download and
manipulate files.
• Extensively performance tuning SQL and PL-SQL tuning and application (OLTP & OLAP) tuning
using various tools like EXPLAN,SQL*TRACE,TKPROF and AUTOTRACE.
• Extensively involving in creating hints to direct the optimizer to