We provide IT Staff Augmentation Services!

Sr. Splunk Developer Resume

2.00/5 (Submit Your Rating)

Detroit, MI

SUMMARY

  • Around 7+ years of experience in Splunk Developer, Information Technology field with strong emphasis in Business Intelligence (BI) and Data Warehousing (DW) associated projects and RDBMS applications under different environments.
  • Expertise in Actuate Reporting, deployment, management and performance tuning of Actuate reports.
  • Various types of charts, Alerts, Knowledge of app creation, user and role access permissions. Creating and managing app, Create user, role, Permissions to knowledge objects.
  • Expertise in data modeling like Parsing, Indexing, Searching
  • Expertise in creating indexes and managing Hot, Warm, Cold, Frozen bucketing.
  • Expertise in customizing Field Extraction, Using Ifx, Rex Command, CLI command and Regex in configuration files.
  • 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.
  • Knowledge about splunk cluster environment like splunk SHPOOL, distributed components like distsearch.conf and configuring deployment server with help of serverclass.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
  • 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.
  • Business Activity Monitoring (BAM) concepts such as IBM.
  • Use techniques to optimize searches for better performance, Search time vs Index time field extraction. And understanding of configuration files, precedence and working.
  • Expertise working with splunk configuration files such as Props.conf, transforms.conf, inputs.conf, outputs. conf setting.
  • Expertise in debugging issues and monitoring health of cluster with existing splunk application
  • Extensive Data Warehouse experience using Informatica 7/8.x/9 Power Center 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.
  • Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse using Informatica Power Center.
  • Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model), and Data Warehousing (ETL).
  • Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups,Normalizer, Expression, Aggregator, Joiner,
  • Union, Update Strategy, Stored Procedure and Sequence Generator Etc.
  • Database experience using Oracle 11g/10g/9i/8.x/7.x, MS SQL Server 2008, Teradata and DB2.
  • 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.
  • Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
  • Good understanding of Views, Synonyms, Indexes, Joins, and Sub - Queries.
  • Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

Tools: Splunk, TOAD, XML, HTML,OLAP,OLTP

Programming Language: Java, Java Script, Python, Uinx Shell Scripting

Data Warehousing/ ETL: Informatica Power Center 9.5/ 9.1/8.5/8.1.1/7.1.2 , Informatica Designer, Workflow Manager, Work flow Monitor, Data mart, MappletTransformations, Autosys, SQL*Plus.

Web Technologies: HTML, DHTML, JavaScript, XML, XSL, XSLT

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

Databases & Tools: Oracle 11g/10g/9i/8i/8.x, SQL*Server, SQL*Plus, SQL*Loader, TOAD, MS SQL Server 2000/2005, MS Access

Operating Systems: Solaris/Linux/ Windows

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Sr. Splunk Developer

Responsibilities:

  • Expertise in Actuate Reporting, development, deployment, management and performance tuning of Actuate reports.
  • Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
  • Created Dashboards, report, scheduled searches and alerts.
  • Experience in using traffic generators like IXIA, Agilent andPerlduring manual as well as script Automation.
  • Knowledge about Splunk and logging architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
  • Experience in BI Report Development, deployment and scheduling using Business Objects (Universe Designer, Web Intelligence, Info view)
  • I have helped team’s on-board data, create various knowledge objects, install and maintain the Splunk Apps, TAs and good knowledge on java script for advance UI as well Python for advance backend integrations.
  • Experienced in developing web-based applications usingPython, Django, Java,, XML, CSS, HTML, DHTML and JavaScript.
  • Extensive experience on setting up the Splunk to monitor the customer volume and track the customer activity. Have involved as a Splunk Admin in capturing, analyzing and monitoring front end and middle ware applications.
  • Developed a Front-End GUI as stand-alonePythonapplication As in production environment, I was involved in triaging and resolving various complex production issues by analyzing data from various monitoring tools from Sys logs and application logs. This involves working with various team’s real time on a conference call.
  • Also, worked on code changes for various maintenance and customer reported bugs as part of production support.
  • Integrated Service Now with Splunk to generate the Incidents from Splunk
  • Worked on DB Connect configuration for Oracle, My SQL 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 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.
  • Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
  • 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 Load Balancers, Web servers and application servers.
  • Captured data from various front end, middle ware application
  • Dashboards were created to monitor the traffic volume across, response times, Errors, Warnings across
  • 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 online search vs scheduled search in a dashboard Environment: SPLUNK 6.0.7, Linux, Unix, Oracle 11g, MS SQL Server 2012, SQL.
  • Developing Custom Modules Telecom Management Reports usingPERL

Environment: SPLUNK 6.2, Linux, Unix, Oracle 11g, MS SQL Server 2012, SQL.

Confidential, Elsegundo, CA

Splunk Poweruser

Responsibilities:

  • Expertise with Splunk UI/GUI development and operations roles.
  • Prepared, arranged and testedSplunksearch strings and operational strings.
  • Played a major role in understanding the logs, server data and brought an insight of the data for the users.
  • Involved in setting up alerts for different type of errors and helped the client to setup 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
  • 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.1.2, Linux, Windows Server 2012, 2008, Splunk Enterprise Security, ESX, Applications Development, Big Data Analysis, operations analysis.

