Debangan Roy
Lead Consultant at DB Results- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Kubernetes
UdemyJun, 2023- Nov, 2024 -
AWS Certified Solutions Architect
Amazon Web Services (AWS) -
Oracle Database SQL Certified Associate
Oracle
Experience
-
DB Results
-
Australia
-
IT Services and IT Consulting
-
200 - 300 Employee
-
Lead Consultant
-
May 2023 - Present
Data Migration Project Lead - Resolution Life:Led the overall data migration for a transformation project at Resolution Life.Took responsibility for the solution design and architecture of the data migration process, ensuring a seamless and successful transition of critical data.Collaborated with cross-functional teams to understand business requirements, assess data dependencies, and design an efficient and scalable migration strategy.Played a crucial role in the solution design and architecture of the migration and reconciliation processes.Developed a comprehensive framework for data migration, including data mapping, transformation, and validation, ensuring data integrity and accuracy throughout the process.Collaborated with stakeholders to identify reconciliation requirements, design efficient reconciliation workflows, and implement automated reconciliation mechanisms.Contributed as a solution designer for an in-house-built policy administration system.Collaborated closely with business stakeholders to understand their requirements and translate them into technical solutions.Designed and implemented the solution architecture, ensuring scalability, performance, and adherence to best practices.Played a key role as a member of the solution architecture team within DB Results, actively contributing to the design of various in-house initiatives.Conducted various workshops within the company, sharing knowledge and insights on emerging technologies and architectural concepts.Key Skills- Solution design, Data architechture, IICS, Snowflake,Event driven systems Show less
-
-
Lead Consultant
-
Nov 2022 - May 2023
Led the design and implementation of a robust data reconciliation framework for the transformation of billing systems into Oracle CCS at Great Western Water.Designed and developed an automated application framework for data reconciliation, ensuring accurate and efficient data movements across different stages within the ecosystem.Leveraged OCI (Oracle Cloud Infrastructure) REST capabilities and CLI (Command Line Interface) tools to architect the application, using Python for frontend development and SQL Server for backend data processing.Played a key role as a member of the solution architecture team within DB Results, actively contributing to the design of various in-house initiatives.Conducted various workshops within the company, sharing knowledge and insights on emerging technologies and architectural concepts.Actively participated in the architecture community, contributing to discussions and knowledge sharing sessions on new-age niche technologies and best practices.Collaborated with peers to explore innovative solutions, evaluate new technologies, and drive continuous improvement in architecture practices.Key Skills- Solution design, Python, Rest API's, OCI, Data architechture Show less
-
-
-
Tata Consultancy Services
-
India
-
IT Services and IT Consulting
-
700 & Above Employee
-
Technical Lead and Solution design
-
Oct 2018 - Nov 2022
Data Analytics Capability:Debangan led the design and implementation of a comprehensive data analytics capability at MLC Life. His expertise in solution design enabled the leveraging of data for forecasting, retention, and growth. By designing a scalable data lake using the Data Vault methodology, Debangan ensured flexible data storage and analysis. His solution design covered data ingestion, transformation, modeling, and visualization, enabling MLC Life to harness the full potential of their data.Data Migration Solution:As the responsible solution architect, Debangan successfully designed and executed the data migration strategy for the claims module. His meticulous planning and implementation ensured a seamless transfer of critical business data from legacy systems to the new environment. Debangan's solution architecture prioritized data quality, integrity, and performance, guaranteeing a successful transition for MLC Life.Retail Policy Administration and Claims Transition:Debangan played a key role in leading the transition of the retail policy administration and claims module. Collaborating closely with stakeholders, he identified requirements, analyzed existing processes, and designed efficient solutions. His solution design included the integration of data analytics architecture, providing comprehensive insights for effective decision-making in the business areas.Digital Capabilities Design:Debangan demonstrated his solution design prowess by spearheading the development of digital capabilities for TCS BaNCS at MLC Life. His expertise resulted in a seamless and efficient digital ecosystem. Additionally, Debangan actively contributed as a developer and owner for specific modules within the digital capabilities, further enhancing his impact on the projectPrimary Skills: Data architecture, Insurance inside and outside Super, Solution design, Application architecture, Digital technologies Show less
-
-
Technical Lead
-
Oct 2014 - Oct 2018
Debangan served as a Technical Lead within the TCS team, driving the transformation efforts at Friends Life UK. In this role, he had the responsibility of overseeing the TCS technical team and leading various initiatives, including data migration, building the TCS BaNCS data warehouse, performance improvement, and establishing a CI/CD capability for TCS BaNCS. With a team of 10 members, his key responsibilities included:Leading the data migration of the policy administration module, ensuring a smooth and successful transfer of critical business data.Taking charge of the build activity for the TCS BaNCS data warehouse capability, creating a scalable and efficient data storage and analysis solution.Being responsible for performance tuning of various production systems, optimizing their performance for enhanced efficiency.Designing the data pipeline for the monthly valuation process, ensuring seamless data flow and accurate valuations.Designing and implementing the overall CI/CD pipeline, promoting continuous integration and delivery practices for streamlined development processes.Debangan's expertise in data architecture, insurance domain, solution design, application architecture, and digital technologies further enhanced his ability to drive successful transformations.Key Skills - ETL, CICD, Data modelling,Data migration, Performance tuning Show less
-
-
Data Engineer
-
Mar 2012 - Oct 2014
Debangan worked as a data engineer as a part of TCS team responsible for building the data analytics and reporting capability of the wealth management division of The Harford insurance. He worked closely with the customer for understanding the reporting needs and build the data pipeline and the data visualisation.•Build the data pipeline in informatica•Build reports using SAP business objects•Defect fixing and resolutions•Gathering new reporting requirements
-
-
Education
-
2007 - 2011
University Institute of Technology, The University of Burdwan
B.E, Electronics and communication engineering
Community
