Jun 2021 – Apr 2025 · 3 yrs 10 mos · London, England, United Kingdom · Remote

• As Lead / Cloud Data Architect/TDM, responsible for creation of Cloud platform for Core Engineering and various business unit of ASDA (leading retailer in UK).
• Key Contributions:
• Created Agile framework for teams and set up scrum teams.
• Capturing requirement and creating Epics and user stories
• Managing backlog and prioritising user stories in sprint
• Creating artefacts like Run book, File Specification Issue Log, ETL File Audit, DQ framework, Data Ingestion Defect, Exception & Failure process, and Deployment Plan.
• Designed DFD, HLD and LLD of the system using Visio.
• Created roadmap for move to cloud for Database and applications.
• Designed Data Models and Entity Relationship Models for Data and UI application using Visio and SQL Data Modeler
• Designed solution for ingestion from various sources using metadata driven approach.
• Created framework and solutioning of data quality framework for data governance.
• Building raw data ingestion with data quality type 1 and type 2.
• Testing of cloud platform build for core engineering and various business units.
• Designing data lakes and containers for segregation of data for PII and Non PII data.
• Stakeholder management and interacting with various teams.
• Creation of dashboard for data processed and reports.
• Managing Azure SQL Server database and Synapse.
• Managing Azure server and RDP Machines.
• Managing different repository for various team using GitHub.
• Environment: Agile, GitHub, Visio, Azure Devops, Rest API, Azure Synapse, Json, PowerShell, ARM Template, Terraform, Azure Data Factory, Azure EventHub, Azure Logic Apps, Micro Services, Phyton, PySpark, Azure SQL Server, Databricks, Azure, Power BI, SharePoint, Devops, Azure Data

Aug 2020 – Jun 2021 · 10 mos

• As Analytics Manager and Scrum Master, responsible for creation of IP project for Insurance Claim processing for Guidewire Claim Centre using AI/ML. The Analytics will utilize the knowledge base to quickly identify the risk factors or indicators the claim falls into, calculate the risk score, fraud score etc. and later will do the segmentation and assignment for Fast Track, High, Medium and Low. Also created Customer Segment, CLTV, Risk of Churn and Recommendation model.
• Key Contributions:
• Created Agile framework for teams and set up scrum teams.
• Designed solution for analyzing historical data from guidewire claim center, ISO and third party.
• Created framework for capturing risk parameter, weightage score and business rule to aid unsupervised learning coming to/from AI/ML.
• Creating data for supervised learning for AI/ML team in Hadoop.
• Designed Database and ETL system (using Pentaho PDI and SSIS) for capturing data from guidewire claim centre, ISO, third party and AI/ML score and segmentation.
• Extracting Customer/Contact data from CRM like Salesforce and Ms Dynamics
• Creating Data sources, unify and measures in CI Dynamics 365.
• Creating Customer Lifetime Value and Risk of Lapsation model.
• Sentimental Analysis using social media and chat data of Contacts.
• Stakeholder management and interacting with various teams.
• Extracting Json files in DB and sending data as Json from DB.
• Creation of dashboard for claim processed and reports.
• Managing Azure SQL Server database and SharePoint.
• Managing AWS server and RDP Machines.
• Managing Azure server and RDP Machines.
• Extracting Telematics data for accident evaluation.
• Creating dashboard using CI Dynamics 365 data and Guidewire data.
• Created Agile framework for teams and setting up scrum teams.
• Managing different repository for various team using GitHub.

Apr 2017 – Aug 2020 · 3 yrs 4 mos

• Responsible for meeting the GDH (Global Datahub) requirements of Prudential UK using Black Rock System for Asset/Risk management.
• Key Contributions:
• Creating Agile framework for team and setting up scrum teams.
• Creation of Project and Operation Schedule and Project status to client and PMO group
• Conducting daily stand-up, RCA, Steering committee and touch point meetings for team.
• Provide production support for the deployed project till it is stabilized
• Received client appreciations for the projects I worked on.

