Speedometer Programmer-Kilometer to miles (Flint)

I run a software company that develops software for an open-source project called OpenEMR, an application that runs medical clinics, hospitals, and other medical organizations. I am looking for a part-time 20 hours per month junior developer to assist me and my company with completing tasks for OpenEMR. As time progresses this has the ability to turn into more hours. You would be a 1099 contractor for my company. More info about the project (this is the project you will be working on): https://www.open-emr.org/ Before the interview I need you to read the following document. In your cover letter please be able to demonstrate as much as possible what is contained in this document. You probably won't get 100% but please give it a solid try. Requirements for OpenEMR Development This document defines the minimum skills and tasks you must demonstrate to be considered ready for OpenEMR development. Review carefully and be prepared to show working examples for the interview. Core Competencies Using Git and standard source control workflows Understanding the OpenEMR database schema at a basic level Setting up multiple virtual hosts using LAMP (preferred), WAMP, or MAMP Configuring and troubleshooting Apache Virtual Host Setup Task Demonstrate your ability to set up a local sandbox by: Creating a new Apache virtual host Installing the latest community version of OpenEMR (use the most recent patch release) Cloning the OpenEMR GitHub repository outside of any vhost folder. (basically, not storing the git repo in the /var/www/ directory, but using an rsync script to update the vhost ) Setting up local instances for both: Master branch and most current stable patch release At minimum: Run OpenEMR v703v4 on a dedicated vhost Git and Source Control Best practices for managing a project with Git Why repositories must not be stored directly on Staging or Production vhosts What cherry-picking is and why it is useful How git reflog can help find a file’s history Xdebug Task Place a breakpoint in login.php at the line that includes globals.inc.php Step over into the next line and explain why globals.inc.php is critical Identify a variable or function from globals.inc.php that is used in login.php OpenEMR Schema Explain the purpose and stored data of these tables: patient_data form_encounter forms users users_secure list_options layout_options Write a query to return: patient first name, last name, PID, encounter number, and forms used in encounters within a specific date or date range Write a query to return: PID and encounter ids for a date range Identify which table/column records when a form has been deleted Identify the view in the OpenEMR interface that updates the list_options table Identify the view in the OpenEMR interface that updates the layout_options table Make a change using the OpenEMR interface and demonstrate the change in the raw data (phpMyAdmin view) Explain how layout_options and list_options are related to creating or updating layout based forms

