SUMMARY:

• Over 8+ years of experience in the Information Technology field with strong emphasis in Splunk, Business Intelligence (BI) and Data Warehousing (DW) associated projects.
• Expert in Splunk Development, Configuration and Administration
• Engineered Splunk to build, configure and maintain heterogeneous environments and in - depth knowledge of log analysis generated by various systems including security products
• Expertise in Actuate Reporting, development, deployment, management and performance tuning of Actuate reports.
• Scripting and development skills (Perl, Python, Java) with strong knowledge of regular expressions.
• Used techniques to optimize searches for better performance, Search time vs Index time field extraction and understanding of configuration files, precedence and working Props.conf, transforms.conf, inputs.conf, outputs.conf setting up a forwarder Monitor stanza in inputs.conf.
• Prepared, arranged and tested Splunk search strings and operational strings.
• Created and configured management reports and dashboards.
• Experience with Nagios, Graphite, Sensu or similar monitoring/graphing solutions
• 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 anddifference 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 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.
• Over 5+ years of experience in SSAS (SQL Server Analysis Services) in SQL 2005 and SQL 2008.
• 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.
• Expertise in installing, configuring, managing, upgrading, monitoring and troubleshooting SQL Server
• Splunk can be used as monitoring, SIEM reporting tool
• Hands on experience with ruby and rails.
• 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.
• Strong background in a disciplined software development life cycle (SDLC).
• 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.
• Hands on experience with python scripting, JSP, HTML5, CSS5, XML, JSON, JQuery.
• Hands on experience in developing Android applications.

TECHNICAL SKILLS:

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#, PYTHON, PERL, Android Programming.

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, Richardson, TX

Senior Splunk Engineer

Responsibilities:

• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Helped teams on-board data, create various knowledge objects, install and maintain the SplunkApps, TAs and good knowledge on javascript for advance UI as well Python for advance backend integrations
• Created Dashboards, report, scheduled searches and alerts.
• Have involved as a Splunk Admin in capturing, analyzing and monitoring front end and middle ware applications.
• Uses reduction in a wide range of applications, including distributed pattern-based searching, distributed sorting, web link-graph reversal, Singular Value Decomposition, web access log stats,inverted indexconstruction,document clustering,machine learning, andstatistical machine translation.
• Hands on experience with Splunk Monitoring tools like Graphite, Sensu
• Prepared, arranged and tested SPLUNKsearchstrings and operationalstrings.
• Analyzed security based events, risks, aws and Siem reporting instances.
• Various types of chartsAlert settings Knowledge of app creation, user and role access permissions. Creating and managing app, Create user, role, Permissions to knowledge objects.
• Parsing, Indexing, Searchingconcepts Hot, Warm, Cold, Frozenbucketing.
• Experience with of AWS (Amazon Web Serviced) and other web services platforms
• Involved in standardizing Splunk forwarder deployment, configuration and maintenance across UNIX and Windows platforms.
• Worked on setting up Splunk to capture and analyze data from various layers LoadBalancers, Webservers and applicationservers.
• Captured data from various front end, middle ware application
• 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.
• 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.
• Analyzed large datasets to identify metrics, drivers, performancegaps and opportunities for improvement.
• Use techniques to optimize searches for better performance, Searchtime vs Indextime field extraction and understanding of configuration files, precedence and working.

Environment: SPLUNK 6.0.1, Linux, UNIX, Oracle 11g, MS SQL Server 2012, SQL.

Confidential, Sidney, NE

Senior Splunk Consultant

Responsibilities:

• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Created Dashboards, report, scheduled searches and alerts.
• Worked on DB Connect configuration for Oracle, MySQL and MSSQL.
• Worked on C++ and JAVA add on integrated within Splunk enterprise environment.
• 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 LINUX and Windows platforms.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Worked with AWS (Amazon Web Serviced) and other web services platforms
• 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, Stamford, CT

Splunk Developer

Responsibilities:

• Completed a full, independent review of each requirement/specifications
• 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.
• Wrote and ran UNIX shell scripts of preprocessor for certain batch and Control-M jobs across multiple environments
• Analysed security based events, risks, aws 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 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: SPLUNK 5.0, Oracle SQL, PL/SQL, DB2, CICS, Mainframe, 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.
• Mentor front end users about SQL Queries.
• 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

MS SQL Server SSIS

Responsibilities:

• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join and Sort.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extractingdata for reporting.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Made sure that standards and best practices in database development were followed and maintained.
• Maintained all records of project status and followed changes as per control procedures.
• Developed, monitored and deployed SSIS packages for data warehouse solution
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Expert in extracting and transforming data using DTS Import or Export Data, Bulk Insert, BCP and MS SQL Server Integration Services(SSIS).
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation. Set up database backup and recovery strategies.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

Environment: SQL Server 2000, MS SQL Server 2005, Php, SQL Server Integration Services, Windows XP

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