Patricio A. Rodriguez

• Prepared analytics products for quarterly management reviews and executive meetings, including PowerPoint presentations, handouts, and ad-hoc reports.
• Conducted advanced quantitative research and statistical analyses (average, median, percentile, regression) aligned with stakeholder requirements.
• Managed large foreign military sales datasets (1,000+ records), organizing data into workbooks, creating pivot tables, and visual graphics for clear stakeholder communication.
• Collaborated with technical teams to extract and manipulate raw DSAMS data in Excel, enhancing data accessibility and analysis.
• Utilized advanced Excel functions including VLOOKUP, histograms, scatter/trend diagrams, pie charts, pivot tables, embedded objects, and macros to analyze and visualize data.
• Centralized information by designing and implementing SharePoint sites, pages, lists, and libraries with controlled access via custom permissions.
• Developed and executed knowledge management strategies by designing new workflows in a solution-driven environment.

• Led development and management of an online project-based selection and resource configuration knowledge management tool for the Joint Multinational Simulation Center.
• Acted as key contact for technical inquiries, content management, and intranet project/site requests.
• Directed implementation of system enhancements, ongoing maintenance, troubleshooting, and help desk ticket resolution.
• Drove continuous improvement of knowledge base content, taxonomy, and processes through gap analysis and key metrics evaluation.
• Collaborated cross-functionally with performance units, training centers, product management, operations, and contract teams on knowledge system R&D.
• Optimized information search and retrieval by liaising with diverse subject matter experts across the organization.
• Partnered with stakeholders to gather requirements, translate business needs into solutions, map impacts, and manage system deployment aligned with business goals.
• Increased adoption and user engagement by designing platform architecture focused on usability tracking and KPI analysis.
• Spearheaded development and implementation of process automation systems to enhance metrics utilization.
• Managed multiple projects by proactively identifying, tracking, and resolving issues, ensuring timely delivery.

• Created and distributed monthly and ad-hoc quality control, command, and operational reports across multiple departments.
• Collaborated on data management initiatives, ensuring data integrity, manipulation accuracy, and functional consistency.
• Supported knowledge management and Change Control Board (CCB) processes to maintain system and data accuracy.
• Assisted service desk in resolving data management system (DMS) issues by acting as liaison between users and IT teams.
• Utilized advanced Excel functions (VLOOKUP, pivot tables, macros), SQL, SQL Reporting Services, Power BI, and Tableau to perform detailed data analysis and produce insightful reports.
• Drove process improvements by analyzing performance metrics, identifying inefficiencies, and recommending solutions to increase operational efficiency.
• Developed and maintained strong relationships with senior military and civilian leadership, addressing issues and facilitating communication across organizational levels.
• Ensured strict confidentiality and security of Personally Identifiable Information (PII) and sensitive data in compliance with Secret security clearance protocols.

• Prepared analytics products for quarterly management reviews and executive meetings, including PowerPoint presentations, handouts, and ad-hoc reports.
• Conducted advanced quantitative research and statistical analyses (average, median, percentile, regression) aligned with stakeholder requirements.
• Managed large foreign military sales datasets (1,000+ records), organizing data into workbooks, creating pivot tables, and visual graphics for clear stakeholder communication.
• Collaborated with technical teams to extract and manipulate raw DSAMS data in Excel, enhancing data accessibility and analysis.
• Utilized advanced Excel functions including VLOOKUP, histograms, scatter/trend diagrams, pie charts, pivot tables, embedded objects, and macros to analyze and visualize data.
• Centralized information by designing and implementing SharePoint sites, pages, lists, and libraries with controlled access via custom permissions.
• Developed and executed knowledge management strategies by designing new workflows in a solution-driven environment.

• Managed over $250K in funds through SABRS, STARS, and CFMS financial systems, generating daily reports, budgeting, accounting, and ensuring audit readiness.
• Oversaw travel arrangements for 5,000 personnel using the Defense Travel System (DTS).
• Processed payments and contractual receipt/acceptance via GSA.
• Served as primary liaison for external auditors (EY), managing audits of approximately 750 government travel card transactions and 250 purchase card holders, ensuring compliance with relevant regulations.
• Maintained adherence to finance and accounting policies, including Joint Travel Regulations (JTR), by developing SOPs and collaborating with senior leadership and financial teams.
• Improved organizational productivity by managing and optimizing financial data reporting processes.

• Engaged with a diverse community of 2,000+ members, providing leadership, facilitating communication, and coordinating organizational mission delivery to political stakeholders.
• Improved efficiency and productivity by collaborating with leadership, key influencers, and industry players to develop policies addressing critical issues.
• Coordinated and managed events promoting intercultural exchange and language learning, raising awareness of language acquisition benefits and educational frameworks.
• Supported teaching and implementation of a school framework modeled on the US educational system.
• Applied advanced Microsoft Office skills to design solutions for data collection, organization, and storage.

If you'd like, I can help you integrate