SUMMARY:

Oracle Certified advanced PL/SQL professional with experience in Design, Analysis, Development, Support and DBA functions.

SKILLSS:

RDBMS Version: ORACLE 11g

RDBMS Tools: ORACLE *Forms 9i, ORACLE Reports 9i

PL/SQL: SQL Plus, SQL*Loader TOAD, PL/SQL developer. PowerBuilder 6.5, Pro*C, C++, Business Objects xi, Informatica Power Centre 7.1.1, ORACLE Developer 2000, Oracle Designer Tool 9i

Languages: C, SQL, Java and UNIX Shell Scripts.

OS: UNIX, Windows NT

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Loading, deployment, testing and quality assurance of MRP applications on QA systems.
• MRP is a very complex application dealing with applying Confidential algorithms to traded deals and monitoring counter party risks.
• Installation of last minute patches in the form of Java TAR files.
• Deployment of the tested version of the MRP application on the LIVE systems .
• Translating Standard operating procedures for the deployment procedures in English from French.
• Creation, running and monitoring of tools to deploy the production snapshot dumps on the QA systems to facilitate the testing of the RDC part.
• Regular interaction with other teams like Development, Pricing, Feeding, DBA and keeping track of dataflow between different teams.
• Monitoring the Bangalore branch of the QA - MRP team as a Single-point-contact.

Confidential

Responsibilities:

• Integration of the newly bought Fortis bank entities within the existing BNP FXO CIB system f
• This consisted of setting up and regularly keeping the FORTIS environment refreshed and in sync with the LIVE PROD database,
• Generation of static data like currencies, portfolios, exchange rates etc., for each entity.
• Creation and flowing of Interface information between various systems and testing the Option / Swap /Futures deals through the FXO back end systems and their subsequent Amendments / Cancellations.
• Monitoring the batch jobs which calculate and post the cash flows, confirmations etc.,
• Managing data flow of information to the OMR upstream systems .The OMR system is mainly used for accounting purposes .
• Testing and implementation of exotic options transmission from the FXO back office to other systems for Fortis Poland. Poland is the first European site to use options with this version of OMR .
• Generation of PV (Present Value reconciliation) files for all Fortis entities. This file is then used by other teams to do the revaluation for FX transactions (forward and swap) which will be sent to Accounting.
• Generation of data files of the tested deals to be sent to other parallel systems for integration like CFT / Socrates in the desired format.
• Managing the day to day Maintenance and Emergency, client support, logs and problems within the FXO Back office systems. Analysing the cause, coding and testing, testing and implementing the solutions for the same.

Confidential

Responsibilities:

• First time and subsequent Installation and deployment of the application and database versions on various platforms and ports for bespoke
• Day to day client interaction, consultancy, recording, logging, analysing and qualifying the bugs / enhancements for the projects gone live.
• Interaction with the Indian and Confidential consultants / developers in English and French on a daily basis.

Confidential

Responsibilities:

• Development of back-end routines using PL/SQL packages, fine tuning of the same.
• Coded enhancements to Forms and reports
• Coding enhancements and testing reports using Business Objects tool which was used to forecast, run and maintain weekly and monthly reports.
• SQL (TSQL & PL/SQL) programming and complex stored procedure development
• Assisted in successful rollout of new mission critical systems
• Involved in full life cycle of Business Objects reporting applications.
• Created Auditor reports and tracked user access of reports and Universes.
• Debugging and coding enhancements and fixed bugs for new releases.
• Writing and executing test plans (both unit and system).
• Providing Support for new implementations.
• Running weekly and monthly MIS reports.

Confidential

Responsibilities:

• Migration of more than 300 Pro C programs from version Oracle 7.2 to Oracle 9i / and Oracle 10g. The migration and testing was done on UNIX platform.
• Migration of Forms from Oracle 6i to web enabled 10g version. Tested the same on Application Server 10g. These forms were compiled and stored on a LINUX machine.
• The source code control system used for GUIs was PVCS.
• Migration of Reports from 6i to 10g vsion which included calling external software like MS word and MS Excel.
• Coded enhancements in Forms and Reports.
• Installed Webutil software and converted all OLE (Object Linking and Embedding ) calls to use Webutil packages.
• Wrote and maintained object libraries along with the main forms.
• Fine tuning, running and maintenance of back end PL/SQL routines, database triggers and packages using TOAD software.
• Migration involved compilation, writing test plans, testing, giving user acceptance demos and documentation of the module.
• Using Matrix Diagrammer tool of Oracle Designer 9i to create and maintain test database objects to enable testing of migrated codes.
• Oracle Developer tool was used for maintenance of Oracle forms and reports.
• Maintenance and running of batch jobs through UNIX shell scripts.

Confidential

Responsibilities:

• Database designing, Analysis, Design, Coding and Testing of front-end screens and reports using Oracle Forms and Reports for Static Data Entry and Query
• Development of back-end routines using PL/SQL packages, fine tuning of the same.
• Coded enhancements to Forms and Reports on day to day basis
• Wrote new forms and reports.
• Debugging and coding enhancements and fixed bugs for new releases.
• Writing and executing test plans (both unit and system).
• Providing Support for new implementations.
• Data extraction and formatting.
• Interaction with customers on a day-to-day basis.
• First line support of the internal application SUMMIT which involved interacting with the end users, taking their requirements, analysing, prioritising, coding, releasing and providing implementation support.

Confidential

Responsibilities:

• Was involved in writing new Forms and Reports from the scratch for bespoke clients.
• Programmed Back-end routines using C, UNIX Shell, Pro C, PL/SQL packages and POWERBUILDER Hotlinks.
• Wrote reconciliation reports and business views using Oracle Reports Designer.
• Database designing and DBA activities like creation of data base procedures, triggers and functions, tables, constraints, import/export, fine-tuning of systems and SQL statements.
• Coding and maintaining different versions for bespoke clients through Source Code control systems.
• Maintenance of back end systems like Reuters price feed and SWIFT messaging systems.
• The entire RFE front end was maintained in PowerBuilder datawindows.
• First line support of the applications RIMS and RFE which involved interacting with the end users, taking their requirements, logging, analysing, prioritising them, coding the enhancements or bugs, UATs, releasing and providing implementation support.

Confidential

Responsibilities:

• Managed teams of three - four candidates involved in development/support.
• Collected/designed functionalities based on user requirements.
• Interacted with external consultants for development/coding.
• Database designing and DBA activities like creation of data base procedures, functions, packages, constraints, triggers, tables and indexes, fine-tuning of systems and SQL statements, installation and maintenance of software on different machines for different users.
• Coding and maintaining different versions of code through Source Code control systems.
• Support of the applications which included interacting with the end users, taking their requirements, logging, analysing, prioritising them, doing an impact analysis, coding the enhancements or bugs, testing, giving user acceptance demos, releasing and providing implementation support for the same.
• Mentoring newcomers.