PraveenKumar Regunathan

• Worked on Dual Axis concept while working with reports.
• Created Filters, Groups, Sets on Tableau Reports.
• Creating Reference Lines, Trend lines using the Analytics pane.
• Created and modified some of the existing reports and dashboards.
• Publishing sheets and dashboards on Tableau server Using Tableau Desktop.
• Created complex reports utilizing the features like hierarchy, new Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Build advanced chart types and visualizations such as bar in bar Charts, bullet graphs, and box and whisper plots, Spark lines.
• Work with Stakeholders on requirement and help them to refresh database from third-party vendor.
• Analyzed large volumes of data and develops medium to complex reports/dashboards, insights for clients.
• Analyzing Data trends and documenting, to get approval from Stakeholders for updating details in Database.
• Created conditional filters and Actions links to filter the data on dashboard.
• Creating dashboard using Tableau and presenting to Stakeholders on Data trends from third-party vendor data.
• Comparing large amount of data using SQL in snowflake and identifying matching and non-matching details.
• Standardizing field values using SQL/Excel and updating database.
• Performed the Joins like Left, Right, Full and Inner joins and Data Blending as per the Requirements.
• Projecting Weekly/Monthly report on Data refresh status.

• Performing different installing of SQL Server like 2008, 2008R2, 2012 and 2014
• Configuring and maintaining Database Backups and other maintenance activities
• Identifying and Resolving Blocking and Deadlock issues by using System Stored Procedures, DBCC, Activity Monitor and Profiler
• Daily checking and resolving the tickets depends on the priority levels
• Refresh the Database every week from Production to Test Environment
• Responsible for performing Database Maintenance activities like rebuilding/reorganizing indexes update statistics, checking database integrity and clean up history on regular intervals
• Enrolling users, controlling and monitoring User Access to the database, and maintaining system security
• Refresh the Database every week from Production to Test Environment
• Basic knowledge on creating the SSIS packages and deploying them
• Configuring the Transaction replication in production environment
• Good experience in performing the Log Shipping and Mirroring in Production environment
• Performed various Database upgrading and server migrations.

• Installation & Configuration of SQL Server 2008, 2008R2 2012 Enterprise Edition
• Experience with Backups, Restores and recovery models
• Import and export data from a file
• Creation of Logins, Roles and granting permissions
• Knowledge of High Availability (HA) )Replication, mirroring, log shipping options for SQL Server
• Index Creation and Maintenance
• Provide 24x7 supports for critical production systems.

· Responsible for all data center operations & day to day daily activities.

· Manage the Backup Media in terms of labelling and storing them in the designated premise locations. Audit Backup Tape Inventory

· Report changes in EOD Processes & jobs. Update operation manual

Update tape inventory and tape movement to Offsite and update the report accordingly