CARRER OBJECTIVE:

To advance in the software development profession by performing and managing challenging assignments in distributed application development where my experience and expertise in Splunk, PL/SQL, J2EE and my business knowledge can be applied and honed.

SUMMARY:

• Overall 7 Years of IT experience in Data analytics and Programming.
• In depth and extensive knowledge of Splunk architecture and various components. Passionate about Machine data and operational Intelligence.
• Headed Proof - of-Concepts (POC) on Splunk implementation, mentored and guided other team members on Understanding the use case of Splunk.
• Implemented workflow actions to drive troubleshooting across multiple event types in Splunk.
• Expert in installing and using Splunk apps for Unix and Linux (Splunk nix).
• Knowledge on Configuration files in Splunk (props.conf, Transforms.conf, Output.confg)
• Extensive experience and actively involved in Requirements gathering, Analysis, Reviews.
• Expertise in creating accurate reports, Dashboards, Visualizations and Pivot tables for the business users.
• Expert in using rex, Sed, erex and IFX to extract the fields from the log files.
• In depth and extensive Knowledge in setting up alerts and Monitoring recipes from the Machine generated data
• Knowledge about Splunk 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.
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• Knowledge of Extract keyword, sed, Knowledge objects, Knowledge of various search commands like stats, chart, time chart, transaction, strptime, strftime, eval, where, xyseries, table etc. Difference between event stats and stats.
• Time chart attributes such as span, bins, Tag, Event types, Creating dashboards, reports using XML. Create dashboard from search, Scheduled searches o Inline search vs scheduled search in a dashboard
• 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.
• Business Activity Monitoring (BAM) concepts such as IBM
• Use techniques to optimize searches for better performance, Search time vs Index time field extraction. And understanding of configuration files, precedence and working.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types. s .
• Good experience in all facets of SDLC viz. requirement analysis, designs, development, testing, and post implementation revisions.
• Worked strongly following Agile (Scrum) methodology.
• Scripting and development skills (Perl, Python, Java) with strong knowledge of regular expressions.
• Extensive knowledge in creating accurate reports, Dashboards, visualization and pivot tables for the business users.
• Implemented a Log Viewer Dashboard as a replacement for an existing tool to view logs across multiple applications hosted on a PaaS setup.
• Expertise in using rex, erex, sed and IFX to extract the fields from log files.
• Have a strong background and experience in designing and developing various SOFTWARE applications. Strong technical skills in the areas of distributed technologies like JAVA, J2EE (JDBC, Servlets, JSP, AJAX, RMI, JNDI, EJB, Struts 1 & 2, Hibernate, Spring, Web services).
• Technically proficient in Oracle, MySQL.
• Strong experience with web/application servers like Apache Tomcat, Jetty, JBoss, IBM WebSphere, WebLogic.
• Knowledge on service oriented architecture (SOA), workflows and web services using XML, SOAP, and WSDL.
• Strong experience with various application development IDEs: Eclipse, IntelliJ, NetBeans .
• Experience with log tools: Maven, JUnit, Log4j, Ant Have excellent logical, analytical & debugging skills Possesses high working qualities with good interpersonal skills, highly motivated, fast learner, good team player and very proactive in problem solving with providing best solutions.
• Have proficient time-management skills, able to deliver assignments with superior quality on schedule and within budget. Strong technical background in system design with expertise in project coordination, determination of scope and priority and project implementation.

TECHNICAL SKILLS:

Tools: Splunk, SQL, T- SQL, HTML, XML, Java, OLTP, OLAP

Operating Systems: Windows 2000, XP, Windows NT, Unix/Linux (Red Hat)

Programming Language: C,C++, Java, Python, Linux shell scripts

Java/J2EE Technologies: J2EE, JSP, JDBC, JMS, Web Services

RDBMS: Oracle 11g/10g/9i/8i, MS: SQL Server 2000/2005/2008 , Sybase, DB2 MS Access.

Web Technologies: HTML, DHTML, JavaScript, XML, XSL, XSLT

Web/App Servers: Apache Tomcat 6.0, web logic8.1/9.2, web sphere 6.0

Tools: Microsoft Visio, Rational Rose, Quality Center

Concepts: SDLC, Object Oriented Analysis and Design, Unified Modeling Language (UML), Assembly and System Level Testing, exposure in Agile.

PROFESSIONAL EXPERIENCE:

Splunk Developer

Confidential, SFO, CA

Responsibilities:

• Knowledge about Splunk architecture and various components (indexer, forwarder, search head, deployment server), Heavy and Universal forwarder, License model
• Created Dashboards, report, scheduled searches and alerts.
• Provide Regular support guidance to Splunk project teams on complex solution and issue resolution.
• Involved in standardizing Splunk forwarder deployment, configuration and maintenance across UNIX and Windows platforms.
• Integrate Service Now with Splunk to generate the Incidents from Splunk
• Created many of the proof-of-concept dashboards for IT operations, and service owners which are used to monitor application and server health.
• Expertise in Actuate Reporting, development, deployment, management and performance tuning of Actuate reports
• Parsing, Indexing, Searching concepts Hot, Warm, Cold, Frozen bucketing.
• Onboard new log sources with log analysis and parsing to enable SIEM correlation.
• Subject matter expert in best practices, security protocols, PKI, and other security-related issues.
• 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..
• Implemented JMS in order to generate appointment logs.
• Used SPLUNK tool in order to analyze the logs in the applications.
• Gained in depth knowledge on Ant build and WebSphere servers.
• Involved in handling various Incident and request related to the application.
• 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.
• Worked closely with business partners in addressing their queries.

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

