SUMMARY

• 8 years of experience in designing, developing and delivering automation projects using SPLUNK, ETL & SQL.
• Experience in analyzing big data and reporting it to the leadership and technology teams to improve the processes.
• Expert in analyzing data, correlating trends, building reports and report writing.
• Proficient in working with large datasets to generate insights by using Splunk.
• Experience in Installation and Maintenance of Splunk Universal Forwarders, Solving Forwarder Issues, Deployment Server Classes and Apps through Deployment Server.
• Proficient in writing complex IFX, rex and Multikv command to extracts the fields from the log files.
• Expert in using SPL to create Visualizations.
• Experience in Preparing, arranging and testing Splunk search strings and operational strings.
• Experience developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis.
• Expert in installing and using Splunk apps for Unix and Linux (Splunk nix).
• Experience with Splunk authentication and permissions.
• Extensive experienced in Business Intelligence Development Studio (SSIS & SSRS)
• Extensive experience in using SQL Server Integration Services (SSIS) to extract, Transform and Load (ETL) data from any data source.
• Experience in writing T - SQL and C# in SSIS
• Experience in the usage of variable, parameter and expression in SSIS
• Experience in Data Flow Tuning and Optimization. Experience in Event and Error Handling
• Familiar with Star Schema, Snowflake Schema, Fact Table and Dimensional Table & SCD (Slowly Changed Dimension)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill-down, drill-through, Tabular, Matrix, Chart and Sub Reports
• Expert at configuring the report server using reporting services configuration manager and creating T- SQL MDX (Multidimensional Expression) reports using SSRS.
• Experience in Data Mining and analyze the hidden trend in data
• Experience in Reporting Services Configuration Manger
• Experience in SQL Server Agent to schedule the job both in SSMS and BIDS
• Extensive experience in Source Code Control, using Subversion Control; familiar with Team Foundation Server (TFS)
• Proficient with Microsoft Excel (VBA & Macro) and other Microsoft Office tool
• Worked closely with the architect and team in designing, developing and implementing the logical and physical model for the Data Mart.
• Experience in different team projects with good project implementation experience, team skills, troubleshooting, presentation abilities and issue resolution capabilities.
• Strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Languages: C, C++, java, PL/SQL, TSQL

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008/2005/2000, Sybase, DB2 MS Access.

Web Technologies: HTML, XML, VB Script, UNIX shell script, Java Script, SOAP, CSS, SQL, Hadoop and MVC

Operating Systems: Windows 95/98/2000/XP/NT/2008, MS DOS, UNIX7, LINUX

Tools: SPLUNK 6.0,SPLUNK 6.2.2,SPLUNK 6.2.3, QlikView, Tableau, OBIEE, SAP Business Objects, SSRS

Data Warehousing: Informatica Power Center/Power Exchange 9.5/ 9.1/8.5/8.1.1/7.1.2, Informatica Designer, Workflow Manager, Work flow Monitor, Datamart, Mapplet, Transformations, Informatica Metadata Manager

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT-Dimensions), Conceptual Physical and Logical Data Modeling, ER Models, OLAP, OLTP concepts, Entities, Attributes, Cardinality, CA Erwin DM (9.x/8.x/7.x)

PROFESSIONAL EXPERIENCE

Confidential - Ann Arbor, MI

Splunk Developer/Administrator

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, Pivotal HD, Datameer, Linux, Bash, Perl, Hbase, Hive, Pig, Hawq, Sed, rex, erex, Splunk Knowledge Objects

Confidential - Phoenix, AZ

Splunk Developer/Administrator

Responsibilities:

