beBee background
Professionals
>
Technology / Internet
>
Chennai
Vinoth Kumar

Vinoth Kumar

VBA Developer
Chennai, Chennai district

Social


About Vinoth Kumar:

Total 11 Years and 9 years in to MS Excel VBA, MS Access VBA, MS Access Database and MS SQL Server to create reports by Automation and Manual.

Experience

 

Work Experience

 

Organization                     :           Working independently on Freelance Projects.

 

Duration                          :           Nov 2020 – Till Date

Industry                           :           BFSI 

Designation                      :           Sr. Developer/Team Leader

Role                                :           Coding and Testing

Environment                     :           Windows 7, MS Excel VBA, MS Access VBA 

Project Details                  :           Excel Automation

 

--------------------------------------------------------------------------------------------------------------------------------

 

Organization                     :           TekSystems (Worked for HSBC, Pune)

 

Duration                          :           Dec 2018 – Nov 2020

Industry                           :           Banking 

Designation                      :           Senior Excel VBA Developer (Worked as Developer in HSBC)

Responsibilities                 :           Handling Scrum Team, Coding, Testing and Deployment

Environment                     :           Windows 10, MS Access, MS SQL Server and MS Access VBA.

 

Description                       :

  1. The tool is designed to extract Daily, Weekly, Monthly, Quarterly and Yearly reports for 47 Countries according to their currency value.
  2. Handling Scrum Team, Client Coordination along with Product Owner.
  3. Communicate with clients to understand business requirement and delivering the product on time.

--------------------------------------------------------------------------------------------------------------------------------

 

Organization                     :           Working independently on Freelance Projects

 

Duration                          :           Jul 2016 – Dec 2018

Industry                           :           Freelance

Designation                      :           Developer

Role                                :           Coding and Testing

Environment                     :           Windows 7, MS Excel VBA

Project Details                  :           Excel Automation

--------------------------------------------------------------------------------------------------------------------------------

 

Organization                     :           Thirdware Technology Solutions, Chennai (6 Month Contract)

 

Duration                          :           Dec 2015 – Jul 2016

Industry                           :           Automobile (Worked for Ford Global Technology & Business Center, Chennai)

Role                                :           Technical Analyst

Environment                     :           Windows 7, MS Access Database, MS Excel VBA and MS Access VBA

Project Details                  :           

  1. Designing, development, enhance the applications in MS Excel VBA, MS Access.
  2. Communicate with clients to understand the requirement and do the enhancement.
  3. Responsible for troubleshoot bugs, production support

 

--------------------------------------------------------------------------------------------------------------------------------

Organization                     :           Wipro Ltd, Chennai

Achievements                   :           Innovative Automation Award in Wipro Ltd, Chennai

Duration                          :           May 2012 – Aug 2015

Industry                           :           Finance and Accounts for US Client

Role                                :           Senior Software Engineer - Business Optimization Services and Solutions

Environment                     :           Windows 7, MS Access Database, MS Excel VBA and MS Access VBA

Project Details                  :           

  1. Developed more than 75 MS Excel VBA tools to extract Daily, Weekly, Monthly, Quarterly and Yearly reports as per the Client requirement.
  2. Holding ownership for 300+ database applications available with the client
  3. Responsible for Business optimizations, troubleshoot bugs, production support
  4. Designed, Writing Code, Developed, Enhancement for MS Excel VBA, MS ACCESS VBA.
  5. Actively involved in Upsizing (On site) the database applications from MS Access 97 to MS Access 2010.
  6. Manual testing – writing test case, bug fixing and bug reporting.

 

--------------------------------------------------------------------------------------------------------------------------------

 

 

 

 

 

 

 

Organization                     :           Zensar Technologies Limited, Pune

 

Achievements                   :           Developed “CSAT Database Tool” Survey Report and Successfully Deployed 

Duration                          :           October 2010 – April 2012

Industry                           :           World's leading IT and Networking Industry (For Japan and Australia Client)

Role                                :           Software Engineer

Environment                     :           Windows 7, MS Access Database, MS Excel VBA and MS Access VBA

Project Details                  :           

  1. As a Team member of the Intelligence Metrics Reporting team, I am responsible for the following:
  2. Maintenance and up gradation of various tools designed in MS Excel VBA and MS Access Database.
  3. Developed Tool using MS Excel VBA, MS Access VBA and MS Access Database to extract Daily, Monthly and Yearly Reports for sales team.
  4. Involved in development, up gradation and maintenance of various sales related tools developed in MS Excel and MS Access.
  5. MS Excel VBA macro Enhancement.
  6. Manual testing – writing test case, executing it and bug reporting.

Training

 

  1. Undergone ITIL V3 Foundation Training.

 

--------------------------------------------------------------------------------------------------------------------------------

 

 

Organization                     :           Tech Mahindra Pvt. Ltd., Pune

 

Duration                          :           November 2009– September 2010

Industry                           :           Services Provider US Client

Position                            :           Senior Executive - MIS

