SUMMARY

• Over 7+ years of experience in Information Technology field with strong experience as Splunk developer, Informatica developer, Business Intelligence (BI) and Data Warehousing (DW) associated projects.
• Experience in Operational Intelligence using Splunk.
• 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 Rex Command and Regex in configuration files.
• Knowledge of Extract keyword, 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.
• Props.conf, transforms.conf, inputs.conf, outputs.conf setting up a forwarder Monitor stanza in inputs.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.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse using Informatica Power Center.
• Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model), and Data Warehousing (ETL).
• 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.
• Database experience using Oracle 11g/10g/9i/8.x/7.x, MS SQL Server 2008, Teradata and DB2.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub - Queries.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5/ 9.1/8.5/8.1.1/7.1.2 , Informatica Designer, Workflow Manager, Work flow Monitor, Datamart, Mapplet, Transformations, Autosys, SQL*Plus

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, MS SQL Server 2012/2008/2005/2000 , MS Access.

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

Environment: Win 9x/NT/2000/XP, Unix.

PROFESSIONAL EXPERIENCE

Splunk Developer

Confidential -Boston, MA

Responsibilities:

• Experience developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis.
• Have Knowledge in various search commands like stats, chart, time chart, transaction, strptime, strftime, eval, where, xyseries,table etc. and difference between event stats and stats.
• Experience in working with Splunk authentication and permissions and having significant experience in supporting large scale Splunk deployments.
• Having experience in understanding of Splunk 5.x and 6.x product, Distributed Splunk architecture and components including search heads, indexers, forwarders, etc;
• 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.
• Maintenance of Splunk Environment with multiple Indexers.
• Manage and configure index settings.
• Create event type definitions.
• Set indexing property configurations, including timezone offset, custom source type rules. Configure regextransformations to perform on data inputs. Use in tandem with props.conf
• Designed core scripts to automate Splunk maintenance and alerting tasks
• Integrated ServiceNow 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.
• Lowering the cost and risk of big data initiaties with full featured platform to rapidly explore, analyze and visualizing data in Hadoop
• Analyzing data in Hadoop through data stores visual interactions and using splunk for deeper analysis
• Working on data model relationships in underlying raw data and making it more meaningful and useful to quickly generate charts, visuals and dashboards using pivot
• Analyzing massive amount of real time data in Hadoop using splunk enterprise operational intelligence.
• 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.
• 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
• Use techniques to optimize searches for better performance, Search time vs Index time field extraction. And understanding of configuration files, precedence and working.
• Create dashboard from search, Scheduled searches o Inline search vs scheduled search in a dashboard

Environment: SPLUNK 6.1.3, SPLUNK 6.2, UNIX, Hadoop, NoSQL, HBase.

Sr. Informatica Developer

Confidential - Tampa, FL

Responsibilities:

• Involved in full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.
• Provided technical support and guidance to the offshore team to address complex business problems.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed as well as modifying existing mappings for enhancements of new business requirements mappings to load into staging tables and then to target tables in EDW. Also created mapplets to use them in different mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets and scheduling of the workflow.
• Creating sessions, configuring workflows to extract data from various sources, transforming data, and loading into enterprise data warehouse.
• Running and monitoring daily scheduled jobs by using Work Load manager for supporting EDW (Enterprise Data Warehouse) loads for History as well as incremental data.
• Investigated failed jobs and writing SQL to debug data load issues in Production.
• Wrote SQL Scripts to extract the data from Database and for Testing Purposes.
• Interacted with the Source Team and Business to get the Validation of the data.
• Involved in Transferring the Processed files from mainframe to target system.
• Supported the code after postproduction deployment.

Environment: Informatica Power Center 9.1, Linux, UNIX, SQL, PL/SQL, Work Load Manager, MS Access, UNIX, BO XI R2, Erwin, Sun Solaris, Shell Scripts, Rapid SQL, PVCS, Visio, AutoSys.

Informatica Developer

Confidential, Bentonville, AR

Responsibilities:

• Designed and developed ETL process using Informatica tool.
• Worked with various Active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Responsible for extracting data from Oracle, Sybase, and Flat files
• Responsible for the Data Cleansing of Source Data
• Responsible for Performance Tuning in Informatica Power Center.
• Extensively made use of sorted input option for the performance tuning of aggregator transformation.
• Extensively made use of sorted input option for the performance tuning of aggregator transformation
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation
• Worked with Update strategy transformation using functions like DD INSERT, DD UPDATE, DD REJECT, and DD DELETE

Environment: Informatica Power Center 9.0 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g, SQL, PL/SQL, Teradata, Flat Files, Autosys, Star Team, UNIX, Linux,Windows XP

SharePoint Developer

Confidential

Responsibilities:

• Administering, designing and developing SharePoint 2010 sites ensuring strong optimization and functionality
• Setup and configure SharePoint services (Access Services, Central Administration, Document Conversions Launcher Service, Excel Calculation Services, Managed Metadata Web Service, Microsoft SharePoint Incoming E-Mail, PowerPoint Conversion Service, Request Management, Search Query and SharePoint Server Search, User Profile Service, User Profile Synchronization Service, Visio Graphics Service.)
• Manage SharePoint Content Databases
• Configure outgoing e-mail settings, incoming e-mail settings and mobile account.
• Configure and manage alternate access mappings, farm features, farm solutions, user solutions, privacy options, cross-firewall access zone, servers in SharePoint farm and services on server
• Analyze, review and modify web systems by designing, maintaining, documenting, testing, developing and monitoring
• Monitors and responds to SharePoint related user performance issues and outages
• Monitoring site technical performance and user administration
• Troubleshoot and improve custom web parts and design
• Add, deploy and configure new Solution.
• Backup SharePoint Server configuration and SharePoint server database.
• Create new site, document library, Calendar assigning Permission to users accordingly.
• Identifies, prioritizes, resolves, documents, and communicates technical and operational issues related to SharePoint and other internal software applications
• Collaborate with IT team members effectively
• Improve the overall quality and completeness of SharePoint documentation and support procedures
• Installed and configured Exchange Server 2010 and migrate and upgraded exchange (2003) to Exchange 2010.
• Installed and configured Windows 2008 R2 IIS web server locally and migrated the hosted web server locally to the local IIS web server.
• Maintain, trouble shoot, backup, of SharePoint server, web server, application server, and database server, and responsible for the integrity of the data and the efficiency and performance of the system.
• Oversee all aspects of administering the SharePoint Server/IIS/ /SQL/website environment including design, architecture, availability, reliability, performance, monitoring, and security.

Environment: WSS 4.0, Project server 2010, MS Project 2010, SharePoint 2010, MS SQL Server 2008, SharePoint Designer 2010, XML, Html, XSLT, XHTML, MS InfoPath 2010, MS Office 2010, SharePoint Manager, SharePoint Analyzer 2010

SQL Developer

Confidential

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• Enforcing business rules with triggers and user defined functions, troubleshooting, and replication.
• Writing the Stored Procedures, checking the code for efficiency.
• Maintenance and Correction of Transact Sequel Server (T-SQL) Statements.
• Daily Monitoring of the Database Performance and network issues.
• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• SQL Authentication
• Rebuilding indexes on various tables.
• Preparing Test Cases and performing Unit Testing.
• Review of Unit and Integration test cases.
• Production Implementation and Post Production Support.

Environment: MS SQL Server 6.5, SQL Server 7, MS SQL Server 2000