• Responsible for maintaining, upgrading, deployment and proper configuration of Splunk servers. Level 2 support for on-boarding of log files. Assist users with the creation of apps and creating dashboards.
• Installation of Splunk head, Indexer and Forwarders on 1000+ servers (Windows & Linux environment)
• Install and maintain the Splunk add-on including the DB Connect 1, Active Directory LDAP for work with directory and SQL database
• Configured Splunk Searching and Reporting modules, Knowledge Objects, Administration, Add-On's, Dashboards, Clustering and Forwarder Management.
• Managed the splunk licenses and restricted the daily indexing limit.
• Splunk DB Connect 2.0 in search head cluster environments of Oracle, MySql.
• Experience with Splunk UI/GUI development and operations roles.
• Automating in Splunk using Perl with Service-Now for event triggering.
• Deployed Splunk updates and license distribution over multiple servers using a deployment server.
• Create Dashboard Views, Reports and Alerts for events and configure alert mail.
• Provides Splunk technical and infrastructure consulting services to clients.
• Completes tasks in an efficient and timely manner reporting progress to the implementation Project Manager and Engagement Manager.
• Used Splunk data Connector between Splunk Enterprise and Relational Database.
• Monitor the Splunk infrastructure for capacity planning and optimization
• Troubleshoot Splunk search head, Indexer and forwarder issues and document.
• Server monitoring using tools like Splunk, Solarwinds-Orion, HP BSM and HP Open View.
• Interpreted and developed SIEM products to meet the internal and external and customer requirements.
• Integrated ServiceNow with Splunk to generate the Incidents from Splunk.
• Worked in team for datacenter migration.
• Provided Strategic support of Splunk integration and deployment, configuration and maintenance.
• Resolved configuration based issues in coordination with infrastructure support teams and Splunk support.
• Responsible in scheduling Backups and Restore, Maintenance plans using Native & Third-party tools.
• Review technical documentation and design documents of lower level engineers.

Environment: SPLUNK 6.1.3, SPLUNK 6.2, Unix, Oracle 11g, ServiceNow, MS SQL Server 2012, SQL server, Unix Scripting

Confidential - Atlanta, GA

SSIS/SQL Developer

Responsibilities:

• Actively Discussed Requirements from Business Analyst and Developed documents based on functional specification.
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation.
• Created appropriate Triggers to assist efficient data manipulation and data consistency.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations and created the SSIS /DTS packages and scheduled them.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed Query for generating Drill Down and Drill Through Reports in SSRS 2008.
• Generated and formatted Reports using Parameters and Expressions for the Reports. Designed and Implemented stylish report layouts.
• Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Managed Logins, Roles, security and permission on different database objects

Environment: SQL Server 2008, BIDS 2008, Microsoft Visual C # 2008 Express Editions, SharePoint 2010, Microsoft Visual SourceSafe, T-SQL, Windows 2008 Server

Confidential - Quincy, MA

SSIS Developer/MSSQL Developer

Responsibilities:

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into Data Warehouse and Data Mart.
• Involved in Extract, Transform and Load (ETL) process framework.
• ETL development using T-SQL programming, scripts, stored procedures, views.
• Developed SSIS packages using different types of Error Handling for various events.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (DB2, Text files and Excel files) to SQL Server.
• Involved in Performance tuning and Query Optimization.
• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).
• Created Clustered index and Non-clustered for increasing performance.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Involved in user interface design and developed scripts to support client business needs.
• Perform data load into star schema and cube refresh (dimensions and measures).

Environment: SQL Server 2008SR2, SQL BI Suite (SSIS, SSAS, SSRS), MS Visio2005/2008, Windows Server 2003.

Confidential, Bradenton, FL

SQL Server/ SSIS Developer

Responsibilities:

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into ODS.
• Involved in Extract, Transform and Load (ETL) process framework.
• ETL development using T-SQL programming, scripts, stored procedures, views.
• Developed SSIS packages using different types of Error Handling for various events.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (DB2, Text files and Excel files) to SQL Server.
• Developed complex queries using joins and sub-queries.
• Experience with ER and Dimensional modeling.
• Created multiple views and queries for complex SSRS reports.
• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).
• Involved in user interface design and developed scripts to support client business needs.
• Perform data load into star schema and cube refresh (dimensions and measures).

Environment: SQL Server 2008SR2, SQL BI Suite (SSIS, SSAS, SSRS), DB2, MS Office, Windows XP

Confidential

SQL Server Developer

Responsibilities:

• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data into database, archive data file from different DBMS's using SQL Enterprise Manager/SSMS on SQL Server 2000 environment and deploy the data.
• Worked on DTS Packages, DTS Import/Export Wizard for transferring data from different types of Databases to SQL Server.
• Designed ER diagrams and mapped the data into database objects.
• Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
• Created joins and sub-queries for complex queries involving multiple tables.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Created Indexes for fast retrieval of the data.
• Worked on Exception Handling with @@error and Try/Catch blocks.

Environment: MS SQL Server 2005, Windows NT, SQL Profiler, Access, Excel, Windows 2000, Query Analyzer, Enterprise Manager, Data Transformation Services (DTS).