Ted Ploszaj Mcts, Cpim Email & Phone Number

Milwakee Wi

Guiding the integration of SAP, Salesforce, SharePoint, and other data using Power BI, PowerApps and Power Automate in a 365 environment. Development of training documentation, development documentation and the development of reports to provide global users with data needed to enhance performance and productivity.Assignment ended November 20201

Greater Milwaukee Area

Administer cloud based database that serves to augment SAP data, the database contains 27 applications that handle proposals, contracts, facilities and financial data. Develop enhancements to applications in the cloud, support SharePoint, Power BI, Quick Base, Azure SQL Server and SharePoint. Responsible for ETL work to in sure the care and feeding of various data sources.

Greater Milwaukee Area

Working with data from SAP and Business Intelligence (BOBJ), I design,create and monitor Access databases applications and Excel spreadsheets used to support operational analytics and ad hoc analysis of Customer Master Data and Point of Sales Data for Global Customer Information personnel around the world, that is distributed via SharePoint, email and High Tail (FTP).

Kohl'S Innovation Center

Working on smaller projects that have not been assigned to a Project Manager, as a Project Coordinator, I am working on multiple assignments:1) Coordination of a System Center Configuration Manager effort involving a cross functional team working on the identification of Service Accounts that present vulnerability issues and the remediation of those accounts.2) Data Center Consolidation project which calls for the identification of cabinets that are under utilized, the identification of applications on servers within under utilized cabinets and the preparation of change notices and communications with owners prior to moving servers.3) Data Center Efficiency project which entails Vendor coordination to provide additional heat and cooling monitoring and recommendations to secure an infrastructure that is as efficient as possible which will ensure proper cooling to servers and provide energy savings.4) Policies and Procedures for data centers, working with a vendor, we are documenting a set of policies and procedures based upon best practices. The effort includes the communication of policies and procedures via various communication vehicles to a three tiered audience at Kohl's and a different set of communication avenues for external vendors.

New Berlin, Wi

Responsible for working with SAP data (from both ECC (ERP) and Business Warehouse (BW) using SQL Server, SAP BEx, Business Objects Explorer, Business Objects WEBI,Business Objects Info View, Business Objects Analysis for Microsoft, CallidusCloud CPQ, ODBO, Visual Studio, Excel, Access, InfoPath and SharePoint. Also responsible for the development and execution of a self-service Business Intelligence program to include user training and the development of reports utilizing selected Business Intelligence tools from SAP, Business Objects and Microsoft, for two business divisions of ABB Inc. Responsible for the design and deployment of reports onto abbnow.com (extranet), Microsoft SharePoint sites (internal and external) and other Web platforms.Working both the demand and supply side of reporting for a fast growing division of ABB, I am responsible for managing business demand for reports and information, which includes project management. After gathering user requirements, I translate the business demand and document the requirements so that Off-Shore consultants located in India, consultants located in Finland or the United States, or myself, can craft the delivery of data that fulfills the needs of the business.I maintain the ability to effectively collaborate as either a Business Analyst or Systems Analyst in a complex and multi-site IS service delivery team environment that spans two continents and multiple countries. Working inside a Matrix organization, I have the opportunity to work with associates from a variety of countries and on a number of projects simultaneously.Specialties:SAP and SAP Net Weaver integration with Microsoft tools and Business Objects tools (Analysis for Microsoft, BO Explorer, Crystal Reports), Service Level Management, Knowledge Management, Training Delivery and Development, Strategy and Goal Alignment, Continual Improvement, Requirement Analysis, Application Management, Data ETL.

Leading a Strategy effort concerning Microsost Office upgrades that is taking a look at the risks and rewards of selecting alternatives to an enterprise rollout.New versions of Microsoft Office offer enhancements that may be of value to a select portion of the enterprise population and may not warrant the expense of a full rollout, as the majority of the population has no need for the enhancements.

Establish training activities to support the availability of SharePoint 2010 to the staff located in the Home Office. My responsibilities include the creation of training course materials, sourcing of vendors to provide instruction, participation in the design of a SharePoint knowledge site, maintainance of the work breakdown schedule, testing and consulting on overall system design issues.

Architectural Design and Development of SharePoint site to handle a Voice of the Customer Program. When mature, this site will handle a chorus of voices including Customers, Employees and an Independent Sales Force.From the Business Development and Analysis standpoint, the focus of fthe Voice of the Customer Program is to gather data through surveys, polls and requested insights on feedback, which is used to create and track actionable business intelligence.

Managed Microsoft Office 2003 Upgrade, covered over 17,000 computers/23,000 users.Also deployed Open Office to users who previously had the Microsoft Office image installed, which resulted in over a $4 million cost reduction regarding licenses from Microsoft.Identified existing software applications that conflicted with Office 2003, and directed the remediation required to meet requirements within Abbott's regulated environment.Assigned deployment groups based upon usage gathered through SMS and personal interviews.Provided hands on management of all Help Desk requests, issues and questions regarding Microsoft Office 2003 and Open Office until the Abbott Help Desk was able to come up to speed.Established a knowledge base concerning Office 2003 and Open Office issues that was used by the Abbott Help Desk to manage user expectations regarding Office 2003 and Open Office issues.Deployment was executed using Active Directory information and analysis provided by Excel Pivot Tables and alignment with IT Governance policies. Training issues and Support delivered through a team under my direction, as well as a second phase directed at deploying Microsoft Office 2003 or Open Office to Lab Machines.Additionally, developed Project Plan for the migration from Microsoft XP to Microsoft Vista to several divisions at Abbott, which included training, education and support plus directed the validation of testing results and the remediation of conflicts among applications slated to run with Vista.

Interviewed users of financial budgeting and forecasting applications.Analyzed business and information technology processes to understand users needs.Gathered requirements and wrote Use Cases.Created context diagrams regarding "as is" environment.Created flow diagram of current process and documented users "must have" requirements.Directed validation and acceptance process for written Use Cases. Interacted with VPs, Directors, Managers, Analysts and other users of the Budgeting and Forecasting system.

Interviewed users and managers of the Marketing Planning application.Analyzed business and information technology process to understand users needs.Created swim lane process flow diagrams and business system diagrams.Gathered requirements and reasons that users were not fully using the present application.Created a proposal to replace marketing application with Microsoft Project and MS Project Server.Wrote templates for enter of marketing plans at the desktop using Microsoft ProjectDirected off-shore development team that created support for marketing on server.Interacted with the in-house IT team responsible for the support of Microsoft Project.Worked with users and management to create reports using Project, Word and Excel.Developed SharePoint document libraries for the storage and distribution of reports.Documented the workings of the marketing application and developed an on-line knowledge base.Achieved a cost savings of $250,000 by not upgrading the software that had been used.

Worked with third-party software vendor to develop project plans and time tables.Acted as the liaison between the vendor, IT department, user community and management.Interviewed users at various levels of organization and numerous locations.Wrote corporate policies and managed approval process for corporate travel.Authored functional specifications and swim lane process flow diagrams for vendor that aligned the software with the business needs of Northwestern Mutual.Created training material and knowledge base for the user community. Tested application to ensure that it answered the needs of the user community. Created standard process flow diagram and instructions for a SharePoint site.Managed software vendor and modification of contract terms.Replaced third-party travel agency and achieve annual cost savings of $300,000.

Supported the Sales effort by reviewing RFPs, presenting demos of software functionality and working with potential clients on a pre-sales basis