Please see my various engagements and key projects described within my individual Customer Experiences.

Collaborated with business subject matter experts to gather requirements and then designed and developed numerous business automations/system integrations in a 25 company NAV/Business Central Web Based environment. Developed interfaces between NAV/Business Central, OpenAir, Quickbase, Paycom, Odoo and Concur to create a fully integrated professional services landscape. Tools included Transact SQL, Stored Procedures, Azure Logic Apps and various APIs to extract, translate and load data. Deployed the solution to NAV and then to Business Central as part of a company-wide upgrade. Developed logic to disperse and retrieve data from numerous Companies.

Support IT solutions and designed Quality Management System utilizing Dropbox that complies with regulations governing control of process and design documentation. Perform internal Quality Systems audits to ensure compliance with regulatory bodies. Provide writing expertise and presentation advice for prospective customer focused literature.

Interface Deployment/Data Warehouse DeploymentDesigned, developed and deployed interfaces to and from MS Dynamics, Salesforce.com, Quotewerks and Quickbase eliminating numerous duplicate data entry tasks and providing my customer with a fully integrated end to end process stream that moves data seamlessly from one system to another. The solution included integration and implementation of Azure Virtual Server and Azure Virtual Database technology as a platform and involved deploying new tools for use such as Visual Studio, SQL Server Management Studio, SSIS and Transact SQL to build packages and integrate triggers into source systems with the timing and logic necessary to mimic workflow. Utilized the data from the systems that were integrated to build out a data warehouse in SQL that became the backend of Power BI reporting solution.Salesforce.com Renewals ContractsDesigned, developed and deployed an automated Opportunity Pipeline for Renewals triggered by entry of new Product Orders in order entry system. Order line items are deconstructed and then inserted into Salesforce as Assets and associated with a Contract for Warranty Coverage. New Opportunities for Warranty Renewal are created and associated with these Contracts and Assets creating a fully integrated pipeline of approximately $5 million annually. Salesforce.com RedeploymentHelping to revive Salesforce.com usage by leading the company through process mapping, requirements definition and gap analysis. Redeployed tool to Sales Reps, Executives and Marketing. Included providing process documentation, configuring Account, Contact, Lead and Opportunity page layouts, defining new profiles and roles, updating workflows, enhancing layouts with simple Visualforce Pages, archiving and loading data via Apexdataloader, creating and updating existing reports, deploying new dashboards, developing interfaces to other databases, and finally delivering training.

Shopify eCommerce SolutionDesigned and deployed B2B storefront (orderportal.datatrend.com) enabling customers to submit server orders via web portal. Involved configuring Shopify for use with several customer product catalogs that include in excess of 150 predefined systems with variant configurations and pricing. The end result is a tool that provides customers with a user friendly online ordering system which in turn helps drive process efficiencies and revenue generation for my customer.

Managed Network Deployments Provided support to core project team in various phases of major network infrastructure projects. Wrote detailed instructions and statements of work for project team that included equipment connection diagrams, VLAN connection diagrams, equipment installation guides, and hardware connectivity verification scripts. Projects typically included installation of new cabling, panels, cabinets, routers, firewalls, switches, and access points and then deinstallation of legacy equipment and infrastructure.

Provided project management and strategic direction on the highly complex One Vision Order to Cash project. Responsible for the successful and timely delivery of Accounts Receivable, Collections, Fulfillment and Entitlement global processes. Established detailed project plans and metrics, work plans, schedules, resource plans and status reports. Identified project risks/gaps and created risk mitigation plans. Communicated and reported status to executives, global business partners and all other key stakeholders. Coordinated large globally distributed teams of IT, Business and Consulting resources while conducting and planning global process optimization and blueprinting workshops.

PMO ImplementationIn support of company’s “Go Big” initiative, positioned the IT group for future growth by leading the IT Directors in identifying and defining the most practical path towards implementing software development best practices. Delivered a detailed action plan to company leadership and implemented a robust Project Management Office with supporting processes and tools.New Product DeploymentDefined firm’s IT capabilities and identified vertical markets and core vertical product offerings. Performed market studies and designed new solutions to enter electronic health records, credit card services and government markets by leveraging existing core vertical products. Put in place a detailed action plan to realize these new product offerings and launch the company into numerous new lateral markets.Performance Management InitiativeDesigned and led the development of a Performance Management Data Warehouse that provides a single source for accurate performance data to measure process capabilities and determine operator productivity. Put in place a methodology for performing continuous improvement analysis to define measurable steps in each process, map system and business processes and collect pertinent data at each step in the process.

