Resume (Hire Me)

Scott David Keefe Sr. 📍 [Wewahitchka, FL] | 📧 [scott.keefe@scottkeefe.com] | 📞 [Email Phn Request] | 🔗 [GitHub] ⛪[www.scottkeefe.com]

PROFESSIONAL SUMMARY
Dynamic and versatile professional with over 30 years of experience in full-stack software development, database architecture, systems maintenance, sales, and team leadership. A passionate technologist who began hacking games and ROM-level systems at age 13, I’ve evolved into a skilled programmer, data architect, and problem-solver with expertise in modern ML/AI solutions, cloud computing, and legacy technologies. Adept at driving sales through customer engagement, optimizing business operations, and leading teams to success. Whether architecting scalable systems, troubleshooting microcontrollers like Raspberry Pi, or enhancing retail workflows, I thrive on delivering innovative solutions and fostering collaboration across technical and non-technical environments.Key Skills

  • ✔ Software & Systems Development: Full-stack development (Python, Java, .NET, VB, C), web applications, microcontroller programming (Raspberry Pi, Arduino)
  • ✔ Database & Data Architecture: SQL, MS SQL Server, MySQL, MariaDB, PostgreSQL, U2 Universe; relational/hierarchical data modeling, report generation
  • ✔ Machine Learning & AI: OpenAI API, Hugging Face, Prophet, LLM prompt engineering, predictive analytics
  • ✔ Cloud & Infrastructure: AWS (EC2, RDS, IAM, Lambda, CodePipeline; Certified Developer, expired July 2024, renewable upon request), Linux administration, server configuration
  • ✔ Sales & Customer Service: Product promotion, upselling, customer education, inventory management, merchandising
  • ✔ Management & Leadership: Team coordination, staff training, project oversight, process automation, workflow optimization
  • ✔ Service & Maintenance: Installation, troubleshooting, and repair of electronic systems; hardware diagnostics, firmware updates
  • ✔ Business Operations: ERP systems (Epicor Eclipse), CRM integration, business reporting (SSRS, Phocas, Pandas), cost update systems
  • ✔ Soft Skills: Translating technical concepts for non-technical stakeholders, collaborative problem-solving, continuous learning

Work Experience Jamestown Distributors
Technical Systems Specialist / Database Programmer / Retail Operations Lead
Bristol, RI | November 2010 – January 2025

  • Designed and maintained scalable database systems and data pipelines, creating nearly 100 SQL reports to support retail sales, inventory, and CRM/ERP operations.
  • Developed Python-based tools and SSRS/Phocas reports for business analytics, automating data workflows and enabling data-driven decision-making.
  • Programmed microcontrollers (e.g., Raspberry Pi) to automate inventory tracking and system monitoring, reducing operational errors by 20%.
  • Led sales and customer service initiatives, driving revenue through upselling, product education, and tailored customer interactions in a high-volume retail environment.
  • Supported marketing efforts by designing product displays and contributing to promotional campaigns based on customer feedback and sales trends.
  • Trained and mentored staff on system usage and retail processes, fostering a collaborative team environment and reducing service tickets by 15%.
  • Maintained and troubleshot electronic systems (e.g., POS, ERP hardware), ensuring 99% uptime and seamless operations.
  • Architected a cost update system using vendor cost sheets and early ML matching algorithms, managing product price updates across multiple channels.

Paratek Pharmaceuticals
Chemical & Biological Database Administrator / Software Developer
Boston, MA | 2001 – 2009

  • Migrated file-based scientific workflows to custom MDLI and Oracle databases, designing systems to support research and operational efficiency.
  • Developed a J++ web application with a custom GUI, merging chemical and biological data to streamline scientist workflows.
  • Provided technical support and training, simplifying complex systems for non-technical users and improving productivity.
  • Automated data imports from analytical devices to a central Oracle database, ensuring data accuracy and accessibility for reporting.

Polaroid Corporation
Analytical Chemical Specialist / Quality Assurance Inspector
Norwood, MA | 1992 – 2001

  • Advanced from temporary line worker (1989) to full-time Quality Assurance Inspector (1992), conducting analytical testing (HPLC, AA, Near IR) to ensure production quality.
  • Troubleshot and maintained production equipment, implementing process optimizations to enhance manufacturing standards.
  • Documented procedures and trained staff on equipment use, supporting operational efficiency and compliance.
  • Leveraged data analysis to identify performance trends, contributing to proactive maintenance and quality improvements.

Education & Certifications
Associate of Arts in Information Technology
University of Massachusetts / University of Phoenix
AWS Certified Developer
*(Expired July 2024; available for renewal upon request Key Projects & Technologies)

  • Microcontroller Automation: Programmed Raspberry Pi systems for inventory tracking and system monitoring at Jamestown Distributors, enhancing operational efficiency.
  • AI & Machine Learning: Trained ML models using OpenAI API and Hugging Face for predictive analytics and time-series forecasting with Prophet.
  • Database Architecture: Designed relational and hierarchical databases for retail, scientific, and manufacturing applications, optimizing data pipelines and reporting.
  • Cost Update System: Built an ML-driven cost update system for Jamestown Distributors, streamlining product pricing across sales channels.
  • Web Development: Created user-friendly web applications (e.g., J++ GUI at Paratek, Python-based wrappers at Jamestown) to simplify data access for non-technical users.
  • Cloud Solutions: Implemented AWS-based serverless solutions (EC2, RDS, Lambda) and Linux server configurations for high-performance applications.

Additional Information

  • Passionate about fitness, nutrition, and continuous learning, maintaining a healthy and productive lifestyle.
  • Lifelong technologist, hacking games and ROM-level systems since age 13, with a deep-rooted love for programming and data architecture.
  • Collaborative, detail-oriented, and adept at leading teams, troubleshooting systems, or engaging customers in fast-paced environments.
  • Language- and paradigm-agnostic programmer, comfortable with procedural, functional, and object-oriented approaches.