I provided home solar advisory and analysis services in over 30 US states, but specialize in helping neighbors in my home state of New York.

- Maintained backend components that include database development, schema design, query writing, and multiple virtual servers- Structured user access control for enterprise systems- Automated system tasks using SQL, CMD / Powershell, and Python- Refactored or replaced legacy PERL, SQL, and other batch scripts as needed- Analyzed internal programs and procedures to guide policy creation and systems architecture- Created SAP crystal reports for business intelligence and built custom reconciliation processes and dashboards into Excel using SQL, VBA, and Python- Designed and implemented basic ticketing, knowledge base, and project management systems with integrations to existing enterprise software using Podio- Developed web applications inside of vendor provided CRM using PHP, HTML, CSS, Javascript, SQL, and APIs- Redesigned existing SMARTY MVC view layers to render better UI following HIG and WCAG using web developer tools and Google Chrome’s Lighthouse to verify performance and accessibility- Deployed and enhanced vendor provided mobile app - Documented all programs, policies, and procedures- Drafted and published training materials, providing onboarding support for new administrative users- Gathered application requirements by organizing business process owners and other stakeholders- Supervised, trained, and mentored subordinate systems administrators, staff associates, and student staff- Generated specifications for backend developers to produce required data sources and third-party integrations- Conducted analysis for enterprise applications and guided directors to correctly scope vendor quotes - Managed projects for systems implementations and upgrades, coordinating vendors, internal IT software, hardware, and networking teams, and business managers- Tested, troubleshot, debugged, audited and provided 24/7 on call support for systems- Provided data analysis and ad hoc reporting for application users and summarized findings for executives

• Created a Foxpro database interface using PHP and ODBC to meet customers' custom reporting requirements not met by default system.• Coordinated sales personnel, customers, third party vendors, contractors, and other technicians to ensure timely project completion.• Prepared, installed, and troubleshot networking equipment, Windows computers, and other system hardware.• Programmed database and edited user interfaces per customer needs.• Provided continued customer support through 24/7 phone support and onsite service. Logged calls into help desk software and paper work orders.• Authored documentation for technicians and customers on system setup, use, and frequently asked questions.• Setup new demo systems to drive sales of handheld POS systems using iOS, Android, and Windows Mobile.

• Troubleshot and maintained IT assets and infrastructure• Coordinated library book sales and managed senior outreach program• Compiled records, sorted and shelved books, issued and received library materials, greeted library patrons, and answered the phone

• Drafted, organized, and executed campaign projects from concept to finish.• Managed social networking outreach, trained volunteers, and designed database and reports.

• Planned, budgeted, and marketed award winning community programs that stimulated the social, emotional, and educational growth of residents.• Worked in teams to assist Resident Directors in the management of the dormitory by writing regular reports, confronting incidents, and upholding the university's Community Rights and Responsibilities.

• Designed and published the club's websites and forum using HTML, CSS, and PHP.• Researched, contacted, and managed relationships with sponsors, vendors, and partners.• Successfully grew club's convention attendance by over 60% through social networking.

• Built and supported a test server running the Linux Apache MySQL PHP suite ofsoftware.• Developed basic modules inside a collaborative support system and documented the process into the company's knowledge support system.

Fun job scaring the daylights out of people.