SHAWN D. BARNES
Oceanside, CA
********@*******.*****.*** 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