We provide IT Staff Augmentation Services!

Developer Resume Profile

Experience Summary

  • Twelve years of IT experience with good understanding of Software business processes and Software Development Life Cycle SDLC .
  • Strong technical expertise in Oracle 8i,9i,10g,11g and PL/SQL
  • Expert level skills in PL/SQL in creating SQL scripts, Functions, Stored procedures, Cursors, Triggers, Collections, Packages etc.
  • Experience in building several applications using Oracle Application Express APEX with AJAX, jQuery, ExtJS and javascript.
  • Experience in performance tuning using oracle plan table.
  • Extensively used utilities like TOAD, SQL Developer, PL/SQL Developer and SQL Loader.
  • Experience in Unix shell scripting
  • Hands on experience with TortoiseSVN, VSS Version control tools.
  • Extensive experience in Visual Basic 6 programming and Crystal Reports 8.5
  • Exposure to C .NET , VB .NET , Sybase and SQL Server programming.
  • Interaction with client/end user during design, development and maintenance of the projects for analyzing user requirements and ensuring functionality.
  • Exposure in Project management, Configuration Management system.
  • As a Lead developer led internal and offshore development and support teams.
  • Conducted Knowledge transfer sessions to new team members, solution designing, problem debugging, database overview,
  • project support process.
  • Worked as a Team Lead managing team Schedule, allocate work and monitor tasks to ensure delivery of
  • project/ module on schedule.
  • Conducted technical interview and helped to recruit resources to the project/organization.
  • Team oriented individual who brings a high level of integrity, enthusiasm and commitment to quality to all initiatives.

COMPUTER KNOWLEDGE:

  • Languages: Visual Basic 6.0, PL/SQL
  • Databases: Oracle 7 through 11g , exposure to Sybase and SQL server
  • Tools and IDEs: Oracle APEX, Toad for Oracle, SQL Developer, PL/SQL Developer
  • Operating Systems: Windows XP/2000/NT/9x, UNIX
  • Versioning Tools: VSS, Subversion
  • Web Technologies: Exposure to ASP .NET, C .Net
  • Scripting Languages: Javascript , Unix Shell Scripting.

EXPERIENCE:

confidential

Senior Developer

  • Confidenial MBAPEX Mortgage Banking APEX owns 70 applications to serve day to day activities of Mortgage Banking group. These applications are constructed in multiple schemas on Info1 that have IT Control Gaps. The main objective of the project is to address items listed below with respect to all relevant APEX applications owned by MBAPEX through one of the following remediation work streams: Remediation, Migration, Decommission, or Rewrite
  • The following control Gaps have been identified and will be remediated at each individual application level.

1. Remediation/Migration of Delphi Applications

2. Remediation/Migration of ESM

3. Migration of Oracle DBMS Jobs to Control M

4. Convert usage of FTP to SFTP

5. Privileged Access Control Remediation

6. Remediation Of Access Admin Risk Control

7. Remediation Of Data Backup Risk Control

8. Remediation Of Change Control Risk Control

9. Remediation Of Capacity Planning

10. Remediation Of Data Confidentiality Risk Control

11. Remediation Of Data Integrity Private to Public db links risk control

12. Remediation Of Project Assurance risk control

Technologies Used: Oracle 11g, PL/SQL, Oracle APEX 3.2, Tortoise SVN, Unix Scripting and Toad.

Responsibilities

  • Gathering/Analyzing the audit requirements
  • Propose high level remediation plan and attain approval
  • Preparing the low level design document and test cases.
  • Coding, Unit testing and Integration testing
  • Supporting Performance/UAT testing
  • Support DR testing
  • Promote and support when the changes moved to production.

confidential

Senior Developer

  • Oracle Application Express Apex is a rapid web application development tool for the Oracle database. Application Express can be used to build web-based applications from a standard web browser web-based development environment . I was involved in the development of the following applications for the Mortgage Banking Domain.

1 Telephony source code database

This application is used to maintain the toll free numbers for the call centers. This has the links to various services offered by the JPMC loan originations department.

2 Credit quality subordinations tracking

  • This application has been built for the National Subordinations group. This application is used to track the subordination requests from both internal and external lenders needing subordination of a chase home equity product. The application has the built in features to randomly assign the requests to the processors. The application has an interface to the oracle reports server through which the legal documents are printed.

3 Credit Administration

