Ramalingam - DB2 Database Developer - Velachery, Chennai, Tamil Nadu, India

Kalidass Ramalingam

Velachery, Chennai, Tamil Nadu, India

Services

DB2 Database Developer

Summary:

IBM DB2 LUW 9.7 , ISW 9.7.3 , Datawarehousing (ETL Process)

Work History

Junior Associate

Star Health and Allied Insurance

From January 2012

Technology Used:
➢ DB2 9.7
➢ Oracle 9i/10g/11g

Tools Used:
➢ IBM Info sphere Warehouse Design Studio V9.7.1
➢ Toad 7.3
➢ BIRT 2.5
➢ IBM X3850 Server
➢ Web sphere Application Server 7.0.0.21

iCAST is an Business Intelligence (BI) application that provides intuitive, on demand, business intelligence in a single and unified manner that is accessible by the management, key decision makers, operational users, regulators and all authorized business-users.

Product Name: iCAST (Insurance)

Client: Star Health and Allied Insurance [On Site]
Team Size: 5 (Developers - 3, Functional Consultant - 1, Project Manager - 1)

Star Health and allied insurance is a Leading Health insurance Company in India. It is India's first stand-alone Health Insurance Company in India and deals in Personal Accident, Mediclaim and Overseas Travel Insurance.

Roles and Major Challenges Involved:
➢ Database Objects like Tables, Views, Triggers, Rules, user defined data types and functions for this project.
➢ Designing BI Reports in Eclipse.
➢ Datamigration from Oracle (From Client DB) To Warehouse DB2.
➢ Developing SQL Queries for BI Reports.
➢ Database Maintaince.
➢ Perform database recovery and backup tasks on daily and weekly basis.
➢ Developing SQL scripts for maintaining administration tasks.
➢ Involved in activities like Data Flow creation and Control Flow Creation using Infosphere Warehouse Design Studio.
➢ Involved in Report Designing activities in BIRT, like Report Creation, Query Writing, Report Formatting, Testing, Debugging and Bug Fixing.
➢ iCAST Application Administrator and performed activities like publishing of Reports, Creation of Users and giving Access Permission to Users.
➢ Identified problematic SQL and optimized SQL queries that helped improve application performance

Software Trainee

Icast Systems Limited

September 2011 - December 2012

Technology Used:
➢ DB2 9.7

Tools Used:
➢ IBM Info sphere Warehouse Design Studio V9.7.1
➢ BIRT 2.5

IBM Banking and Financial Markets Data Warehouse model is the strategic blueprint that supports rapidly changing reporting and analytic priorities of financial institutions and enables the consolidation of trusted information across multiple viewpoints:
➢ Delivers competitive advantage by enabling the consolidation of clean, meaningful financial markets data across multiple channels, and products.

➢ Enables business users to more effectively control and reduce the time taken to scoping their requirements, subsequent customization and any extension of the data warehouse


Product Name: iCAST (Banking)

Bulding the Product -IBM Financial Services Data Model V-8.3.0(Banking)

Team Size: 5 (Developers - 5, Functional Consultant - 2, Project Manager - 1)


Roles and Major Challenges Involved:
➢ Created test environments for the new database and populated test databases with relevant data from various production files and databases
➢ Database Objects like Tables, Views, Triggers, Rules, user defined data types and functions for this project.
➢ Populating The Data into Warehouse
➢ Data mapping Of Reports
➢ Developing SQL Queries for BI Reports.
➢ Perform database recovery and backup tasks on daily and weekly basis.
➢ Part of Design team in creation of Fact and Analysis tables.
➢ Performed database maintenance activities like monitoring partitions, data set extents, executing data consistency, catalog manipulation utilities like RUNSTATS and data reorganization utilities like REORG, etc

Qualifications & Certifications

Information Technology

Vikram College of Engineering

Sivakasi Nadars Matriculation Higher Secondary School

Aiyra Vaisiya Higher Secondary School

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Kalidass Ramalingam provides the following services:


Are you sure that you want to leave?

   
Supported Countries
Choose your country

×