Oracle Developer(forms,Reports),SQL, PL/SQL Developer,Oracle DBA

SUBBURAJ RAMASAMY

+***-*-********* PAN No: BFWPS*696N

EXPERIENCE SUMMARY

• Over 7 years of experience in the development and management of commercial applications

• Functional experience includes Integrated Financial and Personnel Information Management

System, Telecom Domain-(Fusion ASG, Ordinal V3.9,PDB(Portfolio Database), SecureId Card

Management Systems, BridgeMis, Classic SOE (EIN-604359948),21CCE Cust and Prod

Mapping, ATHENE –rPACS CIT Testing, Sitronics-Foris-BSS-OSS Support, IOMSS(LETS LB&

IB)-Banking Domain, Bank Muscat, DPWorld (PROMIS).

• Strong Skills include Oracle8/8i/9i, 10g, SQL, PL/SQL, (D2k) Forms6i, Reports6i programming

• Oracle 9i,10g Junior Database Administrator (DBA)

• Space Management, User Management, Schema Object Management, Backup recovery

(Logical Backup (export), Physical backup (cold backup, hot backup) and Recovery Manager

(RMAN).

• SQL Tuning( Explain plan, TKPROF,Trace)

• Attended OPT (Oracle Performance Tuning) Training.

• Attended UNIX Shell Scripting Training.

• Attended OSS/BSS overview Training.

• Attended DBA Training in Seed InfoTech & Sky IT Solutions.

EDUCATIONAL QUALIFICATION

1. Master of Computer Applications (M.C.A.) from Sourashtra College, Madurai, Madurai Kamaraj

University April 2001-India

2. Bachelors Degree in Mathematics (B.Sc.,) from P.M.T. College, Usilampatti, Madurai Kamaraj

University April 1998-India.

TECHNICAL SUMMARY

GUI : D2K (Forms 6i &10g, Reports 6i &10g)

DATABASE : Oracle 8/8i/9i, 10g, SQL, PL/SQL

OS : DOS, Windows 2000, UNIX Shell Script

WORK EXPERIENCE:

Dicetek LLC Dubai - (DP World Dubai) Feb2013 – Oct2013

Oracle Consultant –www.dpworld.com

Project Description:

Current Project : Terminal 3: OPUS interface and PROMIS Enhancements(Port Operation and

Management System)

1. The objective is to enhance PROMIS and Dubai Trade applications to

accommodate Terminal-3 requirement and also to build the interface for other 3rd party

application (OPUS, ARL, FLMS, and ABB) to exchange the data.

2. OPUS interface sends message to TOS to PROMIS and PROMIS to TOS

3. To provide the users of the system to do the terminal-3 containerized operations.

4. PROMIS Multi Terminal Vessel Call (MTVC) module should be enhanced to cater

segregation of containers between T1, T2 and T3.

5. System to be enhanced to transfer the containers from T3 to other inter terminal

facilities such as T1, T2, CFS & MECRC (vice versa)

Responsibilities

6. Involved in System Analysis and requirements

7. Designed the Fact and dimension tables in database

8. Created Packages,Procedures,Functions and Views and Materialized Views

9. Designed the Oracle Forms screen according to the user requirements

10. Using Oracle Application Server to interact the Forms and Reports

11. Created the User Requirement Document upon discussion with users

12. Created the Oracle SQL Scripts

13. Created the Reports as per user requirement

14. Requirement analysis and Client interaction

15. Unit level testing done

16. Perform immediate troubleshooting and corrections, as needed for critical production

problems.

Technical Environment: Oracle 9iAs & 10g, D2K (Forms10g, Reports10g),UNIX Shell Script

Toad,PLSQL Developer, TortoisesSVN Tool,Struts2.0,Jquery,Spring2.5.2, JBatis 2.3.0, hibernate 3.2.1,

Oracle Database (PL/SQL)

Gavs Technologies, Chennai - Muscat Aug 2012 – Sep 2012

Oracle Lead www.gavsin.com

Application Development - BankMuscat – Finance Dept

This is used by BankMuscat Finance Dept. Data received from T24 System is loaded into Oracle

database through Oracle SQL loader. This application is developed for MIS, CBO reporting,

Profitability System and Funds Transfer Pricing Units. The purpose of this system is as follows:

1. To generate reports for YTD, FTM and FTD values

2. Comparative analysis for current month and previous month balances Reconciliation

corporate summary.

3. Prepared Month on Monthly for Yield, Cost, Loans and Deposits Report

4. Quarterly & between T24 Dumps and RD files.

5. Finding new GL code and add with specific values in Master Tables.

6. Monthly realization, monthly business review, profit & loss statement by each Branch,

profit & loss statement annual balance sheet, cash flow, current assets & current

liabilities, inter plant key indicators.

Client : Bank Muscat, Oman. www.bankmuscat.com

Environment : Oracle 10g, Forms 10g, 10g AS and UNIX

Responsibilities

7. Involved in System Analysis and requirements

8. Designed the Fact and dimension tables in database

9. Created Procedures, Functions and Views

10. Used Oracle Temporary Table to store intermediate results

11. Designed the Oracle Forms screen according to the user requirements

12. Using Oracle Application Server to interact the Forms and Reports

13. Created the User Requirement Document upon discussion with users

14. Created the Oracle SQL Scripts

15. Created the Reports as per user requirement

16. Preparation of Test Cases and Testing

17. Designing the database for entire system

18. Requirement analysis and Client interaction

19. Unit level testing Integration testing and System testing done

20. Perform immediate troubleshooting and corrections, as needed for critical production

problems.

Trial Balance Bifurcation

This Application is developed for Bank Muscat Finance Dept. Loans and deposits file

provided by finance department are loaded in Oracle database through SQL loader. This

data is grouped based on GL code, Company code and currency into temporary tables.

On a GL level, balances in temporary tables and Dump1 are compared. Differences are

updated in the temporary table against identifier “9”. Non matching average and closing

balances are updated from Dump1. These updations are based on identifiers in loans

and deposits file. Once finished, GL description is added for each GL code. Report is

generated and is sent to Manager-Profitability systems.

Client : BankMuscat, Oman. www.bankmuscat.com

Environment : Oracle 10g, Forms 10g, 10g AS and UNIX

Responsibilities

1. Involved in System Analysis and requirements

2. Designed the Fact and dimension tables in database

3. Created Procedures, Functions and Views

4. Used Oracle Temporary Table to store intermediate results

5. Designed the Oracle Forms screen according to the user requirements

6. Using Oracle Application Server to interact the Forms and Reports

7. Created the User Requirement Document upon discussion with users

8. Created the Oracle SQL Scripts

9. Created the Reports as per user requirement

10. Preparation of Test Cases and Testing

11. Designing the database for entire system

12. Requirement analysis and Client interaction

13. Unit level testing Integration testing and System testing done

14. Perform immediate troubleshooting and corrections, as needed for critical production

problems.

Computer & Systems Engineering Company, Riyadh, Saudi Arabia May 2011 – Jan2012

System Analyst www.cse.com.sa

Project 1:

IOMSS-Invest Order Management and Settlement System

Project Name: LETS & IB (Local Equity Trading & Settlement and IB Systems)

Running (Live): Leading Banks like SAIB, AFG and Dutch Bank, Meryl Lynch Bank

Project Description:

1. Local Equity Trading & Settlement is Stock Exchange/Brokerage (Tadawul) system.

LETS System facilitates the Bank to

1. Perform the Trading with the Exchange/Market as per Capital Market Agency (CMA) Rules and

Regulations.

2. Manage the traded orders from the customers

3. Disseminate Stock Prices from the Exchange to Banks

4. Settle the traded orders as per the Tadawul notification and Bank’s policy

5. Manage Customer portfolio in accordance with the exchange

6. Facilitate Margin lending for Trading purpose

In order to facilitate the above, the LETS system interacts with the following external

systems:

1. SAMA TWS Gateway server for the purpose of trading

2. BANK HOST SYSTEM for the purpose of Customer Account's status, Balance verification and

Financial settlement

3. The LETS system comprises of four sub systems namely

4. Front Office Trading System.

5. Back Office Settlement System.

6. SAXESS FIX Gateway Interface.

7. eTadawul Interface (LETS-ETI).

Responsibilities:

1. Individually involved, analyzed and developed patches/enhancements into LETS systems.

2. Developing & Maintenance the Application using Forms 6i and Reports 6i

3. Design, development, debug and testing of Oracle PL/SQL scripts as per the requirement

Assignments / Joint-work with CSE Team:

1. Worked as a consultant at various client places like SAIB, AFG and Dutch Bank, Merryl Lynch

Bank

2. Data Centre Sever Support to AFG.

Technical Environment: Oracle 9iAs & 10g, D2K (Forms6i, Reports6i), UNIX Shell Script.

Tech Mahindra Ltd, Chennai (SEI-CMMI L5 COMPANY) (May 2006 - April 2011)

Technical Associate

Project1:

Sitronics – Foris -BSS-OSS Support (June2010 –April2011)

Project Description:

1. FORIS OSS/BSS providing operational and billing system for wireless telecommunication

operators / service providers.

2. Have involved in various modules involved in end to end Telecom billing. Mainly handling RD,

Configuration TP and Services, Foris Reports Modules.

3. As a responsible member of RD Module checking the CDR Report Processing and fixing the

issues whenever arises.

4. Being a active member of RD Module, Involved in configuring new circles, franchises and other

related for a particular Service Provider.

5. As a member of Foris Reports, Generating various reports as per the business requirement and

also writing stored procedures for customer GUI.

Responsibilities:

1. Technical Support team and Development, Recruitment Panel.

Technical Environment: PL/SQL developer, SQL Developer, Toad, SQL, PL/SQL

Modules Handled: RD, Foris Reports

Project 2:

ATHENE rPACS CIT Testing (April2010-June2010)

Project Description:

1. Athene (Source System) is a part of the overall IP21C solution, which involves the consolidation

of network inventory of MPLS, IP VPN, IPVPN IP Enabled & BTNET services for BT UK.

2. As part of Athene getting migrated into rPACS, it will start supporting customer port allocation for

MPLS UK.

Responsibilities:

1. Updated Sprint Backlog and Defect reports.

2. Managed testing activities using Quality Canter.

3. Data Migration testing done.

Project 3:

BT17- BTGS-21CCE Customer and Product Mapping (Sep 09 – April10)

Client: British Telecom

Role: Data Quality Analyst,

Project Description:

1. This project mainly focuses on the data quality and data cleansing on customer data which has

been taken from 11 different source systems such as CSS, Orion, Classic, CAM etc.

2. The main idea behind this customer mapping is to filter out replicates/duplicates from different

source systems and to map the customers with the correct world key.

3. Analysis of customer master file, which contains the data from 11 different source systems.

4. Involved in customer mapping.

5. Provided recommendations and involved in data cleansing. Creation of db links.

6. Extraction of data using Export-Import and SQL loader utilities.

7. Generation of Control files.

Technical Environment: SQL, PLSQL, Oracle 10g, SQL developer, Toad

Project 4:

Project Name: Classic SOE (Mar 2009 – Sep 09)

Project Description:

1. SOE-Classic is an order management, workflow and trouble ticketing application based on the

Clarify CRM COTS product suite.

2. Classic is the Standard Operating Environment (SoE) system used by BT Global Services to

provision BT MPLS/ harmonized circuits and routers.

3. The Trading Gateway Unisys-CPE interface will provide automated facilities for DSL provide

orders.

4. The system supports sales Offer to Order (O2O), order entry, order management, order

processing (OE&P) through service delivery;

5. Also handles creation, management and closure of trouble tickets (TT) for fault management.

6. It will therefore support multiple business functions across BT Global Services as well as

Distributors and Suppliers.

7. In order to create one Single Operating Environment (SOE), all BTGS offices will eventually use

the same system and provision their orders in the same way. To achieve this, a standard service

delivery process has been created implemented in CLASSIC.

Responsibilities:

1. Attended the Knowledge Transfer Sessions and shared Knowledge with the team members

2. Prepared design Document based on the Understanding of various Interfaces interacting with

Classic

3. Support the technical issues.

Technical Environment: Clarify CRM 10.1, Oracle 8i, Web Logic, Tuxedo

Project 5:

Project Name: Bridge MIS Project (Dec2008 - Mar2009)

Project Description:

BRIDGE MIS is a management information system, which is used to produce various reports for the

bridge Forum. Bridge MIS allows accurate and timely reporting on performance in all areas namely:

1. Problem Management - This area deals with problem records. The problems raised by customers

are raised as problem records in bridge (data warehouse) and are assigned for solution. Even the

desktop repair etc. is part of problem management.

2. Change Management - The change management is about managing major changes such as

change or server etc. Change management makes sure that different departments can plan their

activity as per the change schedule and thus the change will have minimum impact.

Responsibilities:

1. Actuate and Discoverer is used for report generation while Toad is used for other development

work (as developing new SQL-PLSQL queries and executing them).

Technical Environment: Oracle9i and UNIX Shell Script, Actuate Reports, Discoverer, Toad

Project 6:

Project Name: Secure ID Cards Management System (16th Apr-2007 – Dec’08)

Project Description:

1. Secure ID Transaction System is used to perform and to record the SECUREID Card transaction

within the project.

2. All IDU’s Head, PM, Security-Coordinator, Senior Project Manager and ADMIN (who is authorized

to distribute Secureid cards to all the security Co-Coordinators) can able to view, add and modify

their SECUREID data.

3. System helps in transferring the cards from one person to other on on-line and it also helps when

PM can request the ADMIN for new SECUREID cards,

Responsibilities:

1. Involved this project from scratch for Oracle PlSQL and DBA Activities

2. Involved in Bug Fixing, Enhancements and implementation.

3. Involved in production, implementation & support.

Technical Environment: Oracle 8i and 9i using DBA Activities and .Net, Oracle DB & Tools, Design &

Development using Oracle PL/SQL, SQL*Loader, Import and Export, Toad.

Project 7:

Project Name : Portfolio Database(Oct 2006 - Apr2007)

Client : British Telecom (BT.Com), UK

Team Size : 10

Project Description:

1. PDB is a full-fledged Application, which covers the following functionality.

2. PDB manages BT's products & services.

3. A data storage entity for BT’s products & services.

4. Product Lifecycle Management through User Interfaces

5. The Portfolio Database (PDB) was designed to provide BT with a system to manage BT's

products and services from the "cradle to the grave".

6. New products can be captured on PDB while they are simply ideas in the heads of product

managers.

7. PDB then provides a mechanism to allow these products to be tested, and then, as required,

released to the downstream systems.

8. Once the product is launched new versions of the product can be developed, tested and

launched in the same manner.

9. PDB also allows products, or new version of products, to be planned for release in the future.

10. In addition to basic product information, PDB is also holds information that is required to allow the

downstream systems to deal with the products

Responsibilities:

1. Team Member, Analysis, design, develop, coding and documentation for the requirements

2. Provide second line support for PDB, including handling faults raised by users and carrying out

various proactive maintenance activities, to minimize fault levels.

3. Monitoring the applications process and reporting to clients according to business requirement

4. Reducing the large number of outstanding faults when the project was initially taken over

5. Building up a very strong customer support and communication structure

6. Developing Help pages (HTML pages) for the application using FrontPage2000

7. Developing & Maintenance the Application using Forms 6i and Reports 6i

8. Design, development, debug and testing of PL/SQL scripts as per the requirement

9. In case of error / bug, analyze root cause and prepare documentation and working with

development team for bug fixing.

10. Making the Forms Build for using Install Shield Devastation 9.0 for PDB using Install Shield Dev

Studio 9.0

11. Maintaining the File version in VSS databases.

12. Followed by Agile Project Management Process

Technical Environment: SQL, PL/SQL, D2K(Forms 6i, Reports 6i), Oracle 9i, Toad, SQL*Plus,

SQL*Loader, UNIX, Pro*C, FTP 1.0, PVCS, VSS, MS Access 2003 and Install Shield Dev Studio 9.0

Project 8:

Project Name : Ordinal V3.9 (Sep-2006 to Oct-2006)

Client : BT UK

Component Type : Ported Number Maintenance & Point code Forms.

Component Description : This form allows viewing Ported Number details

Project Description:

1. Porting information in ORDINAL database. The form will also allow viewing every data change

within the system, giving details of user identity, date and time that the data was modified etc.

Data may also be logically 'deleted'.

2. Point code allows the user to enter the information of Point code. Point code information in

ORDINAL database. The form will also allow viewing every data change within the system, giving

details of user identity, date and time that the data was modified etc.

Responsibilities:

1. This Point Code maintenance form I have developed some enhancement and modifications work

as per the latest LLD (Ordinal v3.9).

Technical Environment: UNIX, Oracle 8i and forms 6i, Toad.

Project 9:

Project Name: Fusion ASG (May 2006 to Sep-2006)

Client: BT UK

Fusion ASG is an Application support group for monitor and supports, the daily routine activities the

Mediation Project. This uses the fusion works as tool. The activities are subject to both Belgium and

Intelliplus.

Responsibilities: - Belgium

1. Monitor the collection of files and Monitor the parsing of files. Check for the swr & LNP snapshots

refresh. Verify Collector logs and Correlator logs for any messages of Severity 1 and 2

2. Check for Old Files in Download, IN and Processing directories

3. Check for any zero byte file in archive

4. Move the swr control and event files to genswr and ftp the rest Geneva files to Phoenix Geneva

system

5. Remove the Geneva files from delivery directory after ftp the Geneva files to Phoenix Box

6. Check the number of records in BL_ERROR_STORE, BL_FILTER_STORE

7. Check the generation of Daily Integrity report & check for any errors in the report

8. Check fusion integrity messages on MedAdmin Website

9. Close the daily routine tasks on Medadmin website.

Responsibilities: - Intelliplus

1. Monitor the collection of files. Monitor the parsing of files

2. Check for Old Files in Download, IN and processing directories

3. Check for any zero byte file in archive

4. Archive the Input files.

5. Check the number of records in BL_ERROR_STORE

6. Check fusion integrity messages on Medadmin website

7. Close the daily routine tasks on Medadmin website

Technical Environment: Windows 2000 Prof, UNIX, Oracle 9i.

Ramco Systems Ltd (SEI-CMMI L5 COMPANY) Chennai (Aug 2005 - Mar 2006)

Programmer

Client: Airport Authority of India - New Delhi

AAI_IFPIMS (Integrated Financial and Personnel Information Management System)

1. Airports Authority of India (AAI) has today a number of disparate systems developed

Independently by various departments that are used for day-to-day operations.

1. The functioning of these systems is specific to a section's requirement.

AAI faced limitations with the existing applications and has identified

certain drivers for changes like

1. Standardization of Business Processes in Finance, Personnel and Administration

2. Complete Integration of HR and Finance Processes

3. Movement of Web Based technology

4. Movement to a flexible and scalable Solution.

Responsibilities:

1. Database designing, According to AAI requirements, developed Reports.

Technical Environment: UNIX, RVW, Oracle 9i, Oracle Reports 6i.

Personal Details:

Passport Number : J4038021

Mobile Number : +971-0-528021529

Email : **********@*****.***, **********@*****.***

Skype ID : subburaj.ramasamy

Contact this candidate