This application is used by the Loan Processing group for tracking the various exceptions for every loan account.

4 Check receipt log

This application tracks checks between Retail branches and the back office processing groups for Treasury. This application has an interface to BI publisher using which the transmittal reports are printed.

5 Close By Phone

This application is used to schedule and track history of appointments made by loan centers for specialists to perform loan closings over the phone with Chase customers. Application provides complete calendar management for loan closers on a daily basis.

Technologies Used: Oracle PL/SQL, Oracle APEX 3.2, Tortoise SVN, Unix Scripting and Toad.

Responsibilities

  • Analyzing the requirements and preparing the design Documents
  • Development
  • Testing Unit / Integration of the application
  • IST/UAT Support and addressing the technical issues
  • Identifying Application problems
  • Production support

confidential

Senior Developer

  • REVPRO web portal helps the AE's of J.P. Morgan Chase Home Mortgage to model a deal between the bank and the customer. The bid revenue generated will undergo multiple levels of approvals workflow approval system to become active loan. This revenue will be based on the SRP calculations, OMSR base price, other adjustment prices and subsidies determined by the US government, incentives and rebates. Bid revenue is totally based on the finance assumptions i.e. expected revenue.
  • The application development is handled through the JPMC .NET Foundation 2.0 which is commonly used throughout all the .NET projects in Home Mortgage division. This foundation is derived from .NET framework 2.0 which encompasses common .NET functionalities and user defined controls.

Technologies Used: ASP .NET 2.0 , C .NET , Crystal Reports 2008, SVN, SQL Server 2000.

Responsibilities

  • Requirements analysis
  • Design document preparation
  • Enhancement
  • Testing Unit / Integration of the application
  • Identifying Application problems

confidential

Team Lead/ Module Lead/Team Member

  • International/Domestic Collections System IDCS is an application system of JP Morgan Chase, Houston, Texas, USA and its function is to collect on foreign and domestic collections items forwarded to the collections department from customers, bank branches or check processing
  • The project was executed in the following phases.
  • IDCS ITE109B Phase2 Nov 2009 Till Date/Project Leader
  • This release involves the introduction of features such as Auto returns of MT456 on dollar threshold, ability to update/edit reversal reasons.
  • IDCS ITE109B Jul 2009/Sep 2009 /Project Leader
  • This release involves the introduction of features such as Automatic wire and swift payments.
  • IDCS ITE109A Apr 2009/Jun 2009 /Project Leader
  • Many of the production defects are fixed and promoted with this release.
  • IDCS Wamu Merger Jan 2009/ Mar 2009 /Project Leader
  • This release involves changes required to accommodate business functions required for WaMu merger with J P Morgan chase.
  • IDCS ITE308, ITE308 Wave II Sep 2008/Jan 2009 /Project Leader
  • This release involves changes required to accommodate external vault and sap extract file changes.
  • IDCS ER308 May 2008 Aug 2008 /Project Leader
  • This release involves the introduction of features such as Suppress images on all notifications and Decommission of RAZZA and FIRM.
  • IDCS ER208 Jan 2008 Apr 2008/Module Leader
  • This release involves the introduction of features such as Cash letter destination, Decommission of VAT.
  • IDCS ER108 Oct 2007 Jan 2008/Module Leader
  • This release involves the introduction of features such as Automatic GES approval and flexible advising.
  • IDCS ER207 May 2007 Aug 2007
  • The particular release involves the introduction of features such as Automate kill bundle, auto process by dollar threshold, creating interface file for down stream systems, CIU-Secure review queue and many other enhancements to the application.
  • IDCS ER107
  • The particular release involves introduction of contract queue, float removal logic, automating SSR report and many production fixes.
  • IDCS 4Q07
  • The particular release involves the continuation of maintenance Queue changes, Secondary approval features and many production fixes.
  • IDCS ER 306
  • The particular release involves the introduction of Maintenance queue and many production fixes to the application.
  • IDCS Merger
  • IDCS Merger is enhancements to this application are to add additional features that are required to include the business process of BankOne as a result of merger of the banks.
  • IDCS Phase
  • IDCS Phase 4 is enhancements to this application are to accept domestic collections and subsequent process required.
  • 1B List
  • 1B list is a list of enhancements to IDCS application.

Technologies Used: Visual basic 6.0 , PL/SQL ,Crystal Reports 8.5 , VSS, SVN, Oracle 8i,9i

