EXPERIENCE SUMMARY

• Overall 7+ years of Total Experience in teh IT Industry.
• Strong Skills wif Splunk wif Splunk 6.0.2/1, Splunk Enterprise 5.0, SSIS, SSRS.
• Extensive experience and actively involved in Requirements gathering, Analysis, Reviews, Coding and Code Reviews, Unit and Integration Testing.
• Expertise in Actuate Reporting, development, deployment, management and performance tuning of Actuate reports.
• Prepared, arranged and tested Splunk search strings and operational strings.
• Headed Proof - of-Concepts (POC) on Splunk implementation, mentored and guided other team members on Understanding teh use case of Splunk.
• Implemented workflow actions to drive troubleshooting across multiple event types in Splunk.
• Expert in installing and using Splunk apps for UNIX and Linux (Splunk nix).
• Knowledge on Configuration files in Splunk (props.conf, Transforms.conf, Output.confg)
• Extensive experience and actively involved in Requirements gathering, Analysis, Reviews.
• Expertise in creating accurate reports, Dashboards, Visualizations and Pivot tables for teh business users.
• Expert in using Rex, Sed and IFX to extract teh fields from teh log files.
• In depth and extensive Knowledge in setting up alerts and Monitoring recipes from teh Machine generated data
• Has Knowledge in various search commands like stats, chart, time chart, transaction, strptime, strftime, eval, where, xyseries,table etc. and difference 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 wif multiple Indexers.
• Create event type definitions.
• Set indexing property configurations, including time zone offset, custom source type rules, and Configure regextransformations to perform on data inputs. Use in tandem wif 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.
• 4+ years of experience in teh field of Information Technology wif solid experience in Software Analysis, Design and Development, Experience in Internet Technologies, Client/Server business systems, GUI prototyping, Data warehousing and application development.
• Worked on Data Warehousing using IBM Web sphere Data Stage 7.5.1, Ascential DataStage XE/7.5/7.1/6.0/5.2 (Administrator, Manager, Designer, Director, Metastage, Parallel Extender, Profile Stage, Quality Stage (Integrity), MetaRecon, XE/390), DataStage Plug-In,
• Worked extensively on Data modeling concepts and their implementation in Dimensional modeling using ETL Processes for Data warehouses.
• Good experience in Data Warehouse Development, Enhancement, Migration, Maintenance and Production support projects.
• Experience in troubleshooting of jobs and addressing production issues like data issues, Environment issues, performance tuning and enhancements.
• Well versed in setting up Data stage Development, Test & Prod Environments along wif installation of Patches and drivers.
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, transformer etc.
• Expert in developing teh flow and scheduling teh ETL jobs using BMC Control m tool.

TECHNICAL SKILLS

Tools: Splunk 6.0.2/1, Splunk Enterprise 5.0, SSIS, SSRS

ETLIBM: Web sphere Data Stage 7.5.1, Ascential Datastage 7.5/7.1/6.0/5.2

