SUMMARY

• 7+ years of IT Experience in Database Design, Development and Implementation of Microsoft SQL Server 2005/2008/2008 R2 in Development, Test and Production environments with various business domains
• Experience in Splunk 5.x and 6.x product, Distributed Splunk architecture and components including search heads, indexers, forwarders, etc.
• Prepared, arranged and tested Splunk search strings and operational strings.
• Created and configured management reports and dashboards.
• Worked on large datasets to generate insights by using Splunk.
• Experience developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis.
• Extensive 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.
• Experience in working with Splunk authentication and permissions and having significant experience in supporting large scale Splunk deployments.
• Analyzed security based events, risks and reporting instances.
• 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)
• 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.
• Supported data source configurations and change management processes.
• Resolved configuration based issues in coordination with infrastructure support teams.
• Maintained and managed assigned systems, Splunk related issues and administrators.
• In depth and extensive knowledge of Splunk architecture and various components. Passionate about Machine data and operational Intelligence.
• 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.
• Expertise in creating accurate reports, Dashboards, Visualizations and Pivot tables for the business users.
• Expert in using rex, Sed, erex 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
• Extensive experience and actively involved in Requirements gathering, Analysis, Reviews, Coding and Code Reviews, Unit and Integration Testing.
• Experience in Installation, Configuration and administrationof Tableau Server in amulti-serverandmulti-tierenvironment.
• Informatica Administrator with 4+ years of IT experience in Design, Development, Administration and Maintenance of Data warehouse applications as an Informatica Administrator and ETL Developer.
• Install, Configure and Upgrade Informatica Power center 9.5.1/9.1.0/9.0.1/8. x/7.x on IBM AIX, SUN-SOLARIS and LINUX.
• Good Knowledge in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, VSAM, DB2, Oracle, SQL Server and Teradata.
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner and Update Strategy
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.

TECHNICAL SKILLS

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

ETL: Informatica Power Center 9.5.1, B2B DT & Informatica Data Quality

Languages: SQL, PL/SQL, Unix Shell Scripting.

Operating Systems: Windows Server 2003, Windows 2000 advanced Server, Windows NT/95/XP, and UNIX.

Databases: Oracle 11g/10g, MS SQL Server2005/2008, Teradata 14, Sybase, DB2.

Operating System: UNIX (AIX, Solaris, LINUX), Windows NT/XP

Scripting: HTML, DHTML, Shell Scripting, XML.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Splunk Developer

Responsibilities:

• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Created Dashboards, report, scheduled searches and alerts.
• Integrated ServiceNow with Splunk to generate the Incidents from Splunk
• Worked on DB Connect configuration for Oracle, MySQL 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.
• Knowledge about Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
• Involved in standardizing Splunk forwarder deployment, configuration and maintenance across UNIX and Windows platforms.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• 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 o Inline search vs scheduled search in a dashboard

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

Confidential, Georgetown, KY

Splunk Developer

Responsibilities:

• Expertise with Splunk UI/GUI development and operations roles.
• Prepared, arranged and tested Splunk search strings and operational strings.
• Helped the client to setup alerts for different type of errors.
• Played a major role in understanding the logs, server data and brought a insight of the data for the users.
• Involved in setting up 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
• Used Datameer to analyze the transaction data for the client.
• Installed, configured and managed Datameer users on the Hadoop cluster.
• 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.0.1, Pivotal HD, Datameer, Linux, Bash, Perl, Hbase, Hive, Pig, Hawq, Sed, rex, erex, Splunk Knowledge Objects

Confidential, Minneapolis, MN

Informatica Administrator

Responsibilities:

• Installing Informatica Power center 8.1.x on IBM-AIX and applying Patches/Hot fixes.
• Performed Upgrading Informatica Power center Version 7.X to Informatica Power center 8.X.
• Migration of Informatica objects across different environment like DEV, QA, UAT and PROD.
• Create Users, Groups and Roles in Admin console and assign the privileges to the same.
• Create the Folders and assign privileges to developers for Folders depending up on the environments.
• Maintain the Log Management.
• Monitoring the Informatica environments by using automated UNIX scripts and make sure Informatica up and running.
• Create and maintain the Relational and Loader ODBC connections in Development, QA and Production environments.
• Import and export INFA xml’s across repositories from clear case versioning server.
• Creation of Static and Dynamic deployment Groups, Labels and Queries
• Deployments from one repository to another repository using Labels, queries and dynamic deployment groups
• Handling space issues on UNIX servers to minimize the repository unavailability
• Extensively worked on Folder deployments across different repositories
• Monitoring the scheduled jobs and UNIX servers over 24/7 rotations
• Extensively worked on migration of UNIX files and directories in UNIX environments across different servers
• Backup and recovery management

Environment: Informatica Power Center 8.6.1 & 7.1.2, Oracle 10G/9i, Teradata, IBM-AIX, Windows XP professional.

Confidential, McLean, VA

Informatica Developer

Responsibilities:

• Installing Informatica Power center 7.1.2 on SUN-SOLARIS and applying Patches/Hot fixes.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Create Users, Groups and Roles and assign the privileges.
• Create Folders and give permissions for the folders in a repository.
• Stop and Start the Informatica services by using UNIX Server.
• Create the Relational and Loader ODBC connections in Development, QA and Production environments and assign privileges to Connections as per the environment standards.
• Create service accounts and encrypt the passwords and maintain in UNIX Password file.
• Import and export INFA xml’s across repositories.
• Folder deployments from one repository to another repository and within the same repository.
• Monitoring the scheduled jobs and UNIX servers over 24/7 rotations.
• Backup the Informatica Repositories as per the schedule.
• Preparing standard operating Procedures for related Informatica Production issues.
• Preparing weekly and monthly progress report.

Environment: Informatica Power Center 7.2(Repository Manager, Designer, Workflow Manager and Work flow Monitor), Oracle 9i PL/SQL, FTP (Client and Server), MS Office (Excel 2000/MS word/MS Access)

Confidential

Informatica Developer

Responsibilities:

• Responsible for Analysis and gathering system requirements.
• Performed logical and physical design of the database-using Informatica Designer.
• 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.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• 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).
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, and Update Strategy for Designing and optimizing the Mapping.
• Created various tasks like Pre/Post Session, Command, Timer and Event wait.
• 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.
• Created Materialized view for summary data to improve the query performance.
• Creating application schema as tables, view and indexes.
• Managing databases, tables, indexes, views, stored procedures.
• Enforcing business rules with triggers and user defined functions, troubleshooting, and replication.
• Writing the Stored Procedures, checking the code for efficiency.
• Customized the stored procedures and database triggers in PL/SQL.
• Exception handling and cursor management in PL/SQL.
• Preparing Test Cases and performing Unit Testing.
• Review of Unit and Integration test cases.
• Production Implementation and Post Production Support

Environment: Informatica Power Center 7.1.2, Oracle 8i, SQL, PL/SQL, SQL*Loader, Windows XP.