KISHORE MOHANARANGAM

Passport No:K*******

Email: aczuyk@r.postjobfree.com

Mobile:+86-136********

Aspiring to explore a challenging career as an Software Engineer, in a dynamic high technology environment with a burning desire to perform, nurtured by a can do will do attitude and to work in an organization with excellent prospects for learning, professional growth and career development, wherein I can improve my skills and keep abreast of the latest technologies and use the best of my ability to be a part of a high performing team.

CAREER PROFILE

A team player who provide effective and efficient Remote-Infrastructure services company-wide while closely working with business users, other teams and management.

An avid learner, receptive to new ideas and ever willing to assimilate latest technology and knowledge.

Demonstrated organizational, interpersonal, communication and problem solving skills.

SKILLS PROFILE

Programming Language : Java/J2ee

Frameworks : Struts-2.0,Struts-1.3.2,Hibernate-3.0,Spring

Web Development : HTML, Java Script, CSS,Jsp

Database : MS SQL Server 2005/2008,PLSQL

Reporting tool : Jasper report, Crystal report

IDE/Tool : Eclipse(Indigo),Netbeans-6.9,MyEclipse,HUE

Server : Tomcat-7.0, JBoss-6 GA

Operating System : Windows XP/7 /AIX/UNIX/LINUX

Open Standards : Html, Xml

SDLC Model : AGILE,Waterfall Model

IT CERTIFICATION

● IBM Certified Specialist - System p Administration - From 2010 till 2012

● Data ware housing and Business Intelligence - From 2010 till 2012

● Diploma in java/j2ee - From 2010 till 2012

PROFESSIONAL EXPERIENCE

Company Name 1 : Nielsen

Senior Software Engineer - From Sep 2016 Till Date

Company Name 2 : KGK Group

Software Developer ? From Jan 2015 Till sep 2016

Company Name 3 : KCLINK TECHNOLOGIES PVT LTD

Java Developer ? From June 2012 Till Dec 2014

Project #1:

Title :Digital Advertisement Rating(DAR)

Organization : Nielsen

Platform/Technologies :Struts,spring,Oracle 11g,Hive,Impala,HUE,Maven

Team Size: 14 Role : Senior Developer

Synopsis :

DAR is a web based application project which is used to monitor the details of the products added by the user.Initially it will be made as a campaign and then placed in various site,location,country and finally all the data will be grouped according to the user requirement

and pass it to mediaview where user can view the details about his product,the user can able to view only the details,flowchart,charts of his product.so it has been splitted to Daily and weekly according to user requirement.

It is divided into five parts

1.Loader

2.MCH

3.Trackstar

4.DQA /OPS Console

5.Mediaview

In this five parts the process starts from input data loading till displaying the output records in detailed chart according to the user.

The Loader part is where we will load the input data from the various providers and some datas need to be loaded everyday and some once in a year and some static datas will be also provided if necessary.

The MCH part will load all the input datas and move the data into hive tables,in hive db there is a list of input tables all the datas which are loaded will be moved on related tables in Hive.

The DQA part uses certain rules to check the provider data under various conditions .it has certain check id so the data need to be passed inside all this check id,the check id contains sql with conditions if the data passes the conditions it will be passed to output,if fails will be moved back defining in which check id it has been failed.

The ops console part is used to display all the campaigns and their details and their check id if it is failed and all the reports can be viewed here,we can check the results by selecting the date when the campaign is passed so after submitting it will list all the campaigns passed on that date and the details about the campaigns.

The mediaview part is the final part where the output will be converted to charts and graph using front end tools where the user can view the results in detailed chart and graph format.

Project #2:

Title :Enterprise Information System(EIS)

Client :KGK Group

Organization : KGK Creations Guangzhou Ltd

Platform/Technologies :Struts 1.3.2,Spring,Oracle 11g,Jasper Report(iReport)

Team Size: 6 Role : Software Developer

Synopsis :

This is a web based ERP product supporting multilingual, multi-tier, thin client architecture, speedy access over internet. All business functionality is based on Component-based model. This can be organized manage multiple group of companies or service provider across the globe by the concept of Component Interaction Model. Workflow takes care of email notifications and authorization. For safety of business logic we used three level security 1.Domain Security 2.Dynacred (A unique password generator like RSA which is provided by Infosys) 3.Machine level Security with Mac-ID access after ensuring with Database. KGK EIS is a corporate ERP system that can effectively keep track of the modules like Master, Production, Inventory, Purchase, Sales and Shipping from dispersed geographic locations with multiple currencies. It includes Administration and pay role management. All the Web forms are done using JSP with frameworks like struts with springs. This application also consists of 200+ sub modules and 350+ reports (both operational and management level reports). Its efficiency is handling more than 600 Users at the rate of 300 concurrent users.