Orcale Developer

Confidential, Norfolk, VA

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, and implementation.
• Involved in logical modeling and physical modeling of database application and Developed Stored Procedures, Functions, Packages using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, cursors, tables, views, materialized views as per the business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tk-prof and Auto trace.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Part of a development team for creation and maintenance of custom apps/reports.
• Evaluating new techniques for enhanced functionality.
• Developed Perl scripts for data sources for data migration.
• Create or update conceptual, logical and physical data models using OLTP.
• Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic SQL statements.
• Worked on Data schema modeling and designed Database Schema using ERWIN tools and implemented Normalization on relational modeling.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Experience in BI reporting and visualization tools such as: Business Objects, Micro strategy, MSBI (SSAS, SSRS and Performance Point), Cognos, Tableau, Crystal Reports, etc.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Extensively used Database Query tuning and performance tuning of reports.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g, Perl, UNIX, Windows XP/2000.owb 10g.

Sr. Orcale Developer

Confidential, Atlanta, GA

Responsibilities:

• Used SQL hints and Indexes as needed to improve SQL performance.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Work with the Application Development team to implement data strategies and build data flows in OLTP.
• Involved development in Oracle Warehouse Builder out of 11i source system.
• Develop data models according to company standards.
• Worked with several tools to access and perform several operations on database
• Modify existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Part of a development team for creation and maintenance of custom apps/reports.
• Coordinate with the DBA for Table creation and other administrative activities.
• Responsible for analyzing tables and indexes regularly to keep the STATS up-to-date.
• Involve in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Deliver solutions that are reliable, easy to maintain and meet or exceed established performance measures.
• Knowledge of developing BI solutions for enterprise processes such as financials, supply-chain etc.
• Create new database objects like tables, Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in Oracle PL/SQL.
• Extensive experience with building application using Oracle APEX.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Involved in writing several Queries and Procedures.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Designing of ER diagrams for Data Modeling was done using ERWIN Tools.
• Develop and maintainPerl scripts that process data from vendors and other sources
• Application Development may involve interfacing with the following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or Oracle APEX.
• Worked on Korn shell scripts on UNIX platforms.
• Involve in the continuous enhancements and fixing of production problems.
• Worked with different teams to set up the development and test Autosys environments.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Solving the offshore technical issues and co-coordinating between offshore team and client.
• Responsible for writing J2EE compliant code using Java for an application development effort. This involves working with JSP, Servlets, JDBC, XML, EJB etc.
• Involved in the architecture of the modules according to the J2EE Standards like, client tier, web tier and business tier.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Created Work Instruction Manual listing the possible failures and Recovery steps for each and every new job added as part of the project.

Environment: Oracle 10g, SQL * Plus, Java, J2EE, JSP, XML, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Perl, Korn shell.

Sr. Oracle PL/SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Created data accuracy and consistency reports.
• Created complex relational database queries/SQL, dynamic SQL.
• Used various report items like tables, sub report and charts to develop standard and customized reports.
• Worked on designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
• Developed the ETL mappings in PL/SQL via packages, procedures, functions, views and triggers.
• OWB repository creation/configuration/monitoring, mapping/process flow development.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Built physical data structures like tables, views, constraints & Indexes.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Review modifications to existing software to improve efficiency and performance.
• Analyze Korn shell scripts on UNIX platforms.
• Involvedinphysical and logical data modelingusingErwin.
• Involved interfacing with the following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or Oracle APEX.
• Part of a development team for creation and maintenance of custom apps/reports.
• Created complex stored procedures to collect, analyze, and report on data across multiple functional and line of business systems in response to customer requirements.
• Created ETL design specifications.
• Solid understanding of both the business and the technical aspects of BI Solutions.
• Created table partitioning based on the systems and date range.
• Used SQL*Loader with both direct and indirect load methodologies.
• Query optimization using Explain Plan & TK Prof utility.
• Developed extraction, transformation and loading scripts using SSIS.
• Created SQL and PL/SQL scripts to detect data defects/anomalies in systems.
• Converted T-SQL to PL/SQL or vice versa to report data consistency cross multiple databases.
• Developed projects in an OLTP database environment.
• Created business rules to report all expected missing/defect data.
• Involved in Huge data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Environment: Oracle 11g,PL/SQL, SQL Loader, Cognos, Korn shell, ODI, SQL*Plus, Windows NT 4.0/2000/XP, Microsoft SQL server 2008.

Confidential

Java/Clarify CRM Developer

Responsibilities:

• Done JSP changes for UI part, created new JSP pages for the UI environment
• Created new data base table or customized current ones using DAT files
• Successfully upgraded JSP pages and database s from Clarify 12.0 to clarify 13.1.
• Handled the security content and issues.
• Maintained the client-server environment and implemented the updates successfully
• Created and modified required views/tables/triggers using SQL and worked on database bug fixes.
• Experience solving the compatibility issues
• Deployment of application on Web logic 8.1 for testing and development team
• Developed Detail Design and Technical Design Document, Designed unit Test Plans.

Environment: Java, JSP, Clarify CRM 13.1, JavaScript, Java beans, Html, Xml, SQL, Unix, Spring Framework, BEA Web logic 8.1.