Freelancer

Data Replacement via Spreadsheets  

Data Replacement via Spreadsheets is project number 203558
posted at Freelancer.com. Click here to post your own project.


| More Free Trial For New Buyers
 

Status:

Selected Providers: prakash2007

Budget: $100-300

Created: 12/11/2007 at 11:17 EST

Bid Count: 2

Average Bid:
$ 150

12/12/2007 at 11:17 EST

Project Creator: thefarewellnote
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (10 reviews)

Bid On This Project
 

Description

I currently am looking for a developer for the following project. My developer has backed out at the last minute causing some problems.

I have a huge chunck of VB code that I need someone to add a procedure to. Here is what is needed to be done.

Using the 15 csv files you will replace the appropriate fields with the matching
ID.

For example using the test.xls spreadsheet:
a. You will locate what columns needed to be changed (I will provide that information to you) then find the matching value in a csv file that I will provide. The csv file will contain a value and an ID. You will then take the matching ID and replace the value in the first spreadsheet with the matching ID (overwriting the orginal value.)
b. Save all spreadsheets as text delimited files.

I will provide the VB code which you will build on - I will also provide the sample data and detailed instructions. I assume this should be easy for someone will the right VB skills. I am in a hurry to get this completed and would like to have it by Thursday or Friday.

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

100

2 days

12-11-2007 11:34 EST

Hi, please check PM

help

 

200

3 days

12-11-2007 11:43 EST

(No Feedback Yet)

1997—2001: Bachelors of Technology (B.Tech) in Mechanical Engineering, Indian Institute of Technology Kanpur (IITK), India • Summer Internship (2000) (A distributed automatic air traffic management system) at INRIA, France (annual budget Euro 160M) in Computer Science research lab to develop a prototype for testing the theoretical research concept. Industry experience: 07/2006 – 09/2007: Technical Lead, Nagarro Software Pvt Ltd, India (300+ employees) • Project started with a team of two engineers. Convinced client by performance that resulted in growth of the projects, and in turn an opportunity to enlarge team. Leadership challenge due to project needing exacting attention and training new engineers under a tight schedule. Successful outcome generated USD 400K annual revenue. • Led regular interaction with onsite development, design and marketing team. Critical for the success of the project as the market was highly competitive and customers were very demanding. Speed and efficiency of the delivery was differentiating factor. Worked with client using Agile project methodology. • Controlled cost of resources for the project by developing new processes that reduced time spend on any sub task and developed functional expertise within team. • Identified and subdivided tasks to develop project plan and regularly monitored progress against set milestones and updated whenever new requirements arose. 11/2005 – 07/2006: Project Leader, Final Quadrant Solutions Ltd, India (100+ employees) • Initiated changes in the legacy system because it was not a fit with new technologies and requirements. Many of the related system also had to be changed; coordinated and achieved buy-in from other team managers. Produced a system four to six times faster that helped in creating new business opportunities. • Built partnerships with some of the national and international companies for value addition of existing system. These partnerships also increased the scope of the product to cover bigger market. • Implemented product on remote site in France in very a difficult situation when the client was running his existing system on the same machines and complete technology illiterate and we had to provide extensive guidance and training. • Led implementation of processes in the company for the CMMI V certification. Implemented SDLC in software development division. This task honed by project management skills and later on I became Certified Project Management Professional. 01/2005 – 10/2005: Senior Software Engineer, Vichara Technologies Pvt, India (30+ employees) • Participated in design and development phase of project for portfolio management of leading hedge funds. • Learned fundamentals of financial market, specifically hedge funds and portfolio management. • Mentored juniors about the work and process of the company that helped them in integrating with company faster and they could start development early. • Prepared interview questions and interviewed candidates for possible employment. 11/2003 – 11/2004: Expert Engineer, INRIA, France, (1500+ employees) • Coordinated activities for linguistic framework among teams from five EU countries. • Worked with research and production teams of world’s largest electronics and semiconductors companies (Philips, Thomson and Nokia). • Developed new algorithms for Natural language processing and Meta search for subtitles while broadcasting same programs in one language in EU through IDTV. • Created prototypes for testing algorithms and integrated solutions with the Set Top Box developed by other partners. 05/2003 – 08/2003: Research Assistant, Graphitech Fondazione, Italy (7 employees) • Assisted in classification and selection of hardware /software for new research lab • Contributed to setting up possible joint ventures and initiated projects • Mentored and guided two graduate students for their summer projects when the organization was in nascent stage and processes were not there. They were able to finish their thesis in time with a very high quality output. 07/2001 – 04/2003: Application Engineer, Tata Technologies Pvt Ltd , India (1000+ employees) • Worked with the testing experts and production engineers of India’s largest automobile industry (Tata Motors) • Got ‘A’ grade for excellent performance in first year • Developed modules for testing with prototype for indigenously designed cars in India

help


    Bid on this Project