Resourceful Projects, freelancer

ERP Consultant in Vancouver, Canada

- Scriptwriting, procedures, functions and reports in 2014 | 2012 | SQL Server 2008 R2
- Design and optimize databases (tables, indexes, Query Plans)
- Data conversion from MS Access to SQL Server
- Management and maintenance of SQL Servers
- Writing of Powershell scripts and batch files
- Writing specification documents and user manuals
- Implementation Project Management Systems

1. Document Management
a. Office: incoming & outgoing Documentation
b. Universal Document Approval process
c. Employees’ Tasks and Schedules
d. Standardized documentation workflows (Forms, requests, stages etc.)
e. Crafting Agreements and Contracts
2. Archive
a. Referential Archive
b. Archive of Legal Documents, Licenses, Patents, court hearings etc.
c. Knowledge-base Archives
d. Scanned Documents (including Accounting)
3. Project Management
a. Dashboard for Portfolios and individual Projects
b. Storage and virtual Collaboration space for Project Management
c. Managing Tasks, Calendars, Schedules, Lists(Deliverables) etc.
d. Gantt Charts of project timeline, progress and completion
4. Staff Processes & Procedures
a. Search of personnel
b. Hiring Employee
c. Termination of Employment
d. Official and legal documentation, such as note of Employment, transfer of Employee within an organization etc.
e. Drafting Holidays and Vacation Schedules
5. Applications and Services (according to a need), examples:
a. Order stationery, goods and groceries
b. Book a room
c. Request Documents scan
d. Order a taxi, room-cleaning, maintenance jobs
6. Manufacturing and Production
a. Production workflow
b. Raw Materials purchase process and Equipment acquisition