Nov 2015 – Apr 2017 · 1 yr 5 mos

• Project Manager
• Responsible for meeting the BI/DWH requirements of Logitech client of Zensar.
• Key Contributions:
• Data profiling of extract tables for better performance using Denodo and Tableau
• Creation of Project and Operation Schedule and Project status to client and PMO group
• Conducting daily stand-up, RCA, Steering committee and touch point meetings for team.
• Provide production support for the deployed project till it is stabilized
• Received client appreciations for the projects I worked on

May 2014 – Nov 2015 · 1 yr 6 mos · Hyderabad Area, India

• Responsible for meeting the BI/DWH requirements of Novartis client of LiquidHub India Pvt. Ltd.
• Key Contributions:
• Creation of Project and Operation Schedule and Project status to PMO group
• Creation and Maintenance of Knowledge Base, Development and QA Team task activities.
• Conducting daily stand-up, RCA, Steering committee and touch point meetings for team.
• Managing Support and Operations of production team and QA team.
• Manager for Liquid Analytics Development team.
• Presales and Solution Architect for Data Practice, MDM & De-Identification.
• Management of Learning and Development of DWH Practice and Project Management

Nov 2010 – May 2014 · 3 yrs 6 mos

• Scrum Master
• Responsible for meeting the BI/DWH requirements of various internal clients of Nokia Location and Commerce Pvt Ltd, Part of Architecture Council for ETL and BI for Global operation.
• Key Contributions:
• Production support for any production issue.
• Building Testing Framework and System test integration using Robot and QTP.
• Building Regression Testing Framework and Regression testing.
• Development and Maintenance of RDF (ELT) tool.
• Creation and Maintenance of WIKI and JIRA for Knowledge Base, Team and Project status.
• Conducting RCA, Steering Meetings, Scrum, Sprint Review and Sprint Retrospection for team.
• Client interaction for system study and design of system.
• Creation of innovation and ideas for product enhancement and development.

Sep 2008 – Nov 2010 · 2 yrs 2 mos · Mumbai

• Team Leader for POC project for Datawarehousing, handling team of eight.
• Development and Enhancement of datamart and ETL Frame work using Informatica and automation of product.
• Development and Enhancement of BI Framework for various projects.
• Enhancement of Security and Universe using SAP Business Object for reports creation.
• Building reports for super users and canned reports for end users using Crystal reports
• Provide SAP BO training to Super Users and User.
• Production support for any production issue.
• Building Testing Framework and System test integration using Robot and QTP.
• Building Regression Testing Framework and Regression testing.
• Development and Maintenance of RDF (ELT) tool.
• Creation and Maintenance of WIKI and JIRA for Knowledge Base, Team and Project status.
• Conducting RCA, Steering Meetings, Scrum, Sprint Review and Sprint Retrospection for team.
• Client interaction for system study and design of system.
• Creation of innovation and ideas for product enhancement and development.

Feb 2008 – Apr 2008 · 2 mos · Singapore

• The Information Management group is responsible for meeting the Datawarehousing requirements of various business user groups in 3COM.
• The project is to provide Informatica and Business Objects development and maintenance support to different user groups. The project includes design, development and enhancement of Informatica mapping and sessions, which extract data from multiple sources like SAP, Oracle and MS-SQL Server. The scope of project also include enhancement to the existing Universes, Designing and development of Universe and canned reports as per the business users requirement.
• Key Contributions:
• Part of system study team for migration projects for IM.
• Enhancement of datamart and ETL Frame work using Informatica for IM.
• Enhancement of Security and Universe using Business Object for IM, reports creation, installation of software and training.
• Building Dashboard reports for super users.
• On-Call support for any production issue and MS-SQL Server DBA for IM team.
• Migration from BO5 & 6 to SAP BO XI 3.0 and Informatica 6 to informatica 8.

