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