TECHNICAL SKILLS:

SQL, PL/SQL, T: SQL, UNIX Shell Scripting (ksh, bash, csh), Perl, Python, Regular Expressions (Regex), Windows Batch and Powershell, Java, JSP, HTML, JavaScript

APPLICATIONS AND TECHNOLOGIES: Splunk, Splunk Dashboarding, Splunk Administration, Oracle 9i/10g, Oracle SQL Loader, Oracle SQL Developer, Apache Jmeter, SQL Server 2008/2008 R2, SQL Server Business Intelligence Development Studio, Mobile Applications iOS and Android, XML, JSON, JIRA, Apache - Tomcat, J2EE, JBoss, Oracle Warehouse Builder, CA Unicenter Asset Management, CA Wily, HP Discovery and Dependency Mapping Inventory, Microsoft Excel, Access, Word, NetIQ Operations Center

OPERATING SYSTEMS: Microsoft Windows XP/Vista/7/8/Server 2008/Server 2008 R2,), Linux (Red-Hat Enterprise, Ubuntu), VMWare, UNIX (Solaris, HP-UX, AIX)

PROFESSIONAL EXPERIENCE:

Application Support Analyst / Splunk Administrator

Confidential

• Primary Role was 24x7 production support for multiple customer facing mobile applications (My Confidential ) with 10+ million users.
• Secondary Role was Administration of Splunk Cluster with 100+ user base. Our Splunk installation is configured for 200+ hosts and 1000+ JVM’s (log4j) for consolidated monitoring.
• Administrative duties included adding user accounts to Splunk, configuring of multiple Splunk indexes for new data sources and configuring new forwarders for new hosts adding to Splunk.
• Performed major upgrade of Splunk Enterprise to version 7.0. Included upgrading all search head hosts and indexers.
• Analyzed Alerts, Reports, and database logs via Splunk for critical defect analysis to multiple development teams in Confidential, and for troubleshooting user issues reported via tickets
• Wrote custom Splunk alerts and reports for the purpose of decreasing response times for critical errors and reporting to the proper development and executive teams. Used custom Splunk lookup tables for more granular alerting and custom thresholds.
• Developed the use of custom fields and variables through Splunk regex for customized reporting parameters.
• Used and developed Splunk dashboards to show executive feedback during new app launches or for new product launches (i.e. Apple iPhone launch)
• Wrote and modified automatic Apache Jmeter scripts that stress tested critical URL and web services for any production issues that can occur after major change controls. Testing scripts were written in the perl language that used a Jmeter instance on Linux.
• Troubleshot various individual user cases through our ticketing system time permitting. Used log tracking through Splunk as well as logging via database tables.
• Joined many crisis management conferences and verified that our applications are functioning properly after crisis resolution.
• On call support with a weekly rotating schedule. During on call support provided early morning health checks for our applications and daily reports on app ratings and reviews.
• Additional change control support for overnight network and host maintenance. Required full health and traffic checks to ensure our applications were running well.
• Modified our reporting scripts that used SQL Plus to counts of various metrics and email them to our stakeholders. These reports primarily were written in bash, ksh, and Python.

Consultant

Confidential

• Primary Roles were application analyst for frontend and backend services within Confidential Corporation.
• Applied and detailed low level network and application testing for PCI compliance effort within Confidential . Wrote Linux and Windows script to test network connections to many servers and ports.
• Monitored and analyzed various network and performance data with the Splunk tool.
• Deployed releases and provided maintenance support for high throughput web applications.
• Created and modified job schedules and scripts within UC4 Application Manger (Appworx) utility.
• Renewed and installed website certificates in support of continued operations.
• Updated and opened JIRA tickets for tracking bugs, including updates of workflow statuses.
• Provided support and troubleshooting for JBoss application server including log file parsing.

Application Analyst

Confidential

• Contributed backend troubleshooting, initial design and planning, development assistance, and integration for NetIQ Operations Center.
• Installed the base product of NetIQ Operations Center on both Linux and Windows platforms and developed custom scripts and packages that enhanced the product or automated low level processes.
• Created Business Data Integrators that pulled data from a variety of sources including ticketing information, transaction information, alert data and various business metrics. Products that provided alert data to NetIQ Operations Center include BMC Patrol, IBM Netcool, Aternity Transaction Monitoring, AOTS Ticket Support, HP Rum, CA Introscope and many other internal tools.
• Configured and implemented a SQL Server Business Intelligence Development Studio project to import more data sources such as text files, and Microsoft Access mdb files.
• Based on incoming data, created service models that combined all data sources into a single coherent view of an application. This allowed customers to view their application as a service with many different data and alert sources.
• Created dashboard portlets to present service model data and alerts on a standard web display.
• Performed and implemented SQL Server 2000 and SQL Server 2008 cleanup, backup and recovery strategies.
• Contributed project consultationAsset Management Program, a new application designed to track server assets across the corporation.
• Installed and integrated HP Discovery and Dependency Mapping Inventory (DDMI) including system, application and database migration.
• Deployed an automated system for saving certain automated emails, processing them for storage in a SQL Server database.
• Assisted system administrators for Agent program which ran on the following operating systems: Solaris, HP-UX, AIX, Linux, and all 32-bit versions of Windows.
• Rewrote and modified CA Agent for UNIX platforms to accommodate special Confidential &T requirements. Added additional shell scripts to load, debug, and run the CA Agent.
• Wrote and maintained a custom installation script for Windows platforms that installed a custom agent and set all necessary parameters.
• Wrote special job scripts that collect extra information on the installed Agents in a special proprietary language (Desktop Management Scripting or DMS) designed by CA and are pushed to Agents from the console.
• Tracked and maintained a list of problems during the CA Agent rollout for future debugging.
• Assisted team members with Microsoft Access and Excel VBA coding to track assets.
• Wrote and maintained Visual Basic program that evaluated DLL versions versus a list of expected DLL files.
• Evaluated Unicenter product technologies and provide recommendations on configurations and procedures regarding the project rollout.

Production Support Consultant

Confidential

• Primary job duties included production and application support for Xerox web-based reporting systems.
• Delivered 7x24 coverage for applications on a rotating cycle with other team members.
• Provided support for the following web application technologies: ASP, ASP .Net, JSP, Java, J2EE, Apache Tomcat, IIS 5.0, Netscape Application Server, and Crystal Reports.
• Troubleshot, and supported the following database technologies: Oracle 8i/9i, SQL Server 2000, SQL, PL/SQL, SQL DTS.
• Provided system level administration and hardware troubleshooting Intel Server class machines and Windows 2000 application servers.
• Developed and delivered Oracle PL/SQL, and UNIX shell-scripting code according to specific requirements.
• Debugged, wrote, and optimized Oracle SQL Loader scripts written in on UNIX Solaris platform.
• Created Visual Basic 6.0 utility to replace legacy Access 97 reporting system.
• Provided estimation of effort hours for Visual Basic 6.0 and Oracle PL/SQL enhancement projects.
• Rewrote and recompiled Java classes for several web reporting applications.
• Built and tested Windows 2000 and SQL Server 2000 application servers for server upgrade projects.
• Test piloted new Windows XP client image for nationwide Xerox release.
• Rewrote Visual Basic and Wise Installation Scripts for a supported desktop application.
• Assisted with the training of junior level production support members.
• Develop and support processes to enhance production support efforts and reduce support times.
• Promoted releases to production environments created by the development teams and assist in the debugging of the code.
• Provided consultation regarding retirement and upgrades of Xerox legacy systems.
• Wrote detailed documentation on production support processes for ease of transferability.