• Moved data flat files generated from various Databases to HDFS for further processing
• Created Hive tables to store the processed results in a tabular format
• Creating & Loading Hive Staging tables & Fact Tables
• Developed the Sqoop scripts in order to make the interaction between Pig and SQL Database
• Involved in gathering the requirements, designing, development
• Moved all Jsonfiles generated by various products into HDFS location
• Writing the script files for processing data and loading to HDFS
• Completely involved in the requirement analysis phase
• Loading summarized data back to RDBMS for real-time reports
• Generate daily, weekly, monthly, quarterly and yearly reports from RDBMS
• Generating Ad-hoc reports to measure performance and trend analysis

• Deploy new apps (from Splunk base) to Search Head Cluster using a deployer
• Push new cluster bundle to all the indexers through Indexer master
• Troubleshoot and resolve configuration based issues
• Make configuration changes as per the requirement
• Create alerts to monitor the entire environment for disk usage, CPU usage, memory usage etc
• Check DMC (Distributed Management Console) to determine the health of entire environment
• Create dashboards as per the requirement to monitor the data from UFs
• Analyze security based events, risks and reporting instances
• Work on syslog-ng configuration changes on heavy forwarders
• Check missing UFs/network devices on daily basis
• Raise Splunk vendor tickets in case of any critical issues with the Splunk environment
• Work on upgarding ES app and on 2 factor authentication with Duo

• Understanding the Customer Requirement Specifications& Project functionality
• Involved in database testing using SQL Queries
• Handling new developments/change requests
• Creating objects like tables, views, Joins
• Running SQL queries for issue resolution
• Write and modify PL/SQL procedures and functions to enhance business needs
• Co-ordinate with the team members to provide support and customer satisfaction
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time

• Accountable for all performance related deliverables and activities in the project. And also accountable for on-time milestones within the project, while adhering to the budget and delivering high quality Focuses the Application tuning efforts on requirements verification, with an emphasis on how well the product meets the stated requirements, solves the customer’s problems, and delivers value
• Performed risk assessments and escalating those risks as needed
• Liaised as a representative during the weekly status calls with the project team and is responsible for communicating any status updates to all other project stakeholders and also estimating the team effort mentoring the team and tracking the team's status
• Engaged with Security and Performance Engineering Teams to coordinate non-functional requirements
• Once each stage of the PDM is completed, Lead is accountable for signing off on the Stage Exit Checklist (SEC) in Salesforce
• Performance Engineer, Coordinated with customer for Performance tuning activities

Creating dashboards, summary searches, alerts on Splunk 6.5.1/6.6.3/7.0.4. Performing admin tasks in Dev & Prod Created dashboards/views as per request Deploy and test apps for monitoring logs with Splunk Implement forwarder configuration and validate the connection with Indexers and deployment server Create searches as per the clients requirement; new alerts and monitor them minutely and resolve configuration based issues in entire environment Configuration and management of reports, dashboards, saved searches and other knowledge objects Deploy new apps (from Splunk base) to Search Head Cluster using a deployer Push new cluster bundle to all the indexers through Indexer master Troubleshoot and resolve configuration based issues Make configuration changes as per the requirement Create alerts to monitor the entire environment for disk usage, CPU usage, memory usage etc Check DMC (Distributed Management Console) to determine the health of entire environment Create dashboards as per the requirement to monitor the data from UFs Analyze security based events, risks and reporting instances Work on syslog-ng configuration changes on heavy forwarders Check missing UFs/network devices on daily basis Raise Splunk vendor tickets in case of any critical issues with the Splunk environment Work on upgarding ES app and on 2 factor authentication with Duo

Moved data flat files generated from various Databases to HDFS for further processing Created Hive tables to store the processed results in a tabular format Creating & Loading Hive Staging tables & Fact Tables Developed the Sqoop scripts in order to make the interaction between Pig and SQL Database Involved in gathering the requirements, designing, development Moved all Jsonfiles generated by various products into HDFS location Writing the script files for processing data and loading to HDFS Completely involved in the requirement analysis phase Loading summarized data back to RDBMS for real-time reports Generate daily, weekly, monthly, quarterly and yearly reports from RDBMS Generating Ad-hoc reports to measure performance and trend analysis

Understanding the Customer Requirement Specifications& Project functionality Involved in database testing using SQL Queries Handling new developments/change requests Creating objects like tables, views, Joins Running SQL queries for issue resolution Write and modify PL/SQL procedures and functions to enhance business needs Co-ordinate with the team members to provide support and customer satisfaction Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time

Accountable for all performance related deliverables and activities in the project. And also accountable for on-time milestones within the project, while adhering to the budget and delivering high quality Focuses the Application tuning efforts on requirements verification, with an emphasis on how well the product meets the stated requirements, solves the customers problems, and delivers value Performed risk assessments and escalating those risks as needed Liaised as a representative during the weekly status calls with the project team and is responsible for communicating any status updates to all other project stakeholders and also estimating the team effort mentoring the team and tracking the teams status Engaged with Security and Performance Engineering Teams to coordinate non-functional requirements Once each stage of the PDM is completed, Lead is accountable for signing off on the Stage Exit Checklist (SEC) in Salesforce Performance Engineer, Coordinated with customer for Performance tuning activities