MS2 is a national leader in transportation data management and analysis and has the largest traffic count database in North America. More than 270 agencies in 31 US States, and 3 Canadian Provinces, including 28 state Departments of Transportation, are using MS2 software to manage their transportation data. MS2 is located in the beautiful city of Ann Arbor, Michigan, the home of high-tech industries and the University of Michigan. Residents of the city enjoy beautiful parks, mature neighborhoods, amenities of the Huron River (a state-designated Natural River) and easy access to downtown Detroit or to colorful “Pure Michigan” woods and waterways. MS2 is a friendly, open, team working to support our clients' software needs. Employees work on a variety of tasks and are given a high degree of responsibility. We offer an excellent environment for transportation professionals. MS2 offers a competitive compensation and benefit package. We're building the next generation of Transportation Data Management Systems and we need your help! We're a small team and you'll have an opportunity to make a big impact. Position Description MS2 is looking for a Software Project Manager to manage the development of innovative software and data analytics for transportation planning and traffic engineering. An MS2 Software Project Manager will be responsible for concurrent projects and is expected to actively work with our clients. The position is open to professionals with software project management experience. Candidate must possess excellent verbal and written communication skills and be able to relate to clients and staff in a professional, thoughtful, and pleasant manner. Candidate must be able to effectively and professionally represent MS2 at meetings or other public forums. Being an active member of a professional organization is a plus. Candidate must be flexible to do assignments as necessary. This is a full-time position. Occasional, overnight travel is required (estimated at 1-2 times per year). Responsibilities: Project Management (approximately 60%) Manages assigned IT projects to ensure adherence to budget, schedule and scope of project. Be the main interface to MS2’s software engineers, the clients and internal leadership and be responsible for software project deliverables Build project schedules, and provide ongoing project plan/status reporting for weekly staff meetings Make decisions and communicate trade‐offs and risks; drive key decisions across projects Prepare documentation such as requirements and user manuals Drive collaboration across teams and advance project goals Carefully track project deadlines and work closely with MS2 development to meet timelines Contribute to improvement and ongoing refinement of software development lifecycle processes Contribute to technical and cost proposals Coordinate tasks, milestones and availability of project resources Facilitate discussions with both client and internal users and document specifications. Effectively communicate to MS2 development client requests, ideas for new software modules or ideas for user interface improvement Perform quality assurance for system enhancements. Frequent communication with clients Subject Matter Expert (approximately 30%) Conduct methodology research to help guide new software features or solutions Develop solution technical concepts based on an understanding of the data management needs of our clients Business Development (approximately 10%) Work with Business Development Manager to grow MS2 in new market areas. Attend professional conferences as directed to represent MS2. Cross‐sell other MS2 products and services to existing clients Requirements Associate’s or Bachelor’s degree in Engineering, Information Systems, or related field 3 or more years experience as a Project Manager, or similar role Highly proficient in Microsoft Word, Excel, PowerPoint & Project Excellent writing skills, as well as outstanding proofreading skills Excellent attention to detail – gets it right the first time Experience with the full software development life cycle (SDLC) Well organized self-starter with strong project management skills who can independently move projects forward, prioritize tasks, and meet deadlines Preferred: Project Management Professional (PMP) certification Membership in related professional organizaion(s) Previous experience with Software-as-a-Service (SaaS) model Previous experience in transportation planning or traffic engineering Benefits We offer a competitive salary and benefits package. We promote a strong work/life balance at MS2. We encourage our employees to pursue their professional interests and take ownership of projects from start to finish. You’ll be working with big data and cloud-based solutions using the latest technologies as part of a fun and energetic team. We get along so well, we even have regular nights out and company sponsored dinners to celebrate our successes! It’s a great place to work. Salary: $70,000-$115,000, to be determined based on the candidate’s individual skills and experience. Benefits: Participation in the MS2 annual bonus program 401(k) w matching Dental insurance Employee assistance program Flexible schedule Flexible spending account Health insurance Life insurance Paid time off Professional development assistance Referral program Disability insurance Vision insurance We Want You to Be You at MS2: At MS2 a diverse, inclusive, and equitable workplace is one where all employees, whatever their race, gender, color, ethnicity, national origin, age, sexual orientation or identity, education, disability, religion, or veteran status, feel valued and respected. We are committed to a nondiscriminatory approach and provide equal opportunity for employment and advancement in all of our departments and programs. We respect and value diverse life experiences and heritages and ensure that all voices are valued and heard. MS2 is committed to maintaining a welcoming environment with equitable treatment for all, and we strive to: Provide a working environment where all employees feel safe, comfortable, and valued. See diversity, inclusion, and equity as connected to our mission and critical to ensure the well-being of our staff and the agencies we serve. Examine and dismantle any inequities within our policies, systems, programs, and services, and continually update and report our progress to our employees. Explore potential underlying, unquestioned assumptions that interfere with inclusiveness. Encourage company-wide thinking about how systemic inequities impact our organization’s work, and how best to address that in a way that is consistent with our mission. Help to challenge assumptions about what it takes to be a strong leader at our organization, and who is well-positioned to provide leadership. Practice and encourage respectful and transparent communication in all interactions. Commit time and resources to expand more diverse leadership at all levels of our organization. Lead with respect and tolerance. We expect all employees to embrace this notion and to express it in workplace interactions and through everyday practices. MS2 wants every employee to feel our commitment to showing respect for everyone, and we encourage open communication that enables each person to be their best self. MS2 is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. Hybrid Work We require you to work in the office generally at least one day per week. This is not a fully remote position, but we may provide relocation assistance to successful candidates.

We are developing next-generation AI platforms that fuse finance and learning — built to deliver real execution and measurable results for businesses and professionals. We’re seeking visionary technical builders to join as Co-Founders / Founding Engineers at the pre-launch stage. This is not a traditional job — it’s an opportunity to shape a first-of-its-kind startup from the ground up. We’re especially interested in entrepreneurial talent with expertise in: • AI/ML Engineering • Full-Stack Development • Cloud Architecture • UI/UX Design Compensation: Equity-based founding role (with flexibility to discuss minimal salary support if needed). To apply: Please reply with a short note on your background, your key technical skills (e.g., AI/ML, full-stack, cloud, UX/UI), and attach your resume/CV. Selected applicants will then receive more details, including company information and a formal application link.

