PROFESSIONAL SUMMARY

Seasoned Professional with 8+ years of experience in IT covering, Splunk, ITSI, SIEM, Linux/UNIX, SQL /DBA Data Analysis, Business Analysis, Application Design & Development, Quality Testing of Data Warehousing across various domains including Healthcare, Pharma & Market Research Industries.

Expertise in Installation, Configuration, Migration, Trouble-Shooting, and Maintenance of Splunk, Passionate about Machine data and Operational Intelligence.

Experience in deploying, configuring and administering Splunk clusters.

Experience in creating Splunk apps for Enterprise Security to identify and address emerging security threats through the use of continuous monitoring, alerting and analytics.

Helping application teams in on-boarding Splunk and creating dashboards, alerts, reports etc.

Setup Splunk Forwarders for new application levels brought into the environment.

Develop custom app configurations (deployment-apps) within SPLUNK in order to parse, index multiple types of log format across all application environments.

Experience with Splunk Searching and Reporting modules, Knowledge Objects, Administration, Add-On's, Dashboards, Clustering and Forwarder Management.

Worked on Splunk ITSI glasstables, services, deep dives, KPI’s, ITSI modules and alerting framework.

Created and Managed Splunk DB connects Identities, Database Connections, Database Inputs, Outputs, lookups, access controls.

Experience on Splunk Enterprise Deployments and enabled continuous integration on as part of configuration (props.conf, Transforms.conf, Output.confg) management.

Experience on Splunk data flow, components, features, product capability, log parsing, complex Splunk searches, including external table lookups.

Performed various project analysis including entire spectrum of software development life cycle viz. Scope Analysis, Stakeholder Analysis, Gap Analysis, Process Modeling with UML.

Well versed with various SDLC processes like Agile, Scrum, Kanban, TDD, BDD & Waterfall.

Extensive experience in BI/ETL Tools like SSIS, SSAS OLTP, OLAP, Informatica, Business Objects & SSRS.

Experienced to work as a Data Analyst to perform complex Data Profiling, Data Definition, Data Mining, Validating, and analyzing data and presenting reports.

Professional expert in Data Visualization development using tableau to create complex and intuitive dashboards.

Provided Ad-hoc reports using SQL, Stored Procedures, Triggers, Functions, Cursors, and Views.

AREA OF EXPERTISE

Skillset:

Splunk 5x/6x Is 5.1.5.3.6.1.3/6.23/6.3/6.6.2/6.6.3, Splunk DB Connect 1.x/2.x

Splunk on Splunk, Splunk App for VMware, Splunk Web Framework,Splunk IT Service Intelligence, Data Modeling, Data Analysis, Data Mining, Data Reporting, Data Validations, Data Profiling and Project Management.

Technologies:

SPL, SQL, PL/SQL, SSIS, SSAS, SSRS, Informatica, HTML, SharePoint, TFS, Tableau, SPSS, R, Python

Methodologies:

Agile, Scrum, Kanban, TDD, BDD & Waterfall

PROFESSIONAL EXPERIENCE

EMPLOYER - Vizplum Corporation

ALLSTATE - Charlotte, NC 06/2019-Present

Splunk Engineer

Responsibilities:

Install and maintenance the Splunk add-on including the DB Connect, Active Directory LDAP for work with directory and SQL database.

Manage Splunk configuration files like inputs, props, transforms, and lookups.

Continuous monitoring of the alerts received through emails to check if all the application servers and web servers are up.

Create Splunk Search Processing Language (SPL) queries, Reports, Alerts, and Dashboards.

Field Extraction, Using Ifx, Rex Command, and Regex in configuration files and logs.

Creating Reports, Pivots, alerts, advance Splunk search and Visualization in Splunk enterprise.

Developed Splunk infrastructure and related solutions as per automation toolsets.

Provided technical services to projects, user requests and data queries.

Implemented forwarder configuration, search heads and indexing.

Set up Splunk dashboards for continuous monitoring for production support.

Played a major role in understanding the logs and server data and brought insight into the data for the users.

Worked on Splunk ITSI glasstables, deep dives, KPI’s, ITSI modules.

Created IT Service Intelligence glass table dashboards.

Designed and maintained production-quality Splunk dashboards using XML.

Created, de-coded, and debugged complex Splunk queries.

Managed indexes and cluster indexes, Splunk web framework, data models, and pivot tables.

