This position is responsible for developing tools and automation solutions in Microsoft Excel using VBA and SQL databases. Analyze, write code and perofrm testing to enhance existing sales estimate program.
Confirm project requirements by reviewing program objective, input data, and output requirements.
Arrange project requirements in programming sequence by analyzing requirements.
Encode project requirements by converting work flow information into computer language.
Prepare a work flow chart and diagram using knowledge of computer capabilities, subject matter, programming language, and logic.
Confirm program operation by conducting tests, modify program sequence and/or codes as needed.
Educate and assist users on how to interact with the software.
Prepare reference for users by writing operating instructions.
Maintain historical records by documenting program development and revisions.
Education & Work Experience Requirements:
High School Diploma/GED.
Mininum 3 years of hands-on experience on VBA assignments.
Advanced VBA user experience level required.
Strong knowledge of Microsft Excel functions, macros, and programming.
Overall expert level PC skills withing the Microsft Office environment.
High aptitude for analytical thinking and problem solving.
Able to trouble shoot effectively and efficiently.
Demonstrate good judgement in slecting methods and techniques for obtaining solutions, resolving issues or in making recommendations.
Able to work well with very little directive, carry out assignments and prioritize issues.
Strong attention to detail and highly organized.
Able to work cooperatively in a team environme