Reporting Tools: Business Objects XI/6.5/6.0/5.1/4.x, BO Developer Suite (Cognos Series 7.0/6.x

Data Modeling Tools: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling and ERwin 4.5/4.0/3.5/3.0.

Databases: Oracle 10g/9i/8i/8.x/7.x, DB2 8.0/7.0, Teradata V2R5/V2R4/V2R3, MS SQL Server 2000/7.0/6.5, Ms Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000

Language: C, C++, XML, TSQL, VB.NET, C#

Programming/: OthersUNIX Shell Scripting, SAP ABAP/4, SQL, PL/SQL, SQL*Plus 3.3/8.0, C, C++, Java, JavaScript, SQL*Loader.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Splunk Developer

Responsibilities:

• Prepared, arranged and tested Splunk search strings and operational strings.
• Setup alerts for teh different errors.
• 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 teh requirement.
• Analyzed security based events, risks and reporting instances.
• Developing custom web application solutions for internal ticket metrics reporting.
• Created many of teh 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.

Confidential, Durham, NC

Splunk Developer

Responsibilities

• Responsible for Completing a full, independent review of each requirement/specifications
• Extensively worked on teh test cases need to create in order to verify teh functionality for dashboard regarding health care claims submitted.
• Responsible for teh 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 teh objective of ensuring best fit and high quality.
• Provide inputs for identifying best fit architectural solutions - deployment for Splunk project.
• Hands on SPLUNK 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
• Analyzed security based events, risks 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 teh existing scripts for better test coverage.
• Report and maintain teh stories, tasks, acceptance criteria and bugs in teh 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, Oracle SQL, PL/SQL, DB2, CICS, Mainframe, Selenium Web Driver, REST API.

Confidential, Oak Brook, IL

Data Stage Developer

Responsibilities

• Extracted data using different strategies from teh various heterogeneous sources like Oracle & flat files.
• Imported and exported jobs from DataStage Manager to different environments.
• Developed Server jobs using various types of stages like Sequential file, ODBC, Hashed File, Aggregator, Transformer, Sort, Link Partitioned and Link Collector.
• Imported table definitions from teh different Plug-ins table definitions available.
• Used DataStage Director to monitor, validate and execute teh Server jobs created in teh
• DataStage Designer.
• Incorporated slowly changing dimensions in teh dimensional tables by creating and implementing
• Surrogate keys.
• Created several general routines (Before-After, Transform function) and used them throughout teh project
• Developed job sequences and batch jobs run in parallel.
• Improved teh performance of teh job by tuning.
• Written PL/SQL procedures to add and drop of indices. Created queries and constraints on data Tables.
• Extensively used Parallel Extender for enhancing teh job performance by implementing Pipeline Parallelism and Partition Parallelism.
• Extensively used Parallel Extender Stages, Join, Funnel, Remove Duplicates, Merge, Lookup
• Used extensively Reject Link, Job Parameters, and Stage Variables in developing jobs.
• Written UNIX scripts for file validation, scheduled teh jobs/batches for execution.
• Involved in teh ETL documentation using some standards, procedures and naming conventions.
• Adopted performance-tuning techniques to improve teh ETL process.
• Created shared containers to use in multiple jobs.
• Assisted in teh development of reports using Business Objects 5.1.
• Involved in data transfer between different companies using networks.

Environment: Ascential DataStage 7.0, Informatica 7.1, IBM AIX 5.2, DB2, XML/EDI, Business Objects V5.1, Windows NT, Erwin.

Confidential, NJ

Senior ETL Consultant

Responsibilities

• Created complex data stage jobs in Enterprise Edition using various stages.
• Used DataStage Designer to develop server & parallel jobs for extracting, transforming, integrating and loading data to targets.
• Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to teh Data warehouse.
• Developed ETL High level and low level design document and production implementation documents.
• Used teh Datastage Administrator to assign Privileges to users or user groups (to control which DataStage client applications or jobs they see or run), move, rename, or delete projects, and manage or publish jobs from development to production status.
• Created jobs that are used to aggregate, sort, merge data that we get from third party services.
• Used Datastage job Sequencers and Control- M to Schedule and run teh Datastage jobs.
• Experience wif Configuration of Sources and Analysis Settings.
• Used Information Analyzer to conducted end to end data profiling and content analysis
• By using IA Conducted column analysis, primary key analysis, and cross domain analysis.

Environment: Data Stage 7.5/5.2(Designer, Director, Manager, and Administrator) Erwin 4.0, Business objects 5.1 Suite of Products (Supervisor, Designer, and Web Intelligence), Oracle 8i, DB2 UDB 6.1 and Windows 2000.

Confidential

Software Engineer

Responsibilities

• Involved in System study, Analysis, and Project Planning.
• Involved in Database Designing and Application programming.
• Writing Database Packages, Stored Procedures & Triggers.
• Tuning of SQL-Statements, stored procedures
• Involved Unit testing and deployment of teh application.
• Transferring Old Data from Legacy system to Application Database.
• Training teh users, support and maintenance of teh application.
• Discussions wif client for bug fixing and customization of application.

Environment: Oracle 8i, Java, JSP, Java Script, Visual Basic, C, HTML, SQL, UNIX, Windows NT