Anil Mohanty
Bengaluru
Summary
Driven Database Developer with 5 years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments.
Overview
6
6
years of professional experience
Work History
Database Developer
Betsol India Pvt Ltd
07.2023 - 03.2024
- Report Design and Development: Designed and developed detailed and summary reports using SAP Crystal Reports based on business requirements.
- Data Analysis and Validation: Analyzed and validated data to ensure accuracy and consistency in reports.
Collaborated with business analysts and stakeholders to understand reporting needs and translate them into technical specifications.
- Report Optimization: Enhanced report performance by optimizing SQL queries and improving data retrieval processes.
Implemented best practices to ensure efficient report generation and minimal resource usage.
- Testing and Troubleshooting: Conducted thorough testing of reports to identify and resolve any issues or discrepancies.
Provided troubleshooting support for existing reports and made necessary adjustments to meet user requirements.
- Documentation and Training: Documented report development processes, data sources, and report structures.
Provided training and support to end-users on how to effectively utilize and interpret reports.
Senior Software Engineer
LTI Infotech
01.2022 - 05.2023
- Database Design and Development: Designing and implementing database schemas, tables, stored procedures, and triggers.
Developing complex SQL queries, views, and functions to meet business requirements.
- Database Maintenance: Performing regular database maintenance tasks such as indexing, updating statistics, and optimizing query performance.
Monitoring database health, ensuring high availability, and performing routine backups and restores.
- Performance Tuning: Analyzing and optimizing query performance using execution plans and indexing strategies.
Identifying and resolving performance bottlenecks in SQL queries and database structures.
- Troubleshooting and Support: Providing support for database-related issues, including troubleshooting connectivity and performance problems.
Collaborating with development teams to resolve application-related database issues.
- Collaboration and Continuous Improvement: Working closely with cross-functional teams to understand requirements and deliver database solutions.
Keeping up to date with the latest SQL Server features and best practices to continuously improve database performance and reliability.
Senior Software Engineer
Mindtree Ltd
03.2021 - 01.2022
- Database Design and Development:Design, develop, and maintain robust Teradata database solutions to support business applications.
Create complex SQL queries, stored procedures, and scripts to extract, transform, and load (ETL) data.
- Performance Optimization:Optimize SQL queries and database performance, ensuring efficient data retrieval and processing.
Monitor and analyze system performance, making recommendations for improvements.
- Data Analysis and Reporting:Develop and maintain data models, ensuring data integrity and consistency.
Generate and distribute standard and ad-hoc reports to stakeholders using SQL and other reporting tools.
- Troubleshooting and Support:Provide support for data-related issues, resolving SQL errors and optimizing query performance.
Assist in the identification and resolution of data quality issues, ensuring data accuracy and reliability.
Oracle Developer
Xeeva India Pvt Ltd
09.2018 - 03.2020
- Database Design and Development: Design and develop robust, efficient, and scalable database solutions.
Create and maintain database objects such as tables, views, indexes, and sequences.
- PL/SQL Programming: Write and optimize complex PL/SQL stored procedures, functions, packages, and triggers.
Implement business logic through PL/SQL code and ensure adherence to best practices.
- Performance Tuning: Analyze and optimize SQL queries for performance improvements.
Use tools like Explain Plan, SQL Trace for query optimization and performance tuning.
- Data Migration and Integration: Develop and manage data migration strategies and processes.
Integrate data from various sources, ensuring data consistency and integrity.
- Reporting and Data Analysis: Create and manage complex reports using SQL queries and PL/SQL.
Analyze data trends and provide actionable insights to stakeholders.
- Documentation and Compliance: Document database designs, architectures, processes, and best practices.
Ensure compliance with company policies and industry standards.
- Collaboration and Support: Work closely with application developers, analysts, and business users to gather requirements and deliver solutions.
Provide support and troubleshooting for database-related issues.
Education
B. Tech - Electronics and Tele-Communication
Biju Pattnaik University
2012
Skills
- Oracle Developer
- PLSQL Developer
- Microsoft SQL Developer
- Teradata SQL Developer
- Database Design
- SQL and Databases
- Database Development
Timeline
Database Developer
Betsol India Pvt Ltd
07.2023 - 03.2024
Senior Software Engineer
LTI Infotech
01.2022 - 05.2023
Senior Software Engineer
Mindtree Ltd
03.2021 - 01.2022
Oracle Developer
Xeeva India Pvt Ltd
09.2018 - 03.2020
B. Tech - Electronics and Tele-Communication
Biju Pattnaik University
Similar Profiles
Sowmya VupputuriSowmya Vupputuri
Global Support Analyst at Epiq Systems India Pvt. Ltd.Global Support Analyst at Epiq Systems India Pvt. Ltd.
Tapaswini MohantyTapaswini Mohanty
Senior Technical Support Engineer at HARMAN Connected Services Corporation India Pvt. Ltd.Senior Technical Support Engineer at HARMAN Connected Services Corporation India Pvt. Ltd.
SHAIZAN KHANSHAIZAN KHAN
Senior Software Engineer at BETSOL SOFTWARE INDIA PVT LTDSenior Software Engineer at BETSOL SOFTWARE INDIA PVT LTD