Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Michael Vinoth

VBA Macro &Java Developer
Tirunelveli

Summary

Talented VBA developer with 9.8 years of experience in developing successful custom applications.


Core Qualifications:

Proven background translating cell formulas in excel in to VBA code and using Excel-based VBA to design, analyze and deploy programs for Banking industry.

Proven background completing projects under aggressive financial and time constraints.

Exceptional analytical and project management skills.

Proven background on training need identification and designing VBA training programs.

Expert in handling Monarch software.

Overview

10
10
years of professional experience
2
2
Languages

Work History

Senior Macro Developer

Tata Consultancy Services
08.2016 - Current
  • To develop and modify VBA code for Microsoft Products
  • To develop and modify Access databases (start-to-finish)
  • Responsible for all project life cycle phases, from specifications and coding through deployment, testing, debugging, documentation and maintenance
  • Aided in development and management of Access database solutions using SQL server, including macros and reports
  • Assisted to migrate the legacy manual Excel workings by using VBA which resulted in cost effective and improved accuracy of the process
  • Worked with Monarch application and assisted to create multiple models to convert notepad to excel and simplifying the process steps
  • Worked for APAC countries which covers 8 countries to automate the manual excel workings using macros which helped in reducing 9.5 head count in the process which resulted in client appreciation and delight
  • Assisted the team members by helping them to extract data from multiple application and provide the same in readable format using MS Access without the support of the cost involved “Monarch” application
  • This helped remove the waiting time & people dependency within the teams and also ended up in “client Delight” as it gave a cost save to the clients


Management Support activities:

  • Designed a dashboard for the Management using multiple formulae, tables & charts to capture the quality of the Employee contribution towards various trainings and its outcome apart from the regular process related productivity
  • Designed an Excel based tracking system to capture the monthly performance of the employees which paved the way for smooth appraisals and was implemented across all country projects in the unit
  • Designed an user friendly employee database using MS Access which acted as a centralized dump for the whole unit of around 150 employees
  • Designed a critical daily usage MIS by using VBA in excel by extracting data from multiple sub folders and populating the same in excel and automatic mail trigger to the concerned stake holders
  • Assisted the management to “Go Green” and parallelly save a huge cost involved in printing papers & scanning by bringing digitalized Maker checker controls.

Senior Macro Developer

AMP Technologies
12.2012 - 08.2016
  • Implemented Software components as per business requirements
  • Met multiple Projects ahead of deadline
  • Developed custom made applications for multiple clients
  • Created more than 150 Macros to reduce time, effort and increase the Quality
  • Conducted training programs on Excel, VBA, Macro & MS Word
  • Assisted teams in working with Macro, Excel and Visio
  • Conducted Kaizen Projects & training
  • Conducted Quality Awareness Session for New Hires
  • Key contributor in AMPulse, AMPed and AMPcare Initiatives
  • Maintaining Reports, Dashboard

Education

Master of Business Administration - HR & Systems

SCSVMV Deemed University

Bachelor of Business Administration - undefined

St. Xavier’s Autonomous College

Skills

HTML, CSS, Javascript, Jquery – Basicsundefined

Additional Information

  • Received ‘Employee of the Month’ Award thrice in AMP Technologies
  • Received ‘Prism’ Award for best trainer in AMP Technologies
  • Received Best Dancer Award 2014 in AMP Technologies
  • Team Excellence Award 2014 & 2015 in AMP Technologies
  • Received ‘On the Spot’ Award in TCS Received ‘Star Performer’ Award twice in TCS

Timeline

Senior Macro Developer

Tata Consultancy Services
08.2016 - Current

Senior Macro Developer

AMP Technologies
12.2012 - 08.2016

Master of Business Administration - HR & Systems

SCSVMV Deemed University

Bachelor of Business Administration - undefined

St. Xavier’s Autonomous College
Michael VinothVBA Macro &Java Developer