System Programmer Analyst Resume Profile
TN
Objective
Talented IT Business Analyst with more than 20 years of Information Technology experience in various industries including, government, banking, telecommunications, retail, package shipping and trade promotion seeking a diverse and challenging position with a small t mid-size company or government entity as a Business Analyst or Business Systems Analyst.
SUMMARY OF QUALIFICATIONS
- Experienced in serving as a liaison between the business and IT organizations.
- Able t analyze, design, and document requirements for new and existing IT solutions.
- Proven background completing projects under aggressive time constraints.
- Proven background in creating project documents.
- Proficient in facilitating meetings and discussion as needed during the project life cycle.
- Experienced in BMC Remedy.
- Excellent communication, analytical, interpersonal, and presentation skills.
TECHNICAL EXPERTISE
- Operating Systems: MS Windows all versions , Linux Suse, Ubuntu
- Virtual Machines: Oracle Virtual Box
- Systems Monitoring: BMC Patrol, TMART, WEBMETRICS, WEBTRENDS
- Applications: MS Office Suite all versions , MS Project, BMC Remedy, MS Excel, MS Word, MS PowerPoint, Visio, Borland Caliber, SQL Developer, SharePoint, Microsoft Assessment Planning Toolkit MAP
- Databases: MS SQL Server, MS Access, Visual FoxPro, Oracle
- Scripts: VBA, SQL, HTML, JavaScript
PROFESSIONAL EXPERIENCE
System Programmer Analyst
CONFIDENTIAL
- Business Analyst and Technical Lead on project t allow for uploading State of Tennessee Assets servers, desktop computers, laptop computers, tablets, printers, networking gear USBs, routers, switches and mobile devices int the Remedy Asset Tracking Module.
- Used Microsoft Assessment Planning toolkit t query State of Tennessee assets and gather server and desktop properties such as amount of memory, CPU, operating system and networking information for use in the Asset Management Project.
- Used SQL Server 2012 t query the data gathered by the Microsoft Assessment Planning toolkit and populate transactional spreadsheets supplied by BMC Remedy.
- Facilitated researching of all State of Tennessee in-house tools t track servers, desktop computers, laptop computers, tablets, printers, networking gear USBs, routers, switches and mobile devices and created report for management review.
- Facilitated research t ensure all Remedy CI's were mapped t the correct forms and all data was present in the forms.
- Created various Remedy Service and Change Requests t open ports and modify firewall rules t access servers.
- Facilitated meetings and worked with OIR-Remedy team, Security and Network members t accomplish goals related t the Asset Tracking Project.
- Lead Business Analyst on State of Tennessee project t create a framework for onboarding new agency Remedy customers,
- Lead Business Analyst on State of Tennessee project t create a Performance Evaluation framework related t system issue response and resolutions related t Service Level Agreements and determine through investigation, analysis the root cause of SLAs being missed and how t improve performance.
Business Process Analyst
CONFIDENTIAL
- Lead Analyst on project t audit and update USPS Help Desk Knowledgebase for hardware and software applications.
- Lead Analyst on project t audit and update USPS Remedy types and organizational groups.
- Lead Analyst project t project Infrastructure Capacity Planning t accommodate adequate hardware resources for USPS software applications including memory, storage, CPU and I/O.
- Developed MS Office Application t query WEBTRENDS database using VBA, SQL and accessing Oracle Database through and OBDC connection.
- Developed MS Office Application t query Oracle Capacity Planning Database using SQL Developer, VBA and SQL.
- Lead Analyst on projects t retire legacy USPS software applications.
- Create and execute Project Plans for Retired Applications.
- Lead Analyst on projects t decommission USPS Solaris hardware.
- Lead Analyst on project t create and update USPS run books for Project Phoenix USPS.COM and legacy applications.
- Lead Analyst on projects t create and update Standard Operating Procedures SOP for Project Phoenix and legacy applications.
- Facilitated meetings t gather information and resolve problems associated with USPS software applications and hardware environments.
- Create Change Requests, Service Requests and Help Desk Requests using Remedy t accommodate hardware and application problem tickets.
- Created software deployment plan for US Postal Service Project Phoenix.
- Maintained software requirements in Borland CaliberRM
- Translated Business Requirements int Functional Requirements.
VBA Developer Analyst
CONFIDENTIAL
- Responsible for developing new reports using MS Excel and VBA Macros.
- Capture and document user requirements.
- Create training materials and deploy new applications.
Web Designer, VBA Developer
CONFIDENTIAL
- Designed, developed, implemented and maintain an e-commerce web site for sale of pet supplies and gifts.
- Designed, developed and coded desktop application programs t accommodate and analyze Yaho Store sales and Internet traffic reports using Visual Basic, MS Access, MS Excel Macros, VBA and Visual FoxPro.
Adjunct Instructor
CONFIDENTIAL
- Taught college level courses in Visual Basic and Microsoft Office. Fall 2006 .
- Taught college level courses in Visual Basic and Microsoft Office, Fall 2005 .
VBA Developer, Associate Consultant
CONFIDENTIAL
- Researched core business function of company in finding business Information Technology opportunities with the Federal Government. This involves extensive use of the Internet and person t person contact with various government agencies and personnel.
- Met with PTAC and SBA personnel t accomplish core business objectives.
Developer, Programmer/Analyst
CONFIDENTIAL
- Performed Object Oriented programming in a team environment of software related t Trade Promotion Management, using Visual FoxPro, Visual Basic, SQL and VBA.
- Developed sales marketing tool using Visual FoxPr and PowerPoint-VBA
- Researched end-user requirements wrote program specs and developed applications.
- Developed technical and end user documentation.
- Participated in on going Quality Assurance and testing.
- Wrote test scripts for end user testing of Account Review Software.
Programmer/Analyst, VBA Developer
CONFIDENTIAL
- Performed Object Oriented programming using Visual FoxPro, SQL, and VBA related t developing an Employee/Corrections Officer Information, Employee Overtime, and Employee Training, and scheduling program modules relating t a prison shift command system.
- Researched end-user requirements, wrote program specs, and developed applications.
- Designed and developed reports based on end user requirements.
- Developed end user documentation.
- Developed scripts t use in testing.
CONFIDENTIAL
Programmer/Analyst
- Performed Object Oriented programming using Visual FoxPr and SQL related t developing Medical/Surgical and Mental Health program modules relating t a health quality improvement review system.
- Researched end-user requirements, wrote program specs, and developed applications.
- Created reports based on end user requirements.