Built various Sharepoint web sites using different out of box Sharepoint features such as content types, web parts, timer jobs, event handlers , workflows, list and site definitions either through out of box or customisation. The purpose of the site was to manage the documents, publish contents such as news broadcast, collaboration, get online approvals. Have also created custom app to migrate data from excel to Sharepoint lists. Using Sharepoint custom features and excel library generate MIS report for the internal sales team. Have used Excel advanced formulea such as VLOOKUP, IIF, conditional formatting, Macros etc.