SHAWN D. BARNES

Oceanside, CA

760-***-****

adk7ev@r.postjobfree.com I linkedin.com/in/shawnbarnes75

HIGHLIGHTS

Certified Project Management Professional and experienced Business Systems Analyst in designing and developing secure real-time mission-critical systems to support organizational strategic goals and day-to-day business operations. A common-sense approach to solving problems, clear, proactive communicator, and team player with more than 18+ years of experience delivering excellent customer service and solutions within the Pharmaceutical, Utility, and Food & Staples Retailing Industries to Information Technology and Government Administration sector.

KEY SKILLS AND KNOWLEDGE

Strong Knowledge in Business Process Analysis and Gap Analysis

Scope, Schedule, Cost, Quality, Risk, and Procurement Management

System Requirement and Busines/ Technical Process Documentation

Versed in all Project Management Lifecycle Phases

Confident in SDLC Waterfall and Agile environments

System Software and Hardware Configuration

Communication, Stakeholder, and Change Management

Exceptional Analytical, Critical Thinking and Presentation Skills

Excellent Conflict Management, Interpersonal and Teambuilding Skills

ADVANCED TECHNICAL SKILLS

Microsoft: SharePoint, Project, Visio, Excel (VBA), PowerPoint, Dynamics 365, Visual Studio (.NET Framework), SQL Server, Access, Skype/Teams, Publisher, Outlook Power Platform: App, Automate, BI, Virtual Agent

Languages: C#, Java, SQL, Basic Script (Bash Shell for Linux, PowerShell for Windows), JSON, XML, HTML, CSS

Other Applications: Spring/Eclipse IDE, Oracle SQL Developer, Tableau, MicroStrategy, Salesforce CRM, SAP ERP, ServiceNow, Planners Lab, SPSS, Trello, Slack, Confluence, Primavera P6, Jira, HP ALM, WordPress, Google Analytics, Survey Monkey, CyberArk, and some experience with Amazon EMR (Hadoop), Zoom

Comfortable Modeling Workflow [Behavior, Structure, Interaction] Diagrams: Business, Database (ERD) System, Communication, Network, Configuration, Integration Processes

Diagram Types: Use Case, Sequence, Activity, Class, Data Flow/Structures, System Context…

RELEVANT EXPERIENCE

All in Pet Clean Up

Founder Project Manager Business Analyst

Jun 2016 - Present

Own and operate a successful professional cleanup service, specializing in residential, commercial, parks and recreation pet waste removal, servicing 100's of client accounts across North County:

Develop website, business plan(s), financial forecast models, and achieved budgeting cash flow objectives and goals

Negotiate service prices with suppliers and customers, resulting in 20% cost savings annually in reduced transaction cost

Produce advertising content and promoted services on social channels boosting sales response rate by 25% per marketing campaign

Develop sales training and onboarding programs resulting in increased sales productivity 10% annually

Evaluate employee performance regularly and resolved issues as they arose

Coordinate with staff team on milestone timeline achievements to ensure customer satisfaction

San Diego Gas and Electric – Humble Bit Consulting Business Systems Analyst Consultant Project Management Office

Apr 2017 – Jan 2020

Collaborated closely on a $30mil+ SCADA Headend Replacement Distribution project with various levels of key business stakeholders from Operations, IT/Integration, Network Engineers, Telecom, Cybersecurity, Supply Chain Management, Legal, Subcontractors, and Corp Vendor Partners to meet business objectives with technical solutions:

Reduced change order and contract amendments request for product enhancements during the project by applying system thinking to translate client requirements (business-technical-system) to actionable solutions accurately

Delivered assign work package activities on-time and within budget by coordinating with SME's early-on to establish task priorities and exact timelines

Performed fit-gap analysis to assess impact of current state SCADA system hardware and software processes against vendor system proposal and found unnecessary recommendations that resulted in $500K+ savings off vendor original LOD proposal

