Md Sharique
Kolkata,
Summary
Results driven PL/SQL Developer with 4.8 years of experience in application support and implementing advanced database solutions using Oracle PL/SQL. Seeking to leverage my technical expertise and problem solving capabilities to drive innovation and contribute to strategic initiatives within a dynamic organization.
Overview
5
5
years of professional experience
Work History
PL/SQL Developer & Application Support
Tenet Computer & Communication Pvt. Ltd.
Kolkata
02.2023 - Current
- Developed, maintained, and provided production support for complex PL/SQL procedures, packages, functions, and triggers to enhance business application performance.
- Implemented change requests in the application to meet evolving business needs and client requirements.
- Resolved defects in both production and non-production environments and delivered technical support to ensure system stability.
- Analyzed production issues, determined root causes, and provided fix recommendations to users while efficiently troubleshooting production incidents.
- Configured, developed, and tested Shell scripts and PL/SQL scripts to automate processes and improve system functionality.
- Managed inter-operator billing processes and handled credit/debit notes for operators to ensure accurate financial transactions.
- Generated various IOBAS reports for the client and provided call data records (CDR) according to specific requirements
- Maintained direct interaction with clients to address issues, gather requirements, and ensure a smooth user experience
- Actively participated in issue resolution, working with cross-functional teams to ensure seamless operations and adherence to deadlines
- Client: Bharat Sanchar Nigam Ltd
- | Module: IOBAS
PL/SQL Support & Application Support
Waft Global Digital Pvt Ltd.
12.2019 - 01.2023
- Analyzed business requirements and resolved technical issues using PL/SQL and database techniques.
- Managed testing, implementation, and monitoring of change requests to enhance system functionality.
- Conducted analysis of functionalities using stored procedures and other database objects to meet project needs.
- Developed and tested Shell scripts and PL/SQL scripts to optimize processes and data handling.
- Coordinated with cross-functional teams for project delivery and provided application support to ensure system stability.
Education
Bachelor of Engineering -
Chhattisgarh Swami Vivekanand Technical University
ChhattisgarhSkills
- PL/SQL Development: Stored procedures, functions, packages, triggers, cursors, and exception handling
- SQL Programming: Complex queries, joins, subqueries, indexes, and set operations
- Oracle Database: Oracle 9i/10g
- Performance Tuning: Query optimization, indexing strategies, and database performance tuning
- Data Analysis: Analyzing data patterns, trends, and implementing data manipulation techniques
- Development Tools: TOAD, Oracle SQL Developer, PL/SQL Developer
- Extensive experience in writing and optimizing PL/SQL code, including stored procedures, functions, triggers, packages, and complex SQL queries
- Proficient in utilizing collections, bulk operations, exception handling, and advanced PL/SQL concepts to enhance application performance
- Strong expertise in query optimization techniques to enhance the efficiency of SQL queries and database performance
- Proficient in using indexing strategies, execution plans, and analytical functions to improve system speed and responsiveness
- Proven experience in providing technical support for database applications, diagnosing issues, and delivering prompt solutions
References
Available upon request.
Timeline
PL/SQL Developer & Application Support
Tenet Computer & Communication Pvt. Ltd.
02.2023 - Current
PL/SQL Support & Application Support
Waft Global Digital Pvt Ltd.
12.2019 - 01.2023
Bachelor of Engineering -
Chhattisgarh Swami Vivekanand Technical University
Similar Profiles
Manideep Singh WaliaManideep Singh Walia
Assistant System Engineer at Tenet Computer & Communication Pvt, Ltd.Assistant System Engineer at Tenet Computer & Communication Pvt, Ltd.
Sulaiman BakhshSulaiman Bakhsh
SENIOR PURCHASING SPECIALIST at Jeriasy for Computer & Communication ServicesSENIOR PURCHASING SPECIALIST at Jeriasy for Computer & Communication Services
Krishnanull Krishna
Business Development Executive at TENET TECHNOLOGIES PVT LTDBusiness Development Executive at TENET TECHNOLOGIES PVT LTD