Responsibilities:

● Prepared the screen design document in Excel to make the working HTML prototype at requirements stage.

● Requirement discussions with business users from reporting expectations and prepared the required report formats in Excel.

● Involved in preparation of System Requirements Specifications (SRS) documents.

● Involved in DB design and Oracle Database Schema creation related meetings.

● Prepared the create user, schema, tables, sequences, views, scripts in Oracle 10g.

● Created complex stored procedures for common components.

● Developed PL/SQL packages, stored procedures, views, table level triggers & functions as per business requirements specified in SRS.

● Prepared complex PL/SQL packages for managing the accounting entries in almost all the transactions like Sales, Purchase, Production, and Pay-roll.

● Prepared the SQL statements for complex & very complex reports.

● Build complex & very complex reports in Crystal Reports and Jasper reports.

● Did the code review of all the stored procedures & triggers developed by myself and team to ensure the proper implementation of business logics & rules.

● Prepared common unit test cases across the entire application and module level specific unit test cases for those which are assigned to me.

● Involved in setting up different environments like Development, SIT, UAT & Production environments.

● Also modified the SQL statements which were having the performance issues in production environment.

● Worked Extensively on PL/SQL cursors and ref cursors.

● Development and maintaining the java coding standards.

● Creating new modules and changes of existing modules.

● Designing and Validating using javascript.

Project #3:

Title :Digital Factory (DF)

Client :KGK Group

Organization : KGK Creations Guangzhou Ltd

Platform/Technologies :Struts 2,Spring,Oracle 11g,Jasper Report(iReport)

Team Size: 3 Role : Software Developer

Synopsis :

This is a web based ERP product supporting multilingual, multi-tier, thin client architecture, speedy access over internet. This is mainly developed for Factory purpose. Changing the total Factory Atmosphere in to Digitalized .will Reduce the paper work and helps the factory workers in time and will increase the outcome of workers. this contains two main divided modules one for making entries digitally inside all factory. Second module mainly used for displaying purpose which will be displayed in TV in all departments .so the employee can know their current work to be finished and next which has to be done. This project helped a lot in increasing the company development . All business functionality is based on Component-based model. This can be organized manage multiple group of companies or service provider across the globe by the concept of Component Interaction Model. Workflow takes care of email notifications and authorization. For safety of business logic we used three level security 1.Domain Security 2.Dynacred (A unique password generator like RSA which is provided by Infosys) 3.Machine level Security with Mac-ID access after ensuring with Database. KGK EIS is a corporate ERP system that can effectively keep track of the modules like Master, Production, Inventory, Purchase, Sales and Shipping from dispersed geographic locations with multiple currencies. It includes Administration and pay role management. All the Web forms are done using JSP with frameworks like struts with springs. This application also consists of 20+ sub modules and 25+ reports (both operational and management level reports). Its efficiency is handling more than 120 Users at the rate of 80 concurrent users.

Responsibilities:

● Prepared the screen design document in Excel to make the working HTML prototype at requirements stage.

● Requirement discussions with business users from reporting expectations and prepared the required report formats in Excel.

● Involved in preparation of System Requirements Specifications (SRS) documents.

● Involved in DB design and Oracle Database Schema creation related meetings.

● Prepared the create user, schema, tables, sequences, views, scripts in Oracle 10g.

● Created complex stored procedures for common components.

● Developed PL/SQL packages, stored procedures, views, table level triggers & functions as per business requirements specified in SRS.

● Prepared complex PL/SQL packages for managing the accounting entries in almost all the transactions like Sales, Purchase, Production, and Pay-roll.

● Prepared the SQL statements for complex & very complex reports.

● Build complex & very complex reports in Crystal Reports and Jasper reports.

● Did the code review of all the stored procedures & triggers developed by myself and team to ensure the proper implementation of business logics & rules.

● Prepared common unit test cases across the entire application and module level specific unit test cases for those which are assigned to me.

● Involved in setting up different environments like Development, SIT, UAT & Production environments.

● Also modified the SQL statements which were having the performance issues in production environment.

● Worked Extensively on PL/SQL cursors and ref cursors.

● Development and maintaining the java coding standards.

● Creating new modules and changes of existing modules.

● Designing and Validating using javascript.

Project #4:

Title : CITY ROAD SHARE

Client :Kclink Technologies Pvt Ltd

Team Size: 15 Role : Software Developer

Synopsis

