SUMMARY

• Hands - on experience in multi-tiered, high-performance distributed enterprise applications across industries, including financial, healthcare and software development; includes MS Windows application programs.
• Skilled in all facets of product lifecycle development ( SDLC, CMS, CMDB, ITSM, ITIL ) from requirements gathering, analysis, and conceptual design through architecture and implementation on stand-alone to 3 tier systems.
• Strong interpersonal and written communication skills enable effective communication with technical and non-technical staff.
• Planning application upgrades and performing migrations and scripting .

TECHNICAL SKILLS

PC Programming Languages: VB.Net, C#/C++, ASP.Net, HTML, VBScript, JavaScript, OpenEdge Progress, SQL, Assembly

Operating System: Windows 3 to 10 desktop and server 4 to 2016, OS/2, AS400, UNIX, DCL, JCL, Android, iOS

Software: SQL Server, MS Access, MS Excel, Word, Outlook, PowerPoint, Planner, FTP, OCR, Cognos, Hyperion, Magic SDE; Clarity PPM; PeopleSoft, SharePoint Designer, Visual Studio, Power BI, SSIS, SSRS, SSAS, MSBI, Toad

Hardware and Services: Firewall, Switch, Router, Hub, VPN, DSL, T1, Anti-Virus, Exchange, Proxy, IIS, Azure, Intune

PROFESSIONAL EXPERIENCE

Confidential, Leawood, KS

Lead Systems Analyst / Developer

Responsibilities:

• Built and maintained applications on SharePoint, MS Access, SQL, SSIS, SSRS, Power BI, IIS, and Visual Studio using C#, VB, ASP, JavaScript, and PowerShell; converting data using ETL or FTP.
• Automating Axys to Excel for quarterly billing using VBA, PowerShell and Advent Macros
• Began migration from GPO to Intune and use of Azure
• Worked with vendors and monitored and built systems
• Administration of Office 365 products
• Securing cloud web service and configuring CMS of JOOMLA and Email for theshepherdscares on a Linux instance working with HTML and CSS
• Analyzing Scheduling software such as When To Work for a small organization
• Using GO Language imported Google calendar to Excel

Confidential, Kansas City, MO

Lead Software Application Administrator / Senior Network Administrator / Software Engineer

Responsibilities:

• Reduced 12 or more windows scripts to 1 and ensured continual run, setting up Network Drives per logged on user, saving troubleshooting time and reducing launch time of billing applications for many business units, using VBA / CScript / C# / PowerShell / Bat.
• Repaired Magic on several occasions within 1 hour, allowing company help-desk and other departments using ticket tracking system to continue with little downtime.
• Learned new applications on the job and with vendor training, ensuring continuous support when subject matter expert left position of support.
• Enhanced applications by modifying scripts at server and MS Access user interface and data structures.
• Wrote SQL queries, overseeing support queues and enumerate tables.
• Modified HTML, Java Script, C# and ASP code on .Net, permitting F5 network load balancing switch to sense operational status of multiple web servers, with developer vendor approval.
• Recovered multiple server configurations which failed due to hardware malfunction, limiting company downtime .
• Installed and maintained help desk software called Magic from version 7.5 to Remedy SDE 8 to BMC SDE 9.2 on Windows platform by writing scripts ( such as SQL, JavaScript and VBA ), enabling monitoring of database and interface.
• Supported and re-installed IBM / Cognos Contributor Planning and Oracle Hyperion; on mix of Windows and AIX and Linux platforms, reducing vendor support requests and on-site consulting.
• Assisted with some Model planning using STAR schemas and load balancing multiple servers for Oracle Hyperion and Cognos Planning Contributor.
• Assisted users with various functionality questions, determining root cause of server / network issue and developing appropriate plan of action.
• Restored to operation of enterprise software due to data or server issues by troubleshooting and engaging with vendor or other internal teams.
• Configured Oracle Hyperion, connecting to Active Directory, eliminating need for user administration of passwords.
• Formed new support group and training associates on performance of migrations and administrative support of; Clarity, Confluence, HiAffintiy, PeopleSoft, Magic, Contributor, and Kronos, driving optimal support of Level 2&3 of enterprise applications.
• HiAffinity designed on OpenEdge Progress as a utility program, we supported with implementing vendor and developer provided code for the Billing department, utilizing both the desktop install and the server install for modifying configuration.
• Designed SSAS and MS BI reports giving stats about the above software.

Confidential

Network Administrator / Programmer

Responsibilities:

• Troubleshoot networks connecting Internet and computers, operating systems and devices
• Analyze and teach the use of programs such as; FrontPage, DreamWeaver, MS Access, Excel, etc.
• Debug ASP and Java Script and VB for websites

Confidential , Kansas City, MO

Network Administrator / Programmer

Responsibilities:

• Researched both existing and new systems. Analyzed migration issues and identified programming Visual Basic for data migration, reducing need to rekey documents.
• Ensured 90% of data files were moved from Keyfile to AS/400 by training programmer on usage of Visual Basic and coordinating exportation / importation of data between departments, eliminating external consulting fees of $10K.
• Monitored firewall and anti-virus logs, identifying potential areas of vulnerability and applying latest patches on computer systems, which prevented 3 known attacks and maintained 100% external threat protection, resulting in disaster recovery plan that saved company from lost production time and maintained perimeter and internal security.
• Setup IIS, Exchange, Proxy and Windows servers then converted Novel Netware to Windows over TCP/IP.
• Built websites on AS400 and Internet Information Server with skill in HTML and VBScript and JScript.
• Built MS Access application to track paperwork more efficiently than using inner office mail alone.
• Designed and developed and customized software using VB6 and MS Access 2000 with heavy use of SQL and some Win / Win32 API and calls to other scripts or executables.
• Webmaster on IIS and AS400 HTTP, with script programming in FrontPage, VB, ASP, Apache and Net.Data.
• Setting up an AS/400 for TCP/IP, IBM HTTP (Web) and SMTP/POP3 (Email).
• Creating and debugging on an AS/400 with web pages, server side scripts (macros) and changing routes.
• Windows 2003 Administrator, Windows NT4 Administrator, Novell 3.11 Administrator.
• Managing User Accounts and Services on Novel, Microsoft Windows and AS/400 (IBM iSeries).
• Configuring Active Directory connector between Exchange 5 running on Win2000 to AD on Windows 2003.
• Changed routes in Cisco and Intel for VPN, LAN/WAN connections, TCP/IP networking protocol.
• Migrating Token-Ring to Ethernet and expanding the network by configuring Hubs and Switches and Routers.
• Training others in how to program or to operate the program or to do daily tasks.
• Troubleshooting applications like Spreadsheets, Email, Presentations and more on both MS Office and Corel.
• Debugging software programming, analyzing team members source code in RPG, C/C++, VB, HTML, and Java.
• Writing applications in MS Access databases such as; inventory, production count and travel agent itinerary.
• Creating data conversion programs, interface assist programs, and backend programs to Word or MS Access.
• Using SQL and ODBC connections in MS Access, VB, and Excel to databases on the AS/400.
• Creating programs that will update a website for the company email/phone directory or track all the computers in the building, saving either XML/HTML, Text/CSV or MSAccess formats.
• Building websites using FrontPage or HTML or server side scripts such as Net.Data to display dynamic web pages.
• Administering desktops by creating logon scripts that use DOS Batch and VB programs with system calls.
• Analyzing Java and Active Server Page scripts to enhance web pages, debugging HTML and XML.
• Acted as liaison to IT department with hardware and software recommendations for improvements.