See How Many Clients You're Missing Each Month

Simply enter your business email & Topline AI Agent will show you.

Bio

Generated by
Topline AI
Rob Hilliard is a seasoned software developer with 20+ years of experience in full-stack web development, database administration, and project management. He has worked with various technologies including Microsoft Sql Server, Visual Studio, ASP.Net, VB.Net, and Crystal Reports. Rob has held leadership positions in companies such as Atlantic Credit & Finance, Inc. and has managed large-scale projects, including replacing the company's business software and designing data warehouses for data analysis and process improvement.

Experience

    • Latitude Software Developer/Architect
      • Jan 2022 - Present

  • Bethlehem Software Consultants
    • Roanoke, Virginia Area
    • Developer/Owner
      • Jul 2010 - Present
      • Roanoke, Virginia Area

      • Technical Advisor/Developer for 10 current and previous national customers in Boston, Denver, and Chicago.• Provide ASP.NET, VB.NET, CSS, SQL development and minor JavaScript and C#. I used these skills for all the projects listed below.• • Recent projects include:o MSW Interface – 13 Import file formats(XML) and 15 Export File formats(XML). This project was completely automated including FTP uploads and downloads, file ftp transfer verifications and email reporting with detail links to a web interface.o Phone Scrub waterfall flowing through 3 vendors. This was automated with tracking and statistics emails for customers to use for vendor billing verification.o Resurgent Interface – 8 import file formats and 3 export files formats.o Trak-America Interface – 6 import file formats and 2 export files formats o Automating data scrubbing processes using SQL stored procedures along with a user web interface to manually input special data criteria to be cleaned. A SQL job was also used to schedule the process.o SQL DBA for most customers. Setup SQL backups and maintenance jobs to shrink logs and database files as needed. Profile server when users are having performance issues. Find and correct vendor software performance issues; adding indexes as needed. Design, update and maintain all tables and stored procedures. Upgrade, move, combine databases per customer’s requests. Use Activity monitor to find recently run heavy queries and design better queries to resolve issues. Split databases into multiple files and on multiple drives to help with load balances and performance issues.o Provide project management to ensure all interfaces and processes are all schedule and that end-users test and all change requests are reviewed and processed to close out projects.o Provide consulting specifically for the debt industry for all customers to assist them on what software packages and vendor services to use.

    • United States
    • Software Development
    • 100 - 200 Employee
    • Application Development Engineer - Remote
      • Dec 2020 - Jan 2022

      • SQL Database Development/Admin – build tables/views/stored procedures, performance tuning, database management, database investigations into database growth, long-running queries and performance issues/blocking/deadlocking• Application Development - ASP.NET, VB.NET, CSS, and minor JavaScript and C#. Assist and learn from a great team of developers.• Azure Cloud computing – learn about application development, resource setup and management and database operations in the cloud.

    • Personal Trainer - Remote
      • Dec 2019 - Dec 2020

      • Project Management - Manage active customer projects moving to cloud computing as well as reviewing potential customer projects and providing good/better/best recommendations on getting to the cloud.• Team Leader - Lead teams as requested for active projects or sprints. Manage teammember's hours and budget. manage cloud projects and work with teams using Azure DevOps and Microsoft Teams.• SQL Database Development/Admin – Provide SQL development support for data management, transformation, analysis and warehousing.• Application Development - Provide ASP.NET/VB.NET development support.• Team Building/Training - Lead meeting to assist employees with technology training sessions to enhance their IT knowledge.• Azure Cloud computing – learn about application development, resource setup and management and database operations in the cloud.

    • IT Programmer
      • Jul 2018 - Nov 2019
      • Roanoke, Virginia

      Provide computer programming using VB.NET, C#, SQL. Built Intranet pages to automate many data gathering processes. Learn data warehouse structure for creating and maintaining new data processes, reports, imports, exports and migrations. Learn Symitar, ARCU and other banking softwares.

  • FBCS, Inc
    • Hatboro, PA
    • Remote Programmer/Analyst
      • Oct 2016 - Jul 2018
      • Hatboro, PA

      Provide computer programmer using VB.NET, ASP.NET & SQL. Build new user interfaces both desktop application and web interfaces. Interfaces for data management including loading, parsing, reporting, etc.

  • City of Roanoke
    • Roanoke,Virginia
    • Project Manager/Developer
      • Oct 2008 - Jul 2010
      • Roanoke,Virginia

      • Provide Project Management for all applications related to public safety including Fire, EMS, Jail, Sheriff, and Police.• Project manager for regional data sharing project. Application will allow for sharing of police information between the City of Roanoke, Roanoke County, Town of Vinton, and City of Salem. This requires working with the vendor’s technical team and each agency’s IT staff.• As Project Manager, supervise a three developer team. Teach developers ASP.NET, VB.NET and SQL. Teach developers best practices for application development, coding standards, and debugging.• Build HTML and JavaScript pages for Police and Fire departments to display high priority information in their briefing rooms. Data is received from SQL and Lotus Notes databases.• Build ASP.NET pages for the fire department to register citizens for Reverse911 and special needs.• Build ASP.NET page for the traffic department to allow them to link into police accident data and do traffic studies more quickly. Provided external access for VDOT to utilize the page to relieve city of workload.• Build ASP.NET pages for fire station supply management, requisitions, reorders, and request fulfillment.• Building disaster recovery plan for each of the Public safety applications.• Left to start on business.

    • Technical Account Manager/Developer
      • Oct 2006 - Jul 2008
      • Remote

      • Worked with between 6 and 8 Top Level Customers providing primary point of contact for all their issues and whenever possible provide user support to resolve all SQL questions and issues. Learned company software to assist on any and all customer related issue when possible.• Assist customers in identifying hot list of top priority issues and resolving the issues and working with development staff to resolve issues. • Provide project management for customer and Latitude software projects including new data analysis projects working with Transunion, Experian and other data mining companies. Work directly with customer and developers to ensure requirements are gathered in a timely fashion and project definitions are drafted properly for development department. • Design SQL stored procedures to return data for custom interfaces for crystal reports, other databases, ASP web pages, and html web pages.• Design new data imports for customers to use to import many different forms of data from all their customers. Ensuring the data is clean and free of bad information and meets all database standards.• Assist customers with setup of new products. Latest product is Workflow/Job Manager. This product is used to automate data analysis and data movement. Process includes analyzing the customer’s processes and designing new workflows to automate processes including sending and receiving data from outside vendors, action required items, and data reporting.• Assist customers with setting up SQL database maintenance plans and scheduling, checking fragmentation, job scheduling, building triggers, views, and stored procedures.• Troubleshoot issues and provide technical feedback for developers so assist in resolving issues promptly. This included reviewing VB, C#, and other Visual Studio .NET code, profiling applications as they interacted with the SQL database, and process testing.• Laid off due to low sales.

    • Director of IT
      • Nov 2003 - Jul 2006

      • Managed project to replace the entire company’s business software. Project included gathering all departmental requirements as well as their wish list, conducting phone interviews with vendors, narrow search to 5 vendors for on site presentations and final selection. Once the final selection was made, coordination of data migration and implementation. Tasks included converting the collection software from a MS Visual FoxPro database application to MS SQL Server database application. Training and Testing was also conducted with all departments to ensure departmental readiness and maximum amount of departmental requirements were met. This project was for 2 remote sites and 3 local sites. The 2 remote site databases had to be merged with the local HQ database. Total users for all sites are approx. 400 users. Conversion plan called for 1 day of downtime, conversion over a weekend with offices back online on Monday. Remote sites now terminal service to local site allowing for easier data management. Project budget was approx. $2M. Ensured that all deadlines were met and goals were reached.• Responsible for supervising and mentoring 1 network engineer, 3 hardware techs, 1 dialer tech, 1 database administrator and 2 database programmers.• Responsible for managing migration of all internal reporting for Reporting warehouse(ARGUS and ATLAS)/application to auto publication utilizing SQL Server and the company intranet.• Responsible for providing user support for all network and computer issues for 400+ users at 4 offices including network support for Windows 2000 and XP.• Responsible for 8 MS SQL Server databases.• Continued construction and improvement to data warehouses used for financial analysis, process improvements, and performance monitoring.• Provide hands on programming for in house applications and database management using Visual Studio .NET, Visual Basic, Visual FoxPro, and MS SQL Server.• Left due to Layoffs and I had offer from Latitude Software.

    • Senior Programmer/Analyst
      • Jul 2002 - Oct 2003

      • Promoted to Director in October 2003. Responsible for hiring additional staff and upgrading infrastructure to support additional office locations.• Designed data warehouse for data analysis for inventory performance, finance analysis, and process analysis and improvement. Saved company hundreds of man hours each month utilizing data analysis and improving processes in all departments.• Design, program, manage, and maintain all in-house software applications using MS Visual Studio .Net, Visual Basic, MS Visual FoxPro and MS SQL server. Main application was named Atlantic’s Report Generator and Utilities System (ARGUS). This application contained screens and programs designed to provide 150+ users with solutions to automate data reporting and other solutions. These programs provided tracking of collector and supervisor statistics, legal functions, and accounting functions, etc. Initial design was an in-house client application which was moved to all intranet based reporting.• DBA for 4 databases. Setup DTS pages to automate agency, bank, and client file processing, job scheduling for load balancing for all DTS jobs.• Program sales file tool for evaluating files for possible purchase. This program analyzes 23 data points for each file and compiles a weighted average score for each account.• Program new business interface to process multiple file formats for multiple banks. Forward new business to all agencies. Process all agencies monthly payment files.• Provide outside agency support for 5 outside agencies not including ACF agencies.• Provide user support for all network and computer issues for 100+ users at 2 offices including network support for Windows 2000 and XP.• Provide software support for collections software (Windebt) and all MS Office products including Outlook.• Schedule and implement all upgrades for hardware, software and phone systems.

  • US Navy
    • USS George Washington - CVN 73 - Norfolk, VA
    • Data Processing Supervisor
      • Jun 1991 - Jun 1994
      • USS George Washington - CVN 73 - Norfolk, VA

Education

  • US Navy
    General Information Systems Schooling

Suggested Services

This profile is unclaimed. These are suggested service rates with 0% commision upon successful connection

Industry Focus. “Computer Software”

Looking to Create a Custom Project?

Need a custom project? We'll create a solution designed specifically for your project.

Get Started

References

Social Profiles

Community

You need to have a working account to view this content. Click here to join now

Similar Profiles