Responsibilities

  • Analyzing the requirements and preparing the design Documents
  • Development
  • Testing Unit / Integration of the application
  • IST/UAT Support and addressing the technical issues
  • Identifying Application problems
  • Have played Team Member, Module leader and Team leader roles at different releases

confidential

Project Leader

  • Confidenial is a mail deposit processing system for Bank One. It involves modifying the existing NBBM system,
  • currently used by Confidenial The NBBM Project would help automate the manual process currently used y Bank ONE. The NBBM is an interactive modular database management system written in visual basic using oracle 9i. This multi user application allows data entry by keyboard scanner / or from the CAS /DDA mainframe systems. Ninety days of Historical data is maintained for customer research. The application also generates receipts and correspondence letters to the customers based on the LOB and location Domestic and International . The mainframe account verification routine in the legacy system was replaced by MQ series inquiry .

Technologies Used: Visual basic 6.0 ,PL/SQL Crystal Reports 8.5 , VSS.

Responsibilities

  • Analyze the requirements and prepare the design Documents
  • Development
  • Testing Unit / Integration of the application
  • IST/UAT Support and addressing the technical issues
  • Identifying Application problems

confidential

Senior Developer

  • Contact Center Technologies' Distributed Technologies team is responsible for designing, developing, analyzing, and implementing contact center data systems and functionality for the business units while maintaining and improving existing technologies. Distributed Technologies team provides WEBSTATS, an Intranet site that enables access to and greater manipulation of MIS data to line of business managers. The Management of JP Morgan Chase uses this site for all Call Centers related reporting and also to measure the success of their projects or brand responsibilities. TCS has been actively engaged in development and enhancement activities for WEBSTATS application since March 2003 and has 2 resources working at Onsite Tampa, Fl . JPMC wanted additional resources in the area of WEB Development and DBA Activities for carrying out various Maintenance, Enhancement and New Development activities in WEBSTATS.
  • The technologies involved in the application include Active-X Server Pages, PowerBuilder, Java Server Pages and Java for the Front End of the Application Sybase and Oracle forms the back end databases .
  • The database consisted of a sybase server. Data from other databases like oracle,Sybase were loaded into the central Sybase database . This database is the base for building MIS reports. The reports were populated from stored procedures.

Technologies used: Forms 3.0.,PowerBuilder, Sybase 11.5 , oracle 8i

Responsibilities

  • Maintaining Customizing the Product as per Clients Requirement.
  • Tuning stored procedures.

confidential

Developer

  • Centralised Banking System CBS is an innovative software product developed by TATA Consultancy Services TCS for Total Branch Automation
  • And Centralised Banking
  • The Modules in the Product are
  • Savings, Current, CCOD.
  • Deposits
  • Remittances
  • Loans Advances
  • Bills
  • Foreign Exchange
  • External Interfaces
  • ATM
  • Tele-banking
  • IBR
  • MultiBranch Connectivity

Technologies used: PL/SQL, SQL.Red Hat Linux 7.1,Oracle 8.1.7,Oracle Forms 6i

Responsibilities

  • Implementation of the Product.
  • Operating System Oracle Installation Database Administration Activities.
  • Functional testing for Beta release of the product.

confidential

Developer

  • Etreasury is a product developed for handling the Treasury operations involved in the banking industry.
  • It handles 1 Domestic call money trading.
  • Forex trading.

Technologies used: Pro C,PL/SQL,SQL,Oracle 7x, Oracle Reports 6.

Responsibilities

  • Involved in development of reports
  • Involved in production support activites.

confidential

Developer

  • Integrated Standard Banking System is an innovative software product developed by TATA Consultancy Services TCS for Indian Bank's .The
  • Product Caters to various banks and handles information online.
  • The Modules in the Product are
  • Savings, Current, CCOD.
  • Deposits
  • Remittances
  • Loans Advances
  • Bills
  • Foreign Exchange
  • External Interfaces
  • ATM
  • Tele-banking

Technologies used: SCO-Unix, HP-Unix, Sun Solaris, C, Pro C, PL/SQL, SQL, Oracle 7.x., Forms 3.0.

Responsibilities

  • Maintaining Customising the Product as per Clients Requirement.
  • Implementation of the Product.
  • Operating System Oracle Installation Database Administration Activities.

Hire Now