Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Timeline
Generic
Mohanarangan Rangan

Mohanarangan Rangan

Chennai,Tamil Nadu

Summary

  • Proven IT Professional with over 17+ years of banking experience with a US multinational bank.
  • Led a team of DWH application and back end database team for regulatory/compliance reporting.
  • Extensive experience in managing enterprise IT project life cycle through all phases.
  • Involved in software development, release, database maintenance & support. Collaborate with other IT teams for smooth delivery of projects.
  • Involved in managing P1 & P2 incidents till it’s closure.
  • Experienced in database design for application performance
  • Strong technical knowledge in Microsoft SQL Server, SSIS, SSRS & BI Tool
  • Strong technical knowledge in PostgreSQL and Pentaho ETL
  • Strong technical background in systems architecture, database and application design.
  • Proven ability to deliver high quality IT products and services on schedule and under budget.
  • Excellent interpersonal skills in communications, client relations, and negotiation.

Overview

23
23
years of professional experience
1
1
Certification

Work History

Vice President

Bank of New York
08.2005 - Current
  • Responsible for Data Warehouse Front End application and back end database related project deliverables
  • Led a team of Data Warehouse Application team
  • Vast experience Microsoft SQL Server, SSIS & SSRS
  • Executed various banking regulatory & business projects
  • Experience in database / query fine tuning
  • Gather requirements, plan, develop, release, change & support
  • Analyse the application & database performance and fix performance issues
  • Collaborate with business team for project delivery
  • Experience in software release process
  • Experience in PostgreSQL technology
  • Hired and managed DBA & SQL Development team.

Technical Lead

CyberMAK Information Systems
10.2003 - 07.2005

CyberMAK is a subsidiary of MA Kharafi (MAK) group is a multi-billion dollar company located in Kuwait. MAK is having operation in all over Middle East and Egypt CyberMAK is doing the software projects for MAK.

  • Implementation of ACCPAC CRM in one of the division of MAK using .NET. ACCPAC CRM uses web service, .NET & XML.
  • Maintenance and support for CRM application & database.
  • Configuring & monitoring databases.
  • Maintaining high-availability of database.
  • Fine tuning databases for better performance of databases
  • Backup & restore operations
  • Configuring replications between different locations.
  • DTS configuration

Software Engineer

Saipem India Projects
02.2003 - 10.2003
  • Database maintenance and Intranet applications development and maintenance
  • Developed a Helpdesk system for IT department, which will maintain the assets & inventory of IT resources
  • Users will make their complaint using Intranet application; service engineers will attend cases
  • IDPE had large databases in Oracle & SQL Server
  • I was taking care of database on SQL database server & Intranet Server

Software Engineer

Ascendus Technologies Inc. (KVN Software Technologies Pvt. Ltd)
02.2001 - 02.2003
  • Executed the projects for Carnegie Mellon University
  • Lead a team of 6 developers
  • Worked on coding, installing, Configuring & maintaining Windows 2000 Server & IIS Server
  • Major projects done for Ascendus Technologies: Online Course Evaluation System, Online Content Management System, Automated course scheduling of students.

Education

M.C.A. - Computer Applications

University of Madras

B.Sc. - Mathematics

University of Madras

Skills

    Microsoft SQL Server

    Microsoft SSIS / SSRS

    Project / Team Management

    Data Warehousing

    Regulatory Reporting

    PostgreSQL

    Database/Query Tuning

    Release Management

Certification

  • PRINCE 2 Practitioner - Project Management
  • Certified Scrum Master - Agile
  • IT Service Management – ITIL Foundation
  • Microsoft Certification for SQL Server

Personal Information

Passport Number: F4413498

Timeline

Vice President

Bank of New York
08.2005 - Current

Technical Lead

CyberMAK Information Systems
10.2003 - 07.2005

Software Engineer

Saipem India Projects
02.2003 - 10.2003

Software Engineer

Ascendus Technologies Inc. (KVN Software Technologies Pvt. Ltd)
02.2001 - 02.2003

M.C.A. - Computer Applications

University of Madras

B.Sc. - Mathematics

University of Madras
Mohanarangan Rangan