Overview
Skills
Job Details
Apply by Email/Direct Application at
Role: Programmer Analyst
Duration: 3 months to 1 year
Interview Process: 1 video interview
Client Location: Santa Barbara, CA
REMOTE: Yes (PST hours)
Ideally, they want a candidate that is based in California.
Job Description
Must have experience recent experience in VBScript.
The macro system (Macros) was developed in-house by a former contractor. There is very limited documentation on the system. The Macros utilize VBScript and HTA programming. The purpose of the macros is to provide boilerplate text entry into specific locations in the CSE (Child Support Enforcement) application and other applications, such as texting. When launched, a browser window opens and users are presented with a list of macros from which to choose. Once a macro is selected, the user may also specify a call-back telephone number, method of communication, attorney, court location, and date (s). The macro searches for the appropriate webpage and fields, then pastes the text into the message field. The macros greatly reduce the time spent entering redundant text, reduce grammar and spelling errors, and ensure consistent legal communication. Additionally, reports are generated on keywords in the boilerplate to track Child Support Officers' efficiency.
Issue:
Microsoft Office 2019 is end-of-life and must be removed from machines by October 2025. Microsoft 365 Apps for Enterprise 64-bit is the preferred Office application, but the 32-bit version is acceptable for the short term. The current macro automation system is not compatible with Microsoft 365 Apps for Enterprise 64-bit. The Macro system utilizes an out-of-date calendar control that is no longer supported. This causes the Macros to crash upon launch and not function.
The calendar control is dependent on Microsoft Access 2010 Runtime being installed on the user s machine. This program is also no longer supported and poses a potential security vulnerability risk.
Currently, the runtime application is installed on machines with Microsoft Office 2019. Some machines have 32-bit versions, but most have the 64-bit version. When installed alongside M365 Apps for Enterprise 64-bit, the older Access Runtime program is automatically (and continually) removed by M365 Apps for Enterprise.
Resolution:
An Office Automation Programmer/Developer will evaluate, research, and document the Macro system and present options for Office compatibility. Resolution options may include a short-term fix that utilizes Microsoft 365 Apps for Enterprise 32-bit. A long-term resolution must be compatible with Microsoft 365 Apps for Enterprise 64-bit, Microsoft Edge browser, and Windows 11. The long-term resolution must also include user instructions and training, maintenance instructions, and system documentation. The system will be designed, programmed, and developed using software industry standards and best practices.
The Office Automation Programmer/Developer (temporary contractor) focuses on using programming and scripting to automate repetitive tasks, improve workflows, and enhance efficiency within an office environment. This role involves designing, implementing, and maintaining automated solutions, often using languages like PowerShell, JavaScript, Python, VBScript, and other scripting tools.
Key Responsibilities:
Develop and Maintain Automated Solutions:
Create and maintain scripts, applications, and workflows to automate tasks like data processing, document generation, report creation, and email management.
Improve Workflows:
Identify areas for automation and develop solutions to streamline processes, reduce manual effort, and improve efficiency.
Troubleshoot and Debug:
Identify and resolve issues with existing automation systems and applications.
Document Solutions:
Provide clear and concise documentation for automation scripts, configurations, and user guides.
Test and Validate:
Thoroughly test and validate automated solutions to ensure accuracy and reliability.
Collaborate with Teams:
Work with cross-functional teams to understand business needs and develop appropriate automation solutions.
Stay Current with Technology:
Keep abreast of the latest trends in office automation and scripting technologies.
Skills and Requirements:
Programming and Scripting Proficiency:
Familiarity with scripting languages like PowerShell, JavaScript, Python, and VBScript.
Knowledge of Office Applications:
Understanding of the Microsoft Office suite (Word, Excel, PowerPoint, Outlook) and other commonly used office tools.
Strong Problem-Solving Skills:
Ability to identify and resolve technical issues and challenges.
Analytical Skills:
Ability to analyze workflows and identify areas for automation.
Communication Skills:
Ability to communicate technical information clearly and concisely to both technical and non-technical audiences.
Attention to Detail:
Ability to ensure accuracy and completeness in automation solutions.
Example Duties:
Implement solutions that automate data entry into Child Support web-based applications.
Develop, test, and maintain automation applications and workflows.
Identify opportunities for improvement and automation.
Troubleshoot and resolve issues with existing internal applications and integrations.
Document system specifications, configurations, and user guides.
Collaborate with the leadership and IT team to ensure alignment with the organization's standards and best practices.
Advise on best practices for design and implementation.
Provide technical support and training to stakeholders.