SUMMARY:

• Overall 7+ years of Total Experience in the IT Industry.
• Strong Skills with Splunk with 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 the 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 the business users.
• Expert in using Rex, Sed and IFX to extract the fields from the log files.
• In depth and extensive Knowledge in setting up alerts and Monitoring recipes from the Machine generated data
• Have 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 with 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 with 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 the field of Information Technology with 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 with 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 the flow and scheduling the ETL jobs using BMC Control m tool.
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.

TECHNICAL SKILLS:

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

ETL: IBM 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/Others: UNIX 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 the 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 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.

Confidential, Durham, NC

Splunk Developer

Responsibilities:

• Responsible for Completing a full, independent review of each requirement/specifications
• Extensively worked on the test cases need to create in order to verify the functionality for dashboard regarding health care claims submitted.
• Responsible for the 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 the 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 the existing scripts for better test coverage.
• Report and maintain the stories, tasks, acceptance criteria and bugs in the 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 the 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 the different Plug-ins table definitions available.
• Used DataStage Director to monitor, validate and execute the Server jobs created in the
• DataStage Designer.
• Incorporated slowly changing dimensions in the dimensional tables by creating and implementing
• Surrogate keys.
• Created several general routines (Before-After, Transform function) and used them throughout the project
• Developed job sequences and batch jobs run in parallel.
• Improved the performance of the 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 the 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 the jobs/batches for execution.
• Involved in the ETL documentation using some standards, procedures and naming conventions.
• Adopted performance-tuning techniques to improve the ETL process.
• Created shared containers to use in multiple jobs.
• Assisted in the 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 the Data warehouse.
• Developed ETL High level and low level design document and production implementation documents.
• Used the 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 the Datastage jobs.
• Experience with 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 the application.
• Transferring Old Data from Legacy system to Application Database.
• the users, support and maintenance of the application.
• Discussions with client for bug fixing and customization of application.

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