Robert Frederick

Robert H. Frederick Senior Business Analyst-| https://linkedin.com/in/roberthfrederick Alexandria, VA 22311 |- Senior Business Analyst with expertise in all SDLC phases, including requirements analysis, user acceptance testing, in addition to being a former systems developer. An analytical thinker with keen attention to detail, complemented by strong leadership, cross-team collaboration, with exceptional presentation skills. An effective stakeholder liaison who is an effective liaison between business users and IT teams. PROFESSIONAL EXPERIENCE Senior Business Analyst (Part-Time) Portfolio Alignment Partners – Washington, DC 06/2024 – Present - Developed technical requirements, process models and data models to support county agency business functions as business analyst, building Power BI data visualization and improving internal controls. - Developed assessments for a South Carolina county agency, performing benchmarking analysis, business process modeling, and change management, leading to a 20% increase in operational and cost efficiency. - Developed proposals and presentations to drive business growth for the firm, securing new clients. - Advised consultants on improving the quality of client artifacts, including SOPs, process workflows, and business requirements, ensuring high standards in project deliverables. Senior Project Manager & Business Analyst (Project Management Office) Windsor Group, LLC – Washington, DC 08/2021 – 06/2024 - Optimized flow of operations by 30% through the successful replacement of a customer-facing process tracking system, serving dual business analysis and project manager roles, building technical requirements, and supporting user acceptance testing (UAT) phase. - Spearheaded project execution for a congressionally mandated publication, ensuring on-time delivery for the first time in 7 years via schedule management, resource allocation and stakeholder engagement. - Automated project planning, resource management, and risk mitigation, through implementation of realtime status reports and KPI dashboards, optimizing transparency and client decision making. Principal Consultant (Business Analyst, Product Manager) and Owner H. Christopher Harrison Consulting LLC, Self-Employed – Arlington, VA 05/2015 – 08/2021 - Led business analysis engagement for an Agile enterprise scrum team within an electricity cooperative (energy industry), gathering technical requirements for a customer-facing payment portal. - Managed backlog refinement and Enterprise Scrum Team processes using Azure DevOps, ensuring business needs were translated into clear, actionable user stories and technical requirements. - Worked directly with system developers to ensure alignment with business user requirements. - Developed SQL queries for reporting and data analysis, improving cooperative payment accuracy, and generating reports for key stakeholders. - Led User Acceptance Testing (UAT) efforts, validating system functionality and ensuring compliance with customer requirements. - Led Agile development and testing of a new, B2B project management software application using Azure DevOps, defining business and technical requirements, user stories, prioritizing features, and leading beta testing, pushing back on developers, when needed. 1 Senior Manager (Business Analyst and Strategy Focus) Publicis Sapient – Arlington, VA 03/2007 – 04/2015 - Led customer experience enhancements for a financial services self-service portal as business analyst, facilitating process development and requirements definition, increasing customer retention. - Earned a company-wide award for creativity in leading an organization’s rapid expansion from 2 to 130+ employees in 14 months, driving organizational design, business process optimization, change management, and vendor evaluation. - Increased sales conversions by 15% for a home security company’s website through user activity tracking, dynamic content personalization, and A/B testing. - Developed a business case to attract young professionals to the insurance industry, conducting market analysis, and benchmarking, increasing recruitment engagement by 10%. Strategy Consultant and Project Manager Accenture – Arlington, VA 02/2005 – 02/ 2007 - Conducted cost-benefit analysis for technology solutions to secure the U.S. border, evaluating product feasibility and implementation strategy. - Developed a 5-year strategic roadmap to enhance technology capability and business operations, defining product vision, KPI metrics, and risk mitigation strategies. - Spearheaded buildout of PMO at a government agency, introducing Earned-Value Management (EVM) principles, forecasting costs, and mitigating risks, leading to 20% improvement in cost forecasting. TECHNIAL AND BUSINESS SKILLS - Business Analysis: Agile frameworks (Scrum, Kanban), Enterprise Scrum, Azure DevOps, Requirements Gathering, Backlog Management, User Acceptance Testing (UAT), Stakeholder Engagement, Process Optimization, Process User Stores & Acceptance Criteria - Data & Reporting: SQL (data querying, report building), Power BI, Advanced Excel (Pivot Tables, VLOOKUP, Data Cleansing), Key Performance Indicators (KPI), Python - IT & Applications: Office Suite, Jira, Confluence, ServiceNow, Smartsheet, Visio, SharePoint, Microsoft Outlook, Tableau, MS Project, Azure DevOps - Management: Energy Industry Experience, Team Management, Coaching, Project Management, Enterprise Scrum Teams, Resource Allocation - Communication: Cross-Functional Team Collaboration, Presentations EDUCATION Tuck School of Business at Dartmouth Master of Business Administration (MBA) | Business Strategy | 2001 | Han1over, NH University of Virginia Bachelor of Science (BS) | Commerce |1995| Charlottesville, VA ▪ Dual Concentrations: Management Information Systems (MIS) | Marketing PROFESSIONAL CERTIFICATIONS Applied Data Science with Python Specialization (ID: 5E7J3L417A6D) University of Michigan, Completed, January 2025 Project Management Professional (PMP) (ID:-) Renewing in Year 2025 COMMUNITY ENGAGEMENT ▪ ▪ Board Member (Finance/Budget Committee) – Arlington Thrive – Arlington, VA, July 2021 – Present May 2022 Graduate, Arlington VA Leadership Center for Excellence 2