About Me
Total IT Experience : 16 years approx.
Primary Skills.
§ Implementation and production support approx 9 years on Retail Banking domain.
§ Also wo...
§ Also worked as a Oracle PL SQL Developer on Banking and ERP domain for 6 Years.
§ Oracle Forms 10g/11g and Reports 10g/11g for 2.5 years.
§ Freelancer / Self employed Oracle Faculty for about 3.5 years.
§ Oracle database Architecture, Physical and logical database design etc.
§ I have good hands on experience on writing business logic using Oracle PL SQL and advance PL /SQL features. ( ie functions, procedures, view, cursors, packages, Collections, application and database triggers, Materialized view , Table Function, Pipelined Table Function, Bulk collect ,Web util, Excel file data load /off load, Db link, Text_IO Package, UTL_File Package, Sql* Loader etc. ).
§ Having exposure to performance tuning features like Explain Plan, Tkprof, Sql Trace, AWR Reports, Statspack Reports, Automatic SQL Tuning, SQL tuning sets (STS),SQL Tuning Advisor, Automatic Database Diagnostic Monitor (ADDM), Sql Plan management (Plan Baseline), Hints , parallelism etc.
§ I have good functional knowledge of various business verticals on Retail Banking like Saving bank, Current accounts, Advance accounts, General Ledger, Profit and Loss(P & L), Loan accounts, Clearing, Deposits, Reconciliations, lockers, Outward / Inward cheques , Remittances, ALM etc. I have done manual unit testing of various modules whenever required.
Secondary Skills :
§ Good understanding of Oracle DBA 10g/11g/12c. Installation Database, clients/server , Data pump, Backups, Recovery Manager (Rman), Data Base Cloning, Data Guard, Grid Infrastructure Installation, ASM Features, Log Shipping, Log Mining etc.
§ Linux / Unix Basic commands, shell scripting, Unix / Linux O/S and Oracle DB Installations etc.
§ Good working knowledge of Informatica Power Center 8.6( ETL Process) Mappings, Various Transformation, Session and Workflows etc.
Show More
Skills
Database
Development Tools
Web Development
Operating System
Others
Software Engineering
Positions
Portfolio Projects
Company
Pantagon Artical VI project of UBS Investment Bank for US client. Worked as Sr Oracle Developer
Role
Backend Developer
Description
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.
Show More Show LessCompany
Integrated Hospital management System - IHMS
Description
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.
Show More Show LessSkills
Oracle Performance Tuning Unix PL/SQLTools
SQL Developer ToadCompany
Centralized Integrated Project Assistance System - CIPAS
Description
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.
Show More Show LessTools
Toad SQL Developer puttyCompany
SECR/HQ/IT/CM-IT/INET/Upgrade/2R - South Eastern Central Railway's ERP Project.
Description
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.
Show More Show LessSkills
Oracle Oracle Forms Oracle Reports IBM AIXTools
Toad SQL DeveloperCompany
Ebiz Frame 7.4( ACustomized Web Based ERP Solution)
Description
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.
Show More Show LessTools
SQL Developer Toad SVNCompany
Systemas Galilio. (Core Banking Solution, A Spanish application ).
Description
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.
Show More Show LessSkills
Oracle Forms Oracle Reports Oracle PL/SQLTools
PLSQL Developer SVNCompany
Total Bank Branch Automation ( TBA 7.1 Banker 123 )
Description
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.
Show More Show LessTools
Toad