Robert Aguilar Email & Phone Number

United States

• Developed Case Summary Dashboards: Created department-specific dashboards to track open cases, pending queue items, duedates, and case comments, providing business analysts and departments with a centralized, convenient, and secure platform.Conducted comprehensive data clean-up to ensure the integrity of the company dashboard.• Ensured Data Accuracy and Reliability: Conducted comprehensive data clean-up using tools such as Data Loader, Excel, andWorkbench, ensuring the accuracy and reliability of company data.

• Optimized Weekly Report Processing: Developed an automated process to integrate third-party vendor reports with Salesforce bycreating unique Key IDs for accurate data mapping, utilizing Excel’s XLookup for efficient data matching, and implementingSalesforce Flow for automated status updates, reducing the task time from 4 hours to 15 minutes weekly.• Designed Feedback and Escalation Process: Created a system to send surveys to end users after ticket closure, generatingfeedback records from completed surveys. Implemented automated actions for low-score surveys, including automatic emailnotifications to responsible parties and escalation to managers if not addressed within one business day. Developed a report totrack overdue action items, ensuring timely resolution.• Optimized Recruitment Pipeline with Flow Builder Automation: Implemented Flow Builder automation to streamline theinternational recruiting department’s pipeline by automatically populating candidate information at each stage of the hiringprocess, significantly enhancing recruiter efficiency.• Implemented Automated Billing Efficiency Flow: Developed a scheduled daily flow to enhance the billing team’s efficiency byautomatically populating the missing “days to dispute” field on weekly invoices. Extracted information from timesheet and billingprocess objects to create a formula field that calculates the remaining dispute days, eliminating 2 hours of manual input.• User Configuration and Access Management: Configured and set up employee, user, and candidate records for new hires,ensuring appropriate access by assigning correct permission sets, licenses, and public groups based on their role. Responsible forpassword resets and troubleshooting access issues, tailored to specific titles and roles.

• Ensure the reachability of new devices within the network.• Assist field technicians with troubleshooting: confirming valid IP’s, creating tickets for external issues.• Acquire the Layer 2 address for the DHCP server to correctly identify a device within the network.Streamlining calls away from onsite operations for field technicians

Bachelor Of Science - Bs, Computer Science, Senior

Associate Of Arts - Aa, Computer Science