Position Title:  Space Sensitive Activities Technician, Journeyman Company: ACT1 Federal Location: Colorado Springs, CO About ACT1: Delivering mission-critical solutions and industry-leading talent to advance the missions of the partners, organizations, and communities we serve. ACT1 Federal is seeking a Journeyman Space Sensitive Activities Technician. This program provides support to the United States Space Force (USSF), Space Operations Command S33X, Sensitive Activities Division office/staff. Generally, you will provide the client with identity and signature management (ISM) augmentation to the government staff in the execution of the command sensitive activities support program. The client anticipates a high level of knowledge on the full breadth of ISM supporting worldwide operations. Responsibilities: Providing direct support to Command sensitive activity stakeholders throughout the operational lifecycle, to include mission analysis, planning, development, staffing, implementation, and termination. Identifying mission critical vulnerabilities, assess risk to mission, and provide mitigation strategies to decision makers. Understanding and applying DoD policy requirements for sensitive activities and apply to operations, training and force development. Applying identity management protocols to assess risk to personnel and missions and provide mitigation strategies to decision makers. Maintaining currency on key technologies and capabilities, to include ubiquitous technical surveillance, that impact Space Force missions. Developing and maintaining familiarity working within the Joint Community (processes, structure, C2, etc.). Conducting risk analysis to inform Combatant Command leadership decisions. Conducting open-source research, as directed by the client, in preparation for mission analysis and threat assessments. Reporting significant events/incidents. **Physical Demands: Travel may be required** Requirements Active TS/SCI clearance with ability to be SAP cleared. BA/BS degree or additional experience. FOSS or equivalent (Advanced Technician Course or Advanced Planners Course, and Due Diligence Course) Minimum of three (3) years of DoD sensitive activities experience. Minimum of five (5) years overall DoD experience. Preferred: FOSS and PAC or equivalent (Advanced Technician Course, Advanced Planners Course, and Due Diligence Course). MA/MS Degree. Ten (10) years overall DoD experience. Benefits Medical/Dental/Vision Insurance  ACT1 Employee Stock Ownership Plan (ESOP)  Company Paid Life and AD&D Insurance  Company Paid Short-Term Disability   Voluntary Long-Term Disability  Flexible Spending Accounts (FSA)  Health Savings Account (HSA)  401K with employer match  Paid Time Off   Paid Holidays  Parental Leave  Military Leave  Education, Training & Professional Development  Voluntary Accidental Injury/Critical Illness/Hospital Care  Voluntary Pet Insurance, Legal Resources, and Identity Protection   Salaries are commensurate with experience and qualifications, as well as market and business considerations.  Colorado Pay Transparency Range: $110,000-$117,000 All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran or any other status protected by applicable federal, state, local, or international law.

Position Summary: Provide technical design, consultation, information and assistance to internal and external customers under direct supervision to insure that project complies with all engineering standards. The designer will work under the supervision of more senior engineers. Work will be completed in concert with the stated project requirements, all current codes, as well as Prime Electric Engineering Standards. Applicant will be responsible for designing, developing and producing permit and construction documents for electrical systems. Essential Job Functions: • Power Distribution, Signal and Lighting Design • Single line Diagrams and Panel Schedules • Lighting Fixture Selection and Schedules • Lighting Control Diagrams • Title 24 Compliance Calculations • Review shop drawings and specifications • Review, comment and process equipment and system submittals • Visit job sites for field investigations • Voltage drop, load and demand calculations • Coordination with other construction trades and disciplines • Back check of own work for accuracy and completeness before submission to others • Perform coordination between architectural, structural, mechanical, plumbing, process and all electrical trades • Coordinate work with the project specifications or equipment buy-out • Attend project design team meetings. Interface with various team members, particularly the client, architect, and mechanical contractor/engineer • Research and resolve drawing interpretation problems, conflicts, interferences, and errors • Perform other duties assigned by Director of Engineering Minimum Job Requirements: • Bachelor of Science degree in electrical engineering a plus • Minimum 2-Years of experience in electrical systems design a plus • Proficient in AutoCAD, MS Word & Excel • Experience with Revit & Navis Manage a plus • Reasonable knowledge of the NEC as well as building codes and ordinances • Broad knowledge and experience with power and lighting design • Understanding of sustainable design and LEED Documentation a plus • Documents and archives work pursuant the Prime Electric standards

