Patrick Speer Email & Phone Number

Cottage Grove, Mn, Us

• Wrote and enforced new policies for best practice in SQL, C#, and Powershell.• Gathered requirements to determine business need, objectives, and generated small and large scoping documents for client approval.• Participated in planning activities with peers by contributing my knowledge, seeking clarity on business requirements.• Participated in retro by blamelessly identifying issues from the previous sprint and provided potential resolutions.• Participated and advised on impact and possible risks on bi-weekly release meetings.• Reviewed code written by any developer, regardless of team, in my own areas of expertise.• Used my own code reviews to better understand coding standards and quality, treating them as a tool for learning.• Maintained effective communication to keep clients up to date and notified of timelines and needs so their expectations are updated as the project evolved.• Coded in SQL, Powershell, jQuery, Html, C# and tested thoroughly to ensure they met business requirements.• Wrote testing documentation for each product for outside review and testing.• Coordinated with the Management and Lead Software Developer regarding the status of their work, ensuring that it meets their expectations.• Led paired programming sessions to coach and improve team skills.• Acted as a Business Analyst for large projects, managed delegation of tasks, and noted full project scope for other team involvement.• Participated and led Agile (SCRUM) meetings, providing details about progress and actively identifying blockers and impediments. Volunteering often to assist others where appropriate.• Manipulated, analyzed, and interpreted complex datasets using SQL.• Designed and created data reports using SQL Server Reporting Services (SSRS).• Developed table design for database normalization and data collection.

Eagan Mn

• Led and organized interdepartmental projects to improve efficiency.• Wrote Advanced T-SQL queries, generated hundreds of stored procedures, triggers, and functions to accomplish complex tasks and to improve efficiency of the team.• Tested and wrote API endpoints to ensure requested deliverables.• Submitted hundreds of improvement suggestions on existing code.• Participated and led multiple sub-committees regarding projects for the culture committee.• Managed client expectations with timelines and technical updates.• Develop and maintain updates to existing knowledge articles both client facing and internally.• Troubleshot advanced issues escalated by Support Analyst role.• Produced and discussed multiple company culture meeting ideas and concepts.• Kept department updated on meeting progress as well as took feedback in a non-managerial role from team members.• Build and maintain positive relationships with top 20 clients for retention and client satisfaction.

Eagan, Mn

• Communicated professionally and effectively with customers at all levels. Explain technical details in a plain, clear, and simple manner.• Wrote basic SQL queries to find or extract data.• Managed personal queue of tickets and provide status updates to clients.• Troubleshot and analyzed incoming customer calls related to both enterprise and hosted software solutions, utilizing Microsoft SQL Server Management Studio and SQL Server Profiler.• Analyzed and tested software to determine the type of problems the customer is encountering which could include software bugs, client set up, corrupted data, user error, etc.• Assisted in the development of online FAQs and knowledge base.• Created and maintained positive customer relationships.• Continued learning and understanding of all aspects of the TempWorks products, including the core enterprise system, Web Center, and other ancillary product lines.• Reported all billable hours and expenses.

• Wrote, proofread, and edited technical training content in all delivery media for consistency, style, manner of presentation, and format.• Created and incorporated graphics, photographs, drawings, sketches, diagrams, and charts for use in technical training, instructional, and reference materials.• Generated high quality technical training, instructional, and reference materials for publication.• Interfaced with operations, technology, and product management to create new or update existing documentation.• Trained customers and employees via webinar, on-site, and classroom style training.• Built and administered certification exams to clients and employees.• Provided insight into deep dive technical issues to assist in high level troubleshooting.• Tailored software and hardware configurations based on client needs.• Responsible for go-live support of new client when delivering on-site training.• Led a technical team responsible for proactive case management and improved efficiency.• Interfaced with operations, technology, and product management teams to facilitate testing and process improvement.

Eden Prairie

• Provided in depth support to technicians on multiple hardware and software technologies.• Supported, organized, and deployed technicians throughout the continental US and abroad.• Reviewed, evaluated, designed and implemented over 30 new policies and SOPs to significantly increase department efficiency. • Led performance reviews for lower level technicians and provided in-depth feedback.• Worked closely with owners and high level customers to ensure satisfaction of services on daily projects as part of an escalation team.• Supported over 7000 software and hardware endpoints spanning 6 countries.• Identified and corrected problems based on performance requirements of new software via live testing and monitoring of test locations.• Created and documented customer facing operating procedures for multiple solutions.• Led weekly inter-departmental meetings and served as a point of contact for the product development, creative services, and client support teams.• Created a training program to identify and correct common vendor-specific hardware failure points.• Reconfigured existing systems to accommodate additional components.• Troubleshot computer and peripheral hardware and software operational issues.

Eden Prairie

• Provided phone and remote support for 4000 software and hardware endpoints.• Addressed help tickets and resolved issues in a quick and professional manner.• Prepared office computers with remote software and confirmed hardware connectivity.• Managed escalation of help tickets with relevant data for issue resolution.

Apple Valley

• Managed training of new hires and cross-training of existing employees into new positions.• Provided a leadership role between the managers and team members to ensure facile communication and co-operation between team members.• Responsible for monitoring team members throughout shifts to uphold Red Robin standards and to ensure customer satisfaction and repeat patronage.

Network Management With Cisco Ios, 3.0

Ged