SUMMARY

• Overall 6+ years of experience in software design and development activities including requirement analysis, design, and implementations, testing and Reporting of various client server based applications using Splunk, SQL Server, SQL Server Business Intelligence Development and Tableau /BI for global clients like PNC, Confidential, and CHG.
• Worked strongly following Agile (Scrum) methodology.
• Scripting and development skills (Perl, Python, Java) with strong knowledge of regular expressions.
• Extensive understanding in languages like XML.
• Complete involvement in Splunk upgrade activities.
• Took the responsibility of Splunk components in managing forwarders, indexers, searches & deployment servers.
• Extensive knowledge in creating accurate reports, Dashboards, visualization and pivot tables and design patterns for the business users.
• Worked on large datasets to generate insights by using SPLUNK.
• Worked on Application management splunk apps and add - ons.
• Production error monitoring and root cause analysis using SPLUNK.
• Implemented a Log Viewer Dashboard as a replacement for an existing tool to view logs across multiple applications.
• Time chart attributes such as span, bins, Tag, Event types, Scheduled searches online search vs scheduled search in a dashboard.
• Knowledge on configuration files in SPLUNK (props.conf, transforms.conf, output.conf).
• Expertise in using rex, erex, sed and IFX to extract the fields from log files.
• Extensively involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Expert in Tableau Desktop and Server Administration and version upgrade activities.
• Good experience in all facets of SDLC viz. requirement analysis, designs, development, testing, and post implementation revisions.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Handled Tableau POC activities to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to help them make effective business decisions.
• Experienced in designing customized interactive dashboards in Tableau using marks, Action, filters, parameter, calculations and Relationships.
• Experienced in writing Parameterized Queries for generating Tabular, drill down, drill through and sub- reports using SSRS and in generating on-demand and scheduled reports for business analysis or management decision.
• Pull/Load Data using SSIS from SharePoint Source/Destination Adapter.
• Experienced on SQL server SSIS packages to import, export and transforming of data between databases and different external data sources.

TECHNICAL SKILLS

BI Tools: Tableau, Business Objects, Web-Intelligence, Report Conversion tool, Desktop-Intelligence, Import wizard.

ETL Tools: Informatica, Microsoft SQL Server Integrated Services.

Databases: SQL Server, Oracle,Exa Data, MS-Access, DB2, Teradata.

Scripting Languages: HTML, SQL, Python, PL/SQL, and XML .

Monitoring Tools: SPLUNK 5.X, SPLUNK 6.X, Power Designer, Erwin, ER Studio, MS Visio.

PROFESSIONAL EXPERIENCE

Splunk Developer

Confidential - Pittsburgh, PA

Responsibilities:

• Provided 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.
• Worked on Sorting out the issues for password failure cases in the logs.
• Involved in the development of google maps, Baidu maps by fetching the sourceIps of the requirement.
• Involved in lookup tables fetching it with regular fields.
• Involved in making effective dashboards by customized input searches and hyperlinks.
• Involved in creating some professional navigation menus which was user friendly.
• Integrated ServiceNow with Splunk to generate the Incidents from Splunk.
• Creating DevOps dashboard that aggregates data across multiple services to identify critical threats and proactively mitigate risks.
• Knowledge about Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model.
• 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.
• Design platforms for large scale performance while maintaining security of sensitive data.
• Used techniques to optimize searches for better performances and used search time vs index time field extraction.
• Created some calculated fields for the user requirement.
• Having Strong understanding of Report and Dashboard configuration and development.
• Experience in Extraction on Search time vs Index time field extraction.
• Good Understanding of configuration files, precedence and daily work exposure to Props.conf, transforms.conf, inputs.conf, outputs.conf and Setting up a forwarder information based on requirement.
• Created some on boarding applications in splunk.
• Monitor stanza in inputs. conf basic fields in Splunk at index time.
• Creating dashboard with saved searches and Inline search including various types of charts and alert settings.
• Plan and Build Splunk Cluster environment with High Availability resources.
• 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.
• Worked closely with cross functional team to design new features and resolve issues as they arise.
• Integrated ServiceNow 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.
• Performed field extraction using IFX in an event action.
• Very good understanding of software development life-cycle (SDLC) process, Followed Agile scrum and story maps for dev tracking.
• Involved in interacting with business owners, developers and business analysts in improving the application.
• Gained in depth knowledge on Ant build and WebSphere servers.
• Involved in handling various Incident and request related to the application.
• Good command on Linux OS and debugging performance issues.
• Involved in monitoring the ticketing tool and taking the ownership of the tickets.
• Worked on various defects analysis and fixed them.
• Problem record analysis and solution providing.
• Created many of the proof-of-concept dashboards for IT operations, and service owners which are used to monitor application and server health.

Environment: Splunk5.x, Splunk6.1, Splunk6.2, Restful, SOA, LINUX OS, ServiceNow, XML, XSLT, SIEM, JMS.

Tableau Consultant

Confidential - Sunnyvale, CA

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Report Development Documents.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Worked closely with business users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards. Created hierarchy's relevant customer data.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Make use of filters and making them local and global accordingly.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in mobile devices like I pads
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

BI Developer/ Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• Involved in the some part of performance tuning.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Generated Cross Tab, Charts & Vertical Business Objects Reports using Web Intelligence Rich Client Using Universe.
• Migrated & upgraded Business Objects from 6.5 to 3.1 Using Import Wizard.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created the AS-IS and TO-BE process flow diagrams.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions.
• Defined functional business requirements, analyzed client requirements, and generated workflow processes.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Assisted in project management activities like planning, development, task allocation, project execution.
• Provided full project life cycle flowcharting, analysis and documentation.
• Defined project milestones, schedules, monitoring progress and updating plans using MS Project.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: PL SQL, Business Objects, Data Extraction, Data Transformation and Data Loading (ETL). Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

SQL Developer

Confidential 

Responsibilities:

• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Wrote stored procedure and function used in SSIS package and SSRS reports
• Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability. Implemented subscriptions and snapshots in the SSRS Report Manager
• Experienced in writing Parameterized Queries for generating Tabular, drill.
• Designed, implemented and administrated SQL Server 2000 databases.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.

Environment: SQL Server 2000, SQL Profiler, Data Transformation Services, and T-SQL.