Hey, I have excellent professional knowledge in:
Data Processing (MS Excel, MS Access, SQL Server Database)
MS Access - Complete Package with macros and VBA.
Dynamic Reports in MS Access
Front End Development in MS Access
Custom Functions and Macros (MS Access and MS Excel)
Dynamic Query Writing (MS-Access and MS SQL Server)
MS Excel - VBA and PowerPivot
MS Excel Formulas (Ranging from functions i.e. text, numeric, dates and statistical)
MS Excel Charts
MS Excel Customer Function Writing
SQL Programming
SQL Server Database Development (Backup and Recovery Management)
Data Transformation (MS Excel to MS Access to SQL Server Database and vice-versa).
Previous Projects (Completed / Operational)
- Exam Software (MS-Access)
. Student Enrollment
. Exam Enrollment
. Custom Subject Selection
. Award List Entry through Interfaces
. Result Compilation and auto position calculation
. Master Sheet showing a result of a class
. Parent-Teacher Meeting Sheets
. Teacher's Progress Calculation
. Subject Wise Progress
. Class Wise Progress
. Any more features.
- Question Bank and Paper Generation (MS SQL Server with VB.Net and Crystal Reports)
. User Management
. Teacher Enrollment
. Controller Assign Courses to Teachers
. Teachers Maintain Question Bank and Generate Question Papers (MS-Word format)
- Clinical Lab Reporting System (MS-Access)
. Tests Catalogues
. Separate code for each test
. Optimized search for previous reports
. Maintains record of all reports.
. Customized Test Result Display feature.
- Fast Food Invoicing System (MS SQL Server with C#.Net and Crystal Reports)
. Two Users (Admin / Salesman)
. Admin creates users, shifting opening/closing, monthly sales statement etc.
. Salesman enters (orders take-away, home-delivery, dinning).
. Salesman generates bill (for customer and menu for kitchen).
. Bill Printing (Thermal Printer)
- Employee Management Information System (MS Access)
. Employee Management
. Service Record Management
. Employee Evaluation
. Posting History
. Promotion History
. Contract History
. Multiple Reports (more than 30 reports/summaries)
- Medicine Inventory Information Management System (MS Access)
. Patient visit record
. Medicine issued to patient history
. Medicine purchase history
. Medicine Inventory Management
. Ledger Management.