Behavioral Health Outpatient Episodes Data WarehouseRe-engineering a legacy SAS derived data warehouse and redeploying it into a more robust Sybase data warehouse environment that leverages DataStage for ETL and Crystal Reports for report generation. Drafted Technical Specification and ETL Mapping Specifications for handoff to development resources. Requires defining DataStage jobs and relational table structures to leverage the larger data warehousing environment. The data warehouse compiles relevant claims and groups them by provider type, member diagnosis, benefit types and date ranges. Case mixes derived from the data set provide a unique perspective on provider performance.

Solution Manager Implementation Team LeadPerformed fit assessment for most Solution Manager functions including Charm, Service Desk, Configuration Management and Quality Center Integration. Aligned these tools with Target’s existing tools, methodologies and support groups and then assembled a project plan to realize implementation of Solution Manager tools ahead of the functional and support teams’ timelines for use.Release and Change ManagerProvided analysis and alternatives for transport migration path from development environment to production environment. Responsible for deploying first projects in Charm and managing the creation of transport requests and tasks across the SAP landscape. Facilitated change requests for additional corrections and provided change management support to functional, technical and development teams.Goods Receipts BlueprintingResponsible for blueprinting AP functionality with a focus on three-way matching of goods receipts, purchase orders and invoices. Coordinated subject matter experts, gathered business requirements, assessed technical requirements and wrote Blueprint Design Document for goods receipt processing and Functional Specifications for interfacing with legacy distribution applications. Formulated a solution design utilizing SAP rough goods receipts to accommodate substitutions from purchase orders.

Development LeadOrganized workload for a team of 25 developers in effort to implement standard SAP functionality along with more than 250 customization objects. Reviewed functional specifications and assigned work to developers based on fit with technical requirements and resource capabilities. Monitored process team sign off on development work and code promotion to QA environment. Put in place a detailed project plan to manage status of development objects, estimated development hours, actual development hours, and resource constraints. Order Entry IntegratorDocumented decision making rationale for tool selection to meet order entry functionality needs. Compiled CRM System Requirements and documented gaps in tool choice. Coordinated the work breakdown of development and configuration into manageable tasks. Assigned resources to this WBS and handed off to CRM team for execution. Batch Management and Automated IBase Warranty AssignmentIdentified solution design gap between ECC Order Fulfillment and CRM Warranty Assignment functionality. Designed solution to enable automated CRM IObject creation in a batch controlled environment and eventual warranty maintenance functionality to Customer Interaction Center. Leveraged CRM Activities to track complaints and facilitate the exchange and warranty process. Cutover PlanDrafted go live implementation plan with milestones. Defined milestones in collaboration with leadership team and provided several options for cutover successes utilizing maintenance releases to alleviate initial go live constraints. Defined maintenance release strategy and implemented change control processes to enforce scope controls. Implemented prioritization and criticality ratings for changes and incorporated with a daily change review process. Provided updates to the Steering Committee on release strategy and timeline risks using data collected via the change review process.

Gained key stakeholders’ verification of release design via end to end process modeling of SAP functionality. Organized super users from several divisions and assembled modeling sessions for these super users that covered all aspects of the release including PLM, SCM, CRM and BI. Required detailed understanding of end to end process functionality including sequencing of integrated process scenarios. Coordinated training, testing, production support and functional teams around an intensive schedule of recording training materials, testing functionality and integrating process streams. Provided verification results to Steering Committee and worked with functional teams to put design changes in place.

Compliance and ValidationLed FDA driven validation reporting for a major SAP releases and follow-on maintenance releases. Through direct interaction with numerous project teams executed against the validation protocol by coordinating test scenario creation, test case development, test requirement linking, defect resolution, transport baselining, hardware qualifications, application installation qualifications and regulatory risk assessments. These activities and the release scope were summarized and presented to executive leaders for Go-Live Authorization in the Release Validation Report. Project StandardsCoordinated and drafted numerous work instructions defining the software development lifecycle and project methodologies for use in a major SAP project. These work instructions proceduralized the ASAP methodology for implementing SAP and provided an auditing source for ensuring consistent processes were followed by the functional, basis, quality, training, and production support teams.

