Resume

Sign in

MS SQL Server Developer/Administrator and Project Manager

Location:
Brandon, Florida, United States
Posted:
October 19, 2018

Contact this candidate

Resume:

Ron Hymer

Page * of *

Email: ac7fk7@r.postjobfree.com

Cell: 813-***-****

Addr: 152 Butler Road

Brandon, FL 33511

Experienced In Business

Identifying and fulfilling business needs with software that delivers.

Clearly communicating software direction, risks and results to board of directors/senior management.

Leading cross functional teams of business and technology staff (2 to 15 members) to design, develop and implement software solutions on time and within budget. Experienced in Technology

Software development and database design

Database Developer and Administrator

(SQL Server 2000-2014, T-SQL, SSIS, DTS, Stored Procedures, complex data analytics)

Connecting disparate systems

Automating large data processing routines

Education

Penn State University Degree: BS in Engineering 1987 Organizations

Software

Microsoft SQL Server 2000 – 2014

SQL Server Management Studio

Microsoft DTS and RSS

Crystal Reports, JustInMind (Prototyping)

Microsoft Project, Visual Source Safe

Ron Hymer

Page 2 of 5

Email: ac7fk7@r.postjobfree.com

Cell: 813-***-****

Addr: 152 Butler Road

Brandon, FL 33511

Professional Experience

Drive Technology Group (Owner) 1998 – Current

Grew a custom software development company specializing in web-based applications and specialized engineering projects

Creating Business Intelligence (BI) systems turning data into information.

Staffing: From 2 to 15 full time staff in 6 years and sales to 2.2 million in annual sales

Highly skilled in sharing data between disparate systems and building automated management systems to take advantage of trend analysis.

Focused on great customer service and custom software that exceeded expectations, delivering within budget and on-time.

Customer: DealerWizard (2010 – 2014)

