SUMMARY

• Over 7+ years of experience as a Splunk Developer, Information Technology field with strong emphasis in Business Intelligence (BI) and Data Warehousing (DW) 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.
• 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.
• 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 o 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.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Experience in database administration, design, development, testing and implementation of applications, reports and databases (MS SQL Server) in production environments and BI tools (SSIS SSRS SSAS).
• Expertise in installing, configuring, managing, upgrading, monitoring and troubleshooting SQL Server
• Experience with T - SQL in writing triggers, indexes, tables, views, data integrity, user defined functions and relational database models.
• 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.0.2/1, Splunk Enterprise 5.0, SSIS, SSRS

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, C++, XML,TSQL,VB.NET,C#

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

Tools: MS Visio, Microsoft office 2003/2007

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

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

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 (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.
• Perform installation, configuration management, license management, data integration, data transformation, field extraction, event parsing, data preview, and Apps management of Splunk platform
• Troubleshoot Splunk indexers, search heads and forwarder problems
• Build, customize and deploy Splunk apps as per internal customer needs
• Create data retention policies and perform index administration, maintenance and optimization
• Create role based access and SAML based SSO authentication for Splunk
• Create and maintain architectural diagrams and other relevant documentations for the Splunk platform
• Assist internal users of Splunk in designing and maintaining production quality dashboards
• 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 o Inline search vs scheduled search in a dashboard

Environment: Splunk 6.0, Pivotal HD, Datameer, Linux, Bash, Perl, Hbase, Hive, Pig, Hawq, Sed, rex, erex, Splunk Knowledge Objects

Confidential, Columbus, OH

Splunk Developer

Responsibilities:

• Completed a full, independent review of each requirement/specifications
• Determined the logic, and test cases need to created in order to verify the functionality for dashboard regarding health care claims submitted.
• Splunk Engineer/Dashboard Developer responsible for the end-to-end event monitoring infrastructure of business-aligned applications.
• Experience in setting up dashboards for senior management and production support- required to use SPLUNK.
• Develop design of application and Dashboards.
• Provide regular support guidance to Splunk project teams on complex solution and issue resolution WITH the objective of ensuring best fit and high quality.
• Provide inputs for identifying best fit architectural solutions - deployment for Splunk project.
• Hands on SPUNK saved searches, regex functions & complex queries
• Analyzed FACETS for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition and Premium Rate Tables.
• Analysed security based events, risks and reporting instances.
• Set up of splunk dashboards for continuous monitoring for production support
• Test Treat web application components for functionality, regression, integration and end-to-end system stability on various test environments and browsers.
• Write automation scripts for APIs, Unit and functional test cases using Selenium WebDriver.
• Write automation scripts for REST API’s using TestNG and Java.
• Enhance the existing scripts for better test coverage.
• Report and maintain the stories, tasks, acceptance criteria and bugs in the test management system Quality Center (ALM)
• Involved in testing FACETS for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition and Premium Rate Tables.

Environment: Oracle SQL, PL/SQL, DB2, CICS, Mainframe, SPLUNK, Selenium Web Driver, REST API.

Confidential, Madison, WI

SQL Server Developer

Responsibilities:

• Collected the user and system requirements and write technical specifications.
• Actively involved in Normalization & De-normalization of database.
• Designed and developed a Front Office database system.
• Create tables, Views, Clustered & Non-Clustered Index, user defined data types, and user definedFunctions
• Create Joins and Sub-Queries for complex queries involving multiple tables.
• Involved in Administration of the SQL Server by creating Users & Login ids with appropriate
• Roles & grant privileges to users and roles.
• Created & used stored procedures for database transactions in SQL Server
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL Queries and Stored Procedures
• Created automatically running Stored Procedures and Triggers
• Create and customize DTS packages and used DTS to load data from difference sources.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance ofDatabase servers
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Environment: Windows 2000 Advanced Server, MS SQL Server 2005, MS Outlook, TSQL, Erwin, ETL and DTS.

Confidential

.Net Developer

Responsibilities:

• Extensively used object oriented concepts for C# code reusability.
• Developed the business components class libraries in C#.
• Extensively used text reader and writer class functionalities.
• Involved in debugging C# code. Performed unit testing and participated in integrated testing.
• Provided post-development system support for staging and production environment.
• Created database objects using SQL Server including complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in UI Designing, Development and Testing of Web Forms using ASP.Net, C#, XML ADO.Netand .NETFramework.
• Implemented interfaces in C# which encapsulate business logic and call them from web forms.
• Implemented Exception Handling, Logging and Validation of incoming requests.
• Documented the modules developed front-end screens.

Environment: .Net2.0, C#.NET, Windows Service, JavaScript, HTML, IIS, Microsoft Visual Studio 2005

Confidential

SQL Server Developer

Responsibilities:

• Responsible for the study and analysis of the systems design and implementation.
• Responsible for installation and configuration of MS SQL Server 2000 for development purposes.
• Created various database objects including tables, stored procedures and functions.
• Involved in tuning the existing T-SQL code for performance improvement.
• Followed the best practices in writing T-SQL for universal readability and reusability of code.
• Interacted with analysts and other developers in understanding and identifying the business requirements.
• Created stored procedures to hold the business logic.
• Created views as per client requests.

Environment: MS SQL Server 2000, DTS, T-SQL