MOHESH VISWANATH
DataBase Developer
Chennai
Summary
Results-driven SQL Developer with 3+ years of experience in database design, development, and optimization. Proficient in writing complex SQL queries, stored procedures, and performance tuning to ensure efficient data management. Skilled in ETL processes, data modeling, and troubleshooting to support business intelligence and reporting needs. Strong expertise in SQL Server, PostgreSQL, and dynamic query execution for handling large-scale databases.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
2
2
Languages
Work History
Database Developer
Cavintek Software Private Limited
09.2022 - Current
- Utilized advanced SQL techniques to significantly improve query performance and data retrieval processes
- Streamlined data retrieval processes to ensure faster and more efficient handling
- Developed dynamic SQL queries to increase system adaptability and reduce the need for manual intervention
- Automated routine tasks and data processing workflows, significantly enhancing system flexibility and maintenance efficiency
- Created and maintained automation scripts to streamline database operations and minimize errors
- Engineered complex SQL queries incorporating various join types to perform in-depth data analysis
- Leveraged advanced SQL features and functions to derive actionable insights from large datasets
Software Engineer
Financial Software and Systems
05.2022 - 08.2022
- Implemented a range of strategies to optimize Oracle database objects, significantly improving system performance
- Conducted comprehensive assessments and tuning of database indexes, queries, and configurations to enhance efficiency
- Utilized advanced techniques to monitor and resolve performance issues, ensuring seamless database operations
- Designed and developed SQL Loader scripts for efficient data loading and transformations
- Utilized advanced PL/SQL features to develop dynamic and efficient SQL queries
- Employed Dynamic SQL to enhance query flexibility and adaptability in varied scenarios
- Coordinated with support teams to minimize production downtime and ensure the stability of database systems
Operations Executive
ARTWIN AGENCIES
05.2019 - 04.2022
- Developed detailed operational budgets and closely monitored expenses to ensure financial efficiency
- Controlled expenses by implementing cost-effective solutions and negotiating favorable terms with vendors
- Coordinated with suppliers, manufacturers, and logistics providers to streamline operations and optimize delivery schedules
Education
BTECH - INFORMATION TECHNOLOGY
Easwari Engineering College
Chennai, India 05.2011 - 05.2015
Skills
- POSTGRES
- EXCEL
- TABLEAU
MS-SQL
- PYTHON
Oracle SQL
PL and SQL development
RDBMS
SQL programming
Certification
Tableau Desktop Specialist, Tableau
Accomplishments
Team Player Award From Cavintek Software.
Timeline
Database Developer
Cavintek Software Private Limited
09.2022 - Current
Software Engineer
Financial Software and Systems
05.2022 - 08.2022
Operations Executive
ARTWIN AGENCIES
05.2019 - 04.2022
BTECH - INFORMATION TECHNOLOGY
Easwari Engineering College
05.2011 - 05.2015
Similar Profiles
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
Mohan KumarMohan Kumar
HR at Imarticus Learning Private Limited, Imarticus Learning, South India, Josh Software Private LimitedHR at Imarticus Learning Private Limited, Imarticus Learning, South India, Josh Software Private Limited
KISHORE SKISHORE S
Business Analyst at Chella Software Private Limited, Corporation of India LimitedBusiness Analyst at Chella Software Private Limited, Corporation of India Limited
Sumaiga SugunesanSumaiga Sugunesan
Analyst Data Steward at AstraZenecaAnalyst Data Steward at AstraZeneca
Gayathri VGayathri V
CS Associate at AmazonCS Associate at Amazon