Confidential, Sacramento, CA

Informatica Developer

Responsibilities:

  • Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer.
  • Developing workflows with Worklets, event waits, conditional flows, email, and command tasks using Workflow manager and monitored them in Workflow monitor.
  • Reusing the single workflow for loading data from various regions’ files with similar file structure using indirect loading as source type in session properties.
  • Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, PowerCenter transformations and sessions using techniques like Explain plans, Oracle hints re-designing the mappings. Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
  • Creating and scheduling the PL/SQL Reconciliation Scripts of Oracle for checking validity of the data in the DWH.
  • Used Mapplets, Reusable transformations, Parameters and Variables to facilitate the reusability of Code.
  • Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
  • Developed processes for automation of loading data using parameter driven sessions for various workflows, verification and re-conciliation of data stored in several different source systems.
  • Configured and scheduled Pre and Post Session commands with Shell Scripts and called them using command task.
  • Used TOAD to run SQL queries and validate the data in warehouse.
  • Extensively used command, event-wait, event-raise and control tasks for keeping track of events in the ETL process.
  • Created UNIX shell script to FTP flat files from different ordering systems to the ETL server.
  • Fine tuned the performance of ETL processes.
  • Involved in the upgrade from Informatica Power center 8.6.1 to Informatica Power center 9.1.
  • Wrote stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes.
  • Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data.
  • Performed unit test for Informatica mappings and workflows in both development and test environments.
  • Used Incremental aggregation to capture new source data and in scenarios where the incremental changes do not significantly change the target so that the PowerCenter server updates the target incrementally.

Environment: InformaticaPowerCenter 8.6.1/9.1, Oracle 10g, TOAD, Flat Files, Erwin, SQL, PL/SQL, Oracle Linux 5, Windows XP, SQL Loader.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

  • Participated in complete SDLC - requirements gathering, feasibility analysis, physical and logical data modeling, mapping design, unit and integration testing, production support and related documentation. Classified requests as either New Data or Changed Data requests.
  • Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
  • Developed Shell Scripts and SQL Queries.
  • Used SQL * Loader for bulk loading.
  • Worked on Physical modeling phase in designing the Relational Database.
  • Developed Unit test plans and integration test plans for verification and validations of procedure developed as well as to help validate the impact of changes.
  • Involved in creating Technical Specification Document (TSD) for the project
  • Worked on Informatica Power Center tools-source analyzer, Warehouse Designer, Mapping Designer and Transformation developer.
  • Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements.
  • Created and documented Test Plans.
  • Performed Unit and Integration testing for PowerCenter Mappings and Workflows, and documented the findings.
  • Designed Reusable Transformations, Mapplets, Tasks and Worklets during Mapping and Workflow design process. Used most of the PowerCenter Transformations like Source Qualifier, Joiner, Router, Update Strategy, Lookup, Rank, Expression, Aggregator, Filter and Sequence Generator for loading the data into Oracle database.
  • Performed Mapping, Workflow, SQL and Database tuning to improve system performance.
  • Created and maintained Mapping Design and Testing documentation.
Environment: Informatica Power Center 6.x, Oracle, Flat file, XML files, SQL Server 2000, SQL* Loader, PL/SQL, UNIX, Windows 2000.

Confidential

SQL Developer

Responsibilities:
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Developed Query for generating drill down, drill through, sub reports, URL reports and dashboard reports in SSRS 2008.
  • Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
  • Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration
  • Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008
  • Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2008
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler. Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2008.
  • Extensively worked with SSIS tool suite like Conditional Split, Lookup, Multicast and Derived Column.
  • Migrated data from MYSQL to SQL server, synchronizing converted data to SQL server.
  • Developed several Tables, Stored Procedures, functions and views to load data from the SQL server.
  • Working very closely with other developers for their SQL requirements, work with Business Analyst and end users to understand the report requirements.
  • Performance Tuning already existing queries to improve the query time for faster reports.
  • Following Data Warehousing methodologies and concepts, including Star schemas, snowflakes, dimensional modeling.
  • Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package
  • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
  • Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
  • Experience in data migration from old databases and different databases to main database
  • Experience in using Open Query while getting data from different Databases such as Oracle, SQL Server in same query
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Involved in Implementation of database design and administration of SQL based database.
  • Wrote T-SQL procedures to generate scripts that modified database objects dynamically based on user inputs.
  • Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
  • Created Stored Procedures, Triggers and Audit Tables, Views and SQL Joins and other statements for various applications.
  • Analyzed and tuned complex Queries, Stored Procedures in SQL Server 2008 for faster execution and developed database structures.
Environment: MS SQL Server 2008R2, SQL server Reporting Services (SSRS) 2008R2, MS SQL Server Integration Services, MS SQL Server Analysis Services, MYSQL, MS Visual Studio …

We'd love your feedback!