Environment                     :           MS Access Database, MS Excel VBA and Manual MS Excel Report

Project Details                  :           

  1. Developed Process Reports, Login Reports and Agent Reports Tool using Excel VBA and Ms-Access to extract Daily, Monthly and Yearly 
  2. Preparing Manual Daily Reports, Weekly Reports and Monthly Reports for Management.
  3. Preparing Weekly Rosters and Transport Rosters.
  4. Maintain Employee attendance and attrition Tracker.

--------------------------------------------------------------------------------------------------------------------------------

 

Organization                     :           Vertex Software Pvt Ltd., Pune

                                                   (An NTT Data Company - CMM L5)

 

Duration                          :           August 2008 to October 2009

Industry                           :           US Client (Microsoft)

Role                                :           Executive - MIS

Environment                     :           MS Excel VBA and MS Access VBA

Project Details                  :           

  1. Worked on platform like MS Excel VBA, MS-Access.
  2. Prepared the analytical reports/charts based on the data of advertising campaigns that are offered by different publisher like Yahoo, Google, MSN and AOL Network.
  3. Prepared the report of online marketing campaigns based on data that helps publisher to maximize the revenue and lower costs associated with the advertiser.
  4. Developed the program to automatically generate the analytical reports based on data of online advertising campaigns.

 

--------------------------------------------------------------------------------------------------------------------------------

 

 

 

Organization                     :           Cequity Solutions Pvt Ltd., Mumbai

                                                   (Customer Equity Solutions)

Achievements                   :                 1)            Best Performance Award in Cequity

                                                         2)  Developed “Time Sheet “Using VB 6.0, MS Access Database and Time sheet Report for Management.

Duration                          :           January 2008 to July 2008

Industry                           :           Service Provider (TataSky)

Role                                :           Analyst Program & MIS

Environment                     :           VB 6.0, MS Excel VBA and MS Access Database

Project Details                  :           Cequity Solutions do the Analysis with the Client Database, 

  1. Worked on platform like MS Execl VBA, MS Access Database.            
  2. Do Analysis and give the best possible solution to the client. 

--------------------------------------------------------------------------------------------------------------------------------

 

Organization                     :           TNS ORSC India Pvt Ltd., Hyderabad

                                                   (Taylor Nelson Sofres is a leading market research 

                                                   and information group)

 

Achievements                   :           1)       12 CSAT Awards (Customer Satisfaction Award) from 

                                                            TNS ORSC for the Client Satisfaction Rating (12 Bronze Awards and 

                                                            4 Silver Awards)

                                                  2)       Developed Macros in MS Excel VBA.

Duration                          :           From June 2006 to Jan 2008

Role                                :           Charting Analyst

Environment                     :           MS PowerPoint Presentation, MS Excel and MS Excel VBA

Responsibilities                 :           TNS ORSC leading Market Research Company and give the best possible 

  1. Creating Excel Charts with the raw data provided by the Client.
  2. PowerPoint Template Modifications according to client’s requirements.
  3. Formatting PowerPoint presentations
  4. Develop MS Excel VBA Macros for Clients Scorecards.
  5. Analyze data in MS Excel and generate PowerPoint Charts as per project specification.

Education

M.A. (Sociology) , Karnataka State Open University

Professionals in the same Technology / Internet sector as Vinoth Kumar

Professionals from different sectors near Chennai, Chennai district

Other users who are called Vinoth

Jobs near Chennai, Chennai district

  • EFFIC HR Consulting Private ltd

    Head - Sales & Marketing - Electricals/Steel/Automotive

    Found in: Talent IN 2A C2 - 1 week ago


    EFFIC HR Consulting Private ltd Chennai, India

    Head - Sales & Marketing · Hiring for Indo - Japan Joint Venture MNC · Position : Head - Sales & : : 15+ Years · Location : Chennai · Key Skills: · Product positioning with long term vision. · Design & implement strategic business plan · Identify emerging markets and market shift ...

  • 12542 Citicorp Services India Private Limited

    Cash & Trade Proc Sr Supv - C11 - CHENNAI

    Found in: Talent IN C2 - 6 hours ago


    12542 Citicorp Services India Private Limited Chennai, India Full time

    *Night Shift* The Cash and Trade Proc Sr Supv is an intermediate level role to ensure the smooth processing of various Preferred custody activity including executing Banking official checks, disbursements, wire transfers, mutual fund transactions, MF buy/sell orders, FX currency/ ...

  • HITACHI ENERGY TECHNOLOGY SERVICES PRIVATE LIMITED

    Service Support Specialist

    Found in: Talent IN C2 - 1 week ago


    HITACHI ENERGY TECHNOLOGY SERVICES PRIVATE LIMITED Chennai, India Full time

    Description · : Business Information: · The Hitachi Energy Indian Operations Center (INOPC) is a competence center with around 1500 skilled engineers who focus on tendering, engineering, planning, procurement, functional system testing, installation supervision and commissioni ...