Summary
Overview
Work History
Education
Skills
Personal Information
Disclaimer
Certification
Languages
Timeline
Generic
Sandeep Roy

Sandeep Roy

Durgapur

Summary

Project Manager with extensive experience at Capgemini, specializing in risk assessment and strategic planning. Proficient in Oracle PL/SQL, delivering innovative solutions that improve project outcomes. Strong leadership and stakeholder engagement skills drive performance optimization and exceed project goals.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Project Manager

Capgemini
Kolkata
12.2021 - Current
  • Conducted regular status meetings with internal teams and external partners to track project milestones.
  • Participated in cross-functional teams to develop innovative solutions for complex challenges.
  • Analyzed data from surveys, interviews, and focus groups to guide project-related decision-making.
  • Sought feedback from stakeholders throughout projects to identify areas for improvement.
  • Identified project risks and developed strategies for effective mitigation.
  • Advised departments on best practices for managing large-scale projects.
  • Maintained comprehensive records of project documents, including specifications and invoices.
  • Ensured compliance with laws, regulations, and policies throughout project life cycles.

Software Engineer III

Cerner Corporation
Bangalore
03.2020 - 12.2021
  • Engineered CCL programs adaptable at client site, aligned with DA2 reporting needs.
  • Diagnosed and corrected reported bugs, moving systems to production following UAT approval.
  • Utilized version control tools to manage source codes across multiple projects.
  • Conducted code reviews to ensure adherence to coding standards and best practices.
  • Constructed front-end UI utilizing Discern Visual Developer tool based on client requirements.
  • Provided comprehensive data extracts and ad hoc reports through CCL queries.
  • Conducted unit testing, enabling timely releases for UAT stage environments.
  • Addressed production issues efficiently to maintain operational integrity.

Data Architect Analyst

Fiserv India Pvt Ltd
Bangalore
06.2019 - 03.2020
  • Executed comprehensive workload testing on MemSQL databases under different node conditions, including failure scenarios.
  • Optimized performance of procedures and functions through effective tuning strategies.
  • Transitioned PLSQL procedures to MemSQL format to facilitate smoother operations.
  • Loaded datasets of 1M, 5M, and 10M into the database efficiently.
  • Performed regular maintenance tasks such as backup and restore operations, index rebuilds.
  • Worked closely with software engineers in order to design efficient database schemas and queries.
  • Implemented database objects such as tables, views, stored procedures, triggers and user-defined functions.

Applications Developer

Oracle Financial Software Services Limited
Bangalore
05.2017 - 06.2019
  • Resolved multiple bugs to improve application performance.
  • Resolved customer support tickets related to application functionality.
  • Generated reports from databases containing usage statistics and analytics.
  • Optimized existing codebase for improved performance and scalability.
  • Tailored customizations to meet specific customer requirements.
  • Addressed front-end and back-end issues to ensure seamless functionality.
  • Collaborated with kernel team, Open Development Tools team, and other modules for project testing and tool-related concerns.

Senior Software Engineer

Infosys Ltd
Bangalore
09.2014 - 04.2017
  • Executed multiple bug fixes to enhance application performance.
  • Customized PL/SQL procedures, functions, triggers, and packages for improved functionality.
  • Enhanced various application modules and integrated them within WMS.
  • Contributed to application enhancements by implementing user feedback.
  • Documented software development processes and procedures for future use.
  • Resolved complex issues related to software applications quickly and effectively.
  • Optimized databases to improve query performance.

Associate Software Engineer

CGI Information systems & Management Pvt Ltd
Bangalore
06.2012 - 09.2014
  • Developed essential PL/SQL components including procedures, functions, triggers, and packages.
  • Implemented code changes according to user requirements.
  • Participated in design meetings, code reviews, and sprint planning sessions.
  • Enhanced application features through report and form development with SQL/PLSQL coding.
    Conducted bug fixes to ensure optimal application performance.
  • Utilized Progress 4GL for effective coding of various modules.
  • Merged numerous application modules into MBFS to enhance system integration.

Education

Master of Computer Applications -

West Bengal University of Technology
West Bengal

Bachelor of Computer Applications -

Burdwan University
Burdwan University

Higher Secondary (10+2) -

CBSE Board
Kendriya Vidyalaya

Secondary (10) -

CBSE Board
Kendriya Vidyalaya

Skills

  • Oracle PL/SQL and SQL
  • Project management
  • Business analysis
  • Cost evaluation
  • Risk management
  • Decision making
  • Strategy development
  • Leadership and team building
  • Performance tuning
  • MemSQL
  • Cerner command language (CCL)

Personal Information

  • Father's Name: Mr. Nilmoni Roy
  • Mother's Name: Mrs. Chandana Roy
  • Date of Birth: 02/28/87
  • Gender: Male
  • Marital Status: Married

Disclaimer

I hereby declare that the above-mentioned information is correct, up to my knowledge and I bear the responsibility for the correctness of the same.

Certification

  • Certification course titled Diploma in Java Technologies from the National Institute of Information Technology (NIIT)
  • Self-paced MemSQL 6 developer training
  • Self-paced MemSQL 6 database administrator training
  • Agile software development from Coursera
  • Fundamentals of project planning and management from Coursera

Languages

  • English
  • Hindi
  • Bengali

Timeline

Project Manager

Capgemini
12.2021 - Current

Software Engineer III

Cerner Corporation
03.2020 - 12.2021

Data Architect Analyst

Fiserv India Pvt Ltd
06.2019 - 03.2020

Applications Developer

Oracle Financial Software Services Limited
05.2017 - 06.2019

Senior Software Engineer

Infosys Ltd
09.2014 - 04.2017

Associate Software Engineer

CGI Information systems & Management Pvt Ltd
06.2012 - 09.2014

Master of Computer Applications -

West Bengal University of Technology

Bachelor of Computer Applications -

Burdwan University

Higher Secondary (10+2) -

CBSE Board

Secondary (10) -

CBSE Board
Sandeep Roy