Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Sanchayan Banerjee | Elance
 
176985602337900
Last Sign-in: Oct 28, 2015

Sanchayan Banerjee

Expert in Excel VBA programming,SQL Programming
   India
  |   Calcutta Ballygunge, West Bengal
  |  1:20 pm Local Time

Overview

Minimum Hourly Rate $5

I am a seasoned Software Professional from Kolkata, India having ten plus years of experiences in ERP consulting, Database designing and application development in Microsoft Office especially in Excel. I have experiences in managing ERP and IT in large production organizations with extensive domain knowledge in warehouse and stock management. Some of my key skills include
- Complex VBA Macros
- Advance Excel formulas.
- Dynamic Excel Charts.
- Statistical data analysis
- DASHBOARDS / user interface forms
- Data manipulation to...

Read More »

Portfolio

This macro takes a csv file as input and converts it to a xls file and store it in a...
This application gives the user a simple data entry form which saves the data entered...
This program pops up a list box control containing data from list view when user clicks...
This program allows user to dynamically create xls file and input data into them based...
This macro allows user to dynamically edit and save some excel file based on certain...
This program allows user to fetch data into excel from some other source,clear unwanted...
This application scraps data from a well known job website and store it into excel...
This program allows user to generate a tree like hierarchical structure report from raw...

Skills (10)

Tested
C#
Oracle
VB.NET
JavaScript
Software Development
AJAX
Visual Basic
Crystal Reports
ERP
Web Applications

Employment

Hindustan National Galss and Industries Limited
Manager ERP
2012 - Present
Working as Manager (ERP) at Hindusthan National Glass and Industries Limited (www.hngil.com) since last two years and half years. Job scope includes, 1. Planning, understanding,...
Ontrack Systems Limited
Senior Software Engineer-Dot net
2011 - 2012
Worked as a senior developer, designated team leader at M/s.Ontrack systems (www.ontrackindia.com). Scope of work included understanding user requirement, development of business...
Orchid Technical Consulting Pvt Ltd
Senior Software Engeneer and Group Leader
2009 - 2011
Actively participated in the development of companies product called Orqubit,a desktop reporting application which can integrate with any known ERP systems such as Tally, SAP and Navision and...
Descon Limited
Software Engineer
2008 - 2009
Worked as a Software Engineers for M/s. Descon LTD, Plot no. XI-2&3.Block- EP, Sector V,Salt Lake City, Kolkata- 700091.Phone no-2357-4308/09. Current Project: - Payroll Software. Front end: -...
IBC Systems Pte Limited
Senior consultant
2007 - 2008
Worked as a Consultant for M/s. IBC System Pvt Ltd (India) a subsidiary of Ms IBC Systems Pte, Singapore. The system is a web based ERP application developed in C#, VB.Net as front and Oracle as...
M/s.Infitools Software Pvt Ltd, Kolkata
Developer
2005 - 2006
Client-Bhutan National Bank. Name of the Software:’HR Tools’ Domain: HR and Asset Management. Team Member: 3 Front End:VB, Crystal Report. iBack End: Oracle Aim of the project: The...
M/s. Classic Consultants, Kolkata
Consultant
2004 - 2005
Client-M/s Coca Cola Name of the Software-‘Jaguar’, Domain: Sales & Despatch. Team Member: 4 Front End tool: VB Back End: Oracle Aim of the project: It takes care of various Inventory, Accounts,...
M/s. R.K.Hitech LTD.Kolkata
Junior Consultant
2001 - 2004
Client- M/s. NHPC projects at Chamera & Gangtok & Garden Reach Shipbuilders and Engineers Limited. Name of Soft ware – ‘Energize’, Domain: Sales & Despatch. Team member: 4. Front End Tool: Visual...

Education

Jadavpur University
MBA
-
Microsoft
MCAD(Microsoft Certified Application Developer)
-
Sikkim Manipal University of Health, Medical and T
MCA
-
CMC
EDAST
-
Sikkim Manipal University of Health, Medical and T
BSC IT,MCA
-
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

VBA
Excel
SQL
Database
My Snapshot
All Categories
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
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
sanchayan_b
Type
Individual
Member Since
October 2014
Elance URL
Verifications
0
Sanchayan Banerjee | Elance

Sanchayan Banerjee