Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Manish Roy

Technical Lead
Pune

Summary

  • 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

College of Engineering And Management, Kolaghat
04.2001 -

12th Standard : ISC (C.I.S.C.E.) -

South End Centre, E.M. School
04.2001 -

10th Standard : ICSE (C.I.S.C.E.) -

South End Centre, E.M. School
04.2001 -
Manish RoyTechnical Lead