TECHNICAL SKILLS

• MSSQL Server 2014, 2012, 2008 R2, 2005, MySQL, oracle 9i/10g
• Splunk Enterprise 6.x, 7.x, Hive, HDFS, Hive, Sqoop, Pyspark, Impala, Teradata.
• SPL, TSQL, HQL, MySQL, VB, XML, Shell, Python.
• Jasper Soft, Power BI, Ad - hoc Reporting, Splunk, Tableau, Splunk ES.
• SSIS, DTS, BIDS, SSDT, Management Studio

PROFESSIONAL EXPERIENCE

Big Data/Splunk Admin & Developer

Confidential, Phoenix, Arizona

Responsibilities:

• Involved in modeling different key risk indicators in Splunk and building extensive Hive & SPL quires to understand behavior across the customer life cycle.
• Installed and configured components such as universal forwarders, Deployment server, indexers, search heads etc.
• Experience with Index Clustering, Search Head Clustering and Installed Indexer Cluster on AWS and GCP.
• Built and configured a virtual data center in AWS cloud to support enterprise data warehouse hosting including VPC, public and private subnets, security groups, route tables.
• Integrated logs of Network Devices, Switches and Routers to perform network monitoring.
• Experience in Field extraction using IFX, Rex command and Regex in configuration files and Managing multiple data sources Via centralized deployment server.
• Created and Managed Splunk DB connect identities, connections, inputs, outputs, lookups and access controls.
• Experience with Splunk Enterprise security app (ES) by Performing data investigation and data analysis to address security vulnerabilities, incidents and penetration techniques.
• Created dashboards, reports and alerts for real time monitoring in Splunk, Tableau and Jaspersoft.
• Good knowledge of Hadoop Architecture and various components such as HDFS, Resource Manager, Name Node, Data Node, MapReduce concepts with latest yarn concepts.
• Developed Spark SQL scripts to access hive tables in spark for faster data processing.
• Stored real-time data from spark on HBase for future analysis.
• Streamed data files using Flume into HDFS and load into hive tables to query data.
• Created hive tables, implemented partitioning, dynamic partitioning and bucketing in hive for efficient data access.
• Wrote Python scripts to Automate data extraction from different CSV, databases, API and parse the data as per required.
• Wrote Shell scripts to get and post data from API and write to CSV’s and create Automated tickets in Service now.
• Provided production support development (Quick Fixes) and technical support for complex critical applications

Environment: Splunk Enterprise 6.x,7.X, Splunk Enterprise Security App, Tripwire, Db Connect v2.0, 3.0, Hive 2.x, Hadoop, Hive, HDFS, Unix Shell Scripting, Teradata, Python, Tableau, JasperSoft, SQL server 2014, XML, Bit Bucket, Rally, Jira, Service Now, Agile.

Splunk Developer

Confidential

Responsibilities:

• Knowledge on Installation, configuration and deployment of Splunk forwarders, indexers, search heads and deployment server.
• Have knowledge in various search commands like stats, chart, time chart, transaction, strptime, strftime, eval, where, table and difference between event stats and stats.
• On boarding of new data into Splunk. Troubleshooting Splunk and optimizing performance.
• Creating and managing app, create user, role, permissions to knowledge objects
• Created alerts, saved searches and dashboards.
• Gathered requirements and converted them into database objects - Tables, Views and SSIS packages, SSRS reports.
• Created SSIS Packages for data load process using containers as For-Each Loop, For Loop, and Sequence.
• Wrote store procedures, Functions, views according to the requirements.
• Increased performance of existing slow running SSRS reports and store procedures.
• Used error handling, coding, trouble shooting, Event handlers for performance tuning of SSIS package.

Environment: Splunk, Visual studio 2012, Oracle 11g, SQL server 2012, Teradata, SSIS, SSRS, HTML, XML, Linux, Jira.

SQL BI Developer

Confidential

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements.
• Created Database and Objects like Stored Procedures, Views, Triggers, user defined data types and functions.
• Designed SSIS Packages to extract, transform and load (ETL) data from various sources into SQL Server 2008R2/2012.
• Enhance and deployed SSIS Packages from development server to production server.
• Utilized different transformations like fuzzy lookup, derived column, conditional split and Multi cast.
• Coordinated with test engineers to perform unit testing and regression testing at various levels of the ETL.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Managed the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application database.
• Working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.

Environment: SQL Server 2008/2008 R2, SSIS, SSRS, Performance Point Server, SQL Server Business Intelligence Development Studio (BIDS), TSQL, VB.NET, ASP.NET, Python, C#, MS Excel, TSQL, ASP, MS Visual Studio .NET, Unix.

Software Engineer

Confidential

Responsibilities:

• System administrator in a windows environment consisting of windows 7, windows server 2008, VMware, vSphere.
• Utilized enterprise active directory to create, delete, and modify user accounts, computers, and peripherals.
• Done troubleshooting problems in operating system programs and applications.
• Performed administrative tasks such as backup strategy, documentation Security etc.
• Involved in configuration and implementation of DNS and DHCP servers.
• Written T-SQL queries for the retrieval of the data.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Generated scripts to import data for status and sub status.
• Work with RDBMS utilities to perform backup and restore operations.
• Installed, tested, and configured new workstations, peripheral equipment, and software.
• Monitored service desk for tickets assigned to the queue and process first -in first-out based on priority.
• Provided one on one assistance to the end user regarding the technical flaw.
• Network administrator for IT managed services provider focusing in the consultation administration.

Environment: Windows 07/2008, SQL Server 7.0/2008, Enterprise Manager, SQL Profiler, DTS, TSQL, BCP.