Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Additional Information
Paintings, Verse Writings, Journal Blogs, Musics, Movies
Timeline
Generic

MURUGAVEL. K. N

Data Analysis / Full Stack Web Developer
Al Khaimah

Summary

More than 15+ Years of Experience in Software Development. More that 12+ Years of Experience in Teaching. Strong in BI Data Analytics & Analysis, PowerBI Visualization, SQL Developer, Full stack Web Developer, JSON, JQuery, JavaScript, JSP, Java, Java Servlets, C, C++ Have professional software design and development experience in the areas of Internet and Electronic Commerce. Experience in application software development in the IT industry. Specialized in Analysis and Design of application using RDBMS / DBMS. Well Qualified in Computer Science Engineering.

Overview

28
28
years of professional experience
6
6
Certifications

Work History

STEWARD Cum BI Analyst

DATA, Gulf Pharmaceutical Industries, JULPHAR
01.2013 - Current

charge cum Assistant Professor

Birla Institute of Technology, Ras Al
Ranchi
04.2007 - 01.2013

Assistant Professor and Head

Seshachala Institute of Computer Studies
Puttur
08.2004 - 10.2006

Lecturer

N.B.K.R. Institute of Science and Technology
12.2001 - 08.2004

System Analyst

dotSys Soft Solution
Chennai
01.2000 - 12.2001
  • Description
  • The software was developed for Certification of sample materials and making bills for the testing job
  • Element module deals with maintaining the details of various testing methods by Category wise
  • Quotation module deals with generating the quotation for individual Customers
  • Order Module involves in making the order form for testing the given samples
  • Certificate module is used for maintaining the testing results of samples category wise and creating the certificates based on these results
  • Reports module consists of Working (Labour) sheets are generated for entering the results after testing the samples from lab
  • Generation of Certificates based on test results
  • Bill details based on Testing Samples
  • Accounts status relating to a customer
  • Staff information [profile and their wages]
  • Expenses statement [under each category]
  • Title Purchase and Sales System, The Company purchases fabric from manufacturers and sells it to the retailers, wholesalers and as well as the end users (tailors)
  • The software automates the purchase process and keeps track of the sales to end users, retailers and wholesalers
  • A survey report maintained using the data given by sales rep's gives the management insight on the demand for a estimated time period
  • The following modules constructed in the package are Administration module, Product Modules, Sales Module, Purchase module, Accounts module
  • The Reports module consists of the following reports Stock Details, Purchase Details, Sales Details, Agent commission details, Expenses statement, Customer and Supplier Account Details
  • Title Chit Fund Accounting System, The company runs chit funds wherein every customer deposits a fixed amount of money for a fixed period
  • The company runs periodic lucky draw for giving bonus
  • After the maturation of the deposits the customer is entitled for a purchase of any jewel equivalent to the matured amount with bonus
  • The |Modules involves in the package are Group Allotment Module, Amount entry Module, Lot entry
  • Reports are Customer information by group wise, Lot Information, Group Information, Total Collection Details, Transaction Details
  • Title Medicinal Storage & Retrieval System
  • Organisation Broadline Computer

Client Tamilnadu Medical Services Corporation Ltd
  • Description
  • Medicinal Storage and Retrieval Systems aims to maintain the storage of drugs in effective manner
  • The function of this software includes placing the drugs in its appropriate shelves based on the expiry date, and packing method
  • The drugs are placed on the pallet, this pallet placed on the steel plate
  • So that it can be retrieved easily
  • The Location of the rack is detected through this system
  • Information System
  • Organisation Broadline Computer System

Tamilnadu Medical Services, Corporation Ltd
  • This Software is used to track drugs which are coming into warehouse and issue them to various hospitals based on the expiry date and the allotment for the hospital
  • It takes care of some important facts like maintaining a buffer stock to issue in the case of emergencies
  • Data is transferred to the head office daily so that an overall stock situation can be derived in the head office.

System Analyst cum Programmer

Broadline Computer Systems
Chennai
08.1996 - 12.2000

Programmer

Computer Links
Chennai
12.1994 - 07.1996

Education

PMP -

IIT

Ph.D. - Computer Science

University of Madras
Chennai, Tamil Nadu
04.2001 -

Master of Computer Applications (MCA) - undefined

University of Madras

Postgraduate Diploma - Computer Applications

Loyola College

Postgraduate Diploma - Business Administration

Annamalai University

B.Sc - Maths

Sacred Heart College

