SUMMARY

• 7 Plus years of IT Experience in designing, developing, Administration of business intelligence solutions using Splunk 6.x.x/5.x.x, SQL server integration(SSIS), Reporting(SSRS), Analysis(SSAS) services.
• Developing various reports and dashboards by using data from multiple data sources.
• Expert developing Splunk queries for retrieving data from multiple data sources.
• Worked on Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Develop deployment - apps wifinSPLUNKin order to parse, index multiple types of log format across all application environments.
• Experience on Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• MonitorSplunkInfrastructure (Identify bad searches, dashboards and overall health ofSplunk) and collaborate wif respective teams to improve performance.
• Experience wif various security platforms including HP ArcSight ESM, ArcSight Connector, ArcSight Logger, Tipping Point IDS, McAfee Network Security Platform (NSP) 7.5 for maintaining splunk platform.
• Experience in working wif Splunk autantication and permissions
• Working experience on Time chart attributes such as span, bins, Tag, Event types, Creating dashboards, reports using XML.
• Experience in Installation ofSplunkEnterprise,Splunkforwarded,SplunkIndexer, Apps in multiple servers (Windows and Linux) .
• Configure teh adds-on app SSO Integration for user autantication and Single Sign-on inSplunkWeb.
• Familiar System Administration wif Windows … Servers, Red Hat Linux Enterprise Servers, Solaris and IBM AIX servers.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms.
• Wrote complex T-SQLcode and created Stored Procedures, Triggers, CTE to calculate estimated insurance prices; created views to reduce database complexities for teh end users under different business requirements.
• Created packages to transfer data between OLTP and OLAP database; used various tasks in control flow and transformations in data flow to load data to destinations such as text files, Excel file and CSV file.
• Used different types of SSIS configuration to make packages dynamic.
• Used Index Tuning Wizard,SQLProfiler andSQLQuery analyzer for Performance Tuning, in order to improve teh performance of queries and packages.
• Wrote technical documents including task in control flow, transformations & logic in data flow, logging, package configuration after developing packages and sent them to DBA.
• Proficiency in managing, maintaining, troubleshooting, and resolving issues in a 24x7 production environment. Strong analytical skills and high degree of learn-ability. Excellent Leadership, interpersonal and communication skills.

TECHNICAL SKILLS

Reporting tools tools: Splunk 6.x.x/5.x.x, SSRS, SSAS, Crystal Reports11/10/8.5, buisiness objects

Databases: Microsoft SQL Server 2005/2008/2010/2012, MS Access, oracle, Flat files

Programming languages: SQL, PL/SQL, Java, C#,C,C++,XML, HTML, CSS, Java Script

Scripting languages: Power shell scripts, Shell Scripts

Web Servers: Internet Information Server (IIS) 6.0/7.0/7.5.

Tools: Visual Studio, Eclipse, SQL profiler, SharePoint 2010

Operating System: Windows server 2012/2008/2003, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Splunk developer /Admin

Responsibilities:

• Communicate effectively wif clients to identify needs and analyze business solutions wif project management.
• Created huge analytical Dashboards, reports.
• Worked on Parsing, alerts, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• OptimizedSplunkfor peak performance by splittingSplunkindexing and search activities across different machines.
• Prepared, arranged and testedSplunksearch strings and operational strings. Created and configured search management reports.
• Worked on DB Connect configuration for Oracle and MSSQL.
• Worked on Splunk Queries for retrieving teh data.
• Experience on Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• Worked wif security and risk assessment teams in discovering security vulnerabilities and assisted server operations in patching teh servers for critical patches such as Heart Bleed and OpenSSL known issues.
• Develop deployment-apps wifinSPLUNKin order to parse, index multiple types of log format across all application environments.
• Provide access on roles, restriction permissions for various users across teh system.
• Extracted complex Fields from different types of Log files using Regular Expressions.
• Efficiently handled Work Load Management for load balancing, failover, improving performance, reliability and scalability.
• Configured Web Sphere wif splunk, in such a way that WAS logs, metrics, and server configuration files can be searched and reported using Splunk.
• Providing on-call support across teh organization.
• Involved in Designing SplunkEnterprise Server infrastructure to provide high availability by configuring clusters across two different data centres.
• Involved in Setting upSplunkForwarders for new application tiers introduced into environment and existing applications.
• Conducted several meetings wif various kinds of users in organisation for requirement gathering and explaining how to use splunk.
• Expert in writing power shell scripts for configuring, maintaining and resolving issues across splunk platform.

Environment: SplunkEnterprise Server 6.x.x/5.xx, UniversalSplunkForwarder 5.x.x/6.x.x,, Apache 2.2/2.4, Oracle, Flat files, MS SQL, HTML, Java Script, XML, Wily Introscope 9.x, IIS 7, Windows 2008 R2/2012,Linux, Regular Expressions, Web Sphere.

Confidential, Rochester, Minnesota

SQL BI /Splunk Developer

Responsibilities:

• Involved in development and implementation of SSIS and SSRS application solutions for various business units across teh organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for teh Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develop and unit test SSIS load processes for performance check.
• Created various complex reports and manage them usingSQLServer Reporting Services (SSRS 2008/2005).
• Involved in migration and Conversion of Reports from legacy systems to new systems.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects inBIstudio and created, modified and managed various report models wif multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate teh special reports according to client's need.
• Created POC, in which we created few reports using Splunk as an alternative to SSRS using Oracle DB and Flat files as data source.

Environment: SQLServer 2005/2008 Enterprise Edition, Splunk enterprise server 5.x, .Net 3.5,SQLBISuite (SSAS, SSIS, SSRS), Enterprise manager, SharePoint 2010, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008, Oracle.

Confidential, Houston TX

SQL BI Developer

Responsibilities:

• Transformed data from MSSQLServer 2000 to MSSQLServer 2005R2 using OLE DB connection by creating various SSIS packages.
• Created Data Transformation tasks like Bulk Insert to import/export data from clients.
• Used SSIS to create ETL packages to Validate, Extract, Transform, and Load data to Data Warehouse and Data Mart Databases.
• Designed a new schema for teh Data Mart databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Generated Dynamic reports from Cubes (SSAS) using SSRS 2008.
• Designed, Developed and Deployed reports in MSSQLServer environment using SSRS 2008.
• Generated Sales Ranking reports usingSQLServer Reporting Services for different subjects.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Generated Dashboard and Scorecard Reports using Performance Point.
• Generated Daily, Weekly, and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.

Environment: SQLServer 2005, SQLBISuite (SSAS, SSIS, SSRS), Enterprise manager, MS Office, MS Access 2003 & Windows Server 2003

Confidential

Junior software Developer

Responsibilities:

• Involved in a part of teh project from requirements gathering, design & development and knowledge transfers.
• Interacted directly wif customers to collect key requirements and scenarios.
• Performed functional testing to check teh stability of teh product.
• Worked wif Microsoft Enterprise Library viz., Data Access Application Block, Exception Application Block to reduce teh development effort.
• Created various reports using SSRS .
• Designed front end screens using ASP.NET to dispaly various reports developed by SSRS.
• Developed Java Scripts, .NET validation controls to validate client side data for better quality.
• Performed test-driven development methodology which allowed reducing development time.
• Performed end to end testing for both positive and negative scenarios for teh pages developed.

Environment: SSRS, C# 2.0, ASP.net, ADO.net, SQL Server 2005, Visual Studio 2005 and TFS.