Data Architect/Business Analyst/Data Modeler/Data Enginner
- Verfügbarkeit einsehen
- 1 Referenz
- auf Anfrage
- 65760 Eschborn
- Weltweit
- hi | en | de
- 16.09.2024
Kurzvorstellung
DWH, MPP systems, ETL, GenAI, Big Data, Azure, Snowflake, Data Science
Domains: Telecom, Banking, Healthcare, Retail, Real Estate, and Sustainability.
CI/CD Specialist
Auszug Referenzen (1)
"R. was a great asset to our customer and a pleasure to work with. We thank him for the great work and wish him all the best for the future."
11/2023 – 8/2024
Tätigkeitsbeschreibung
Contribution as Senior Data Expert:
1. Provided high level deliverables to kick start – Blue Print of the Solution, Data Dictionary and Conceptual Model.
2. Responsible for Logical Data Model – in accordance with Data Modeling Framework to ensure Bosch standards are being followed.
3. Responsible for Physical Data Model of 2 source systems as per DMF(internal) and Data Vault standards.
4. Responsible for Business Vault Layer, Information Mart.
5. Responsible for documentation of Hard Rules and Soft Rules as per Data Vault 2.0.
6. Responsible for maintaining data quality using existing Data Governance Framework within Bosch.
7. Responsible for setting up the CI/CD process including Gitbucket, Sourcetree, Jenkins, Blue Ocean and SonarQube.
8. Responsible for Metadata Management, Orchestration and Monitoring.
9. Comparative analysis of Databricks vs Wherescape Red vs In-House Bosch Framework vs Databricks.
Azure Databricks, Data Vault, Datawarehouse / DWH, Proof of Concept (POC), Python, Requirement Analyse, Stakeholder-Analyse
Qualifikationen
Projekt‐ & Berufserfahrung
11/2023 – 8/2024
Tätigkeitsbeschreibung
Contribution as Senior Data Expert:
1. Provided high level deliverables to kick start – Blue Print of the Solution, Data Dictionary and Conceptual Model.
2. Responsible for Logical Data Model – in accordance with Data Modeling Framework to ensure Bosch standards are being followed.
3. Responsible for Physical Data Model of 2 source systems as per DMF(internal) and Data Vault standards.
4. Responsible for Business Vault Layer, Information Mart.
5. Responsible for documentation of Hard Rules and Soft Rules as per Data Vault 2.0.
6. Responsible for maintaining data quality using existing Data Governance Framework within Bosch.
7. Responsible for setting up the CI/CD process including Gitbucket, Sourcetree, Jenkins, Blue Ocean and SonarQube.
8. Responsible for Metadata Management, Orchestration and Monitoring.
9. Comparative analysis of Databricks vs Wherescape Red vs In-House Bosch Framework vs Databricks.
Azure Databricks, Data Vault, Datawarehouse / DWH, Proof of Concept (POC), Python, Requirement Analyse, Stakeholder-Analyse
6/2022 – 9/2023
Tätigkeitsbeschreibung
Contribution as a Senior Data Modeler + Architect + Erwin Admin:
1. Educate new joiners around Data Vault methodology.
2. Collect requirements from Tower/Business Team.
3. Decode XML based dynamic files to fixed schema based Enrich Layer.
4. Create Data Vault Components in Raw Vault and Business Vault Layer.
5. Create IM objects to cater the reporting requirements.
6. Provide mapping sheets to Engineering team to build pipelines.
7. Act as a bridge between Data Modeling and Data Architect community and create RACI matrix.
8. Create standards for Data Modeling community.
9. Review data models of other towers.
10. Work closely with Management to draft the project plan based on requirements complexity.
11. Write STTMs from Stage layer to Raw Vault Layer and Raw Vault Layer to Information Mart
Data Vault, Datawarehouse / DWH, Teradata
10/2019 – 5/2022
Tätigkeitsbeschreibung
Contribution as Lead Developer
1. Provided Inputs to Project Charter to define the roadmap of project.
2. Documented existing business rules currently implemented in Retail Mart, Riskmart and Kordoba.
3. Delivered physical model for Espernato Mart.
4. Developed ETL mappings in Datastage and Job plans using Automic UC4.
5. Delivered first phase of solution in production precisely matching the specs of downstream systems.
6. Delivered second phase of project, Enterprise Warehouse Model.
Datawarehouse / DWH, Data Vault
9/2018 – 9/2019
Tätigkeitsbeschreibung
Contribution as Business Analyst + Data Modeler + Power Designer Mappings Developer:
1. Provided Inputs to Project Charter to define the roadmap of project.
2. Finalization of Scope & Collection of Business Requirements from Business head and directors.
3. Established Data Model Governance, Data Quality Management and Reference Data Management
processes.
4. Worked closely with Business Contacts to understand the business requirements and nature of
data.
5. Worked closely with IT contacts to understand the nature of source systems.
6. Defined frameworks to capture the business requirements as part of Gap Analysis and not BRD
given the nature of project.
7. Documented existing business rules currently implemented in Remedy, CMDB and ADDM source
systems.
8. Delivered fully functional model for Integrated Layer embedded with mappings and scheduling
metadata in Power Designer.
9. Led the team to create Access Layer and Data Mart Layer.
Datawarehouse / DWH, Teradata
11/2017 – 6/2018
Tätigkeitsbeschreibung
Contribution as Senior Business Analyst:
1. Provided Inputs to Project Charter to define the roadmap of project.
2. Finalization of Scope & Collection of Business Requirements from CIO and Business Heads of various
functions within Bank.
3. Established Project Governance, Data Management and Information Management Team.
4. Worked closely with Business Contacts to understand the business requirements and nature of
data.
5. Worked closely with IT contacts to understand the nature of source systems.
6. Defined frameworks to capture the business requirements as part of Gap Analysis and not BRD
given the nature of project.
7. Documented existing business rules for Retail and Marketing functions.
8. Delivered Gap Analysis document, Erwin Data Model and SMX(Source to target mapping).
9. Leveraged my expertise in MPP systems to help the client with a POC to compare Teradata and
Amazon Redshift.
Datawarehouse / DWH, ETL
Ausbildung
C-DAC
Hyderabad
Panipat
Über mich
➢ Working as a Senior Data Expert(Data Vault 2.0) for German manufacturing giant.
➢Seasoned Data Modeler with experience on Telecom, Manufacturing, Finance, and Retail Logical data models.
➢Deep understanding of GenAI concepts and products. Developed customer bot as a capstone project.
➢Delivered multiple projects with Top-Down and Bottom-Up approaches, ER modeling, Dimensional Modeling, and Key-Based Modeling (Data Vault, Key-Version)
➢ In-depth understanding of the Architecture of MPP systems.
Weitere Kenntnisse
➢ Databases: Teradata, MS SQL Server, Oracle, MemSQL(In-Memory).
➢ Scripting Languages: Bash, Python, Scala.
➢ Big Data Ecosystem: Hadoop, MapReduce, HDFS, HBase, Hive, Pig, Sqoop, Impala, Apache Spark, Kafka, and NiFi.
➢ Data Science Techniques: Linear Regression, Logistics Regression(Simple and Multiple), Decision Tree, Random Forest, Principal Component Analysis, K-means, Recommendation Engine, Time Series Analysis, and Sentiment Analysis using R.
➢ Tools: SAP Power Designer, Erwin, Teradata UDI, Informatica, SAP BODS, Datastage, HP Quality Center, GIT.
Certifications
➢Snowflake Snow Pro Core Certified
➢ Teradata(V2R5) Certified Professional
➢ Teradata(V2R5) Certified SQL Specialist
➢ Teradata(V2R5) Certified Implementation Specialist
Persönliche Daten
- Hindi (Muttersprache)
- Englisch (Muttersprache)
- Deutsch (Fließend)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden