About Me
- Around 16+ Years of IT experience in BFSI (Banking Financial Service and Insurance) sector.
- Working Knowledge in projects compliance to SEI CMM and ISO standards.
- Worked on various phase of software development life cyc...
- Worked on various phase of software development life cycle.
- Have Hands-on experience on Production Support Environment
- Excellent working skills in Oracle, PL/SQL, Pro*C, UNIX
- Excellent Knowledge in Oracle 8.x / 9i - Performance Fine Tuning
- Excellent Knowledge in Oracle 10G – Migration
Skills
Database
Development Tools
Software Engineering
Operating System
Others
Networking & Security
Web Development
Software Testing
Portfolio Projects
Company
Project: Merck – Merck Research Laboratory – Clinical Trial Applications. Oracle & PLSQL,Unix,Shell
Role
Backend Developer
Description
Project: Merck – Merck Research Laboratory – Clinical Trial Applications.
Roles and responsibilities: Onsite Support Lead
- Support lead for Clinical Trial applications.
- Working with the business team in understanding the new requirements.
- Supervising the onsite team of 5 resources and offshore team of 6 resource and overall management of 11 resources.
- Understanding complex business application and Participate in Business Meeting for Requirement Gathering.
- Creating Complex PLSQL components to meet client requirements.
- Responsible for all major and minor enhancements.
- Collection and Presentation of metrics.
- Working on the daily day to day activities, and production issues.
- Working on the new enhancements development works.
- Architectural design review of the systems.
- Configuration and Release management using remedy workflow system.
Tools and Technology used: Oracle & PLSQL,Unix,Korn Shell Scripting
Show More Show LessSkills
Oracle PL/SQL UNIX Shell ScriptingCompany
Project : ADS – Advance Detective System for FINRA
Role
Backend Developer
Description
Project : ADS – Advance Detective System for FINRA
Commercial Banking System for WORLD BANK
Roles and responsibilities: Developer, Onsite Coordinator, Project and Support Lead
- Performed data analysis and created conceptual, logical and physical data model
- Developed numerous programs using PL/SQL packages to do the validations
- Extensively worked on Performance Tuning Project to bring down the execution time of BATCH/EOD Processors
- Designed and developed different database objects containing functions, triggers, store procedures to manipulate database of the application
- Used materialized view for reporting purpose
- Created DB triggers to update in master tables
- Used SQL*LOADER to upload the information into the database
- Responsible for SQL tuning, Bug fixes and Testing
- Handle Client Escalation
Tools and Technology used: Oracle, PLSQL ,Pro*c,Pro*c++,Unix,SQL Loader
Show More Show LessSkills
Oracle PL/SQL UNIX Shell ScriptingCompany
Project : Ashok Leyland Corporate & Finance Applications
Role
Backend Developer
Description
Project : Ashok Leyland Corporate & Finance Applications
Roles and responsibilities: Developer and Support Lead
- Support lead for corporate, & finance applications.
- Worked on gathering new requirements for enhancements.
- Support applications integrated with Oracle Forms & Reports
- Worked as a developer on multiple new enhancements for these applications
- Worked with the business on various requirements to the existing applications.
Tools and Technology used: Oracle and PLSQL, Oralce Forms & Reports, Unix
Show More Show LessSkills
Oracle PL/SQL UNIX Shell ScriptingTools
Unix CommandCompany
Project : CACS ( Computer Aided Collection System ) for CITIBANK
Role
Backend Developer
Description
Project : CACS ( Computer Aided Collection System ) for
CITIBANK
Roles and responsibilities: Developer and Tester
- Worked on PLSQL – DBMS OBFUSCATION to Encrypt the data
- Implementation of METHOD4 in PRO*C
- Modified/Develop the database structure as per the client requirements
- Developed packages, stored functions, procedures and database triggers
- Used Ref cursors to retrieve data from database
- Worked on creating the test scripts, and tested the applications by performing regression and volume testing
Tools and Technology used: Unix, Pro*C, Shell Scripting
Show More Show LessSkills
Oracle PL/SQL Shell Scripting