William Smith | Elance
 
176985602337900
Last Sign-in: Aug 10, 2012

William Smith

blogspot programmer
   United Kingdom
  |   London, London
  |  3:07 pm Local Time

Resume/C.V.

I have a Masters of Computer Science in Business Computing. I also have a Bachelor Degree in Information Systems with Business. I am also a qualified developer in HTML from W3Schools.com. I have been developing blogs using blogger (blogspot) for 4 years.
Service Description
I can monetize blogger with Adsense. I can also set up new blogs via blogger and enable mobile blogging. I am able to configure Adsense for blogs and for Feeds. I can fully set up a new blog for you so that all you need to do is post blog news and nothing else. one of the blogs I have set up is (excelgeeks.blogspot.com).
Certifications
Happy Computers
MOS Excel 2003
Awarded: 2011
Happy Computers
MOS Excel 2007
Awarded: 2011
Education
University of Westminster
MSc Business Computing
2003 - 2006
Thames Valley University
BSc Information Systems with Business
2000 - 2003
Employment
BBC
Data Cleanser
2011 - 2012
Access 2007 GUIDs Database Project: Linking tables in Access 2007 using joins Writing SQL statements/scripts in Access SQL view to automate the running of the GUIDs reports Excel 2007 Reconciliation Project: High volume data reconciliation (over 10,000 records) Comparison of Inventory report against the report from client to discover what data is missing and existing Using VLOOKUPs to match unique identifiers from the Inventory excel worksheet to the clientís worksheet Using pivot tables to summarise reports to show total records matched and not matched E-Service Desk Assigning calls using our call logging system known as E-Service Desk Assigning engineer updates Sending emails via E-Service to clients Attaching files to calls Stopping the clock on calls that have been delayed due to reasons beyond the teamís control Ingest of programmes into database system Data entry of TV episode data in a Master worksheet Assigning Technical Keys using VLOOKUPs Using pivot-tables to check for blanks and error in data Use of IF Statement formulas for data validation Use of COUNTIF formula to track number of records per batch SharePoint Uploading documents to SharePoint Creating folders in SharePoint Sending links via SharePoint Managing files and folders in SharePoint Outlook 2007 Sending emails via Outlook Creating folders in Outlook Setting up rules via Outlook Setting up meetings via Outlook Setting up tasks via Outlook Setting up reminders via Outlook In House Systems Looking up records using SPS Exporting data from SPS Looking up episode data on ORAC TV MS Word 2007 Guidelines and Manuals Documentation Writing guidelines step by step guidelines on ingest process Writing guidelines on how to use the GUIDs database Documenting business SOP overview for data cleansers Writing Guidelines on How to assign Technical Keys Writing data validation and checks guidelines Writing guidelines on how to assign season numbers Writing guidelines on how to check data for errors before populating Master spreadsheet Data mapping comparison between Client column names and our column names Writing guidelines on how to populate image aspect ratio based on criteria given Writing guidelines on how to populate asset data in general
City & Guilds
Data Administrator
2010 - 2011
Building Tables using SAP Testing module data within education Outlook emailing Setting up tasks via Outlook Setting up task requests via Outlook Setting up reminders via Outlook Pivot Tables to aid with building tables
Office Angels Temp
Data Entry Temp
2010 - 2010
Data Entry into excel spread sheets Data Entry into Oracle HRMS forms Data Entry into In house systems
City Sprint
Commercial Analyst
2009 - 2009
Matching data using excel VLLOOKUPS Creating reports using Report Builder Importing text files into Access Outlook emailing Setting up tasks via Outlook Setting up reminders via Outlook Pivot Tables for reporting
Carphone Warehouse
Human Resources MI Assistant
2007 - 2008
Oracle HRMS data entry Running reports in Oracle Discoverer Matching data using excel VLOOKUPS Pivot Tables for reporting Outlook emailing Setting up tasks via Outlook Setting up reminders via Outlook
Clarkson Research PLC
Data Technician
2007 - 2007
Excel data entry from PDF and Access data entry from PDF Web Editing paragraphs of text commentary using HTML File upload into Intranet system and outlook emailing Running Excel Macros Maintaining Outlook team inbox
Her Majesty's Treasury
HRIS Assistant
2006 - 2007
Excel pivot tables and formulas HR Diversity reporting Pivot Tables for diversity reporting Matching data using excel VLOOKUPS Outlook emailing Setting up tasks via Outlook Setting up reminders via Outlook
Victim Support
Data Assistant
2004 - 2006
In-house database Data entry Excel reporting Pivot Tables for reporting Access database querying Outlook emailing
Ricall Ltd
Data Entry Clerk
2004 - 2004
Excel Data Entry Word Processing
Hackney Housing
Data Entry Consultant
2004 - 2004
Data entry into an in house system similar to access called Saffron
London Fire & Emergency Planning Authority
Performance Information Assistant
2003 - 2003
Excel reporting, SPSS and Access data entry
London Fire & Emergency Planning Authority
Performance Information Assistant
2002 - 2002
Excel reporting, SPSS and Access data entry
Payment Terms
None specified
William Smith | Elance

William Smith