James Hughes Email & Phone Number

Tampa, Florida, United States

Developed complex TSQL queries, views, and stored procedures to extract data from a read-only database into VTB's SQL data warehouse.Created and implemented Power BI and SSRS reports and dashboards using Visual Studio 2019 for Power BI Server, enabling data-driven decision-making for the organization.Provided management and administration of the CRM application, ensuring smooth operations and data integrity.Established and tracked deadlines by department for data entered into CRM on a monthly basis, ensuring timely and accurate data updates to be presented to Hillsborough County commissioners and stakeholders.Served as an internal CRM trainer, conducting training sessions for all onboarded employees and keeping them updated on the latest features and functionalities.Coordinated with leadership and all departments to understand and address business needs regarding CRM initiatives, ensuring alignment with organizational goals.Created technical documentation of report logic and business processes, facilitating knowledge sharing and ensuring efficient maintenance and troubleshooting.

Orlando, Florida, United States

Developed and implemented databases for in-house application development, ensuring efficient data storage and retrieval for optimal performance.Created and modified stored procedures to fulfill SSRS requests, enabling the generation of accurate and insightful reports.Designed and customized SSIS packages to seamlessly import data from various sources and export it to SQL, ensuring data integrity and efficiency in data integration processes.Configured SSIS package settings and server aliases, facilitating seamless deployment and maintenance across multiple servers.Managed the processing of statements, renewals, and invoices for all customers with a current balance, ensuring accurate and timely financial operations.Successfully addressed Tier 3 DBA duties by resolving Helpdesk tickets related to database administration tasks, ensuring minimal downtime and efficient database operations.Utilized advanced Transact-SQL queries, including Joins, Sub-Queries, Clustering, and Case statements, to retrieve and manipulate data, providing valuable insights for decision-making.Created and designed visually appealing reports using SQL Server Reporting Services (SSRS), presenting company data in a clear and concise manner on a daily basis.Developed workflow applications and implemented ETL processes using SQL Server Integration Services (SSIS), streamlining data workflows and ensuring data accuracy and consistency.Held administrative privileges for over 500 Massey databases on all servers, overseeing database management and ensuring data security and access control.Demonstrated expertise in database maintenance, including database creation, restoration, and backup processes on live and developmental servers.Successfully completed over 30,000 Helpdesk tickets within a 24-month period, consistently delivering prompt and effective solutions to technical challenges.

Longwood, Florida, United States

Managed and scheduled lawn production, successfully overseeing the scheduling of over $1 million worth of lawn services on a monthly basis.Efficiently routed and coordinated the activities of a team of 60 lawn technicians throughout Florida, ensuring optimal productivity and customer satisfaction.Generated accurate and comprehensive daily production reports for over 30 service centers, providing valuable insights into performance metrics and facilitating data-driven decision-making.Recognized as Renewal Coordinator of the Year in 2009 for outstanding performance.