|
nevarmihnd (ID: 431829)
|
|
|
Admin Support
|
|
Earnings (Year):
$0
|
|
|
|
|
Summary
|
| Member Since: |
March 24, 2004 | 0 quotes in last 30 days
| Last Signed in: March 03, 2008
|
| Location: |
Macungie, Pennsylvania | United States |
| Would work on site: |
Yes |
| Earnings (All Time): |
$0 |
Earnings by Skill (Year): |
| Admin Support |
$0 |
| Accounting |
$0 |
| Data Entry |
$0 |
| Office Management |
$0 |
| Word Processing |
$0 |
|
Feedback |
| Rate: |
Min. Rate: $18.00 | Min. Budget: $0.00 |
Work Terms |
| Industries: |
No information provided |
|
|
Highlights
|
|
I am excellent at organizing data and creating spreadsheets and reporting tools. I can help you compile data and summarize it into useful reports. I am adept with advanced excel capabilities including pivot tables, macros, vlookups, conditional formulas, and many others. Dymanic user inputs can allow the user to change information via direct input or drop down menus. This can allow you, or example, to see changes in "what-if" scenarios, or enable you to quickly calculate pricing for a buyer's unique order based on your cost for labor and materials including mark-up.
I have utilized these skills for many different objectives:
In Optoelectronics Manufacturing:
I have extensive experience in production planning. I coordinated customer purchase orders for production, ordered and maintained parts inventory and buffer strategies, and worked with the factory to execute the plan. Allocation of scarce resources and trouble-shooting manufacturing issues were problems I addressed on a daily basis.
In the Restaurant/Bar Industry:
I compiled and analyzed data to identify areas of the business that required cost reduction, including liquor, food, labor, and hours of operation.
Some examples:
1. I identified that costs were too high on alcohol, and took measures to reduce theft, taking my cost to revenue % from nearly 75% down to 35% within two months.
2. I identified that costs were too high on food. I analyzed the cost of each menu item and discontinued menu items that had low profit margins except in case of "loss leaders" that generated revenue in other areas (such as alcohol), and changed the menu offerings to reduce the over number of inventoried items, in order to reduce spoilage and waste.
3. Based on scrutinization of hourly revenue generation, labor costs, and variable expenses, I changed the hours this particular business opened from 11 a.m. to 3 p.m. to eliminate those time periods where the business was losing money.
4. Based on study of clientele demographics, spending habits and entertainment preferences, I changed the theme of the restaurant to attract more of the revenue-generating consumers. This change tripled my net profits.
In the Construction Business:
I worked with a master carpenter to help create excel templates to enable him to quickly cost out his jobs and create customer invoices.
|
|
Skills
|
| Years of Experience: |
No information provided |
| Highest degree: |
Bachelor's Degree |
| Software Skills: |
No information provided |
| Additional Skills: |
MS Access
SAP
Oracle
Ø Extensive and proficient computer application experience and aptitude: advanced Excel, Access, Power Point, Word, TOM, Oracle, Business Objects, SAP, Quicken and QuickBooks, internet, and various other Windows and DOS based apps.
Ø Self-starter; analyzes complex situations and sets missions and goals; meets deadlines.
Ø Well-organized work habits with the focus and discipline to produce outstanding results in a fast-paced environment.
Ø Possess excellent team and interpersonal skills and communicate effectively with technical and non-technical personnel.
Ø Resourceful, creative and persistent in satisfying the customer.
Ø Highly versatile with numbers and mathematics: excellent memory for data.
Ø Multi-tasks and handles several projects; assesses situations and determines priorities.
Ø Problem solving of intricate situations to determine optimal solutions and courses of action.
Ø Work well without supervision and generates comprehensive plans. |
| Tested Skills: |
 |
| The Freelancer has not taken any Skill Tests. |
|
|
Work Terms
|
|
No information provided
|
|
|
| |
|
|
|
|
|
<
|
The Freelancer has not uploaded images.
|
>
|
|
|
|
My Account URL
|
|
Contact this Freelancer Now!
The Freelancer has opted to hide his/her contact information.
|
|
Instant Messenger
|
|
The Freelancer has not entered IM information.
|
|
Global Region
|
| Country: |
|
United States |
| GMT: |
|
|
| Local Time: |
|
|
|
|
|
|
|
| Profile |
|
|
|