Company Profile      At Sand Cherry Associates, we excel in the design and delivery of strategic customer-centric initiatives through digitally native, data-empowered solutions.  Our client’s confidence in us is centered on exceptionally skilled, high-energy talent working with the support of the full Sand Cherry team.  Finding the right match for this role is a critical aspect of continuing that success.       Overview   We are looking for an experienced Product Manager. This role is responsible for leading project lifecycle and product development and deployment initiatives for an IP Video product for an enterprise organization. This involves product planning, drafting and refining product requirements, competitive research and analysis, and all product operations through deployment. This position is hybrid and qualified candidate will work on-site in either Philadelphia PA, or Denver, CO a few days a week and other days remote. Candidates must live in either the Philadelphia metro area or the Denver metro area and be willing to go on-site each week some days.     Duties & Responsibilities  Manage products and services utilizing product and/or project management principles, strategy and execution  Understand the current GTM approach and how to engage with stakeholders as necessary for product release solutions  Proven ability to work in large, enterprise organization and communicate effectively with stakeholders  Manage key documentation deliverables such as inputs, outputs, GTM materials   Enhance product management tools, documentation, and reporting  Create and maintain product related information and communication  Create and maintain process workflow documentation to support business needs  Consistently exercise informed judgment and discretion in matters of significance  Direct cross functional teams, such as engineering or development, regarding product requirements  Act instrumentally in connecting Agile and non Agile teams to support product efforts   Requirements Desired Skills and Experience  Minimum 7 years direct product planning, product operations and product management experience  Experience in telecommunications/broadband, data service networks, or contact center environments preferred  Experience working with IP video is required Experience in an Agile or Scaled Agile environment is necessary  Experience with project or program management is necessary Knowledge and understanding of products in a technical capacity, understanding their requirements and related business needs  Experience aligning multiple business groups in a cross-functional, matrixed environment  Ability to drive and lead stakeholder meetings and manage deliverables from development and engineering  Excellent communication skills, utilizing a formal system for communications, reporting intake status, and collaborating with other internal groups  Ability to ramp up on new projects quickly and work autonomously, while actively keeping project team and client informed of milestones and potential issues    Qualifications/Technical Skill Requirements  Excellent knowledge of MS Office Suite products, especially Excel and PowerPoint for tracking, reporting, and executing slide presentations  Experience with MS Project and JIRA are helpful  Experience with broadband technology product solutions/offerings is preferred  Familiarity working with cross functional teams- IT, product development, engineering, and marketing is necessary  Experience managing numerous product lines and providing updates and insights to stakeholders at a variety of levels in a large enterprise organization    Education/Certifications  Bachelor’s degree in Business or other quantitative field  PMP certification is helpful or project management methodology courses  Consulting background is helpful but not required  Compensation For individuals assigned and/or hired to work in Colorado, Sand Cherry Associates is required by law to include a reasonable estimate of the compensation range for this role. This compensation range considers a wide range of factors considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and delivery model. This is a 6 - 12 month engagement with an annualized salary of $120,000 - $150,000. Years of experience, level of education, geographic location, unique skills/qualifications for the specific role and potential certifications can be key factors in the final compensation for this role. Benefits Our team is unique — we are passionate about what we do. At Sand Cherry, our consultants know they are impacting and shaping our clients’ industries. We recognize our employees for their contributions. Our culture is one of the most friendly and communicative in the consulting industry. Sand Cherry is not a top-heavy organization. We offer the opportunity to be part of a digital workforce. Discover the experience that only comes with self-responsibility in the workplace. Our team members manage their own workloads and are expected to deliver exceptional work for our clients. Professional career growth is one of our main priorities, as we affirm that investing in our consultants and empowering our people will also deliver the best results and value for our clients.