Shinoy B.

Shinoy B.

IT Professional with 20+ Years of Experience in Delivery/Program/Project Managment, Excel VBA expert

Kochi , India

Experience: 20 Years

Shinoy

Kochi , India

IT Professional with 20+ Years of Experience in Delivery/Program/Project Managment, Excel VBA expert

20 Years

Now you can Instantly Chat with Shinoy!

About Me

IT Professional with 20+ years experience in US based software product companies. A known expert in Excel VBA. Has developed many Excel VBA programs for Management teams like status report generator, Employee Cross training tracking, Employee Capa...

Show More

Portfolio Projects

Employee Capacity Planning Tool

Company

Employee Capacity Planning Tool

Role

Full-Stack Developer

Description

Created an MS Excel Tool to capture planned work and routine maintenance tasks for 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

Show More Show Less

Skills

MS Office

Tools

MS Excel

Excel VBA Status Report Generator

Company

Excel VBA Status Report Generator

Role

Full-Stack Developer

Description

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

Show More Show Less

Skills

Excel VBA

Tools

Excel Macro

Cross Training Report Generator

Company

Cross Training Report Generator

Role

Full-Stack Developer

Description

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.

Show More Show Less

Skills

Excel VBA

Tools

Excel Macro

Daily Manpower Consolidation Tool

Company

Daily Manpower Consolidation Tool

Role

Full-Stack Developer

Description

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

Show More Show Less

Skills

Excel VBA

Tools

Excel Macro

Instrument Calibration Management Tool

Company

Instrument Calibration Management Tool

Role

Full-Stack Developer

Description

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

Show More Show Less

Skills

Clipper
Share:

Verifications

  • Profile Verified

  • Phone Verified

Available Timezones

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]