Responsibilities:• Partner with IT Infrastructure, Security Teams, Business Teams, and vendors on enterprise Infrastructure Fitness projects• Elicit, document, and analysis of requirements for new systems and enhancements for existing systems.• Vetting of requirements with IT Infrastructure, Security Teams, and Business Teams• Project Management and coordination of work efforts with PGE IT, Application, and Business teams

Responsibilities:• Lead enterprise project activities to capture business and data requirements, processes, and specifications• Effectively work with technical and business teams capturing and documenting feature requirements for Agile development teams• Bring an enterprise, cross-functional perspective to project teams that deliver unified requirements and streamlined processes that increasingly meet Cambia’s goals and initiatives• Create, review, and obtain approvals of Feature documents for business requirements that are the basis for the Agile team development planning sessions

Responsibilities:• Conduct requirement gathering sessions with Corporate Accounting, Facilities, HRIS, Marketing, and Operations for the Business Intelligence Next Generation Program (BING)• Member of a 4 person BSA team that created technical and non-technical deliverables to support both Agile and Waterfall methodologies• Delivery of requirements to scrum teams for development work for the new BING Enterprise Data Warehouse Accomplishments:• Vetting and documenting of data sources for an Enterprise wide single source for the Location Master containing over 150 attributes from 10 subject areas with 9 data owners involving over 30 stakeholders• Create SQL scripts to export Location Master data values and document the required business rules• Analysis of data from 4 different databases using SQL Navigator 7.3 and SSMS 2016 to provide source specifications to be used by development for SSIS package creation• Business Requirements Document for Financials signed off on by 15 senior level stakeholders

Responsibilities:• Collect, organize, and validate data and modeling results from data analysis.• Plan and lead prototyping sessions and requirements gathering meetings.• Effectively work with business and technical groups to define business requirements and deliverables. • Systematically plan, prioritize, delegate, and monitor the defined project deliverables.• Development of documentation for requirements, configurations, functional designs, process diagrams, and project plans using MS Office, Visio, and Project versions 2010. Accomplishments:• Review of project documents from the previous Cascade Data Quality project team that lead to creating new and/or updated project scope and requirement documents to restart the project. • Analysis of the data values which resulted in creating re-useable SQL scripts for data analysis for the Cascade Data Quality project using SSMS 2012.• Generate and update SQL scripts utilized by SharePoint Web Administrator to validate SharePoint lists against SQL source database.• Construct ad-hoc SQL scripts as requested by staff to facilitate data analysis and trouble shooting.

Responsibilities:• Effectively work with technical and business departments to define project objectives and scope elements utilizing an Agile software development methodology.• Capture and document business needs, process flows, and requirements ensuring a cross-functional perspective.• Creation of Requirements Matrix document to support project traceability. • Facilitate cross-functional streamlining of business processes resulting in increased efficiencies and productivity.Accomplishments:• Collaborated with 7 departments creating an approved process flow reflecting the new automated system processes to integrate the systematic loading of group and subscriber insurance information into various systems.

Responsibilities:• Analyze and evaluate business processes, systems, and user needs.• Enterprise level integration of inbound and outbound EDI documents in an Oracle ERP system.• Coordination with external service providers for EDI integration.• Define business solutions and document functional descriptions to be used by development, quality assurance, and customer support departments.Accomplishments:• Successful implementation of a VAN to VAN integration of EDI documents for consumer drop ship orders for a national online shopping network, QVC.• Project coordination and deployment of a Cognos BI reporting tool upgrade that is used by business data owners in Finance, Sales, Inventory, and Retail Order Management functions.• Deployment of updated integrated EDI documents for consumer drop ship orders required by Dick's Sporting Goods. • Analysis, design, test, and deployment of an enhancement to transmit tracking number information to the customers via an external email marketing platform indicating whether the shipment is origin or zone skipped.

Responsibilities:• SQL Database management, data analysis, data design and data correlation of the RFMS, MS Dynamics SL, and MS Dynamics GP databases• Monitor, troubleshoot, and correct failed SSIS jobs• Creation of 60+ SSRS Reports to provide staff members with information to facilitate and support business objectives for the Sales, Operations, Purchasing, and Accounting departments.• Installation, testing, and scheduling of RFMS software updates.• Assisting business users in eleven branches with day to day RFMS processes.Accomplishments:• Creation of re-useable SQL scripts to perform price and cost updates of products and services.• Successfully exported Inventory Product Information, Inventory Quantities, and Open AR Invoices from a MS Dynamics GP database and imported the data into the RFMS SQL database. • Creation and maintenance of a test RFMS system and database that was used for training and testing purposes• Deployed a redesigned web based ordering system based upon a SQL database.• Creation of SSIS ETL scheduled package to populate the SQL database for the web based order system.

Responsibilities:• Analysis of client’s business needs and processes which resulted in recommendations to improve processing and enhance the information in their Microsoft Dynamics ERP systems.• Management of client projects to ensure on time, on budget, and fulfillment of project’s defined specifications.

Responsibilities:• Perform application configuration, data migration, systems integration, and training services for Accounting, Distribution, HR/PR, and Manufacturing modules.• Work collaboratively and effectively with diverse groups such as Engineering, QA, Production, Accounting, and HR to assist them in development of short term and long term IT system plans.• Project management of client’s staff for manufacturing facilities located on the West and East coasts; collaboration with client’s major customers, Daimler Trucks North America and Paccar; scheduling of third party vendors’ work; and coordination of internal staff. Accomplishments:• Successful implementation of an integrated ERP/EDI solution for a Portland area manufacturer whose two major customers are Daimler Trucks North America and Paccar.• Utilize SQL scripts to validate the EDI data following in and out of a MS Dynamics SL system.• Creation of client-specific training and procedural materials used to transition users from a UNIX-based legacy system to MS Dynamics SL, which included third party solutions, and a custom developed EDI solution for a manufacturing environment. Training sessions were held on-site and online. • Interim client controller duties consisting of financial statements, month-end and year-end closings; which required importing and exporting of GL data between the legacy and MS Dynamics SL systems.

Responsibilities• Perform application configuration, data migration, systems integration, and training services for the Accounting, Distribution, PR, and Manufacturing modules.• Capitalized on my extensive knowledge of the AddonSoftware data structure when converting legacy data to MS Dynamics SL and SAP Business One (B1) systems using each system’s data import tools. • Project manager responsible for MS Dynamics SL and SAP B1 ERP implementations. Assess and assign tasks to consultants, developers, and IT staff members.• Preparation of weekly status reports for implementation projects to ensure tasks are progressing on time and on budget, which were distributed to and reviewed with senior management.Accomplishments• Analysis of 7 types of inbound and outbound EDI specifications for Daimler Trucks North American and Paccar; and creation of EDI Mapping Correlation documentation for the EDI document types.• In the first ten months of employment passed certifications in MS Dynamics SL and SAP B1 while working on client projects and implementing new systems.