Ronak Kothari Email & Phone Number

Berlin, Germany

Pune, Maharashtra

Pune Area, India

Design, model and implement a cloud data warehouse from scratch for leading healthcare firm based on Snowflake and Dundas BI as Business dashboards.• Understand Business analytics use cases and requirements directly working with Client’s CIO & Regional managers.• Design conceptual, logical data models, physical data model and flowcharts along with helping on POC and prepare product comparisons for finalizing DW components technology• Drive Cloud Data Warehouse implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design.• Architect data model for BI dashboard and helping team to change management & new integration considering growth factors and performance tuning.• Expertise with Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel

Pune Area, India

• Designed and supported High Availability/DR Techniques such as Clustering, Mirroring, Replication and Always ON.• Automated and standardized SQL Server environments to operationalize repetitive tasks. • Installing, configuring and baselining the performance of SQL Server.• Analyzing and correcting issues with backups, TSQL code, database corruption, and security.• Servers, stored procedures, and queries performance tuning through query optimization tools. Perform query plan analysis optimize inefficient queries.• Write and deploy SQL stored procedure, functions and other programming objects.• Maintain very large size database (> 2 TB) and optimize for smooth data loading & recovery.• Perform and maintain best practices for database maintenance (Index and file management, statistics, database defragmentation). • Monitoring & troubleshooting the High CPU, Disk Space usages, Procedure Queue Length and Disk Queue Length and provides the recommendations and solutions.• Configure change data capture and other database auditing techniques.

Pune Area, India

• Installation, Configuration and Maintenance of Microsoft SQL Server 2012/2008R2 on Standalone, Cluster servers and AWS servers according to the Clients / Projects requirement.• Providing pre- sales cost analysis for SQL environments.• Capacity planning for Disks and Space Management Database files.• Security Management for Windows\SQL server Logins and assigning appropriate access rights.• Monitoring & troubleshooting the High CPU, Disk Space usages, Procedure Queue Length and Disk Queue Length and provides the recommendations and solutions.• Bulk Insert, BCP Utility and DTS, SSIS packages for data transfer activities.• Monitoring and troubleshooting the Blocking, Deadlocks, login failure, disk space, backup jobs, maintenances jobs which helps the daily work to run faster and in timely fashion• Providing solution for Database migrations and Server upgrades, Logins transfers for End to End Server Migration.• Core database activities like Shrinking Database, Attach-Detach Database, Import-Export database, adding files, suspect database, migration, linked server etc. • Creating and configuring Boomi (dell integrator tool) processes for synchronizing cloud and enterprise environment.• Analyzing query plans and performance optimization of OLTP and reporting queries over 6 TB databases.

Pune

• Creating Databases, Batches, Jobs, Maintenance plan, Transactions etc…• Database Backups, Configuring SQL Mails, Clustering, Data Security etc.• Implementation, Monitoring and Troubleshooting database jobs, space issues,• Database Migration between production, development and UAT servers.• Installation, Upgrade and Patch management.• SQL DBA Activities, User creation, Granting Permissions, Creating Roles etc.• SQL Server Authentication and Windows authentication DB Security.• User creation and security management.• Back and Restoration. Monitoring SSIS packages. • Log shipping on SQL server 2005, Mirroring on SQL server 2005 • Database Backups & Restore• Shrinking Database, Attach-Detach Database, Import-Export database etc. • Database Performance Monitoring, Monitoring Expensive SQL Statements • Database tuning advisor, Graphical Execution plan, Profiler, Performance Monitor etc.

Mumbai

1. Handling the Backup / Restore jobs and user request2. Merge Replication,Troubleshoot replication and clustering problems.3. Installing, Managing, Maintaining & Configuring Microsoft SQL Server 2005 Databases4. Daily monitoring and generating performance reports.5. Managing and Troubleshooting Database issues.6. Monitoring and Troubleshooting database jobs7. Troubleshooting database issues Blocking, Deadlock, High CPU problem, Memory etc8. Implementing and Troubleshooting Database maintenance activities Rebuild Index, Upadate Statistics etc.9. SQL Server Authentication and Windows authentication DB Security10.Shrinking Database, Attach-Detach Database, Truncate logfile, Import-Export database etc

1. Write procedures to implements portfolio data checks on basis of accounting principles and implementation of database email configuration for critical checks. 2. Unit testing and review codes of other team members, log defects and suggest resolution of defects.3. Analysis of existing code compatibility for SQL server 2008 and prepare stats of generation systems to measure performance between both versions. Prepare scripts to check data accuracy. 4. To make changes in macros such that it supports both office versions. Analysis of technology for better representations of reports.5. Implementation of standard and customized reports for clients to show risk and performance figures on daily and monthly basis.6. Write stored procedures to generate risk and performance data of client on the basis of client trading portfolio.7. Write reporting stored procedures and VBA programmed macros for excel reports. 8. Implementation of major modules in parsing utility which converts report style text files into delimited readable format. 9. Standardization of reading configuration. 10. Write data fetching, validating, customizing and saving stored procedure system.

B.E., Computer Science, 80

Hsc, Science Maths, 83