SUMMARY

• Over 8 years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, requirement assessment, design, analysis, development, documentation, coding, enhancement, testing and implementation of the business technology solutions. Extensive experience in developing scalable enterprise applications to the user needs which serves for Financial, Auto Insurance, Health Insurance, and Automobile Industries.
• Worked in Data modeling, OLTP/OLAP, Operational Intelligence, Business Intelligence (BI), Client - Server, 3-Tier technologies, ORACLE /11g/10g/ 9i, PL/SQL, SQL*Plus.
• More than 3+ years of experience in Splunk 5x and 6x product, Distributed Splunk architecture and components including indexers, forwarders, search heads etc.
• More than 5 years BI of experience using Cognos10.2,Cognos 8,Cognos Impromptu, Framework Manager, Report Studio, Analysis Studio, Active Reports, Metrics Manager, Workspace, Query Studio, Power Play, Transformer, Impromptu Web Reports, Upfront, Scripting, ODI and Microsoft SQL Server 2008/2012.
• Knowledge about Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
• Developed custom app configurations (deployment-apps) within Splunk in order to Parse, Index multiple types of log format across all application environment setup Splunk Forwarders for new application levels brought into environment. Gained knowledge on searching concepts Hot, Warm, Cold, Frozen bucketing.
• Worked on large datasets to generate insights by using Splunk. Expertise with the usage of various search commands like stats, chart, time chart, transaction, strptime, strftime, eval, where, xyseries, table etc and . Difference between event stats and stats.
• Experienced in using Ifx, Rex Command and Regex in configuration files. Performed production error monitoring and root cause analysis using Splunk.
• Experience in Operational Intelligence using Splunk and installing Splunk apps for Linux and UNIX environments.
• Used techniques to optimize searches for better performance, Search time vs Index time field extraction. And understanding of configuration files, precedence and working.
• Experienced in using Time chart attributes such as span, bins, Tag, Event types, Creating dashboards, reports using XML. Created dashboard from search, Scheduled searches Inline search vs scheduled search in a dashboard.
• Experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
• Experience in developing complex reports using Drill-through reports, Prompts, Master-detail, Burst-reports, Conditional formatting, complex hierarchical list reports, Dynamic filtering in Cognos.
• Expertise in creating Dashboard reports using Java Script in Report studio.
• Extensive Data Warehouse experience using SSIS, SQL server integration services, 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.
• Experienced in all data processing phases from the Enterprise Model, Data Model (Logical and Physical Model), and Data Warehousing (ETL)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.
• Experience in using dimensional/star-schema based data structures
• Team player with excellent communication, presentation and interpersonal skills..
• Highly motivated team player with zeal to learn new technologies.
• Excellent understanding of project issues, tracking of issues, solving issues and closing issues.

TECHNICAL SKILLS

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

Databases: Oracle 11g/10g/9i/8i, Vertica, DB2.

Programming: SQL, PL/SQL, SQL Plus, Unix Shell Scripting, C

Environment: Win 9x/NT/2000/XP, Unix, Linux, Cognos 10.2.2 (Framework Manager, Report Studio, Query Studio, Cognos GO Mobile, Cognos SDK), Power play transformer, JSP, HTML, SplunkEnterprise Server 4.x.x/5.x.x/6.x.x, UniversalSplunkForwarder 4.x.x/5.x.x/6.x.x, RedHat Linux, IBM HTTP Web Server 6.1/7/8, Oracle, HACMP 5.4, HTML, Java Script, XML, Wily Introscope 9.x, IIS 7, Windows 2003, Windows 2008 R2, Python (Jython), Regular Expressions.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr.Splunk Developer

Responsibilities:

• Developing a new Splunk environment in multiple servers with 2 head servers, Search Head and node servers and training fellow team mates with the implementation of Splunk
• Knowledge about Splunk and logging architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
• Expertise in Actuate Reporting, development, deployment, management and performance tuning of Actuate reports.
• Helping application teams in on-boarding Splunk and creating dashboards/alerts/reports etc. c
• Played a major role in understanding the server data & logs, brought an insight of the data for the users.
• Provide regular support guidance to Splunk project teams on complex solution and issue resolution.
• Extensive experience on setting up the Splunk to monitor the track the customer activity and customer volume.
• 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 team's real time on a conference call.
• Integrated Service Now with Splunk to generate the Incidents from Splunk
• Created Shell Scripts to installSplunkForwarders on all servers and configure with common configuration files such as Bootstrap scripts, Outputs.conf and Inputs.conf files.
• Create dashboard from search, Scheduled searches online search vs scheduled search in a dashboard.
• Created many of the proof-of-concept dashboards for IT operations, and service owners which are used to monitor application and server health Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• Worked with administrators to ensure Splunk is actively and accurately running and monitoring on the current infrastructure implementation
• Extensively involved in troubleshooting the issues and document the problem resolutions for future references.
• Attended Change management meetings for approval for the applications which are supposed to go live and provided the MOM of CM meetings to the team.
• Experienced in Installation and Maintenance of Splunk Universal Forwarders, Solving Forwarder Issues, Deployment Server Classes and Apps through Deployment Server.
• Responsible to check the Splunk logs for web server so as to avoid server time down during production are used to monitor application and server health.
• Configured Splunk for all the mission critical applications and used Splunk effectively for Application troubleshooting and monitoring post go lives.
• Create dashboard from search, Scheduled searches online search vs scheduled search in a dashboard.
• Experienced in Installation and Maintenance of Splunk Universal Forwarders, Solving Forwarder Issues, Deployment Server Classes and Apps through Deployment Server.
• Experienced in attending the bridge calls for production issues and non-prod issues and involved application teams or database teams or networking teams to resolve the issues and involved in Root cause analysis for the issues encountered. Also provided 24/7 on call support for all the production applications.
• Implemented Forwarders (Universal and Heavy) with Load Balancing, Splunk Forwarder Management.

Environment: SplunkEnterprise Server 4.x.x/5.x.x/6.x.x, UniversalSplunkForwarder 4.x.x/5.x.x/6.x.x, RedHat Linux, IBM HTTP Web Server 6.1/7/8, Oracle,Service Now, HACMP 5.4, HTML, Java Script, XML, Wily Introscope 9.x, IIS 7, Windows 2003, Windows 2008 R2, Python (Jython), Regular Expressions.

Confidential, Columbus, OH

Splunk Developer

Responsibilities:

• Extensive experience on Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model
• Responsible for completing a full, independent review of each requirement/specifications.
• Creating DevOps dashboard that aggregates data across multiple services to identify critical threats and proactively mitigate risks.
• Experience in setting up dashboards for senior management and production support- required to use SPLUNK.
• Prepared, arranged and tested Splunk search strings and operational strings.
• Analyzed security based events, risks and reporting instances.
• Provide regular support guidance to Splunk project teams on complex solution and issue resolution WITH the objective of ensuring best fit and high quality.
• Onboard new log sources with log analysis and parsing to enable SIEM correlation.
• Monitoring tool to measure a particular problem or the contribution of a particular technique over time.
• Wrote and ran UNIX shell scripts of preprocessor for certain batch and Control-M jobs across multiple environments.
• Worked closely with cross functional team to design new features and resolve issues as they arise.
• Integrated Service Now with Splunk to generate the Incidents from Splunk.
• Analyzed large datasets to identify metrics, drivers, performance gaps and opportunities for improvement.
• Worked on large datasets to generate insights and communicate insights to guide strategic roadmap.
• Deployed Active Directory/LDAP authentication across entire Linux environment.
• Performed field extraction using IFX in an event action.
• Created, documented, maintained disaster recovery plans.
• Used Splunk tool in order to analyze the logs in the applications.
• Involved in handling various Incident and request related to the application.
• Good command on Linux OS and debugging performance issues.
• Involved in testing FACETS for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition and Premium Rate Tables.

Environment: Splunk 6.X, Oracle SQL, PL/SQL, DB2 Linux OS, Service Now, XML, XSLT, SIEM, JMS.

Confidential, Columbus, OH

Cognos Developer

Responsibilities:

• Implemented Data Analytics using Cognos BI Suite v10.2 to support Claims and Reimbursement Dept.
• Understood the source system and interacted with users to acquire the elaborate technical and business requirements and required documentation for clear understanding and traceability of requirements.
• Installation and configuration of the Cognos 10.2 in Development environment.
• Experience in developing complex reports using Drill-through reports, Prompts, Master-detail, Burst-reports, Conditional formatting, complex hierarchical list reports, Dynamic filtering in Cognos.
• Experience in building models using Framework Manager. Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Created Dashboard reports using the Cognos Report Studio.
• Knowledge in developing Active reports.
• Extensive knowledge in writing complex SQL and Stored procedures.
• Developed ad-hoc reports using Query Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple.
• Conceptualize and formalize several list, crosstab, master-detail, drill-down and bursting reports to be developed, using Report Studio, and made available to the users.
• Busted the reports in Cognos Connection based on the RDT number.
• Prompts, multi-query, cubes in Report Studio, Burst Reports against database.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in writing Stored Procedures and imported into Framework Manager to create complex reports.
• Trained end users effectively to use reporting tool, to build and customize their ad-hoc reports.
• Implemented Cognos SDK code for extracting the report schedules defined by power users.
• Worked on Java Script to perform Prompt page validations.
• Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.
• Followed Kimball model methodologies in database design for DW
• Deployed the Cognos content from Development environment to UAT/Production environments.
• Developing multi-dimensional analysis and business metrics reports using Cognos Power Play and Power Cubes using Cognos Transformation Server.

Environment: Cognos 10.2, Transformer, Report Studio, Query Studio, Workspace, Metrics Studio, Metric Manager, Oracle 11g, TOAD, SQL Navigator, Visual Source Code, PL/SQL.

Confidential

Cognos Developer

Responsibilities:

• Designed the reports and catalogs using impromptu as per the requirements.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Installation, Configuration and Maintenance of Cognos Application on Development and UAT Environments
• Extensively used Power Play Transformer to convert the data into power cubes.
• Modified Power Cubes by adding new Dimensions, Levels and Measures. Designed Cognos Transformer cube models using reports modeled according to user needs.
• Installed Cognos Report Net and Framework in an interim environment as a proof of concept.
• Involved in migration of catalogs from Impromptu to Report Net using Migration Utility.
• Created customized BI reports linking various databases, to meet the user requirements.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Created standard and Ad hoc reports using Cognos Query Studio.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using Report Studio.
• Developed Templates, standard Reports, and Master Detail Reports.
• Created Complex mappings using Connected/Unconnected Lookup, Aggregator and Router transformations for populating target table in efficient manner.
• Created Applets and used them in different Mappings.
• Responsible for creating the Cubes and Reports and scheduling them accordingly.
• Created events and tasks in the work flows using workflow manager.
• Provided production support by monitoring the processes running daily.
• Created Schema objects like Indexes, Views, and Sequences.

Environment: Cognos Report Net 1.x, Impromptu 7.0, Power Play Transformer7.0, Power Play Web 7.0, Upfront 7.0, Access Manager, Power Play Enterprise Server, Oracle 9i(SQL,PL/SQL), Windows NT, UNIX, Informatics Power Center 6.1, Oracle, DB2.