SUMMARY:

• Over 6+ 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.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• Knowledge of Extract keyword, sed, Knowledge objects, Knowledge of various search commands like stats, chart, time chart, transaction, strptime, strftime, eval, where, xyseries, table etc. Difference between event stats and stats.
• 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.
• 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
• 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.
• Business Activity Monitoring (BAM) concepts such as IBM
• 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.
• 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.
• Had experience in working in different environments and also with the process flows in AGILE as well as Waterfall methodologies.

TECHNICAL SKILLS:

Data Warehousing: SQL Server Management Studio (SSMS), Enterprise Manager, Query Analyzer, SQL Profiler, SQL Server Data Tools, SSIS, SSAS, SSRS, Data Transformation Services, SQL*Plus

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT-Dimensions), Conceptual Physical and Logical Data Modeling, ER Models, OLAP, OLTP concepts

Databases: Oracle … MS SQL Server … MS Access.

Programming: SQL, PL/SQL, SQL Plus, Unix Shell Scripting, C

Environment: Win … Unix.

PROFESSIONAL EXPERIENCE

Splunk Developer

Confidential, Dallas, TX

Responsibilities:

• Prepared, arranged and tested Splunk search strings and operational strings.
• Created Dashboards, report, scheduled searches and alerts.
• Involved in standardizing Splunk forwarder deployment, configuration and maintenance across UNIX and Windows platforms.
• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Experience in Extraction on Search time vs Index time field extraction.
• Designed core scripts to automate Splunk maintenance and alerting tasks.
• 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 the requirement.
• Analyzed security based events, risks and reporting instances.
• Developing custom web application solutions for internal ticket metrics reporting.
• 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.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Worked on DB Connect configuration for Oracle, MySQL and MSSQL.
• 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 to Inline search vs scheduled search in a dashboard

Environment: SPLUNK 6.0.2, Linux, Informatica Power Center 9.5/9.1, Power Exchange 9.5, Oracle 11g, MS SQL Server 2012, SQL.

Splunk Developer

Confidential, Chicago, IL

Responsibilities:

• Expertise with Splunk UI/GUI development and operations roles.
• Prepared, arranged and tested Splunk search strings and operational strings.
• Helped the client to setup alerts for different type of errors.
• Played a major role in understanding the logs, server data and brought a insight of the data for the users.
• Involved in setting up alerts for different type of errors.
• Analyzed security based events, risks and reporting instances
• Prepared, arranged and tested Splunk search strings and operational strings.
• Developed, evaluated and documented specific metrics for management purpose.
• Using SPL created Visualizations to get the value out of data
• Created Dashboards for various types of business users in organization.
• Provided technical services to projects, user requests and data queries.
• Involved in assisting offshore members to understand the use case of business.
• Assisted internal users of Splunk in designing and maintaining production - quality dashboard
• Used Datameer to analyze the transaction data for the client.
• Installed, configured and managed Datameer users on the Hadoop cluster.
• Involved in writing complex IFX, rex and Multikv command to extracts the fields from the log files.
• Involved in helping the Unix and Splunk administrators to deploy Splunk across the UNIX and windows environment.
• Worked with administrators to ensure Splunk is actively and accurately running and monitoring on the current infrastructure implementation.
• Involved in installing and using Splunk app for Linux and Unix.

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

SQL Server Developer

Confidential

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

SQL Server Developer/DBA

Confidential

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