Vba Programmer Resume Profile
SOFTWARE VBA, VB.NET, SQL, HEAT, VNC, PCANYWHERE, EXCEL, EXCEL VBA, ACCESS, WORD, POWER POINT JAVA, SharePoint, WebEx, Lync EXPERIENCE Analyst While assigned to SRA PBT/CTT/CED Operations Team as Analyst, I designed and built a number of macros interfacing with Outlook and Excel, using VBA that increased the efficiency of creating and distributing the weekly ADVANCE Report for the Deputy Secretary, Veterans Administration Learning University VALU and other high level Veterans Administration Learning University Staff. Daily responsibilities included gathering and disseminating of all project reporting including Monthly Program Reports, Internal Program Reports, Monthly Dashboards, and Weekly Delivery Reports for both internal corporate and external Office of Management Personnel and Veterans Administration management teams for oversight of project. A comprehensive process analysis was also carried out with the result of an entirely new SharePoint site and Access database was designed, created, and stood up as a document repository, as well as interfaced to the Access database to allow for version control and deliverables tracking. As SharePoint Collection Administrator for three separate and distinct sites I supported the troubleshooting and creation of SharePoint elements, while assisting the team in defining and implementing processes around capturing and presenting the work product of the group. Further job duties included direct support for the VA Enterprise Reporting Committee by hosting a weekly pre-meeting with stakeholders to set the agenda for the main committee meeting which I facilitated weekly. Heavily involved with the technical support for the operations team SharePoint site, Deliverables Database Access , and other document repositories. Created and maintained a multipage Excel macro based spreadsheet used for forecasting all project based labor hours for 100 people over 192 separate projects. This report was utilized extensively for man power scheduling, project budgeting, and financial reconciliation. Confidential Application Developer As lead programmer created an interactive budgetary tracking tool for NIDA Senior Management to track current and past grants and awards using a custom created VBA application. Worked closely with NIDA Senior Management to finalize requirements throughout the development process. Application included past and forward looking modeling sheets with 3D charts and graphs. Created documentation for the end user as well as technical documents for support personnel. Confidential VBA Programmer / Application Developer Led the gathering of requirements and created a custom Excel VBA application to track events and display impacts of those events to the defined schedule utilizing a built on the fly scatter chart based loosely on aviation specific project tracking charts. As a parallel process also created a rollup report for trend analysis for management overview. Wrote technical documentation for the end user and for training. This application took a process that required seven personnel many working through the night and reduced it to a simple one to two day highly automated process requiring only one individual to complete. Confidential VBA Programmer During this short contract assignment, I completed the development for a financial reporting tool for roll out to a nationwide audience. As part of this effort I tailored the application to the end users needs, resolved a list of user reported bugs and added some additional functionality as requested by end users. Updated current documentation or created new documents as needed and provided end user training in support of added functionality. HELP DESK METRICS ANALYST Confidentia
- Designed all metrics reporting for the Help Desk to assist in achieving critical business objectives. Used Excel APIs VBA, Redemption to develop customized applications that provide comparative metrics data. Used SQL to provide a client server configuration for the Columbus software application. Responsible for maintaining scripts written in SQL. Developed software using VBA for Office Products. Used Windows' scheduled tasks to kick off a batch file that runs 10 separate SQL scripts to pull relevant data from Oracle database for further processing by VBA programs to create custom reports. Responsible for the installation and support of multiple client sites with proprietary POS software designed for convenience stores . Clients included ARCO, Phillips 66, Texaco and Shell, Mobil. Performed remote installations for software applications with outside vendors using multiple platforms. Redesigned and automated metrics reporting after implementation of the Oracle Database. Administrated the Symposium ACD system for Customer Service and Help Desk
- Departments, approximately 70 agents, personally responsible for all reporting, scripting Programming and operational troubleshooting. Created and maintained customized programs using VBA to produce Help Desk reports. These reports covered Departmental Key Performance Indicators and employee metrics on a daily, weekly, monthly and yearly cycle. Worked with external customers to create custom reports describing Help Desk activities. Acted as the first point of contact for Help Desk users for any company-provided hardware and software issues.