Professional Summary

A experienced IT professional with a 14 year track record as a Business Analyst, Software Developer and Technical Support Representative in Information Technology and Investment Banking with the interest and the ability in solving problems and contributing to team effectiveness and success.

Accomplishments

• Developed an Excel interface to drive consolidation and virtualization of the servers and storage. Tool was implemented globally to over 50 users. Business Managers were able to track decommissioned servers, new purchases, recycles, physical to virtual consolidations and storage requests from multiple lines of businesses. Forecasting reports and data established targets that reduced server inventories by 10 percent yearly. The temporary solution was in use for 5 years before moving to an Enterprise Solution.
• Designed and developed a validation tool to track decommissioned servers for credit toward new server purchases. Eliminating duplicate server submissions allowed Business Managers to get a more accurate view of the costs of new server purchases and manage their inventory more efficiently.
• Gathered requirements, designed and developed an application in Visual Basic to identify client names, customer Ids, account numbers and licensed products for a 24/7 technical support call center. The application helped technicians reduce call duration resulting in more efficient technical support and better customer service. It also helped identify delinquent clients who needed additional approval from Accounting for Technical Support.
• Planned, directed and implemented POS and Inventory software to track sales and inventory costs for two locations. The software helped identify popular as well as slow selling items with the end result of reducing Inventory costs. Managed remote communication and data transfers between stores.

Experience

Technical Business Analyst

Confidential

• Analyze and troubleshoot VBA error messages. Modify VBA to manipulate data types as necessary.
• Automate weekly reports to track applications migrated to Microsoft Office 2010
• Document the progress of End User Applications from submission to sign off
• Follow strict guide lines for converting EUAs to Office 2010 during migration process
• Convert applications to Office 2010 using Office Converter diagnostic tool.
• Diagnose and troubleshoot compatibility issues converting applications from Office 2003 to Office 2010
• Create how to Wiki documents for common issues and problems that users may encounter.
• Update SharePoint website for manual EUA process.
• Diagnose and resolve JIRA tickets related to Microsoft Office conversions

Business Analyst Applications Developer

Confidential

• Create an Excel User Interface for input and reporting of server forecasts
• Connect to external Oracle, MS SQL and Access databases for reporting and analyzing data.
• Interface with web services for reporting.
• Modify complex queries in MS SQL and VBA to maximize the efficiencies of the database and improve performance of application.
• Maintain and support quarterly, monthly, weekly and adhoc reporting
• Manipulate, map and normalize data in Excel worksheets and automate the process
• Create SQL queries to integrate Estate Management inventory with Forecasting Tool.
• Maintain and support Excel worksheets for Finance integrate with Krescendo
• Import data from MS SQL to Access.Modify data types as necessary for conversion to Access.

Technical Business Analyst

Confidential

• Create Master Asset ID to match serial numbers, inventory Ids, and fixed asset Ids to easily identify the asset as it moves though its life cycle.
• Sign off and approve new server purchases.
• Manipulate and transfer data between the purchase order, inventory, Oracle Discoverer Plus and accounting systems to improve data integrity for asset tracking and depreciation.
• Develop flexible applications to enter and extract data from three regional systems into Inventory System using macros, VBA, SQL, Excel and Access to link primary keys and unique Ids as needed.
• Import and export data in and out of Excel and Access Transfer data to QuickPlace web site to distribute data
• Responsible for database and worksheet backups.
• Deliver weekly and monthly reports for senior management

.Programmer Technical Support Analyst

Confidential

• Reviewed, analyzed, and evaluated user needs for Accounting and Sales Department. Wrote detailed description of user needs, program functions, and steps required to develop or modifycomputer programs.
• Developed and managed a relational database to store customer ids, names, aliases, and licensed products in addition to area code information for licensed clients. Responsible for exporting data from MAS90 accounting software to update and refresh data on a monthly basis.
• Created an application in Visual Basic to search client names, customer account numbers and licensed products resulting in a major increase in productivity for the entire technical support team. Prior to this application, searches were done manually using hard copy lists. This required expertise and strong knowledge of Access, Excel and SQL analytical and technical skills to efficiently complete the project.
• Created reports in Access to assist Sales Team to eliminate duplicate calls to prospective customers.
• Provided technical support to clients running SEA mainframe products on IBM z/OS operating systems.
• Communicated with clients to understand and analyze issues. Documented, troubleshoot and recreated problems in JCL batch environment, resolving or escalating to next-level support as appropriate.
• Responsibilities included 24/7 technical support for major US and International banks, retail, airline industries, brokerage firms, universities and government agencies. Clients included Wal-Mart, Merrill Lynch, AIG, Wells Fargo, IBM Global Services, DAK Hamburg, Government of Quebec, US Dept of Agriculture, Federated Department Stores, and State of Florida.