Rajan Dhakate
Solution Success Engineer I
Pune
Summary
Experienced and Dedicated Solution Success Engineer having 4 years of experience in Solving and troubleshooting critical technical issues. Critical thinker who addresses client issues quickly and who consistently exceeds performance standards and always passionate about helping businesses succeed. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Looking forward to enhance professional and technical skills by meeting organization objectives with zest and focus.
Overview
4
4
years of professional experience
5
5
years of post-secondary education
6
6
Certifications
Work History
Solutions Success Engineer I
eGain Communications
06.2020 - Current
- · Hands on experience in working of both the eGain products (eGain Analytics) and have written extensive code in SQL
- · Single handedly worked on incidents and delivered all the requirements before deadline and fixing security vulnerabilities in the application
- · Experience on PL-SQL scripts and provided with a correction in script when a defect was identified
- · Also developed and modified triggers, packages, functions and stored procedures based on the change request
- · Built complex SQL queries using joins, sub-queries and correlated sub-queries required to retrieve data using cursors for reporting
- · Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables
- · Participated in code reviews to ensure adherence to coding standards and best practices
- · Experience in understanding and writing MDX queries and experience in browsing OLAP cubes using Analysis service
- Collaborated with cross-functional teams to troubleshoot and resolve database-related issues
- Good Understanding on the Defect management of the company and submitted the bugs as per the company's bug cycle format
- And Unit-Tested the fixes from our end before getting back to the customer Have been part of multiple client interactions to discuss their issues and providing them with a solution at the earliest
- Experienced with monitoring AWS resources using CloudWatch, setting up alarms, and configuring logging for troubleshooting and performance optimization.
- Experience on deriving SQL profiler traces and OLAP traces
- Worked on Database replication, switch overs, SSAS, SSIS and SSRS
- Worked on customers production setups to investigate on the ETL packages and to understand the issue from the logs
- Proficient in accessing data on the Database and analyzing back-end scripts
- Unit-Tested the fixes from our end before getting back to the customer.
- Documented technical specifications, user manuals, and operational procedures
- Analyzing the root cause of the issue, receiving 100% positive feedback for alignment to client goals
- Knowledge Transfer to New joiners and performed Cross Functional Task Involved in Live Deployment, Post
- Deployment and Early Life Monitoring activity
- Performing complex custom analytics as needed by internal and external clients
- Handling Application components to avoid the potential issues and preforming health check frequently to make sure application is running fine.
- Have been part of multiple client interactions to discuss their issues and providing them with a solution at the earliest
- Actively engaged with product managers, internal stakeholders, business users and cross-functional teams to analyze business needs, gather, document, business, and technical requirements
- Monitoring customers data to detect the data lag and further analyze it.
- Enhanced product performance by conducting thorough failure analysis and recommending improvements.
- Experience on troubleshooting system issues, debug errors, and resolve performance bottlenecks on Linux servers.
Education
PG - Diploma - Big Data Analytics
CDAC- Sunbeam Institute Pune
Pune 01.2019 - 04.2019
BE - Electronics Engineering
Rajiv Gandhi College of Engineering Nagpur
Nagpur 01.2014 - 04.2018
Skills
Customer Relationship Management
JIRA, Microsoft SQL, Tableu, PowerBI , Postman, eGain In house tools like ticketing tool, Advisor Desktop , Linux
System Configuration Changing , Process Improvement
Technical Documentation, Application installations, Project Management
Network Operational Enhancements
Debugging, System Troubleshooting, Technical Troubleshooting
Problem-Solving
Server maintenance
Customer Relationship Management
Technical reporting
Data Analysis, Problem Resolution, Analytical Thinking
Certification
Completed Certifications on Big data.
Projects
Churn Modelling, This case study aims to classify the new customers into good and bad with the help of Machine learning by analysing past records of Telecom Company customers which in turn will help company to analyse the Business Problem and improve it accordingly., 07/2019, 08/2019 Cricket Prediction, Cricket is a sport that contains a lot of statistical data so the aim of this study was to predict the winner of cricket match. With the help of Big-data technologies like Hadoop, Hive, Spark and mainly Machine Learning we reached to get the outcome of this project., 07/2019, 08/2019
Timeline
Solutions Success Engineer I
eGain Communications
06.2020 - Current
PG - Diploma - Big Data Analytics
CDAC- Sunbeam Institute Pune
01.2019 - 04.2019
BE - Electronics Engineering
Rajiv Gandhi College of Engineering Nagpur
01.2014 - 04.2018