Shyam Mohan K

Senior Data Modeller

Bank of Ireland•  October 2018 - October 2021

• Empower the Group’s BI Strategy by contributing to the development of the data reporting layers within the Enterprise Data Warehouse (EDW), through the extension and maintenance of the conceptual Business Data Model (BDM). • Liaise with the stakeholders and business SMEs, to gather and map the data requirements from different source systems into the BDM, and support the Group’s strategic data projects like BCBS239, Core Banking (CBS), Digital Relationship Bank (DRB), Open Banking APIs etc. • Review and approve the metadata mappings between the BDM and the physical data layers, to help the technical implementation teams define the ETL workflows and data pipelines; and support the various Data Lineage and Data Governance projects. • Serve as the technical owner for all the third-party tools and technologies, used within the team; and collaborate with the external vendors and internal support teams to manage and maintain these tools. • Identify the potential areas for automation, spearhead the development of the corresponding frameworks and utilities, to automate and streamline the internal reporting and release processes.

Data Analyst Intern

SAP•  June 2018 - October 2018

• Function as part of the CoE - Analytics and undergo hands-on training in different SAP analytical tools and software. • Develop the optimized prototypes using the SAP HANA Enterprise Information Management (EIM) suite and present it to the wider business for review and enhancement ideas.

Consultant - Data Solutions

Dassault Systemes•  March 2016 - June 2017

• Lead a team of application developers and testers, planning their day-to-day activities and ensuring on-time delivery and quality of the deliverables. • Liaise with customers and project stakeholders to elicit, analyze, and document business (functional & non-functional) data requirements. • Understand the as-is and to-be system scenarios and analyze the potential negative impacts on the business or other systems within the ecosystem. • Work with the design and development teams to define technical requirements and provide clarity on the functions to be developed. • Lead and facilitate the major project team discussions and meetings to assess project health, identify critical issues, and find the corresponding resolutions. • Validate the technical implementations, ensure there are no gaps with the specifications, and obtain business sign-off on UAT and delivery. • Serve as the application SME to help the new business users and customer’s third-party vendors adapt and get used to the new ecosystem, post-delivery.

Data Integration Specialist

TCS•  January 2014 - March 2016

• Act as the translator between the business stakeholders, the technical teams, and external vendors to enable hassle-free communication between them. • Co-ordinate with the customer teams and business units across the globe, to identify the data sources, extract and collate the business data to be migrated. • Perform feasibility analysis, identify workarounds for conflicting requirements, develop proofs of concept for the suggested workarounds. • Collaborate and negotiate with the peer vendors to set up the required technical infrastructure for the proposed application ecosystem. • Spearhead the re-design and re-engineering of all the third-party application interfaces and corresponding data integration scripts to align it to the new target systems. • Proactively engage in development cycles, write code and unit test cases, conduct code reviews and efficiency tests, to improve system performance. • Review the test cases and ensure they are aligned to the functional requirements and covers all aspects of the proposed system. • Conduct overall project reviews post-delivery and document the best practices and lessons learned.