The company had multiple factories at different geographical locations and they receive daily manpower raw data from all factories in the morning. From those reports, the HR team used to manually generate consolidated reports which was very time consuming. I created an Excel VBA tool to automate data consolidation and report generation which made their life easier. Input to the tool are the raw data excel files received from various factories. My Excel VBA program reads data from these input excels which are in different formats and create final input data for the tool by converting all data to a unified format. Then my program reads this formatted data and generates various Manpower summary and cost reports with a click of a button. The report generation time reduced from few hours to just 5 minutes with the help of this tool

Created an MS Excel Tool to capture planned work and routine maintenance tasksfor each employee in the team to automatically generate Employee Capacity Utilization Charts based on selected parameters . Using the charts capacity plan for a sub team or a Technology group or the entire project can be generated. It helps in planning additional work looking at spare capacity of the team in the upcoming weeks/months

The status report generator is an Excel VBA based tool which I created to automatically generate Status reports for various Application Groups based on the Project, Defect and Ticket Status updated in SharePoint site. Input to the Excel VBA tool is the excel data dump extracted from the Sharepoint site. The Excel VBA Status report generator reads these data dump files and add reference data to it to create final input data tables for status report generation. The report generator automatically generates Project Status report , Defect Status Report, Ticket Status Report and Work Summary showing tabulated summary of Projects, Defects, Tickets. The tool helped in reducing Status report generation time from few hours to just 5 minutes

As the project had ~120 employees supporting ~60 applications each application support team comprising 1 to 3 employees, cross training was very important activity in view of losing Application knowledge in case of Attrition. To Keep track of Cross training, a complex Excel worksheet was created which recorded each employee's primary support applications , expertise level, cross trained application list with expertise levels and the plan for cross training. To generate a pivot table report from this tracker was very difficult and so I created an Excel VBA Cross Training Report Generator which helped in generating meaningful reports that show summary of number of employees cross trained in each of the application and their expertise level. This helped in properly planning cross training for those applications who didn't have adequate number of employees cross trained.

Main Focus area for ISO Quality Audit in a Production Plant is the Measuring Instruments Calibration as these instruments are used in almost all technical departments and controlled by Quality Assurance Department. A small company will have around 3000 to 5000 measuring instruments and to maintain its calibration status periodically is a tedious job and retrieval of latest calibration status of each instrument in 3 minutes (mandated by ISO Quality statndards) is very difficult if data is maintained manually. I had created a Clipper Application to create a fully paperless system for manaing instrument calibration. It generates Calibration Card for each instrument and stores data in Clipper database. Just give the instrument serial number and it immediately retrieves the latest calibration data and all historic calibration data in few seconds.It automatically generates Instrument Call Notice to the user department well in advance before the instrument recalibration date so that they can submit the instrument to Quality Assurance department for recalibration