M.J.RAJAN

No */***A, Nehru street,

Pasumpon Nagar,

Perumbakkam, Medavakkam, Chennai - 600100

Phone: – 098********

Email: adyk0x@r.postjobfree.com

SUMMARY OF SKILLS AND EXPERIENCE

Present 19 years’ experience in software development.

Presently working in Intellect Design Arena Ltd (Polaris Group)

From Jan 2010 to Feb 2012 Worked with Scope International Ltd (as Vendor Resources)

From March 2007 to July 2009 worked with CSC INDIA, Chennai.

March 2000 to March 2007 Laser Soft Info Systems Ltd Chennai. A Leading Banking Software Development company

Successfully completed 35 Hours PMP exam prep certification course (Program No – 2042 IIPM 01)

Skills in using Oracle PL/ SQL, Informatica, Seagate Crystal Reports, Visual Basic and SQL Developer

Handling Data Migration Project -- Requirements gathering, migration strategy diagram, logical and physical entities, Data mapping, development and data migration

Data Analysis – identifying and analysing the data and data cleaning

Scheduling Tools: Control-M

Creating XML FILES

Handling Trade Finance Production Support project & Migration Project and CR

Worked in Payment system – RTGS

Having Good experience using Informatica power center 8.1

Retail Loans Demo Given to Dena Bank (Fin Mart) Mumbai Vileparli Branch.

Handling Clients: Bank Muscat, Andhra Bank, Corporation Bank, Indusind Bank and Central Bank of india.

Trade Finance & Services -- Import & Export Bills, Import LC and Export LC

Handling Enhancement & Changes and releasing code into production

Doing Root cause analysis and closing the issue

IT SKILLS

OS: Windows 98/ 2000,

Windows 2000 Advance Server and Windows NT Server

GUI: Visual Basic

RDBMS Oracle: Oracle 10G, Oracle 11G, PL/SQL (Stored Procedure, Functions, Triggers, Packages, Collections and Bulk Collect and Performance Tuning)

Tools Crystal Reports, Toad, SQL Developer, Oracle Reports, SQL Loader,

Control – M, Fermat version 10 and ETL Tool.

Data Base Installation, Creating Database, Creating Schema, Database Migration and

Database Backups / Restores

Dataware House Informatica 7.1 & 8.1 (designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router, rank, Flat File, Mapplet and SCD)

ORGANISATIONAL EXPERIENCE

Presently Working as Project Manager with Intellect Design Arena Ltd, Chennai, an CMM Level 5 Company.

Projects Handled

Employer / Client: Intellect Design Arena Ltd / Central Bank of India

Project: Trade finance & Services (Migration & Support project)

Role: Project Manager (Techno Functional)

Trade finance includes such activities as lending, issuing letters of credit, export credit and insurance. Companies involved with trade finance include importers and exporters, banks and financiers, insurers and export credit agencies, as well as other service providers

Trade finance Deals with total automation of International Trade Finance operations

Import & Export bills, Forward contracts, foreign currency accounting, Import LC, Packing Credit

Inland trade – Inward & outward bills, LC, guarantees and warehouse receipt loans.

Responsibilities: Requirements gathering, Data migration, Deployment of application EAR in UAT

and Production, Development and handling production support

Environment: Oracle11, PL/SQL, Java (J2EE), Application server Web logic

Employer / Client: Polaris Financial Tech Ltd / Indusind Bank

Project: Trade finance & Services (Migration & Support project)

Role: Senior Project Lead

Trade finance includes such activities as lending, issuing letters of credit, export credit and insurance. Companies involved with trade finance include importers and exporters, banks and financiers, insurers and export credit agencies, as well as other service providers

Trade finance Deals with total automation of International Trade Finance operations

Import & Export bills, Forward contracts, foreign currency accounting, Import LC,

Inland trade – Inward & outward bills, LC, guarantees and warehouse receipt loans.

Responsibilities: Requirements gathering, Architecture, logical and physical data modelling, data migration,

Development and handling production support

Environment: Oracle11, PL/SQL

Employer / Client: Polaris Financial Tech Ltd / National Bank for Agriculture and Rural Development

Project: Centralized Loan Management System

Role: Project Lead

Scope: The National Bank for Agriculture and Rural Development (NABARD) is an apex development finance institution set up with a mandate for providing and regulating credit and other facilities for the promotion & development of agriculture, small scale, cottage & village industries, handicrafts & other rural crafts, and other allied economic activities in rural areas with a view to promoting integrated rural development and securing prosperity of rural areas.

Responsibilities:

Development, Handling Client, Preparing Template, Migration Strategy document and Data Migration

Environment: Oracle11, PL/SQL

Employer/Client: Melstar Information / Scope International

Project: Basel II Calculation & Reporting Solution

Role: Project Lead

The BCRS is a shared platform that will support all of SCB’s geographies and businesses.

The bank’s CB and WB businesses that take data extracts from transaction processing (TP) systems, and provide the credit risk information required to determine minimum capital requirements under Basel II.

In order for SCB to meet Basel II regulatory computation and reporting requirements,

it needs to be able to collate all relevant data from its branches and subsidiaries centrally in the BCRS platform.

The scope can be summarised as:

• RWA, stress-testing, Economic Capital and National Discretion calculations

• Regulatory reporting, MIS, analytics and capital management

Responsibilities:

Production Support, Generating Report and Interacting with Business people.

Environment:

Oracle10G, PL/SQL, SQL, FERMAT Ver10, unix and Control – M tool

Employer/Client: CSC India / Ford Motor Company

Project: SERVIS2 (Warranty and Extended Service Business System)

Role: Team Lead

SERVIS2 is a cost effective, highly functional warranty claim processing system for vehicles including claims with extended service plans. It is a business renewal project for Ford Motor Company involving re-engineering of current SERVIS application and enhancement of the same with additional features that adhere to the business needs. This Application would be a global application that would serve for various markets across the global. This would help the Ford Dealers across the globe to register their Warranty Claims. This Application would interface with 15 other global applications and local applications.

Responsibilities:

Development, Interaction with QA for testing and Production Support

Environment:

Oracle10g, PL/SQL, unix and oracle reports

Employer/Client: CSC India / Ford Motor Company

Project: BUES Lite (Built Up Export Control System)

Role: Migrating the data from Legacy system

Ford Motor Company, Hiroshima, Japan supports the export operations for BU vehicles manufactured in Taiwan and Philippines. The vehicles are exported to FAP and WDMO markets worldwide. Sumitomo Corporation supports the export operations for order consolidation, Logistics and other support services.

Responsibilities:

Designing (Mapplet, Mapping and Session using various transformation)

Unit Testing and Data Migration

Environment: ETL Tool Informatics

Employer/Client: CSC India / Ford Motor Company

Project: Integrated Sales and Service Applications of Mexico

Role: Migrating the data from Legacy system

This project involved the study and merging of a set of 11 applications across the marketing and customer service domains. The project required a multi-market and multi-brand scalable solution that would ensure all issues reported by audits on the legacy application were closed. The project involved studying an application with Spanish screens and working with users

Responsibilities:

Development, Handling Client and Data Migration

Environment:

Oracle9i, PL/SQL and SQL Loader.

Employer / Client: Laser Soft Info Systems Ltd / Corporation Bank & Andhra Bank

Project: RTGS (Real Time Gross Settlement)

Role Team Lead

Scope: This Product is specifically handling the Fund transactions like Inter Bank Payment and Customer Payment through RBI.

Responsibilities:

Development, Code walk through, Testing, implementation and Onsite Customer Support

Environment:

Visual Basic, Oracle9i, PL/SQL and Crystal Reports

Employer / Client: Laser Soft Info Systems Ltd / Bank Muscat (Muscat)

Project: Corporate Loans

Role: Developer

Scope: This Product is specifically handling the all-corporate loan activities process like Customer Module, Security Modules, Documentation Process, Risk grading Process, Financial Delegation Process, Sanction Process, Disbursement Process.

Responsibilities:

Development, unit level testing, Test Case preparation

Environment:

Visual Basic, Oracle9i, PL/SQL and Crystal Reports

PROFESSIONAL TRAINING

Having Oracle Certification OCA (Developers)

EDUCATIONAL QUALIFICATIONS

M.A (Public Administration)

M.B.A (International Business).

Passport No : A0924506

Contact this candidate