VIPIN KUMAR GARG
I am looking for challenging work for MIS and data with automation (Excel VBA) for business process, presentation and coordination with global team.
- Role
Senior VBA Developer
- Years of Experience
18 years
Skillsets
- Database Design
- Custom ui editor
- Report Creation
- Pivot Tables
- Macros development
- Google forms
- G Suite
- Excel VBA
- Debugging
- SQL
- Data Cleaning
- Data Analysis
- Charts
- Adhoc reporting
- Data Import/Export
- MS Access
- automation
Professional Summary
18Years
- Aug, 2021 - Mar, 2022 7 months
Senior VBA Developer
Namaste Credit - Nov, 2018 - Aug, 20212 yr 9 months
VBA Developer
Freelancer - Jul, 2018 - Oct, 2018 3 months
Sales Operation Support Specialist
Watlow Thermal Solutions India Pvt. Ltd. - Feb, 2010 - Oct, 20144 yr 8 months
Senior Data Analyst
Tata Docomo - Oct, 2014 - May, 20172 yr 7 months
Senior Executive
Paramount Health Services & Insurance TPA Pvt. Ltd. - May, 2017 - Feb, 2018 9 months
Senior MIS Executive
MSILHK - Jan, 2005 - Feb, 20105 yr 1 month
Data Analyst
MTS
Applications & Tools Known
MS Access
.jpg)
XML
HTML
VBA Excel
VBA
Work History
18Years
Senior VBA Developer
Namaste CreditAug, 2021 - Mar, 2022 7 months
Created macro for unstructured excel data into formatted excel sheet.
VBA Developer
FreelancerNov, 2018 - Aug, 20212 yr 9 months
Working for business automation and creating automated balance sheets, production processes, and client support coordination.
Sales Operation Support Specialist
Watlow Thermal Solutions India Pvt. Ltd.Jul, 2018 - Oct, 2018 3 months
Created sales playbook, customized ribbons in Excel and coordinated with global teams.
Senior MIS Executive
MSILHKMay, 2017 - Feb, 2018 9 months
Developed macros and reports for various data processing tasks and business modules.
Senior Executive
Paramount Health Services & Insurance TPA Pvt. Ltd.Oct, 2014 - May, 20172 yr 7 months
Created macros for claims analysis, data uploads, and report generation while maintaining databases.
Senior Data Analyst
Tata DocomoFeb, 2010 - Oct, 20144 yr 8 months
Created macros for data processing, TRAI compliance, and adhoc reporting.
Data Analyst
MTSJan, 2005 - Feb, 20105 yr 1 month
Developed macros for subscriber activations, data analysis, and reporting modules.
Achievements
- Developing existing and creating new applications using VBA
- Maintaining and creating databases using MS Access
- Gather and understand requirements to provide best business solutions
- Worked on large volume of data, including data conversion, cleaning, and report creation
- Project delivery within TAT with testing and 100% accuracy
- 98% success rate in project completions
Major Projects
9Projects
Freelancer
Finance balance sheets Production process (PIR)
VBA/pivot tables
MTS (Sistema Shyam TeleServices Ltd.)
Loops (do while, do until, for next, for each next & while wend)
Array (static & dynamic)
User Defined Functions (UDF)
ByRef and ByVal
Charts
Education
MCA
IGNOU (2005)