• Use SQL queries to identify and extract data to be used in data warehouse project. Later used Power BI to create reports and visualizations of that data as a proof of concept.• As PM/Scrum Master lead small team to implement data warehouse and bring to production a set of Power BI reports to satisfy business requirements.• Conduct interviews with user communities to understand user’s processes and to gather requirements for software features, and to solicit sign off from users and manage changes to requirements that occur after sign-off.• Perform Use case analysis and write user stories to define specific tasks for developers and to create acceptance criteria to provide details of functionality to define when the user story is complete. Also create negative scenarios and explain how system should react to them. Use Jira to enter user story and acceptance criteria to be used during Sprint Planning and execution.• Write test cases for use during User Acceptance Testing and PPV. Work with QA Engineers to define automated testing scenarios and to validate those scenarios work as expected. • Work with UI/UX team on design of wireframes to ensure user interface meets requirements and provides a streamlined experience. Also work with Accessibility Team to ensure interface meets WCAG 2.x guidelines.• Assist with regression, user acceptance, and post-production validation testing during the software development life cycle, and work with developers by demonstrating bugs and making recommendations to resolve software issues.

Functions as a liaison between the project sponsors, and internal software developers to define solutions for eCommerce and Enterprise Systems.Conduct requirements gathering sessions with Senior business users to define new features, enhancements to existing functionality, and discovery of software bugs by conducting interviews and performing analysis on existing systems. Write user stories, functional and detailed specifications for new features and enhancements, from details gathered from users, including policies, workflows, and processes (procedures). These specifications, once approved by users, are then used by the developers to implement the new functionality.Perform data analysis using SQL Queries and Excel to identify trends and anomalies of data in QA and Production in order to validate requirements, identify bugs and gaps, and ensure developed requirements meet business needs.Use tools like JIRA and Trello to track all requirements through the SDLC Lifecycle, included requirements definition, development, testing, and deployment.Coordinate testing with QA team and business users to ensure developed functionality meets the stated requirements in terms of functionality and performance.

Work with clients to define project scope and requirements for a new website based on individual project budget.Manage the project team though the creation of detailed project description, estimates, specifications, schedules, and timelines.Leads team including Graphic Artists and Developers from project initiation though completion.Document all aspects of the project through the use of meeting notes, status reports, change requests, and project plans.

Led implementation projects for new and existing clients by gathering requirements, establish best practices to implement our solutions. Includes client on-boarding, normalizing data sources, defining workflows, data structures and processing routines and resulting reports and dashboards.As primary point of contact, managed relationship by conducting status meetings with clients and internal stakeholders, defining the project plan for implementation of SaaS/PaaS solution, and setup and monitor the daily/weekly/monthly production cadence.Perform data analysis using SQL Queries, Excel, and other tools, to ensure client data is consistent and valid during both the implementation and production processing.Identify sales opportunities with existing clients that leads to expansion of services and deliver these to Account Management team.  Support sales team with proof of concepts for potential clients.Use JIRA to track development of custom client processes and new platform features, during SDLC cycle from requirements definition to production deployment. Partner with development team to define custom client processes and new features, work with QA Team to ensure product stability, then assist client during the roll out of the new feature set.Demonstrate an in-depth understanding the client’s strategic agenda and issues facing them through the development of custom reports, charts, dashboards and other presentation aids, created specifically for different levels of the client’s organization, by presenting raw data in relevant and functional visualizations.

Responsible for supporting SAP for inventory and warehouse management and manufacturing processes for multiple US plants and non-US plants.Traveled abroad as part of implementation for first SAP plant, then provided continued on-site support.Participated as member of project team to implement SAP at several plants from start of project through hyper-care. Helped rework inventory and manufacturing processes to simplify manufacturing operations and to increase inventory accuracy.Provided training to end users and super users on various transactions and processes, including cycle counting, process order life cycle, and other inventory movements.Provided support for homegrown MES and Inventory Control system, multiple ERP systems, and Warehouse Management System for largest US plant.Performed analysis, wrote specifications, performed testing to update existing functionality in SAP and MES, and WMS systems.

Responsible for supporting the chemical production environment, including multi-vendor automated compounding machines, Warehouse Management System, Manufacturing Execution System, and Enterprise Resource Management System.IS representative on large projects to support expansion of the production department. This included construction projects, installation of infrastructure equipment, computers, printers, and automated systems to support manufacturing processes, and warehouse management systems.Coordinated with multiple international vendors and internal engineering group to support compounding systems. Three compounding systems were successfully installed with interfaces to the current ERP and MES systems. Others were enhances to support manufacturing processes. Managed security for ERP and MES systems for North and South America. Successfully implemented approval and tracking process to comply with corporate data security requirements.Collaborated with internal and offshore developers to enhance and fix problems with current ERP and MES solutions. This includes writing specifications, organizing user acceptance testing, scheduling deployment and providing support for the new changes.Supported members of IS Security Team in conducting security audits of local systems and participated in litigation activities as a subject matter expert.

