Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Disclaimer
Generic

THOMAS DCRUZ

Manager Data and Analytics
Bangalore,Karnataka

Summary

Having 12+ years of rich experience in Data analytics with Azure, AWS and GCP Cloud adoption and enabling Data products by Data Engineering, Data warehouse Development, Cloud Data Ingestion, Data Curation, Data management, Data Governance, Data Quality, Data modeling, design of new Data warehouse, Datalake and lakehouse system to provide data insight for reports/KPI/Dashboard, using on Premises tools and cloud platforms on various components and ETL/ELT and streaming services. Well versed in Data transfer/migration process from EDW to cloud for various use cases, Data pipeline design, development, implementation and consultancy in adoption for PaaS services (Compute, Storage). Hands-on experience in writing and debugging complex SQL Queries, defect/issues Analysis, RCA. Experience in DevOps builds and release pipeline creation Code Deployment/verification till PROD. Ability to work in diverse stakeholder environment. Lead a team of Data - Engineers/Architects/Modelrs, SQL deveplopers and Reporting Analysts, providing them direction, assisting, and supporting to scale up the team. Drive and motivate a team to deliver on project objectives and team growth. Passion for turning ideas into products and improving the member experience. Experience in Team leading, mentoring, Stakeholder management, Cross-team collaboration, Project management, effort estimation, project roadmap creation. Expertise in Healthcare, Finance, Banking, E-commerce, Retail, Manufacturing and Pharm- Data analytics. Skilled at gathering requirements, translating the same into Business Requirement, Documents and technical solution agreed-upon SLAs & KPIs. Worked on Azure Cloud for creating analytics data using Azure. Stream Analytics, Azure Event Hubs to get it in required format. Worked on Data Models Desgining and Data Load Integration, Master Data Management & Master Data Unit process flow and relational data systems. Data Security and Integreity Policies and Used different data warehousing concepts to build a data warehouse for internal departments of the organization. Phases on Databricks to cut down large data sets from multiple source systems. Hand on experience on Data Warehouse/Lakehouse technical architecture concepts,infrastructure component and ELT process. Data Visualizations on Power BI and Tableau to build interactive dashboards and data stories. Data Integration and Transformations for data extracted from various IT systems. Develop, construct, test and maintain architectures. Align architecture with business requirements.

Overview

12
12
years of professional experience
6
6
Certificates
5
5
Languages

Work History

Manager, Data & Analytics (Handling a Team of 20)

MYK Laticrete LTD
09.2023 - Current
  • Cleansing data directly in source systems SAP Hana
  • Appy ETL methodology for data driven tasks in Azure Data Factory
  • Good Knowledge of Data Factories process
  • IDS Integration with pipeline process
  • Data Models Desgining and Data Load Integration
  • Master Data Management & Master Data Unit process flow and relational data systems
  • ETL,ELT process flow
  • Determines data storage needs in Azure Data Factory
  • Managing Relationship with Data Stakeholders for services related
  • Look into the Data related policies for qulaity and security on SAP and Azure ADF
  • Data Security and Integreity Policies
  • Use different data warehousing concepts to build a data warehouse for internal departments of the organization in Azure Data Factory
  • Contribute to innovation strategies by exploring, investigating, recommending, benchmarking and implementing new data centric technologies for the platform
  • Create and enhance data solutions enabling seamless delivery of data and be responsible for collecting, parsing, managing and analyzing large sets of data
  • Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models
  • Lead the design of the logical data model and implement the physical database structure to constructs and implement operational data stores and data marts
  • Phases on Databricks to cut down large data sets from multiple source systems
  • Knowledge of Data Warehouse/Lakehouse technical architecture concepts,infrastructure component and ELT process.

Lead Data Architect (Handled a Team of 10)