Cityroadshare.com is a social networking site through which people can meet up for sharing their ride with in the city. City road share is also known as vehicle-sharing and ride-sharing. The main intention of this site is, if you have a vehicle split costs by offering vehicle pools. If you don't have a vehicle, use the system to find a vehicle pool. Through this a Ride Sharer can share his ride with Ride Seeker and Ride Seeker can share a ride with the Ride Sharer. By sharing a ride we can save gas, money and reduce auto emissions and also meet new friends. City road share?s main motto is to control Pollution, parking, traffic and road maintenance. People can share experiences as well as expenses and help each other.

Moderators here work hard 24/7 to provide the services and at the same time maintain the user database very securely and updating it regularly. City road share will only be used by IT/ NON-IT professional?s so as to ensure the safety and security of all the site users.

It contains three main modules Ride Sharer (provider), Ride Seeker (requestor), and administrator.

Environment

Java 1.6,Struts 1.3,Hibernate 3.0,JUNIT,MySql,Tomcat 6.0,Ajax,Eclipse Helios

Contribution

● Team Member for the project.

● Involved in the Requirements gathering.

● Participated in Software design meetings to write technical design documents and to propose design solutions.

● Develop codes based on user requirements documentation.

● Develop web-based application using Struts.

● Use Hibernate framework for the java object persistence in database.

● Involved in unit testing.

● Estimate and plan development work, report on task process and deliver work on schedule.

Project #5:

HRMS(Human Resource Management System)

Client: Kclink Technologies Pvt Ltd

Team Size: 12 Role: Software Developer

Synopsis

Human Resource Management System is an online employee management system,it contains Two Modules,Employee Module and Admin Module.

Admin Module is the Module done for the administration of the employees who can register a new employee, can accept leaves, performance appraisal, and view feedback from the employee, salary management and login checks of the employee.

Employee Module is the module done for the employees who can login and view and update the whole information (educational, personal, address)about him, Leave Management,training and project details, beneficiary management.

Environment

Java 1.6,Struts 2.0,Hibernate 3.6,JUNIT,MySql,Tomcat 6.0,Ajax,Eclipse Helios, JSP.

Contribution

● Team Member for the project.

● Involved in the Requirements gathering.

● Participated in Software design meetings to write technical design documents and to propose design solutions.

● Develop codes based on user requirements documentation.

● Develop web-based application using Struts.

● Use Hibernate framework for the java object persistence in database.

● Involved in unit testing.

● Estimate and plan development work, report on task process and deliver work on schedule.

AIX ADMINISTRATION

● Disk Storage Management in AIX ? Logical and Physical Volume Configuration and maintenance.

● Creating and removing the Volume Group, Logical volume, File systems.

● Modify (Extend and Decrease) LV, PP(rootvg and othervg), FS

● Configuration of new devices using cfgmgr - Disk Replacement incase of any disasters. Working with mirrored logical volumes.

● Extending and Reducing Volume groups and Logical Volumes etc.

● Installation, Migration of AIX operating system.

● Mirrored and un mirrored the volume group.

● Working with paging spaces ? creation, increase, decrease paging spaces as per the requirement.

● Restoring the mksysb and savevg and filesystem backup.

● Replacement in the failure disk (rootvg, other vg, SAN)

● User Maintenance and Group Maintenance

● Performing various tasks related AIX Logical Volume Manager.

● Configuration of Network File System (NFS).

● User Administration tasks such as create users, define or changes their attributes, and define the security environment for the users.

● checking for error report on servers

● Monitoring server performance and disk utilization, failed logins etc

● Performance data from reporting tools like topas, iostat, and vmstat.

● Software Install in AIX ? Package and patch install

● Handling Export and Import Volume Group (Moving Vg One node to another node)

INDUSTRIAL TRAINING:

● Undergone Industrial Training in IBM, India From June2007 till July2007

● Undergone Industrial Training in INDIAN RAILWAYS, India From 16th Nov2006 till 23rd Nov2006

EDUCATION

B.E - COMPUTER SCIENCE ENGINEERING :Anna University, 2007 - 2010, India

DIPLOMA : Board Of Technical Education, India

HIGHER SECOUNDARY : Revoor Padmanabha Higher Secoundary School, India

SSLC :Vellayan chettiar Higher Secoundary School, India

PERSONAL DETAILS

Date Of Birth : 19th Oct 1987

Gender : Male

Languages Known : English(R/W/S), Tamil(R/W/S), Telugu(S)

Nationality : Indian

Marital Status : Single

Passport No : K3846499

Phone Number : +86-136-********

Notice Period : Immediate

Present Address : Shanghai

Declaration

I hereby declare that all the particulars stated above are true to my knowledge & brief. I hope that, I will satisfy all your needs, if am selected in your concern.

Date :

Place :

Contact this candidate