Banner Image

All Services

Other

Data Processing / DBMS Expert

$5/hr Starting at $25

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.

About

$5/hr Ongoing

Download Resume

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.

Skills & Expertise

Data EntryData ManagementData ProcessingDatabase DevelopmentMicrosoftMicrosoft ExcelMicrosoft Excel FormulasMicrosoft WordOrder ProcessingServer AdministrationSQLVBA

0 Reviews

This Freelancer has not received any feedback.