Skills

CRM Data Mining and Data warehousingDatabase Design and Normalizing for Optimal space to execute effectivelyCore Java, Swing, JSP, Servlets, EJB, JDBC, XML, ASP, ASPNET, PHP, C, C, FORTRAN, COBOL, CGI-PERLScripting Languages: JavaScript, HTML, VBScript, Perl, ASP, PHP, AJAX, jQuery, Google Graphs, Morrisjs, ChartjsOperating System: MS Windows 9x/NT/7/10/11, UNIX, MS DosDatabase: MS-SQL Server, MySQL, MS Access, Oracle and FoxPro

Accomplishments

  • Faculty Development Programmes: “Orientation Programme” conducted by UGC at Sri Venkateswara University, Tirupati from 23/05/2005 to 18/06/2005
  • Faculty Development Program” conducted by Andhra Pradesh State Council of Higher Education with UGC in Wipro Technology, Hyderabad at Sunflower Training Room in Manikonda From 06/10/2006 to 8/10/2006
  • Being as “Academic Judge” for the “Software Development Trade Show” held at University of Wollongong University of Dubai (UOWD) on 28, April 2010
  • Project Profile(Developed)
  • Title: In-Market Sales Reporting Automation
  • Organization Gulf Pharmaceutical Industries (Julphar)
  • Platform: Windows
  • Tools: MS-SQL Server, T-SQL Query Language
  • Team Size: 1
  • Role Analysis, Design and Coding
  • Description
  • Design the backend data model which provided all the information for In-Market sales which deals PVT and LPO Sales
  • This is live sales and stock data from various countries like AE, BH, OM, JO, SA, LB
  • Still need to add other possible countries like DZ, EG etc
  • This provides information to both Commercial team and finance Team to know the information on Price Compensation and Discounts, Rebates as per the Commercial condition agreement by customers
  • This provides Sales forecast and Inventory forecast
  • The price Compensation and commission compensation, discount and Rebates are calculated according to the country
  • This data model using for Data visualization using PowerBI tool
  • This dashboards are for teams who are all required the information on this
  • Title: IMS Data Model
  • Organization Gulf Pharmaceutical Industries (Julphar)
  • Platform: Windows
  • Tools: MS-SQL Server, T-SQL Query Language
  • Team Size: 1
  • Role Analysis, Design and Coding
  • Description
  • This backend data model which provided all the information of all countries IMS Data which Extracted by country wise from IMS System and integrated into one data model
  • This Data Model has the molecule combination for every SKU’s
  • In this the based on manufacturer and Pack with strength, also Value and Units as YTD and Value and Units as MAT are calculating on execution time in the data model
  • This data model also using for Data visualization using PowerBI tool to the teams to use
  • Title: www.biticrak.ae
  • Organisation BIT-IC, Ras Al Khaimah, UAE
  • This project is developed as a distributed application with Web enabled for the customer, enhancing the existing Ordering System giving more features like online public access, Approval handling by the administrators and also enhancement of User Interface to make it more user friendly
  • The Online Ordering System is developed using Java’s powerful server side programming language, servlets
  • Customers can access the system remotely and search for the Books based on different categories provided
  • Author, by Title, by Category, enhances the search facility to search; by Available etc.and can order the books on-line
  • The payment process is also an added feature that accepts all the major credit cards for online purchase
  • Payment process is done through the payment gateway, which the cline of this project has made a contract with
  • Title Material Resource Planning
  • Organisation dotSys Soft Solution,
  • Platform Windows-NT 4.0
  • Tools Java, JDBC, Servlets, HTML, JavaScript
  • Duration 4 months
  • Team Size 3
  • Description
  • The Project deals with the assurance of a large engineering firm, in general and in particular the inspection and testing of product at various stages from the raw material to the finished product
  • There are various types of documents generated by the quality assurance department to check the quality of the product
  • Quality Acceptance Note (QAN) document is used for the acceptance or rejection of the material/item
  • Finished Product Acceptance Note (FPAN) is used for the acceptance/rejection/rework of the final product
  • Reacceptance Note (RAN) document is used after the inspection of previously rejected material/item or product which has been send for re inspection or rework either at the inward or final stage
  • The dispatch memo document is used to indicate the rejected material after the inspection, which has been sent to stores department
  • Title An Intranet Leave Management system
  • Organisation dotSys Soft Solution,
  • Platform Windows-NT 4.0
  • Tools JSP, JDBC, HTML and Java Script
  • Database Oracle
  • Team 2
  • Description
  • This Project aims at automation of the Leave Processing System
  • The System should significantly reduce the time spent on processing paperwork and considerably reduce the burden on organization to maintain employee records
  • This system will optimize the administration setup
  • This system provides all possible options for leave processing applying for leave, canceling the leave, pending leave registration of new employee and generating the reports based on department and designation wise
  • Title Material Evaluation System
  • Organisation dotSys Soft Solution,
  • Platform Windows-NT 4.0
  • Tools Java, JDBC, HTML and Java Script
  • Database Oracle, Title Fixed Deposit System
  • Organisation Computer Links, Mylapore, Chennai - 4
  • Client Triplicane Permanent Fund Ltd., Triplicane, Chennai - 5
  • Software FoxPro 2.6
  • Role Design and Development
  • Description
  • This system was developed for Triplicane Permanent Fund Ltd.,
  • The main aim of the software is that it maintenances list of persons who have invested with their respective amounts
  • The feature of the software is it calculates interest for the invested amount and sum up to the original amount
  • The reports generated by this software are Daily transaction report and maturity list report
  • Title Jewel Loan System
  • Organisation Computer Links, Mylapore, Chennai - 4
  • Client Triplicane Permanent Fund Ltd., Triplicane, Chennai - 5
  • Software FoxPro 2.6
  • Role Design and Development
  • Description
  • This system was developed for a finance company that gives loan on Jewels
  • The software maintains the number of days the borrower has not paid interest
  • If the day increases the dead line, software generates the list of jewels that has to be auctioned
  • The reports that are generated by this system are daily transactions, Interest pending report, reports of warning letters that has to be send to the borrower
  • Title Invoicing System
  • Organisation Computer Links, Mylapore, Chennai - 4
  • Client Hydro Systems Pvt
  • Ltd., Egmore, Chennai
  • Software FoxPro 2.6
  • Role Development and Implementation
  • Description
  • This Software was developed for dealers of chemical goods
  • This software main function is to generate bills for the supplied goods and it is also use for accounting purpose
  • The most important feature of this software is that it interacts with existing software
  • The reports that are generated in this system are bill's reports, transportation report and daily transaction
  • Personal Profile
  • Father’s Name K.N
  • Nagalingam

