It Analyst Resume
SUMMARY
- IT professional with experience in Design, Development and support of RDBMS in Production and Development Environments using Oracle.
- Banking functional Knowledge in Modules like Trade Finance (Bill and Collections and Letters of Credit), Loans and Deposits, core module, Reconciliation.
- Client interaction for Interface Study and gap analysis.
- Preparation of functional and design specifications.
- Handling various technical aspects like product documentation, software design, coding of modules, monitoring critical paths & taking appropriate actions.
- Mentoring team members and provided Oracle Flexcube Training to new hires.
Technical Skill Set
- OS Plat forms: Windows XP.
- Programming Languages: SQL & PL/SQL (Good Concept in Cursor, Procedure, Function, Packages, Triggers).
- Development Tools: PL/SQL Developer
- RDBMS: Oracle10G
- GUI: Developer 2000, RAD Tool(Rapid Application Development Tool)
- Version Control: IBM Clear Case, FlexMart
Education:
Masters in Computer Application
Bachelor of Science (Mathematics)
PROFESSIONAL EXPERIENCE:
Confidential Nov 2010-Apr 2011
Client: Confidential
Designation: IT Analyst
Worked in L3 support to maintain the system called CIBR
(Comprehensive Inventory Business Repository). CIBR keeps track of Intel’s chip manufacturing at every stage of production. Data that comes into CIBR is processed and passed to various other downstream systems for reporting purpose.
Role: To help Intel users of CIBR with various issues related to reporting and also write extraction procedures using pl/sql which will extract data in the desired format and pass it to other downstream for reporting purpose.
Confidential Oct2005-Oct2010
PROJECTS INVOLVED
Client: Confidential (Oracle Flexcube 11.0), IC Bank Hungary(Oracle Flexcube 5.5)
Module: Interface
- Developed packages which will aid in data extraction for UBS bank to extract data from CBS (core banking system) to other systems like FMS, REX .
- Preparation of test plans, Unit Testing, Integrating with flexcube end of day batch to generate handoff files.
- Developed interface between ‘Inforex’ and FlexCube for modules Teller, FX(Foreign Exchange), and LD(Loans and Deposit) for IC bank.
- Developed Jobs for Data validation and Generation of Flexcube contracts.
- Provided offshore UAT support.
Client: Confidential (Oracle Flexcube 3.4.12)
Module: Reconciliation
- Developed the items for currency wise reconciliation of Nostro account with its corresponding mirror account. Also developed the batch program for Automatic reconciliation where the system does automatic reconciliation based on various criteria’s provided by the client.
- Based on the requirement from the client developed Functional Specification and Design Specification documents.
- Provided Testing team support and also involved in bug fixing.
- Provided offshore UAT support.
Client: Confidential (Oracle Flexcube 7.1)
Module: Core, Loans and Deposit
- Developed the items for Inclusion of “Know Your Customer”(KYC) Details in Customer Screen (Core Module), Liquidation and Capitalization Frequency of Interest for Capitalized Loans: (Loans and Deposits)
- Based on the requirement from the client developed Functional Specification and Design Specification documents.
- Provided Testing team support and also involved in bug fixing.
- Provided offshore UAT support.
Testing Projects
- Worked under IQA (Internal Quality Assurance) Team for assuring Quality output of the Product for SARB(South African Reserve Bank) Release.
- Worked in association with SQA Team for assuring Quality Product and Quality Testing. Good understanding on SDLC of a Product.
Confidential (Oct2004-May2005)
- Maintenance of various systems of ZIL and generating reports as per to the requirements of the various departments of ZIL.