Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Amit K. | Elance
 
176985602337900
Last Sign-in: Apr 19, 2014

Amit K.

IPR Professional, Expert MS Office,VBA,VB.NET,VBS
   India
  |  11:13 am Local Time

Overview

Minimum Hourly Rate $20

Microsoft Excel- Top 1%, Microsoft Word- Top 5%, MS Office - Top 10%. Developed multiple complex MS Office solutions with VBA and VB.NET. This includes Reports, Dashboards with customized Ribbon, web scraping and data collection, E-commerce data support and so on.

I'm an IITian with more than 7 years of professional experience, which includes 2 years of research experience and 5 plus years of IPR+BI experience.

I have been working in the field of Intellectual Property Research and Business Analytics for the past 5+years with one of the...

Read More »
Apr 2, 2014|Other IT & Programming|Private|Completed
|
5.0
Mar 29, 2014|Database Development|Private|Working
Mar 23, 2014|Database Development|Private|Completed
Mar 16, 2014|Other IT & Programming|Private|Completed

View All »

Portfolio

A windows utility which combines a web browser and office applications developed in...
Interactive Sales Chart
Excel Workbook with Custom Ribbon Tab and Task Pane. Designed and coded in Visual...
Macro to send customized emails from excel
Macro to download historical data from Yahoo Finance or Google Finance with customised...
Analysis of product sales and visualizations.
Sales by customers and months.
This addin adds a group in Ribbon for bookmarks tool.

Skills (15)

Tested
Microsoft Excel
Microsoft Excel 2007 Test
My Score
avg
Microsoft Word
Microsoft Word 2007 Test
My Score
avg
Microsoft Outlook
Microsoft Outlook 2007 Test
My Score
avg
Knowledge of Microsoft Office
Knowledge of Microsoft Office Skills Test
My Score
avg
Computer Skills
Computer Skills Test
My Score
avg
Passed
English
U.S. English Basic Skills Test
My Score
avg
Passed
UK English Basic Skills Test
My Score
avg
Passed
Email
Email Etiquette Certification
My Score
avg
Passed
Microsoft Access Administration
Java
HTML
XML
Visual Basic
Excel; VBA; Macros; MATLAB; Data Analysis
VBA
VBA
My Score
avg
BigCommerce

Service Description

My services are in the following areas:

*#*- Microsoft Office -*#*

VBA and Macros based automation:

1.Microsoft Word 2010, 2007, 2003
2.Microsoft Power Point 2010, 2007, 2003
3.Microsoft Excel 2010, 2007, 2003

** Advanced Excel Formulas
** Custom functions and macros
** Dashboards and charts with customized ribbon
** Data Analysis and Pivot Tables
** Internet Explorer Automation
** VB Script and VBA based scraping
** BigCommerce Products Upload
** Upload CSV file generation from inventory CSV file for Ecommerce Websites


## Office applications using VSTO

*#*- Website Development -*#*
1.HTML & CSS
2.PHP-MYSQL
3.JOOMLA
4.DRUPAL
5.WORDPRESS

*#*- Programming Skills -*#*
1. JAVA
2.MATLAB
3.VB.NET




Read More »

Employment

Leading KPO
Manager
2013 - Present
Leading KPO
Project Manager | Senior Analyst
2010 - 2012
Leading Patent Analytic Firm
Senior Analyst
2008 - 2010

Education

Indian Institute of Technology
Master of Technology
2006 - 2008
Indian Institute of Technology
Bachelor of Technology
2001 - 2005

Keywords

Excel
VBA
Macros
Dashboards
RibbonX
MATLAB
VB Script
Google Script
HTML
Word
Access
Powerpoint
BigCommerce
My Snapshot
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
Total
Milestones
Hours
Reviews
4.8
Recommend
Clients
Total
Repeat
Earnings
Private
Private
Total
Per Client
Identity
Username
am352623it
Type
Individual
Member Since
June 2011
Elance URL
Verifications
0
Groups
Amit K. | Elance

Amit K.