|
jsac (ID: 873355)
Business problem solver with strong SQL Server, Access DB exprnce
|
|
|
Programming & Databases
|
|
Earnings (Year):
$0
|
|
|
|
|
Summary
|
| Member Since: |
October 21, 2007 | 0 quotes in last 30 days
| Last Signed in: June 04, 2011
|
| Location: |
Oswego, Illinois | United States |
| Would work on site: |
No |
| Earnings (All Time): |
$0 |
Earnings by Skill (Year): |
| Programming & Databases |
$0 |
| Database Administration |
$0 |
| Database Design |
$0 |
|
Feedback |
| Rate: |
Min. Rate: $20.00 | Min. Budget: $0.00 |
Work Terms |
| Industries: |
Retail & Wholesale |
|
|
Highlights
|
-- Created access DB application that is used by store layout personnel to identify missing core planograms when designing new stores. The application identified missing planogram assignments among existing stores that resulted in the identification of enough space to add 10,000 skus throughout the chain (equivilent to the opening of a whole new store)
-- Redesigned SQL Server DB application used to establish site-level forecasts for week promotional skus to be used in conjunction to Manugistics forecasting.
-- Created application SQL Server to calculate lost sales per sku/store/week based on product movement, on-hand inventory, and proportion of expected weekly sales on out of stock days. Completed SQL application to be built into SAP for enterprise-wide use as standard way to calculate lost sales due to out of stock events.
|
|
Skills
|
| Years of Experience: |
5 year(s) |
| Highest degree: |
Master's Degree |
| Software Skills: |
Back-end Database development in Access, SQL Server, and some Oracle |
| Additional Skills: |
Adept at finding system solutions to real business problems and opportunities. Certified in JDA Space Planning and Floor Planning for Retail space planning. Created several site-level forecasting and lost sales calculation tools for 850 retail chain using SQL Server. |
| Tested Skills: |
 |
| The Freelancer has not taken any Skill Tests. |
|
|
Work Terms
|
|
Work from home during non business hours. Able to meet deadlines, accessible at all hours to answer questions. Able to meet on site during business hours with notice.
|
|
|
| |
|
|
|
|
|
<
|
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: |
|
(GMT-06:00) Central America |
| Local Time: |
|
6:46 PM |
|
|
|
|
|
| Profile |
|
|
|
