SUNIL KUMAR

ac0gew@r.postjobfree.com

Phone: 561-***-****

Professional Summary

8+ years of extensive experience in Information Technology with emphasis on both analytical and technical capacities during complete SDLC in analytics/monitoring of infrastructure and security.

3 years of experience in SPLUNK development, design, configuration, dashboard design, alerts and scheduling.

Experienced in Splunk 5.x and 6.x product.

Knowledge on Distributed splunk architecture and components like Indexer, Forwarder, Search Head, Deployment Server, Universal Forwarder, Heavy Forwarder and licensing model.

Experience in administration, architecture and upgrades for splunk environments on linux RHEL.

Knowledge on amazon aws concepts like EMR & EC2 web services.

Strong experience in creating time-chart attributes like span, tags, event types, dashboard, data visualization and pivots as per business requirements.

Skilled in writing Search Processing Language (SPL)commands.

Have experience in configuring Indexers, Forwarders (Universal and Heavy), Search Heads, Deployment/Management servers, Deployment clients.

Good understanding of precedence and daily work exposure to props.conf, transforms.conf, inputs.conf, outputs.conf and setting up a forwarder information based on requirement, inline searches and scheduled searches.

Strong knowledge on Amazon AWS, Cloudstack and Openstack.

Expertise on designing Dashboards using XML and creating visualization.

Experience working with ecommerce and retail systems.

Perfect in installation and usage of SPLUNK apps on Unix/Linux and windows platforms.

Excellent communication skills required for the position.

Effectively utilized SPLUNK for understanding the structure and meaning of data and visually represent the results for clear understanding.

Experience with creating and executing complex SQL queries.

Planning, Development and Implementation of Test cases, Test plansand Test Scenarios to meet software requirements and specifications.

Experience in creating different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.

Used techniques to optimize searches for better performance, Search time vs Index time field extraction.

Expertise in Back-end testing using SQL Queries on Oracle, MS SQL Server environment running on UNIX or Windows platform to verify Data Integrity.

Technical Proficiency

Methodologies : Waterfall, Agile,

Languages : SQL, C, Javascript

Office Tools : MS Word, Excel, Outlook, PowerPoint, MS Project, FACETS, Share Point

Bug reporting tool : HP Quality Center. Linborg, CA, Alarm point

Web Technologies : HTML, XML, ASP and JSP.

Database : MS SQL Server, Oracle.

Data Warehousing : SSIS, SSRS, SSAS, Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, BCP, DTS Analysis Manager, SQL profile

Cloud Platforms : Amazon AWS, Cloudstack, Openstack

Data Modeling : Star Schema, Snow-flake schema, FACT Dimensions, ER Models, OLAP/OLTP concepts

Testing software : Load Runner, QTP.

Reporting tool : Splunk 6.2, Linborg

Professional Experience

Florida Power & Light, Juno Beach, FL May 2015 - Present

Splunk Developer/Admin

Worked as Splunk developer, Created Dashboards by using XML and transformed the data into Graphical representations.

Load data sources into splunk including syslog and log files.

Using search processing language commands to get the desired output.

Knowledge on splunk architecture.

Knowledge on universal and heavy forwarders.

Arranged and tested splunk search strings and operational strings.

Used splunk to provide SIEM functionality to aggregate and correlate data from all security systems.

Worked with VM ware virtualization to provision and manage Red hat machines.

Field extraction, using ifx, rex command and regex in configuration files.

Installation of splunk in various platforms like unix/linux, windows and adding the data to the splunk.

knowledge on Amazon AWS, Cloud stack and openstack.

Implement forward configuration, search heads and index.

Used splunk enterprise on AWS to monitor workloads on-premises or in the cloud.

Experience in upgrading splunk versions.

Working on various splunk architecture components and configuring them.

Monitoring the real time data using alerts.

Involved in setting up alerts for different type of errors.

Analyzed security based events, risks and reporting instances.

Create Splunk applications and deploy using Splunk Deployment Server.

