My roles involve understand businees requirement of client, refers FRDs /BRDs documents , do development, enhancement and maintenance of ICRM project of UBS Investment bank using Oracle PL SQL and its advance features. Checking status of batch jobs (Autosys jobs) as well as correction and enhancement of the same if business required.

Worked as Oracle PL SQL Developer on Rajasthan Government's   Project Name - Integrated hospital managements(IHMS) and EHR (Electronic Health Record)for client Rajcorp info Service limited Jaipur. 

Worked as Oracle Technical Consultant and migrated oracle forms/report (6i) to Oracle Forms /Reports (12c) version and providedDevelopment and Maintenance Support to one of leading ERP system (Centralized Integrated Project Assistance System, CIPAS) for big govt. Enterprises.

Development and Support of ERP application based on Oracle Fusion Middleware, Monitoring of various Oracle 11g Databases on IBMAIX 7Bled Server, NetVault Tape Backup,Rman backups and Data Dump backups, archive log application, IBM Bled server logs, san disk status  etc.

ERP Application contains various modules ie HR, Finance, purchase, sales, Inventory, production, Fixed Assets etc. I have been worked on modification of baseline forms as per client requirements (ie Gap analysis). I have designed new Forms, Reports and migrated Oracle forms from version 6i to 10g/11g. I have written business logic using oracle PL SQL ( ie  functions, procedures, view,cursors, package, application and database triggers, Materialized viewWebutil, Excel file data load /off load,Db link, Text_IOPackage, UTL_File Packageetc). I have also written tests cases peer review and unit testing on project’s demand.

I have worked with core development team to migrated business logic defined on front end, oracle forms6i to backend on Oracle 10g Database. My work involved understand the business logic and write program units accordingly, I have extensively writtenCursors ,Ref Cursors, Views , Procedures, Functions,Packages, Database and  Application Triggers, Bulk Collect, Collections to migrate complex business logic. In project development we had strictly adhered to object naming convention and coding standard. Used VSS(visual safe source) for version control purpose. Mywork also involved techno -functional role, like modules functionality and manual unit testing of various modules (CASA,loan, FD, General Ledger, advance accounts, P&L etc) of CBS application.

Worked on implementation (i.e. Branch Rollout) of highly parameterized, multilingual, multi-currency Banking business application to client side. I have done data conversion  to migrate from legacy system to new business application. I have extended production /   operation support and software training to esteemed clients. Software support involved assisting bankers during SOD(start of day), BusinessHrs, EOD(end of day),month end, half yearly / yearly closing activities and other issues as well.During project I have worked on multiple roles like crises management, manual Unit testing of application modules andBusiness logic migration etc as and when required by company.