SUMMARY

• 8 years of experience in Data Visualization, Analytics, Data Management, Data Integration, Implementation and Maintenance of Business Intelligence, and the related Database Platforms.
• Experience in Operational Intelligence using Splunk.
• Design, Deploy, and Support enterprise Splunk logging application. Assist other enterprise instances as Splunk Subject Matter Expert SME.
• Proficient with Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
• Expert with various search commands like stats, chart, timechart, transaction, strptime, strftime, eval, where, xyseries, table etc. ; Experience with the usage of Extract Key Word, sed, etc..
• 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.
• Expertise in Actuate Reporting, development, deployment, management and performance tuning of Actuate reports.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator Etc.
• Implemented a Log Viewer Dashboard as a replacement for an existing tool to view logs across multiple applications hosted on a PaaS setup.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Expertise in using the commands like rex, erex, sedandIFX to extract the fields from log files.
• Extensive knowledge in creating accurate reports using XML, Dashboards, visualization and pivot tables for the business users.
• Used techniques to optimize searches for better performance, Search time vs Index time fieldextraction. And understanding of configuration files, precedence and working.
• Knowledge on configuration files in SPLUNK (props.conf, transforms.conf, output.conf).
• Extensive Data Warehouse experience using Informatica 7/8.x/9 Power Center tools (Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Designer, Repository Manager, and Server Manager) as ETL tool on Oracle /DB2 Database.
• Extensive experience in writing Packages, Stored Procedures, Functions and Database Triggers using PL / SQL and UNIX Shell scripts. Also handled Oracle utilities like SQL Loader, import etc.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modelling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse using Informatica Power Centre.
• Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model), and Data Warehousing (ETL).
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub - Queries.
• Ability to manage projects starting with gathering requirements, accordingly deciding andordering hardware, and building, configuring and supporting them.
• Experience in coordinating and working with different infrastructure teams like dba, san, network etc. along with vendors such as IBM, HP, and Splunk etc.
• Excellent understanding of project issues, tracking of issues, solving issues and closing issues.

TECHNICAL SKILLS

Big Data: Splunk, Cassandra, Elastic search, Logstash, Hadoop, HDFS, Hive

BI Tools: SAP BO, SSRS, Crystal Reports, MS Excel

ETL Tools: Informatica, DataStage, Microsoft SQL Server Integration Services (SSIS)

Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio, Rational Rose, DOORS

Databases: Teradata, Oracle, SQL Server, DB2, Sybase, Access

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle, CMMI Compliance, Waterfall, Agile, Iterative

Scripting Languages: Python, Perl, Shell, SQL, PL/SQL, Vizql, C, C++, HTML, COBOL, JCL, and XML

Front End/ Client Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, Teradata SQL Assistant, Toad, Putty, SQL Developer, Share Point

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Splunk Developer/Administrator

Responsibilities:

• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Created Dashboards, report, scheduled searches and alerts.
• Involved in standardizing Splunk forwarder deployment, configuration and maintenance across UNIX and Windows platforms.
• Helped teams to on-board data, create various knowledge objects, install and maintain the SplunkApps, TAs
• Provided services related to java script for advance UI as well Python for advance backend integrations.
• Integrated Service Now with Splunk to generate the Incidents from Splunk.
• Extensive experience on setting up the Splunk to monitor the customer volume and track the customer activity.
• Worked on DBConnect configuration for Oracle, MySQL, and MSSQL.
• Knowledge about Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
• Worked on setting up Splunk to capture and analyze data from various layers Load Balancers, Web servers and application servers.
• Captured data from various front end, middle ware application.
• Field Extraction, Using Rex Command and Regex in configuration files.
• Created many of the proof-of-concept dashboards for IT operations, and service owners which are used to monitor application and server health.
• As in production environment, I was involved in triaging and resolving various complex production issues by analyzing data from various monitoring tools from Sys logs and application logs. This involves working with various teams real time on a conference call.
• Also, worked on code changes for various maintenance and customer reported bugs as part of production support.
• Used techniques to optimize searches for better performance, Search time vs Index time field extraction. And understanding of configuration files, precedence and working.
• Various types of charts Alert settings Knowledge of app creation, user and role access permissions, creating and managing app, create user role Permissions to knowledge objects.
• Create dashboard from search, Scheduled searches o Inline search vs scheduled search in a dashboard.

Environment: Splunk, Linux, UNIX, Bash, Perl, Hbase, Hive, Pig, Oracle 11g, MS SQL Server 2012, SQL.

Confidential - Seattle, WA

Splunk Developer/Administrator

Responsibilities:

