Panneerselvam Kolandaivel

Address: Ground Floor,

# **/*, *** *****,

Cashier Layout, Taverekere,

Madiwala,

Bangalore, Karnataka – 560029

E-mail: acuxe0@r.postjobfree.com Phone: +91 - 973-***-****.

Professional Summary:

Having 7 years of experience in all stages of SDLC.

Involved in Analysis, Design, Development, Testing and Implementation of software applications.

Experience in Requirements gathering and SRS preparation.

Requirements’ gathering includes Design requirements & Functional requirements.

Constantly successful with exceeding preset business targets on a quarterly basis.

Proficient with various online client interaction tools and office automation tools.

Successful with Contract renewals and product up sells to existing client base.

Emphasis on Accelerative Growth Strategy modeling with Senior Management & Product Management leads.

Experience in MS SQL Server, Pentaho, VB 6.0, HTML.

Experience in Development of data mappings and data Transformations to implement the business logic.

Having good knowledge of DML, DDL, TCL and DCL queries in SQL Server.

Working knowledge in writing medium and complex queries using joins, sub-queries and grouping.

Successfully contributed my knowledge towards completing the projects in time with desired results.

Having good analytical and programming capabilities.

Ability to work in the pressure situations and flexible to work in different technologies.

Successfully trained a new support team and transitioned the production tasks without any escalation.

Skills:

Languages

Databases

Special Skills

SQL Scripting

SQL Server

Creating reports as per the requirements using complex logics.

Data Integration using Pentaho Business Intelligence

My SQL, MS Access

Creating and Maintaining Pentaho Mappers for various ETL requirements.

Unix, Shell Scripting

MS SQL Server

Bash Scripting Programming

HTML, CSS, DHTML, XML

MS Access, SQL Server

Performed maintenance for web based projects

Education:

School

Year

Degree

GPA

Notable Course Work

Concordia University

Montreal, Quebec, Canada.

Sep’05

-

May’08

MS in Applied Computer Science

3.5/4

Design and Analysis of Algorithms, Compiler Design, Introduction to Expert Systems, Computer Systems Design, Description Logics & Uncertainty Theory, Database Design, Software Design Methodologies and Computer Networks.

Valliammai Engineering College

University of Madras, Chennai, India.

June’00

-

May’04

BE in Computer Science and Engg

87% (100%)

Calculus, Linear Programming, Numerical Analysis, Advanced Data Structures, Probability Theory, Software Engineering, Object Oriented Programming, Resource Management, Management and Organizational Behavior.

SRM Systems and Software

Chennai, India

Nov’03

-

Mar’04

.Net

N/A

VB.Net, ASP.Net, C#, SQL Server.

Publications:

• A Novel Earthquake Mitigation Information expert System: EMIS in IEEE

CCECE/CCGEI, May 2006 - Ottawa Congress Centre, Ottawa, Canada.

• Won 1st prize for Paper Presentations in Neural Networks and Network Security in the

Inter-College Competition, Jan 2004, SRM Engineering College, Chennai, India.

Experience:

Senior / Lead Consultant Tangoe India Softek Services Inc., Bangalore Mar 2013 – Nov 2015

Primary responsibilities include driving the Implementation process for all the prospective Clients. Gathering requirements and finalizing strategy for executing the project, from kickoff phase till it goes live.

Providing Interactive Product demos to prospective customers and preparation of Cost Estimation.

Requirements gathering and SRS preparation during Project initiation phase.

Conversion of successful Project prospects into long term Customer projects.

Client Support on a day to day basis for project tracking with development leads.

Primary point of contact to Clients during the whole Project life-cycle.

Requirements’ gathering includes Design requirements & Functional requirements.

Constantly successful with exceeding preset business targets on a quarterly basis.

Training new employees and guiding then until they become proficient.

Leading various cleanup projects in production clients to reduce the errors.

Leading the projects that involves in optimizing the available reports.

Mentoring new joinees and junior members in the team.

Implemented EOM Health Check process and as a result, we’re able to prevent 70% of billing errors.

Have created multiple training materials as well as process documents to reduce individual dependency across teams.

Tools Used: SQL Server 2008, MS Access, My SQL, MS Excel, Pentaho 4.1.0

Senior / Lead Consultant Symphony Services, Bangalore, India Feb 2011 – Mar 2013