Custom Electronic Device History RecordManaged a team of on and offshore consultants and partnered with BW team to build a custom solution for product tracking across MM, QM, PP, SD, and CRM modules of SAP. The eventual solution included 15 custom fetching transactions, tables, and InfoCubes containing data that was provided in Crystal and BEXs reports. These reports provided full forward and backward traceability from raw material purchasing, material movements, production order issues and confirmations, distribution movements, to finished device implantation in a patient. Field Action ManagementLed a cross functional business team through blueprinting of product recall requirements. This variant process stream integrated configuration across functional areas to provide a process stream from QM, PP, MM, SD, and CRM. By leveraging integration across functionality and teams, we were able to avoid customizing ECC and provided a solution that enabled the business unit to have visibility to inventory derived from various attribute inputs. Leveraged Batch Cockpit (BMBC), Product Structure Browser (CC04) and Quality Inquiry (QA10) to create continuous process stream. Patient and Device TrackingLed a cross functional business team through blueprinting and conceptual design of a device tracking solution. This solution bridged a gap in SAP functionality and enabled tracking of implantable devices from components out to a patient implant. The solution utilized Equipment Master, Serial Master, Batch Master, Bi-Directional Replication, Installed Base, Business Partner and Business Warehouse functionality. Document Management SystemRe-engineered document control processes and leveraged SAP Document Management System. The solution consolidated several legacy document scanning and storage systems into one streamlined business process and provided visibility to key documents across the entire organization by linking to the SAP Batch Master record.

MFG Pro Patient and Device TrackingEngineered new and improved Product Registration process and redesigned the Patient and Device Tracking database as part of a continuous improvement project to gain Green Belt certification. This effort involved blueprinting several process streams and identifying business efficiency opportunities. The final product included completely redesigned tracking system that interfaced with distribution and manufacturing functionality, data entry interface built around the most efficient business process and a business warehouse that provided quality and sales metrics. Cardiac Surgery MetricsLeveraged key data to define and build statistical metrics for executive leaders providing trending of sales, implant, complaints and returns data. Trending reports and market indicators such as implants by physician and units sold by sales representative were distributed via executive dashboard to sales vice presidents and sales force. This tool, built in an SQL database, has been in use for five years and continues to assist all facets of the organization including leveling inventory, driving intelligent sales tactics with physicians, and providing divisional executives with accurate daily sales data. Cardiac Surgery Annual Quality Systems ReportExecutive anthology and analytical narrative of quality systems metrics that included implant, returns, sales and complaint metrics. This compilation afforded executive leaders a unique record of the prior year and a baseline metric for managing the cardiovascular line of products. Included analysis of patient demographics, implant and failure rate analysis, control charts that established upper and lower controls for complaint management, pareto chart summaries by failure type, and return dispositions.

Pier 1 Imports Wide Area NetworkProvided support to Senior Project Manager at customer host site on this 750 site managed wide area network. Drafted statements of work for subcontractors, ordered equipment, coordinated site surveys, coordinated maintenance, ordered circuits, and created and maintained asset management database. Included negotiating terms of the statement of work and defining Comdisco's and Pier 1's responsibilities to ensure a smooth rollout. BBraun/McGaw Wide Area NetworkProject lead on this wide area network rollout. Included interfacing with customer on a daily basis, hiring subcontractors, ordering circuits, ordering maintenance, drafting statements of work and coordinating site installations. Honda Motor Corporation Wide Area Network Project lead on Honda's international wide area network rollout. Included interfacing with customer on a daily basis, hiring subcontractors, ordering circuits, ordering maintenance, drafting statements of work and coordinating site installations. Molex Disaster Recovery NetworkImplemented this disaster recovery network. Negotiated and drafted statement of work. Procured equipment, circuits, maintenance and subcontractors. Drafted technical description and provided detailed network design to customer. Negotiated and drafted service level agreement. ProStaff Personnel Services Wide Area NetworkCoordinated the rollout of this Citrix/WinFrame/Windows NT based WAN. Configured and tested equipment, determined equipment needs for sites, procured equipment, procured circuits, coordinated sub-contractors, provided communication between Comdisco and ProStaff, performed site installations and upgrades, maintained asset management database and provided technical support to sub-contractors and ProStaff personnel.

-Helped with personnel and regulatory compliance issues for a start up tele-communications corporation. -Compiled information and filed documents for copyright protection.-Drafted corporate resolutions and board minutes-Drafted explanatory memoranda regarding regulatory compliance

-Summarized legislation for the Senator and his staff. -Attended oral arguments and summarized the impact of Supreme Court decisions on Senator’s constituents.