AWARD AND RECOGNITION
Project by: Mr. Mohammad Shabbir Taibani
Category: Access, SQL & VBA
Project Title: Monthly PKT
Level of Complexity: 7/10
Company Name: WNS
Name of the Award (if Any): Nominated for best Brainwave
Savings: Paper & Other Stationary cost.
Area or Field of Project: Project Management
Previous Situation
Task:On monthly basis operation team need to conduct product test for 250 + employee ( around 20 objective type question)
Challenges:
1) Setting of question paper
2) Printing of question paper ( average 5 , A4 size paper)
3) Need to provide pen or pencil to every one
4) Manually check each and every paper by Team leader
5) Employee has to wait for test result
6) Manually analysis of report ( which is quite difficult)
7) Need to prepare manual report in excel for result
Tools used in the project: MS Access, VBA, SQL, and excel ( for reporting)
After Situation
Monthly PKT test form created in MS Access
Improvement in efficiency :
1) Can upload 25 odd question ( random question will populate for every employee)
2) No need to Printing of question paper
3) No Need to provide pen or pencil to every one
4) No need to check each and every paper by Team leader
5) Auto check for every Test paper and Employee get result immediately after finishing test
6) No need to manually analysis of report , now available in one click of pivot refresh ( Import data from MS Access)
7) No need to prepare manual report in excel for result ( Import data from MS Access)
8) Can save all test answer and result as soft copy for future reference
Posted on 03/12/2013 14:40:24
Project by: Mangesh Shivarekar
Category: Advanced Excel + VBA/Macros
Project Title: Training & Exam
Level of Complexity: 7/10
Company Name: ITCube Solution Pvt Ltd
Area or Field of Project: Training Reports
Previous Situation: There were all paper work prior and no specific guideline, which made things difficult in giving training and analyzing new candidate based on his performance.
Tools used in the project
I have used many excel tools to create new reports and standard exams.
I have used many Formulae (Hlookup and Vlookup), charts to create dashboards.
Now I have created macros for exams to make things easier for the candidate who is giving exam.
After Situation
After my new reports and standards exams preparation in excel, many things gets lined up.
Now, all new reports are automatic along with calculation of the percentage, dashboards and graphs which made evaluation of candidate bit easy.
Posted on 3/13/2013 23:50:26
Project by: Amol Suresh Jadhav
Category: Access, SQL & VBA
Project Title: Consolidator
Level of Complexity: 8/10
Company Name: Aspect Ratio
Name of the Award (if Any): Star Award - Process excellency award Dec 2012
Area or Field of Project: Forecasting Model
Previous Situation
Situation - Client was looking for tool which can be used in various countries. so it must be user friendly, easy to handle. It should work without any user interface.
- Dynamic Chart automation on User form.
- Text,excel file - Data consolidation
- Export chart as picture from user form to pdf,PPT,Excel file with and without data
- Dll integration Project
- VBA wrapper to run SQL Stored procedure.
Tools used in the project
Charts on User Form, Charts on Excel sheet, Various reports, Dashboard.
Data consolidation using VBA.
MS-Access as Database
SQL Server as Database
After Situation
Client was very happy with the tool. it was very user friendly and everything was automated.
I join this company in Sept 2012 and I got my first award in Dec 2012.
Now I am working on Forecasting model Project.
Posted on 3/14/2013 11:13:33