Analyze logs in the application by using splunk tool.

Resolving the configuration issues and resolving them.

Identifying bad searches, dashboards and communication with the team to make it a better search.

Assisted internal users of Splunk in designing and maintaining production-quality dashboard.

Coordinating with the business analysts and developers, and discussed issues in interpreting the requirements.

Creating perfect dashboards to better assisting the customers.

Performing Field extraction using lookups, rex and regex in configuration files.

Installing machine data tool and performing indexing.

Using Machine learning predicted numeric fields and categorical fields.

Using algorithms Detected numeric and categorical outliers.

Cluster events using algorithms k-means.

Experience in data ingestion.

Added TBs of data to the splunk and indexed it for the purpose.

Environment: Splunk6.3.4, 6.4.0, Unix/Linux, XML, SPL, AWS, Windows.

Cigna health spring, Nashville, Tennessee Oct 2013 - Apr 2015

Splunk engineer

Experience in indexing Terabytes of data on a daily basis.

Created dashboards and charts for visualizing the data for better analyzing.

Involved in creation of dash boards for the experience

Experience monitoring data through TCP/IP ports.

Set up the configuration like forwarding and receiving the data.

Making the data useful for the configuration.

Used system data to generate dashboard.

Experience in cluster expansion, upgrade and migration.

Implemented map integration in dashboards.

Implemented dynamic drilldown.

Experienced with splunk regex and integrating with reporting tool like JIRA.

Created pivots and data models in splunk.

Populate splunk data from third party data source.

Create splunk applications and deploy using splunk deployment server.

Worked on complete optimization of resources by developing apps in java, pearl and python.

Experienced in splunk forwarder management, data digestion, indexing and field extraction using splunk IFX.

Experienced in splunk deployment like updating the configurations.

Experienced in splunk security apps.

Monitoring splunk server issues and resolving them.

Experienced in Common Information Model.

Validate indexing data for compliance.

Use normalized data in pivots.

Improve performance through data modelacceleration.

Knowledge on HTML/CSS and JAVA Script.

Edited in the source file of CSS file and made the changes in the dashboards.

Converted source file from CSS to HTML for better style changes.

Knowledge on Splunk visualizations and data models.

Data visualization is done and sent as per the requirement.

Worked on saved searches and alerts

Worked on knowledge objects.

Created alerts for finding the errors and resolving it.

Configured search heads for better performance.

Configured Universal forwarders.

Monitored various servers for their better maintenance.

Played a major role in understanding the logs and server data.

Created Reports for various Data Sources.

Configured indexers and forwarders in various platforms.

Captured data from frontend and middle ware applications.

Maintained Shared servers for Splunk and Business Objects

Developed, evaluated and documented specific metrics for management purpose.

Analyzed security based events, risks and reporting instances.

Created Data Models and Pivots for non-functional business users.

Using lookup commands to add a field in an event.

Using bucketing to index, parse and search various data.

Environment: Splunk6.3.2 6.3.3, 6.3.4, 6.4.0, Unix/Linux, XML, SPL, AWS, Windows

Sentient Jet, Boston, Massachusetts Aug2012–Sep 2013

MS SQL Server / BI Developer

Provided Application support. Understand the issues received from the Customer and assist them to provide a solution to issues.

Wrote Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each legacy system interface.

Prepared documentation for the issues received from the end users and uploaded to the defect tracking system.

Troubleshoot project issues by doing Research and Development by scanning all the log tables and implemented code to fix the issue.

Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.

Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.

Designed and developed MOLAP and ROLAP cubes with SSAS.

Designed MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.

Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor, Execution Plan and Index tuning wizard.

Performed API coding using VB for implementing cube at application level.

Implemented VB.Net script and performed testing.

Monitoring the MS SQL Server 2008/2012/2014databases performance by using third party monitoring tools. Alert to production level support for tasks like increasing the hardware, Backup and restoring the databases etc.

Involved Schedules and release process of the application.

Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for Error handling during the ETL process.

Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS 2008/2012/2014.

Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, and Execution Plan and Index Tuning wizard.

