Azure Data Solutions Architect

• Apr 2022 - Present

JustGiving is a global online social platform for giving. Playing a hands on Data Solutions Architect role to migrate JG's on-prem (& AWS Ec2 based) Analytics & BI platform to Azure . Providing end to end solutions architecture, migration options, process & steps along with migrating ODS & DWH to to Delta Lake & Synapse JustGiving is a global online social platform for giving. Playing a hands on Data Solutions Architect role to migrate JG's on-prem (& AWS Ec2 based) Analytics & BI platform to Azure . Providing end to end solutions architecture, migration options, process & steps along with migrating ODS & DWH to to Delta Lake & Synapse

Cloud Solutions Architect

• Jun 2020 - Mar 2022

Played role of hands on Azure Solutions Architect for various large clients of HCL Technologies, like ASDA, Nestle, DHL and leading pharma clients. Played role of hands on Azure Solutions Architect for various large clients of HCL Technologies, like ASDA, Nestle, DHL and leading pharma clients.

Azure Architect (Delta Lake and ML solutions)

• Dec 2019 - May 2020

Worked as Azure Architect at National Air Traffic Services (NATS) UK, to build end to end Data Lake solution using Azure Data Lake, Delta Lake, Azure Data Bricks , PySpark, Azure Data Factory and Azure DevOps. Worked as Azure Architect at National Air Traffic Services (NATS) UK, to build end to end Data Lake solution using Azure Data Lake, Delta Lake, Azure Data Bricks , PySpark, Azure Data Factory and Azure DevOps.

Solutions Architect - Cloud, Analytics & Bigdata

• Sep 2014 - Nov 2019

Worked as Solution /Data Architect for NHS UK, Leading Healthcare provider in UK ) in the area of Azure based end to end solution . This involves providing end to end cloud native architecture, building real time streaming solution using Event Hub, Cosmos DB, Azure Data Factory, Azure Logic Apps and Azure SQL. Also built end to end metadata management solution using on-prem Metadata management tool and Azure based app solution for data capture and storage Played a Big Data Solution Architect role for a top Retail Customer in UK. Responsibilities include, preparing Data Lake Architecture , Data Lake design using Azure Data Lake and also evaluate Map-R Hadoop Distribution Suite in the Cloud Played a role of Architect for a discovery phase in UK Govt project, to ingest non survey data collection to Cloudera Hadoop cluster to be consumed for predictive analysis by downstream systems Played Solutions Architect role for a leading High street retailer (WHSmith) in UK to implement a end to end Analytics solution: Provided end to end Architecture and solution for “WHSmith Future Store Analytics and RBM Dashboard. Designed Opportunity dashboard to empower Store Managers with potential sales opportunities and Store & performance KPIs. Co-ordinated go-live for all 600 WHSmith Stores across UK. This also involved designing custom integration solutions and components to integrate with the clients’ systems and workflows and also optimizing Analytics for required performance target (5-8 sec). Worked as Technical Architect for a UK Border Security (UK Govt ) Account: Played Integration consultant role in BRP (Biometric Residency Permit) Integration project. Provided ETL Design and implemented solution using Talend ETL 5.5. In addition, Prepared HA & DR Architecture and Scheduling design using ActiveEon. Show less

Solutions Architect & Delivery Manager

• Feb 2014 - Aug 2014

Worked as Solutions Architect and Delivery Lead for a UK based large Print/Media client in their MDM & DataMart project: Design ETL solution using Informatica Suite to extract data from Teradata, Marketo, and thirdparty data Dedup and enrich data Data Mart design and loading strategies MDM POC to build single customer view using Informatica MDM suite Worked as Solutions Architect and Delivery Lead for a UK based large Print/Media client in their MDM & DataMart project: Design ETL solution using Informatica Suite to extract data from Teradata, Marketo, and thirdparty data Dedup and enrich data Data Mart design and loading strategies MDM POC to build single customer view using Informatica MDM suite

Solutions Architect & Senior Manager -MDM

• Apr 2012 - Jan 2014

Solutions Architect & Agile Project Manager for end to end design and implementation of MDM solution using Informatica MDM 9.1 suite. Prepared a MDM architecture , and design for critical enterprise entities like Protocol, StudySite, Customer, Sponsor, Subject to name a few. Implemented several reference data entities using Informatica MDM Publish the data and harmonize with new source /applications Part of Data Governance team to define decision rights and accountability framework for critical data Show less

Technical Architect & Manager , MDM, Data Warehousing

• Jan 2008 - Apr 2012

Played various Project Manager, Architect roles to implement MDM, Data Quality & Data Mart projects using SAS , Informatica & oracle products Suite. Managed ETL & MDM projects. teams . Worked as Senior Architect and Manager for Data Mart, MDM & ETL Projects. Introduced agile process for MDM project streams. Created Architecture and design for Operational Data Store & Data Mart to publish metrics and milestones at Clinical Study, Site and Country level. Started MDM initiative at NESS Technologies, for Quintiles IMS, with designing and building Protocol entity and project entity. The solution was provided using SAS DataFlux and SAS qMDM tools and extended this solution to build Site, Customer, Sponsor, Subject and Investigator entities. Show less

Consultant, Architect

• Jun 2003 - Jan 2008

Played Role of Consultant, Architect, Lead for various Data warehousing projects of UBS IB (Zurich), UBS -London, Belgacom etc. Worked extensively in ETL, Database & report development Played Associate Consultant role in UBS for Compliance Data mart project at their Zurich & London offices Designed Data Model, Data Mart and developed regulatory reporting solution using Informatica & Business Objects. Worked for Database Solutions Practice, to provide Database design, tuning and modeling related consulting to various clients of Wipro Technologies like Intel, Transco. Show less

Faculty (Information Technology)

• Oct 1994 - May 2003