SUMMARY:

• Result - driven IT Professional with 8+ years of experience in Splunk solution design, architect, deployment and configuration Splunk components (forwarders, indexers, search heads etc.) & development (creation of dashboards/reports, alerts and Splunk integration).
• Highly skilled in tier Splunk installation, Indexer, Intermediate, Heavy forwarder, Search heads, UFs and apps.
• Expert in actuate reporting, development, deployment, management and performance tuning of actuate reports.
• Excelled in modifying the Configuration files in Splunk such as props.conf, Transforms.conf, Output.conf and inputs.conf according to the requirements.
• Expertise with the usage of various search commands like stats, chart, time chart, transaction, strptime, strftime, eval, where, table etc.
• Proficient in setting up Splunk forwarder agents across different OS platforms to capture the data.
• Good knowledge in setting up the receiving environment using Splunk heavy forwarder component and indexer.
• Experience in optimizing searches for better performance, Search time vs. Index time field extraction and understanding of configuration files, precedence and working.
• Strong Knowledge in Objects such as Event Types, Tags, Field Extraction (Using Regular Expression) and Lookups etc.
• Skilled in write, use and understand of complex regular expressions and good knowledge in scripting and development.
• Experience in generating visualizations of reports, dashboards for alerting, roles/user provisioning and clustering with Splunk and creating Visualizing report results as interactive line, bar, column, pie, scatterplot and heat-map charts as per the business requirements.
• Experience in Developing Splunk Dashboards to capture and track the Application activities using Simple XML language.
• Skilled in creating & managing Splunk App’s, Splunk Add-on’s, Splunk DB connections, Database connection, Lookup’s, Output’s.
• Good knowledge in customizing Splunk Apps and dashboards, built advanced visualizations, configurations, Reports and search capabilities .
• Versatile team player and self-starter with s trong analytic, writing, communication skills and quick learner with ability to work independently and as part of a team.

TECHNICAL COMPETENCIES:

Splunk Modules: Splunk 5.x/6.x, Splunk Cloud, Splunk DB Connect, Splunk Enterprise, Splunk IT Service Intelligence, Splunk Web Framework, Splunk Machine Learning Toolkit

Operating Systems: Red Hat Linux 4.x/5.x/6.x, Windows 2000/2003/XP

RDBMS: Oracle 10g/9i/8i, MS-SQL Server 2000/2005/2008/ R2/2012

Languages: C, LINUX Shell scripts, Python, SQL, Oracle

Tools: Splunk, Java, SQL, T-SQL

Web Tools & Languages: Java Script, Servlets, python, XML, HTML, CSS

Application Servers: Server 8.x./9.x/10.x, Apache Tomcat, Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Splunk Admin / Developer

Responsibilities:

• Involved in accessing and normalizing data from multiple sources to Splunk indexer.
• Gathering various sources of syslog and XML data from devices, applications, and data bases.
• Perform daily health checks and maintain integrity of production environment by proactively resolving services impacting incidents.
• Setup Splunk Forwarders for new application tiers introduced into environment and existing application.
• Work closely with Application Teams to create new Splunk dashboards for Operation teams.
• Identify pattern and trends that are indicators of routine problems.
• Troubleshooting and resolve the Splunk - performance, log monitoring issues; role mapping, dashboard creation etc.
• Optimized Splunk for peak performance by splitting Splunk indexing and search activities across different machines.
• Used Search Processing Language (SPL) created Visualizations to get the value out of data.
• Worked with administrators to ensure Splunk is actively and accurately running and monitoring on the current infrastructure implementation.
• Interacted with the data warehousing team regarding extracting the data and suggest the standard data format such that Splunk will identify most of the fields
• Managed Indexer Clusters including security, hot and cold bucket management and retention policies.
• Created EVAL Functions where necessary to create new field during search run time.
• Used Ifx, Rex and Regex commands for field extraction.
• Configured Splunk Searching and Reporting modules, Knowledge Objects, Administration, Regex, Dashboards, Clustering and Forwarder Management.
• Involved in writing complex IFX, rex and Multikv command to extracts the fields from the log files.
• Create Dashboard, Reports and Alerts for events and configure alert mail.

Environment: Splunk 6.x, Linux, UNIX, Oracle 11g, MS SQL Server 2012, SQL, XML, Java Script, MS Excel, MS Power Point

Confidential, Los Angeles, CA

Splunk Admin/ Developer

Responsibilities:

• Installation of Splunk Enterprise, Splunk forwarders’, Splunk Indexer, Apps in multiple servers (Windows and Linux) with automation.
• Install and maintain the Splunk adds-on including the DB Connect, Active Directory LDAP for work with directory and SQL database.
• Manage Splunk configuration files like inputs, props, transforms, and lookups.
• Deploy, configure and maintain Splunk forwarder in different platforms.
• Ensuring that the application website is up and available to the users.
• Continuous monitoring of the alerts received through mails to check if all the application servers and web servers are up.
• Create Splunk Search Processing Language (SPL) queries, Reports, Alerts and Dashboards.
• Problem record analysis and solution providing.
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• Creating Reports, Pivots, alerts, advance Splunk search and Visualization in Splunk enterprise.
• Provide power, admin access for the users and restrict their permission on files.
• Installed, tested and deployed monitoring solutions with Splunk services.
• Provided technical services to projects, user requests and data queries.
• Implemented forwarder configuration, search heads and indexing.
• Assisted in auditing through Splunk SME knowledge.
• Supported data source configurations and change management processes.
• Maintained and managed assigned systems, Splunk related issues and administrators.
• Performed Splunk administration tasks such as installing, configuring, monitoring and tuning.
• Active monitoring of Jobs through alert tools and responding with certain action w.r.t to logs, analyses the logs and escalate to high level teams on critical issues.
• Worked on log parsing, complex Splunk searches, including external table lookups.
• Designing and maintaining production-quality Splunk dashboards.
• Splunk configuration that involves different web application and batch, create Saved search and summary search, summary indexes.
• Deployed applications on multiple WebLogic Servers and maintained Load balancing, High availability and Fail over functionality.
• Involved in monitoring the ticketing tool and taking the ownership of the tickets.
• Developed build scripts, UNIX shell scripts and auto deployment processes.

Environment: Splunk 6.x, Linux, UNIX, Oracle 11g, MS SQL Server 2012, SQL, XML, Java Script, MS Excel, MS Power Point

Confidential, Bloomington, IL

Splunk Developer

Responsibilities:

• Create Dashboard Views, Reports. lookups and Alerts for events and configure alert mail
• Create Splunk apps for consuming data for applications and implement apps.
• Involved in setting up alerts for different type of errors.
• Fetching the data from databases using "DB Connect Application
• Customizing, visualizations, configurations, reports and search capabilities using customized Splunk queries.
• Created Regular Expressions for Field Extractions and Field Transformations in Splunk
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files
• Worked on data model relationships in underlying raw data and making it more meaningful and useful to quickly generate charts, visuals and dashboards using pivot.
• Analyzing massive amount of real time data in Hadoop using Splunk enterprise operational intelligence.
• Worked on Actuate Reporting, development, deployment, management and performance tuning of Actuate reports (various types of charts Alert settings Knowledge of app creation, user and role access permissions).
• Creating and managing app, Create user, role, Permissions to knowledge objects.

Environment: Splunk, Universal Splunk Forwarder, RedHat Linux, Oracle, HTML, Perl, Java Script, XML, rex, Splunk Knowledge Objects

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Planned, defined and designed data based on business requirement and provided documentation for all kinds of reports, DTS and SSIS packages for further reference.
• Developed SSIS Packages using Look up Values implementing rules provided by business in the mapping document.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Generated parameterized reports, sub reports, Drill down reports, Drill through reports using SSRS.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Environment: T-SQL, MS SQL Server 2012, SQL Server Reporting Services, SQL Server Integration Services, SQL Server DTS, SQL Server Management Studio, Business Intelligence Studio, Query Analyzer, SQL Profiler, Performance Monitor, MS Visio, Windows, ERwin

Confidential

SQL Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2008 to SQL Server 2012 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services SSAS.
• Created business critical KPIs using MS SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: T-SQL, MS SQL Server 2008, Crystal Reports, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Management Studio, SQL Profiler, Performance Monitor, SQL Server Agent, MS Visio, Windows, ERwin

Confidential

SQL Developer

Responsibilities:

• Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.
• Troubleshoot the existing PL/SQL procedures, functions, triggers
• Stored Procedures and Triggers were developed for Business rules.
• Involved in writing procedural scripts using PL/SQL.
• Analyzing tables and indexes for performance tuning
• Involved in coding and testing of the system.
• Effectively resolved QA Trackers.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Improved query performance by query optimization - tracing the query execution plan (explain plan).
• Created indexes for better performance.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Involved in PL/SQL code review and modification for the development of new requirements.

Environment: Oracle 8i, PL/SQL, Windows NT, Linux, VSS