Krishna_Divagar_Kumaresan

of 5
Krishna Divagar Kumaresan
NRIC: S8385002G
HP: (+65) 8499 1656
E-mail: krishna.divagar@gmail.com
Company: Government of Singapore Investment Corporation (GIC)
A. Summary of Professional Experience
o 12+ years of working experience in managing the project which includes design,
development and support of IT software system.
o 10 years of working experience in investment domain Risk Performance Management
Division (RPMD) project implementation
o A good team leader.
o Have good experience of the SQL Performance Tuning implementation in Database
Query level (Oracle 10g /12C using AWR)
o Have good exposure in Oracle 10g/12c Implemented Web service invocation,
Partitioning, DBMS_SCHEDULER etc..
o Have working experience in Control-m 8.0 workload automation tool
o Good understanding of business knowledge in investment performance computation,
attribution and analysis.
o Involved in the whole SDLC process of PACE2 project across business requirement study
& analysis, system architecture design & solutioning, technical development &
programming, UAT support & implementation, post-production support and system
enhancement.
o Did the application design and development of PACE2 system using the following
technologies such as Microsoft Visual Studio .net 2012/2005, ASP.Net (Front End),
C#.NET, VB.NET, Oracle 12C/10G (Back End) and Crystal Report 10 (Reporting
purpose).
o Worked in UK for 9 months with the client - Anite, for Project Development.
o Got the Best Employee award and Pillar Award for effective Contribution in the project
and long term continuous best performance with the GIC client respectively.

B. Technical Summary
Platforms
 Visual studio.Net 2012, 2005
 ASP.NET
 Control-m Version 8.0
 Tableau 9.2.2 (Basic)
 Crystal Report 10.
 VB.Net
 C#.Net,
 HTML
 JavaScript
 ASP
 Visual Basic
RDBMS
Oracle 12C
Oracle 10g
SQL Server 2000
SQL Server 2005
CM System Tools:
 Microsoft Visual Source Safe
 SVN
C. Education
 Bachelor of Technology (Information Technology) @ Pondicherry Engineering College,
Pondicherry University, Pondicherry, INDIA.
 Completed Basic training of Tableau 9.2.2 tool
D. Details of Professional History
PACE2 (Performance Attribution and Computation Engine) - Since Nov 2013
Role: Technical Project Management
Working Location: Singapore
PACE2 (Performance Attribution Computation Engine 2) is higher version of PACE which
software system which provides performance attribution computation for internal and external
portfolios on both segment-based level and decision-based level. It has user cum batch driven
performance computation engine that delivers new attribution reports customized to users’ needs.
Tasks & Responsibilities:
 User Coordination for enhancement
 Project Management
 Control-m Job workload automation.
 Server upgrade - DB server from Oracle 10g to Oracle 12C and Application Server from Win 2003
to Win 2012 R2. Application migration
 Implemented the EMNA model decision based attribution system for EQ department
 Implemented the EQ Risk Monitor report for different models such as MCS, MCC and MCI

 Lead the Workload automation of extraction module using Control –M version 8.0 tool.
Implemented the new advanced feature DB-plugin
Environment: Oracle 12C,Visual Studio 2012 ASP.NET,VB.Net,Control-m version 8.0, Excel Interop
implementation
PACE (Performance Attribution and Computation Engine) - Nov 2007 to Nov 2013
Roles: Senior Consultant- (Analysis, Designing, Coding and Testing)
Working Location: Singapore
Client: GIC (Government of Investment Corporation of Singapore)
PACE(Performance Attribution Computation Engine 2) is software systemwhich provides
performance attribution computation for internal and external portfolios on both segment-based
level and decision-based level. It has user cum batch driven performance computation engine that
delivers attribution reports customized to users’ needs.
This system is used by the user of three different departments such as PM (Public Market), SI
(Special Investment) and RE (Real State). So Front End is same, business logic and functionality
is specific to their departmental user needs.
 Software Design Document Preparation.
 Front End Page Design and Database Design.
 Crystal Report design and Implementation.
 Coding, Integration & Deployment to the different servers.
 Bug Fixing and Enhancement changes implementation.
 Worked in all the modules of the PACE2 project such as Extraction, Aggregation, Attribution
and Reporting. Have the overall knowledge of PACE2 system.
 Deploying the code changes related to enhancement/bug fixing to different server environment and
providing the support to user for their testing.
 Providing the user support for their SQL queries and their data investigation of their
Adhoc/scheduled jobs of PACE2 system.
 Developed the Chain linking & Annualisation report for RE (Real Estate) and SI (Special
Investment) department to handle the large number of timespan and periods starting from Since
Inception.
 Involved in the SQL performance tuning implementation of the system to handle the top EQD
portfolio and provided the report to top level GIC executives.
 Developed the reporting module for different EQ attribution models such as
