Robert (Bo) Nash Email and Phone Number

Key BSA for 5 of the major applications used by a major pharmaceutical manufacturing organization. Worked closely with end users on a daily basis, from responding to application issues, to requirements gathering for enhancements and upgrades, to testing new application features and enhancements. Partnered with vendors, from future version enhancements to system support issues in a GMP and SOX regulated environment.• Worked on multiple projects with cross-functional teams, for various systems simultaneously.• Collaborated with internal customers on requests for new functionality to systems, from idea inception through user acceptance, training, enhancement implementation, and provided specialized support post-implementation. Documented and communicated status continuously during all steps.• Developed user stories based off of user requirements gathering sessions and operated projects in a pseudo-Agile environment. • Coordinated with application vendors to ensure functionality requests were possible, and once getting new versions of applications, that the requests functioned as requested.• Developed and documented user requirements, functional requirements, threat assessments, traceability matrices, and test plans used in the validation plans (SQAP) for the software validation of new systems and enhancements to existing systems as mandated by corporate, GMP, and SOX policies.• Provided day to day user support of key systems, resolving issues or forwarding through proper channels when needed, to help ensure the continuous operation of systems.

(Continuation of PharMEDium accomplishments):• Successfully implemented functionality integrating two systems (MasterControl and ASCTrac) that allowed for materials to be placed on hold for various quality related investigative purposes.• Administered user security and access rights along with general administrator functions for the Cloud-based Quality Management System used, MasterControl.• Coordinated with vendor of Cloud-based Quality Management System (MasterControl) for vendor performed monthly maintenance and yearly updates of application.• Confirmed required vendor documentation of disaster recovery testing, risk assessments, and software validation plans for upcoming versions of Cloud-based Quality Management System (MasterControl), as per PharMEDium’s validated systems’ requirements.• Used JIRA for enhancements and application project tracking.• Performed various steps of the SDLC in the process of application upgrades and enhancements. • Administered user and group/role security and reviews for the ASCTrac (warehousing) and GP (ERP) systems, following GMP and SOX guidelines.• Performed monthly and quarterly SOX reviews of the organization’s ERP system and helped eliminate or mitigate segregation of duties conflicts.

(Continuation of PharMEDium accomplishments):• Wrote complex SQL stored procedures and designed reports for SSRS site that were used by sales staff.

Developed and maintained custom applications written in VB (6 & .Net 2013).• Maintained SQL Server Stored Procedures and Views.• Created and maintained reports for Made2Manage ERP system (v6.01).

= I.T. Systems Manager: 2012 – 2016= Senior Database Programmer/Analyst: 2011 – 2012= Database Programmer/Analyst: 2006 – 2011Developed several applications using Visual Basic (v6, .Net), performing such processes as: Database access and table manipulation via custom created Windows Forms and using ADO and SQL Client. File reading and writing, to csv, txt, and tab delimited formats. Reporting (using Crystal Reports 8.5 and 10, and SSRS). Automated emailing. Assisted end users. • Created and maintained reports for Made2Manage ERP system (v6.01).• Built several complex Excel applications which accessed SQL Server data and performed automated functions.• Wrote several stored procedures and views used to access SQL Server data for end users via custom created VB applications, Excel Worksheets, and QlikView BI reporting tool.• Performed as needed data table manipulation and maintenance, created and maintained automated jobs on SQL Server 2008 R2.• Monitored application written in C# which accessed multiple data sources, processed and formatted data into csv files, and then initiated an automated task which imported the data into Great Plains.• Maintained user security on organization’s Great Plains system, adding and deleting users, administering rights.

• Enhanced and maintain sales tracking/order entry/inventory system designed in Access 97 for a steel commodities broker.

Enhanced functionality and made major modifications to a sales tracking/order entry/inventory system designed in Access 97 for a steel commodities broker. Provided programming and network support for a national healthcare organization.• Designed the home delivery order modification segment of an internet-based order entry system for a prominent Illinois dairy using Visual Interdev, Visual Basic, VBScript, and SQL Server.• Developed a custom report system using Access (2000) that involved several complex queries and reports for a major automobile service center.• Performed project life cycle and acted as Project Manager for a sales tracking and marketing application incorporating Visual Basic, Access (2000), Excel (2000), and Crystal Reports for use by over one hundred users. • Designed, coded, and acted as Project Manager for a financial quote application using Visual Basic, Access, and Excel, for use by a prominent financial organization.

Developed multiple custom business applications using such Microsoft Products as Visual Basic, and SQL Server for use in organizations dealing with surveillance for loss prevention, and workflow automation.• Developed applications using 3-tier architecture, object-oriented design techniques, and COM.• Maintained Access based application for an equipment parts manufacturer.• Used such tools as Visual Basic 6.0, Access (97 and 2000), ActiveX Data Objects, Data Dynamics ActiveReports, and SQL Server 7.