SUMMARY

• Over 7 years of experience in Information Technology field with strong experience as Splunk Developer/Administrator, Business Intelligence and Data Warehousing associated projects.
• Expertise in Actuate Reporting, development, deployment, management and performance tuning of Actuate reports.
• Prepared, arranged and tested Splunk search strings and operational strings.
• Created and configured management reports and dashboards.
• Worked on large datasets to generate insights by using Splunk.
• Experience developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis.
• Worked as Splunk developer to setup splunk app for a critical new launch.
• Having Good experience on SIEM ( Security Information Event Management )
• Worked on setup of various dashboards, reports and alerts in splunk.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• Experience in developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis
• Have Knowledge in various search commands like stats, chart, time chart, transaction, strptime, strftime,eval, where, xyseries,table etc and difference between event stats and stats.
• Having experience in understanding of Splunk 5.x and 6.x product, Distributed Splunk architecture and components includingsearch heads, indexers, forwarders, etc;
• Experience in Extraction on Search time vs. Index time field extraction.
• Good Understanding of configuration files, precedence and daily work exposure to Props.conf, transforms.conf, inputs.conf,outputs.conf and Setting up a forwarder information based on requirement.
• Maintenance of Splunk Environment with multiple Indexers.
• Create event type definitions.
• Set indexing property configurations, including time zone offset, custom source type rules, Configure Regextransformations to perform on data inputs. Use in tandem with props.conf.
• Experience in Operational Intelligence using Splunk.
• Knowledge about Splunk architecture and various components indexer, forwarder, search head, deployment server, Heavy and Universal forwarder, License model.
• Time chart attributes such as span, bins, Tag, Event types, Creating dashboards, reports using XML. Create dashboard from search, Scheduled searches Inline search vs. scheduled search in a dashboard
• 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.
• Experience in some basic development of coding in VB.NET, C# while working with SSIS.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent, FTP,SFTP and SMTP.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Solid experience in Replication Services, Database mirroring and Log shipping to ensure high availability and up time.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Expert in performing various SSIS data transformation tasks like Derived Column, Data conversion, Merge, Bulk Insert, Data Mining, Look - ups, Fuzzy Look-ups, OLEDB Command and Conditional Split.
• Excellent communication, analytical and interpersonal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
• Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities.

TECHNICAL SKILLS

Tools: Splunk 6.3.2/1, Splunk Enterprise 5.0, SSIS, SSRS, SIEM, CISSP

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2008R2, 2008, 2005, Oracle, SAP, Siebel, Microsoft Office 2007/2003, MS-Access.

Language: C, Java, Ruby, Bash, Python, XML,TSQL,VB.NET,C#

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

Tools: Erwin Data Modeler, MS Visio, Business Objects, Microsoft office 2003/2007, LANDesk

Architecture: Relational DBMS, Client-Server Architecture, OLAP, MOLAP, ROLAP, HOLAP,OLTP

PROFESSIONAL EXPERIENCE

Confidential, Columbus- OH

Splunk Developer / Admin

Responsibilities:

• Getting data and Managing Splunk apps.
• Data inputs in detail, Index administration, maintenance and optimization
• Manipulating raw data and Field extraction
• Involved in standardizing Splunk forwarder deployment, configuration and maintenance across UNIX and Windows platforms.
• Distributed search and Search performance tuning
• Worked on SIEM ( Security Information event management ).
• Created Dashboards, report, scheduled searches and alerts.
• ConfigureSplunkfor all the mission critical applications and usingSplunkeffectively for Application troubleshooting and monitoring post go lives.
• Created many of the proof-of-concept dashboards for IT operations, and service owners which are used to monitor application and server health.
• Use techniques to optimize searches for better performance, Search time vs Index time field extraction. And understanding of configuration files, precedence and working.
• Introduction to large-scale Splunk deployment
• Monitoring and troubleshooting
• Ingesting logs to geologically distributed Splunk infrastructure.
• Very Good experience on Splunk Search Language and Regular expressions.
• Experience in developing dashboards and customizing them.
• Installation and implementation of several kind of visualizations to Splunk Dashboards.
• Good knowledge about Indexer and Search head clustering.
• DesignedSplunkEnterprise Server 6.2 infrastructure to provide high availability by configuring clusters across two different data centers.
• Responsible for administering, maintaining and configuring a 24 x 7 highly available, Splunk apps for production portal environment.
• Doing deeper analysis of data using event correlations across indexes and various source types to generate custom reports for senior management.
• Additional responsibilities include Knowledge management, Providing KTs, Documentation and communications on future upgrades

Environment: SPLUNK 6.3.2, Linux, Unix, Oracle 11g, MS SQL Server 2012.

Confidential, Detroit-Mi

Splunk Developer / Admin

Responsibilities:

• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Created Dashboards, report, scheduled searches and alerts.
• Integrated ServiceNow with Splunk to generate the Incidents from Splunk
• Worked on DB Connect configuration for Oracle, MySQL and MSSQL.
• Created many of the proof-of-concept dashboards for IT operations, and service owners which are used to monitor application and server health.
• Knowledge about Splunk architecture and various components like indexer, forwarder, search head, deployment server, Heavy and Universal forwarder, License model.
• Involved in standardizing Splunk forwarder deployment, configuration and maintenance across UNIX and Windows platforms.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• 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
• Use techniques to optimize searches for better performance, Search time vs Index time field extraction. And understanding of configuration files, precedence and working.
• Create dashboard from search, Scheduled searches, Inline search vs. scheduled search in a dashboard.
• Efficiently handled Work Load Management for load balancing and failover, improving performance, reliability and scalability.

Environment: Linux RHEL, Splunk 6.1.5/6.0, Splunk Universal forwarder.

Confidential, PARAMUS, NJ

Splunk Developer

Responsibilities:

• Worked on Splunk search processing language, Splunk dashboards and Splunk dbconnect app.
• Involved in the requirement gathering and analysis. Interacted with team members and Business users during the design and development of the application.
• Worked on developing internal we application Employee Ideal Portal using JAVA, JSP and Spring Framework
• Experience in consuming REST and SOAP Web services.
• Experience in using JSON and XML formats.
• Wrote PL/SQL and Splunk queries.
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• 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
• Use techniques to optimize searches for better performance, Search time vs. Index time field extraction. And understanding of configuration files, precedence and working.
• Dashboards were created to monitor the traffic volume across, response times, Errors, Warnings across.
• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Work closely with Application Teams to create newSplunkdashboards for Operation teams.
• Create dashboard from search, Scheduled searches o Inline search vs. scheduled search in a dashboard.

Environment: SPLUNK 6.0.1, Linux, Unix, Oracle 11g, MS SQL Server 2010.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• Enforcing business rules with triggers and user defined functions, troubleshooting, and replication.
• Writing the Stored Procedures, checking the code for efficiency.
• Maintenance and Correction of Transact Sequel Server (T-SQL) Statements.
• Daily Monitoring of the Database Performance and network issues.
• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• SQL Authentication
• Rebuilding indexes on various tables.
• Preparing Test Cases and performing Unit Testing.
• Prepared SQL Queries to validate the data in both source and target databases.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Review of Unit and Integration test cases.
• Production Implementation and Post Production Support.

Environment: MS SQL Server 6.5, SQL Server 7, MS SQL Server 2000