Environment: Windows server 2003, SQL Server 2014/2012, MS SQL Server 2014/2012/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Share Point Sever, Office-2007, MS Excel, ProClarity Analysis.

Sunrise Senior Living, Alexandria, Virginia Dec 2011 – Jul 2012

Sr. MS SQL Server / BI Developer

Scheduled SSIS Packages for loading Facts and Dimensions.

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Involved in updating slowly changing dimension strategies.

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Designed and built OLAP cubes to meet reporting needs.

Responsible for identifying and defining Data Source and Data Source views.

Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.

Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.

Designed, Developed and Deployed reports in MS SQL Server using SSRS-2008/2005.

Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.

Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.

Created cubes and defined the dimensions.

Responsible for defining calculated members.

Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)

Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.

Defined attribute properties in a Parent Child Dimensions.

Used Joins to write queries that retrieve data from more than one table.

Responsible for hiding and disabling attributes and attribute hierarchies.

Developed reports that deliver data from cubes.

Created and managed subscriptions for the reports.

Responsible for ongoing maintenance and change management to existing reports and optimize report performance.

Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.

Defined specific read/process permissions for the users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2008 BI Suite, SQL Server 2012/2008R2,SSAS, SSIS, SSRS, ETL, OLAP, OLTP, PROCLARITY, MDX, T-SQL, MS Visual Studio 2012, SQL Profiler.

Fannie Mae, Washington, D.C. Jan 2011 – Nov 2011

Sr. MS SQL Server / BI Developer

Involved in migration from Oracle to SQL Server 2008 using SSIS.

Developed Cubes using SQL Analysis Services (SSAS).

Deployment of SSAS Cubes to the production server.

Generation of reports from the cubes by connecting to Analysis server from SSRS.

Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.

Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.

Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.

Created Indexes to get the high level performance.

Performing the ETL operations to support the data loads and transformations using SSIS.

SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Developed SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.

Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.

Maintained databases, performed software installations and upgrades, monitored Database Performance.

Implemented automated backup and database maintenance / cleanup jobs.

Managing Logins, Users, Roles and User permissions.

Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.

Designed numerous ad-hoc and custom reports using SQL Reporting Services.

Created various Tabular and Matrix Reports using SSRS.

Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2012/2008R2, Query Analyzer, SSIS 2008, T-SQL, Excel, Microsoft SQL Reporting Services 2008 (SSRS), MS SQL Analysis Services(SSAS), Windows 2000/XP, Oracle 7.0.

Credent Technologies, Hyderabad, India Nov2008 - Oct 2010

SQL Server Developer/SQL Server DBA

Created Database as per the requirement of the bank to maintain the student records using SQL server 2005

Maintained and supported the SQL Server databases as a developer helping administrator

Involved in the Data modeling, Physical and Logical Design of Database

Created tables, indexes, sequences, constraints, triggers and procedures

Written Stored procedures and triggers to implement business rules

Involved in integration of the front end with the SQL Server backend

Used DDL and DML for writing triggers, stored procedures, and data manipulation

Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.

Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.

Created Cubes and used basic MDX to retrieve the result set for Calculations.

Worked on advanced dimension Design and Cube design.

Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.

Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

Involved in deployment of SSRS reports on the SharePoint Portal.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Wrote stored procedures to get the fields required for the reports.

Created datasets using stored procedures and reports using multi value parameters.

Maintained disaster recovery Backup and Re-Indexing was implemented to increase the performance

Created user profiles and corresponding read, write and DDL and DML access properties were maintained on the database

Created documentation as required.

Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).

Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i

Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse

Environment: MS SQL Server 2005/2000, T-SQL, DTS, MS-Excel, MS-Office, Oracle8i, SQL Server2008, SQL Server 2005/2000(2003,64-bit edition of SQL server 2000), DTS, Microsoft Business Intelligence Development Studio, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, ERWIN.

EDUCATION

Bachelors of Technology JNTU Hyderabad, India

Contact this candidate