Ishan Mukherjee

About Ishan Mukherjee

Experienced Data Architect with 13+ years of expertise in designing and implementing scalable data solutions. Specialized in data modeling for large-scale data warehouses and web-based applications, with a strong focus on performance, reliability, and business impact. Passionate about transforming complex data into actionable insights and driving innovation through robust architecture.Previously my role has been that of an E2E Data Architect for Designing BT Google Cloud Projects.My Project requirements required me to understand E2E Impact of the Requirement and discuss with all the Components involved to agree on a E2E solution approach and provide a End to End (E2E) Design of migration of existing On-Premise systems to BT Google Cloud Platform, provide high level and low level costs break ups for the requirements, design data transfer processes. I have exposure to Google Cloud Platform tools like Storage Transfer, Cloud Scheduler, Cloud Composer, Data Flow, Cloud Functions, Pub/Sub, Google Cloud Data Catalogue, Google Cloud Operations Suite, Cloud Big Query,Cloud SQL.Previously, my role has been that of a DSS Solution Designer / Component Designer/Developer/Marketing Data Analyst working in data warehousing. My project engagements required me to have exposure to Oracle Database 12c, Oracle PL/SQL, Orange Business Intelligence 12c, UNIX, Shell Scripting, Python,Data Warehousing Tool (Oracle Data Integrator 12 c and Oracle Warehouse Builder: OWB),OBIEE 11g, Seibel Marketing and UNICA.Having strong knowledge in Developing DW projects for creating Software Applications and Front End Dashboards to support the huge Decision Support System (DSS) of BT, which is considered to be the 2nd Largest Data Warehousing System in the World. Advanced knowledge on complex ETL Implementation & Data Modelling which includes Near Real Time and Low Latency Systems and Integration/Dimensional Layer of Data Warehouse Have also worked in Campaign Management Projects with knowledge in tools like Seibel CRM, OBIEE Marketing and IBM UNICA EMM and ability to gather and understand requirement from customer for Campaign Management.Have a positive attitude towards work, Independently managing work assignments, with the goal of successfully completing the assignment on time with having enthusiasm and creativity along the way.

Experience

1. Data Architect

   HSBC

   Jun 2024 — Present · Kolkata, IN

Education

• University of Calcutta

  MS, Computer Science

  2009 — 2011

• University of Calcutta

  Bsc, Computer Science

  2007 — 2009

Skills

• Microsoft Sql Server
• Etl
• Unix Shell Scripting
• Pl/Sql
• Obiee
• Seibel
• Sql
• Oracle
• Requirements Analysis
• Shell Scripting
• Oracle Certified Associate
• Data Warehousing
• Oracle Warehouse Builder
• Sql Pl