Raja Boopathi Subramanian
Summary
Experienced Data Architect with over 22 years of expertise in data management, data governance, and data quality. Proven track record in leading data management initiatives, designing automated data validation processes, and driving data quality improvements. Skilled in SQL, Python, R, and industry-standard data quality and governance tools(Collibra, Informatica DQ,CDQ and SAP-MDG). Adept at working with cross-functional teams,key business stakeholders, data owners, SPOC in complex environments to establish and maintain data standards.
Overview
22
22
years of professional experience
Work History
Data Architect, NGDA, Contractor
LeasePlan N.V, B.V
11.2021 - 05.2024
- Led data management/data quality improvement initiatives, working with finance and insurance teams
- Automated data quality rules using Collibra and Ataccama to ensure data quality and accuracy
- Migrated data from SAP ECC, Salesforce, NOLS to S/4 HANA and Enterprise Datawarehousing (SAP, Snowflake)
- Developed Denodo and Power BI reports for data quality monitoring
- Designed reports for regulatory and enterprise data quality and migrated from the existing systems using hybrid modelling/virtualization techniques
- Worked with Migration team to prepare the data from Business applications, SAP ECC, Salesforce, NOLS to S/4 HANA for UK and extract the data for Denodo Virtualization
- Worked in Agile teams, executing changes based on 2-week sprints
- Served as SME on data protection and regulations, provided guidance
- Provided a consultative approach with users, understanding business needs and deriving data flows accordingly for Regulatory reporting
- Collaborated closely with Data Managers, Data Governance experts, Data Engineers, Product owners and Data analysts on gathering, reviewing, and interpreting business and technical requirements
- Developed strategic data architecture designs for an open data architecture used for data analytics use cases
- Technologies: SAP,Salesforce, Snowflake, Denodo,Power BI, SQL, ODP, S/4 HANA , Denodo,Collibra, Ataccama, Jira, Confluence and Leasing Solutions
- GrandVision
Architect
01.2021 - 10.2021
- Determined structured and unstructured data architecture requirements by blending business needs with the feasibility of current and emerging data technologies and standards
- Developed data extract models and migration processes to Azure DataLake
- Worked with a roll-out program to model and implement new reports for Production data from SAP and Retails solutions
- Conducted data profiling and implemented data transformation rules
- Worked with Product owner to automate the data loading process by using R Programs and SAP Algorithms
- Co-ordinated with functional teams to resolve data load issues
- Partnered with and became a knowledge expert across the organization to help solve complex data analytics business problems by designing appropriate data architectures
- Technologies: Azure, BODS, SAP, SQL, Python, R,Jira,Azure DevOps,Jenkins
ICT, Data Lead /Data Security Officer
Jumbo Supermarket
08.2018 - 12.2020
- Improved data quality post-merger using SAP and Azure DWH
- Developed data reports and optimized data extraction and loading processes
- Implemented security models and data pipelines
- Developed database and big data solutions by designing data architectures, including business architecture, data storage, data analytics, data transformation, and data access definitions
- Worked with Data pipelines/Data Ingestion techniques to extract and load the data from various sources to Azure Storage (Blob/Azure Gen2 and File storage)
- Developed a strategy for data archival process using NLS solutions
- Provided best practice direction and hands-on implementation of optimized relational and non-relational database solutions
- Provided delivery leadership in the design, deployment, and data conversion of complex data solutions, UAT, and data architecture practices
- Technologies: SAP, HANA Cloud, Retail Systems, CAR,Azure, Power BI, MicroStrategy, SLT, ODP, CDS, SAC,Git,Confluence and okta for Single Sign-on
Data Delivery Lead
KPN, Cognizant Technology Solutions
04.2016 - 07.2018
- Managed data integration projects and set up data in Enterprise Datawarehouse(SAP/Tera data) from ServiceNow, Oracle and other DB systems
- Prepared functional and technical designs, and worked with various data pipelines for migrating the data model from SAP to Teradata
- Created and communicated data architecture standards and best practices, and designed data movement and mapping
- Validated data quality and integration of all data architecture components, capturing necessary metrics for benchmarking and trending
- Technologies: BODS,SAP-BO(Universe for Virtualization ,Webi ) ServiceNow,Jira, Teradata, Oracle Financials, Hadoop, Python,Airflow,Oozie,Lugie
Solution Architect/Project Manager
AkzoNobel, Cognizant Technology Solutions
10.2011 - 03.2016
- Led data modeling and quality initiatives, developed data remediation dashboards
- Managed data consolidation projects post-merger
- Worked with SQL,R Programming and DataServices for extraction
- Worked with DQR (Data Quality Remediation) Dashboard to improve the Vendor Payment terms data quality across Organizations by identifying the error data and fixed it in Source Systems.This improves the data quality from 65% to 93%
- Developed Slowly changing Dimension(SCD) in BODS for loading the data
- Developed reports in Finance, Procurement, and other functional areas
- Understood and applied the enterprise data life cycle (creation, replication, archival, disposition of historical and PII data)
- Delivered a common solution to develop OTP (On Time Payment)Dashboard based on Vendor Master data by combining data from various source systems and business applications in Enterprise Datawarehouse
- This process helps to automate the reporting and improve the data quality
- Evaluated and recommended data query and modeling tools, developed and communicated best practices for those tools, and improved effectiveness and quality
- Developed and improved data domain blueprints
- Assisted developers in designing and improving database queries, providing training and learning opportunities.
Project Manager/Data Analyst/Lead Consultant
Mindwave Solutions Pte, Airlines/Accenture Technology Solutions, Tata Technologies
02.2002 - 09.2011
- Novartis, SAP Labs, Managed teams and led data migration projects
- Developed and tested Finance and Purchasing related master data
- Supported deep business analytics and statistically based data analysis projects by designing and implementing suitable architectures
- Technologies: SAP-DWH,LSMW, BDC, SAP, DataServices,ABAP, BEx Analyzer
Designer
SAP
- MfgPro, Data Services, HANA, BO,Hyperion,Cognos,SAP-BO,Lumira
Education
Bachelor of Engineering - Electronics and Communication
2001
Skills
- Key Competencies
- Data Architecture & Management: Enterprise Data Warehousing (Kimball, InMon, LSA and LSA), Data Lake, Data Lakehouse, Data Fabric and Data Mesh (SAP-Data and Analytics, Teradata,Big data, Snowflake, Azure Data Factory, Azure Data Lake, Azure Synapse Analytics)
- Data Analysis & Visualization: Power BI,Spotfire, Denodo, Tableau,SAP-BO, Qlik, MicroStrategy, SAS Visual Analytics and Cognos
- Data Quality & Governance: Master data governance, DQ Dimensions - Automated Data Quality, Data Profiling, Assessment, Cleansing, Monitoring, Issue Management (Collibra, CDQ, Ataccama,Informatica, SAP-Information Steward,MDG and Talend)
- Programming & Data Integration: SQL, Python, R, Hadoop (Spark,Hive,Pig, Impala, Sqoop), Data Services, Informatica, BDC, LSMW, BAPI, ALE, IDoc,Azure Pipelines, EDI,S/4 Data Migration Cockpit, Syniti, SLT, Cloudera-Hadoop
- Data Modeling: Enterprise Data Modeling, Data Vault, Dimensional models, ERD/ERM (Power Designer, Collibra, Erwin)
- Reference and Meta/Master data management :SAP and Informatica
- Data extraction techniques : ETL,ELT and EtLT
- Cloud & Big Data Technologies: AWS, Azure, Databricks, Teradata, Hive, Map Reduce, Spark, Kafka
- Workflow Management: Airflow, Oozie, Luigi
- DevOps(CI/CD) Tools - Azure DevOps, Jenkins ,Git, Docker, Solution Manager and Kubernetes
- Project Management: Agile/SCRUM,Kanban, Jira, Confluence, GitHub and Waterfall
- Data Management Best Practices: DAMA-DMBOK, Data Privacy, Regulatory Requirements, AI/ML, Generative AI
- Skills
- SQL, Python, R Programming
- Data Governance, Data Mapping, Data Integration and Data Quality
- Risk Management, Regulatory Compliance, GDPR,Internal System Auditing
- Data Modelling,Reporting and Data Quality Dashboards
- Data Management Knowledge
- DAMA-DMBOK (Data Management Body of Knowledge): Extensive understanding of the DAMA-DMBOK framework, encompassing data governance, data quality, data modeling, data storage and operations, data security, and data integration This framework provides best practices and methodologies to ensure effective data management and governance
- Data Governance: Implementing data governance frameworks to establish and maintain data quality standards Knowledge of data policies, standards, and procedures to ensure data accuracy, consistency, and security
- Data Privacy & Compliance: Understanding of regulatory requirements such as GDPR, and implementing measures to ensure data privacy and protection
Additional Information
- Familiarity with AI/ML,IoT and Generative AI technologies and their applications in data management and analytics. Key responsibilities: Implemented a data sensitivity approach for confidential data by using the relevant security and authorization approach (data masking, encryption, hiding and restricting the access etc) Good experience in Data Management (Data Migration/Profiling/Data Cleansing/ Data quality/Transformation/Harmonization and Consolidation)projects by extracting data from various Source systerms/csv files. Employed a consultative approach with stakeholders,data owners to grasp business requirements and derive appropriate data flows. Worked closely with Data Managers, Data Governance experts, Data Engineers, and Data Owners to gather, assess, and interpret both technical and business requirements. Worked with high-availability and high-scalability solutions. Designed strategic data architecture solutions tailored for open data frameworks used in data analytics applications. Determined the needs for structured and unstructured data architecture by blending business requirements with current and emerging data technologies and standards by using Traditional DWH ,Cloud DWH and Big data . Developed comprehensive database and big data solutions, encompassing business architecture, data storage, analytics, transformation, and access definitions. Provided leadership in implementing optimized relational and non-relational database solutions, offering guidance on best practices. Lead the design, deployment, and conversion of complex data solutions,First time right scenarios implementation for DQ, overseeing User Acceptance Testing (UAT) and data architecture practices. Established and communicated standards and best practices for data architecture, including designing data movement strategies and mapping. Validated the quality and integration of all components within data architecture, capturing metrics for benchmarking and trend analysis. Applied a comprehensive understanding of the enterprise data lifecycle, including data creation, replication, archival, and handling Personally Identifiable Information (PII) data. Evaluated and recommended data query and modeling tools, and enhance their effectiveness and quality through best practices communication. Developed and refined blueprints for data domains to improve overall data management efficiency. Supported the developers in enhancing database queries, offering training and opportunities for skill development. Supported complex business analytics and statistically-driven data analysis initiatives by designing and implementing appropriate architectural solutions. Participated actively in data management processes, including data lineage tracking, profiling, quality management, stewardship, and governance. Collaborated seamlessly with ETL/ELT/EtLT developers, Data engineers,database and big data administrators, application interface developers, DevOps and IT operations personnel, as well as product management and clients. Interacted professionally and cooperatively with personnel at all organizational levels, external vendors, and clients within a team-oriented environment. Organized tasks and allocate resources efficiently to ensure timely completion of work in adherence to established procedures.
Timeline
Data Architect, NGDA, Contractor
LeasePlan N.V, B.V
11.2021 - 05.2024
Architect
01.2021 - 10.2021
ICT, Data Lead /Data Security Officer
Jumbo Supermarket
08.2018 - 12.2020
Data Delivery Lead
KPN, Cognizant Technology Solutions
04.2016 - 07.2018
Solution Architect/Project Manager
AkzoNobel, Cognizant Technology Solutions
10.2011 - 03.2016
Project Manager/Data Analyst/Lead Consultant
Mindwave Solutions Pte, Airlines/Accenture Technology Solutions, Tata Technologies
02.2002 - 09.2011
Designer
SAP
Bachelor of Engineering - Electronics and Communication
Similar Profiles
Liandro J. S. Fernandez RiosLiandro J. S. Fernandez Rios
Warranty Specialist at A&F Motors N.V / The Freedom Machines N.VWarranty Specialist at A&F Motors N.V / The Freedom Machines N.V
Tatiana DijkersTatiana Dijkers
Regional Head - Internal Audit at Orco Bank N.V. & Aruba Bank N.V.Regional Head - Internal Audit at Orco Bank N.V. & Aruba Bank N.V.
Chen LuChen Lu
Solution Delivery Manager at SGFleet (LeasePlan), AustraliaSolution Delivery Manager at SGFleet (LeasePlan), Australia
Roy MitchellRoy Mitchell
Contractor - Senior Data Modeler / Data Architect at Ascension (Bank)Contractor - Senior Data Modeler / Data Architect at Ascension (Bank)
Pradeep KattaPradeep Katta
Head of Data Governance Representing Technology || Head of Data Engineering Tooling and Platform || Cloud Solutions Data Architect at CitigroupHead of Data Governance Representing Technology || Head of Data Engineering Tooling and Platform || Cloud Solutions Data Architect at Citigroup