SUMMARY

• Around 7 years of experience in Information Technology field with strong experience as Splunk developer/admin, Software Analysis, Design and Development for various software applications in providing Business Intelligence Solutions in Data Warehousing for decision Support Systems, and Database Application Development.
• Experience in Operational Intelligence using Splunk 6.x, Splunk 5.x.
• Expert in Extracting, Transforming, Analyzing, Visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and C - level executives to take informed action.
• Installed and configured syslog-ng server for receiving logs form Cisco, Netscaler devices and forwarding logs to Splunk indexer.
• Parsing, Indexing, Searching concepts of Hot, Warm, Cold, Frozen bucketing.
• Investigated and escalated potential security incidents in a SIEM environment.
• Good experience in all facets of SDLC viz. requirement analysis, designs, development, testing, and post implementation revisions.
• Good knowledge about Splunk architecture and various components (indexer, forwarder, search heads, deployment server), Heavy and Universal forwarder, License model.
• Expertise in Preparing, arranging and testing the Splunk search strings and operational strings.
• Worked on large datasets to generate insights by using Splunk.
• Extensive experience in deploying, configuring, and administering Splunk Clusters.
• Experience in developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis.
• Assigning Splunk User and role authentication including LDAP authentication and scripted authentication.
• Created data models using Pivot tables in Splunk, after mining data and extracting key information for capacity planning purposes.
• Setup Splunk Forwarders for new application levels brought into environment.
• Experience in working with Splunk authentication and permissions and having significant experience in supporting large scale Splunk deployments.
• Expert in installing SPLUNK apps for Linux and UNIX environments.
• Knowledge on Configuration files in Splunk (props.conf, transforms.conf, inputs.conf, output.conf).
• Experience in Big Data and familiar with components of Hadoop Ecosystem: HDFS, HAWQ, Hive, HBase, Pig. Expertise in Hadoop Application Development.
• Extensive knowledge in creating Actuate reports using XML, Dashboards, visualization and pivot tables for the business users.
• Maintenance and Correction of Transact Sequel Server (T-SQL) Statements.
• Experience with T-SQL in writing triggers, indexes, tables, views, data integrity, user defined functions and relational database models.
• Experience with configuration management using tools such as Puppet, Chef, etc.
• Extensive experience in Data Warehouse, Data mart, Data Integration and Data Conversion projects ETL using Informatica Power Center 9.5/8.x/7.x/6.2/5.0 tools (Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Designer, Repository Manager, and Server Manager) as ETL tool on Oracle /DB2 Database.
• Extensive experience in writing Packages, Stored Procedures, Functions and Database Triggers using PL / SQL and UNIX Shell scripts. Also handled Oracle utilities like SQL Loader, import etc.
• Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model), and Data Warehousing (ETL).
• Knowledge on service oriented architecture (SOA), workflows and web services using XML, SOAP, and WSDL.
• Expertise in RDBMS like Oracle, MS SQL Server, MySQL and DB2.
• Experienced in Various BI Tools like Qlikview, Tableau and SSRS for designing customized interactive and advanced rich visualization dashboards using different connectors, extensions, marks, Action, filters, parameter, calculations and Relationships.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, Ability to adapt, learn new technologies and get proficient in them very quickly.

TECHNICAL SKILLS

Programming Languages: C, C++, Java SQl, Python, Bash, Ruby, PL/SQL, TSQL, Grok, R, Mapreduce

Web Technologies: HTML, CSS, JavaScript, XML, VB Script, UNIX Shell Script, SOAP, Hadoop and MVC

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008/2005/2000 , Sybase, DB2 MS Access

Operating Systems: Windows XP/Vista/7,8,10, MS DOS, UNIX, LINUX, SOLARIS, AIX

Tools: SPLUNK 6.3, 6.2, 5.x, QlikView, Tableau, OBIEE, SAP Business Objects, SSRS, SSIS.

Data Warehousing: Informatica Power Center/Power Exchange 9.5/ 9.1/8.5/8.1.1/7.1.2 , Informatica Designer, Workflow Manager, Work flow Monitor, Datamart, Mapplet, Transformations, Informatica Metadata Manager.

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, Entities, Attributes, Cardinality, CA Erwin DM (9.x/8.x/7.x)

Server: Apache, Tomcat, Glassfish

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Splunk Developer/Admin

