Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Andres R. | Elance
 
176985602337900
Last Sign-in: Jun 29, 2011

Andres R.

Automate Time Consuming Tasks and Complex Analysis
   Colombia
  |   Bogota, DC

Overview

My passion is automating your tasks.

If you spend more of your valuable time in preparing data in Excel than in analyzing it, I will boost your productivity by automating the data preparation so you can focus most of your time in analyzing it.

I can turn any time consuming task in Excel into a fast, simple and reliable one, just a few clicks away.

I specialize in automating tasks which includes multiple data sources and variables, where a suggested decision is made following business rules.

Read More »

Skills (8)

Tested
VBA programming
Microsoft Excel
Microsoft PowerPoint
Six Sigma
Microsoft Access Administration
Computer Skills
Microsoft Word
Data Modeling

Service Description

I have a B.Sc in Industrial Engenieering and Computer Science. I have been working for more than 10 years in Industrial companies where I have automated many processes using Excel, from simple tasks such as converting text files to Excel files, to complex and critical decision tasks such as production scheduling and materials order planning.

My knowledge and experience in Supply Chain processes makes me strong in understanding complex tasks, formulating solution strategies, and designing and programing macros to achieve the desired results.

Many other Excel Automation projects include:
- Reading data from other file formats.
- Displaying and sumarizing data in specific Layouts and Formats.
- Creating text files to be uploaded in specific Information Systems.
- Automation of time consuming repetitive tasks.
- Decision making assistants using multiple variables.
- Building of business key indicators from multiple data sources.



Read More »

Employment

Vistaflor Corporation
Logistics Manager
2008 - Present
COCA COLA FEMSA
Process Automation Consultant
2007 - 2008
Developed automation tools for the logistics department.
CASA EDITORIAL EL TIEMPO
Logistics Planning Manager
2004 - 2007
- Planned the long term design for the distribution network that will reduce distribution costs by 26% (US$1.0 M a year) . - Designed and updated the distribution strategy to serve more than...
COCA COLA FEMSA
Forecasting Executive
2003 - 2004
- Generated the strategic, tactical and operational sales forecasts for all the products in Colombia, obtaining a demand forecast accuracy of 85% at a SKU level. - Developed a procedure to...
COCA COLA FEMSA
Supply Chain Specialist
2001 - 2003
- Implemented logistics information systems for demand, inventory, production and transportation planning and scheduling. - Constructed raw materials and finished products inventory policies for...
COCA COLA FEMSA
Inventory Coordinator
2000 - 2001
- Designed the optimal supply chain network for non returnable products, leading to savings over US 2 M a year. - Coordinated and balanced the sourcing returnable bottles, with budgets over US 16...
COCA COLA FEMSA
Logistics Analyst
1998 - 2000
- Generated a new key indicator called Cost per Case, which integrally measured the performance of each production facility. - Automated the consolidation and generation of manufacturing key...

Education

Universidad de los Andes
Industrial Engenieer
1991 - 1998
Universidad de los Andes
Computer Science
1991 - 1997

Keywords

Excel
programing
Logistics
spanish
automation
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
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
Josefo
Type
Individual
Member Since
December 2007
Elance URL
Verifications
0
Andres R. | Elance

Andres R.