SUMMARY

• 6 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, upgrade and configuration of Microsoft SQL Server and databases.
• Over 3 years of extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2000/2005/2008.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in extracting and transforming data using Import/Export wizard, Bulk Insert, Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server .Integration Services (SSIS) (2005/2008).

TECHNICAL SKILLS

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

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio.

Languages: C, C++, T-SQL, Visual Basic

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

Databases: MS SQL Server 2008/2005/2000 , MS Access 97/2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Scripting: HTML, DHTML, Shell Scripting, XML.

PROFESSIONAL EXPERIENCE

Confidential - Spring, TX

Splunk Admin

Responsibilities:

• Created Dashboards for various types of business users in organization.
• Assisted internal users of Splunk in designing and maintaining production-quality dashboard
• Experience developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis
• Involved in setting up alerts for different type of errors
• Using SPL created Visualizations to get the value out of data
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• Monitoring and generating alerts in Remote graphic workstations.
• Involved in installing and using Splunk app
• Use techniques to optimize searches for better performance, Search time vs Index time field extraction. And understanding of configuration files, precedence and working.
• Co-ordinated various upgrade related to application software and Windows operating software
• Captured data from various front end, middle ware application
• Dashboards were created to monitor the traffic volume across, response times, Errors, Warnings across various data centers, applications and servers
• Tracking was set up to trace a customer session across load balancer, web server, application server and Middleware applications
• Configure Splunk Enterprise and Security application
• Set up alerts when the response time or traffic falls above or below expected limit.
• Review detailed business requirement and communicate those requirements to Developers, Architects, QA, and production support personnel.
• Lead a team consisting of developers, business analysts, vendor team members and content editors.
• Responsible for day to day project life cycle planning, status review, identifying critical paths, escalations of unresolved issues.
• Responsible for reviewing software design and recommending best practices

Confidential - Chicago, IL

Splunk Developer/Admin

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 an 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
• Customers use the website to purchase the needful.
• From the website, the number of errors, various products viewed by the customer and also the request and response is captured.
• This information has to be captured for applications developed in various technologies (Java, .NET, PHP,ePub etc).
• These applications are hosted in different domains and different servers.
• 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, Pivotal HD, Datameer, Linux, Bash, Perl, Hbase, Hive, Pig, Hawq, Sed, rex, erex, Splunk Knowledge Objects

Confidential - New York, NY

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 Windows platforms.
• Part of ecommerce Platform monitoring team in the Bank of America Mobile and Desktop online Banking website.
• Worked on setting up Splunk to capture, analyze data in Bank of America online Banking.
• Set 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.
• Part of ecommerce Platform production support team in the Bank of America Mobile and Desktop website.
• Some of the functionalities include Login, Account overview, account details, statements and documents, bill pay, alerts, Cash Back deals, Transfer of funds, marketing and customer service sections
• Involved in analyzing and triaging production issues related to various functionalities of the site.
• Participated in change execution activities, which include analyzing the changes for the impacts to the environment and approving the change with all the required documentation. This also includes end-to-end coordination of successful implementation.
• Ability to identify customer-facing issues arising in production or after deployment of new products and services.
• Supported the applications involved in the Bank phone banking channel.
• Took owner ship of the issues from the problem description to the deployment of fix in production
• Worked on various maintenance changes done as part of Day Light Savings change done
• Co-ordinated various upgrade related to application software and Windows operating software
• Dashboards were created to monitor the traffic volume across, response times, Errors, Warnings across various data centers, applications and servers
• Indexed web-server logs and IBM application server logs into splunk to get the operational intelligence
• 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.1, Linux, Unix, Oracle 11g, MS SQL Server 2012, SQL.

Confidential, WI

Senior SQL Server SSIS SSRS Developer

Responsibilities:

• Monitored performance and optimized SQL queries for maximum efficiency.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Identified and added the report parameters.
• Built effective queries for high-performance reporting.
• Deployed the generated reports on to the server.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005.

Confidential

SQL Server Developer

Responsibilities:

• Responsible for the study and analysis of the systems design and implementation.
• Responsible for installation and configuration of MS SQL Server 2000 for development purposes.
• Created various database objects including tables, stored procedures and functions.
• Involved in tuning the existing T-SQL code for performance improvement.
• Followed the best practices in writing T-SQL for universal readability and reusability of code.
• Interacted with analysts and other developers in understanding and identifying the business requirements.
• Created stored procedures to hold the business logic.
• Created views as per client requests.

Environment: MS SQL Server 2000, DTS, T-SQL