Robert Kerwin Email & Phone Number

New Mexico, United States

Albuquerque, New Mexico Area

Partnered with customers to define business needs and implement efficient, cost-effective systems and procedural improvements. Designed, developed and implemented Banner add-on web Self-Service applications using Oracle Web Toolkit, PL/SQL, HTML, JavaScript and CSS. Worked directly with Finance, Budget and HR-Payroll functional groups to assess and define project scope and milestones. Served as Interim Manager of the HR-Payroll/Finance applications team from July 2014 to June 2015.- Implemented extensive changes to Budget Development and Salary Planner- Developed compound JV, Categorization of Reserves and Garnishment Self-Service applications- Coordinated and completed several high-visibility projects and operations such as BIRS re-implementation, LoboTime (Kronos) time and leave tracking system and benefits open enrollment- Planned and implemented Banner upgrades- Established strong, collaborative relationships with offices across UNM, including Human Resources, Finance, Payroll, Graduate Studies, Faculty Affairs and Services and Planning and Campus Development

Albuquerque, New Mexico Area

Supported Finance functional groups by implementing Banner add-on processes in an Oracle environment. Worked directly with functional groups to assess needs, specify software requirements and develop and test Banner add-on processes. Assisted groups outside of Finance on an occasional basis by sharing knowledge, training and supporting Banner module implementation.- Developed batch processes that improved data integrity- Developed ad hoc and scheduled reports and processes in PL/SQL- Provided general technical support for Banner ERP- Project lead for small and medium projects

Urbana-Champaign, Illinois Area

Developed a variety of university-wide systems (involving both web and batch components) for various clients including Security, Payroll and Records using Java, JSP, XML and PL/SQL. Worked with project managers, technical leads, analysts and other consultants in a team environment to design, build, test and deliver the applications. Performed both unit and functional testing to ensure software was delivered with minimal defects.- Developed a web application for tracking organizational and program codes utilizing Java, JSP and XSLT- Developed a web/batch application for managing involuntary payroll deductions utilizing Oracle PL/SQL packages, functions and procedures called by Java code via JDBC- Developed a web/batch application for assigning student registration time windows which interfaced with SCT Banner tables

Scottsdale, Az

Developed and maintained Human Resources applications, including salary planning and staffing applications. Worked with internal customers to understand and document business processes and systems needs. Responsible for all phases of the software lifecycle: requirements, analysis, design, build, test, deployment, maintenance.- Designed, coded and implemented a new employee orientation Internet application that reduced paperwork for new hires by 25%; cycle time was reduced from 48 hours to real time. The application utilized HTML and Acrobat forms generated by Java servlets and interfaced to the staffing system database- Designed and developed a version release of an enterprise-wide staffing system that was completed on time and under severe resource constraints (40% of original plan). The application was developed in Java using NetDynamics application server and interfaced with an Oracle database- Implemented a vendor package case-tracking system for Global Immigration Services on time, meeting all client expectations- Performed quality assurance testing of applications using Mercury Interactive’s test suite (LoadRunner, Test Director and WinRunner). Documented test cases, developed manual and automated tests, designed and ran load-testing scenarios- Assembled a multimedia training course for the Organizational Development department, which included video, audio and online assessments. The application was developed using Macromedia Authorware, with back-end programming in Oracle PL/SQL- Developed and documented a process for production support of staffing systemsImplemented enhancements to the Space and Systems Technology Group’s salary planning system. Developed an Access/Visual Basic interface that eliminated several manual procedures in the generation of salary planning documents

Scottsdale, Az

Managed a Local Area Network; determined business requirements for the entire network, which included evaluation of hardware/software and implementation of network systems appropriate to business requirements. - Participated on work teams that developed group-wide standards for network configuration and security -Upgraded file server hardware and optimized performance, which increased network capacity by 50%- Developed a re-imaging procedure for PC workstations that reduced setup time by 50%- Consolidated smaller LAN's and added workgroups, which doubled the user base, saving the company $75K annually in redundant support and hardware costsManaged six Novell file servers and over 250 PC and Macintosh workstations. Performed server/workstation hardware and software upgrades, specified and implemented backup procedures and performed performance monitoring- Provided technical support and training for 250 end-user clients

Scottsdale, Az

Maintained the mainframe Reproduction/Document Control financial charge back database system. Designed and implemented related applications and ensured compliance with accepted software change control and documentation guidelines.- Redesigned applications and processes for generation of month-end journal voucher entries resulting in reduction of failure rates and cycle time. Implemented applications on the mainframe using a combination of Pascal and FORTRAN programming languages- Designed, coded and implemented a query system that decreased report creation time by 50% and improved access to archived data- Analyzed data entry screens and streamlined the screens and process, which increased data entry efficiency and accuracy