Primary responsibilities include driving the Implementation process for all the prospective Clients. Gathering requirements and finalizing strategy for executing the project, from kickoff phase till it goes live.

Providing Interactive Product demos to prospective customers and preparation of Cost Estimation.

Requirements gathering and SRS preparation during Project initiation phase.

Conversion of successful Project prospects into long term Customer projects.

Client Support on a day to day basis for project tracking with development leads.

Primary point of contact to Clients during the whole Project life-cycle.

• Our flag ship product TEM (Telecom Expense Management) required constant upgrades so as to facilitate the growing needs of the customer & to compete with global competitors. This being a complex telecom product, met with lot of challenges in getting into stable & steady state, which in-turn created more pacifying moments with customers. By gaining multiple requirements from customers & marketplace, we were able to project the key features to the customer’s immense satisfaction. Thus, we were able to deliver one of the most successful products in Telecom market space.

• EDI Processor Enhancement- Involved in analyzing various XML based templates to break down its methods of parsing and identifying the optimal one.

• Databases - Creating Access, SQL Server 7, SQL Server 2000, SQL Server 2005, SQL Server 2008, MySQL, Oracle and Sybase databases. Database logic including: data modeling, data replication database optimization as well as server workload optimization in search algorithms.

Tools Used: SQL Server 2008, MS Access, My SQL, MS Excel, Pentaho 4.1.0

Software Developer, Consultant HMS Software Inc, Montreal, Canada Oct 2008 – May 2010

Primary responsibilities include design development and deployment of new applications and web apps as well as fixing and improving current deployed apps. Migrated PHP websites and reporting systems to .NET based systems. Developed and deployed ASP/SQL Server logging and tracking systems and ASP.NET visual 3D components

• Personalizing Web Directories with the Aid of Web Usage Data: This project uses a knowledge discovery framework for building Web directories according to the preferences of user communities. Community Web directories are more appropriate than personal user models for personalization across Web sites, since they aggregate statistics for many users under a predefined thematic taxonomy, thus making it possible to handle a large amount of data, residing in a sparse dimensional space.

• Mass FTP uploads: Assisted in developing a mass upload FTP system using auto uploading and encoding. Content files are uploaded along with a metadata file and the system picks up the files, encodes them and uploads them to the CDN along with the correct metadata.

Tools Used: Visual Studio .NET 2008 (ASP.Net), VB.NET, MS Access, SQL, MS Excel

Research Assistant & TA ENCS, Concordia University, Montreal, Canada Jan 2006 – Mar 2008

Developed an Earthquake Mitigate Information System using C# and VB.Net. Assisted professors’ in class works and lab exercises in the field of Data Mining and Data Processing. Assisted in collecting data’s for testing Knowledge Base Systems which provides solutions for - Uncertainty Reasoning, Data Integration, and Web Usage Mining. Assisted in coding for the implementation of Description Logic concepts in Knowledge Base Systems.

Tools Used: Visual Studio, C#, VB.NET, SQL, and MS Excel.

Software Engineer JTN IT Consulting Services, Hyderabad, India June 2004 - July 2005

Company provides solutions for data entry, processing, validation, tabulation for medical and automobile claims. Helped in developing processing editor to correct web entered documents. System allowed user to modify documents to allow for proper computer processing. Programs modified to user specification.

Duties included development of VB.Net Screens and GUI development, VB.Net Interfacing with database and web created files. Duties included VB.Net programming and SQL (ADO) database. Worked with senior managers to modify and extend specification, to add capabilities. Supported Quality Team responsible for overall testing of the project - which included preparing Manual Test Cases from requirement documents, System Test Cases, peer reviewing them, initiating, closing reviews, executing test cases, logging and managing Defects, analyzing them.

Tools Used: VB 6.0, Visual Basic .Net, MS SQL Server (ADO), MS Excel and MS Access.

Personal Details:

Father’s Name : S.Kolandaivel

Date of Birth : 15-07-1983

Nationality : Indian

Sex : Male

Marital Status : Single

Languages Known : English, French (Basic), Hindi, and Tamil

Personal Interest : Reading, Music, and Soccer

Passport No : F0544984

Declaration:

I hereby declare that the above-mentioned information is true to the best of my knowledge and belief.

Panneerselvam Kolandaivel

Contact this candidate