SUMMARY

• 10+ years of core experience in Data warehousing & Business Intelligence/Business Analytics software and Monitoring of Infrastructure and Security.
• Certified Splunk Developer having experience in Splunk solution design, architect, deployment and configuration Splunk components (Forwarders, Indexers, Search heads etc.) & development (creation of dashboards/reports, alerts and Splunk integration).
• Experience with Splunk Searching and Reporting modules, Knowledge Objects, Administration, Add - On’s, Clustering and Forwarder Management.
• Expertise in Splunk Query Language and Monitored Database Connection Health by using Splunk DB Connect Health dashboards.
• Having experience in configuring Indexers, Forwarders (Universal and Heavy).
• Install and maintain the Splunk adds-on including the DB Connect for Teradata, *nix and jmx.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Worked on log parsing, complex Splunk searches, including external table lookups.
• Strong experience with products ofMicroStrategy9x suite namely Desktop, Web, Command Manager, Object Manager, Enterprise Manager and Narrowcast Server.
• Expertise has been concentrated in all the phases like Architect, Design, and Development& Administration of Microstrategy suite.
• Proficient in all phases of the Report development lifecycle, including requirements gathering, Design, Development, System Testing and User Acceptance & Support.
• Good understanding of concepts such as Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables.
• Extensive hands on experience architecting a Microstrategy project and building reports and dashboards
• Design, developing, deploying, maintaining and integrating complex Microstrategy reports, dashboards using Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, users, user groups, security filter etc.) using MicroStrategy desktop.
• Highly experienced in developing Transaction services screen that allow users to take action on a decision from directly within a MicroStrategy application by inserting, updating, or deleting rows in the underlying data source.
• Good at writing complex SQL Queries in Teradata to perform Data Validation and Graph validation to make sure test results matched back to expected results based on the user needs.
• Hands on experience in Project Migrations between DEV / UAT & PROD environments.
• Experienced in Enterprise Manager Setup & Statistics Report Development.
• Experience in developing Security Filters, Access Control Lists, Security Roles and assigning privileges.
• Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for Teradata.
• Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Extensively worked on performance tuning to reduce the run time of Microstrategy reports.
• Extensively used Microstrategy Visual Insight to create reports and dashboards using the data stored in Hive Tables by connecting through Hortonworks Hadoop, Amazon Web services EC2/S3.
• Extensively used Hue application to run HIVE and Cloudera Impala queries for unit testing.
• Extensively used Hadoop Map Reduce Job tracker to monitor the jobs.
• Created customized reports using various chart types like text tables, bar, pie, Heat maps, line charts, Area charts, scatter plot, dual combinations charts in Tableau.
• Developed views using advanced calculations like filters, Parameters, Actions, Table calculations, Logical calculations, date calculations, and Trend Lines.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience in modeling and developing logical/physical data models using entity-relationship modeling tools like ERWIN.
• Experience in performing System, Functionality, User Acceptance, Integration and Regression testing.
• Strong knowledge and understanding of SQL and ability to write SQL queries.
• Able to handle different projects concurrently and Lead experience.
• Good Working Knowledge in Agile Project management (Scrum process).

TECHNICAL SKILLS

BI Tools: Splunk 6.3, Microstrategy 8.x, 9.x, Tableau 7, 8.X.

Databases: Teradata, Sybase IQ, Netezza, Oracle 10g, Oracle exadata, SQL Server2008, MS Access

Big Data: Hortonworks Hadoop, Amazon Web services EC2/S3.

DataModeling Tools: ErwinR8

Scripting: Python, Windows Powershell

Operating system: Unix/Linux, Windows98/2000/XP/7, Windows Server2003

PROFESSIONAL EXPERIENCE

Confidential

Splunk Architect

Environment: Splunk 6.3.x, Teradata 15, Unix/Linux, Windows

Responsibilities:

• Establishing GRT Splunk framework and common Splunk repository.
• Provide Splunk functional expertise/knowledge and administration of Splunk environment.
• Infrastructure configuration and maintenance (Search Head, Indexer Cluster, License Master, Universal Forwarder, Heavy forwarder, Load Balancer for Search Head/Heavy forwarder).
• Install and maintain the Splunk adds-on including the DB Connect for Teradata, *nix and jmx.
• User provisioning, User training and support.
• Writing requirement and design documents for Splunk objects.
• Troubleshooting the issues related to Splunk.
• Design and developed the dashboards to do the data analysis.
• Define testing and deployment strategy.
• Splunk object/dashboard development and testing.
• Plan and manage application support.
• Platform Health monitoring and capacity management.

Confidential

Splunk Admin/Architect

Environment: Splunk 6.2.x/6.3.x, python, Teradata 15, Unix/Linux, Windows

Responsibilities:

• Estimating storage for indexes considering basic sizing criteria like amount of incoming data, amount of indexed data, number of concurrent users, number of scheduled searches and types of searches.
• Scaling splunk by additional disk storage for indexer clustering and summarization and acceleration
• Allocating licensing capacity and managing licensing usage of all instances using License Master
• Managing splunk configuration files for deployment clients using Deployment server
• Monitoring performance details across the splunk environment with Distributed Management Console.
• Created a job server a search head that only runs scheduled searches.
• Enabling the indexer cluster master node that coordinates the activities of the peer nodes
• Extensively used deployer to distribute apps and configuration updates.
• Established multisite indexer cluster that spans multiple sites and also for disaster recovery and search affinity
• Assisting application teams on logging formats and best practices

