Ron Reinke
Senior Business Applications / Database Engineer at Envoy Managed Services, LLC.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
OCP - Oracle Certified Professional - Database Administrator
Oracle -
Oracle 11g Certified Associate Database Administ
-
Experience
-
Envoy Managed Services, LLC.
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior Business Applications / Database Engineer
-
Mar 2016 - Present
Support of ERP (MS Dynamics GP 2013) system for Argos USA – responsibilities include: Help Desk tickets for all aspects of the business Project work which included:o Accounts Payable auto match of Material/Hauler tickets for invoicingo XML file creation for Ready Mix invoices - for 3rd party mailingSupport of custom BizTalk integrations for invoicing, Material ticket processing, Vendor Auto MatchSupport of Command Alkon applicationsOracle DBA responsible for 2 node RAC 11g cluster database used for propriety application Other tasks include:o Daily / Weekly / Monthly checklists maintained to ensure uptimeo Development 2 node RAC 11g cluster database maintained for testing, development of custom integrations, patch applications, propriety application patches, PSU patches, and various other applicationso Test 11g database maintained for testing of applications before rollout to production Show less
-
-
Senior Business Applications Consultant
-
Jan 2015 - Feb 2016
Independent consultant responsible for support of MS Dynamics GP 2013 and propriety application used for Ready Mix concrete dispatch and delivery
-
-
-
Argos USA
-
United States
-
Wholesale Building Materials
-
700 & Above Employee
-
Business Applications Manager
-
Oct 2010 - Dec 2014
- Support of proprietary application for plant/dispatch operations - Support of MS Dynamics for Financial departments - Support of SQL Server/Oracle databases for business applications - Ongoing software upgrades for all business applications Level 2/3 support, management, and technical troubleshooting of MS Dynamics GP 2013 ERP system which consists of 37 company databases. This support covers modules of Finance, Purchasing, HR/Payroll, Accounts Payable, Fixed Assets, and Accounts Receivable. This support also includes Back Office BizTalk integrations for Material Tickets, Command Alkon invoicing into GP, and Auto Match of Material Tickets for GP. All aspects of GP security are handled as well – which includes user setup, user access to companies, and security task/role creation and modifications. To effectively support these applications a detailed knowledge of the database structure is required for troubleshooting and resolution. Fully understanding the business requirements is essential to support the various departments effectively – especially during upgrades and installation of new products. This management and support also includes Command Alkon dispatching software, Kronos timekeeping, Cognos reporting, and various 3rd party add-ons. Strong Oracle/SQL Server skills are required for maintaining, troubleshooting, and remediation of issues. Working alongside other IT team members is critical for successful completion of projects – dedication to this is important. Documentation of change control is essential as well – development cycle of development, test, and production changes. The most important part of Business applications is listening to the business, defining the requirements, and seeing it through to the end. Technical Skills In depth knowledge of Oracle databases In depth knowledge of SQL Server databases Proficient in MS Dynamics GP – application, database structures, SmartList Proficient with SQL, PL/SQL, stored procedures, views, triggers Show less
-
-
-
Ready Mixed Concrete Company
-
United States
-
Construction
-
1 - 100 Employee
-
IT Manager
-
Oct 2004 - Sep 2010
• Responsible for data center management and day to day operations of 11 admin sites, 90 plants • End user support management • Voice/Data project management • Network support and management • Oracle database support and upgrades • Oracle applications support • Cognos database/application support • Data center project management • Software licensing/maintenance • Support of proprietary application for plant/dispatch operations • Responsible for data center management and day to day operations of 11 admin sites, 90 plants • End user support management • Voice/Data project management • Network support and management • Oracle database support and upgrades • Oracle applications support • Cognos database/application support • Data center project management • Software licensing/maintenance • Support of proprietary application for plant/dispatch operations
-
-
-
Rock Solid Technology, Inc
-
United States
-
Senior Development Engineer
-
Apr 2000 - Nov 2003
•January 2001 – November 2003 Developed and supported Visual Basic 6.0, .NET applications. These applications included: (1) Jan 2001 – April 2002 HR/Payroll application for Department of Education in Puerto Rico, (2) May 2002 – Nov 2003 an Order Management application for a large Manufacturing company, and (3) various data management applications. •January 2001 – November 2003 Oracle DBA support which included building databases for testing, monitoring the databases as needed, and making changes as requested. This support was for Oracle 7/8 on Windows NT/2000 •April 2000 – November 2003 Design and development of Applications using Microsoft Visual Basic .NET technology (front end) and Microsoft SQL Server or Oracle (back end). Project work has included Data warehousing using an Oracle database, Web development using an Oracle database, and various Visual Basic development projects using Oracle. •April 2000 – December 2000 Developed and supported Access 2000 applications for validating, editing, and posting data into a data warehouse from multiple locations. This menu driven application enabled the user to load data, validate against a set of tables, make corrections as necessary, and then transfer to another system for posting. Show less
-
-
-
CCI / Triad
-
Software Development
-
Oracle Applications/System DBA
-
Jun 1997 - Mar 2000
Oracle Applications/System DBAJune 1997 – March 2000•Responsible for maintaining Oracle databases running Oracle Financials, Payroll, and Human Resources applications. These responsibilities as a Production DBA included monitoring, change management, maintenance, and upgrades as necessary. The Oracle database was running under Oracle 7.3.4 using 10.7SC client application software on a SUN Enterprise system. The Application DBA responsibility included change management, upgrades, and maintenance when needed. The applications supported were AP, GL, Fixed Assets, and HR/Payroll. Support of these modules was 24/7.•Responsible for installing/maintaining various 3rd party applications using Oracle databases. These applications included 401K, Payroll, Check Writer, and applications designed for data transfer. This also included the setup of network printers and testing with the application.•Was involved in the initial setup of Oracle and participated in all aspects of the Oracle installation. This included the initial client setup which ultimately grew to 350+ users, the creation /setup/change management of the Oracle database, and the loading of the application software. This Oracle database included 9 Accounting centers, the corporate users, and remote users.Provided test/development environments for training/development use and change management testing. This environment was especially critical for Y2K testing/implementation provided by the DBA.•Developed database monitoring tools using UNIX scripts, reporting these messages via email, and notification to the DBA.•Worked with management on training with PC Helpline on Oracle support issues.•Worked with PC Helpline on setup of desktop PC’s with Oracle client software. This included user setup, application software load, and testing.•Provided PC support for the Oracle installation until PC helpline was established. This included application support, network support, and error troubleshooting. Show less
-
-
Financial Support Manager
-
Jan 1991 - May 1997
• Implemented and supported proprietary financial application software for multiple Accounting centers. This support included implementation, reporting errors/changes, and 24/7 support.• Tested, implemented, supported, and training for Centralized applications for automotive parts stores. This software enabled centralized control for 1000+ stores including A/R, Inventory, General Ledger, and various management reports. Training on these applications included store support personnel, helpline personnel, and management.• Worked with other team members on implementing hardware/software for new automotive warehouses. This included hardware setup, cabling, data conversions, and training. This training included Order Entry, communications gear troubleshooting, printer troubleshooting, and other aspects of the proprietary warehouse software. Show less
-
-
Implementation Specialist
-
Jul 1989 - Dec 1990
1990 Implemented, supported, and trained warehouse personnel on automotive warehouse proprietary software. This involved data conversions, hardware setup, printers, cabling, software setup, training, and support.
-
-
Center Manager / Assistant Center Manager
-
Jan 1986 - Jun 1989
• January 1986 – June 1989 Responsible for daily operations of Computer center and software implementation. This responsibility included managing center employees, maintaining the data center resources, and 24/7 support.• Installation, training, and support of computer systems running proprietary software in automotive parts stores. This included hardware setup, cabling, printers, and training with personnel.
-
-
Operations Manager
-
May 1983 - Dec 1985
• May 1983 – December 1985 Responsible for daily operations of computer center which included support of automotive distribution centers, automotive parts stores, and personnel using the proprietary software. This also included the management of the 24/7 operators and working with the center manager on various responsibilities.
-
-
Education
-
1984 - 1985
Saginaw Valley State University
Attended various classes, Information Technology -
1981 - 1982
Delta College – University Center, MI 8/1982
Associate's Degree, Associates in Business Studies in Data Processing/Programming with Honors
Community