Responsibilities:

• Experience 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. difference between event stats and stats.
• Experience in working with Splunk authentication, permissions and having significant experience in supporting large scale Splunk deployments.
• Having experience in understanding of Splunk 6.x product, Distributed Splunk architecture and components including search heads, indexers, forwarders, etc.
• Created Dashboards, report, scheduled searches and alerts.
• Resolved configuration based issues in coordination with infrastructure support teams.
• 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.
• Manage and configure index settings and created event type definitions. Analyzed security based events, risks and reporting instances.
• Developing custom web application solutions for internal ticket metrics reporting.
• Set indexing property configurations, including time zone offset, custom source type rule, configure regex transformations to perform on data inputs. Use in tandem with props.conf.
• Designed core scripts to automate Splunk maintenance and alerting tasks.
• Integrated ServiceNow with Splunk to generate the incidents from Splunk.
• Created many of the proof-of-concept dashboards for IT operations, and service owners which are used to monitor application and server health.
• Lowering the cost and risk of big data initiates with full featured platform to rapidly explore, analyze and visualizing data in Hadoop.
• Analyzing data in Hadoop through data stores visual interactions and using splunk for deeper analysis.
• Working 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.
• Knowledge about Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
• Expertise in 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.
• Interact with the data warehousing team regarding extracting the data and suggest the standard data format such that Splunk will identify most of the fields.
• Experienced in creating Dashboards using different BI tools like Qlikview 11.0 and Tableau.
• Experienced in using various connectors to extract the data from different data sources.

Environment: Splunk 6.3, 6.2, Splunk Enterprise Security, Pivotal HD, Linux, UNIX, Oracle 11g, MS SQL server 2012, Hbase, Hadoop, ServiceNow, XML, Qlikview.

Confidential, Pleasanton, CA

Splunk Developer/Admin

Responsibilities:

• Installing, Configuring and Administering Splunk Enterprise Server 6.0.4/6.1.1 and Splunk Forwarder 5.0.1/6.2.0 on Redhat Linux and Windows severs.
• To Setup Splunk Forwarders for new application tiers introduced into environment and existing applications.
• Work closely with Application Teams to create new Splunk dashboards for Operation teams.
• Troubleshooting and resolve the Splunk - Performance, Log Monitoring Issues; Role Mapping, Dashboard creation etc.
• Created Splunk app for Enterprise Security to identify and address emerging security threats through the use of continuous monitoring, alerting and analytics.
• Created Regular Expressions for Field Extractions and Field Transformations in Splunk.
• Automating in Splunk using Perl with Service-Now for event triggering.
• Used Splunk data Connector between Splunk Enterprise and Relational Database.
• Anonymize the PII (Personally Identifiable Information) data in Splunk. Masked sensitive information such SSN numbers, Addresses when showing results in Splunk
• Configure Splunk for all the mission critical applications and using Splunk effectively for Application troubleshooting and monitoring post go lives
• Created Dashboards and Reports to show Login count of each application, to show which app resources being accessed more, Number of failed logins, statistics on High hitting applications.
• Generated Shell Scripts to install Splunk Forwarders on all servers and configure with common Configuration Files such as Bootstrap scripts, Outputs.conf and Inputs.conf files
• Configured Splunk forwarder to send unnecessary log events to "Null Queue" using props and transforms configurations to reduce license costs.
• Developing a custom application in Splunk.
• Fetching the data from databases using "DB Connect Application".
• Expansively involved in troubleshooting the issues and document the problem resolutions for future references. Attended Change management meetings for approval for the applications which are supposed to go live and provided the MOM of CM meetings to the team.
• Experienced in attending the bridge calls for production issues and non-prod issues and involved application teams or database teams or networking teams to resolve the issues and involved in Root cause analysis for the issues encountered. Also provided 24/7 on call support for all the production applications.
• Developed a POC on usage of Puppet Configuration Management tool.

Environment: Splunk Enterprise Server 6.0.4/6.1.1 , Universal Splunk Forwarder 5.0.1/6.2.0 , RedHat Linux, IBM HTTP Web Server 6.1/7/8, Oracle, HACMP 5.4, HTML, Java Script, XML, Wily Introscope 9.0, IIS 7, Windows 2003, Windows 2008 R2, Python (Jython), Regular Expressions.