Jul 2007 – Feb 2008 · 7 mos · Singapore

• Working on client side for a DBS Bank in Singapore. Involved in all development process for GCS (Global Credit Solution).
• Key Contributions:
• Part of system study team for GCS.
• Development of datamart and ETL Frame work using Informatica 8 and UNIX scripts.
• Development of Security and Universe using Business Object XI R2 for GCS, reports creation, installation of software and training.
• Building reports for super users and canned reports for end users using Crystal reports
• Provide SAP BO training to Super Users and User.

Dec 2004 – Jun 2007 · 2 yrs 6 mos

• Working on client side, NETS (Payment Gateway Industry), via HP (C&I) Pte Ltd., Singapore. Involved in all development process for NETS-DW.
• Key Contributions:
• Part of system study team for NETS-DW.
• Development of datamart and ETL Frame work using Informatica 8 and Unix scripts for NETS-DW.
• Development of Security and Universe using Business Object XI R2 for NETS-DW, reports creation, installation of software and training.
• Building Dashboard reports for super users.
• Migration from MS-SQL Server to Oracle 10 g.
• Building reports for super users and canned reports for end users using Crystal reports
• Provide BO training to Super Users and User.

Oct 2003 – Dec 2004 · 1 yr 2 mos

• Managed account of BNP, Mumbai and development of Treasury Management System (OMR).
• Key Contributions:
• Part of system study team for OMR
• Development of datamart and ETL Frame work for OMR.
• Development of Universe for OMR, reports creation, installation of software and training.
• Handling client account and developed it by bagging another BI project for financial control worth USD$ 100,000 and handling development team.
• Instrumental in making Mumbai office as the choice centre for other regional offices for all BI related work.

Sep 2001 – Oct 2003 · 2 yrs 1 mo · Mumbai Area, India

• Managed database design work and information architecture for its client applications and all marketing collateral for the region. Assisted marketing managers and clients in understanding and assessing technical aspects of campaigns and poll capture.
• Key Contributions:
• Generated approximately USD$ 50,000 revenue through project acquisition and cost reduction by utilizing in-house talent and employing minimalist resources.
• Steered information architecture, pre-sales, development and management of various campaigns and poll based application development projects for Asia-Pacific region and US.
• Managed vendors and teams to meet requirements of regional and country managers, for various online projects for Dating website, pharmaceuticals websites and E-cards for spirituality websites for Europe region
• Designed and developed software for CRISIL, leading credit rating organisation. Objective of the software was to do credit rating and project rating.
• Designed and developed software for Ginza Industries Ltd, India. Designing and developed production module with MIS reports using Excel pivots. Integration of production system with Tally ERP.

Jan 2000 – Jan 2001 · 1 yr

• Conceived a new product suite, evaluated its feasibility and part of the entire design, development and integration of the product suite (Bicycle and DataLogistiX).
• Key Contributions:
• Impressed the higher management with re-design of the COM DLL and ActiveX.
• Pioneered the design and development of one of the earliest OLAP activities, when the product was still at its initial stages.
• MS-SQL Server backup DBA

Dec 1998 – Jan 2000 · 1 yr 1 mo · Mumbai Area, India

• Part development team for customized application for Cebon Apparels Ltd.
• Key Contributions:
• Independently lead production management module
• Part of system study team.
• Impressed the higher management with re-design of the COM DLL and ActiveX.

May 1997 – Nov 1998 · 1 yr 6 mos · Mumbai Area, India

• Part development team for customized ERP package for Polycab wires & cable Ltd.
• Key Contributions:
• Independently lead inventory management module
• Part of system study team.

Jun 1995 – Mar 1997 · 1 yr 9 mos · Mumbai Area, India

• Part product development team (Export documentation) and application development.
• Key Contributions:
• Handling Data entry jobs for Excise Control for large Organisations and reports for reconciliation.
• Forged long term relationships with leading clients in the local IT industry, as well as a major MNC conglomerate