Rahul Roy
Bangalore
Summary
Software Engineer with extensive experience at ITC Infotech, focusing on full-stack development with .NET Core and Angular 16. Skilled in enhancing database performance and executing comprehensive data quality checks. Proven ability to lead modernization initiatives and promote cross-team collaboration for effective data migrations.
Overview
6
6
years of professional experience
Work History
Software Engineer
ITC Infotech
04.2022 - Current
- A centralized governance platform managing the end-to-end lifecycle of large-scale SAP data migrations. The system orchestrates Data Preparation (DP), Data Quality Checks (DQC), and Data Loads (DL) across critical stages like Trial Conversions (TC1/TC2) and Cutover 1.
- A Master Data Management (MDM) tool used for creating and updating data in SAP Bridge & Federation systems. The application manages critical master data needs across Material, Logistics, Manufacturing, Sales, and Quality domains, featuring robust Data Quality Reporting (DQR) and workflow capabilities.
- Full-Stack Modernization: Spearheaded the re-engineering of the legacy MOM application into a modern architecture using .NET Core and C# for the backend API and Angular 16 for the frontend, hosted on IIS.
- Workflow Engine: Developed state-machine logic to track data objects (UDFs) through statuses from 'Not Started' to 'Validated' 2, including an 'Unlock Workflow' feature to handle transaction failures.
- Database & ORM: Designed the Oracle Database schema using EF Core to manage complex 'Predecessor/Successor' relationships between migration objects.
- Integrations: Implemented PingID for SSO security and built APIs to interface with SharePoint for automated DQC file handling.
- Tooling: Developed a high-performance Excel/CSV Converter utility using Node.js (v22) to standardize datasets for migration teams.
- Workflow Orchestration: Implemented the end-to-end request lifecycle: ERP Selection → Template Download → Queue Processing → DQC → SAP Upload.
- Queue Mechanism: Developed a concurrency control system (Queue Mechanism) to manage incoming requests; ensuring active processes complete before picking up new requests for the same activity.
- Data Quality Check (DQC): Built validation logic to verify data formats in uploaded templates. Configured the system to reject invalid data with detailed feedback or promote valid data to the SAP upload stage.
- Notification System: Integrated automated email triggers to notify users of DQC results and final SAP upload status.
- Legacy Maintenance: Supported the transition from the legacy application (built on VB.NET, Oracle SQL) to the modern .NET Core architecture, ensuring feature parity in the Waterfall model.
Software Engineer
CGI
07.2019 - 04.2022
- Facilitates annual financial declarations and KYC management for members.
- An administrative platform managing queries, invoice/vendor management, and incident tracking.
- HR operations tools managing employee documents (eNabler) and payroll-related queries.
- Manages domestic and international business travel requests with multi-level approvals.
- Exit management application streamlining clearance processes across departments.
- Developed modules using .NET Core, Razor Pages, and Entity Framework.
- Optimized stored procedures and performed unit testing.
- Handled full-stack development using ASP.NET and ADO.NET.
- Performed data modeling and performance tuning.
- Developed application logic and managed SQL Server data modeling.
- Responsible for deployment and maintenance.
- Developed web forms and logic using C# and ASP.NET.
- Optimized stored procedures and conducted unit testing.
- Participated in Low-Level Design (LLD) and developed application logic.
- Managed deployment, maintenance, and database optimization.
Education
B.Tech - Electronics & Communication Engineering
Bengal College Of Engineering & Technology
Durgapur01.2018
Skills
- C# and VBNET
- JavaScript and TypeScript
- SQL and Oracle Database
- ASPNET MVC and NET Core
- Web API and Entity Framework Core
- Angular 16 and Nodejs
- HTML5 and CSS3
- Bootstrap framework
- SQL Server (2008 R2, 2017, 2019)
- Visual Studio (2008–2022)
- Git and GitHub
- IIS administration
Disclaimer
I hereby declare that the information provided above is true to the best of my knowledge.
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Timeline
Software Engineer
ITC Infotech
04.2022 - Current
Software Engineer
CGI
07.2019 - 04.2022
B.Tech - Electronics & Communication Engineering
Bengal College Of Engineering & Technology