System: Management and Marketing tool for use in automotive dealerships (.NET C#, Custom windows services, SQL Server 2008, Stored Procedures) (Users 5,200) Overview:

Designed, Developed, Implemented, and Maintained DealerWizard. Responsible for the Business Logic Layer, Database Design and Stored Procedures. Lead a team of 8 .NET C# developers to build the front end application.

Daily data feeds from ADP, Reynolds and Reynolds, UCS, Black Book and NADA containing vehicle inventory, New/Used car deals and Repair Orders are imported, data cleansed and processed automatically with full file archive.

Customer history is examined, generating warm/hot leads, showing which customers are in a position to trade out, and what vehicles in current inventory would effectively meet the customer’s needs.

Database mining is performed to create marketing campaigns. Tracking campaigns yields a dealership’s ROI, providing dealership management with effective marketing aiding in customer retention.

Customer: Sonic Automotive/Hendrick Automotive (2005 – 2013) Company: Sonic Automotive (Fortune 500) the second largest dealer group in the US. Company: Hendrick Automotive a Charlotte, NC based dealer group System: Cash Management (SQL Server 2008) (Users 1500) Overview:

Designed, Developed, Implemented, Maintained a corporate cash management system. Responsible for the Business Logic Layer, Database Design and Stored Procedures. Lead a team of 3 .NET C# developers to build the front end application.

Interfaced with Bank of America, tracking all dealership’s account balances. Dealership accounts were ZBA (Zero Based Accounts) where there was either a funding or withdraw to bring a dealership to zero at the end of the day.

Ron Hymer

Page 3 of 5

Email: ac7fk7@r.postjobfree.com

Cell: 813-***-****

Addr: 152 Butler Road

Brandon, FL 33511

Created monthly cash profiles/projections over the course of the month.

Tracked short investments and interest distributions. Customer: Sonic Automotive (2000 – 2004)

System: AuditNet (PowerBuilder and SQL Server 2000) Overview:

Designed, Developed, Implemented an Intranet based application for electronic work papers. Responsible for the Business Logic Layer, Database Design and Stored Procedures. Lead a team of 3 PowerBuilder developers to build the front end application.

Provided Internal Audit team with custom audit capability, problem identification, document backup (and secure electronic storage), dealership response and automated follow-up on the next audit.

Customer: DealerTrack (2005 – 2006)

System: eMenu (.NET C# and SQL Server 2005) (Users 20,000) Overview:

Originally Designed, Developed, Implemented a menu selling web-based software for GoBig Software.

GoBig sold the software to DealerTrack

DealerTrack retained my staff to migrate the GoBig Menu to work seamlessly within DealerTrack’s internal security and software structures.

Responsible for the Business Logic Layer, Database Design and Stored Procedures. Lead a team of 7 to build the original application and a team of 15 to migrate the application.

eMenu accomplished customized menu packages for Platinum, Gold, Silver, Basic and calculated the amount of additional monthly payment required for the package. The calculations took into account state and local taxes, fees and laws.

Custom interfaces were developed to take the finished deal and update ADP and Reynolds and Reynolds with the customer’s choices automatically. Ron Hymer

Page 4 of 5

Email: ac7fk7@r.postjobfree.com

Cell: 813-***-****

Addr: 152 Butler Road

Brandon, FL 33511

Customer: Dynatron Software (2001 – 2005)

Company: A Texas based organization specializing in Repair Order analysis serving over 500 dealerships.

System: Ebis Reporting (.NET C#, SQL Server 2000, Stored Procedures) (Users 2,800) Overview:

Migrated a Windows based application to become a web-based application. Taking the application from a single dealership to an enterprise implementation.

Responsible for the Business Logic Layer, Database Design and Stored Procedures. Lead a team of 6 to build the application.

Ebis, automatically processed nightly data feeds from ADP and Reynolds and Reynolds comprising of all repair orders.

Report delivery options were either through a system logon or automated delivery via PDF

Reporting was accomplished either on a single dealership or enterprise scale depending upon user permissions.

Reporting showed parts utilization and repair order types based upon user defined regions in the country all the way through a corporate rollup. Customer: Premier Dealer Services (2000 – 2001)

System: PDS (.NET VB, SQL Server 2000, Stored Procedures) Overview:

Migrated a Windows based application to become a web-based enterprise application.

Responsible for the Business Logic Layer, Database Design and Stored Procedures. Lead a team of 5 .NET C# developers to build the front end application.

PDS compiled warranty claim information from dealerships and interfaced with insurance agencies.

Customer: SunTrust

System: Teller-less Branch (C++, Visual basic, Picture-Tel) Overview: Wrote first generation control systems to integrate video teleconferencing and touch screen technology providing prototype kiosks to centralize Customer Service Representatives. Customer: Premium Assignment Corporation

Company: A SunTrust corporation specializing in the financing of professional insurances. System: PAC Plus (Visual Basic, Access)

Overview:

Designed, Developed, Implemented, Maintained the core system (PACPlus) alloweing Insurance Agencies to provide a quote to their customer for financing insurance premiums.

PACPlus would calculate payments based upon state laws, generate contracts, fax contracts to underwriting for approval.

Created an automatic interface from the Client Side PACPlus software to the corporate mainframe.

Ron Hymer

Page 5 of 5

Email: ac7fk7@r.postjobfree.com

Cell: 813-***-****

Addr: 152 Butler Road

Brandon, FL 33511

Customer: JLM Industries

Company: A reseller of bulk chemicals

System: RIMS (ASP, SQL Server 2000)

Overview:

Designed, Developed, Implemented, Maintained a Tank Farm management system.

Providing for a graphical interface showing tank levels.

Interfaced with 3M’s order processing system

Interfaces with automated measuring systems.

Automated Research Systems(Tampa, FL) (Senior IT Consultant) 1996 – 1998

Member of the management team responsible for securing new contracts.

Secured contract at the University of South Florida. o Lead a team of 5 Oracle developers and 2 business analysts to implement electronic test scores, electronic transcripts and automated admission decisions as part of changing out the student information system to OASIS.

ParaSoft Computing Solutions (Winston-Salem, NC)(Senior IT Consultant) 1995 – 1996

Developed and Delivered a protocol analyzer to Ford Motor Company for real time analysis of the environmental systems in the Ford Tarus. (C++)

Developed a touch id system for a fueling company of construction equipment for fluid records and billing (C++)

New Zealand Milk Products (Fort Lauderdale, FL)(Director Information Technologies) 1994 – 1995

Responsible for implementing Oracle Financials for Production Control, Lot Traceability, MRP, Automated Ordering in my region comprising of Mexico, Latin America and the Caribbean.

General Dynamics (San Diego, CA) (Engineer) 1987-1994

Engineering for F-16 cable and harnesses, Phalanx control systems

Implemented MRPII using PC’s and building interface to IBM 3090.

Created bi-lingual work instructions, time tracking, and CSPEC accounting interface for offshore manufacturing facility.



Contact this candidate