Participated on several development projects from design phase through development. Wrote specifications, defined data models, designed architecture and wrote software for several applications to manage commercial divisions requirements.Acted as primary developer for an application to manage the Global pre-sales Sampling Process. In this role, designed application with the division’s end users, performed development, coordinated testing, and supported the application. The application was successfully deployed and managed 10,000 sample orders per year.Participated as subject matter expert on development team to develop web-based applications to manage pre and post-sales activities, including the Global Sampling Application. Written in Java, these applications were successfully rolled out to 3,000 users globally.Managed custom extranet applications used by top clients to provide product specifications, documentation, and sample ordering. This included a self-service web site used to sell some materials to customers with credit card payments.Chief technical architect on a project to replace extranet applications with a new web portal. Coordinated internal business users to define requirements, and led consultants to define the architecture and ensure the system fulfilled the requirements. Acted as IT Coordinator of a commercial division ensuring the proper IT resources were available to meet their needs. This included project management, budget planning, purchasing hardware and software, and support of custom software needs.

Responsibilities include installing, maintaining, and upgrading hospital network. This includes file servers, hubs, routers, backbone equipment, gateways, and Internet servers. Other responsibilities include aiding in installation and support of clinical and administrative systems for diversified departments such as Cardiology and Finance. Install and maintain Enterprise Network Concentrators that form a fault-tolerant 3,000 node network that must be in operation 24 hours per day. Use tools such at Network General Sniffers to diagnose problems quickly to minimize downtime in ICUs, Emergency Rooms, Radiology, and Operating Rooms. Upgraded hospital backbone from a three-segment Ethernet backbone to a high-speed ATM backbone that utilizes switching and VLAN technology to reduce broadcast traffic and network congestion. Upgraded WAN connections at remote sites which Included acquisition of T1 communication lines, installing routers at remote sites, and installation of high-capacity routers in the data center. Installed and maintained Novell Netware File Servers for use throughout the hospital. These fileservers are used for general file and print services as well as a platform to host departmental applications- Established connection to Internet, which included installation of Unix and NT servers to provide Internet/lntranet Web access and E-mail throughout the hospital.

Installed, maintained, and upgraded corporate network. Including corporate accounting system, and electronic mail system. Wrote standard operating procedures for maintaining these systems. Acted as project leader with both users and independent software developers to design and implemented a time tracking system to track time accumulated on projects. Later, maintained system written in Visual Basic. Installed and upgraded network file servers to meet corporate needs. This included combining file servers during a corporate downsizing, implemented Microsoft Mail as corporate electronic mail system. Installed and maintained Palindrome Network Archivist to backup corporate file servers and developed a disaster recovery plan with vendors to minimize downtime in the event of a system-wide failure. Developed several standard operating procedures to provide guidelines for network maintenance, system backup and restore procedures, disaster recovery procedures, electronic mail and scheduler usage, anti-virus protection, and network security as part of ISO 9000 Certification ProcessResponsible for specifying, maintaining, and upgrading all corporate computing hardware and software Installed and maintained communications server for remote access to the network, that provided both remote node and remote control access to the network.

Worked with users to write functional specifications and with programmers to write detail specifications, wrote software to implement the specifications, and validated software of other programmers. After validation, provided training and support to users. Designed and wrote Data Collection Utility to facilitate the submission of electronic filings for Financial Printing, from outside customers. Maintained an Insurance Tracking System by redefining modules and reports to better suite the needs of the user community. Designed and wrote a Mutual Funds Reporting System in Microsoft Visual Basic and Access. Installed and maintained Novell Netware servers for departmental use. This included administration of user, file and print services, writing backup procedures for operators, and planning the implementation of upgrades and patches to the operating system. Aided nation-wide help desk center as second-level support personnel for application software troubleshooting. This involved receiving trouble tickets, determining reason for problem, planning and implementing corrective action.

Responsible for all of the day-to-day activities of both PC and AS/400 including administration, maintenance of hardware and software installations, and upgrades. Also, managed projects to enhance the business objectives of the departments. Wrote and maintained Human Resource Information System in Foxpro. Included defining the necessary data models, developing a system prototype, coding the system, testing the system for data integrity, writing technical and user documentation, and providing training and support for users. Realized a $12,000 vendor cost savings by creating a data entry system to capture the results of 2,500 surveys, created a series of statistical reports from the entered data. Developed management reports by utilizing AS/400 Query and CL. Maintained department Netware Servers. This involved adding, and deleting users, and maintaining user access privileges for the departments. Led and managed the installation, training, and continuing day-to-day support of all the new hardware and software for an off-site department. Analyzed group word processing requirements, compared features of several applications on several platforms, selected and installed the software, customized the package with macros, and converted existing manuscripts.