SUMMARY:

• Transitioned over 30 departmental SharePoint/2007 sites of old company to new company Office/365, incorporating new features and capabilities and trained users.
• Implemented workflow publishing for corporate policies and procedures.
• Customized entry forms using 3rd party forms tool and workflows using SharePoint designer.
• Designed a corporate directory and publishing system, linking employee, job title and location.
• Developed an A/P JE Reconcile for month - end closing using SharePoint, Excel and SQL scripting to ERP. Backup documentation is stored in SharePoint and linked to ERP.
• Project manager to develop a Microsoft LightSwitch / SharePoint custom application as a replacement for a records management/off-site storage application.
• Customized and maintained a project management site template used for the company’s LEAN initiative
• Integrated a Pole Resource Job Credit Excel Worksheet to SharePoint content type using Visual Basic for Applications (VBA).
• Developed a SQL script for lumber purchasing which replaced 4 manually generated reports and cut-paste operating, increasing accuracy, timeliness and saving over an hour per run.
• Successfully fast-tracked an automated Excel-based budgeting and inventory flow and forecasting tool using SQL scripts and VBA programming for a new CEO and management team. It was used by the new team for its last 2 years before the company acquisition.
• Automated Telephone Pole Quote spreadsheet with ERP using VBA, in use for over 10 years.
• Developed and supported a corporate reporting infrastructure for GL financial package using Excel, SQL and VBA, in use for 16 years.
• PowerBI and Tableau

TECHNICAL SKILLS:

Technology and Tools: R Fundamentals ITIL foundation LEAN and experience Adobe Photoshop Visio HTML Java Script experience IBM/Cognos Avaya PBX Administration Crystal Reports - advanced Results - oriented Compassionate Customer focused Self-starter Team builder Hands-off management Curious Creative Open-minded Logical Dependable Analytical Realistic Value conscious Lifelong learner MS SQL Scripting Crystal Reports SharePoint Administration Excel / Microsoft Office Visual Basic for Applications (VBA) Active Directory administration Business Reporting Accounting principles

PROFESSIONAL EXPERIENCE:

SR. BUSINESS SYSTEMS ANALYST

Confidential, Tacoma, WA

Responsibilities:

• Designed or led development of the following ERP capabilities: financial reporting, sales forecasting, operations, barcode automation, document imaging, EDI, sales tax automation-Taxware, dispatch and transportation, sales invoicing and multiple customer retention features.
• Project manager to transition EDI system from old company to new ERP module in new company.
• Led modernization efforts replacing antiquated systems to modern processes adding to the company from $50m to $250m over a 16 year period.
• Build customized business solutions through management of system engineers and developers over 16 years with $1.5m budget leveraging Microsoft System Center with no FTE increase.
• Developed and supported a corporate reporting infrastructure for GL financial package using Excel, SQL and VBA, in use for 16 years.
• Successfully fast-tracked an Excel-based budgeting and inventory flow and forecasting tool using SQL and VBA programming and integrated into SharePoint team sites for a new CEO and management team. It was used by the new team for the last 2 years before the company acquisition.

BUSINESS ANALYSIS

Confidential

Responsibilities:

• Independently contracting with wood a manufacturing company to implement their on-site SharePoint site, supporting multiple business units and two separate companies. Developing tie-ins with Microsoft CRM and supporting inventory initiatives on SharePoint.

SR. BUSINESS SYSTEMS ANALYST

Confidential

Responsibilities:

• Led transition from old system to new (new owners), which included data cleaning, data mapping, requirements gathering, transition team meetings, conversion scripts, project management, and ongoing support for old system through transition.

SR. BUSINESS SYSTEMS ANALYST

Confidential

Responsibilities:

• Key member in LEAN workshops for imitative begun in 2010, developing and supporting project management sites in SharePoint, Excel and SQL database. Involved SQL scripts, VBA macros and SharePoint development.
• BA requirements gathering to define current state for ERP imitative, planning future state
• Developed and supported inventory management and budgeting using Excel, SQL and SharePoint

SYSTEMS ADMINISTRATOR

Confidential

Responsibilities:

• IT manager of 10 developers and support staff
• Led development efforts and participated in continual system enhancements to support company growing from $50m to over $250m, involving all facets of business: Purchasing, Sales, Finance, EDI, Budgeting, General Ledger, Accounts Payable, Accounts Receivable, Manufacturing, Production.
• Designed and maintained system supporting company financials in Excel, linked to SQL back-end
• Implemented new technologies which continually improved efficiency and reliability as system grew from a single server to over 30, resulting in minimal staff growth.

SYSTEMS ANALYST

Confidential

Responsibilities:

• Developer for in-house homegrown system
• Supported minicomputer, doing system support, maintenance and backup/restore