SUMMARY

• Over 7+ years of diverse experience in Information Technology wif emphasis on Splunk Administration, Business Intelligence (BI) and Data Warehousing (DW) associated projects.
• Experience in Operational Intelligence using Splunk.
• Design, support and maintain the Splunk infrastructure wif Windows, Linux and Unix environments.
• Configure and Install Splunk Enterprise, Agent, and Apache Server for user and role autantication.
• Knowledge about Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
• Manage Splunk configuration files like inputs, props, transforms, and lookups.
• Deploy, configure and maintain Splunk forwarder in different platforms.
• Developing alerts, reports and dashboards to create awareness of potential system issues, highlight trends in system performance and create key performance indicators
• Experience in Shell scripting and extensively used Regular expressions in search string and data anonymization.
• 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.
• 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.
• 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.
• Worked extensively wif Informatica Designer to create mappings using Expression, Router, Lookup, connected and Unconnected, Source Qualifier, Aggregator and other transformations.
• 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.
• Database experience using Oracle 11g/10g/9i/8.x/7.x, MS SQL Server 2008, Teradata and DB2.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub - Queries.
• 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.
• 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.
• Excellent communication, presentation, project management skills, a very good team player and self-starter wif ability to work independently and as part of a team.

PROFESSIONAL EXPERIENCE

Splunk Developer

Confidential, Irvine, CA

Responsibilities:

• Design, support and maintain Splunk cluster infrastructure to receive logs from infrastructure and application services.
• Standardized Splunk agent deployment, configuration and maintenance across a variety of LIUX and Windows platforms.
• Upgraded Splunk wif patching in multiple server wifout downtime.
• Indexing and troubleshooting the application errors, troubleshooting non-responding forwarders/servers and documenting.
• Created alerts on the requests from managers for certain tasks
• Deployment script for universal forwarder installation
• Troubleshoot Splunk server and agent problems and issues
• Troubleshoot Splunk search head, Indexer and forwarder issues and document.
• Created Dashboards for various types of business users in organization
• Assist internal users of Splunk in designing and maintaining production-quality dashboards.
• Ingested the data from different backend application into Splunk.
• Created reports on Splunk based on the events gathered from server and log files.
• Assisted internal users of Splunk in designing and maintaining production-quality dashboard.
• Communicate wif development and other teams for successful implementation of software and release activities.
• Implementing Deployment server for controlling, patching and installing updates on slave nodes.
• Working on indexers and computing servers and wif configuration management.
• Configure search time and schedule Reports.
• Implementing new apps to the Splunk and license distributing across the servers.
• Create dashboard from search, Scheduled searches of Inline search vs scheduled search in a dashboard.
• Monitored high volumes on a trading platform using SPLUNK Enterprise search dashboards.

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

Splunk Developer

Confidential, Bothell, WA

Responsibilities:

• Monitoring tool to measure a particular problem or the contribution of a particular technique over time.
• Worked closely wif cross functional team to design new features and resolve issues they arise.
• Maintain, grow and improve the TVX Splunk environment
• Integrated ServiceNow wif Splunk to generate the Incidents from Splunk
• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Created Dashboards, report, scheduled searches and alerts.
• Involved in standardizing Splunk forwarder deployment, configuration and maintenance across UNIX and Windows platforms.
• Worked on DB Connect configuration for Oracle, MySQL and MSSQL.
• Involved in interacting wif business owners, developers and business analysts in improving the application.
• 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.
• Setup Splunk Forwarders for new application tiers introduced into environment and existing application.
• Created many of the proof-of-concept dashboards for IT operations, and service owners which are used to monitor application and server health.
• 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.

Environment: SPLUNK 6.0.1, Linux, Oracle 11g, MySQL, MS SQL.

Informatica Developer

Responsibilities:

• Worked wif various Active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Responsible for extracting data from Oracle, Sybase, and Flat files
• Responsible for the Data Cleansing of Source Data.
• Designed and developed ETL process using Informatica tool.
• Analyzed business process and gathered core business requirements. Interacted wif business analysts and end users.
• Used Informatica designer for designing mappings and mapplets to extract data from SQL Server, DB2 and Oracle sources.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions (SCD).
• Responsible for Performance Tuning in Informatica Power Center.
• Provided technical support and guidance to the offshore team to address complex business problems.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Wrote SQL Scripts to extract the data from Database and for Testing Purposes.
• Interacted wif the Source Team and Business to get the Validation of the data.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
• Worked wif Update strategy transformation using functions like DD INSERT, DD UPDATE, DD REJECT, and DD DELETE

Environment: Informatica Power Center 9.0 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g, SQL, PL/SQL, Teradata, Flat Files, Autosys, Star Team, UNIX, Linux, Windows XP

Informatica Developer

Confidential

Responsibilities:

• Designed & developed ETL processes based on business rules, job control mechanism using Informatica Power Center 7.1. Re-engineered on existing Mappings to support new/changing business requirements.
• Extensively worked on Expressions, Source Qualifier, Union, Filter, Sequence Generator, sorter, Joiner, Update Strategy Transformations.
• Developed Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Used Mapping, Sessions Variables/Parameters, and Parameter Files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
• Involved in writing UNIX Shell scripts (Pre/Post Sessions commands) for the Sessions & wrote Shell scripts to kickoff workflows, unscheduled workflows, get status of workflows.
• Tuned SQL Statements, Mappings, Sources, Targets, Transformations, Sessions, Database, Network for the bottlenecks, used Informatica parallelism options to speed up data loading to target.
• Created UNIX shell scripts to extract data from various sources like Oracle and Flat Files and loaded the transformed data into targets database and to schedule the session and workflow.
• Created Test cases for the mappings developed and tan created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Monitored batches and sessions for weekly and Monthly extracts from various data sources to the target database.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, and Update Strategy for Designing and optimizing the Mapping.
• Created Materialized view for summary data to improve the query performance.
• Prepared SQL Queries to validate the data in both source and target databases.
• Extensively worked wif various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.

Environment: Informatica Power Center 7.1.2, Oracle, Mainframe, DB2, COBOL, VSAM, SQL, PL/SQL

PL/SQL Developer

Confidential

Resposibilities:

• PL/SQL Involved in the review of Requirements wif business analysts and other Developers.
• Performing System Study, System Analysis and Design.
• Developed triggers, functions and procedures to create and modify forms
• Personalized Forms and Reports using Developer 6i, custom.pll and PL/SQL.
• Enhanced database programs using PL/SQL
• Query Optimization, Tuning SQL queries
• Interacted wif senior developers to ascertain program specifications of changes and/or upgrade using PL/SQL.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked wif java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: PL/SQL, Forms 6i, Reports 6i, Oracle 9i, UNIX