As an Excel Expert having sound knowledge of dealing with basic to advance formulas like Sum, SumIF, Sumifs, count, countif, countifs, & many more basic to advance formula. Data Validation, Conditional Formatting, VBA, Micro, Graphs. Provide excel based menu driven payroll automation in connectivity of bio metric machine, this includes fetching daily attendance data (in/out time), generating work hrs & over time calculation, Monthly attendance register with considering paid holidays, weekly off, generating Salary Sheet with OT calculation, Leave Register, Salary Slip for employees.
As an ABAP Consultant : Sound knowledge of developing ALV reports, Screen Painter for designing user input screens, ABAP Workbench, Custom Development, BDC for T Code automation or autofiling data in standard tables using excel templates.
Products:
1. Excel Based Payroll System : This automated payroll system grab In/Out data from bio-metric machine, & create attendance on the basis of hours worked, also it generated Over Time work hours, on the basis of attendance it generates monthly payroll / salary sheet, the system automatically mark as holiday if holiday list is maintained, It also mark Employee Leave in lieu of bio-metric attendance, also it maintain yearly leave record of each employee.
2. Excel Based Quotation System : After creating quotation in provided template, the system automatically create follow-up record for the said quotation, where user can maintain periodical follow-up details. After realization of quotation, user will mark it as closed.
3. Excel Based Invoice System : after creating invoice in provided template, the system automatically update periodical sales register (Item wise), day book to record daily sales transaction (Header data only), Debtor Outstanding on tips.