Felicito Rustique, Jr.

SharePoint & MS 365 Developer, Chugach Government Solutions (CGS)

San Diego, CA | Jan 2025 - present

• Creating workflow, data visualization, and application solutions for the Contracts Directorate at Naval Information Warfare Systems (NAVWAR) Command.
• Collaborating with four (4) senior procurement analysts and one military deputy director to identify project goals and timelines.
• Submitting monthly situation reports (MSR) showcasing accomplishments and percentage of task completions.
• Developing a display and management solution for the NAVWAR Acquisition Policies and Procedures Manual (NAPPM) - 82 documents related to Federal Acquisition Regulations (FAR).
• Created a four (4)-screen ‘NAPPM Power App’ application with key features such as:
• Ability to search, display, and make non-destructive edits to the NAPPM documents, and submit changes for approval to publish.
• Ability to search for and download resource files through a ‘NAPPM Toolbox’ embedded as a gallery in the application.
• Ability to download all NAPPM documents as one, stylized HTML file, viewable in web browsers and also received via email through a button triggering a Power Automate flow.
• Created three (3) data sources (two Microsoft lists and one document library) to populate application:
• ‘NAPPM PowerApp Content’ list - Converted 82 documents previously displayed as individual SharePoint pages into individual records with corresponding columns and fields.
• ‘NAPPM Change Log’ list - Tracks proposed changes to NAPPM documents as dated records created when app users submit proposed changes. Records display old values compared to new values, submitter & reviewer info, and status updates of pending, accepted, or rejected through a notification & approval automation process.
• ‘NAPPM Toolbox’ document library - Organized 368 resource files by FAR categories and converted the library into a searchable gallery in the application, allowing for better displaying, locating and downloading of the resource files.
• Producing and embedding data visualization charts in a SharePoint page for NAVWAR HQ leadership meetings.
• Produced four (4) Power BI reports by creating normalized Excel tables referencing downloaded data sheets, done bi-weekly, from the DoD’s Acquisitions Management System (AMS).
• Lead Specialist Workload Status’ report - Contains seven (7) donut charts displaying counts of Procurement Initiation Documents (PID) and totals and percentages for different categories.
• ‘Award Timeliness Trends’ - Line chart compares percentages of three types of contract awards for current versus previous fiscal year.
• ‘Complexity Workload’ - Heat map displays PID counts for Procurement Acquisition Lead Time (PALT) categories based on five (5) complexity categories grouped into seven (7) NAVWAR acquisition branches.
• ‘Bow Wave by PALT Category’ - Bow wave graph displays PID counts for fifteen (15) PALT categories by month for past, current, and future fiscal years.

EDUCATION