CGI Infosystems Pvt Ltd
05.2022 - 09.2023
  • Design develop, automates, and support complex applications to extract, transform, and load data
  • Prepare data for predictive and prescriptive modeling
  • Develop logical and physical data flow models for ETL applications
  • Translate data access, transformation, and movement requirements into functional requirements and mapping designs
  • Creation and desiging of various data moels : Conceptual,Logical,Dimensional & Physical Data Models in SQL,SAP PD certified and Microsoft Studio
  • Adherence to compliance procedures in accordance with regulatory standards, requirements, and policies
  • Managing and designing the reporting environment, including data sources security, and metadata
  • Database mapping
  • Database implementation
  • Data Visualizations on Power BI and Tableau to build interactive dashboards and data stories
  • Data Integration and Transformations for data extracted from various IT systems
  • Develop, construct, test and maintain architectures
  • Align architecture with business requirements.

Business Information Expert and Data Migration Expert

HTC Global Services, Client- PHILIPS INNOVATION CAMPUS
01.2019 - 05.2022
  • Data acquisition
  • Develop data set processes
  • Identify ways to improve data reliability, efficiency and quality
  • Conduct research on data for industry and business questions
  • Use large data sets to address business issues
  • Deploy sophisticated analytics and statistical methods
  • Find hidden patterns using data
  • Use data to discover tasks that can be automated
  • Deliver updates to stakeholders based on analytics
  • Responsible for creating data upload mail merge templates for automated data feeds
  • Performance management
  • Data warehouse mappings
  • Build data architectural behaviors
  • Maintain and re-engineer existing ETLs to increase data accuracy and data stability
  • Participate in workflow analysis and workflow redesign
  • Data Warehouse Solutions
  • Participate in rapid prototyping activities in real-time with the clients to configure the RSA Archer, Informatica MDM, SAP MDM platform to meet client business needs
  • Produce a detailed technical design document and effort estimation for Proposal to match clients requirements expectations on datasets.

Marketing Operations Analyst

True Blue India, Client -DELL INTERNATIONAL SERVICIES (DELL TECHNOLOGIES)
10.2016 - 10.2018

System Admin

Blue matrix Services Pvt Ltd
10.2015 - 01.2016

System Admin

Shristi Informatics
07.2014 - 10.2015

Technical Engineer

Informatique Pvt Ltd
11.2011 - 02.2014

Education

Bachelor of Computer Applications -

Oxford University

Diploma in Information Technology - undefined

CMC Computer Education

Intermediate - undefined

Fatima College

Matriculation - undefined

St. Mary’s School

Skills

Windows 8undefined

Certification

Diploma in Information Technology

Accomplishments

  • Won the Quality performer of the year 11th Nov 2014
  • Won the top performer of the month 12 Dec 2014
  • Increased the revenue on quarterly basis on giving sales improvements through dashboards
  • Developed Interface between Systems 2020-2021
  • Managed client escalations and played key roles in technology enhancements and process

Timeline

Manager, Data & Analytics (Handling a Team of 20)

MYK Laticrete LTD
09.2023 - Current

Lead Data Architect (Handled a Team of 10)

CGI Infosystems Pvt Ltd
05.2022 - 09.2023

Business Information Expert and Data Migration Expert

HTC Global Services, Client- PHILIPS INNOVATION CAMPUS
01.2019 - 05.2022

Marketing Operations Analyst

True Blue India, Client -DELL INTERNATIONAL SERVICIES (DELL TECHNOLOGIES)
10.2016 - 10.2018

System Admin

Blue matrix Services Pvt Ltd
10.2015 - 01.2016

System Admin

Shristi Informatics
07.2014 - 10.2015

Technical Engineer

Informatique Pvt Ltd
11.2011 - 02.2014

Bachelor of Computer Applications -

Oxford University

Diploma in Information Technology - undefined

CMC Computer Education

Intermediate - undefined

Fatima College

Matriculation - undefined

St. Mary’s School

Disclaimer

I do hereby declare that all the information given above is true to the best of my knowledge and belief.
THOMAS DCRUZManager Data and Analytics