o SCS(Single Country Attribution by Sector),
o MCS (Multiple Countries Attribution by Sector)

o MCC (Multiple Countries Attribution by Country)
 Developed the reporting module for different FI attribution models such as
o GSR (Global Sector Rotation),
o GIRDIV (Global Interest Rates Divisional)
o GIRINT (Global Interest Rates Internal)
o GIREXT (Global Interest Rates External)
o GC (Global Credit)
 Developed the CR Scheduler (Crystal Report Scheduler) tool - Automate the manual Crystal
Report generation of 160 Daily, 1 weekly and 8 monthly reports.
 Configured & Integrated the DB objects with Visual Source Safe to maintain the Version Control
using Team Coding.
 Developed a tool called VSS Helper to automate the deployment Code Synchronize process in the
Visual Source Safe for 3 different schemas involves in the project in different environment such as
DEV, UAT and PROD .
 Implemented the performance tuning changes in Database and Crystal report level to improve the
application performance of the PACE2 system
Environment: Oracle 10g,Crystal Report 10, Visual Studio 2005, ASP.NET,VB.Net,C#.Net,Infragistics
NetAdvantage Controls.
Library Management System (LMS) - August 2007 to Nov 2007 (3.5 months)
Client: Rascal
Roles: Technical Lead (Analysis, Design, Coding and Deployment)
LMS is an Application migration project of ‘Notebooks’, a RASCO’s product for Library
Management system, from Lotus Notes platform to SharePoint 2007 & .Net.
The design of the website was accomplished by first understanding and defining the audience
persons and then using that information to guide the information architecture and graphical design of the
site.
 Requirement gathering and Analysis
 Client Interaction
 Design(Custom pages and webparts)
 Coding and IUT.
 Technically managed the team.
 Bug Fixing
Environment: Microsoft Office Sharpoint Server 2007, Microsoft Share Point Designer 2007 and
C#.Net. VisualStudio 2005

EDRM Studio - November 2006 to July2007 (9 months)
Roles: Senior Developer (Analysis, Coding, Testing, and Defect Fixing)
Client: Anite Public Sector.
Worked Location: UK
EDRM Studio is an electronic document and records management tool, providing configuration
and administration functions, which enables Anite@Work to index and quickly retrieve electronic
documents. The documents can be declared as ‘records’ which prevents the contents from being altered or
deleted. They are stored in Classifications Schemes which are sophisticated, structured representations of
Business activities and processes. Anite@Work is a document management tool developed in Visual Basic.
 Design (Pages) and Database Design.
 Coding and IUT.
 Bug Fixing and Enhancement changes implementation.
 Developed the tools for application and service configuration.
Environment: Windows XP, Visual Studio 2005 (WPF &WCF implementation), VB, C#. NET, SQL
Server 2005.
Lead Management System - December 2004 to November 2006 (2 Years)
Client: Citibank.
Role: Developer (Design, Analysis, Coding, Testing)
Lead management System for Citibank. It is a Windows application for the Citibank Call Centers. The
application workflow has various levels by which a loan approving process is in place. It has features for
Pop Ups (Notifications) to remind the call center agents that a call has to be made to client. The Reports
Module of the CITILMS project is a Web module with Crystal Reports implemented in it.
 Software Design Document Preparation.
 Design(Pages) and Database Design
 Coding and IUT.
 Project Integration and testing.
 Project Deployment in Client place.
Environment: Windows 2000, C#. Net, ASP. Net, XML, SQL SERVER 2000, Crystal Reports
Effortless - Effort Tracking System - July 2004 to November 2004 ( 5 months)
Client: CSS
Role: Developer (Design, Coding, Testing, Defect analysis, Defect Fixing)
Effortless is a web enabled time sheet management system, which provides a user-friendly system
to enter and keep track of various activities involved during software project life cycle. Timesheets is a
system used by the employees of CSS group, which takes care of features like Project Planning, Tracking

& Monitoring, Billing of Projects, Effort Logging and Approval of the Timesheets. The system helps in
entering timesheets, approving timesheets, enter projected related details, metric collation and generating
various reports. The finance and accounts department can use this system to perform billing based on the
effort invested in projects on a periodical basis (either weekly or monthly). The system does not however,
take care of any features pertaining to the attendance registration and monitoring system. Defect Tracker is
an Open Source defect tracking software tool, which helps you to organize and manage defects.
 Software Design Document Preparation.
 Design(Pages) and Database Design
 Coding and IUT.
 Client Interaction.
 Project Build preparation, testing and Deployment.
Environment: Windows 2000, ASP.NET, C#. NET, JavaScript, SQL Server 2000

Krishna_Divagar_Kumaresan

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Viewers also liked

Viewers also liked (20)

Similar to Krishna_Divagar_Kumaresan

Similar to Krishna_Divagar_Kumaresan (20)

Krishna_Divagar_Kumaresan