16-08-2012, 03:56 PM
Payroll Application Overview
1Payroll Application Overview.ppt (Size: 777.5 KB / Downloads: 48)
Introduction
About the company
Tata Consultancy Services (TCS) Limited is an IT services, business solutions and outsourcing organization that delivers real results to global businesses, ensuring highest level of certainty and customer satisfaction.
TCS offers a consulting-led, integrated portfolio of IT and IT-enabled services delivered through its unique Global Network Delivery Model TM, recognized as the benchmark of excellence in software development.
More than 96 % of TCS customers reward the company’s reliability, passion, creativity, and unique ability to handle the broadest range of their IT needs by continually extending and deepening their partnerships with TCS.
My assignment in TCS
In TCS, I have been assigned to a project named 'Payroll Management'.
The project involved Payroll Application development and maintenance for a US based customer.
I have completed the following in my training :
Understanding basics of Payroll Application
Undergone training in RDBMS Concepts
Undergone in-depth training in SQL Server 2008 for 5 weeks
Understanding the database structure of Payroll Management application
Basic Overview of Payroll Application
Windows based UI: This is a Back-office application used to enter and manage client data for payroll calculations.
Payroll Processing Engine : This is the payroll gross to net engine. It updates all employee changes, processes employee pay transactions and performs all payroll calculations to produce the results of the employee pays and adjustments. It does not have any UI and runs in light-off mode.
Web UI: This is a web front for the Windows UI. It is a web application where customer can directly enter data and generate reports.
Basics of RDBMS
RDBMS is an abstract theory of data that is based on mathematical concepts of relations.
It is concerned with three aspects of data
Data structure
Data integrity
Data manipulation
Its data structure consists of tables which are matrix of a series of row and column intersections.
It is easy to maintain data in RDBMS than in other models.
Relationship among tables is maintained in RDBMS whereas this is not the case with DBMS as it is used to manage the database.
DBMS accepts the ‘flat file’ data that means there is no relation among different data whereas RDBMS does not accept this type of design.
Although the foreign key concept is supported by both DBMS and RDBMS but its only RDBMS that enforces the rules.
RDBMS solution is required by large sets of data whereas small sets of data can be managed by DBMS.
DBMS is used for simpler business applications whereas RDBMS is used for more complex applications.