Certification

Paper Publications / Seminars / Workshop / Paper presentation Attended: Paper Publications

Additional Information

  • Description This is the project Java, Oracle with the implementation on Threading Concept to access with multi- users. The software developed the Accounting for the students and the faculty members of the college having Internet Accessing Card. The Accessing hour of each day has been accounted and maintaining the remaining hours to access through this software by login into the system which has included in the software. After finishing their allotted hours, the software won’t allow the user to access the Internet. Here the back-end is Oracle8.0 and the Front-end designed with JAVA 2.0. The Internet Explorer can be accessed only through this software, no other facility to access without login. With the machine number the user ID and the login time and logout time are stored in the database. Role Worked on Admin Setup module Involved in design of protocol between admin and user module Title On-line Ordering System
  • .1 sp1 Team Size 4

Paintings, Verse Writings, Journal Blogs, Musics, Movies

Interest in paintings and line drawings. Writing poetry (verse)-published 4 books so for. listening musics and watching movies.

Timeline

STEWARD Cum BI Analyst

DATA, Gulf Pharmaceutical Industries, JULPHAR
01.2013 - Current

charge cum Assistant Professor

Birla Institute of Technology, Ras Al
04.2007 - 01.2013

Assistant Professor and Head

Seshachala Institute of Computer Studies
08.2004 - 10.2006

Lecturer

N.B.K.R. Institute of Science and Technology
12.2001 - 08.2004

Ph.D. - Computer Science

University of Madras
04.2001 -

System Analyst

dotSys Soft Solution
01.2000 - 12.2001

System Analyst cum Programmer

Broadline Computer Systems
08.1996 - 12.2000

Programmer

Computer Links
12.1994 - 07.1996

Client Tamilnadu Medical Services Corporation Ltd

Tamilnadu Medical Services, Corporation Ltd

PMP -

IIT

Master of Computer Applications (MCA) - undefined

University of Madras

Postgraduate Diploma - Computer Applications

Loyola College

Postgraduate Diploma - Business Administration

Annamalai University

B.Sc - Maths

Sacred Heart College
MURUGAVEL. K. NData Analysis / Full Stack Web Developer