Confidential

Splunk Consultant

Environment: Splunk 6.2.x/6.3.x,python, linux/unix, Windows 7

Responsibilities:

• Build and manage a production splunk environment. create and maintain splunk indexes.
• Manage users, roles, and authentication options.
• Deploy forwarders with forwarder management.
• Configure common splunk data inputs.
• Customize the input parsing process.
• Configure a distributed search environment.
• Monitor a Splunk instance with Distributed Management Console.
• Configure system alerts.

Confidential, Oakbrook, IL

Technical Lead

Environment: Splunk 6.2.x, linux/unix, Windows 7

Responsibilities:

• Installation and configuration ofSplunkproduct at different environments.
• Involved in Installation, Administration and Configuration ofSplunkEnterprise and integration with local legacy systems.
• ConfiguredSplunkSearching and Reporting modules, Knowledge Objects, Administration, Add-On's, Dashboards, Clustering and Forwarder Management.
• Hands on development experience in customizing, visualizations, configurations, reports and search capabilities using customizedSplunkqueries.
• Knowledge aboutSplunkarchitecture and various components (indexer, forwarder, search head, deployment server), Heavy Forwarder and Universal forwarder, License model.
• Designing and maintaining production-qualitySplunkdashboards.
• Good experience inSplunk, WLST, Shell scripting to automate and monitor the environment routine tasks.
• SplunkEnterprise Deployments and enabled continuous integration on as part of configuration management.
• Experience on Configured and developed complex dashboards and reports onSplunk.
• Expertise in creating and customizingSplunkapplications, searches and dashboards as desired by IT teams and business.
• Drive complex deployments ofSplunkdashboards and reports while working side by side with technical teams to solve their integration issues.
• Created Regular Expressions for Field Extractions and Field Transformations inSplunk.
• Responsible for documenting the current architectural configurations and detailed data flow and Troubleshooting Guides for application support.
• Expertise in creating and customizingSplunkapplications, searches and dashboards as desired by IT teams and business.
• Managed Indexer Clusters including security, hot and cold bucket management and retention policies.
• Worked on Various types of charts, alerts settings, app creations, user and role access permissions.
• Integrate Service Now withSplunkto consume the alerts fromSplunkand create service now tickets.
• Splunkconfiguration that involves different web application and batch, create Saved search and summary search, summary indexes. Managing indexes and cluster indexes,Splunkweb framework, data model and pivot tables.
• Performed troubleshooting and/or configuration changes to resolveSplunkintegration issues.

Confidential, Oakbrook, IL

Technical Lead

Environment: Microstrategy 9.3.1, Teradata 13, Windows 7

Responsibilities:

• Participating in meetings and interactions with Confidential ’s team for status updates, discussions for business requirements
• Requirements Gathering & analysis for enhancement of Reports using Microstrategy.
• Creating technical/design specification’s to be used for development/coding for Break fixing
• Microstrategy Report analysis.
• Analyzing the business logic of the application.
• Reporting or Escalation of Issues/Concerns /Achievements related to the project.
• Responding data related queries raised by end user.
• Suggestions provided for performance improvement.
• Break fixing critical production issues (Reports) as well as data issues.
• Change management process to migrateMicroStrategyprojects and objects between QA, UAT, andProduction environments by creating and applying packages and undo packages for roll backprocedures.
• Automating the user reports for the client so they have data available to do their analysis on a timely and efficient manner.
• Implement user level security, object security, user roles and groups, create, modify and delete users, govern thresholds, set up distribution services using Narrowcast Server, install and configure MicroStrategy Desktop.
• Creation and maintenance of report schedules using Distribution services and Narrowcast server.

Confidential, SFO, CA

Programmer Analyst

Environment: Microstrategy8.x/9.x, Sql Server 2008, Sybase IQ, Windows 2003 Server

Responsibilities:

• Gathering business requirements, established functional specifications, translated them to design specifications.
• Participating in Sprint meetings with QA, DB teams, Product Manager, Project manager etc.
• Used MicroStrategy Desktop to generate MSTR Reports.
• Identified and Created Application objects like Metrics, Prompts Filters, Custom Groups, and Consolidations using Micro Strategy Desktop.
• Identified and Created Schema objects like Attributes, Facts for the report development using MicroStrategy Desktop.
• Developed Dashboards for easy analysis of the data.
• Created ad-hoc reports and report templates for end users.
• Using Object Manager promoted the objects from Development to Testing and using package in 9.x.

Confidential, SFO, CA

Microstrategy Developer

Environment: Microstrategy8.x, Netezza, MS SQL Server, Windows 2003 Server

Responsibilities:

• Gathering business requirements, established functional specifications, translated them to design specifications.
• Participating in Sprint meetings with QA, DB teams, Product Manager, Project manager etc.
• Used MicroStrategy Desktop to generate MSTR Reports.
• Identified and Created Application objects like Metrics, Prompts Filters, Custom Groups, and
• Consolidations using Micro Strategy Desktop.
• Identified and Created Schema objects like Attributes, Facts for the report development using MicroStrategy Desktop.
• Developed Dashboards for easy analysis of the data.
• Created Templates to maintain a standard interface for the reports.
• Created ad-hoc reports and report templates for end users.
• Using Object Manager promoted the objects from Development to Testing and using package in 9.x.