Experienced IT professional with overall working experience of 8.5+ years and 6.5 years of experience primarily as Oracle Database Developer developing & managing business applications based on Oracle Database.
Programming experience as an Oracle SQL and PL/SQL Developer in Analysis, Design, Implementation and maintenance of business logic using the Oracle Database.
Possess Knowledge in Client-Server application development/support using Oracle 12c/11g/10g/9i, SQL Plus, TOAD, SQL Developer and SQL Loader.
Experience in developing all types of DB objects like Packages, Procedures, Functions, Views, Tables, Triggers as per business requirements.
Having good knowledge on performance tuning of SQL using key Oracle performance related features.
Having experience in creating complex SQL queries which involves using analytical functions for extracting data from the Oracle DB as per business requirement.
Have the ability to quickly find patterns and relations in data which helps to solve any data related issues. Good experience with analyzing datasets using MS Excel.
Good Experience in Job scheduler tools such as Control-M.
Having good domain knowledge in banking and financial services and Telecom businesses.
Experienced in working in SOX applications and resolving security implications of servers and performing SOX audits as scheduled.
Have good understanding on the ITSM practices and processes related to Incident Management, Change Management and Problem Management.
Overview
8
8
years of professional experience
3
3
Languages
Work History
Technical Lead
HCL Technologies Ltd
Pune, MH
01.2024 - Current
Investigated system issues and implemented resolutions to reduce downtime.
Evaluated and adopted new technologies to address changing industry needs.
Educated stakeholders on data protection tactics to reduce breaches.
Supervised architecture, design and implementation of company-wide platforms and applications.
Assessed project milestones and team performance to keep staff on-task.
Organized system operating procedures to strengthen controls.
Enhanced interfaces to promote better functionality for users.
Provided educational expertise and mentoring to junior team members.
Deputy Branch Manager
Union Bankof India
Howrah, WB
07.2022 - 01.2024
Worked as Deputy Branch Head handling responsibilities of day to day operational and functional tasks of Nationalised Bank.
Maintained friendly and professional customer interactions.
Enhanced branch production rates by handling staff conflicts, evaluations, hiring, and termination processes and coaching employees on company protocol and payroll operations.
Assessed employee performance and developed improvement plans.
Met deadlines by proactively managing individual and team tasks and streamlining processes.
Created strategies to develop and expand existing customer sales, resulting in increase in annual sales.
In charge of all operations, including market assessment, forecasts, setting financial goals and achieving branch business objectives, including attaining deliverables on time.
Generated financial and operational reports to assist management with business strategy.
Assistant Manager
Paschim Banga Gramin Bank
Howrah, WB
04.2022 - 06.2022
Worked as Assistant Manager(trainee) ,handling responsibilities of day to day operational and functional tasks of Regional Rural Bank.
Generated repeat business through exceptional customer service and responded to customer concerns with friendly and knowledgeable service.
Offered hands-on assistance to customers, assessing needs, and maintaining current knowledge of consumer preferences.
Monitored cash intake and deposit records, increasing accuracy, and reducing discrepancies.
Created employee schedules to align coverage with forecasted demands.
IT Analyst
Tata Consultancy Services Ltd
Kolkata, WB
04.2017 - 04.2022
Worked in a Devops model managing the business applications based on Oracle Database which supports the R2R , A2R & P2P business cycles of the organization.
Performed SOX audits of the servers and application and resolved the security vulnerabilities of the server.
Prepared KEDB and SOP documents.
Bug fixing of the application’s PL/SQL code and performed data extraction using SQL queries.
Managed service communications and stakeholder confidence for incidents, Service requests and applications management.
Analyzed and resolved data reconciliation issues in batch processing during financial Month Ends and Year Ends.
Transferred files to different servers using SFTP and SSH file transfer protocols.
Documented and created new knowledge base to provide the most effective solutions to application issues.
IT Analyst
Tata Consultancy Services Ltd
Nagpur, MH
10.2015 - 03.2017
Assisted in post-implementation and continuous-improvement efforts to enhance performance and improve future outcomes.
Incident management and problem management, joined Bridge lines, provided timely updates and troubleshooting production issues.
Attended regular status calls with Client and internal management.
Managed SLAs for incidents and service requests.
Documented and created new knowledge base to provide the most effective solutions to application issues.
Provided generic solutions to avoid re-occurring of incidents and proactively monitored the production environment and identified the potential incidents.
Tasks involved following up with upstream for delays, resolving production issues, understanding end to end flow of the application.
Involved in audits for application abiding by company security policies.
Education
B.Tech - Electronics And Communications Engineering
College of Engineering And Management, Kolaghat
Kolaghat, WB
04.2001 -
12th Standard : ISC (C.I.S.C.E.) -
South End Centre, E.M. School
Howrah, WB
04.2001 -
10th Standard : ICSE (C.I.S.C.E.) -
South End Centre, E.M. School
Howrah, WB
04.2001 -
Skills
Oracle PL/SQL
undefined
Additional Information
DECLARATION: I, Manish Roy , hereby declare that the information contained herein is true and correct to the best of my knowledge and belief.
Timeline
Technical Lead
HCL Technologies Ltd
01.2024 - Current
Deputy Branch Manager
Union Bankof India
07.2022 - 01.2024
Assistant Manager
Paschim Banga Gramin Bank
04.2022 - 06.2022
IT Analyst
Tata Consultancy Services Ltd
04.2017 - 04.2022
IT Analyst
Tata Consultancy Services Ltd
10.2015 - 03.2017
B.Tech - Electronics And Communications Engineering