Vikas Baranwal Email & Phone Number

• Splunk Enterprise Admin certified.• 2+ years of experience in the SPLUNK Development and Admin.• Searching and Reporting with SPLUNK.• Creating Knowledge objects with SPLUNK• Experience in CIM, creating lookups, field Aliases, Calculated fields, field extractor, Tags and event types, workflow actions, Alerts and scheduled reports, Macros with Splunk.• Worked with Data models i.e. Pivots.• Knowledge of Splunk Infrastructure i.e. deployment, pipeline, inputs, apps, indexes, monitoring.• Around 5 + years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2.• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS.• Experience in ETL processes involving migrations and in sync processes between two databases.• Basic knowledge of C# in script component in SSIS.• Exposure in creating tables, schemas, identifying the columns for keys, indexing and constraints.• Working knowledge in creating cursors.• Exposure to SQL Profiler.• Working experience in identifying the deadlocks and resolving them.• Exposure to creating and scheduling jobs in SQL Server Agent.• Database creation, backup and restoration activities.• Exposure in handling multiple filegroup, creating/managing the file groups.• Handling the security and granting/revoking access, creating logins and assigning roles in the database.• Working knowledge in Log shipping.• Performance tuning, query analysis and creating indexes.• Regular cleanup/backup/archive of the historical data.

Listed skills include Sql, Microsoft Sql Server, Splunk, Windows, and 5 others.