Helped in maintaining Splunk instance and monitored the health of the cluster.

Extracted various fields using field extractor, field extractions (rex) and calculated fields to optimize the search performance and reduce the load on the search head.

Used techniques to optimize searches for better performance, search time vs. index-time, field extraction, and understanding of configuration files, precedence and working.

Configured various summary indexes by created saved searches to collect the aggregated data to run create dashboards on top of the summary index.

Installed and configured Splunk product upgrading version and testing in different environments.

Provide power, admin access for the users and restrict their permission on files.

Splunk integration with service now, Unity, Thousand eye and other applications.

Installed tested and deployed monitoring solutions with Splunk services.

Validation and support of all Splunk environments during the Disaster recovery exercises.

Maintenance, administration, and utilization of Cyber Security/Information Security (SIEM)

Environment: Splunk 6.x/ 7.x, Splunk Enterprise, Splunk Modules, Splunk DB Connect, Splunk Tools, Search Processing Language (SPL), Oracle 11g/10g, Web Services, HTTP, HTML, XML, SSL, and SIEM.

EMPLOYER – Vizplum Corporation

AMERICA FAMILY INSURANCE - Madison, WI 09/2018-5/2019

Sr Splunk Engineer

Responsibilities:

Installed and configured Splunk product upgrading version and testing at different environments.

Installation of Splunk Enterprise, Splunk forwarded, Splunk Indexer, Apps in multiple servers (Windows and Linux).

Install and maintenance the Splunk adds-on including the DB Connect, Active Directory LDAP for work with directory and SQL database.

Configure the adds-on app SSO Integration for user authentication and Single Sign-on in Splunk Web.

Manage Splunk configuration files like inputs, props, transforms, and lookups.

Upgrading the Splunk Enterprise to 6.2.3 and security patching.

Performed routine security functions for risk detection, prevention, and response. Monitor security systems & events to detect investigate & mitigate threats.

Deploy, configure and maintain Splunk forwarder in different platforms.

Ensuring that the application website is up and available to the users.

Continuous monitoring of the alerts received through mails to check if all the application servers and web servers are up.

Create Splunk Search Processing Language (SPL) queries, Reports, Alerts and Dashboards.

Problem record analysis and solution providing.

Field Extraction, Using Ifx, Rex Command and Regex in configuration files.

Creating Reports, Pivots, alerts, advance Splunk search and Visualization in Splunk enterprise.

Provide power, admin access for the users and restrict their permission on files.

Developed Splunk infrastructure and related solutions as per automation tool sets.

Installed, tested and deployed monitoring solutions with Splunk services.

Provided technical services to projects, user requests and data queries.

Implemented forwarder configuration, search heads and indexing.

Active monitoring of Jobs through alert tools and responding with certain action w.r.t to logs, analyses the logs and escalate to high level teams on critical issues.

Environment: Splunk 6.x, Splunk ES, Splunk DBConnect2.0, HTTP server 2.4, RedHat Linux 6.x.

Kantar (WPP Group), Hyderabad, India. 06/2012 – 04/2016

Splunk Developer, Admin and SQL developer: Data Analyst Team (Asst. Project Lead)

Responsibilities: Worked with Data science team to Manage/ Co-ordinate project activities and mission critical applications following ITIL Methodologies. Worked on Splunk Searching and Reporting modules, Knowledge Objects, Administration, Add-On’s, Dashboards, Clustering and Forwarder Management and use cases in security. Extracting the information from raw data and proving constructive inputs to take data-based action for the improvement of the project. Preparing monthly and quarterly reports and analyzed complex raw data and design complex SQL queries to provide accurate and timely recommendations to senior management.

Worked with application teams for on-boarding Splunk and creating dashboards, alerts, reports etc.

Hands on experience in customizing Splunk Apps and dashboards, built advanced visualizations, configurations, Reports and search capabilities

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.

Set up of Splunk dashboards for continuous monitoring for production support.

Installed, configured and manage Splunk Enterprise Security.

Deploy, configure and maintain Splunk forwarder on different platforms.

Creating Reports, Pivots, alerts, advance Splunk search and Visualization in Splunk enterprise.

Provide power, admin access for the users and restrict their permission on files.

Installed and upgraded Splunk software in distributed and clustered environments for numerous corporations and public entities.

Involved in preparing Logical Data Models/Physical Data Models.

