Javascript must be enabled to properly navigate this site.
Home
Why oDesk
Tour
Who Uses oDesk
FAQs
Press
Find Providers & Jobs
Find Providers
Find Jobs
Tests
Trends
oConomy
Groups
My Jobs
Openings
Candidacies
Assignments
Post a Job
Manage & Work
Team Room
Work Diary
Reports
Team Admin
Staffing Console
Payments
Financial Activity
Payment Methods
Withdrawals
Referrals
Sign In
or
Create an Account
Community
What's New
Forums
Blog
Store
?
Help
Help Center
A-Z Index
Resources & Downloads
Contact Support
Providers
Jobs
Tests
Community
Help
Find Providers
Find Jobs
Tests
Trends
oConomy
Groups
Share
Flag as Inappropriate
Last 6 mos.
All-time
Feedback:
none
none
Hours:
0
0
Assignments:
0
0
See all Work History & Feedback
Location:
Oakville, Canada (GMT-05:00)
English Skills:
(self-assessed)
5.0
Member Since:
October 30, 2009
Last Worked:
oDesk Ready:
Yes
Related links:
Trends for
Linux Developers
Trends for
Excel Consultants
Trends for
Crystal Reports Developers
Trends for
Access Consultants
Trends for
MS-SQL Administrators
James Mendez
-
"
MS Access Developer / IT Business Analyst
-
Freelance
Programmer / Developer
,
Canada
"
Permalink :
Overview
Résumé
Work History & Feedback (0)
Tests (3)
Portfolio (0)
18 years experience using MS Access, MS Excel and Crystal Reports in Supply Chain Ad hoc reporting. Built challenging Database and Sales Data Analysis using Ms Access and MS Excel. Provided client with hands on training and provided training manuals using my past experiences as an Analyst from Nabisco (Kraft Foods), Nestle Canada and Bauer Hockey Inc. I am in my late 50's, able, willing in both mind and body. I can provide you with my expert knowledge and strength in my years of experience...
18 years experience using MS Access, MS Excel and Crystal Reports in Supply Chain Ad hoc reporting. Built challenging Database and Sales Data Analysis using Ms Access and MS Excel. Provided client with hands on training and provided training manuals using my past experiences as an Analyst from Nabisco (Kraft Foods), Nestle Canada and Bauer Hockey Inc. I am in my late 50's, able, willing in both mind and body. I can provide you with my expert knowledge and strength in my years of experience in both Matrix and Key Performance Indexes. Am also well verse with computer hardware and software installation and troubleshooting, including having a basic MS SQL 2005 knowledge and server maintenance.
.
more
less
See All Work History & Feedback
(0 items, with Feedback)
Recent Work History & Feedback
Buyer ID
From/To
Job Title
Hours
Feedback
Work History & Feedback is empty
See All Tests Taken
(3 items)
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
MS Access 2000 Test
3.10
85%
TOP 20%
10/31/2009
40 min
MS Excel 2000 Test
3.15
78%
11/01/2009
24 min
oDesk Readiness Test for Independent Contractors and Company Managers
11/02/2009
2 min
Recent Candidacies
Job Opening Title
Initiated By
Date
MS ACCESS
Provider
November 4, 2009
Database Extraction and Manipulation
Provider
November 2, 2009
Job Category Interests
Web Development
Web Design
Software Development
Desktop Applications
Software Project Management
Writing & Translation
Technical Writing
Creative Writing
Design & Multimedia
Presentations
Customer Service
Customer Service & Support
Technical support
Business Services
Project Management
Business Consulting
Skills
Skill
Experience
Level
Last Used
Description
Access
15 yrs
4.0
2009
Develop MS Access database 2003 for SNOP Sales Forecast clients. Original files were done in Excel worksheets. Data includes three text files imported from SAP which includes History, Forecast and Demand. When imported into the Database, it contains over 2 million records. MS Access limits prevent this import from happening. The challenge is to split database tables into 4 tables in 4 separate database. One separate database contains a menu system that calls each of these databases when called by the user. Databases includes multiple tables, queries, forms, reports and macros. Developed databases include training manuals, flowcharts and reports specifications including printed reports converted in pdf formats.
Cognos 7
3 yrs
1.0
2006
Develop Ad hoc reprots for Sales and Financial Analyst to determine Cost of Sales base on plant, Dollars and top twenty Skus. Build reports requiring total sales by plant, by category, by month comparing to same period a year ago. Build reprots extracting product with expiry dates within 45 days from plants, by category, by sku and by expiry date.
Crystal Reports
15 yrs
2.0
2009
Able to design reports, extract data from SAP, Excel and Access or text format. Build formulas into queries and reports.
Excel
15 yrs
4.0
2009
Abilty to extract data from Access, SAP and text files. Auto excel macros to execute program to sort, cut and paste, create vlookup function and create report for print. worksheets contains multipe if and else statements and reference to tables to calculate data referenced from a different spreadsheet unsing Pivot Tables.
Linux
1 yrs
1.0
2009
Installed Fedora 11 on 7 Dell Poweredge Servers 2650. Interface with network connection. Support and maintain as test equipment.
MS-SQL
1 yrs
1.0
2009
Install and used as test application for MS Access data. Used MS SQL 2005.
Certifications
Date Earned
Name
Score
Percentile
Organization
Description
2001
Business Analyst [CDI Corporate]
CDI Corporate
Introduction to Business Analyst.
The course discusses the business analysis process as it is applied throughout a project to include the pre-project activities that comprise enterprise analysis. Participants also learn how a business analyst supports the project throughout the solution development life cycle, from establishing the solution vision and scope in the analysis phase to validating that requirements have been met in the testing phase.
Employment History
From
To
Company
Title/Role
Description
09/2009
Present
Anexxa Medical Technologies
Shipper / Analyst / Independent Contributor
Provide technical and Analytical support. Pack, check and repack medical supplies for shipment to hospitals across Canada. Prepare shipping documents, packing slips and invoice customer using Quickbooks. VerifyOrders from Hospital Administration though phone, email and or Fax. Providing care and thoughtful process in the delicate handling of fragile, heat and cold sensitive, and time sensitive medical equipment and materials through courier service.
07/2008
02/2009
Bauer Hockey
Supply Chain Analyst / Independent Contributor
As a Supply Chain Analyst, on a one year contract, at Bauer Hockey Corporation, I built a database application for Sales Operation Planning team in MS ACCESS 2003 from scratch using various Excel reports and SAP as the source. Designed and implemented Database structure involving queries and macros to perform drill down data at Material Levels. Roll up data for reports using complicated matrix calculations for comparing Forecast, History and demand through the year on various categories and by product groups. Purpose of this is to make the database user friendly so that only the user can navigate through the form menus to print and or query a specific material of category. With this tool on hand, they are able to communicate with teams to analyze and make better decisions on the forecast and demand planning and sales issues that they are faced with on a daily basis with competitors.
04/2003
06/2007
Nestle Canada
Data Analyst / Independent Contributor
Developed and supported tools related to KPI and Business Metrics.
Provided ad hoc analysis and business review for Customer Service, Warehousing, Transportation and Financial Settlement Operations.
Support Corporate on reporting and Analysis.Lead and support intranet development website for Logistics. Initiate process improvement to increase efficiencies and reduce cost while maintaining high levels of customer satisfaction across the supply chain.Provide data gathering support to GLOBE initiatives relative to Logistics.Project Managed data extracts from various systems, analyze for integrity, implement KPI for functionality and upload reports to Auditors for review. Project Managed top selling product data over 3 year periods, determining ABC analysis for benchmarking product retail strength.Project managed on product sitting at the back of the warehouse and forgotten. Tracked and managed inventory by production date to warn shippers of bad goods ahead of time. My strength is in the use of MS Excel and MS Access, Crystal Reports 8 & 9, Cognos 7 and ROC WMS, SAP Global
04/1991
02/2003
Nabisco Brands
Logistics Analyst / Independent Contributor
Designed and maintained programs in Microsoft Access and Excel to measure performance of Forecast, Sales, Deployment and Inventory Control for Snack, Grocery and Food Service Divisions
Developed Supply Chain Key Performance Indicator measurement reports for 11 plants with sales over $50 billion. Created and trained end users on Capacity Utilization report to utilize bakery ovens and staff to 98%. Provided support to Capacity planned reviews 2002/2003. Created monthly, weekly and daily reports tracking inventory on hand, aged inventory, stock surplus reports, Daily Unit Fill Reports for Bakeries and for Sales Branches across North America, Used proper file design structure and access methods in programs that exchange data with other hardware and software platforms and achieved system downtime results to 85%.
Provided assistance, testing and in migrating data into MANUGISTICS and SAP applications. Involved in MRP and DRP platforms and system/software implementations. Accomplished a leadership role in Project Management.
Member of Sales and Operation Team responsible for Supply Chain gathering data to produce National Summary report for daily and weekly review by Executive Board of Directors.
Represented Logistics requirements on all mainframe application developments.
Liaised with Information Services for system needs. Recommended software, hardware and network support.
Other Experience
IT Tech Support
Provided Desktop support, backup servers on a daily basis, PC support on phone with client and at the customer site at Nestle Canada.
Organized Chariatable Functions
Chairperson for the Annual Childrens Christmas Party for 7 years with the Knights of Columbus. Rebuild the Ontario Squires Youth Group consisting of 17 teenages from ages 12 to 15.
Project Support
Was part of SNOP project incharge of preparing data for cockpit. Provided support for the design of system to be used to house the data. Accumulate data from MS Access tables and provide rollup top level summary line data for Shareholders use.
Education
From
To
School
Degree
Area of Study
Description
08/1985
11/1985
Devry Institute of Technology
Diploma
Computer Information Systems
Studied Computer Science with focus on Database Management. Courses included Data Structures, On-line Systems, Management Information Systems, Literature, Distributive Data Processing, Database Management Systems, and Senior Projects.
This two Trimester programs gave me insight into the Database Management, programming System and Design that I am qualified and built my career on as a Database Programming and Design specialist.
02/1983
07/1985
Devry Institute of Technology
Diploma
Computer Programming & Systems
Studied Computer Science with some focus on Data Processing, Statistics & Applied Algebra Mathematics. Courses included RPG, COBOL, PASCAL, JCL and their Labs, English, Financial and Managerial Accounting, Business Writing, Public Speaking, Physcology, Security, Small Business, Economics, Management, Applications and Maintenance Programming.
Over 120 hours of credit is required to complete this six trimester program. Was elected Faculty Assistant for Technical Writing Class.
My education at Devry provided me the foundation and pillar strength for what I am today.
No items in portfolio
Hourly Assignment History
Buyer ID
From/To
Job Title
Hours
Feedback
Hourly Assignment History is empty
Fixed-Price Assignment History
Buyer ID
From/To
Job Title
Paid
Feedback
Fixed-Price Assignment History is empty
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
MS Access 2000 Test
3.10
85%
TOP 20%
10/31/2009
40 min
MS Excel 2000 Test
3.15
78%
11/01/2009
24 min
oDesk Readiness Test for Independent Contractors and Company Managers
11/02/2009
2 min
