Samaresh Pahar

About Samaresh Pahar

I bring over 17 years of diverse experience in the IT industry, specializing in techno-functional data expertise across various Data and Insight Projects. My expertise spans ETL development, Data Analysis, Data Modeling, Data Governing and Process architecture of Enterprise Data Warehouse solutions on traditional and Snowflake DB platforms, primarily focused on Banking and Telecom domains.Highlights of my professional journey include- Successfully leading and managing multiple Enterprise Data Warehouse projects in roles ranging from ETL developer and Data Analyst to EDW Data/Solution Architect and Project Lead, both in traditional setups and cloud-based environments like Azure, Snowflake Database- Proficiency in governing Data Lake/Warehouse projects, encompassing Data Modeling, Data Lineage/Mapping, Master/Reference Data Management, Data Quality, Data Security, and Maintenance procedures, with hands-on experience in Azure Data Engineering using Microsoft Fabric, Azure Databricks, ADF, PySpark, ADLS Gen2, and Event Hub- Expertise in conceptual, logical, and Physical modeling, leveraging Data Vault 2.0 and IBM 3NF BDW platform for EDW implementations in the banking and telecom sectors across diverse geographies- Proven ability as an information analyst to translate business stakeholder requirements into technical components effectively- Agile methodologies advocate, enabling prioritization of critical features/epics and facilitating incremental delivery to meet evolving business needs promptly- Exploring advanced GenAI capabilities in Data Lake projects using tools like MS Copilot and IBM Watsonx- Extensive experience in project implementation and delivery, collaborating with cross-cultural customers globally in Asia, Europe, and the USA- Technical proficiency includes Azure Data Engineer(MS Fabric,ADF,Databricks,PySpark etc), Data Vault 2.0, Snowflake, Informatica Power Center (ETL), Teradata, Oracle Database, IBM Watsonx GenAI and MS Copilot Agentic app and prompt engineering.

Experience

1. Data Engineer

   IBM

   Jul 2023 — Present · Kolkata, IN

   Engaged as a Data Engineer with a focus on comprehensive data analysis, crafting EDW and Data Lake solutions on the Snowflake and Azure cloud platform, data modeling, and leveraging GenAI capabilities.Key Responsibilities- Conducted thorough requirement elicitation from stakeholders, analyzing extensive and intricate datasets to translate business needs into technical components effectively- Employed a structured approach to transform existing data sources into well-organized formats for processing within the target destination, adhering to the principles of the Data Vault model- Led Data Vault Modeling efforts (Conceptual, Logical, Physical) to architect and implement the Enterprise Data Warehouse (EDW) solution on the Snowflake platform, ensuring alignment with business objectives- Managed end-to-end data lifecycle processes including Data Lineage/Mapping, Data Quality assessment, Reference Data management, and the development of comprehensive ETL standards utilizing PowerCenter- Pioneered the exploration of automation opportunities within Data Warehouse projects, leveraging GenAI Watsonx and MS Copilot to generate project artifacts efficiently- Actively expanding expertise in cloud-based data engineering, particularly within the MS Azure environment.Tools/Technologies:Extensive experience in Data Modeling utilizing Data Vault methodology, Snowflake Data Warehousing, Informatica, Oracle and Teradata.Proficient in leveraging AI-powered tools such as GenAI Watsonx and MS Copilot to enhance productivity and streamline development processes.Hands-on experience in Azure Data Engineering using Microsoft Fabric, Azure Databricks, Azure Data Factory (ADF), PySpark, ADLS Gen2, and Event Hub for building scalable data pipelines and enabling real-time data processing.

Education

• Jadavpur University

  BE, Production Engg.

  2004 — 2008

Skills

• Sdlc
• Data Integration
• Oracle
• Requirements Analysis
• Cognos
• Extract, Transform, Load (Etl)
• Data Modeling
• Data Governance
• Ownership
• Software Development Life Cycle (Sdlc)
• Pl/Sql
• Integration
• Team Management
• User Acceptance Testing
• Business Intelligence
• Databases
• Business Analytics
• Testing
• Informatica
• Data Marts
• Datastage
• Agile Methodologies
• Sql
• Business Process Improvement
• Ibm Industry Model
• Process Management
• Software Project Management
• Microsoft Office
• Enterprise Data Modeling
• Business Analysis
• Bi Reporting
• Ida
• Data Mapping
• Team Leadership
• Data Warehousing
• Performance Tuning
• Etl
• Rdbms