Job description
JOIN THE TEAM THAT’S POWERING PROGRESS
Building cities. Driving commerce. Saving lives. For over 100 years, Allison Transmission has powered the vehicles and technology that move our world forward.
What powers us? Our employees. From the first person hired by James Allison in 1915 to the thousands across the globe who work for Allison today, we’re driving progress everywhere because we employ top talent worldwide.
What powers us? Our employees. From the first person hired by James Allison in 1915 to the thousands across the globe who work for Allison today, we’re driving progress everywhere because we employ top talent worldwide.
Learn more about this role and how you can begin
driving your career forward!
Job Title:
Application Developer/Programmer, VBA
Job Description:
JOIN THE TEAM THAT’S POWERING PROGRESS
Building cities. Driving commerce. Saving lives. For over 100 years, Allison Transmission has powered the vehicles and technology that move our world forward.
What powers us? Our employees. From the first person hired by James Allison in 1915 to the thousands across the globe who work for Allison today, we’re driving progress everywhere because we employ top talent worldwide.
What powers us? Our employees. From the first person hired by James Allison in 1915 to the thousands across the globe who work for Allison today, we’re driving progress everywhere because we employ top talent worldwide.
This is an exciting opportunity in Indianapolis, IN for an Application Developer/Programmer, VBA
Learn more about this role and how you can begin
driving your career forward!
Summary:
Responsible for the DIRECT development and maintenance of Applications to manage data, documents, and reports in a Manufacturing Engineering environment.
Responsibilities:
Application Development: Document Templates and Reporting
- Provide maintenance and support for existing Excel/VBA applications that utilize Excel as a template to store and retrieve data utilizing an Oracle database to create reports that are then published externally (often to SharePoint sites).
- Maintain databases from data exported nightly from SAP, SQL Server, and other sources.
- Migrate multiple Oracle based applications to Web/SQL Server based applications and propose future migration direction.
- Note that over 70 existing applications utilize nearly 400,000 lines of VBA code. The current direction requires support of the existing applications (including improvements and enhancements) while working to migrate from Oracle to SQL Server.
- Design/create/modify applications as required to meet the needs of the Manufacturing Engineering community.
Emerging Technologies
- Work with emerging technologies such as PowerBI and PowerApps to interface with SharePoint and other data sources and develop other ways to develop and integrate new tools in new and creative ways.
NFS
- Manage Departmental Network File Shares and Archives
Authorizations
- Authorize user access to specific Manufacturing Engineering SharePoint sites, SAP roles, and network folders.
SAP
- Maintain SAP queries for nightly and ad-hoc reporting.
Training/Testing
- Create training materials and schedule training sessions (either in groups or individually)
- Communicate with personnel on new software releases or upgrades
- Perform UAT (User Acceptance Testing) in conjunction with IS&S personnel
User Support
- Provide general Tech Support to Users throughout Allison (for users of Mfg. Engr. Applications)
- Provide a physical presence in the workplace
Required Experience:
- Education: Bachelor’s Degree or equivalent experience
- Minimum 3 years’ experience
- Experienced in VBA (Visual Basic for Applications) programming.
- Experienced in Oracle & SQL
- Advanced experience in Excel
- Excellent Communication skills (written and oral)
- Knowledge of Manufacturing (materials and processes)
Preferred Experience:
- Microsoft SQL Server
- Microsoft SharePoint
- SAP
- wScript or Powershell
Allison Transmission is an equal opportunity employer. We have opportunities for all qualified applicants regardless of age, race, color, sex, religion, creed, national origin, disability, sexual orientation, gender identity/expression or veteran status.
If you are an individual with a disability or a disabled veteran requiring assistance and/or reasonable accommodations reviewing any of the careers information, please contact us at 317-242-5000.
Please note that Allison Transmission will make an offer of employment only to individuals who have applied for a position using our official application. Be on alert for possible fraudulent offers of employment. Allison Transmission will not solicit money or banking information from applicants.
Primary Location:
Indianapolis, IN
Additional Locations:
Allison Transmission is an equal opportunity employer. We have opportunities for all qualified applicants regardless of age, race, color, sex, religion, creed, national origin, disability, sexual orientation, gender identity/expression or veteran status.
If you are an individual with a disability or a disabled veteran requiring assistance and/or reasonable accommodations reviewing any of the careers information, please contact us at 317-242-5000.
Please note that Allison Transmission will make an offer of employment only to individuals who have applied for a position using our official application. Be on alert for possible fraudulent offers of employment. Allison Transmission will not solicit money or banking information from applicants.
jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.