• Installation of Splunk head, Indexer and Forwarders on 1000+ servers (Windows & Linux environment).
• Install and maintain the Splunk adds-on including the DB Connect 1, Active Directory LDAP for work with directory and SQL database
• Configure the adds-on app SSO Integration for user authentication and Single Sign-on in Splunk Web
• Configure and Install Splunk Enterprise, Agent, Apache Server for user and role authentication and SSO
• Part of the Devops Team responsible for Application and Infrastructure Monitoring
• Upgraded Splunk to 6.2.3 with patching in multiple servers without downtime.
• Working on indexers and computing servers and with configuration management.
• Monitor the Splunk infrastructure for capacity planning and optimization
• Troubleshoot Splunk search head, Indexer and forwarder issues and document.
• Used Splunk data Connector between Splunk Enterprise and Relational Database
• Provide access on roles, restriction permissions. Report on license usage and set Distributed license system.
• Deploying Splunk updates and license distribution over multiple servers using a deployment server.
• Create Dashboard Views, Reports and Alerts for events and configure alert mail.
• Create Splunk apps for consuming data for applications and implement apps
• Worked based on the concepts of ITIL and ITSM Service Now with SLA Agreements.
• Responsible in scheduling Backups and Restore, Maintenance plans using Native & Third-party tools.
• Responsible for Scheduling and Automating Database tasks - Jobs, Alerts, Emails, Notification.
• Expertise in PowerShell Scripts, created many automation and applied into operations successfully.
• Recovering the databases from backup in disasters
• Design, document and implement moderate to-complex technical solutions
• Participate in cross functional projects as a technical resource and technical lead as a subject matter expert; and participate in product evaluations, gathering system requirements, testing, recommending and implementing solutions.
• Analyzed and monitored incident management and incident resolution problems.
• Resolved configuration based issues in coordination with infrastructure support teams and Splunk support
• Review technical documentation and design documents of lower level engineers
• Worked in team for datacenter migration
• Hands on experience with configuring load balancing devices for vendors like Cisco, F5
• Automated multiple routine tasks through PowerShell
• Design, develop, implement and document moderate to complex technical solutions and ensure deliverables are high quality and meet business expectations, perform general system management, including installation, configuration, and maintenance
• Participate in, lead, and mentor others to translate business requirements into technical designs
• Perform system design, consulting, and participate in planning activities for medium to large projects

Environment: Microsoft Windows Server 2008, 2003, IIS 7.5/6.0, SQL Server 2008/2005, SCOM 2007/2012, Keynote, Splunk, Active Directory Services, DNS, SCCM, .Net 4.5/4.0/3.5, BIG IP F5 & Cisco Switches, Radius, ITIL, MOF, Remedy, ITSM.

Confidential, Boston, MA

SQL/BI Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Used SSIS to migrate and transform data from different sources like SQL server, Oracle, DB2 to different destinations.
• Used joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Used T-SQL for programming for stored procedures and queries.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Performed data conversion from flat file into a normalized database structure.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Created various Weekly and Monthly reports showing detailed information.
• Responsible for creating the reports basing on the requirements using SSRS.
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Developed SSIS Templates which can be used to develop SSIS Packages.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio and updated in Visual studio 2008.
• Developed, monitored and deployed SSIS packages.

Environment: SQL Server 2012/2008/2005/2000, Oracle,DB2,SSIS, SSRS, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

Confidential, Chicago, IL

SQL Server BI Developer

Responsibilities:

• Involved in User Requirement Gathering and Technical Specification Documentation.
• Developed Stored Procedures, Functions, Triggers and Cursors.
• Used Inner joins, Outer joins and other Complex joins for data retrieval from complex tables.
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Set up the SSIS packages for the exchange of data between different data sources.
• Defined and processed the Fact table & Dimensions using SSIS.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Co-developed the ETL architecture design and the metadata model.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc.).
• Used various ETL tools like DTS/SSIS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated SQL Server 2000 DTS objects to SQL Server 2005 integration services (SSIS) environment.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the users.
• Involved in designing of Star, Snowflake schemas and dimensional data models.
• Designed/implemented the information access and delivery effort for the data warehouse.
• Created logical and physical data models according to the business requirements.
• Monitored the performance of SQL Server using SQL Server Profiler.
• Designed different kinds of transactions for the application.
• Performed data transformation services and bulk inserts for large amounts of data.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Experienced in setting up SQL Server and database configuration parameters.
• Developed a Tabular Reports using SSRS Report Designer.
• Debugging reports and deploying reports on server.
• Installed and administered Microsoft SQL Server Reporting Services. Configured SMTP server and scheduled reports and send the reports via email.
• Created ad-hoc reports using SSRS Report Builder.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005, Windows 2003 server.

Confidential, Long Island, NY

SQL Server / SSIS / SSRS / Developer

Responsibilities:

• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Monitored and modified Performance using execution plans and Index tuning.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Involved in Scheduling jobs using MS SQL server Agent.
• Created and managed users, login IDs, security, and add groups to Windows and SQL Server.
• Involved in Performance tuning of existing database objects such as stored procedures and complex stored procedures
• Prepared documentation related to database design, objects security and rules.
• Created DTS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat Files.
• Performed daily database backup & restoration and monitor the performance of Database Servers.
• Generate various ad hoc reports using MS Reporting services.

Environment: SQL Server 2000/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows XP.

Confidential 

SQL Server DBA

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created & managed the Database Users, Login and Security.
• Scheduled database backups and restored the Database from DR.
• Provide 24X7 support to all Production, QA & Development MS SQL Server Environments.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
• Configured Replication Server, worked on replication server.
• Logical and Physical Data Modeling using Erwin.
• Identified the necessary steps to enhance user response time by checking fragmentation and re-index tables for efficient application access methods.

Environment: SQL Server 2000/2005 Enterprise Edition Advanced Windows 2003 Server, Erwin, SQL RedGate, SQL Backup, and Dell Power Edge 8450.