Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$10 USD / hour
Flag of INDIA
dholpur, india
$10 USD / hour
It's currently 6:16 PM here
Joined July 2, 2019
0 Recommendations

Vipin G.

@vipin0110

3.8 (1 review)
1.8
1.8
100%
100%
$10 USD / hour
Flag of INDIA
dholpur, india
$10 USD / hour
100%
Jobs Completed
100%
On Budget
N/A
On Time
N/A
Repeat Hire Rate

Excel VBA Developer

Greeting! I am an expert in MS Excel, Google sheet, MS Access and MS Excel VBA. I have 18 Yrs experience. I have worked 6 MNC companies. I have developed 1000 macros & formula sheets in Google sheets, MS Excel and MS Excel VBA for global sales team, paper mill, manufacturing companies and upload data on websites and worked in 200 million data in MS Access. Examples: -  Market, Portfolio, Funnel, Revenue, Vision and True North for (Sales Playbook)  Module for paper size cutting (stop for wastage)  Macro for purchase paper reels (as per requirement)  Formula sheet for finance balance sheets for maintain as (opening, closing & GST)  Formula sheet for data entry (inward & outward material PMS & IMS)  Module for PIR as production process in part in machine wise. VBA (MS Excel) :- 1. Predefined functions (split, vlookup, offset, date, time, len, trim, sum, count, sumif, countif, concatenate (&), counta, match, Index, left, right, shell, average, max, min, Ucase, Lcase, proper, strReverse and InStr) 2. Loops (do while, do until, for next, for each next & while wend) 3. Array (static & dynamic) 4. User Defined Functions (UDF) 5. ByRef and ByVal 6. Modules 7. Class modules 8. Charts (Bar, Pie and Line) 9. Pivot tables 10. ADO, DAO 11. FSO 12. File dialog 13. Select case 14. Add Ins 15. collection 16. Sort and Filter 17. Input Box and Message Box 18. Dictionary 19. IF Then else 20. Forms 21. Data types 22. Option explicit and option base 23. Error handlers 24. Screen updating 25. Debugging 26. Objects 27. Workbooks, Worksheets, range and cells 28. Cut, copy and paste 29. DIM and set 30. Formatting and Comments : MS Access 2016 (full outer join, left join, right join, inner join, select, in, not in, create table, like, drop, where, order by, ASC, DESC and ODBC) I would love to have the opportunity to discuss your project with you. I believe my skills are a match for your project. I would be easily able to achieve the task. Ensure projects are completed on time and achieving 100% success rate.

Contact Vipin G. about your job

Log in to discuss any details over chat.

Portfolio

5412101
5412101

Reviews

Changes saved
Showing 1 - 1 out of 1 reviews
Filter reviews by:
3.8
₹7,000.00 INR
Sincere and ethical work. Great guy to work with
Excel
Excel VBA
Excel Macros
Excel VB Capabilities
S
Flag of Satish M.
@satishmate
4 years ago

Experience

Sales Operation Support Specialist (VBA)

Watlow.com - USA Base Company
Jul 2018 - Oct 2018 (3 months, 1 day)
Worked in VBA, SQL Server & MS Access and provide best business solutions by developing customize macros and managed back-end functions to store in database with large data and import/export data in .csv, .txt with automation.  Market, Portfolio, Funnel, Revenue, Vision and True North  Customize ribbon in excel with XML by “Custom UI Editor for Microsoft Office”  Created macro for sales playbook related as per management requirement

Lead VBA Developer - HongKong Base Company

MSILHK (Material Sources International Limited HongKong)
May 2017 - Jul 2018 (1 year, 2 months)
I developed macro and modules in MS Excel 2016 (VBA) for business automation & coordinated with team in Honk Kong & Ethiopia.  Module for paper size cutting (stop for wastage)  Macro for purchase paper reels (as per requirement)  Macro for finance balance sheets for maintain as (opening, closing & GST)  Macro for weight calculation as (GSM, length & width)  Macro for PMS (production management sheet) as per machine wise  Macro for send automatic Emails for customers by sales department

Lead Data Analyst (VBA)

Paramount Health Services & Insurance TPA Pvt. Ltd-India Base Company
Oct 2010 - May 2017 (6 years, 7 months)
Worked on MoLE (Ministry of Labour Employment) data & prepared macro for daily routine reports, coordinated with team, hospitals and insurance companies ITGI (IFFCO Tokio General Insurance Company Limited)  Created macro for Claim Amount Vs Paid Amount MS Excel 2016  Created macro for Float raised to Insurance Company for payment of Hospitals in MS Excel 2016  Created macro for Upload data on RSBY website (rsby.gov.in) in MS Excel 2016

Education

MCA

Indira Gandhi National Open University, India 2001 - 2005
(4 years)

CIC (Certificate In Computing

Indira Gandhi National Open University, India 2000
(Less than a year)

Contact Vipin G. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.