Jonathan Head
Round Rock,TX
Summary
DEDICATED AND EXPERIENCED REPORTING CONSULTANT WELL-VERSED IN THE CREATION OF DATA COLLECTION TECHNIQUES AND GUIDELINES. WITH A PROVEN TRACK RECORD OF SUCCESSFULLY PROVIDING OUTSTANDING SERVICE FOR CLIENTS AND END USERS. SEEKING TO CONTRIBUTE MY SKILLS AND EXPERTISE TO DRIVE EFFICIENCY FOR CLIENTS.
Overview
10
10
years of professional experience
Work History
TECHNICAL CONSULTANT II
CASEWORTHY
WEST VALLEY CITY, UTAH
10.2021 - 02.2024
- Play a key role in understanding customer requirements and designing the data mappings, data models, and reporting needed to meet the project needs
- Led the implementation of technical projects, collaborating closely with cross-functional teams to ensure successful execution within budget and timeline constraints
- Consistently surpassed company billable goal standards by delivering exceptional performance and exceeding client expectations
- Ensure that requirements are aligned with business objectives and can be effectively translated into system solutions
- Take on project management responsibilities for complex projects, ensuring they are delivered on time and within budget
- Develop and maintain stored procedures, views, dashboards, reports, and automations
- Developed and maintained Microsoft Visual Studio reports, ensuring high performance and reliability
- Project proposals for clients
- Recommend changes for improvement of operational procedures and methods with an emphasis on data quality, automation, and efficiency
- Provide leadership and mentorship to junior analysts, guiding them in best practices and helping them develop their skills
- Managed large datasets through performance optimization, data scalability, and security awareness.
- Developed and implemented reporting procedures to ensure accuracy of data.
- Reviewed, updated, and maintained existing reports for accuracy.
- Provided coaching and guidance on report writing to team members.
- Created new reports as needed to meet business requirements.
- Involved in developing reports using SQL Server Reporting Services based on the requirements gathered from stakeholders.
SYSTEM ANALYST|INFORMATION SYSTEMS
ROUND ROCK INDEPENDENT SCHOOL DISTRICT
08.2018 - 10.2021
- Create and generate ad hoc reports relevant for shareholders
- Design and develop scalable and efficient solutions and reports to address business challenges
- Analyze business requirements and user needs to design and develop scalable and efficient IT solutions
- Facilitated hands-on workshops and demonstrations, providing step-by-step guidance and addressing questions and concerns to enhance understanding and proficiency
- Develop and maintain SQL queries, data transfers, ETLs, and reports
- Maintain, test, and oversee multiple database systems
- Develop and update documentation, user manuals, and training materials
- Collaborate with stakeholders to understand their needs and optimize the use of the system
- Propose enhancements and work with vendors or developers to implement improvements
- Provide ongoing support and maintenance for deployed systems, troubleshooting issues and implementing enhancements as needed
- Distill complex data insights into clear, concise, and visually appealing reports and presentations.
- Performed data analysis and wrote reports to identify trends in customer feedback.
- Executed testing strategies to improve systems, databases and processing techniques.
SYSTEM/PROGRAMMER|INFORMATION SYSTEMS
TAYLOR INDEPENDENT SCHOOL DISTRICT
08.2016 - 08.2018
- Provide training to end-users on new systems or features
- Developed scripts for automating daily jobs like backups, reindexing.
- Develop new documentation for district needs
- Investigate and resolve issues in a timely manner
- Develop, install, and maintain multiple software applications
- Conducted comprehensive training sessions for end users on newly implemented systems, ensuring smooth adoption and maximizing productivity
- Documenting data processing workflows, procedures, and decisions to facilitate collaboration, troubleshooting, and knowledge sharing within the team or organization
- Capability to generate both ad hoc reports to address immediate data inquiries and regular reports tailored for shareholders or executives
- Provided ongoing technical support and maintenance services to clients, troubleshooting issues and optimizing system performance as needed.
- Created and modified stored procedures using PL and SQL to support business processes.
- Implemented security protocols to protect sensitive data from unauthorized access.
- Resolved application issues related to system programming tasks.
- Designed and developed stored procedures, functions, views and triggers using T-SQL for efficient data transformation.
SOFTWARE CONSULTANT
PROLOGIC TECHNOLOGY SYSTEM
AUSTIN, TX
04.2014 - 08.2016
- Identify root causes of problems and implement preventive measures
- Work closely with cross-functional teams, including developers, testers, and business analysts, to ensure a cohesive and integrated solution
- Collaborated with clients' internal teams and external vendors to implement and integrate new systems and technologies
- Develop and execute test plans to ensure the quality and reliability of systems
- Provided ongoing support and maintenance services to clients, including system updates, enhancements, and troubleshooting, to ensure optimal performance and user satisfaction
- Created test plans, test cases, and test scripts based on software requirements and design specifications
- Analyzed clients' technical requirements and business objectives to develop customized solutions that aligned with their strategic goals
- Developed and delivered customized training programs and workshops for clients' end users, covering system functionality, best practices, and troubleshooting techniques.
Education
Bachelor of Arts - Consumer Affairs
Texas State University
San Marcos, TX12-2009
Skills
- Mentorship And Coaching
- Project Budget Allocation
- Client Needs Assessment
- Customer Success Management
- Troubleshooting And Diagnosis
- Functional Requirements Understanding
- Database Programming and SQL
- Task Prioritization
- System programming
- Relational databases
- Data Integrity
- Dashboard creation
- Business Intelligence
- Microsoft Excel
- Report Development
- Machine Learning
- Data Analysis
- Dashboard creation and management
- Project Management
- Strong analytical skills
- Report Preparation
- Data Mapping
- Data Validation
- Data Modeling
- Statistical Analysis
- Clear And Concise Communication
- Reporting Tools
- Agile Methodology
- Microsoft Office Proficiency
- Software-As-A-Service Development
- Software Development Life Cycle (Sdlc)
Accomplishments
- TRAINING CERTIFICATE FOR MICROSOFT TRANSACT-SQL PROGRAMMING
- IBM COGNOS ANALYTICS TRAINING
- THE KNOWLEDGE ACADEMY - SSRS MASTER COURSE CLASS
Job Skills
- HIGH LEVEL PROBLEM SOLVER
- EXCEPTIONAL RELATIONSHIP WITH CLIENT
- EXTENSIVE YEARS OF SAAS TRAINING
- STRONG ORGANIZATIONAL, COMMUNICATION AND INTERPERSONAL SKILLS
- SELF -DRIVEN
- KNOWLEDGE OF HTML AND WORDPRESS
- EXTENSIVE KNOWLEDGE(OVER 10 YEARS) WITH MICROSOFT SQL SERVER AND MICROSOFT PRODUCTS
- COGNOS AND MICROSOFT VISUAL STUDIOS REPORT WRITING SKILLS
- KNOWLEDGE OF SSIS AND SSAS
- POWER BI KNOWLEDGE
- KNOWLEDGE OF XML, GITHUB, AND SFTP/FTP SETUP
- KNOWLEDGE OF WINDOW REMOTE MANAGEMENT TOOL
- WORKING KNOWLEDGE OF CSV,XML, AND JSON
- SDLC AND PMLC KNOWLEDGE
- KNOWLEDGE OF JAVASCRIPT
Affiliations
- IT MANAGER - SUMMIT WORSHIP CENTER
Timeline
TECHNICAL CONSULTANT II
CASEWORTHY
10.2021 - 02.2024
SYSTEM ANALYST|INFORMATION SYSTEMS
ROUND ROCK INDEPENDENT SCHOOL DISTRICT
08.2018 - 10.2021
SYSTEM/PROGRAMMER|INFORMATION SYSTEMS
TAYLOR INDEPENDENT SCHOOL DISTRICT
08.2016 - 08.2018
SOFTWARE CONSULTANT
PROLOGIC TECHNOLOGY SYSTEM
04.2014 - 08.2016
Bachelor of Arts - Consumer Affairs
Texas State University