Assisted management in the development of new SCADA electric operation technology standard procedures, including how-to training guides for: server failover, troubleshooting server login issues, remote terminal unit (RTU) device display configuration(s), SCADA software patch, and license key update(s)

Provided clear, detailed meeting minutes within 24hrs resulting in the successful completion of tasks; Responsible for multiple communication channels: monthly Corp Newsletter, SharePoint dashboard (including timeline, risk, accomplishment, and upcoming events)

Led coordination efforts with Developers, Database Administrators, and IT to migrate MS Power BI to the new enterprise gateway and MS SQL Server database

Resolved system issues remotely through command prompt using Putty and WinSCP to transfer and update new database/ display files to the appropriate environment and administered password changes, ping/restart server processes, etc.

Created SharePoint system change tracker library with version control to manage all business and system changes during system deployment resulting in zero concurrency issues (SharePoint Site front and backend administrator, managed dashboards/docs, access permissions, etc.)

Designed, tested, and published (web and phone view) Power BI Electric Distribution Outage Dashboards to production improving executive, senior, and operator management decision making and situation awareness on elevated weather conditions resulting in 50% reduced outage impact to customers

Mapped and develop MS Access Firewall Rule database for technical team to track 200K+ port/protocol traffic integrations

Supported successful coordination and installation of brand-new cabinets and hardware equipment (100+) at MCC and BCC

Logged identified issues and risk in control matrix and coordinated weekly meetings with key stakeholders (vendor partner and SME's) to address risk score severity level and mitigation plans

Westpak Inc – Senior Experience Research Project, CSUSM Research Analyst Team Lead

Jun 2016 – Dec 2016

Partnered with Westpak executives and senior management on a senior experience project to develop the business case for an improved idealized future state online portal. Interviewed and analyzed client current pain points and translated Westpak customer voices and experiences into a recommended future system design proposal:

Coordinated group collaboration and facilitated communications between Business Researchers, Advisors, and Sponsors

Conducted needs assessment survey of 100+ clients, analyzed data, and determined efficiency level in the current system

Interviewed stakeholders, gathered and compiled business and system requirements that accurately described the needs of Westpak clients; documented the current state of customer experience from requesting a proposal, invoicing, and then provided recommendations on an idealized future state for the IT team to build

Generated Use Cases, Flow Charts, and Data Flow Diagrams to map out how data flows throughout the organization

Provided weekly status reports to senior management on the team progress of the project

Communicated precise analysis using both qualitative and quantitative metrics; delivered [recommendations in final report, presentation, and tradeshows]

ADDITIONAL LEADERSHIP EXPERIENCE

Produce Manager at Frazier Farms

May 2014 – Aug 2016

Inventory Control Lead at Camp Pendleton Commissary

Dec 2009 – Aug 2013

Maintenance Mechanic at US Foods

Aug 2007 – Nov 2008

Dispatch at Camp Pendleton Base Brig

May 2006 – Aug 2007

Motor Vehicle Representative at Camp Pendleton Joint Reception Center

May 2005 – Apr 2006

Service Account Manager at Prescription Solution/United Health

Feb 2002 – May 2005

Market Research Analyst at Harte Hanks Market Intelligence

Jun 1999 – Feb 2002

EDUCATION QUALIFICATIONS AND PROFESSIONAL DEVELOPMENT

Project Management Professional (PMP) Certification from PMI

Oct 2020 – Oct 2023

PMI San Diego Chapter Member

BS, BA - Management Information Systems at California State University San Marcos

Dec 2016

Dean's List Graduated Magna Cum Laude GPA 3.84

MIS Society Member Awarded MIS Outstanding Student of Year Plaque

AS, BA - Advertising, Marketing, and Merchandising at Palomar College San Marcos

Dec 2014

Phi Theta Kapa Honor Society GPA 3.89

Toastmaster International Member

Since Jan 2020

Contact this candidate