Drew Cook Email & Phone Number

Lewisburg, Ohio, United States

Columbus, Ohio, United States

- CI/CD ImplementationTools Used: Azure DevOps, Azure Cloud ServicesOutcome: Reduced deployment times, enhanced security with permission based controls.- Data MigrationTools Used: Azure Cloud ServicesOutcome: Developed pipelines to interface with external data sources, centralizing data and automating daily updates.- Database OptimizationTools Used: Microsoft Fabric, SSAS, SSIS, SSMS, Python, SQLOutcome: Reduced database costs by approximately $33,000 annually through the elimination of legacy workflows and optimized data retrieval.- Advanced AnalyticsTools Used: Power BI, Azure Synapse Analytics, PySparkOutcome: Leveraged Microsoft Fabric and PySpark to uncover patterns and insights, visualizing findings in Power BI to drive business decisions.

Ohio, United States

Cloud-Based Energy Data Capture – Yellow Springs Solar - Yellow Springs, OH 45387Architected and implemented a cloud-based energy monitoring solution using Dent Instruments to capture energy readings from a building and automate tenant invoicing based on consumption.This system saved the company 20 hours of manual labor per month and digitized historical data, enhancing auditing capabilities and supporting business analysis.Invoice Management CRM - D&D Computers - Huber Heights, OH 45424Developed a comprehensive customer management program that securely stores invoices, personal information, and signatures.

- Team Leadership and CoordinationTools Used: Leadership Skills, Team Collaboration, MentoringOutcome: Led a cross-functional software development team; mentored junior developers, enhancing team performance and cohesion.- Primary Point of ContactTools Used: Communication SkillsOutcome: Served as the main liaison between the development team, pre-sales, and clients. Improving client satisfaction heading off issues upstream.- Business and Technical AlignmentTools Used: Requirement Analysis, Stakeholder ManagementOutcome: Collaborated with presales and business teams to translate client requirements into technical specifications, ensuring the team delivered solutions aligned with client needs.- Demo Quality Assurance Tools Used: Manual VerificationOutcome: Led detailed manual efforts to test demo functionality and performance, reducing software defects and ensuring high-quality deliverables that boosted client trust.- Technical Guidance and Issue ResolutionTools Used: Java, Apache Tomcat, Debugging ToolsOutcome: Guided the team in debugging Java applications and resolving server issues, improving system reliability and maintaining project timelines.- API Development LeadershipTools Used: Java, RESTful APIsOutcome: Oversaw the implementation and management of RESTful APIs, enhancing communication between software modules.Overall Achievement: These combined efforts contributed to securing substantial contracts with major clients, driving significant business growth.

Dayton, Ohio, United States

- Feature DevelopmentTools Used: Java, TypeScriptOutcome: Enhanced application functionality and user experience by designing and implementing new features.- API Development and IntegrationTools Used: RESTful APIs, Java, TypeScriptOutcome: Improved client-server communication efficiency through the development and integration of RESTful APIs.- Front-End Web DevelopmentTools Used: Angular, ReactOutcome: Increased application usability by creating dynamic and responsive user interfaces.- Database Management and OptimizationTools Used: SQL Server, MongoDBOutcome: Ensured data integrity and optimized performance by managing and fine-tuning databases.- Version Control and Team CollaborationTools Used: SVN (Apache Subversion)Outcome: Maintained code quality and consistency by employing version control and collaborating effectively with team members.- Technical DocumentationTools Used: Documentation Tools, Technical WritingOutcome: Facilitated knowledge transfer within the team by creating comprehensive technical documentation for new features and processes, annotating API REST endpoints with JavaBeans.