Identify source systems, their connectivity, related tables, and fields and ensure data suitably for mapping.

Worked with BI and/or Oracle in a multi megabytes environment.

Designed many Packages using SSIS designer by using Control Flow and Data Flow Tasks with ETL Tool. Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.

Migrate the data from an Access database to SQL Server.

Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).

Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS).

Worked in entire life-cycle beginning from Requirements gathering, Data Model Design, ETL Design, Report Design, Testing, and Migration to Production and Post Production Support.

Working with ETL Lead and Business Analysts to ensure design integration and consistency across subject areas

Experienced in Data Transformation and Data Mapping from source to target database schemas and data cleansing.

Developed and maintained Data Dictionary to create Meta data Reports for technical and business purpose.

Assisted other team members to make them understand the data conversion process and the SQL queries written for data analysis purpose.

Used python-based data manipulation tools such as PostgreSQL to clean corrupted data before generating business requested reports.

Worked on Performance Tuning of the database, which includes indexes, optimizing SQL Statements.

Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.

Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting, and rolling out the deliverables.

Running Quality checks using SQL Queries and keep synchronize all databases with Erwin model and across all environments.

Having knowledge on logical & physical data model using data warehouse methodologies, including Star schema - Star-joined schema, conformed dimensions’ data architecture, early/late binding techniques, data modelling, designing & developing ETL applications using Informatica.

Environment: Windows, TFS, SQL Loader, PL/SQL, Share Point, MS-Excel, VB, Bravo tool, MS-Access, SQL SERVER, SQL SERVER Report Builder, PostgreSQL, Splunk 6.x, Splunk ES, Splunk DBConnect.

Granules India Limited, Hyderabad, India. 02/2011 – 05/2012

Executive /Analyst: Data Analyst team

Responsible for providing reporting, data analysis, and business intelligence related to

pricing, revenue, supply & demand balancing, forecasting, and inventory for the enterprise supply chain

Good experience with procurement planning, execution, and collaboration

Ensures a balance demand and supply to provide combination of cost control, lead times and service level.

Ensuring simple but effective way to communicate with distributors, partners, suppliers, contractors and manufacturers to make sure they know what client want and you know what they are intending on delivering,

Using advanced inventory management and demand planning technique.

To co-ordinate and schedule with the planning department, as well as with the suppliers for the delivery of materials in the plant, providing key insights for the supplier rating, Vendor identification and development.

Performed exploratory and quantitative analysis on Supply Chain, procurement and spend data to provide insightful and actionable information to support business decisions.

Gathered Business requirements and converted into technical requirements

Acquired, organized, cleansed and manipulated large amounts of enterprise data.

Pulled supply chain data from multiple sources to create complete data sets, replicating data, transforming data via ETL, queries, stored procedures, views, and jobs. With aggregated, organized, and complete data I developed front end dashboards and scorecards, data input forms and multi layered reports in SSRS. From data analysis I recommend process improvements and identify opportunities for different teams' management.

Performed Data reconciliation, Gap analysis, Root Cause Analysis on data quality issues

Used visualization tools like Tableau for Creating dashboard, reports and for creating Simple statistical analytics like trends and forecasting.

Oracle Apps R12 (ERP) exposure:

Have good functional exposure in complete Procure to Pay Process.

Handling RFQ’s, handling Quotations.

Doing Suppliers setup and buyer setups.

Item setups, descriptive flex fields in Po module.

Approving items for respective vendors

Environment: Oracle Apps, Windows 7, PL/SQL, MS-Access, SQL SERVER, MS Office, VISIO, Tableau.

TECHNICAL SKILLS

SPL, UML, Agile, Waterfall, SDLC, MS Visio, MS Office (Word, Excel, PowerPoint, Project, Outlook, Access), MS SharePoint, MS SQL Server, Oracle Apps, Rational Requisite Pro, Rational ClearQuest, SPSS Modeler, R Programming, Python, VB, Statistical Modeling, & techniques.

EDUCATION

Master of Science in Business Analytics from Grand Canyon University, Phoenix, AZ.

Post Graduate Diploma in Management (PGDM) from Vignana Jyothi Institute of Management (Autonomous), Hyderabad, India.

Bachelor of Technology (Information Technology) from Vignan’s Engineering College, Affiliated to JNTU, Vadlamudi, India

References are available upon request

Contact this candidate