Confidential, Columbus, Ohio

Splunk Developer

Responsibilities:

• As primary for Splunk support, supported Splunk circulated environment comprising of search heads, indexers and forwarders across different OS including Aix, Solaris and Windows.
• Configured Indexer replication to achieve data availability, data fidelity and disaster tolerance.
• Improved search performance by configuring 2 search heads for all Indexes in production.
• Install different Splunk Applications, for example, Cisco for Splunk, Windows for Splunk and VMware for Splunk.
• Created and configured management reports and dashboards in Splunk for application log monitoring.
• Responsible for administering, maintaining and configuring a 24 x 7 highly available, Splunk apps for production portal environment.
• Provided load/stress and architecture validation testing and trouble shooting on issues such as Out of Memory, 100% CPU Usage hung Thread sessions, session replication, JVM Crashes.
• Efficiently handled Work Load Management for load balancing and failover, improving performance, reliability and scalability.
• Gathering different wellsprings of syslog and XML information from different gadgets, applications, and information bases.
• Guarantee high accessibility & execution trough flat scaling and burden adjusted segments.
• Work towards accomplishing a speedier ROI and keeping up partners persuaded of the worth and undiscovered open doors in Splunk.
• Supporter and execute arrangements considering a full information lifecycle (Search & Investigate, Add Knowledge, Monitor & Alert, Report & Analyze)
• Problem determinations such as Broken Pipe/Connection reset issues by enabling traces in WebSphere V6.0/6.1 various Components and even automating various processes using wsadmin script.
• Basic understanding of Network Firewalls, Load-balancers, LDAP and complex network design.

Environment: Splunk Enterprise Server 5.1.2, Splunk Forwarder 5.1, 5.4, XML, VMware.

Confidential, PARAMUS, NJ

ETL/SQL Developer

Responsibilities:

• Analyzed busi6ness requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Documentation of technical specification, business requirements, functional specifications for the development of Informatica mappings to load data into various tables and defining ETL standards.
• Installed and configured Informatica Server and Power Center 7.2. migrated the Metadata changes to the Informatica repository.
• Responsible for Data Import/Export, Data Conversions and Data Cleansing.
• Created Informatica mappings with SQL procedures to build business rules to load data.
• Worked on Informatica Power Center 7.1.3 tool - Source Analyzer, warehouse designer, Mapping Designer &Mapplets, and Transformations.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Extensively worked in Oracle SQL Query performance tuning and created DDLs, database objects like Tables, Indexes and Sequences etc., by working closely with DBAs.
• Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
• Designed tables, indexes and constraints using TOAD and loaded data into the database using SQL*Loader.
• Tuning of Informatica jobs with oracle as backend database.

Environment: Informatica 7.1.3, Business Objects, Oracle 8.1.7.4, SQL*Plus, PL/SQL, TOAD, 7.1, UNIX, Windows XP.

Confidential

UI Developer

Responsibilities:

• Designing and developing dynamic web pages using XHTML, CSS and JavaScript.
• Coded extensively in jQuery to make rich Internet web pages and created custom date picker on the website.
• Developed mockups and prototypes using HTML and CSS.
• Design website and maintain the website content up to date.
• Experience in cross browser compatibility check and thoroughly performed unit testing and integration testing.
• Develop the online chat interface for the anonymous communication between mentors and clients.
• Re-designing/ developing the main website to improve user experience and add new functionality.
• Worked on the website from start to finish to give it a new look using HTML/CSS/JavaScript.
• Designed dynamic and browser compatible pages using HTML, DHTML, CSS and JavaScript.
• Involved in extensive HTML coding.
• Developed CSS styles to maintain the uniformity of all the screens throughout the application and positioning of screen objects.
• Developed page layouts, navigation, animation buttons and icons.
• Applied industry best practices and standards when project requirements are lagging.
• Designed CSS based page layouts that are cross-browser compatible and standards-compliant.
• Performing the different modules like login, search and download with tracking.
• Did extensive JavaScript and jQuery programming to give AJAX functionality for the website.
• Further tasks include management of all MySQL database and all the required tables to store different survey information related to the site.

Environment: HTML, CSS, JavaScript (Libraries: jQuery), MS Access, Adobe Flash, MS Office, Firefox, Chrome.